> ## Documentation Index
> Fetch the complete documentation index at: https://docs.simcel.io/llms.txt
> Use this file to discover all available pages before exploring further.

# P&L Waterfall

> Break down revenues and costs up to Constrained Net Sales In and compare variances across scenarios.

The **P\&L Waterfall** widget displays the different revenues and costs up to the **Constrained Net Sales In** in a waterfall format. It helps you with:

1. **Breakdown of components**: Shows the incremental effect of each component on the final net income.
2. **Visualizing contributions**: Distinguishes between positive contributions (revenues) and negative contributions (costs and expenses) to the overall financial outcome.
3. **Facilitating decision making**: Isolates and visualizes the impact of individual P\&L components.
4. **Performance comparison**: Compares various scenarios to identify variances.

<Frame caption="The P&L Waterfall widget in the Business Explorer">
  <img src="https://mintcdn.com/simcel-knowledge/jyNxnn8Nkzs8STrN/images/business-explorer/pl-waterfall-1.png?fit=max&auto=format&n=jyNxnn8Nkzs8STrN&q=85&s=adbbba387b70150b05415a7a3465a342" alt="P&L waterfall chart showing revenues and costs as incremental bars building up to Constrained Net Sales In" width="2543" height="1162" data-path="images/business-explorer/pl-waterfall-1.png" />
</Frame>

## P\&L structure

SIMCEL cascades financial KPIs down this waterfall:

```text theme={null}
Primary Gross Sales Value (Constrained Sales In GSV)
  - Primary Trade Expenses
= Primary Net Sales Value (Net FIE Sales)
  - COGS (Distributor COGS)
= Gross Profit
  - Transport
  - Storage & Handling
= (Supply Chain Cost)
  - Promotion
  - Medical Affairs
= D-P-M (Distribution, Promotion & Medical)
  - Administration
= D-P-M-A
= EBIT (Earnings Before Interest & Tax)
```

See [KPI Table](/business-explorer/kpi-table) for the formula behind each line.

## Scenario comparison

The Business Explorer highlights differences between scenarios using color coding:

* **Green** — favorable movement (higher revenue, lower costs)
* **Red** — unfavorable movement (lower revenue, higher costs)

```text theme={null}
% Difference = ((Scenario Value - Active Scenario Value) / |Active Scenario Value|) x 100
```

## Full screen view

To enable the full screen view for this widget, click the full screen button.

<Frame caption="The full screen button on the P&L Waterfall widget">
  <img src="https://mintcdn.com/simcel-knowledge/jyNxnn8Nkzs8STrN/images/business-explorer/pl-waterfall-2.png?fit=max&auto=format&n=jyNxnn8Nkzs8STrN&q=85&s=6112c55bd0a0ab3c6e3d02e43ad0375c" alt="The full screen button in the corner of the P&L Waterfall widget, which expands the chart to fill the screen" width="1192" height="627" data-path="images/business-explorer/pl-waterfall-2.png" />
</Frame>
