Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Buy Cash Flow

VIEWS: 34 PAGES: 8

Buy Cash Flow document sample

More Info
									Cash Flow Budget Instructions (long form)
Ag Decision Maker -- Iowa State University Extension
See File C3-15, Twelve Steps to Cash Flow Budgeting, for more information.

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.

1. Getting Started
         a. Enter your name or the name of your farming operation and the year(s) that your cash flow budget will cover.
            Name:
            Year(s):

           b. Enter the column headings that you want to use for budget periods, such as Jan-Feb, March-April, 1st
              Quarter, etc. You can begin and end in any month. You can use from one to six periods.

              1st period     2nd period     3rd period     4th period   5th period 6th period
              January        March          May            July         September November
              February       April          June           August       October    December

2. Livestock
         a. Columns for up to 7 livestock enterprises are provided. Names are up to you. Budgeting units are usually
             per head, per litter, or per sow or cow unit. The best source of budget information is your own records.
             However, livestock budget information is available in AgDM Information Files:
             Livestock Enterprise Budgets
             Livestock Planning Prices
         b. Enter the expected number of head, weight, and selling price for market livestock, and for cull breeding stock
             and animal products where applicable, per unit of the enterprise (such as per head or per litter).
          c. Enter the expected costs per unit for purchased livestock, purchased feed, and other operating costs, for each
             enterprise.
         d. Enter the quantities of corn, hay and silage to be used per unit, for each enterprise. This is carried to the crop
             summary sheet.
         e. Total revenue, operating costs, and feed use are calculated. Indicate how each of these will be distributed
             throughout and year by entering the dollar value or percent in each period in which they are expected to occur.
3. Crops
         a. Columns for up to 10 crop enterprises are provided. Use a different column for the same crop if yields or costs
             are significantly different due to tillage system, land quality, rotation, or technology used. Use a separate
             column for crops on crop-share rented land, and enter the operator's share of yield and costs, only.
             The best source of budget information is your own records. However, crop budget information is available in AgDM
             Information Files:
             Crop Production Cost Budgets                             Organic Crop Production Budgets
             Iowa Pasture Cost Improvement Budgets                    Vegetable Crop Production Budgets
         b. Enter the expected yields. Use the designated rows for corn, soybeans, silage and hay. These are used to
             calculate total feed supplies.
          c. Enter the expected costs per acre for seed, fertilizer and other operating costs. Do not include cash rent here.
             Enter percentages to allocate operating costs by period.
         d. In the Crop Summary, enter the quantity of crops carried over from last year,
         e. Enter the bushels of purchases and/or sales among the periods. You cannot sell more bushels or tons than are available.
          f. Enter an expected selling or purchase price in each period to plan to sell or buy crops.
4. Overhead
         a. Enter the expected amount of other farm income to be received for the year, and enter values to allocate it
             among the periods.
         b. Enter the expected amount of other farm expenses to be paid for the year, and enter values to allocate it
             among the periods.
          c. Enter the expected amount of nonfarm income to be received for the year, and enter values to allocate it
             among the periods.
         d. Enter the expected amount of nonfarm expenses to be paid for the year, and enter values to allocate it among
             the periods.

5. Capital Assets Sales and Purchases
         a. Enter the expected amounts to be received from sales of machinery, equipment, buildings and/or land, and
            allocate it among the periods.
         b. Enter the expected amounts to be spent on purchases of machinery, equipment, buildings and/or land, and
            allocate it among the periods. If an item is to be purchased on an installment contract, enter the down payment
            amount only. For trades enter the cash differences to pay, only.

6. Financing
         a. Enter the amount of new short-term borrowing expected as single notes, such as for purchasing feeder
            livestock, and allocate it by the month received.
                     b. Enter the amount of new borrowing expected as term notes, such as for purchasing equipment, and
                        allocate it by the month to be received.
                     c. Enter existing accounts payable, short-term notes due, payments due on term loans, and equipment lease payments.
                        Include both principal and interest. Enter values to indicate in which periods they will be paid.
                     d. Enter the cash balance on hand to start the year, and the interest rate received on it, if any.
                     e. Enter the outstanding balance owed on the operating credit line to start the year, and the interest rate to be paid on it.

 7. Whole Farm Budget
         a. Enter the farm or family name and the year of the budget.
         b. All other values are carried forward from the other worksheets.
          c. Under the Summary section, check the Ending cash balance. For the budget to be feasible, the ending
             cash balances should be positive for the whole year and for each period. If they are not, adjustments can be
             made to the amount and timing of cash inflows and outflows on the other worksheets, or the operating loan
             line can be used to achieve a positive cash balance.
         d. For periods in which the projected ending cash balance is negative, values can be entered for New operating
             loans received.
         e. For periods in which the projected ending cash balance is positive, values can be entered for Repay
             operating loan. Interest to pay is calculated.
          f. The operating loan balance at the end of each period can be used to compare to limits on the line of credit.

 Printing
                            Each worksheet can be printed simply by clicking on the printer icon.


