Trailing twelve months (TTM) or Last Twelve Months (LTM) is a corporate finance and accounting term. It contains the company’s financial performance data for the past 12 consecutive months. It does not necessarily coincide with the fiscal or calendar year and starts from any point in time to go back to the 12 months preceding it.
In this post, we will further explore what does trailing 12 months mean, its associated benefits, and how to calculate trailing 12 months. So let’s get started!
Typically, financial analysts refer to the trailing 12 months data in cases where the data corresponding to the previous fiscal period (annual or quarterly) is either inaccurate or outdated to reflect the business’ present standing. As such, it is particularly essential during high-growth or dull periods where the figures have significantly deviated from the average.
Apart from the usage and advantage cited in the above trailing 12-month example, here are a few other aspects that highlight its importance:
Now that you know what does trailing 12-months mean, let’s move on to the next part - how to calculate trailing 12 months!
Fortunately, you can achieve your goals in three easy steps, detailed as under:
You can use the TTM to calculate a range of variable factors and situations to find their corresponding results. You could use it to calculate revenue or sales figures. Hence, before you break open the trailing 12 months calculation excel sheet, you need to clearly define your goals and map the related key performance indicators (KPIs) that will quantify and measure the variations.
Generally, the TTM report contains an analysis of any of the following documents:
The standard TTM formula for a period, say ‘t’, where ‘t’ indicates a quarter (or four months), is as follows:
T12(t) = Q(t) + Q(t-4) + Q(t-8) + Q(t-12)
Suppose you are required to calculate the TTM for the month of May 2020. In this case, consider that the following details are available about Company A:
Accordingly, the TTM for May 2020 works out to be:
TTM(May 2020) = Q1(2020) + Q4(2019) + Q3(2019) + Q2(2019)
TTM(May 2020) = $58.0 + $63.3 + $55.8 + $74.9
TTM(May 2020) = $252.0 million
Similarly, if you were to calculate the TTM revenue in November of 2020, you would have to add the quarterly revenue of Q3, Q2, Q1 of 2020, and Q4 of 2019.
While the above trailing 12 months example is a quarterly computation, some analysts may report on the annual figures. In that case, the formula gets adjusted accordingly.
Furthermore, you can follow the above formula for the TTM calculation from Income Statements and Cash Flow Statements. However, in the case of Balance Sheets, for TTM calculation, you can simply directly refer to the balance sheet as it will offer a snapshot of the total assets, equities, and liabilities for the past 12 months.
Now that all the T12 details are readily available, it is all about analyzing the same and reporting on what you observe!
You can use the TTM methodology to analyze the performance of any property for the 12 months of its operation. Typically, it is used to monitor multifamily properties as these are short-term leases. However, you can also use it to analyze the monthly/quarterly/annual performance of office properties and retail properties for shorter durations.
Through the T12 data reports, lenders and investors can get an overview of the property’s performance and how they can enhance its value.
While the T12 technique comes with its fair share of advantages, the practice can be rather cumbersome given that the calculation utilizes inputs collected from monthly, quarterly, semi-annual or annual reports. As such, it involves a large amount of data compilation and computation, which can be prone to errors.
Hence, the best way to extract useful insights with no room for errors would be through the automation of the process. If you are looking for a TTM automation software solution, Docsumo has you covered. From real-time data calculation to detailed report generation, we can make it all happen automatically.
Give your admin a break and get in touch with us now!
In today’s dynamic business world, filing and archiving official documents in the digital form makes it handy, and works wonders in the future or in unforeseen circumstances.
Optical Character Recognition (OCR) is the technology to convert an image of text into machine-readable text. It is the underlying technology for various data extraction solutions including Intelligent Document Processing. However, OCR is not smart enough to figure out the context in a document - it works simply by distinguishing text pixels from the background and finding a pattern. This limitation could cause inaccuracy in captured data that could directly impact the output of your data extraction model.
Accounts payable is a key financial function for any business. Corporations can have thousands of suppliers; even for relatively smaller businesses, the number of suppliers could be in hundreds. All the invoices they receive from these suppliers come in multiple formats, layouts, and templates - some semi-structured, some unstructured. Therefore, firms expend time and resources to capture invoice information through manual data entry and verification of accounts payable. Manual data entry is not feasible in the long run, definitely not on a large scale. Before we talk about how intelligent invoicing solves the problems associated with manual invoicing, let’s discuss the challenges in much detail.
As most of an organization's information is available in an unstructured format, processing it requires an automated system that can handle documents with minimum human interaction. OCR is one such technology, but its scope is limited as it requires human interaction and is highly dependent on the layout and structure of the document to be processed.These limitations are overcome by Intelligent Data Extraction.Using artificial intelligence, the Intelligent Data Extraction technology extracts data from documents and transforms it into useful information through the extraction process. It functions as a singular tool for extracting information from any type of document and aids in optimizing company operations.