Rental Property Per-Door Dashboard

Most landlords know their rent and their mortgage payment and believe the difference is what they make. Then the water heater goes, the unit sits empty for six weeks, and the year that looked like $6,000 of profit turns out to be a loss they never saw coming.

This dashboard takes every property you own down to one honest number — cash flow per door, per month, after taxes, insurance, vacancy, maintenance, capital reserves and management — and tells you which properties are working, which are thin, and which are costing you money.

How it works

Fill in one column per property (up to eight). Twenty yellow cells each, straight from your closing statement, your lease and last year's tax and insurance bills. Everything else calculates:

• NOI, annual cash flow and cash flow per door
• Cash-on-cash return, cap rate and DSCR — the three numbers a lender or a buyer will ask for
• Expense ratio and break-even occupancy
• The 1% rule, calculated, not guessed
• A verdict per property: strong, below target, thin, or losing money

The stress test

Rents fall 10%, every property sits empty one extra month, and each door needs a $1,500 repair. Does the portfolio survive the year? It tells you — and how much cash to hold in reserve so a bad year is a nuisance, not a forced sale.

Should I buy this one?

The deal analyser is the part you will use before every offer. Enter the asking price, the rent and the lender's quote, set your target return, and it solves for the maximum price you can pay and still hit it. Bring that number to the negotiation instead of a feeling.

Built for

Landlords with one to eight doors · house hackers · anyone about to buy their first or next rental · people who inherited a property and want to know whether to keep it.

What you get

One .xlsx file, six tabs, instant download. Works in Excel, Google Sheets, Apple Numbers and LibreOffice. No macros, no subscription. Benchmarks are editable so the verdicts reflect your targets, not mine.