Rental Property Analysis Spreadsheet, Cap Rate Calculator, Cash on Cash Return, DSCR, IRR, Real Estate Deal Analyzer Excel Google Sheets

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.

About this design: this original printable was designed for CoreCreativeCoCrafts with the help of AI tools (for page layout and wording) and built as a fillable PDF in code. No real people are shown in the images.