Fundraising Financial Model: How to Build It in Google Sheets with AI

An investor spends 15 minutes parsing a financial model. If the logic doesn’t come through in that time, the deck goes in the trash. The usual problems: formulas hardcoded into cells, assumptions scattered across tabs, no scenario analysis. Not bad numbers — bad structure.

A fundraising model is different from an internal one. It answers three questions: how much money you need, what it’ll be used for, and when the business reaches breakeven. Google Sheets with AI gets you there in a day instead of two weeks. Below is the full structure, prompts for generating formulas, and formatting that holds up under due diligence.

The Structure of an Investor-Ready Financial Model

A fundraising model has six tabs. Each one does a specific job.

1. Assumptions. All input parameters in one place: pricing, growth rates, churn, headcount plan, unit costs. An investor opens this tab first. They change one number and watch it cascade across the other tabs. If assumptions are buried in formulas across different sheets, the model can’t be verified.

2. Revenue Model. A 36-month revenue forecast. For SaaS: customers × ARPU × retention. For a marketplace: GMV × take rate. For transactional businesses: transactions × average order value × margin. Formulas pull from Assumptions only — nothing hardcoded.

3. P&L (Profit & Loss). Revenue minus expenses. Expenses are split into COGS (cost of goods sold), OPEX (operating expenses), and capex. OPEX is broken down by category: People, Marketing, Infrastructure, G&A. Shows gross margin, EBITDA, and net income by month.

4. Cash Flow. Actual cash in and out, not accounting profit. Accounts for payment delays (receivables/payables), capital expenditures, and investment proceeds. Shows runway — how many months the company can run on its current balance.

5. Unit Economics. CAC, LTV, Payback Period, LTV/CAC ratio. Calculated from Revenue Model and P&L data. The investor checks whether the economics work at the level of a single customer. For more on calculating unit economics, see the dedicated guide.

6. Scenarios. Base, Optimistic, Conservative. Each scenario swaps out the Assumptions tab values. The tab shows key metrics — runway, breakeven, required funding — for all three, side by side.

The Assumptions Tab: The Model’s Foundation

Assumptions drives everything else. Get this tab right and the rest of the model nearly builds itself.

Tab structure:

Section             | Example parameters
--------------------|--------------------------------------------
Pricing             | Monthly price, Annual discount %, Enterprise tier
Growth              | MoM user growth %, Paid conversion rate
Retention           | Monthly churn %, Net revenue retention
Costs               | Server cost per user, Support cost per ticket
Team                | Hires by month, Average salary by role
Marketing           | CAC by channel, Budget allocation %
Timeline            | Launch date, Fundraise close date

Prompt for generating the Assumptions tab in Google Sheets:

Create an Assumptions tab for a SaaS product with the following parameters:

Product: [description]
Pricing model: [freemium / flat / usage-based / tiered]
Current metrics: [MRR, number of customers, churn rate]
Target round: [Pre-Seed / Seed / Series A]
Forecast horizon: 36 months

Requirements:
- All parameters in named cells (Named Ranges)
- Grouped by section: Pricing, Growth, Retention, Costs, Team, Marketing
- Each parameter with a justification comment
- Color coding: blue font for editable cells, black for calculated cells
- Validation: dropdown lists for categorical parameters

The key rule: no formula in the model contains a bare number. Every constant references Assumptions. An investor changes growth from 10% to 7% and sees the runway impact immediately.

Revenue Model: From Assumptions to Revenue Forecast

The Revenue Model turns assumptions into a monthly forecast. The structure depends on the business model, but the logic is always the same: drivers → calculation → output.

For SaaS with three pricing tiers:

Month 1    Month 2    Month 3    ...    Month 36
──────────────────────────────────────────────────
New users (Free)
  × Conversion to Basic
  × Conversion to Pro
  × Conversion to Enterprise
= Paying customers by tier
  × Price by tier
  - Churn
  + Expansion revenue
