The internal rate of return (IRR) is the discount rate at which the net present value (NPV) of all cash flows from an investment equals zero. It represents the annualised rate of return an investment is expected to generate. FP&A teams use IRR to rank investment opportunities and compare projects of different scales and durations.
Formula
IRR is the rate r that satisfies: NPV = Sum of [Cash Flow_t / (1+r)^t] = 0In Depth
IRR is one of the most sophisticated capital budgeting metrics used by FP&A teams. While ROI gives a simple percentage return, IRR accounts for the time value of money and the specific timing of cash flows, making it a more accurate measure of investment performance.
Conceptually, IRR answers the question: "What annualised rate of return does this investment earn?" If a project has an IRR of 18%, it is equivalent to earning 18% per year on the invested capital, accounting for the timing of all inflows and outflows.
The decision rule is straightforward: accept investments where IRR exceeds the company's cost of capital (hurdle rate). If the hurdle rate is 12% and a project's IRR is 18%, the project creates value. If IRR is 8%, the project destroys value relative to the cost of funding it.
IRR is particularly useful for comparing projects of different sizes and durations. A small project might have higher IRR than a large one, even if the large project has higher NPV. This distinction between IRR (rate of return) and NPV (total value created) is important for capital allocation.
However, IRR has limitations. It can produce multiple solutions for projects with non-conventional cash flows (alternating positive and negative). It assumes interim cash flows are reinvested at the IRR itself, which may be unrealistic. Modified IRR (MIRR) addresses this by assuming reinvestment at the cost of capital.
For UK businesses, IRR calculations should use after-tax cash flows that reflect corporation tax payments, capital allowance benefits, and any available tax incentives like R&D tax credits or the Enterprise Investment Scheme.
Real-World Example
A UK manufacturing company evaluates two CapEx projects. Project A: £500K investment generating £150K annually for 5 years (IRR = 15.2%). Project B: £200K investment generating £70K annually for 4 years (IRR = 14.9%). While Project A has higher NPV at the 10% hurdle rate (£68.6K vs £21.9K), the similar IRRs suggest both are attractive. The FP&A team recommends both, given available capital.
Related Terms
Return on investment (ROI) measures the gain or loss generated by an investment relative to its cost...
Net present value (NPV) is the difference between the present value of future cash inflows and the p...
Weighted average cost of capital (WACC) represents the average rate a company must pay to finance it...
Cost of capital is the required rate of return a company must earn on its investments to maintain it...
A DCF (Discounted Cash Flow) model values a company or project by projecting future free cash flows ...
Stop wrestling with spreadsheets. Grove FP gives your finance team a purpose-built platform for budgeting, forecasting, and financial modelling — designed for UK businesses.
FAQ