Step-by-Step Guide

How to Build a Financial Model from Scratch

A financial model is the map your investors, board, and future self will use to make decisions. Here's how to build one correctly — from revenue assumptions to three-statement integration.

Updated: June 2026 Reading time: 12 minutes

Why you need a financial model before your next raise

The first question any institutional investor asks after your pitch is: "Can I see the model?" They are not testing your spreadsheet skills. They are testing whether you understand the economics of your own business — and whether the numbers you just presented are derived from real assumptions or pulled from thin air.

A well-built financial model also surfaces the questions your board will ask 18 months from now: "What does our path to profitability look like?" "How much runway do we have at current burn?" "What revenue do we need to hit to extend to 24 months?" Without a model, you are guessing. With one, you are running a business.

Board presentations

Your board wants to see the story behind the numbers. A model lets you show scenario analysis, not just "we think MRR will grow."

Fundraise due diligence

Lead investors will rebuild your model from scratch to stress-test your assumptions. If they find holes, trust erodes. Build it right the first time.

Operational planning

Headcount plans, vendor commitments, office expansions — all of these should flow from your model. Without one, you are making spending decisions without a framework.

Scenario modeling

What happens to runway if your revenue growth slows 40%? A model lets you answer "what if" before the crisis hits — not during it.

1

Build your revenue model first

Revenue is the foundation. Everything else — headcount, burn, cash — is derived from it. A weak revenue model corrupts everything downstream, so get this right before moving on.

SaaS revenue model structure

For B2B SaaS startups, the revenue model should project:

  • New MRR New logo ARR each month, based on pipeline conversion assumptions
  • Expansion MRR Net dollar retention — existing customers growing their seats or plan
  • Churned MRR Monthly churn rate applied to prior month base
  • Net new MRR New − Churn + Expansion
  • Cumulative ARR Rolling sum of net new MRR added to starting base
Key assumption to document

Your MRR churn rate. Pre-product-market-fit startups often use 5–8%/month. Post-PMF SaaS with strong retention uses 1–2%/month. Document which you are using and why — investors will ask.

Sample monthly revenue build

Month Starting ARR + New − Churn + Expansion Ending ARR
Month 1 $500K $40K $8K $5K $537K
Month 6 $900K $60K $10K $12K $962K
Month 12 $1.6M $90K $16K $24K $1.7M
Month 18 $2.8M $120K $22K $42K $2.9M
Month 24 $4.2M $150K $32K $65K $4.4M

Sample SaaS cohort model. Use your own pipeline data to build the New MRR assumption. Churn rate assumptions should be based on actual data once you have it, or industry benchmarks for similar cohort ages.

2

Model your expenses by category

Expense categories matter. Investors look at the ratio between revenue growth and expense growth (the efficiency curve), so model categories cleanly enough to show that ratio clearly.

Revenue-driven expenses

These scale with revenue. Model them as a percentage of ARR or a per-customer variable.

  • ✓
    Cost of Goods Sold (COGS)
    Hosting, infrastructure, customer support
  • ✓
    Sales Commissions
    Typically 8–12% of new ARR
  • ✓
    Customer Success
    Often 10–15% of ARR post-PMF

Fixed and semi-variable expenses

These grow in steps or on a different timeline than revenue. Model them separately.

  • ›
    Engineering salaries
    Grows in headcount steps, not continuous
  • ›
    Marketing
    Step function — campaigns and channels added in batches
  • ›
    G&A
    Grows slower than revenue post-PMF

Headcount model (most important expense)

Build a separate headcount model first. Every hire has a fully-loaded cost that is higher than base salary.

Engineering
Base × 1.5
Benefits, payroll tax, equity
Sales / CS
Base × 1.4
Commission accelerator included
G&A
Base × 1.35
Lower variable component

Use 1.4–1.6× multiplier for total compensation. Do not model headcount at base salary alone — investors will catch it and recalculate your burn.

3

Build the P&L

The P&L integrates your revenue and expense models to show net income. For SaaS, the key metrics on the P&L are Gross Margin, Operating Expenses by function, and Net Burn.

