NPV Cash-Flow Timelines and Sign Conventions

Why a Cash-Flow Timeline Comes First

A project forecast can contain the right dollar amounts and still be unusable for present-value analysis if a receipt is assigned to the wrong year or a payment is given the wrong sign. The timeline is the organized record of how much cash changes hands and when. Its job is to make the project’s cash-flow inputs explicit before any present-value calculation is performed.

Use the perspective of the company making the investment. Cash paid by the company is an outflow and receives a negative sign; cash received by the company is an inflow and receives a positive sign. A negative sign does not mean that an item is undesirable in every sense, and a positive sign does not by itself mean that a project is worthwhile. The signs record direction of cash movement from the stated perspective.

Definition: A project cash-flow timeline lists the project’s net cash flow at each relevant date. With the investing company as the perspective, receipts are positive and payments are negative. The time index identifies when each net amount occurs: $t=0$ is the initial date, and $t=1,2,\ldots$ identify later periods under the chosen period convention.

For an annual timeline, $t=0$ is the date the initial investment is made, and $t=1$ commonly represents the end of the first year. The period convention must be stated and used consistently. A cash flow at the end of year 2 belongs at $t=2$, not at $t=1$ merely because it is the second item in a list. If several components occur at the same date, combine them into one net cash flow for that date.

Building and Checking the Timeline

Start by fixing the viewpoint, the time-zero date, and the length of a period. Then list the project’s relevant cash receipts and payments by date. Components already estimated as project cash flows can be carried into the timeline without recalculating them. The key task here is to place each component correctly and preserve its sign.

Fix the perspective and period.
Use the company undertaking the project as the perspective. State whether periods are annual and what date corresponds to $t=0$.

Assign a sign to each component.
Mark cash paid by the company as negative and cash received by it as positive.

Place components at their dates.
Use the date cash is expected to be received or paid, not the date an accounting entry is recorded or a forecast is prepared.

Net components with matching dates.
Add the signed amounts occurring at the same date to obtain that period’s net project cash flow.

Reconcile the result.
Check that each component appears once, with the correct sign and date, and that the period totals add to the total of the listed components.

The sign convention follows directly from the meaning of net cash flow. At a given date, total the company’s cash receipts and subtract its cash payments. If $R_t$ denotes the sum of receipts at date $t$, and $P_t$ denotes the sum of payments stated as nonnegative amounts, then the signed net amount is $C_t=R_t-P_t$. Equivalently, listing each payment with a negative sign gives the same result by addition. This is why combining signed components is both convenient and consistent: it computes the company’s net cash movement at that date.

C_t=\sum_j \text{signed cash-flow component}_{j,t} =\text{receipts at }t-\text{payments at }t

This construction also explains why signs and dates must be settled before present-value analysis. A present-value method assigns a value to a signed amount at a particular date. Changing the sign changes whether that amount adds to or subtracts from the project total; changing the date changes how far in time that amount is from the valuation date. A timeline prevents those inputs from being confused.

Worked Timelines

Worked Example: Initial Outlay and Terminal Receipts

A company plans a three-year equipment project. At time zero it pays $84,000 for equipment, $6,000 for installation, and $9,000 to establish working capital. The estimated net operating cash inflows are $34,000 at the end of year 1, $37,000 at the end of year 2, and $39,000 at the end of year 3. At the end of year 3, the company also expects $12,000 of after-tax salvage proceeds and a $9,000 recovery of working capital. Construct the annual timeline, in dollars.

Method. Take the company’s perspective, assign a negative sign to each initial payment, and put each later receipt at the date it occurs. Amounts stated as after-tax salvage and working-capital recovery are already cash-flow amounts for this timeline.

At $t=0$, the three payments total $84{,}000+6{,}000+9{,}000=99{,}000$. They are all outflows, so $C_0=-\$99{,}000$.

At $t=1$, the net operating inflow is $C_1=+\$34{,}000$. At $t=2$, it is $C_2=+\$37{,}000$.

At $t=3$, combine the operating inflow, salvage proceeds, and working-capital recovery: $39{,}000+12{,}000+9{,}000=60{,}000$. Therefore $C_3=+\$60{,}000$.

(C_0,C_1,C_2,C_3)=(-\$99{,}000,\ \$34{,}000,\ \$37{,}000,\ \$60{,}000)

