{"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":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,"122 Derby Ave, New Haven, CT 06513"]
[null,"(2) 2 Bedrooms, (2) 1 Bedrooms, (1) Studio"]
[]
[null,"Monthly Operating Income","As Is ","Fully Occupied","Pro Forma"]
[null,"Number of Units",5.0,5.0,5.0]
[null,"Average Monthly Rent per Unit",1550.0,{"$f":"D7/D5","v":1470},1560]
[null,"Total Rental Income",{"$f":"sum(C5*C6)","v":7750},{"$f":"'Rent Roll'!D7-450","v":7350},{"$f":"'Rent Roll'!D7","v":7800}]
[null,"% Vacancy and Credit Losses",0.8,0.03,0.03]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":6200},220.5,234]
[null,"Other Monthly Income (laundry, vending, parking, etc.)",null,100.0,100.0]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":1550},7229.5,7666]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",{"$f":"C11*0.05","v":77.5},361.475,383.3,"5% Rule of Thumb"]
[null,"Repairs and Maintenance",{"$f":"C11*0.05","v":77.5},361.475,383.3,"5% Rule of Thumb"]
[null,"Real Estate Taxes",743.25,743.25,743.25]
[null,"Rental Property Insurance",416.67,416.67,416.67,"Typically $1000 a unit/year"]
[null,"Landscaping ",100.0,100.0,100.0]
[null,"Cleaning "]
[null,"Common Utilities",null,null,null,"Common Utiltiies "]
[null,"- Water and Sewer",50.0,250.0,250.0]
[null,"- Garbage",100.0,100.0,100.0]
[null,"- Electric"]
[null,"- Heat  ",0.0,0.0,0.0]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C25)","v":1564.92},2332.87,2376.52]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":18600},86754,91992]
[null,"Total Annual Operating Expense",{"$f":"C26*12","v":18779.04},27994.44,28518.24]
[null,"Annual Net Operating Income",{"$f":"C29-C30","v":-179.04},58759.56,63473.76]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.065,0.0675,0.0675]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C34=0,\" - \",C31/C34)","v":-2754.461538},870512,940352]
[null,"Actual Purchase Price",575000.0,575000.0,575000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C36=0,\" - \",C31/C36)","v":-0.000311373913},0.1021905391,0.1103891478]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C36*0.25","v":143750},143750,143750,"25% Down"]
[null,"Loan Amount",{"$f":"C36-C40","v":431250},431250,431250,"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C36*0.0075","v":4312.5},4312.5,4312.5,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0,30.0,30.0]
[null,"Annual Interest Rate",0.0625,0.0625,0.0625]
[null,"Initial Investment",{"$f":"C40+C42","v":148062.5},{"$f":"D40+C58","v":143750},143750]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C41=0,0,-PMT(C44/12,C43*12,C41))","v":2655.280427},2655.280427,2655.280427]
[null,"Annual Interest",{"$f":"IF(C41=0,0,-CUMIPMT(C44/12,C43*12,C41,1,12,0))","v":26809.99625},26809.99625,26809.99625]
[null,"Annual Principal",{"$f":"IF(C41=0,0,-CUMPRINC(C44/12,C43*12,C41,1,12,0))","v":5053.368877},5053.368877,5053.368877]
[null,"Total Annual Debt Service",{"$f":"C46*12","v":31863.36512},31863.36512,31863.36512]
[null,"DEBT SERVICE RATIO",{"$f":"C31/C49","v":-0.005618992197},1.844110306,1.992060781]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C26-C46","v":-2670.200427},2241.349573,2634.199573]
[null,"Total Annual Cash Flow",{"$f":"C31-C49","v":-32042.40512},26896.19488,31610.39488]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C45=0,\" \",C54/C45)","v":-0.2164113474},0.1871039644,0.2198983992]
[]
[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":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Notes","Additional"]
[1.0,"1 Bed",null,1500.0,"Vacant","Cleaned out and Ready for Rent"]
[2.0,"1 Bed",null,1500.0,"Vacant","Cleaned out and Ready for Rent"]
[3.0,"2 Bed",1550.0,1800.0]
[4.0,"2 Bed",null,1800.0,"Vacant","Cleaned out and Ready for Rent"]
[5.0,"Studio",null,1200.0,"Vacant","Cleaned out and Ready for Rent"]
[null,"Total",{"$f":"SUM(C2:C6)","v":1550},7800]