{"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":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,"123 North St New Britain"]
[]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",8.0,8.0]
[null,"Average Monthly Rent per Unit",1205.0,1337.0]
[null,"Total Rental Income",{"$f":"sum(C5*C6)","v":9640},10696]
[null,"% Vacancy and Credit Losses",0.05,0.05]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":482},534.8]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":9158},10161.2]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",482.0,{"$f":"D11*0.05","v":508.06}]
[null,"Repairs and Maintenance",482.0,{"$f":"D11*0.05","v":508.06}]
[null,"Real Estate Taxes",1419.91,1419.91]
[null,"Rental Property Insurance",600.0,600.0]
[null,"Landscaping ",100.0,100.0]
[null,"Cleaning ",200.0,200.0]
[null,"Common Utilities"]
[null,"- Water and Sewer",318.58,318.58]
[null,"- Garbage",195.0,195.0]
[null,"- Electric",70.0,70.0]
[null,"- Heat  ",0.0,0.0]
[null,"Pest Control"]
[null,"Accounting and Legal"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C27)","v":3867.49},3919.61]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":109896},121934.4]
[null,"Total Annual Operating Expense",{"$f":"C28*12","v":46409.88},47035.32]
[null,"Annual Net Operating Income",{"$f":"C31-C32","v":63486.12},74899.08]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.065,0.065]
[null,"Property Valuation",{"$f":"IF(C36=0,\" - \",C33/C36)","v":976709.5385},1152293.538]
[null,"Actual Purchase Price",950000.0,950000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C38=0,\" - \",C33/C38)","v":0.06682749474},0.07884113684]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C38*0.25","v":237500},237500,"25% Down"]
[null,"Loan Amount",{"$f":"C38-C42","v":712500},712500,"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C38*0.0075","v":7125},7125,".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":"C42+C44","v":244625},244625]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C43=0,0,-PMT(C46/12,C45*12,C43))","v":4271.797492},4271.797492]
[null,"Annual Interest",{"$f":"IF(C43=0,0,-CUMIPMT(C46/12,C45*12,C43,1,12,0))","v":42511.98645},42511.98645]
[null,"Annual Principal",{"$f":"IF(C43=0,0,-CUMPRINC(C46/12,C45*12,C43,1,12,0))","v":8749.58345},8749.58345]
[null,"Total Annual Debt Service",{"$f":"C48*12","v":51261.5699},51261.5699]
[null,"DEBT SERVICE RATIO",{"$f":"C33/C51","v":1.23847397},1.46111561]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C28-C48","v":1018.712508},1969.792508]
[null,"Total Annual Cash Flow",{"$f":"C33-C51","v":12224.5501},23637.5101]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C47=0,\" \",C56/C47)","v":0.04997261155},0.09662753234]
[]
[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":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes"]
[1.0,"1 Bed",1050.0,1300.0]
[2.0,"1 Bed",1299.0,1300.0]
[3.0,"1 Bed",1195.0,1300.0]
[4.0,"2 Bed ",1299.0,1500.0]
[5.0,"1 Bed",1050.0,1300.0]
[6.0,"2 Bed","Vacant",1500.0]
[7.0,"1 Bed ",1075.0,1300.0]
[8.0,"Commercial",1050.0,1200.0]
[]
[]
["Total",null,{"$f":"SUM(C2:C10)","v":8018},10700]