How to Create Financial Projections for Your Startup

Financial projections aren't about predicting the future. Nobody can do that. They're about showing you've thought through the economics of your business: how you'll make money, what it will cost to operate, and whether the math makes sense.

First-time founders either skip projections entirely ("we're pre-revenue, so what's the point?") or create fantasy hockey sticks that fool no one. This guide walks through building projections that are actually useful for planning, fundraising, and understanding your business.

There are two ways to project revenue: top-down and bottom-up.

Top-down (avoid this): "The market is $10 billion. If we capture just 1%, that's $100 million in revenue."

This sounds reasonable but tells investors nothing. Every founder says this. It's meaningless because the assumptions are untested.

Bottom-up (do this): "We'll acquire 100 customers in Year 1 at $1,000 average revenue per customer. That's $100K. With 20% monthly customer growth and 5% churn, we'll have 600 customers by end of Year 2 at $600K revenue."

Bottom-up projections are grounded in specific, testable assumptions. Investors can evaluate each input independently. More importantly, YOU can evaluate whether your assumptions are realistic.

The bottom-up approach forces you to answer real questions:

• How many customers will you acquire per month?
• What will they pay?
• How many will you lose to churn?
• How will acquisition efficiency change as you scale?

For most early-stage startups, a 3-year model is sufficient. Five years out is pure fiction anyway. Here's how to structure it.

The Tabs You Need

1. Assumptions Tab All your inputs in one place. This is where you change numbers to see how the model responds.

Key assumptions to include:

• Customer acquisition rate (new customers per month)
• Average revenue per customer
• Monthly churn rate
• Pricing increases (if planned)
• Hiring timeline and salaries
• Marketing spend as percentage of revenue
• Major expense categories

2. Revenue Tab Your revenue build from assumptions to monthly numbers.

For a SaaS business:

• Starting customers
• New customers added
• Customers churned
• Ending customers
• ARPU (average revenue per user)
• Monthly recurring revenue (MRR)
• Annual recurring revenue (ARR)

3. Expenses Tab Every cost category with monthly projections.

Standard categories:

• Salaries and benefits (usually 60-70% of early-stage costs)
• Marketing and advertising
• Software and tools
• Hosting and infrastructure
• Office/coworking
• Legal and accounting
• Insurance
• Travel
• Miscellaneous

4. P&L Tab (Profit & Loss) Brings revenue and expenses together.

5. Cash Flow Tab P&L doesn't equal cash flow. This tab tracks actual cash in and out.

6. Summary Tab Key metrics at a glance for presenting to investors.

SaaS Business

Key inputs:

• Starting MRR
• New customers per month
• Monthly ARPU
• Logo churn rate
• Net revenue retention (expansion revenue)

Formula: Ending MRR = Starting MRR + New MRR + Expansion MRR - Churned MRR

Example for Year 1:

• Start with 10 customers at $100/month = $1,000 MRR
• Add 20 customers/month average = 240 new customers
• 5% monthly churn
• End Year 1: ~180 customers, ~$18,000 MRR, ~$150,000 total revenue

Marketplace Business

Key inputs:

• Number of transactions
• Average transaction value
• Take rate (your percentage)
• Supply and demand side growth

Formula: Revenue = Transactions x Average Value x Take Rate

E-Commerce Business

Key inputs:

• Monthly site traffic
• Conversion rate
• Average order value
• Repeat purchase rate

Services Business

Key inputs:

• Number of clients
• Average project value (or hourly rate x hours)
• Client retention rate
• Capacity utilization

Investors won't believe your numbers. That's not the point. They're evaluating:

1. Do You Understand Unit Economics?

Can you explain CAC, LTV, payback period, and margins for your business? Founders who don't know their unit economics raise red flags.

2. Is the Growth Rate Realistic?

Claiming 10x growth year over year with no explanation of how isn't credible. Show the levers: channels, conversion rates, pricing.

3. What's the Path to Profitability (or Next Milestone)?

Your projections should show how you get from here to either profitability or clear Series A metrics. If you're raising $500K, show what that buys you.

4. Are the Assumptions Testable?

Good projections have discrete assumptions an investor can evaluate. "We'll grow 50%/month" is not testable. "We'll add 50 customers/month at $30 CAC via Google ads" is.

5. Do You Know What Matters?

For SaaS: MRR, churn, NRR. For marketplace: GMV, take rate, liquidity. For e-commerce: CAC, AOV, repeat rate. Show you know your metrics.

Hockey stick with no basis. If year 3 shows $10M in revenue but you can't explain the path from year 1's $50K, nobody believes you.

Forgetting taxes. Payroll taxes, sales taxes, income taxes. These are real costs that founders often omit.

Underestimating hiring costs. Benefits, payroll taxes, recruiting, equipment. A hire costs 30-50% more than salary.

Linear expense growth with exponential revenue. Usually, expenses grow faster than you think as you scale. More customers need more support. More employees need more management.

Ignoring churn. Projecting customer acquisition without customer loss creates false optimism. Model churn explicitly.

Not modeling runway. Your model should clearly show when you run out of money. This informs fundraising timing.

• Use bottom-up projections based on testable assumptions, not top-down market share claims.
• Build a 3-year model with tabs for assumptions, revenue, expenses, P&L, and cash flow.
• Payroll is your biggest expense. Include benefits and taxes (30-40% on top of salary).
• Investors evaluate your thinking, not your predictions. Know your unit economics.
• Model churn and runway explicitly. Optimism kills more startups than pessimism.
• Stress test your assumptions. If everything needs to go right, your model is too fragile.

How detailed should my financial projections be?

Monthly for years 1-2, quarterly for year 3. More detail than that is false precision. You don't know what Q3 of Year 3 will look like. Focus detail where you have real information.

What if I'm pre-revenue?

Project anyway. Start from "How many customers can I get in month 1?" and build up. Your assumptions will be guesses, but educated guesses. Update as you learn.

How often should I update my projections?

Monthly for the next 12 months, quarterly beyond that. Your model should be a living document, not something you create once for fundraising.

What growth rate should I assume?

Depends on your stage and market. Seed-stage SaaS companies often target 15-20% month-over-month growth. But your rate should be based on YOUR assumptions about channels and conversion, not benchmarks.

Do investors want to see my spreadsheet?

Sometimes. More often they want to see a summary (one-page or a few slides) with key metrics. Have the detailed model ready for due diligence, but lead with the story.