How to Build a 3-Year Financial Model in Excel

Published: June 2026

Whether you're pitching investors, applying for a loan, or just trying to understand if your business idea actually makes money — a 3-year financial model is the single most important spreadsheet you'll ever build.

Here's how to do it properly, step by step. At the end, there's a plug-and-play template that does the heavy lifting for you.

What a Financial Model Needs

A good model answers five questions:

1. How much will we make? (Revenue projections)
2. How much will it cost? (Expense structure)
3. Will there be anything left? (Profit & Loss)
4. What if things change? (Sensitivity analysis)
5. When do we break even? (Breakeven analysis)

Step 1: Set Up Your Assumptions

Everything flows from assumptions. Put these in a separate "Assumptions" section at the top of your sheet. Color them yellow — universal spreadsheet convention for "change me."

ASSUMPTIONS (Year 1 | Year 2 | Year 3)
Revenue growth rate:     —     |  30%  |  25%
Cost of goods sold:      45%   |  43%  |  40%
Sales & marketing:       25%   |  20%  |  18%
General & admin:         15%   |  12%  |  10%
Research & development:  12%   |  10%  |   8%
Tax rate:                25%   |  25%  |  25%

Start conservative. Investors prefer you beat projections than miss them.

Step 2: Build the Revenue Forecast

Revenue is usually driven by unit economics:

Revenue = Number of Customers × Average Revenue Per Customer (ARPU)

Or for transactional businesses:

Revenue = Number of Transactions × Average Order Value

Model this for each year. Year 1 should be monthly. Years 2-3 can be quarterly or annual.

Step 3: Map Your Cost Structure

Split costs into two categories:

Variable costs (scale with revenue): COGS, payment processing fees, shipping, customer support. Express these as percentages of revenue.

Fixed costs (don't scale with revenue): Rent, base salaries, software subscriptions, insurance. Express these as absolute dollar amounts.

Variable costs should decrease as a percentage of revenue over time (economies of scale). Fixed costs should increase in steps (new hires, bigger office) rather than smoothly.

Step 4: Build the P&L Waterfall

Revenue
- Cost of Goods Sold
= Gross Profit
- Sales & Marketing
- General & Administrative
- Research & Development
= Operating Income (EBIT)
- Interest Expense
- Taxes
= Net Income

Each line should be a formula referencing your assumptions. Change one assumption and everything recalculates.

Step 5: Add Sensitivity Analysis

Your base case is one scenario. Create two more:

• Best case: Revenue grows 20% faster than base case, costs 10% lower
• Worst case: Revenue grows 30% slower than base case, costs 15% higher

This shows investors you've thought about risk — and gives you a dashboard for decision-making.

Step 6: Calculate Key Metrics

Investors will look for:

• Gross Margin: Gross Profit / Revenue (should be >50% for SaaS, >30% for e-commerce)
• EBITDA Margin: EBITDA / Revenue (trending positive by Year 3)
• Net Margin: Net Income / Revenue
• Burn Rate: Monthly cash outflow (for pre-revenue startups)
• Runway: Cash on hand / Monthly burn rate
• Breakeven Point: Month when cumulative revenue exceeds cumulative costs

Common Mistakes

• Over-optimistic revenue: "If we get 1% of a $100B market..." — No. Build from the bottom up: customers × price.
• Ignoring working capital: Revenue booked ≠ cash in bank. Account for payment terms.
• Flat cost ratios: Costs should change as a % of revenue as you scale.
• No sensitivity analysis: A single scenario isn't a model. It's a hope.

Blog Index