Skip to content
Back to Fiplan

KPIs, distribution capacity and sensitivity

⏱ 6 min readUpdated on

What if sales fell by 10%? How much can the company distribute? Can it repay its debts? Analysis answers these questions on the plan as it is entered, without changing it.

What it is for

In Analysis, the KPI & Insights tab gives each financial year a badge — OK, WATCH or RISK — based on the EBITDA margin, cash, the DSCR and the distribution capacity. Three blocks follow: Distribution Capacity, Performance Drivers and Sensitivity Analysis. The Thresholds button sets the file's alert thresholds.

Steps

  1. Open Analysis, KPI & Insights tab, and choose the financial year.
  2. Read the Distribution Capacity: the tests of Belgian law, the legal maximum and the prudent recommendation.
  3. Read the Performance Drivers: the five lines that weigh most on EBITDA and on cash.
  4. In the Sensitivity Analysis, move the sliders: revenue (−10% to +10%), gross margin (−2 to +2 points), payroll (−5% to +5%).
The KPI & Insights tab for 2027: the distribution capacity and the sensitivity simulator, revenue +10%.
The KPI & Insights tab for 2027: the distribution capacity and the sensitivity simulator, revenue +10%.

Worked example · Boulangerie Dupont SRL

The DSCR (debt service coverage ratio) for 2027: EBITDA , minus taxes paid , divided by debt service — the capital repaid and the interest paid , read in cash.

DSCR(1)

The screen shows 13.53×. In 2028, the 2027 tax is paid (€21,025.38): the DSCR falls to 9.73×.

Sensitivity: revenue at +10% in 2027 brings EBITDA to €125,932.60 (+€14,972.05) — supplies follow sales, so the margin as a percentage stays the same.

Distribution: for 2027, the prudent recommendation is €62,345.17, capped by the solvency test (equity minus 25% of the balance sheet total); the legal maximum, under the net asset and liquidity tests (test d'actif net, test de liquidité / netto-actieftest, liquiditeitstest), is €103,076.13.

Pitfalls

Sensitivity does not change the plan. The sliders simulate; they write nothing. To keep a scenario, enter it in a version of the file.
The recommendation is not a legal limit. It is capped out of prudence (solvency, a liquidity floor of €5,000.00, the result for the year). The legal limit is set by the net asset and liquidity tests.
Thresholds are specific to your browser. Custom Thresholds are kept for this file on the device where you set them.

What it changes · 2027

① Income statementNo effect€0.00Analysis reads the plan; a distribution is entered in the appropriation of the result.
② CashNo effect€0.00The simulator moves no cash flow.
③ Balance sheetNo effect€0.00Nothing is posted to the journal.

Source

Companies and Associations Code (CSA / WVV): the net asset test (Article 5:142, for the private limited company (SRL / BV)) and the liquidity test (Article 5:143).

Fiplan conventions (capacite-remboursement.ts, sensibilite.ts, capacite-distribution.ts): the DSCR read from the journal (taxes, capital and interest paid in cash); the adjusted EBITDA starting from the engine's EBITDA; the default thresholds (liquidity floor, minimum solvency); the recommendation capped at the result for the year.