IQCalculators

Rental Property Calculator

Full rental property pro-forma: cash flow, NPV, and before/after-tax IRR with financing, depreciation, taxes, and a hypothetical sale.

Year 1 Cash on Cash
4.27%
Year 1 Equity Build-Up
2.11%
NPV of Cash Flows
$116,223
Tax Savings (Depreciation)
$49,848
Before-Tax IRR
9.36%
After-Tax IRR
9.03%

Hover any number for how it's calculated.

Line ItemYear 1Year 3Year 5Year 10Year 20Year 30
Income Statement
Gross Income$18,000Monthly rent ($1500) × 12, grown 3% per year to Year 1 = $18,000$19,096Monthly rent ($1500) × 12, grown 3% per year to Year 3 = $19,096$20,259Monthly rent ($1500) × 12, grown 3% per year to Year 5 = $20,259$23,486Monthly rent ($1500) × 12, grown 3% per year to Year 10 = $23,486$31,563Monthly rent ($1500) × 12, grown 3% per year to Year 20 = $31,563$42,418Monthly rent ($1500) × 12, grown 3% per year to Year 30 = $42,418
Less: Vacancy($1,800)Gross Income ($18,000) × 10% vacancy allowance = $1,800($1,910)Gross Income ($19,096) × 10% vacancy allowance = $1,910($2,026)Gross Income ($20,259) × 10% vacancy allowance = $2,026($2,349)Gross Income ($23,486) × 10% vacancy allowance = $2,349($3,156)Gross Income ($31,563) × 10% vacancy allowance = $3,156($4,242)Gross Income ($42,418) × 10% vacancy allowance = $4,242
Gross Operating Income$16,200Gross Income ($18,000) − Vacancy ($1,800) = $16,200$17,187Gross Income ($19,096) − Vacancy ($1,910) = $17,187$18,233Gross Income ($20,259) − Vacancy ($2,026) = $18,233$21,137Gross Income ($23,486) − Vacancy ($2,349) = $21,137$28,407Gross Income ($31,563) − Vacancy ($3,156) = $28,407$38,176Gross Income ($42,418) − Vacancy ($4,242) = $38,176
Less: Expenses($2,050)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.($2,175)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.($2,307)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.($2,675)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.($3,595)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.($4,831)Property taxes, insurance, utilities, repairs, HOA, and other costs, each inflated 3% per year from your inputs.
NOI (EBITDA)$14,150Gross Operating Income ($16,200) − Expenses ($2,050) = $14,150$15,012Gross Operating Income ($17,187) − Expenses ($2,175) = $15,012$15,926Gross Operating Income ($18,233) − Expenses ($2,307) = $15,926$18,463Gross Operating Income ($21,137) − Expenses ($2,675) = $18,463$24,812Gross Operating Income ($28,407) − Expenses ($3,595) = $24,812$33,345Gross Operating Income ($38,176) − Expenses ($4,831) = $33,345
Less: Interest($7,450)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $7,450.($7,218)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $7,218.($6,961)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $6,961.($6,195)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $6,195.($3,952)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $3,952.($257)The interest portion of this year's loan payment(s) on your loan, from the amortization schedule: $257.
Less: Depreciation($7,273)Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 1: $7,273.($7,273)Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 3: $7,273.($7,273)Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 5: $7,273.($7,273)Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 10: $7,273.($7,273)Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 20: $7,273.$0Depreciable basis ($200,000) ÷ 27.5 years = $7,273/year, with the final fractional year prorated. Year 30: $0.
Taxable Income-$572NOI ($14,150) − Interest ($7,450) − Depreciation ($7,273) = -$572$522NOI ($15,012) − Interest ($7,218) − Depreciation ($7,273) = $522$1,692NOI ($15,926) − Interest ($6,961) − Depreciation ($7,273) = $1,692$4,995NOI ($18,463) − Interest ($6,195) − Depreciation ($7,273) = $4,995$13,588NOI ($24,812) − Interest ($3,952) − Depreciation ($7,273) = $13,588$33,089NOI ($33,345) − Interest ($257) − Depreciation ($0) = $33,089
Less: Income Tax$0max(Taxable Income -$572, $0) × 25% marginal rate = $0($130)max(Taxable Income $522, $0) × 25% marginal rate = $130($423)max(Taxable Income $1,692, $0) × 25% marginal rate = $423($1,249)max(Taxable Income $4,995, $0) × 25% marginal rate = $1,249($3,397)max(Taxable Income $13,588, $0) × 25% marginal rate = $3,397($8,272)max(Taxable Income $33,089, $0) × 25% marginal rate = $8,272
Net Income-$572Taxable Income (-$572) − Income Tax ($0) = -$572$391Taxable Income ($522) − Income Tax ($130) = $391$1,269Taxable Income ($1,692) − Income Tax ($423) = $1,269$3,746Taxable Income ($4,995) − Income Tax ($1,249) = $3,746$10,191Taxable Income ($13,588) − Income Tax ($3,397) = $10,191$24,817Taxable Income ($33,089) − Income Tax ($8,272) = $24,817
Cash Flow
Cash Flow Before Tax$4,487NOI ($14,150) − this year's total loan payment(s) (principal + interest) = $4,487$5,349NOI ($15,012) − this year's total loan payment(s) (principal + interest) = $5,349$6,263NOI ($15,926) − this year's total loan payment(s) (principal + interest) = $6,263$8,800NOI ($18,463) − this year's total loan payment(s) (principal + interest) = $8,800$15,149NOI ($24,812) − this year's total loan payment(s) (principal + interest) = $15,149$23,683NOI ($33,345) − this year's total loan payment(s) (principal + interest) = $23,683
Cash Flow After Tax$4,487Cash Flow Before Tax ($4,487) − Income Tax ($0) = $4,487$5,219Cash Flow Before Tax ($5,349) − Income Tax ($130) = $5,219$5,840Cash Flow Before Tax ($6,263) − Income Tax ($423) = $5,840$7,551Cash Flow Before Tax ($8,800) − Income Tax ($1,249) = $7,551$11,752Cash Flow Before Tax ($15,149) − Income Tax ($3,397) = $11,752$15,410Cash Flow Before Tax ($23,683) − Income Tax ($8,272) = $15,410
Balance Sheet
Loan Balance$147,787From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 1 = $147,787.$143,015From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 3 = $143,015.$137,743From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 5 = $137,743.$122,013From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 10 = $122,013.$75,918From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 20 = $75,918.$0From the loan amortization schedule: your starting balance reduced by cumulative principal paid through Year 30 = $0.
Property Value$270,000Value of Property ($270,000) × (1 + 2%)^0 = $270,000$280,908Value of Property ($270,000) × (1 + 2%)^2 = $280,908$292,257Value of Property ($270,000) × (1 + 2%)^4 = $292,257$322,675Value of Property ($270,000) × (1 + 2%)^9 = $322,675$393,339Value of Property ($270,000) × (1 + 2%)^19 = $393,339$479,478Value of Property ($270,000) × (1 + 2%)^29 = $479,478
Loan to Value54.74%Loan Balance ($147,787) ÷ Property Value ($270,000) = 54.74%50.91%Loan Balance ($143,015) ÷ Property Value ($280,908) = 50.91%47.13%Loan Balance ($137,743) ÷ Property Value ($292,257) = 47.13%37.81%Loan Balance ($122,013) ÷ Property Value ($322,675) = 37.81%19.30%Loan Balance ($75,918) ÷ Property Value ($393,339) = 19.30%0.00%Loan Balance ($0) ÷ Property Value ($479,478) = 0.00%
Disposition
Sale Price$270,000Value of Property ($270,000) × (1 + 2%)^0 = $270,000 — the same appreciation used for Property Value.$280,908Value of Property ($270,000) × (1 + 2%)^2 = $280,908 — the same appreciation used for Property Value.$292,257Value of Property ($270,000) × (1 + 2%)^4 = $292,257 — the same appreciation used for Property Value.$322,675Value of Property ($270,000) × (1 + 2%)^9 = $322,675 — the same appreciation used for Property Value.$393,339Value of Property ($270,000) × (1 + 2%)^19 = $393,339 — the same appreciation used for Property Value.$479,478Value of Property ($270,000) × (1 + 2%)^29 = $479,478 — the same appreciation used for Property Value.
Capital Gains Tax($2,250)(Sale Price $270,000 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $2,250($3,886)(Sale Price $280,908 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $3,886($5,589)(Sale Price $292,257 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $5,589($10,151)(Sale Price $322,675 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $10,151($20,751)(Sale Price $393,339 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $20,751($33,672)(Sale Price $479,478 − Purchase Price $250,000 − Acquisition Costs $5,000) × 15% capital gains rate = $33,672
Depreciation Recapture Tax($1,818)Cumulative depreciation claimed through Year 1 × 25% marginal rate = $1,818($5,455)Cumulative depreciation claimed through Year 3 × 25% marginal rate = $5,455($9,091)Cumulative depreciation claimed through Year 5 × 25% marginal rate = $9,091($18,182)Cumulative depreciation claimed through Year 10 × 25% marginal rate = $18,182($36,364)Cumulative depreciation claimed through Year 20 × 25% marginal rate = $36,364($50,000)Cumulative depreciation claimed through Year 30 × 25% marginal rate = $50,000
Disposition Expenses($5,400)Sale Price ($270,000) × 2% expenses on sale = $5,400($5,618)Sale Price ($280,908) × 2% expenses on sale = $5,618($5,845)Sale Price ($292,257) × 2% expenses on sale = $5,845($6,453)Sale Price ($322,675) × 2% expenses on sale = $6,453($7,867)Sale Price ($393,339) × 2% expenses on sale = $7,867($9,590)Sale Price ($479,478) × 2% expenses on sale = $9,590
Net Sale Proceeds$112,745Sale Price ($270,000) − Disposition Expenses ($5,400) − Loan Balance ($147,787) − Recapture Tax ($1,818) − Capital Gains Tax ($2,250) = $112,745$122,934Sale Price ($280,908) − Disposition Expenses ($5,618) − Loan Balance ($143,015) − Recapture Tax ($5,455) − Capital Gains Tax ($3,886) = $122,934$133,989Sale Price ($292,257) − Disposition Expenses ($5,845) − Loan Balance ($137,743) − Recapture Tax ($9,091) − Capital Gains Tax ($5,589) = $133,989$165,875Sale Price ($322,675) − Disposition Expenses ($6,453) − Loan Balance ($122,013) − Recapture Tax ($18,182) − Capital Gains Tax ($10,151) = $165,875$252,439Sale Price ($393,339) − Disposition Expenses ($7,867) − Loan Balance ($75,918) − Recapture Tax ($36,364) − Capital Gains Tax ($20,751) = $252,439$386,217Sale Price ($479,478) − Disposition Expenses ($9,590) − Loan Balance ($0) − Recapture Tax ($50,000) − Capital Gains Tax ($33,672) = $386,217
Rate of Return
Before Tax IRR7.63%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 1, then the before-tax sale proceeds landing one period later = 7.63%9.27%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 3, then the before-tax sale proceeds landing one period later = 9.27%9.69%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 5, then the before-tax sale proceeds landing one period later = 9.69%9.82%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 10, then the before-tax sale proceeds landing one period later = 9.82%9.59%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 20, then the before-tax sale proceeds landing one period later = 9.59%9.36%The IRR on your initial equity ($105,000), each year's Cash Flow Before Tax through Year 30, then the before-tax sale proceeds landing one period later = 9.36%
After Tax IRR5.78%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 5.78%7.41%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 7.41%8.00%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 8.00%8.58%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 8.58%8.94%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 8.94%9.03%Same as Before Tax IRR, but using Cash Flow After Tax and the after-tax sale proceeds, net of capital gains and recapture tax = 9.03%

Estimates only, not financial, tax, or legal advice. See our Terms and Privacy Policy.

Advertisement

A rental property's return comes from several sources at once: rental cash flow, mortgage paydown, tax benefits from depreciation, and appreciation realized at sale, and a single number like 'cap rate' can't capture all of them. A full pro-forma ties them together so you can judge the investment the way a serious buyer would.

This calculator builds that year-by-year pro-forma: income net of vacancy and expenses, mortgage interest and principal, depreciation and taxes, before- and after-tax cash flow, and the net proceeds of a hypothetical sale, rolled up into cash-on-cash return, NPV, and IRR.

How does this calculator work?

Enter the purchase price and financing (up to two mortgages), the rent and vacancy, operating expenses, depreciation, your tax rate, and a hypothetical sale year. The calculator builds a full year-by-year rental property pro-forma.

Gross rent grows every year at the rent inflation rate you enter, and operating expenses (property taxes, insurance, utilities, repairs, HOA, and other costs) inflate separately at their own rate, so the two don't have to move in lockstep.

Interest on each of your mortgages is pulled from a full monthly amortization schedule, then summed into an annual figure. Depreciation is the depreciable basis (purchase price minus land value) divided evenly across your depreciation schedule, 27.5 years for residential or 39 for commercial, with the final, fractional year getting a prorated partial deduction before depreciation stops entirely.

Taxable income is net operating income minus interest and depreciation, taxed at your marginal rate. Unlike our Farmland calculator, a loss year here does not create a tax benefit: the tax floors at zero rather than going negative.

The calculator also tracks your loan balance and the property's appreciating value each year, giving you a loan-to-value ratio. At every single year, it separately models what selling that year would look like: the appreciated sale price, minus your remaining loan balance, minus selling costs, minus capital gains tax on the appreciation, minus depreciation recapture tax on the depreciation you've already claimed.

That sale proceeds figure is combined with every prior year's cash flow into an IRR on your original invested equity, which is why you can pick any hypothetical sell year and see its return immediately, and why the before- and after-tax IRR curves climb as more years of income and appreciation build up.

Headline results include year-1 cash-on-cash return and equity build-up, NPV of the cash flows, tax savings from depreciation, and before- and after-tax IRR through your chosen sell year.

Worked example

A $300,000 rental with $75,000 down, renting for $2,400/month, with typical expenses and a sale modeled in year 10.

Purchase price / down
$300,000 / $75,000
Gross rent
$2,400/mo
Year-1 cash-on-cash
6–9%
Plus equity build-up (yr 1)
from principal paydown
After-tax IRR (10-yr hold)
the headline return

How the numbers work

Start with gross rent: $2,400 × 12 = $28,800 a year. Subtract a vacancy allowance and operating expenses (taxes, insurance, maintenance, management) to get net operating income, then subtract the mortgage payment to reach annual cash flow.

Year-one cash-on-cash is that first-year cash flow divided by the $75,000 you actually invested, typically landing in the 6–9% range once realistic expenses are applied.

The IRR goes further: it discounts every year's cash flow plus the net proceeds of the year-10 sale (after paying off the loan, depreciation recapture, and capital gains) back to your $75,000 outlay, giving the annualized return across the whole hold.

Year-1 cash-on-cash measures only the first year's cash flow against your down payment. The IRR is the fuller picture: it folds in every year's cash flow plus the gain at sale, which is often where most of a rental's return actually comes from.

Small changes in rent, vacancy, or sale price swing the IRR significantly, so it's worth testing a range rather than trusting one optimistic set of assumptions.

Advertisement

Rental Property Calculator glossary

Gross Monthly Rents
Total rent collected each month before vacancy and expenses.
Year 1 Cash on Cash
First-year pre-tax cash flow divided by the cash you invested.
Year 1 Equity Build-Up
First-year mortgage principal paid divided by your invested cash.
NPV of Cash Flows
The future after-tax cash flows discounted to today at your discount rate.
Tax Savings (Depreciation)
The income tax reduced by depreciation deductions over the hold.
Before-Tax IRR
The internal rate of return on your equity including the sale, before taxes.
After-Tax IRR
The same return measured after income taxes.
Net Operating Income (NOI)
Rental income minus vacancy and operating expenses, before mortgage payments and taxes.
Capitalization Rate (Cap Rate)
NOI divided by the property's value: a quick measure of unleveraged yield, independent of financing.
Vacancy Rate
The share of potential rent lost to empty units; subtracted from gross rent to get effective income.
Depreciation Recapture
Tax owed at sale on the depreciation deductions you previously claimed, factored into the after-tax return.

Rental Property Calculator FAQs

What's the difference between cash-on-cash and IRR?+

Cash-on-cash is a single year's pre-tax cash flow divided by your invested cash. IRR accounts for every year's cash flow plus the eventual sale, giving the annualized return over the whole hold.

Why model a sale year?+

Most of a rental's return often comes from appreciation and equity build-up realized at sale. Setting a sell year lets the calculator include net sale proceeds in the IRR and NPV.

Does this account for taxes?+

Yes. It models depreciation deductions, income tax on rental profit, and at sale both depreciation recapture and capital gains, reporting before- and after-tax cash flow and IRR.

Related Calculators