P&L Line Month 1 Month 12 Month 24
Revenue (ARR) $500K $1.7M $4.4M
Gross Profit $475K $1.6M $4.1M
− Engineering $120K $280K $520K
− Sales & Marketing $80K $200K $400K
− G&A $30K $55K $90K
Operating Expenses $230K $535K $1.0M
Net Income $245K $1.06M $3.09M
Net Burn ($55K) ($135K) $290K net positive

Sample P&L from a healthy SaaS model. Numbers are illustrative. Replace with your own assumptions — and always document which assumptions drive each line.

4

Build the cash flow statement

Revenue is an accounting concept. Cash is a survival concept. A startup can be "profitable" on the P&L and still run out of money if receivables stretch, deferred revenue runs out, or capital expenditures spike. The cash flow statement shows you when you run out of money — before you run out of money.

Operating Cash Flow

Net income + changes in working capital (receivables, payables, deferred revenue). For SaaS, deferred revenue is a significant cash flow driver — annual contracts collect cash before revenue is recognized.

Investing Cash Flow

Capital expenditures, equipment, capitalized software. Most early-stage SaaS has minimal investing cash outflow. Model this separately to keep it clean.

Financing Cash Flow

Venture funding, SAFE notes, convertible notes, debt. Each round adds to your cash position. Model your fundraise schedule alongside your operating cash flow.

The runway calculation

Ending Cash Balance ÷ Monthly Net Burn = Runway in months. If your net burn is $100K/month and you have $1.8M in the bank, your runway is 18 months. Always model 3 scenarios: base, downside (-30% revenue), and upside (+30% revenue) so you can see the range of runway outcomes.

Cash Position Base Downside Upside
Starting Cash $3.0M $3.0M $3.0M
Monthly Net Burn ($100K) ($120K) ($80K)
Months 1–6 $2.4M $2.3M $2.5M
Months 7–12 $1.8M $1.5M $2.0M
Runway (months) 18 14 24
5

Integrate the three statements

A financial model only works if the three statements talk to each other. The connections are:

P&L → Cash Flow
Net income flows into the operating section of the cash flow statement. If P&L shows a loss, cash flow reflects the same loss (with adjustments for non-cash items like stock compensation and depreciation).
Cash Flow → Balance Sheet
Ending cash balance from the cash flow statement flows into the cash line on the balance sheet. The balance sheet is a snapshot; update it each month to track receivables, payables, and deferred revenue.
Financing → Balance Sheet
Fundraising adds cash to the balance sheet and creates a corresponding entry on the liability or equity side (SAFE notes, convertible notes, or equity). Debt repayments reduce cash and reduce debt on the balance sheet.

How to check your model is correct

  • ✓
    Cash balance matches
    Ending cash from cash flow statement should match the balance sheet cash line exactly
  • ✓
    Income statement links to cash
    Net income reconciles to operating cash flow within non-cash adjustments
  • ✓
    Deferred revenue moves
    When you collect annual contracts, cash increases and deferred revenue increases on the balance sheet. Revenue is recognized monthly
  • ✓
    Round modeling is consistent
    New cash raised appears in financing cash flow and increases the balance sheet cash balance
6

Run scenario analysis and stress tests

A model with one scenario is a guess. Investors want to see the range — what happens if you hit your plan, and what happens if everything goes wrong. Build three scenarios explicitly.

Base Case
  • Revenue growth: 15–20%/month post-PMF
  • Churn: 1.5%/month
  • Net burn: $100K–120K/month
  • Runway: 18–20 months at current
Downside Case
  • Revenue growth: 5–8%/month (sales miss)
  • Churn: 2.5%/month (customer friction)
  • Net burn: $130K–150K/month
  • Runway: 12–14 months
Upside Case
  • Revenue growth: 25–35%/month (strong product-market fit)
  • Churn: 1%/month
  • Net burn: $60K–80K/month
  • Path to profitability: Month 18–22
Investor question you need to answer

