You can set this up in Excel to have all the data in one table, then break out the calculations line by line. 1 Let’s derive the compound annual growth rate of a company’s sales over 10 years: ...

A time series is a sequence of numerical data points in successive order. In investing, it tracks the movement of the chosen data points at regular intervals and over a specified period of time.