Tutorials › CAS Exam 5 - Basic Ratemaking and Estimated Claim Liabilities › Selecting Historical and Prospective Trend Periods

CAS Exam 5 · Loss and Exposure Trending · Tutorial 150 of 989

Selecting Historical and Prospective Trend Periods

Use a consistent timeline and period midpoints to identify the duration over which historical experience is projected to a prospective rate period.

Intermediate 11 min read

What You'll Learn

  • Represent experience and prospective rate periods with clear start and end boundaries.
  • Find the midpoint of a full or partial calendar-year interval.
  • Calculate midpoint-to-midpoint time in months and convert it to years.
  • Distinguish the trend duration from the gap between period endpoints.
  • Recognize when a simple midpoint depends on reasonably uniform experience.

Why Trend Periods Are Measured Between Midpoints

A ratemaking trend connects the time represented by historical experience with the time represented by the rates being developed. Those are not generally the start or end dates of either period. When experience is reasonably spread across its interval, the historical period is represented by its midpoint. A prospective rate period is represented in the same way: by the midpoint of the period during which the rates will apply.

The duration used for a trend calculation is therefore the elapsed time from the historical midpoint to the prospective midpoint. It is not simply the time between the end of experience and the start of the prospective period. That gap omits part of each interval: experience is occurring before its midpoint, and the prospective rate period continues after its midpoint.

Definition: The historical trend period is the time represented by the experience measure, usually its midpoint when experience is reasonably uniform. The prospective trend period is the time represented by the prospective rate period, usually its midpoint. The midpoint-to-midpoint duration is the elapsed time from the historical midpoint to the prospective midpoint, expressed in the time units used for the trend.

A reliable way to calculate the duration is to draw or write a timeline, identify the boundary dates for each interval, find each midpoint, and subtract the historical midpoint from the prospective midpoint. For annual trend calculations, convert the resulting months or days into years using a consistent convention.

Representing Periods on a Timeline

Treat an interval as running from its start boundary to its end boundary. For example, calendar years 2022 and 2023 together run from January 1, 2022, to January 1, 2024. The final date of 2023 is December 31, but the next boundary is January 1, 2024. Using boundaries avoids ambiguity about whether an endpoint is included.

For an interval with evenly distributed experience, the midpoint is halfway between its start and end boundaries. A one-year calendar period has a midpoint six months after its start; a two-year period has a midpoint one year after its start. A partial-year prospective period is handled the same way. Do not assume that every period midpoint falls on January 1 or July 1.

$$ t = \text{prospective midpoint} - \text{historical midpoint} $$

The subtraction is elapsed calendar time, not subtraction of year labels alone. For example, January 1, 2023, to October 1, 2024, is 21 months, or 1.75 years. If dates do not fall on month boundaries, use exact elapsed days or a stated day-count convention; do not silently treat a partial month as a full year.

Worked Example: Two Years of Experience and a January Rate Period

A hypothetical insurer combines experience from July 1, 2021, through June 30, 2023. Assume the experience is reasonably uniform over that interval. The indicated rates are intended for a twelve-month period beginning January 1, 2025. Find the midpoint-to-midpoint duration in years.

Method: represent both intervals by their midpoints. Write the historical interval using boundaries: July 1, 2021, to July 1, 2023. Its length is 24 months, so its midpoint is 12 months after its start:

$$ \text{Historical midpoint} = \text{July 1, 2022}. $$

The prospective rate period runs from January 1, 2025, to January 1, 2026. Its midpoint is six months after its start:

$$ \text{Prospective midpoint} = \text{July 1, 2025}. $$

From July 1, 2022, to July 1, 2025, is 36 months. Converting months to years gives:

$$ t = \frac{36}{12} = 3.00\text{ years}. $$

Check. The historical midpoint is halfway through the two-year experience interval, and the prospective midpoint is halfway through the rate year. The dates are three years apart. The common mistake is to count only from the end of experience, June 30, 2023, to the start of the rate period, January 1, 2025. That gap is about 18 months, but it is not the midpoint-to-midpoint trend duration. The omitted halves of the historical and prospective intervals account for the difference.

Partial-Year Periods Require the Same Method

A rate period does not have to begin on January 1, and the historical experience period does not have to be a calendar year. Find each midpoint from its own endpoints before comparing dates. This matters because using a period’s start date or end date in place of its midpoint can shift the calculated duration by several months.

Worked Example: Two Calendar Years and an April Effective Date

A hypothetical book of business has experience for calendar years 2022 and 2023, treated as one uniform interval. The prospective rates apply from April 1, 2024, through March 31, 2025. Find the midpoint-to-midpoint duration in years.

Step 1: Find the historical midpoint. The combined experience interval runs from January 1, 2022, to January 1, 2024. Its length is two years, so its midpoint is January 1, 2023.

Step 2: Find the prospective midpoint. Represent the rate period by the boundaries April 1, 2024, and April 1, 2025. The period is twelve months long, so its midpoint is six months after April 1, 2024: October 1, 2024.

Step 3: Subtract the dates. January 1, 2023, to January 1, 2024, is 12 months. January 1, 2024, to October 1, 2024, is 9 months. The total is 21 months:

$$ t = \frac{12+9}{12} = \frac{21}{12} = 1.75\text{ years}. $$

