Waterfall Chart for Income Statement — Revenue to Net Income P&L Bridge
An income statement waterfall chart maps top-line Revenue on the left and sequentially deducts cost of goods sold, operating expenses, and taxes ($Net\ Income = Revenue - COGS - OpEx - Tax$) to land on bottom-line profit.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Net Revenue = Gross Revenue - Discounts. Gross Profit = Net Revenue - COGS. Operating Income (EBIT) = Gross Profit - OpEx. Net Margin = (Net Income / Gross Revenue) * 100%.
Chart Design & Use-Case Tips
- 01Net Revenue = Gross Revenue - Discounts. Gross Profit = Net Revenue - COGS. Operating Income (EBIT) = Gross Profit - OpEx. Net Margin = (Net Income / Gross Revenue) * 100%.
- 02Enter Gross Revenue as a positive number in Row 1 and all expense lines (COGS, R&D, S&M, G&A, Tax) as negative numbers.
- 03The final anchored Net Total pillar displays Net Profit ($138M in the sample dataset) and lets stakeholders see expense proportions visually.
- 04Compare the Net Total against Row 1 to read net profit margin immediately.
Frequently Asked Questions
Why do investors like P&L waterfall charts in earnings decks?+
A P&L waterfall turns a dense accounting table into an intuitive visual staircase showing exactly where every revenue dollar goes before reaching net income.
Can I include non-operating income or interest credit?+
Yes, insert a row with a positive value for interest/other income and it will step upward along the P&L bridge.
What happens if expenses exceed revenue (Net Loss)?+
The waterfall bridge crosses below the zero baseline and renders a negative Net Total pillar appropriately.