IRR for Irregularly Timed Cash Flows

Why Timing Matters in an IRR Equation

An internal rate of return is the rate that makes the net present value of a cash-flow stream equal to zero. When payments are evenly spaced, each cash flow can be indexed by its payment period. When dates are irregular, the period index is not enough: a receipt after three years must be discounted for three years, even if it is only the second receipt.

The key is to express each date as an elapsed time in years from a common valuation date, using the year-count convention stated in the problem. Each cash flow is then discounted using its own elapsed time. This is aligned with the SOA Exam FM (Financial Mathematics) syllabus.

Definition: For cash flows $C_0,C_1,\ldots,C_n$ occurring at elapsed times $t_0,t_1,\ldots,t_n$ years from a chosen valuation date, the annual effective internal rate of return $r$ is a rate satisfying $$ \sum_{j=0}^{n} C_j(1+r)^{-t_j}=0. $$ Here, a positive $C_j$ is a receipt and a negative $C_j$ is a payment. The equation assumes a single constant annual effective rate over the time horizon. The times $t_j$ must be measured under the stated year-count convention.

The cash flows need not occur at integer times, and they need not be equally spaced. For this tutorial’s examples, the dates and conventions give whole-year times; the essential setup is still to use the elapsed time for each date rather than the order in which the cash flow appears. More complex non-integer exponents are a separate calculation issue.

From Dated Cash Flows to the IRR Equation

First identify the valuation date, then calculate the elapsed time from that date to every cash-flow date. Under Actual/365, divide the actual number of days by 365. Under a different convention, use that convention’s prescribed day count and denominator. Finally, discount each cash flow using its own time.

For example, if the valuation date is January 1, 2025, and a receipt occurs on January 1, 2028, the Actual/365 elapsed time is $1095/365=3$ years. A cash flow dated January 1, 2026 has time $365/365=1$ year. These two receipts are not one and two years from the valuation date merely because they are the first and second receipts.

Choose the valuation date.
Usually this is the date of the initial investment, assigned time zero.

Calculate each elapsed time.
Apply the specified year-count convention separately to each cash-flow date.

Write the NPV equation.
Multiply each cash flow by $(1+r)^{-t}$, using that cash flow’s own elapsed time $t$.

Solve and check.
Find a rate that makes the equation zero, then substitute it back into the NPV calculation.

Why the Exponent Is Elapsed Time

Suppose the annual effective rate is $r$, and the same annual accumulation model applies throughout the investment. One dollar invested at the valuation date accumulates to $1+r$ after one year and to $(1+r)^k$ after $k$ years. Consequently, an amount $C$ payable at time $t$ has present value $C/(1+r)^t$: accumulating that present value for $t$ years gives $C$ at the payment date.

The NPV at rate $r$ is the sum of the present values of all the dated cash flows. An IRR is a rate for which that sum is zero. Thus the exponent comes from the time between the valuation date and the cash-flow date—not from the cash flow’s position in a list.

Worked Example: Unequal Year Gaps Under Actual/365

A hypothetical project requires $1,000 on January 1, 2025. It pays $550 on January 1, 2026, and $665.50 on January 1, 2028. Using Actual/365, set up the IRR equation and verify that $r=10\%$ is a solution.

Method. Convert dates to elapsed years from January 1, 2025, then discount each amount by its own time exponent.

The first payment is 365 days after the valuation date, so $t_1=365/365=1$. The second is 1,095 days after it, so $t_2=1095/365=3$. The initial payment occurs at $t_0=0$. Therefore the equation is

-1000+\frac{550}{(1+r)^1}+\frac{665.50}{(1+r)^3}=0.

At $r=0.10$, the first receipt’s present value is

\frac{550}{1.10}=500.

Since $1.10^3=1.331$, the second receipt’s present value is

\frac{665.50}{1.331}=500.

The total present value of receipts is $500+500=1000$, exactly offsetting the $1,000 initial outflow. The NPV is zero, so $10\%$ is an IRR. This is a conventional cash-flow pattern—one initial outflow followed only by receipts—so there is no second sign reversal to complicate the interpretation.

Common mistake avoided: Discounting the second receipt by $(1+r)^2$ because it is the second receipt. Its date is three years after the valuation date, so its exponent is 3.

Applying a Specified Year-Count Convention

A date is not itself an exponent. The year-count convention translates calendar dates into year units. If the problem specifies Actual/365, count actual calendar days and divide by 365. A different convention can produce different elapsed times and therefore a different IRR equation. Do not replace a stated convention with a convenient count of payment intervals.

In the next example, the dates are chosen so Actual/365 gives exact whole-year times. The calculation illustrates that a cash flow occurring after three years uses exponent 3 even though it is only the second receipt.

Worked Example: Solving from Dated Cash Flows

A hypothetical investment pays $13,250 on January 1, 2025. It receives $810 on January 1, 2026 and $15,746.40 on January 1, 2028. Under Actual/365, determine the annual effective IRR.

Method. Set the January 1, 2025 payment date as time zero, convert both receipt dates to years, and solve the resulting NPV equation.

There are 365 days from January 1, 2025 to January 1, 2026, giving $t_1=1$. There are 1,095 days from January 1, 2025 to January 1, 2028, giving $t_2=3$. Thus

-13250+\frac{810}{1+r}+\frac{15746.40}{(1+r)^3}=0.

Test $r=0.08$. Since $1.08=27/25$, the first receipt has present value