Check. The signed amounts sum to $-99{,}000+34{,}000+37{,}000+60{,}000=\$32{,}000$. This agrees with the component check: total receipts of $34{,}000+37{,}000+39{,}000+12{,}000+9{,}000=\$131{,}000$, less initial payments of $\$99{,}000$, also equal $\$32{,}000$. This undiscounted reconciliation checks the arithmetic; it is not a present-value result. The common mistake avoided is placing the terminal receipts in a separate year rather than combining them with the other year-3 cash flow.

Worked Example: A Payment During the Project and Terminal Items

A four-year project requires equipment costing $110,000, installation costing $4,000, and initial working capital of $6,000, all paid at time zero. Forecast net operating receipts and operating payments are given by year: in year 1, receipts are $55,000 and payments are $27,000; in year 2, receipts are $63,000 and ordinary payments are $24,000, with an additional overhaul payment of $11,000; in year 3, receipts are $48,000 and ordinary payments are $20,000. At the end of year 4, the project has $10,000 of after-tax salvage proceeds, $6,000 of working-capital recovery, and a $7,000 cleanup payment. There is no other year-4 operating cash flow. Construct the annual timeline.

Method. First net receipts and payments separately for each year, then combine all components sharing the same date. The overhaul is a year-2 payment; it does not belong at time zero just because it is an equipment-related cost.

At time zero, the initial payments total $110{,}000+4{,}000+6{,}000=120{,}000$, so $C_0=-\$120{,}000$.

For year 1, the net amount is $55{,}000-27{,}000=\$28{,}000$, so $C_1=+\$28{,}000$.

For year 2, include the ordinary payments and the overhaul: $63{,}000-24{,}000-11{,}000=\$28{,}000$. Thus $C_2=+\$28{,}000$.

For year 3, $48{,}000-20{,}000=\$28{,}000$, giving $C_3=+\$28{,}000$.

At the end of year 4, net the two receipts against the cleanup payment: $10{,}000+6{,}000-7{,}000=\$9{,}000$. Therefore $C_4=+\$9{,}000$.

(C_0,C_1,C_2,C_3,C_4)=(-\$120{,}000,\ \$28{,}000,\ \$28{,}000,\ \$28{,}000,\ \$9{,}000)

Check. The signed timeline totals $-120{,}000+28{,}000+28{,}000+28{,}000+9{,}000=-\$27{,}000$. Separately, total receipts are $55{,}000+63{,}000+48{,}000+10{,}000+6{,}000=\$182{,}000$. Total payments are $120{,}000+27{,}000+24{,}000+11{,}000+20{,}000+7{,}000=\$209{,}000$, so receipts less payments equal $-\$27{,}000$ as well. This check catches the common error of omitting a cleanup payment or giving it a positive sign.

Worked Example: Excluding Non-Project Items and Keeping Dates Straight

A company evaluates a three-year service project. It will pay $50,000 for equipment and $3,000 for installation at time zero. A $2,000 feasibility study was paid for last month. The company will borrow $40,000 to help finance the purchase. The project is forecast to generate incremental cash benefits and project operating costs as follows: year 1, benefits of $31,000 and costs of $17,000; year 2, benefits of $35,000 and costs of $18,000, plus a $6,000 replacement-component payment; year 3, benefits of $30,000 and costs of $16,000, plus $4,000 of after-tax disposal proceeds. Construct the project cash-flow timeline, excluding items that are not project operating or investment cash flows.

Method. Use the project’s incremental cash flows from the company’s perspective. Include the equipment and installation payments. The study payment has already occurred, so it is not a future cash movement caused by undertaking the project at the evaluation date. The borrowing is a financing source, not a project operating or investment cash flow, so neither loan proceeds nor related financing flows belong in this project timeline.

At $t=0$, the project requires $50{,}000+3{,}000=\$53{,}000$ of cash outflow. Thus $C_0=-\$53{,}000$. The study payment and borrowing do not change this project cash flow.

At $t=1$, the net project cash flow is $31{,}000-17{,}000=\$14{,}000$, so $C_1=+\$14{,}000$.

At $t=2$, include the replacement-component payment: $35{,}000-18{,}000-6{,}000=\$11{,}000$. Thus $C_2=+\$11{,}000$.

At $t=3$, include the disposal proceeds as a receipt: $30{,}000-16{,}000+4{,}000=\$18{,}000$. Thus $C_3=+\$18{,}000$.

