{"id":265550,"date":"2024-03-13T20:08:01","date_gmt":"2024-03-13T19:08:01","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265550"},"modified":"2026-10-26T14:30:03","modified_gmt":"2026-10-26T13:30:03","slug":"receita-ttm","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-processes\/ttm-revenue\/","title":{"rendered":"O que \u00e9 receita TTM (receita LTM)?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

A company\u2019s 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 (MRR), 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.<\/p>\n

In this article, you will learn about TTM or LTM revenue, as well as why it\u2019s 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.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”what-is-ttm-revenue” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What is TTM revenue?<\/h2>\n

TTM or LTM revenue refers to the revenue earned by the company in the trailing twelve months (TTM), also known as the last twelve months (LTM). TTM and LTM mean the same thing, so TTM revenue and LTM revenue are the same figure. This provides more context for assessing the company\u2019s growth and allows you to identify specific sources of growth.<\/p>\n

The TTM or LTM 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.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”why-is-ttm-revenue-important” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Why is TTM revenue important?<\/h2>\n

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

However, looking at revenue in the longer term is also a good idea to get a more accurate picture of progress. For instance, it\u2019s much harder to distinguish actual revenue growth from seasonal growth if you\u2019re 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.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-calculate-ttm-revenue” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to calculate TTM revenue?<\/h2>\n

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 2, 2026, you would include all revenue generated since December 2, 2025.<\/p>\n

\n

TTM or LTM revenue = sum of all revenue in the last 12 months<\/p>\n<\/blockquote>\n

This means the specific formula will vary depending on how frequent your revenue figures are. If you\u2019re 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\u2019re 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.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”ttm-revenue-examples” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

TTM revenue examples<\/h2>\n

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.<\/p>\n

Gather data<\/h3>\n

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.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/ttm-revenue-monthly-revenue-data.webp” alt=”TTM revenue \u2014 monthly revenue by year and month for 2022 and 2021 in Google Sheets” title_text=”Monthly revenue by year and month for 2022 and 2021 in Google Sheets” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

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.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/ttm-revenue-add-ttm-column.webp” alt=”TTM revenue \u2014 empty TTM column added next to the monthly revenue in column D” title_text=”Empty TTM column added next to the monthly revenue in column D” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

First, I\u2019ll 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.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/ttm-revenue-sum-formula.webp” alt=”TTM revenue formula \u2014 =SUM(C2:C13) in cell D2 with the last 12 months of revenue selected” title_text=”=SUM(C2:C13) in cell D2 with the last 12 months of revenue selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Press \u2018Enter\u2019 to see the result.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/ttm-revenue-result.webp” alt=”TTM revenue \u2014 $38,642.00 returned in cell D2″ title_text=”$38,642.00 returned in cell D2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Given the way the data is structured in the spreadsheet, I can grab the fill handle<\/a> 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\u2019t make sense to calculate it further than December 2021 since I won\u2019t have twelve months for the calculation.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/ttm-revenue-formula-filled-down.webp” alt=”TTM revenue \u2014 SUM formula filled down column D, from $38,642.00 to $33,670.00 for December 2021″ title_text=”SUM formula filled down column D, from $38,642.00 to $33,670.00 for December 2021″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

As you can see in the screenshot above, Company Y’s revenue has been growing steadily over the last twelve months.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Conclusion<\/h2>\n

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.<\/p>\n

You now know what Trailing Twelve Months (TTM) or Last Twelve Months (LTM) revenue means and why it\u2019s 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.<\/p>\n

To learn more about other revenue-related metrics, check out the articles below.<\/p>\n