MarketXLS

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

Syntax

=hf_Revenue_Growth(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Revenue growth rate as decimal

Examples

=hf_Revenue_Growth("AAPL", 2023, 4)
Q4 2023 revenue growth
=hf_Revenue_Growth("NVDA", "ly")
Last year growth
=hf_Revenue_Growth("GOOGL", 2023, , "TTM")
TTM revenue growth
=hf_Revenue_Growth("MSFT", 2023)*100
Convert to percentage

When 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

Why is growth rate very high?

Small base revenue or acquisitions can cause high growth rates.

What period is being compared?

Year-over-year for annual, sequential for quarterly.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

See hf_Revenue_Growth used in a complete workbook: DCF Model Excel: Build a Discounted Cash Flow Valuation Template (2026)

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Revenue Growth (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions