---
# === IDENTITY ===
id: business/fundraising/financial-projections-for-investors/2026
canonical_question: "How do I present financial projections to investors — detail level by stage, assumptions, common investor questions?"
aliases:
  - "How to build a startup financial model for investor pitch"
  - "What financial projections do seed and Series A investors expect"
  - "Bottom-up revenue forecast for startup fundraising"
  - "Unit economics presentation for investor meetings"
entity_type: execution_recipe
domain: business > fundraising > financial projections for investors
region: global
jurisdiction: global
temporal_scope: 2025-2026

# === VERIFICATION ===
last_verified: 2026-03-12
confidence: 0.90
version: 1.0
first_published: 2026-03-12

# === TEMPORAL VALIDITY ===
temporal_validity:
  status: evolving
  last_breaking_change: "Investors in 2025-2026 demand unit economics and path-to-profitability even at seed stage — a shift from growth-at-all-costs era"
  next_review: 2026-09-08
  change_sensitivity: high

# === CONSTRAINTS ===
constraints:
  - "All revenue projections must be bottom-up (customers x ARPU x retention) — top-down market share claims are immediately discounted"
  - "Seed decks need 18-24 month projections; Series A needs 3-year projections with monthly detail for Year 1"
  - "Every assumption must be stated and defensible — investors rarely challenge the numbers, they challenge the assumptions behind them"
  - "Include base case, upside case, and downside case — single-scenario models signal lack of risk awareness"
  - "Unit economics (CAC, LTV, payback period, gross margin) are mandatory for Series A and strongly expected for seed"

# === SKIP CONDITIONS ===
skip_this_unit_if:
  - condition: "User needs overall pitch deck structure, not financial model"
    use_instead: "business/fundraising/pitch-deck-structure-by-stage/2026"
  - condition: "User needs SaaS-specific benchmark data for projections"
    use_instead: "finance/industry-benchmarks/saas-industry-benchmarks-2026/2026"
  - condition: "User is preparing for due diligence after term sheet"
    use_instead: "business/fundraising/due-diligence-preparation-checklist/2026"

# === AGENT HINTS ===
inputs_needed:
  - key: funding_stage
    question: "What funding stage are the projections for?"
    type: choice
    options: ["pre-seed", "seed", "Series A", "not sure"]
  - key: business_model
    question: "What is the primary business model?"
    type: choice
    options: ["SaaS/subscription", "marketplace/transaction fee", "e-commerce", "services/consulting", "usage-based/API", "other"]
  - key: has_revenue
    question: "Does the startup currently have revenue?"
    type: choice
    options: ["no revenue yet", "some revenue (< $10K MRR)", "growing revenue ($10K-$100K MRR)", "significant revenue (> $100K MRR)"]
  - key: modeling_tool
    question: "What tool will be used for the financial model?"
    type: choice
    options: ["Google Sheets", "Excel", "Causal", "Mosaic", "no preference"]

# === EXECUTION METADATA ===
execution:
  required_inputs:
    - name: "Business model definition"
      source: "founder"
      format: "pricing structure, revenue streams, cost structure"
    - name: "Current metrics (if available)"
      source: "analytics/CRM/accounting"
      format: "MRR, users, CAC, churn rate, gross margin"
    - name: "Hiring plan"
      source: "founder"
      format: "role list with start dates and compensation"
  outputs:
    - name: "Investor-ready financial model"
      format: "spreadsheet (Google Sheets or Excel)"
      description: "3-year projection with monthly Year 1 detail, assumptions log, unit economics dashboard, and scenario analysis"
    - name: "Financial projections pitch slides"
      format: "2-3 presentation slides"
      description: "Summary financials formatted for the pitch deck — revenue trajectory, use of funds, path to key milestones"
  tools_required:
    - name: "Spreadsheet tool"
      purpose: "Build the financial model with formulas and scenario toggles"
      tier: "free"
      cost: "$0 (Google Sheets) to $0 (Excel with Microsoft 365)"
      alternatives: ["Google Sheets", "Excel", "Causal ($50/mo)", "Mosaic"]
    - name: "Charting tool"
      purpose: "Create clean charts for pitch deck slides"
      tier: "free"
      cost: "$0 (Google Sheets charts) to $12/mo (Figma)"
      alternatives: ["Google Sheets", "Excel", "Figma", "Canva"]
  credentials_needed:
    - service: "Google Sheets"
      type: "Google account"
      where_to_get: "https://sheets.google.com"
      free_tier_limits: "Unlimited"
  estimated_duration: "4-8 hours for complete financial model"
  estimated_cost: "$0 (spreadsheet) to $50/mo (Causal for automated modeling)"

