Focal-Date Consistency in Multi-Rate NPV

Why a Common Focal Date Matters

A cash-flow schedule may include payments on different dates, and the effective interest rate may differ from one interval to the next. Adding the listed amounts directly is not meaningful: a dollar at one date and a dollar at another date are not values measured at the same time. To calculate a net present value, first choose a focal date, then express every cash flow as a value at that date.

The main discipline is to use every interval rate along the path between the cash flow’s date and the focal date. Carry a cash flow forward through each intervening interval if it occurs earlier than the focal date. Discount it through each intervening interval if it occurs later. A rate for an interval is not automatically the rate for every other interval.

Definition: Let the valuation dates be $0,1,\ldots,n$, and let $C_k$ be the signed cash flow at date $k$, with an outflow negative and an inflow positive. Let $i_j$ be the effective rate applying over the interval from date $j-1$ to date $j$. The accumulation factor from date $s$ to date $t$, for $s<t$, is $$ A(s,t)=\prod_{j=s+1}^{t}(1+i_j). $$ The value of the schedule at focal date $T$ is the sum of all cash flows transferred to date $T$: earlier amounts are accumulated, and later amounts are discounted.

This setup assumes that the dates and interval rates are specified, that the rates are deterministic for the valuation being performed, and that each $i_j$ is effective over its stated interval. It does not assume one flat rate for the whole schedule. If the stated rate is annual but an interval is shorter than one year, an appropriate conversion or an explicitly stated interval rate is needed; the annual rate must not simply be treated as the rate for every shorter interval.

The Focal-Date Value Formula

For a cash flow at date $k$, its value at date $T$ depends on whether it is before or after the focal date. If $k\leq T$, accumulate it from $k$ to $T$. If $k>T$, discount it from $k$ back to $T$. Thus,

V_T = \sum_{k=0}^{T} C_k A(k,T) + \sum_{k=T+1}^{n}\frac{C_k}{A(T,k)}.

The first sum includes the cash flow at the focal date, if any, because $A(T,T)=1$. The second sum includes cash flows after the focal date. This formula values signed amounts, so outflows remain negative when they are transferred.

Why the Formula Works

The formula follows from transferring value one interval at a time. Consider an amount $C_k$ at date $k<T$. Over the first interval, it becomes $C_k(1+i_{k+1})$. Over the next interval, that accumulated amount is multiplied by $1+i_{k+2}$, and the process continues through date $T$. Therefore,

C_k(1+i_{k+1})(1+i_{k+2})\cdots(1+i_T) = C_k A(k,T).

For a future amount $C_k$ at date $k>T$, let $X$ be its equivalent value at date $T$. Accumulating $X$ from $T$ to $k$ must produce $C_k$, so $X A(T,k)=C_k$. Solving gives $X=C_k/A(T,k)$. Adding these date-$T$ equivalents gives the full schedule value.

Consistency result: Under the same deterministic interval factors, transferring a schedule from one focal date to another means transferring its already-calculated value by the accumulation factor between those dates. In particular, if $T<U$, then $V_U=V_TA(T,U)$. Because each factor $1+i_j$ is positive when $i_j>-1$, the sign of the value is unchanged by such a transfer. The dollar amounts differ, but they refer to equivalent values at different dates.

Worked Examples

Worked Example: Valuing Cash Flows at an Intermediate Date

A project has cash flows of $-\$1{,}000$ at date 0, $+\$400$ at date 1, and $+\$800$ at date 3. The effective rates are 5% from date 0 to 1, 7% from date 1 to 2, and 4% from date 2 to 3. Find the value at date 2.

Method. Date 2 is the focal date. Accumulate the date-0 and date-1 amounts to date 2; discount the date-3 amount one interval to date 2.

The date-0 outflow passes through the 5% and 7% intervals: $$ -\$1{,}000(1.05)(1.07)=-\$1{,}123.50. $$ The date-1 inflow passes through the 7% interval: $$ \$400(1.07)=\$428.00. $$ The date-3 inflow is discounted through the date-2-to-3 interval: $$ \frac{\$800}{1.04}=\$769.230769\ldots. $$ Therefore, $$ V_2=-\$1{,}123.50+\$428.00+\$769.230769\ldots =\$73.730769\ldots. $$ Rounded to the nearest cent, $V_2=\$73.73$.

Check. The transferred amounts sum to a positive value, as the date-2 inflow equivalents exceed the accumulated outflow by about \$73.73. The common mistake is to use one of the three rates for every cash flow; each amount instead uses only the rates on its own path to date 2.

Worked Example: Accumulating an Intermediate Inflow Correctly

A schedule has $-\$800$ at date 0, $+\$300$ at date 1, and $+\$700$ at date 3. The effective rates in the intervals from date 0 to 1, 1 to 2, and 2 to 3 are 4%, 6%, and 5%, respectively. Find the value at date 2.

Method. Carry the date-0 outflow through both the first and second intervals. Carry the date-1 inflow through the second interval only. Discount the date-3 inflow through the third interval only.

The three date-2 equivalents are $$ -\$800(1.04)(1.06)=-\$881.92, $$ $$ \$300(1.06)=\$318.00, $$ and $$ \frac{\$700}{1.05}=\$666.666666\ldots. $$ Adding them gives $$ V_2=-\$881.92+\$318.00+\$666.666666\ldots =\$102.746666\ldots. $$ Rounded to the nearest cent, $V_2=\$102.75$.

