{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CashFlow","©"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"148 Benham Rd - Groton"]
[null,"24 unit Rooming House "]
[]
[null,"Monthly Operating Income","As Is With Vacancy Filled ","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%)",2000.0,{"$f":"$D11*0.05","v":1052.125},1052.125,1052.125,"Goes towards Super cost (who has free rent)"]
[null,"Repairs and Maintenance",1080.0,{"$f":"$D11*0.05","v":1052.125},1052.125,1052.125,"Rent Super & On include renting unit and 5% management"]
[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," - Water and Sewer"]
[null," - Gas and Electricity"]
[null," - Garbage"]
[null," - Cable, Phone, Internet"]
[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:C27)","v":8167.49},7691.74,7691.74,7691.74]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":241200.288},{"$f":"D11*12","v":252510},267307.2,280440]
[null,"Total Annual Operating Expense",{"$f":"C28*12","v":98009.88},{"$f":"D28*12","v":92300.88},92300.88,92300.88]
[null,"Annual Net Operating Income",{"$f":"C31-C32","v":143190.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(C36=0,\" - \",C33/C36)","v":1909205.44},{"$f":"IF(D36=0,\" - \",D33/D36)","v":2136121.6},2333417.6,2508521.6]
[null,"Actual Purchase Price",1649000.0,1649000.0,1649000.0,1649000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C38=0,\" - \",C33/C38)","v":0.08683469254},{"$f":"IF(D38=0,\" - \",D33/D38)","v":0.09715531837},0.1061287568,0.1140928563]
[]
[null,"Loan Information"]
[null,"Down Payment",370000.0,370000.0,370000.0,370000.0]
[null,"Loan Amount",{"$f":"C38-C42","v":1279000},1279000,1279000,1279000]
[null,"Acquisition Costs and Loan Fees",{"$f":"C38*0.0075","v":12367.5},12367.5,12367.5,12367.5]
[null,"Length of Mortgage (years)",30.0,30.0,30.0,30.0]
[null,"Annual Interest Rate",0.0625,0.0625,0.0625,0.0625]
[null,"Initial Investment",{"$f":"C42+C44","v":382367.5},382367.5,382367.5,382367.5]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C43=0,0,-PMT(C46/12,C45*12,C43))","v":7875.022993},{"$f":"IF(D43=0,0,-PMT(D46/12,D45*12,D43))","v":7875.022993},7875.022993,7875.022993]
[null,"Annual Interest",{"$f":"IF(C43=0,0,-CUMIPMT(C46/12,C45*12,C43,1,12,0))","v":79513.00915},{"$f":"IF(D43=0,0,-CUMIPMT(D46/12,D45*12,D43,1,12,0))","v":79513.00915},79513.00915,79513.00915]
[null,"Annual Principal",{"$f":"IF(C43=0,0,-CUMPRINC(C46/12,C45*12,C43,1,12,0))","v":14987.26677},{"$f":"IF(D43=0,0,-CUMPRINC(D46/12,D45*12,D43,1,12,0))","v":14987.26677},14987.26677,14987.26677]
[null,"Total Annual Debt Service",{"$f":"C48*12","v":94500.27592},{"$f":"D48*12","v":94500.27592},94500.27592,94500.27592]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow (before taxes)",{"$f":"C11-C28-C48","v":4057.511007},5475.737007,6708.837007,7803.237007]
[null,"Total Annual Cash Flow (before taxes)",{"$f":"C33-C51","v":48690.13208},65708.84408,80506.04408,93638.84408]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C47=0,\" \",C55/C47)","v":0.1273385737},{"$f":"IF(D47=0,\" \",D55/D47)","v":0.1718473565},0.2105462522,0.2448922675]

{"sheet":"©","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Rental Cash Flow Analysis"]
[]
[null,"By Vertex42.com"]
[null,"https://www.vertex42.com/ExcelTemplates/rental-cash-flow-analysis.html"]
[]
[null,"Disclaimer: This spreadsheet should only be used for informational and educational purposes. Please verify calculations and seek professional assistance before making financial decisions."]
[]
[null,"© 2015-2018 Vertex42 LLC"]
[]
[null,"This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws."]
[]
[null,"Do not submit copies or modifications of this template to any website or online template gallery."]
[]
[null,"Please review the following license agreement to learn how you may or may not use this template. Thank you."]
[]
[null,"License Agreement"]
[null,"https://www.vertex42.com/licensing/EULA_privateuse.html"]
[]
[null,"Do not delete this worksheet."]