How to: Dashboard KPIs
The dashboard turns your model into decision-ready KPIs. It’s fully derived from your P&L + Balance Sheet (and their computed logic), so it updates automatically as you adjust drivers and run scenario analysis.
What the dashboard is (in the code)
The dashboard uses computed series (per year) for revenue, EBITDA, investments and cash — and it derives financing ratios from EBIT, interest, debt and equity. It’s designed for fast scanning and scenario comparison.
- • Revenue
- • EBITDA
- • Investments
- • Cash (year-end)
- • Net result
- • ICR (Interest Coverage Ratio)
- • Debt / EBITDA
- • Debt / Equity
- • Solvency ratio
- • Net debt
Step-by-step
- 1. Complete baseline inputs first
The dashboard relies on your saved P&L and Balance Sheet. Make sure the base year and forecasts are filled in and press Save.
- 2. Open the Dashboard tab
You’ll see KPI charts per year. These are computed series: no extra “dashboard inputs” are required.
- 3. Choose what you want to see (show/hide KPIs)
In the UI you can toggle KPI cards on/off and also use Show all / Hide all. This helps you focus on the metrics that matter for your decision.
Typical combinations:
- – Growth decisions: Revenue + EBITDA + Cash
- – Funding decisions: Cash + ICR + Debt/EBITDA + Solvency
- – Working capital plans: Cash + Net working capital
- 4. Use it together with Scenario analysis
After adjusting scenario sliders, come back to the dashboard to verify impact across performance and financing risk metrics.
How key ratios are calculated
Computed as EBIT / interest. This indicates how comfortably operating profit covers interest expense.
Computed as (short-term debt + long-term debt) / EBITDA. Useful for leverage and covenant-style thinking.
Computed as equity / total assets. This is a simple view of capital structure strength.
Computed as total debt / equity. Helpful to compare financing mix between baseline and scenario.
If a KPI looks “wrong”, the dashboard is usually doing its job: it ’s pointing you to an input inconsistency. Review P&L drivers, working capital ratios, fixed assets/investments, and debt/interest inputs.