Staged Investment NPV

Why Staged Investment NPV Requires Care

A project may require an initial investment, additional funding later, and operating receipts in between. The timing matters: an outflow made one year from now is not equivalent to the same outflow today, because the two amounts have different present values. To evaluate the project, put every investment and receipt on one signed timeline and value each at the same date.

This tutorial uses time 0 as the valuation date and annual periods. The method also applies when cash flows occur at other specified dates, provided the rate and time units are consistent. The earlier material on present value sums, cash-flow signs, and timelines provides the basic framework; the key task here is to keep multiple investment outflows at their actual dates rather than combining them as if they were all immediate.

Definition: For a project with cash flow $C_t$ at time $t$, the net present value at time 0, using an effective annual discount rate $i$, is $$ \operatorname{NPV}_0=\sum_{t=0}^{n} C_t v^t =\sum_{t=0}^{n}\frac{C_t}{(1+i)^t}, \qquad v=\frac{1}{1+i}. $$ A receipt is positive and an investment outflow is negative. A project’s NPV is the sum of the present values of all its dated cash flows.

The formula assumes that the cash-flow amounts are known, the rate $i$ applies consistently over the valuation horizon, and each time $t$ is measured in years. In particular, $i$ is an effective annual rate, so a cash flow at time $t$ is discounted by $(1+i)^t$. If the stated rate uses a different period or convention, it must be converted or the discounting periods must be changed before using this formula. A cash flow at time 0 is not discounted.

Valuing Each Investment at Its Own Date

A staged project can be organized by listing every receipt and outflow in the period when it occurs. Each amount is then discounted from its own date to time 0. An outflow is included with a negative sign; it is not subtracted again after discounting. This signed-sum approach handles operating receipts between investments without requiring a separate valuation method.

Set the valuation date and rate.
State the date at which NPV is required, the effective rate, and the period represented by each time index.

Record every dated cash flow.
Enter each investment as a negative amount and each receipt as a positive amount. Keep separate dates separate, even if they are both outflows.

Discount each amount to the valuation date.
For time 0 valuation, multiply the amount at time $t$ by $v^t$.

Add the signed present values.
The total is the project NPV. If a future cash flow is unknown and break-even is required, set NPV equal to zero and solve for it.

Worked Example: NPV With Two Investment Outflows

A hypothetical project requires $20,000 now and a further $12,000 at the end of year 1. It is expected to pay $10,000 at the end of year 2, $15,000 at the end of year 3, and $9,000 at the end of year 4. Find its NPV at time 0 using an effective annual rate of 8%.

Method. Assign each cash flow its actual date and sign, then discount all amounts to time 0. The timeline is $-20{,}000$ at time 0, $-12{,}000$ at time 1, $+10{,}000$ at time 2, $+15{,}000$ at time 3, and $+9{,}000$ at time 4.

The NPV equation is

\operatorname{NPV}_0 =-20{,}000-\frac{12{,}000}{1.08} +\frac{10{,}000}{1.08^2} +\frac{15{,}000}{1.08^3} +\frac{9{,}000}{1.08^4}.

The discount denominators are $1.08$, $1.1664$, $1.259712$, and $1.36048896$, respectively. Therefore, before rounding the final result, the calculation is

\operatorname{NPV}_0 =-20{,}000-\frac{12{,}000}{1.08} +\frac{10{,}000}{1.1664} +\frac{15{,}000}{1.259712} +\frac{9{,}000}{1.36048896} \approx -4{,}014.9706.

Rounded to the nearest cent, the NPV is −$4,014.97. The negative result means that, at the stated rate and under these projected cash flows, the present value of receipts is less than the present value of investment costs.

Check. The present value of the two investments is $20{,}000+12{,}000/1.08$, or approximately $31,111.11. The present value of the three receipts is approximately $27,096.14. Their difference is $27,096.14 − $31,111.11 = −$4,014.97, consistent with the signed-sum calculation. The common mistake avoided is treating the year-1 investment as though it were paid at time 0.

Why Discounting to a Common Date Works

Present values can be added because they are all expressed in units of value at the same date. The same conclusion can be checked by accumulating all cash flows to a later common date. Under a constant effective annual rate $i$, a time- $t$ cash flow grows to time $n$ by the factor $(1+i)^{n-t}$. Thus the accumulated net value at time $n$ is

\sum_{t=0}^{n} C_t(1+i)^{n-t} =(1+i)^n\sum_{t=0}^{n}\frac{C_t}{(1+i)^t} =(1+i)^n\operatorname{NPV}_0.

The first equality follows by factoring $(1+i)^n$ from each term: $(1+i)^{n-t}=(1+i)^n/(1+i)^t$. Since $(1+i)^n$ is positive when $i>-1$, the accumulated net value has the same sign as the NPV at time 0. This confirms why each staged investment and receipt must be moved to one common date before addition. It also shows why a zero NPV at time 0 corresponds to a zero accumulated net value at time $n$, under the same rate assumption.

Solving for a Break-Even Receipt

A common staged-investment question asks for the future receipt that makes a project’s NPV exactly zero. The method is to include the unknown receipt at its correct date, set the signed present-value sum equal to zero, and isolate the unknown. Do not solve for a receipt at time 0 if the problem asks for a receipt at a later date: after finding its required present value, accumulate it to the specified date.

Worked Example: Required Receipt After a Staged Investment

A hypothetical project has an outflow of $15,000 at time 0, a receipt of $6,360 at time 1, and a further outflow of $11,236 at time 2. What receipt at time 3 makes NPV exactly zero, using an effective annual rate of 6%?

Method. Let the required receipt at time 3 be $X$. Keep the year-1 receipt positive and the year-2 investment negative. The break-even equation at time 0 is

