Estimate the internal rate of return for a series of cash flows.
IRR is the discount rate r where: 0 = Σ [Cash flow at time t ÷ (1 + r)^t]The calculator applies the relevant rate-of-change, discounting or return relationship to the entered values and time period. Cash-flow timing, compounding, fees, taxes and inflation must be entered or evaluated separately unless the tool provides a field for them.
Use an IRR Calculator to determine an investment, project, acquisition or other stream of cash flows. Typically, the calculator accepts an initial cash outflow, followed by all future projected inflows or outflows, positive or negative. It then outputs the discount rate required to set the cash flows at a present value equal to zero. It is useful for businesses to make investment decisions, analyze capital projects, determine future returns, and find out whether a given future return meets an internal threshold for decisions.
All IRR calculations are derived from cash flows- not accounting revenue or profit. Inputting sales revenue and not deducting related cash expense will cause the return calculation to be in serious error.
The IRR Calculator calculates discount rate that results in the present values of cash inflows equaling present values of cash outflows. Net Present Value equals 0 at the IRR.
A limitation of just looking at a rate of return is that IRR also considers how much the returns are and when they are received. Early dollars impact the IRR more significantly than later dollar amounts because each dollar amount is discounted back in time depending on when the cash flow arises.
There is generally no easy to solve algebraically for IRR with multiple cash flows. The calculator therefore, uses a numerical iterative approach to determine the rate that equates the NPV to 0 to the closest degree.
The established internal rate of return equation is:
0 = CF0 + CF1 ÷ (1 + r)^1 + CF2 ÷ (1 + r)^2 + ... + CFn ÷ (1 + r)^n
Where:
The value of r that makes the equation equal to zero is the IRR.
There is generally no easy to solve algebraically for IRR with multiple cash flows. The calculator therefore, uses a numerical iterative approach to determine the rate that equates the NPV to 0 to the closest degree.
Consider a U.S. Firm's evaluation of a new project proposal for an asset that requires an initial cash outlay of $100,000. Management estimates that the new asset would provide net cash flows over a four-year period.
Inputs:
| Period | Cash Flow |
|---|---|
| Initial investment | -$100,000 |
| Year 1 | $25,000 |
| Year 2 | $30,000 |
| Year 3 | $35,000 |
| Year 4 | $40,000 |
Formula:
0 = -100,000 + 25,000 ÷ (1 + r) + 30,000 ÷ (1 + r)^2 + 35,000 ÷ (1 + r)^3 + 40,000 ÷ (1 + r)^4
Calculation:
Solving the equation numerically gives:
IRR ≈ 10.48%
Result: The estimated internal rate of return for the project is approximately 10.48% per year because the cash flows are annual.
The time value, or present value of anticipated future revenues is equal to the initial $100,000 investment at a discount rate of roughly 10.48%. The firm can compare this with its own required rate of return or assumptions regarding cost of capital in evaluating the project.
The IRR is defined as the discount rate at which all cash flows can be received by; in other words, it is the discount rate at which the net present value is zero. This means that a higher IRR corresponds to higher cash flows being supported and thus a project having a wider range to have a net present value that is positive
Generally, the IRR should be measured against appropriatehurdle rate, required rate of return, or cost of capital instead of against absolute benchmark values. Decision-making threshold will differ across firms, risks, leverage, industries, investment types, and business cycles.
If IRR is higher than that that would not be acceptable for a given project, it might be acceptable to further evaluate. If IRR is lower than desired it might be somewhat acceptable. The IRR decision should not be made on its own due to the fact size, risk, and liquidity of the project; as well as financing of the project; and total dollar value of the project.
An initial higher cash outlay will most likely decrease IRR if the future cash flows are constant. So misstating the initial cash outlays of a project may show an investment is desirable when it is not.
Receiving larger cash inflows earlier rather than later tends to improve the IRR, assuming other cash flows are the same. Precision in receiving money earlier is important because IRR uses a time value of money calculation in each period.
The higher the net cash inflow the higher the IRR; lower cash inflows and additional cash outlays in the future will decrease the IRR. Cash flows estimates used should be net, not net sales.
Sale proceeds at termination, scrap value of equipment, recovery of working capital, or the final-period cash flows can significantly impact IRR-include it if it is a credible assumption based on the projected economics.
After the initial investment, a project may require a cash injection in the form of a later cash outlay that contributes to a future maintenance, extension or working capital; if this is forgotten then the IRR will be overstated
Projects, such as investment in equipment, facility expansions and software developments, etc., allow a comparison to be made between the calculated IRR for that particular long-term investment and target criteria of the business.
IRR is presented as a percentage, allowing for better comparison among different cash flow projects. Nonetheless, percent return should be considered relative to the size of the project and value added.
The acquirer can treat the purchase price as the initial out-flow and make projections for operating cash flows, and potentially one future realization. IRR indicates the implied return at these projections.
A typical use for IRR is where there is an initial expense followed by a number of later cash inflows such as in property investment, the expansion of a warehouse, a major ecommerce infrastructure project, etc
Analysts can re-perform IRR calculations based conservative, base and optimistic case cash flow assumptions in order to see how sensitive the investment case is to alterations to revenue, costs, timing or terminal value.
IRR and ROI both address returns on investments but in slightly different ways. Generally, ROI represents the comparison of total return to investment, whereas IRR incorporates timing, multiples streams of cash flows, and is expressed as a periodic rate.
Two projects can have similar total ROI but different IRRs if one generates cash sooner. For investments with multiple cash flows over several periods, IRR can provide timing information that a basic ROI calculation does not.
IRR is when NPV equals zero (the interest rate that causes npv to equal 0.) NPV simply calculates dollar amount created or lost over a period of time using an interest rate decided upon by the analyst.
These two metrics can even provide different preferences on certain competitive projects, particularly when two or more projects vary drastically in their magnitudes, the time-paths of cash flows, and the periods in which cash flows are generated. A project with a higher IRR doesn't result in a larger total dollar amount added.
Imagine three different investment opportunities that demand an initial outflow of $100,000 cash each, but generate cashflows at differing points in time.
| Scenario | Cash Flow Pattern | Likely Effect on IRR |
|---|---|---|
| Earlier cash generation | More cash received in Years 1 and 2 | Generally higher |
| Evenly distributed cash | Similar cash flow each year | Depends on total cash generated |
| Back-loaded returns | Most cash received near the end | Generally lower, all else equal |
It is clear why IRR cannot be worked out on total cash received without considering other factors such as cash flows. The timing of the cash is taken into account here.
It is clear why IRR cannot be worked out on total cash received without considering other factors such as cash flows. The timing of the cash is taken into account here.
If cash flows fluctuate between positive and negative several times the equation may result in more than one mathematically correct IRR, in some occasions it may be meaningless.
Consider an initial investment, then a number of positive cash flows, but finally a significant negative shutdown costs in future - this is a non-conventional cash flow pattern. In this case it would be preferable to use NPV analysis or another return measure to make a comparison more clear.
The calculated IRR reflects the time period within which cash flows occur. An IRR generated using monthly cash flows, will be a monthly IRR. An IRR using quarterly cash flows, will be a quarterly IRR.
Do not simply assume a monthly IRR is an annual IRR. To determine the effective annual rate for a given periodic return, compound:
Effective Annual Rate = (1 + Periodic IRR)^m − 1
Where m is the number of periods per year. For monthly cash flows, m = 12.
To calculate IRR it gives the rate, or IRR percentage per cash-flow period, at which the net present value of a stream of cash flows is zero.
ROI calculates the benefit against the input while IRR take into consideration the timing of several cash streams and calculate the periodical return rate.
Yes. It can also occur if none of the cash inflows in the investment generate enough value to offset a positive discount rate at the assumptions provided.
Yes, if you have a cash-flow stream which alternates from positive to negative and from negative to positive more than once, you may have more than one answer to the IRR equation.
Not necessarily. A greater IRR reflects a higher percentage discount rate above which to break-even, yet takes no notice of the actual dollar amount, overall magnitude and strategic importance, risk etc of the investment.
This results in earlier cash flows being discounted for fewer periods, the same cash flows are therefore worth more at the earlier point in time. This may cause NPV to hit zero faster.
Calculate the measure using the expected values, then change the time period, cost or ending value. A second scenario helps show whether the result is driven by performance, timing or the initial amount.
Compared with the payback period or NP V method, the IRR is especially sensitive to timing of cash inflows rather than its quantity. For example, if two investments have the same total inflow of cash then IRR could still be varied and in that scenario, which one that you can get back cash from the early time will always have a higher IRR.
| Investment Pattern | Initial Investment | Early Cash Flow | Later Cash Flow | IRR Impact |
|---|---|---|---|---|
| Front-loaded | -$100,000 | $70,000 in Year 1 | $70,000 in Year 3 | Higher relative to later cash flows |
| Back-loaded | -$100,000 | $0 in Year 1 | $140,000 in Year 3 | Lower relative to earlier cash flows |
The examples had the same total future cash inflow. However the cash flow streams had a different timing. As each of the cash inflows are discounted according to its duration the period when the recovery occurs can have a significant impact.
The IRR is measured as percentage of profit return not value created amount (absolute). This makes two projects which has significantly different level of investment can resulted to extremely differ or not too much IRRs without knowing which of them is more valuable in term of dollar value.
| Project | Initial Investment | Total Future Cash Inflows | IRR | What to Compare |
|---|---|---|---|---|
| A | $25,000 | $40,000 | Depends on timing | Percentage return and dollar gain |
| B | $250,000 | $350,000 | Depends on timing | Percentage return and dollar gain |
When projects differ greatly in scale, the IRR should be assessed with NPV, and the actual dollar volume of value created by expected.
IRR is derived from the projects cash flows and need not be automatically equated to the rate at which interim cash distributions are reinvested.
However, with, for example, cash generation in Years 1 and 2 and recapture of the initial outlay much later on. The calculated IRR represents the return implied by these cash flows but it may be the case that it actually reinvests the intervening cash flow at a different rate to the calculated.
IRR can also be compared with an acceptable Hurdle Rate/ Required Return within the company. Question is, does the expected cash flow support a return that is greater than required by the company.
| Projected IRR | Required Return | Basic Interpretation |
|---|---|---|
| 8% | 10% | IRR is below the required return |
| 10% | 10% | IRR equals the required return |
| 14% | 10% | IRR is above the required return |
This is a mathematical argument, not a global principle of investing. The required return in business decisions (hurdle rate) should take into account the company's goals, risk levels, cost of financing, and nature of the business project.
The IRR for projects that realize most of their value at the final selling price, terminal value, etc. Can be very sensitive to the assumption related to that last cash inflow. This is exacerbated if most of the cash flow in the model for a project comes at the end of the modeled cash flow period.
If employing a terminal value, sensitivity test by varying the terminal value above and below. This could highlight if the investment argument hinges on operating cash flows, or is based on an anticipated exit.
An historical IRR uses past, existing cash flows whereas a forecast IRR will rely on all or in part on forecast cash flows and these do not necessarily carry the same degree of reliance.
Historical figures can add up the prior investment's actual performance-they do not prove that the same amount of return will be generated in the future. Projected IRR relies even more heavily on estimates of revenue, costs, investment requirements, exiting cash proceeds and timing.
For a standard periodic IRR calculation, the cash flows don't actually have to be the same. Different amounts can be incurred or generated each year.
| Period | Example Cash Flow |
|---|---|
| Year 0 | -$150,000 |
| Year 1 | $20,000 |
| Year 2 | $45,000 |
| Year 3 | $30,000 |
| Year 4 | $80,000 |
Cash flow does not often come in smooth streams for business investment. This is really what one wants, that each amount be in the right period and is a Net Cash Flow for the period.
The IRR and NPV are complementary approaches to evaluation. IRR gives the minimum rate of return-break even - in a percentage, while NPV give a valuation of the total gain or loss from investment at chosen rate in monetary values.
It is advantageous to use the values of both measures in project comparison situations where projects are of different scale, life span or shape. In case of conflicting ranking when both techniques are adopted, analyze the factors causing discrepancies such as the size, the timings, the cash flow configuration, and the underlying assumptions; instead of depend just on the IRR.