Tutorials › Exam FM - Financial Mathematics › IRR for Level-Payment Investment Cash Flows

Exam FM · Internal Rate of Return · Tutorial 479 of 998

IRR for Level-Payment Investment Cash Flows

Translate equal periodic receipts into an annuity-immediate factor equation, then solve for the IRR using a suitable rate for the cash-flow period.

Intermediate 10 min read

What You'll Learn

  • Set up the IRR equation for an initial outlay followed by equal end-of-period receipts.
  • Convert the investment-to-receipt ratio into a target annuity-immediate factor.
  • Solve for an unknown rate using factor values and numerical calculation.
  • Match the IRR period to the spacing of the receipts.
  • Convert a periodic IRR to an effective annual rate when needed.

Why Level-Payment Cash Flows Have an Annuity-Factor Equation

When a project requires one initial investment and then pays the same amount at regular intervals, its IRR calculation has a useful structure: the present value of the receipts is an annuity. Instead of solving a separate discounting equation for each receipt, you can divide the investment by the level receipt and match the result to an annuity-immediate factor.

The key is to interpret the cash-flow timeline correctly. The initial outlay occurs at time 0, and the equal receipts occur at the ends of periods 1 through \(n\). A receipt at time 0, a different payment frequency, or a receipt that is not level changes the equation.

Definition: For an investment of \(P\) at time 0 followed by \(n\) equal receipts of \(R\) at the ends of successive periods, the IRR per period is the rate \(i\) that makes the present value of the receipts equal to \(P\). For \(i\ne 0\), this gives \(P=R a_{\overline{n}|}\), where \(a_{\overline{n}|}=(1-v^n)/i\) and \(v=1/(1+i)\). At \(i=0\), \(a_{\overline{n}|}=n\).

Here \(P\) and \(R\) are positive amounts: the cash-flow timeline records the initial investment as \(-P\) and each receipt as \(+R\). The rate \(i\) is measured per interval between receipts. Thus, if receipts are annual, \(i\) is an annual effective rate; if receipts are quarterly, \(i\) is a quarterly effective rate. The annuity factor assumes equal spacing and payments at period-end. It does not apply unchanged to payments at the beginning of periods or to unequal receipts.

Deriving the Level-Receipt Equation

Each receipt is discounted to time 0 using the same rate per period. The present values of the receipts are \(Rv\), \(Rv^2\), through \(Rv^n\). Their sum must equal the investment for the IRR to make the net present value zero.

$$ P=R(v+v^2+\cdots+v^n)=R a_{\overline{n}|} $$

To obtain the annuity factor formula, let \(A=v+v^2+\cdots+v^n\). Multiplying by \(v\) gives \(vA=v^2+v^3+\cdots+v^{n+1}\). Subtracting these expressions cancels the middle terms:

$$ (1-v)A=v-v^{n+1}=v(1-v^n) $$

Since \(v=1/(1+i)\), \(1-v=i/(1+i)=iv\). Therefore \(A=v(1-v^n)/(iv)=(1-v^n)/i\), which is \(a_{\overline{n}|}\). This derivation shows why the formula applies to end-of-period receipts: its first term is \(v\), not 1. The equation is valid for \(i\ne 0\); at zero interest the sum has \(n\) terms, each equal to 1, so the factor is \(n\).

Key result: For a time-0 investment \(P\) and \(n\) equal receipts \(R\) at times \(1,2,\ldots,n\), set \(a_{\overline{n}|}=P/R\), then find the rate \(i\) that produces that factor. The quotient \(P/R\) is a target factor, not the IRR itself.

A Practical Solving Process

For most level-payment problems, the unknown rate is inside the annuity factor, so a calculator or numerical solver is needed. Factor tables can identify a nearby rate or narrow the search. A disciplined setup also makes it easier to catch timing and period errors.

