Wall Street Prep

Calendarization

Understand the Calendarization Concept

Learn Online Now

Calendarization

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 Filing Date

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.

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.

Calendarization Revenue Excel Example

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
guest
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.