Markdown Notes Vault Template
$7.99USD
Printable & fillable PDF
Rental Property Analysis Spreadsheet
$14.99USD · instant digital download
Rental property analysis spreadsheet: cap rate, cash on cash return, DSCR, IRR and a 10-year cash flow for any deal. Works in Excel and Google Sheets.
- Instant download after checkout
- Print at home or fill in on a tablet
- Secure payment and delivery through Etsy
About this spreadsheet
Rental property analysis spreadsheet: cap rate, cash on cash return, DSCR, IRR and a 10-year cash flow for any deal. Works in Excel and Google Sheets.
Know whether a rental deal works before you make an offer. Type the price, rent, expenses and loan terms into one sheet and get cap rate, cash-on-cash return, DSCR, IRR, a 10-year cash flow and a sensitivity check straight away.
What's included
- Rental_Property_Pro_Forma.xlsx: an XLSX spreadsheet for Excel 2019/365 and LibreOffice Calc, or import it into Google Sheets (File > Import). No macros.
- PDF guide in US Letter and A4, 13 pages: how to use the spreadsheet, every metric explained in plain English, a worked example, plus printable, fillable deal worksheets
Spreadsheet sheets
- Inputs and Results: price, closing costs, repairs, rent, other income, vacancy, rent growth, taxes, insurance, utilities, HOA, repairs, management and reserve percentages, down payment, rate, term, loan fees, hold period, exit cap rate and selling costs
- Results panel: loan amount, cash invested, monthly payment, NOI, cash flow, cap rate, cash-on-cash return, DSCR, gross rent multiplier, break-even occupancy, rent as % of price, price per unit, IRR, equity multiple, total profit, NPV and sale price
- Cash Flow 10yr: income, every expense line, NOI, debt service, cash flow, loan balance, principal paid, cash-on-cash and DSCR for each year, plus the sale in your exit year
- Sensitivity: cap rate, cash-on-cash and DSCR grids as price and rent change by up to 10%, with weak results shaded red
- Rent Roll: units, rents, market rents, lease dates, deposits and tenants
- Compare Deals: a quick year-1 screen for up to 4 properties side by side
Printable worksheets in the guide
Property analysis worksheet, property tour checklist, rent comps worksheet, due diligence checklist, deal log and notes.
Sample numbers are filled in so you can see how it works. Just type over them.
This is a digital download. No physical item will be shipped. For personal use; please do not resell or share the files.
Disclaimer
This spreadsheet and guide are educational tools only. They are not financial, investment, tax or legal advice. Results depend on the estimates you enter, and figures are before income tax. Check every number and consult a qualified lender, accountant, attorney or licensed agent before you invest.
