Cash Flow Analysis - Excel

Document Sample
Cash Flow Analysis - Excel Powered By Docstoc
					                  NAME:
                                                                                             Cash Flow Analysis

                                                  Production Year    2011   Crops, livestock, & other products produced this year
                                                                                                                      # of Acres or
       Farm Cash Inflow                                                          Commodity         Production Unit    # of Animals       Yield or Lbs    Price per Unit Total Income
       Livestock Purchased for Resale (Sale Price less Cost)                Corn                          Bu
       Sales of crops, livestock & other products you raised                Soybeans                      Bu
       Cooperative distribution payments                                    Wheat                         Bu
       CCC loan taxable income                                              Hay                          Ton
       Agricultural program payments                                        Milk                        Cwt.
       Crop insurance proceeds                                              Steers                       Lbs.
       Custom hire income
       Federal and state gasoline refunds
       Recurring Capital gain (loss)
       Other
       Other
       TOTAL FARM CASH IN
                                                                                                                                                                    Total
       Farm Cash Outflow
       Car and truck expense
       Chemicals
       Conservation expense                                                                      Amount prepaid        To be paid
       Custom hire                                                              Expenses          for this year       for this year         Total
       Employee benefit programs                                            Chemicals
       Feed                                                                 Feed
       Fertilizer and lime                                                  Fertilizer
       Freight and trucking                                                 Gas/diesel/oil/etc
       Gasoline, diesel, oil                                                Seed
       Insurance                                                            Supplies
       Interest: Operating Loans
       Labor hired
       Rent: vehicles, machinery,equipment
       Rent: land, animals, etc
       Repairs and maintenance
       Seed, plants
       Storage                                                              Loan / Lease Payments (Farm) - except operating                Annual
       Supplies                                                                 Owed To            Security       Loan Balance          Pymt Amt (P&I)
       Taxes
       Utilities
       Veterinary, breeding, medicine, etc
       Other
       Other
       Farm Loan / Lease Payments
       TOTAL FARM CASH OUT

       FARM NET CASH

       NON-FARM CASH                                                                                                                                     Subtotal
       Wages, salaries, tips
       Interest income                                                      Loan / Lease Payments (Non-farm, Personal)
       Dividend income
       Taxable refunds of state and local taxes
       Business income/(loss) (before interest and depreciation)
       Non-farm capital gain (loss)
       Pensions and annuities                                                                                                                            Subtotal
       Rents, partnerships, etc (before interest and depreciation)
       Other                                                                                                                    Total
Less   Non-farm, Personal Loan / Lease Payments
       NON-FARM NET CASH
       FARM AND NON-FARM NET CASH
Less   Family Living
Less   State Income Taxes Paid
Less   Federal Income & Self-employment Taxes Paid
       NET CASH FLOW

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:82
posted:10/3/2012
language:Unknown
pages:1