Calendarization

In This Article

• What formula is used for calendarization?
• Which date is the fiscal year-end typically adjusted to?
• Why is calendarization necessary for comps analysis?
• What are the steps to calendarize financial data in Excel?

Calendarization of Financial Data

By setting a consistent year-end date, the standardized financial metrics can be compared to that of industry peers.

Calendarization is the process of adjusting a company’s financials for the ending fiscal dates to match the calendar year.

Under U.S. GAAP accounting, public companies must file quarterly reports on their financial performance (10-Q), including a comprehensive end-of-year report (10-K).

Most companies file their year-end reports with December 31 as the fiscal year (FY) ending date, aligning with the calendar year.

Certain companies, however, opt to report on a different schedule, such as Apple (NASDAQ: AAPL), which files its 10-K at the end of September.

^{Apple Fiscal Year Ending Date (Source: 10-K)} 

Comps Analysis Calendarization

To compare the financial data among different companies – particularly in comparable company analysis – it is necessary to align the fiscal year ending dates among the entire peer group.

In such cases, the operating metric in the valuation multiple – e.g. EBITDA, EBIT – must be adjusted so that the metric covers identical time frames among companies.

Without normalized year-end dates, the valuation multiples will be skewed and likely cause less reliable conclusions due to the inconsistencies, i.e. the performance reflected is spread across different periods (and thus, not truly “comparable”).

Calendarization is especially important for industries with high seasonality (e.g. retail), as full-year performance tends to be heavily concentrated around the holidays and may vary from year to year.

Calendarization Formula

The steps involved in calendarization are relatively straightforward, as illustrated by the formula for revenue shown below.

Calendarized Revenue Formula

• Calendarized Revenue = [Month × FYA Revenue ÷ 12] × [(12 – Month) × NFY Revenue ÷ 12]

Where:

• Month: Fiscal Year Ending Month
• FYA: Fiscal Year Actual
• NFY: Next Fiscal Year

Here, the term “Month” refers to the month the company’s fiscal year ends, e.g. if the fiscal year ends on June 30, the month will be six.

Calendarization Calculator – Excel Model Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

Submit

Email provided

Your Download is Ready

Submitting ...

Calendarization Example Calculation

Suppose a company has a fiscal year ending date of September 30 and you are given the task of calendarizing its revenue.

In FY-2021, the company generated $80 million in revenue, which is projected to grow to $100 million in the following year.

• 2021A Revenue: $80m
• 2022E Revenue: $100m

To calculate the “Year 1 Calendarized Revenue” – i.e. fiscal year ending 12/31/21 – we must adjust the financials so that 75% of the data is contributed by 2021A and the remaining 25% stems from 2022E.

• 2021A (%): 9 ÷ 12 = 75%
• 2022E (%): (12 – 9) ÷ 12 = 25%

Given those adjustment factors (%), we’ll multiply the percentage by the corresponding revenue amount.

• FYA: $80m × 75% = $60m
• NFY: $100m × 25% = $25m

The calendarized revenue for the first adjusted year equals the sum of the two figures above, which comes out to $85 million.