Docstoc

cashflow

Document Sample
cashflow Powered By Docstoc
					                                                                Guaranteed Farm Loan Programs

MO 2-FLP Guide 19                         USDA-Farm Service Agency                 NAME                                                   Tel #-
(Rev. 4/18/2002)                                                                                                                          Soc. Sec.#-
                                                                                   Applicants DOB-                                                  0
                                                                                   Co-App DOB-                         Ages of Children             0

                     BALANCE SHEET                                                                                     Others-                     0
                                                                                   DATE OF BALANCE SHEET                                  ACRES OWNED
PERIOD COVERED                                                                                                                            TOTAL    CROP
BY PLAN:           From                                  Thru                                                                             0        0
A. BALANCE SHEET
CURRENT FARM ASSETS                                                    $VALUE   CURRENT FARM LIABILITIES                                                $AMOUNT
Cash on hand       Checking               $0 Savings          $0             $0 Farm Accounts and Notes Payable {include principal and interest}
Other investments: time cert              $0 other            $0             $0        Creditor         Due Date       Int Rate      Payment
Accounts and Notes to be Received                                             $0 Open Accounts - see debt schedule                            $0             $0
CROPS AND FEED                    Units      Price per unit                                                                                                  $0
                                    0          $0.00                          $0                                                                             $0
                                    0          $0.00                          $0                                                                             $0
                                    0          $0.00                          $0 Annual OL Loan see debt schedule                             $0             $0
                                    0          $0.00                          $0                                                                             $0
                                    0          $0.00                          $0                                                                             $0
                                    0          $0.00                          $0                                                                             $0
LIVESTOCK TO BE SOLD                                                                                                                                         $0
                    No.        Unit Weight Price per unit                                                                                                    $0
                     0              0        $0.00                            $0 CCC Loan                                                                    $0
                     0              0        $0.00                            $0 Current Portion of Principle Due on:
                     0              0        $0.00                            $0   Intermediate Liabilities                                                  $0
                     0              0        $0.00                            $0   Long Term Liabilities                                                     $0
GROWING CROPS                     Acres    Cost/Acre                             Accrued Interest On:
                                    0        $0.00                            $0   Intermediate Liabilities                                                  $0
                                    0        $0.00                            $0   Long Term Liabilities                                                     $0
                                    0        $0.00                            $0 Accrued Taxes on:
                                    0        $0.00                            $0 Real Estate, Personnal Property and Assessments                             $0
SUPPLIES AND PREPAID EXPENSES                                                 $0   Income and Social Security Tax                                            $0
LEASES                                                                        $0 Accrued Rent/Lease Payments                                                 $0
OTHER                                                                         $0 Other Judgements, Liens, etc.                                               $0
                               TOTAL CURRENT FARM ASSETS                      $0                            TOTAL CURRENT FARM LIABILITIES                   $0
INTERMEDIATE FARM ASSETS                                                         INTERMEDIATE FARM LIABILITIES(portion due beyond 12 months)
Accounts and Notes to be Received beyond 12 months                                       Creditor             Due Date  Int Rate  Payment
Breeding Livestock                 No.       Price Per Unit                        IT Debts -see debt schedule                                $0             $0
                                    0            $0                           $0                                                                             $0
                                    0            $0                           $0                                                                             $0
                                    0            $0                           $0                                                                             $0
                                    0            $0                           $0                                                                             $0
                                    0            $0                           $0                                                                             $0
                                    0            $0                           $0                                                                             $0
Machinery, Equipment and vehicles                                             $0 Loans Secured by Life Insurance Policies                                    $0
CO-OP Stock                                                                   $0 Farmer-Owned Reserve                                                        $0
Cash Value Life Insurance         Face Amount  $0                             $0 Other                                                                       $0
Other                                                                         $0
                                  TOTAL INTERMEDIATE ASSETS                   $0                          TOTAL INTERMEDIATE LIABILITIES                     $0
LONG TERM FARM ASSETS                                                            LONG TERM FARM LIABILITIES(portion due beyond twelve months)
Acres                 Date Bought   RE Tax    Cost                                      Creditor           Due Date       Int Rate Payment
                                                                              $0 LT Debts - see debt schedule                     $0                         $0
                                                                              $0                                                                             $0
                                                                              $0                                                                             $0
                                                                              $0                                                                             $0
CO-OP Stock                                                                   $0                                                                             $0
Equity In Partnership/Corp/Joint Operation/COOP                               $0                                                                             $0
                                  TOTAL LONG TERM ASSETS                      $0                         TOTAL LONG TERM LIABILITIES                         $0
                                  TOTAL FARM ASSETS                           $0                         TOTAL FARM LIABILITIES                              $0




          Balance Sheet                                                     Page 1                   afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs




Balance Sheet              Page 1           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs




Balance Sheet              Page 1           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs




Balance Sheet              Page 1           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                               Guaranteed Farm Loan Programs
                                                                  Balance Sheet Continued
                                         NAME

A. BALANCE SHEET (continued)
Non-Farm Assets                                                   $VALUE           NONFARM LIABLITIES                                                          $AMOUNT
Household Goods                                                     $0             Non Farm Accounts and Notes Payable
Car, Truck                                                          $0               Creditor                   due date        interest rate   payment
Recreational Vehicles                                               $0             Non-farm debts - see debt schedule                                     $0      $0
Cash Value Life Insurance                                           $0                                                                                            $0
Stocks, Bonds                                                       $0                                                                                            $0
Non Farm Business                                                   $0                                                                                            $0
Other                                                               $0                                                                                            $0
                                                                    $0                                                                                            $0
Non-Farm RE                                                         $0                                                                                            $0
                                                                                                                TOTAL NON FARM LIABILITIES                        $0
                   TOTAL NONFARM ASSETS                             $0                                          TOTAL FARM LIABILITIES                            $0
                   TOTAL FARM ASSETS                                $0                                          TOTAL LIABILITIES                                 $0
                   TOTAL ASSETS                                     $0                                          NET WORTH                                         $0
                                                                                                                NET WORTH/TOTAL ASSETS
The above information is furnished for the purpose of securing and maintaining credit and is certified to be correct and accurate. The undersigned
authorizes the fsa to make all inquires deemed necessary tnecessary to verify the accuracy of the information contained above to determine my credit-
worthiness and to answer questions about their credit experience with me. I agree to notify FSA promptly to any material changes to the above.
I recognize that making any false statements on this Farm & Home Plan or any other loan document may constitute a violation of criminal law.
Signature of Applicant/Borrower/Entity Member
                                                                                                                                Date
x________________________________________ x__________________________________________                                           ______________________________




B. RENTAL AND LEASE INFORMATION
General Description or                                                    Acres                                                                                Expiration
FSA Farm #                    Landlord                      Total                      Crop     Type of Lease                   Crop Share      Cash Rent        Date
                                                              0                         0


                                                              0                         0
                                                              0                         0


Other items-Descriptions      Owner                     Number of Units                                                                          Payment



                                                                                                                                TOTAL                $0



Total Assets of:                                    $0 Divided by Total Liabilities                                        $0   = Net Capital Ratio            #DIV/0!
Annual Cash Oper. Exp.                              $0 Divided by Gross Farm Income                                        $0   = Operating Ratio              #DIV/0!
Net Farm & Non-farm Income                          $0 Divided by Total Assets                                             $0   = Profit to Assets             #DIV/0!
Debt Repayment                                      $0 Divided by Gross Income                                             $0   = Debt Repayment               #DIV/0!




         Balance Sheet                                                            Page 2               afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs
                   Balance Sheet Continued




Balance Sheet              Page 2          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs
                   Balance Sheet Continued




Balance Sheet              Page 2          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs
                   Balance Sheet Continued




Balance Sheet              Page 2          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs
                   Balance Sheet Continued




Balance Sheet              Page 2          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                Guaranteed Farm Loan Programs
                   Balance Sheet Continued




Balance Sheet              Page 2          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                  Balance Sheet
                                                Supporting Schedule
                            List of Machinery, Equipment and Vehicles
                                                         Model # &                           Condition      Estimated
 #          Item                 Manufacturer            Discription             Serial #    (E,VG,G,P,F)     Value
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
                                                                                             TOTAL                 $0
         Customer's Signature

        Loan Officer Signature




     Balance Sheet                                    Page 3           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                  Balance Sheet
                Supporting Schedule




Balance Sheet         Page 3          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                  Balance Sheet
                Supporting Schedule




Balance Sheet         Page 3          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                  Balance Sheet
                Supporting Schedule




Balance Sheet         Page 3          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                  Balance Sheet
                Supporting Schedule




Balance Sheet         Page 3          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                  Balance Sheet
                Supporting Schedule




Balance Sheet         Page 3          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                                                                                   Balance Sheet
                                                                                                                                 Supporting Schedule




                                                          BALANCE SHEET DEBT SCHEDULE


OPEN ACCTS:            Principal        Accrued       Current Annual    Interest    Principal
Description            Balance          Interest      Rate    Payment   Portion     Portion      Purpose              Security
                                                                     $0          $0           $0
                                                                     $0          $0           $0
                                                                     $0          $0           $0
                                                                     $0          $0           $0
                                                                     $0          $0           $0
                                                                     $0          $0           $0
                                                                     $0          $0           $0
TOTAL                              $0              $0                $0          $0           $0

ANNUAL OL LOAN Principal                Accrued         Current Annual     Interest        Principal
Description    Balance                  Interest        Rate    Payment    Portion         Portion          Purpose   Security
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
TOTAL                              $0              $0                 $0              $0               $0

INTERMEDIATE:          Principal        Accrued         Current Annual     Interest        Principal
Description            Balance          Interest        Rate    Payment    Portion         Portion          Purpose   Security
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
TOTAL                              $0              $0                 $0              $0               $0

LONG TERM:             Principal        Accrued         Current Annual     Interest        Principal
Description            Balance          Interest        Rate    Payment    Portion         Portion          Purpose   Security
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
TOTAL                              $0              $0                 $0              $0               $0

NON-FARM:              Principal        Accrued         Current Annual     Interest        Principal
Description            Balance          Interest        Rate    Payment    Portion         Portion          Purpose   Security
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
                                                                                      $0               $0
TOTAL                              $0              $0                 $0              $0               $0

GRAND TOTALS                       $0              $0                 $0              $0               $0

Customer's Signature

Loan Officer Signature




                  Balance Sheet                                                                                                        Page 4          afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
      MO 2-FLP Guide 19A               Crop and Livestock Income Worksheets
                                                 Guaranteed Cash Flow
      (Rev. 4/18/2002)                                     Supporting Schedule
                                              A. CROPS, PASTURE, ETC.--PRODUCTION, SALES AND USE
                                                                    PLANNED
               Crops, Pasture,                         Yield                                  Operator's    Price

            Subsidy Payment, etc.          Acres        Per                                     Share      per Unit      Dollar

                                                       Acre        Farm Use   Hold for Sale     Sale          $          Sales
