Don’t forget to share this post

A company’s ability to generate revenue is essential to its success, and monitoring this metric can help to assess its current and future value. This is why there are so many financial metrics related to revenue, like total revenue, Monthly Recurring Revenue (MMR), or Annual Recurring Revenue (ARR). Each metric focuses on a different aspect or a different type of revenue. Another of these metrics is Trailing Twelve Months (TTM) or Last Twelve Months (LTM) revenue.

In this article, you will learn about TTM or LTM revenue, as well as why it’s important. You will also learn how to calculate TTM and have step-by-step examples of how to calculate TTM using Microsoft Excel or Google Sheets.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE

What is TTM Revenue?

TTM or LTM revenue refers to the revenue earned by the company in the trailing twelve months (TTL), also known as the last twelve months (LTM). This provides more context for assessing the company’s growth and allows you to identify specific sources of growth.

The TTM or TTL technique applies to more than just revenue and is frequently calculated for other financial metrics, like yield or the Price/Earnings ratio. These would also be calculated based on the last or trailing twelve months of data.

Why is TTM Revenue Important?

Revenue can be calculated for any time period you wish to analyze or represent. For instance, financial statements are commonly prepared quarterly or annually, including the total revenue for the period. However, it’s common for companies to look at revenue much more frequently, sometimes weekly. During the initial stages, it’s normal to want to keep a very close eye on revenue.

However, looking at revenue in the longer term is also a good idea to get a more accurate picture of progress. For instance, it’s much harder to distinguish actual revenue growth from seasonal growth if you're looking at it weekly, monthly, or quarterly. TTM revenue provides a summary of the previous twelve months and can be compared to that of similar companies. It also allows you to monitor real revenue growth unaffected by seasonality.

How to Calculate TTM Revenue?

As mentioned, TTM is simply the sum of all revenue generated during the last twelve months. The formula is simple, and you can calculate the value at any time. For example, if you’re calculating it on December 2nd, 2022, you would include all revenue generated since December 2nd, 2021.

TTM or LTM revenue = sum of all revenue in the last 12 months

This means the specific formula will vary depending on how frequent your revenue figures are. If you’re calculating it for your own company, you have access to detailed revenue data and can calculate TTM revenue from any date, as in the example above. However, if you’re calculating it for other companies, you may only have access to quarterly figures. In that case, you can take the value for the current quarter and the three previous quarters.

Annual Recurring Revenue ARR And How to Calculate It
Annual Recurring Revenue (ARR) And How to Calculate It

The Annual Recurring Revenue (ARR) is a key metric for any subscription business. Here’s what it is, why it’s important and how to calculate it.

READ MORE

TTM Revenue Examples

Now that you know how TTM revenue is calculated let’s see some examples of how to do it using Microsoft Excel or Google Sheets.

Gather Data

The first step is to gather the relevant revenue data in your spreadsheet. For this example, I will use the data for Company Y. I have two years of monthly revenue figures to work with, so I can calculate TTM revenue at different points.

What is TTM Revenue LTM Revenue Gather Revenue Data
What is TTM Revenue (LTM Revenue)? - Gather Revenue Data

As you can see in the screenshot above, the data is listed in reverse chronological order, with the most recent figure in the top row. I will add a column for TTM Revenue calculations.

What is TTM Revenue LTM Revenue Add TTM or LTM Column
What is TTM Revenue (LTM Revenue)? - Add TTM or LTM Column

First, I’ll calculate the current value. Type the SUM formula in the row with the current monthly revenue and select the revenue figure for that month, as well as the previous 11 months.

What is TTM Revenue LTM Revenue Add TTM or LTM Formula
What is TTM Revenue (LTM Revenue)? - Add TTM or LTM Formula

The Revenue Forecasting Guide and Best Forecasting Models

Discover what Revenue Forecasting is, why it is crucial for every business, as well as the top forecasting methods to use and examples of each one.

READ MORE
The Revenue Forecasting Guide and Best Forecasting Models

Press ‘Enter’ to see the result.

What is TTM Revenue LTM Revenue TTM Revenue Result
What is TTM Revenue (LTM Revenue)? - TTM Revenue Result

Given the way the data is structured in the spreadsheet, I can grab the fill handle and drag the formula down to get TTM revenue for previous months. However, as I only have data going back to January 2021, it doesn’t make sense to calculate it further than December 2021 since I won’t have twelve months for the calculation.

What is TTM Revenue LTM Revenue Drag Formula Down
What is TTM Revenue (LTM Revenue)? - Drag Formula Down

As you can see in the screenshot above, Company Y’s Revenue has been growing steadily over the last twelve months.

How to Automate Your FP&A on Top of Google Sheets?

Layer is an add-on that equips finance teams with the tools to increase efficiency and data quality in their FP&A processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

  • Share & Collaborate: Automate your data collection and validation through user controls.
  • Automate & Schedule: Schedule recurring data collection and distribution tasks.
  • Integrate & Sync: Connect to your tech stack and sync all your data in one place.
  • Visualize & Report: Generate and share reports with real-time data and actionable decisions.

Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your FP&A processes on top of Google Sheets!

Conclusion

As you have seen, TTM or LTM revenue are useful metrics. They can be calculated at any point in time by adding all the revenue generated in the previous twelve months. This provides a clearer picture of revenue growth, as it removes fluctuations due to seasonality or other temporary factors. The trailing twelve months technique can also be used to calculate other financial metrics and ratios.

You now know what Trailing Twelve Months (TTM) or Last Twelve Months (LTM) revenue means and why it’s an important metric to consider. You know how to calculate TTM revenue, and you have seen examples of how to calculate it using Microsoft Excel or Google Sheets.

To learn more about other revenue-related metrics, check out the articles below.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE
Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Dec 23 2022, Updated Jan 12 2023