Planypals

Financial Models

How to Create Financial Projections for a Startup

By Sofia Marchetti··8 min read

Key takeaways

  • Projections forecast sales, expenses, profit, and cash flow over 3 to 5 years.
  • Credibility beats optimism; trace every number to a documented assumption.
  • Bottom-up forecasting is usually more believable than top-down.
  • Use best, base, and worst case scenarios and a visible assumptions tab.
RevenueExpensesYear 1Year 5
Credible projections show revenue and expenses year by year — and when the lines cross into profit.

To create financial projections for a startup, build a model that forecasts sales, expenses, profit, and cash flow over three to five years. Start by gathering your data, choose a forecasting method, build a sales forecast, plan your expenses, add best, base, and worst case scenarios, and assemble the three core financial statements. Document every assumption so the numbers are defensible.

Projections prove you understand your business

Investors and lenders know no one predicts the future perfectly. What they are really testing is whether you understand the drivers of your business today. Strong projections are not the most optimistic; they are the most credible, with each figure traceable to a clear assumption.

The steps to build them

1. Gather your data

Pull together any existing financials, pricing, costs, and market research. These inputs anchor your forecast in reality.

2. Choose a forecasting method

Top-down starts from the market size and works toward your share, useful when you have no sales history. Bottom-up starts from your own units, prices, and capacity, and is usually more credible. Many founders sanity-check one against the other.

3. Build the sales forecast

Your sales forecast drives everything else, so most lenders and investors want at least a three year view. Tie it to specific assumptions about customers, pricing, and conversion.

4. Plan your expenses

Separate fixed costs like rent and payroll from variable costs like advertising that scale with sales. This split makes your model far more realistic.

5. Add scenarios

Build best, base, and worst case versions so readers can see how the business holds up under different conditions. Scenario analysis signals maturity.

6. Assemble the statements

Produce an income statement, cash flow statement, and balance sheet. The standard format is monthly for year one, quarterly for years two and three, and annual after that. See our explainer on the 3-statement financial model for how they connect.

Numbers not your strength?

We build clean, defensible models with a documented assumptions tab that survive due diligence. Send your assumptions and we'll quote the build.

Build my financial model

Make the assumptions visible

Keep every driver in a single assumptions tab so reviewers can see what is behind each number and test it themselves. Hidden or hard-coded assumptions are the fastest way to lose trust. Tracking your unit economics like customer acquisition cost and lifetime value also shows that growth is profitable, not just fast. Two outputs reviewers look for early are a break-even analysis and, if you are raising, a sense of how to value a startup from the same numbers. The model should also track your burn rate and runway so you know how long the cash lasts.

Where projections fit in your raise

The same numbers should appear in your pitch deck financials slide and your written plan, so consistency matters. If you want the model built for you, our financial modeling services delivers an editable model and a walkthrough, and it pairs naturally with a full business plan.

Frequently asked questions

How many years of financial projections do I need?+
Most lenders and investors want three to five years, with monthly detail for year one, quarterly for years two and three, and annual figures after that.
What is the difference between top-down and bottom-up forecasting?+
Top-down starts from the total market and estimates your share, while bottom-up builds from your own units, prices, and capacity. Bottom-up is generally more credible because it ties to your actual operations.
What should be in a startup financial projection?+
A sales forecast, an expenses budget split into fixed and variable costs, a breakeven analysis, and the three core statements: income statement, cash flow statement, and balance sheet, all driven by documented assumptions.
How accurate do startup projections need to be?+
They do not need to be precise, but they must be credible and internally consistent. Investors evaluate whether your assumptions are reasonable, not whether you can predict the future exactly.

About the author

Sofia Marchetti, Head of Financial Modeling

Sofia Marchetti

Head of Financial Modeling

Sofia came up through corporate FP&A and startup finance, building the driver-based models founders live or die by. At Planypals she leads the financial modeling and writes the guides on projections, unit economics, and cap tables. She is unmovable on one point — a number you can't trace back to a defensible assumption has no business being in the model.

Reviewed for accuracy by Claire Whitfield, Managing Editor.

Get started

Ready to get a funding-ready document?

Tell us about your project and get a free, no-pressure quote within one business day.