LeadMagic SaaS Financial Modeling
Overview
Most founder financial models are fiction — aggressive growth curves with no operational logic underneath. The mistake: building a top-down model ("we'll capture 1% of a $100B market") instead of a bottom-up operating model ("we'll hire 3 AEs at $120K OTE, each producing $800K quota in month 6"). This skill covers building a real operating model that investors trust, boards respect, and YOU can use to make decisions. Now includes DCF valuation, consumption-based pricing models, cohort analysis, and full ARR bridge/build methodology.
When to Use
Trigger phrases: "financial model", "SaaS P&L", "runway calculation", "DCF valuation", "consumption pricing model", "cohort analysis", "ARR bridge", "headcount plan", "revenue forecast", "409A valuation", "unit economics model", "annual GTM budget", "operating budget", "variance review", "QuickBooks vs NetSuite"
Authoritative Foundations
David Skok — SaaS Unit Economics
LTV = (ARPA × Gross Margin %) ÷ Monthly Churn Rate. LTV/CAC > 3x is investable. CAC Payback < 12 months is good.
Aswath Damodaran — DCF Valuation
"The value of any asset is the present value of its expected future cash flows." For startups: high growth + high risk = high WACC (20-30% for early stage).
Ben Murray — The SaaS CFO
Three P&L layers: Revenue (new + expansion - churn), COGS (20-30%), OpEx
(S&M + R&D + G&A). Model per-head where possible. PE exits require EBITDA
bridge — see references/unit-economics-exit-bridge.md.
Meritech Capital — Public SaaS Benchmarks
For IPO-track scenarios, compare implied ARR growth, FCF margin, and Meritech Rule of 40 to public medians. references/meritech-saas-benchmarks.md. Private stage gates remain in references/benchmark-reconciliation.md.
Force Management — Pod Economics & Headcount Planning
Bottom-up headcount from pod economics: group SDR/AE/SE/CSM into pods, run
pod cost % of ARR (target ≤35% at 80% ramp), link quota attainment distribution
to hiring triggers. See references/force-management-playbook.md (repo root)
and references/unit-economics-exit-bridge.md.
Step-by-Step Process
Phase 1: Revenue Model (Bottom-Up)
Do NOT model "1% of market." Model customers × average revenue.
Monthly Revenue Model:
New Customers = (SDR meetings × demo conversion rate) + inbound + expansion
Average ACV = $X (new logo) / $X (expansion)
Monthly Churn = Previous month customers × monthly churn rate
Net New MRR = (New × ACV) + Expansion - Churned
Revenue inputs to get right:
- SDR productivity: 8-12 meetings/month per SDR
- Demo conversion: 20-30% for qualified meetings
- Sales cycle: 30-90 days depending on ACV
- AE ramp: 3-6 months to full quota
- Monthly churn: 1-3% SMB, 0.5-1% mid-market, <0.5% enterprise
Phase 2: Headcount Model
Model every hire with: role, salary, start month, ramp, fully-loaded cost. Fully-loaded = base × 1.25-1.35 (benefits, payroll tax, tools, equipment).
S&M Headcount by ARR Stage (benchmarks):
| ARR | AEs | SDRs | CSMs | Managers |
|---|---|---|---|---|
| $0-1M | Founder(s) | — | — | — |
| $1-3M | 1-3 | 2-4 | 1 | — |
| $3-10M | 5-10 | 5-10 | 3-5 | SDR Mgr, VP Sales |
| $10-20M | 10-20 | 10-15 | 5-10 | Full management layer |
Phase 3: Operating P&L
MONTHLY P&L STRUCTURE:
REVENUE: New MRR + Expansion MRR - Churned MRR = Net New MRR
COST OF REVENUE (20-30%): Hosting, APIs, support team
GROSS PROFIT / Gross Margin %
OPERATING EXPENSES:
S&M: Headcount + tools + ad spend + events
R&D: Headcount + tools + infra
G&A: Headcount + rent + legal + SaaS tools
NET OPERATING INCOME (Loss)
Phase 4: Cash Flow & Runway
Starting Cash: $X
+ Inflows: customer cash (monthly/annual) + expansion
- Outflows: payroll (60-70%), infra, tools, marketing, rent, legal
= Net Cash Burn
Runway (months) = Cash ÷ |Monthly Net Cash Burn|
Runway rules: 18+ months post-raise. Start fundraising at 9-12 months left. Cash-zero date is NOT when you start fundraising — it's when you're dead.
Phase 5: Scenario Planning
Load references/gtm-budget-playbook.md for annual S&M/R&D/G&A structure,
headcount-driven build, vendor budget tie to gtm-spend-management, and monthly
variance cadence. Worksheet → skills/gtm-ops/gtm-spend-management/templates/annual-gtm-budget-worksheet.md.
| Driver | Conservative | Base Case | Aggressive |
|---|---|---|---|
| Monthly churn | 3% | 2% | 1% |
| Demo conversion | 15% | 25% | 35% |
| ACV | $10K | $15K | $20K |
| AE ramp (months) | 6 | 4 | 3 |
| Hiring speed | 45 days | 30 days | 21 days |
Conservative should feel uncomfortable. It's a stress test, not a wish.
Consumption-Based Pricing Models
What they are: Customers pay based on usage, not seats. Examples: AWS (per compute hour), Twilio (per SMS/API call), Snowflake (per credit), Stripe (per transaction). Consumption models align price with value.
Modeling consumption revenue:
CONSUMPTION REVENUE MODEL
Base Metric: [API calls / compute hours / events / contacts]
Usage Tiers:
- Light (0-1K units): X% of customers, avg Y units/mo, $Z/unit
- Medium (1K-10K): X% of customers, avg Y/mo, $Z/unit
- Heavy (10K-100K): X% of customers, avg Y/mo, $Z/unit
- Enterprise (100K+): X% of customers, avg Y/mo, $Z/unit
Monthly Revenue = Σ (customers in tier × avg usage × unit price)
Key consumption metrics:
- NRR: Best-in-class consumption companies hit 130%+ NRR (usage compounds)
- Usage Growth Rate: 5-10% MoM per existing customer = healthy
- Dormancy Rate: % of customers with zero usage in a month. <5% healthy.
- Commitment Coverage: % of committed spend consumed. <80% at renewal = risk.
Consumption model pitfalls:
- Revenue unpredictability → Fix: Annual commitments with true-up
- Pricing complexity → Fix: Usage dashboards, spend alerts, never-exceed caps
- Volume discounting → Fix: Tiered pricing from day 1, no custom discounts
Hybrid models (best of both):
- Platform fee (predictable) + consumption (growth-aligned)
- Seat minimum + usage above threshold
- "Starter includes X units, then $Y/unit above"
Expansion Revenue Modeling
The 5 expansion levers:
| Lever | Model As | Contribution to NRR |
|---|---|---|
| Seat expansion | New seats × ACV | 3-8% of starting ARR |
| Usage growth | Consumption increase × unit price | 5-15% of starting ARR |
| Tier upgrade | (New price - Old) × Upgrading | 2-5% of starting ARR |
| Cross-sell | New product ACV × Attach rate | 2-10% of starting ARR |
| Price increases | Increase % × Retained customers | 3-5% of starting ARR |
Expansion formula:
Expansion ARR = (Starting ARR × Seat Exp %) +
(Starting Usage × Usage Growth % × Unit Price) +
(Upgrading × Tier Delta) +
(Eligible × Cross-Sell Attach % × Cross-Sell ACV) +
(Retained × Price Increase %)
DCF Valuation for SaaS Companies
When to use DCF: Fundraising, 409A valuations, acquisition offers, or understanding what your company is actually worth. DCF is the gold standard.
The DCF formula:
Enterprise Value = Σ (FCF_t ÷ (1 + WACC)^t) + Terminal Value
Where:
- FCF = EBIT × (1 - Tax Rate) + D&A - Capex - Δ Working Capital
- WACC = 12-25% for startups (higher = riskier stage)
- t = year 1 through 5
- Terminal Value = FCF_Year5 × (1 + g) ÷ (WACC - g)
(g = perpetual growth rate, 2-4%)
DCF Step-by-Step
Step 1: Project Revenue (5 years)
Year 1: Starting ARR × (1 + growth rate)
Year 2: Year 1 × (1 + decaying growth rate)
...decay toward terminal growth rate (3-5%)
Growth rate decay (benchmarks):
| Year | Early Stage | Growth Stage | Mature |
|---|---|---|---|
| 1 | 150-300% | 60-100% | 30-50% |
| 2 | 80-150% | 40-80% | 25-40% |
| 3 | 50-80% | 30-50% | 20-30% |
| 4 | 30-50% | 20-35% | 15-25% |
| 5 | 20-35% | 15-25% | 10-20% |
Step 2: Project Margins
Gross Margin: 65-75% early → 75-85% mature
S&M as % of Revenue: 80-120% early → 20-30% mature
R&D: 40-60% early → 15-25% mature
G&A: 15-25% early → 8-12% mature
EBITDA Margin: -50% early → 15-30% mature
Step 3: Calculate Free Cash Flow
Revenue - COGS = Gross Profit
- S&M - R&D - G&A = EBITDA
- D&A (2-5% of revenue) = EBIT
- Taxes (21% federal + state, startup NOLs typically offset)
= NOPAT
+ D&A - Capex (3-5% revenue) - Δ Working Capital (5-10% revenue change)
= Unlevered Free Cash Flow
Step 4: Calculate WACC
Cost of Equity = Risk-Free Rate (~4%) + (Beta × ERP) + Startup Premium
- Beta: 1.5-2.5 for SaaS
- ERP (Equity Risk Premium): 5-6%
- Startup Premium: 5-15% depending on stage
Early stage WACC: 20-30%
Growth stage WACC: 15-20%
Mature SaaS WACC: 10-15%
Step 5: Terminal Value
TV = FCF_Year5 × (1 + g) ÷ (WACC - g)
g = 2-4% (can't exceed GDP growth long-term)
Step 6: Enterprise Value & Sensitivity
EV = PV(Year 1-5 FCFs) + PV(Terminal Value)
SENSITIVITY TABLE (WACC × Terminal Growth):
| WACC → | 12% | 15% | 18% | 22% | 25% |
| g = 2% | $X M | $X M | $X M | $X M | $X M |
| g = 3% | $X M | $X M | $X M | $X M | $X M |
| g = 4% | $X M | $X M | $X M | $X M | $X M |
DCF quick-check (reality test):
- Early-stage SaaS: 10-20× forward ARR (growth rate dependent)
- Growth-stage: 8-15× forward ARR
- Mature: 5-10× forward ARR If your DCF is outside these bands, check your assumptions.
For exit planning, connect unit economics → P&L → ARR and EBITDA multiples via
references/unit-economics-exit-bridge.md. Sensitivity template →
exiting-company/templates/valuation-sensitivity-table.md.
Earn-out / deferred consideration: Model cash at close, earn-out scenarios
(base / max), and 3-year hold — not headline EV alone. Worksheet →
exiting-company/templates/earn-out-term-sheet-review.md. Structure norms →
references/benchmark-reconciliation.md. Typical not guaranteed — CPA for tax timing.
DCF Pitfalls for Startups
- Terminal value dominates. 80-90% of startup DCF = terminal value (most speculative part). Fix: Conservative terminal growth (2-3%). Wide sensitivity.
- Growth rate optimism. "100% growth for 5 years" = nonsense. Fix: Model realistic decay. Even the best decay toward market growth rates.
- WACC too low. 10% WACC for seed stage = utility-level risk pricing. Fix: Early stage WACC = 20-30%.
- No sensitivity. Single-point DCF = guess. Range = analysis. Fix: Always build sensitivity table.
SaaS Cohort & Unit Economics Deep-Dive
Cohort Analysis
Why cohorts matter: Aggregate churn of 2% hides that Q1 cohort churns at 5% and Q4 at 0.5%. One is a problem you can't see in aggregate.
Cohort retention curve (power law): Retention(t) = a × t^(-b). Where a ≈ 100%, b = churn decay factor.
Monthly cohort table:
| Cohort | M0 MRR | M1 | M3 | M6 | M12 | Est LTV |
|---|---|---|---|---|---|---|
| Jan 2025 | $X | $X | $X | $X | $X | $X |
| Feb 2025 | $X | $X | $X | $X | — | $X (est) |
Cohort CAC payback: Aggregate "8 months" can hide Q2 cohort taking 14 months. Fix: Track CAC payback per cohort, not just aggregate.
Unit Economics by Segment
| Segment | ACV | Churn | LTV | CAC | LTV:CAC | Payback |
|---|---|---|---|---|---|---|
| SMB (<$1K ACV) | $X | X% | $X | $X | Xx | X mo |
| Mid-Market ($1-10K) | $X | X% | $X | $X | Xx | X mo |
| Enterprise ($10K+) | $X | X% | $X | $X | Xx | X mo |
Decision rule: If LTV:CAC < 3x, stop acquiring in that segment until fixed.
ARR Build vs. ARR Bridge
ARR Build (forward-looking): Starting ARR + New ARR + Expansion - Churned - Contraction = Ending ARR
ARR Bridge (backward analysis): Starting ARR + New Logo + Expansion - Logo Churn - Contraction - Downsell = Ending
The bridge tells WHERE growth came from. The build projects WHERE it will come from.
Revenue lens: Model recognized revenue in P&L; use committed MRR bridge for
board ARR/NRR. Reconcile gaps (prepay, PS, implementation delay) via
references/saas-mrr-accounting-nuances.md and references/bookings-billings-revenue-matrix.md.
Accounting Stack for SaaS (Founder Timing)
| Stage | Stack | Hire trigger |
|---|---|---|
| Pre-$500K ARR | QuickBooks Online or Xero + Stripe/billing + bookkeeper (Pilot/Bench class) | Founder + part-time bookkeeper |
| $500K–$3M ARR | QBO/Xero + billing + fractional CFO | First finance hire = controller or strong fractional CFO |
| $3M–$15M ARR | Evaluate NetSuite; dedicated controller | VP Finance when board/investor reporting >20 hrs/mo founder |
| $15M+ / multi-entity | NetSuite or ERP | Full-time CFO |
Chart of accounts (minimum): Subscription revenue, PS revenue, COGS (hosting), S&M, R&D, G&A, deferred revenue.
Tax / 409A / QSBS awareness (not advice): references/saas-tax-founder-awareness.md · Carta 409A · CPA handoff triggers.
Bootstrap path: solo-founder-gtm · saas-outcomes/templates/bootstrap-capital-plan.md.
Output Format
SAAS FINANCIAL MODEL — [Company]
Summary (Base Case — 36 months):
- Ending ARR: $X M
- Headcount: X
- Gross Margin: X%
- Magic Number: X
- LTV:CAC: Xx
- CAC Payback: X months
- NRR: X%
- Rule of 40: X%
- Runway: X months
- Break-Even: [month/year or N/A]
DCF Valuation:
- Enterprise Value (Base): $X M
- Sensitivity Range: $X M - $Y M
- Implied ARR Multiple: Xx
Consumption Model (if applicable):
- Unit: [metric], Unit Price: $X
- Usage Growth Rate: X% MoM
- Dormancy Rate: X%
Key Assumptions: [10-15 key drivers documented]
Funding Requirement: $X M at month Y, runway post-raise: X months
Implementation Checklist
- Revenue modeled bottom-up (customers × ACV), not top-down (market %)
- Headcount has every role, start date, and fully-loaded cost (1.3x salary)
- Churn modeled monthly with compounding, not annual averaging
- AE ramp curve built (0% M1, 50% M3, 100% M6)
- Three scenarios: Conservative, Base, Aggressive (internally consistent)
- Cash flow includes ALL costs (insurance, legal, SaaS tools)
- LTV/CAC uses fully-loaded CAC (all S&M, not just ad spend)
- DCF uses appropriate WACC (20-30% early stage)
- Terminal growth capped at 3-4% (GDP growth ceiling)
- Sensitivity table built (WACC ±5%, growth ±10%, terminal g ±1%)
- Cohort analysis segmented (not just aggregate metrics)
- ARR bridge built alongside ARR build (where growth came from)
Quality Check
Before delivering, verify:
- Output matches the user's stated request
- Named frameworks or sources are reflected in the recommendation
- The deliverable is specific enough for an agent to execute
- Any assumptions, risks, or dependencies are explicit
- No unsupported claims, invented facts, or private/internal references are included
Common Pitfalls
Top-down revenue modeling. "1% of $100B market" = fiction. Fix: Model customers × ACV with realistic acquisition.
Zero churn assumption. No SaaS has zero churn. Fix: 1-3% monthly churn minimum for SMB, 0.5-1% for mid-market.
Instant AE productivity. AEs don't close month 1. Fix: Ramp curve: 0% M1, 50% M3, 100% M6.
Terminal value dominates DCF. 80-90% of startup value from terminal = speculative. Fix: Conservative terminal growth (2-3%). Wide sensitivity.
WACC too low for startups. 10% WACC for seed stage implies utility-level risk. Fix: Early stage WACC = 20-30%. Risk is real.
Aggregate metrics hiding segment problems. 2% churn average hides 5% SMB churn and 0.5% Enterprise. Fix: Segment everything.
Execution Artifacts
references/framework-notes.md— Named frameworks and reference tablestemplates/output-template.md— Deliverable shell for agent outputscripts/check-output.py— Lightweight deliverable validatorreferences/gtm-budget-playbook.md— canonical annual GTM budget (repo root)skills/gtm-ops/gtm-spend-management/templates/annual-gtm-budget-worksheet.md— budget worksheet (gtm-spend-management skill)references/saas-mrr-accounting-nuances.md— MRR/recognition reconcile (repo root)references/saas-tax-founder-awareness.md— tax/409A/QSBS handoffs (repo root)references/bookings-billings-revenue-matrix.md— cash vs committed ARR (repo root)references/unit-economics-exit-bridge.md— LTV/NRR/EBITDA → valuation multiple bridge Cross-skill (journey / exit):gtm-spend-management(vendor budget) ·saas-metrics-calculator(MRR bridge) ·saas-outcomes/references/journey-stage-gates.md,saas-outcomes/references/bootstrap-founder-playbook.md,saas-outcomes/templates/bootstrap-capital-plan.md,saas-outcomes/templates/journey-planning-worksheet.md,saas-outcomes/references/valuation-multiples.md,exiting-company/templates/valuation-sensitivity-table.md,exiting-company/templates/earn-out-term-sheet-review.md,exiting-company/references/negotiating-earn-out.md,exiting-company/references/buyer-readiness-checklist.md,saas-metrics-calculator/references/metric-definitions-exit-weight.md,references/benchmark-reconciliation.md
⚠️ Disclaimer
This skill provides general informational guidance based on publicly available frameworks and operator experience. It is NOT legal advice, accounting advice, tax advice, financial advice, insurance advice, or professional services advice.
Consult qualified professionals for your specific situation — attorneys for legal/equity matters, CPAs for tax and accounting, licensed brokers for insurance, and certified security assessors for compliance. This skill does not create a professional-client relationship. Use it as a starting point for research and preparation.
Related Skills
saas-metrics-calculator— Complete SaaS metrics with stage benchmarksfundraising-strategy— Fundraising process, SAFEs, term sheetsboard-meeting-prep— Board deck, metrics presentationpricing-strategy— Tier design, monetization modelspricing-psychology— Anchoring, decoy effect, willingness-to-payinvestor-updates— Monthly investor communicationsco-founder-dynamics— Equity modeling, co-founder equity splitsyc-ecosystem— YC funding context and valuation benchmarks