Deterministic engine — formulas, not AI guesses

A bank-grade financial model in 5 minutes — live formulas and sensitivity analysis included

Describe the business or attach your data and get the Excel a CFO spends a week on: assumptions, P&L, cash flow, balance sheet, debt schedule and DSCR, NPV/IRR, tornado and sensitivity tables, dashboard. Plus an explanatory note for the credit committee.

Build the model → Download a sample model (xlsx)

Every number is an Excel formula, not an AI output. The balance sheet balances in every period. No result — no charge.

Metric202620272028
Revenue28 80034 41141 117
EBITDA6 2048 71711 817
Net profit2 5864 4716 999
DSCR3,632,623,44
Balance check000
NPV @ 22 %=NPV(rate, CF!D29:H29)+CF!C29 → 16 103
Price → NPV = 0at a −32 % drop

Fragment of the demo model of a bakery-café: 2 products, a 5-year loan at 21 %. Every cell is a formula (demo in Russian; your model is built in the language of your brief).

What is inside the financial model

The structure credit analysts and investors expect. Yellow cells are inputs; everything else recalculates.

10 sheets with formulas

Statements and debt

  • Assumptions: prices, volumes, growth, costs, headcount, working capital, taxes + scenario multipliers
  • Revenue by product → P&L with margins → indirect cash flow → balance sheet (check row = 0)
  • CAPEX and depreciation; debt: annuity or straight-line, grace period, schedule, DSCR and ICR
  • Metrics: NPV, IRR, payback, break-even, safety margin, minimum cash
AssumptionsDashboardMetricsRevenueP&LCAPEXDebtCash flowBalance sheetSensitivity
What the bank asks about

Sensitivity analysis

  • Tornado: NPV at ±10 / ±20 % of price, volume, variable and fixed costs, CAPEX, interest rate
  • The shift of each driver at which NPV hits zero (headroom on price, volume, rate)
  • Tables: price × volume → NPV and IRR; costs; interest rate × CAPEX → minimum DSCR
  • Scenario multipliers on the Assumptions sheet — stress any scenario right in Excel
  • Explanatory note (DOCX): results, assumptions, defaults taken, methodology

Industries: retail, wholesale, manufacturing, services, agro, construction, HoReCa, logistics, IT/SaaS, medical. Horizon 1–10 years by year, quarter or month.

ABC/XYZ assortment analysis from a sales export

For commercial directors and purchasing: upload an export from your ERP, marketplace or CRM and learn what to keep in stock, what to order on demand and what to delist.

How it is computed

  • Columns are detected automatically: item, group, period, quantity, revenue, margin or cost
  • ABC by cumulative revenue share (80 / 95 %) and separately by margin when present
  • XYZ by the coefficient of variation of demand across months (10 / 25 %)
  • 9-group matrix: items, revenue, share — COUNTIF / SUMIF formulas
  • Class thresholds are editable on the Parameters sheet — everything recalculates

What you get

  • Excel: an Analysis sheet with shares, cumulative share, coefficient of variation and classes — as formulas
  • Recommendations for each of the 9 groups with your own example SKUs (AX — auto-replenish; AZ — order on confirmed demand; CZ — delist)
  • Pareto and cumulative-share charts; a short DOCX note for the meeting

Sample result (xlsx) · Sample input export

Upload the export →

How it works

Describe the business

In plain words: products, prices, volumes, cost of sales, rent, headcount, CAPEX, equity and loan. Or attach a file — the figures are taken from it.

Get the model

In 3–5 minutes — xlsx and docx. Whatever was missing came from the industry template and is listed separately: confirm or correct it in one message.

Keep it current

Send the model back with actuals (“2026 revenue 31M, loan 9M”) — it is rebuilt with the other inputs kept. Banks ask for an up-to-date model; now it takes minutes.

Pricing

Paid with Konsilito credits — one balance for every service. 1 credit ≈ $0.001. A new account gets 500 welcome credits: the first ABC/XYZ analysis is free.

Financial model

≈ 1500 credits

≈ $1.5 per model: xlsx with formulas + explanatory note. Updates cost the same.

ABC/XYZ

≈ 500 credits

≈ $0.5 per analysis of any export: xlsx with formulas + note. Free with the welcome credits.

No risk

No file — no charge

If the model or analysis is not produced (missing data, unreadable file) no credits are taken.

FAQ

Will a bank accept a model built by a service?

A bank checks the links, not the author: formulas, a balancing balance sheet, realistic assumptions, DSCR. The model is built exactly the way a CFO builds it: every calculation is an Excel formula, inputs are highlighted, assumptions are listed in the note. There are no AI-generated numbers in the model — the AI only turns your description into inputs.

What if I do not have all the figures?

Missing inputs come from the industry template (working-capital days, inflation, discount rate, payroll taxes) and are explicitly flagged as defaults. Change the yellow cells — the model recalculates.

Which export works for ABC/XYZ?

xlsx or csv: item, sales amount and month/date (as rows) or month columns. Quantity and margin if available. Without periods only ABC is computed. Sample export.

Monthly or quarterly?

Yes: a horizon of 1–10 years by year, quarter or month — pick it in the form or say so in the brief.

Is it confidential?

Files are stored in your Konsilito account and reachable only via your links; your data is not used for training.

Build your model now

Sign in with your Konsilito account. The first ABC/XYZ analysis is covered by the welcome credits.

Financial model → ABC/XYZ analysis →