How to Prepare Financial Projections for Investors
How to Prepare Financial Projections for Investors
"Your projections look like a hockey stick. Walk me through how you get from here to there."
Every founder has heard some version of this question. And most fumble the answer.
Financial projections are one of the most misunderstood parts of fundraising. Founders either wing it with unrealistic numbers or overcomplicate things with 50-tab spreadsheets that obscure rather than clarify.
Here's the truth: Investors don't expect your projections to be right. They expect them to reveal how you think. Your model is a window into your strategic assumptions about growth, unit economics, and capital efficiency.
This guide shows you how to build financial projections that investors actually respect—and use to make investment decisions.
What Investors Actually Care About in Your Projections
Before building your model, understand what investors look for:
1. Reasonableness, Not Precision
A model showing $50M ARR in Year 3 from a company at $100K today will get dismissed immediately. Investors have seen thousands of projections and can spot fantasy math instantly.
2. Clear Assumptions
Every output should trace back to a defendable input. When an investor asks "Why do you assume 8% monthly churn improvement?" you need a real answer.
3. Unit Economics That Work
Your model should show a path to positive unit economics. If your LTV:CAC never gets above 2:1, there's a fundamental problem.
4. Scenario Planning
Sophisticated investors want to see how the business performs under different conditions—not just the optimistic case.
5. Capital Efficiency
How much revenue do you generate per dollar raised? Your model should demonstrate efficient use of capital.
The 3-Year Financial Model Framework
For most seed and Series A raises, you need a 3-year projection with monthly granularity for Year 1 and quarterly for Years 2-3. Here's the framework:
Revenue Model
Start with your revenue drivers, not revenue itself. Work bottom-up:
For SaaS/Subscription Businesses:
Starting ARR/MRR: Your current baseline
New MRR: New customers × Average Contract Value
Expansion MRR: Upsells and price increases from existing customers
Churned MRR: Lost revenue from cancellations
Net New MRR: New + Expansion - Churned
Ending MRR: Starting + Net New
For Transactional/Marketplace Businesses:
Active Users/Merchants: Your supply or demand side
Transactions per User: Frequency of activity
Average Transaction Value: Size of each transaction
GMV: Total transaction volume
Take Rate: Your commission or fee percentage
Net Revenue: GMV × Take Rate
Customer Acquisition Model
Model how you'll acquire customers:
Marketing Spend by Channel: Paid ads, content, events, etc.
Conversion Rates: Visitor → Lead → Trial → Paid
CAC by Channel: Fully loaded acquisition cost
Payback Period: Months to recover CAC
Example breakdown:
Channel | Monthly Spend | Leads Generated | Conversion Rate | Customers | CAC |
|---|---|---|---|---|---|
Paid Search | $20,000 | 400 | 5% | 20 | $1,000 |
Content/SEO | $5,000 | 200 | 3% | 6 | $833 |
Referrals | $2,000 | 50 | 15% | 8 | $250 |
Cost Structure
Break costs into categories investors understand:
Cost of Goods Sold (COGS):
Hosting/infrastructure
Payment processing fees
Customer support (if volume-based)
Third-party software costs
Operating Expenses:
R&D/Engineering: Product development team costs
Sales & Marketing: Go-to-market team and campaigns
General & Administrative: Finance, HR, legal, office
Headcount Plan
Your biggest cost driver. Model by function:
Department | Current | Year 1 End | Year 2 End | Year 3 End |
|---|---|---|---|---|
Engineering | 4 | 8 | 15 | 25 |
Product | 1 | 2 | 4 | 6 |
Sales | 2 | 5 | 12 | 20 |
Marketing | 1 | 3 | 5 | 8 |
Customer Success | 1 | 3 | 8 | 12 |
G&A | 1 | 2 | 4 | 6 |
Total | 10 | 23 | 48 | 77 |
Cash Flow Model
Don't just show income—show cash:
Monthly Burn: Net cash outflow
Runway: Months of cash remaining
Break-even Point: When monthly cash flow turns positive
Building Your Assumptions Sheet
The assumptions sheet is where sophisticated investors spend the most time. Include:
Growth Assumptions
MoM revenue growth rate (and the basis for it)
Customer acquisition rate
ACV trends (increasing, stable, decreasing)
Net Revenue Retention assumptions
Unit Economics Assumptions
CAC by channel with improvement rates
Gross margin evolution
Churn rate and improvement trajectory
ACV changes over time
Operational Assumptions
Revenue per employee targets
Hiring timeline and ramp periods
Sales productivity (quota attainment %)
Engineering velocity impact on product
Market Assumptions
TAM penetration rate
Competitive dynamics
Pricing pressure or expansion potential
The Three Scenarios You Need
Build three versions of your model:
Base Case
Your realistic expectation. This is what you actually think will happen with solid execution. Growth rates should be achievable, not aspirational.
Upside Case
Everything goes right: a key enterprise deal closes early, viral growth kicks in, churn drops faster than expected. Show what's possible, but keep it grounded.
Downside Case
What if customer acquisition costs increase 30%? What if churn is 2x higher than expected? Show how you'd adapt—slower hiring, focus on retention, etc.
Present the base case as your primary model, with scenarios available for discussion.
Financial Projection Template Checklist
Before sharing your model with investors, verify:
Structure
☐ Monthly detail for Year 1, quarterly for Years 2-3
☐ Separate tabs for Revenue, Costs, Headcount, Cash Flow
☐ Clear assumptions tab with all inputs consolidated
☐ Summary dashboard with key metrics
Revenue
☐ Revenue built bottom-up from customer/transaction drivers
☐ New vs. expansion vs. churned revenue separated
☐ Cohort analysis showing retention curves
☐ Clear path from current revenue to projected revenue
Costs
☐ Headcount plan by department
☐ Fully loaded employee costs (salary + benefits + taxes)
☐ Marketing spend broken down by channel
☐ Variable vs. fixed costs clearly separated
Metrics
☐ Monthly/Annual burn rate
☐ Runway calculation
☐ Gross margin %
☐ CAC, LTV, LTV:CAC ratio
☐ Revenue per employee
☐ Burn multiple (Net Burn / Net New ARR)
Quality
☐ All formulas work (no circular references)
☐ Numbers tie across all sheets
☐ No hardcoded numbers in formula cells
☐ Version control (date in filename)
Common Financial Projection Mistakes
Mistake #1: The Hockey Stick Without Logic
Revenue that suddenly inflects upward with no explanation. Growth should stem from identifiable drivers: new channels, product launches, or team additions.
Mistake #2: Gross Margin That Never Improves
SaaS gross margins typically expand as you scale. If your margin stays flat at 60%, explain why—or show the improvement trajectory.
Mistake #3: Infinite Sales Productivity
Each salesperson generating $1M+ in Year 1 of their tenure? Unlikely. Model realistic ramp times (usually 3-6 months to full productivity).
Mistake #4: Zero CAC Payback Sensitivity
What happens if CAC increases 25%? If your model breaks, you need to build in more resilience.
Mistake #5: Forgetting Cash Timing
Revenue recognized isn't cash collected. If you have annual contracts, show the cash impact of billing cycles.
How to Present Your Financial Model
In investor meetings, don't walk through every cell. Instead:
Start with the summary: Key metrics, growth trajectory, break-even point
Highlight critical assumptions: The 3-5 inputs that matter most
Show the path: How you get from today to the projection
Demonstrate scenario awareness: "If CAC increases 30%, here's how we adapt"
Keep a detailed model available for deep dives during diligence.
FAQ
How far out should my projections go?
For seed and Series A, 3 years is standard. Monthly detail for Year 1, quarterly for Years 2-3. Going beyond 3 years adds uncertainty without adding value—investors know anything past Year 2 is largely speculative.
What growth rate is believable?
It depends on your current scale, but for Series A SaaS companies, 2-3x YoY growth is typical. Anything claiming 10x+ needs exceptional justification. The "triple, triple, double, double, double" framework (3x, 3x, 2x, 2x, 2x growth over 5 years) is a common benchmark for high-growth startups.
Should I hire someone to build my financial model?
Having professional help ensures accuracy and credibility. A fractional CFO can build your model, stress-test assumptions, and prepare you for investor questions. For significant raises, this investment typically pays for itself in better terms and faster closes.
Tools and Resources
Popular tools for financial modeling:
Google Sheets/Excel: Standard, familiar to all investors
Causal: Visual modeling, good for scenarios
Mosaic: Connects to your accounting data
Pry: Built for startups, integrates with common tools
Whatever tool you use, ensure you can export to Excel/Sheets. Many investors will want to manipulate the model themselves.
Getting Professional Support
Building investor-ready financial projections requires both finance skills and fundraising experience. Consider:
Virtual CFO services to build bulletproof models and handle investor diligence
Fundraise preparation support to ensure your projections align with your overall fundraising narrative
Conclusion
Your financial projections tell investors how you think about your business. A thoughtful, well-structured model demonstrates strategic clarity and operational rigor—two qualities every investor looks for.
Build your model bottom-up from real drivers. Document your assumptions clearly. Create multiple scenarios. And remember: investors don't expect the numbers to be right. They expect them to be defensible.
Amit Patel is a startup advisor with 12 years of experience working with early-stage companies on fundraising and financial strategy. He has helped founders build financial models that have raised over $200M in venture capital.





