Report this item to Etsy

Rental Property Calculator Excel, Rental Property Analyzer Spreadsheet, Deal Analyzer for 1-4 Units, Cash Flow, Cap Rate, DSCR

NowPrice:$10.50

Original Price: $15.00

30% off

•

Sale ends in 5 days

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

Rental property analysis spreadsheet for 1-4 units: the example duplex nets $659 a month after costs, 6.04% cash-on-cash. Excel.

This rental property analysis spreadsheet shows what a 1-4 unit rental costs and what it pays, before you make an offer. Excel.

WHO IT'S FOR
For: a landlord or first-time buyer of a 1-4 unit property who wants to see monthly cash flow, cap rate, cash-on-cash and DSCR before making an offer. Up to 4 unit rents go on Inputs.
Not for: after-tax or multiple-loan analysis (pre-tax only, one fixed-rate loan, no refinance, no depreciation) or a 5+ unit property.

WORKED EXAMPLE
The file opens with a sample duplex (example numbers) filled in. $450,000 price, $4,600 rent, 25% down at 6.75%. It shows a 7.59% cap rate, $659 a month cash flow, 6.04% cash-on-cash and a 1.30 DSCR. Rent minus mortgage says $2,411 a month. The full picture says $659. That gap is why this exists.

WHY NOT A FREE CALCULATOR?
Free tools are fine for a quick look. This is one Excel file you keep. Every formula is visible. You get a 10-year pro forma, IRR, break-even rent and price-versus-rent grids. Change the blue cells. Save a copy for each deal.

Excel file. No macros.

Type your deal into the Inputs tab: price, closing costs, down payment, loan rate and term, up to 4 unit rents, vacancy, taxes, insurance, repairs, capex, management, HOA, utilities, rent and expense growth, appreciation, hold period (1-10 years) and sale costs. The Summary tab then shows:
- Monthly cash flow
- NOI and cap rate
- Cash-on-cash return
- DSCR
- IRR and equity multiple
- Net sale proceeds and total profit
- Break-even rent, total and per unit, and how much cushion you have

The ProForma tab lays out the full 10 years: income, expenses, NOI, debt service, cash flow, property value, loan balance, equity and the sale. The Sensitivity tab shows year-1 cash-on-cash and cap rate on 5x5 grids, with purchase price down the side and total monthly rent across the top. The step size is adjustable. Price and rent are the only two things the grids vary.

No macros. Blue cells are inputs, black cells are formulas, yellow cells are the key assumptions. A worked example (an example duplex, clearly labeled EXAMPLE) is loaded so you can see every output; replace the blue cells with your own deal.

WHAT YOU GET
- 1 Excel workbook (.xlsx) with 5 tabs: Start Here, Summary, Inputs, ProForma, Sensitivity
- 1-page HOW-TO-USE PDF
- Instant digital download, delivered as one .zip file

GOOD TO KNOW
- Pre-tax numbers only: one fixed-rate loan, no refinance, no depreciation, no income tax.
- Built and checked in Excel. The current file has not been re-tested in Google Sheets.
- Property taxes are a % of price, so they move with price in the Sensitivity grids.
- This is a screening tool. Your results are only as good as your inputs, so check rents, taxes and insurance for your market.

FAQ
Does it include taxes or depreciation? No. It is pre-tax, with one fixed-rate loan and no refinance.
Does it show how far rent can fall? Yes. The example duplex breaks even at $3,748.73 a month, a cushion of 18.5%. Example numbers shown. Replace them with yours.
Does it work in Google Sheets? It is built and checked in Excel. The current file has not been re-tested in Google Sheets, so this listing does not promise it.
Bought it? Track rent and Schedule E lines all year with the Schedule E Spreadsheet for Landlords: https://www.etsy.com/listing/4593251883/landlord-tax-spreadsheet-schedule-e

Calculator only, not financial, tax or legal advice.
Personal use only. No resale or sharing of the file.
Pairs with: DSCR Loan Calculator Spreadsheet and Rental Property Portfolio Dashboard.
Made by Cap Rate Studio with AI-assisted tools.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Sales Operations

Buy to Let Spreadsheet

Listed on Oct 9, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Personal Finance Templates