\frac{810}{1.08}=810\left(\frac{25}{27}\right)=750.

Also $1.08^3=1.259712$, so the second receipt has present value

\frac{15746.40}{1.259712}=12500.

The receipts’ present values sum to $750+12500=13250$. Therefore the NPV is $-13250+13250=0$, and the IRR is $8\%$.

Check. The present values reproduce the initial investment exactly. A solver can also be checked by substituting its rate back into the dated-cash-flow equation and confirming that NPV is approximately zero, subject only to displayed rounding.

Common mistake avoided: Using exponents 1 and 2 because there are two receipts. The second receipt is three years from the initial date, so the exponent is 3.

Solving an Irregular-Timing IRR Numerically

When the rate is not immediately recognizable, use an IRR-solving method on the NPV equation. The methods used for evenly spaced cash flows still apply once the equation has been set up correctly; the crucial difference is that the exponents now reflect the actual elapsed times. For conventional cash flows, NPV decreases as the rate increases, so opposite NPV signs at two trial rates bracket the root.

Worked Example: Bracketing an IRR with Unequal Payment Gaps

A hypothetical project costs $1,000 today, pays $400 one year later, and pays $800 three years after today. Times are measured in years from the investment date. Estimate its annual effective IRR to three decimal places.

Method. Write the date-specific NPV equation, evaluate it at trial rates to bracket the root, and refine the rate numerically.

\operatorname{NPV}(r)=-1000+\frac{400}{1+r}+\frac{800}{(1+r)^3}.

At $r=8.25\%$, $1+r=1.0825$ and $(1+r)^3=1.2684802656$. The present values are approximately

\frac{400}{1.0825}=369.5150,\qquad \frac{800}{1.2684802656}=630.6760.

Thus $\operatorname{NPV}(0.0825)\approx-1000+369.5150+630.6760=0.1910$, which is positive.

At $r=8.30\%$, $1+r=1.083$ and $(1+r)^3=1.270238787$. Then

\frac{400}{1.083}=369.3444,\qquad \frac{800}{1.270238787}=629.8028,

so $\operatorname{NPV}(0.0830)\approx-1000+369.3444+629.8028=-0.8528$. The NPV changes sign between 8.25% and 8.30%, bracketing the IRR. Numerical refinement gives approximately $8.2593\%$, or $8.259\%$ to three decimal places.

To check the rounded result, at $r=8.259\%$ the receipt present values are approximately $369.48 and $630.52, totaling $1,000.00 to the nearest cent. The rounded-rate NPV is therefore approximately $0.00 at that precision.

Common mistake avoided: Using exponent 2 for the $800 receipt because it is the second receipt. The project receives it at year 3, so its discount factor is $(1+r)^{-3}$.

Common Errors and When the Setup Does Not Apply

Irregular timing changes how the cash flows are discounted, not the definition of IRR. The equation still asks for a rate that makes the dated cash flows’ present values sum to zero. However, the result depends on the chosen year-count convention and on the assumption of a single annual effective rate.

Using receipt number as time. The first receipt is not necessarily at year 1, and the second is not necessarily at year 2. Use its date relative to the valuation date.
Using the interval since the previous cash flow. Unless the equation is deliberately being compounded between successive dates, each cash flow in the standard NPV equation is discounted from its own date back to the common valuation date.
Mixing units. If $r$ is an annual effective rate, the exponents must be in years. Do not enter a day count as an exponent without converting it by the specified convention.
Ignoring the stated convention. Changing from one day-count convention to another can change the time exponents and the calculated IRR.

This single-rate equation is not a term-structure valuation model: it assumes the same annual effective rate applies across all cash-flow dates. It also does not establish that an IRR exists or is unique for every possible cash-flow pattern. For conventional cash flows, where there is one initial outflow followed by receipts, the usual monotonic NPV behavior supports a unique root when the NPV crosses zero. With more sign changes, existence and uniqueness require care.

Key takeaway: In an irregularly timed IRR calculation, date conversion comes before rate solving. Find each cash flow’s elapsed time under the specified convention, place that time in its own discount exponent, and verify the result by checking that NPV is zero.

Check Your Understanding

For each problem, use the stated times or year-count convention, write the dated IRR equation, and check the proposed result.

A project pays $900 at time 0, receives $330 at year 1, and receives $798.60 at year 3. Set up the IRR equation and verify the rate. (Answer: $-900+330/(1+r)+798.60/(1+r)^3=0$; IRR $=10\%$.)
A hypothetical investment costs $2,400 on January 1, 2025, receives $600 on January 1, 2026, and receives $2,116.80 on January 1, 2028. Under Actual/365, state the times and verify the IRR. (Answer: times $0,1,3$; $-2400+600/(1+r)+2116.80/(1+r)^3=0$; IRR $=5\%$.)
A project costs $1,000 at time 0, receives $500 at year 1, and receives $626.40 at year 2. Write the equation and verify that the annual effective IRR is 8%. (Answer: $-1000+500/(1+r)+626.40/(1+r)^2=0$; IRR $=8\%$.)
A project costs $1,000 at time 0, receives $400 at year 1, and receives $800 at year 3. Is 8.25% an exact IRR? Use the NPV sign to determine whether the IRR is above or below 8.25%. (Answer: No; $\operatorname{NPV}(8.25\%)\approx+\$0.19$, so for this conventional cash-flow pattern the IRR is above 8.25%.)

What You'll Learn