{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["CashFlow"],"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":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,"148 Benham Rd Groton, CT"]
[null,"24 Unit Rooming House"]
[]
[null,"Monthly Operating Income","As-Is","Year 1 Pro Forma (Rent Super)","Year 2 Pro Forma","Year 3 Pro Forma"]
[null,"Number of Units",24.0,24.0,24.0,24.0]
[null,"Average Monthly Rent per Unit",881.58,922.91,977.0,1025.0]
[null,"Total Rental Income",{"$f":"C5*C6","v":21157.92},{"$f":"(900*23)+1450","v":22150},{"$f":"E5*E6","v":23448},24600]
[null,"% Vacancy and Credit Losses",0.05,0.05,0.05,0.05]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":1057.896},1107.5,1172.4,1230]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":20100.024},21042.5,22275.6,23370]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees ( 10%)",1080.0,{"$f":"$D11*0.05","v":1052.125},1052.125,1052.125]
[null,"Repairs and Maintenance",1080.0,{"$f":"$D11*0.05","v":1052.125},1052.125,1052.125]
[null,"Real Estate Taxes",1750.0,1750.0,1750.0,1750.0]
[null,"Rental Property Insurance",1000.0,1000.0,1000.0,1000.0]
[null,"Electric ",729.16,729.16,729.16,729.16]
[null,"Water + Sewer ",458.33,458.33,458.33,458.33]
[null,"Oil",750.0,750.0,750.0,750.0]
[null,"Cleaning",null,500.0,500.0,500.0]
[null,"Internet",400.0,400.0,400.0,400.0]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C23)","v":7247.49},7691.74,7691.74,7691.74]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":241200.288},252510,267307.2,280440]
[null,"Total Annual Operating Expense",{"$f":"C24*12","v":86969.88},92300.88,92300.88,92300.88]
[null,"Annual Net Operating Income",{"$f":"C27-C28","v":154230.408},160209.12,175006.32,188139.12]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.075,0.075,0.075,0.075]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C32=0,\" - \",C29/C32)","v":2056405.44},2136121.6,2333417.6,2508521.6]
[null,"Actual Purchase Price",1649000.0,1649000.0,1649000.0,1649000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C34=0,\" - \",C29/C34)","v":0.09352965919},0.09715531837,0.1061287568,0.1140928563]
[]
[null,"Loan Information"]
[null,"Down Payment",370000.0,370000.0,370000.0,370000.0]
[null,"Loan Amount",{"$f":"C34-C38","v":1279000},1279000,1279000,1279000]
[null,"Acquisition Costs and Loan Fees"]
[null,"Length of Mortgage (years)",30.0,30.0,30.0,30.0]
[null,"Annual Interest Rate",0.06,0.06,0.06,0.06]
[null,"Initial Investment",{"$f":"C38+C40","v":370000},370000,370000,370000]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C39=0,0,-PMT(C42/12,C41*12,C39))","v":7668.251217},7668.251217,7668.251217,7668.251217]
[null,"Annual Interest",{"$f":"IF(C39=0,0,-CUMIPMT(C42/12,C41*12,C39,1,12,0))","v":76312.7448},76312.7448,76312.7448,76312.7448]
[null,"Annual Principal",{"$f":"IF(C39=0,0,-CUMPRINC(C42/12,C41*12,C39,1,12,0))","v":15706.2698},15706.2698,15706.2698,15706.2698]
[null,"Total Annual Debt Service",{"$f":"C44*12","v":92019.0146},92019.0146,92019.0146,92019.0146]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow (before taxes)",{"$f":"C11-C24-C44","v":5184.282783},5682.508783,6915.608783,8010.008783]
[null,"Total Annual Cash Flow (before taxes)",{"$f":"C29-C47","v":62211.3934},68190.1054,82987.3054,96120.1054]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C43=0,\" \",C51/C43)","v":0.1681389011},0.1842975822,0.2242900146,0.2597840686]
[]
[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."]