# === DISTRIBUTION ===
canonical_source: "https://knowledgelib.io/business/fundraising/financial-projections-for-investors/2026"
suggested_citation: "Source: knowledgelib.io — AI Knowledge Library (verified 2026-03-12)"

# === RELATED UNITS ===
related_kos:
  depends_on:
    - id: "business/fundraising/pitch-deck-structure-by-stage/2026"
      label: "Deck structure determines how much financial detail to show"
  feeds_into:
    - id: "business/fundraising/pitch-deck-slide-by-slide-guide/2026"
      label: "Financial slides populated from this model"
    - id: "business/fundraising/due-diligence-preparation-checklist/2026"
      label: "Financial model is a due diligence artifact"
  related_to:
    - id: "business/fundraising/investor-research-targeting/2026"
      label: "Tailor financial depth to investor type"
  alternative_to: []

# === SOURCES ===
sources:
  - id: src1
    title: "Startup Financial Projections: What Investors Actually Look For"
    author: Finro
    url: https://www.finrofca.com/news/startup-financial-projections
    type: guide
    published: 2025-06-01
    reliability: high
  - id: src2
    title: "The Ultimate Guide to Financial Modeling for Startups"
    author: EY
    url: https://www.ey.com/en_nl/services/finance-navigator/the-ultimate-guide-to-financial-modeling-for-startups
    type: guide
    published: 2025-01-01
    reliability: authoritative
  - id: src3
    title: "Building a Startup Financial Model That Works"
    author: Visible.vc
    url: https://visible.vc/blog/financial-modeling-for-startups/
    type: guide
    published: 2025-01-01
    reliability: high
  - id: src4
    title: "What Investors Want in 2026: From Seed to Series C"
    author: TalkingSeed
    url: https://www.talkingseed.com/blog/from-seed-to-series-c-decoding-what-investors-really-want-in-2026/
    type: analysis
    published: 2026-01-01
    reliability: high
  - id: src5
    title: "How to Create Financials for Pre-Seed Startups That Will Wow Investors"
    author: Feel the Boot
    url: https://www.feeltheboot.com/blog/pre-seed-startup-financial-projections
    type: guide
    published: 2025-06-01
    reliability: high
  - id: src6
    title: "Bottom Up Forecasting: Formula and Methodology"
    author: Wall Street Prep
    url: https://www.wallstreetprep.com/knowledge/bottom-up-forecasting/
    type: educational
    published: 2025-01-01
    reliability: authoritative
  - id: src7
    title: "Startup Financial Modeling: Balance Sheet, Cash Flow, and Unit Economics"
    author: Startup Rocket
    url: https://www.startuprocket.com/articles/startup-financial-modeling-part-4-the-balance-sheet-cash-flow-and-unit-economics
    type: guide
    published: 2025-01-01
    reliability: high
---

# Financial Projections for Investors

## Purpose

This recipe produces an investor-ready financial model with bottom-up revenue projections, unit economics dashboard, scenario analysis, and pitch-ready summary slides — calibrated to the detail level investors expect at each funding stage. The output is a spreadsheet model that passes investor scrutiny and 2-3 presentation slides summarizing the financial thesis for the pitch deck.

## Prerequisites

