Building an IRR Equation from a Cash-Flow Timeline

From a Timeline to an IRR Equation

An internal rate of return is defined through a zero-net-present-value condition. To use that definition, first translate the cash-flow timeline into signed amounts at numbered times. The equation is only as reliable as that translation: a correct rate-solving method cannot repair a payment given the wrong sign, date, or period.

In this tutorial, the cash flows occur at time zero or at the ends of equally spaced periods. The unknown rate $i$ is an effective rate per such period. For example, if the periods are years, $i$ is an annual effective rate; if the periods are quarters, $i$ is a quarterly effective rate. Do not treat the rate as annual unless the timeline and stated rate period support that interpretation.

Definition: Let $C_k$ be the net cash flow to the investor at the end of period $k$, with receipts positive and payments negative. Let $C_0$ denote the cash flow at time zero. For a rate $i>-1$ per period, the IRR equation is $$ \sum_{k=0}^{n} C_k v^k=0, \qquad v=\frac{1}{1+i}. $$ The IRR is a rate per the specified period that satisfies this equation. This tutorial focuses on constructing the equation, not on finding or assessing its solutions.

The sign convention is from one consistent viewpoint. If the timeline is for an investor who pays to acquire an asset and later receives proceeds, the acquisition cost is negative and the proceeds are positive. If the timeline instead describes the party receiving the purchase price and making later payments, the signs reverse. Reversing every sign leaves the zero equation unchanged, but mixing viewpoints does not.

Why Each Cash Flow Gets Its Discount Factor

The equation follows from valuing every cash flow at time zero using the same rate per period. A cash flow $C_k$ received or paid at the end of period $k$ has present value $C_kv^k$, because it is discounted once for each of the $k$ periods. The time-zero amount is already at the valuation date, so its factor is $v^0=1$. Adding the signed present values gives net present value; the IRR condition sets that sum equal to zero.

\operatorname{NPV}(i) =C_0+C_1v+C_2v^2+\cdots+C_nv^n =0, \qquad v=(1+i)^{-1}.

This derivation assumes that the cash flows can be represented at the stated period dates and that one rate per period is used throughout the equation. It does not supply a valid exponent for a cash flow whose timing does not fit that period grid. In that case, the timing and rate convention must be handled explicitly rather than silently assigning the nearest integer exponent.

A useful construction routine is to identify the viewpoint and rate period first, then place each signed net cash flow at its time index. Only after that should you write the discount factors. The routine makes the timeline auditable: every term in the equation should correspond to a dated amount.

Choose the viewpoint and period.
Mark receipts positive and payments negative from one party’s perspective. State whether one period is a year, quarter, or another specified interval.

Record the net cash flow at each date.
Combine transactions occurring at the same date. Include zero at any intervening period with no flow if it helps make the timeline clear.

Attach the time index.
A flow at time $k$ gets the factor $v^k$; a time-zero flow gets factor $1$.

Set signed present value equal to zero.
Write one term per nonzero net cash flow, using the same unknown rate per period throughout. Check that signs and exponents match the timeline.

Worked Timeline Constructions

Worked Example: Three Year-End Receipts

An investor pays \$9,760 now for a project. The project pays \$5,000 at the end of each of the next three years. Construct the annual IRR equation and check it at an annual effective rate of 25%.

Method and period. Use the investor’s viewpoint: the purchase price is a payment, so it is negative; the later receipts are positive. The periods are years, so the unknown $i$ is an annual effective rate. The time-zero flow is $C_0=-9{,}760$, and the year-end flows are $C_1=C_2=C_3=5{,}000$.

Build the equation. The initial payment is not discounted. The year-one, year-two, and year-three receipts receive factors $v$, $v^2$, and $v^3$, respectively:

-9{,}760+5{,}000v+5{,}000v^2+5{,}000v^3=0, \qquad v=\frac{1}{1+i}.

