Cashflow - Actual Report

     Page No.     1            48000000 Farm Biz Sample Data      Y/E 12-31, Pd.  1-01    THRU  6-30   

09/21 C A S H F L O W - A C T U A L THIS REPORT IS BASED ON UNAUDITED INFORMATION DESCRIPTION JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL CASH AVAILABLE 470 Hogs Farrow Finis 1032 985 225 5094 7336 510 Hogs Weaning Pig 14011 11526 9970 9962 6526 5378 57372 MILK SOLD 4320 4507 4880 4904 4740 4319 27670 222 Corn For Grain 12566 4556 5234 3088 25444 *TOT SALE-CROP/LVSK 30896 17064 19407 21085 11491 17879 117822 ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======== CUSTOM WORK-MACHINERY 1800 1500 3300 CUSTOM WORK-LABOR 500 600 1100 COOP CASH REFUND 9 9 FUEL TAX-FED REFUND 637 637 *TOTAL FARM INCOME 30896 18864 19907 21722 11491 19988 122868 ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======== DIVIDEND INC-TAXABLE 735 735 WAGES-OPER-OFF FARM 220 220 220 220 220 220 1320 *TOTAL CASH IN 31116 19084 20127 21942 11711 20943 124923 ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======== EXPENDITURES MILK HAULING 100 105 113 110 114 103 646 MARKETING-LIVESTOCK 349 231 327 221 1127 BREEDING 60 40 75 40 20 235 VETERINARY 106 117 218 158 186 22 806 MISC LIVESTOCK SUPPLY 192 180 379 123 93 95 1061 FEED-PROTEIN SUPPLEMT 1582 2274 1910 1423 310 1437 8936 FEED-COMPLETE FEED 176 12 12 17 59 145 421 FEED-SOYBEANS PUR 148 178 79 405 FERTILIZER 1809 583 3141 5533 CHEMICALS 515 145 864 1524 SEED 510 84 594 CUSTOM WORK-MACHINE 200 200 CUSTOM WORK-LABOR 40 165 205 FUEL-PICKUP 39 44 56 49 39 230 457 FUEL-MACHINERY 264 362 473 304 256 387 2046 REPAIR-PICKUP F/S 64 76 23 44 207 REPAIR-MACHINERY 378 404 97 1013 1891 REPAIR-LIVESTCK EQUIP 35 55 15 20 125 WAGE-NET PAY 753 753 753 753 753 1506 5272 WAGE-FICA PAID TO DEP 281 374 655 TAX-REAL ESTATE 387 387 RENT-LAND 949 949 949 949 949 4745 GENERAL FARM EXPENSE 167 19 185 ELECTRICITY F/S 133 129 92 63 84 122 623 TELEPHONE F/S 87 29 117 INTEREST-REAL ESTATE 3371 1407 4778 INTEREST-NON-REAL EST 262 262 *TOTAL FARM EXPENSE 5847 5825 5612 7218 7272 11669 43443 ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ========
Printed by Farm Biz for Windows

Page No.     2            48000000 Farm Biz Sample Data      Y/E 12-31, Pd.  1-01    THRU  6-30   
     09/21   
                                                     C A S H F L O W  -  A C T U A L

                                              THIS REPORT IS BASED ON UNAUDITED INFORMATION

     DESCRIPTION               JAN     FEB     MAR     APR     MAY     JUN     JUL     AUG     SEP     OCT     NOV     DEC    TOTAL

     PICKUP PURCHASE F/S                                              5000                                                     5000
     LVSTK EQUIP PURCH                                                 700                                                      700
     DRAW PERSONAL                                                     276                                                      276
     FOOD & MEALS              432     432     432     432     432     222                                                     2382
     CLOTHING                  105      62      44      58             156                                                      425
     SUPPLIES & OPERATING       94      56     166     113      15      14                                                      458
     RECREATION                                                 41                                                               41
     CONTRIBUTIONS              40      40      40      40      40      75                                                      275
     FURNISHINGS/EQUIPMENT     615    1014     570                     280                                                     2480
     PERSONAL CARE              21      37      28      32      18                                                              135
     INSURANCE-HEALTH          408                                      82                                                      490
     DOCTOR/HOSPITAL           208                                                                                              208
     DRUGS                       9      13       9      12       7      29                                                       80
     GIFTS                                             100             160                                                      260
     FUEL-AUTO P/S              23      22      25      23      25                                                              119
     REPAIR-AUTO P/S                    35              31              35                                                      101
     BUILDING REPAIR P/S                                31                                                                       31
     ELECTRICITY P/S            33      30      27      22      14      18                                                      144
     TELEPHONE P/S                                              22      17                                                       39
     GENERAL FARM EXP P/S       57                                                                                               57
     TAX-REAL ESTATE P/S                        41                                                                               41
     TAX-STATE INCOME PD                       873                                                                              873
     TAX-FEDERAL INCOME PD             315                     315                                                              629
     TAX-OTHER PAID                            200                                                                              200
     SPECULATIVE MARGIN PD                                            1500                                                     1500
     TRANS TO OTH CHECKBKS   20000                   30000                                                                    50000
         *TOTAL CASH OUT     27892    7881    8067   38111    8200   20233                                                   110385
     ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ========
     ** CASH BALANCE **       3225   11203   12060  -16169    3511     710                                                    14538

       Begining CB Balance    3432    6657   22159   31719   14549   17561                                                     3432
     PRINCIPAL PAID-FARM                      2500    1000     500     500                                                     4500
     MONEY BORROWED, FARM             4300                            4300                                                     8600
         Ending CB Balance    6657   22159   31719   14549   17561   22070                                                    22070
     ===================== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ========
     Debt Load ($   69700)   69700   74000   71500   70500   70000   73800                                                    73800
     Ratio Op-Exp/Totl-Inc      19      31      28      33      63      58                                                       35
     Incr/Decr Debt LOAD              4300   -2500   -1000    -500    3800                                                     4100

 

Printed by Farm Biz for Windows