Sales (1-Year Growth)
Returns the 1-year percentage change in sales/revenue.
Syntax
=SalesOneYearGrowth(Symbol)Returns
number
1-year sales/revenue growth as decimal
Examples
=SalesOneYearGrowth("AAPL")=SalesOneYearGrowth("AMZN")When to Use
- Revenue momentum analysis
- Growth stock screening
- Top-line performance tracking
When NOT to Use
| Scenario | Use Instead |
|---|---|
| EPS growth | EPSOneYearGrowth() |
| EBITDA growth | EBITDAOneYearGrowth() |
Common Issues & FAQ
Is this organic growth?
Includes all revenue changes including acquisitions.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
- Shares Outstanding (1 Year - Growth)
- Shares Outstanding (3 Year - Growth)
- Total Cash On Hand (1-Year Growth)
- Book Value Per Share (1-Year Growth)
- CAGR
- Cash Flow (1-Year Growth)
- Dividend (1-Year Growth)
- EBITDA Growth 5 Year CAGR
See SalesOneYearGrowth used in a complete workbook: stock data excel: The Complete MarketXLS Workflow Guide
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?