Consistent Periods for Cash Flows and Discount Rates

Why Period Matching Matters

An NPV calculation discounts each future cash flow from its payment date to the valuation date. The rate and the time exponent must describe the same period. If a rate is monthly, the exponent counts months; if it is quarterly, the exponent counts quarters. A mathematically correct discounting formula can still produce a wrong NPV when the rate and exponent use different time units.

The first step is therefore not to substitute numbers into an NPV formula. It is to identify how the rate is quoted, how often it is effective, and how many of those periods elapse before each cash flow. The examples below assume certain cash flows, a constant rate, and valuation at time 0. They do not include taxes, inflation adjustments, or changes in rates during the project.

Definition: A rate period is the time interval over which a stated interest rate applies. A cash flow at a future date must be discounted by the accumulation factor covering the entire interval from time 0 to that date. The rate period and the exponent or elapsed-time input used to form that factor must be consistent.

Write NPV in the Rate's Own Periods

If a rate $j$ is effective per period, and a cash flow $C_k$ occurs $k$ such periods from now, its present value is $C_k/(1+j)^k$. For a sequence of cash flows, add the present values, including any initial outlay as a negative cash flow. Thus, when all cash flows occur at integer multiples of the rate period,

\operatorname{NPV}=\sum_{k=0}^{n}\frac{C_k}{(1+j)^k}.

Here $C_k$ is the net cash flow at the end of period $k$; $C_0$ is undiscounted because it occurs at the valuation date. This form applies directly when the cash-flow dates line up with the periods for which $j$ is effective. If the dates do not line up, an accumulation convention for the fractional interval must be specified; it is not valid simply to use a fractional exponent without a model that supports it.

Rate conversion: A nominal annual rate $i^{(m)}$, convertible $m$ times per year, has an effective rate per conversion period of $j=i^{(m)}/m$. Under this convention, $k$ conversion periods accumulate by $(1+j)^k$. An effective annual rate $i$ instead accumulates by $1+i$ over one year. It is not generally interchangeable with a nominal rate divided by the number of periods.

Why the Matching Formula Holds

The period-matching rule follows by applying compound accumulation one rate period at a time. If $j$ is effective per period, one unit grows to $1+j$ after one period. After two periods it grows to $(1+j)(1+j)=(1+j)^2$, and repeating this argument gives $(1+j)^k$ after $k$ periods. Therefore, a future amount $C_k$ at that date has present value $C_k/(1+j)^k$: accumulating that present value for $k$ periods returns exactly $C_k$.

For a nominal annual rate $i^{(m)}$ convertible $m$ times per year, the definition of the quote assigns $i^{(m)}/m$ to each conversion period. If a cash flow occurs after $t$ years and $mt$ is an integer, it is $mt$ conversion periods away, so the factor is $(1+i^{(m)}/m)^{mt}$. The exponent is not $t$, unless the rate period is one year.

Read the rate quote.
Determine whether it is an effective annual rate, a nominal rate with a stated conversion frequency, or an effective rate per some other interval.

Convert if needed.
For a nominal annual rate convertible $m$ times yearly, calculate the per-period rate $i^{(m)}/m$. Do not divide an effective annual rate by $m$ and call the result its effective rate per period.

Count matching periods.
For each cash flow, count the number of periods at that rate from time 0 to its payment date.

Discount and add.
Use the appropriate accumulation factor for each date, preserve the cash-flow signs, and then sum the present values.

Worked Examples

Worked Example: Monthly Rate and Month-Dated Receipts

A hypothetical project requires $1,000 immediately and returns $400 at the end of month 6 and $700 at the end of month 12. The annual nominal discount rate is 12% convertible monthly. Find the NPV to the nearest cent. Assume the rate remains constant and the receipts are certain.

Method. Convert the nominal annual rate to its effective monthly rate, then count the months to each receipt. This avoids using an annual rate-period exponent for cash flows dated in months.

The monthly rate is $0.12/12=0.01$, or 1%. The first receipt is six monthly periods away and the second is twelve monthly periods away. Therefore,

\begin{aligned} \operatorname{NPV} &=-1000+\frac{400}{(1.01)^6}+\frac{700}{(1.01)^{12}}\\ &=-1000+376.818094\ldots+621.214458\ldots\\ &=-1.967448\ldots \end{aligned}

The NPV is -$1.97 to the nearest cent. As a check, the two receipts have a combined present value of about $998.03, which is $1.97 less than the $1,000 outlay. The project has negative NPV under the stated rate and cash-flow assumptions.

Worked Example: Effective Annual Rate With Fractional Years