Check at 25%. At $i=0.25$, $v=1/1.25=0.8$. The discounted receipts are $5{,}000(0.8)=4{,}000$, $5{,}000(0.8)^2=3{,}200$, and $5{,}000(0.8)^3=2{,}560$. Their sum is $4{,}000+3{,}200+2{,}560=9{,}760$, which exactly offsets the initial payment. The equation is therefore satisfied at the stated rate.

Mistake avoided. Discounting the initial \$9,760 by $v$ would treat a payment made now as though it occurred one year later. Its exponent must be zero.

Worked Example: A Later Investment and Two Receipts

A project requires an outlay of \$6,000 now and a further outlay of \$1,500 at the end of year 1. It returns \$6,250 at the end of each of years 2 and 3. Construct the annual IRR equation and verify that 25% satisfies it.

Method and period. From the investor’s perspective, both outlays are negative and both returns are positive. All dates are year-end dates, and the unknown rate is annual. The timeline is $C_0=-6{,}000$, $C_1=-1{,}500$, $C_2=6{,}250$, and $C_3=6{,}250$.

Build the equation. Assign the factor for each date, retaining the negative sign on the year-one outlay:

-6{,}000-1{,}500v+6{,}250v^2+6{,}250v^3=0, \qquad v=\frac{1}{1+i}.

Check at 25%. For $i=0.25$, $v=0.8$. The present values of the four terms are $-6{,}000$, $-1{,}500(0.8)=-1{,}200$, $6{,}250(0.8)^2=4{,}000$, and $6{,}250(0.8)^3=3{,}200$. Adding them gives $-6{,}000-1{,}200+4{,}000+3{,}200=0$, as required.

Mistake avoided. The second outlay is not part of the time-zero amount: it occurs one year later and must be multiplied by $v$. Combining it with the initial outlay without discounting would change the cash-flow timing.

Worked Example: Quarterly Timeline With a Missing Quarter

A fund receives an investment of \$12,000 at time zero. It pays \$3,300 at the end of quarter 1, \$4,840 at the end of quarter 2, nothing at the end of quarter 3, and \$7,320.50 at the end of quarter 4. Construct an equation using a quarterly rate and check it at 10% per quarter.

Method and period. Use the fund’s viewpoint: the initial investment received is positive, but for an investor’s return equation it is clearer to describe the investor’s cash flows. The investor pays \$12,000, then receives the listed amounts. Thus $C_0=-12{,}000$, $C_1=3{,}300$, $C_2=4{,}840$, $C_3=0$, and $C_4=7{,}320.50$. The unknown $j$ is a rate per quarter, not per year.

Build the equation. Use $v_q=1/(1+j)$ as the discount factor per quarter. The zero cash flow at quarter 3 contributes no term, but its position confirms that the final receipt is at quarter 4, not quarter 3.

-12{,}000+3{,}300v_q+4{,}840v_q^2+7{,}320.50v_q^4=0, \qquad v_q=\frac{1}{1+j}.

Check at 10% per quarter. Here $v_q=1/1.10=10/11$. The quarter-one receipt has present value $3{,}300/1.10=3{,}000$. The quarter-two receipt has present value $4{,}840/(1.10)^2=4{,}840/1.21=4{,}000$. Since $(1.10)^4=1.4641$, the quarter-four receipt has present value $7{,}320.50/1.4641=5{,}000$. The sum is $-12{,}000+3{,}000+4{,}000+5{,}000=0$.

Mistake avoided. A missing quarter does not shorten the timeline. Giving the final receipt exponent 3 would incorrectly move it from the end of quarter 4 to the end of quarter 3.

Worked Example: Netting Operating Proceeds and Salvage

An investor pays \$18,880 now for equipment. At the end of year 1, the equipment produces \$10,000 net cash flow; at the end of year 2, it produces \$5,000. At the end of year 3, it produces \$11,000 from operations and \$4,000 from sale of the equipment. Construct the annual IRR equation and check it at 25%.

Method and period. All amounts are from the investor’s perspective, with the acquisition payment negative and receipts positive. Net the two year-three receipts: $11{,}000+4{,}000=15{,}000$. Therefore $C_0=-18{,}880$, $C_1=10{,}000$, $C_2=5{,}000$, and $C_3=15{,}000$.

