Growth Functions
Analyze company growth metrics and value stocks based on fundamental growth rates using these specialized functions.
Finding Growth Functions
These functions can also be found by clicking on the Search and Help panel in MarketXLS and filtering them by "New". These functions help you value stocks based on company growth metrics.
Available Growth Functions
| Function |
|---|
| =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() |