Same multiple, different returns
| Hold | Cash flows on $10M equity | Total back | Equity multiple | IRR |
|---|---|---|---|---|
| 3 years | $0.5M, $0.5M, then $15.5M | $16.5M | 1.65x | 18.9% |
| 5 years | $0.5M a year, plus $14M at sale | $16.5M | 1.65x | 11.4% |
| 7 years | $0.5M a year, plus $13M at sale | $16.5M | 1.65x | 8.3% |
Every deal returns the same $16.5M. The only difference is when it comes back, and IRR captures that where the multiple doesn't.
The formulas
Equity multiple = total cash distributions ÷ total equity invested. It ignores time.
IRR is the discount rate that makes the net present value of all cash flows equal zero. In Excel, use =IRR() for annual cash flows, or =XIRR() with exact dates. There's no simple closed-form formula.
When each one misleads
| Metric | Weakness | How to catch it |
|---|---|---|
| IRR | An early sale or refinance can produce a high IRR with little total profit | Check the multiple and dollars earned |
| IRR | Assumes you can do as well with distributions, which isn't always possible | Ask what you'd do with the cash |
| IRR | Heavily dependent on the exit cap rate and timing | Run the sensitivities |
| Equity multiple | Looks the same whether it took 3 years or 10 | Check the hold period and IRR |
| Equity multiple | Doesn't show risk or how the income arrives | Look at cash flow year by year |
Take a quick example. Doubling $1M in a year is a 100% IRR and $1M of profit. Turning $10M into $16.5M over five years is an 11.4% IRR and $6.5M of profit. Which is better depends on what you'd do with the money next.
Other measures to read with them
- Cap rate: the unlevered one-year income yield.
- Cash-on-cash return: annual cash flow divided by equity invested, for a read on current income.
- DSCR and debt yield: financing risk.
Check how much of the return is from selling
In the five-year example, $14M of the $16.5M comes from the sale. That makes this deal highly sensitive to exit NOI and the exit cap rate. On $840,000 of exit NOI at 6%, value is $14M. At 7%, it falls to $12M, a $2M drop with no change in operations. Investors can't control the exit cap rate. They can control the NOI, which is the part that compounds through to value.
What asset managers should report
Show actual returns against the original underwriting, and split the variance between operations and market movement. It keeps the discussion honest. If you can't trace results to specific operating lines, start with a clean T12 and our NOI leakage process. We provide audit-ready data to support this.
