{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Gross Schedule Income",96600,null,null,"Sales Information"]
["Less Vacancy",{"$f":"SUM(B1*C2)","v":0},0,null,"Sales Price",899000]
["Gross Operating Income",{"$f":"B1-B2","v":96600},null,null,"Down Payment",{"$f":"F2*G3","v":179800},0.2]
[{"$nulls":4},"Balance Financed",{"$f":"F2-F3","v":719200}]
["Annual Operating Expenses"]
["Taxes",8473,null,null,"Finance Summary"]
["Insurance",2500,null,null,"Bank Type","Conv."]
["Water/sewer",20320,null,null,"Term",20]
["Oil, Electric and Trash",5800,null,null,"Interest",6.7500000000000004E-2]
["Management",{"$f":"SUM(B3*C10)","v":0},0,null,"Included",0]
["Maintenance and Repair",2500,null,null,"Per Month",{"$f":"PMT(F9/12,F8*12,F4)*-1","v":5469}]
[{"$nulls":4},"Per Year",{"$f":"F11*12","v":65628}]
["Total Expenses",{"$f":"SUM(B6:B11)","v":39593},null,null,"Balance",{"$f":"F2-F3","v":719200}]
[{"$nulls":4},"Total Monthly Payments",{"$f":"F11+F10","v":5469}]
["Net Operating Income",{"$f":"B3-B13","v":57007},null,null,"Less Tax & Insurance",0]
["Cap Rate",{"$f":"B15/F2*100","v":6.34}]
[{"$nulls":4},"Total Debt Balance",{"$f":"F2-F3","v":719200}]
["Cash Flow Schedule"]
["Net Operating Income",{"$f":"B3-B13","v":57007},null,null,"Estimated Depreciation"]
["Less Prin. & Interest Pmts.",{"$f":"F11*12","v":65628},null,null,null,"Life","Basis","St. Line"]
["Cash Flow (before Inc. Taxes)",{"$f":"B19-B20","v":-8621},null,null,"Land",0,{"$f":"SUM(F2*0.5)","v":449500},0]
[{"$nulls":4},"Buildings",27.5,{"$f":"SUM(F2*0.5)","v":449500},{"$f":"G22/F22","v":16345}]
["Income Tax Computations"]
["Net Operating Income",{"$f":"B3-B13","v":57007}]
["Approx. Annual Interest",{"$f":"F17*F9","v":48546},null,null,"Personal Property",null,null,0]
["Estimated Annual Depreciation",{"$f":"SUM(H21:H26)","v":16345},null,null,"Total Basis",null,{"$f":"G21+G22","v":899000}]
["Net Taxable Income",{"$f":"B24-B25-B26","v":-7884},null,null,"Total Depreciation",null,null,{"$f":"SUM(H21:H26)","v":16345}]
["Tax Savings or Expense",{"$f":"B27*C28","v":-1971},0.25]
[{"$nulls":4},"Return on Equity"]
[{"$nulls":4},"Cash Flow Before Income Taxes",{"$f":"B19-B20","v":-8621},{"$f":"F30/F3","v":-0.05}]
[{"$nulls":4},"Income Tax",{"$f":"B27*C28","v":-1971}]
[{"$nulls":4},"Cash Flow After Income Taxes",{"$f":"F30-F31","v":-6650},{"$f":"F32/F3","v":-0.04}]
[{"$nulls":4},"Equity Growth",{"$f":"F12-B25","v":17082},{"$f":"F33/F3","v":0.1}]
[{"$nulls":4},"Appreciation",{"$f":"G34*F2","v":17980},0.02]
[{"$nulls":4},"TOTAL RETURN ON EQUITY",{"$f":"SUM(F32:F34)","v":28412},{"$f":"F35/F3","v":0.16}]
[{"$nulls":4},"Value-End of year",{"$f":"SUM(F3:F4)","v":899000}]
[{"$nulls":4},"Mortgage Balance",{"$f":"F17-F33","v":702118}]
[{"$nulls":4},"Equity-End of year",{"$f":"F36-F37","v":196882}]

{"sheet":"Sheet2","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Address","Current Monthly Rent","Fair Market Monthly Rent"]
["18 Roberts Lane",0,0]
["19 Roberts Lane",0,0]
["20 Roberts Lane",225,300]
["22 Roberts Lane",0]
["24 Roberts Lane",350,600]
["26 Roberts Lane",225,300]
["28 Roberts Lane",225,300]
["30 Roberts Lane",400,600]
["32 Roberts Lane",0,0]
["34 Roberts Lane",300,600]
["35 Roberts Lane",225,300]
[]
["127 Woodward"]
["Suite 201",350,600]
["Suite 202",600,600]
["Suite 203",400,600]
["Commercial Space",0,1500]
[]
["129 Woodward (House)",0,1000]
[]
["Lamar Ad - Billboard",167,300]
[]
["Monthly Total",{"$f":"SUM(B2:B22)","v":3467},{"$f":"SUM(C2:C22)","v":7600}]
["Yearly Total",{"$f":"SUM(12*B24)","v":41604},{"$f":"SUM(12*C24)","v":91200}]