Worksheet 11 · Total return

Investment property calculator

An investment property's total return combines yearly cash flow, mortgage paydown and the profit or loss when you sell. With the example's 25% down, 2% rent growth and no change in price, a $320,000 rental returns 1.60% a year (IRR) over 10 years, mostly from loan paydown rather than cash flow.

Cap Rate Calculator editorial teamUpdated 5 sources

Worksheet 11

Return over the holding period

Every growth figure is your assumption

Purchase and loan

$
%
$
$
%
years

Year-one operations

$
%
$

Your assumptions

years
%
%
%
%
Annualized return (IRR)1.60%over 10 years, your assumptions
Total profit$15,661
Total ROI16.7%profit ÷ cash invested
Equity at sale$115,278
Less: Cash invested($94,000)
Cash flow, years 1–10$13,584
Sale price after 10 years$320,000
Less: Selling costs($19,200)
Less: Loan payoff($204,722)
Net sale proceeds$96,078
Total profit before tax$15,661

IRR if yearly price change were…

-2%0%+2%+4%
(5.5%)1.6%6.6%10.6%

Growth and sale figures are your assumptions, not forecasts. Change them and watch how much the answer moves.

Formula. Profit = total cash flow + (sale price − selling costs − loan balance) − cash invested. ROI = profit ÷ cash invested. IRR = the yearly rate at which the present value of every cash flow, including the sale, equals the cash invested. Before income tax.

Where the return comes from

A leveraged rental produces return from three sources: cash flow each year, the principal you pay down on the loan, and any change in the property's value when you sell. This calculator keeps them separate so you can see which one carries the result.

The example over 10 years
ComponentAmount
Cash invested (down payment, closing, repairs)($94,000)
Cash flow, years 1–10$13,584
Loan paid down$35,278
Price change at 0% a year$0
Selling costs at 6%($19,200)
Total profit before tax$15,661
Total ROI16.7%
Annualized return (IRR)1.60%

ROI vs IRR

Total ROI is profit divided by the cash invested, with no regard to time. The internal rate of return (IRR) is the discount rate at which the present value of all the cash flows, including the sale, equals the money put in, so it accounts for when each dollar arrives. It can be measured on the property alone (NOI and net sale price) or on your equity (cash flow after the loan), which is what this worksheet does.[1]

0=−Cash invested + CF1(1 + IRR) + … + CFn + sale proceeds(1 + IRR)n

A 50% ROI earned over 3 years is far better than the same ROI over 15. The table shows how the IRR changes with the holding period, everything else unchanged:

Years heldTotal profitTotal ROIIRR
5($16,666)-17.7%-3.83%
10$15,66116.7%1.60%
15$67,16671.5%3.91%

Your assumptions drive the answer

Rent growth, expense growth and the property's future price are guesses. The example sets the price change to zero on purpose, so the result reflects only what is known today. The results panel recalculates the IRR at price changes of −2%, 0%, +2% and +4% a year, so you can see how much of any projected return depends on appreciation. Property values can fall,[3] and past performance does not necessarily predict future results.[2]

Before income taxThese figures ignore income tax on rental profits and on the sale. In the U.S., a gain on selling a rental held more than a year is generally a long-term capital gain, and the part that comes from depreciation taken (unrecaptured section 1250 gain) is taxed at up to 25%.[4] The tax on sale of rental property calculator estimates it.

Financing limits

The down payment is not entirely your choice: Fannie Mae's eligibility matrix caps a one-unit investment purchase at 85% loan-to-value and a two- to four-unit purchase at 75%, so at least 15% or 25% down.[5] Change the down payment to see how leverage raises or lowers the IRR at your interest rate.

To pull equity out of a property you already own, see the cash-out refinance calculator. For a single year, use the rental property calculator; for valuing a property by its future income instead of measuring your return, use the discounted cash flow calculator; for the year-one cash return alone, the cash-on-cash return calculator.

Frequently asked questions

How do you calculate ROI on a rental property?

Add up the cash flow over the years you own it and the net proceeds from selling (sale price minus selling costs minus the loan balance), subtract the cash you invested, and divide by that cash.

What is the difference between ROI and IRR?

ROI ignores time; IRR is an annual rate that accounts for when each cash flow arrives. Use IRR to compare investments held for different lengths of time.

Does this include appreciation?

Only if you enter it. The default price change is 0% a year, and the results show the IRR at several other rates for comparison.

Is loan paydown a return?

Yes, but you only receive it when you sell or refinance. That is why it appears in the sale proceeds rather than in yearly cash flow.

Sources

  1. Etter, W. E. Expected Rate of Return: More than Interest (Publication 1145) · Real Estate Center at Texas A&M University, Fall 1996
  2. Investor Bulletin: Performance Claims · U.S. Securities and Exchange Commission, Investor.gov, September 15, 2022
  3. Buying an investment property · ASIC Moneysmart, September 29, 2026
  4. Topic no. 409, Capital gains and losses · Internal Revenue Service, reviewed November 9, 2026
  5. Eligibility Matrix · Fannie Mae, August 5, 2026