background
Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for May 1-June 25 →
Wall Street Prep

Trailing Twelve Months (TTM)

Guide to Understanding Trailing Twelve Months (TTM)

Learn Online Now

Trailing Twelve Months (TTM)

How to Calculate TTM Revenue (Step-by-Step)

The trailing twelve months (TTM) refers to a company’s financial performance in the most recent 12-month period.

TTM stands for “trailing twelve months” and is a backward-looking metric that captures the financial performance of a company in its latest four reporting quarters.

In effect, a metric on a trailing twelve months basis, such as TTM revenue, is meant to show the current state of a company’s growth trajectory.

The process of adjusting a financial metric like revenue by adding the most recent period past the latest reported fiscal year and subsequently deducting the matching period is referred to as the “stub period”.

The required financial filings to perform such a calculation are the company’s latest 10-K, most recent quarterly filing(s), and the corresponding filings from the year prior.

To calculate a company’s revenue on a TTM basis, the following three steps can be followed.

  • Step 1 → Compile Annual Report (10-K) and Latest Quarterly Reports (10-Q)
  • Step 2 → Add the Year-to-Date (YTD) Data to the Fiscal Year Data
  • Step 3 → Subtract the YTD Data from the Prior Year

Trailing Twelve Months Formula (TTM)

The formula for calculating a financial metric on a trailing twelve-month basis is as follows.

Trailing Twelve Months (TTM) = Latest Fiscal Year Data + YTD Data Prior YTD Data

For example, if two quarters have passed since the latest fiscal year, the quarterly data that we would deduct is the first two quarters from the prior year.

The Wharton Online
and Wall Street Prep Private Equity Certificate Program

Level up your career with the world's most recognized private equity investing program. Enrollment is open for the May 1 - Jun 25 cohort.

Enroll Today

Trailing Twelve Months Calculator (TTM) — Excel Template

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

Submitting ...

TTM Revenue Calculation Example

Suppose you’re tasked with calculating the revenue of a company on a trailing twelve-month basis.

In the recent quarters leading up to the end of fiscal year 2022, the company’s revenue has grown significantly.

Historical Revenue:

  • Q1, 2022 = $20 million
  • Q2, 2022 = $25 million
  • Q3, 2022 = $40 million
  • Q4, 2022 = $60 million

The company brought in $145 million in revenue to wrap up the fiscal year.

  • FY, 2022 = $145 million

In the most recent quarter, Q-1 of 2023, the company reported $75 million in quarterly revenue.

  • Q1, 2023 = $75 million

In order to calculate the TTM revenue of our company, we’ll start with our fiscal year 2022 revenue, add the Q1 2023 revenue, and subtract the Q4 2022 revenue.

  • TTM Revenue = FY-22 Revenue + Q1-23 Revenue – Q1-22 Revenue
  • TTM Revenue = $145 million + $75 million – $20 million = $200 million

Our company’s trailing twelve months (TTM) revenue amounts to $200 million, which reflects its financial performance and growth profile far more accurately than its fiscal year 2022 revenue of $145 million.

TTM Revenue 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
guest
0 Comments
Inline Feedbacks
View all comments
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.