Check. The historical midpoint is in January 2023 and the prospective midpoint is in October 2024, so the answer must be less than two years. The common mistake is to count from the experience midpoint to the end of the prospective period, which would add six unnecessary months. Another mistake is to count by year labels without accounting for the October prospective midpoint.

Why the Midpoint Is a Useful Representative Date

The midpoint convention gives a single representative date for an interval whose experience is spread through time. One justification is that, under uniform weighting, the average date in the interval is its midpoint. Put dates on a numerical time scale, let the interval start at \(a\) and end at \(b\), and let the relative weight per unit of time be constant. The average time is:

$$ \bar{x} = \frac{\int_a^b x\,dx}{b-a} = \frac{\left[x^2/2\right]_a^b}{b-a} = \frac{(b^2-a^2)/2}{b-a} = \frac{(b-a)(b+a)/2}{b-a} = \frac{a+b}{2}. $$

Thus the midpoint is the average date when the time weighting is uniform. Using the historical and prospective midpoints identifies the interval between the central dates represented by the two periods. This is the standard period-selection convention for a reasonably uniform experience measure.

The uniformity assumption matters. If experience is concentrated in a particular part of the interval, its representative date may not be the calendar midpoint. For instance, if most exposures or losses occur late in a period, the simple midpoint can misrepresent the timing. A weighted average date may be more appropriate when the data support one. The midpoint convention is a practical representation of the interval, not a claim that all observations occurred on that date.

Also distinguish the midpoint convention from a claim that averaging a nonlinear trend factor over every date in an interval always gives exactly the factor at the midpoint. The convention identifies the representative time for the period. It does not remove the need to consider the assumptions behind a trend model or the distribution of experience within the interval.

Worked Example: A Midyear Prospective Period

A hypothetical insurer uses experience from January 1 through December 31, 2024, and assumes the experience is uniform. New rates apply from July 1, 2025, through June 30, 2026. Determine the trend duration in years. Show why measuring only the gap between the intervals gives the wrong result.

Step 1: Find the historical midpoint. The experience interval is January 1, 2024, to January 1, 2025. Halfway through the year is July 1, 2024.

Step 2: Find the prospective midpoint. The rate interval is July 1, 2025, to July 1, 2026. Halfway through the year is January 1, 2026.

Step 3: Calculate the elapsed time. July 1, 2024, to July 1, 2025, is 12 months. July 1, 2025, to January 1, 2026, is 6 months. Therefore:

$$ t = \frac{12+6}{12} = 1.50\text{ years}. $$

Step 4: Compare with the incorrect gap calculation. The period after the historical interval ends and before the prospective interval begins is January 1, 2025, to July 1, 2025, or 6 months. Using that gap alone would give \(6/12=0.50\) years. It omits the six months from the historical midpoint to the historical period’s end and the six months from the prospective period’s start to its midpoint. Adding these omitted halves gives \(0.50+0.50+0.50=1.50\) years, which agrees with the midpoint calculation.

Check. The two midpoints are July 1, 2024, and January 1, 2026, exactly 18 months apart. The correct duration is 1.50 years, not the six-month gap between the intervals.

Common Errors and Practical Checks

Before using a selected duration in a trend calculation, check that the timeline matches the question’s experience and prospective periods. These are common sources of error:

  • Using the gap between intervals. The gap from the end of experience to the start of the rate period is generally shorter than the midpoint-to-midpoint duration.
  • Using the start or end of one period as its representative date. Find both midpoints independently, including for partial-year intervals.
  • Counting by year labels only. A date in October is not equivalent to a date in January; calculate elapsed months or days.
  • Mixing units. If the result is 21 months and the trend period is in years, convert it to \(21/12=1.75\) years.
  • Assuming uniformity without checking the setup. A simple calendar midpoint is appropriate when the period’s experience is reasonably uniform or the problem directs that convention. A concentrated or changing distribution may call for a weighted representative date.
Key takeaway: Mark the start and end boundaries of the historical experience period and the prospective rate period. Find both midpoints, then measure elapsed time from the historical midpoint to the prospective midpoint. Keep the unit conversion explicit and use the uniformity assumption only when it is reasonable or specified.

Check Your Understanding

For each hypothetical scenario, use period midpoints and report the duration in years.

  1. Experience covers calendar years 2021 and 2022 and is treated as one uniform interval. Rates apply from April 1, 2024, through March 31, 2025. What is the midpoint-to-midpoint duration? (Answer: 2.75 years)
  2. Experience runs from October 1, 2022, through September 30, 2024, and is reasonably uniform. The prospective rate period is January 1 through December 31, 2026. Find the duration. (Answer: 2.75 years)
  3. A uniform experience interval is calendar year 2024. Prospective rates apply for calendar year 2025. Find the duration between the period midpoints. (Answer: 1.00 year)
  4. Experience covers calendar years 2022 and 2023, treated as one uniform interval. Rates apply from July 1, 2024, through June 30, 2025. Find the duration. (Answer: 2.00 years)
  5. A uniform historical interval runs from January 1, 2024, through December 31, 2025. Prospective rates apply from October 1, 2026, through September 30, 2027. Find the midpoint-to-midpoint duration. (Answer: 2.25 years)
Clinical Biostats