Growth Functions
These functions can also be found by clicking on the Search and Help panel and filtering them by "New". These functions value a stock on the basis of the growth of the company.
Functions
=BookValuePerShareOneYearGrowth("MSFT")
=CashFlowOneYearGrowth("MSFT")
=CashAndEquivalentOneYearGrowth("MSFT")
=DividendOneYearGrowth("MSFT")
=DividendPerShareFiveYearCAGR("msft")
=EBITDAOneYearGrowth("MSFT")
=EBITDAGrowthFiveYearCAGR("msft")
=EBITDAMarginFiveYearAverage("msft")
=EBITDAMarginOneYearGrowth("MSFT")
=EpsFourQuarterAverageGrowth("MSFT")
=EPSOneYearGrowth("MSFT")
=EpsThreeYearCAGR("msft")
=EpsFourYearCAGR("msft")
=EpsFiveYearCAGR("msft")
=FreeCashFlowOneYearGrowth("MSFT")
=FreeCashFlowPerShare("MSFT")
=GrossMarginFiveYearAverage("msft")
=GrossProfitMarginOneYearGrowth("msft")
=NetIncomeGrowthFiveYearCAGR("msft")
=NetProfitMarginOneYearGrowth("MSFT")
=NetMarginFiveYearAverage("msft")
=PERatioFiveYearAverage("msft")
=SalesOneYearGrowth("MSFT")
=RevenueThreeYearCAGR("msft")
=RevenueGrowthFiveYearCAGR("msft")
=ReturnOnAssetsFiveYearAverage("msft")
=ReturnOnEquityFiveYearAverage("msft")
=ReturnOnCapitalFiveYearAverage("msft")
=SharesOutstandingOneYearChange("ibm")
=SharesOutstandingThreeYearChange("MSFT")
=QoQGrowth("msft","revenue")
=QoQGrowth("msft","eps")
=QoQGrowth("msft","fcf")
=YoYGrowth("msft","revenue")
=YoYGrowth("msft","eps")
=YoYGrowth("msft","fcf")
=IsOptionable("msft")
=DividendFrequency("msft")
=Exchange("msft")
=AltmanZScore("msft")
=BeneishMscore("msft")
=PitrioskiFScore("msft")
=Inflation()
Copy link