Version 1.2
Author: William Edwards
Date Printed:
7/7/2010



. . . and justice for all
The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual orientation, and marital
or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of discrimination, write USDA, Office of Civil Rights, Room
326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964.
Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Gerald A. Miller, interim director, Cooperative Extension Service, Iowa State
University of Science and Technology, Ames, Iowa.
Livestock Budgets
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.


                                    0                                                                     0

Livestock Enterprise Data                  1             2             3               4          5            6             7           Resource information
Name of Enterprise                                                                                                                       Livestock Enterprise Budgets
Budget unit (head, litter,etc.)                                                                                                          Livestock Planning Prices
Number of units planned

Revenue per unit
No. head sold per budget unit
Sale weight--lbs.
Expected sale price per lb.
No. cull females sold / unit
Sale weight--lbs.
Expected sale price per lb.
Lb. of product (milk,wool,etc.)
Exp. sale price of product/lb.
Total revenue per budget unit                  $0            -             -               -          -            -             -

Cash production costs per unit
Name of Enterprise                              0                0             0            0             0            0             0
                                                                                   Purchases
 Purchases of livestock /unit
 Purchased feed /unit
 Health and veterinary /unit
 Marketing costs /unit
 Other cash costs /unit
                                                                                   Feed use
 Corn use per unit, bu.
 Silage use per unit, tons
 Hay use per unit, tons
 Small grain use per unit, bu.

                                                     Allocation by period (enter $ for each period or % to allocate to each period)
                                        Total for     January       March           May          July      September November               Total
Allocation by period                     Year        February        April         June         August       October     December         Allocated
Revenue                                         $0                                                                                                    0

 Purchases of livestock                        $0                                                                                                0
 Purchased feed                                $0                                                                                                0
 Health and veterinary                         $0                                                                                                0
 Marketing                                     $0                                                                                                0
 Other cash costs per head                     $0                                                                                                0
                                                     Allocation by period (enter bu. or tons used in each period, or % to allocate to each period)
 Corn use, bu.                                  0                                                                                                0
 Silage use, tons                               0                                                                                                0
 Hay use, tons                                  0                                                                                                0
 Small grain use, bushels                       0                                                                                                0
Crop Budgets
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.


                                                                       0                                                           0

Crop Enterprise Information
 Name of crop                             All Acres        Cont. corn Rotated Corn Soybeans
 Number of acres in each crop                   -
Expected yields
 Corn (bushels per acre)                         -
 Soybeans (bushels per acre)                     -
 Silage (bushels per acre)                       -
 Hay (tons per acre)                             -
 Small grains (bushels per acre)                 -

 Other income per acre, $/acre                       $0

