How to Build a Financial Model for Your First SaaS

Building a financial model can feel intimidating if you’re a first-time founder. Common fears include: “I’ll get the math wrong,” or “Investors will rip apart my assumptions.” The reality is simpler: investors care about clear thinking, defensible assumptions, and clean outputs more than perfect precision.

This guide walks you through the essential components, gives practical formulas you can copy into a spreadsheet, and shows how to make realistic assumptions so your model is credible for both planning and fundraising.

What this model should do (and what it shouldn’t)

Should: produce a 12–36 month monthly forecast for MRR, customers, cash flow, and core SaaS metrics (CAC, LTV, churn), and highlight runway and break-even assumptions.
Shouldn’t: pretend to predict unknowns—use scenarios (best/base/worst) instead of a single overconfident forecast.

Basic structure: tabs to include in your spreadsheet

Assumptions (single source of truth for all inputs) ✅
Revenue / Customers (monthly MRR and customer counts) ✅
Expenses (COGS / hosting + operating expenses: payroll, marketing, G&A) ✅
Cash Flow & Cash Balance (monthly cash in/out and runway) ✅
Key Metrics & Dashboard (MRR chart, CAC payback, LTV:CAC, runway) ✅
Scenarios & Sensitivity (base, conservative, aggressive) ✅

Keep the assumptions tab simple and clearly labeled—this is what you will defend to investors.

Core inputs (use realistic, defendable numbers)

Starting cash balance
Starting customers and MRR
New customer acquisition per month (by channel optional)
Average Revenue Per Account (ARPA) or average MRR per customer
Churn rate (monthly) or retention curve
CAC by channel (or blended CAC)
Gross margin (1 - COGS/MRR)
Monthly operating expenses (payroll, hosting, marketing, tools)
Capital raises and planned use of funds (if any)

Tip: put ranges or two-point estimates (low/high) next to the assumption to show your uncertainty.

Revenue modeling — MRR & ARR (monthly cadence)

Start with a simple cohort-driven approach: model customers rather than revenue first.

Customers_t = Customers_{t-1} + NewCustomers_t - ChurnedCustomers_t
MRR_t = Customers_t * ARPA_t

Where:

NewCustomers_t = Traffic_t * ConversionRate_t (optional channel-level breakdown)
ChurnedCustomers_t = Customers_{t-1} * ChurnRate

Example formula (monthly churn and constant ARPA):

MRR_t = MRR_{t-1} + (NewCustomers_t * ARPA) - (Customers_{t-1} * ChurnRate * ARPA)

Pro tip: model on a monthly basis for the first 12–24 months—monthly granularity helps you spot seasonality and cash needs.

Customer economics: CAC, LTV, Payback

These are the most important unit economics.

CAC (Customer Acquisition Cost) = Total marketing + sales spend over period / New customers acquired during period
LTV (Customer Lifetime Value) (simple formula, assuming constant churn and gross margin):

LTV = ARPA * (GrossMargin) / ChurnRate

(If churn is monthly, ensure ARPA and churn rate are on the same timeframe.)

CAC Payback Period (months):

CAC_Payback = CAC / (ARPA * GrossMargin)

Rule of thumb: early-stage SaaS often targets LTV/CAC > 3 and CAC payback < 12 months; for bootstrapped businesses you want faster payback.

Caveat: these are simplified formulas—if you have trial conversion curves or multi-month ARPA changes, model cohorts and real revenue streams.

Expenses and operating model

Separate COGS (infrastructure, third-party costs per customer) from Operating Expenses (payroll, marketing, office, tools).

Gross Margin = 1 - COGS / Revenue. Keep an eye on gross margin early—low gross margin limits scaling.
Model payroll as the largest expense: hires, monthly salaries, benefits, and employer taxes. Add hiring lag (time-to-hire + ramp).
Marketing & sales: budget these as separate line items and tie them to customer acquisition where possible (e.g., spend $X -> acquire Y customers via paid channel).

Practical tip: keep an expenses cadence table (monthly) and include hiring milestones triggered by MRR thresholds.

Cash flow, burn rate, and runway

Monthly Burn = Total Cash Outflows - Total Cash Inflows (non-financing)
Runway (months) = Cash Balance / Burn Rate

If you expect to raise, model the fundraising as a cash inflow and clearly show use of proceeds and runway improvement.

Pro tip: run a conservative scenario assuming slower growth and higher CAC—this shows you how much cash you truly need.

Scenario planning & sensitivity

Build three scenarios: Conservative, Base, Aggressive. Key variables to tweak:

New customer growth rate
CAC (increase or decrease)
Churn
ARPA (price changes / upsells)

Run sensitivity tables for CAC, Churn, and ARPA to show which variables most influence runway and MRR. Investors like to see how fragile or robust your model is.

Common formulas (copy into your spreadsheet)

MRR_growth_rate_month = (MRR_t - MRR_{t-1}) / MRR_{t-1}
ARR = MRR * 12
Churn_rate_monthly = churned_customers / customers_start
LTV = ARPA * GrossMargin / ChurnRate_monthly
CAC = TotalMarketingSpend / NewCustomers
CAC_Payback_months = CAC / (ARPA * GrossMargin)
Burn = TotalCashOutflows - TotalCashInflows
Runway_months = CashBalance / Burn

Practical tips for realistic assumptions

Be conservative. Use conservative growth and slightly worse CAC than early tests—assume your best-case channel will degrade.
Benchmark. Use public benchmarks for your stage and industry (e.g., SaaS Capital, Pacific Crest reports) to sanity-check churn and conversion.
Avoid too many moving pieces. Start with a simple model and expand: get customers → ARR → cash. Add complexity (cohorts, upsells) as you gather data.
Document sources. Add a short note explaining why you chose each assumption—this wins trust with investors.

Common mistakes to avoid

Building wildly optimistic growth assumptions without supporting channels.
Forgetting hiring lags and ramp—salaries and hiring timelines are often underestimated.
Mixing timeframes (monthly churn vs annual ARPA) — keep units consistent.
Hiding fundraising assumptions—clearly show when and how much you expect to raise.

Example minimal outputs investors want to see

12–36 month monthly MRR and customer forecast
Cash flow statement and runway under base/conservative cases
Key metrics table (MRR growth, CAC, LTV, CAC payback, churn, gross margin)
A short assumptions page showing how you derived key inputs

Next steps (action list) ✅

Create the assumptions tab with defensible starting values.
Build a month-by-month customer table and test the MRR formula.
Add expense lines with hiring dates and marketing spend.
Calculate CAC, LTV, CAC payback, runway.
Run base/conservative/aggressive scenarios and prepare a 1–2-slide summary for investors.

Resources & templates

Template: I can generate a 12–36 month Google Sheet pre-filled with formulas and scenarios if you want—reply and I’ll create one for your product.
Books: Lean Analytics, The SaaS Metrics Guide (articles and public benchmarks).

Final notes — practical, not perfect ✨

A good early SaaS financial model is clear, defensible, and directional—not a crystal ball. Keep it readable, document your assumptions, and focus on the unit economics that matter. If you’d like, I can build a ready-to-use spreadsheet for your product with the formulas and scenario tabs already wired.

Ready to get a spreadsheet template? Reply and tell me whether you want a 12-month or 36-month model and whether your product is B2B or B2C.