{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CashFlow","Rent Roll"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":"CashFlow","index":0,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,8]]}
[null,"232 Main St. Ansonia, CT",null,null,"New Roof - New HVAC - Renovated 6 Units - New Windows - Repointed Brick"]
[null,"8 Units - 7 Residential & 1 Commercial Unit"]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",8.0,8.0]
[null,"Average Monthly Rent per Unit",{"$f":"C7/C5","v":1593.75},1987.5]
[null,"Total Rental Income",12750.0,15900.0]
[null,"% Vacancy and Credit Losses",0.05,0.05,"5% Rule of Thumb"]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":637.5},795]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":12112.5},15105]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees"]
[null,"Repairs and Maintenance",{"$f":"C11*0.05","v":605.625},755.25,"5% Rule of Thumb"]
[null,"Real Estate Taxes",{"$f":"14613/12","v":1217.75},1217.75]
[null,"Rental Property Insurance",600.0,600.0]
[null,"Landscaping "]
[null,"Cleaning "]
[null,"Common Utilities",null,null,"Common Utiltiies "]
[null,"- Water and Sewer",{"$f":"(600*8)/12","v":400},400,"$600 Unit/Yr"]
[null,"- Garbage",400.0,400.0]
[null,"- Electric"]
[null,"- Heat  ",400.0,400.0]
[null,"Accounting and Legal"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C26)","v":3623.375},3773]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":145350},181260]
[null,"Total Annual Operating Expense",{"$f":"C27*12","v":43480.5},45276]
[null,"Annual Net Operating Income",{"$f":"C30-C31","v":101869.5},135984]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.07,0.07]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C35=0,\" - \",C32/C35)","v":1455278.571},1942628.571]
[null,"Actual Purchase Price",1500000.0,1500000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C37=0,\" - \",C32/C37)","v":0.067913},0.090656]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C37*0.3","v":450000},450000,"30% Down"]
[null,"Loan Amount",{"$f":"C37-C41","v":1050000},1050000,"70% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C37*0.0075","v":11250},11250,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0,30.0]
[null,"Annual Interest Rate",0.06,0.06]
[null,"Initial Investment",{"$f":"C41+C43","v":461250},461250]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C42=0,0,-PMT(C45/12,C44*12,C42))","v":6295.280514},6295.280514]
[null,"Annual Interest",{"$f":"IF(C42=0,0,-CUMIPMT(C45/12,C44*12,C42,1,12,0))","v":62649.24319},62649.24319]
[null,"Annual Principal",{"$f":"IF(C42=0,0,-CUMPRINC(C45/12,C44*12,C42,1,12,0))","v":12894.12298},12894.12298]
[null,"Total Annual Debt Service",{"$f":"C47*12","v":75543.36617},75543.36617]
[null,"DEBT SERVICE RATIO",{"$f":"C32/C50","v":1.348490346},1.800078642]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C27-C47","v":2193.844486},5036.719486]
[null,"Total Annual Cash Flow",{"$f":"C32-C50","v":26326.13383},60440.63383]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C46=0,\" \",C55/C46)","v":0.0570756289},0.1310366045]
[]
[null,"Note: This spreadsheet should only be used for informational and educational purposes. Please verify"]
[null,"calculations and seek professional assistance before making financial decisions."]

{"sheet":"Rent Roll","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes"]
["Commercial",null,2500.0,3000.0]
[1.0,"2 Bed",1200.0,2100.0,"Vacant"]
[2.0,"2 Bed",1800.0,2100.0,"Vacant"]
[3.0,"2 Bed",1800.0,2100.0]
[4.0,"2 Bed",1400.0,2100.0,"Section 8"]
[5.0,"2 Bed",1500.0,2100.0]
[6.0,"1 bed",1400.0,1700.0,"Vacant"]
[7.0,"1 Bed",1150.0,1700.0,"Not Renovated"]
[null,"TOTAL",{"$f":"sum(C2:C9)","v":12750},{"$f":"SUM(D2:D9)","v":16900}]
[]
[]
[null,null,{"$f":"sum(C2+C5+C7+C6+C9)","v":8350}]