What a startup financial model is, and what it is for
A startup financial model is a spreadsheet that projects your revenue, costs and cash balance month by month, usually for 12 to 36 months. It connects a handful of assumptions about customers, pricing and hiring to the numbers that decide whether the company survives: monthly burn, cash on hand and runway. If you can change one assumption and watch the cash line move, you have a model. If you only have a table of numbers that someone typed in, you have a forecast that cannot be questioned.
At the seed stage the model has two jobs. Internally, it tells you when you must raise, cut costs or reach a milestone. Externally, investors read it to judge how you think, not to believe the exact figures. Nobody expects month 18 to come true. They expect the logic to be visible, the assumptions to be reasonable and the cash line to show a believable path to the next milestone.
Start with five inputs, not forty tabs
Most early models fail because they are built too big. A useful first version needs only five blocks: how you acquire customers, what each customer pays, what it costs to deliver the product, what the team costs, and your starting cash. Everything else, from taxes to depreciation, can wait until the core shows the company can work at all.
The table lists each block, the assumption behind it and the metric it should end up as. Fill the left column with plain numbers and write beside each one whether it is measured or guessed. That single habit separates a model you can defend from one you have to apologise for.
| The assumption you write down | The metric it becomes | |
|---|---|---|
| Customer acquisition | New customers per month and what you spend to win them | CAC, new customers, sales and marketing spend |
| Pricing and revenue | Price per customer and how many stay each month | MRR, ARPU, churn |
| Cost of delivery | Hosting, support and payment fees per customer | Gross margin |
| Team and operating costs | Who you hire, when, and at what fully loaded cost | Payroll, monthly burn |
| Starting cash and funding | Cash today, plus any round you expect and when | Cash balance, runway in months |
Forecast revenue bottom-up, not as a share of a huge market
The weakest sentence in any pitch is some version of "if we capture just 1% of a $50 billion market." Investors have heard it so often that it signals the founder has not thought about how customers are actually won. A bottom-up forecast does the opposite: it starts with the channel and works toward revenue. For example, 200 outreach messages a week, a 5% reply rate, a 20% demo-to-paid rate and a price of $100 a month give you a number you can check against what you did last month.
Use the figures you already have, even if they are small, and flag the ones you are guessing. Model churn explicitly: a customer base that grows 10% a month and loses 5% is growing far more slowly than the sales line suggests. Our guide to MRR versus ARR explains how to count recurring revenue, and the unit economics article shows how acquisition cost and margin decide whether growth is worth buying.
Costs and hiring: where the cash line really bends
For most startups, people are the largest cost, and hiring dates move the cash line more than any other input. Use the fully loaded cost of each person, which includes payroll taxes, benefits, equipment and software, not only the salary. A common rule of thumb is to add a meaningful margin on top of base pay, but check it against your own country and contracts rather than copying a number.
Separate fixed costs, such as salaries and rent, from variable ones, such as hosting and payment fees that grow with customers. Then add a buffer line for the things that always appear: legal bills, a late customer payment, a tool that quietly gets more expensive. Our article on hiring plans and burn rate walks through how a single hire changes the number of months you have left.
Run three scenarios and read the runway
One forecast is a hope. Three scenarios are a decision tool. Build a base case, a downside where growth is slower than you expect, and an upside where it is faster, changing only the growth and churn inputs. Then look at one output above all others: the month in which cash would reach zero, because that is your real deadline, not the number on the last row.
The example below is illustrative. A SaaS startup begins with $200,000 in cash, $8,000 of MRR and $19,000 of monthly costs, held flat to isolate growth. Only the monthly MRR growth rate changes between cases, and the difference in cash at month 12 shows how much the growth assumption is worth. Notice that in the slow case the company still runs out of money, around month 23, even though revenue is rising.
~$79K
downside: MRR grows 2% a month, cash runs out around month 23
~$99K
base case: MRR grows 5% a month, MRR passes costs near month 19
~$124K
upside: MRR grows 8% a month, cash never reaches zero in 24 months
$19K
monthly costs held flat in all three cases
The mistakes that make investors stop reading
The first is the hockey stick: flat revenue for a quarter, then a sudden curve with no new channel, hire or product to explain it. The second is a model that ignores timing, assuming customers pay on the day you invoice when many business customers pay in 30 to 60 days. A profitable-looking month can still leave the bank balance lower, which is why profit and cash are different things. Our explanation of EBITDA shows exactly where that gap comes from.
The third mistake is hiding assumptions inside formulas, so nobody can see what drives the result. Keep every assumption in one clearly labelled sheet and make the rest of the model read from it. The fourth is false precision: showing revenue to the cent in month 24 signals that you have confused arithmetic with evidence. Round the later months and show a range.
Turn the model into a monthly habit
A model is only useful while it is current. Once a month, enter the actual revenue, costs and cash, compare them with the forecast and write down the biggest gap and its cause. After three months you will know which of your assumptions are reliable and which keep missing, and your next forecast improves for free.
Use the output to decide, not to decorate. If the downside case shows cash running out in 14 months and your next milestone takes 12, you have two months of room and a reason to start fundraising now. How long a round takes is its own question, and our guide to the seed timeline helps you set the date. A free runway calculator gives a quick cross-check on the cash line before you build the full sheet.
Practice reading the numbers under pressure
A spreadsheet cannot teach you how it feels to make a hiring or pricing call with six months of cash left. Founder Runway lets you rehearse that: a run lasts 20 turns, and each decision offers four options that move cash, burn, MRR and runway. You choose a B2B, B2C or B2G model and a starting stage of Pre-Seed, Seed, Pre-Series A or Series A, then watch the same variables a financial model tracks respond to your choices.
A run ends as a failure, a promising company, EBITDA positive or high-value exit potential. Try the same start twice, once choosing the aggressive option each turn and once the cautious one, and compare where runway ends up. It is a rehearsal rather than a forecast, but it builds the instinct for what a cash line can and cannot absorb.
Frequently asked questions
What is a startup financial model?
A startup financial model is a spreadsheet that projects revenue, costs and cash month by month, usually for 12 to 36 months. It links assumptions about customers, pricing and hiring to outputs such as burn, cash balance and runway. Founders use it to plan fundraising, and investors use it to judge how the team thinks.
How do you build a financial model for a startup?
Start with five blocks: customer acquisition, pricing and revenue, cost of delivery, team and operating costs, and starting cash. Put every assumption on one labelled sheet, build revenue bottom-up from your channels, then add hiring dates and a buffer for surprises. Finish with a cash balance line and the month in which cash would reach zero.
How far ahead should a startup financial projection go?
Twenty-four months is a good default for an early-stage startup, with monthly detail for the first 12 to 18 months. Beyond that the figures are guesses, so show them as ranges or yearly totals. Investors care more about whether you reach the next milestone than about year five.
What should be in a seed-stage financial model?
A seed-stage model needs a revenue forecast built from channels and conversion rates, a hiring plan with fully loaded costs, a monthly cash balance and the resulting runway. It should also show how much you plan to raise and what milestone that money buys. Detailed tax, depreciation and balance sheet items can usually wait.
What is the difference between a financial model and a budget?
A budget sets spending limits for a period, while a financial model forecasts how revenue, costs and cash change as assumptions change. A model can test scenarios, such as slower growth or an earlier hire, and a budget normally cannot. Many startups use the model to set the budget.
Why do investors not trust startup financial projections?
Investors distrust projections that show a sudden hockey-stick curve with nothing to explain it, hide assumptions inside formulas or ignore payment timing. They also lose confidence when a model claims precision far into the future. A transparent bottom-up model with scenarios earns more trust than an impressive number.
How many scenarios should a startup financial model include?
Three is enough for most startups: a base case, a downside and an upside. Change only the key drivers, usually growth and churn, so the cases stay easy to compare. The downside case matters most because it shows the month when cash would run out.
Test this decision in the game.
Apply the same assumption across one run and see which metric weakened three turns later.