How to Use the Profit Sensitivity Analyzer
The Profit Sensitivity Analyzer helps you quickly understand which business variables have the greatest impact on your profit.
- Select a Template (Optional) — Choose from E-commerce, Import/Export, SaaS, or Wholesale to auto-fill example data.
- Enter Base Data — Fill in selling price, sales volume, purchase cost, shipping cost, platform fees, ad spend, fixed costs, and other variables.
- Review Base Results — See your profit, margin, revenue, total cost, break-even volume, and break-even price.
- Read Sensitivity Analysis — The table shows how profit changes when each variable shifts by a percentage range. The most impactful variable is highlighted.
- Compare Scenarios — View Optimistic, Base, and Pessimistic scenarios side by side.
Formula & Theory — Profit Sensitivity Analyzer
The Profit Sensitivity Analyzer uses standard business profit formulas:
Revenue = Price × Volume × (1 - Refund Rate)
Total Cost = (Purchase + Shipping + Ad + Other) × Volume
+ Revenue × (Platform Fee% + Payment Fee%)
+ Fixed Costs
+ Revenue × Tax Rate%
Profit = Revenue - Total Cost
Profit Margin = Profit ÷ Revenue × 100%
Break-Even Analysis
Break-Even Volume = Fixed Costs ÷ Contribution per Unit
Where Contribution per Unit = Revenue per Unit - Variable Cost per Unit - Fee per Unit - Tax per Unit.
Break-Even Price = (Variable Cost per Unit + Fixed Cost per Unit) ÷ Effective Revenue Rate
Sensitivity Analysis
For each variable, the Profit Sensitivity Analyzer calculates profit at multiple percentage changes (e.g. -20% to +20%) while keeping all other variables constant. This reveals which variable has the steepest profit curve — the one you should monitor most closely.
Use Cases for the Profit Sensitivity Analyzer
- E-commerce pricing — Test how a price increase or decrease affects your bottom line before making changes.
- Import/export cost planning — Evaluate the impact of freight cost fluctuations or exchange rate changes on order profitability.
- SaaS revenue modeling — Understand how churn rate (refund rate) and ad spend affect subscription profit.
- Wholesale margin analysis — See how volume discounts or cost increases change your margin at scale.
- Investor presentations — Present optimistic, base, and pessimistic profit scenarios with clear numbers.
The Profit Sensitivity Analyzer is for business calculation and decision reference only. It does not provide investment, tax, or legal advice.