1                                                                                                 0                               $0
2                                                                                                 0                               $0
3                                                                                                 0                               $0
4                                                                                                 0                               $0
5                                                                                                 0                               $0
6                                                                                                 0                               $0
7                                                                                                 0                               $0
8                                                                                                 0                               $0
9                                                                                                 0                               $0
10                                                                                                0                               $0
11                                                                                                0                               $0
12                                                                                                0                               $0
13                                                                                                0                               $0
     TOTAL (Entered in
         Table J, Line 1)                                                                                                         $0


     The totals from both of these worksheets are automatically transferred to the "table f-k worksheet".

                                      B. LIVESTOCK/DAIRY/POULTRY AND PRODUCTS--PRODUCTION, SALES AND USE
                                                                    PLANNED
            Livestock/Dairy/Poultry                  Production                               Operator's    Price

                 and Products               No.         Per                      Units For:     Share      per Unit      Dollar

            Subsidy Payments, etc.                    Animal       Farm Use   Hold for Sale     Sale          $          Sales
1                                                                                                 0                               $0
2                                                                                                 0                               $0
3                                                                                                 0                               $0
4                                                                                                 0                               $0
5                                                                                                 0                               $0
6                                                                                                 0                               $0
7                                                                                                 0                               $0
8                                                                                                 0                               $0
9                                                                                                 0                               $0
10                                                                                                0                               $0
11                                                                                                0                               $0
12                                                                                                0                               $0
13                                                                                                0                               $0
     TOTAL (Entered in
         Table J, Line 2)                                                                                                         $0




      Guaranteed Cash Flow                                        Page 2             afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19A     Guaranteed Cash Flow
(Rev. 4/18/2002)        Supporting Schedule




Guaranteed Cash Flow         Page 2           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19A     Guaranteed Cash Flow
(Rev. 4/18/2002)        Supporting Schedule




Guaranteed Cash Flow         Page 2           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19A     Guaranteed Cash Flow
(Rev. 4/18/2002)        Supporting Schedule




Guaranteed Cash Flow         Page 2           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
     MO 2-FLP Guide 19B                                                             Guaranteed Cash Flow
     (Rev. 4/18/2002)                                                                Supporting Schedule

                                                       Debt Repayment & Capital Expenditure Worksheets
                                                                               DEBT REPAYMENT WORKSHEET
                                                                          Bal Sheet
     If completing the Balance Sheet, GO TO the        Debt Sch       since the DEBT REPAYMENT WORKSHEET IS AUTOMATICALLY completed.
     If not completing the Balance Sheet section, you must complete these worksheets to prefill Tables H & K in the table f-k worksheet.
     In the Month Due blocks starting at cell J11, use 1=Jan, 2=Feb, 3=Mar, 10=Oct, 12=Dec, etc. and 13=monthly.
     For IA loans, the Debt Repayment Worksheet must be completed. Starting in cell C11 either the number 1 if the loan is to be considered for IA.
                                                 Interest         Loan                Terms                                                                                       Month
                     Lender                     Assistance       Balance        Years     Int Rate      Principal          Interest     Annual Payment                             Due
                                                            IA 1=Yes


 1                                                                                                                                                                                 12

 2                                                                                                                                                                                 12

 3                                                                                                                                                                                 12

 4                                                                                                                                                                                 12

 5                                                                                                                                                                                 12

 6                                                                                                                                                                                 12

 7                                                                                                                                                                                 12

 8                                                                                                                                                                                 12

 9                                                                                                                                                                                 12

10                                                                                                                                                                                 12

11                                                                                                                                                                                 12

     Totals                                                                            $0                                            $0                $0                   $0
     Transfer totals to:                                                                                                CF Line 50        CF Line 51

                                                            IA 1=Yes

     Annual Operating Loan
                                                PLANNED CAPITAL PURCHASES & EXPENDITURES WORKSHEET
     In the Month Due blocks starting at cell G35, use 1=Jan, 2=Feb, 3=Mar, 10=Oct, 12=Dec, etc. and 13=monthly.
                                                                                                         Month                              Planned Term Financing                 Years
     Descriptions                                                                Cost or Boot           Needed                              Lender          Amount               Financed

 1

 2

 3

 4

 5

 6

 7

     Totals                                                                                                      $0                                                         $0
     Transfer totals to:                                                                        CF line 49                                                     CF line 48
     If new loan is required for the purchase of the capital expenditure, then the loan must be shown in the Debt Repayment Worksheet.
                                                                                                                                                                            Master
                                                        CASH FLOW BEGINNING "CASH ON HAND" WORKSHEET                                                                        Menu

     A1 - Enter cash on hand > $1,000 and NON-TYPICAL
                                                                                                          A2 - Enter all debts/expenses to be paid from
                                                                          Income                 $        the income in A1.                                 Debts and Expenses          $
     CARRYOVER CURRENT ASSESTS (All other current assets
                                                                                   Amount                                                                           Amount
     greater than last years beginning of the year carryover balances).


 1

 2

 3

 4

 5
                    TOTAL INCOME TO BE RECEIVED >                                                    $0
                                                                                                                 TOTAL EXPENSES TO BE PAID >                                            $0
                                                            A3 - Total Income to be received minus total expenses = Cash on Hand >                                                      $0




      Guaranteed Cash Flow                                                                  Page 3                                    afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                             MO 2-FLP Guide 19 Monthly w/o IA
                                                                             (Rev. 04-18-2002)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Guaranteed Monthly Cash Flow W/O Interest Assistance




Guaranteed Monthly Cash Flow                                                                                              Name
                                                  Date Completed          _____________________                           Taxpayer ID #                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        CASH FLOW SUMMARY AND DEBT REPAYMENT TABLE                                                                                    PAGE 4         PAGE 5
Period Covered by Plan                            Signature               ____________________________                    Signature of Lender                  ____________________________                                                                                                                                                                                                                                                                         John Gabbert, a Farmer Program Specialist for Farmers Home                                                                                                                                                                                                                                                ---------     ---------   --------- --------- --------- ---------      ---------             ---------       ---------        ---------   ---------                  ------------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ------------------            -----------
From                                      To                                                                              Date of Plan                    0                                                                                                                                                                                                                                                                                                         Administration in Missouri. It is a tribute to the design and                                                                                            (Obtain the figures to complete Lines 1 to 16 from                                                                                                                       POSITIVE CASH FLOW DETERMINATION - GUARANTEED LOANS                                                                           Without IA                             With IA
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    form used by John Gabbert that updates to the original software                                                                                           the "This Year Total" column of the Cash Flow.)                                                                                                 ---------     ---------   --------- --------- --------- ---------      ---------             ---------       ---------        ---------   ---------                  ------------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ------------------            -----------
                                                   THIS YEAR                                                                                                                                                                                                                                                                                                                                                                                                        have been possible without removing or destroying the original                                                                                                                                                                                                                                                        1. TYPICAL YEAR GROSS FARM OPERATING INCOME (exclude cash carryover)                                                                                   $0                           $0
                                                    TOTAL          JAN         FEB        MAR        APRIL        MAY        JUNE         JULY           AUG      SEPT       OCT        NOV   DEC        Check                                                                                                                                                                                                                                                      programming which was done by him.                                                1. Crop Income (Line 1,2,3 of Cash Flow)                                                                                                                                                                          0
  OPERATING INCOME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    2. Livestock Income (Lines 5 and 6 of Cash Flow)                                                                                                                                                                  0                 2. TYPICAL YEAR TOTAL OPERATING EXPENSES (include withdrawals from entities                                                                            $0                   #DIV/0!
1 Crop Income - (table f-k worksheet J1)                  0                                                                                     0                               0         0    0    1            0                                                                                                                                                                                                                                                                                                                                    3. Other Farm Income (Lines 4,7,9,10,and 11 of Cash Flow)                                                                                                                                                         0                   for living expenses, depreciation, and interest on operating debt, term debt
2                                                         0           0          0           0           0           0           0              0         0          0          0         0    0    2            0                                                                                                                                                                                                                                                  Cashfow, Worksheets 1-4, Tables A & B, Debt Repayment Summary                     4. Total Cash Farm Income (Add Lines 1-3 above)                                                                                                                                                                   0                   and capital leases; exclude income and social security taxes carryover debt
3 Other Farm Income - (table f-k worksheet J2)            0                                              0                                                                      0                   3            0                                                                                                                                                                                                                                                  Print Menu and Single Letter Macros --- John Gabbert 9 24 86                      5. Cash Farm Operating Expenses (Line 36 of Cash Flow)                                                                                                                                                            0                   and delinquent interest)
4                                                         0           0          0           0           0           0           0              0         0          0          0         0    0    4            0                                                                                                                                                                                                                                                                                                                                    6. Net Cash Farm Income (Line 4 minus Line 5 above)                                                                                                                                                               0
5 Livestock Income - (table f-k J3)                       0                                  0                                                                                            0         5            0                                                                                                                                                                                                                                                  Interest Assist Worksheet, Guaranteed Guide 2, Full Menuing                       7. Non-Farm Income (Lines 12 & 13 of Cash Flow)                                                                                                                                                                   0                 3. NET FARM OPERATING INCOME (1-2)                                                                                                                     $0                   #DIV/0!
6                                                         0           0          0           0           0           0           0              0         0          0          0         0    0    6            0                                                                                                                                                                                                                                                  System, Basic Input Screen, Revised Print menu, name location                     8. Total Cash Farm and Non-Farm Income (Add Lines 6 & 7 above)                                                                                                                                                    0
7                                                         0           0          0           0           0           0           0              0         0          0          0         0    0    7            0                                                                                                                                                                                                                                                  revised creditor worksheet to account for interest assist,                        9. Cash Family Living and Non-Farm Expenses (Lines 37-39 of Cash Flow)                                                                                                                                            0                 4. NONFARM INCOME                                                                                                                                      $0                           $0
8 TOTAL OPER. INC.                                        0           0          0           0           0           0           0              0         0          0          0         0    0    8            0                                                                                                                                                                                                                                                  full integration to allow a single entry to be distributed                       10. Net Cash Farm and Non-Farm Income (Line 8 Minus Line 9 above)                                                                                                                                                  0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    to multiple locations, Disclaimer                                                11. Cash Carryover or Beginning Balance (Line 42 of Cash Flow)                                                                                                                                                     0                 5. DEPRECIATION/AMORTIZATION                                                                                                                           $0                           $0
CAPITAL SALES                                                                                                                                                                                                                                                                                                                                                                                                                                                       Jim Harms Gary Harris 2-27-91                                                    12. Loans and Other Credit                                                                                                                                                                                         0
9                                                         0           0          0           0           0           0           0              0         0          0          0         0    0     9           0                                                                                                                                                                                                                                                                                                                                   13. Total Sources Available (Add Lines 10-12 above)                                                                                                                                                                0                 6. ANNUAL TERM DEBT INTEREST                                                                                                                           $0                   #DIV/0!
10                                                        0           0          0           0           0           0           0              0         0          0          0         0    0    10           0                                                                                                                                                                                                                                                  Major revisions/changes were made 1/2000 by Jim Harms.                           14. Capital Purchases and Expenditures (Line 49 of Cash Flow)                                                                                                                                                      0
11                                                        0           0          0           0           0           0           0              0         0          0          0         0    0    11           0                                                                                                                                                                                                                                                  Bla cesh e wsu p rtin sh d le
                                                                                                                                                                                                                                                                                                                                                                                                                                                                     a n e t / p o g ce u s.                                                         15. Balance Available to Pay Debts (Line 13 Minus Line 14 above)                                                                                                                                                   0                 7. ANNUAL CAPITAL LEASE INTEREST                                                                                                                       $0                           $0
  NON FARM INCOME                                                                                                                                                                                                                                                                                                                                                                                                                                                      o th o sh e
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    IAMn lyWrk e t.
12 Wages & Salary - (table f-k worksheet J7)              0           0          0           0           0           0           0              0         0          0          0         0    0    12           0                                                                                                                                                                                                                                                  5Ya H ry
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      e r isto                                                                       --------      --------      --------      --------       --------       --------      --------       --------    --------       --------      --------    --------   --------     --------   --------   --------                     8. INCOME AND SOCIAL SECURTY TAXES                                                                                                                     $0                           $0
13 Interest & Other                                       0                                                                                                                                         13           0                                                                                                                                                                                                                                                  Revised all macros
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    L a L d rswrk e ts
                                                                                                                                                                                                                                                                                                                                                                                                                                                                     o n e ge o sh e                                                                                                                                                                                                                                                                                                      9. LIVING EXPENSES                                                                                                                                     $0                           $0
