Deal terms and returns
IRR and Equity Multiple Calculator for Real Estate
The three numbers
- Equity multiple
- Total cash back / investment
- IRR
- Rate where NPV of all cash flows = 0
- Cash-on-cash
- Yearly distribution / investment
- Default example
- 1.68x, 11.98% IRR, 6% cash-on-cash
Computed by Relli; illustrative.
An IRR and equity multiple calculator turns a real estate investment's cash flows into two numbers.
IRR, a year
11.98%
- Equity multiple
- 1.68x
- Average cash-on-cash
- 6.00%
- Total cash back
- $168,000
- Profit
- $68,000
How this is calculated
IRR is the yearly rate at which the cash you get back, discounted to today, equals the cash you put in (NPV = 0). It uses the same yearly cash flows as Excel or Google Sheets =IRR(), solved here by bisection.
Equity multiple = total cash back (distributions plus sale proceeds) / investment.
Average cash-on-cash = average yearly distribution / investment. Sale proceeds are left out.
Assumes each payment arrives at the end of its year. Taxes are ignored.
Illustration only, not investment or tax advice; actual results depend on each offering's documents.
The short answer
An IRR and equity multiple calculator turns a real estate investment's cash flows into two numbers: the equity multiple, total cash back divided by cash in, and the IRR, a yearly rate that accounts for when the cash arrives. $100,000 that pays $6,000 a year for five years plus $138,000 at the sale is a 1.68x multiple and an 11.98% IRR.
The three numbers
- Equity multiple
- Total cash back / investment
- IRR
- Rate where NPV of all cash flows = 0
- Cash-on-cash
- Yearly distribution / investment
- Default example
- 1.68x, 11.98% IRR, 6% cash-on-cash
Computed by Relli; illustrative.
- Multiple = cash back / cash in. $168,000 back on $100,000 is 1.68x, whenever the cash arrives.
- IRR prices the timing. The same 1.68x is a 15.28% IRR with early cash and 8.84% over seven years in Relli's example.
- Enter your cash, not the property's. Use distributions after fees and the promote, and your share of the sale.
- Same math as Excel's IRR. Year-end yearly cash flows; it shows n/a when no single rate fits.
How to use it
How do you use this IRR and equity multiple calculator?
Enter what you invest, the cash you expect back at the end of each year, and your share of the sale proceeds in the final year. Add or remove years with the buttons, up to ten. The results card updates as you type and shows four numbers:
- IRR: the yearly rate at which the cash you get back, discounted to today, equals what you put in.
- Equity multiple: total cash back, distributions plus sale proceeds, divided by the investment.
- Average cash-on-cash: the average yearly distribution divided by the investment, with the sale left out.
- Total cash back and profit in dollars.
The IRR uses the same yearly cash flows as Excel's IRR function, which Microsoft says needs "at least one positive value and one negative value" and cash flows "at regular intervals." The calculator shows "n/a" instead of a number when no money comes back, when more than one rate fits the cash flows or when no rate between -99.9% and 1,000% a year fits, as with a near-total loss.
For what each metric means and what counts as good, see the guide to equity multiple, IRR and cash-on-cash return.
Worked example
Why can the same equity multiple have different IRRs?
Because the equity multiple ignores time and IRR does not. Every row below turns $100,000 into $168,000, a 1.68x multiple, but the cash arrives on different schedules.
Worked example
Four ways to get $168,000 back on $100,000. Enter any row in the calculator to check it.
| Cash back | Hold | Cash-on-cash | IRR |
|---|---|---|---|
| $20,000 a year, $68,000 at sale | 5 years | 20% | 15.28% |
| $6,000 a year, $138,000 at sale | 5 years | 6% | 11.98% |
| Nothing until $168,000 at sale | 5 years | 0% | 10.93% |
| $6,000 a year, $126,000 at sale | 7 years | 6% | 8.84% |
Same profit, IRRs from 8.84% to 15.28%: earlier cash and a shorter hold raise the IRR.
Read the two numbers together. A high IRR on a low multiple can mean a quick, small profit; a high multiple on a low IRR can mean a big profit that took a long time. Neither alone says whether a deal is better.
From an offering
Which numbers should you enter from a real estate offering?
Enter the cash you would receive as an investor, not the property's cash flow. In a syndication that means:
- Investment: your commitment, the amount you wire at closing.
- Yearly distributions: your projected share of cash flow after the asset management fee and any split with the sponsor. If the offering shows a cash-on-cash target, multiply it by your investment.
- Sale proceeds: your share after the loan payoff, sale costs and the sponsor's promote.
If the offering quotes a preferred return and a split instead of net figures, run those terms through the syndication returns calculator first. To check the property price behind the projections, use the cap rate calculator.
Ask the sponsor three things before comparing a projected IRR with another deal's: is it levered, is it net of fees and the promote, and what exit cap rate does it assume? A projection is a target, not a result; check it against the sponsor's realized track record. You can try it on real offerings: each one on Relli's investments page shows the sponsor's target terms.
Limits
What does this calculator not account for?
It keeps the math simple so you can see what drives the result. It assumes every payment arrives at the end of its year, as Excel's IRR does. Real distributions are often quarterly or monthly, which lifts the IRR slightly. Excel's XIRR function handles actual dates; Microsoft describes it as an IRR "for a schedule of cash flows that is not necessarily periodic."
It also ignores taxes, which can matter as much as the timing: depreciation often shelters distributions, while the sale can bring capital gains and depreciation recapture. The guide to real estate tax benefits covers both. A capital call can be entered as a negative amount in its year.
Short answers
What else do people ask about IRR and equity multiple?
How do you calculate the equity multiple?
Add up all the cash you receive, every distribution plus your share of the sale, and divide by the cash you invested. $168,000 back on $100,000 is 1.68x. A multiple of 1.0x means you got your money back with no profit.
Why does the calculator show n/a for IRR?
IRR needs money going in and money coming back. It shows n/a when nothing comes back, when the cash flows switch between negative and positive more than once and two or more rates fit, or when no rate between -99.9% and 1,000% a year works, as with a near-total loss.
Does this match Excel's IRR function?
Yes, for the same yearly cash flows: year 0 is the investment as a negative number, then each year's cash, with the sale added to the last year. The calculator solves by bisection rather than Excel's iterative guess, so it does not need a starting guess.
Why does a longer hold lower the IRR?
IRR is a yearly rate, so the same profit spread over more years earns less per year. In the example, $68,000 of profit is an 11.98% IRR over five years and 8.84% over seven.
Is cash-on-cash return the same as IRR?
No. Cash-on-cash is one year's distribution divided by the investment and leaves out the sale. IRR uses every cash flow, including the sale, and their timing. A deal can pay 6% cash-on-cash and still have an IRR near 12% if the sale adds a profit.
Sources
- IRR function, Microsoft Support (accessed Nov 12, 2026)
- XIRR function, Microsoft Support (accessed Nov 12, 2026)
- 11.431J Real Estate Finance and Investment: cash flow pro formas, MIT OpenCourseWare (Fall 2006)
- The Nuts and Bolts of Private Commercial Real Estate (CRE) Investing, CFA Institute Enterprising Investor (Apr 7, 2023)
- Subscription Lines of Credit and Alignment of Interests, Institutional Limited Partners Association (Jun 2017)
- Private Investment Fund Terms: Fees and Distribution Waterfall, Cambridge Associates (Aug 27, 2024)
