You’re meeting with a Series A investor next week. She asks, “If we invest $3 million, what metrics will you hit in 18 months?” You pull out your financial model—a spreadsheet with 47 tabs, circular references in six formulas, and assumptions buried in hidden columns. You click to the projections tab. Excel crashes.
This happens more often than founders admit. They spend 200 hours building elaborate financial models with every possible scenario modeled, but the models are so complex they can’t explain them in meetings. Or worse, they show up with back-of-napkin math that insults the investor’s intelligence.
The best financial models aren’t the most sophisticated—they’re the ones that clearly answer three questions: How much money do you need? What will you accomplish with it? When will you need to raise again? If your model answers these questions in under five minutes, you’ve built the right tool.
This guide shows you exactly how to build a financial model that closes funding rounds, not one that impresses Excel nerds.
Table of Contents
- Why Financial Models Matter for Fundraising
- The Core Components Every Model Needs
- Building Your Revenue Projections
- Modeling Your Cost Structure
- Headcount Planning: The Biggest Expense
- Cash Flow, Burn Rate, and Runway
- Scenario Modeling: Best Case, Base Case, Worst Case
- Common Financial Modeling Mistakes
- How to Present Your Model to Investors
- Frequently Asked Questions About Financial Models
Why Financial Models Matter for Fundraising
Investors don’t invest in spreadsheets—they invest in businesses. But your financial model is the tool that proves your business logic works mathematically.
When you tell an investor “we need $2 million to reach $2 million ARR,” they’re thinking: Does the math actually work? Can they hire enough salespeople to close that much revenue? Do they understand their unit economics well enough to know this is achievable?
Your financial model answers these questions. It shows that if you hire three sales reps in month 3, each ramping to $25K monthly quota by month 6, and you maintain 5% monthly churn, you’ll reach $2 million ARR in month 20 with $200K in the bank—giving you three months to close your Series A.
Without a model, you’re asking investors to trust your gut. With a model, you’re showing them the math.
What Investors Actually Look For
Investors evaluate your financial model on three dimensions.
First, credibility. Are your assumptions realistic? If you’re projecting 30% month-over-month growth for 18 straight months, that’s a 100x revenue increase—possible but extremely rare. Investors will push back hard on unrealistic growth assumptions.
Second, capital efficiency. How much revenue growth do you generate per dollar invested? If you need $5 million to reach $1 million ARR, that’s inefficient. If you need $2 million to reach $2 million ARR, that’s strong capital efficiency.
Third, milestones. Does this funding round get you to the next fundable milestone? Seed investors want to see you reach $1-2 million ARR (Series A territory). Series A investors want to see you reach $10 million ARR (Series B territory). If your model shows you’ll run out of money at $800K ARR—stuck between fundraising stages—investors will pass.
The Core Components Every Model Needs
A fundraising-ready financial model has five core tabs or sections: revenue projections, expense projections, headcount plan, cash flow forecast, and cap table/fundraising summary.
Tab 1: Revenue Projections
This is where you model how much money your company will make over the next 24-36 months. Revenue projections break down by revenue stream (subscriptions, professional services, one-time sales) and show monthly or quarterly growth.
For a SaaS company, revenue projections track MRR (monthly recurring revenue) growth based on new customer acquisition, churn, and expansion revenue from existing customers.
Tab 2: Expense Projections
This models all your costs: payroll, marketing spend, technology infrastructure, office expenses, professional services. Expenses are broken into fixed costs (salaries, rent) and variable costs (paid ads, hosting fees that scale with usage).
Tab 3: Headcount Plan
Since payroll is typically 60-70% of startup expenses, headcount deserves its own detailed tab. This shows who you’ll hire, when, at what salary, and how they contribute to revenue growth (sales reps) or support operations (engineers, customer success).
Tab 4: Cash Flow Forecast
This pulls together revenue and expenses to show your cash position month by month. Cash flow forecasts reveal when you’ll run out of money (your runway) and when you need to start your next fundraise (typically 6-9 months before running out of cash).
Tab 5: Cap Table and Fundraising Summary
This shows your current ownership structure and models how the new funding round will dilute existing shareholders. It also summarizes your “use of funds”—exactly how you’ll spend the capital you’re raising.
These five components work together to tell a complete financial story: here’s how much we’ll grow, here’s what it costs, here’s when we need more money, and here’s how ownership changes.
Building Your Revenue Projections
Revenue projections are the hardest part of financial modeling because you’re predicting the future with limited data. But investors don’t expect perfect accuracy—they expect logical thinking and realistic assumptions.
Start With Your Business Model
Revenue modeling starts with understanding exactly how you make money. Different business models require different approaches.
SaaS (B2B): Revenue comes from monthly or annual subscriptions. You model new customer acquisition each month, average contract value, and churn rate. The formula is: MRR = (Starting MRR + New MRR from new customers + Expansion MRR from existing customers) – Churned MRR.
E-commerce: Revenue comes from transactions. You model traffic, conversion rate, and average order value. The formula is: Monthly Revenue = Monthly Visitors × Conversion Rate × Average Order Value.
Marketplaces: Revenue comes from taking a percentage of transactions between buyers and sellers. You model gross merchandise volume (GMV) and take rate. The formula is: Revenue = GMV × Take Rate.
Freemium/Consumer: Revenue comes from converting free users to paid subscribers or from advertising. You model user acquisition, conversion rate to paid, and ARPU (average revenue per user).
Build Bottom-Up, Not Top-Down
Investors hate top-down projections like “The market is $10 billion, we’ll capture 1%, so we’ll have $100 million revenue.” This tells them nothing about how you’ll actually acquire customers.
Instead, build bottom-up projections based on your go-to-market motion.
Example for a B2B SaaS company: You hire one sales rep in month 3. They ramp for two months, then close two deals per month at $500 MRR each. By month 6, you hire a second rep who follows the same ramp. By month 12, you have four reps each closing $2,000 MRR monthly. Your revenue projection is the sum of all reps’ output minus churn.
This bottom-up approach shows investors you understand the mechanics of customer acquisition, not just aspirational market size.
Use Historical Data When You Have It
If you’re raising Series A and already have 12 months of revenue history, use that data to inform projections. Look at your actual growth rate over the past 6-12 months and extend that trend forward with slight improvements as you deploy more capital.
If you grew 15% MoM for the past six months, projecting 20% MoM after raising capital (because you’ll hire more sales reps and increase marketing spend) is credible. Projecting 50% MoM is not—unless you can explain exactly what changes to produce that acceleration.
Document Every Assumption
Below your revenue projections, create an “Assumptions” section that lists every key input:
- Average contract value: $500/month
- Sales cycle length: 45 days
- Sales rep quota (fully ramped): $25K MRR/month
- Ramp time for new reps: 3 months
- Monthly churn rate: 5%
- Expansion revenue: 10% of existing customers expand by $100/month annually
When investors question your projections, you point to these assumptions and explain your logic. If they disagree, you can adjust assumptions in real-time and show how it changes the model.
Modeling Your Cost Structure
Expense modeling is more straightforward than revenue because costs are more predictable. But founders still make critical mistakes that destroy credibility.
Break Down Fixed vs Variable Costs
Fixed costs don’t change with revenue: salaries, software subscriptions, office rent, insurance. These costs are predictable and easy to model.
Variable costs scale with revenue or usage: cloud hosting, payment processing fees, customer acquisition costs, transaction fees. Model these as a percentage of revenue or based on usage metrics.
For example, if AWS costs are currently $2,000/month supporting 1,000 users, and you project 10,000 users by month 18, model AWS costs scaling proportionally (though economies of scale might reduce per-unit costs as you grow).
The Major Expense Categories
Payroll and benefits: Salaries, payroll taxes, health insurance, 401k contributions. This is typically 60-70% of total expenses for early-stage startups.
Sales and marketing: Paid advertising, events, content creation, sales tools (Salesforce, HubSpot), trade shows. For high-growth startups, this can be 20-30% of expenses.
Technology and infrastructure: Cloud hosting, software licenses, development tools, security. Usually 5-10% of expenses.
General and administrative: Legal, accounting, insurance, office expenses. Typically 5-10% of expenses.
Cost of goods sold (COGS): For SaaS, this includes hosting costs directly tied to delivering the product. For e-commerce, this is inventory costs and shipping.
Modeling Expenses Month-by-Month
Don’t model expenses as annual totals divided by 12. Model them month-by-month with realistic timing.
If you hire a sales rep in March, their salary hits in March—not spread across Q1. If you pay for an annual software license in January, that entire cost hits January (or is amortized monthly depending on your accounting method).
Month-by-month modeling reveals cash flow timing issues. You might be profitable on an annual basis but still run out of cash in month 8 because too many expenses hit simultaneously.
Headcount Planning: The Biggest Expense
Payroll is your largest expense, so headcount planning deserves detailed attention. Investors scrutinize your hiring plan to see if you’re building the right team at the right pace.
Build a Hiring Timeline
Create a table showing every role you’ll hire, when, and at what salary.
| Month | Role | Salary | Total Monthly Cost |
|---|---|---|---|
| 1 | Engineer #1 | $120K ($10K/mo) | $10K |
| 3 | Sales Rep #1 | $100K + commission | $12K |
| 5 | Engineer #2 | $120K | $22K |
| 6 | Sales Rep #2 | $100K + commission | $34K |
| 9 | Customer Success Manager | $80K ($6.7K/mo) | $40.7K |
This shows your burn rate accelerating as you hire. Month 1 burn is $10K, month 12 burn is $50K+.
Factor in Ramp Time
Sales reps and customer success hires aren’t productive on day one. Model a 2-3 month ramp period where they’re learning the product, shadowing senior reps, and gradually taking on quota.
If a sales rep has a $25K MRR monthly quota when fully ramped, month 1 they contribute $0, month 2 they contribute $8K, month 3 they contribute $15K, and month 4 they hit full quota. This realistic ramp timing prevents over-optimistic revenue projections.
Don’t Overhire Too Early
The most common mistake founders make is front-loading hiring. They raise $3 million and immediately hire 10 people, causing burn to spike to $150K/month before revenue has time to catch up.
Better approach: hire in waves tied to revenue milestones. When you hit $50K MRR, hire sales rep #2. When you hit $100K MRR, hire your first marketer. This keeps burn aligned with revenue growth and extends runway.
When planning how new hires will drive specific revenue outcomes and justifying each role’s impact on your financial projections, comprehensive business planning helps you articulate the strategic rationale behind your hiring decisions. Fundreef’s AI business plan generator structures your hiring strategy alongside revenue targets to show investors exactly how team growth translates into business growth.
Cash Flow, Burn Rate, and Runway
Cash flow forecasting is the most important output of your financial model. It tells you exactly when you’ll run out of money—and therefore when you need to start fundraising.
The Cash Flow Formula
Cash flow is simple: Starting Cash + Revenue – Expenses = Ending Cash.
Model this month-by-month. If you start with $500K, generate $20K revenue, and spend $80K, you end the month with $440K. Next month you start with $440K, generate $25K revenue, spend $85K, and end with $380K.
Track this for 24-36 months to see when cash hits zero.
Burn Rate: Gross vs Net
Gross burn rate is total monthly expenses regardless of revenue. If you spend $100K/month, gross burn is $100K.
Net burn rate is expenses minus revenue. If you spend $100K and earn $30K revenue, net burn is $70K.
Investors care about net burn because it shows how fast you’re actually consuming capital. A company with $100K gross burn and $90K revenue is only burning $10K net—sustainable for years. A company with $100K gross burn and $0 revenue is burning cash fast.
Runway Calculation
Runway is how many months you can operate before running out of cash. The formula is: Runway = Cash in Bank ÷ Monthly Net Burn.
If you have $1 million and burn $80K net per month, you have 12.5 months of runway.
But this formula assumes burn stays constant—which it doesn’t. As you hire and scale marketing, burn increases. Model runway accounting for increasing burn rate.
The Fundraising Timeline Rule
Start fundraising when you have 6-9 months of runway remaining. Fundraising takes 3-6 months on average, and you need buffer in case it takes longer.
If your model shows you’ll run out of cash in month 18, you should start raising in month 10-12. If you wait until month 15, you’re in a desperate position that weakens your negotiating leverage.
Scenario Modeling: Best Case, Base Case, Worst Case
No financial model is perfectly accurate. Markets shift, customers churn unexpectedly, hires take longer than planned. Smart founders model multiple scenarios to show investors they understand uncertainty.
The Three Scenarios
Base case: Your most realistic projection based on current traction and reasonable assumptions. This is the scenario you’d bet on if forced to choose.
Best case: Aggressive but achievable if everything goes right. Maybe you grow 30% MoM instead of 20%, or churn is 3% instead of 5%. This shows upside potential.
Worst case: Conservative scenario if growth is slower or costs are higher. Maybe you grow 10% MoM instead of 20%, or sales reps take 4 months to ramp instead of 3. This shows you’ve thought about downside risk.
How Scenarios Change Your Ask
Scenario modeling helps you determine the right fundraising amount.
If your base case shows you need $2 million to reach Series A milestones with 3 months of runway remaining, your worst case might show you need $2.5 million to hit the same milestones with comfortable buffer.
Smart founders raise based on worst case or midpoint between base and worst case. This ensures you have runway even if things don’t go perfectly.
Common Financial Modeling Mistakes
Even experienced founders make these errors that undermine investor confidence.
Mistake 1: Overly Optimistic Growth Assumptions
Projecting 50% MoM growth for 24 months means you’ll grow 8,300x over two years. Unless you’re in an explosive viral consumer app, this is fantasy.
Most sustainable SaaS companies grow 15-25% MoM in early stages, slowing to 10-15% MoM as they scale. Use realistic benchmarks from similar companies at similar stages.
Mistake 2: Underestimating Hiring Costs
Founders model salaries but forget payroll taxes (7.65% employer contribution), benefits (health insurance adds 20-30% to compensation costs), recruiting fees (15-25% of first-year salary), and equity compensation (which dilutes shareholders).
A $100K salary actually costs $130K+ all-in when you include these factors.
Mistake 3: Ignoring Seasonality
B2B SaaS sales slow in November-December (holiday season) and August (summer vacations). E-commerce spikes in Q4 (holiday shopping). Consumer apps spike in January (New Year’s resolutions).
Model these patterns if they apply to your business. Investors know them and will question projections that ignore obvious seasonal effects.
Mistake 4: Projecting Profitability Too Soon
Early-stage startups shouldn’t be profitable—they should be investing in growth. If your model shows profitability by month 12 on a seed round, investors will ask why you need funding at all.
Better to show disciplined cash burn that extends runway to 24 months, reaching the next fundable milestone with 3-6 months of cash remaining. This demonstrates capital efficiency without claiming premature profitability.
Mistake 5: Building a Model Too Complex to Explain
If you can’t walk through your model in under 10 minutes, it’s too complex. Investors won’t spend an hour decoding your 50-tab spreadsheet with macros and hidden assumptions.
Simplify ruthlessly. Remove unnecessary detail. If a tab doesn’t directly support answering “How much do you need and what will you accomplish?”, delete it.
How to Present Your Model to Investors
Your financial model lives in Excel, but investors don’t want to see raw spreadsheets in pitch meetings. They want clear, visual summaries.
Create a Simple Financial Summary Slide
Your pitch deck should include one slide summarizing your financial projections:
Key Metrics (24 months out):
- Revenue: $2.5M ARR
- Customers: 250
- Gross margin: 75%
- Monthly burn: $120K
- Headcount: 15
Use of Funds (how you’ll spend the $2M you’re raising):
- Product development: $600K
- Sales & marketing: $800K
- Team expansion: $400K
- Runway buffer: $200K
This slide shows investors the headline numbers without drowning them in detail.
Be Ready to Go Deeper
Investors will ask follow-up questions: “How did you get to $2.5M ARR?” “What’s your CAC assumption?” “How many sales reps are you hiring?”
Have your full Excel model ready to share and walk through. Practice explaining your assumptions in 2-3 sentences: “We’re hiring 4 sales reps over 18 months. Each ramps to $30K MRR monthly quota after 3 months. We assume 5% monthly churn based on current cohorts.”
Show, Don’t Just Tell
Use simple charts to visualize your model:
- Line chart showing MRR growth over 24 months
- Stacked bar chart showing expense breakdown by category
- Waterfall chart showing how cash flows month-by-month
Visuals make complex financial data immediately understandable and demonstrate that you’ve thought carefully about the numbers.
When modeling different funding scenarios and showing investors how various investment amounts and valuations affect your ownership and runway, financial analysis tools help you quickly adjust assumptions during live discussions. Fundreef’s AI company valuation tool allows you to model cap table scenarios in real-time so you can answer investor questions about dilution and ownership immediately.
Frequently Asked Questions About Financial Models
How far out should my financial projections go?
For seed rounds, 24 months is standard. For Series A, 36 months. Beyond 36 months, projections become guesswork. Focus on the next fundable milestone, not five-year plans.
Should I project monthly or quarterly?
Model monthly internally because it reveals cash flow timing issues. But you can present quarterly summaries to investors since monthly detail can be overwhelming. Have monthly detail available if they ask.
What if I don’t have historical data to base projections on?
Use industry benchmarks and comparable companies. Research average SaaS sales cycles, typical e-commerce conversion rates, or standard marketplace take rates in your industry. Document where you got benchmarks and explain why they apply to your business.
How accurate do my projections need to be?
Investors don’t expect perfect accuracy—they know projections are educated guesses. What matters is logical thinking and reasonable assumptions. If your actual results are 20% above or below projections, that’s fine. If you’re off by 5x, you didn’t understand your business.
Should I include a cap table in my financial model?
Yes. Create a simple cap table tab showing current ownership and how the new funding round will dilute existing shareholders. This helps investors understand their ownership percentage and shows you understand dilution dynamics.
What’s the difference between a financial model and a pitch deck?
Your financial model is the detailed Excel file with all your assumptions, calculations, and projections. Your pitch deck includes 1-2 summary slides showing the key outputs from that model. The model is for deep due diligence; the deck is for storytelling.
How do I model revenue when I’m pre-product?
Focus on unit economics and hypothetical customer scenarios. “If we charge $50/month and acquire 100 customers in month 6 with 5% churn, we’ll reach $5K MRR by month 12.” Use pilot program results, survey data, or letter-of-intent commitments to justify your assumptions.