14 TOTAL CASH IN-FLOW                                     0           0          0           0           0           0           0              0         0          0          0         0    0    14           0                                                                                                                                                                                                                                                   mrtiza n n qu l rin a o sh e
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    A o tiio a dE a P cip l Wrk e ts
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          10. BALANCE AVAILABLE FORTERM DEBT REPAYMENT (3+4+5+6+7-8-9)                                                                                           $0                   #DIV/0!
 CASH OUT-FLOW - Cells #15-35 come from table f-k
15 Labor                                                  0           0          0           0           0           0           0              0         0          0          0         0    0    15           0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ---------    ---------  --------- --------- ---------      ---------      ---------         ---------       ---------        ---------   ---------
16 Mach. & Equip. Rep.                                    0                                  0                                   0                                   0                         0    16           0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          11. "TOTAL ANNUAL SCHEDULED TERM DEBT AND CAPITAL LEASE PAYMENTS"
17 Building Repairs                                       0                                  0                                   0                                   0                         0    17           0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ---------    ---------  --------- --------- ---------      ---------      ---------         ---------        ---------      ---------    ---------
18 Cash Rent & Misc.                                      0                                  0                                                                                            0         18           0                                                                                                                                                                                                                                                                                                                                   --------      --------      --------      --------       --------       --------      --------    --------      --------      --------        --------    --------   --------     --------   --------   --------       Term Debt Owed                                           Amount Due Without                                Amount Due With
19 Seed                                                   0                                                          0           0                                                                  19           0                                                                                                                                                                                                                                                                                                                                                                                                                                     C. DEBT REPAYMENT                                                                                                    (Intermediate and Long Term)                             Interest Assistance                               Interest Assistance
20 Fertilizer & Lime                                      0                                              0           0                                                                              20           0                                                                                                           WORKSHEET 3                                                                                                                                                                                                             --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
21 Chem. & Insect.                                        0                                                          0           0                                                                  21           0                                                                   LOAN REPAYMENT SCHEDULE (PRESENT AND PLANNED LOANS AND ACCOUNTS)                                                                                                                                                                                                                                                       Interest         *         Amt. Due           *                           *                           *            PLAN                    *      Actual
22 Machinery Hire                                         0                                                                      0                                                        0         22           0        ---------        ---------       ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                          --------- --------                                                                                          To Whom Owedm                                         Assist           *             T. Year        *              P.& I.       *                 Date      *                                    *      Amount
23 Farm Supplies                                          0                                  0                                   0                                   0                         0    23           0        Lender:                                                                       * Loan              * Loan Terms         *                                        *                                                  Month                                                                                                                                                          Y=1 N=0          *         (P.& I.)           *             To B Pd       *             To B Pd       *        Source of Funds             *      Paid
24 Vet. & Med.                                            0           0          0           0           0           0           0              0         0          0          0         0    0    24           0                                                                                      * Balance           * Yrs.|    % Int.    * Principal                              * Interest                 Total                          Due                                                                                              --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
25 Feed: Supplement &Grain                                0           0          0           0           0           0           0              0         0          0          0         0    0    25           0        ---------        ---------       ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                          --------- --------                                                                                         Annual Oper. Loan          n                 *                      0   *                   0        *              D /0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        # IV !        *                           *                                    *
26 Marketing                                              0                                              0                                      0                               0              0    26           0    1                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                                    Pmts. on Accounts          s                 *                          *                            *                           *                           *                                    *
27 Trucking & Hauling                                     0                                  0                                   0                                   0                         0    27           0    2                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               1                                                 *                      0   *                            *                           *                           *                                    *
28 Gas, Fuel, Oil                                         0                                  0                                   0                                   0                         0    28           0    3                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               2                                                 *                      0   *                            *                           *                           *                                    *
29 Taxes, R.E.& P.P.                                      0           0          0           0           0           0           0              0         0          0          0         0    0    29           0    4                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               3                                                 *                      0   *                            *                           *                           *                                    *
30 Insurance                                              0                                                                                                                                    0    30           0    5                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               4                                                 *                      0   *                            *                           *                           *                                    *
31 Utilities                                              0           0          0           0           0           0           0              0         0          0          0         0    0    31           0    6                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               5                                                 *                      0   *                            *                           *                           *                                    *
32 Auto & Truck                                           0           0          0           0           0           0           0              0         0          0          0         0    0    32           0    7                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               6                                                 *                      0   *                            *                           *                           *                                    *                    ________________________________                             _________                                     _________
33                                                        0           0          0           0           0           0           0              0         0          0          0         0    0    33           0    8                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               7                                                 *                      0   *                            *                           *                           *                                    *                                           TOTALS                                            $0                                            $0
34                                                        0           0          0           0           0           0           0              0         0          0          0         0    0    34           0    9                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               8                                                 *                      0   *                            *                           *                           *                                    *
35 Current Operating Bills                                0           0                                                                                                                             35           0   10                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               9                                                 *                      0   *                            *                           *                           *                                    *                    12. TERM DEBT AND CAPITAL LEASE COVERAGE RATIO (Line 10 divided by Total Line 11)                                                                            #DIV/0!                      #DIV/0!
36 TOTAL OPER. EXP.                                       0           0          0           0           0           0           0              0         0          0          0         0    0    36           0   11                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               10                                                *                      0   *                            *                           *                           *                                    *                              Minimum 1.1 as per 7 CFR Part 1980, Subpart B, 1980.106(b)
                                                                                                                                                                                                                          TOTALS                                                                        *                 0                                          0                    *                  0    *                  0    *                                                                                                     11                                                *                      0   *                            *                           *                           *                                    *                              If less than 1.1 consider Interest Assistance Program
 OTHER EXPENDITURES                                                                                                                                                                                                       Transfer Totals to:                                                           *                                          CF. L 50                               * CF. L 51              *                       *                                                                                                           ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     ____________                                 *                          *                            *                           *                           *                                    *
37 Family Living Exp - from table f-k                     0           0          0           0           0           0           0              0         0          0          0         0    0    37           0        ---------      ---------         ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------   --------- --------
                                                                                                                                                                                                                                                                                                                                                                                                                                                  -                                                                                                  ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      ____________                                *                          *                            *                           *                           *                                    *                    13. CASH CARRYOVER FROM PREVIOUS YEAR
38 Other Non-Farm Exp.                                    0                                                                                                                                         38           0        * See Note Below                                                                                                                                                                                                                                                                                                           ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      ____________                                *                          *                            *                           *                           *                                    *                            0                                                                $0
39 Inc.& Soc. Sec. Tax - from table f-k                   0                      0                                                                                                                  39           0                                                                                                                                                                                                                                                                                                                                     co e n S x s
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     In m a dS tae                                *                          *                        0   *                      0    *                           *                                    *                            0                                                                $0
                                                                                                                                                                                                                          Description:                                                          * Cost or                     * Month                 *           Planned Term Financing                           *                      *      Years                                                                                               --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------               0                                                                $0
40 Total Farm Operating & Non-farm expenses               0           0          0           0           0           0           0              0         0          0          0         0    0    40           0                                                                              Boot                          * Needed                *               Lender                                       * Amount               * Financed                                                                                                 TOTAL                                                                                       0                      #DIV/0!                                                                                         0           0                                                                $0                                                                                          $0                           $0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
41 OPERATING BALANCE                                      0           0          0           0           0           0           0              0         0          0          0         0    0    41           0             RF
                                                                                                                                                                                                                              # E!                                                               *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         We agree to follow this plan and to discuss with the Bank's Loan Officer any important changes that may become necessary.                                                                                              14. CARRYOVER DEBT FROM PREVIOUS YEAR
                                                                                                                                                                                                                                      0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         This instrument is a prospective plan only and does not release the Bank's security interest in any security referred to herein.                                                                                              0                                                                 $0
