A QuickSheet extension that calculates break-even point and contribution margin — essential metrics for pricing decisions and business planning.
Enter your selling price, variable cost per unit, and total fixed costs. The extension instantly shows:
- Contribution margin per unit and as a percentage
- Break-even point in units and revenue
- Health indicator (🟢 strong → 🔴 razor-thin margin)
In any QuickSheet cell, type:
margin: 50, 20, 9000
Parameters: sellingPrice, variableCostPerUnit, totalFixedCosts
🟢 Strong margin CM: $30.00/unit (60.0%)
Break-even: 300 units BE revenue: $15,000.00
Fixed: $9,000.00 Price $50.00 − Var $20.00
Plan,Price,Infra Cost,Fixed,Analysis
Starter,29,8,50000,"margin: 29, 8, 50000"
Pro,79,15,50000,"margin: 79, 15, 50000"
Enterprise,199,25,50000,"margin: 199, 25, 50000"| Ratio | Status | Meaning |
|---|---|---|
| ≥ 60% | 🟢 Strong | Healthy pricing power |
| ≥ 40% | 🟡 Moderate | Typical for competitive markets |
| ≥ 20% | 🟠 Thin | Watch costs carefully |
| < 20% | 🔴 Razor-thin | Consider repricing |
Clone into your QuickSheet extensions directory:
cd ~/.quicksheet/extensions
git clone https://github.com/Deskworks/quicksheet-margin-ext.gitRequires .NET 9 SDK. Zero NuGet dependencies.
Works alongside other financial extensions:
- quicksheet-budget — budget envelope visualizer
- quicksheet-qtr — quarterly tax deadline countdown
- quicksheet-fx — live currency conversion
- quicksheet-1099-ext — freelancer tax estimator
- quicksheet-mileage-ext — IRS standard mileage
MIT