Last Twelve Months (LTM) Period

Last Twelve Months (LTM) is a built-in XBRLAnalyst period code which calculates a value of financial concept (Original or Normalized) for last twelve months starting from your specified date. For example, if you are looking for LTM value of some "Duration" concept such as Revenue as of 2018-Q3, you can get it with XBRLAnalyst using the following syntax in Excel:
              FinValue("MSFT","[Revenue]","2018-Q3LTM")

As one can see in the example above, it is enough to just add "LTM" code to any valid fiscal period code, except FY that is already returning 12 month trailing value. Other examples of valid LTM syntax are as follows:

       FinValue("IBM","[Net Income]","2018","Q1LTM")

       FinValue("XRX","Revenues","2017","Q1LTM")

In the last example, we used XBRL Concept "Revenues" instead of normalized FinDynamics concept [Revenue]. In such case, XBRLAnalyst computes the value for the corresponding concept and returns the answer in Excel.

If we omit the year parameter and simply set "LTM" for the year/period, it will make XBRLAnalyst return 12-month trailing value as of most recent report filed with SEC, e.g.

       FinValue("TSL","[Gross Profit]","LTM")

Note that for concepts with "instant" period type such as "Assets", this parameter doesn't trigger any special computation, because the concept reflects a point-in-time view and hence no adjustment is required. For instance, the function below will return the same result with or without "LTM":

       FinValue("MSFT","[Assets]","2018-Q2LTM")

This feature is very useful if you are doing a mid-year comparison of multiple companies or comparing companies having different fiscal years. LTM will logically identify the most fitting or relative period on your defined date and will set it as basis for a standard "calendar year".

Follow the link below for more information on varios Period prefix codes for pulling data.

Leave a reply