WB WorkbookBarn All workbooks

Free calculator · nothing to download

RENTAL PROPERTY DEAL ANALYZER

Blue cells on the left are yours. Everything on the right calculates itself.

THE PURCHASE
THE INCOME
THE EXPENSES

THE LOAN

Loan amount
Down payment
Total cash in the deal
Monthly principal + interest

THE OPERATING NUMBERS (ANNUAL)

Gross scheduled income
Less vacancy
Effective gross income
Operating expenses
NET OPERATING INCOME
Annual debt service

THE VERDICT

Annual cash flow
MONTHLY CASH FLOW
Cap rate
Cash-on-cash return
DSCR (lenders want 1.25)
1% rule (rent ÷ price)
Break-even rent

PROPERTY COMPARISON LOG

One row per property you run. Copy the Analyzer results across so you can rank deals side by side.

DateAddressPriceRent/moCash inNOICash flow/moCap rateCash-on-cash1% ruleVerdictNotes
1
2
3
4
5
6

Where that leaves you

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook

Keep it

Rental Property Deal Analyzer — the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $19.99What is inside →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks