Ready 36-month business financial model in Excel — 9 linked sheets on live formulas. Change assumptions and everything recalculates: revenue, profit, cash, LTV/CAC.
The bundled example is a coffee-shop chain (2 locations → 4 over 3 years). Replace the yellow cells with your own numbers — the model fits any small business: food service, retail, services, manufacturing.📦 FORMAT · VERSION · GUARANTEE• Contents: ZIP — XLSX model (9 sheets), verify_model.py (recalc & compare), docs/METODIKA.md, GUIDE.pdf with screenshots, README, LICENSE• Version: September 2026 · No macros: Excel 2016+ / Google Sheets / LibreOffice• : automatic e-mail right after payment• Guarantee: reproducible bugs fixed in 24–72h (6 months of support)WHAT´S INSIDE (9 SHEETS)• Dashboard — 8 KPIs: revenue, profit, cash balance, cash gap, LTV/CAC, CAC payback• Assumptions — the only input area: price, traffic, growth, locations, rent, food cost, taxes, 30% payroll contributions• Revenue — 36 months: traffic growth with a cap, scenario multiplier, COGS• Staff — headcount, salaries, 30% insurance contributions (2026)• OpEx — rent/misc/marketing/payroll with yearly indexation• P&L — depreciation, EBITDA, 15% simplified tax, net profit monthly and cumulative• Cash — inflows/outflows/CapEx/balance/runway: see the cash gap before it happens• Unit economics — CAC, LTV, payback, LTV/CAC (healthy ≥ 3)• Scenarios — pessimistic ×0.75 / base / optimistic ×1.3, one-cell switch
VERIFICATION — 30 CONTROL POINTS
python verify_model.py recalculates the workbook with the formulas engine and compares it to an independent Python computation: revenue, EBITDA, tax, net profit (months 1–36), cash balance, LTV. Match to the ruble. Gallery screenshots are real Excel (sheets printed via COM), not drawn mockups.bFOR WHOM/bbr• An entrepreneur sizing up a business before launch: how much capital, when it pays back, where the cash gap isbr• An operating business — a 3-year plan for banks and investorsbr• Franchises and consultants — a template for client unit economicsbr• An investor — a summary with ROI and required capitalbrbWHY IT IS NOT "A 200-RUB SPREADSHEET"/bbrFormulas are open (click any cell), every sheet´s logic is documented in docs/METODIKA.md, and the model passed an independent verification. Nothing hidden, nothing breaks on edit: quoted cross-sheet references (P&L, unit economics), negative-balance guards, traffic caps.brSEE ALSO: WB/Ozon unit economics PRO for marketplace sellers; Plati seller profit analytics.<br /><br /><br />MORE FROM THE SHOP:<br />⟶ PHP SaaS Starter Kit Pro: SaaS source code: subscriptions, invoices, API — e-market.su /6190459<br />⟶ Mortgage calculator widget: white-label payment-schedule widget — e-market.su /6190678<br />⟶ AI Agency Toolkit: 12 client templates and 40 prompt systems — e-market.su /6195112<br />⟶ Telegram Business Pack: 8 bots on one core: shop, CRM, quizzes — e-market.su /6198929<br />⟶ Marketplace Seller Suite: WB/Ozon: prices, SEO, unit economics, supply — e-market.su /6200000<br />⟶ CRM Automation Bundle: self-hosted CRM: funnel, reports, notifications — e-market.su /6201824<br />⟶ Freelancer Operating System: time tracker, projects, taxes, contracts — e-market.su /6203531<br />⟶ Small Business Accounting Pack: NPD and USN taxes, bank CSV + Excel — e-market.su /6204262