1
Mark the timeline.
Record the outlay at time 0 and each receipt at the end of its period. Count the receipts to determine \(n\).
2
Match the periods.
Use a rate for one interval between receipts. Do not substitute an annual rate into a quarterly annuity factor unless it has been converted to an equivalent quarterly rate.
3
Form the target factor.
Divide the initial investment by one receipt, \(P/R\). The result should equal \(a_{\overline{n}|}\) at the IRR.
4
Solve and check.
Use a factor table, calculator, or numerical solver to find the rate. Substitute the result back into the annuity factor and confirm that \(R a_{\overline{n}|}\) agrees with \(P\), allowing for rounding.

For a nonnegative trial rate, each present-value term \(v^k=1/(1+i)^k\) decreases as the rate rises. Consequently, \(a_{\overline{n}|}\) decreases as the trial rate rises. If the target factor lies between the factors at two trial rates, the IRR lies between those rates. A numerical solver can refine the result; the final check should use the unrounded rate rather than a rounded display value.

Worked Example: Solving a Five-Year Level-Receipt IRR

A hypothetical project costs $4,000 now and is expected to pay $1,000 at the end of each of the next five years. Find its annual IRR to three decimal places. The receipts are annual and level, so the unknown rate is annual and the correct factor is an annuity-immediate factor.

Method: target-factor matching followed by numerical solving. There are \(n=5\) receipts, each \(R=\$1{,}000\), and the initial outlay is \(P=\$4{,}000\). Thus the required annuity factor is

$$ a_{\overline{5}|}=\frac{P}{R}=\frac{4{,}000}{1{,}000}=4 $$

Use \(a_{\overline{5}|}=(1-(1+i)^{-5})/i\). At \(i=0.079\), the factor is approximately \(4.0032\). At \(i=0.080\), it is approximately \(3.9927\). The target value 4 lies between these factors, so the IRR lies between 7.9% and 8.0%.

Solving the factor equation without rounding the trial rate gives \(i\approx0.079308\). The annual IRR, rounded to three decimal places as a percentage, is 7.931%. As a check, substituting the unrounded rate gives \(a_{\overline{5}|}\approx4.0000\), so the present value of the receipts is approximately \(\$1{,}000(4.0000)=\$4{,}000\).

Common mistake avoided: Treating 7.90% as though it produced a factor of exactly 4. At 7.90%, the factor is approximately 4.0032, not 4.0000, so rounding the trial rate too early gives an incorrect IRR.

Using the Payment Period as the Rate Period

The rate in the annuity equation is the rate per payment interval. When payments are quarterly, first solve for a quarterly rate. If a problem asks for an effective annual IRR, convert the result after solving. If \(j\) is the effective rate per quarter, the equivalent annual effective rate is \((1+j)^4-1\), because one year contains four quarterly periods.

Worked Example: Quarterly Receipts and an Annual Effective IRR

A hypothetical investment costs $17,729.75 at time 0 and pays $5,000 at the end of each quarter for four quarters. Find the quarterly IRR and the equivalent annual effective IRR. Assume the stated receipts are exactly quarterly and there are no other cash flows.

Method: solve in quarterly periods, then convert the rate. There are four receipts, so \(n=4\). Divide the investment by one receipt:

$$ a_{\overline{4}|}=\frac{17{,}729.75}{5{,}000}=3.54595 $$

At a quarterly rate of 5%, the factor is

$$ a_{\overline{4}|\,0.05} =\frac{1-(1.05)^{-4}}{0.05} =3.5459505\ \text{(approximately)} $$

The factor agrees with the target 3.54595 to the precision of the stated dollar amount. Thus the quarterly IRR is approximately 5.0000%. The present-value check is \(5{,}000(3.5459505)=\$17{,}729.7525\), which rounds to $17,729.75.

To report the annual effective rate, compound the quarterly rate for four quarters:

$$ (1.05)^4-1=0.21550625 $$

The equivalent annual effective IRR is therefore 21.5506% (rounded to four decimal places as a percentage). It is not 20%: multiplying 5% by four omits the effect of quarterly compounding.

Common mistake avoided: Using 5% as an annual rate in a four-quarter factor. The equation has four periods, each one quarter long, so 5% is a quarterly rate; annualization comes only after solving.

Checking the Timing and the Factor Type

