Gross Profit Margin (1-Year Growth)
Returns the 1-year change in gross profit margin (margin expansion/contraction).
Syntax
=GrossProfitMarginOneYearGrowth(Symbol)Returns
number
1-year gross margin growth as decimal
Examples
=GrossProfitMarginOneYearGrowth("AAPL")When to Use
- Pricing power analysis
- Cost management assessment
- Competitive position tracking
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Net margin growth | NetProfitMarginOneYearGrowth() |
| EBITDA margin growth | EBITDAMarginOneYearGrowth() |
Common Issues & FAQ
What affects gross margin?
Input costs, pricing power, and product mix changes.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
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?