42 Beginning Cash Balance                                 0           0          0           0           0           0           0              0         0          0          0         0    0    42                                0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                                                                                                                                                                                                                                                       0                                                                 $0
43 Balance Before Borrowing                               0           0          0           0           0           0           0              0         0          0          0         0    0    43                                0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         ________________                          ________________________________________________                                                    ________________________________________________                                0                                                                 $0
44 Money Borrowed, Oper. L.                               0           0          0           0           0           0           0              0         0          0          0         0    0    44                                0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                            Date                                                                                                          Borrower                                                                    Co-Borrower                      0                                                                 $0                                                                                          $0                           $0
45 Annual Operating Loans Principal Payments.             0                      0           0           0           0           0              0         0          0          0         0    0    45           0                    0                                                          *                       0     *                  0   *                   0                                        *                 0     *
46 Annual Operating Loan Interest Payments                0                      0           0           0           0           0              0         0          0          0         0    0    46           0                    0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         ________________                                                                                                                              ________________________________________________                         15. CAPITAL REPLACEMENT AND TERM DEBT REPAYMENT MARGIN                                                                                                               $0                   #DIV/0!
47 Pymts On Accounts & Beginning OL/LOC Bal               0           0                                                                                                                             47           0        Total                                                                  *                       0     *                      *                                                            *                  0    *                                                                                                            Date                                                                                                                                       Lender                                                    Title
48 New IT & LT Lns (Debt Pymt & Cap Exp wkst)             0           0          0           0           0           0           0              0         0          0          0         0    0    48           0        Figures to:                                                            * CF. L 49     L 49           *                      *                                                            * CF. L 48              *                                                                                                                                                                                                                                                                                                                                16. PORTION OF CAPITAL ASSETS NOT FINANCED                                                                                                                           $0                           $0
49 Capital Purchases. & Expenditures (see wkst)           0           0          0           0           0           0           0              0         0          0          0         0    0    49           0        ---------        ---------     ---------    ---------   ---------      ---------      ---------      ---------    --------- ---------   ---------   ---------   ---------   ---------   ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                          --------- --------                                                                                         Total Assets of:                                     0   Divided by Total Liabilities                                       0   = Net Capital Ratio                     #DIV/0!
50 Inter.& L.T. Debt PRINCIPAL PYMT                       0           0          0           0           0           0           0              0         0          0          0         0    0    50           0        * If a payment in Worksheet Three is to be amortized, you can enter the amortization formula in the total column.                                                                                                                                                                                                          Annual Cash Oper. Exp.                               0   Divided by Gross Income                                            0   = Operating Ratio                       #DIV/0!
51 Inter.& L.T. Debt INTEREST PYMT                        0           0          0           0           0           0           0              0         0          0          0         0    0    51           0        The formula is +@PMT(Principal,Interest,Term). For example a $100000 loan amortized over 7 years at 10% would be entered as                                                                                                                                                                                                Net Income                                           0   Divided by Total Assets                                            0   = Profit to Assets                      #DIV/0!                                        __________________________________________                              ___________
52 Ending Cash Balance                                    0           0          0           0           0           0           0              0         0          0          0         0    0    52                    +@SUM(100000,.10,7) and the total payment would be $20541.                                                                                                                                                                                                                                                                 Debt Repayment                                       0   Divided by Gross Income                                            0   = Debt Repayment                        #DIV/0!                                        CS/ACS Signature                                                        Date
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     --------     --------       --------      --------       --------     --------        --------       --------    --------       --------      --------    --------   --------     --------   --------   --------       ________________________________________________________________________________________________________________________________                                                      ___________
53.Operating Loan Balance                       0            0        0           0          0            0           0           0           0           0          0          0         0    0    53
54.Interest Accrual Operating Loan                       0.00%        0           0          0            0           0           0           0           0          0          0         0    0    54
55.Accumulated Interest                                               0           0          0            0           0           0           0           0          0          0         0    0    55           0
This monthly cash flow is automatically prefilled if you have completed the worksheets Debt Pymt & Capital Exp and table f-k.                                                                                                              Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
It's OK to change the month (JAN - DEC) (light green areas) in which the income & expenses are incurred. (Cells E9..P13, E23..P23, E29..P49, E53..P55)                                                                                 1               0           0           0            0              0             0            0           0           0           0           0
Usually only the yellow areas are changed and/or modified. Grey areas can be changed, but the formulas will be lost.                                                                                                                   2               0           0           0            0              0             0            0           0           0           0           0
NOTE: Any changes/additions made to the yellow areas (cell D10, D12, D14-15, D19..P21, D21, D25) will not transfer back to the table f-k worksheet.                                                                                    3               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       4               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       5               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       6               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       7               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       8               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       9               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                      10               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                      11               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                       0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                           Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                       1               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       2               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       3               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       4               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       5               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       6               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       7               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       8               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                       9               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                      10               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                      11               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                       0           0           0            0              0             0            0           0           0           0           0           0

                                                                                                                                                                                                                                                       0           0           0           0                           0
                                                                                                                                                                                                                                       1                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       2                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       3                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       4                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       5                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       6                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       7                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       8                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                       9                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                      10                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                      11                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                                                     #VALUE!      #VALUE!        #VALUE!       #VALUE!




                                                                                                                                                                                                                                           Annual Operating Loan
                                                                                                                                                                                                                                           AVG Balance
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!               0            0
                                                                                                                                                                                                                                           Term Operating
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                     0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                                                   #DIV/0!




                                                                                                                                                                                                                                           Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                      1                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      2                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      3                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      4                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      5                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      6                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      7                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                     0                                 0           0           0            0              0             0            0           0           0           0           0           0




                                                                                                                                                                                                                                           Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                      1                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      2                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      3                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      4                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      5                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      6                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                      7                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                     0                                 0           0           0            0              0             0            0           0           0           0           0           0




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Page 23                                                                                                                                                                                                                                                                                                                                                                                                                                                   afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Monthly w/o IA
(Rev. 04-18-2002)                            Guaranteed Monthly Cash Flow W/O Interest Assistance




                                   Page 24              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                               MO 2-FLP Guide 19 Monthly IA
                                                                               (Rev. 04-18-2002)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Guaranteed Monthly Cash Flow with Interest Assistance




INTEREST ASSISTANCE Guaranteed Monthly Cash Flow                                                                         Name
                                                  Date Completed           __________
                                                                          ___________                                    Taxpayer ID #                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       CASH FLOW SUMMARY AND DEBT REPAYMENT TABLE                                                                                    PAGE 4         PAGE 5
Period Covered by Plan                            Signature               ____________________________                   Signature of Lender                ____________________________                                                                                                                                                                                                                                                                                          John Gabbert, a Farmer Program Specialist for Farmers Home                                                                                                                                                                                                                                                ---------     ---------   --------- --------- --------- ---------      ---------             ---------       ---------        ---------   ---------                  ------------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  ------------------            -----------
From                                      To                                                                             Date of Plan                  0                                                                                                                                                                                                                                                                                                                          Administration in Missouri. It is a tribute to the design and                                                                                            (Obtain the figures to complete Lines 1 to 16 from                                                                                                                       POSITIVE CASH FLOW DETERMINATION - GUARANTEED LOANS                                                                           Without IA                             With IA
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  form used by John Gabbert that updates to the original software                                                                                           the "This Year Total" column of the Cash Flow.)                                                                                                 ---------     ---------   --------- --------- --------- ---------      ---------             ---------       ---------        ---------   ---------                  ------------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  ------------------            -----------
                                                  THIS YEAR                                                                                                                                                                                                                                                                                                                                                                                                                       have been possible without removing or destroying the original                                                                                                                                                                                                                                                        1. TYPICAL YEAR GROSS FARM OPERATING INCOME (exclude cash carryover)                                                                                   $0                           $0
                                                   TOTAL           JAN         FEB        MAR       APRIL        MAY        JUNE         JULY       AUG        SEPT         OCT        NOV         DEC                 Check                                                                                                                                                                                                                                                      programming which was done by him.                                                1. Crop Income (Line 1,2,3 of Cash Flow)                                                                                                                                                                          0
  OPERATING INCOME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  2. Livestock Income (Lines 5 and 6 of Cash Flow)                                                                                                                                                                  0                 2. TYPICAL YEAR TOTAL OPERATING EXPENSES (include withdrawals from entities                                                                            $0                   #DIV/0!
1 Crop Income - (table f-k worksheet J1)                 0           0           0          0           0           0           0              0                   0          0           0           0          1             0                                                                                                                                                                                                                                                                                                                                    3. Other Farm Income (Lines 4,7,9,10,and 11 of Cash Flow)                                                                                                                                                         0                   for living expenses, depreciation, and interest on operating debt, term debt
2                                                        0           0           0          0           0           0           0              0       0           0          0           0           0          2             0                                                                                                                                                                                                                                                  Cashfow, Worksheets 1-4, Tables A & B, Debt Repayment Summary                     4. Total Cash Farm Income (Add Lines 1-3 above)                                                                                                                                                                   0                   and capital leases; exclude income and social security taxes carryover debt
3 Other Farm Income - (table f-k worksheet J2)           0           0           0          0           0                                              0                      0                                  3             0                                                                                                                                                                                                                                                  Print Menu and Single Letter Macros --- John Gabbert 9 24 86                      5. Cash Farm Operating Expenses (Line 36 of Cash Flow)                                                                                                                                                            0                   and delinquent interest)
4                                                        0           0           0          0           0           0           0              0       0           0          0           0           0          4             0                                                                                                                                                                                                                                                                                                                                    6. Net Cash Farm Income (Line 4 minus Line 5 above)                                                                                                                                                               0
5 Livestock Income - (table f-k J3)                      0           0           0          0           0           0           0              0       0           0          0           0           0          5             0                                                                                                                                                                                                                                                  Interest Assist Worksheet, Guaranteed Guide 2, Full Menuing                       7. Non-Farm Income (Lines 12 & 13 of Cash Flow)                                                                                                                                                                   0                 3. NET FARM OPERATING INCOME (1-2)                                                                                                                     $0                   #DIV/0!
6                                                        0           0           0          0           0           0           0              0       0           0          0           0           0          6             0                                                                                                                                                                                                                                                  System, Basic Input Screen, Revised Print menu, name location                     8. Total Cash Farm and Non-Farm Income (Add Lines 6 & 7 above)                                                                                                                                                    0
7                                                        0           0           0          0           0           0           0              0       0           0          0           0           0          7             0                                                                                                                                                                                                                                                  revised creditor worksheet to account for interest assist,                        9. Cash Family Living and Non-Farm Expenses (Lines 37-39 of Cash Flow)                                                                                                                                            0                 4. NONFARM INCOME                                                                                                                                      $0                           $0
8 TOTAL OPER. INC.                                       0           0           0          0           0           0           0              0       0           0          0           0           0          8             0                                                                                                                                                                                                                                                  full integration to allow a single entry to be distributed                       10. Net Cash Farm and Non-Farm Income (Line 8 Minus Line 9 above)                                                                                                                                                  0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  to multiple locations, Disclaimer                                                11. Cash Carryover or Beginning Balance (Line 42 of Cash Flow)                                                                                                                                                     0                 5. DEPRECIATION/AMORTIZATION                                                                                                                           $0                           $0
CAPITAL SALES                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Jim Harms Gary Harris 2-27-91                                                    12. Loans and Other Credit                                                                                                                                                                                         0
9                                                        0           0           0          0           0           0           0              0       0           0          0           0           0          9             0                                                                                                                                                                                                                                                                                                                                   13. Total Sources Available (Add Lines 10-12 above)                                                                                                                                                                0                 6. ANNUAL TERM DEBT INTEREST                                                                                                                           $0                   #DIV/0!
10                                                       0           0           0          0           0           0           0              0       0           0          0           0           0         10             0                                                                                                                                                                                                                                                  Major revisions/changes were made 1/2000 by Jim Harms.                           14. Capital Purchases and Expenditures (Line 49 of Cash Flow)                                                                                                                                                      0
11                                                       0           0           0          0           0           0           0              0       0           0          0           0           0         11             0                                                                                                                                                                                                                                                  Bla cesh e wsu p rtin sh d le
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   a n e t / p o g ce u s.                                                         15. Balance Available to Pay Debts (Line 13 Minus Line 14 above)                                                                                                                                                   0                 7. ANNUAL CAPITAL LEASE INTEREST                                                                                                                       $0                           $0
  NON FARM INCOME                                                                                                                                                                                                                                                                                                                                                                                                                                                                    o th o sh e
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  IAMn lyWrk e t.
12 Wages & Salary - (table f-k worksheet J7)             0           0           0          0           0           0           0              0       0           0          0           0           0         12             0                                                                                                                                                                                                                                                  5Ya H ry
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    e r isto                                                                       --------      --------      --------      --------       --------       --------      --------       --------    --------       --------      --------    --------   --------     --------   --------   --------                     8. INCOME AND SOCIAL SECURTY TAXES                                                                                                                     $0                           $0
13 Interest & Other                                      0           0           0          0           0           0           0              0       0           0          0           0           0         13             0                                                                                                                                                                                                                                                  Revised all macros
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  L a L d rswrk e ts
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   o n e ge o sh e                                                                                                                                                                                                                                                                                                      9. LIVING EXPENSES                                                                                                                                     $0                           $0
14 TOTAL CASH IN-FLOW                                    0           0           0          0           0           0           0              0       0           0          0           0           0         14             0                                                                                                                                                                                                                                                   mrtiza n n qu l rin a o sh e
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  A o tiio a dE a P cip l Wrk e ts
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        10. BALANCE AVAILABLE FORTERM DEBT REPAYMENT (3+4+5+6+7-8-9)                                                                                           $0                   #DIV/0!
 CASH OUT-FLOW - Cells #15-35 come from table f-k
