When I first started building financial models for the startups I supported, I quickly realized that investors don't just want numbers — they want a clear, credible story backed by assumptions they can trust. Google Sheets is my go-to tool because it's accessible, collaborative, and powerful enough for early-stage needs. In this article I’ll walk you through how I build investor-ready financial models in Google Sheets, step by step, and share practical templates, sanity checks, and presentation tips that actually get meetings across the finish line.
Why a solid model matters
A great pitch deck can open doors, but a clean and transparent financial model builds trust. Investors use models to test your thesis: will unit economics scale, how capital efficient is growth, when will you need the next raise, and where are the biggest risks? If your model is sloppy, contradictory, or opaque, investors will assume your thinking is sloppy, too. I always aim for models that are:
- Transparent: every number traces back to an assumption.
- Flexible: easy to run scenarios (best/worst/base).
- Readable: clear structure and labelled sections for non-financial founders.
- Defensible: assumptions benchmarked against real data or comparable companies.
High-level structure I use
I divide the workbook into a handful of tabs so anyone can follow the logic quickly:
- Cover / Inputs: key variables (pricing, growth rates, churn, CAC) — this is the control center for scenarios.
- Revenue Model: unit-based or cohort-based revenue and bookings.
- Expenses & Hiring Plan: fixed vs variable, hiring timeline, salaries, and overheads.
- P&L / Cashflow / Balance: consolidated financial statements.
- Cap Table & Funding: current ownership, dilution, and planned raises.
- KPIs & Charts: CAC payback, LTV:CAC, runway, burn rate, and visuals for investors.
- Supporting data: market sizing, customer assumptions, and benchmarking sources.
Start with clean assumptions
The most common trap I see is building a model that embeds assumptions inside formulas across many cells. Instead, centralize assumptions in one tab labeled Inputs. For each assumption I include:
- A short description of the assumption and its source.
- Base, optimistic, and pessimistic values (so scenario toggles are simple).
- Units and whether the value is monthly or annual.
Example assumptions I always include: average transaction value, conversion rate, monthly active users growth, churn rate (monthly), CAC, gross margin, salary inflation, and sales ramp time.
Revenue modelling approaches
Choose the approach that best suits your business model. I use one of these three:
- Unit-based model: Best for e-commerce and marketplaces (units sold x price minus take rate).
- Cohort-based SaaS model: Track monthly cohorts, new MRR, churn, expansion, and churn recovery.
- Transactional / hybrid: Combine frequency of purchase with average order value and take rate.
Whichever you choose, link the outputs to the P&L dynamically. Avoid hard-coding totals — investors will change assumptions during a call and expect the model to update.
Expense and hiring plans that tell a story
Expenses must align with your growth plan. I split expenses into:
- COGS / Direct costs: costs tied to delivering your product (hosting, fulfillment, customer success time).
- Operating expenses: marketing, sales, R&D, G&A.
- People plan: roles, start month, fully loaded cost (salary + benefits + taxes), and assumed productivity ramp.
Make hiring headcount visible by month. Investors will ask when you’ll hire a first sales manager and how that impacts sales capacity. Also include a simple ramp for variable costs like commission percentages or marketing ramp-up.
Build the P&L, cashflow and runway
Link revenue and expense tabs to create a monthly P&L for 24–36 months. Use that to build a cashflow statement (starting cash, cash in, cash out, ending cash). Runway = ending cash / average monthly burn. I use a separate “funding events” section to model equity raises, debt, or convertible notes, showing pre- and post-money valuations and dilution impact.
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Revenue | $240,000 | $720,000 | $1,800,000 |
| COGS | $48,000 | $144,000 | $360,000 |
| Gross Profit | $192,000 | $576,000 | $1,440,000 |
| Operating Expenses | $360,000 | $420,000 | $520,000 |
| Net Income | -$168,000 | $156,000 | $920,000 |
Key metrics investors care about
Make these front-and-center as calculated KPIs:
- Gross margin — shows unit economics viability.
- Customer Acquisition Cost (CAC) and payback period — how quickly you recoup acquisition costs.
- Lifetime Value (LTV) and LTV:CAC ratio — ideally >3 for SaaS.
- Monthly Recurring Revenue (MRR) growth and churn rate.
- Burn rate and runway — how many months before you need capital at current plan.
- Gross margin breakeven and EBITDA breakeven month.
Scenario and sensitivity analysis
Investors love to stress-test assumptions. I build a simple scenario selector (drop-down or toggle) that switches inputs between base, upside, and downside. I also include sensitivity tables that show how valuation or runway changes with +/- 10-20% changes in CAC, churn, or growth. This demonstrates you understand what matters most to outcome and can prioritize mitigations.
Design and presentation tips in Google Sheets
A tidy layout increases credibility. I follow these best practices:
- Color-code: Inputs in green, calculated cells in blue, and hard-coded outputs in grey.
- Freeze header rows and name key ranges (Data > Named ranges) so formulas are easier to follow.
- Use comments and a README tab that explains assumptions and links to source docs (e.g., market research, CRM exports).
- Include charts — a monthly MRR chart, burn chart, and a cohort retention heatmap are especially persuasive.
- Set permissions sensibly. Share view-only with investors but be ready to give edit access during deep diligence.
Validation and readiness checklist
Before sending your model, I go through this checklist:
- All assumptions documented and sourced where possible.
- No circular references; iterative calculations removed or explained.
- Monthly P&L for at least 24 months and annualized projections to year 5.
- Scenario toggle works and KPIs update accordingly.
- Cap table accuracy: show post-money ownership for planned raises.
- Readable README tab and a one-page summary export (PDF) for non-financial readers.
Collaborating with advisors and investors
Google Sheets shines in collaboration. When I invite advisors or potential investors, I give them a guided path: first the one-page summary, then the Inputs tab, and finally the full model for deeper review. During investor calls I keep the model open and walk through the assumptions live — this is far more persuasive than static slides. If you’re using tools like Carta for cap tables or QuickBooks for accounting, link exported data to validate historicals.
Finally, pace your optimism with humility. Investors expect growth, but they also expect founders to know what could go wrong and how they’d fix it. A model that balances ambition with defensible assumptions will open more doors than one full of unchecked, optimistic projections.