Tutorials › VEE Accounting and Finance › IRR for Level Annual Cash Flows

VEE Accounting and Finance · IRR, Payback, and Alternatives · Tutorial 451 of 996

IRR for Level Annual Cash Flows

Learn how level annual inflows turn the IRR calculation into an annuity-factor equation, and how to solve and check that equation.

Intermediate 10 min read

What You'll Learn

  • Set up the IRR equation for one initial outflow and equal annual inflows
  • Derive the ordinary annuity factor from discounted end-of-year payments
  • Solve level-cash-flow IRRs algebraically or with a rate solver
  • Check an estimated rate by substituting it back into the present-value equation
  • Avoid confusing ordinary annuities with annuities due

Why Level Annual Cash Flows Simplify IRR

When a project requires one initial investment and then produces the same cash inflow at the end of every year, its internal rate of return can be found using an ordinary annuity factor. This structure replaces a separate present-value calculation for every annual inflow with one compact equation. The rate is still determined by the project’s timing and amounts: equal payments do not mean that the IRR is simply the total inflow divided by the investment.

Assume the project has an initial outflow of \(I>0\) at time 0 and a level inflow of \(C>0\) at the end of each year for \(n\) years. The cash flows are annual, deterministic estimates, and there are no other project cash flows, such as a terminal payment or later outflow. Let \(i\) denote the effective annual rate that makes the project’s net present value equal to zero. Each annual inflow is discounted to time 0 at that rate.

Definition: For an initial investment \(I\) followed by \(n\) equal annual inflows \(C\), the IRR \(i\) satisfies \(-I+C a_{\overline{n}|i}=0\). Here \(a_{\overline{n}|i}\) is the present-value factor for an ordinary annuity: \(n\) payments of 1, each paid at the end of a year, discounted at effective annual rate \(i\).

The rate \(i\) is an unknown in this equation, not a required return supplied in advance. A required return can be compared with an IRR in a project decision, but that comparison is separate from calculating the rate. This tutorial focuses on setting up and solving the level-inflow equation.

Deriving the Ordinary Annuity Equation

The first inflow arrives at time 1, so its present value is \(C/(1+i)\). The second arrives at time 2, so its present value is \(C/(1+i)^2\). Continuing through year \(n\), and setting the net present value equal to zero, gives the IRR equation:

$$ 0=-I+\frac{C}{1+i}+\frac{C}{(1+i)^2}+\cdots+\frac{C}{(1+i)^n} $$

To collect the discounted inflows, factor out \(C\). The remaining terms form a finite geometric series with first term \(q=1/(1+i)\) and common ratio \(q\). The sum of \(q+q^2+\cdots+q^n\) is \(q(1-q^n)/(1-q)\). Since \(1-q=i/(1+i)\), this reduces to the ordinary annuity factor:

$$ \begin{aligned} a_{\overline{n}|i} &=\sum_{t=1}^{n}\frac{1}{(1+i)^t}\\ &=\frac{1-(1+i)^{-n}}{i}, \qquad i\ne 0. \end{aligned} $$

Substituting this sum into the IRR equation gives the central result for level annual inflows:

$$ I=C a_{\overline{n}|i} =C\left(\frac{1-(1+i)^{-n}}{i}\right) $$

This formula applies when the initial investment occurs at time 0 and the equal inflows occur at the ends of years 1 through \(n\). For \(i=0\), each inflow has a discount factor of 1, so the annuity factor is \(n\), not the result of substituting zero into a fraction with denominator \(i\). Thus, at a zero IRR, the equation is \(I=nC\). The formula uses an effective annual rate because the cash-flow periods are annual; if cash flows are expressed in a different time unit, the periods and rate must be made consistent.

Solving the Equation

With two annual inflows, the equation can be rearranged into a quadratic. With more years, it is usually easiest to solve \(I=C a_{\overline{n}|i}\) using a financial calculator, spreadsheet rate solver, or numerical equation solver. Enter the initial outflow at time 0 and the equal inflows in periods 1 through \(n\). Then substitute the resulting rate back into the equation as a check.

Worked Example: Solving a Two-Year Equation Algebraically

A hypothetical equipment upgrade costs \(I=\$14{,}400\) immediately and is expected to generate \(C=\$10{,}000\) at the end of each of the next two years. Find its IRR. Assume the amounts are in dollars, the inflows occur at year-end, and the annual cash flows are level.

Method. Use the two-year IRR equation and solve its quadratic form. This avoids treating the two inflows as if they were received at the same time.

Set NPV equal to zero and divide both sides by \(\$10{,}000\):

$$ 1.44=\frac{1}{1+i}+\frac{1}{(1+i)^2} $$

Let \(x=1+i\), where \(x>0\) for an annual effective rate greater than \(-1\). Multiplying by \(x^2\) gives \(1.44x^2=x+1\), or \(1.44x^2-x-1=0\). The quadratic formula gives:

$$ x=\frac{1\pm\sqrt{1+4(1.44)(1)}}{2(1.44)} =\frac{1\pm 2.6}{2.88} $$

The positive value is \(x=3.6/2.88=1.25\). The other value, \(-1.6/2.88\), cannot equal \(1+i\) for a rate greater than \(-1\). Therefore \(i=1.25-1=0.25\), or 25%.

Check. At 25%, the year 1 present value is \(\$10{,}000/1.25=\$8{,}000\). The year 2 present value is \(\$10{,}000/1.25^2=\$6{,}400\). Their sum is \(\$14{,}400\), exactly the initial investment, so NPV is zero.

