{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["CashFlow","Sheet3","Sheet1","Sheet2","©"],"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":81,"n_cols":5,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
["Destabilized Legal 7 unit buillding. 2bdr x 7 units"]
[]
["Monthly Operating Income","Scenario A","Scenario B","Scenario C"]
["Number of Units",7.0,7.0,7.0]
["Monthly Rent in Unit 1",2500.0,2600.0,null,"Vacant - Projected"]
["Monthly Rent in Unit 2",2589.0,2600.0]
["Monthly Rent in Unit 3",2500.0,2600.0,null,"Vacant - Projected"]
["Monthly Rent in Unit 4",2600.0,2600.0]
["Monthly Rent in Unit 5",2441.0,2600.0]
["Monthly Rent in Unit 6",2441.0,2600.0]
["Monthly Rent in Unit 7",2441.0,2600.0]
["% Vacancy and Credit Losses",0.03,0.03,0.03]
["Total Vacancy Loss",{"$f":"B13*B15","v":525.36},546,0]
["Total Rental Income",{"$f":"SUM(B6:B12)","v":17512},18200.0]
["Other Monthly Income (laundry, vending, parking, etc.)",0.0]
["Gross Monthly Operating Income",{"$f":"B15-B14+B16","v":16986.64},17654,0]
[]
["Monthly Operating Expenses"]
["Property Management Fee Percentage",0.05,0.05,0.0]
["Property Management  Total",875.6,{"$f":"C15*C20","v":910},0,"← Don't forget these are MONTHLY numbers."]
["Repairs and Maintenance",350.0,350.0]
["Real Estate Taxes",1403.0,1173.0]
["Rental Property Insurance",729.0,729.0]
["Homeowners/Property Association Fees"]
["Heat (gas)",null,null,0.0]
["Utilities"]
[" - Water and Sewer",300.0,300.0]
[" - Gas and Electricity",100.0,100.0]
[" - Garbage"]
[" - Cable, Phone, Internet"]
["Water & Water Pollution",0.0,0.0,0.0]
["Accounting and Legal"]
["Advertising"]
["Monthly Operating Expenses",{"$f":"SUM(B20:B34)","v":3757.65},3562.05,{"$f":"SUM(D21:D34)","v":0}]
[]
["Net Operating Income (NOI)"]
["Total Annual Operating Income",{"$f":"B17*12","v":203839.68},211848,0]
["Total Annual Operating Expense",{"$f":"B35*12","v":45091.8},42744.6,0]
["Annual Net Operating Income",{"$f":"B38-B39","v":158747.88},169103.4,0]
[]
["Capitalization Rate and Valuation"]
["Desired Capitalization Rate"]
["Property Valuation (Offer Price)"]
["Property Cost",2350000.0,2350000.0]
["Closing Costs"]
["LLC Incorporation Fee"]
["Carrying Costs"]
["Appraisal Fee",0.0]
["Acquisition & Project Manegemtn Fee",0.0,0.0]
["Rehab Costs"]
["Actual Purchase Price",{"$f":"SUM(B45:B51)","v":2350000},2350000,0]
["Actual Capitalization Rate",{"$f":"IF(B52=0,\" - \",B40/B52)","v":0.06755228936},0.07195889362," - "]
[]
["Loan Information"]
["Down Payment Percentage"]
["Down Payment"]
["Loan Amount"]
["Points "]
["Annual Interest Rate"]
["Initial Investment"]
["Monthly Mortgage Payment (PI)",{"$f":"B60*B58/12","v":0},0,0.0]
["Annual Interest",{"$f":"B62*12","v":0},0,0]
["Total Annual Debt Service",{"$f":"B62*12","v":0},0,0]
[]
["Cash Flow and ROI"]
["Total Monthly Cash Flow (before taxes)"]
["Total Annual Cash Flow (before taxes)"]
["Cash on Cash Return (ROI)",null,null,null," "]
[]
["Note: This spreadsheet should only be used for informational and educational purposes. Please verify"]
["calculations and seek professional assistance before making financial decisions."]
[]
[]
[]
[]
["Cash On Cash Return = Total Annual Cash Flow before taxes Divided by Initial investment "]
["Annual Cash Flow is NOI minus Debt Service"]
["Debt Service equals monthly mortgage times 12"]
[]
["Healthy Cash on Cash is 8-12%"]

{"sheet":"Sheet3","index":1,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Destabilized Legal 7 unit buillding. 2bdr x 7 units"]
[]
["Monthly Operating Income","Scenario A","Scenario B","Scenario C"]
["Number of Units",7.0,7.0,7.0]
["Monthly Rent in Unit 1",2500.0,2600.0]
["Monthly Rent in Unit 2",2589.0,2600.0]
["Monthly Rent in Unit 3",2500.0,2600.0]
["Monthly Rent in Unit 4",2600.0,2600.0]
["Monthly Rent in Unit 5",2441.0,2600.0]
["Monthly Rent in Unit 6",2441.0,2600.0]
["Monthly Rent in Unit 7",2441.0,2600.0]
["% Vacancy and Credit Losses",0.03,0.03,0.03]
["Total Vacancy Loss",{"$f":"B12*B14","v":525.36},546,0]
["Total Rental Income",{"$f":"SUM(B5:B11)","v":17512},18200.0]
["Other Monthly Income (laundry, vending, parking, etc.)",0.0]
["Gross Monthly Operating Income",{"$f":"B14-B13+B15","v":16986.64},17654,0]
[]
["Monthly Operating Expenses"]
["Property Management Fee Percentage",0.03,0.03,0.0]
["Property Management  Total",483.0,{"$f":"C14*C19","v":546},0]
["Repairs and Maintenance",250.0,250.0]
["Real Estate Taxes",1170.0,1170.0]
["Rental Property Insurance",583.0,583.0]
["Homeowners/Property Association Fees"]
["Heat (gas)",null,null,0.0]
["Utilities"]
[" - Water and Sewer",300.0,300.0]
[" - Gas and Electricity",100.0,100.0]
[" - Garbage"]
[" - Cable, Phone, Internet"]
["Water & Water Pollution",0.0,0.0,0.0]
["Accounting and Legal"]
["Advertising"]
["Monthly Operating Expenses",{"$f":"SUM(B19:B33)","v":2886.03},2949.03,{"$f":"SUM(D20:D33)","v":0}]
[]
["Net Operating Income (NOI)"]
["Total Annual Operating Income",{"$f":"B16*12","v":203839.68},211848,0]
["Total Annual Operating Expense",{"$f":"B34*12","v":34632.36},35388.36,0]
["Annual Net Operating Income",{"$f":"B37-B38","v":169207.32},176459.64,0]
[]
["Capitalization Rate and Valuation"]
["Desired Capitalization Rate"]
["Property Valuation (Offer Price)"]
["Property Cost",2500000.0,2500000.0]
["Closing Costs"]
["LLC Incorporation Fee"]
["Carrying Costs"]
["Appraisal Fee",0.0]
["Acquisition & Project Manegemtn Fee",0.0,0.0]
["Rehab Costs"]
["Actual Purchase Price",{"$f":"SUM(B44:B50)","v":2500000},2500000,0]
["Actual Capitalization Rate",{"$f":"IF(B51=0,\" - \",B39/B51)","v":0.067682928},0.070583856," - "]

{"sheet":"Sheet1","index":2,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,4,0,6],[0,7,0,9],[2,0,2,1],[2,7,2,8],[4,0,4,2],[4,7,4,9],[9,0,9,1],[10,7,10,8],[11,0,11,1],[13,0,13,1],[17,0,17,1],[17,7,17,8],[18,7,18,8],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,2],[26,0,26,2],[30,0,30,1],[31,0,31,2],[19,7,19,8],[20,7,20,9],[25,7,25,9],[30,7,30,8],[31,7,31,9],[32,7,32,9],[33,7,33,9],[44,0,44,2],[45,0,45,2],[47,1,47,2],[51,1,51,2],[55,0,55,1],[57,0,57,1],[32,0,32,2],[33,0,33,2],[37,0,37,2],[39,0,39,2],[40,0,40,2],[42,0,42,2],[43,0,43,2],[47,8,47,9],[51,8,51,9],[55,7,55,8],[57,7,57,8],[37,7,37,9],[39,7,39,9],[40,7,40,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[45,7,45,9]]}
["PERSONAL USE ONLY*",null,null,null,"***DO NOT TYPE ANYTHING IN A PINK CELL*****",null,null,"BANK USE ONLY*",null,null,null,"****DO NOT TYPE ANYTHING IN A PINK CELL****"]
[]
["Initial investment",{"$nulls":6},"Initial investment"]
[]
["Monthly Operating Income",{"$nulls":6},"Monthly Operating Income"]
["Monthly Rent in Unit 1",{"$nulls":6},"Monthly Rent in Unit 1"]
["Monthly Rent in Unit 2",{"$nulls":6},"Monthly Rent in Unit 2"]
["Monthly Rent in Unit 3",{"$nulls":6},"Monthly Rent in Unit 3"]
["Monthly Rent in Unit 4",{"$nulls":6},"Monthly Rent in Unit 4"]
["Total Rental Income",null,null,"*Automatic Calculation"]
[null,"% Vacancies",0.03,{"$nulls":4},"Total Monthly Rents",null,{"$f":"SUM(J6:J9)","v":0},"*Automatic Calculation"]
["Total Vacancy Loss",null,{"$f":"C11*C10","v":0},"*Automatic Calculation"]
[]
["Gross Monthly Operating Income",null,{"$f":"C10-C12","v":0},"*Automatic Calculation"]
[]
[]
["Monthly Operating Expenses",{"$nulls":6},"Monthly Operating Expenses"]
["Property Management Total",{"$nulls":6},"Repairs and Maintenance"]
["Repairs and Maintenance",{"$nulls":6},"Real Estate Taxes"]
["Real Estate Taxes",{"$nulls":6},"Property Insurance"]
["Rental Property Insurance",{"$nulls":6},"Homeowners/ Property Association Fees"]
["Homeowners/ Property Association Fees",{"$nulls":6},"Heat (gas)"]
["Heat (gas)",{"$nulls":6},"Utilities"]
["Utilities",{"$nulls":6},"Water"]
["Water",{"$nulls":6},"Accounting and Legal",null,null,0.0]
["Accounting and Legal",{"$nulls":6},"Monthly Operating Expenses",null,null,{"$f":"SUM(K18:K25)","v":0},"*Automatic Calculation"]
["Monthly Operating Expenses",null,null,{"$f":"SUM(D18:D26)","v":0},"*Automatic Calculation"]
[]
[]
[]
["Net Operating Income",{"$nulls":6},"Net Operating Income"]
["Total Annual Operating Income",null,null,{"$f":"C14*12","v":0},"*Automatic Calculation",null,null,"Total Annual Operating Income",null,null,{"$f":"J11*12","v":0},"*Automatic Calculation"]
["Total Annual Operating Expense",null,null,{"$f":"D27*12","v":0},"*Automatic Calculation",null,null,"Total Annual Operating Expense",null,null,{"$f":"K26*12","v":0},"*Automatic Calculation"]
["Annual Net Operating Income",null,null,{"$f":"D32-D33","v":0},"*Automatic Calculation",null,null,"Annual Net Operating Income",null,null,{"$f":"K32-K33","v":0},"*Automatic Calculation"]
[]
[]
[]
["Property Worth",null,null,{"$f":"K38","v":0},"*Automatic Calculation",null,null,"Property Worth",null,null,{"$f":"K34/0.07","v":0},"*Automatic Calculation"]
[]
["Length of Mortgage (Years)",null,null,30.0,null,null,null,"Length of Mortgage (Years)",null,null,30.0]
["Annual Interest Rate",null,null,0.0375,null,null,null,"Annual Interest Rate",null,null,0.0375]
[]
["Mortgage",null,null,{"$f":"D38*0.7","v":0},"*Automatic Calculation",null,null,"Mortgage",null,null,{"$f":"K38*0.7","v":0},"*Automatic Calculation"]
["Monthly Mortgage Payment",null,null,{"$f":"IF(D43=0,0,-PMT(D41/12,D40*12,D43))","v":0},"*Automatic Calculation",null,null,"Monthly Mortgage Payment",null,null,{"$f":"IF(K43=0,0,-PMT(K41/12,K40*12,K43))","v":0},"*Automatic Calculation"]
["Annual Interest",null,null,{"$f":"IF(D43=0,0,-CUMIPMT(D41/12,D40*12,D43,1,12,0))","v":0},"*Automatic Calculation",null,null,"Annual Interest",null,null,{"$f":"IF(K43=0,0,-CUMIPMT(K41/12,K40*12,K43,1,12,0))","v":0},"*Automatic Calculation"]
["Annual Principal",null,null,{"$f":"IF(D43=0,0,-CUMPRINC(D41/12,D40*12,D43,1,12,0))","v":0},"*Automatic Calculation",null,null,"Annual Principal",null,null,{"$f":"IF(K43=0,0,-CUMPRINC(K41/12,K40*12,K43,1,12,0))","v":0},"*Automatic Calculation"]
[]
[null,"Annual Mortgage Payment",null,{"$f":"D44*12","v":0},"*Automatic Calculation",null,null,null,"Annual Mortgage Payment",null,{"$f":"K44*12","v":0},"*Automatic Calculation"]
[]
[null,null,"Complete Net",{"$f":"D34-D48","v":0},"*Automatic Calculation",{"$nulls":4},"Complete Net",{"$f":"K34-K48","v":0},"*Automatic Calculation"]
[]
[null,"Complete Net Monthly",null,{"$f":"D50/12","v":0},"*Automatic Calculation",null,null,null,"Complete Net Monthly",null,{"$f":"K50/12","v":0},"*Automatic Calculation"]
[]
[]
[]
["Cash on Cash ROI",null,{"$f":"C58/C3","v":"#DIV/0!"},{"$nulls":4},"Cash on Cash ROI",null,{"$f":"J58/J3","v":"#DIV/0!"}]
[]
["Total annual Cash flow ",null,{"$f":"D34-D48","v":0},{"$nulls":4},"Total annual Cash flow ",null,{"$f":"K34-K48","v":0}]

