{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Input Form","Balance Sheet","Farm Earnings","Annual Cash Flow Projection","Curent Monthly Cash Flow ","DuPont","Annual CF Projection Summary","Current CF Summary"],"not_rendered":{"charts":0,"images":31,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":63,"n_cols":1,"rows_kept":63,"cut":false,"hidden":false,"merged":[[55,2,62,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AAA"]

{"sheet":"Input Form","index":1,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[null,null,"Data entry cell color coding:"]
[null,null,null,null,"Input from AgFA",null,null,"FarmID","Farm1"]
[null,null,null,null,"Input from your own records/projections"]
[null,null,null,null,"Calculations performed by the tool"]
[null,null,"Check box below if comparative year data will be entered:"]
[null,"Farm Earnings Previous Year:",null,null,1,2009,null,"Range for Sensitivity Analyses"]
[{"$f":"E7*E8","v":0},"Farm Earnings Current Year:",null,null,1,2010,null,"Minimum",10,"%"]
[null,"Farm Earnings Projection Year:",null,null,null,2011,null,"Maximum",40,"%"]
[]
[{"$f":"F8","v":2011},null,"Projection INPUT Form"]
[null,"Non-Cash Expenses"]
["Gain (Loss) on Sale of All Farm Capital Assets",null,null,null,null,5908,"(IRS Form 4797)"]
[]
[]
[]
[null,"Non-Farm Income/Family Living Expense"]
[" Total Non-Farm Income ",null,null,null,null,17000]
["- Cash Family Living Expenditures ",null,null,null,null,55670]
[]
[null,"Cash Provided by Operating Activities"]
["Cash Paid for Purchased Resale Livestock",null,null,null,null,0]
["Personal Income Tax Paid",null,null,null,null,0]
["Income Tax Paid",null,null,null,null,1123]
[]
[null,"Cash Provided by Investing Activities"]
["Income from Sales of equipment",null,null,null,null,8092]
["Income from sale of buildings",null,null,null,null,0]
["Income from sale of land",null,null,null,null,0]
["Income from sale of non-current assets",null,null,null,null,0]
["Cash Received from Sale of Assets",null,null,null,null,{"$f":"SUM(F26:F29)","v":8092}]
["Cash Received from Sale of Personal Assets ",null,null,null,null,1252]
["Amount Paid for Breeding Livestock",null,null,null,null,16732]
["Boot Price Paid for Machinery & Equipment ",null,null,null,null,34070]
[" Amount Paid for Buildings ",null,null,null,null,59349]
["Amount Paid for Land and House",null,null,null,null,23028]
[" Amount Paid for Coop Stock, Etc. ",null,null,null,null,8399]
[" Amount Paid for Personal  Assets ",null,null,null,null,5139]
[]
[null,"Cropping Data",null,null,null,null,null,"Hours/acre Labor"]
["Total acres Corn Silage",null,null,35,null,null,null,2.5]
["Total acres corn grain",null,null,50,null,null,null,3]
["Total acres hay forage",null,null,100,null,null,null,2]
["Total acres small grains",null,null,20,null,null,null,1.5]
[]
[null,"Herd Data",null,null,null,"Hours/cow and"]
["Total number cows milked",null,null,100,null,"raised replacement",null,35]
[]
["Predicted Milk Price/Production"]
["Expected average milk price",null,null,12.5,"per CWT",{"$f":"($D$50/100)*$D$46","v":22000},"CWT Annual Production"]
[null,"Avg.  milk/cow",null,22000,"lbs.",{"$f":"(($D$50/100)*$D$46)*$D$49","v":275000},"Gross milk income"]
[]
[null,"Manager/Operator Information"]
["Value Operator Management/$ Gross Income",null,null,null,null,0.06]
["Value Operator Labor/hour",null,null,null,null,15]
[]
[null,"Cash Provided by Financing Activities"]
["Proceeds from Added Term Debt ",null,null,null,null,168962]
[" Repayment of Term Debt ",null,null,null,null,62481]
[" Net Proceeds from Personal Loans ",null,null,null,null,806]
["Proceeds from Gifts",null,null,null,null,0]
["Operating Loans"]
[null,"Beginning loan Balance",null,null,20000]
[null,"New borrowings",null,null,9000]
[null,"Principal paid",null,null,20000]
[null,"Ending loan Balance",null,null,9000]
[]
["Line of Credit"]
[null,"Beginning loan Balance",null,null,0]
[null,"New borrowings",null,null,5553]
[null,"Principal paid",null,null,0]
[null,"Ending loan Balance",null,null,5553]
[]
["CCC Loans"]
[null,"Beginning loan Balance",null,null,0]
[null,"New borrowings",null,null,0]
[null,"Principal paid",null,null,0]
[null,"Ending loan Balance",null,null,0]

{"sheet":"Balance Sheet","index":2,"n_rows":49,"n_cols":33,"rows_kept":49,"cut":false,"hidden":false,"merged":[[24,22,24,26],[28,22,28,26],[19,22,19,26],[19,28,19,32],[33,28,33,32],[33,22,33,26],[7,22,7,26],[7,28,7,32],[11,22,11,26],[11,28,11,32],[15,22,15,26],[15,28,15,32],[28,28,28,32],[24,28,24,32],[46,28,46,32],[46,22,46,26],[42,28,42,32],[42,22,42,26],[37,28,37,32],[37,22,37,26]]}
["Input from AgFA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Form'!I7/100","v":0.1},{"$f":"AVERAGE(W1,Y1)","v":0.17499999999999999},{"$f":"AVERAGE(W1,AA1)","v":0.25},{"$f":"AVERAGE(Y1,AA1)","v":0.32500000000000001},{"$f":"'Input Form'!I8/100","v":0.4}]
["Input from your own records/projections"]
["Calculations performed by the tool"]
[]
["Balance Sheet Statement",null,null,null,null,null,null,null,"↓","↓",null,null,null,null,"Previous Years Values"]
[{"$f":"\"FarmID      \"&'Input Form'!I2","v":"FarmID      Farm1"},{"$f":"'Input Form'!F8","v":2011},"Projection",null,null,null,null,null,{"$f":"'Input Form'!F7","v":2010},{"$f":"I6","v":2010},null,null,null,null,null,"                Range",null,null,null,null,null,null,null,"Sensitivity Analysis",null,{"$f":"'Input Form'!F8","v":2011},"Projection Year End"]
["Current Assets","Ending","Change","Cost Basis",null,null,null,null,"Beginning","Ending","Change","Cost Basis",null,null,"Average","Min","Max",null,null,null,"$ Equity"]
["Cash Accounts",9000,{"$f":"B8-J8","v":-18783.313558558566},null,null,null,null,null,30429.521148648648,27783.313558558566,{"$f":"J8-I8","v":-2646.2075900900818},null,null,null,{"$f":"AVERAGE(J8,I8)","v":29106.417353603607},{"$f":"MIN(I8:J8)","v":27783.313558558566},{"$f":"MAX(I8:J8)","v":30429.521148648648},null,null,null,null,null,"With an increase in operating expenses ",null,null,null,null,null,"With a decrease in operating expenses"]
["Prepaid Expenses & Purchased Inventories",12000,-9343.1635450450231,null,null,null,null,null,15806.166425675678,21343.163545045023,{"$f":"J9-I9","v":5536.9971193693455},null,null,null,18574.664985360352,15806.166425675678,21343.163545045023,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Raised Feed Inventories",165000,12144.53105292804,null,null,null,null,null,147986.39079954952,152855.46894707196,{"$f":"J10-I10","v":4869.0781475224358},null,null,null,150420.92987331073,147986.39079954952,152855.46894707196,null,null,null,null,null,{"$f":"$B$45+'Annual Cash Flow Projection'!N10","v":1010119.0096241757},{"$f":"$B$45+'Annual Cash Flow Projection'!O10","v":965434.01684230764},{"$f":"$B$45+'Annual Cash Flow Projection'!P10","v":920749.02406043955},{"$f":"$B$45+'Annual Cash Flow Projection'!Q10","v":876064.03127857146},{"$f":"$B$45+'Annual Cash Flow Projection'!R10","v":831379.03849670326},null,{"$f":"$B$45-'Annual Cash Flow Projection'!T10","v":992119.00962417584},{"$f":"$B$45-'Annual Cash Flow Projection'!U10","v":947434.01684230764},{"$f":"$B$45-'Annual Cash Flow Projection'!V10","v":902749.02406043955},{"$f":"$B$45-'Annual Cash Flow Projection'!W10","v":858064.03127857135},{"$f":"$B$45-'Annual Cash Flow Projection'!X10","v":813379.03849670314}]
["Basis in Resale Livestock Purchased",null,-931.85810810810813,null,null,null,null,null,1719.1148648648648,931.85810810810813,0,null,null,null,1325.4864864864865,931.85810810810813,1719.1148648648648]
["Accounts Receivable",2200,1581.5337837837837,null,null,null,null,null,759.27105855855859,618.46621621621625,{"$f":"J12-I12","v":-140.80484234234234},null,null,null,688.86863738738748,618.46621621621625,759.27105855855859,null,null,null,null,null,"With an Increase in operating revenue ",null,null,null,null,null,"With a decrease in operating revenue "]
["Market Livestock & Etc.",null,-375.40290540540548,null,null,null,null,null,1190.5333108108109,375.40290540540548,{"$f":"J13-I13","v":-815.13040540540544},null,null,null,782.96810810810825,375.40290540540548,1190.5333108108109,null,null,null,null,null,{"$f":"$B$45+'Annual Cash Flow Projection'!N13","v":1139555.1221648352},{"$f":"$B$45+'Annual Cash Flow Projection'!O13","v":1191947.2137884614},{"$f":"$B$45+'Annual Cash Flow Projection'!P13","v":1244339.3054120878},{"$f":"$B$45+'Annual Cash Flow Projection'!Q13","v":1296731.3970357142},{"$f":"$B$45+'Annual Cash Flow Projection'!R13","v":1349123.4886593404},null,{"$f":"$B$45+'Annual Cash Flow Projection'!T13","v":999842.87783516489},{"$f":"$B$45+'Annual Cash Flow Projection'!U13","v":947450.78621153848},{"$f":"$B$45+'Annual Cash Flow Projection'!V13","v":895058.69458791218},{"$f":"$B$45+'Annual Cash Flow Projection'!W13","v":842666.60296428576},{"$f":"$B$45+'Annual Cash Flow Projection'!X13","v":790274.51134065934}]
["Total Current Assets",{"$f":"SUM(B8:B13)","v":188200},-15707.673280405288,null,null,null,null,null,{"$f":"SUM(I8:I13)","v":197890.99760810804},{"$f":"SUM(J8:J13)","v":203907.67328040529},{"$f":"J14-I14","v":6016.6756722972495}]
["Non-Current Assets",null,"Depreciation","Purchase","Beginning","Ending","Depreciation",null,null,null,null,"Beginning","Ending",null,null,null,null,null,null,null,null,null,"Rate of Return on Equity (ROROE)"]
["Raised Breeding Livestock",247000,"(%)","$","$","$","$",null,300079.94887387386,317808.34009008994,{"$f":"J16-I16","v":17728.391216216085},null,null,null,{"$f":"AVERAGE(J16,I16)","v":308944.14448198187},{"$f":"MIN(I16:J16)","v":300079.94887387386},{"$f":"MAX(I16:J16)","v":317808.34009008994},null,null,null,null,null,"With an increase in operating expenses ",null,null,null,null,null,"With a decrease in operating expenses "]
["Purchased Breeding Livestock",30000,0.1,{"$f":"'Input Form'!F32","v":16732},{"$f":"M17","v":47628.08310810812},{"$f":"(($E$17+$D$17-'Farm Earnings'!$B$20)*(1-$C$17))","v":55997.053781912691},{"$f":"(($E$17+$D$17-'Farm Earnings'!$B$20)*($C$17))","v":6221.8948646569661},null,67018.391891891893,65304.394144144142,-1713.9977477477514,52644.995540540542,47628.08310810812,null,66161.393018018018,65304.394144144142,67018.391891891893,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Machinery & Equipment",226999,7.0000000000000007E-2,{"$f":"'Input Form'!F33","v":34070},{"$f":"M18","v":106065.77383783786},{"$f":"(($E$18+'Balance Sheet'!$D$18-'Input Form'!$F$26)*(1-$C$18))","v":122800.70966918919},{"$f":"(($E$18+'Balance Sheet'!$D$18-'Input Form'!$F$26)*($C$18))","v":9243.0641686486506},null,277600.83571074286,288430.68773223623,10829.852021493367,101071.01061711715,106065.77383783786,null,283015.76172148954,277600.83571074286,288430.68773223623,null,null,null,"ROROE",null,{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)+(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!W17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/W10)","v":-6.8114760878129413E-3},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)+(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!X17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/X10)","v":-5.3411619398315707E-2},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)+(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!Y17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/Y10)","v":-0.10453487815732782},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)+(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!Z17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/Z10)","v":-0.16087337773680366},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)+(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AA17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AA10)","v":-0.22326804503396061},null,{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AC17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AC10)","v":0.11317148263722994},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AD17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AD10)","v":0.1656733548334709},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AE17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AE10)","v":0.22337278630165966},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AF17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AF10)","v":0.28708178951435348},{"$f":"((('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-(((('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10))*(1+'Balance Sheet'!AG17))-('Annual Cash Flow Projection'!$C$13+'Annual Cash Flow Projection'!$C$12+'Annual Cash Flow Projection'!$C$10)))/AG10)","v":0.35779081661249407}]
["Buildings",144000,null,{"$f":"'Input Form'!F34","v":59349},{"$f":"M19","v":261574.32461711712},{"$f":"(($E$19+'Input Form'!$F$34-'Input Form'!$F$27)*(1-$C$19))","v":320923.32461711712},{"$f":"(($E$19+'Input Form'!$F$34-'Input Form'!$F$27)*($C$19))","v":0},null,382745.30310276075,393981.19715493091,11235.894052170159,258179.22844594589,261574.32461711712,null,388363.2501288458,382745.30310276075,393981.19715493091]
["Land & House",450000,null,{"$f":"'Input Form'!F35","v":23028},{"$f":"M20","v":249221.0624549549},{"$f":"($E$20+'Input Form'!$F$35-'Input Form'!$F$28)*(1-$C$20)","v":272249.0624549549},{"$f":"($E$20+'Input Form'!$F$35-'Input Form'!$F$28)*($C$20)","v":0},null,512842.91704954958,529047.52252252272,16204.60547297314,233300.10777027029,249221.0624549549,null,520945.21978603618,512842.91704954958,529047.52252252272,null,null,null,null,null,"Increase in operating revenue ",null,null,null,null,null,"Decrease in operating revenue "]
["Other Non-Current Assets",23000,null,{"$f":"'Input Form'!F36","v":8399},{"$f":"M21","v":39080.209549549545},{"$f":"(($E$21+'Input Form'!$F$36-'Input Form'!$F$29)*(1-$C$21))","v":47479.209549549545},{"$f":"(($E$21+'Input Form'!$F$36-'Input Form'!$F$29)*($C$21))","v":0},null,42762.038018018007,45980.744572072086,3218.7065540540789,35224.666463963928,39080.209549549545,null,44371.391295045047,42762.038018018007,45980.744572072086,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Total Non-Current Assets",{"$f":"SUM(B16:B21)","v":1120999},null,null,{"$f":"SUM(E17:E21)","v":703569.45356756751},{"$f":"SUM(F17:F21)","v":819449.36007272336},{"$f":"SUM(G17:G21)","v":15464.959033305617},null,{"$f":"SUM(I16:I21)","v":1583049.4346468369},{"$f":"SUM(J16:J21)","v":1640552.8862159958},57503.451569158817,{"$f":"SUM(L17:L21)","v":680420.00883783784},{"$f":"SUM(M17:M21)","v":703569.45356756751},null,null,null,null,null,null,null,"ROROE",null,{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1+W21)))/W13","v":0.10754697923514016},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1+X21)))/X13","v":0.14677479057846432},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1+Y21)))/Y13","v":0.18269927930366517},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1+Z21)))/Z13","v":0.21572083977537398},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1+AA21)))/AA13","v":0.24617767042608155},null,{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1-'Balance Sheet'!AC21)))/AC13","v":-1.7159229364175785E-2},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1-'Balance Sheet'!AD21)))/AD13","v":-7.340605539062732E-2},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1-'Balance Sheet'!AE21)))/AE13","v":-0.13623767609151693},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1-'Balance Sheet'!AF21)))/AF13","v":-0.20688230378008579},{"$f":"(('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)-('Annual Cash Flow Projection'!$C$7)+(('Annual Cash Flow Projection'!$C$7)*(1-'Balance Sheet'!AG21)))/AG13","v":-0.28689385335076761}]
["Total Farm Assets",{"$f":"B22+B14","v":1309199},null,null,null,null,null,null,{"$f":"I22+I14","v":1780940.4322549449},{"$f":"J22+J14","v":1844460.5594964011},63520.127241456183]
["Current Liabilities",null,"Change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Ratio (CR)"]
["Accounts Payable",4500,{"$f":"B25-J25","v":-4293.1969594594611},null,null,null,null,null,16846.976223740039,8793.1969594594611,{"$f":"J25-I25","v":-8053.779264280578},null,null,null,{"$f":"AVERAGE(J25,I25)","v":12820.086591599749},{"$f":"MIN(I25:J25)","v":8793.1969594594611},{"$f":"MAX(I25:J25)","v":16846.976223740039},null,null,null,null,null,"With an increase in operating expenses ",null,null,null,null,null,"With a decrease in operating expenses "]
["Current Portion of Non-Current Liabilities",14000,{"$f":"B26-J26","v":-4930.1793248070571},null,null,null,null,null,25666.696824324314,18930.179324807057,{"$f":"J26-I26","v":-6736.5174995172565},null,null,null,{"$f":"AVERAGE(J26,I26)","v":22298.438074565685},{"$f":"MIN(I26:J26)","v":18930.179324807057},{"$f":"MAX(I26:J26)","v":25666.696824324314},null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Other Current Liabilities",12000,{"$f":"B27-J27","v":-13608.028310810801},null,null,null,null,null,null,25608.028310810801,{"$f":"J27-I27","v":25608.028310810801},null,null,null,{"$f":"AVERAGE(J27,I27)","v":25608.028310810801},{"$f":"MIN(I27:J27)","v":25608.028310810801},{"$f":"MAX(I27:J27)","v":25608.028310810801},null,null,null,"CR",null,{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!N10))*(1+W26))-('Annual Cash Flow Projection'!N10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":4.0650345362665652},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!O10))*(1+X26))-('Annual Cash Flow Projection'!O10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":3.8072631777551731},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!P10))*(1+Y26))-('Annual Cash Flow Projection'!P10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":3.4007170669014246},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!Q10))*(1+Z26))-('Annual Cash Flow Projection'!Q10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":2.8453962037053189},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!R10))*(1+AA26))-('Annual Cash Flow Projection'!R10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":2.1413005881668554},null,{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!T10))*(1+AC26))-('Annual Cash Flow Projection'!T10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":4.3295229848752008},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!U10))*(1+AD26))-('Annual Cash Flow Projection'!U10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":4.6172590516191185},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!V10))*(1+AE26))-('Annual Cash Flow Projection'!V10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":5.053769870705394},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!W10))*(1+AF26))-('Annual Cash Flow Projection'!W10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":5.6390554421340262},{"$f":"(($B$14)+(((('Annual Cash Flow Projection'!X10))*(1+AG26))-('Annual Cash Flow Projection'!X10)))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77)","v":6.373115765905017}]
["Total Current Liabilities",{"$f":"SUM(B25:B27)","v":30500},{"$f":"SUM(C25:C27)","v":-22831.404595077322},null,null,null,null,null,{"$f":"SUM(I25:I27)","v":42513.673048064353},{"$f":"SUM(J25:J27)","v":53331.404595077314},{"$f":"J28-I28","v":10817.731547012962}]
["Non-Current Liabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase in operating revenue ",null,null,null,null,null,"Decrease in operating revenue "]
["Intermediate Liabilities",90000,{"$f":"B30-J30","v":-137397.7701527251},null,null,null,null,null,218095.85221217066,227397.7701527251,{"$f":"J30-I30","v":9301.9179405544419},null,null,null,{"$f":"AVERAGE(J30,I30)","v":222746.81118244788},{"$f":"MIN(I30:J30)","v":218095.85221217066},{"$f":"MAX(I30:J30)","v":227397.7701527251},null,null,null,"CR",null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Long-Term Liabilities",125000,{"$f":"B31-J31","v":-359700.90061255731},null,null,null,null,null,459722.66212715179,484700.90061255731,{"$f":"J31-I31","v":24978.238485405513},null,null,null,{"$f":"AVERAGE(J31,I31)","v":472211.78136985458},{"$f":"MIN(I31:J31)","v":459722.66212715179},{"$f":"MAX(I31:J31)","v":484700.90061255731},null,null,null,null,null,{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!N13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":5.7278343765084507},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!O13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":6.8907334425778863},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!P13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":8.0536325086473219},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!Q13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":9.2165315747167611},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!R13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":10.379430640786197},null,{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!T13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":2.6267702003232833},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!U13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":1.4638711342538451},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!V13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":0.30097206818440769},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!W13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":-0.86192699788502958},{"$f":"(($B$14+(-$B$8+'Annual Cash Flow Projection'!X13))/($B$28+'Input Form'!$E$65+'Input Form'!$E$71+'Input Form'!$E$77))","v":-2.0248260639544671}]
["Contingent Liabilities",162000,{"$f":"B32-J32","v":-48677.132122440817},null,null,null,null,null,202010.21071826131,210677.13212244082,{"$f":"J32-I32","v":8666.9214041795058},null,null,null,{"$f":"AVERAGE(J32,I32)","v":206343.67142035108},{"$f":"MIN(I32:J32)","v":202010.21071826131},{"$f":"MAX(I32:J32)","v":210677.13212244082}]
["Total Non-Current Liabilities",{"$f":"SUM(B30:B32)","v":377000},{"$f":"SUM(C30:C32)","v":-545775.8028877232},null,null,null,null,null,{"$f":"SUM(I30:I32)","v":879828.72505758377},{"$f":"SUM(J30:J32)","v":922775.8028877232},{"$f":"J33-I33","v":42947.077830139431},null,null,null,null,null,null,null,null,null,"Working Capital (WC)"]
["Total Farm Liabilities",{"$f":"B33+B28","v":407500},{"$f":"C33+C28","v":-568607.20748280047},null,null,null,null,null,{"$f":"I33+I28","v":922342.39810564811},{"$f":"J33+J28","v":976107.20748280047},{"$f":"J34-I34","v":53764.809377152356},null,null,null,null,null,null,null,null,null,null,null,"With an increase in operating expenses ",null,null,null,null,null,"With a decrease in operating expenses "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Non-Farm Assets",167000,{"$f":"B36-J36","v":-230073.97248560766},null,null,null,null,null,384430.10977068776,397073.97248560766,{"$f":"J36-I36","v":12643.862714919902},null,null,null,{"$f":"AVERAGE(J36,I36)","v":390752.04112814774},{"$f":"MIN(I36:J36)","v":384430.10977068776},{"$f":"MAX(I36:J36)","v":397073.97248560766},null,null,null,"WC",null,{"$f":"($B$14+('Annual Cash Flow Projection'!N10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":98120.009624175727},{"$f":"($B$14+('Annual Cash Flow Projection'!O10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":53435.016842307639},{"$f":"($B$14+('Annual Cash Flow Projection'!P10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":8750.0240604395512},{"$f":"($B$14+('Annual Cash Flow Projection'!Q10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":-35934.968721428537},{"$f":"($B$14+('Annual Cash Flow Projection'!R10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":-80619.961503296741},null,{"$f":"($B$14+('Annual Cash Flow Projection'!T10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":217279.99037582416},{"$f":"($B$14+('Annual Cash Flow Projection'!U10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":261964.98315769236},{"$f":"($B$14+('Annual Cash Flow Projection'!V10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":306649.97593956045},{"$f":"($B$14+('Annual Cash Flow Projection'!W10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":351334.9687214286},{"$f":"($B$14+('Annual Cash Flow Projection'!X10-'Annual Cash Flow Projection'!$C$36)-$B$28)","v":396019.9615032968}]
["Non-Farm Liabilities",8000,{"$f":"B37-J37","v":-2251.1349324324347},null,null,null,null,null,10298.192027027028,10251.134932432435,{"$f":"J37-I37","v":-47.057094594592854},null,null,null,{"$f":"AVERAGE(J37,I37)","v":10274.66347972973},{"$f":"MIN(I37:J37)","v":10251.134932432435},{"$f":"MAX(I37:J37)","v":10298.192027027028}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase in operating revenue ",null,null,null,null,null,"Decrease in operating revenue"]
["Statement of Equities (Net Worth) ",null,"Change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Contributed Capital",505,{"$f":"B40-J40","v":-31.599100000000021},null,null,null,null,null,536.59910000000002,536.59910000000002,{"$f":"J40-I40","v":0},null,null,null,{"$f":"AVERAGE(J40,I40)","v":536.59910000000002},{"$f":"MIN(I40:J40)","v":536.59910000000002},{"$f":"MAX(I40:J40)","v":536.59910000000002},null,null,null,"WC",null,{"$f":"(($B$14+('Annual Cash Flow Projection'!N13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":227556.12216483522},{"$f":"(($B$14+('Annual Cash Flow Projection'!O13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":279948.21378846152},{"$f":"(($B$14+('Annual Cash Flow Projection'!P13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":332340.30541208782},{"$f":"(($B$14+('Annual Cash Flow Projection'!Q13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":384732.39703571424},{"$f":"(($B$14+('Annual Cash Flow Projection'!R13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":437124.48865934054},null,{"$f":"(($B$14+('Annual Cash Flow Projection'!T13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":87843.877835164894},{"$f":"(($B$14+('Annual Cash Flow Projection'!U13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":35451.786211538478},{"$f":"(($B$14+('Annual Cash Flow Projection'!V13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":-16940.305412087881},{"$f":"(($B$14+('Annual Cash Flow Projection'!W13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":-69332.397035714239},{"$f":"(($B$14+('Annual Cash Flow Projection'!X13-'Annual Cash Flow Projection'!$C$36)-$B$28))","v":-121724.4886593406}]
["Retained Earnings",{"$f":"B14+B16+F22+B32-B34-B40","v":1008644.3600727234},549325.5675927233,null,null,null,null,null,447166.19737000001,459318.79248000006,12152.595110000053,null,null,null,{"$f":"AVERAGE(J41,I41)","v":453242.49492500001},{"$f":"MIN(I41:J41)","v":447166.19737000001},{"$f":"MAX(I41:J41)","v":459318.79248000006}]
["Valuation Adjustment",{"$f":"B23-B34-B40-B41","v":-107450.36007272336},-432832.27382152923,"Equity",null,null,null,null,400539.26622173865,325381.91374880588,-75157.352472932776,null,null,null,{"$f":"AVERAGE(J42,I42)","v":362960.58998527227},{"$f":"MIN(I42:J42)","v":325381.91374880588},{"$f":"MAX(I42:J42)","v":400539.26622173865},null,null,null,"Working Capital:Gross Revenue    "]
["Total Farm Equities",{"$f":"SUM(B40:B42)","v":901699},116461.69467119407,"Accuracy",{"$f":"B23-B34","v":901699},null,null,null,{"$f":"SUM(I40:I42)","v":848242.0626917386},{"$f":"SUM(J40:J42)","v":785237.30532880593},-63004.757362932665,null,null,null,null,null,null,null,null,null,null,null,"With an increase in operating expenses ",null,null,null,null,null,"With a decrease in operating expenses"]
["Non-Farm Equities",{"$f":"B36-B37","v":159000},-227822.83755000005,"Check",null,null,null,null,374131.91773999995,386822.83755000005,12690.919810000109,null,null,null,{"$f":"AVERAGE(J44,I44)","v":380477.377645},{"$f":"MIN(I44:J44)","v":374131.91773999995},{"$f":"MAX(I44:J44)","v":386822.83755000005},null,null,null,"WC/GR",null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Total Equities",{"$f":"B44+B43","v":1060699},-111361.14287880599,null,null,null,null,null,{"$f":"I44+I43","v":1222373.9804317385},{"$f":"J44+J43","v":1172060.142878806},-50313.837552932557,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W36/('Farm Earnings'!$B$29+'Balance Sheet'!$B$12)","v":0.13754414549467178},{"$f":"X36/('Farm Earnings'!$B$29+'Balance Sheet'!$B$12)","v":7.4904943030679419E-2},{"$f":"Y36/('Farm Earnings'!$B$29+'Balance Sheet'!$B$12)","v":1.2265740566687054E-2},{"$f":"Z36/('Farm Earnings'!$B$29+'Balance Sheet'!$B$12)","v":-5.0373461897305308E-2},{"$f":"AA36/('Farm Earnings'!$B$29+'Balance Sheet'!$B$12)","v":-0.11301266436129784},null,{"$f":"AC36/('Farm Earnings'!$B$29+$B$12)","v":0.30458201873198504},{"$f":"AD36/('Farm Earnings'!$B$29+$B$12)","v":0.36722122119597755},{"$f":"AE36/('Farm Earnings'!$B$29+$B$12)","v":0.4298604236599699},{"$f":"AF36/('Farm Earnings'!$B$29+$B$12)","v":0.49249962612396236},{"$f":"AG36/('Farm Earnings'!$B$29+$B$12)","v":0.55513882858795482}]
["Rate of Return on Equity (RORE)",{"$f":"('Farm Earnings'!$B$77-'Farm Earnings'!$B$81)/B45","v":4.968383009310267E-2},3.8368961408406788E-3,null,null,null,null,null,{"$f":"('Farm Earnings'!D77-'Farm Earnings'!$D$81)/I45","v":4.8050240678305531E-2},{"$f":"('Farm Earnings'!E77-'Farm Earnings'!$E$81)/J45","v":4.5846933952261991E-2},-2.2033067260435399E-3]
["Current Ratio (CR)",{"$f":"$B$14/$B$28","v":6.1704918032786882},{"$f":"$B$47-$J$47","v":2.3470846601781159},null,null,null,null,null,{"$f":"I14/I28","v":4.6547612431506433},{"$f":"J14/J28","v":3.8234071431005723},-0.83135410005007104,null,null,null,null,null,null,null,null,null,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue "]
["Working Capital (WK)",{"$f":"$B$14-$B$28","v":157700},{"$f":"B48-J48","v":7123.7313146720408},null,null,null,null,null,{"$f":"I14-I28","v":155377.32456004369},{"$f":"J14-J28","v":150576.26868532796},-4801.0558747157338,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4},null,{"$f":"W$1","v":0.1},{"$f":"X$1","v":0.17499999999999999},{"$f":"Y$1","v":0.25},{"$f":"Z$1","v":0.32500000000000001},{"$f":"AA$1","v":0.4}]
["Working Capital: Gross Revenue    ",{"$f":"B48/('Farm Earnings'!B29+'Balance Sheet'!B12)","v":0.22106308211332848},{"$f":"B49-J49","v":2.8679540213042476E-2},null,null,null,null,null,{"$f":"I48/('Farm Earnings'!D29+'Balance Sheet'!I12)","v":0.19848189696237648},{"$f":"J48/('Farm Earnings'!E29+'Balance Sheet'!J12)","v":0.192383541900286},-6.0983550620904714E-3,null,null,null,null,null,null,null,null,null,"WC/GR",null,{"$f":"W40/('Farm Earnings'!$B$29+$B$12)","v":0.31898704958475316},{"$f":"X40/('Farm Earnings'!$B$29+$B$12)","v":0.39243002518832154},{"$f":"Y40/('Farm Earnings'!$B$29+$B$12)","v":0.46587300079188987},{"$f":"Z40/('Farm Earnings'!$B$29+$B$12)","v":0.53931597639545836},{"$f":"AA40/('Farm Earnings'!$B$29+$B$12)","v":0.61275895199902675},null,{"$f":"AC40/('Farm Earnings'!$B$29+$B$12)","v":0.12313911464190394},{"$f":"AD40/('Farm Earnings'!$B$29+$B$12)","v":4.9696139038335425E-2},{"$f":"AE40/('Farm Earnings'!$B$29+$B$12)","v":-2.3746836565233014E-2},{"$f":"AF40/('Farm Earnings'!$B$29+$B$12)","v":-9.7189812168801445E-2},{"$f":"AG40/('Farm Earnings'!$B$29+$B$12)","v":-0.1706327877723699}]

{"sheet":"Farm Earnings","index":3,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["Input from AgFA"]
["Input from your own records/projections"]
["Calculations performed by the tool"]
[]
["Farm Earnings Statement",null,null,null,null,null,"Previous Years Values"]
["FarmID",{"$f":"'Input Form'!I2","v":"Farm1"},null,"↓","↓"]
[null,"Projection",null,null,null,null,null,"                Range"]
["Cash Income - Basis Adjustments",{"$f":"'Input Form'!F8","v":2011},null,{"$f":"'Input Form'!F6","v":2009},{"$f":"'Input Form'!F7","v":2010},null,"Average","Min","Max"]
["Sales of Livestock and Other Items Bought for Resale",364.52967032967035,null,565.30474040632066,565.30474040632066,null,{"$f":"AVERAGE(D9:E9)","v":565.30474040632066},{"$f":"MIN(E9,D9)","v":565.30474040632066},{"$f":"MAX(E9,D9)","v":565.30474040632066}]
["Basis in Resale Livestock Sold",0,null,-1738.6162528216705,-1738.6162528216705,null,-1738.6162528216705,-1738.6162528216705,{"$f":"MAX(E10,D10)","v":-1738.6162528216705}]
["Animal Product Sales",548935.2527472527,null,630562.56322799111,630562.56322799111,null,630562.56322799111,630562.56322799111,630562.56322799111]
["Raised Non-Breeding Livestock Sales",10213.210043956045,null,13462.410541760721,13462.410541760721,null,13462.410541760721,13462.410541760721,13462.410541760721]
["Crop Sales",40304.375824175819,null,51071.842279909739,51071.842279909739,null,51071.842279909739,51071.842279909739,51071.842279909739]
["Distributions Received from Cooperatives",6145.7571648351641,null,6227.0139954853275,6227.0139954853275,null,6227.0139954853275,6227.0139954853275,6227.0139954853275]
["Agricultural Program Payments",12356.780065934065,null,7242.5870654627543,7242.5870654627543,null,7242.5870654627543,7242.5870654627543,7242.5870654627543]
["MILC Program Payments",28473.007032967038,null,1227.1903837471787,1227.1903837471787,null,1227.1903837471787,1227.1903837471787,1227.1903837471787]
["Crop Insurance Proceeds and Certain Disaster Payments",5477.3912087912086,null,4051.7539503386006,4051.7539503386006,null,4051.7539503386006,4051.7539503386006,4051.7539503386006]
["Custom Hire (Machine Work) Income",6587.2153846153842,null,7293.4411738148992,7293.4411738148992,null,7293.4411738148992,7293.4411738148992,7293.4411738148992]
["Other Income, Incl. Tax Credits, Refunds",12735.318681318684,null,8628.9305417607193,8628.9305417607193,null,8628.9305417607193,8628.9305417607193,8628.9305417607193]
["Sale of Purchased Breeding Livestock",2141.1344615384623,null,3631.6159819413097,3631.6159819413097,null,3631.6159819413097,3631.6159819413097,3631.6159819413097]
["Basis in Breeding Livestock Sold",-3522.3370109890107,null,-1813.8885778781039,-1813.8885778781039,null,-1813.8885778781039,-1813.8885778781039,-1813.8885778781039]
["Sale of Raised Breeding Livestock",24827.249362637354,null,29951.816094808099,29951.816094808099,null,29951.816094808099,29951.816094808099,29951.816094808099]
["Total Cash Income - Basis Adjustments",{"$f":"SUM(B9:B22)","v":695038.88463736256},null,{"$f":"SUM(D9:D22)","v":760363.96514672716},{"$f":"SUM(E9:E22)","v":760363.96514672716}]
["Non-Cash Income"]
["Change in Raised Crop Inventories",-7201.9993664835165,null,4566.5252765237019,4566.5252765237019,null,{"$f":"AVERAGE(D25:E25)","v":4566.5252765237019},{"$f":"MIN(E25,D25)","v":4566.5252765237019},{"$f":"MAX(E25,D25)","v":4566.5252765237019}]
["Change in Remaining Current Assets",-687.60610989010979,null,-967.12246049661394,-967.12246049661394,null,{"$f":"AVERAGE(D26:E26)","v":-967.12246049661394},{"$f":"MIN(E26,D26)","v":-967.12246049661394},{"$f":"MAX(E26,D26)","v":-967.12246049661394}]
["Change in Raised Breeding Livestock",24021.757252747244,null,18106.056884875859,18106.056884875859,null,{"$f":"AVERAGE(D27:E27)","v":18106.056884875859},{"$f":"MIN(E27,D27)","v":18106.056884875859},{"$f":"MAX(E27,D27)","v":18106.056884875859}]
["Total Non-Cash Income",{"$f":"SUM(B25:B27)","v":16132.151776373617},null,{"$f":"SUM(D25:D27)","v":21705.459700902946},{"$f":"SUM(E25:E27)","v":21705.459700902946}]
["Total Income",{"$f":"B28+B23","v":711171.03641373618},null,{"$f":"D28+D23","v":782069.42484763009},{"$f":"E28+E23","v":782069.42484763009}]
[]
[]
["Cash Expense"]
["Cost of Items for Resale",128.55384615384617,null,36.720090293453723,36.720090293453723]
["Breeding Fees",9864.0373626373621,null,10002.754356659141,10002.754356659141]
["Car and Truck Expenses",2639.0701098901091,null,2886.7778329571101,2886.7778329571101]
["Crop Chemicals",8521.2153846153869,null,8619.2996613995474,8619.2996613995474]
["Conservation Expenses",4.9890109890109891,null,35.822234762979683,35.822234762979683]
["Custom Heifer Raising Expenses",6722.0439560439554,null,1599.2948081264105,1599.2948081264105]
["Custom Hire (Machine Work)",24393.283516483516,null,26922.399638826188,26922.399638826188]
["Employee Benefits - Dependents",3649.6747252747255,null,3277.2776523702032,3277.2776523702032]
["Employee Benefits - Non-Dependents",14087.668131868129,null,12884.866839729119,12884.866839729119]
["Feed Purchase",187231.82857142863,null,177240.55182844237,177240.55182844237]
["Fertilizer and Lime",18171.156043956045,null,22844.906275395038,22844.906275395038]
["Freight and Trucking",8504.9436043956048,null,8926.0676749435679,8926.0676749435679]
["Gasoline, Fuel, and Oil",21332.857142857138,null,25667.782844243789,25667.782844243789]
["Farm Insurance",9114.9978021978022,null,9191.8536794582378,9191.8536794582378]
["Mortgage Interest",16297.415384615386,null,17036.51072234763,17036.51072234763]
["Other Interest",24545.529846153848,null,22362.847720090289,22362.847720090289]
["Labor Hired - Dependents",6313.7934065934087,null,5465.9864559819425,5465.9864559819425]
["Labor Hired - Non-Dependents",68944.380219780229,null,66095.253340857802,66095.253340857802]
["Pension and Profit-Sharing Plans - Non-Dependents",39.107692307692311,null,39.826185101580137,39.826185101580137]
["Pension and Profit-Sharing Plans - Dependents",0,null,0,0]
["Rent/Lease Equipment",2934.028571428571,null,2876.6360948081256,2876.6360948081256]
["Rent/Lease Other",25187.909890109884,null,27999.672121896161,27999.672121896161]
["Repairs and Maintenance",2339.0307692307692,null,2032.6911060948082,2032.6911060948082]
["Building and Fence Repairs",7591.1846153846172,null,7848.9725056433417,7848.9725056433417]
["Machinery Repairs",22088.490109890106,null,25105.680180586904,25105.680180586904]
["Seeds and Plants Purchased",15642.929670329671,null,23430.201422121896,23430.201422121896]
["Storage and Warehousing",37.872527472527473,null,122.53417607223477,122.53417607223477]
["Supplies Purchased",18482.516483516483,null,20344.790519187361,20344.790519187361]
["Taxes - Other",5461.7142857142853,null,6866.3290293453729,6866.3290293453729]
["Taxes - Payroll",156.48571428571429,null,90.625282167042897,90.625282167042897]
["Utilities",17669.874725274727,null,18036.145124153496,18036.145124153496]
["Veterinary Fees and Medicine",22886.725274725279,null,23013.540248306996,23013.540248306996]
["Other Farm Expenses",6455.4922417582411,null,7122.4696839729158,7122.4696839729158]
["Marketing & Hedging",7214.5604395604387,null,6989.6694808126413,6989.6694808126413]
["Other Crop Expenses",7188.3384615384621,null,6989.7100451467259,6989.7100451467259]
["Other Livestock Expenses",44799.149450549456,null,39952.110812641076,39952.110812641076]
["Total Cash Expense",{"$f":"SUM(B33:B68)","v":636642.84898901114},null,{"$f":"SUM(D33:D68)","v":639958.5776749436},{"$f":"SUM(E33:E68)","v":639958.5776749436}]
["Non-Cash Expenses"]
["- Change in Prepaid Expenses",{"$f":"'Balance Sheet'!C9","v":-9343.1635450450231},null,-5549.4959841986465,-5549.4959841986465]
["Change in Accounts Payable",{"$f":"'Balance Sheet'!C25","v":-4293.1969594594611},null,-1566.3022121896156,-1566.3022121896156]
["Machinery, Equipment and Building Depreciation",{"$f":"'Balance Sheet'!G18+'Balance Sheet'!G19","v":9243.0641686486506},null,63097.546963478992,63097.546963478992,null,{"$f":"AVERAGE(D73:E73)","v":63097.546963478992},{"$f":"MIN(E73,D73)","v":63097.546963478992},{"$f":"MAX(E73,D73)","v":63097.546963478992}]
["Livestock Depreciation",{"$f":"'Balance Sheet'!G17","v":6221.8948646569661},null,12393.734446952587,12393.734446952587,null,{"$f":"AVERAGE(D74:E74)","v":12393.734446952587},{"$f":"MIN(E74,D74)","v":12393.734446952587},{"$f":"MAX(E74,D74)","v":12393.734446952587}]
["Total Non-Cash Expenses",{"$f":"SUM(B71:B74)","v":1828.5985288011325},null,{"$f":"SUM(D71:D74)","v":68375.483214043314},{"$f":"SUM(E71:E74)","v":68375.483214043314}]
["Total Allocated Expenses ",{"$f":"B75+B69","v":638471.44751781225},null,{"$f":"D75+D69","v":708334.06088898692},{"$f":"E75+E69","v":708334.06088898692}]
["Net Farm Income From Operations (NFIFO)",{"$f":"(((B23-B69)+B28)-B75)","v":72699.588895923909},null,73735.363958643371,73735.363958643371,null,{"$f":"AVERAGE(D77:E77)","v":73735.363958643371},{"$f":"MIN(E77,D77)","v":73735.363958643371},{"$f":"MAX(E77,D77)","v":73735.363958643371}]
["Gain (Loss) on Sale of All Farm Capital Assets",{"$f":"'Input Form'!F12","v":5908},null,2707.53424,2707.53424,null,{"$f":"AVERAGE(D78:E78)","v":2707.53424},{"$f":"MIN(E78,D78)","v":2707.53424},{"$f":"MAX(E78,D78)","v":2707.53424}]
["Net Farm Income (NFI)",{"$f":"B78+B77","v":78607.588895923909},null,{"$f":"D78+D77","v":76442.898198643365},{"$f":"E78+E77","v":76442.898198643365}]
["Value of Unpaid Labor",30000,null,25000,30000,null,{"$f":"AVERAGE(D80:E80)","v":27500},{"$f":"MIN(E80,D80)","v":25000},{"$f":"MAX(E80,D80)","v":30000}]
["Value of Unpaid Management",20000,null,15000,20000,null,{"$f":"AVERAGE(D81:E81)","v":17500},{"$f":"MIN(E81,D81)","v":15000},{"$f":"MAX(E81,D81)","v":20000}]
["Total Unpaid Labor",{"$f":"B81+B80","v":50000},null,{"$f":"D81+D80","v":40000},{"$f":"E81+E80","v":50000}]
["Working Capital: Gross Income",{"$f":"'Balance Sheet'!B48/B29","v":0.22174693839507725},null,{"$f":"'Balance Sheet'!I48/D29","v":0.19867459284745179},{"$f":"'Balance Sheet'!J48/E29","v":0.19253568021108178}]
["Working Capital: Operating Expense",{"$f":"'Balance Sheet'!B48/B76","v":0.24699616656796614},null,{"$f":"'Balance Sheet'!I48/D76","v":0.21935599759954941},{"$f":"'Balance Sheet'!J48/E76","v":0.21257804332654689}]
["Average Assets",{"$f":"AVERAGE('Balance Sheet'!J23,'Balance Sheet'!B23)","v":1576829.7797482004},null,{"$f":"'Balance Sheet'!I23","v":1780940.4322549449},{"$f":"AVERAGE('Balance Sheet'!I23:J23)","v":1812700.4958756729}]
["Rate of Return on Assets (ROROA)",{"$f":"(B77+B47+B48-B82)/B85","v":4.0297649716407605E-2},null,{"$f":"(D77+D47+D48-D82)/D85","v":4.1065226594064939E-2},{"$f":"(E77+E47+E48-E82)/E85","v":3.4829097550713901E-2}]
[]
["Operating Profit Margin (OPM)",{"$f":"(B77+B47+B48-B80-B81)/B29","v":8.9349159165877726E-2}]
["Operating Expense Ratio (OER)",{"$f":"(B69-B47-B48)/B29","v":0.83777301556418404}]
["Asset Turn Over Ratio (ATO)",{"$f":"B29/('Balance Sheet'!B23+'Balance Sheet'!J23/2)","v":0.31870650926207544}]
[]
["Calculated values of-"]
["Unpaid Labor",{"$f":"(('Input Form'!$D$40*'Input Form'!$H$40)+('Input Form'!$D$41*'Input Form'!$H$41)+('Input Form'!$D$42*'Input Form'!$H$42)+('Input Form'!$D$43+'Input Form'!$H$43)+('Input Form'!$D$46*'Input Form'!$H$46))*'Input Form'!$F$54","v":59385}]
["Unpaid Management",{"$f":"$B$29*'Input Form'!$F$53","v":42670.262184824169}]

{"sheet":"Annual Cash Flow Projection","index":4,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,19,23,23],[23,13,23,17],[19,13,19,17],[7,13,7,17],[7,19,7,23],[11,13,11,17],[11,19,11,23],[19,19,19,23],[14,13,14,17],[14,19,14,23]]}
["Input from AgFA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!W1","v":0.1},{"$f":"'Balance Sheet'!X1","v":0.17499999999999999},{"$f":"'Balance Sheet'!Y1","v":0.25},{"$f":"'Balance Sheet'!Z1","v":0.32500000000000001},{"$f":"'Balance Sheet'!AA1","v":0.4}]
["Input from your own records/projections"]
["Calculations performed by the tool"]
[{"$f":"FarmID","v":"Farm1"}]
["Cash Flow Statement- Annual",null,"Projection",null,null,"↓","↓",null,"Previous Years Values",null,"                Range"]
["Cash Provided by Operating Activities",null,{"$f":"'Input Form'!F8","v":2011},null,null,{"$f":"'Input Form'!F6","v":2009},{"$f":"'Input Form'!F7","v":2010},null,"Average","Min","Max",null,null,"Sensitivity Analysis for:",null,null,{"$f":"'Input Form'!F8","v":2011}]
["Cash Received from Operations ",null,{"$f":"'Farm Earnings'!B23-'Farm Earnings'!B21","v":698561.22164835152},null,null,397613,397613,null,{"$f":"AVERAGE(F7:G7)","v":397613},{"$f":"MIN(G7,F7)","v":397613},{"$f":"MAX(G7,F7)","v":397613}]
["+ Total Non-Farm Income ",null,16313,null,null,2493,2493,null,2493,2493,2493,null,"Cash Flow ","Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["- Cash Paid for Purchased Resale Livestock ",null,{"$f":"-'Input Form'!F21","v":0},null,null,0,0,null,0,0,0,null,null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4},null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4}]
["- Cash Paid for Purchased Feed ",null,{"$f":"-'Farm Earnings'!B42","v":-187231.82857142863},null,null,-44635,-44635,null,-44635,-44635,-44635,null,"Cash at end of year",{"$f":"(($C$13+$C$10+$C$12)*(1+N9)-($C$13+$C$12+$C$10))+$C$36","v":-50579.990375824273},{"$f":"(($C$13+$C$10+$C$12)*(1+O9)-($C$13+$C$12+$C$10))+$C$36","v":-95264.983157692361},{"$f":"(($C$13+$C$10+$C$12)*(1+P9)-($C$13+$C$12+$C$10))+$C$36","v":-139949.97593956045},{"$f":"(($C$13+$C$10+$C$12)*(1+Q9)-($C$13+$C$12+$C$10))+$C$36","v":-184634.96872142854},{"$f":"(($C$13+$C$10+$C$12)*(1+R9)-($C$13+$C$12+$C$10))+$C$36","v":-229319.96150329674},null,{"$f":"(($C$13+$C$10+$C$12)*(1-N9)-($C$13+$C$12+$C$10))+$C$36","v":68579.990375824156},{"$f":"(($C$13+$C$10+$C$12)*(1-O9)-($C$13+$C$12+$C$10))+$C$36","v":113264.98315769236},{"$f":"(($C$13+$C$10+$C$12)*(1-P9)-($C$13+$C$12+$C$10))+$C$36","v":157949.97593956045},{"$f":"(($C$13+$C$10+$C$12)*(1-Q9)-($C$13+$C$12+$C$10))+$C$36","v":202634.9687214286},{"$f":"(($C$13+$C$10+$C$12)*(1-R9)-($C$13+$C$12+$C$10))+$C$36","v":247319.9615032968},null,{"$f":"($C$13+$C$12+$C$10)-(($C$13+$C$12+$C$10)*(1-T9))","v":-59579.990375824156}]
["- Cash Interest Paid ",null,{"$f":"-SUM('Farm Earnings'!B47,'Farm Earnings'!B48)","v":-40842.945230769234},null,null,-30292,-30292,null,-30292,-30292,-30292,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($C$13+$C$12+$C$10)","v":-595799.90375824191}]
["- Wages and Benefits Paid ",null,{"$f":"-SUM('Farm Earnings'!B40,'Farm Earnings'!B41,'Farm Earnings'!B49,'Farm Earnings'!B50,'Farm Earnings'!B51,'Farm Earnings'!B52)","v":-93034.624175824181},null,null,-5262,-5262,null,-5262,-5262,-5262,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["- Cash Paid for Other Operating Expenses ",null,{"$f":"-('Farm Earnings'!B69+(SUM(C9:C12)))","v":-315533.45101098908},null,null,-215584,-215584,null,-215584,-215584,-215584,null,"Cash at end of year",{"$f":"((($C$7*(1+N9)))-$C$7+$C$36)","v":78856.122164835222},{"$f":"((($C$7*(1+O9)))-$C$7+$C$36)","v":131248.21378846152},{"$f":"((($C$7*(1+P9)))-$C$7+$C$36)","v":183640.30541208782},{"$f":"((($C$7*(1+Q9)))-$C$7+$C$36)","v":236032.39703571424},{"$f":"((($C$7*(1+R9)))-$C$7+$C$36)","v":288424.48865934054},null,{"$f":"(($C$7*(1-T9)))-$C$7+$C$36","v":-60856.122164835106},{"$f":"(($C$7*(1-U9)))-$C$7+$C$36","v":-113248.21378846152},{"$f":"(($C$7*(1-V9)))-$C$7+$C$36","v":-165640.30541208788},{"$f":"(($C$7*(1-W9)))-$C$7+$C$36","v":-218032.39703571424},{"$f":"(($C$7*(1-X9)))-$C$7+$C$36","v":-270424.4886593406}]
["- Cash Family Living Expenditures ",null,0,null,null,-27000,-27000,null,-27000,-27000,-27000]
["- Income & Social Security Taxes Paid ",null,{"$f":"-('Farm Earnings'!B62+'Input Form'!F23)","v":-1279.4857142857143},null,null,0,0,null,0,0,0,null,null,"Increase in Interest expenses",null,null,null,null,null,"Decrease in Interest expenses"]
["Net Cash Provided by Operating Activities ",null,{"$f":"SUM(C7:C15)","v":76951.886945054677},null,null,{"$f":"SUM(F7:F15)","v":77333},{"$f":"SUM(G7:G15)","v":77333},null,null,null,null,null,null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4},null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4}]
["Cash Provided by Investing Activities",null,null,null,null,null,null,null,null,null,null,null,"Cash at end of year",{"$f":"((('Farm Earnings'!$B$48-('Farm Earnings'!$B$48)*(1+N16))+$C$36))","v":6545.4470153846123},{"$f":"((('Farm Earnings'!$B$48-('Farm Earnings'!$B$48)*(1+O16))+$C$36))","v":4704.532276923077},{"$f":"((('Farm Earnings'!$B$48-('Farm Earnings'!$B$48)*(1+P16))+$C$36))","v":2863.6175384615381},{"$f":"((('Farm Earnings'!$B$48-('Farm Earnings'!$B$48)*(1+Q16))+$C$36))","v":1022.7027999999991},{"$f":"((('Farm Earnings'!$B$48-('Farm Earnings'!$B$48)*(1+R16))+$C$36))","v":-818.21193846153619},null,{"$f":"('Farm Earnings'!$B$48-(('Farm Earnings'!$B$48*(1-T16)))+$C$36)","v":11454.552984615384},{"$f":"('Farm Earnings'!$B$48-(('Farm Earnings'!$B$48*(1-U16)))+$C$36)","v":13295.467723076923},{"$f":"('Farm Earnings'!$B$48-(('Farm Earnings'!$B$48*(1-V16)))+$C$36)","v":15136.382461538462},{"$f":"('Farm Earnings'!$B$48-(('Farm Earnings'!$B$48*(1-W16)))+$C$36)","v":16977.297200000001},{"$f":"('Farm Earnings'!$B$48-(('Farm Earnings'!$B$48*(1-X16)))+$C$36)","v":18818.21193846154}]
["Cash Received from Sale of Assets ",null,{"$f":"'Input Form'!F30","v":8092},null,null,0,0,null,{"$f":"AVERAGE(F18:G18)","v":0},{"$f":"MIN(G18,F18)","v":0},{"$f":"MAX(G18,F18)","v":0},null,"Ending Liquidity",{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1+N16)-'Farm Earnings'!$B$48)","v":155245.44701538462},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1+O16)-'Farm Earnings'!$B$48)","v":153404.53227692307},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1+P16)-'Farm Earnings'!$B$48)","v":151563.61753846155},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1+Q16)-'Farm Earnings'!$B$48)","v":149722.7028},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1+R16)-'Farm Earnings'!$B$48)","v":147881.78806153848},null,{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1-N16)-'Farm Earnings'!$B$48)","v":160154.55298461538},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1-O16)-'Farm Earnings'!$B$48)","v":161995.46772307693},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1-P16)-'Farm Earnings'!$B$48)","v":163836.38246153845},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1-Q16)-'Farm Earnings'!$B$48)","v":165677.2972},{"$f":"'Balance Sheet'!$B$48-('Farm Earnings'!$B$48*(1-R16)-'Farm Earnings'!$B$48)","v":167518.21193846155}]
["+ Cash Received from Sale of Personal Assets ",null,{"$f":"'Input Form'!F31","v":1252},null,null,0,0,null,0,0,0]
["- Amount Paid for Breeding Livestock ",null,{"$f":"-'Input Form'!F32","v":-16732},null,null,0,0,null,0,0,0,null,"Working Capital ","Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["- Boot Price Paid for Machinery & Equipment ",null,{"$f":"-'Input Form'!F33","v":-34070},null,null,-41187,-41187,null,-41187,-41187,-41187,null,null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4},null,{"$f":"N$1","v":0.1},{"$f":"O$1","v":0.17499999999999999},{"$f":"P$1","v":0.25},{"$f":"Q$1","v":0.32500000000000001},{"$f":"R$1","v":0.4}]
["- Amount Paid for Buildings ",null,{"$f":"-'Input Form'!F34","v":-59349},null,null,0,0,null,0,0,0,null,"Ending Liquidity",{"$f":"($C$13+$C$12+$C$10)*(1+N21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":98120.009624175727},{"$f":"($C$13+$C$12+$C$10)*(1+O21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":53435.016842307639},{"$f":"($C$13+$C$12+$C$10)*(1+P21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":8750.0240604395512},{"$f":"($C$13+$C$12+$C$10)*(1+Q21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":-35934.968721428537},{"$f":"($C$13+$C$12+$C$10)*(1+R21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":-80619.961503296741},null,{"$f":"($C$13+$C$12+$C$10)*(1-N21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":217279.99037582416},{"$f":"($C$13+$C$12+$C$10)*(1-O21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":261964.98315769236},{"$f":"($C$13+$C$12+$C$10)*(1-P21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":306649.97593956045},{"$f":"($C$13+$C$12+$C$10)*(1-Q21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":351334.9687214286},{"$f":"($C$13+$C$12+$C$10)*(1-R21)-($C$13+$C$12+$C$10)+'Balance Sheet'!$B$48","v":396019.9615032968}]
["- Amount Paid for Land ",null,{"$f":"-'Input Form'!F35","v":-23028},null,null,0,0,null,0,0,0]
["- Amount Paid for Coop Stock, Etc. ",null,{"$f":"-'Input Form'!F36","v":-8399},null,null,0,0,null,0,0,0,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["- Amount Paid for Personal  Assets ",null,{"$f":"-'Input Form'!F37","v":-5139},null,null,0,0,null,0,0,0,null,"Ending Liquidity",{"$f":"(($C$7*(1+N21)))-$C$7+'Balance Sheet'!$B$48","v":227556.12216483522},{"$f":"(($C$7*(1+O21)))-$C$7+'Balance Sheet'!$B$48","v":279948.21378846152},{"$f":"(($C$7*(1+P21)))-$C$7+'Balance Sheet'!$B$48","v":332340.30541208782},{"$f":"(($C$7*(1+Q21)))-$C$7+'Balance Sheet'!$B$48","v":384732.39703571424},{"$f":"(($C$7*(1+R21)))-$C$7+'Balance Sheet'!$B$48","v":437124.48865934054},null,{"$f":"(($C$7*(1-N21)))-$C$7+'Balance Sheet'!$B$48","v":87843.877835164894},{"$f":"(($C$7*(1-O21)))-$C$7+'Balance Sheet'!$B$48","v":35451.786211538478},{"$f":"(($C$7*(1-P21)))-$C$7+'Balance Sheet'!$B$48","v":-16940.305412087881},{"$f":"(($C$7*(1-Q21)))-$C$7+'Balance Sheet'!$B$48","v":-69332.397035714239},{"$f":"(($C$7*(1-R21)))-$C$7+'Balance Sheet'!$B$48","v":-121724.4886593406}]
["Net Cash Provided by Investing Activities ",null,{"$f":"SUM(C18:C25)","v":-137373},null,null,{"$f":"SUM(F18:F25)","v":-41187},{"$f":"SUM(G18:G25)","v":-41187}]
["Cash Provided by Financing Activities"]
["Net Proceeds from Operating & CCC Loans ",null,{"$f":"'Input Form'!E63+'Input Form'!E69+'Input Form'!E75","v":14553},null,null,-9693,-9693,null,{"$f":"AVERAGE(F28:G28)","v":-9693},{"$f":"MIN(G28,F28)","v":-9693},{"$f":"MAX(G28,F28)","v":-9693}]
["+ Net Capital Contribution, Gifts, Etc. ",null,{"$f":"'Balance Sheet'!C40+'Input Form'!F60","v":-31.599100000000021},null,null,0,0,null,{"$f":"AVERAGE(F29:G29)","v":0},{"$f":"MIN(G29,F29)","v":0},{"$f":"MAX(G29,F29)","v":0}]
["+ Proceeds from Added Term Debt ",null,{"$f":"'Input Form'!F57","v":168962},null,null,49135,49135,null,{"$f":"AVERAGE(F30:G30)","v":49135},{"$f":"MIN(G30,F30)","v":49135},{"$f":"MAX(G30,F30)","v":49135}]
["- Repayment of Term Debt ",null,{"$f":"-'Input Form'!F58","v":-62481},null,null,-46977,-46977,null,{"$f":"AVERAGE(F31:G31)","v":-46977},{"$f":"MIN(G31,F31)","v":-46977},{"$f":"MAX(G31,F31)","v":-46977}]
["+ Net Proceeds from Personal Loans ",null,{"$f":"'Input Form'!F59","v":806},null,null,0,0,null,{"$f":"AVERAGE(F32:G32)","v":0},{"$f":"MIN(G32,F32)","v":0},{"$f":"MAX(G32,F32)","v":0}]
["Net Cash Provided by Financing Activities ",null,{"$f":"SUM(C28:C32)","v":121808.40090000001},null,null,{"$f":"SUM(F28:F32)","v":-7535},{"$f":"SUM(G28:G32)","v":-7535}]
["Cash Provided by Cash Accounts"]
["Cash at Beginning of Year ",null,{"$f":"'Balance Sheet'!J8","v":27783.313558558566},null,null,37622,37622,null,{"$f":"AVERAGE(F35:G35)","v":37622},{"$f":"MIN(G35,F35)","v":37622},{"$f":"MAX(G35,F35)","v":37622}]
["- Cash at End of Year ",null,{"$f":"'Balance Sheet'!B8","v":9000},null,null,-66884,-66884,null,{"$f":"AVERAGE(F36:G36)","v":-66884},{"$f":"MIN(G36,F36)","v":-66884},{"$f":"MAX(G36,F36)","v":-66884}]
["Net Cash Provided by Cash Accounts ",null,{"$f":"C35-C36","v":18783.313558558566},null,null,{"$f":"F35+F36","v":-29262},{"$f":"G35-G36","v":104506}]
["Cash Flow Imbalance",null,{"$f":"C16+C26+C33+C37","v":80170.601403613255},null,null,{"$f":"F16+F26+F33+F37","v":-651},{"$f":"G16+G26+G33+G37","v":133117}]
["Cash Flow Imbalance % Cash Income",null,{"$f":"C38/C7","v":0.11476531894289761},null,null,{"$f":"F38/F7","v":-1.6372704111787091E-3},{"$f":"G38/G7","v":0.33479036148214469}]
["Cash Flow Coverage Ratio, Farm Only",null,{"$f":"(C35+C7+C18+C28+C29+C30)/(C9+C10+C11+C12+C13+C15+C20+C21+C22+C23+C24+C31)","v":-1.0901903620350124},null,null,{"$f":"(F35+F7+F18+F28+F29+F30)/(F9+F10+F11+F12+F13+F15+F20+F21+F22+F23+F24+F31)","v":-1.2363408580053499},{"$f":"(G35+G7+G18+G28+G29+G30)/(G9+G10+G11+G12+G13+G15+G20+G21+G22+G23+G24+G31)","v":-1.2363408580053499}]
["Cash Flow Coverage Ratio, Farm + Personal",null,{"$f":"(C35+C7+C18+C28+C29+C30+C32+C18+C8)/(C9+C10+C11+C12+C13+C15+C20+C21+C22+C23+C24+C31+C25+C14)","v":-1.1133376186008341},null,null,{"$f":"(F35+F7+F18+F28+F29+F30+F32+F18+F8)/(F9+F10+F11+F12+F13+F15+F20+F21+F22+F23+F24+F31+F25+F14)","v":-1.161175557323872},{"$f":"(G35+G7+G18+G28+G29+G30+G32+G18+G8)/(G9+G10+G11+G12+G13+G15+G20+G21+G22+G23+G24+G31+G25+G14)","v":-1.161175557323872}]
[]
["Average Milk Price Needed to Break Even on Cash Flow",null,null,null,{"$f":"'Input Form'!$F$50-$C$36","v":266000}]
[{"$f":"IF($C$36<1, ($E$43/'Input Form'!F49),($E$44/'Input Form'!F49))","v":12.909090909090908},null,null,null,{"$f":"'Input Form'!$F$50+$C$36","v":284000}]

{"sheet":"Curent Monthly Cash Flow ","index":5,"n_rows":49,"n_cols":37,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,30,34,34],[34,24,34,28],[23,24,23,28],[23,30,23,34],[27,30,27,34],[27,24,27,28],[30,24,30,28],[30,30,30,34],[18,24,18,28],[18,30,18,34],[14,30,14,34],[14,24,14,28],[7,24,7,28],[11,24,11,28],[11,30,11,34],[7,30,7,34]]}
[null,null,0,"Comparisons To Annual Projection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!W1","v":0.1},{"$f":"'Balance Sheet'!X1","v":0.17499999999999999},{"$f":"'Balance Sheet'!Y1","v":0.25},{"$f":"'Balance Sheet'!Z1","v":0.32500000000000001},{"$f":"'Balance Sheet'!AA1","v":0.4}]
["Input from your own records/projections",null,null,"Monthly  Cash Flow ACTUAL (Statement)"]
["Calculations performed by the tool"]
[{"$f":"FarmID","v":"Farm1"},null,null,"Enter your monthly ACTUAL values in the BROWN cells below.",null,null,null,null,null,null,null,null,null,null,null,"Actual Yearly","Rolling",null,"Predicted",null,"Monthly Range"]
["Cash Flow Statement- Monthly",{"$f":"'Annual Cash Flow Projection'!C5","v":"Projection"},null,null,null,null,null,null,null,null,null,null,null,null,null," Totals","Actual Totals",null,"Monthly Averages",null,"$"]
["Cash Provided by Operating Activities",{"$f":"'Input Form'!F8","v":2011},null,"January","February","March","April","May","June","July","August","September","October","November","December","$","% of Predicted",null,"$",null,"MIN","MAX",null,"Sensitivity Analysis for Predicted:",{"$f":"'Input Form'!F8","v":2011},null,"Projected"]
["Cash Received from Operations ",{"$f":"'Annual Cash Flow Projection'!C7","v":698561.22164835152},null,65000,68000,66700,65000,65600,64500,62000,60000,64000,63000,64000,64000,{"$f":"SUM(D7:O7)","v":771800},{"$f":"P7/B7","v":1.1048423188719687},null,{"$f":"+B7/12","v":58213.435137362627},null,{"$f":"MIN(D7:O7)","v":60000},{"$f":"MAX(D7:O7)","v":68000}]
["+ Total Non-Farm Income ",{"$f":"'Annual Cash Flow Projection'!C8","v":16313},null,40000,0,0,0,0,5666,5667,5667,0,0,0,30000,{"$f":"SUM(D8:O8)","v":87000},{"$f":"P8/B8","v":5.3331698645252255},null,1359.4166666666667,null,{"$f":"MIN(D8:O8)","v":0},{"$f":"MAX(D8:O8)","v":40000},null,"Cash Flow","Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["- Cash Paid for Purchased Resale Livestock ",{"$f":"'Annual Cash Flow Projection'!C9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,0,null,0,0,null,null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4},null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4}]
["- Cash Paid for Purchased Feed ",{"$f":"'Annual Cash Flow Projection'!C10","v":-187231.82857142863},null,18000,18500,19000,17500,16000,14000,14000,15000,16000,17500,18000,19000,202500,-1.0815468798497931,null,-15602.652380952386,null,14000,19000,null,"Cash at end of year",{"$f":"((($B$13+$B$12+$B$10)*(1+Y9))-($B$13+$B$12+$B$10))+$B$36","v":-50579.990375824273},{"$f":"((($B$13+$B$12+$B$10)*(1+Z9))-($B$13+$B$12+$B$10))+$B$36","v":-95264.983157692361},{"$f":"((($B$13+$B$12+$B$10)*(1+AA9))-($B$13+$B$12+$B$10))+$B$36","v":-139949.97593956045},{"$f":"((($B$13+$B$12+$B$10)*(1+AB9))-($B$13+$B$12+$B$10))+$B$36","v":-184634.96872142854},{"$f":"((($B$13+$B$12+$B$10)*(1+AC9))-($B$13+$B$12+$B$10))+$B$36","v":-229319.96150329674},null,{"$f":"-((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AE9)))+$B$36","v":68579.990375824156},{"$f":"-((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AF9)))+$B$36","v":113264.98315769236},{"$f":"-((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AG9)))+$B$36","v":157949.97593956045},{"$f":"-((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AH9)))+$B$36","v":202634.9687214286},{"$f":"-((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AI9)))+$B$36","v":247319.9615032968}]
["- Cash Interest Paid ",{"$f":"'Annual Cash Flow Projection'!C11","v":-40842.945230769234},null,3958,4000,4000,3800,3800,4500,4500,4500,4500,4500,5000,5000,52058,-1.274589765891365,null,-3403.5787692307695,null,3800,5000]
["- Wages and Benefits Paid ",{"$f":"'Annual Cash Flow Projection'!C12","v":-93034.624175824181},null,7000,7000,6500,6500,8000,8000,8000,8000,8000,8500,8000,7000,90500,-0.97275611958152219,null,-7752.8853479853487,null,6500,8500,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["- Cash Paid for Other Operating Expenses ",{"$f":"'Annual Cash Flow Projection'!C13","v":-315533.45101098908},null,23000,24000,25000,26000,27000,30000,30000,28000,27000,27000,32000,27500,326500,-1.0347555828197403,null,-26294.454250915758,null,23000,32000,null,"Cash at end of year",{"$f":"($B$7*(1+Y9))-$B$7+$B$36","v":78856.122164835222},{"$f":"($B$7*(1+Z9))-$B$7+$B$36","v":131248.21378846152},{"$f":"($B$7*(1+AA9))-$B$7+$B$36","v":183640.30541208782},{"$f":"($B$7*(1+AB9))-$B$7+$B$36","v":236032.39703571424},{"$f":"($B$7*(1+AC9))-$B$7+$B$36","v":288424.48865934054},null,{"$f":"(($B$7*(1-AE9)))-$B$7+$B$36","v":-60856.122164835106},{"$f":"(($B$7*(1-AF9)))-$B$7+$B$36","v":-113248.21378846152},{"$f":"(($B$7*(1-AG9)))-$B$7+$B$36","v":-165640.30541208788},{"$f":"(($B$7*(1-AH9)))-$B$7+$B$36","v":-218032.39703571424},{"$f":"(($B$7*(1-AI9)))-$B$7+$B$36","v":-270424.4886593406}]
["- Cash Family Living Expenditures ",{"$f":"'Annual Cash Flow Projection'!C14","v":0},null,4700,0,0,8000,4700,0,0,10000,0,0,10000,30000,67400,{"$error":"#DIV/0!"},null,0,null,0,30000]
["- Income & Social Security Taxes Paid ",{"$f":"'Annual Cash Flow Projection'!C15","v":-1279.4857142857143},null,0,0,1250,0,0,1400,0,0,1500,0,0,1250,5400,-4.2204457147961234,null,-106.62380952380953,null,0,1500,null,"Working Capital","Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["Net Cash Provided by Operating Activities ",{"$f":"'Annual Cash Flow Projection'!C16","v":76951.886945054677},null,{"$f":"SUM(D7:D8)-SUM(D9:D15)","v":48342},14500,10950,3200,6100,12266,11167,167,7000,5500,-9000,4250,114442,1.4871890026779211,null,6412.6572454212228,null,-9000,48342,null,null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4},null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4}]
["Cash Provided by Investing Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ending Liquidity",{"$f":"((($B$13+$B$12+$B$10)*(1+Y16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":98120.009624175727},{"$f":"((($B$13+$B$12+$B$10)*(1+Z16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":53435.016842307639},{"$f":"((($B$13+$B$12+$B$10)*(1+AA16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":8750.0240604395512},{"$f":"((($B$13+$B$12+$B$10)*(1+AB16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":-35934.968721428537},{"$f":"((($B$13+$B$12+$B$10)*(1+AC16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":-80619.961503296741},null,{"$f":"-(((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AE16)))-'Balance Sheet'!$B$48)","v":217279.99037582416},{"$f":"-(((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AF16)))-'Balance Sheet'!$B$48)","v":261964.98315769236},{"$f":"-(((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AG16)))-'Balance Sheet'!$B$48)","v":306649.97593956045},{"$f":"-(((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AH16)))-'Balance Sheet'!$B$48)","v":351334.9687214286},{"$f":"-(((($B$13+$B$12+$B$10))-(($B$13+$B$12+$B$10)*(1-AI16)))-'Balance Sheet'!$B$48)","v":396019.9615032968}]
["Cash Received from Sale of Assets ",{"$f":"'Annual Cash Flow Projection'!C18","v":8092},null,0,0,0,0,0,0,0,0,0,0,0,500,500,{"$f":"P18/B18","v":6.1789421651013345E-2},null,{"$f":"+B18/12","v":674.33333333333337},null,0,500,null,null,{"$f":"((($B$13+$B$12+$B$10)*(1+Y16)-($B$13+$B$12+$B$10))+'Balance Sheet'!$B$48)","v":98120.009624175727}]
["+ Cash Received from Sale of Personal Assets ",{"$f":"'Annual Cash Flow Projection'!C19","v":1252},null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P19/B19","v":0},null,104.33333333333333,null,0,0,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["- Amount Paid for Breeding Livestock ",{"$f":"'Annual Cash Flow Projection'!C20","v":-16732},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-1394.3333333333333,null,0,0,null,"Ending Liquidity",{"$f":"((($B$7*(1+Y16)))-$B$7+'Balance Sheet'!$B$48)","v":227556.12216483522},{"$f":"((($B$7*(1+Z16)))-$B$7+'Balance Sheet'!$B$48)","v":279948.21378846152},{"$f":"((($B$7*(1+AA16)))-$B$7+'Balance Sheet'!$B$48)","v":332340.30541208782},{"$f":"((($B$7*(1+AB16)))-$B$7+'Balance Sheet'!$B$48)","v":384732.39703571424},{"$f":"((($B$7*(1+AC16)))-$B$7+'Balance Sheet'!$B$48)","v":437124.48865934054},null,{"$f":"((($B$7*(1-AE16))-$B$7)+'Balance Sheet'!$B$48)","v":87843.877835164894},{"$f":"((($B$7*(1-AF16))-$B$7)+'Balance Sheet'!$B$48)","v":35451.786211538478},{"$f":"((($B$7*(1-AG16))-$B$7)+'Balance Sheet'!$B$48)","v":-16940.305412087881},{"$f":"((($B$7*(1-AH16))-$B$7)+'Balance Sheet'!$B$48)","v":-69332.397035714239},{"$f":"((($B$7*(1-AI16))-$B$7)+'Balance Sheet'!$B$48)","v":-121724.4886593406}]
["- Boot Price Paid for Machinery & Equipment ",{"$f":"'Annual Cash Flow Projection'!C21","v":-34070},null,0,0,0,0,0,0,0,0,0,0,0,12000,12000,-0.35221602582917522,null,-2839.1666666666665,null,0,12000]
["- Amount Paid for Buildings ",{"$f":"'Annual Cash Flow Projection'!C22","v":-59349},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-4945.75,null,0,0,null,null,null,null,"Actual"]
["- Amount Paid for Land ",{"$f":"'Annual Cash Flow Projection'!C23","v":-23028},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-1919,null,0,0]
["- Amount Paid for Coop Stock, Etc. ",{"$f":"'Annual Cash Flow Projection'!C24","v":-8399},null,600,600,600,600,600,700,600,600,600,600,600,600,7300,-0.86915108941540664,null,-699.91666666666663,null,600,700,null,null,"Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["- Amount Paid for Personal  Assets ",{"$f":"'Annual Cash Flow Projection'!C25","v":-5139},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-428.25,null,0,0,null,null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4},null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4}]
["Net Cash Provided by Investing Activities ",{"$f":"'Annual Cash Flow Projection'!C26","v":-137373},null,{"$f":"D19+D18-SUM(D20:D25)","v":-600},{"$f":"E19+E18-SUM(E20:E25)","v":-600},-600,-600,-600,-700,-600,-600,-600,-600,-600,-12100,{"$f":"P19-P18-SUM(P20:P25)","v":-19800},0.14413312659692953,null,-11447.75,null,-12100,-600,null,"Cash at end of year",{"$f":"-(((($P$13+$P$12+$P$10)*(1+Y25))-($P$13+$P$12+$P$10)))+$O$36","v":-57950},{"$f":"-(((($P$13+$P$12+$P$10)*(1+Z25))-($P$13+$P$12+$P$10)))+$O$36","v":-104412.5},{"$f":"-(((($P$13+$P$12+$P$10)*(1+AA25))-($P$13+$P$12+$P$10)))+$O$36","v":-150875},{"$f":"-(((($P$13+$P$12+$P$10)*(1+AB25))-($P$13+$P$12+$P$10)))+$O$36","v":-197337.5},{"$f":"-(((($P$13+$P$12+$P$10)*(1+AC25))-($P$13+$P$12+$P$10)))+$O$36","v":-243800},null,{"$f":"((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AE25)))+$O$36","v":65950},{"$f":"((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AF25)))+$O$36","v":112412.5},{"$f":"((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AG25)))+$O$36","v":158875},{"$f":"((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AH25)))+$O$36","v":205337.5},{"$f":"((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AI25)))+$O$36","v":251800},null,{"$f":"IF($O$36<0,((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AE25))),(($P$13+$P$12+$P$10)*(1-AE25))-($P$13+$P$12+$P$10))","v":-61950}]
["Cash Provided by Financing Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($P$13+$P$12+$P$10)","v":619500}]
["Net Proceeds from Operating & CCC Loans ",{"$f":"'Annual Cash Flow Projection'!C28","v":14553},null,0,0,0,0,0,0,0,0,0,0,8700,0,8700,{"$f":"P28/B28","v":0.59781488352916923},null,{"$f":"+B28/12","v":1212.75},null,0,8700,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["+ Net Capital Contribution, Gifts, Etc. ",{"$f":"'Annual Cash Flow Projection'!C29","v":-31.599100000000021},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-2.6332583333333353,null,0,0,null,"Cash at end of year",{"$f":"($P$7*(1+Y25))-$P$7+$O$36","v":81180.000000000116},{"$f":"($P$7*(1+Z25))-$P$7+$P$36","v":135065},{"$f":"($P$7*(1+AA25))-$P$7+$P$36","v":192950},{"$f":"($P$7*(1+AB25))-$P$7+$P$36","v":250835},{"$f":"($P$7*(1+AC25))-$P$7+$P$36","v":308720},null,{"$f":"(($P$7*(1-AE25)))-$P$7+$O$36","v":-73180},{"$f":"(($P$7*(1-AF25)))-$P$7+$P$36","v":-135065},{"$f":"(($P$7*(1-AG25)))-$P$7+$P$36","v":-192950},{"$f":"(($P$7*(1-AH25)))-$P$7+$P$36","v":-250834.99999999994},{"$f":"(($P$7*(1-AI25)))-$P$7+$P$36","v":-308720}]
["+ Proceeds from Added Term Debt ",{"$f":"'Annual Cash Flow Projection'!C30","v":168962},null,0,0,0,0,0,0,0,0,0,0,0,1250,1250,7.3981131852132436E-3,null,14080.166666666666,null,0,1250]
["- Repayment of Term Debt ",{"$f":"'Annual Cash Flow Projection'!C31","v":-62481},null,14000,0,0,13500,0,0,12000,0,0,15000,0,1000,55500,-0.88827003409036343,null,-5206.75,null,0,15000,null,null,"Increase in operating expenses",null,null,null,null,null,"Decrease in operating expenses"]
["+ Net Proceeds from Personal Loans ",{"$f":"'Annual Cash Flow Projection'!C32","v":806},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,67.166666666666671,null,0,0,null,null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4},null,{"$f":"Y$1","v":0.1},{"$f":"Z$1","v":0.17499999999999999},{"$f":"AA$1","v":0.25},{"$f":"AB$1","v":0.32500000000000001},{"$f":"AC$1","v":0.4}]
["Net Cash Provided by Financing Activities ",{"$f":"'Annual Cash Flow Projection'!C33","v":121808.40090000001},null,{"$f":"SUM(D28:D30)+D32-D31","v":-14000},{"$f":"SUM(E28:E30)+E32-E31","v":0},0,-13500,0,0,-12000,0,0,-15000,8700,250,-45550,-0.3739479351460725,null,10150.700075000001,null,-15000,8700,null,"Ending Liquidity",{"$f":"-(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-Y32)))-'Balance Sheet'!$B$48)","v":95750},{"$f":"-(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-Z32)))-'Balance Sheet'!$B$48)","v":49287.5},{"$f":"-(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AA32)))-'Balance Sheet'!$B$48)","v":2825},{"$f":"-(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AB32)))-'Balance Sheet'!$B$48)","v":-43637.5},{"$f":"-(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AC32)))-'Balance Sheet'!$B$48)","v":-90100},null,{"$f":"(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AE32)))+'Balance Sheet'!$B$48)","v":219650},{"$f":"(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AF32)))+'Balance Sheet'!$B$48)","v":266112.5},{"$f":"(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AG32)))+'Balance Sheet'!$B$48)","v":312575},{"$f":"(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AH32)))+'Balance Sheet'!$B$48)","v":359037.5},{"$f":"(((($P$13+$P$12+$P$10))-(($P$13+$P$12+$P$10)*(1-AI32)))+'Balance Sheet'!$B$48)","v":405500}]
["Cash Provided by Cash Accounts"]
["Cash at Beginning of Year / Month",{"$f":"'Annual Cash Flow Projection'!C35","v":27783.313558558566},null,{"$f":"'Annual Cash Flow Projection'!G36","v":-66884},{"$f":"D36","v":-48},14000,25000,8900,14200,26000,24500,24000,30436,20330,19431,null,null,null,{"$f":"+B35/12","v":2315.2761298798805},null,-66884,30436,null,null,"Increase in operating revenue",null,null,null,null,null,"Decrease in operating revenue"]
["- Cash at End of Year / Month",{"$f":"'Annual Cash Flow Projection'!C36","v":9000},null,-48,14000,25000,8900,14200,26000,24500,24000,30436,20330,19431,4000,null,null,null,{"$f":"+B36/12","v":750},null,-48,30436,null,"Ending Liquidity",{"$f":"(($P$7*(1+Y32))-$P$7+'Balance Sheet'!$B$48)","v":234880.00000000012},{"$f":"(($P$7*(1+Z32))-$P$7+'Balance Sheet'!$B$48)","v":292765},{"$f":"(($P$7*(1+AA32))-$P$7+'Balance Sheet'!$B$48)","v":350650},{"$f":"(($P$7*(1+AB32))-$P$7+'Balance Sheet'!$B$48)","v":408535},{"$f":"(($P$7*(1+AC32))-$P$7+'Balance Sheet'!$B$48)","v":466420},null,{"$f":"((($P$7*(1-AE32)))-$P$7+'Balance Sheet'!$B$48)","v":80520},{"$f":"((($P$7*(1-AF32)))-$P$7+'Balance Sheet'!$B$48)","v":22635},{"$f":"((($P$7*(1-AG32)))-$P$7+'Balance Sheet'!$B$48)","v":-35250},{"$f":"((($P$7*(1-AH32)))-$P$7+'Balance Sheet'!$B$48)","v":-93134.999999999942},{"$f":"((($P$7*(1-AI32)))-$P$7+'Balance Sheet'!$B$48)","v":-151020}]
["Net Cash Provided by Cash Accounts ",{"$f":"'Annual Cash Flow Projection'!C37","v":18783.313558558566},null,{"$f":"D35-D36","v":-66836},{"$f":"E35-E36","v":-14048},-11000,16100,-5300,-11800,1500,500,-6436,10106,899,15431,null,null,null,{"$f":"+B37/12","v":1565.2761298798805},null,-66836,16100]
["Cash Flow Imbalance",{"$f":"'Annual Cash Flow Projection'!C38","v":80170.601403613255},null,{"$f":"D16+D26+D33+D37","v":-33094},{"$f":"E16+E26+E33+E37","v":-148},{"$f":"F16+F26+F33+F37","v":-650},5200,200,-234,67,67,-36,6,-1,7831,null,null,null,{"$f":"+B38/12","v":6680.8834503011049},null,-33094,7831]
["Cash Flow Imbalance % Cash Income",{"$f":"'Annual Cash Flow Projection'!C39","v":0.11476531894289761},null,{"$f":"D38/D7","v":-0.50913846153846154},-2.176470588235294E-3,-9.7451274362818589E-3,0.08,3.0487804878048782E-3,-3.6279069767441862E-3,1.0806451612903225E-3,1.1166666666666666E-3,-5.6249999999999996E-4,9.5238095238095241E-5,-1.5625E-5,0.12235937500000001,null,null,null,{"$f":"+B39/12","v":9.5637765785748004E-3},null,-0.50913846153846154,0.12235937500000001]
["Cash Flow Coverage Ratio, Farm Only",{"$f":"'Annual Cash Flow Projection'!C40","v":-1.0901903620350124},null,{"$f":"(D7+D18+D28+D29+D30+D35)/(D28-D9+D10+D11+D12+D13+D15+D20+D21+D22+D23+D24+D31)","v":-2.8306139006580727E-2},1.2560443622920519,1.4321206743566992,1.3254786450662739,1.3447653429602888,1.3430034129692834,1.2735166425470332,1.5062388591800357,1.5277777777777777,1.2781942544459644,1.2867219917012449,1.1612951601908656]
["Cash Flow Coverage Ratio, Farm + Personal",{"$f":"'Annual Cash Flow Projection'!C41","v":-1.1133376186008341},null,{"$f":"(D7+D18+D28+D29+D30+D35+D32+D19+D8)/(D28-D9+D10+D11+D12+D13+D15+D20+D21+D22+D23+D24+D31+D25+D14)","v":0.53490134441045212},1.2560443622920519,1.4321206743566992,1.1857707509881423,1.2396006655574043,1.4396928327645051,1.3555282199710565,1.3640998487140696,1.5277777777777777,1.2781942544459644,1.1303766707168894,1.1144750846637639]
[]
["CWT Milk Produced this Month",null,null,1833,2100,1921,2200,2570,2800,3200,2700,2540,2320,2400,2000,{"$f":"SUM(D43:O43)","v":28584},{"$f":"P43/'Input Form'!F49","v":1.2992727272727274},null,{"$f":"'Input Form'!F49/12","v":1833.3333333333333},"CWT",{"$f":"MIN(D43:O43)","v":1833},{"$f":"MAX(D43:O43)","v":3200}]
["Milk Price This Month",null,null,13.1,14.5,14.75,12.5,12.4,11.9,12.1,13,13.21,13.8,14.5,18,{"$f":"AVERAGE(D44:O44)","v":13.646666666666668},{"$f":"P44/B46","v":1.0571361502347421},null,null,null,{"$f":"MIN(D44:O44)","v":11.9},{"$f":"MAX(D44:O44)","v":18}]
["Milk Price/CWT need to Break Even "]
["On Projected Ending Cash Balance",{"$f":"IF(B36<1, 'Annual Cash Flow Projection'!$E$43/'Input Form'!F49,'Annual Cash Flow Projection'!E44/'Input Form'!F49)","v":12.909090909090908},null,{"$f":"-IF(D36<1,(D36-(D43*D44))/D43,-((D43*D44)-D36)/D43)","v":13.126186579378068},7.833333333333333,1.7359448204060386,8.454545454545455,6.8747081712062252,2.6142857142857143,4.4437499999999996,4.1111111111111107,1.2273228346456699,5.0370689655172418,6.4037499999999996,16,null,null,null,null,null,{"$f":"MIN(D46:P46)","v":1.2273228346456699},{"$f":"MAX(D46:P46)","v":16}]
["CWT Needed Breakeven at Received Price",null,null,{"$f":"-IF(D36<1,(D36-(D43*D44))/D44,-((D43*D44)-D36)/D44)","v":1836.6641221374045},1134.4827586206898,226.08474576271186,1488,1424.8387096774193,615.1260504201681,1175.206611570248,853.84615384615381,235.98788796366398,846.8115942028985,1059.9310344827586,1777.7777777777778,null,null,null,null,null,{"$f":"MIN(D47:Q47)","v":226.08474576271186},{"$f":"MAX(D47:Q47)","v":1836.6641221374045}]
["Actual Diff Milk Price Received and Needed",{"$f":"$O$46-$O$44","v":-2}]
["Year End     "]

{"sheet":"DuPont","index":6,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["DuPont Financial Analysis Easy Calculator",null,null,null,null,null,null,null,null,null,null,"DuPont Financial Analysis Output:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DuPont Analysis Table-",null,null,{"$f":"F9","v":2011}]
[{"$f":"FarmID","v":"Farm1"},null,null,null,null,null,null,"AgFA Data",null,null,null,"Calculated output:",null,"(Green Cells)"]
[{"$f":"'Input Form'!F8","v":2011},null,null,null,null,null,null,"or Other Comparables",null,null,null,null,null,null,null,null,null,"My Farm","AgFA Comparables"]
[null,null,null,null,null,null,null,"(Yellow cells)",null,null,null,null,null,"1. Operating profit margin ratio (OPMR)",null,null,null,{"$f":"F12","v":8.9349159165877726E-2},-0.14299999999999999]
["INPUT : My Financial analysis values:",null,null,null,null,"(Blue Cells)",null,"INPUT:",null,null,null,null,null,"2. Asset turnover ratio (ATO)",null,null,null,{"$f":"F11","v":0.31870650926207544},0.29899999999999999]
[null,null,null,null,null,"My Farm",null,"Comparable",null,null,"Basic DuPont Analysis:",null,null,"3. ROROA (1*2) ",null,null,null,{"$f":"F10","v":4.0297649716407605E-2},-4.2700000000000002E-2]
["1. Year of analysis=",null,null,null,null,{"$f":"A5","v":2011},null,{"$f":"F9","v":2011},null,null,"Extended DuPont output:",null,null,"4. Interest expense to avg. farm assets",null,null,null,{"$f":"F23","v":2.4986437311406876E-2},{"$f":"H23","v":1.6213228520542897E-2}]
["2. Rate of Return on Assets (ROROA)= ",null,null,null,null,{"$f":"'Farm Earnings'!B86","v":4.0297649716407605E-2},null,null,null,null,null,null,null,"5. Equity multiplier",null,null,null,{"$f":"F24","v":1.4519246444767044},{"$f":"H24","v":1.4557086090922886}]
["3. Asset Turn Over ratio (ATO)=",null,null,null,null,{"$f":"'Farm Earnings'!B90","v":0.31870650926207544},null,null,null,null,null,null,null,"6. ROROE (3-4) * 5",null,null,null,{"$f":"'Balance Sheet'!B46","v":4.968383009310267E-2},-8.4500000000000006E-2]
["4. Operating Profit Margin (OPM)=",null,null,null,null,{"$f":"'Farm Earnings'!B88","v":8.9349159165877726E-2}]
["5. Total Interest Expense for the Year=",null,null,null,null,{"$f":"'Farm Earnings'!E48+'Farm Earnings'!E47","v":39399.358442437922},null,25080]
["6. Beginning Total Asset value=",null,null,null,null,{"$f":"'Balance Sheet'!J23","v":1844460.5594964011},null,1587739]
["7. Ending Total Asset value=",null,null,null,null,{"$f":"'Balance Sheet'!B23","v":1309199},null,1506031]
["8. Total Equity value, year end=",null,null,null,null,{"$f":"'Balance Sheet'!B43","v":901699},null,1034569]
[]
["Intermediate calculated OUTPUT:",null,null," (Tan cells)"]
["1. Average Farm Asset Value for the year=",null,null,null,null,{"$f":"+(F15+F14)/2","v":1576829.7797482004},null,{"$f":"(H15+H14)/2","v":1546885}]
["2.  Leverage Multiplier=",null,null,null,null,{"$f":"(F15)/(F16)","v":1.4519246444767044},null,{"$f":"(H15)/(H16)","v":1.4557086090922886}]
[]
["DuPont Input Calculations:",null,"(Maroon cells)"]
["#1. Total interest expense:average farm assets=",null,null,null,null,{"$f":"F13/F19","v":2.4986437311406876E-2},null,{"$f":"H13/H19","v":1.6213228520542897E-2}]
["#2. Equity Multiplier=",null,null,null,null,{"$f":"F15/F16","v":1.4519246444767044},null,{"$f":"H15/H16","v":1.4557086090922886}]

{"sheet":"Annual CF Projection Summary","index":7,"n_rows":109,"n_cols":18,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Annual Cash Flow Projection Narrative Summary"]
[null,{"$f":"FarmID","v":"Farm1"}]
[null,"You have utilized your farm business financial information for ",null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!F6","v":2009},"and",{"$f":"'Annual Cash Flow Projection'!G6","v":2010},"to project your",null,{"$f":"'Annual Cash Flow Projection'!C6","v":2011},"Cash Flow Statement.  Based on your prediction"]
["of input costs and",null,"prices you expect to receive for the products you sell  during",null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C6","v":2011},"the following year end cash Flow is predicted:"]
[]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A34","v":"Cash Provided by Cash Accounts"}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A35","v":"Cash at Beginning of Year "},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C35","v":27783.313558558566}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A36","v":"- Cash at End of Year "},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C36","v":9000}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A37","v":"Net Cash Provided by Cash Accounts "},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C37","v":18783.313558558566}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A38","v":"Cash Flow Imbalance"},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C38","v":80170.601403613255}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A39","v":"Cash Flow Imbalance % Cash Income"},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C39","v":0.11476531894289761}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A40","v":"Cash Flow Coverage Ratio, Farm Only"},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C40","v":-1.0901903620350124}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A41","v":"Cash Flow Coverage Ratio, Farm + Personal"},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!C41","v":-1.1133376186008341}]
[null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A43","v":"Average Milk Price Needed to Break Even on Cash Flow"},null,null,null,null,{"$f":"'Annual Cash Flow Projection'!A44","v":12.909090909090908},"at a marketing level of ",null,{"$f":"'Input Form'!F49","v":22000},"Cwt./year"]
[null,null,null,null,null,null,null,"Alternatively, a reduction/increase in Total Cash Expense of",null,null,null,null,{"$f":"('Annual Cash Flow Projection'!T10+'Annual Cash Flow Projection'!Z10)/'Annual Cash Flow Projection'!Z11","v":-1.5105742621354862E-2},"is needed to Break Even on Cash Flow."]
[]
[]
["Given your expectation that input prices may vary from your prediction by",null,null,null,null,null,null,{"$f":"'Input Form'!I7","v":10},"to",{"$f":"'Input Form'!I8","v":40},"% the Sensitivity Analysis is calculated based on cost variances of ",null,null,null,null,{"$f":"'Annual Cash Flow Projection'!N9","v":0.1},{"$f":"'Annual Cash Flow Projection'!P9","v":0.25},"and"]
[{"$f":"'Annual Cash Flow Projection'!R9","v":0.4},"from your base prediction. Your business's Cash Flow situation may change based on this range of potential variance by the following amounts;"]
[]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M8","v":"Cash Flow "}]
[null,null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!N8","v":"Increase in operating expenses"},null,null,null,{"$f":"'Annual Cash Flow Projection'!T8","v":"Decrease in operating expenses"}]
[null,null,null,null,null,null,null,null,{"$f":"P19","v":0.1},{"$f":"Q19","v":0.25},{"$f":"A20","v":0.4},null,{"$f":"I24","v":0.1},{"$f":"J24","v":0.25},{"$f":"K24","v":0.4}]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M10","v":"Cash at end of year"},null,{"$f":"'Annual Cash Flow Projection'!N10","v":-50579.990375824273},{"$f":"'Annual Cash Flow Projection'!P10","v":-139949.97593956045},{"$f":"'Annual Cash Flow Projection'!R10","v":-229319.96150329674},null,{"$f":"'Annual Cash Flow Projection'!T10","v":68579.990375824156},{"$f":"'Annual Cash Flow Projection'!V10","v":157949.97593956045},{"$f":"'Annual Cash Flow Projection'!X10","v":247319.9615032968}]
[]
[null,null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!N12","v":"Increase in operating revenue"},null,null,null,{"$f":"'Annual Cash Flow Projection'!T12","v":"Decrease in operating revenue"}]
[null,null,null,null,null,null,null,null,{"$f":"I24","v":0.1},{"$f":"J24","v":0.25},{"$f":"K24","v":0.4},null,{"$f":"I28","v":0.1},{"$f":"J28","v":0.25},{"$f":"K28","v":0.4}]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M13","v":"Cash at end of year"},null,{"$f":"'Annual Cash Flow Projection'!N13","v":78856.122164835222},{"$f":"'Annual Cash Flow Projection'!P13","v":183640.30541208782},{"$f":"'Annual Cash Flow Projection'!R13","v":288424.48865934054},null,{"$f":"'Annual Cash Flow Projection'!T13","v":-60856.122164835106},{"$f":"'Annual Cash Flow Projection'!V13","v":-165640.30541208788},{"$f":"'Annual Cash Flow Projection'!X13","v":-270424.4886593406}]
[]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M20","v":"Working Capital "},null,{"$f":"'Annual Cash Flow Projection'!N20","v":"Increase in operating expenses"},null,null,null,{"$f":"'Annual Cash Flow Projection'!T20","v":"Decrease in operating expenses"}]
[null,null,null,null,null,null,null,null,{"$f":"I28","v":0.1},{"$f":"J28","v":0.25},{"$f":"K28","v":0.4},null,{"$f":"M28","v":0.1},{"$f":"N28","v":0.25},{"$f":"O28","v":0.4}]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M22","v":"Ending Liquidity"},null,{"$f":"'Annual Cash Flow Projection'!N22","v":98120.009624175727},{"$f":"'Annual Cash Flow Projection'!P22","v":8750.0240604395512},{"$f":"'Annual Cash Flow Projection'!R22","v":-80619.961503296741},null,{"$f":"'Annual Cash Flow Projection'!T22","v":217279.99037582416},{"$f":"'Annual Cash Flow Projection'!V22","v":306649.97593956045},{"$f":"'Annual Cash Flow Projection'!X22","v":396019.9615032968}]
[]
[null,null,null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!N24","v":"Increase in operating revenue"},null,null,null,{"$f":"'Annual Cash Flow Projection'!T24","v":"Decrease in operating revenue"}]
[null,null,null,null,null,null,null,null,{"$f":"I32","v":0.1},{"$f":"J32","v":0.25},{"$f":"K32","v":0.4},null,{"$f":"M32","v":0.1},{"$f":"N32","v":0.25},{"$f":"O32","v":0.4}]
[null,null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M25","v":"Ending Liquidity"},null,{"$f":"'Annual Cash Flow Projection'!N25","v":227556.12216483522},{"$f":"'Annual Cash Flow Projection'!P25","v":332340.30541208782},{"$f":"'Annual Cash Flow Projection'!R25","v":437124.48865934054},null,{"$f":"'Annual Cash Flow Projection'!T25","v":87843.877835164894},{"$f":"'Annual Cash Flow Projection'!V25","v":-16940.305412087881},{"$f":"'Annual Cash Flow Projection'!X25","v":-121724.4886593406}]
[]
[null,null,null,"The effect of rising or falling interest rates will change your Ending Cash Balance and Liquidity  as follows;"]
[]
[null,null,null,null,null,"\"Other\" Loan Interest",null,null,{"$f":"'Annual Cash Flow Projection'!N15","v":"Increase in Interest expenses"},null,null,null,{"$f":"'Annual Cash Flow Projection'!T15","v":"Decrease in Interest expenses"}]
[null,null,null,null,null,null,null,null,{"$f":"I36","v":0.1},{"$f":"J36","v":0.25},{"$f":"K36","v":0.4},null,{"$f":"M36","v":0.1},{"$f":"N36","v":0.25},{"$f":"O36","v":0.4}]
[null,null,null,null,null,{"$f":"'Annual Cash Flow Projection'!M17","v":"Cash at end of year"},null,null,{"$f":"'Annual Cash Flow Projection'!N17","v":6545.4470153846123},{"$f":"'Annual Cash Flow Projection'!P17","v":2863.6175384615381},{"$f":"'Annual Cash Flow Projection'!R17","v":-818.21193846153619},null,{"$f":"'Annual Cash Flow Projection'!T17","v":11454.552984615384},{"$f":"'Annual Cash Flow Projection'!V17","v":15136.382461538462},{"$f":"'Annual Cash Flow Projection'!X17","v":18818.21193846154}]
[null,null,null,null,null,"Ending Liquidity",null,null,{"$f":"'Annual Cash Flow Projection'!N18","v":155245.44701538462},{"$f":"'Annual Cash Flow Projection'!P18","v":151563.61753846155},{"$f":"'Annual Cash Flow Projection'!R18","v":147881.78806153848},null,{"$f":"'Annual Cash Flow Projection'!T18","v":160154.55298461538},{"$f":"'Annual Cash Flow Projection'!V18","v":163836.38246153845},{"$f":"'Annual Cash Flow Projection'!X18","v":167518.21193846155}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Net Cash Income   "]
[]
[]
[]
[]
[null,"Your NCI ","in",{"$f":"'Farm Earnings'!D8","v":2009},"was ",{"$f":"'Farm Earnings'!D23-'Farm Earnings'!D69","v":120405.38747178356},"compared to an average AgFA farm in your herd size of ",null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows of ","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"Alternatively, your projected",null,null,{"$f":"'Farm Earnings'!B8","v":2011},"NCI is",{"$f":"'Farm Earnings'!B23-'Farm Earnings'!B69","v":58396.035648351419},"."]
[]
[null,"If you are not comfortable with your business’s present NCI performance, options to affect this measure include; "]
[null,"1. improve profitability by lowering costs and\\or,"]
[null,"2. improving profitability through higher productivity and/or better marketing, "]
[null,"3 expand, or"]
[null,"4. decrease the number of partners."]
[]
[]
[]
[]
[]
[]
[null,"Your WC  with deferred taxes on the sale of assets not considered, in "]
[null,{"$f":"'Balance Sheet'!I6","v":2010},"was",{"$f":"'Balance Sheet'!J48","v":150576.26868532796},"compared to the average AgFA in you herd size category of",null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows of","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"The",{"$f":"B84","v":2010},"AgFA database WC range for your herd size was",null,null,null,null,"XXXX","."]
[]
[null,"Your",{"$f":"C87","v":2010},"Working Capital: Gross Income was ",null,null,null,{"$f":"'Farm Earnings'!D83","v":0.19867459284745179},"and your Working Capital: Operating Expense was",null,null,null,{"$f":"'Farm Earnings'!D84","v":0.21935599759954941},"."]
[]
[null,"Your projected WC for",null,null,{"$f":"'Balance Sheet'!B6","v":2011},"is",null,{"$f":"'Balance Sheet'!B48","v":157700},"."]
[null,"Your projected Working Capital: Gross Income for",null,null,null,null,null,{"$f":"E91","v":2011},"is",{"$f":"'Farm Earnings'!B83","v":0.22174693839507725},"."]
[null,"Your projected Working Capital: Operating Expense for",null,null,null,null,null,{"$f":"H92","v":2011},"is",{"$f":"'Farm Earnings'!B84","v":0.24699616656796614},"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," Your CR in",null,{"$f":"'Balance Sheet'!I6","v":2010},"was",{"$f":"'Balance Sheet'!J47","v":3.8234071431005723},"compared to the average AgFA farm in your herd size of",null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows of","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"The",{"$f":"D104","v":2010},"AgFA database CR range for your herd size was",null,null,null,"XXXX","."]
[]
[null,"Your projected CR for",null,null,{"$f":"'Balance Sheet'!B6","v":2011},"is",{"$f":"'Balance Sheet'!B47","v":6.1704918032786882},"."]

{"sheet":"Current CF Summary","index":8,"n_rows":102,"n_cols":18,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Current Year Cash Flow Narrative Summary"]
[null,{"$f":"FarmID","v":"Farm1"}]
[null,"Your current year Cash Flow summary for ",null,null,null,null,{"$f":"'Input Form'!F8","v":2011},"follows;"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A34","v":"Cash Provided by Cash Accounts"}]
[null,null,null,null,null,null,null,null,"Cash at beginning of year",null,null,null,{"$f":"'Curent Monthly Cash Flow '!O35","v":19431}]
[null,null,null,null,null,null,null,null,"-Cash at End of year",null,null,null,{"$f":"'Curent Monthly Cash Flow '!O36","v":4000}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A37","v":"Net Cash Provided by Cash Accounts "},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O37","v":15431}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A38","v":"Cash Flow Imbalance"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O38","v":7831}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A39","v":"Cash Flow Imbalance % Cash Income"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O39","v":0.12235937500000001}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A40","v":"Cash Flow Coverage Ratio, Farm Only"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O40","v":1.1612951601908656}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A41","v":"Cash Flow Coverage Ratio, Farm + Personal"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O41","v":1.1144750846637639}]
[]
[null,null,null,null,null,null,null,null,"CWT Milk produced this year",null,null,null,{"$f":"'Curent Monthly Cash Flow '!P43","v":28584}]
[null,null,null,null,null,null,null,null,"Avg. Annual Milk Price/CWT.",null,null,null,{"$f":"'Curent Monthly Cash Flow '!P44","v":13.646666666666668}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A45","v":"Milk Price/CWT need to Break Even "}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A46","v":"On Projected Ending Cash Balance"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O46","v":16},"for the month of December."]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A47","v":"CWT Needed Breakeven at Received Price"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!O47","v":1777.7777777777778},"for the month of December."]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!A48","v":"Actual Diff Milk Price Received and Needed"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!B48","v":-2},"for the month of December."]
[null,null,null,null,null,null,null,null,"Alternatively, a reduction/increase in Total Cash Expense of",null,null,null,{"$f":"('Curent Monthly Cash Flow '!AE26+'Curent Monthly Cash Flow '!AK26)/'Curent Monthly Cash Flow '!AK27","v":6.4568200161420498E-3},"is needed to Break Even on Cash Flow."]
[]
["A change in prices paid for production inputs and/or in prices received for products sold during",null,null,null,null,null,null,null,null,{"$f":"G4","v":2011},"would have affected year-end Cash Flow and Working Capital levels by the following amounts;"]
[]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X8","v":"Cash Flow"}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!Y6","v":2011}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!Y8","v":"Increase in operating expenses"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!AE8","v":"Decrease in operating expenses"}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!Y1","v":0.1},{"$f":"'Curent Monthly Cash Flow '!AA9","v":0.25},{"$f":"'Curent Monthly Cash Flow '!AC9","v":0.4},null,{"$f":"I29","v":0.1},{"$f":"J29","v":0.25},{"$f":"K29","v":0.4}]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X10","v":"Cash at end of year"},null,{"$f":"'Curent Monthly Cash Flow '!Y10","v":-50579.990375824273},{"$f":"'Curent Monthly Cash Flow '!$AA$26","v":-150875},{"$f":"'Curent Monthly Cash Flow '!$AC$26","v":-243800},null,{"$f":"'Curent Monthly Cash Flow '!AE10","v":68579.990375824156},{"$f":"'Curent Monthly Cash Flow '!$AG$26","v":158875},{"$f":"'Curent Monthly Cash Flow '!$AI$26","v":251800}]
[]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!Y12","v":"Increase in operating revenue"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!AE28","v":"Decrease in operating revenue"}]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X13","v":"Cash at end of year"},null,{"$f":"'Curent Monthly Cash Flow '!Y13","v":78856.122164835222},{"$f":"'Curent Monthly Cash Flow '!$AA$29","v":192950},{"$f":"'Curent Monthly Cash Flow '!$AC$29","v":308720},null,{"$f":"'Curent Monthly Cash Flow '!AE13","v":-60856.122164835106},{"$f":"'Curent Monthly Cash Flow '!$AG$29","v":-192950},{"$f":"'Curent Monthly Cash Flow '!$AI$29","v":-308720}]
[]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X15","v":"Working Capital"},null,{"$f":"'Curent Monthly Cash Flow '!Y15","v":"Increase in operating expenses"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!AE31","v":"Decrease in operating expenses"}]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X17","v":"Ending Liquidity"},null,{"$f":"'Curent Monthly Cash Flow '!Y33","v":95750},{"$f":"'Curent Monthly Cash Flow '!$AA$33","v":2825},{"$f":"'Curent Monthly Cash Flow '!$AC$33","v":-90100},null,{"$f":"'Curent Monthly Cash Flow '!AE33","v":219650},{"$f":"'Curent Monthly Cash Flow '!$AG$33","v":312575},{"$f":"'Curent Monthly Cash Flow '!$AI$33","v":405500}]
[]
[null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!X20","v":"Ending Liquidity"},null,{"$f":"'Curent Monthly Cash Flow '!Y19","v":"Increase in operating revenue"},null,null,null,{"$f":"'Curent Monthly Cash Flow '!AE35","v":"Decrease in operating revenue"}]
[null,null,null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!Y36","v":234880.00000000012},{"$f":"'Curent Monthly Cash Flow '!$AA$36","v":350650},{"$f":"'Curent Monthly Cash Flow '!$AC$36","v":466420},null,{"$f":"'Curent Monthly Cash Flow '!AE36","v":80520},{"$f":"'Curent Monthly Cash Flow '!$AG$36","v":-35250},{"$f":"'Curent Monthly Cash Flow '!$AI$36","v":-151020}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Net Cash Income   "]
[]
[]
[]
[]
[null,"Your NCI ","in",{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"was ",{"$f":"'Curent Monthly Cash Flow '!P16","v":114442},"compared to an average AgFA farm in your herd size of ",null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows of ","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"Alternatively, your projected",null,null,{"$f":"'Farm Earnings'!B8","v":2011},"NCI was",{"$f":"'Curent Monthly Cash Flow '!B16","v":76951.886945054677},"."]
[]
[null,"If you are not comfortable with your business’s present NCI performance, options to affect this measure include; "]
[null,"1. improve profitability by lowering costs and\\or,"]
[null,"2. improving profitability through higher productivity and/or better marketing, "]
[null,"3 expand, or"]
[null,"4. decrease the number of partners."]
[]
[null,"Your Net  Available Cash, year end in "]
[null,{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"was",{"$f":"'Curent Monthly Cash Flow '!O36","v":4000}]
[]
[null,"The average milk price earned by your farm in ",null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"was",{"$f":"'Curent Monthly Cash Flow '!P44","v":13.646666666666668},"compared to the average AgFA herd in you herd size range of",null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows of","XXXX","."]
[]
[null,"Your average Cash Flow Coverage Ratio, Farm Only of",null,null,null,null,{"$f":"M13","v":1.1612951601908656},"compared to the average AgFA farm at your herd size of",null,null,null,null,{"$f":"L62","v":100},"cows was","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"Your average Cash Flow Coverage Ratio, Farm plus Personnel of",null,null,null,null,null,{"$f":"M14","v":1.1144750846637639},"compared to the average AgFA farm at your herd size of",null,null,null,{"$f":"L62","v":100},"cows was","XXXX","."]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[]
[]
[]
[]
[]
[null,"Your Projected WC  with deferred taxes on the sale of assets not considered, in ",null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!B6","v":2011},"was,",{"$f":"'Balance Sheet'!B48","v":157700},"."]
[null,"Your Actual WC  with deferred taxes on the sale of assets not considered, in ",null,null,null,null,null,null,{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"was,",{"$f":"(('Curent Monthly Cash Flow '!O36+SUM('Balance Sheet'!B9:B13)))-'Balance Sheet'!B28","v":152700},"."]
[null,"Your WC compares to the average AgFA farm in you herd size category of",null,null,null,null,null,{"$f":"'Input Form'!D46","v":100},"cows in",{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"cows of","XXXX","."]
[]
[null,"You ","are/are not",null,"competitive with the average AgFA herd summarized in your herd size category."]
[]
[null,"The",{"$f":"'Curent Monthly Cash Flow '!B6","v":2011},"AgFA database WC range for your herd size was",null,null,null,"XXXX","."]
[]
[null,"Your",{"$f":"C95","v":2011},"Working Capital: Gross Income was ",null,null,null,{"$f":"K90/('Curent Monthly Cash Flow '!P7+'Curent Monthly Cash Flow '!P18+'Farm Earnings'!B28+'Balance Sheet'!B12)","v":0.19313659286043106},"and your Working Capital: Operating Expense was",null,null,null,{"$f":"K90/('Curent Monthly Cash Flow '!P10+'Curent Monthly Cash Flow '!P12+'Curent Monthly Cash Flow '!P13+'Curent Monthly Cash Flow '!P15+'Farm Earnings'!B75+'Balance Sheet'!B25)","v":0.2419091916239165},"."]
[]
[null,"If you are not comfortable with your business’s present WC performance, options to affect this measure include; "]
[null,"1. Increase cash reserves in good  years"]
[null,"2. Improve profitability"]
[null,"3. Restructure debt"]