{"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]]}
[null,"127 James St."]
[null,"(1) 3 Bed - (3) 2 Bed - (2) 1 Bed"]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",6.0,6.0]
[null,"Average Monthly Rent per Unit",{"$f":"C7/C5","v":1591.5},1783.333333]
[null,"Total Rental Income",{"$f":"'Rent Roll'!C8","v":9549},{"$f":"'Rent Roll'!D8","v":10700}]
[null,"% Vacancy and Credit Losses",0.05,0.05,"5% Rule of Thumb"]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":477.45},535]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":9071.55},10165]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",{"$f":"C11*0.05","v":453.5775},508.25,"5% Rule of Thumb"]
[null,"Repairs and Maintenance",{"$f":"C11*0.05","v":453.5775},508.25,"5% Rule of Thumb"]
[null,"Real Estate Taxes",{"$f":"12331/12","v":1027.583333},1027.583333]
[null,"Rental Property Insurance",500.0,500.0]
[null,"Landscaping ",50.0,50.0]
[null,"Cleaning "]
[null,"Common Utilities",null,null,"Common Utiltiies "]
[null,"- Water and Sewer",300.0,300.0]
[null,"- Garbage",100.0,100.0]
[null,"- Electric","TPU","TPU"]
[null,"- Heat  ","TPU","TPU"]
[null,"Pest Control"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C26)","v":2884.738333},2994.083333]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":108858.6},121980]
[null,"Total Annual Operating Expense",{"$f":"C27*12","v":34616.86},35929]
[null,"Annual Net Operating Income",{"$f":"C30-C31","v":74241.74},86051]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.065,0.0725]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C35=0,\" - \",C32/C35)","v":1142180.615},1186910.345]
[null,"Actual Purchase Price",925000.0,925000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C37=0,\" - \",C32/C37)","v":0.08026134054},0.09302810811]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C37*0.25","v":231250},231250,"25% Down"]
[null,"Loan Amount",{"$f":"C37-C41","v":693750},693750,"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C37*0.0075","v":6937.5},6937.5,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0,30.0]
[null,"Annual Interest Rate",0.0625,0.0625]
[null,"Initial Investment",{"$f":"C41+C43","v":238187.5},238187.5]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C42=0,0,-PMT(C45/12,C44*12,C42))","v":4271.538078},4271.538078]
[null,"Annual Interest",{"$f":"IF(C42=0,0,-CUMIPMT(C45/12,C44*12,C42,1,12,0))","v":43129.12439},43129.12439]
[null,"Annual Principal",{"$f":"IF(C42=0,0,-CUMPRINC(C45/12,C44*12,C42,1,12,0))","v":8129.332541},8129.332541]
[null,"Total Annual Debt Service",{"$f":"C47*12","v":51258.45694},51258.45694]
[null,"DEBT SERVICE RATIO",{"$f":"C32/C50","v":1.448380315},1.678766883]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C27-C47","v":1915.273589},2899.378589]
[null,"Total Annual Cash Flow",{"$f":"C32-C50","v":22983.28306},34792.54306]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C46=0,\" \",C55/C46)","v":0.09649239807},0.1460720779]
[]
[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":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes"]
["1A","2 Bed / 1 Ba",1545.0,1800.0]
["1B","1 Bed / 1 Ba",1459.0,1550.0]
["2A","1 Bed / 1 Ba",1520.0,1550.0]
["2B","2 Bed / 1 Ba",1600.0,1800.0]
["3A","3 Bed / 1 ba",1950.0,2200.0]
["3B","2 Bed / 1 Ba",1475.0,1800.0]
[null,"TOTAL",{"$f":"SUM(C2:C7)","v":9549},10700]