Cash production costs per acre
 (operator's share)                        Total $  Cont. corn             Rotated Corn   Soybeans              -            -               -         -   -   -   -
Seed                                             $0
Fertilizer and lime                              $0
Pesticides                                       $0
Crop insurance                                   $0
Drying fuel                                      $0
Custom hire/machine rental                       $0
Other cash costs per acre                        $0

                                               Allocation by period: enter % or $ of the total cost that will be paid in each period
                                                        January       March           May            July       September November
Allocation by period                        Total      February        April          June         August         October     December
Seed                                            0%
Fertilizer and lime                             0%
Pesticides                                      0%
Crop insurance                                  0%
Drying fuel                                     0%
Custom hire or machine rental                   0%
Other cash crop costs                           0%

 Other crop income                                0%

                                         Beginning         Expected   Expected            Quantity        Expected      Expected        Ending
Crop summary                             Inventory         Purchases Production           Available       Feed Use        Sales        Inventory
Corn--bushels                                                       0          0                      0            0               0               0
Soybeans--bushels                                                   0          0                      0                            0               0
Silage--tons                                                        0          0                      0                            0               0
Hay--tons                                                           0          0                      0             0              0               0
Small grain--bushels                                                0          0                      0             0              0               0

                                                            Allocation by period: enter bushels or tons to sell in each period
                                         Total bu.or        January        March          May          July        September November
Allocation of crop sales                    tons            February       April         June         August        October    December
Corn--bushels                                   -
Soybeans--bushels                               -
Silage--tons                                    -
Hay--tons                                       -
Small grain--bushels                            -

                                                          Allocation by period: enter bushels or tons to purchase in each period
                                         Total bu.or         January        March         May            July     September November
Allocation of crop purchases                tons             February        April        June         August       October    December
Corn--bushels                                   -
Soybeans--bushels                               -
Silage--tons                                    -
Hay--tons                                       -
Small grain--bushels                            -

                                         Weighted                          Expected selling price or purchase price in each period
                                         average            January           March          May           July      September November
Expected price                             price            February          April         June         August        October     December
Corn, $/bushel
Soybeans, $/bushel
Silage--tons
Hay, $/ton
Small grain, $/bushel
Overhead
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.


                                                          0                                                       0

                                                              Allocation by period (enter $ or % to allocate to each period)
                                              Total for        January        March           May           July      September     November     Total
                                                Year           February        April         June          August       October     December   Allocated
Other farm income
USDA payments                                                                                                                                        -
Custom hire income                                                                                                                                   -
Rents, interest                                                                                                                                      -
Other farm income                                                                                                                                    -

Other farm expenses                                           Allocation by period (enter $ or % to allocate to each period)
Real estate taxes                                                                                                                                    -
Cash rent                                                                                                                                            -
Hired labor                                                                                                                                          -
Repairs and upkeep                                                                                                                                   -
Fuel and lubrication                                                                                                                                 -
Other fixed expenses                                                                                                                                 -

                                                              Allocation by period (enter $ or % to allocate to each period)
                                              Total for       January        March           May            July      September     November     Total
Non-farm income                                 Year          February        April          June         August       October      December   Allocated
Wages and salaries                                                                                                                                    -
Rents and interests                                                                                                                                   -
Other nonfarm income                                                                                                                                  -
                                                       $0              $0            $0            $0             $0           $0         $0            $0
Non-farm expenditures                                         Allocation by period (enter $ or % to allocate to each period)
Family living expenses                                                                                                                               -
Income and other personal taxes                                                                                                                      -
Purchase of vehicles, furniture, etc.                                                                                                                -
Contributions to savings, retirement                                                                                                                 -
Real estate, remodeling, etc.                                                                                                                        -
Other non-farm investments                                                                                                                                0
Total non-farm expenses                               $0              $0           $0             $0            $0             $0         $0             $0
Capital Assets Sales and Purchases (machinery, equipment, buildings, land, breeding livestock expansion)
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.


                                                          0                                                    0

                                                              Allocation by period (enter $ or % to allocate to each period)
                                                               January        March          May           July      September   November     Total
Sales planned (list)                           Total $        February        April          June         August      October    December   Allocated
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
Total                                                    $0           $0           $0            $0           $0            $0         $0

                                                              Allocation by period (enter $ or % to allocate to each period)
                                                               January        March          May           July      September   November     Total
Purchases planned (list)                       Total $        February        April          June         August      October    December   Allocated
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
                                                                                                                                                        0
Total                                                    $0           $0           $0            $0           $0            $0         $0
Financing
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.

                                                             0                                                        0

New Borrowing Expected                                             Allocation by period (enter $ to borrow in each period)
                                                     Total          January       March           May          July      September   November
New short-term notes (list)                         Amount         February        April         June         August       October   December
                                                           $0
                                                           $0
                                                           $0
                                                           $0
Total new short-term notes to receive                      $0              $0             $0           $0            $0         $0         $0

New long-term loans (list)                                         Allocation by period (enter $ to borrow in each period)
                                                            $0
                                                            $0
                                                            $0
                                                            $0
Total new long-term loans to receive                        $0             $0             $0           $0            $0         $0         $0

Payments due on existing liabilities                               Allocation by period (enter $ to pay in each period)
                                                     Total         January        March          May          July      September    November
                                                    Amount         February       April         June         August      October     December
Accounts Payable                                           $0

Short-term notes (list) (excluding operating line)                 Allocation by period (enter $ to pay in each period)
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
Total short-term notes                                      $0             $0             $0           $0            $0         $0         $0

Payments due on long-term loans (list)                             Allocation by period (enter $ to pay in each period)
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
                                                            $0
Total term loan payments                                    $0             $0             $0           $0            $0         $0         $0

Equipment lease payments (list)                                    Allocation by period (enter $ to pay in each period)
                                                            $0
                                                            $0
                                                            $0
                                                            $0             $0             $0           $0            $0         $0         $0

Cash balance                                                                    Short-term operating line balance
Cash on hand, beginning balance                                                  Operating line, beginning balance
Interest rate earned on cash balance (%)                                         Interest rate paid on operating line (%)
Cash Flow Budget
Ag Decision Maker -- Iowa State University Extension

Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.


 Name:                                                                                              Year:
                                                                    0                                           0

CASH INFLOWS                                                                  Total for                   January                       March                         May                        July                    September                 November
Operating                                                                      Year                       February                      April                         June                      August                    October                  December
 Livestock income                                                                             $0                           0                           0                           0                            0                 0                           0
 Sales of crops                                                                               $0                           0                           0                           0                            0                 0                           0
 Other crop income                                                                            $0                           0                           0                           0                            0                 0                           0
 USDA payments                                                                                $0                           0                           0                           0                            0                 0                           0
 Custom hire income                                                                           $0                           0                           0                           0                            0                 0                           0
 Farm rents, interest                                                                         $0                           0                           0                           0                            0                 0                           0
 Other                                                                                        $0                           0                           0                           0                            0                 0                           0

 Sales of Capital Assets                                                                      $0                           0                           0                           0                            0                              0              0

 Financing
 Total new short-term loans to receive                                                        $0                           0                           0                           0                            0                              0              0
 New term loans to receive                                                                    $0                           0                           0                           0                            0                              0              0

 Non-farm Income                                                                              $0                           0                           0                           0                            0                              0              0

 Total Cash Inflows                                                                           $0                           0                           0                           0                            0                              0              0

CASH OUTFLOWS                                                                 Total for                   January                       March                         May                        July                    September                 November
Operating                                                                      Year                       February                      April                         June                      August                    October                  December
 Seed                                                                                         $0                           0                           0                           0                            0                 0                           0
 Fertilizer and lime                                                                          $0                           0                           0                           0                            0                 0                           0
 Pesticides                                                                                   $0                           0                           0                           0                            0                 0                           0
 Crop insurance                                                                               $0                           0                           0                           0                            0                 0                           0
 Drying fuel                                                                                  $0                           0                           0                           0                            0                 0                           0
 Custom hire or machine rental                                                                $0                           0                           0                           0                            0                 0                           0
 Other cash costs per acre                                                                    $0                           0                           0                           0                            0                 0                           0

  Purchased crops                                                                             $0                           0                           0                           0                            0                              0              0
  Purchased livestock                                                                         $0                           0                           0                           0                            0                              0              0
  Purchased feed                                                                              $0                           0                           0                           0                            0                              0              0
  Health and veterinary                                                                       $0                           0                           0                           0                            0                              0              0
  Marketing                                                                                   $0                           0                           0                           0                            0                              0              0
  Other cash costs per head                                                                   $0                           0                           0                           0                            0                              0              0

  Real estate taxes                                                                           $0                           0                           0                           0                            0                              0              0
  Cash rent                                                                                   $0                           0                           0                           0                            0                              0              0
  Hired labor                                                                                 $0                           0                           0                           0                            0                              0              0
  Repairs and upkeep                                                                          $0                           0                           0                           0                            0                              0              0
  Fuel and lubrication                                                                        $0                           0                           0                           0                            0                              0              0
  Other fixed expenses                                                                        $0                           0                           0                           0                            0                              0              0

 Purchases of Capital Assets                                                                  $0                           0                           0                           0                            0                              0              0

 Financing
 Accounts payable                                                                             $0                           0                           0                           0                            0                              0              0
 Short term notes due                                                                         $0                           0                           0                           0                            0                              0              0
 Term loan payments                                                                           $0                           0                           0                           0                            0                              0              0
 Equipment lease payments                                                                                                  0

 Non-farm Expenditures                                                                        $0                           0                           0                           0                            0                              0              0

 Total Cash Outflows                                                                          $0                           0                           0                           0                            0                              0              0

 Net Cash Flow                                                                                $0                           0                           0                           0                            0                              0              0

 SUMMARY                                                                     Total for     January            March           May            July         September                                                                                November
                                                                               Year        February            April          June          August         October                                                                                 December
    Net cash flow                                                                    $0              0                0              0              0              0                                                                                          0
     Beginning cash balance                                                          $0              0                0              0              0              0                                                                                          0
     Interest earned on cash balance                                                 $0              0                0              0              0              0                                                                                          0
     New operating loan needed                                                       $0
     Operating loan repayments                                                       $0
     Interest paid on oper. loan balance                                             $0              0                0              0              0              0                                                                                          0
     Ending cash balance                                                             $0              0                0              0              0              0                                                                                          0
                                                                        For a feasible cash flow plan, all projected ending cash balances should be positive.

Operating Loan Balance
 Balance at start of year or period                                                           $0                           0                           0                           0                            0                              0              0
 Balance at end of year or period                                                             $0                           0                           0                           0                            0                              0              0


Version 1.2
Author: William Edwards
Date Printed:
7/7/2010



. . . and justice for all
The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual orientation, and marital or
family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of discrimination, write USDA, Office of Civil Rights, Room 326-W,
Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964.
Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Gerald A. Miller, interim director, Cooperative Extension Service, Iowa State
University of Science and Technology, Ames, Iowa.

								
To top