SaaSSaaS
Investor Pitch Deck: Seed Round
View case study
Back to all work
SaaSClient engagement
Five Year SaaS Financial Model | Scenario Driven MRR/ARR Forecast
A scenario driven five year SaaS financial model that turns a monthly customer cohort engine into investor ready MRR/ARR, cash-runway, and fundraising outputs. Eight one click cases let investors stress test the plan on the spot. Built to support an $8M raise.
Shown anonymised at the client's request.
- Client
- Confidential
- Our role
- Senior SaaS Financial Modeller
The engagement
The founders were heading into a raise and needed a model investors could actually stress test, one that tied bottoms up customer cohorts to ARR, burn, and runway, rolled up into full financials, and could switch between scenarios instantly instead of breaking every time an assumption changed.
What we built
A 13 tab model driven by a one click scenario manager (8 cases). A monthly cohort engine (trials → conversion → churn) builds 24 months of MRR/ARR by plan and add on module, then flows into staffing & opex, a cash runway forecast, funding & break even, five year P&L / balance sheet / cash flow, two-way sensitivity grids, and a KPI dashboard.
The outcome
A board and investor ready model showing $1.89M ARR and 1,866 customers by month 24, 22.9x LTV:CAC, and 92% gross margin, used to support an $8M raise.
Deliverables
- 13 tab Excel model
- Scenario manager (8 cases)
- Cohort & revenue build
- Staffing & opex
- Monthly cash flow & runway
- Funding & break even
- 5 year P&L / balance sheet / cash flow
- Sensitivity analysis
- KPI dashboard
Skills & tools
- Excel
Deliverable (view only)
ProtectedFive Year SaaS Financial Model | Scenario Driven MRR/ARR Forecast
Opens in a distraction free, full screen reader. View only, no download.
Downloading, printing and copying are disabled. All work is the property of A&S Financial Consultants and its clients.
Discuss a similar model
Book a free scoping call and we will map out the model your business needs. Available 9:00 AM to 8:00 PM EST, Mon to Fri.
