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() |