Signal Lab

P&L Margin Stack

A P&L margin waterfall from revenue through gross, EBITDA, EBIT, EBT, and NPAT.

It measures each level in dollars and as a percent of revenue — so you see where margin is earned and lost.

Use it to pick the largest step leak before you cut price, add opex, or brief the year-end pack.

Profitability

Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.

Signal Lab · Model

P&L Margin Stack

A P&L margin waterfall from revenue through gross, EBITDA, EBIT, EBT, and NPAT.

Illustrative SMB sample (Rev 8.4m · NPAT 560k). Currency-agnostic. Not financial advice.

P&L inputs

Enter cost lines as positive reductions. Optional advanced opex split · Jump to results

Top-line for the period

Cost of goods / services sold

Primary opex input (excludes D&A)

Depreciation & amortisation

Net interest expense

Income tax expense

Advanced: split opex (Selling / Admin / Other)

Optional. Split sums into Opex excl D&A above. Edit either the total or the split.

Selling / sales expense

G&A

Other opex excl D&A

Margin stack

Waterfall $ and % of revenue — where margin is earned and lost.

Equations

  • Gross = Rev − COGS · EBITDA = Gross − OpexExclDA
  • EBIT = EBITDA − DA · EBT = EBIT − Interest · NPAT = EBT − Tax
  • Margin % = Level $ ÷ Revenue
Level$% of RevStep deductionStep % Rev

How this is calculated
  • Stack identity Revenue → Gross → EBITDA → EBIT → EBT → NPAT (top-down; EBITDA = Gross − opex excl D&A)
  • Cost lines entered as positive reductions (Pocket Margin convention)
  • Identity check Rev − COGS − Opex − DA − Interest − Tax − NPAT ≈ 0

Illustrative — not financial advice.

Take it with you

Download a prompt or export the Excel workbook from your current inputs.

Takes your current inputs — stays on your device.