A hypothetical investment costs $1,400 now and pays $660 after six months and $1,331 after 18 months. The effective annual rate is 21%. Assume compound accumulation for fractional years, so an amount invested for $t$ years accumulates by $(1.21)^t$. Find the NPV.

Method. Use the stated annual effective-rate model with time measured in years. The fractional exponents are justified here by the explicit fractional-year compounding assumption.

The six-month date is $0.5$ years away, and the 18-month date is $1.5$ years away. Since $\sqrt{1.21}=1.1$, the accumulation factors are

(1.21)^{0.5}=1.1, \qquad (1.21)^{1.5}=1.21(1.1)=1.331.

The present values are $660/1.1=600$ and $1331/1.331=1000$. Thus,

\operatorname{NPV}=-1400+600+1000=200.

The NPV is $200.00. The check is direct: the two discounted receipts total $1,600, which exceeds the initial cost by $200. A fractional-year exponent is appropriate in this example because the problem explicitly specifies that model; without such a convention, the rate quote alone need not determine how to treat a fraction of a year.

Worked Example: Quarterly Rate and Annual Cash-Flow Dates

A hypothetical project costs $900 now and returns $400 at the end of year 1 and $600 at the end of year 2. The annual nominal rate is 8% convertible quarterly. Find the NPV to the nearest cent, assuming a constant rate and certain cash flows.

Method. Convert the quoted rate to a quarterly rate and count four quarters per year. This avoids mistakenly using the quarterly rate as if it were effective annually.

The quarterly rate is $0.08/4=0.02$, or 2%. The year-1 and year-2 receipts occur after four and eight quarters, respectively. The accumulation factors are

(1.02)^4=1.08243216, \qquad (1.02)^8=1.171659381002\ldots.

Their present values are

\frac{400}{(1.02)^4}=369.538171\ldots, \qquad \frac{600}{(1.02)^8}=512.094223\ldots.

Therefore,

\operatorname{NPV} =-900+369.538171\ldots+512.094223\ldots =-18.367607\ldots.

The NPV is -$18.37 to the nearest cent. The discounted receipts total about $881.63, confirming that they fall short of the $900 outlay by about $18.37.

Common Period-Mismatch Traps

A frequent error is to recognize the right per-period rate but use the wrong exponent. In the quarterly example, using 2% with exponents 1 and 2 would treat the annual receipts as if they were one and two quarters away. It would instead calculate

-900+\frac{400}{1.02}+\frac{600}{(1.02)^2} =68.858\ldots,

which is not the NPV under the stated quarterly quote. The correct exponents are 4 and 8, giving -$18.37. The opposite error is also possible: using a rate quoted per year with a monthly exponent. Both errors arise from failing to match the rate period to the elapsed-time unit.

Other checks help catch mistakes before finalizing a calculation:

Label the rate beside its unit. For example, write “2% per quarter,” not just “2%.”
Write each payment date as a period count. A payment at the end of 18 months is 18 monthly periods from now, but 6 quarterly periods if quarterly periods are being used.
Do not confuse rate conversion rules. Dividing a nominal convertible rate by its conversion frequency gives the effective rate per conversion period. An effective annual rate has a different definition.
Check the fractional-period assumption. If payment dates fall between conversion dates, use a stated model that specifies the accumulation over the partial interval rather than assuming a convention that was not given.
Keep signs and dates separate. A correct discount factor applied to the wrong payment date, or to a cash flow with the wrong sign, still gives an incorrect NPV.

Key takeaway: For every NPV term, identify the time from valuation to payment, the effective rate for the chosen unit, and the number of those units elapsed. A cash flow's discount factor is correct only when all three describe the same accumulation interval.

Check Your Understanding

For each hypothetical project, assume certain cash flows and a constant rate. Match the rate period to the cash-flow dates before calculating.

A project costs $900 now and pays $1,000 at the end of month 12. The annual nominal rate is 12% convertible monthly. Find the NPV to the nearest cent. (Answer: -$12.55)
A project costs $1,000 and pays $500 at the end of year 1 and $600 at the end of year 2. The annual nominal rate is 8% convertible quarterly. Find the NPV to the nearest cent. (Answer: -$25.98)
A project costs $1,500 now and pays $800 at the end of year 1 and $900 at the end of year 2. The effective monthly rate is 0.5%. Find the NPV to the nearest cent. (Answer: $51.99)
A project costs $900 now and pays $1,000 at the end of year 2. The annual nominal rate is 10% convertible semiannually. Find the NPV to the nearest cent. (Answer: -$77.30)
A project costs $1,600 now and pays $550 after six months and $1,331 after 18 months. The effective annual rate is 21%, with compound accumulation for fractional years. Find the NPV. (Answer: -$100.00)

What You'll Learn