Comparable Sales Growth Calculator
A retailer reports that sales grew 8% last quarter. Did the business actually improve, or did two new store openings do all the work? Comparable sales growth answers that by measuring only the locations, channels, or products that existed in both periods: same stores, same basis, no expansion noise.
The Comparable Sales Growth Calculator below computes the standard single-period figure, plus two things competing tools leave out: a multi-period series mode that turns up to six periods of sales into per-period growth and a CAGR, and a target-growth planner that tells you the exact sales number a growth target requires.
Same-store growth for one period, a multi-period series with CAGR, or a target-growth plan.
How to use the Comparable Sales Growth Calculator
Single period: enter current period sales and prior period sales for the same set of stores or channels, then calculate. You get the growth percentage, the dollar change, and a growth, decline, or flat label.
Multi-period series: enter up to six consecutive periods, oldest first. The calculator shows the growth for every step and the CAGR across the whole run.
Target planner: enter current sales and the growth rate you want. The calculator returns the exact sales figure that target requires.
Formula
Comparable Sales Growth = (Current Period Sales – Prior Period Sales) ÷ Prior Period Sales × 100
The "comparable" part is a data discipline, not math: both figures must cover the same stores, channels, or product lines. New openings, closures, and acquisitions are excluded, otherwise you are measuring expansion, not performance.
For a series, the CAGR = (Latest Sales ÷ First Sales)1 ÷ number of steps – 1, expressed as a percentage. It is the single smoothed rate that would take you from the first period to the latest.
Worked example
Single period. A retail chain reports $120,000 in comparable sales this quarter against $100,000 in the same quarter last year: ($120,000 – $100,000) ÷ $100,000 × 100 = 20.00% growth, a $20,000 increase.
Series. Four quarters at $100,000, $110,000, $121,000, and $133,100 grow 10.00% each step. The CAGR is (133,100 ÷ 100,000)1÷3 – 1 = 10.00%, and total growth from first to latest is 33.10%.
Target. To grow 12% from $120,000 of comparable sales, the business needs $120,000 × 1.12 = $134,400, an additional $14,400. All three examples were verified against the calculator above.
What competitors miss
Every other comparable-sales tool in this space stops at one number for one pair of periods. That matches the textbook formula, but it is not how the metric is actually used: analysts track it as a time series across quarters, and they plan against targets. The multi-period series mode with CAGR and the target planner were built for that real workflow, and no competing calculator offers either. Most also skip the dollar change entirely, reporting only the percentage.
Frequently asked questions
What is comparable sales growth?
The percentage change in sales measured on a like-for-like basis: only stores, channels, or products that existed in both periods are counted, so new openings and closures do not distort the figure.
How is it different from ordinary sales growth?
Ordinary sales growth includes everything, including revenue from newly opened stores. Comparable (same-store) growth isolates how existing operations are performing, which is the number retail analysts and investors watch.
What does a negative result mean?
Comparable sales shrank by that percentage on a like-for-like basis. A negative figure with rising total sales usually means growth came entirely from new locations while existing ones weakened.
What is CAGR and why does the series mode show it?
The compound annual growth rate smooths uneven per-period growth into one steady rate. It is the standard way to summarize a multi-period run without letting one strong quarter dominate the story.
Which periods should I compare?
Match the calendar: Q1 against Q1, not Q1 against Q4, because seasonality would swamp the signal. Year-over-year is the standard for retail; quarter-over-quarter works for stable, non-seasonal businesses.
Do I include online sales?
Include them only if the same channel existed in both periods and you are measuring total comparable revenue. Many retailers report store-only and total comparable figures separately; keep the two series consistent.