= MRR
  × 12 = ARR

Prompt for generating Revenue Model formulas:

Generate Google Sheets formulas for the Revenue Model.

The Assumptions tab contains:
- Cell B3: initial number of users (Free)
- Cell B4: MoM user growth (%)
- Cell B5: conversion Free → Basic (%)
- Cell B6: conversion Free → Pro (%)
- Cell B7: conversion Free → Enterprise (%)
- Cell B8: Basic price ($)
- Cell B9: Pro price ($)
- Cell B10: Enterprise price ($)
- Cell B11: monthly churn (%)
- Cell B12: expansion rate (% of MRR)

Generate formulas for 36 months in the following format:
- Row: metric name
- Columns B–AK: months 1–36
- Each formula references Assumptions via Named Ranges
- Month 1 formula differs from months 2–36 (month 1 uses initial values)

Output formulas for each row: the formula for cell B (month 1)
and the formula for cell C (month 2), which can be dragged to AK.

AI generates formulas that reference Named Ranges. This matters: =B3*(1+B4) tells you nothing. =initial_users*(1+mom_growth) you can actually read and check.

Named Ranges in Google Sheets

Google Sheets supports Named Ranges via Data → Named ranges. For a financial model, this isn’t optional. Prompt for bulk creation:

Create a list of Named Ranges for a Google Sheets financial model.
Format: Name | Tab!Cell | Description

Naming rules:
- snake_case
- Prefix by section: price_, growth_, cost_, team_
- Examples: price_basic, growth_mom, cost_server_per_user, team_engineers_m1

P&L: Expenses and the Path to Profitability

P&L shows when the business stops burning money. Investors look at three things: gross margin, burn rate, and the month you hit EBITDA-positive.

P&L structure:

Revenue (from Revenue Model)
- COGS
  - Hosting / Infrastructure
  - Payment processing fees
  - Customer support (direct)
= Gross Profit
  Gross Margin %

- OPEX
  - People (salaries + benefits + taxes)
  - Marketing & Sales
  - R&D (tools, licenses)
  - G&A (legal, accounting, office)
= EBITDA
  EBITDA Margin %

- D&A
- Interest
- Tax
= Net Income

Prompt for generating People costs (the most complex part of OPEX):

Generate Google Sheets formulas for People costs over 36 months.

Input data (Assumptions tab):
- Hiring table: role | start month | salary | headcount
  Engineering Lead | M1 | $12,000 | 1
  Backend Engineer | M1 | $8,000 | 2
  Frontend Engineer | M3 | $8,000 | 1
  Designer | M4 | $6,000 | 1
  Marketing Manager | M6 | $7,000 | 1
  Sales Rep | M9 | $6,000 | 2

- Benefits multiplier: 1.3 (30% on top of salary)
- Annual raise: 5%

Requirements:
- One row per role showing headcount by month
- Formula accounts for start month (zero before start)
- Annual raise applies every 12 months
- Summary row: Total People Cost = sum of all roles × benefits multiplier

COGS for SaaS

COGS in SaaS is infrastructure, payment processing, and direct support. Prompt:

Calculate COGS for a SaaS product with variable server load.

Formulas:
- Infrastructure = number of paying customers × cost_server_per_user
- Payment processing = MRR × 2.9% + (number of transactions × $0.30)
- Direct support = number of tickets/month × cost_per_ticket
- Number of tickets = number of customers × tickets_per_customer_month

All coefficients reference Named Ranges from Assumptions.
Gross Margin = (Revenue - COGS) / Revenue as a percentage.

Target gross margin for SaaS is 70–85%. Below 60%, expect questions about infrastructure costs.

Cash Flow: From Profit to Cash in the Bank

P&L shows profit. Cash flow shows money. The difference matters: a company can be profitable on paper and still go bankrupt from a cash flow gap.

Cash Flow Statement for a startup:

Operating Cash Flow
  Net Income (from P&L)
  + D&A (non-cash expense)
  - Increase in Accounts Receivable
  + Increase in Accounts Payable
  = Cash from Operations

Investing Cash Flow
  - Capital expenditures
  = Cash from Investing

Financing Cash Flow
  + Equity raised
  + Debt drawn
  - Debt repaid
  = Cash from Financing

Net Cash Flow = Operations + Investing + Financing
Ending Cash Balance = Beginning Balance + Net Cash Flow
Runway (months) = Ending Cash Balance / Average Monthly Burn

Prompt for Cash Flow accounting for a fundraising round:

Generate a Cash Flow tab in Google Sheets for a startup raising a round.

Parameters:
- Current balance: $50,000
- Target round: $500,000 (received in month 4)
- Payment terms: customers pay on average within 15 days
- Vendor payments: 30-day payment terms

Formulas should:
- Calculate Accounts Receivable as % of revenue with a delay
- Calculate Accounts Payable as % of OPEX with a delay
- Show Ending Cash Balance each month
- Show Runway = Cash Balance / Avg Monthly Burn (last 3 months)
- Highlight in red any months where Cash Balance < 2 × Monthly Burn

Format: formula for month 1 and formula for month 2 (drag-ready).

Runway is the primary metric at early stages. If the model shows 18+ months after the round, that’s a strong signal. Less than 12 months means the founder will be back for more money before the year is out.

Scenario Analysis: Base, Optimistic, Conservative

One scenario isn’t a model — it’s a wish. Investors want three because no forecast will be exactly right.

How scenarios work in Google Sheets:

                    Conservative    Base    Optimistic
MoM Growth              5%          10%        15%
Churn                   8%           5%         3%
Conversion Rate         2%           4%         7%
CAC                   $120          $80        $50
Avg Deal Size          $25          $29        $35

Prompt for scenario analysis:

Create a Scenarios tab in Google Sheets.

Structure:
1. Parameter table: three columns (Conservative, Base, Optimistic)
   with rows for each key assumption

2. Scenario switcher: one cell (dropdown: Conservative/Base/Optimistic)

3. Routing formula that populates Assumptions values
   based on the selected scenario.
   Use VLOOKUP or INDEX/MATCH.

4. Summary table: for each scenario show:
   - Month of breakeven
   - Runway after round
   - ARR at 12/24/36 months
   - Required funding
   - LTV/CAC ratio

Routing formula for an Assumptions cell:
=INDEX(scenarios_table, MATCH("growth_mom", scenario_params, 0),
       MATCH(selected_scenario, scenario_headers, 0))

An alternative: three separate P&L sheets, one per scenario. Downside: triple the formula maintenance. Upside: the investor compares them side by side without touching a dropdown.

AI Workflow: Step-by-Step Model Assembly

Building a financial model with AI takes five stages. Each ends with a review.

Stage 1: Gather Input Data (30 minutes)

Prompt for structuring input data:

I'm building a financial model for raising a [Seed] round.

My product: [2–3 sentence description]
Business model: [SaaS / marketplace / transactional]
Current metrics:
- MRR: $[X]
- Customers: [Y]
- MoM growth: [Z]%
- Churn: [W]%
- CAC: $[V]

Help me define the complete list of assumptions for a
36-month financial model. For each parameter, provide:
1. Current value
2. Justification for the projected value
3. Benchmark source (industry, stage, geography)

Stage 2: Generate Structure (1 hour)

Create all tabs with headings and Named Ranges. AI generates the structure; you check for completeness.

Create the structure of a Google Sheets financial model with 6 tabs:
Assumptions, Revenue, P&L, Cash Flow, Unit Economics, Scenarios.

For each tab, output:
- List of rows (metrics) with row numbers
- Column headers
- List of Named Ranges mapped to cells
- Formatting: which rows are bold, which are indented,
  where horizontal separators go