{"sheet":"Sheet2","index":3,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,2],[7,0,7,1],[9,0,9,1],[11,0,11,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,2],[24,0,24,2],[28,0,28,1],[29,0,29,2],[30,0,30,2],[43,0,43,2],[45,1,45,2],[49,1,49,2],[53,0,53,1],[55,0,55,1],[31,0,31,2],[35,0,35,2],[37,0,37,2],[38,0,38,2],[40,0,40,2],[41,0,41,2],[42,0,42,2]]}
["Initial investment"]
[]
["Monthly Operating Income"]
["Monthly Rent in Unit 1"]
["Monthly Rent in Unit 2"]
["Monthly Rent in Unit 3"]
["Monthly Rent in Unit 4"]
["Total Rental Income",null,{"$f":"SUM(C4:C7)","v":0},"*Automatic Calculation"]
[null,"% Vacancies"]
["Total Vacancy Loss",null,{"$f":"C9*C8","v":0},"*Automatic Calculation"]
[]
["Gross Monthly Operating Income",null,{"$f":"C8-C10","v":0},"*Automatic Calculation"]
[]
[]
["Monthly Operating Expenses"]
["Property Management Total",null,null,300.0]
["Repairs and Maintenance",null,null,180.0]
["Real Estate Taxes",null,null,666.0]
["Rental Property Insurance",null,null,166.0]
["Homeowners/ Property Association Fees"]
["Heat (Oil)",null,null,250.0]
["Utilities"]
["Water",null,null,166.0]
["Accounting and Legal"]
["Monthly Operating Expenses",null,null,null,"*Automatic Calculation"]
[]
[]
[]
["Net Operating Income"]
["Total Annual Operating Income",null,null,{"$f":"C12*12","v":0},"*Automatic Calculation"]
["Total Annual Operating Expense",null,null,{"$f":"D25*12","v":0},"*Automatic Calculation"]
["Annual Net Operating Income",null,null,{"$f":"D30-D31","v":0},"*Automatic Calculation"]
[]
[]
[]
["Property Worth",null,null,{"$f":"K36","v":""},"*Automatic Calculation"]
[]
["Length of Mortgage (Years)",null,null,30.0]
["Annual Interest Rate",null,null,0.05]
[]
["Mortgage",null,null,{"$f":"D36*0.7","v":0},"*Automatic Calculation"]
["Monthly Mortgage Payment",null,null,{"$f":"IF(D41=0,0,-PMT(D39/12,D38*12,D41))","v":0},"*Automatic Calculation"]
["Annual Interest",null,null,{"$f":"IF(D41=0,0,-CUMIPMT(D39/12,D38*12,D41,1,12,0))","v":0},"*Automatic Calculation"]
["Annual Principal",null,null,{"$f":"IF(D41=0,0,-CUMPRINC(D39/12,D38*12,D41,1,12,0))","v":0},"*Automatic Calculation"]
[]
[null,"Annual Mortgage Payment",null,{"$f":"D42*12","v":0},"*Automatic Calculation"]
[]
[null,null,"Complete Net",{"$f":"D32-D46","v":0},"*Automatic Calculation"]
[]
[null,"Complete Net Monthly",null,{"$f":"D48/12","v":0},"*Automatic Calculation"]
[]
[]
[]
["Cash on Cash ROI",null,{"$f":"C56/C1","v":"#DIV/0!"}]
[]
["Total annual Cash flow ",null,{"$f":"D32-D46","v":0}]

{"sheet":"©","index":4,"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-2019 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"]