IRR (Internal Rate of Return)

Project IRR

Project IRR (Project Internal Rate of Return) is the internal rate of return calculated on a project's total cash flows before any financing costs — that is, before debt drawdowns, interest payments, principal repayments, and equity contributions. It represents the unlevered return of the underlying project, independent of how it is financed. Project IRR answers the question: what return does the project generate on the capital deployed in it, regardless of whether that capital is debt or equity? This distinguishes it from Equity IRR, which is calculated on cash flows net of all financing — the return received by equity investors after debt has been serviced. The Project IRR formula is the same as the standard IRR formula: Where: - C_t is the total project cash flow in period t (pre-financing) - r is the Project IRR In Excel: XIRR is the correct function for project finance applications where cash flows occur at irregular intervals.

Equity IRR

Equity IRR (Equity Internal Rate of Return) is the discount rate at which the net present value of all equity cash flows — comprising the initial equity investment as a negative cash flow and subsequent distributions and terminal proceeds as positive cash flows — equals zero. It measures the annualised return earned by equity investors on capital contributed to a project or transaction, calculated on post-debt-service cash flows only. Equity IRR is distinct from Project IRR, which is calculated on total project cash flows before financing. Equity IRR is always higher than Project IRR in a positively leveraged transaction because debt amplifies equity returns. It is lower than Project IRR when leverage is negative — that is, when the cost of debt exceeds the unlevered return of the project.

Terminal Value

Terminal value (TV) is the estimated value, at the end of a financial model's explicit forecast period, of all cash flows that the asset or business is expected to generate beyond that period. In a discounted cash flow (DCF) analysis, the terminal value represents the present value of the perpetuity of cash flows from the terminal period onwards, discounted back to the valuation date. Terminal value is the single largest component of total enterprise value in most DCF analyses. It is typically significant because a business or asset's cash flow-generating life extends far beyond a practical explicit forecast period of 5 to 10 years.

WACC (Weighted Average Cost of Capital)

WACC (Weighted Average Cost of Capital) is the rate of return that a company must earn on its existing assets to maintain the value of its equity and satisfy both its debt holders and equity investors. It is calculated as the weighted average of the after-tax cost of debt and the cost of equity, with the weights determined by the proportion of each in the total capital structure. WACC is used primarily as the discount rate in a discounted cash flow (DCF) valuation, where it converts projected free cash flows into present value. It is also used as a return hurdle: a project or investment is value-creating if its expected return exceeds the WACC.

Investment Analysis and Capital Budgeting

Investment analysis and capital budgeting is the discipline of deciding whether a project or investment is expected to create value, using a toolkit of quantitative techniques — net present value, internal rate of return, modified internal rate of return, payback period, and the profitability index — each applied to the same underlying forecast cash flow series but answering a subtly different question. This page is the hub for the Knowledge Centre's investment analysis content: what each technique measures, how the techniques relate to and sometimes conflict with one another, how discount rates and hurdle rates are set, how risk is layered onto the analysis through sensitivity, scenario, and Monte Carlo methods, and — distinctively — how capital-budgeting failure modes map onto FMAE's existing structural audit rule taxonomy.

MIRR (Modified Internal Rate of Return)

Modified Internal Rate of Return (MIRR) is a capital budgeting metric that corrects two specific weaknesses of IRR — its implicit assumption that interim cash flows are reinvested at the IRR itself, which is often unrealistic, and its potential to produce multiple or no real solutions for a non-conventional cash flow series. MIRR resolves both by using an explicit finance rate for outflows and a separately specified reinvestment rate for inflows, producing a single, more defensible rate of return.

NPV vs. IRR

Net present value (NPV) and internal rate of return (IRR) are the two most widely used capital budgeting metrics, calculated from the same underlying cash flow series, and they usually agree on whether a single, standalone project should be accepted. They can disagree, however, on how to rank mutually exclusive projects of different scale or cash flow timing, and IRR carries additional technical limitations — a reinvestment assumption embedded in the rate itself, and the possibility of multiple or no real solutions for a non-conventional cash flow series — that NPV does not share. Institutional practice generally defers to NPV when the two conflict.

MIRR vs. IRR

Internal rate of return (IRR) and modified internal rate of return (MIRR) both express a project's return as a single percentage figure calculated from the same underlying cash flow series, but they differ in a specific and consequential way: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself for the remainder of the project's life, an assumption that is often unrealistic, particularly for projects with a high IRR. MIRR replaces this implicit assumption with two explicit, separately specified rates — a finance rate for outflows and a reinvestment rate for inflows — producing a single, more defensible rate of return and eliminating the possibility of multiple or no real solutions for a non-conventional cash flow series.