{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Sheet","Real Estate Financing Calc.","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Input Sheet","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,2,18,7],[11,2,11,6]]}
["Data Input Sheet "]
[]
["Purchase Price",472000]
["Down Payment",122000]
["Amount of Purchase Price Financed",{"$f":"B3-B4","v":350000}]
["Guaranteed Interest Rate",7.0000000000000007E-2]
["Guaranteed  Terms",25]
["Bank Beg. Farmer/SDA Down Payment Terms",30]
["FSA Beg. Farmer/SDA Down Payment Terms",20]
["FSA  D-FO Interest Rate",1.4999999999999999E-2]
["FSA D-FO Terms",40]
["Particpation Lender Portion Amount",250000,{"$f":"IF(AND(B5>0,B12=0),\"Warning! Must Enter Value\",IF(AND(B5>300000,B12<B5-300000),\"Warning FSA loan Amount Exceeded\",IF(B12>B5,\"Warning! Value Exceeds Amount Financed\",\"\")))","v":""}]
["Land Price/Acre ",2950]
[]
[]
["Shared Lien Postion Unguaranteed Portion",0]
["Shared Lien Postion Guaranteed Amount",250000,{"$f":"IF(AND(B18=300000,B17>914000),\"Warning! FSA Loan Amount Exceeded\",  IF(B17+B18>1214000,\"Warning! FSA Loan Amount Exceeded\",\"\"))","v":""}]
["Shared Lien Position FSA Amount",100000,{"$f":"IF(B18>300000,\"Warning! FSA Loan Amount Exceeded\",\"\")","v":""}]
[null,{"$f":"SUM(B16:B18)","v":350000},{"$f":"IF(OR(B16+B17+B18>B5, B16+B17+B18<B5),\"Warning! Total Does Not Match Amount Financed\",\"\")","v":""}]
["Shared Lien Postion Unguaranteed Interest Rate",0.06]
["Shared Lien Postion Unguaranteed Terms",23]
[]
[]
["Note:  When a unguaranteed real estate loan and guaranteed real estate loan share the same"]
["lien position the 85% loan to value ratio does not apply to junior liens for guaranteed real estate loans."]
[]
["All three Shared Position amounts must equal Amount of Purchase Price Financed."]
[]
["Failure to correct any displaying \"Warning Messages\" will result in the option being blacked out."]
[]
["Disclaimer:  This calculator is only a guide.  Accuracy of the results are not guaranteed and are subject to the rules and regulations of the Farm Service Agency"]
["Version 5.2 last updated 10/6/11"]