"At what revenue level does the company hit breakeven, and what assumptions does that depend on?" If you cannot answer this from your model, investors will assume you do not understand your own business economics. Build this sensitivity table before your next investor meeting.

7

Build the cap table and fundraise scenarios

Your cap table answers investor questions about dilution, ownership, and exit scenarios. Model it alongside your financial model so you can show the impact of future raises on existing shareholder dilution.

Pre-seed round
$500K at $5M pre-money
10%
$0.50/share (par value $0.0001)
Seed round
$2.5M at $10M pre-money
20%
$1.00/share
Series A
$8M at $30M pre-money
21%
$3.00/share

Sample cap table structure. Replace with actual terms from your fundraising history. Include a fully-diluted cap table showing option pool and warrants, not just shareholder equity.

Free Template

Get the startup financial model template

The CFO Tech Stack Startup Financial Model is a 7-tab Google Sheets template built for Series A fundraising. Revenue model, P&L, cash flow, balance sheet, headcount, and three scenario tabs — all linked and ready to customize with your numbers.

Download Free Template → See pricing

7-tab Google Sheets. No signup required. Built for Series A due diligence.

Related tools and guides

Fundraise Readiness Score →
Score your investor-readiness before your next raise — built from the same metrics investors use in due diligence.
Cash Flow Intelligence →
AI-powered 12-month cash flow forecast. Connect your books and see your runway across three scenarios.
13-Week Cash Flow Model →
The $19 template that tracks weekly cash position, AR aging, and vendor payments — plus 3 scenario tabs.
Board Pack Template →
12-slide board narrative deck + KPI dashboard. Pre-built for Series A/B SaaS with speaker notes on every slide.

Frequently Asked Questions

What software should I use to build a financial model? +
Google Sheets or Excel are the standard. For early-stage startups, Google Sheets is preferred because it is collaborative and your investors likely want to review it in real time. Avoid building models in Notion, Airtable, or custom tools — investors expect Sheets or Excel and will be slower to review anything else.
How detailed should my revenue model be? +
Start at the monthly level for the first 12 months, then quarterly through year 3. Break revenue down by cohort (new logo MRR, expansion MRR, churned MRR) so you can show the mechanics of growth. Investors will ask about each component, especially churn and expansion rates.
How do I model churn correctly for a SaaS company? +
Churn is modeled as a percentage of your starting ARR each month. Use 1.5–2%/month for a healthy post-PMF SaaS company, 3–5%/month if you are early and still finding product-market fit. Never model zero churn — it is not realistic and investors will immediately discount your model.
What is a three-statement model and why does it matter? +
A three-statement model links the Income Statement (P&L), Balance Sheet, and Cash Flow Statement so they are internally consistent. Changes in one statement cascade to the others. This is how investors verify that your numbers are real — if the statements do not reconcile, the model is wrong.
How do I build a cap table in my financial model? +
Create a separate tab for the cap table. List each funding round with share price, shares issued, pre-money valuation, and post-money dilution. Include the option pool (typically 10–15% post-Series A) and calculate fully-diluted ownership after each round. Investors want to see the fully-diluted cap table, not just the current shareholder list.
What is the most common mistake in startup financial models? +
Modeling revenue without expense assumptions. If you show 3× revenue growth but do not model the sales and engineering hires needed to support it, the model collapses under scrutiny. Always build the expense side alongside the revenue side. Another common mistake: not stress-testing. Single-scenario models give investors no confidence you understand the range of outcomes.
Do I need to build the model in Google Sheets or can I use a template? +
Use a template as a starting point, not as the final model. CFO Tech Stack offers a free 7-tab financial model template at /products/startup-financial-model that covers the three statements, cap table, and scenario tabs. Customize it with your actual assumptions before sharing with investors — generic templates without real assumptions are easy to spot and will hurt your credibility in due diligence.

Your investors will ask for the model. Make it count.

CFO Tech Stack's Startup Financial Model template is built specifically for Series A fundraising — the same structure investors expect to see in due diligence. Download it, plug in your numbers, and present with confidence.

Download free template → Score fundraise readiness
← Back to Research