{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Menu","Land Value","Afford","Sask","KSU","Blank"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Menu","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["This is a farm business decision calculator that has 6 worksheets. There are fields that can be completed by the user. It is up to 11 columns wide and 91 rows."]
["Welcome to the Land Cost Calculator Menu Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The Land Cost Calculator allows you to examine the cost of owning land and what you can afford to pay for it using a number of worksheets. "]
[]
["Developed by Rob Gamble"]
["Finance and Business Structures Program Lead"]
["OMAFRA, Guelph"]
[]
[]
["2000-12-01"]
[]
["End of worksheet"]

{"sheet":"Land Value","index":1,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Land Purchase Worksheet"]
[null,"Option 1","Option 2","Option 3","Option 4"]
["Net cash Flow per year",2418,100,40,20]
["Current selling price",15000,1200,1200,1200]
["Discount rate",0.08,0.08,0.05,0.05]
["Length of investment",12,10,10,10]
["Annual increase in land",0.03,0.03,0.03,0.03]
["Tax Rates"]
["Marginal Tax rate",0.5,0.5,0.5,0.5]
["Capital gains %",0.66659999999999997,0.75,0.75,0.75]
["Capital gains Tax rate",{"$f":"B10*B9","v":0.33329999999999999},{"$f":"C10*C9","v":0.375},{"$f":"D10*D9","v":0.375},{"$f":"E10*E9","v":0.375}]
[]
["Present Value of net cash flow                                     (A)",{"$f":"PV(B5,B6,-B3)","v":18222.236644924913},{"$f":"PV(C5,C6,-C3)","v":671.00813989414462},{"$f":"PV(D5,D6,-D3)","v":308.86939716739249},{"$f":"PV(E5,E6,-E3)","v":154.43469858369625}]
["Future value of land ",{"$f":"FV(B7,B6,,-B4)","v":21386.413302692679},{"$f":"FV(C7,C6,,-C4)","v":1612.699655212946},{"$f":"FV(D7,D6,,-D4)","v":1612.699655212946},{"$f":"FV(E7,E6,,-E4)","v":1612.699655212946}]
["Future value of land discounted back to present value    (B)",{"$f":"PV(B5,B6,,-B14)","v":8492.8389705889185},{"$f":"PV(C5,C6,,-C14)","v":746.99197853105215},{"$f":"PV(D5,D6,,-D14)","v":990.05769231584043},{"$f":"PV(E5,E6,,-E14)","v":990.05769231584043}]
["Future value minus the purchase price",{"$f":"B14-B4","v":6386.4133026926793},{"$f":"C14-C4","v":412.69965521294603},{"$f":"D14-D4","v":412.69965521294603},{"$f":"E14-E4","v":412.69965521294603}]
["Present value of those future gains",{"$f":"PV(B5,B6,,-B16)","v":2536.1325908990484},{"$f":"PV(C5,C6,,-C16)","v":191.15979282943101},{"$f":"PV(D5,D6,,-D16)","v":253.36178806692928},{"$f":"PV(E5,E6,,-E16)","v":253.36178806692928}]
["Capital gains tax                                                         (C)",{"$f":"B17*B11","v":845.29299254665284},{"$f":"C17*C11","v":71.68492231103663},{"$f":"D17*D11","v":95.010670525098476},{"$f":"E17*E11","v":95.010670525098476}]
[]
["Present value of Land Purchase  (A  plus B minus C)",{"$f":"B13+B15-B18","v":25869.782622967177},{"$f":"C13+C15-C18","v":1346.3151961141602},{"$f":"D13+D15-D18","v":1203.9164189581345},{"$f":"E13+E15-E18","v":1049.4817203744383}]
[]
[]
["Alternative Methods to Calculation"]
["Productive Value of Land (Capitalization Method)",{"$f":"B3/B5","v":30225},{"$f":"C3/C5","v":1250},{"$f":"D3/D5","v":800},{"$f":"E3/E5","v":400}]
["Economic Value (accounts for Capital Gain)",{"$f":"B3/(B5-B7)","v":48360},{"$f":"C3/(C5-C7)","v":2000},{"$f":"D3/(D5-D7)","v":1999.9999999999995},{"$f":"E3/(E5-E7)","v":999.99999999999977}]
[]
[]
[]
["Developed by Rob Gamble"]
["Finance and Business Structures, Program Lead"]
["OMAFRA"]
[]
[]
[]
["End of worksheet"]

{"sheet":"Afford","index":2,"n_rows":93,"n_cols":5,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["HOW MUCH CAN YOU AFFORD TO PAY FOR LAND?"]
["INVESTMENT DETAILS"]
["Amount of land to be purchased (acres)",100]
["Price per Acre",2000]
["Total Cost for Land",{"$f":"B3*B4","v":200000}]
["Down payment  ",25000,"(A)"]
["Loan Amount ($)",{"$f":"B5-B6","v":175000}]
["Annual Interest Rate (%)",7]
["Amortized Length of Loan (Years)",15]
["Number of Payments Per Year",1]
["Compounding Periods per Year",2]
[{"$f":"IF(OR(B9<1,),\"WARNING: LOANS MUST BE AT LEAST ONE YEAR IN LENGTH\",IF(OR(B10<1),\"WARNING: MINIMUM OF ONE  PAYMENT PER YEAR REQUIRED\",IF(OR(B11<1),\"WARNING: AT LEAST ONE COMPOUND PER YEAR REQUIRED\",\"\")))","v":""}]
["Loan  Payment per period ",{"$f":"IF(AND(AND(AND(AND(B9>=1,B10>=1),B11>=1),B7>=0),B8>=0),IF(B8=0,B7/B9/B10,((1+(B8/(B11*100)))^(B11/B10)-1)/(1-((1/(1+((1+(B8/(B11*100)))^(B11/B10)-1))^(B10*B9))))*B7),#VALUE!)","v":19362.990468693697}]
["Total Payments",{"$f":"B13*B10*B9","v":290444.85703040543}]
["Buildings and Equipment"]
["Value of your current equipment ",100000]
["Value of your current buildings ",100000]
["CASH INFLOW:"]
["Total expected farm cash income (including amount from land to be purchased)  ",250000]
["Other regular income (including spouse income)",50000]
["Total cash inflow         ",{"$f":"B19+B20","v":300000},"(B)"]
["CASH OUTFLOW:"]
["All operating cash costs including livestock,and cash expenses for the land to be purchased",180000]
["Annual principal and interest payments on existing debt",30000]
["Replacement fund for equipment 10%    ",{"$f":"B16*0.1","v":10000}]
["Replacement fund for buildings 5%    ",{"$f":"B17*0.05","v":5000}]
["Family living expenses        ",30000]
["Annual income tax payable     ",5000]
["Additional equipment and buildings if required because of land purchase",0]
["Total Cash Outflow                                     ",{"$f":"SUM(B23:B29)","v":260000},"(C)"]
["Calculations"]
["Risk Adjustment to cash available ",0.25,"(D)"]
["Expected cash available (B - C)    ",{"$f":"B21-B30","v":40000},"(E)"]
["Less: Allowance for risk (D) *(E)            ",{"$f":"B33*B32","v":10000},"(F)"]
["Cash available for annual debt payments (E - F)              ",{"$f":"B33-B34","v":30000},"(G)"]
["Cash required for debt payments",{"$f":"B13","v":19362.990468693697}]
["Difference (if negative the debt requirements are too high)",{"$f":"B35-B36","v":10637.009531306303}]
[]
["Maximum Debt you can Afford"]
["Amortization factor",{"$f":"B13/B7","v":0.11064565982110684},"(H)"]
["Amount of debt that can be serviced  (G divided by H)",{"$f":"B35/B40","v":271135.80459011532},"(I)"]
["Dollar amount available for land purchase(A) + (I)",{"$f":"B41+B6","v":296135.80459011532},"(J)"]
[]
["Below is a chart to organize your current loans and a loan calculator"]
[]
[null,"Current Loans",null,"Revised:  Nov 88"]
["Current Liabilities","Amount"," Interest ","    Months"," Interest"]
["(Less Than One Year)","Owed ","Rate","  Outstanding","Owing"]
["Operating Loans"]
[null,0,0,0,{"$f":"B50*C50/100*D50/12","v":0}]
[null,0,0,0,{"$f":"B51*C51/100*D51/12","v":0}]
["",0,0,0,{"$f":"B52*C52/100*D52/12","v":0}]
["Supplier Credit"]
[null,0,0,0,{"$f":"B54*C54/100*D54/12","v":0}]
["",0,0,0,{"$f":"B55*C55/100*D55/12","v":0}]
["",0,0,0,{"$f":"B56*C56/100*D56/12","v":0}]
["",0,0,0,{"$f":"B57*C57/100*D57/12","v":0}]
["",0,0,0,{"$f":"B58*C58/100*D58/12","v":0}]
["Sub Total ",{"$f":"SUM(B50:B58)","v":0},null,null,{"$f":"SUM(E50:E58)","v":0}]
["Long Term Liabilities"]
["(Greater Than One Year)","     Ave. Balance","Principal","Interest ","Total "]
[null,"Owing","Payments","Payments","Payment"]
["Mortgages "]
[null,0,0,0,{"$f":"C64+D64","v":0}]
["",521,0,0,{"$f":"C65+D65","v":0}]
["",0,0,0,{"$f":"C66+D66","v":0}]
["Term Loans"]
[null,0,0,0,{"$f":"C68+D68","v":0}]
["",0,0,0,{"$f":"C69+D69","v":0}]
["",0,0,0,{"$f":"C70+D70","v":0}]
["",0,0,0,{"$f":"C71+D71","v":0}]
["Other Financing"]
[null,0,0,0,{"$f":"C73+D73","v":0}]
["",0,0,0,{"$f":"C74+D74","v":0}]
["",0,0,0,{"$f":"C75+D75","v":0}]
["Sub Total",{"$f":"SUM(B64:B75)","v":521},{"$f":"SUM(C64:C75)","v":0},{"$f":"SUM(D64:D75)","v":0},{"$f":"SUM(E64:E75)","v":0}]
[]
[]
["    COMPARING INITIAL RATES"]
[null,"LOAN A ","LOAN B","LOAN C"]
["  Loan Amount ($)",5000,100000,120000]
["  Annual Interest Rate (%)",7,12,11.25]
["  Amortized Length of Loan (Years)",15,15,20]
["  Number of Payments Per Year",1,12,12]
["Compounding Periods per Year",1,2,2]
[{"$f":"IF(OR(OR(B83<1,C83<1),D83<1),\"WARNING: LOANS MUST BE AT LEAST ONE YEAR IN LENGTH\",IF(OR(OR(B84<1,C84<1),D84<1),\"WARNING: MINIMUM OF ONE  PAYMENT PER YEAR REQUIRED\",IF(OR(OR(B85<1,C85<1),D85<1),\"WARNING: AT LEAST ONE COMPOUND PER YEAR REQUIRED\",\"\")))","v":""}]
["  PAYMENT",{"$f":"IF(AND(AND(AND(AND(B83>=1,B84>=1),B85>=1),B81>=0),B82>=0),IF(B82=0,B81/B83/B84,((1+(B82/(B85*100)))^(B85/B84)-1)/(1-((1/(1+((1+(B82/(B85*100)))^(B85/B84)-1))^(B84*B83))))*B81),#VALUE!)","v":548.97312350503307},{"$f":"IF(AND(AND(AND(AND(C83>=1,C84>=1),C85>=1),C81>=0),C82>=0),IF(C82=0,C81/C83/C84,((1+(C82/(C85*100)))^(C85/C84)-1)/(1-((1/(1+((1+(C82/(C85*100)))^(C85/C84)-1))^(C84*C83))))*C81),#VALUE!)","v":1181.6096242895492},{"$f":"IF(AND(AND(AND(AND(D83>=1,D84>=1),D85>=1),D81>=0),D82>=0),IF(D82=0,D81/D83/D84,((1+(D82/(D85*100)))^(D85/D84)-1)/(1-((1/(1+((1+(D82/(D85*100)))^(D85/D84)-1))^(D84*D83))))*D81),#VALUE!)","v":1238.2214878996447}]
["  TOTAL INTEREST",{"$f":"B87*B83*B84-B81","v":3234.5968525754961},{"$f":"C87*C83*C84-C81","v":112689.73237211883},{"$f":"D87*D83*D84-D81","v":177173.15709591471}]
[null,{"$f":"B87*B83*B84","v":8234.5968525754961}]
["  PAYMENT SAVING (LOSS) VS. \"A\"",null,{"$f":"B87-C87","v":-632.6365007845161},{"$f":"B87-D87","v":-689.2483643946116}]
["  TOTAL INTEREST SAVING (LOSS) VS. \"A\"",null,{"$f":"B88-C88","v":-109455.13551954333},{"$f":"B88-D88","v":-173938.56024333922}]
[]
["End of worksheet"]

{"sheet":"Sask","index":3,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["WORKSHEET FOR ESTABLISHING THE VALUE OF LAND"]
["Existing Grain Acres",800]
["Grain Acres for Purchase",200]
["Estimated Annual Capital Gain",0.03]
["Annual Labour and Management Allowance",20000]
["Capitalization Rate",5]
["Market Value of Comparable Sales (per acre)",2400]
["Value of Buildings and Machinery"]
["Current Buildings",25000]
["Current Machinery",110000]
["Additional Buildings",0]
["Additional Machinery",15000]
["STEP 1.  GROSS INCOME ESTIMATE"]
["Estimated yields and prices of grains (typical rotation) to be grown on the new land"]
["Crop","Acres","Yield","Price","Total Income"]
["Corn",80,120,2.5,{"$f":"B16*C16*D16","v":24000}]
["Soybeans",60,40,6,{"$f":"B17*C17*D17","v":14400}]
["Wheat",60,35,3,{"$f":"B18*C18*D18","v":6300}]
["Other Crop",0,0,0,{"$f":"B19*C19*D19","v":0}]
["Other Crop",0,0,0,{"$f":"B20*C20*D20","v":0}]
["Total grain acres for purchase = ",{"$f":"SUM(B16:B20)","v":200}]
["Other Income",null,null,null,8000]
["Total income",null,null,null,{"$f":"SUM(E16+E17+E22)","v":46400}]
[" Income per acre:",null,null,null,{"$f":"E23/B21","v":232}]
["STEP 2.  COST OF PRODUCTION ESTIMATE"]
["A. Operating Costs"]
["1) Total annual operating expenses on existing farm unit",null,200000]
["2) Deduct:"]
["Interest on loans for capital assets",10000]
["Livestock share of total expenses including a protion of machinery costs except loan interest",0]
["Extraordinary expenses not expected to continue",4000]
["Total",{"$f":"B29+B30+B31","v":14000}]
["= Total Operating Costs - Existing Land Base =",null,{"$f":"C27-B32","v":186000}]
["3) Operating cost per grain acre:",{"$f":"C33/B2","v":232.5}]
["4) Adjust operating costs per acre for changes in farming practices of new land, e.g. more weed control (+) or (-)",2]
[]
["5) Expected operating costs per grain acre on new land",null,{"$f":"B35+B34","v":234.5}]
[]
["B. Fixed Costs, Labour and Management"]
["1) Total annual fixed costs on existing Farm Unit:"]
["Depreciation on crop portion of buildings ",0.05,{"$f":"(B9*B41)","v":1250}]
["Depreciation on crop portion of machinery ",0.1,{"$f":"+(B10*B42)","v":11000}]
["Interest on investments for crop portion of buildings & machinery",7.0000000000000007E-2,{"$f":"(B9+B10)*B43","v":9450}]
["Labour and management for grain operation",{"$f":"+B5","v":20000}]
["Total Fixed Costs on Existing Farm Unit",null,{"$f":"SUM(B41:B44)","v":20000.22}]
[]
["2) Plus:"]
["Depreciation on grain portion of additional buildings (5%)  & machinery (10%)",0.05,{"$f":"B11*B48","v":0}]
["Investment cost of grain portion of additional buildings & machinery (10%)",0.1,{"$f":"B12*B49","v":1500}]
["Management Allowance",2000]
["Sub-Total",null,{"$f":"SUM(B48:B50)","v":2000.15}]
["Total Fixed Costs",null,{"$f":"SUM(C45+C51)","v":22000.370000000003}]
[]
["3) Expected Fixed Costs per Grain Acre:"]
["= Total Fixed Costs/Existing Grain Acres + Grain Acres for Purchase =",null,{"$f":"C52/(B2+B3)","v":22.000370000000004}]
[]
["C. Total Costs"]
["Expected total costs per grain acre on new land:"]
["= Expected operating costs + Expected fixed costs =",null,{"$f":"C37+C55","v":256.50036999999998}]
[]
["STEP 3.  RETURN TO LAND"]
[]
["Return to land per acre for proposed purchase"]
["= Income per grain acre - Expected total cost per grain acre =",null,{"$f":"E24-C59","v":-24.500369999999975}]
[]
["STEP 4.  CAPITALIZATION (VALUE OF LAND)"]
[]
["1) Productive value of land:"]
["= Return to land X 100/Capitalization rate = ",null,{"$f":"C64/B6","v":-4.9000739999999947},"based on infinite years"]
[]
["2) Economic value of land (including potential capital gain):"]
["= Return to land x 100/Capital rate-capital gain =",null,{"$f":"C64/(B6-B4)","v":-4.9296519114688078}]
[]
["3) Market value of land (reported in the area):",null,{"$f":"B7","v":2400}]
[]
["4) Variances:"]
["Market value less productive value",null,{"$f":"C74-C69","v":2404.9000740000001}]
["Market value less economic value",null,{"$f":"C74-C72","v":2404.9296519114687}]
[]
["End of worksheet"]

{"sheet":"KSU","index":4,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["SHOULD I BUY MORE LAND ",null,null,"NET RETURN/ACRE based on 100% financing"]
["adapted from a KSU Extension Publication"]
[]
["Interest rate",7,null,"PRICE OF",null,null,"GROSS CROP VALUE"]
["Amount financed - total dollar amount",100000,null,"LAND",{"$f":"F5-10","v":170},{"$f":"G5-10","v":180},{"$f":"H5-10","v":190},{"$f":"$B$10","v":200},{"$f":"H5+10","v":210},{"$f":"I5+10","v":220},{"$f":"J5+10","v":230}]
["Years financed",20,null,{"$f":"D7-100","v":1600},{"$f":"(+E$5-($B$8+$B$9))*($B$7/100)-PMT($B$4/100,$B$6,-($D6))","v":-124.02868118920912},-114.02868118920912,-104.02868118920912,-94.028681189209124,-84.028681189209124,-74.028681189209124,-64.028681189209124]
["Percent of acres harvested   ( % )",100,null,{"$f":"D8-100","v":1700},-133.46797376353467,-123.46797376353467,-113.46797376353467,-103.46797376353467,-93.467973763534673,-83.467973763534673,-73.467973763534673]
["Crop production cost per acre",120,null,{"$f":"D9-100","v":1800},-142.90726633786025,-132.90726633786025,-122.90726633786025,-112.90726633786025,-102.90726633786025,-92.90726633786025,-82.90726633786025]
["Depreciation cost per crop acre",23,null,{"$f":"D10-100","v":1900},-152.34655891218583,-142.34655891218583,-132.34655891218583,-122.34655891218583,-112.34655891218583,-102.34655891218583,-92.346558912185827]
["Expected gross crop value per acre including gov't payments",200,null,{"$f":"$B$12","v":2000},-161.78585148651138,-151.78585148651138,-141.78585148651138,-131.78585148651138,-121.78585148651138,-111.78585148651138,-101.78585148651138]
["Number of acres to purchase",100,null,{"$f":"D10+100","v":2100},-171.22514406083695,-161.22514406083695,-151.22514406083695,-141.22514406083695,-131.22514406083695,-121.22514406083695,-111.22514406083695]
["Cost per acre",2000,null,{"$f":"D11+100","v":2200},-180.66443663516253,-170.66443663516253,-160.66443663516253,-150.66443663516253,-140.66443663516253,-130.66443663516253,-120.66443663516253]
["Expected annual income for land purchase based on financing",{"$f":"((($B$10-($B$8+$B$9))*$B$11)*($B$7/100)-PMT($B$4/100,$B$6,-($B$5)))","v":-3739.292574325571},null,{"$f":"D12+100","v":2300},-190.10372920948811,-180.10372920948811,-170.10372920948811,-160.10372920948811,-150.10372920948811,-140.10372920948811,-130.10372920948811]
["Annual income for land purchase based on 100% financing",{"$f":"(($B$10-($B$8+$B$9))*$B$11)*($B$7/100)-PMT($B$4/100,$B$6,-($B$11*$B$12))","v":-13178.585148651142},null,{"$f":"D13+100","v":2400},-199.54302178381366,-189.54302178381366,-179.54302178381366,-169.54302178381366,-159.54302178381366,-149.54302178381366,-139.54302178381366]
["Annual income for land purchase based on net cash flow",{"$f":"(($B$10-$B$8)*$B$11)*($B$7/100)-PMT($B$4/100,$B$6,-($B$5))","v":-1439.292574325571}]
["  (excluding depreciation, not adjusted for opportunity cost)",null,null,"*** FORMULA FOR CALCULATING NET RETURN/ACRE="]
[null,null,null,null,"(GROSS CROP VALUE-(CROP PROD.$+DEPREC.$))*%HARVESTED ACRES"]
[null,null,null,null,"- ANNUAL PAYMENT OF LOAN"]
[]
[null,null,null,"CASH FLOW based on amount financed without depreciation"]
[]
[null,null,null,"AMOUNT "]
[null,null,null,"BORROWED",null,null,"GROSS CROP VALUE"]
[null,null,null,"PER ACRE",{"$f":"F24-10","v":170},{"$f":"G24-10","v":180},{"$f":"H24-10","v":190},{"$f":"$B$10","v":200},{"$f":"H24+10","v":210},{"$f":"I24+10","v":220},{"$f":"J24+10","v":230}]
[null,null,null,{"$f":"IF($D$28>300,+D26-100,0)","v":600},{"$f":"(+E$5-$B$8)*($B$7/100)-PMT($B$4/100,$B$6,-($D25))","v":-6.6357554459534143},3.3642445540465857,13.364244554046586,23.364244554046586,33.364244554046586,43.364244554046586,53.364244554046586]
[null,null,null,{"$f":"IF($D$28>200,+D27-100,0)","v":700},-16.075048020278984,-6.0750480202789845,3.9249519797210155,13.924951979721016,23.924951979721016,33.924951979721016,43.924951979721016]
[null,null,null,{"$f":"IF(D28>100,+D28-100,0)","v":800},-25.514340594604562,-15.514340594604562,-5.5143405946045618,4.4856594053954382,14.485659405395438,24.485659405395438,34.485659405395438]
[null,null,null,{"$f":"IF(D29>0,D29-100,0)","v":900},-34.953633168930125,-24.953633168930125,-14.953633168930125,-4.953633168930125,5.046366831069875,15.046366831069875,25.046366831069875]
[null,null,null,{"$f":"$B$5/B11","v":1000},-44.392925743255688,-34.392925743255688,-24.392925743255688,-14.392925743255688,-4.3929257432556881,5.6070742567443119,15.607074256744312]
[null,null,null,{"$f":"D29+100","v":1100},-53.832218317581265,-43.832218317581265,-33.832218317581265,-23.832218317581265,-13.832218317581265,-3.8322183175812654,6.1677816824187346]
[null,null,null,{"$f":"D30+100","v":1200},-63.271510891906829,-53.271510891906829,-43.271510891906829,-33.271510891906829,-23.271510891906829,-13.271510891906829,-3.2715108919068285]
[null,null,null,{"$f":"D31+100","v":1300},-72.710803466232406,-62.710803466232406,-52.710803466232406,-42.710803466232406,-32.710803466232406,-22.710803466232406,-12.710803466232406]
[null,null,null,{"$f":"D32+100","v":1400},-82.150096040557969,-72.150096040557969,-62.150096040557969,-52.150096040557969,-42.150096040557969,-32.150096040557969,-22.150096040557969]
[]
[null,null,null,"*** FORMULA FOR CALCULATING CASH FLOW="]
[null,null,null,null,"(AMOUNT BORROWED/ACRE-CROP PRODUCTION $) * % HARVESTED ACRES"]
[null,null,null,null,"- ANNUAL PAYMENT OF LOAN"]
[]
[]
[]
[]
["End of worksheet"]

{"sheet":"Blank","index":5,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["HOW MUCH CAN YOU AFFORD TO PAY FOR LAND?"]
["PURCHASE DETAILS","Example",null,"Your Farm"]
["Amount of land to be purchased (acres)",100]
["Price per Acre",2000]
["Total Cost for Land",{"$f":"B3*B4","v":200000}]
["Down payment  ",25000,"(A)",null,"(A)"]
["Buildings and Equipment"]
["Value of your current equipment ",100000]
["Value of your current buildings ",100000]
[]
["CASH INFLOW:"]
["Total expected farm cash income (including amount from land to be purchased)  ",250000]
["Other regular income (include spouses income)",50000]
["Total cash inflow         ",{"$f":"B12+B13","v":300000},"(B)",null,"(B)"]
[]
["CASH OUTFLOW:"]
["All operating cash costs including livestock,and cash expenses for the land to be purchased",180000]
["Annual principal and interest payments on existing debt",30000]
["Replacement fund for equipment 10%    ",{"$f":"B8*0.1","v":10000}]
["Replacement fund for buildings 5%    ",{"$f":"B9*0.05","v":5000}]
["Family living expenses        ",30000]
["Annual income tax payable     ",5000]
["Additional equipment and buildings if required because of land purchase",0]
["Total Cash Outflow                                     ",{"$f":"SUM(B17:B23)","v":260000},"(C)",null,"(C)"]
[]
["CALCULATIONS"]
["Risk Adjustment to cash available ",0.25,"(D)",null,"(D)"]
["Expected cash available (B - C)    ",{"$f":"B14-B24","v":40000},"(E)",null,"(E)"]
["Less: Allowance for risk (D) *(E)            ",{"$f":"B28*B27","v":10000},"(F)",null,"(F)"]
["Cash available for annual debt payments (E - F)              ",{"$f":"B28-B29","v":30000},"(G)",null,"(G)"]
[]
["Maximum Debt you can Afford"]
["Amortization factor",0.10979999999999999,"(H)",null,"(H)"]
["Amount of debt that can be serviced  (G divided by H)",{"$f":"B30/B33","v":273224.04371584702},"(I)",null,"(I)"]
["Dollar amount available for land purchase(A) + (I)",{"$f":"B34+B6","v":298224.04371584702},"(J)",null,"(J)"]
[]
["End of worksheet"]