Reading Calendar-Year Diagonals

Why Calendar-Year Diagonals Matter

A loss triangle organizes observations by origin period and development age. A calendar-year diagonal answers a different question: which cells were valued at the end of the same calendar year? The cells may belong to different accident years and may be at different development ages, but they share a valuation date period.

Reading the diagonal correctly depends on the indexing convention. In this tutorial, annual origin periods are calendar years, and development age 1 is the first valuation at the end of the origin year. Development age 2 is the valuation at the end of the following year, and so on. A cell in accident year 2021 at development age 2, for example, is valued at the end of calendar year 2022.

This convention is consistent when origin periods are calendar years, development ages are annual, and the first valuation is at the end of the origin year. Other data arrangements can use a different first valuation or a different period definition. In those cases, assign the actual valuation period from the stated dates rather than applying this formula without checking its assumptions.

Finding an Annual Calendar-Year Diagonal

In a standard annual triangle, origin years increase as you move down the rows and development ages increase as you move to the right. Calendar year increases by one when either the origin year increases by one while development age stays fixed, or development age increases by one while origin year stays fixed. To keep the calendar year unchanged, moving down one row must be paired with moving left one development column.

For example, consider the following hypothetical cumulative paid loss triangle. The amounts are included to show that a cell’s calendar-year label is determined by its row and column, not by the loss amount.

The observed cells on the 2022 calendar-year diagonal are accident year 2020 at development age 3, accident year 2021 at development age 2, and accident year 2022 at development age 1. Each satisfies the same date calculation: \(2020+3-1=2022\), \(2021+2-1=2022\), and \(2022+1-1=2022\).

In the usual triangle layout, this equal-calendar-year set runs from the upper right toward the lower left. A diagonal is not necessarily complete: the available cells depend on the shape and valuation cutoff of the triangle. Identify the cells that exist; do not fill a blank cell merely because it would fit the date pattern.

Why Cells on a Diagonal Share a Valuation Period

The formula follows directly from how the periods are indexed. Give each calendar year its usual integer label. For an origin year \(y\), age 1 is valued at the end of year \(y\). Each increase of one in development age moves the valuation forward by one calendar year. Therefore, at development age \(j\), the valuation year is the origin year plus \(j-1\).

Now suppose two cells have the same calendar-year label \(C\). Their origin years and ages satisfy \(y_1+j_1-1=C\) and \(y_2+j_2-1=C\). Even when \(y_1\ne y_2\) and \(j_1\ne j_2\), both cells are assigned the same valuation year by the indexing rule. Rearranging also shows the diagonal relationship: \(j=C-y+1\). As the origin year increases by one along that diagonal, development age decreases by one.

This explains a diagonal’s meaning, but it does not imply that the cells contain the same claims, the same cumulative amount, or the same development information. Their common feature is the valuation period. The values in the cells remain observations for different origin periods and different maturities.

Quarterly Triangles and Period Indices

The same reasoning applies to quarterly triangles, but the arithmetic should be done in quarter units rather than treating a development-quarter number as a number of years. Number the calendar quarters consecutively: for example, Q1 2023 is followed by Q2 2023, Q3 2023, Q4 2023, and Q1 2024. If development quarter 1 is valued in the origin quarter, then development quarter \(j\) is \(j-1\) quarters after the origin quarter.

When using year-and-quarter labels, apply the quarter offset across year boundaries. For instance, moving three quarters forward from Q1 2023 gives Q4 2023, not Q1 2026. The ordinal-index approach makes this boundary handling explicit.

Common Mistakes and a Reliable Procedure

Calendar-year diagonal errors are often off-by-one errors or period-unit errors. Before assigning a label, state what the first development age means. If it is the valuation at the end of the origin year, the annual formula includes \(j-1\), not \(j\). If the triangle’s first valuation instead occurs one calendar year after the origin year, the mapping changes and must follow the stated valuation dates.

• Adding the age instead of the age offset. Under this tutorial’s convention, AY 2020 at age 3 is valued in 2022, because \(2020+3-1=2022\), not 2023.
• Reading a row as a diagonal. A row holds one origin year fixed as development age changes. A calendar-year diagonal holds the valuation year fixed while origin year and age change together.
• Using the wrong time unit. In a quarterly triangle, advance by quarters, including across year boundaries; do not treat a quarter number as an annual age.
• Assuming equal amounts or equal maturity. Cells on one calendar-year diagonal share valuation timing, not claim population, loss amount, or development age.
• Ignoring the convention or dates. The formula depends on the relationship between origin periods, development ages, and valuation periods. Confirm that relationship before using the index rule.

The practical value of this check is that it keeps the triangle’s two time dimensions distinct. Row-wise reading follows an origin period as it matures. Diagonal reading groups cells by when they were valued. Keeping those questions separate makes it less likely that a calendar-year label will be mistaken for an accident-year label or a development-age label.