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. [src1]

Prerequisites

• Business model definition — pricing structure, revenue streams, cost categories
• Current metrics (if available) — MRR, users, CAC, churn, gross margin
• Hiring plan — roles, start dates, compensation over 18-24 months
• Market data — comparable company benchmarks for margins and growth
• Spreadsheet tool — Google Sheets or Excel

Constraints

• All revenue must be bottom-up (customers × ARPU × retention). [src1] [src6]
• Pre-seed: 12-18 months. Seed: 18-24 months monthly + Y2-Y3 quarterly. Series A: 3 years (monthly Y1, quarterly Y2, annual Y3). [src5]
• Every assumption stated and defensible. Investors challenge assumptions, not numbers. [src2]
• Three scenarios required: base, upside, downside. [src2]
• Unit economics (CAC, LTV, payback, gross margin) mandatory for Series A, expected for seed in 2026. [src4]

Tool Selection Decision

Which path?
├── Budget = $0 AND spreadsheet-comfortable
│   └── PATH A: Google Sheets — free, collaborative
├── Budget = $0 AND Excel preferred
│   └── PATH B: Excel — powerful formulas, offline
├── Budget = $50/mo AND wants automation
│   └── PATH C: Causal — formula-free, visual scenarios
└── Budget > $100/mo
    └── PATH D: Mosaic/Runway — accounting integration

Execution Flow

Step 1: Set Up Model Structure

Duration: 30 minutes · Tool: Spreadsheet

Create 7-8 tabs: Assumptions (yellow editable cells), Revenue (bottom-up), Costs (fixed + variable), P&L Summary, Cash Flow, Unit Economics, Scenarios, Charts. All formulas reference Assumptions tab. [src2] [src3]

Verify: Changing any assumption auto-updates all tabs. · If failed: Search for hardcoded numbers in formula tabs.

Step 2: Build Bottom-Up Revenue Projections

Duration: 1-2 hours · Tool: Spreadsheet

SaaS: Monthly Revenue = (Starting + New - Churned) × ARPU. State assumptions: lead gen rate, conversion %, churn %, ARPU, expansion rate. Marketplace: GMV × take rate. E-commerce: visitors × conversion × AOV. [src1] [src6]

Verify: Model matches actual revenue within 10%. · If failed: Adjust conversion or churn to match historical data.

Step 3: Model Costs with Hiring Plan

Duration: 1-2 hours · Tool: Spreadsheet

COGS (hosting, payment processing, APIs, support) + OpEx (team salaries by role/month, marketing = target customers × target CAC, tools, office, legal). Embed hiring plan with role, monthly cost, start month. [src2]

Verify: Total cost = raise + existing cash for 18-24 months runway. · If failed: Reduce costs or increase raise.

Step 4: Calculate Unit Economics

Duration: 45 minutes · Tool: Spreadsheet

CAC = marketing spend ÷ new customers. LTV = ARPU × margin × (1 ÷ churn). LTV:CAC target > 3:1. Payback < 12 months. SaaS gross margin: 70-85%. Burn multiple: net burn ÷ net new ARR (< 1.5 = excellent). [src4] [src7]

Verify: LTV:CAC > 3:1, payback < 12 months. · If failed: Identify lever to fix (pricing, churn, CAC efficiency).

Step 5: Build Scenario Analysis

Duration: 30 minutes · Tool: Spreadsheet

Three scenarios with dropdown toggle: base (60%), upside (20%), downside (20%). Each adjusts growth rate, churn, and hiring timeline. [src2]

Verify: Switching scenarios changes all tabs. · If failed: Fix formula references to scenario selector.

Step 6: Create Pitch-Ready Charts

Duration: 30 minutes · Tool: Spreadsheet + presentation

Extract 3 charts: (1) revenue trajectory line chart with scenario band, (2) unit economics dashboard (CAC, LTV, ratio, payback), (3) use-of-funds allocation for ask slide. Clean design, labeled axes. [src1]

Verify: Charts readable at slide size, numbers match model. · If failed: Re-link chart data ranges.

Output Schema

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

Quality Benchmarks

If below minimum: Add explicit assumptions. Every number must trace to a stated, defensible input on the assumptions tab.

Error Handling

Cost Breakdown

Anti-Patterns

Wrong: Top-down revenue from market share assumption

"If we capture 1% of the $50B market" demonstrates no understanding of customer acquisition mechanics. [src1] [src6]

Correct: Bottom-up from unit economics

Revenue = new customers × ARPU + existing × retention × ARPU. Every number traces to an acquisition channel and conversion rate.

Wrong: Single-scenario hockey stick projection

Only showing explosive growth signals founders have not considered downside risks. [src2]

Correct: Three scenarios with probability weights

Base (60%), upside (20%), downside (20%). Downside shows risk awareness and runway planning.

Wrong: Showing broken unit economics with "scale will fix it"

If CAC exceeds LTV, scaling amplifies losses. Investors require specific improvement levers. [src4]

Correct: Show path from current to target unit economics

Name specific levers (pricing, churn reduction, marketing efficiency) with timeline and evidence.

When This Matters

Use when building the financial section of a pitch deck or preparing for investor meetings. Requires defined business model — handles modeling and presentation, not business model design.