Build and check. The annual equation is

-18{,}880+10{,}000v+5{,}000v^2+15{,}000v^3=0, \qquad v=\frac{1}{1+i}.

At $i=0.25$, $v=0.8$. The year-one receipt has present value $10{,}000(0.8)=8{,}000$; the year-two receipt has present value $5{,}000(0.64)=3{,}200$; and the combined year-three amount has present value $15{,}000(0.512)=7{,}680$. The total is $8{,}000+3{,}200+7{,}680=18{,}880$, exactly balancing the initial payment.

Mistake avoided. The \$11,000 operating receipt and \$4,000 sale proceeds occur on the same date, so they can be combined into one \$15,000 term. They must not be assigned different exponents merely because they have different descriptions.

Common Construction Errors

Before using an IRR equation, compare every term against the original timeline. A quick check is to ask: does every amount appear exactly once, with the correct sign and the exponent matching its date? The following errors are especially easy to make:

Starting the first receipt at exponent zero. A receipt at the end of period 1 has factor $v$, not $1$. Only an amount at time zero has exponent zero.
Discounting the time-zero investment. The factor for time zero is $v^0=1$, so the initial amount appears without a discount factor.
Changing sign conventions midway. Decide whose cash flows are being listed and keep receipts and payments consistently signed. Reversing every sign is harmless; reversing only some signs is not.
Using the wrong rate period. If the periods on the timeline are quarters, label the unknown as a quarterly rate. Do not call it annual merely because the investment lasts a year.
Dropping a no-flow period. A zero amount adds no algebraic term, but the period still counts when assigning the exponent to later cash flows.
Separating transactions on the same date incorrectly. Add the signed amounts at that date before forming its present-value term.

Key takeaway: An IRR equation is a signed timeline written in present-value form. State the rate period, give each cash flow its correct sign and date index, and set the sum of discounted amounts equal to zero.

Check Your Understanding

For each problem, construct the zero-NPV equation only; do not solve for the rate. Use the viewpoint and rate period specified in the question.

An investor pays \$9,000 now and receives \$4,000 at the end of year 1 and \$5,000 at the end of year 2. Write the annual IRR equation. (Answer: $-9{,}000+4{,}000v+5{,}000v^2=0,\ v=1/(1+i)$, where $i$ is annual.)
A project requires \$15,000 now, a further \$3,000 at the end of year 1, and returns \$8,000 at the end of year 2 and \$12,000 at the end of year 3. Write the annual IRR equation. (Answer: $-15{,}000-3{,}000v+8{,}000v^2+12{,}000v^3=0,\ v=1/(1+i)$, where $i$ is annual.)
An investor pays \$5,000 at time zero, receives \$1,200 at the end of quarter 1 and \$2,000 at the end of quarter 3, and pays \$500 at the end of quarter 4. There is no cash flow at quarter 2. Write the equation using a quarterly rate. (Answer: $-5{,}000+1{,}200v_q+2{,}000v_q^3-500v_q^4=0,\ v_q=1/(1+j)$, where $j$ is per quarter.)
A project costs \$24,000 now. It generates \$7,000 at the end of year 1, receives \$9,000 and pays an operating fee of \$1,000 at the end of year 2, has no cash flow at year 3, and generates \$13,000 at the end of year 4. Write the annual IRR equation. (Answer: $-24{,}000+7{,}000v+8{,}000v^2+13{,}000v^4=0,\ v=1/(1+i)$, where $i$ is annual.)
An investor pays \$10,000 at time zero. The investor receives \$3,500 at the end of year 1, pays a \$1,000 maintenance charge at the end of year 2, and receives \$9,000 at the end of year 3. Write the annual IRR equation. (Answer: $-10{,}000+3{,}500v-1{,}000v^2+9{,}000v^3=0,\ v=1/(1+i)$, where $i$ is annual.)

What You'll Learn