The model is confessing. Read it that way.
Every spreadsheet has one or two numbers quietly carrying the sales pitch. Find them before they start carrying your money.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "IRR, finally explained clearly." It is knowing what you would verify next.
IRR is the discount rate that makes the present value of all cash flows equal zero.
That sentence is technically correct and spiritually useless.
Here is the human version: IRR rewards getting money back sooner. Same total profit, faster timing, higher IRR.
IRR is a stopwatch. It measures when investor cash goes out and when it comes back. It does not inspect the property, grade the operator, or ask whether the early distribution came from durable operations or a new loan. A fast reading can be real. It can also be bought with a fragile assumption and excellent posture.
Two cases, one finish line
Assume $100,000 is invested.
| Year | Case A cash flow | Case B cash flow |
|---|---|---|
| 1 | $5,000 | $0 |
| 2 | $5,000 | $0 |
| 3 | $5,000 | $0 |
| 4 | $5,000 | $0 |
| 5 | $150,000 | $170,000 |
| Total cash returned | $170,000 | $170,000 |
Both cases return the same total dollars. Case A usually shows a higher IRR because some cash arrives earlier.
That is not a scam. It is just what IRR measures. The stopwatch favors Case A even though the finish-line total is identical.
Where the stopwatch gets helped
IRR can look impressive when:
- A refinance returns capital early.
- The hold period is short.
- Sale timing is aggressive.
- Early distributions are modeled before the property has earned them.
- A large exit value sits on a friendly cap rate.
The metric is sensitive to timing. That makes it helpful for comparing cash-flow patterns and dangerous when the timing itself is fragile.
You should not punish IRR for having a narrow job. You should punish the return summary that hires it as a character witness.
The refinance can be the starter pistol
Suppose a model returns 50% of investor capital in year two through a refinance. IRR may jump because the clock loves early cash.
Now delay that refinance to year four, reduce proceeds, or remove it entirely. If the return story changes from “strong” to “awkward,” the refinance was not a side event. It was the engine.
Trace that event through the loan assumptions, refinance proceeds, debt payoff, closing costs, lender reserves, and distribution waterfall. A cell labeled “refi” is not evidence that a lender will hand over the modeled amount on the modeled date.
Run the clock three ways
Run three IRR versions:
| Case | Change |
|---|---|
| Base case | Sponsor timing |
| Delayed case | Refinance or sale happens 12 months later |
| No-refi case | Cash flows continue without early capital return |
Then compare equity multiple beside IRR. If IRR is the hero but total dollars are mediocre, you have learned something.
Ask three questions while the cases are beside each other:
- Which dated cash flow creates most of the IRR?
- Which document supports its amount and timing?
- What happens to investor cash if that event is late, smaller, or absent?
The useful answer is not “IRR falls.” Of course it falls. The useful answer names the assumption that moved, the document that supports it, and the cash consequence if it misses.
Find the split second doing all the work
When someone leads with IRR, ask what cash flow event creates it. Timing is not a footnote. In IRR math, timing is the plot.
Your next move is simple: take the dated investor cash-flow schedule, mark the refinance and sale dates, and rerun each one 12 months late. If the deal loses its entire personality when the stopwatch slips, write that down before you admire the headline.
PR Steinfurth Equity provides educational information only. Nothing on this website is an offer to sell or a solicitation of an offer to buy any security, nor investment, legal, or tax advice. Any securities offering is made only to qualified investors through official offering documents. Real estate investments involve risk, including possible loss of principal. Past performance is not indicative of future results.