(C_0,C_1,C_2,C_3)=(-\$53{,}000,\ \$14{,}000,\ \$11{,}000,\ \$18{,}000)

Check. The timeline sums to $-53{,}000+14{,}000+11{,}000+18{,}000=-\$10{,}000$. Project receipts total $31{,}000+35{,}000+30{,}000+4{,}000=\$100{,}000$. Project payments total $53{,}000+17{,}000+18{,}000+6{,}000+16{,}000=\$110{,}000$, also giving $-\$10{,}000$. The common mistake avoided is inserting the loan proceeds as a positive project inflow while still treating the purchase as a project outflow. That would mix financing with project cash flows and distort the timeline.

Common Sign and Timing Traps

The timeline is not a ranking of items as good or bad. It is an accounting of signed cash movements from one viewpoint at specified dates. Several errors arise when that distinction is lost.

Reversing the perspective. A company payment is negative on the company’s project timeline, even though it is a receipt to the supplier.
Using the list position as the date. The third forecast item is not automatically $t=3$. Use the actual period in which the cash flow occurs.
Putting all equipment-related costs at time zero. A replacement payment expected in year 2 belongs in year 2, even if it relates to the same asset as the initial purchase.
Forgetting terminal components. Salvage receipts, working-capital recovery, and cleanup payments belong at the dates they occur; apply the sign of each cash movement.
Mixing project and financing cash flows. A loan receipt is a source of financing, not a cash benefit generated by the project. Keep the project timeline consistent with the project cash flows being evaluated.
Counting a past payment again. A payment already made before the evaluation date is not a new cash movement on the future project timeline.

Key takeaway: A reliable timeline begins with one viewpoint and one time convention. Give every relevant project receipt a positive sign, every project payment a negative sign, and place each amount at its actual date. Net components at matching dates, then reconcile the timeline to the underlying receipts and payments before using it for present-value analysis.

Check Your Understanding

For each problem, use the company’s perspective and give the net annual project cash flows, including time zero where applicable.

A project requires a $72,000 machine, $3,000 of delivery costs, and $5,000 of initial working capital at time zero. Year-1 receipts are $29,000 and payments are $12,000. In year 2, receipts are $34,000 and operating payments are $14,000; at year-end the company receives $5,000 of after-tax salvage proceeds and recovers $5,000 of working capital. (Answer: $C_0=-\$80{,}000,\ C_1=+\$17{,}000,\ C_2=+\$30{,}000$.)
A two-year project has an initial outlay of $45,000. In year 1, receipts are $20,000 and payments are $7,000. In year 2, receipts are $23,000, operating payments are $8,000, a final service payment is $3,000, and disposal proceeds are $4,000. (Answer: $C_0=-\$45{,}000,\ C_1=+\$13{,}000,\ C_2=+\$16{,}000$.)
A three-year project has an initial investment of $100,000. Operating receipts and payments are $41,000 and $25,000 in year 1, $44,000 and $28,000 in year 2, and $39,000 and $23,000 in year 3. At the end of year 3, add $8,000 of after-tax salvage proceeds and $5,000 of working-capital recovery. (Answer: $C_0=-\$100{,}000,\ C_1=+\$16{,}000,\ C_2=+\$16{,}000,\ C_3=+\$29{,}000$.)
A project requires $64,000 for equipment, $2,000 for setup, and $4,000 of initial working capital at time zero. A planning study costing $1,000 was paid last year, and the company receives a $20,000 loan at time zero. Operating receipts and payments are $26,000 and $15,000 in year 1; $30,000 and $16,000 in year 2, when a $4,000 upgrade payment is also made; and $27,000 and $14,000 in year 3. Year 3 also has $3,000 of after-tax salvage proceeds and $4,000 of working-capital recovery. Exclude the past study and loan from project cash flows. (Answer: $C_0=-\$70{,}000,\ C_1=+\$11{,}000,\ C_2=+\$10{,}000,\ C_3=+\$20{,}000$.)
A project requires a $90,000 initial payment. In year 1, receipts are $40,000 and payments are $15,000. In year 2, operating receipts are $32,000, operating payments are $14,000, and maintenance costs are $3,000. At the end of year 2, the company also receives $6,000 of after-tax salvage proceeds and recovers $4,000 of working capital. (Answer: $C_0=-\$90{,}000,\ C_1=+\$25{,}000,\ C_2=+\$25{,}000$.)

What You'll Learn