Stage 3: Generate Formulas (2–3 hours)

The heaviest stage. AI generates formulas tab by tab, in order: Assumptions → Revenue → P&L → Cash Flow → Unit Economics → Scenarios.

Prompt for verifying formulas:

Review the formulas on the Revenue Model tab.

Verification requirements:
1. All Assumptions references use Named Ranges (not A1 notation)
2. No circular references
3. Month 1 formulas correctly handle initial conditions
4. Month 2–36 formulas drag correctly
5. Summary rows sum the correct ranges
6. MoM MRR growth is within realistic values (5–20% MoM for Seed)

Show a list of issues found, with cell references.

Stage 4: Formatting (1 hour)

Formulas aren’t enough. Formatting determines whether an investor actually works through the model or closes the tab.

Formatting standards:

Color coding:
- Blue font: editable assumptions (inputs)
- Black font: calculated values (formulas)
- Gray background: section headers
- Yellow background: key metrics (MRR, Runway, Breakeven)
- Red background: months with negative cash balance

Number formats:
- Currency: $#,##0 (no cents in forecasts)
- Percentages: 0.0%
- Counts: #,##0
- Dates: MMM-YY (Jan-26, Feb-26...)

Structure:
- Frozen first column and first row
- Row grouping (collapse detail, show totals)
- Column widths: first column 200px (metrics), remaining 100px (months)

Prompt for Apps Script formatting:

Write a Google Apps Script that formats a financial model:

1. Applies color coding:
   - Cells with "Assumptions!" in the formula → blue font
   - Cells with formulas → black font
   - Header rows (list: Revenue, COGS, OPEX...) → gray background, bold

2. Number formats:
   - Rows with "$" in the name → $#,##0 format
   - Rows with "%" in the name → 0.0% format
   - Rows with "Margin" → 0.0% format

3. Conditional formatting:
   - Cash Balance < 0 → red background
   - Runway < 6 → orange background
   - Gross Margin < 60% → yellow background

4. Freeze row 1 and column A on each tab
5. Set column widths

Stage 5: Stress Test and Validation (1 hour)

Prompt for stress-testing the model:

Stress test the financial model. Check the following scenarios:

1. Churn doubles after 6 months. When does the money run out?
2. CAC increases by 50%. How does Payback Period change?
3. Average deal size drops by 20%. When is breakeven?
4. Hiring is delayed by 3 months. Effect on runway?
5. Round closes 2 months late. Is there enough money?

For each scenario show: the changed parameter,
new runway, new breakeven month, change in ARR at 36 months.

Common Mistakes in Startup Financial Models

Seven mistakes that show up again and again.

Hockey stick without justification. 5% MoM for the first six months, then a sudden jump to 25%. Every inflection point needs an explanation: a new channel, a new market, a viral loop. Unexplained jumps are a red flag.

Fixed expenses against growing revenue. Server costs don’t grow with user count. Support doesn’t scale linearly. In reality, COGS grows proportionally and OPEX grows in steps. Formulas need to reflect this.

No seasonality. B2B sales dip in August and December. B2C tends to reverse. A flat forecast with no seasonal adjustments looks like the founder has never sold anything.

Unrealistic churn. 1% monthly churn for a product without product-market fit. Benchmarks: Pre-Seed SaaS — 5–10% monthly, Series A — 3–5%, Series B+ — 1–3%.

CAC that doesn’t include all costs. The simple formula: marketing spend / new customers. But a complete CAC includes salaries for marketing and sales, tools, and content. Underestimating by 2–3× is the standard first-time mistake.

No working capital. The model books revenue in the delivery month. Cash arrives 30–60 days later. Without accounting for receivables and payables, the cash flow statement is wrong.

Hardcoded values instead of formulas. The literal number 0.05 instead of a reference to churn_rate. An investor can’t test assumptions. The model becomes a static table rather than a tool.

Investor-Ready Checklist

