Revenue Breakdown: 40% Online, 35% Retail, 25% B2B = Wildly Different Margins
Company total revenue SGD 250K. Breakdown: Online SGD 100K (40% of revenue, 40% margin = SGD 40K profit). Retail SGD 87.5K (35% revenue, 20% margin = SGD 17.5K profit). B2B SGD 62.5K (25% revenue, 5% margin = SGD 3.1K profit). Blended margin: (SGD 40K + SGD 17.5K + SGD 3.1K) / SGD 250K = 24% blended. But if you shift 10% revenue from B2B to Online: new blended margin 25.5% = +SGD 3.75K annual profit. Waterfall shows hidden channel economics.
- What Is Revenue Waterfall?
- Hidden Channel Economics
- Margin Drivers by Channel
- AskBiz Revenue Waterfall
- Building the Waterfall Step by Step
What Is Revenue Waterfall?#
Visualize revenue from gross → net profit, breaking down costs by channel. Online: gross SGD 100K, minus payment fees (2.8%) = net SGD 97.2K, minus COGS (60%) = SGD 38.88K profit. Retail: gross SGD 87.5K, minus distributor commission (10%) = SGD 78.75K, minus COGS (60%) = SGD 31.5K profit. Shows true channel profitability.
Hidden Channel Economics#
Many businesses think all revenue equally valuable. Wrong. B2B channel may be SGD 100K (looks good) but after 15% discount + 10% distributor fee + 60% COGS = only 15% margin (SGD 15K profit). Online SGD 50K with 40% margin = SGD 20K profit. Online generates 4/3 = 1.33x more profit per revenue dollar.
Margin Drivers by Channel#
Online: payment processing (1-3%), shipping (varies), returns (1-5%), ads (varies). Retail: distributor discount (5-15%), returns (2-5%), shelf-space fees (1-3%). B2B: volume discount (10-20%), payment terms (3-6% cost of capital), support costs (5-10%). Each channel has different profit profile.
AskBiz Revenue Waterfall#
Shows gross → net by channel. "Online SGD 100K gross, SGD 38K profit (38% margin). Retail SGD 87.5K gross, SGD 26K profit (30% margin). B2B SGD 62.5K gross, SGD 5K profit (8% margin). Most profitable channel: Online (1 dollar = 0.38 profit). Least profitable: B2B (1 dollar = 0.08 profit). Recommendation: focus growth on Online, optimize B2B or deprioritize."
Building the Waterfall Step by Step#
Start with gross revenue per channel (from your POS/sales system, already segmented). Subtract channel-specific variable costs in order: payment processing or distributor commission first, then COGS, then channel-specific overhead (ad spend for online, shelf fees for retail, support cost-to-serve for B2B). Each subtraction is a "step" in the waterfall, and the running total after each step is what you chart. The formula for channel net margin is: (gross revenue − all channel-specific costs) ÷ gross revenue. The critical discipline is not letting shared costs (rent, general admin) contaminate the channel-level view — those get allocated separately in a blended P&L, not in the waterfall, because they don't change your channel-mix decision. The waterfall should only include costs that vary by channel.
Worked Example: Should You Chase the B2B Deal?#
A Singapore FMCG distributor was offered a new B2B contract worth SGD 40K/year gross. Running it through the waterfall: 15% volume discount (-SGD 6K), 8% distributor commission (-SGD 3.2K), 60% COGS (-SGD 24K), 6% cost-of-capital on 60-day payment terms (-SGD 2.4K). Net profit: SGD 40K − 6K − 3.2K − 24K − 2.4K = SGD 4.4K, an 11% margin. Compare to redirecting the same sales effort toward online growth, where historical data showed 38% margin. SGD 40K of online revenue would net roughly SGD 15.2K — more than 3x the B2B profit for the same top-line number. The waterfall turned a seemingly attractive SGD 40K deal into a clear "decline or renegotiate terms" decision, because gross revenue alone was hiding the true cost structure.
Common Mistakes in Channel Profitability Analysis#
The most frequent error is ranking channels by gross revenue instead of net profit — a channel that's 40% of revenue but only 8% margin is not your best channel, even though it looks biggest on a pie chart. The second is failing to update the waterfall when cost structures shift — a distributor commission renegotiated upward, or payment terms extended, changes channel economics materially and should trigger a re-run of the analysis, not be discovered a year later in the annual accounts. The third is ignoring the growth cost of scaling a channel — online's 38% margin may compress as you spend more on ads to acquire the next customer, so waterfall figures should be treated as current-state, not fixed forever. AskBiz recalculates the waterfall automatically as transactions post, so the channel mix decision is always based on current cost structures, not last year's numbers.
People also ask
Should I stop B2B if margin is low?
Not necessarily. B2B often strategic (brand building, volume predictability, reduces customer acquisition cost if bundled with retail). But: price appropriately (ensure minimum 20% margin) or consider exit.
How do I improve low-margin channels?
Reduce costs (renegotiate distributor fees), reduce discounts (better positioning), or exit (reallocate effort to high-margin channel).
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Analyze Revenue Waterfall (Find Most Profitable Channel)
AskBiz breaks down revenue by channel, subtracts all costs, shows net margin per channel. Recommends channel optimization. Try free.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes