{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Proforma"],"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,"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":"Proforma","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,6,0,7],[0,16,0,19],[1,2,1,3],[1,6,1,7],[1,11,1,14],[2,6,2,7],[3,8,4,8],[3,9,4,9],[10,11,10,14],[20,11,20,14],[21,16,21,19],[30,11,30,14],[40,11,40,14],[50,11,50,14],[2,2,2,3],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[353.0,"Property Name","2119 Post RD LLC"]
[null,"Address","2119 Post Rd, Fairfield CT 06824"]
[null,"Type of Property","Commercial"]
[null,"Units","Current","5% increase","Market Value"]
[null,"Annual Operating Income"]
[null,"Rental Income",155064.0,162817.2,200000.0,{"$nulls":4},{"$f":"O61","v":""}]
[{"$nulls":4},200000.0,null,null,null,{"$f":"I6*0.08","v":0},0]
[null,"Effective Rental Income",155064.0,162817.2,200000.0,null,null,null,{"$f":"I6-I7","v":0},0]
[null,"Other Income"]
[null,"Gross Operating Income",155064.0,162817.2,{"$nulls":4},{"$f":"I8+I9","v":0},0]
[]
[null,"Monthly Expenses",null,null,41008.0]
[null,"RE Taxes",41008.0,41008.0,41008.0,null,null,null,{"$f":"H13","v":""},""]
[null,"Insurance",12000.0,12000.0,12000.0,null,null,null,{"$f":"H14","v":""},""]
[null,"Electricity & Gas",10000.0,10000.0,0.0,null,null,null,{"$f":"H15","v":""},""]
[null,"Water and Sewer",0.0,0.0,0.0,null,null,null,{"$f":"H16","v":""},""]
[null,"Waste Management",0.0,0.0,800.0,null,null,null,{"$f":"H17","v":""},""]
[null,"Snow Removal",800.0,800.0,0.0,null,null,null,{"$f":"H18","v":""},""]
[null,"Landscaping",0.0,0.0,0.0,null,null,null,{"$f":"H19","v":""},""]
[null,"Pest Control",0.0,0.0,0.0,null,null,null,{"$f":"H20","v":""},""]
[null,"Misc",5000.0,5000.0,5000.0,null,null,null,{"$f":"H21","v":""},""]
[null,"Repairs and Maintenance  ",{"$nulls":6},{"$f":"H22","v":""},""]
[null,"In House Maintenance (Labor)",{"$nulls":6},{"$f":"H23","v":""},""]
[null,"Management",{"$nulls":6},{"$f":"I8*0.08","v":0},0]
[null,"Reserves 3%",{"$nulls":6},{"$f":"I8*3%","v":0},0]
[null,"Expenses",6808.0,68808.0,68808.0,null,null,null,{"$f":"SUM(I13:I25)","v":0},0]
[]
[null,"Net Operating Income (NOI)",86256.0,91002.2,131192.0]
[null,"Total Annual Operating Income",155064.0,162817.2,200000.0,null,null,null,{"$f":"I10","v":0},0]
[null,"Total Annual Operating Expense",68808.0,68808.0,68808.0,null,null,null,{"$f":"I26","v":0},0]
[null,"Net Operating Income (NOI)",86256.0,94002.0,131192.0,null,null,null,{"$f":"I29-I30","v":0},0]
[]
[null,"Initial Debt Service Ratio "]
[null,"Debt Service Property",{"$nulls":6},{"$f":"I51*12","v":0},0]
[null,"Debt Service Homes",{"$nulls":6},{"$f":"I57*12","v":0},0]
[null,"Cash Flow Before Taxes",{"$nulls":6},{"$f":"I31+I35+I34","v":0},0]
[null,"1/5 Share",{"$f":"C36/5","v":0},{"$nulls":5},{"$f":"I36/4","v":0},0]
[null,"Add Back Principal Payments",{"$f":"-C35-(C53*C55)+-C34-(C48*C49)","v":0},0,{"$nulls":4},{"$f":"-I35-(I53*I55)","v":0},0]
[null,"Taxable Net Income",{"$nulls":6},{"$f":"I36+I38","v":0},0]
["Project Costs"]
[null,"Price",0.0,{"$f":"C41","v":0},{"$nulls":4},{"$f":"H41","v":""},""]
[null,"New Home Set Up"]
[null,"CapEx"]
[null,"Total Project Cost",{"$f":"C41+C43+C42","v":0},0,{"$nulls":4},{"$f":"I41+I43+I42","v":0},0]
[]
["Property Mortgage"]
[null,"Down Payment",{"$nulls":6},{"$f":"I44*0.3","v":0},0]
[null,"Mortgage Balance"]
[null,"Interest Rate"]
[null,"Loan Term (Months)"]
[null,"Payment"]
[]
[null,"Mortgage Balance"]
[]
[null,"Interest Rate"]
[null,"Loan Term (Months)"]
[null,"Payment"]
[]
[null,"CAP Rate",0.039,0.0427,0.06]
[null,"COC Return"]
[]
[]
[null,"Value (CAP Rate)"]
[null,5.0,{"$nulls":6},{"$f":"I31/0.05","v":0},0]
[null,6.0,{"$nulls":6},{"$f":"I31/0.06","v":0},0]
[null,7.0,{"$nulls":6},{"$f":"I31/0.07","v":0},0]
[null,8.0,{"$nulls":6},{"$f":"I31/0.08","v":0},0]
[null,9.0,{"$nulls":6},{"$f":"I31/0.09","v":0},0]
[null,10.0,{"$nulls":6},{"$f":"I31/0.1","v":0},0]
[null,11.0,{"$nulls":6},{"$f":"I31/0.11","v":0},0]
[null,12.0,{"$nulls":6},{"$f":"I31/0.12","v":0},0]
[]
[{"$nulls":8},{"$f":"I67+I53-I44","v":0},0]
[{"$nulls":8},{"$f":"I73/4","v":0},0]