15 Labor                                                 0           0           0          0           0           0           0              0       0           0          0           0           0         15             0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ---------    ---------  --------- --------- ---------      ---------      ---------         ---------       ---------        ---------   ---------
16 Mach. & Equip. Rep.                                   0           0           0          0           0           0           0              0       0           0          0           0           0         16             0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          11. "TOTAL ANNUAL SCHEDULED TERM DEBT AND CAPITAL LEASE PAYMENTS"
17 Building Repairs                                      0           0           0          0           0           0           0              0       0           0          0           0           0         17             0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ---------    ---------  --------- --------- ---------      ---------      ---------         ---------        ---------      ---------    ---------
18 Cash Rent & Misc.                                     0           0           0          0           0           0           0              0       0           0          0           0           0         18             0                                                                                                                                                                                                                                                                                                                                   --------      --------      --------      --------       --------       --------      --------    --------      --------      --------        --------    --------   --------     --------   --------   --------       Term Debt Owed                                           Amount Due Without                                Amount Due With
19 Seed                                                  0           0           0          0           0           0           0              0       0           0          0           0           0         19             0                                                                                                                                                                                                                                                                                                                                                                                                                                     C. DEBT REPAYMENT                                                                                                    (Intermediate and Long Term)                             Interest Assistance                               Interest Assistance
20 Fertilizer & Lime                                     0           0           0          0           0           0           0              0       0           0          0           0           0         20             0                                                                                                           WORKSHEET 3                                                                                                                                                                                                             --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
21 Chem. & Insect.                                       0           0           0          0           0           0           0              0       0           0          0           0           0         21             0                                                                   LOAN REPAYMENT SCHEDULE (PRESENT AND PLANNED LOANS AND ACCOUNTS)                                                                                                                                                                                                                                                       Interest         *         Amt. Due           *                           *                           *            PLAN                    *      Actual
22 Machinery Hire                                        0           0           0          0           0           0           0              0       0           0          0           0           0         22             0        ---------        ---------       ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                                        --------- --------                                                                                          To Whom Owedm                                         Assist           *             T. Year        *              P.& I.       *                 Date      *                                    *      Amount
23 Farm Supplies                                         0           0           0          0           0           0           0              0       0           0          0           0           0         23             0        Lender:                                                                       * Loan              * Loan Terms         *                                        *                                                  Month                                                                                                                                                          Y=1 N=0          *         (P.& I.)           *             To B Pd       *             To B Pd       *        Source of Funds             *      Paid
24 Vet. & Med.                                           0           0           0          0           0           0           0              0       0           0          0           0           0         24             0                                                                                      * Balance           * Yrs.|    % Int.    * Principal                              * Interest                 Total                          Due                                                                                              --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
25 Feed: Supplement &Grain                               0           0           0          0           0           0           0              0       0           0          0           0           0         25             0        ---------        ---------       ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                                        --------- --------                                                                                         Annual Oper. Loan          n                 *                      0   *                   0        *              D /0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      # IV !        *                           *                                    *
26 Marketing                                             0           0           0          0           0           0           0              0       0           0          0           0           0         26             0    1                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                                    Pmts. on Accounts          s                 *                          *                            *                           *                           *                                    *
27 Trucking & Hauling                                    0           0           0          0           0           0           0              0       0           0          0           0           0         27             0    2                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               1                                                 *                      0   *                            *                           *                           *                                    *
28 Gas, Fuel, Oil                                        0           0           0          0           0           0           0              0       0           0          0           0           0         28             0    3                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               2                                                 *                      0   *                            *                           *                           *                                    *
29 Taxes, R.E.& P.P.                                     0           0           0          0           0           0           0              0       0           0          0           0           0         29             0    4                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               3                                                 *                      0   *                            *                           *                           *                                    *
30 Insurance                                             0           0           0          0           0           0           0              0       0           0          0           0           0         30             0    5                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               4                                                 *                      0   *                            *                           *                           *                                    *
12 Utilities                                             0           0           0          0           0           0           0              0       0           0          0           0           0         31             0    6                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               5                                                 *                      0   *                            *                           *                           *                                    *
32 Auto & Truck                                          0           0           0          0           0           0           0              0       0           0          0           0           0         32             0    7                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               6                                                 *                      0   *                            *                           *                           *                                    *                    ________________________________                             _________                                     _________
33                                                       0           0           0          0           0           0           0              0       0           0          0           0           0         33             0    8                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               7                                                 *                      0   *                            *                           *                           *                                    *                                           TOTALS                                            $0                                            $0
34                                                       0           0           0          0           0           0           0              0       0           0          0           0           0         34             0    9                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               8                                                 *                      0   *                            *                           *                           *                                    *
35 Current Operating Bills                               0           0           0          0           0           0           0              0       0           0          0           0           0         35             0   10                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               9                                                 *                      0   *                            *                           *                           *                                    *                    12. TERM DEBT AND CAPITAL LEASE COVERAGE RATIO (Line 10 divided by Total Line 11)                                                                            #DIV/0!                      #DIV/0!
36 TOTAL OPER. EXP.                                      0           0           0          0           0           0           0              0       0           0          0           0           0         36             0   11                                                                                 *                                       0.0                                       *                       *                       *                    12                                                                               10                                                *                      0   *                            *                           *                           *                                    *                              Minimum 1.1 as per 7 CFR Part 1980, Subpart B, 1980.106(b)
                                                                                                                                                                                                                                        TOTALS                                                                        *                 0                                          0                    *                  0    *                  0    *                                                                                                     11                                                *                      0   *                            *                           *                           *                                    *                              If less than 1.1 consider Interest Assistance Program
 OTHER EXPENDITURES                                                                                                                                                                                                                     Transfer Totals to:                                                           *                                          CF. L 50                               * CF. L 51              *                       *                                                                                                           ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ____________                                 *                          *                            *                           *                           *                                    *
37 Family Living Exp - from table f-k                    0           0           0          0           0           0           0              0       0           0          0           0           0         37             0        ---------      ---------         ---------   ---------   ---------  --------- --------- --------- ---------  --------- ---------   ---------                    ---------  ---------    ---------   ---------   --------- --------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                -                                                                                                  ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ____________                                *                          *                            *                           *                           *                                    *                    13. CASH CARRYOVER FROM PREVIOUS YEAR
38 Other Non-Farm Exp.                                   0           0           0          0           0           0           0              0       0           0          0           0           0         38             0        * See Note Below                                                                                                                                                                                                                                                                                                           ____________
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ____________                                *                          *                            *                           *                           *                                    *                            0                                                                $0
39 Inc.& Soc. Sec. Tax - from table f-k                  0           0           0          0           0           0           0              0       0           0          0           0           0         39             0                                                                                                                                                                                                                                                                                                                                     co e n S x s
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   In m a dS tae                                *                          *                        0   *                      0    *                           *                                    *                            0                                                                $0
                                                                                                                                                                                                                                        Description:                                                          * Cost or                     * Month                 *           Planned Term Financing                           *                      *      Years                                                                                               --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------               0                                                                $0
40 Total Farm Operating & Non-farm expenses              0           0           0          0           0           0           0              0       0           0          0           0           0         40             0                                                                              Boot                          * Needed                *               Lender                                       * Amount               * Financed                                                                                                 TOTAL                                                                                       0                      #DIV/0!                                                                                         0           0                                                                $0                                                                                          $0                           $0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   --------     --------      --------      --------      --------      --------     --------        --------      --------      --------        --------    --------   --------     --------   --------   --------
41 OPERATING BALANCE                                     0           0           0          0           0           0           0              0       0           0          0           0           0         41             0             RF
                                                                                                                                                                                                                                            # E!                                                               *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         We agree to follow this plan and to discuss with the Bank's Loan Officer any important changes that may become necessary.                                                                                              14. CARRYOVER DEBT FROM PREVIOUS YEAR
                                                                                                                                                                                                                                                    0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         This instrument is a prospective plan only and does not release the Bank's security interest in any security referred to herein.                                                                                              0                                                                 $0
42 Beginning Cash Balance                                0           0           0          0           0           0           0              0       0           0          0           0           0         42                                  0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                                                                                                                                                                                                                                                       0                                                                 $0
43 Balance Before Borrowing                              0           0           0          0           0           0           0              0       0           0          0           0           0         43                                  0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         ________________                          ________________________________________________                                                    ________________________________________________                                0                                                                 $0
44 Money Borrowed, Oper. L.                              0           0           0          0           0           0           0              0       0           0          0           0           0         44                                  0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                            Date                                                                                                          Borrower                                                                    Co-Borrower                      0                                                                 $0                                                                                          $0                           $0
45 Annual Operating Loans Principal Payments.            0                       0          0           0           0           0              0       0           0          0           0           0         45             0                    0                                                          *                       0     *                  0   *                   0                                        *                 0     *
46 Annual Operating Loan Interest Payments               0                       0          0           0           0           0              0       0           0          0           0           0         46             0                    0                                                          *                       0     *                  0   *                   0                                        *                 0     *                                                                                                         ________________                                                                                                                              ________________________________________________                         15. CAPITAL REPLACEMENT AND TERM DEBT REPAYMENT MARGIN                                                                                                               $0                   #DIV/0!
47 Pymts On Accounts & Beginning OL/LOC Bal              0           0                                                                                                                                          47             0        Total                                                                  *                       0     *                      *                                                            *                  0    *                                                                                                            Date                                                                                                                                       Lender                                                    Title
48 New IT & LT Lns (Debt Pymt & Cap Exp wkst)            0           0           0          0           0           0           0              0       0           0          0           0           0         48             0        Figures to:                                                            * CF. L 49     L 49           *                      *                                                            * CF. L 48              *                                                                                                                                                                                                                                                                                                                                16. PORTION OF CAPITAL ASSETS NOT FINANCED                                                                                                                           $0                           $0
49 Capital Purchases. & Expenditures (see wkst)          0           0           0          0           0           0           0              0       0           0          0           0           0         49             0        ---------        ---------     ---------    ---------   ---------      ---------      ---------      ---------    --------- ---------   ---------   ---------   ---------   ---------   ---------   ---------           -
                                                                                                                                                                                                                                                                                                                                                                                                                                                        --------- --------                                                                                         Total Assets of:                                     0   Divided by Total Liabilities                                       0   = Net Capital Ratio                     #DIV/0!
