Skip to main content
Share:
Startup financial projections template, with an example

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.

14 min read

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:

  1. Assumptions. Every number that drives the plan, in one list, each with its reason.
  2. Revenue, built from the bottom up. How many customers you reach each month, how many sign, how many leave, and what each one pays.
  3. 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:

ColumnHow to calculate it
New customersContacts this month ÷ sign-up rate
Lost customersCustomers at the start of the month × monthly churn, rounded to a whole customer
CustomersLast month's customers + new − lost
RevenueCustomers × price per month
Cash inThe revenue you invoiced one payment period ago (last month's, on 30-day terms)
CostsEvery cost line for the month, added up
Cash at endLast 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:

AssumptionNumberWhy this number
Price€120 a school a monthIn 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 today12The pilot.
Contacts by the founder40 a monthWhat one founder managed during the pilot alongside demos and setup.
Sign-up rate1 in 10In the pilot, 120 schools contacted, 12 signed.
Contacts by a salesperson40 a month in months 7 and 8, then 80A new hire needs time to get up to speed. After that, selling is their whole job, so twice the founder's pace.
Schools that leave2 in 100 a monthA guess. No pilot school has left yet, but the pilot is three months old. To be replaced with real numbers.
Payment termsInvoiced each month, paid 30 days laterPilot schools pay by bank transfer about a month after the invoice.
Founders' pay€3,500 each a monthFull cost to the company. The least each needs to live on, so neither takes outside work.
Developer€6,000 a month from month 3Full cost to the company: salary plus employer costs.
Salesperson€4,500 a month from month 7Full cost to the company. Commission is left out to keep the example short; put it in yours.
Marketing€1,500 a month from month 7Ads and a stand at driving instructor events, to give the salesperson warm leads.
Software and hosting€800 a monthToday's tool bills, plus hosting priced for 300 schools.
Accountant, insurance, legal€700 a monthYearly quotes, spread across the months.
Laptops€2,000 in months 3 and 7One 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.

MonthNewLostSchoolsRevenueCash inCostsCash at end
140161,9201,4408,500112,940
240202,4001,9208,500106,360
340242,8802,40016,50092,260
440283,3602,88014,50080,640
541313,7203,36014,50069,500
641344,0803,72014,50058,720
781414,9204,08022,50040,300
881485,7604,92020,50024,720
9121597,0805,76020,5009,980
10121708,4007,08020,500-3,440 (cash runs out)
11121819,7208,40020,500-15,540
121229110,9209,72020,500-26,320
1312210112,12010,92020,500-35,900
1412211113,32012,12020,500-44,280
1512212114,52013,32020,500-51,460
1612213115,72014,52020,500-57,440
1712314016,80015,72020,500-62,220
1812314917,88016,80020,500-65,920
1912315818,96017,88020,500-68,540
2012316720,04018,96020,500-70,080
2112317621,12020,04020,500-70,540 (lowest point)
2212418422,08021,12020,500-69,920
2312419223,04022,08020,500-68,340
2412420024,00023,04020,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.

CaseSign-up rateSchools that leaveSchools payCash runs outRevenue passes costsLowest cash (€)
Good1 in 81 in 100 a monthafter 30 daysMonth 11Month 16-29,480 (month 16)
Base1 in 102 in 100 a monthafter 30 daysMonth 10Month 21-70,540 (month 21)
Bad1 in 153 in 100 a monthafter 60 daysMonth 10Not 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.
Join 700+ founders who got personalized advice

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.