Tutorials › VEE Accounting and Finance › Future Value of an Uneven Cash-Flow Stream

VEE Accounting and Finance · Uneven Cash Flows and Applications · Tutorial 377 of 996

Future Value of an Uneven Cash-Flow Stream

Learn to move each cash flow to a common future date, combine the accumulated amounts, and avoid common timing and sign errors.

Intermediate 9 min read

What You'll Learn

  • Define a future-value date and represent receipts and payments with signed cash flows.
  • Accumulate each cash flow using the effective annual rate and its own time interval.
  • Derive the future-value sum from compound accumulation and addition of balances.
  • Calculate a stream’s future value with withdrawals and a clearly specified target date.
  • Check results using a date-by-date account balance and identify common timing errors.

Why the Target Date Matters

An uneven cash-flow stream has payments or receipts at different dates and in different amounts. To find its value at a future date, each amount must first be carried forward to that same date. A receipt made early has more time to earn interest than a receipt made later; an outflow reduces the value of the stream, but its effect also accumulates from its own date.

The essential discipline is to identify the target date before calculating. For every cash flow, count the periods from its date to that target—not from the cash-flow date to some other event in the description. This tutorial uses a single effective annual interest rate and annual time units in its examples. Its method is aligned with the SOA VEE Accounting and Finance syllabus.

Definition: Let \(C_j\) be the signed cash flow at time \(t_j\), and let \(T\) be a target date at or after every cash-flow date. A receipt is positive and a payment or withdrawal is negative. Under a constant effective annual interest rate \(i\), the future value at \(T\) is the sum of each cash flow accumulated from its own date to \(T\).

The Future-Value Sum

Suppose the cash flows occur at times \(t_1,t_2,\ldots,t_n\), measured in years, and the target date is \(T\). With a constant effective annual rate \(i\), one dollar invested for one year grows to \(1+i\) dollars. Thus, a cash flow \(C_j\) grows by a factor of \((1+i)^{T-t_j}\) between its date and the target date.

$$ \operatorname{FV}_T=\sum_{j=1}^{n} C_j(1+i)^{T-t_j} $$

Here \(T-t_j\) is the number of years the \(j\)th cash flow accumulates. A flow at the target date has \(T-t_j=0\), so it is included at its original amount. A flow before the target date has a positive accumulation period. Only cash flows dated at or before \(T\) belong in the calculation; a later flow has not yet occurred at the valuation date.

The formula assumes that each amount can be accumulated at the same effective annual rate over its applicable period, with no taxes, fees, or other account changes beyond the stated cash flows. If the rate varies by period, the accumulation factor must reflect the rates applying over that cash flow’s interval; the single-rate formula as written does not apply unchanged. For fractional-year dates, using \((1+i)^{T-t_j}\) assumes the corresponding fractional-period accumulation convention. The examples below use whole-year dates.

Why the Formula Works

Compound accumulation gives the value of one cash flow at the target date. The values can then be added because the total account balance is the sum of the amounts attributable to all the receipts and payments. This additivity is valid when each component is subject to the same accumulation rule and there are no extra account-specific charges or constraints.

1
Accumulate one cash flow.
A signed amount \(C_j\) at time \(t_j\) becomes \(C_j(1+i)^{T-t_j}\) at time \(T\), by compound interest.
2
Accumulate the other flows.
Apply the same rule separately to each cash flow, using its own date and therefore its own number of accumulation periods.
3
Add at the common date.
At time \(T\), all the accumulated amounts are expressed in dollars at the same date. Adding them gives the stream’s net future value.

For a direct justification, imagine processing cash flows in chronological order. If the balance immediately after one cash flow is \(B\), and the next cash flow occurs \(m\) years later with amount \(C\), the balance just after that next flow is \(B(1+i)^m+C\). The earlier balance accumulates for \(m\) years, while the new flow is added at its own date. Repeating this step carries every earlier flow to the latest date and adds each new flow there. Carrying the resulting balance forward to \(T\) gives one accumulated term for each original cash flow, precisely \(C_j(1+i)^{T-t_j}\), and the sum of those terms.

Worked Calculations

Worked Example: Deposits and Withdrawals Before a Stated Target Date

A hypothetical fund receives $1,500 at time 0, receives $900 at the end of year 2, pays out $400 at the end of year 3, and receives $1,200 at the end of year 5. Find its value at the end of year 6. Assume an effective annual interest rate of 5%, annual compounding, and no other transactions.

Method. Use the future-value sum, with receipts positive and the payout negative. The target is \(T=6\); the accumulation periods are \(6\), \(4\), \(3\), and \(1\) years, respectively.

$$ \begin{aligned} \operatorname{FV}_6 &=1500(1.05)^6+900(1.05)^4-400(1.05)^3+1200(1.05)^1\\ &=1500(1.340095640625)+900(1.21550625)-400(1.157625)+1200(1.05)\\ &=2010.1434609375+1093.955625-463.05+1260\\ &=3901.0490859375 \end{aligned} $$

Rounding only the final result to the nearest cent, the fund’s value at the end of year 6 is $3,901.05.

Check. The year-5 receipt accumulates for one year, so it contributes $1,260 at year 6. The year-3 payout accumulates for three years and therefore subtracts $463.05, not just $400. The sign and timing of each term match its stated transaction.

Common mistake avoided. Treating every flow as though it had the same number of years to earn interest would ignore the different transaction dates. Each exponent must be the target date minus that particular flow’s date.