Check and trap. A common incorrect calculation leaves the date-1 inflow at \$300: $$ -\$881.92+\$300+\$666.666666\ldots =\$84.746666\ldots. $$ That calculation mixes a date-1 amount with date-2 amounts. The \$300 must earn 6% over the interval from date 1 to date 2, giving \$318 before it is added. The corrected date-2 value is \$102.75.

Worked Example: Respecting Six-Month Rate Periods

Each interval is six months. A schedule has $-\$1{,}200$ at date 0, $+\$500$ at date 2, and $+\$900$ at date 3. The effective rates for the intervals from date 0 to 1, 1 to 2, and 2 to 3 are 3%, 3%, and 4%, respectively. Find the value at date 1.

Method. The rates are effective per six-month interval, not per year. Accumulate the date-0 outflow one interval to date 1. Discount the date-2 inflow one interval and the date-3 inflow through two intervals.

The date-0 amount at date 1 is $$ -\$1{,}200(1.03)=-\$1{,}236.00. $$ The date-2 amount discounted to date 1 is $$ \frac{\$500}{1.03}=\$485.436893\ldots. $$ The date-3 amount must be discounted first through the 4% interval to date 2 and then through the 3% interval to date 1: $$ \frac{\$900}{(1.03)(1.04)} = \frac{\$900}{1.0712} = \$840.179238\ldots. $$ Thus, $$ V_1=-\$1{,}236.00+\$485.436893\ldots+\$840.179238\ldots =\$89.616131\ldots. $$ Rounded to the nearest cent, $V_1=\$89.62$.

Check and trap. Using only one discount factor for the date-3 amount would give $\$900/1.04=\$865.384615\ldots$, which discounts it only to date 2, not date 1. The date-3 flow crosses two intervals to reach the focal date. The stated six-month rates also must not be replaced by annual rates or treated as annual rates: each is already the effective rate for one six-month interval.

A Reliable Calculation Process

A short schedule prevents most focal-date errors. Keep the signed cash flows and the factors used to move them separate until every amount has been transferred to the chosen date.

Choose and label the focal date.
Write the date at which the final value is required. Do not assume that the phrase “net present value” means date 0 if another date is specified.

List interval rates in chronological order.
Record the rate that applies to each interval and identify its period length. For example, a stated six-month effective rate applies to one six-month interval.

Trace each cash flow to the focal date.
For an earlier flow, multiply by every intervening accumulation factor. For a later flow, divide by every intervening accumulation factor.

Add only date-consistent amounts.
Preserve each cash flow’s sign, sum the transferred amounts, and round the final result only after the addition.

Common Errors and Their Corrections

Most incorrect answers arise not from difficult arithmetic but from using a correct factor over the wrong interval. Before evaluating a product, check its starting date, ending date, and rate period.

Adding amounts from different dates. A cash flow at date 1 cannot be added directly to a value at date 2. Transfer both to the same focal date first.
Using only the rate nearest the cash flow. A flow several intervals away needs every interval factor along its path, not just one rate.
Using the wrong direction. Earlier amounts are multiplied to carry them forward; later amounts are divided to discount them back.
Applying an annual rate to a shorter interval without conversion. Confirm whether the given rate is effective per year, per six months, or per another period before using it.
Dropping the sign of an outflow. Accumulation and discounting change the date of a value, not whether it is an inflow or an outflow.
Rounding each transferred amount too early. Keep sufficient precision in intermediate values and round the final sum to the required monetary unit.

Focal-date consistency is useful whenever a project, financing arrangement, or investment schedule contains cash flows at multiple dates and more than one applicable rate. It also provides a practical diagnostic: if two calculations use the same dated cash flows and the same interval factors but produce values at different dates, their results should be related by the accumulation factor between those dates. If they are not, check for a missing interval, a reversed factor, or a mismatched rate period.

Key takeaway: A multi-rate NPV is a sum of cash flows expressed at one date. For each flow, identify its path to that date, use the effective factor for every interval on that path, and only then add the signed values.

Check Your Understanding

For each schedule, transfer every cash flow to the stated focal date before summing. Rates apply to the intervals as listed.

A schedule has $-\$500$ at date 0, $+\$200$ at date 1, and $+\$400$ at date 2. The effective rates are 4% from date 0 to 1 and 6% from date 1 to 2. Find the value at date 1. (Answer: \$57.36)
A schedule has $-\$1{,}000$ at date 0, $+\$350$ at date 2, and $+\$800$ at date 3. The interval rates from date 0 to 1, 1 to 2, and 2 to 3 are 2%, 5%, and 3%. Find the value at date 2. (Answer: \$55.70)
Each interval is six months. A schedule has $-\$2{,}000$ at date 0, $+\$900$ at date 2, and $+\$1{,}300$ at date 4. The effective six-month rates are 2%, 2.5%, 3%, and 1.5% in chronological order. Find the value at date 3. (Answer: \$54.06)
A schedule has $-\$1{,}500$ at date 0, $+\$700$ at date 1, and $+\$950$ at date 3. The effective annual rates for the three successive one-year intervals are 6%, 8%, and 5%. Find the value at date 2. (Answer: $-\$56.44$)

What You'll Learn