Bilanea

Sample report

A complete financial report, generated from a demo ledger

Atelier Lumière SAS is a fictional retail company (NAF 47.59B): €1.2M revenue, nine employees, an ongoing loan. The report below is produced live by the Bilanea engine from its ledger file — exactly what you get with your own documents.

The amounts are fictional but consistent: the ledger balances, so does the balance sheet, and cash computed from working capital matches bank balances. On a real company, the AI-written reading and the multi-year history complete this report.

In brief

Financial health

Sound

80 / 100 · grade A

Strength

Profitability

100 / 100 on this component

Watch point

Operating cycle

35 / 100 on this component

Net cash

272 k€

83 days of revenue

Priority no. 1

Shorten customer payment terms

+100.3 k€cash

Financial health score

80out of 1000100A
  • Profitability100
  • Financial structure85
  • Liquidity93
  • Operating cycle35
  • Growth50
  • Solvency90
Altman Z'' score
8.22 (safe zone)
Conan-Holder score
0.39 (low risk)
Rating equivalent (indicative)
3+

Revenue

1.2 M€

EBITDA

195 k€

EBITDA margin 16.3%

Net profit

125.3 k€

Cash flow (CAF)

149.3 k€

Net cash

272 k€

Net debt

-172 k€

-0.9× EBE

Action plan

Cumulative potential of the actions on profit and cash: €100,274

  1. PriorityCash

    Shorten customer payment terms

    +100.3 k€cash
    Detail and actions

    Customers pay in 30 days versus 5 days in your sector. Returning to the median frees about 100 274 € of cash.

  2. To considerSale

    Prepare and maximise the sale value

    +1.1 M€value
    Detail and actions

    Equity value is estimated between 880 391 € and 1 290 517 €. Each extra euro of EBITDA is worth about €4.2 of value; documenting adjustments (owner pay, non-recurring costs) is the fastest lever.

  3. To considerFinancing

    Available borrowing capacity to invest

    +185.3 k€value
    Detail and actions

    Over 7 years at 4,5 %, the company can raise about 185 250 € within banking norms (annuity ≤ 70% of CAF, net debt ≤ 3.5× EBITDA).

What to do now?

To handle

Cash: meeting the deadlines

Cash €272,000; short-term debts (suppliers, tax, social) €148,750; cash flow from operations €149,250.

  1. Does cash cover the short-term debts?

    From your accounts : Cash €272,000 against €148,750 of short-term debts.

    Yes

  2. Does the business generate cash (positive cash flow from operations)?

    From your accounts : Cash flow from operations €149,250.

    Yes
Good news

Cash under control: build a safety reserve

You hold 5 months of fixed costs (€48,783 a month). Target: at least three months, i.e. €146,349.

What to do

  1. Open a dedicated savings account and transfer a fixed amount every month
  2. Keep a 13-week cash plan updated every Monday
  3. Pay tax and social debts on time to avoid surcharges and penalties

To considerFinancing: what can be borrowed?Cash flow from operations €149,250; financial debt €100,000; estimated borrowing capacity €185,250.

  1. Can a bank lend on the basis of the current accounts?

    From your accounts : Estimated borrowing capacity €185,250 (repayments covered by cash flow from operations).

    Yes

Does the project to be financed earn more than the cost of credit (about 4.5% a year)?

To considerDistribute or keep the profit?Distributable profit €125,250; cash €272,000; recommended reserve of three months of fixed costs €146,349.

  1. Is there a distributable profit?

    From your accounts : Distributable profit €125,250.

    Yes

  2. After distribution, does cash keep three months of fixed costs (€146,349)?

    From your accounts : Cash after full distribution: €146,750.

    Yes

Is an investment or a hire planned within twelve months?

To considerInvest now?Estimated borrowing capacity €185,250; cash €272,000.

Do you have a costed project (equipment, premises, hire, development)?

Ratios and sector benchmark

Retail trade — 100 = best position in the sector, 50 = median.

Profitability

  • Gross margin rate65.5%Sector median 36%100Good
  • Value added rate58.5%Sector median 23%100Good
  • EBITDA margin16.3%Sector median 5%100Good
  • Net margin10.4%Sector median 2%100Good
  • Return on capital employed (ROCE)44.4%Sector median 10%100Good
3 ratios without a sector reference
  • Return on equity (ROE)43.9%Sector median —No reference
  • Cash flow / revenue12.4%Sector median —No reference
  • Trade margin rate42.5%Sector median —No reference

Terms and turnover

  • Days sales outstanding (DSO)30 dSector median 5 d0Watch
  • Days payable outstanding (DPO)30 dSector median 40 d33Average
  • Days inventory outstanding (DIO)32 dSector median 55 d71Good
  • Working capital requirement in days of revenue2 dSector median 15 d80Good
  • Revenue per employee133.3 k€Sector median 200 k€26Watch
