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.
Processing mortgage loans requires tons of paperwork, followed by a lengthy waiting period for document verification, resulting in a tiresome customer experience. Automation, specifically RPA (robotic process automation), helps you perform these routine tasks more efficiently so underwriters spend more time doing what’s essential. With RPA, enterprises can reduce heavy expenses, fight against fraud and improve customer experience.
Businesses have to process a plethora of digitally typed, printed, or handwritten papers. To deal with it, businesses require efficient and flexible automated document processing solutions that produce accurate results - this is where Intelligent Document Processing can help your business. An IDP solution incorporates the powerful features of Artificial Intelligence and Machine Learning technologies to automate the tasks that once required human intervention, thereby making document processing scalable, robust, and credible.
RPA (robotic process automation) is like a sword that slices through tedious and repetitive tasks in high volumes for your company. Except, it's not a sword - it's tiny robots performing repetitive and routine tasks so that you can focus on core business functionalities. So, whether you're looking to automate the financial auditing statement or you wish to speed up tasks like account receivable and payable, RPA is one of the easiest ways to go about it. You can utilize RPA for plenty of purposes.