An annuity-immediate factor discounts payments at times \(1\) through \(n\). The future-value annuity factor \(s_{\overline{n}|}\), by contrast, accumulates payments to a future date; it is not the factor to use when equating the time-0 investment to the present value of receipts. Likewise, if the first receipt is immediate, the stream is not the end-of-period pattern in this tutorial. A timing change alters the powers of \(v\) in the present-value equation.

The amount \(P/R\) also has a useful interpretation: it is the number of receipt-sized units of present value required to recover the investment. It does not give the rate directly. The number of periods \(n\) and the payment timing are needed to identify which annuity factor to match.

Worked Example: Verifying a Candidate IRR by Discounting Each Receipt

A hypothetical project requires $5,687.50 now and pays $2,700 at the end of each of the next three years. Determine its annual IRR by identifying the factor at a trial rate of 20%, and verify the result by discounting each receipt separately.

Method: factor recognition and a cash-flow check. First calculate the target factor:

$$ \frac{P}{R}=\frac{5{,}687.50}{2{,}700}=2.10648148\ldots $$

At \(i=0.20\), the three-year annuity-immediate factor is

$$ a_{\overline{3}|\,0.20} =\frac{1-(1.20)^{-3}}{0.20} =\frac{1}{1.20}+\frac{1}{1.20^2}+\frac{1}{1.20^3} =0.8333333+0.6944444+0.5787037 =2.1064814\ldots $$

This matches the target factor, so the annual IRR is 20%. To check directly, the present values are \(\$2{,}700/1.20=\$2{,}250\), \(\$2{,}700/1.20^2=\$1{,}875\), and \(\$2{,}700/1.20^3=\$1{,}562.50\). Their sum is \(\$2{,}250+\$1{,}875+\$1{,}562.50=\$5{,}687.50\), equal to the initial investment.

Common mistake avoided: Using a future-value factor for receipts that must be valued at time 0. The separate discounting check confirms that each receipt was brought back to the correct date.

Common Exam Traps

  • Using the receipt amount as the target factor. The target is \(P/R\), not \(R/P\) and not \(R\). Check the equation \(P=R a_{\overline{n}|}\) before solving.
  • Counting intervals incorrectly. Four end-of-quarter receipts mean \(n=4\), even though the final receipt arrives one year after the initial outlay.
  • Using the wrong payment timing. End-of-period receipts are discounted by \(v,v^2,\ldots,v^n\); they are not an annuity-due stream.
  • Mixing rate and cash-flow periods. Solve with a quarterly rate for quarterly receipts, then convert if an annual effective rate is required.
  • Rounding a trial rate too early. A factor that is close to the target may still imply a measurably different IRR. Retain calculator precision until the final reported rate.
Key takeaway: For an initial investment followed by equal end-of-period receipts, write the timeline first, set \(a_{\overline{n}|}=P/R\), and solve using a rate measured per receipt interval. Confirm the answer by substituting it into the factor equation and comparing the resulting present value with the investment.

Check Your Understanding

For each problem, use the stated timing and report the requested rate. Round only the final answer.

  1. A hypothetical project costs $2,486.85 now and pays $1,000 at the end of each of the next three years. Find the annual IRR to two decimal places. (Answer: approximately 10.00% per year)
  2. An investment of $4,000 is followed by five annual receipts of $1,000, each at year-end. Find the annual IRR to three decimal places. (Answer: approximately 7.931% per year)
  3. A device costs $3,629.90 now and pays $1,000 at the end of each quarter for four quarters. Find the quarterly IRR and equivalent annual effective IRR. (Answer: approximately 4.0000% per quarter and 16.9859% per year)
  4. A project costs $10,000 and pays $6,000 at each of the next two year-ends. Solve \(a_{\overline{2}|}=10{,}000/6{,}000\) for the annual IRR, to two decimal places. (Answer: approximately 13.07% per year)
  5. A hypothetical asset costs $9,834.64 and pays $2,000 at the end of each half-year for six half-years. Find the half-year IRR and its equivalent annual effective rate. (Answer: approximately 6.0000% per half-year and 12.36% per year)
Clinical Biostats