Comp Sales Calculator

Updated on 09-May-2025

Easily compare your current and previous sales performance with this Comp Sales Calculator. Analyze changes in revenue, units sold, pricing, and profit margins to understand business growth over time.


Current Period Data
$
$
$
Comparison Period Data
$
$
$
Comparative Results
%
%
%
$
%
%

If you're running a business, understanding how your sales are performing over time is critical. Our Comp Sales Calculator is designed to help you compare your current sales performance with a previous period, so you can track growth, identify trends, and make informed decisions.

Whether you're in retail, e-commerce, or product sales, this tool gives you a snapshot of how well you're doing compared to a past period — all in just a few clicks.

What Does the Comp Sales Calculator Do?

This tool asks for two sets of input:

Current Period Data

  1. Sales Revenue
  2. Units Sold
  3. Price per Unit
  4. Cost per Unit

Comparison Period Data

  1. Sales Revenue
  2. Units Sold
  3. Price per Unit
  4. Cost per Unit

Then, it calculates and compares:

  • 📈 Revenue Change
  • 📅 Revenue per Day (Current)
  • 🔄 Units Sold Change
  • 💰 Profit Margin (Current & Comparison)
  • 💵 Price per Unit Change

Why Is This Useful?

  • Quickly assess if your sales are up or down.
  • Understand whether the change is due to pricing, volume, or cost.
  • Optimize decisions like discounting, inventory restocking, or pricing strategies.

How Are Calculations Done?

Let’s break down the formulas used by the Comp Sales Calculator.

🔹 1. Revenue Change

Revenue Change (%)=(Revenuecurrent-RevenuecomparisonRevenuecomparison)×100\text{Revenue Change (%)} = \left( \frac{\text{Revenue}_{\text{current}} - \text{Revenue}_{\text{comparison}}}{\text{Revenue}_{\text{comparison}}} \right) \times 100

🔹 2. Revenue per Day (Current)

If the current period is assumed to be 30 days (or user-defined), revenue per day is:

Revenue per Day=RevenuecurrentNumber of Days\text{Revenue per Day} = \frac{\text{Revenue}_{\text{current}}}{\text{Number of Days}}

🔹 3. Units Sold Change

Units Sold Change (%)=(Unitscurrent-UnitscomparisonUnitscomparison)×100\text{Units Sold Change (%)} = \left( \frac{\text{Units}_{\text{current}} - \text{Units}_{\text{comparison}}}{\text{Units}_{\text{comparison}}} \right) \times 100

🔹 4. Profit Margin (Current & Comparison)

Profit Margin (%)=(Price per Unit-Cost per UnitPrice per Unit)×100\text{Profit Margin (%)} = \left( \frac{\text{Price per Unit} - \text{Cost per Unit}}{\text{Price per Unit}} \right) \times 100

Calculate this for both current and comparison periods.

🔹 5. Price per Unit Change

Price Change (%)=(Pricecurrent-PricecomparisonPricecomparison)×100\text{Price Change (%)} = \left( \frac{\text{Price}_{\text{current}} - \text{Price}_{\text{comparison}}}{\text{Price}_{\text{comparison}}} \right) \times 100

Example Calculation

Let’s take an example with the following data:

🔸 Current Period:

  • Sales Revenue = $12,000
  • Units Sold = 400
  • Price per Unit = $30
  • Cost per Unit = $18

🔸 Comparison Period:

  • Sales Revenue = $10,000
  • Units Sold = 350
  • Price per Unit = $28
  • Cost per Unit = $16

1. Revenue Change:

(12000-1000010000)×100=20%\left( \frac{12000 - 10000}{10000} \right) \times 100 = 20\%

2. Revenue per Day (Assuming 30 days):

1200030=400\frac{12000}{30} = 400

3. Units Sold Change:

(400-350350)×10014.29%\left( \frac{400 - 350}{350} \right) \times 100 \approx 14.29\%

4. Profit Margin (Current):

(30-1830)×100=40%\left( \frac{30 - 18}{30} \right) \times 100 = 40\%

5. Profit Margin (Comparison):

(28-1628)×10042.86%\left( \frac{28 - 16}{28} \right) \times 100 \approx 42.86\%

6. Price Change:

(30-2828)×1007.14%\left( \frac{30 - 28}{28} \right) \times 100 \approx 7.14\%

Conclusion

The Comp Sales Calculator simplifies performance analysis by automating these comparisons. Instead of spending hours in spreadsheets, use this tool to instantly see:

  • Are you selling more units?
  • Are you making better margins?
  • Is your revenue improving over time?

Try it now and unlock insights that drive smarter decisions for your business growth.

Comp Sales Calculator