Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

EPS (5-Year Growth, Annualized)

To be added
Returns the annualized percent change in EPS over the past 5 years.

How calculated

(sum of EPS from past 1 year minus sum of EPS for year ended 5 years ago) divided by sum of EPS for year ended 5 years ago, and divide this by 5.

Example usage

=EPSFiveYearAnnualizedGrowth("MSFT")