{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PropBuy"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"PropBuy","index":0,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Property Buying Worksheet"]
["       Not all costs are required, especially for agricultural loans."]
["       Check with your lender."]
[]
["PURCHASE EXPENSES",null,null,"Date of Closing"]
["Purchase Price:",150000,null,"Month",2]
["Percent Down:",20,null,"Day",14]
["Down Payment:",{"$f":"B6*B7/100","v":30000},null,"Year",2011]
["Amount Borrowed:",{"$f":"B6-B8","v":120000}]
["Origination %:",1,null,{"$f":"DATE(E8,E6,E7)","v":"2011-02-14"}]
["Interest Rate:",10]
["Years:",30]
["Points:",2,null,"Perfect fit purchase price"]
["Prop. Taxes/Yr",2500,null,"Enter desired"]
["Haz. Insur./Yr",500,null,null,"Total Payment:",1000]
["Mortg. Ins/Yr",400,null,"Difference needed:",null,{"$f":"B31-F15","v":336.41921743989178}]
["Mos. Prepaid Taxes",6]
["Mos. Prepaid Ins.",2,null,"Then press Ctrl-L"]
["Mos. PreMort Ins",12]
["Deed Tax% County",0.05,null,"New purchase Price:",null,{"$f":"B6","v":150000}]
["Deed Tax % State",0.15]
["Mortg Tax% County",0.05,null,"Return to original price with "]
["Mortg Tax% State",0.15,null,null,"Cancel or UNDO."]
[null,null,null,"You may need to adjust prop. taxes"]
[]
["Monthly Payments"]
["Loan Payment",{"$f":"PMT(B11/1200,B12*12,-B9)","v":1053.0858841065585}]
["Prop. Tax Escrow",{"$f":"B14/12","v":208.33333333333334}]
["Insurance Escrow",{"$f":"B15/12","v":41.666666666666664}]
["Mortg. Ins. Escrow",{"$f":"B16/12","v":33.333333333333336}]
["Total Payment",{"$f":"SUM(B27:B30)","v":1336.4192174398918}]
[]
[]
["Closing Costs",null,null,"Prepaid Expenses at Closing",null,null,{"$f":"B9*B11/36500","v":32.876712328767127}]
["Loan Origination",{"$f":"B9*B10/100","v":1200},"","Interest",null,{"$f":"IF(E6=12,G34*(DATE(E8+1,1,1)-D10),G34*(DATE(E8,E6+1,1)-D10))","v":493.15068493150693},null,""]
["Loan Points",{"$f":"B9*B13/100","v":2400},null,"Property Taxes",null,{"$f":"B14*B17/12","v":1250}]
["Credit Check",30,null,"Hazard Insurance",null,{"$f":"B15*B18/12","v":83.333333333333329}]
["Survey Fee",150,null,"Pers. Mortg. Ins.",null,{"$f":"B16*B19/12","v":400}]
["Appraisal Fee",250,null,"Total Prepaid",null,{"$f":"SUM(F35:F38)","v":2226.4840182648404}]
["Title Search",350,null,null,null,null,null,""]
["Law. Title Insur",190]
["Escrow Setup Fee",40,null,null,null,null,""]
["Amort. Schedule",5,null,null,null,null,""]
["Deed Recrdng Fee",11,null,null,null,null,""]
["Deed Tax County",{"$f":"B6*B20/100","v":75},null,"SUMMARY for",null,{"$f":"D10","v":"2011-02-14"},""]
["Deed Tax State",{"$f":"B6*B21/100","v":225},null,null,null,null,""]
["Mortg Recrdg Fee",10,null,"Cash Required at Closing"]
["Mortg Tax County",{"$f":"B9*B22/100","v":60},null,"Down Payment",null,{"$f":"B8","v":30000},null,""]
["Mortg Tax State",{"$f":"B9*B23/100","v":180},null,"Closing Costs",null,{"$f":"B51","v":5196}]
["Other",20,null,"Prepaid Expenses",null,{"$f":"F39","v":2226.4840182648404}]
["Total Closing",{"$f":"SUM(B34:B50)","v":5196},null,"Total Cash Needed",null,{"$f":"SUM(F48:F50)","v":37422.48401826484}]
[null,null,"",null,null,null,null,""]