-15{,}000+\frac{6{,}360}{1.06} -\frac{11{,}236}{1.06^2} +\frac{X}{1.06^3}=0.

The first receipt has present value $6{,}360/1.06=6{,}000$. The year-2 outflow has present value $11{,}236/1.1236=10{,}000$, because $10{,}000(1.1236)=11{,}236$. Substituting these values gives

-15{,}000+6{,}000-10{,}000+\frac{X}{1.191016}=0, \qquad \frac{X}{1.191016}=19{,}000.

Therefore,

$$ X=19{,}000(1.191016)=22{,}629.304. $$

The exact break-even receipt under the stated model is $22,629.304. To the nearest cent, it is $22,629.30. That cent-rounded amount makes NPV approximately $-0.004/1.191016=-$0.00336$, not exactly zero; the exact amount and the rounded amount should not be described as identical. This check avoids a rounding trap: a receipt rounded to cents may leave a small nonzero NPV even when the unrounded amount is exactly break-even.

Check. At time 0, the known cash flows have net present value $-15{,}000+6{,}000-10{,}000=-19{,}000$. The required receipt has present value $22{,}629.304/1.191016=19{,}000$. Their sum is zero, as required. The common mistake avoided is using $X$ as though it occurred at time 0 instead of discounting it from time 3.

A Further Staged-Investment Calculation

Staged costs need not all occur before receipts. A project can generate a receipt, require another investment, and then generate a later receipt. The signed timeline still gives one consistent calculation, without changing the treatment of any cash flow.

Worked Example: Break-Even After an Interim Receipt

A hypothetical project has an outflow of $10,000 at time 0, an outflow of $5,250 at time 1, a receipt of $11,025 at time 2, and an outflow of $8,103.375 at time 3. What receipt $X$ at time 4 makes NPV zero at an effective annual rate of 5%?

Method. Discount each known cash flow to time 0 and then solve the zero-NPV equation for the time-4 receipt:

-10{,}000-\frac{5{,}250}{1.05} +\frac{11{,}025}{1.05^2} -\frac{8{,}103.375}{1.05^3} +\frac{X}{1.05^4}=0.

The discount factors give the following present values: $5{,}250/1.05=5{,}000$; $11{,}025/1.1025=10{,}000$; and $8{,}103.375/1.157625=7{,}000$. The known signed present values therefore total

$$ -10{,}000-5{,}000+10{,}000-7{,}000=-12{,}000. $$

The time-4 receipt must have a present value of $12,000. Since $1.05^4=1.21550625$,

$$ X=12{,}000(1.21550625)=14{,}586.075. $$

The exact break-even receipt is $14,586.075, or $14,586.08 to the nearest cent. The exact amount discounts to $12,000, which offsets the known net present value of −$12,000. Rounding is performed only after solving; if an answer must be reported in cents, it should be identified as a rounded amount.

Check. The known cash flows have NPV −$12,000, while $14{,}586.075/1.21550625=$12{,}000$. Their sum is zero. The common mistake avoided is omitting the time-3 investment because an earlier receipt has already occurred.

Common Mistakes and Exam Traps

Staged-investment problems test timing and signs as much as arithmetic. A compact timeline is useful because the size of a cash flow alone does not determine its present value: its date matters too.

Moving a later outflow to time 0. In the first worked example, incorrectly treating the $12,000 year-1 outflow as an immediate cost gives an investment present value of $32,000 instead of $20{,}000+12{,}000/1.08$, or approximately $31,111.11. The resulting incorrect NPV is about $27,096.14 − $32,000 = −$4,903.86, rather than −$4,014.97.
Using the wrong sign. An additional investment is a negative cash flow, even if it occurs after the project has started producing receipts. A receipt between two investments remains positive; do not combine the cash flows without preserving their signs.
Discounting a cash flow twice. Once a cash flow has been multiplied by its discount factor, it is already expressed at the valuation date. Add that present value with its sign; do not apply another discount factor to it.
Mixing rates and periods. With an effective annual rate, $t=2$ means a two-year discount factor $(1+i)^2$. If dates or rate periods use another time unit, make that convention consistent before calculating.
Calling a rounded answer exact. As the break-even example shows, a receipt rounded to cents can produce a small nonzero NPV. Distinguish the exact solution from its required reporting precision.

Key takeaway: For a staged project, retain every cash flow at its actual date, assign receipts positive signs and investments negative signs, and discount each amount to the same valuation date. For break-even, set that signed present-value sum equal to zero and solve for the unknown at its stated date.

Check Your Understanding

Use an effective annual rate for each problem. Unless a question asks for an exact amount, report money to the nearest cent.

A project has cash flows of −$4,000 at time 0, −$2,200 at time 1, +$5,000 at time 2, and +$2,500 at time 3. Find its NPV at 10%. (Answer: $10.52)
A project requires $5,000 at time 0 and $3,240 at time 1. It pays $5,832 at time 2 and $7,558.272 at time 3. Find its NPV at 8%. (Answer: $3,000.00)
At 6%, a project has outflows of $8,000 at time 0 and $4,240 at time 1, and receipts of $6,741.60 at time 2 and $5,955.08 at time 3. Find its NPV. (Answer: −$1,000.00)
At 5%, a project requires $7,000 at time 0 and $4,200 at time 1, receives $8,820 at time 2, and requires $5,788.125 at time 3. What receipt at time 4 makes NPV zero? (Answer: $9,724.05)
At 4%, a project has cash flows of −$12,000 at time 0, −$5,200 at time 1, +$10,816 at time 2, −$6,749.184 at time 3, and +$10,528.72704 at time 4. Find its NPV. (Answer: −$4,000.00)

What You'll Learn