Revenue Growth (Historical)
Returns the historical revenue (sales) growth rate compared to the prior period.
Formula
Revenue Growth = (Current Revenue - Prior Revenue) / Prior Revenue
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Quarter 1-4 |
| TTM | No | "TTM" for trailing twelve months |
Return Value
- Returns as decimal (0.15 = 15% growth)
- Negative values indicate revenue decline
Examples
=hf_Revenue_Growth("AAPL", 2023, 4)=hf_Revenue_Growth("NVDA", "ly")=hf_Revenue_Growth("GOOGL", 2023, , "TTM")=hf_Revenue_Growth("MSFT", 2023)*100When to Use
- Growth stock analysis
- Revenue trend tracking
- Industry growth comparisons
- Sales momentum analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Absolute revenue | hf_Revenue() |
| Earnings growth | Earnings growth functions |
| Cash flow growth | hf_NCFO_Growth() |
Common Issues & FAQ
Q: Why is growth rate very high? A: Small base revenue or acquisitions can cause high growth rates.
Q: What period is being compared? A: Year-over-year for annual, sequential for quarterly.
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?