Matching IRR Periods to Cash-Flow Spacing

Why the IRR Period Matters

An internal rate of return is not a rate without a time unit. If the cash flows in an IRR equation are one quarter apart, the rate that zeros that equation is an effective rate per quarter. Calling it an annual rate without conversion changes the meaning of the result. The same issue arises with monthly or semiannual cash flows.

The period is determined by the spacing used in the equation, not by the size of the cash flows or the wording of a report. Once the period rate is identified, convert it to the requested period by equating accumulation over the same length of time. This tutorial treats equally spaced cash flows; an equation with unequal time intervals requires the actual time of each cash flow and a consistent rate convention.

Definition: For cash flows $C_0,C_1,\ldots,C_n$ occurring at equally spaced times, the IRR $r$ is the effective rate per cash-flow interval that satisfies $$ \sum_{k=0}^{n}\frac{C_k}{(1+r)^k}=0. $$ If the interval is one month, $r$ is a monthly effective rate. If it is one quarter, $r$ is a quarterly effective rate. The usual domain for a periodic effective rate is $r>-1$, so the accumulation factor $1+r$ is positive.

The cash-flow timeline sets the unit of $k$. If each step in the equation advances one month, then $k=1$ means one month after the initial date, not one year later. The rate that solves the equation therefore applies to each such step. Before calculating, label the timeline and write down the interval length explicitly.

Converting Between Periods

Rates for different periods are equivalent when they produce the same accumulation over the same total length of time. Let $r$ be an effective rate per interval, and suppose $m$ such intervals fit into one year. One unit invested for a year accumulates to $(1+r)^m$. If $i$ is the equivalent effective annual rate, the same investment accumulates to $1+i$. Equating these values gives the conversion.

1+i=(1+r)^m, \qquad i=(1+r)^m-1.

The reverse conversion is $$ r=(1+i)^{1/m}-1. $$ This root is essential: an effective annual rate is not divided by the number of periods to obtain an equivalent effective periodic rate.

A different annual quote is the nominal annual rate convertible $m$ times per year, denoted $i^{(m)}$. By definition, its periodic rate is $i^{(m)}/m$. To be equivalent to a periodic effective rate $r$, it must satisfy $$ \frac{i^{(m)}}{m}=r, \qquad i^{(m)}=mr. $$ The nominal rate and the effective annual rate are different measures. The first is a stated annual rate whose periodic portions are applied $m$ times; the second is the actual one-year accumulation less one.

Why the Conversion Formula Holds

The conversion does not depend on a special IRR technique. It follows from repeated accumulation at the same periodic effective rate. Starting with one unit, after one interval the accumulated value is $1+r$. After two intervals it is $(1+r)(1+r)$. Continuing for $m$ equal intervals gives $(1+r)^m$. An equivalent annual effective rate must produce that same one-year accumulated value.

Identify the interval.
Read the timeline: for example, monthly cash flows have one-month intervals.

Read the IRR in that unit.
The rate in the equally spaced IRR equation applies once per interval.

Match accumulations.
Raise the periodic accumulation factor to the number of intervals in the requested period, or take the corresponding root for a conversion in the other direction.

Label the answer.
State whether the result is effective per period, effective annual, or nominal annual convertible at a specified frequency.

Worked Examples

Worked Example: A Quarterly IRR and Its Annual Equivalents

A small equipment project has cash flows of $-\$200$ now, $+\$110$ one quarter from now, and $+\$121$ two quarters from now. Determine the IRR per quarter, then report the equivalent effective annual rate and nominal annual rate convertible quarterly.

Method. Use one exponent step for each quarter in the IRR equation. Then convert the periodic effective rate to annual measures. This avoids treating a quarterly rate as though it were already effective annually.

The timeline has equal three-month intervals, so write $r$ as the effective quarterly IRR:

-200+\frac{110}{1+r}+\frac{121}{(1+r)^2}=0.

Test $r=0.10$. The first receipt has present value $110/1.10=100$. The second receipt has present value $121/(1.10)^2=121/1.21=100$. Thus the equation's left side is $-200+100+100=0$, so $r=10\%$ per quarter.

There are four quarters in a year. The effective annual rate is

(1.10)^4-1=1.4641-1=0.4641=46.41\%.

The nominal annual rate convertible quarterly is $4(0.10)=0.40$, or $40\%$. These annual figures answer different questions: the effective rate describes the full-year accumulation, while the nominal rate is four times the quarterly rate.

Check. At the quarterly rate, the present values of the two receipts total $\$200$, equal to the initial investment. The rate is therefore $10\%$ per quarter, not $10\%$ per year.

Worked Example: A Monthly IRR Reported as an Effective Annual Rate

A hypothetical installation requires $\$10{,}000$ immediately and returns $\$100$ at the end of month 1 and $\$10{,}100$ at the end of month 2. Find its IRR per month and equivalent effective annual rate.

Method. Because the receipts are one month apart, solve the IRR equation using a monthly rate. Then compound that monthly rate for 12 months. This avoids multiplying a monthly effective rate by 12 and labelling the result an effective annual rate.

-10{,}000+\frac{100}{1+r}+\frac{10{,}100}{(1+r)^2}=0.