50 Inter.& L.T. Debt PRINCIPAL PYMT                      0           0           0          0           0           0           0              0       0           0          0           0           0         50             0        * If a payment in Worksheet Three is to be amortized, you can enter the amortization formula in the total column.                                                                                                                                                                                                          Annual Cash Oper. Exp.                               0   Divided by Gross Income                                            0   = Operating Ratio                       #DIV/0!
51 Inter.& L.T. Debt INTEREST PYMT                       0           0           0          0           0           0           0              0       0           0          0           0           0         51             0        The formula is +@PMT(Principal,Interest,Term). For example a $100000 loan amortized over 7 years at 10% would be entered as                                                                                                                                                                                                Net Income                                           0   Divided by Total Assets                                            0   = Profit to Assets                      #DIV/0!                                        __________________________________________                              ___________
52 Ending Cash Balance                                   0           0           0          0           0           0           0              0       0           0          0           0           0         52                      +@SUM(100000,.10,7) and the total payment would be $20541.                                                                                                                                                                                                                                                                 Debt Repayment                                       0   Divided by Gross Income                                            0   = Debt Repayment                        #DIV/0!                                        CS/ACS Signature                                                        Date
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   --------     --------       --------      --------       --------     --------        --------       --------    --------       --------      --------    --------   --------     --------   --------   --------       ________________________________________________________________________________________________________________________________                                                      ___________
53.Operating Loan Balance                        0           0         0          0          0          0             0           0           0      0            0            0           0          0           53
54.Interest Accrual Operating Loan                       0.00%         0          0          0          0             0           0           0      0            0            0           0          0           54
55.Accumulated Interest                                                0          0          0          0             0           0           0      0            0            0           0          0           55
This monthly cash flow is ONLY to be used with INTEREST ASSISTANCE. W ith IA, this plan has a feasible plan margin of                                                    #DIV/0!
                                                                                                                                                                                                                               0                         Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
This monthly cash flow is automatically prefilled if you have completed the worksheets Debt Pymt & Capital Exp and table f-k.                                                                                                                       1                0           0           0            0              0             0            0           0           0           0           0
It's OK to change the month (JAN - DEC) (grey areas) in which the income & expenses are incurred. (Cells E9..P13, E23..P23, E29..P49, E53..P55)                                                                                                     2                0           0           0            0              0             0            0           0           0           0           0
Usually only the yellow areas are changed and/or modified. Grey areas can be changed, but the formulas will be lost. NOTE: Any changes/additions made to the yellow areas (sell D10, D12, D14-D15, D19..P21, D21,
D25) will not transfer back to the table f-k worksheet.                                                                                                                                                                                              3               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     4               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     5               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     6               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     7               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     8               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     9               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                    10               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                    11               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                                     0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                         Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                                     1               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     2               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     3               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     4               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     5               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     6               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     7               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     8               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                     9               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                    10               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                    11               0           0           0            0              0             0            0           0           0           0           0
                                                                                                                                                                                                                                                                     0           0           0            0              0             0            0           0           0           0           0           0

                                                                                                                                                                                                                                                                     0           0           0           0                           0
                                                                                                                                                                                                                                                     1                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     2                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     3                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     4                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     5                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     6                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     7                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     8                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                     9                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                    10                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                    11                                       0     #VALUE!      #VALUE!        #VALUE!
                                                                                                                                                                                                                                                                                                   #VALUE!      #VALUE!        #VALUE!       #VALUE!




                                                                                                                                                                                                                                                         Annual Operating Loan
                                                                                                                                                                                                                                                         AVG Balance
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!               0            0
                                                                                                                                                                                                                                                         Term Operating
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                   0                      0.04      #DIV/0!      #DIV/0!                            0
                                                                                                                                                                                                                                                                                                                 #DIV/0!




                                                                                                                                                                                                                                                         Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                                    1                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    2                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    3                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    4                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    5                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    6                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    7                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                   0                                 0           0           0            0              0             0            0           0           0           0           0           0




                                                                                                                                                                                                                                                         Jan             Feb         march       april        may            june           july        aug         sept        oct         nov         dec
                                                                                                                                                                                                                                                    1                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    2                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    3                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    4                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    5                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    6                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                                    7                0           0           0            0              0             0            0           0           0           0           0           0
                                                                                                                                                                                                                                   0                                 0           0           0            0              0             0            0           0           0           0           0           0




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Page 25                                                                                                                                                                                                                                                                                                                                                                                                                                                   afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Monthly IA
(Rev. 04-18-2002)                        Guaranteed Monthly Cash Flow with Interest Assistance




                               Page 26              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
               MO 2-FLP Guide 19 Annual                                             Guaranteed Annual Cash Flow
               (Rev.4/18/2002)


F. CASH FAMILY LIVING                       Credit                                 H. CAPITAL AND CARRY-                                      Credit
   EXPENSES                                Needed         Planned Expenses            OVER EXPENSES                                          Needed         Planned Expenses
                                                                                   CAPITAL EXPENSES




Make sure credit card and personal                                                 CARRY-OVER EXPENSES
loan payments are included here or
in Table K. Debt Repayment Table                                                   DEBTS REFINANCED
              TOTAL                           $0                   $0                                         TOTAL                             $0                $0
                                                                                   I. CREDIT FOR                                                         Planned Credit Needs
G. CASH FARM                                Credit                                 Family Living (table F)                                                        $0
   OPERATING EXPENSE                       Needed         Planned Expenses         Farm Operating (table G)                                                       $0
Labor Hired                                                                        Capital and Carryover (table H)                                                $0
Machinery Repair                                                                   CCC Loans
Farm Building and Fence Repair                                                                                TOTAL                                                  $0
Interest                                                           $0
Rent or Lease                                                                      J. SUMMARY OF YEAR'S BUSINESS                                                TOTALS
Feed Purchased                                                                      1. Crop Income (Crop Wkst)                                                     $0
Seeds and Plants Purchased                                                          2. Livestock Income (Lvst Wkst)                                                $0
Fertilizer and Lime                                                                 3. Other Farm Income                                                           $0
Chemicals                                                                           4. Total Cash Farm Income 1+2+3                                                $0
Livestock Expense (Vet, Med)                                                        5. Cash Farm Operating Expense (table G)                                       $0
Custom Hire (Machine Work)                                                          6. Net Cash Farm Income 4-5                                                    $0
Gasoline, Fuel, Oil                                                                 7. Non-farm Income                                                             $0
Taxes                                                                               8. Total Net Cash Farm and Non-farm Income 6+7                                 $0
Truck and Auto                                                                      9. Cash Family Living Expense (table F)                                        $0
Insurance(other than personal)                                                     10. Net Income 8-9                                                              $0
Utilities                                                                          11. Beginning Cash                                                              $0
Supplies Purchased                                                                 12. Loans and Other Credit (table I)                                            $0
Marketing                                                                          13. Interest (table G)                                                          $0
Trucking and Hauling                                                               14. Total Available 10+11+12+13                                                 $0
                                                                                   15. Capital and Carry-over Expense (table H)                                    $0
                                                                                   16. Balance Available 14-15                                                     $0
Current Operating Bills                                                            Balance Available will not change when calculating WITH or WITHOUT IA
TOTAL                                         $0   $0
K. DEBT REPAYMENT                     $0 #DIV/0!      Farm expense to gross farm income ratio - interest & depreciation                                  History =
         To Whom Owed                      Principal and Interest      Principal and Interest
                                           to be Paid WITHOUT                to be Paid                 Date                                          Source of Funds
See Debt Pymt & Capital Exp Worksheet    Interest Assistance        WITH Interest Assistance
Annual operating loan                                         $0                           #DIV/0!