- [ ] **Business model definition** — pricing structure, revenue streams, and cost categories clearly defined
- [ ] **Current metrics** (if available) — MRR, users, CAC, churn rate, gross margin from analytics or accounting
- [ ] **Hiring plan** — roles needed over next 18-24 months with approximate compensation
- [ ] **Market data** — comparable company benchmarks for gross margin, CAC, and growth rates
- [ ] **Spreadsheet tool** — [Google Sheets](https://sheets.google.com) or Excel (free with Microsoft 365)

## Constraints

- All revenue projections must be bottom-up. Investors immediately discount top-down "if we get X% of the market" projections. [src1] [src6]
- Pre-seed: 12-18 month projection with monthly granularity. Seed: 18-24 months monthly + Year 2-3 quarterly. Series A: 3 years with monthly Year 1, quarterly Year 2, annual Year 3. [src5]
- Every assumption must be stated explicitly. Investors challenge assumptions, not numbers. [src2]
- Three scenarios required: base case (most likely), upside (aggressive growth), downside (slow growth / extended runway). [src2]
- Unit economics (CAC, LTV, payback period, gross margin) are mandatory for Series A and strongly expected for seed in 2026. [src4]

## Tool Selection Decision

```
Which path?
├── Budget = $0 AND spreadsheet-comfortable
│   └── PATH A: Google Sheets — free, collaborative, version history
├── Budget = $0 AND Excel preferred
│   └── PATH B: Excel — familiar, powerful formulas, offline
├── Budget = $50/mo AND wants automation
│   └── PATH C: Causal — formula-free modeling, scenario comparison
└── Budget > $100/mo AND enterprise
    └── PATH D: Mosaic or Runway — integrated with accounting data
```

| Path | Tools | Cost | Speed | Best For |
|------|-------|------|-------|----------|
| A: Google Sheets | Google Sheets | $0 | 4-6 hrs | Most founders, easy sharing with investors |
| B: Excel | Excel | $0-$9.99/mo | 4-6 hrs | Finance-background founders, complex formulas |
| C: Causal | Causal | $50/mo | 2-3 hrs | Non-finance founders, visual scenario comparison |
| D: Enterprise | Mosaic/Runway | $100-500/mo | 3-4 hrs | Series A+ with accounting integration |

## Execution Flow

### Step 1: Set Up the Model Structure

**Duration**: 30 minutes
**Tool**: Google Sheets or Excel

Create the spreadsheet with these core tabs. This structure is what investors expect and can navigate quickly. [src2] [src3]

```
Tab Structure:
─────────────────────────────────────────────────
Tab 1: ASSUMPTIONS — All inputs in one place (yellow cells = editable)
Tab 2: REVENUE — Bottom-up revenue model with driver formulas
Tab 3: COSTS — Fixed costs (team, rent, tools) + variable costs (COGS, marketing)
Tab 4: P&L SUMMARY — Monthly income statement (Revenue - COGS - Opex = Net Income)
Tab 5: CASH FLOW — Cash in / cash out / runway calculation
Tab 6: UNIT ECONOMICS — CAC, LTV, payback period, gross margin
Tab 7: SCENARIOS — Toggle base/upside/downside with scenario selector
Tab 8: CHARTS — Investor-ready charts for pitch deck slides

Rules for the model:
- All hardcoded assumptions live on Tab 1 ONLY (yellow highlighted cells)
- All other tabs reference Tab 1 assumptions via formulas
- No magic numbers buried in formulas — everything traces to Assumptions tab
- Include a "sources" column in Assumptions tab for every external benchmark
```

**Verify**: Changing any single assumption on Tab 1 flows through the entire model automatically.
**If failed**: You have hardcoded numbers in formula tabs. Search for cells not referencing the Assumptions tab.

### Step 2: Build Bottom-Up Revenue Projections

**Duration**: 1-2 hours
**Tool**: Spreadsheet

Build revenue from the smallest unit up. Never start with market size. [src1] [src6]

```
SaaS/Subscription Revenue Formula:
─────────────────────────────────────────────────
Monthly Revenue = (Starting Customers + New Customers - Churned Customers) × ARPU

Where:
  Starting Customers = Prior month ending customers
  New Customers = Leads × Conversion Rate
  Churned Customers = Starting Customers × Monthly Churn Rate
  ARPU = Average Revenue Per User (monthly)

Key Assumptions to State:
  - Lead generation rate (e.g., 500 leads/mo from paid + organic)
  - Lead-to-customer conversion (e.g., 3% for self-serve, 15% for sales-led)
  - Monthly churn rate (e.g., 5% for SMB, 2% for mid-market, 0.5% for enterprise)
  - ARPU (e.g., $49/mo starter, $199/mo pro, $499/mo enterprise)
  - Expansion revenue rate (e.g., 5% of existing customer base upgrades monthly)

Marketplace/Transaction Revenue Formula:
  Monthly Revenue = GMV × Take Rate
  GMV = Transactions × Average Order Value
  Transactions = Active Sellers × Orders per Seller

E-commerce Revenue Formula:
  Monthly Revenue = Site Visitors × Conversion Rate × AOV
```

**Verify**: Plug in your current numbers (if you have them) — the model should match actual revenue within 10%.
**If failed**: Your conversion rate or churn assumptions are off. Adjust to match historical data before projecting forward.

### Step 3: Model Costs with Hiring Plan

**Duration**: 1-2 hours
**Tool**: Spreadsheet

Costs must be as detailed as revenue. Investors will check that use-of-funds matches the cost model. [src2]

```
Cost Categories:
─────────────────────────────────────────────────
COGS (Cost of Goods Sold):
  - Hosting/infrastructure (e.g., AWS: $X/mo, scaling with users)
  - Payment processing (e.g., Stripe: 2.9% + $0.30/txn)
  - Third-party API costs (e.g., AI inference, data providers)
  - Customer support staffing

Operating Expenses:
  - Team: [Role] × [Salary] × [Start Month] (the biggest cost for most startups)
  - Marketing: Customer acquisition spend = Target New Customers × Target CAC
  - Tools/Software: CRM, analytics, dev tools (itemize >$100/mo)
  - Office/Remote: Rent, co-working, or remote stipends
  - Legal/Accounting: Formation, IP, compliance, bookkeeping

Hiring Plan Format (embed in Assumptions tab):
  | Role | Monthly Cost | Start Month | Notes |
  | CEO (founder) | $8,000 | M1 | Below market, equity-heavy |
  | CTO (founder) | $8,000 | M1 | Below market, equity-heavy |
  | Engineer #1 | $12,000 | M3 | Full stack |
  | Designer | $10,000 | M4 | Product design |
  | Sales rep #1 | $8,000 + commission | M6 | Triggers revenue acceleration |
```

**Verify**: Total annual cost matches the raise amount plus existing cash. The model should show 18-24 months of runway post-raise.
**If failed**: If runway is under 18 months, either reduce costs or increase raise amount. Investors want 18-24 month runway from each round.

### Step 4: Calculate Unit Economics

**Duration**: 45 minutes
**Tool**: Spreadsheet (Tab 6)

Unit economics are the most scrutinized part of any financial model in 2026. [src4] [src7]

```
Core Unit Economics:
─────────────────────────────────────────────────
CAC (Customer Acquisition Cost):
  CAC = Total Sales & Marketing Spend ÷ New Customers Acquired
  Good seed target: CAC < 1/3 of first-year contract value
  Good Series A: CAC payback < 12 months

LTV (Lifetime Value):
  LTV = ARPU × Gross Margin % × (1 ÷ Monthly Churn Rate)
  Example: $99/mo × 80% margin × (1 ÷ 0.05) = $1,584 LTV

LTV:CAC Ratio:
  Target: > 3:1 (minimum), > 5:1 (good), > 7:1 (excellent)
  < 3:1 = unit economics don't work at scale

Payback Period:
  Payback = CAC ÷ (Monthly ARPU × Gross Margin %)
  Target: < 12 months (seed), < 8 months (Series A)

Gross Margin:
  Gross Margin = (Revenue - COGS) ÷ Revenue
  SaaS target: 70-85%
  Marketplace: 40-70%
  E-commerce: 30-50%

Burn Multiple:
  Burn Multiple = Net Burn ÷ Net New ARR
  < 1.5 = excellent efficiency
  1.5-2.5 = good
  > 2.5 = inefficient growth
```

**Verify**: LTV:CAC ratio is > 3:1. Payback period is < 12 months. Gross margin matches industry benchmarks.
**If failed**: If unit economics are weak, identify which lever to fix (reduce CAC via better targeting, increase ARPU via pricing, reduce churn via product improvement) and model the improvement.

### Step 5: Build Scenario Analysis

**Duration**: 30 minutes
**Tool**: Spreadsheet (Tab 7)

Investors expect three scenarios. Build them as toggles, not separate models. [src2]

```
Scenario Definitions:
─────────────────────────────────────────────────
Base Case (60% probability):
  - Current growth trajectory continues
  - Assumptions match recent 3-month trends
  - Hiring plan executes on schedule
  - No major market changes

Upside Case (20% probability):
  - Growth accelerates 30-50% above base
  - Key channel unlock (viral, partnership, enterprise deal)
  - Hiring slightly ahead of plan
  - Product-market fit strengthens

Downside Case (20% probability):
  - Growth 30-50% below base
  - One channel underperforms or fails
  - Hiring delayed by 2-3 months
  - Churn increases 30%

Implementation:
  Cell A1 on Scenarios tab: dropdown selector [Base / Upside / Downside]
  Assumptions tab reads this cell and applies multipliers
  All downstream tabs auto-update via formulas
```

**Verify**: Switching between scenarios changes revenue, costs, and runway figures across all tabs.
**If failed**: Your model has hardcoded numbers bypassing the scenario toggle. Fix formula references.

### Step 6: Create Pitch-Ready Summary Charts

**Duration**: 30 minutes
**Tool**: Spreadsheet + presentation software

Extract 2-3 charts from the model for the pitch deck. [src1]

```
Required Charts for Pitch Deck:
─────────────────────────────────────────────────
Chart 1: Revenue Trajectory
  - Line chart showing monthly revenue over 18-24 months
  - Include base case line + shaded area for upside/downside
  - Y-axis: Monthly revenue ($)
  - Mark "Current" with a vertical line

Chart 2: Unit Economics Summary
  - Bar chart or dashboard showing CAC, LTV, LTV:CAC, Payback Period
  - Compare to industry benchmarks (use different color)

Chart 3: Use of Funds (for Ask slide)
  - Pie or horizontal bar: % allocation across categories
  - Categories: Product (X%), Team (Y%), Marketing (Z%), Operations (W%)
  - Dollar amounts + percentages on each segment

Design Rules:
  - Clean, minimal — no 3D effects, no excessive grid lines
  - Label axes clearly with units ($, months, %)
  - Use brand colors or a neutral palette (max 3 colors)
  - Include the assumptions footnote: "Based on [base case] assumptions as of [date]"
```

**Verify**: Charts are readable at slide size. Numbers match the model exactly.
**If failed**: Chart data range is wrong. Re-link to the correct cells on the P&L or Unit Economics tab.

## Output Schema

```json
{
  "output_type": "financial_model",
  "format": "Google Sheets or Excel workbook",
  "columns": [
    {"name": "tab_name", "type": "string", "description": "Worksheet name in the model", "required": true},
    {"name": "time_horizon", "type": "string", "description": "Monthly/quarterly/annual granularity", "required": true},
    {"name": "scenario_support", "type": "boolean", "description": "Whether tab supports scenario toggles", "required": true},
    {"name": "key_outputs", "type": "string", "description": "Primary metrics computed on this tab", "required": true}
  ],
  "expected_row_count": "7-8 tabs",
  "sort_order": "tab order (assumptions first, charts last)",
  "deduplication_key": "tab_name"
}
```

## Quality Benchmarks

| Quality Metric | Minimum Acceptable | Good | Excellent |
|---------------|-------------------|------|-----------|
| Revenue model methodology | Bottom-up with stated assumptions | Bottom-up + historical validation | Bottom-up + cohort-level detail |
| Scenario analysis | Single base case | Base + downside | Base + upside + downside with toggle |
| Unit economics completeness | CAC and LTV stated | CAC, LTV, payback, gross margin | Full unit economics + burn multiple |
| Assumption documentation | Key assumptions listed | All assumptions on dedicated tab | Assumptions with sources and sensitivity ranges |
| Model traceback | Most formulas reference assumptions | All formulas reference assumptions | Zero hardcoded values outside assumptions tab |

**If below minimum**: The most common fix is adding explicit assumptions. Every number in the model must trace back to a stated, defensible input on the assumptions tab.

## Error Handling

| Error | Likely Cause | Recovery Action |
|-------|-------------|----------------|
| Revenue projections seem unrealistic | Assumptions not grounded in data | Benchmark against comparable companies; use industry conversion rates |
| Runway shows < 18 months | Costs too high or raise too low | Reduce non-essential costs; delay hires; increase raise amount |
| Unit economics show LTV:CAC < 3:1 | CAC too high or LTV too low | Model pricing increase, churn reduction, or more efficient acquisition |
| Investor questions "magic number" in formula | Hardcoded value not on assumptions tab | Move all inputs to Assumptions tab; eliminate magic numbers |
| Scenarios produce identical results | Toggle not wired correctly | Check formula references to scenario selector cell |
| Charts don't match model | Chart data range incorrect | Re-link chart to correct cells; verify with spot-check |

## Cost Breakdown

| Component | Free Tier | Paid Tier | At Scale |
|-----------|-----------|-----------|----------|
| Spreadsheet tool | Google Sheets: $0 | Excel (M365): $9.99/mo | Causal: $50/mo |
| Benchmark data | Public benchmarks: $0 | SaaS benchmarks (KeyBanc): $0 (report) | PitchBook: $450+/mo |
| Chart design | Sheets built-in: $0 | Canva charts: $12.99/mo | Custom design: $200-500 |
| Financial review | Peer review: $0 | Fractional CFO: $500-2,000 | Full CFO consultant: $5,000+ |
| **Total** | **$0** | **$50-500** | **$5,500+** |

## Anti-Patterns

### Wrong: Top-down revenue projections based on market share
"If we capture 1% of the $50B market, we'll do $500M in revenue" is the most discredited approach in startup fundraising. It demonstrates no understanding of how customers are actually acquired. [src1] [src6]

### Correct: Bottom-up from unit economics
Revenue = (New Customers per month x ARPU) + (Existing Customers x Retention Rate x ARPU). Every number traces to an acquisition channel, conversion rate, and pricing tier.

### Wrong: Single-scenario "hockey stick" projection
A model that only shows explosive growth signals that the founder has not considered what happens if growth is slower than planned. Investors immediately ask about the downside case. [src2]

### Correct: Three scenarios with explicit probability weights
Base case (60%), upside (20%), downside (20%). The downside case shows you understand risks and have a plan for extending runway if growth is slower.

### Wrong: Showing unit economics that don't work but promising they will improve
A CAC of $500 with LTV of $400 does not become viable by adding "scale benefits" to a projection. Investors will ask: what specific action makes CAC decrease? What evidence do you have? [src4]

### Correct: Show the path from current to target unit economics
If current LTV:CAC is 2:1, show the specific levers (pricing increase of X%, churn reduction from Y% to Z%, marketing efficiency from A to B) and the timeline for each improvement.

## When This Matters

Use this recipe when building the financial section of a pitch deck or preparing for investor meetings where financial projections will be scrutinized. Requires the business model to be defined — this recipe handles modeling and presentation, not business model design. For SaaS-specific benchmarks to validate assumptions, reference SaaS unit economics cards.

## Related Units

- [Pitch Deck Structure by Stage](/business/fundraising/pitch-deck-structure-by-stage/2026) — where financial slides fit in the deck
- [Pitch Deck Slide-by-Slide Guide](/business/fundraising/pitch-deck-slide-by-slide-guide/2026) — how to present financial charts on slides
- [Investor Research & Targeting](/business/fundraising/investor-research-targeting/2026) — tailor financial depth to investor expectations
- [Due Diligence Preparation Checklist](/business/fundraising/due-diligence-preparation-checklist/2026) — financial model as due diligence artifact