Worked Example: Choosing One Consistent Target Date

A hypothetical account starts with $5,000 at time 0. It pays out $700 at the end of year 2 and $1,200 at the end of year 4, then receives $1,000 at the end of year 5. Find the balance at the end of year 6. Assume a 6% effective annual interest rate, annual compounding, and no other transactions.

Method. The requested target is year 6, one year after the final receipt. The signed cash flows are \(+5000\), \(-700\), \(-1200\), and \(+1000\). Their respective accumulation periods are 6, 4, 2, and 1 years.

$$ \begin{aligned} \operatorname{FV}_6 &=5000(1.06)^6-700(1.06)^4-1200(1.06)^2+1000(1.06)^1\\ &=5000(1.418519112256)-700(1.26247696)-1200(1.1236)+1060\\ &=7092.59556128-883.733872-1348.32+1060\\ &=5920.54168928 \end{aligned} $$

Rounding only at the end to the nearest cent, the balance at the end of year 6 is $5,920.54.

Check. The year-5 receipt earns one year of interest, so it is worth \(1000(1.06)=1060\) at year 6. The two withdrawals remain negative when accumulated. Their combined value at year 6 is \(-883.733872-1348.32=-2232.053872\); adding this to the accumulated receipts gives $5,920.54168928.

Common mistake avoided. “At the end of year 6” is not the same as “immediately after the receipt at the end of year 5.” The latter is year 5, and the year-5 receipt would have zero years of accumulation at that target. This problem explicitly asks for year 6, so that receipt accumulates for one year.

Worked Example: A Stream That Begins After Time 0

A hypothetical reserve receives $2,000 at the end of year 1, pays $500 at the end of year 2, and receives $800 at the end of year 4. Find its value at the end of year 5. Assume an effective annual interest rate of 4%, annual compounding, and no other transactions.

Method. There is no time-0 cash flow. From years 1, 2, and 4 to the target year 5, the accumulation periods are 4, 3, and 1 years. The payment is entered as a negative amount.

$$ \begin{aligned} \operatorname{FV}_5 &=2000(1.04)^4-500(1.04)^3+800(1.04)^1\\ &=2000(1.16985856)-500(1.124864)+832\\ &=2339.71712-562.432+832\\ &=2609.28512 \end{aligned} $$

Rounding only the final result to the nearest cent, the reserve’s value at the end of year 5 is $2,609.29.

Check. The year-4 receipt is carried forward just one year, while the year-1 receipt is carried forward four years. The accumulated payment reduces the two positive contributions: \(2339.71712+832-562.432=2609.28512\).

Common mistake avoided. The first cash flow does not have to occur at time 0. Its exponent is still calculated from its actual date to the target date, not from the start of the timeline.

Common Timing and Sign Errors

The calculation is simple once the timeline is correct, but a small timing error can change several exponents. A useful working table records each date, signed amount, number of years to the target, and accumulated amount before the terms are summed.

CheckCorrect treatmentTypical error
Target dateState one valuation date and use it for every term.Describe year 5 as the target while calculating to year 6.
Accumulation periodUse \(T-t_j\) for the cash flow at \(t_j\).Use the same exponent for every flow.
Transaction signUse positive amounts for receipts and negative amounts for payments.Add a withdrawal as though it were a receipt.
Flow at targetInclude it with exponent zero, so its factor is 1.Give a target-date flow an extra year of interest.

A reliable check is to ask whether an early receipt has been accumulated for more years than a later receipt, and whether each payment reduces the result. As a further check, the value can be built forward across the timeline: accumulate the balance between events, then add the next signed flow at its date. This gives the same balance at the target date as the future-value sum.

If the calculated value is unexpectedly large or small, first recheck the target date, exponents, and signs before rounding. Keep intermediate values unrounded when practical; rounding each accumulated term early can create a small discrepancy in the final total. The result is a signed net value: it can be negative if the accumulated outflows exceed the accumulated receipts.

Key takeaway: To find the future value of an uneven stream, choose the target date, assign a sign to every flow, accumulate each flow for exactly \(T-t_j\) years, and add the accumulated amounts. The date and sign checks are as important as the arithmetic.

Check Your Understanding

For each problem, use the stated target date and effective annual rate. Round money to the nearest cent only at the final step.

  1. A reserve receives $1,000 at time 0 and $500 at the end of year 2. Find its value at the end of year 4 at an effective annual rate of 5%, with annual compounding and no other transactions. (Answer: $1,766.76)
  2. A hypothetical project account receives $2,400 at the end of year 1 and pays out $600 at the end of year 3. Find its value at the end of year 5 at an effective annual rate of 4%, with annual compounding and no other transactions. (Answer: $2,158.70)
  3. An account receives $3,000 at time 0, pays out $900 at the end of year 2, and receives $500 at the end of year 4. Find its value immediately after the year-4 receipt at an effective annual rate of 6%, with annual compounding and no other transactions. (Answer: $3,276.19)
  4. A fund receives $800 at time 0 and $600 at the end of year 1, then pays out $250 at the end of year 3. Find its value immediately after that year-3 payout at an effective annual rate of 3%, with annual compounding and no other transactions. (Answer: $1,260.72)
  5. A hypothetical account receives $1,000 at the end of year 1 and another $1,000 at the end of year 4, then pays out $300 at the end of year 5. Find its value at the end of year 7 at an effective annual rate of 5%, with annual compounding and no other transactions. (Answer: $2,166.97)
Clinical Biostats