Try $r=0.01$, or $1\%$ per month. The month-1 present value is $100/1.01=99.00990099\ldots$. The month-2 present value is $10{,}100/(1.01)^2=10{,}100/1.0201=9{,}900.990099\ldots$. Their sum is exactly $\$10{,}000$, so the equation is zero. The monthly IRR is $1\%$.

The equivalent effective annual rate is

(1.01)^{12}-1 =1.126825030\ldots-1 =0.126825030\ldots.

Rounded to four decimal places as a percentage, the effective annual rate is $12.6825\%$. The monthly rate is not $12.6825\%$; that is the equivalent annual rate after monthly accumulation.

Check. Substituting the monthly rate into the original equation gives present values of approximately $\$99.01$ and $\$9{,}900.99$, which total $\$10{,}000.00$. The annual conversion uses 12 monthly accumulation periods.

Worked Example: Converting an Annual Hurdle Rate for Monthly Cash Flows

A committee uses a $10\%$ effective annual hurdle rate to assess a hypothetical project with cash flows of $-\$1{,}000$ now, $+\$500$ at month 6, and $+\$600$ at month 12. Find the equivalent monthly effective rate and calculate the project's NPV at that hurdle rate.

Method. First take the twelfth root of the annual accumulation factor. Then use the resulting monthly rate for discounting, with six monthly periods to month 6 and twelve to month 12. This keeps the rate period consistent with the cash-flow dates.

Let $r$ be the equivalent monthly effective rate. Matching one-year accumulation gives

(1+r)^{12}=1.10, \qquad r=(1.10)^{1/12}-1 \approx 0.0079741404289.

Thus $r$ is approximately $0.7974\%$ per month. The equivalent nominal annual rate convertible monthly is

i^{(12)}=12\left((1.10)^{1/12}-1\right) \approx 0.0956896851,

or $9.5690\%$ when rounded to four decimal places as a percentage. This is a nominal annual rate, not the effective annual rate; the effective annual rate remains $10\%$.

For the NPV, six monthly accumulation periods give $(1+r)^6=(1.10)^{1/2}=\sqrt{1.10}$, and twelve give $(1+r)^{12}=1.10$. Therefore,

\begin{aligned} \operatorname{NPV} &=-1{,}000+\frac{500}{\sqrt{1.10}}+\frac{600}{1.10}\\ &=-1{,}000+476.7312946\ldots+545.4545455\ldots\\ &=22.1858401\ldots. \end{aligned}

Rounded to the nearest cent, the NPV is $\$22.19$. Check. The month-6 and month-12 discount factors are derived from the same $10\%$ effective annual accumulation, and their discounted receipts total $\$1{,}022.19$, exceeding the initial cost by the stated NPV.

Common Period-Matching Mistakes

A frequent error is to multiply a periodic effective rate by the number of periods in a year and call the result an effective annual rate. For the quarterly rate in the first example, that incorrect calculation is $4(10\%)=40\%$. It does not give the effective annual rate. The correct calculation is

(1.10)^4-1=46.41\%.

The $40\%$ figure is instead the nominal annual rate convertible quarterly. Multiplication is appropriate for that nominal quote because it is defined as the periodic rate times the conversion frequency.

Another trap is to read the time unit from a sentence such as “annual project return” rather than from the IRR equation. The rate in the equation belongs to the interval represented by one exponent step. If one step is a month, a solver's monthly output remains monthly even if a report requests an annual figure. Convert only after identifying the rate's unit.

Do not divide an effective annual rate by $m$ to obtain its equivalent periodic effective rate. Take the $m$th root of its accumulation factor.
Do not use $mr$ as the effective annual rate. It is the nominal annual rate convertible $m$ times.
Do not change the cash-flow spacing while keeping the same exponent. A cash flow six months away is six monthly intervals away, not one.
Label every reported rate. “$4\%$” is incomplete unless its period and effective or nominal basis are clear.

Period matching matters whenever an IRR is compared with a quoted annual rate, a loan rate, or a required return. A comparison is meaningful only after both rates are expressed on a consistent basis. For equally spaced cash flows, identify the interval first, solve or interpret the IRR in that interval, and then convert by matching accumulation.

This treatment is aligned with the SOA Exam FM (Financial Mathematics) syllabus. For cash flows that are not equally spaced, do not force them into a monthly or quarterly exponent sequence; the actual timing must be reflected in the valuation equation.

Check Your Understanding

For each problem, identify the rate period before converting. Rates in the answers are rounded only where indicated.

A project has equally spaced quarterly cash flows, and its IRR is $3\%$ per quarter. What is the equivalent effective annual rate? (Answer: $(1.03)^4-1=12.5509\%$.)
A monthly effective IRR is $0.8\%$. Find the equivalent effective annual rate. (Answer: $(1.008)^{12}-1\approx 10.0339\%$.)
An investment's IRR is $4.5\%$ per six-month interval. Find the equivalent effective annual rate and nominal annual rate convertible semiannually. (Answer: effective annual $=(1.045)^2-1=9.2025\%$; nominal $=2(4.5\%)=9.00\%$.)
What monthly effective rate is equivalent to an $8\%$ effective annual rate? (Answer: $(1.08)^{1/12}-1\approx 0.6434\%$ per month.)
A $10\%$ effective annual rate is to be expressed as a nominal annual rate convertible monthly. What is the nominal rate? (Answer: $12((1.10)^{1/12}-1)\approx 9.5690\%$.)

What You'll Learn