Live recalc

Assumptions

Every driver from SnapClaim's venture forecast.

60-Month Forecastrevenue / opex / ebitda / cash

Introductionforecast start

Forecast start date

Funding / Financingcapital raises

Raise 1
Raise 2
Raise 3
Raise 4 (optional)
24-month use of funds

User Growthper year

DriverY1Y2Y3Y4Y5
New users target
Churn rate
Average lifetime (months)
Total users
New users vs total (annual)

Subscription Revenue

Subscription 1
DriverY1Y2Y3Y4Y5
% of users on plan
Monthly subscription fee ($)
Subscription 2 (optional)
DriverY1Y2Y3Y4Y5
% of users on plan
Monthly subscription fee ($)
Revenue by plan (annual)

Cost Of Goods SoldAPI calls, claims, onboarding, hosting

DriverY1Y2Y3Y4Y5
API calls — price per user ($)
Unprocessed claims — price per user ($)
Onboarding fees — price per new user ($)
Hosting — price per user ($)
COGS by line (annual)

Salaries

Annual increase %
Recruitment cost (% of 1mo salary)
Founding Team
RoleMonthly $Start date
Director 1
Director 2
New Hires by Department (per year)
DeptMonthly $Y1Y2Y3
Devs
Marketing
Admin
Headcount growth (annual)

MarketingDirect spend, indirect per-user

DriverY1Y2Y3Y4Y5
Direct marketing — fixed ($/mo)
Direct marketing — % of revenue
Indirect marketing — price per new user ($)
Marketing spend (annual)

OverheadsExpense 1-10, fixed $/mo

ExpenseY1Y2Y3Y4Y5
Expense 1
Expense 4
Expense 5
Expense 6
Expense 7
Expense 8
Expense 9
Expense 10

Expenses 2 and 3 use % of revenue / price-per-new-staff drivers respectively and are read-only here; their $ impact still flows through Statements and the charts.

Overheads (annual)

Product Development

DriverY1Y2Y3Y4Y5
Development costs ($/yr)
Product development spend (annual)

CAPEX3 asset classes

Asset class 1 — period to depreciate (months)
DriverY1Y2Y3Y4Y5
Asset class 1 — fixed ($/mo)
Asset class 3 — period to depreciate (months)
DriverY1Y2Y3Y4Y5
Asset class 3 — price per new staff ($)

Depreciation itself is not modeled live in this build (a dynamic-OFFSET schedule HyperFormula can't parse — genuinely immaterial at SnapClaim's scale, ~$10.5k over 5 years vs $2.05m Year-5 revenue). CAPEX spend itself flows through Cash Flow and the Balance Sheet in full.

CAPEX spend (annual)

Tax

Annual corporate tax rate
First tax payment date
Tax payment interval (months)

Statements

Profit & Loss, Cash Flow and Balance Sheet · 5-year annual · $ · live.

Profit & Loss

$Year 1Year 2Year 3Year 4Year 5

Cash Flow

$Year 1Year 2Year 3Year 4Year 5

Balance Sheet

$Year 1Year 2Year 3Year 4Year 5

Dashboard

Headline KPIs · live.

60-Month Forecastrevenue / opex / ebitda / cash

24-month use of funds

Where it goes24mo spend split

Revenue vs EBITDA (annual)

Cash at year end