Back to Templates
FINANCIAL MODEL
Elasticity Calculator Model
Excel-based model to calculate PED (Price Elasticity of Demand) from historical sales data.
LIVE PREVIEW
| Period | Price ($) | Volume (Units) | Revenue | % Change Price | % Change Vol | Implied Elasticity |
|---|---|---|---|---|---|---|
| Q1 | $100 | 1000 | $100,000 | - | - | - |
| Q2 | $90 | 1200 | $108,000 | -10.0% | +20.0% | -2.0 (Elastic) |
| Q3 | $110 | 800 | $88,000 | +22.2% | -33.3% | -1.5 (Elastic) |
| -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Clean Data: Ensure periods are comparable.
- 2Outliers: Remove holiday spikes.
- 3Formula: %ΔQ / %ΔP.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Calculate your true elasticity coefficient using historical sales data.
Key Features
Automated Formulas: Just enter price/volume.
Interpretation Key: What the number means.
Common Use Cases
Quarterly Business Reviews: Strategic insight.
Pricing Reviews: Data backing.
Frequently Asked Questions
Does this work for services?
Yes, use billable hours or contracts as volume.