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 →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: October 2026

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