3 ratios without a sector reference
  • Cash in days of revenue83 dSector median —No reference
  • Working capital in days of revenue85 dSector median —No reference
  • Asset turnover2.25Sector median —No reference

Structure and leverage

  • Equity ratio53.4%Sector median 30%87Good
  • Net debt / EBITDA-0.9×Sector median 2×88Good
  • Current ratio2.88Sector median 1.1100Good
  • Debt repayment capacity0.7 yrsSector median 3 yrs79Good
4 ratios without a sector reference
  • Financial debt / equity0.35Sector median —No reference
  • Interest coverage (EBITDA / interest)48.75Sector median —No reference
  • Interest / revenue0.3%Sector median —No reference
  • Implied interest rate on debt4%Sector median —No reference

Other indicators

  • External costs / revenue7%Sector median 12%78Good
  • Staff costs / revenue42%Sector median 15%0Watch
  • Staff costs / value added71.8%Sector median 65%37Average
4 ratios without a sector reference
  • Depreciation / value added3.4%Sector median —No reference
  • Effective tax rate25%Sector median —No reference
  • Weight of exceptional items0%Sector median —No reference
  • Owner remuneration / EBITDA0%Sector median —No reference

Intermediate management balances

  • Revenue1.2 M€
  • Purchases and external costs-498 k€
  • Value added702 k€
  • Staff and taxes-507 k€
  • EBITDA195 k€
  • Depreciation, financial, income tax-69.8 k€
  • Net profit125.3 k€
From every euro sold to what is left: red is what leaves, blue the balances.
Show the detailed table
Intermediate management balances
Balance2025
Sales of goods€720,000
Gross margin on goods€306,000
Production for the year€480,000
Purchases from third parties€84,000
Value added€702,000
EBITDA (EBE)€195,000
Operating profit€171,000
Profit before tax€167,000
Exceptional result€0
Net profit€125,250
Cash flow from operations (CAF)€149,250
Adjusted EBITDA (leasing)€195,000

Financial structure and cash

  • Net cash272 k€
  • Short-term debts148.8 k€
  • Target: 3 months of fixed costs146.4 k€
5.6 months of fixed costs covered by cash
Permanent capital
€385,250
Net fixed assets
€106,000
Working capital
€279,250
Working capital requirement
€7,250
Operating working capital requirement
€7,250
Non-operating requirement
€0
Net cash
€272,000
Net financial debt
-€172,000

Borrowing capacity

Additional borrowing under three banking constraints: annuities ≤ 70 % of cash flow, net debt ≤ 3.5 × EBITDA, debt ≤ 1 × equity.

Recommended capacity (7 years)

€185,250

Existing financial debt

€100,000

Cash flow available for new annuities

€83,808

Current debt service (estimated)

€20,667

Current leverage (net debt / EBITDA)

-0.9×

Debt service coverage (cash flow / annuities)

7.22×

Borrowing capacity
TermRateMaximum amountAnnuityBinding constraint
5 years4.5%€185,250€42,198Gearing
7 years4.5%€185,250€31,437Gearing
10 years4.5%€185,250€23,412Gearing
15 years4.5%€185,250€17,249Gearing

Valuation

Indicative range, not a formal valuation.

Estimated equity value

880.4 k€ – 1.3 M€

Central : 1.1 M€

Enterprise value

882.7 k€

Net debt deducted : -172 k€

Confidence index

73%

5 methods retained out of 5

Valuation
MethodLowCentralHighWeight
EBITDA multiple682.5 k€819 k€975 k€40%
Revenue-based scale (goodwill)360 k€600 k€840 k€10%
Net asset value (adjusted book equity)Latent capital gains (property, inventory) are not included without an appraisal.84.7 k€113.3 k€141.8 k€10%
Capitalised normative net income663 k€871.8 k€1.2 M€15%
Discounted cash flows (simplified DCF)1.2 M€1.4 M€1.8 M€25%

Break-even

Assumption: 40 % of external costs are variable, the rest fixed.

  • Revenue1.2 M€+266.3 k€
  • Break-even revenue933.7 k€
Safety margin: 22% above break-even
Break-even revenue
€933,652
Break-even point
284 days of activity
Safety margin
22.2%
Contribution margin rate
62.7%
Fixed costs
€585,400
Variable costs
€447,600

Three-year forecast

Three-year forecast
YearBase scenariogrowth 2%/yrOptimisticgrowth 5%/yrPessimisticgrowth -2%/yr
20261.2 M€Cash 388.2 k€1.3 M€Cash 401.8 k€1.2 M€Cash 369.4 k€
20271.2 M€Cash 507.8 k€1.3 M€Cash 540.2 k€1.2 M€Cash 464.6 k€
20281.3 M€Cash 631 k€1.4 M€Cash 687.7 k€1.1 M€Cash 557.9 k€

Generated on 20 Oct 2026 · Bilanea engine 1.3.1

Get the same report for your company

First analysis free, from your ledger or balance sheet.

Analyse my companyHow it works