Outputs
1 artefact
gousto_financial_model (1).xlsx
Highlights
- Steps
- 4
- Median time
- 7m
- Views
- 1
- Last active
- 21 May
- Model used
Claude
steps in the playbook
to use end to end
since published
latest view, fork, or discussion
Opus 4.6
You are a VP of Finance at a high-growth startup. I need a complete unit economics and financial model for Gousto.
Please provide:
- Unit economics breakdown:
- Customer Acquisition Cost (CAC) by channel
- Lifetime Value (LTV) calculation with assumptions
- LTV:CAC ratio and payback period
- Gross margin per unit/customer
- Contribution margin analysis
3-year financial projection:
- Revenue model (monthly for year 1, quarterly for years 2-3)
- Cost structure breakdown (fixed vs. variable)
- Break-even analysis: when and at what volume
- Cash flow forecast with burn rate
- Sensitivity analysis: best case, base case, worst case
- Key assumptions table with justification for each assumption
- Benchmark comparison: How do my metrics compare to industry standards
- Red flags: What numbers should worry me and trigger action
Format as a financial model summary with clear tables and formulas.
My business: Gousto — UK's largest recipe box delivery company by number of meals served. Founded 2012, headquartered in London, with automated fulfilment facilities in Lincolnshire and the Midlands. Gousto delivers pre-portioned ingredient kits with step-by-step recipes directly to customers' homes, with a menu of 250+ recipes per week rotating across categories (everyday, premium, plant-based, calorie-controlled, family, 10-minute meals).
Current financials (estimated 2025):
- Revenue: ~£350M annually
- Active customers: ~1.8M who have ordered in the last 12 months
- Orders per month: ~2.5M boxes
- Average order value (AOV): ~£32 (typically 3–4 meals for 2 people per box)
- Average orders per active customer: ~16 per year (roughly every 3.3 weeks — not weekly, which is a key retention insight)
- Gross margin: ~32–35% (ingredients ~40% of revenue, packaging ~8%, fulfilment/delivery ~18%). Margins have improved significantly since investment in robotic automation at the Lincolnshire facility which reduced pick-and-pack costs by ~30%
- EBITDA: Recently reached breakeven/slight profitability after years of losses — estimated ~£5–10M positive EBITDA in 2025 after burning through ~£300M+ in cumulative funding
- Total funding raised: ~£400M from investors including Softbank, BGF, Unilever Ventures, and Joe Wicks (brand ambassador and investor)
CAC by channel (estimated):
- TV advertising (largest spend): ~£45–55 per acquired customer. Gousto is one of the UK's heaviest TV advertisers in the DTC category — runs persistent campaigns on ITV, Channel 4, and Sky
- Paid social (Instagram, Facebook, TikTok): ~£30–40 per acquired customer
- Influencer/creator partnerships: ~£25–35 per acquired customer (Joe Wicks, Nadia Hussain, micro-influencers in food/family content)
- Referral programme ("Give £25, Get £25" off first box): ~£18–22 per acquired customer — lowest CAC, highest quality customers, but limited scale
- Organic/SEO/direct: ~£8–12 per acquired customer — lowest cost but driven by cumulative brand spend above
- Blended CAC: ~£32–38 per acquired customer
Retention and LTV dynamics (the critical challenge):
- First box to second box conversion: ~55–60% (first box is heavily discounted, typically 50–65% off)
- Month 1 to Month 3 retention: ~40% of first-box customers still active
- Month 3 to Month 12 retention: ~60% of those who reached Month 3 (the "habit" customers)
- 12-month retention from first order: ~22–25% — meaning roughly 3 in 4 first-time customers churn within a year
- Average customer lifespan: ~14–16 months for customers who make it past the 3rd order, but blended across all customers (including one-and-done discount seekers) it's closer to ~6–8 months
- Estimated blended LTV: ~£180–220 per acquired customer
- LTV:CAC ratio: ~5.5–6.0x (healthy, but inflated by the tail of long-retention customers masking the high volume of early churners)
Cost structure:
- Variable costs (~70% of revenue): Ingredients and sourcing (~40%), packaging (~8%), last-mile delivery (~18%, outsourced to DPD and own fleet), payment processing (~2%)
- Fixed costs (~25% of revenue): Fulfilment centre operations and automation depreciation (~10%), technology and product development (~6%), corporate overhead (~5%), customer service (~4%)
- Marketing (~18–22% of revenue): The single largest discretionary spend. Gousto has historically spent aggressively on customer acquisition with the thesis that recipe box habit formation creates long-term LTV — but the 75% first-year churn rate challenges whether this spend level is sustainable at current retention rates
Key modelling questions: First, the unit economics look healthy at the blended level (5.5x LTV:CAC) but mask a dangerous bimodal distribution — a small cohort of loyal customers (~25%) generates the vast majority of lifetime value while ~50% of acquired customers order once or twice at deep discount and never return. Should Gousto reduce first-box discounting to improve customer quality even if it reduces top-line acquisition volume? Second, the path to sustained profitability depends on whether gross margins can expand from ~33% to ~40%+ through further automation, reduced food waste (currently ~4% of ingredients are wasted), and supplier negotiation — what does the breakeven look like at current margins vs. target margins? Third, the competitive landscape is shifting — HelloFresh (the global leader, ~€7B revenue) has entered a cost-cutting phase and may engage in UK price wars, while supermarket meal kits (Tesco, M&S, Waitrose) and quick commerce (Deliveroo, Uber Eats) are competing for the same "don't want to think about dinner" occasion at lower price points. How sensitive is the model to a 10–15% reduction in AOV or a 5-point increase in churn? Fourth, Gousto's robotic fulfilment investment is a potential competitive moat — if automation reduces variable costs by another 10–15% over 3 years, does that fundamentally change the breakeven dynamics and make the business defensible against HelloFresh's scale advantages?
I'll build this as a comprehensive Excel financial model. Let me start by reading the skill file for spreadsheet creation.Now let me build this comprehensive financial model for Gousto.Zero errors across 268 formulas. Let me copy to outputs.Here's the complete model across 8 tabs. Let me give you the VP Finance headline view:
The core tension: Gousto's blended unit economics look healthy (5.7x LTV:CAC, 4-month payback) — but they mask a dangerous bimodal reality. The top 25% of customers generate ~18x LTV:CAC while the bottom 50% are destroying value at ~1.4x. Half of all marketing spend is subsidising customers who order once at 65% off and vanish.
Three things that matter most:
The automation investment is the single highest-ROI lever in the business. £45M cumulative CapEx over 3 years delivers ~£37M in annual EBITDA uplift by pushing gross margins from 32% toward 39%. That's a ~14-month payback. At 32% gross margin, Gousto is treading water at breakeven. At 39%, it's generating £55M EBITDA. Every point of gross margin is worth roughly £4.5M of EBITDA — this is where management attention should be.
The discount strategy needs to shift from volume to quality. The model shows that reducing first-box discounting from 65% off to 40% off cuts acquisition volume by ~25% but lifts 1st→2nd box conversion from 57% to 68% and LTV from £200 to £280. Total lifetime value created is actually higher with fewer, better customers. This is the hardest commercial decision — it looks like shrinking the business to grow it.
The competitive shock scenario is the existential risk. A combined 15% AOV reduction (from a HelloFresh price war or supermarket substitution) plus a 5-point churn increase wipes £80M off revenue and £45M off EBITDA — pushing the business back into heavy cash burn with limited runway. The automation moat is real but not yet wide enough to be fully defensive.
What the tabs contain: Key Assumptions (all inputs in blue, all formulas in black), Unit Economics (CAC by channel, LTV waterfall, cohort-adjusted view, per-box margins), 3-Year P&L (monthly Y1, quarterly Y2–Y3 with seasonality), Cash Flow (burn rate, runway, CapEx schedule), Sensitivity Analysis (bear/base/bull across all key drivers), Break-Even (at current vs target margins with a margin sensitivity table), Benchmarks & Red Flags (vs HelloFresh and DTC best practice with traffic-light triggers), and Strategic Analysis (modelled answers to your four key questions).

File
gousto_financial_model (1).xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Want to build playbooks like this?
Ascend captures your AI work and turns it into reusable playbooks. Free during early access.