{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blank Cash Flow","Sample Cash Flow 2015"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":51,"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":"Blank Cash Flow","index":0,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[48,0,48,4],[15,11,15,15],[0,11,0,15],[0,6,0,7],[0,4,0,5],[0,0,0,2],[27,0,27,3],[26,0,26,3],[35,10,35,17],[36,10,36,17],[37,10,37,17],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[0,17,1,17],[14,17,15,17],[19,0,19,1],[19,2,19,6],[42,1,42,3],[41,1,41,3],[34,0,34,3],[35,0,35,3],[36,6,36,7],[39,10,39,15],[37,0,37,3],[38,0,38,3],[21,0,21,3],[36,0,36,3],[17,8,21,8],[34,10,34,17],[37,6,37,7],[53,2,53,4],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[33,0,33,3],[28,0,28,3],[29,0,29,3],[31,0,31,3],[32,0,32,3],[49,0,49,4],[50,0,50,4],[51,0,51,4],[52,0,52,4],[46,0,46,4],[47,0,47,4],[38,6,38,7],[47,6,47,7],[39,19,39,24],[38,10,38,17],[41,10,41,12],[40,6,40,8],[40,10,40,15],[53,10,53,12],[42,10,42,12],[43,10,43,12],[44,10,44,12],[45,10,45,12],[46,10,46,12],[47,10,47,12],[48,10,48,12],[49,10,49,12],[50,10,50,12],[51,10,51,12],[52,10,52,12],[30,6,30,7],[31,6,31,7],[28,6,28,8],[29,6,29,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[27,6,27,8]]}
["Carrington Area Farm Management   ******* Cash Flow Projection *******",null,null,"Name",null,null,"Cash Flow Period",null,null,null,null,"                 Input per acre expenses:",null,null,null,null,null," BE Yield Over All Listed Costs Shown"]
["Crop","Acres","Yield","Feed","Seed","Bu/Cwt Sold","Price","Dollars","File Name",null,"Crop","Seed","Fertilizer","Chemical","Crop Insur","Custom/Drying","Listed Costs/Unit "]
[null,0,0,null,null,{"$f":"SUM(B3*C3-(E3+D3))","v":0},0,{"$f":"SUM(F3*G3)","v":0},{"$f":"C3*G3","v":0},null,{"$f":"A3","v":0},0,0,0,0,0,{"$f":"(L3+M3+N3+O3+P3)/C3","v":{"$error":"#DIV/0!"}},{"$f":"(L3+M3+N3+O3+P3)/G3","v":{"$error":"#DIV/0!"}}]
[null,0,0,null,null,0,0,0,{"$f":"C4*G4","v":0},null,0,0,0,0,0,0,{"$f":"(L4+M4+N4+O4+P4)/C4","v":{"$error":"#DIV/0!"}},{"$f":"(L4+M4+N4+O4+P4)/G4","v":{"$error":"#DIV/0!"}}]
[null,0,0,null,null,0,0,0,0,null,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Livestock","Head","%","Replacements","Sell","Weight","Price/lb.","Value","Gross $/Acre",null,null,null,null,null,null,null,null,"   Return Over Listed Costs/A."]
["Beef cows",0,0,0,{"$f":"(B16*C16)-D16","v":0},0,0,{"$f":"F16*E16*G16","v":0},{"$f":"SUM(B3:B14)","v":0},null,null,"          Crop totals for per acre expenses:",null,null,null,null,"Listed Costs/Ac."]
["Open Heifers",0,0,0,{"$f":"(B17*C17)-D17","v":0},0,0,{"$f":"F17*E17*G17","v":0},"Total Acres",null,{"$f":"A3","v":0},{"$f":"B3*L3","v":0},{"$f":"B3*M3","v":0},{"$f":"B3*N3","v":0},{"$f":"B3*O3","v":0},{"$f":"B3*P3","v":0},{"$f":"(L17+M17+N17+O17+P17)/B3","v":{"$error":"#DIV/0!"}},{"$f":"I3-Q17","v":{"$error":"#DIV/0!"}}]
["Cull cows",0,0,0,{"$f":"(B18*C18)-D18","v":0},0,0,{"$f":"F18*E18*G18","v":0},"Notes:",null,0,0,0,0,0,0,{"$f":"(L18+M18+N18+O18+P18)/B4","v":{"$error":"#DIV/0!"}},{"$f":"I4-Q18","v":{"$error":"#DIV/0!"}}]
["Other Livestock",0,0,0,{"$f":"(B19*C19)-D19","v":0},0,0,{"$f":"F19*E19*G19","v":0},null,null,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Farm Income",null," ",null,null,null,null,0,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["     OPERATING EXPENSES ",null,null,null,"Credit Needed","Planned Exp."," Gov't Pymt.",0,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Machinery & Building Repair",null,null,null,0,0,"Total",{"$f":"SUM(H3:H21)","v":0},null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Interest",null,null,null,0,0,"Notes:",null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Seed",null,null,null,0,{"$f":"L29","v":0},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Fertilizer",null,null,null,0,{"$f":"M29","v":0},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Chemical",null,null,null,0,{"$f":"N29","v":0},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Crop Insurance",null,null,null,0,{"$f":"O29","v":0},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Feed Expense",null,null,null,0,0,null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Livestock Exp. (Vet,Supplies,Marketing,etc.)",null,null,null,0,0,null,null,null,null,"Total Crop Exp.    $",{"$f":"SUM(L17:L28)","v":0},{"$f":"SUM(M17:M28)","v":0},{"$f":"SUM(N17:N28)","v":0},{"$f":"SUM(O17:O28)","v":0},{"$f":"SUM(P17:P28)","v":0},{"$f":"(L29+M29+N29+O29+P29)/I16","v":{"$error":"#DIV/0!"}}]
["Land Rent",null,null,null,0,0,"       Projected $ Left From Prior Year",null,null,null,null,"Seed","Fertilizer","Chemical","Crop Insur","Custom","  xxxxxxxxxx"]
["CustomHire-Other ",0,"  Lvstk.",0,0,{"$f":"B31+D31+P29","v":0},"Cash at Begin. of Period",null,0]
["Gas, Fuel and Oil",null,null,null,0,0,"Old Crop & Grain Sales",null,0,null,"Return over listed costs is available to pay for those expenses, capital purchases, family living and loan"]
["Real Estate Taxes",null,null,null,0,0,"Old Livestock Sales",null,0,null,"payments listed on the plan.  There are 5 areas of listed costs shown above."]
["Hired Labor",null,null,null,0,0,"Old Acct's Receivable",null,0,null,"Notes:"]
["Farm Insurance ",null,null,null,0,0,"Last Year's Acct's Pay.",null,0]
["Utilities",null,null,null,0,0,"Last Year's Oper. Loans",null,0]
["General Farm Supplies",null,null,null,0,0,"Last Year's Chat. Loans",null,0]
[null,null,null,null,0,0,"Last Year's RE Loans",null,0]
[null,null,null,null,0,0,"Projected Cash Balance",null,{"$f":"I31+I32+I33+I34-I35-I36-I37-I38","v":0}]
[null,null,"                   TOTAL>",null,{"$f":"SUM(E22:E39)","v":0},{"$f":"SUM(F22:F39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculating Amortized Loan Payments(Ending Balance = 0 or a negative balance)"]
["Family Living Expense",null,null,null,0,0,"Financial Summary",null,null,null,"Land Rental Units",null,null,null,null,null,null,null,null,"Loan Amount $","Inter.Rate","Years","Ending Bal.$","Payment $","Interest $"]
["Capital Purchases",null,null,null,0,0,"Farm Income",null,{"$f":"H22","v":0},null,"Landlord",null,null,"Acres","Rent/Acre","Total Paid",null,null,null,0,0,0,0,{"$f":"PMT(U42,V42,T42,W42,0)*-1","v":{"$error":"#NUM!"}},{"$f":"T42*U42","v":0}]
["Capital Purchases",null,null,null,0,0,"Farm Expenses",null,{"$f":"F40","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},{"$f":"T43*U43","v":0}]
["Payments to be made",null,null,null,null,null,"Net Farm Income",null,{"$f":"I42-I43","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Annual  Operating Ln","Int rate",0.05,"Est Months",0,{"$f":"(E40+E41)*(1+(C45*(E45/12)))","v":0},"Non Farm Income",null,0,null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Capital Purchases Ln","Int rate",0,"Years for loan",0,0,"Family Living Exp",null,{"$f":"F41","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,0,"Net Cash Income",null,{"$f":"I44+I45-I46","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,0,"(Plus) Proj. Cash Bal.",null,{"$f":"I39","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"(Plus) Interest Expense",null,{"$f":"F23","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"(Plus) Money Borrowed",null,{"$f":"SUM(E40:E43)","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"(Less)Capital Purchases",null,{"$f":"SUM(F42:F43)","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"Available for Payments",null,{"$f":"I47+I48+I49+I50-I51","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Income & Soc. Sec. Taxes to be paid",null,null,null,null,0,"Payments to be made",null,{"$f":"F54","v":0},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[null,null,"Total Payments to be made",null,null,{"$f":"SUM(F45:F53)","v":0},"Margin",null,{"$f":"I52-I53","v":0},null,"Total Acres Rented, Avg. Rent, Total Paid",null,null,{"$f":"N43+N44+N45+N46+N47+N48+N49+N50+N51+N52+N53","v":0},{"$f":"P54/N54","v":{"$error":"#DIV/0!"}},{"$f":"P43+P44+P45+P46+P47+P48+P49+P50+P51+P52+P53","v":0},null,null,null,"Total Interest $","  xxxxxxxxx","  xxxxxxxxx","  xxxxxxxxxxxx","  xxxxxxxxx",{"$f":"SUM(Y42:Y53)","v":0}]

{"sheet":"Sample Cash Flow 2015","index":1,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,11,0,15],[0,17,1,17],[14,17,15,17],[15,11,15,15],[23,0,23,3],[23,6,23,8],[0,0,0,2],[0,4,0,5],[0,6,0,7],[17,8,21,8],[19,0,19,1],[19,2,19,6],[21,0,21,3],[22,0,22,3],[24,0,24,3],[24,6,24,8],[25,0,25,3],[25,6,25,8],[26,0,26,3],[26,6,26,8],[33,0,33,3],[33,6,33,7],[27,0,27,3],[27,6,27,8],[28,0,28,3],[28,6,28,8],[29,0,29,3],[29,6,29,8],[30,6,30,7],[31,0,31,3],[31,6,31,7],[32,0,32,3],[32,6,32,7],[34,0,34,3],[34,6,34,7],[34,10,34,17],[35,0,35,3],[35,6,35,7],[35,10,35,17],[39,19,39,24],[40,6,40,8],[40,10,40,15],[36,0,36,3],[36,6,36,7],[36,10,36,17],[37,0,37,3],[37,6,37,7],[37,10,37,17],[44,10,44,12],[38,0,38,3],[38,6,38,7],[38,10,38,17],[39,10,39,15],[41,1,41,3],[41,10,41,12],[42,1,42,3],[42,10,42,12],[43,10,43,12],[45,10,45,12],[46,0,46,4],[46,10,46,12],[47,0,47,4],[47,6,47,7],[47,10,47,12],[48,0,48,4],[48,10,48,12],[49,0,49,4],[49,10,49,12],[50,0,50,4],[50,10,50,12],[51,0,51,4],[51,10,51,12],[52,0,52,4],[52,10,52,12],[53,2,53,4],[53,10,53,12]]}
["Carrington Area Farm Management   ******* Cash Flow Projection *******",null,null,"Name","Iam Trying",null,"Jan-Dec 2015",null,null,null,null,"                 Input per acre expenses:",null,null,null,null,null," BE Yield Over All Listed Costs Shown"]
["Crop","Acres","Yield","Feed","Seed","Bu/Cwt Sold","Price","Dollars","ITryingCF2015A",null,"Crop","Seed","Fertilizer","Chemical","Crop Insur","Custom/Drying","Listed Costs/Unit "]
["Wheat",700,55,null,1000,{"$f":"SUM(B3*C3-(E3+D3))","v":37500},5,{"$f":"SUM(F3*G3)","v":187500},{"$f":"C3*G3","v":275},null,{"$f":"A3","v":"Wheat"},25,135,41,32,6,{"$f":"(L3+M3+N3+O3+P3)/C3","v":4.3454545454545457},{"$f":"(L3+M3+N3+O3+P3)/G3","v":47.8}]
["Malting Barley",500,75,null,null,37500,5.45,204375,{"$f":"C4*G4","v":408.75},null,"Malting Barley",18,120,36,30,6,{"$f":"(L4+M4+N4+O4+P4)/C4","v":2.8},{"$f":"(L4+M4+N4+O4+P4)/G4","v":38.532110091743121}]
["Soybeans",600,35,null,null,21000,10,210000,350,null,"Soybeans",65,18,25,30,0,3.9428571428571431,13.8]
["Winter Wheat",0,0,null,null,0,0,0,0,null,"Winter Wheat",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Mixed Hay",300,1.5,450,null,0,0,0,0,null,"Mixed Hay",0,0,0,0,0,0,{"$error":"#DIV/0!"}]
["Pasture",600,1.2,720,null,0,0,0,0,null,"Pasture",0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" ",0,0,null,null,0,0,0,0,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Livestock","Head","%","Replacements","Sell","Weight","Price/lb.","Value","Gross $/Acre",null,null,null,null,null,null,null,null,"   Return Over Listed Costs/A."]
["Beef cows",100,0.9,10,{"$f":"(B16*C16)-D16","v":80},600,2.4,{"$f":"F16*E16*G16","v":115200},{"$f":"SUM(B3:B14)","v":2700},null,null,"          Crop totals for per acre expenses:",null,null,null,null,"Listed Costs/Ac."]
["Open Heifers",0,0,0,{"$f":"(B17*C17)-D17","v":0},0,0,{"$f":"F17*E17*G17","v":0},"Total Acres",null,{"$f":"A3","v":"Wheat"},{"$f":"B3*L3","v":17500},{"$f":"B3*M3","v":94500},{"$f":"B3*N3","v":28700},{"$f":"B3*O3","v":22400},{"$f":"B3*P3","v":4200},{"$f":"(L17+M17+N17+O17+P17)/B3","v":239},{"$f":"I3-Q17","v":36}]
["Cull cows",10,1,0,{"$f":"(B18*C18)-D18","v":10},1300,1.1000000000000001,{"$f":"F18*E18*G18","v":14300.000000000002},"Notes:",null,"Malting Barley",9000,60000,18000,15000,3000,{"$f":"(L18+M18+N18+O18+P18)/B4","v":210},{"$f":"I4-Q18","v":198.75}]
["Other Livestock",0,0,0,{"$f":"(B19*C19)-D19","v":0},0,0,{"$f":"F19*E19*G19","v":0},null,null,"Soybeans",39000,10800,15000,18000,0,138,212]
["Other Farm Income",null," ",null,null,null,null,0,null,null,"Winter Wheat",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["     OPERATING EXPENSES ",null,null,null,"Credit Needed","Planned Exp."," Gov't Pymt.",20000,null,null,"Mixed Hay",0,0,0,0,0,0,0]
["Machinery & Building Repair",null,null,null,20000,27000,"Total",{"$f":"SUM(H3:H21)","v":751375},null,null,"Pasture",0,0,0,0,0,0,0]
["Interest",null,null,null,0,39000,"Notes:",null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Seed",null,null,null,65500,{"$f":"L29","v":65500},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Fertilizer",null,null,null,165300,{"$f":"M29","v":165300},"Based on all soil tests",null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Chemical",null,null,null,61700,{"$f":"N29","v":61700},"RR Soybeans",null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Crop Insurance",null,null,null,0,{"$f":"O29","v":55400},null,null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Feed Expense",null,null,null,3500,3500,"Salt, Protein, Mineral",null,null,null," ",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Livestock Exp. (Vet,Supplies,Marketing,etc.)",null,null,null,4500,4500,"Hauling grain $3,000",null,null,null,"Total Crop Exp.    $",{"$f":"SUM(L17:L28)","v":65500},{"$f":"SUM(M17:M28)","v":165300},{"$f":"SUM(N17:N28)","v":61700},{"$f":"SUM(O17:O28)","v":55400},{"$f":"SUM(P17:P28)","v":7200},{"$f":"(L29+M29+N29+O29+P29)/I16","v":131.5185185185185}]
["Land Rent",null,null,null,42000,42000,"       Projected $ Left From Prior Year",null,null,null,null,"Seed","Fertilizer","Chemical","Crop Insur","Custom","  xxxxxxxxxx"]
["CustomHire-Other ",3000,"  Lvstk.",0,10000,{"$f":"B31+D31+P29","v":10200},"Cash at Begin. of Period",null,1000]
["Gas, Fuel and Oil",null,null,null,30000,39000,"Old Crop & Grain Sales",null,115000,null,"Return over listed costs is available to pay for those expenses, capital purchases, family living and loan"]
["Real Estate Taxes",null,null,null,0,11500,"Old Livestock Sales",null,54000,null,"payments listed on the plan.  There are 5 areas of listed costs shown above."]
["Hired Labor",null,null,null,3000,4000,"Old Acct's Receivable",null,6000,null,"Notes:"]
["Farm Insurance ",null,null,null,3900,7800,"Last Year's Acct's Pay.",null,29500]
["Utilities",null,null,null,2400,4800,"Last Year's Oper. Loans",null,31900]
["General Farm Supplies",null,null,null,2000,5000,"Last Year's Chat. Loans",null,34600]
[null,null,null,null,0,0,"Last Year's RE Loans",null,75000]
["Borrowing $450,000 Operating ",null,null,null,0,0,"Projected Cash Balance",null,{"$f":"I31+I32+I33+I34-I35-I36-I37-I38","v":5000}]
[null,null,"                   TOTAL>",null,{"$f":"SUM(E22:E39)","v":413800},{"$f":"SUM(F22:F39)","v":546200},null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculating Amortized Loan Payments(Ending Balance = 0 or a negative balance)"]
["Family Living Expense",null,null,null,36200,60000,"Financial Summary",null,null,null,"Land Rental Units",null,null,null,null,null,null,null,null,"Loan Amount $","Inter.Rate","Years","Ending Bal.$","Payment $","Interest $"]
["Capital Purchases","Trading Combines, 5%, 5 Years",null,null,250000,250000,"Farm Income",null,{"$f":"H22","v":751375},null,"Landlord",null,null,"Acres","Rent/Acre","Total Paid",null,null,null,250000,0.05,5,0,{"$f":"PMT(U42,V42,T42,W42,0)*-1","v":57743.699532067032},{"$f":"T42*U42","v":12500}]
["Capital Purchases","Semi Tractor & Trailer",null,null,0,50000,"Farm Expenses",null,{"$f":"F40","v":546200},null,"J. Johnson",null,null,200,65,{"$f":"200*65","v":13000},null,null,null,200000,0.04,10,0,24658.188866027307,{"$f":"T43*U43","v":8000}]
["Payments to be made",null,null,null,null,null,"Net Farm Income",null,{"$f":"I42-I43","v":205175},null,"Selma Bjronson",null,null,300,70,{"$f":"300*70","v":21000},null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Annual  Operating Ln","Int rate",0.04,"Est Months",9,{"$f":"(E40+E41)*(1+(C45*(E45/12)))","v":463500},"Non Farm Income",null,15000,null,"Charlie Brightone",null,null,100,80,{"$f":"100*80","v":8000},null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Capital Purchases Ln","Int rate",0,"Years for loan",0,0,"Family Living Exp",null,{"$f":"F41","v":60000},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,0,"Net Cash Income",null,{"$f":"I44+I45-I46","v":160175},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["FCS RE $200,000 Bal. 4%  10 Years amortized",null,null,null,null,24658,"(Plus) Proj. Cash Bal.",null,{"$f":"I39","v":5000},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Farm Bank $100,000 Tractor Loan 5%, $20,000 +Interest Annually",null,null,null,null,25000,"(Plus) Interest Expense",null,{"$f":"F23","v":39000},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["JD Credit, Combine, $250,000 for 5 Years @ 5%",null,null,null,null,57744,"(Plus) Money Borrowed",null,{"$f":"SUM(E40:E43)","v":700000},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"(Less)Capital Purchases",null,{"$f":"SUM(F42:F43)","v":300000},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[" ",null,null,null,null,0,"Available for Payments",null,{"$f":"I47+I48+I49+I50-I51","v":604175},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
["Income & Soc. Sec. Taxes to be paid",null,null,null,null,15000,"Payments to be made",null,{"$f":"F54","v":585902},null,null,null,null,null,0,0,null,null,null,0,0,0,0,{"$error":"#NUM!"},0]
[null,null,"Total Payments to be made",null,null,{"$f":"SUM(F45:F53)","v":585902},"Margin",null,{"$f":"I52-I53","v":18273},null,"Total Acres Rented, Avg. Rent, Total Paid",null,null,{"$f":"N43+N44+N45+N46+N47+N48+N49+N50+N51+N52+N53","v":600},{"$f":"P54/N54","v":70},{"$f":"P43+P44+P45+P46+P47+P48+P49+P50+P51+P52+P53","v":42000},null,null,null,"Total Interest $","  xxxxxxxxx","  xxxxxxxxx","  xxxxxxxxxxxx","  xxxxxxxxx",{"$f":"SUM(Y42:Y53)","v":20500}]