JJENCP CalculatorsFree tools from JENCP Templates

Rental property cash flow calculator

Screen a buy-and-hold rental in under a minute. Same math as the free Rental Deal Quick Analyzer spreadsheet.

Inputs

Purchase and loan
Contract price only. Closing costs and rehab go below.
% of the purchase price paid in cash.
Annual rate on the loan.
Cash at closing, not financed.
Upfront repairs you pay in cash.
Income and expenses
As if 100% occupied.
% of gross rent.
% of gross rent.
% of collected rent. 0 if you self-manage.
Owner-paid HOA, utilities, lawn.
Your targets

Results

Loading… (this calculator needs JavaScript)

How the numbers are calculated

Everything runs off one year of operations. Rent is reduced for vacancy, operating expenses come out to get NOI, then the mortgage comes out to get cash flow.

Gross scheduled rent = monthly rent × 12 Effective gross income = gross rent × (1 − vacancy %) Operating expenses = taxes + insurance + HOA × 12 + maintenance % × gross rent + management % × effective gross income NOI = effective gross income − operating expenses Cap rate = NOI ÷ purchase price Debt service = monthly P&I × 12 Cash flow = NOI − debt service Cash-on-cash = annual cash flow ÷ (down payment + closing + rehab) DSCR = NOI ÷ annual debt service

Two details that trip people up. Management is charged on rent you actually collect, so it shrinks with vacancy; maintenance is budgeted on gross rent because the roof doesn’t care whether the unit is occupied. And cap rate uses the purchase price only. Closing costs and rehab show up in cash-on-cash, where they belong.

Worked example

A single-family rental at $220,000 with 25% down at 6.5% over 30 years, $6,500 of closing costs, $8,000 of rehab and $2,400 a month in rent. These are the default inputs above.

Gross scheduled rent ($2,400 × 12)$28,800
Vacancy (5%)−$1,440
Effective gross income$27,360
Taxes + insurance−$4,600
Maintenance (8% of gross)−$2,304.00
Management (8% of collected)−$2,188.80
NOI$18,267.20
Debt service ($1,042.91 × 12)−$12,514.95
Annual cash flow$5,752.25

That’s $479 a month. Cash in the deal is $55,000 down + $6,500 + $8,000 = $69,500, so cash-on-cash is $5,752 ÷ $69,500 = 8.28%. Cap rate is $18,267 ÷ $220,000 = 8.30%, and DSCR is $18,267 ÷ $12,515 = 1.46x. Both clear the 1.25x and 8% targets, so the screen says PASS.

Reading the result

  • DSCR under 1.25x is where many lenders start asking questions, and under 1.0x the rent doesn’t cover the mortgage before you’ve fixed a single toilet.
  • Cash-on-cash vs. cap rate. If cash-on-cash is below the cap rate, your financing is costing more than the property earns (negative leverage). That’s common at today’s rates; decide whether appreciation or paydown justifies it.
  • Stress the two inputs that move most: taxes (many states reassess on sale) and vacancy. Rerun with taxes up 20% and vacancy at 8–10% before you make an offer.

This is a one-year screen. It doesn’t model rent growth, capex timing, appreciation or your exit, so use it to decide which deals deserve a full underwrite.