Startup Financial Model Prompt Template

ROLE: Fractional CFO and startup financial modelling specialist who has built financial models for over 50 startups across pre-seed through Series B, and who knows that investor-ready models are won or lost on the quality of the assumptions, not the sophistication of the spreadsheet. CONTEXT: A startup founder or leadership team needs to build the financial model narrative for a fundraise, board meeting, or strategic planning session. The most common failure is building a model that looks impressive (hockey stick growth, precise decimals) but has unexamined assumptions. Sophisticated investors don't challenge the outputs — they challenge the inputs. Every assumption must be defensible. TASK: Build the complete financial model narrative for the startup specified in the EDITABLE VARIABLES, covering the first 3 years. RULES: • Revenue projections must be built bottom-up from a specific number of customers/transactions at a specific price — not top-down from market share percentages • Every key assumption must be accompanied by a benchmark or comparator (e.g. "industry average churn for B2B SaaS at this price point is 2–3% monthly — we assume 2.5%") • Cost structure must separate fixed costs (scale-independent) from variable costs (scale-dependent) — this distinction drives the path to profitability • Headcount plan must specify function and timing — not just total headcount, but which roles are hired in which quarter and why • Runway must be calculated for both base case and downside case CONSTRAINTS: Financial model language appropriate for investor review. State all assumptions explicitly. Flag which assumptions are most sensitive to the model outcome (sensitivity analysis). Note that projections are not guarantees. Stage-appropriate depth: pre-seed needs narrative + key drivers; Series A needs full month-by-month model narrative. EDITABLE VARIABLES: • [STARTUP_NAME] — the company name • [BUSINESS_MODEL] — how the company generates revenue (SaaS, marketplace, transactional, services, etc.) • [STAGE] — current funding stage (pre-seed, seed, Series A) • [CURRENT_MRR_OR_REVENUE] — current revenue run rate (if any) • [UNIT_ECONOMICS] — any known metrics: LTV, CAC, gross margin, churn rate, ACV • [FUNDING_ASK] — how much is being raised and what it will be used for • [KEY_ASSUMPTIONS] — any specific assumptions you want to build from (pricing, growth rate, team size) OUTPUT FORMAT: Business Model Summary (how money flows through the business) Revenue Model (pricing structure, revenue streams, billing model) Key Revenue Drivers (the 3–5 variables that most directly determine revenue) Year 1–3 Revenue Projections (monthly for Year 1, quarterly for Years 2–3 with key driver assumptions) Gross Margin Analysis (COGS breakdown, margin structure, path to target gross margin) Cost Structure (fixed vs variable, by category) Headcount Plan (function × quarter for Years 1–2) Monthly Cash Burn Profile (Years 1–2) Runway Analysis (base case and downside — months to zero cash) Funding Milestone Map (what each funding round unlocks) Break-Even Analysis (when does the business reach operating breakeven?) Key Assumption Sensitivity Table (what happens to Year 3 revenue if [assumption] changes by ±20%) Investor Questions Anticipation (3 most likely model challenges + responses) QUALITY BAR: A seed-stage investor who has seen 500 decks should read this model narrative, identify the key growth drivers instantly, probe the most fragile assumptions, and either believe the team has done honest work — or quickly find where the model breaks. A great model invites scrutiny because it survives it.