Internal Rate of Return

Internal Rate of Return (IRR) is the annualized discount rate that sets the net present value of all cash flows from a note investment — purchase price, monthly payments, workout costs, and final proceeds — equal to zero. Unlike simpler metrics such as cash-on-cash return, IRR accounts for the time value of money, giving investors a single percentage that reflects both the magnitude and timing of every dollar in and out. It is the standard benchmark professional note investors use to compare deals with different hold periods, payment structures, and resolution paths.

How IRR Works in Note Investing

IRR answers a specific question: "What annualized rate of return am I earning on the capital I have deployed, given when I deploy it and when I get it back?" The calculation considers:

• Initial outflow — the purchase price plus any closing costs (due diligence, legal, assignment fees)
• Periodic inflows — monthly principal and interest payments received
• Interim outflows — servicing fees, legal costs, property preservation, property taxes advanced
• Terminal inflow — the final event that closes the investment, whether a full payoff, discounted payoff, note sale, or foreclosure liquidation

Because IRR is solved iteratively (there is no closed-form formula), investors typically use a spreadsheet function like Excel's XIRR, which handles irregular cash flow dates.

IRR for Performing vs. Non-Performing Notes

The way IRR behaves differs significantly between asset types:

For a performing loan, IRR is relatively straightforward to model because payments follow the amortization schedule. The investor's IRR is primarily a function of the discount paid at purchase and the remaining term.

For a non-performing loan, IRR projections require assumptions about workout timelines, legal costs, and recovery values. A projected 30% IRR can quickly drop to single digits if a judicial foreclosure drags on for three years instead of one. This is why experienced NPL investors model multiple scenarios — best case, base case, and worst case — rather than relying on a single IRR projection.

IRR vs. Other Return Metrics

IRR is powerful but not the only metric that matters. Investors should evaluate it alongside complementary measures:

• Cash-on-Cash Return: Measures annual cash income as a percentage of cash invested. Useful for understanding current yield but ignores the timing of the final payoff.
• ROI: Total profit divided by total investment. Simple but does not account for how long capital was deployed.
• Equity multiple: Total cash received divided by total cash invested. Shows absolute return but strips out the time dimension.

A note that returns 1.5x over 18 months has a much higher IRR than one returning 1.5x over five years, even though the equity multiples are identical. This is exactly the kind of distinction IRR captures and simpler metrics miss.

Practical Tips for Using IRR

• Use XIRR, not IRR. The standard IRR function assumes equal periods between cash flows. XIRR handles actual dates, which matters when payments are irregular or when modeling NPL workouts.
• Stress-test your timeline. Add three to six months to your expected resolution and see what happens to IRR. If the deal no longer meets your threshold, the margin of safety is thin.
• Include all costs. Legal fees, servicing costs, property preservation, and assignment recording fees all reduce IRR. Omitting them inflates projected returns and leads to bad purchase decisions.
• Set a minimum hurdle rate. Many note investors use a 12%--15% IRR floor for performing notes and 18%--25% for NPLs. Your threshold should reflect your cost of capital, time commitment, and risk tolerance.