Worked Example: Using an Annuity Factor and Rate Solver

A hypothetical service platform requires an initial investment of \(\$16{,}851.85\) and is expected to produce \(\$8{,}000\) at each year-end for three years. Find the IRR, reporting the rate to four decimal places. Assume annual effective discounting and no other cash flows.

Method. Form the annuity-factor equation, then use a rate solver. The solver is useful here because the three-year equation does not reduce directly to a simple quadratic.

The equation is \(16{,}851.85=8{,}000a_{\overline{3}|i}\), so the required annuity factor is \(16{,}851.85/8{,}000=2.10648125\). At 15%, \(a_{\overline{3}|0.15}=(1-1/1.15^3)/0.15=2.283225\), giving an inflow present value of \(\$18{,}265.80\), above the investment. At 20%, \(a_{\overline{3}|0.20}=(1-1/1.20^3)/0.20=2.10648148\), giving an inflow present value of \(\$16{,}851.85\) when rounded to cents.

Using the unrounded annuity factor in the rate equation gives an IRR of approximately 20.0000% to four decimal places. The tiny difference between the calculated present value before rounding and the stated investment is due to expressing the initial cost to the nearest cent.

Check. At 20%, the three discounted inflows are approximately \(\$6{,}666.67\), \(\$5{,}555.56\), and \(\$4{,}629.63\). Their sum is \(\$16{,}851.86\) using those individually rounded values, or \(\$16{,}851.85\) when the unrounded values are summed and then rounded. The latter agrees with the investment to the cent.

Worked Example: Checking a Four-Year IRR Directly

A hypothetical production line costs \(\$35{,}424\) at time 0 and is expected to return \(\$15{,}000\) at the end of each of the next four years. Find and check the IRR. Assume all amounts are in dollars and the stated inflows are level year-end cash flows.

Method. Test the rate through the annuity factor and confirm it by discounting each payment. This provides a direct check that the annuity factor has the correct payment timing.

The required factor is \(\$35{,}424/\$15{,}000=2.3616\). At \(i=25\%\), the factor is:

$$ a_{\overline{4}|0.25} =\frac{1-(1.25)^{-4}}{0.25} =\frac{1-0.4096}{0.25} =2.3616 $$

Thus the equation gives \(I=C a_{\overline{4}|i}=\$15{,}000(2.3616)=\$35{,}424\), so the IRR is 25%.

Check. Discounting the four inflows individually at 25% gives \(\$15{,}000/1.25=\$12{,}000\), \(\$15{,}000/1.25^2=\$9{,}600\), \(\$15{,}000/1.25^3=\$7{,}680\), and \(\$15{,}000/1.25^4=\$6{,}144\). These sum to \(\$35{,}424\), matching the initial investment.

Common Errors and Practical Checks

A frequent error is to use an annuity-due factor even though the first inflow arrives at the end of year 1. For the two-year project in the first example, the correct factor at 25% is \(1/1.25+1/1.25^2=1.44\). If the payments are incorrectly treated as occurring at times 0 and 1, the factor becomes \(1+1/1.25=1.8\), and the resulting present value is \(\$18{,}000\), not \(\$14{,}400\). The correction is to place each cash flow at its stated date: an end-of-year payment is discounted at least one period.

Another error is to apply a rate measured in one time unit to cash flows measured in another. In this setting, the periods are years and \(i\) is an effective annual rate. A quoted nominal rate with more than one compounding period per year must first be handled consistently with annual cash flows; it is not automatically the effective annual IRR.

Before accepting a calculated answer, check the timeline, the number of payments, and the payment amount. Then substitute the rate into \(I=C a_{\overline{n}|i}\), or discount each payment separately, and verify that the present value of the inflows equals the initial outflow. Keep full precision through the calculation and round the final rate only as requested.

Key takeaway: For one initial investment followed by equal end-of-year inflows, set \(I=C a_{\overline{n}|i}\). The annuity factor compresses the present values of all \(n\) payments; correct timing and consistent annual units are essential to obtaining the IRR.

Check Your Understanding

For each problem, identify the year-end payment pattern, set up the annuity equation, and solve for the annual IRR. Rates in the answers are rounded as stated.

  1. A hypothetical two-year monitoring system costs \(\$16{,}257.09\) initially and returns \(\$10{,}000\) at each year-end. Find its IRR to two decimal places. (Answer: 15.00%)
  2. A hypothetical three-year project costs \(\$12{,}638.89\) and produces equal year-end inflows of \(\$6{,}000\). Use the three-payment annuity factor to find the IRR to two decimal places. (Answer: 20.00%)
  3. A hypothetical four-year storage installation requires \(\$21{,}254.40\) initially and yields \(\$9{,}000\) at the end of each year. Find the IRR and verify that the present value of the four inflows matches the cost. (Answer: 25.00%)
  4. A hypothetical two-year project has an initial outflow of \(\$12{,}000\) and level year-end inflows of \(\$7{,}500\). Solve the quadratic IRR equation and report the rate to two decimal places. (Answer: 16.26%)
  5. A hypothetical five-year project costs \(\$18{,}953.93\) and generates \(\$5{,}000\) at each year-end. Calculate the five-year annuity factor at the IRR and report the rate to two decimal places. (Answer: 10.00%)
Clinical Biostats