Relative Periods

In many financial models, we build Excel templates leveraging relative periods with respect to the latest reported financials. This makes the templates automatically updating whenever a new report is published. Some examples of relative periods are:

  • 0Q, -1Q, -2Q, -3Q, ...
  • 0FY, -1FY, -2FY, ...
  • LTM

The period parameter should be used in the third input of standard XBRLAnalyst functions like FinValue. For example, one can get Microsoft's revenue for the Last Twelve Month period using formula: 

=FinValue("MSFT","[Revenue]","LTM")

Leave a reply