INCOME AND SOCIAL SECURITY TAX                                                                       $0
TOTAL                                  #DIV/0!                       $0             #DIV/0!             #DIV/0!
BALANCE AVAILABLE (Table J #16) divided by K. DEBT REPAYMENT Total = Cash Flow Margin.
For FEASIBLE PLAN, cash flow margin must be greater than or equal to 1.0 or 100%.
To qualify for Interest Assistance (IA), Balance Available to Debt Repayment must be less than 1:1WITHOUT IA and greater than 1:1WITH IA.
IA can be applied to each loan, only 1 loan, or any distribution lender selects, however, IA is only available on as many loans as necessary to achieve a 1:1 cash flow margin.
Signature of Borrower(s)                                                                                                     Date

X_______________________________________ X ____________________________________                                              __________________________________

Signature of Lender                                                                                                          Date

X____________________________________________________                                                                        __________________________________




               Guaranteed Cash Flow                                                                   Page 1                         afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Annual   Guaranteed Annual Cash Flow
(Rev.4/18/2002)




Guaranteed Cash Flow                 Page 1              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Annual    Guaranteed Annual Cash Flow
(Rev.4/18/2002)




                  $0   $0
                  $0   $0
                  $0   $0




Guaranteed Cash Flow                  Page 1              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Annual   Guaranteed Annual Cash Flow
(Rev.4/18/2002)




Guaranteed Cash Flow                 Page 1              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Annual   Guaranteed Annual Cash Flow
(Rev.4/18/2002)




Guaranteed Cash Flow                 Page 1              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
MO 2-FLP Guide 19 Annual   Guaranteed Annual Cash Flow
(Rev.4/18/2002)




Guaranteed Cash Flow                 Page 1              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                                                                                                                                                                                                                                                                                                                     Guaranteed Cash Flow
                                                                                                                                                                                                                                                                                                                                                                     Supporting Schedules




MO 2-FLP Guide 20                                 Name                                                                                                PAGE 1             (A1:L78)      Part A                                                                   FINANCIAL DATA                                             PAGE 3              (O1..W68)
(Rev. 04/18/2002)                                               SUMMARY OF PAST HISTORY                                                                                                                                                                                                                                                          0
                                                                                                                                                                                                                                                                                                                                              year
                                                                                                                                                                                                       Insert date in Cell R5.          Use Farm Records or Income Tax Returns                                                              Average
                                                                                                                                                                                                                                             1995             1996          1997                         1998               1999
Note: The Cash Flow projections are to be based on the loan applicant's/borrower's proven record of production & financial management.                                                 1. Non-farm Income                                                                                                                                                                                                 $0
PART A                                       CROP PRODUCTION HISTORY                                                                                                                   2. Gross Farm Income                                                                                                                                                                                               $0
Insert date in Cell B10.                                                                                                                                                     0         3. Total Farm & Non-farm Income                                  $0                 $0                 $0                 $0                  $0      #VALUE!
                                                                                                Actuals                                                                   YEAR            (1+2)
                     1995                       1996                        1997                        1998                      1999                                 AVERAGE         4. Operating Expenses                                                                                                                                  #DIV/0!                                                     $0
                                                                                                                                                                                            (Exclude Interest. & Depreciation.)
       Crop            acres          yield         acres          yield        acres           yield        acres          yield         acres           yield                        5. Interest Paid                                                                                                                                       #DIV/0!                                                     $0
                               0              0             0              0            0               0            0              0             0               0          0.00      6. Depreciation                                                                                                                                        #DIV/0!                                         0   0       $0
                               0              0             0              0            0               0            0              0             0               0          0.00      7. Total Expenses                                                $0                 $0                 $0                 $0                  $0       #DIV/0!                                         0   0
                               0              0             0              0            0               0            0              0             0               0          0.00        (4 + 5 + 6)                                                                                                                                                                                          0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      8. Family Living Expenses                                                                                                                              #DIV/0!                                         0   0       $0
                               0              0             0              0            0               0            0              0             0               0          0.00                                                                                                                                                                                                             0   0
                               0              0             0              0            0               0            0              0             0               0          0.00       9. Net Cash Income Before Taxes                                 $0                 $0                 $0                 $0                  $0       #DIV/0!                                         0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      10. MO Taxes Paid                                                                                                                                      #DIV/0!                                         0   0       $0
                               0              0             0              0            0               0            0              0             0               0          0.00      11. Federal Taxes Paid                                                                                                                                 #DIV/0!                                         0   0       $0
                               0              0             0              0            0               0            0              0             0               0          0.00      12. Social Security Taxes Paid                                                                                                                         #DIV/0!                                         0   0       $0
                               0              0             0              0            0               0            0              0             0               0          0.00      13. Net Cash Income After Taxes                                  $0                 $0                 $0                 $0                  $0       #DIV/0!                                         0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      13. Operating Expenses       (excluding                                                                                                                             #DIV/0!           0      #DIV/0!   0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      interest & depreciation) to Gross Farm                                                                                                                                                                 0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      Income Ratio                                                                                                                                                                                           0   0
                               0              0             0              0            0               0            0              0             0               0          0.00      NOTE: Any Deviations in the Cash Flow from the Operating Expense to Gross Farm Income Ratio must be thoroughly documented.                                                                             0   0
                               0              0             0              0            0               0            0              0             0               0          0.00                                                                                                                                                                                                             0   0

                                                                                                                                                                                       Part B
Part B                                            LIVESTOCK (Include Cull Sales) PRODUCTION HISTORY                                                                                                                                     FINANCIAL STATEMENT TREND

                                                                                      Actuals                                                                                0         Complete this section OR provide copies of the past three - five years Balance Sheets.
                          1995                           1996                      1997                         1998                        1999                          YEAR
                                                                                                                                                                       AVERAGE         Date Balance Sheets
                       % Production Per              % Production Per           % Production Per             % Production Per             % Production Per                             were completed (M/D/Y)                                 (M/D/Y)            (M/D/Y)            (M/D/Y)            (M/D/Y)             (M/D/Y)                                                                    (M/D/Y)
Kind                   Number      Animal            Number      Animal         Number      Animal           Number      Animal           Number      Animal
                           0            0                0            0             0            0               0            0               0            0                 0.00      1. CURRENT FARM ASSETS                                                                                                                                                                                 0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      2. INTERMEDIATE FARM ASSETS                                                                                                                                                                            0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      3. LONG TERM FARM ASSETS                                                                                                                                                                               0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      4. TOTAL FARM ASSETS                                             $0                 $0                 $0                 $0                  $0                                                       0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      5. NON-FARM ASSETS                                                                                                                                                                                     0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      6. TOTAL ASSETS                                                  $0                 $0                 $0                 $0                  $0                                                       0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      7. CURRENT FARM LIABILITIES                                                                                                                                                                            0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      8. INTERMEDIATE FARM LIABILITIES                                                                                                                                                                       0   0       $0
                           0            0                0            0             0            0               0            0               0            0                 0.00                                                                                                                                                                                                             0   0
                           0            0                0            0             0            0               0            0               0            0                 0.00      9. LONG TERM LIABILITIES                                                                                                                                                                               0   0       $0

Part C                    FEEDER LIVESTOCK OPERATIONS PRODUCTIONS HISTORY                                                                                                              10. TOTAL FARM LIABILITIES                                       $0                 $0                 $0                 $0                  $0

       Name of Enterprise                                                                                                                                                              11. NON-FARM LIABILITIES                                                                                                                                                                                           $0
                                                                                                                                                              0
                                                                                                            Actuals                                        YEAR                        12. TOTAL LIABILITIES                                            $0                 $0                 $0                 $0                  $0
                                                                                   1995           1996         1997           1998          1999        AVERAGE
                                                                                                                                                                                       13. NET WORTH                                                    $0                 $0                 $0                 $0                  $0
1. No. Head on-hand first of year                                                       0               0            0              0             0                0                                                                                                                                                                                                                              0

2. No. Head purchased                                                                   0               0            0              0             0                0                   The above information is furnished for the purpose of securing and maintaining credit and that the undersigned certifies that the above information is true,                                               0
                                                                                                                                                                                       correct and complete to the best of my knowledge. We will provide verification of this information in the form of records or receipts if requested.
3. Average weight/head when purchased                                                   0               0            0              0             0                0                                                                                                                                                                                                                              0

4. Total gross cost of no. head purchased                                               0               0            0              0             0                0                   Date                                                                  Applicant/Borrower's Signature                                                                                                       0

5. No. Head raised                                                                      0               0            0              0             0                0                                                                                                                                                                                                                              0

6. No. Head sold                                                                        0               0            0              0             0                0                                                                                                                                                                                                                              0

7. Average weight/head when sold                                                        0               0            0              0             0                0                                                                                                                                                                                                                              0

8. No. Head on-hand end of year                                                         0               0            0              0             0                0                                                                                                                                                                                                                              0

9. Total Gross $ livestock sales                                                        0               0            0              0             0                0                                                                                                                                                                                                                              0



                                                                SCHEDULE F INCOME TAX RECORDS HISTORY                                                    PAGE 2        (A81..L136)

                   Insert date in Cell B10.

Name:                                                             1995          1996          1997           1998          1999         Average          average          Plan
   INCOME                                                                                                                                             # of Years
Crop Income                                                                                                                                       0         0                      0
Livestock Income                                                                                                                                  0         0                      0
FSA Payments                                                                                                                                      0         0
CCC Loans                                                                                                                                         0         0
Custom & Machine Hire                                                                                                                             0         0
                                                                                                                                                  0         0
Other Farm Income                                                                                                                                 0         0                      0
Gross Farm Income                                                          0            0               0            0              0             0         0                      0
 EXPENSES                                                         1995          1996           1997          1998          1999          Average      # of Years         Planned
Chemicals                                                                                                                                         0         0                      0
Custom Hire                                                                                                                                       0         0                      0
Depreciation                                                                                                                                      0         0
Feed                                                                                                                                              0         0                     0
Fertilizer & Lime                                                                                                                                 0         0                     0
Fuel                                                                                                                                              0         0                     0
Insurance                                                                                                                                         0         0                     0
Interest                                                                                                                                          0         0                    0
Hired Labor                                                                                                                                       0         0                     0
Vet                                                                                                                                               0         0                     0
Rent                                                                                                                                              0         0                     0
Repairs                                                                                                                                           0         0                     0
Seeds                                                                                                                                             0         0                     0
Storage                                                                                                                                           0         0                    0
Supplies                                                                                                                                          0         0                     0
Taxes                                                                                                                                             0         0                     0
Utilities                                                                                                                                         0         0                     0
Miscellaneous                                                                                                                                     0         0
Trucking and Hauling                                                                                                                              0         0                      0
                                                                                                                                                  0         0                      0
                                                                                                                                                  0         0                      0
Truck and Auto                                                                                                                                    0         0                      0
Current Operating Bills                                                                                                                           0         0                      0
Gross Farm Expenses                                                        0            0               0            0              0             0         0                      0

 SUMMARY                                                          1995          1996           1997          1998          1999          Average      # of Years         Planned
Gross Farm Income                                                       0             0              0             0             0              0           0                      0
Gross Farm Expenses                                                     0             0              0             0             0              0           0                      0
Net Farm Income                                                         0             0              0             0             0              0           0                      0
OPERATING EFFICIENCY - interest & depreciation                       0.0%          0.0%           0.0%          0.0%          0.0%           0.0%           0            #DIV/0!
Farm Interest Expense                                                   0             0              0             0             0              0           0                      0
Farm Depreciation                                                       0             0              0             0             0              0           0                      0
Non Farm Income                                                                                                                                 0           0                      0
Other Income                                                                                                                                    0           0
Capital Gain                                                                                                                                    0           0
Total Cash Available                                                       0            0               0            0              0           0           0                      0
Income & SS Taxes                                                                                                                               0           0                      0
Family Living Expense                                                                                                                           0           0                      0
Other Expense                                                                                                                                   0           0
TOTAL OTHER EXPENSES                                                       0            0               0            0              0           0           0                      0
BALANCE AVAILABLE                                                          0            0               0            0              0           0           0                      0

It is not necessary to complete both the detailed Page 2, "Schedule F Income Tax Records History," and the summary Page 3, "Financial Data - Part A".




                                                                                                                                                                                                                                                                                                                                                                          Page 33                               afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                                                     Amortization Schedule




                                   LOAN AMORTIZATION TABLE

                               $100,000.00                        LOAN AMOUNT
                                     7.00%                        INT % PER YEAR
                                         5                        # of YEARS
                                         1                        # PAYMENTS PER YEAR
                                $24,389.07                        PAYMENT AMOUNT

      Complete fields C3 - C6 and then highlight print range such as A1..F18 and use print menu
PMT     PRINCIPAL              TOTAL           PRINCIPAL             INTEREST          PRINCIPAL
NO.                           PMT AMT               PMT                 PMT            BALANCE
 1     $100,000.00              $24,389.07        $17,389.07           $7,000.00        $82,610.93
 2      $82,610.93              $24,389.07        $18,606.30           $5,782.77        $64,004.63
 3      $64,004.63              $24,389.07        $19,908.75           $4,480.32        $44,095.88
 4      $44,095.88              $24,389.07        $21,302.36           $3,086.71        $22,793.52
 5      $22,793.52              $24,389.07        $22,793.52           $1,595.55             $0.00




                                                                                                           Page 34
                                           Equal Principal Payments


                                 EQUAL PRINCIPAL PAYMENT TABLE

                                   $100,000.00                        LOAN AMOUNT
                                         7.00%                        INT % PER YEAR
                                             5                        # of YEARS
                                             1                        # PAYMENTS PER YEAR
                                    $20,000.00                        PAYMENT AMOUNT

      Complete fields C3 - C6 and then highlight print range such as A1..F18 and use File "print" menu
PMT      PRINCIPAL               TOTAL               PRINCIPAL           INTEREST            PRINCIPAL
NO.                             PMT AMT                 PMT                 PMT              BALANCE
  1        $100,000.00             $27,000.00          $20,000.00            $7,000.00         $80,000.00
  2         $80,000.00             $25,600.00          $20,000.00            $5,600.00         $60,000.00
  3         $60,000.00             $24,200.00          $20,000.00            $4,200.00         $40,000.00
  4         $40,000.00             $22,800.00          $20,000.00            $2,800.00         $20,000.00
  5         $20,000.00             $21,400.00          $20,000.00            $1,400.00              $0.00




                                                    Page 35
Equal Principal Payments




        Page 36
Equal Principal Payments




        Page 37
Equal Principal Payments




        Page 38
Equal Principal Payments




        Page 39
Equal Principal Payments




        Page 40
Equal Principal Payments




        Page 41
Equal Principal Payments




        Page 42
Equal Principal Payments




        Page 43
Equal Principal Payments




        Page 44
Equal Principal Payments




        Page 45
                                                                                                                                      Loan Ledger
                                                                                                                               360 over 365 Interest Accrual



                 New                                                                                                                                   Daily      Days       Accrued Interest                 Days                Days
    Date       Interest      Interest                              Principal                 Interest                                 Loan            Interest    This     This           Unpaid              Times              Times
                 Rate          Rate     Loan Advances              Payments                 Payments                   Total         Balance          Accrual    Period   Period          Interest             Rate             Prin. Bal.
                   --                   <Enter beginning of period date, rate & balances for an existing loan on this line>




                                                                                          IF leap year,                                              Average       No.    Interest     If applicable,
                             Average                                                     insert principal                            Average           Daily      Days    Accrued          Interest
                             Interest                                                   balance on Feb                               Principal       Interest    in the     This        Assistance
                               Rate                                                     29th in Cell F45                             Balance         Accrual     Period    Period     Subsidy Owed
                                                                                                                                                                                      $             -
                                          February 29th Principal Balance =                                                                                                                                               $                  -




USDA, FSA
"Approximate Calculations"                                                                                                               Page 46                                                        afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                    Loan Ledger
                             360 over 365 Interest Accrual




USDA, FSA
"Approximate Calculations"             Page 47               afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                                                                                                  Loan Ledger
                                                                                                                                           360 over 360 Interest Accrual




   Enter                        New                                                                                                                                 Daily                  Accrued Interest                                        Days             Days
   Date      Mo. Day    Yr.   Interest   Interest                              Principal                 Interest                                 Principal        Interest    No.       This          Unpaid        Calculation of Days           Times           Times
                                Rate       Rate     Loan Advances              Payments                 Payments            Total Payment         Balance          Accrual    Days      Period         Interest           This Period               Rate          Prin. Bal.
                                                    <Enter beginning of period date, rate & balances for an existing loan on this line.>




                                                                                                                                                                  Average       No.     Interest    If applicable,
                                         Average                                                                                                  Average           Daily      Days    Accrued          Interest
                                         Interest                                                                                                 Principal       Interest    in the      This       Assistance
                                           Rate                                                                                                   Balance         Accrual     Period    Period     Subsidy Owed




                                                                                                                                                                                                                                           afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
USDA, FSA
"Approximate Calculations"                                                                                                                           Page 48
                                                                                                                                       Loan Ledger
                                                                                                                               365 over 365 Interest Accrual



                 New                                                                                                                                  Daily      Days        Accrued Interest               Days                Days
    Date       Interest      Interest                               Principal                Interest                                 Loan           Interest    This     This            Unpaid            Times              Times
                 Rate          Rate     Loan Advances               Payments                Payments                   Total         Balance         Accrual    Period   Period           Interest           Rate             Prin. Bal.
                   --                   <Enter beginning of period date, rate & balances for an existing loan on this line>




                                                                                           IF leap year,                                             Average      No.    Interest       If applicable,
                             Average                                                      insert principal                          Average            Daily     Days    Accrued            Interest
                             Interest                                                    balance on Feb                             Principal        Interest   in the     This          Assistance
                               Rate                                                      29th in Cell F45                           Balance          Accrual    Period    Period      Subsidy Owed
                                                                                                                                                                                      $              -
                                           February 29th Principal Balance =                                                                                                                                            $                  -




USDA, FSA
"Approximate Calculations"                                                                                                               Page 49                                                         afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                     Loan Ledger
                             365 over 365 Interest Accrual




USDA, FSA
"Approximate Calculations"             Page 50               afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                         Menu



Enter Basic Information in Cells B2..B17 below                          First Print Instructions & Disclaimer.
        Enter Borrowers Name
           Enter Borrowers SS
                Telephone No.
                  Period from:
                     Period To:
  Date of Financial Statement:
     Applicant's Date of Birth:
  Co_Applicants Date of Birth:
                 Ages of Sons:
           Ages of Daughters:
               Ages of Others:
           Total Acres Owned:
             Total Crop Acres:
  Interest Rate for Cash Flow:
   Beginning OL/LOC Balance
Cash on Hand (COH) to be
Included in the Cash Flow.
(Use the COH Schedule for
documentation purposes.)                                           $0
IF COH is used, a typical year cash flow must be developed.
Cells B4..B14 are only required if completing the Balance Sheet.
Cells B15..B17 are only required if completing the Cash Flow.




                                                                        Page 51
 Menu




Page 52
 Menu




Page 53
 Menu




Page 54
 Menu




Page 55
 Menu




Page 56
                                                             Print Menu




Can print each individual worksheet on clicking on the PRINT button. This menu is provided to allow you to print all of the three




                                                       P rint Ma in Me nu
                                                              Ba sic
                                                           Informa tion
ed to allow you to print all of the three main sections.
                                                                     Instructions and Disclaimer
                                                                               4/18/2002

                                                       INSTRUCTIONS and DISCLAIMER
This software is provided AS IS and makes NO WARRANTY of any kind, expressed or implied, including without limitations, any warranties of
merchantability and/or fitness for a particular purpose. FURTHER, there shall not be any liability for any damages, whether direct, indirect, special or
consequential arising from a failure of this program to operate in the manner desired by the user. FURTHER MORE, there shall not be any liability for
any damages to data or property which may caused directly or indirectly by use of the program. IN NO EVENT WILL THERE BE ANY LIABILITY FOR
ANY DAMAGES, INCLUDING ANY LOST PROFITS OR OPPORTUNITY COSTS, WHETHER INCIDENTAL OR CONSEQUENTIAL ARISING OUT OF YOUR USE OR
INABILITY TO USE THIS PROGRAM, OR ANY CLAIM BY ANY OTHER PARTY.

If you have any questions about the spreadsheet or find any errors in it please contact :

James L. Harms                                 Phone (573) 876-0980
State Farm Loan Specialist                     Fax (573) 876-0935
USDA, Farm Service Agency                       Email: james.harms@mo.usda.gov
601 Business Loop 70 W
Parkade Center, Suite 225
Columbia, MO 65203

The BASIC BORROWER INFORMATION in the MAIN MENU should always be completed first. This information is transferred to other worksheets.
If only completing the cash flow, the worksheets should be completed in the following order:
           1) 5 Year History MO2-FLP Guide 20 - This worksheet does not have to be completed, but the Page 2 history comparison in the table f-k
           worksheet will be unavailable. It is not necessary to complete the detailed PAGE 2 - Schedule F Income Tax Records History, and then complete
           the summary PAGE 3 - Financial Data, Part A and visa versa.
           2) Debt Pymt & Capital Exp - It is recommended , but not required that these worksheets be completed. The information is used in the prefilled
           green areas in the table f-k worksheet. Note: Both of these worksheets must be completed for all interest assistance loans and to obtain the
           Monthly Cash Flow worksheet. In order to consider a loan for IA the number 1 must be entered for the specific loan. The CASH FLOW
           BEGINNING "CASH ON HAND" WORKSHEET is used to document the amount of cash assets used in the cash flow.
           3) Crop & Livestock - It is recommended, but not required that these worksheets are completed. The information is used in the prefilled green
           areas in the table f-k worksheet.
           4) table f-k - Green areas in Table H, J & K cells are prefilled from the Debt Pymt & Capital Exp Worksheet and the Crop & Livestock Worksheet,
           but can be overwritten. However, if information is input into these green areas, ALL formulas will be lost. Note that interest in Table G is prefilled
           and locked as it is calculated for you.
           5) Monthly Cash Flow - The cell are prefilled from other worksheets. You should change only the month (Jan - Dec) in which the income and/or
           expense are to be incurred. Must complete the Debt Pymt & Capital Exp, Crop & Livestock, and table f-k worksheets.
           6) IA Monthly Cash Flow - The cells are prefilled from other worksheets and is locked/read only. Any changes to the (Jan -Dec) income and
           expenses must be done through the Monthly Cash Flow worksheet. USE ONLY if interest assistance is used to obtain a feasible plan.
