
Startup financial projections template, with an example
A 24-month projections template filled in for one made-up startup: every assumption explained, monthly cash, three scenarios and the month cash runs out.
A common way projections fall apart: an investor points at one number and asks where it came from, and the founder doesn't know. My advice: keep them realistic, and be able to explain the logic behind every number.
This page gives you a startup financial projections template you can copy into a spreadsheet, then fills it in for one made-up startup over 24 months: the assumptions, each with a one-line reason, the monthly revenue and spend, and the month the cash runs out.
What the plan needs, and what it doesn't
At pre-seed and seed, a plan of 18 to 24 months is enough. It is long enough to show what the money buys and short enough that each month still rests on something you know. A five-year forecast at this stage asks the reader to believe year five, and nobody does.
The plan has three parts:
- Assumptions. Every number that drives the plan, in one list, each with its reason.
- Revenue, built from the bottom up. How many customers you reach each month, how many sign, how many leave, and what each one pays.
- Costs and cash. What you spend each month and, most important, how much cash is left at the end of it.
Keep every month for the whole plan. A quarterly view can hide the month the cash runs out, and finding that month is the main reason to build the plan.
You don't need a full set of financial statements for this. The plan is about cash: when it comes in and when it runs out. A spreadsheet in Google Sheets or Excel is the right tool. VAT and corporation tax are left out of this example; ask your accountant how they affect your cash.
The startup financial projections template
One row per month. These are the columns and how each one is calculated:
| Column | How to calculate it |
|---|---|
| New customers | Contacts this month ÷ sign-up rate |
| Lost customers | Customers at the start of the month × monthly churn, rounded to a whole customer |
| Customers | Last month's customers + new − lost |
| Revenue | Customers × price per month |
| Cash in | The revenue you invoiced one payment period ago (last month's, on 30-day terms) |
| Costs | Every cost line for the month, added up |
| Cash at end | Last month's cash at end + cash in − costs |
Above the table, keep the assumptions in their own cells (price, sign-up rate, churn, payment terms, each salary and its start month) and point every formula at them. Then changing one assumption updates the whole plan, which is how you build the scenarios further down.
The example: software for driving schools
Imagine two founders building booking and pupil-progress software for independent driving schools in Ireland. Instructors use it to fill their diaries, send lesson reminders and track what each learner has covered. Schools pay a monthly subscription.
Everything in this example is invented: the company, the interviews, the pilot and every number.
After a three-month pilot, the founders have 12 paying schools and €120,000 in the bank. Here are their assumptions:
| Assumption | Number | Why this number |
|---|---|---|
| Price | €120 a school a month | In 20 interviews, owners paid €60 to €150 a month for what this replaces (a booking app plus a texting service). The 12 pilot schools pay €120. |
| Paying schools today | 12 | The pilot. |
| Contacts by the founder | 40 a month | What one founder managed during the pilot alongside demos and setup. |
| Sign-up rate | 1 in 10 | In the pilot, 120 schools contacted, 12 signed. |
| Contacts by a salesperson | 40 a month in months 7 and 8, then 80 | A new hire needs time to get up to speed. After that, selling is their whole job, so twice the founder's pace. |
| Schools that leave | 2 in 100 a month | A guess. No pilot school has left yet, but the pilot is three months old. To be replaced with real numbers. |
| Payment terms | Invoiced each month, paid 30 days later | Pilot schools pay by bank transfer about a month after the invoice. |
| Founders' pay | €3,500 each a month | Full cost to the company. The least each needs to live on, so neither takes outside work. |
| Developer | €6,000 a month from month 3 | Full cost to the company: salary plus employer costs. |
| Salesperson | €4,500 a month from month 7 | Full cost to the company. Commission is left out to keep the example short; put it in yours. |
| Marketing | €1,500 a month from month 7 | Ads and a stand at driving instructor events, to give the salesperson warm leads. |
| Software and hosting | €800 a month | Today's tool bills, plus hosting priced for 300 schools. |
| Accountant, insurance, legal | €700 a month | Yearly quotes, spread across the months. |
| Laptops | €2,000 in months 3 and 7 | One for each hire. |
Where you have no data yet, as with schools that leave, the table says so.
A note on the salary lines: each one is the full cost of that person to the company, not the figure on their payslip. In Ireland, employers pay employer PRSI on top of salary (Citizens Information on paying PRSI). In the UK, employers pay employer National Insurance (GOV.UK National Insurance rates). Rates and thresholds change, so take the current figures from those pages, and ask your accountant what else applies where you hire. For the founders' line, how much should a founder pay themselves shows how to get from each founder's living costs to the full cost.
Revenue from the bottom up
The revenue line comes from three sales numbers: how many schools you contact, how many of them sign, and how many leave. These are the same numbers that build the obtainable slice of a bottom-up market count, which how to calculate market size works through. The plan turns them into months.
In months 1 to 6 the founder contacts 40 schools a month and 4 sign. In months 7 and 8 the salesperson adds 40 more, so 8 sign. From month 9 it is 120 contacts and 12 new schools a month.
The 24-month plan, filled in
All amounts in euro. Revenue is the schools at the end of the month × €120. Cash in is last month's revenue, because schools pay 30 days after the invoice. Month 1's cash in is the pilot schools paying for the month before.
| Month | New | Lost | Schools | Revenue | Cash in | Costs | Cash at end |
|---|---|---|---|---|---|---|---|
| 1 | 4 | 0 | 16 | 1,920 | 1,440 | 8,500 | 112,940 |
| 2 | 4 | 0 | 20 | 2,400 | 1,920 | 8,500 | 106,360 |
| 3 | 4 | 0 | 24 | 2,880 | 2,400 | 16,500 | 92,260 |
| 4 | 4 | 0 | 28 | 3,360 | 2,880 | 14,500 | 80,640 |
| 5 | 4 | 1 | 31 | 3,720 | 3,360 | 14,500 | 69,500 |
| 6 | 4 | 1 | 34 | 4,080 | 3,720 | 14,500 | 58,720 |
| 7 | 8 | 1 | 41 | 4,920 | 4,080 | 22,500 | 40,300 |
| 8 | 8 | 1 | 48 | 5,760 | 4,920 | 20,500 | 24,720 |
| 9 | 12 | 1 | 59 | 7,080 | 5,760 | 20,500 | 9,980 |
| 10 | 12 | 1 | 70 | 8,400 | 7,080 | 20,500 | -3,440 (cash runs out) |
| 11 | 12 | 1 | 81 | 9,720 | 8,400 | 20,500 | -15,540 |
| 12 | 12 | 2 | 91 | 10,920 | 9,720 | 20,500 | -26,320 |
| 13 | 12 | 2 | 101 | 12,120 | 10,920 | 20,500 | -35,900 |
| 14 | 12 | 2 | 111 | 13,320 | 12,120 | 20,500 | -44,280 |
| 15 | 12 | 2 | 121 | 14,520 | 13,320 | 20,500 | -51,460 |
| 16 | 12 | 2 | 131 | 15,720 | 14,520 | 20,500 | -57,440 |
| 17 | 12 | 3 | 140 | 16,800 | 15,720 | 20,500 | -62,220 |
| 18 | 12 | 3 | 149 | 17,880 | 16,800 | 20,500 | -65,920 |
| 19 | 12 | 3 | 158 | 18,960 | 17,880 | 20,500 | -68,540 |
| 20 | 12 | 3 | 167 | 20,040 | 18,960 | 20,500 | -70,080 |
| 21 | 12 | 3 | 176 | 21,120 | 20,040 | 20,500 | -70,540 (lowest point) |
| 22 | 12 | 4 | 184 | 22,080 | 21,120 | 20,500 | -69,920 |
| 23 | 12 | 4 | 192 | 23,040 | 22,080 | 20,500 | -68,340 |
| 24 | 12 | 4 | 200 | 24,000 | 23,040 | 20,500 | -65,800 |
Costs are €8,500 a month at the start (founders, software, accountant), €16,500 in month 3 with the developer and a laptop, €14,500 in months 4 to 6, €22,500 in month 7 with the salesperson, marketing and a second laptop, and €20,500 a month from then on.
What the numbers say
The cash runs out in month 10. Every negative number after that is money the company doesn't have. A round can take three to six months of meetings and paperwork, so to have money in the bank by month 9, the founders need to start raising in month 3 or 4.
Revenue passes costs in month 21. That is the month the company starts making money on paper: €21,120 of revenue against €20,500 of costs.
The gap is about €70,000. The lowest point is -€70,540 in month 21. That is the least extra money the company needs to reach the point where it pays for itself, and only if the base case is right.
How to fill the gap (angels, a grant, customers paying upfront, a slower hiring plan) is a separate decision, and so is whether to take investors' money at all. Bootstrapping vs fundraising: how to decide goes through that choice. If the founders put in different amounts of their own money to make up the €120,000, agree now whether it is a loan or a bigger share of the company: co-founder money: who pays for what covers that conversation.
Why profitable companies still run out of cash
Look at month 21 again. Revenue is €21,120 and costs are €20,500, so on paper the company made €620. But the cash fell by €460, because the money that arrived in month 21 was month 20's invoices: €20,040. Profit counts what you invoiced. Cash counts what arrived.
Now run the same plan with one change: schools pay 60 days after the invoice instead of 30. Same schools, same revenue, same profit on paper. The lowest point drops from -€70,540 to -€89,600, in month 22. Slower payment alone costs the company €19,060 more cash. And the cash keeps falling for two months from the first "profitable" month, not one.
The faster you grow, and the longer your customers take to pay, the bigger this gap gets. It also works in your favor: if customers pay upfront (an annual plan, a setup fee, a paid pilot instead of a free one), the cash arrives before the costs, and the gap shrinks.
Base, good and bad cases
Your base case will be wrong. The question is by how much, and what happens if it is. So build two more versions by changing only the assumptions you are least sure of. Here, those are the sign-up rate, the share of schools that leave, and payment terms.
| Case | Sign-up rate | Schools that leave | Schools pay | Cash runs out | Revenue passes costs | Lowest cash (€) |
|---|---|---|---|---|---|---|
| Good | 1 in 8 | 1 in 100 a month | after 30 days | Month 11 | Month 16 | -29,480 (month 16) |
| Base | 1 in 10 | 2 in 100 a month | after 30 days | Month 10 | Month 21 | -70,540 (month 21) |
| Bad | 1 in 15 | 3 in 100 a month | after 60 days | Month 10 | Not within 24 months | -167,560 (month 24) |
In all three, the cash runs out within a month of each other (month 10 or 11), because early on costs drive the plan, not sales. What the cases change is how deep the gap gets and whether it ever closes.
The bad case never reaches the point where revenue covers costs. At month 24, with 124 schools, its cash is still falling by €6,700 a month. That is the case to look at hardest, because it tells you whether the business survives a slow year. It changes three assumptions at once, so on its own it can't tell you which one hurts most. The 60-day version above shows payment terms alone, and the sign-up rate gets its own test below.
The founders decide to look for €170,000 more. It covers the bad case to month 24, with €2,440 left, and in the base case it leaves just under €100,000 at the lowest point. If they raise it as a SAFE, how a SAFE works explains the terms.
The number that matters most
Investors usually don't believe your month 24 revenue, and they don't expect to. What they test is the logic. Be ready to defend each assumption rather than the final numbers: where it came from, and what would change it.
So test which assumption hurts most when it is wrong. In this plan it is the sign-up rate. If 1 in 12 schools sign instead of 1 in 10, revenue never catches up with costs within 24 months, and the cash at month 24 is -€107,680 instead of -€65,800. That is two fewer new schools a month at full pace. It is the number the founders track every week and the first one they would explain in a meeting.
If you are pitching, this plan sits behind the ask: how much you are raising, how many months it buys and where it gets you. The pitch deck outline for a 10-minute pitch shows where that goes in the deck. The plan itself is for when an investor asks for the numbers.
Mistakes that make a plan hard to believe
- Five years of hockey stick. Revenue that doubles every year to a big round number, with no monthly logic underneath. Show 18 to 24 months you can explain.
- Revenue from a market share. "We only need 1% of the market" has no logic behind it to explain. Count contacts, sign-ups and losses instead.
- Everyone hired in month 1. People join when the money and the work are there, and new salespeople take time to sell at full pace. Put each hire in the month they start, with a slower first month or two.
- Payslip salaries. Use the full cost to the company, as in the salary note above.
- No payment lag. If customers pay 30 or 60 days after the invoice, your cash runs a month or two behind your revenue. Model it.
- Nobody leaves. Some customers always cancel. If you have no data yet, guess, say it is a guess, and replace it once you know.
- A plan you never open again. Each month, put the real numbers next to the plan. Where they differ, change the assumption, not just the total.
Ready to Move Faster?
Get actionable feedback and insights on your challenges and goals. 30 minutes focused on helping you move forward.
No sales pitch. No obligations. Just helpful advice.