Calculate Trailing 12 Month (TTM) Values in Excel

data ttm2. Benefits of Trailing Twelve Months (TTM) Data. TTM data offers a comprehensive view of a company's financial performance over the past twelve months,Calculating trailing-12 month values, also known as TTM, can be a powerful way to analyze financial or business data over the most recent year.