background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Calendarization

Step-by-Step Guide to Understanding the Calendarization Concept in Finance

Last Updated February 4, 2024

Learn Online Now

Calendarization: Financial Statement Adjustments

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

Calendarization in Comps Analysis

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.

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 Template

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

dl

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Calendarization Calculation Example

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 Calculator

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

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.