Back to Templates
FINANCIAL MODEL
Channel Margin Waterfall
Analyze profitability across different sales channels (Amazon vs Shopify vs Wholesale) accounting for all fees.
LIVE PREVIEW
| Line Item | DTC (Shopify) | Marketplace (Amazon) | Wholesale (Retailer) |
|---|---|---|---|
| List Price | $100.00 | $100.00 | $100.00 |
| Discount | $0.00 | $0.00 | -$50.00 (50%) |
| Platform Fee | -$3.00 (3%) | -$15.00 (15%) | $0.00 |
| Shipping/FBA | -$8.00 | -$12.00 | $0.00 (Bulk) |
| Net Revenue | $89.00 | $73.00 | $50.00 |
| -- | -- | -- | -- |
| -- | -- | -- | -- |
Instructions
- 1List All Fees: Don't forget ad spend attribution per channel.
- 2Compare Net: Look at the bottom line, not the top line.
- 3Parity Check: Ensure your pricing strategy minimizes channel conflict.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Stop treating all revenue as equal. $1 on Amazon is worth less than $1 on your own site.
Key Features
Fee Breakdown: Granular cost analysis.
Net Margin Comparison: True profit.
Common Use Cases
Channel Strategy: Where to push volume.
Amazon FBA: Fee auditing.
Frequently Asked Questions
What is 'Channel Conflict'?
When one channel undercuts another.