Financial Model Review
WealthAi Financial Model Review
Advisor Briefing for the WealthAi Team
Executive Summary
A rebuilt, driver-based financial model is now ready to sit alongside the March 2026 plan. It starts from first principles (sales funnel, cohort conversion, tiered pricing, cost base, expansion curves) and produces a full set of statements. Where it aligns with the existing model, that is validation. Where it diverges, it is usually because the rebuilt model adds mechanics the spreadsheet could not capture: expansion, churn, scenarios, and a working cash flow.
Headline: with a GBP 3M seed closing June 2026, the business reaches EBITDA breakeven in 2028 at +£878K on a £15.01M ARR base, with £6.07M of organic cash. Cash trough sits at year-end 2027 (£1.35M Base) before revenue ramp catches up with cost build. Growth shape is Triple-Double (406% / 207% YoY ARR), the post-£1M ARR T2D3 pattern. Net revenue retention runs at 123% across both 2027 and 2028 on a cohort basis. Figures are from the Base scenario of Financial Model v2.42 (6 May 2026 tuning pass), built on a cohort-driven sales engine. Customer count resolves from five operationally-meaningful drivers (concurrent sales teams, cohorts per team per year, cohort size, cohort cycle, conversion rate), making every revenue number auditable in any direction.
About This Model
The Excel workbook is formula-native. Every number is calculated live in Excel from the Assumptions tab. The Python engine that previously powered the web dashboard is being re-aligned to mirror the v2.32+ Cohorts → Revenue rewire (Phase 3 work, in progress). Until that lands, the Excel is the authoritative source of truth and the web dashboard may show stale numbers. The Assumptions tab is the single source for every driver: change a value there and the whole workbook recalculates.
Engine (Python)
- All drivers, formulas and assumptions live in code
- Versioned in git, every change is diffable
- Covered by unit tests on drivers and engine
- Three scenarios (Conservative, Base, Aggressive) from the same source of truth
- To change an assumption, edit the driver inputs and re-run
Excel (Output)
- Formula-native: every cell is a live Excel formula from the Assumptions tab, not a static number
- 14 sheets: Intro, Assumptions, Summary, Dashboard, Recommendations, Funnel, Clients, Revenue, Headcount, OpEx, P&L, Cash Flow, Balance Sheet, Unit Economics
- Interactive: switch between Base, Conservative and Aggressive via the scenario selector and every number recalculates
- Live charts on Dashboard and inline on Revenue, Cash Flow, P&L, Headcount and Unit Economics
- Cross-validated against the Python engine to zero percent diff across every tracked number
This is more rigorous than a pure spreadsheet: the logic is testable, versioned, and repeatable, and there is no risk of a broken formula silently changing an answer. If investors want to stress-test an assumption, we change one input in the driver config and regenerate the entire workbook.
What This Model Adds
The existing March 2026 plan is a client-by-client revenue schedule. Every named client is listed with a tier, contract value and start month, and the monthly MRR builds from that list. It is detailed and grounded in real pipeline data. The rebuilt model keeps that pipeline story intact and adds the mechanics investors will ask about.
Existing Model (March 2026 plan)
- Individual named clients on a monthly schedule
- Full blended TCV from day one for every client
- No churn modelled
- No funnel or conversion mechanics
- No unit economics (CAC, LTV, NRR)
- Formula errors on the P&L and cash sheets
- Single scenario
- No balance sheet or statement of cash flows
Rebuilt Model (v2.1, April 2026)
- Driver-based: funnel → conversion → clients → revenue
- Land-and-expand modelled for every tier (85-100%)
- 10% annual churn modelled
- 8 driver categories on one Key Drivers sheet
- Full unit economics: CAC, LTV, NRR, Rule of 40
- Working P&L, Balance Sheet and Cash Flow
- Three scenarios: Conservative, Base, Aggressive
- March 2026 plan preserved on a Reference sheet for side-by-side comparison
How the Numbers Compare
| Metric | March 2026 Plan | Rebuilt Model | Delta |
|---|---|---|---|
| Clients (year-end) | |||
| Dec 2026 | 12 | 11 | -8% |
| Dec 2027 | 44 | 50 | +14% |
| Dec 2028 | 96 | 116 | +21% |
| ARR (year-end) | |||
| Dec 2026 | £1,036,900 | £726,791 | -30% |
| Dec 2027 | £7,212,770 | £5,733,312 | -21% |
| Dec 2028 | £13,871,740 | £15,461,854 | +11% |
| Expenses (annual) | |||
| 2026 | £1,978,510 | £1,870,498 | -5% |
| 2027 | £3,705,922 | £3,844,697 | +4% |
| 2028 | £4,820,497 | £4,911,837 | +2% |
The shape of the story is consistent across both models: a slow 2026 build, a steep 2027 ramp, and a profitable 2028. The differences are explainable and, in most cases, make the rebuilt model more defensible to a diligent investor.
The reconciliation table above compares Jason's March 2026 plan to the April 2026 rebuilt model (v2.1). The current model is v2.42 (5 May 2026 cohort engine rebuild) and the headline figures throughout the rest of this review reflect v2.42 Base. See the Base scenario values in the stat cards above for the current numbers.
The rebuilt model shows more clients at lower initial ACVs in 2026 and 2027 because large clients are assumed to land at a fraction of their full tier TCV and expand upward over the first 6 to 18 months (see next section). By 2028 the cohorts have matured, expansion has compounded, and total ARR pulls ahead of the existing plan. Expenses track within 5% across every year, which is strong validation of the cost base.
Key Findings
1. The land-and-expand story is now visible in the numbers
This is the single biggest change from the March 2026 plan and it deserves to be the headline. The rebuilt model lands every client at a fraction of their tier TCV and ramps them to full contract over the first phase of the relationship:
- Boutique lands at 85% of TCV, expands to 100% by month 6
- Small lands at 80%, expands to 100% by month 9
- Medium lands at 70%, expands to 100% by month 12
- Large lands at 60%, expands to 100% by month 15
- Very Large lands at 55%, expands to 100% by month 18
This matches what is actually happening in the pipeline (Plurimi landing at GBP 35K on a GBP 196K tier, Mediobanca landing at GBP 50K on a GBP 495K tier) and produces net revenue retention of 123% in both 2027 and 2028, driven by per-tier expansion of 25-45% across the platform. That is the compounding platform thesis made numerical: land with compliance, expand into research and advisory.
This is the investor story
NRR above 120% is what separates a compounding SaaS platform from a collection of point solutions. Every board slide, investor conversation and KPI dashboard should lead with expansion revenue alongside new logos. The cohort programme produces the proof points. If expansion runs faster than modelled, the upside is significant. If it stalls, the Conservative scenario shows the downside.
2. Cash runway is comfortable with a GBP 3M seed
Cash stays positive across the entire plan with the raise sized at GBP 3M and closing in June 2026. The trough sits at year-end 2027 (£1.35M Base), after which revenue ramp begins to fund the business. Full year 2028 closes at +£878K EBITDA on an organic cash balance of £6.07M.
| Milestone | Cash Balance | Comment |
|---|---|---|
| Apr 2026 (model start) | £647K | Opening balance |
| Jun 2026 (pre-close trough) | £494K | Final pre-seed month |
| Jul 2026 (seed close) | £3.39M | +£3M seed |
| Dec 2026 | £2.43M | Cash positive |
| Dec 2027 (trough) | £1.35M | Trough before revenue ramp catches cost base; ~3 months runway at burn pace |
| FY 2028 EBITDA flips positive | — | +£878K EBITDA, +9.2% margin |
| Dec 2028 | £6.07M | Organic cash; EBITDA breakeven full-year |
The GBP 3M raise does the job without forcing an emergency bridge in any scenario. Conservative survives on the seed alone (£3.44M cash YE 2028, EBITDA -£555K); Base reaches EBITDA breakeven with £6.07M cash; Aggressive cushions to £13.54M.
3. Unit economics are healthy across all three years
| Metric | 2026 | 2027 | 2028 | Benchmark |
|---|---|---|---|---|
| CAC | £50K | £69K | £49K | £40-80K vertical SaaS norm |
| Entry ACV (Year 1) | £46K | £71K | £89K | |
| LTV (horizon-capped) | £116K | £332K | £415K | |
| LTV:CAC | 2.33x | 4.82x | 8.48x | 3-5x good, >5x excellent |
| CAC Payback | 17.2 months | 15.5 months | 8.8 months | 12-18 months good |
| Gross Logo Retention | 90% | 90% | 90% | 92-95% target |
| NRR (cohort) | n/a | 123% | 123% | 110-120% good |
| Rule of 40 | n/a | 319 | 217 | >40 good |
Capital-efficient, defensible unit economics
CAC includes Commercial and Marketing payroll fully loaded with 30% employer cost loading, 12% sales commission on invoicing, and a 25% sales loading uplift covering ramp inefficiency, accelerators and enablement tools. LTV is horizon-capped (3 years for 2026, 5 years from 2027) on entry-discounted ACV compounded by gross logo retention and cohort NRR, so expansion is not double-counted. CAC Payback drops to 8.8 months by 2028, well inside the 12-18 month industry target. LTV:CAC lifts from 2.33x in year one (fully-loaded CAC against partial-year cohorts at 3-year horizon) to 4.82x in 2027 and 8.48x in 2028 as cohorts mature and the LTV horizon extends to 5 years. Gross logo retention is reported separately so each metric is investor-defensible.
Modelled, not yet observed. The metrics above are derived from the financial model v2.42 cohort engine (6 May 2026 tuning pass). The first cohort is in flight. Observed CAC and ACV will be measurable after Q3 2026 close. NRR will be measurable after 12 months of usage at the anchor client (Q4 2026). Until then, treat these numbers as forward-looking targets that we are committed to validating.
4. Things that still need confirmation from the team
Named pipeline assumption
The 2027 ARR ramp relies on specific named clients converting at specific times (Mediobanca, Plurimi, Rathbones, JM Finn among others). The rebuilt model uses a funnel-led approach that assumes this pipeline holds. If any of these deals slip out of 2027, the profile shifts closer to the Conservative scenario. Please confirm the named pipeline is still live.
Hiring plan and actual payroll
The rebuilt model carries 45 roles across Management, Technology, Product, Commercial, Marketing and Legal, organised by department on the Headcount tab. Scheduling reflects the Q2 2026 HR plan with fully loaded payroll at 30% employer cost loading. Sharing updates to actual monthly payroll and planned hire dates on a rolling basis will let us keep the cost base tight. Expenses already reconcile to within 5% of the March 2026 plan.
2028 cost base is conservatively estimated
The hiring plan carries an explicit roster through 2028 (37 FTE in Base, 31 in Conservative, 45 in Aggressive). The business will need to add further engineering, commercial and customer success capacity as client volume compounds past 100 active accounts. Any real 2028 run-rate is likely to sit above the modelled numbers, particularly on marketing, customer success and engineering. The +£878K EBITDA and £6.07M cash exiting 2028 should be read as a ceiling on what the business generates on the current plan, not a floor. Management will rebaseline 2028 costs once the first wave of expansion hiring lands mid-2027.
International ramp timing
The model currently assumes Italy and Switzerland open in Q4 2026, with each geography taking roughly 6 months to reach steady funnel throughput. Either the model timing moves to 2027, or the public positioning explicitly carves out the model assumption as more aggressive than the conservative external narrative.
Expansion velocity
The NRR story depends on clients actually moving from compliance to research and advisory. The Launch Group cohort is the evidence base. If expansion happens faster than the curves above, every scenario gets stronger. If it stalls, NRR drops toward 90% and the Conservative case becomes the realistic one. This should be the KPI the team tracks hardest from Q3 2026.
Three Scenarios
| Metric (Dec 2028) | Conservative | Base | Aggressive |
|---|---|---|---|
| ARR | £8.24M | £15.01M | £26.73M |
| Active Clients | 58 | 106 | 148 |
| EBITDA | -£555K | +£878K | +£4.59M |
| Cash YE 2028 | £3.44M | £6.07M | £13.54M |
Base is the management plan of record, the numbers the business is committed to executing. Conservative is an adverse-conditions stress test (40% conversion, 12% churn, geos slip three months, 10% lean operating spend via Cost Multiplier); it shows the business survives on the seed alone with cash positive at year-end, not a forecast. Aggressive is an upside case (55% conversion, 8% churn, faster cohort cadence, slightly richer cost envelope); it shows the ceiling if compliance lands cleanly, reference clients convert their peers, and the platform compounds into the enterprise segment. Aggressive lands at 1.35× Base ARR — squarely inside the credible bull-case benchmark range (1.3-1.8×).
What Needs to Happen Next
Before investor meetings
- Confirm the named 2027 pipeline. Mediobanca, Plurimi, Rathbones, JM Finn and the rest. Which are still in, which are at risk, what is the honest probability on each. The ramp depends on it.
- Share the real payroll numbers. The cost base is close, but tightening it with actual salaries and start dates takes one more objection off the table.
- Reconcile the international timing. The model still has Italy and Switzerland opening Q4 2026. Canonical positioning is 2027 for both. Pick one and propagate, or explicitly carve out the model assumption as more aggressive than the public narrative.
- Agree the expansion narrative. NRR of 121% in 2027 is the story. The team needs a consistent pitch on what drives it (cohort graduates, new modules, geographic replication) and what the early proof points are.
After seed close
- Track actual vs model monthly. The Summary sheet has a month-by-month view. Compare actual MRR, client count and burn from month one.
- NRR is the north star. Expansion revenue from the first cohort graduates is the single metric that proves the platform thesis. Build the KPI dashboard around it.
- International readiness gate. Italy and Switzerland hires only fire if the UK playbook is documented and repeatable. Whatever launch date is chosen (model says Q4 2026, canonical says 2027), the gate is the same: the UK playbook has to work first.
Deliverables
Driver engine (Python)
Source of truth for every number in this briefing. Lives at model/ with unit tests in test_drivers.py and test_engine.py. Three scenarios defined in config.py.
Excel workbook (generated output)
13-sheet presentation at model/output/WealthAi_Financial_Model.xlsx. Sheets: Summary, Intro, Key Drivers, Sales Funnel, Revenue, Costs, Hiring Plan, P&L, Balance Sheet, Cash Flow, Unit Economics, Valuation, Reference. Regenerated from the engine whenever assumptions change.
Reference sheet
The March 2026 plan data is preserved inside the workbook for side-by-side comparison. Nothing has been lost, and every difference between the two models is traceable.