How do production, demand, pricing, and channel assumptions shape the commercial plan?
Model profile
Soft Drinks
Lender-grade soft-drinks bottling: shelf-price waterfall, sugar excise, filling-line OEE, sculpted debt, and international KPI and IFRS registers.
Decision scope
Questions this model helps you examine
What capacity, working capital, operating cost, and funding does the business require?
How do downside cases and key sensitivities affect cash flow and investment returns?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Shelf-price waterfall, bill of materials, and sugar-tiered excise with reformulation
- Syrup room and filling lines with OEE, ramp-up, and applied yields
- Returnable glass, visi-coolers, IFRS 16 leases, and capitalised construction interest
- Senior debt sculpted to a target DSCR and sized on a lender downside, with DSRA, lock-up, and cash sweep
- International soft-drinks KPI review, requirements register, and IFRS S1/S2 data
- Full re-run commodity, FX, CAPEX-overrun, and break-even scenarios with XLSX, PDF, and CSV exports
Build the case
Inputs and workspaces
- AssumptionsTiming, commercial, tax, liquidity, covenant, and dividend controls
- Production schedulesProducts, channels, sales, labour, process costs, working capital, OPEX, CAPEX, debt, and equity
- Risk, analytics & AINamed scenarios, sensitivity, Monte Carlo, forecast, resilience, and decision support
Review the result
Outputs and analysis
- Equity IRRAnnual
- Project IRRAnnual
- Minimum DSCRRepayment years
- Senior debtUSD
- Financial statementsDetailed schedules
- Commercial and OPEX schedulesDetailed schedules
- Operations and working-capital schedulesDetailed schedules
- Funding schedulesDetailed schedules
- Valuation, analytics & AIDetailed schedules
Designed for review
Who this model is for
- Founders and business owners
- Production and commercial teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?