For the Balance Sheet, complete the Balance Sheet page 1 and Balance Sheet page 2 worksheets. The Mach List and Bal Sheet Debt Sch supporting
worksheets will be accessed from a GO TO BUTTON from the actual balance sheet.




                                                                                 63
                                                                                                                    afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
                                                                       Instructions and Disclaimer
                                                                                 4/18/2002



                                                         INSTRUCTIONS and DISCLAIMER
                                                                  Continued
Tab key - You should be able to use the Tab key to move the active cell from one input field on the worksheet to another. Use Shift/Tab to move back to a
previous input field. [Note: If Tab or Shift/Tab key move a complete screen instead of one field, it means that the "Transition Navigation Keys" are turned on.
To turn the "Transition Navigation Keys" off, (1) click on the "Tools", (2) click on "Options", (3) click on the "Transition" tab, (4) remove the "x" in the box to the
left of "Transition Navigation Keys" by clicking on the box and (5) click on "OK".]
This workbook does contain macros. When this workbook is opened, a screen can appear and you will need to select ENABLE MACROS.
This workbook and the individual worksheets have been protected. A password is needed to unprotect.
This workbook is considered a master template. It is recommended that immediately after opening, (1) click on File, (2) click on Save As, (3) change the File
name to something you can remember such as the borrower's name, and (4) click on Save. The master template is now preserved for future use.
LOAN LEDGER WORKSHEETS - Enter the date as M/D/Y and use / or - between the month, day, and year. The worksheet has been programmed for a 4-
digit year. Interest rate can be input as a whole number or a decimal (example 9.5% can be entered as 9.5 or .095) and should be the borrower's effective
interest rate. Interest rate changes can be made at any time as per the terms in the promissory note.
If you do not have enough spaces for all of the transactions, start a new worksheet. Under Edit on the menu select Move or Copy Sheet, mark the box Create a
copy, select placement in Before sheet, and click OK. The new worksheet is the same name as one copied, but with a (2). The beginning information on
worksheet (2) is the exact same information as the ending date information on the first worksheet.
FSA calculates and pays interest on either a 365 or 360 daily interest accrual method. FSA does not pay interest on February 29th in leap years. However, this
spreadsheet calculates and includes interest on February 29th in leap years. When February 29th in leap years falls between the beginning and ending claim
period dates, the unpaid principal balance owed by the borrower on February 29th in leap years must be input in Cell F45. For leap years, the correct amount of
IA subsidy that Finance Office will pay in reflected in Cell L45 with the corresponding average principal balance shown in H45.

This workbook has 3 different worksheets to check the borrower's promissory note history records and/or to calculate the amount of interest assistance subsidy
owed the lender. Select which worksheet to use based on how the Daily Interest Accrual is determined (360/365, 360/360, or 365/365).
For interest assistance, you must enter the beginning claim period date in cell A4, interest rate in either cell C4 or F4, beginning principal balance in either cell
H4 or K4, and beginning interest balance in cell L4 or O4. The ending claim period date must be the final date entered in Column A. All transactions (loan
advances, principal payments, interest payments, and interest rate changes) must be entered into the spreadsheet.
If you need more than one spreadsheet to show all transactions between the beginning date and ending date, add the interest assistance subsidy on both
pages together to obtain the total IA subsidy owed. To obtain the Average Principal Balance, divide the total IA subsidy owed from both pages by .04 or 4%.
If you want the borrower's name and loan # to appear on the printed loan ledger worksheet, select View on the menu, select Header and Footer, under
Header/Footer select Custom Header, under the Left section type the borrower's name and loan #, click OK, click OK. To view select Print Preview.
The amount of interest assistance subsidy owed the lender is automatically calculated. It has been calculated by multiplying the Average Principal Balance
times 4% interest divided by a 365 DIA times the actual number of days between the beginning claim period and the ending claim period.
                       Users should check the results of the worksheets to assure themselves of the accuracy of the calculations.



                                                                                     64
                                                                                                                        afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
Instructions and Disclaimer
          4/18/2002




            65
                              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
Instructions and Disclaimer
          4/18/2002




            66
                              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
Instructions and Disclaimer
          4/18/2002




            67
                              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls
Instructions and Disclaimer
          4/18/2002




            68
                              afd4d137-5a67-4efb-b3c5-e6740c4c4808.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:25
posted:5/6/2012
language:Latin
pages:68