{"sheet":"Real Estate Financing Calc.","index":1,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,4,3,4],[0,5,3,6],[0,2,3,3],[23,0,23,10],[6,7,6,8],[5,7,5,8],[7,7,7,8],[22,7,22,8],[18,7,18,8],[19,7,19,8],[0,7,3,8],[4,7,4,8],[0,0,2,0],[4,2,4,3],[5,2,5,3],[6,2,6,3],[0,1,3,1],[7,2,7,3],[4,5,4,6],[14,5,14,6],[6,5,6,6],[5,5,5,6],[7,5,7,6],[17,0,20,0],[26,7,27,8],[28,7,29,8],[16,7,16,8],[24,7,25,8],[20,7,20,8],[14,7,14,8],[15,7,15,8],[42,7,43,8],[44,7,45,8],[30,7,31,8],[32,7,33,8],[34,7,35,8],[36,7,37,8],[38,7,39,8],[40,7,41,8],[42,4,43,4],[44,4,45,4],[44,5,45,6],[42,5,43,6],[42,1,43,1],[44,1,45,1],[30,1,31,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[38,1,39,1],[40,1,41,1],[34,4,35,4],[36,4,37,4],[38,2,39,3],[40,2,41,3],[42,2,43,3],[44,2,45,3],[30,2,31,3],[32,2,33,3],[34,2,35,3],[36,2,37,3],[38,4,39,4],[40,4,41,4],[26,1,27,1],[28,1,29,1],[26,2,27,3],[28,2,29,3],[26,5,27,6],[24,5,25,6],[24,1,25,1],[24,2,25,3],[24,4,25,4],[26,4,27,4],[28,4,29,4],[38,5,39,6],[40,5,41,6],[34,5,35,6],[15,2,15,3],[16,2,16,3],[18,2,18,3],[28,5,29,6],[30,5,31,6],[32,5,33,6],[36,5,37,6],[15,5,15,6],[13,4,16,4],[30,4,31,4],[32,4,33,4],[9,4,12,4],[9,5,12,6],[9,7,12,8],[12,9,12,10],[7,9,7,10],[8,9,8,10],[10,9,10,10],[11,9,11,10],[21,0,22,0],[19,2,19,3],[20,2,20,3],[22,2,22,3],[13,0,16,0],[9,0,12,0],[9,1,12,1],[9,2,12,3],[17,1,20,1],[14,2,14,3],[19,5,19,6],[20,5,20,6],[18,5,18,6],[16,5,16,6],[22,5,22,6],[16,9,16,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[4,9,4,10],[0,9,3,10],[5,9,5,10],[6,9,6,10],[14,9,14,10],[15,9,15,10],[44,9,45,10],[32,9,33,10],[34,9,35,10],[36,9,37,10],[38,9,39,10],[24,9,25,10],[26,9,27,10],[28,9,29,10],[30,9,31,10],[40,9,41,10],[42,9,43,10]]}
[null,"GUARANTEE FARM OWNERSHIP LOANS ","DOWN PAYMENT",null,"DIRECT FARM OWNERSHIP ","50/50       JOINT FINANCING ",null,"PARTICPATION FINANCING",null,"SHARED LIEN BANK/GUAR/DIRECT"]
[]
[]
["PURCHASE PRICE"]
[{"$f":"'Input Sheet'!B3","v":472000},{"$f":"'Input Sheet'!B3","v":472000},{"$f":"'Input Sheet'!B3","v":472000},null,{"$f":"'Input Sheet'!B3","v":472000},{"$f":"'Input Sheet'!B3","v":472000},null,{"$f":"'Input Sheet'!B3","v":472000},null,{"$f":"'Input Sheet'!B3","v":472000}]
["DOWN PAYMENT",{"$f":"B7/B5","v":0.25847457627118642},{"$f":"C7/C5","v":0.25847457627118642},null,{"$f":"E7/E5","v":0.25847457627118642},{"$f":"F7/F5","v":0.25847457627118642},null,{"$f":"H7/H5","v":0.25847457627118642},null,{"$f":"J7/J5","v":0.25847457627118642}]
[{"$f":"'Input Sheet'!B4","v":122000},{"$f":"A7","v":122000},{"$f":"IF(A7>C5*0.05,A7,C5*0.05)","v":122000},null,{"$f":"A7","v":122000},{"$f":"A7","v":122000},null,{"$f":"'Input Sheet'!B4","v":122000},null,{"$f":"A7","v":122000}]
["AMOUNT OF PURCHASE PRICE FINANCED",{"$f":"'Input Sheet'!B5","v":350000},{"$f":"C5-C7","v":350000},null,{"$f":"'Input Sheet'!B5","v":350000},{"$f":"'Input Sheet'!B5","v":350000},null,{"$f":"H5-H7","v":350000},null,{"$f":"J5-J7","v":350000}]
["TERMS"]
["BANK             LOAN AMOUNT   YEARS    INTEREST RATE","N/A","See Note",null,"N/A","See Note",null,"See Note",null,"Bank",{"$f":"J11/J8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Input Sheet'!B16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Sheet'!B21=0,J16,'Input Sheet'!B21)","v":23}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Sheet'!B20 = 0,J17,'Input Sheet'!B20)","v":0.06}]
["BANK  GUAR.            LOAN AMOUNT   YEARS    INTEREST RATE","Bank (100%)","Bank",{"$f":"C15/C5","v":0.29152542372881357},"N/A","Bank",{"$f":"F15/F8","v":0.5},"Bank",{"$f":"H15/H8","v":0.7142857142857143},"Bank",{"$f":"J15/J8","v":0.7142857142857143}]
[null,{"$f":"B8","v":350000},{"$f":"IF(C5>500000,C8-225000,C5-C7-(C5*0.45))","v":137600},null,null,{"$f":"F8/2","v":175000},null,{"$f":"'Input Sheet'!B12","v":250000},null,{"$f":"'Input Sheet'!B17","v":250000}]
[null,{"$f":"'Input Sheet'!B7","v":25},{"$f":"'Input Sheet'!B8","v":30},null,null,{"$f":"B16","v":25},null,{"$f":"B16","v":25},null,{"$f":"H16","v":25}]
[null,{"$f":"'Input Sheet'!B6","v":7.0000000000000007E-2},{"$f":"B17","v":7.0000000000000007E-2},null,null,{"$f":"B17","v":7.0000000000000007E-2},null,{"$f":"B17","v":7.0000000000000007E-2},null,{"$f":"B17","v":7.0000000000000007E-2}]
["FSA                 LOAN AMOUNT   YEARS      INTEREST RATE","N/A"," FSA",{"$f":"C19/C5","v":0.45},"FSA (100%)","FSA",{"$f":"F19/F8","v":0.5},"FSA",{"$f":"H19/H8","v":0.2857142857142857},"FSA",{"$f":"J19/J8","v":0.2857142857142857}]
[null,null,{"$f":"IF(C5>500000,225000,C8-C15)","v":212400},null,{"$f":"E8","v":350000},{"$f":"F8/2","v":175000},null,{"$f":"H8-H15","v":100000},null,{"$f":"'Input Sheet'!B18","v":100000}]
[null,null,{"$f":"'Input Sheet'!B9","v":20},null,{"$f":"'Input Sheet'!B11","v":40},{"$f":"'Input Sheet'!B11","v":40},null,{"$f":"'Input Sheet'!B11","v":40},null,{"$f":"H20","v":40}]
[null,null,{"$f":"IF('Input Sheet'!B10-0.04>0.015,'Input Sheet'!B10-0.04,0.015)","v":1.4999999999999999E-2},null,{"$f":"'Input Sheet'!B10","v":1.4999999999999999E-2},{"$f":"IF('Input Sheet'!B10<=0.05,'Input Sheet'!B10,0.05)","v":1.4999999999999999E-2},null,{"$f":"IF(AND(I18>0.5,'Input Sheet'!B10>=0.05),'Input Sheet'!B10,IF(AND(I18>0.5,'Input Sheet'!B10<=0.05),'Input Sheet'!B10,IF(AND(I18<=0.5,'Input Sheet'!B10<=0.05),'Input Sheet'!B10,IF(AND(I18<=0.5,'Input Sheet'!B10>0.05),0.05))))","v":1.4999999999999999E-2},null,{"$f":"IF(AND(K18>0.5,'Input Sheet'!B10>=0.05),'Input Sheet'!B10,IF(AND(K18>0.5,'Input Sheet'!B10<=0.05),'Input Sheet'!B10,IF(AND(K18<=0.5,'Input Sheet'!B10<=0.05),'Input Sheet'!B10,IF(AND(K18<=0.5,'Input Sheet'!B10>0.05),0.05))))","v":1.4999999999999999E-2}]
["TOTAL PAYMENTS"]
[null,{"$f":"PMT(B17,B16,B15)*-1","v":30033.681027232968},{"$f":"PMT(C17,C16,C15)*-1+PMT(C21,C20,C19)*-1","v":23460.083422865642},null,{"$f":"PMT(E21,E20,E19)*-1","v":11699.485594047736},{"$f":"PMT(F17,F16,F15)*-1+PMT(F21,F20,F19)*-1","v":20866.583310640352},null,{"$f":"PMT(H17,H16,H15)*-1+PMT(H21,H20,H19)*-1","v":24795.339474894332},null,{"$f":"PMT(J13,J12,J11)*-1+PMT(J17,J16,J15)*-1+PMT(J21,J20,J19)*-1","v":24795.339474894332}]
["COST/ACRE"]
[{"$f":"A5","v":472000},"G-F0","BF-F0",null,"D-FO","JOINT",null,"PART",null,"SHARED "]
["WILL BUY @"]
[{"$f":"'Input Sheet'!B13","v":2950},{"$f":"B23/A28","v":187.71050642020606},{"$f":"C23/A28","v":146.62552139291026},null,{"$f":"E23/A28","v":73.121784962798344},{"$f":"F23/A28","v":130.41614569150221},null,{"$f":"H23/A28","v":154.97087171808957},null,{"$f":"J23/A28","v":154.97087171808957}]
[{"$f":"A25/A27","v":160}]
[{"$f":"A27+200","v":3150},{"$f":"B23/A30","v":200.43664244869458},{"$f":"C23/A30","v":156.56623470768383},null,{"$f":"E23/A30","v":78.07919411281857},{"$f":"F23/A30","v":139.25791828075657},null,{"$f":"H23/A30","v":165.47737149558716},null,{"$f":"J23/A30","v":165.47737149558716}]
[{"$f":"A25/A29","v":149.84126984126985}]
[{"$f":"A27+400","v":3350},{"$f":"B23/A32","v":213.16277847718314},{"$f":"C23/A32","v":166.50694802245741},null,{"$f":"E23/A32","v":83.036603262838796},{"$f":"F23/A32","v":148.09969087001096},null,{"$f":"H23/A32","v":175.98387127308476},null,{"$f":"J23/A32","v":175.98387127308476}]
[{"$f":"A25/A31","v":140.8955223880597}]
[{"$f":"A27+600","v":3550},{"$f":"B23/A34","v":225.88891450567166},{"$f":"C23/A34","v":176.44766133723098},null,{"$f":"E23/A34","v":87.994012412859021},{"$f":"F23/A34","v":156.94146345926535},null,{"$f":"H23/A34","v":186.49037105058235},null,{"$f":"J23/A34","v":186.49037105058235}]
[{"$f":"A25/A33","v":132.95774647887325}]
[{"$f":"A27+800","v":3750},{"$f":"B23/A36","v":238.61505053416025},{"$f":"C23/A36","v":186.38837465200459},null,{"$f":"E23/A36","v":92.951421562879261},{"$f":"F23/A36","v":165.78323604851974},null,{"$f":"H23/A36","v":196.99687082807998},null,{"$f":"J23/A36","v":196.99687082807998}]
[{"$f":"A25/A35","v":125.86666666666666}]
[{"$f":"A27+1000","v":3950},{"$f":"B23/A38","v":251.34118656264877},{"$f":"C23/A38","v":196.32908796677816},null,{"$f":"E23/A38","v":97.908830712899487},{"$f":"F23/A38","v":174.62500863777413},null,{"$f":"H23/A38","v":207.50337060557757},null,{"$f":"J23/A38","v":207.50337060557757}]
[{"$f":"A25/A37","v":119.49367088607595}]
[{"$f":"A27+1200","v":4150},{"$f":"B23/A40","v":264.06732259113733},{"$f":"C23/A40","v":206.26980128155174},null,{"$f":"E23/A40","v":102.86623986291971},{"$f":"F23/A40","v":183.46678122702852},null,{"$f":"H23/A40","v":218.00987038307517},null,{"$f":"J23/A40","v":218.00987038307517}]
[{"$f":"A25/A39","v":113.73493975903614}]
[{"$f":"A27+1400","v":4350},{"$f":"B23/A42","v":276.79345861962582},{"$f":"C23/A42","v":216.21051459632528},null,{"$f":"E23/A42","v":107.82364901293992},{"$f":"F23/A42","v":192.30855381628288},null,{"$f":"H23/A42","v":228.51637016057276},null,{"$f":"J23/A42","v":228.51637016057276}]
[{"$f":"A25/A41","v":108.50574712643679}]
[{"$f":"A27+1600","v":4550},{"$f":"B23/A44","v":289.51959464811443},{"$f":"C23/A44","v":226.15122791109889},null,{"$f":"E23/A44","v":112.78105816296016},{"$f":"F23/A44","v":201.1503264055373},null,{"$f":"H23/A44","v":239.02286993807036},null,{"$f":"J23/A44","v":239.02286993807036}]
[{"$f":"A25/A43","v":103.73626373626374}]
[{"$f":"A27+1800","v":4750},{"$f":"B23/A46","v":302.24573067660299},{"$f":"C23/A46","v":236.09194122587246},null,{"$f":"E23/A46","v":117.73846731298039},{"$f":"F23/A46","v":209.99209899479169},null,{"$f":"H23/A46","v":249.52936971556798},null,{"$f":"J23/A46","v":249.52936971556798}]
[{"$f":"A25/A45","v":99.368421052631575}]
[]
["Note:"]
["Loan limits are set for each program:  G-FO - $1,214,000; BF-FO - $225,000; Joint - $600,000; D-FO - $300,000"]
["Bank portion maybe guaranteed or unguaranteed.  The Beginning Farmer Downpayment program may receive up to a 95% guarantee"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}