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.
With an automated data extraction solution, loan documents can automatically be processed end-to-end without any human errors and delays. Automation in loan document processing prevents downtimes, eliminates data redundancy, and allows companies to respond faster to client queries. By combining machine learning with deep learning and OCR, companies can eliminate huge costs, derive actionable insights, and streamline loan processing and approvals through efficient data extraction and analysis.
Mortgage lenders receive multiple identity and income verification documents along with different forms from loan applicants in a variety of formats and styles. Traditional OCR solutions fail to extract data from these semi-structured documents and that’s why more and more lenders are adopting intelligent document processing solutions. IDP solutions not only extract data correctly, they are able to validate extracted data against predefined rules in order to improve accuracy.
Intelligent Document Processing is an automation technology that captures information from a myriad of documents and data sources, extract data, and organizes it for further processing. IDP solutions enable businesses to seamlessly integrate with core processes, eliminate manual labour, address challenges faced in reading different document layouts, and meeting legal & compliance requirements. Accurate data is the foundation of every organization, and IDP assists businesses in dealing with the complexity of processing huge volumes of documents, helping them automate manual data entry processes, and move away from traditional semi-automated OCR workflows.