Go through this before sending the model to an investor.

Structure:

• 6 tabs: Assumptions, Revenue, P&L, Cash Flow, Unit Economics, Scenarios
• All assumptions on a single tab
• Named Ranges for all key parameters
• No hardcoded values in formulas

Accuracy:

• Balance sheet balances (if included)
• Cash Flow = P&L + non-cash adjustments + working capital changes
• Revenue on the P&L tab matches the Revenue Model
• Unit Economics calculated from model data, not manually

Formatting:

• Color coding for inputs vs. formulas
• Number formats are consistent
• Section headers are clearly marked
• Rows are grouped (detail can be hidden)
• Frozen panes on each tab

Realism:

• Growth rates are justified (source/benchmark in comments)
• Gross margin is within industry range
• CAC includes all components
• Runway after round is 18+ months
• Three scenarios with a meaningful delta

Google Sheets vs. Excel: Which to Choose for Fundraising

Google Sheets wins on three counts.

Shared access. The investor gets a link, opens it in a browser, and changes assumptions. No downloading, no hunting for a compatible Excel version, no file sent back and forth. When 3–5 people are reviewing the model at the same time during due diligence, this matters.

Version history. Every change is saved automatically. You can roll back to any version. The investor sees when the model was last updated. A file touched yesterday carries more credibility than one dated three months ago.

Apps Script. Automate formatting, validation, and data updates. AI generates scripts that run on a schedule or trigger on cell changes.

The weak point of Google Sheets is performance on large models. For 36 months across 6 tabs, it’s fine. For 60-month models with dozens of product lines, consider Excel.

Advanced Prompts for AI Formula Generation

Cohort-based revenue

Generate Google Sheets formulas for a cohort-based revenue model.

Each month is a new customer cohort.
Cohort from month N:
- Size = new_customers in month N
- Revenue in month N+k = cohort_size × (1 - churn)^k × ARPU
- Total revenue = sum of revenue across all cohorts

Format: triangular matrix.
Rows = cohorts (acquisition months).
Columns = cohort age (0, 1, 2...).
Last row = column sum = Total MRR.

Use Named Ranges: new_customers_m1...m36, monthly_churn, arpu.

Sensitivity table

Create a sensitivity table (Data Table) in Google Sheets.

Two variables:
- Rows: Monthly Churn (1%, 2%, 3%, 4%, 5%, 7%, 10%)
- Columns: MoM Growth (3%, 5%, 7%, 10%, 15%, 20%)

Value at each intersection: Runway in months for the given parameters.

Formula for each intersection:
substitute churn and growth into the model, calculate the month
when Cash Balance goes negative.

Conditional formatting: gradient from green (24+ months)
through yellow (12–18) to red (< 12).

Headcount planning

Build a headcount planning model for a startup.

Input data:
- Role table: name | department | salary | hire month
- Benefits: 30% of salary
- Annual raise: 5%
- Hiring cost: 15% of annual salary (one-time, in month of hire)

Output data:
- Headcount by month (total and by department)
- Payroll by month (total and by department)
- Hiring costs by month
- Cost per employee (fully loaded)

Formulas should use IF to check the hire month:
=IF(month >= hire_month, salary × (1 + annual_raise)^FLOOR((month - hire_month)/12, 1), 0)

Conclusion

A fundraising model is a communication tool, not an accurate forecast. The investor doesn’t expect the numbers to come true. They’re checking whether the founder understands the business economics, can think in scenarios, and has left enough margin for error.

AI handles the technical work — generating formulas, formatting, checking consistency. The founder focuses on substance: justifying assumptions, picking benchmarks, explaining the growth logic. That’s exactly what gets probed in a face-to-face meeting.

The model feeds directly into the cap table and becomes the financial backbone of due diligence. One day of work with AI instead of two weeks with a spreadsheet consultant.

Need help building a fundraising-ready financial model? I help startups build AI products and automate processes — belov.works.