{"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,"Property Address"]
[]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma "]
[null,"Number of Units",5.0,5.0]
[null,"Average Monthly Rent per Unit",1380.0,1780.0]
[null,"Total Rental Income",{"$f":"sum(C5*C6)","v":6900},8900]
[null,"% Vacancy and Credit Losses",0.05,0.05,"5% Rule of Thumb"]
[null,"Total Vacancy Loss",{"$f":"C8*C7","v":345},445]
[null,"Other Monthly Income (laundry, vending, parking, etc.)"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":6555},8455]
[]
[null,"Monthly Operating Expenses"]
[null,"Property Management Fees",{"$f":"C11*0.05","v":327.75},422.75,"5% Rule of Thumb"]
[null,"Repairs and Maintenance",{"$f":"C11*0.05","v":327.75},422.75,"5% Rule of Thumb"]
[null,"Real Estate Taxes",708.3,708.3]
[null,"Rental Property Insurance",416.0,416.0,"Typically $1000 a unit/year"]
[null,"Landscaping ",50.0,50.0,"$500 Base"]
[null,"Cleaning ",0.0,0.0,"$250 Base"]
[null,"Common Utilities",100.0,100.0,"Common Utiltiies "]
[null,"- Water and Sewer",250.0,250.0,"$600 Unit/Yr"]
[null,"- Garbage",0.0,0.0,"$200/mo"]
[null,"- Electric"]
[null,"- Heat  ",0.0,0.0]
[null,"Pest Control",null,null,"$200/mo"]
[null,"Accounting and Legal"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C27)","v":2179.8},2369.8]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":78660},101460]
[null,"Total Annual Operating Expense",{"$f":"C28*12","v":26157.6},28437.6]
[null,"Annual Net Operating Income",{"$f":"C31-C32","v":52502.4},73022.4]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate"]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C36=0,\" - \",C33/C36)","v":" - "}," - "]
[null,"Actual Purchase Price",650000.0,650000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C38=0,\" - \",C33/C38)","v":0.08077292308},0.1123421538]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C38*0.2","v":130000},130000,"20%%"]
[null,"Loan Amount",{"$f":"C38-C42","v":520000},520000,"80% LTC"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C38*0.0075","v":4875},4875,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0,30.0]
[null,"Annual Interest Rate",0.065,0.065]
[null,"Initial Investment",{"$f":"C42+C44","v":134875},134875]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C43=0,0,-PMT(C46/12,C45*12,C43))","v":3286.753722},3286.753722]
[null,"Annual Interest",{"$f":"IF(C43=0,0,-CUMIPMT(C46/12,C45*12,C43,1,12,0))","v":33628.87223},33628.87223]
[null,"Annual Principal",{"$f":"IF(C43=0,0,-CUMPRINC(C46/12,C45*12,C43,1,12,0))","v":5812.172439},5812.172439]
[null,"Total Annual Debt Service",{"$f":"C48*12","v":39441.04467},39441.04467]
[null,"DEBT SERVICE RATIO",{"$f":"C33/C51","v":1.331161495},1.85143169]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C28-C48","v":1088.446278},2798.446278]
[null,"Total Annual Cash Flow",{"$f":"C33-C51","v":13061.35533},33581.35533]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C47=0,\" \",C56/C47)","v":0.09684044733},0.2489813185]
[]
[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":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes"]
[1.0,"commercial ","vacant",1400.0,null,null,null,"Property Overview"]
[2.0,"2 beds 1 bath ",1600.0,1800.0]
[3.0,"2 beds 1 bath",1600.0,1800.0,null,null,null,"Total Units: 5"]
[4.0,"2 beds 1 bath",1600.0,1800.0]
["     attic","3 beds 1 bath",2100.0,2100.0,null,"attic/ not legal untis ",null,"3 Residential Units – All currently rented"]
["TOTAL",null,6900.0,8900.0]
["ANNUAL",null,82800.0,106800.0,null,null,null,"1 Commercial Unit – Currently vacant (previously rented for $1,300/month)"]
[{"$nulls":7},"Building & Systems"]
["EXPENSES (30%)"]
["MONTHLY",{"$nulls":6},"Furnaces: ONLY 2 FURNACES, OTHER UNTIS USE ELECTRIC BASEBORD"]
["ANNUAL",null,24840.0,32040.0]
[{"$nulls":7},"Roof: Recently replaced"]
["ANNUAL NOI",null,57960.0,74760.0]
[{"$nulls":7},"Water Heaters: New"]
[]
[null,700.0,0.0828,{"$nulls":4},"Electric Meters: 5 total (one per unit)"]
[null,550.0,0.105]
[{"$nulls":7},"ATTIC"]
[{"$nulls":7},"Configured as a 3-bedroom unit, currently rented by the room"]
[]
[{"$nulls":7},"Each room rented at $700/month for a total of $2,100/month"]
[]
[{"$nulls":7},"Includes a kitchen and bathroom"]