Test more than the happy path
See what happens when performance is weaker, stronger or simply different from what you expected.
Free business template
Financial Projections
Template
Optimism is not a financial model.
Growth can look convincing until you test what happens when sales come in slower, margins get squeezed or costs rise faster than expected. Use this free Financial Projections Template to model the next 36 months across Conservative, Base and Upside scenarios, then see what your assumptions actually do to revenue, gross profit, operating profit and break-even.
Free to use. No sign up required.
Financial Projections
Projection starts: January 2027 Currency: KES
| Scenario | Start Revenue | Growth | Margin | Start OPEX | Month 36 Revenue |
|---|---|---|---|---|---|
| Conservative | 320,000 | 1% | 44% | 155,000 | 453,313 |
| Base Case | 400,000 | 3% | 48% | 160,000 | 1,125,545 |
| Upside | 500,000 | 5% | 52% | 175,000 | 2,758,008 |
Base Year 3 Revenue11.54M
Base Year 3 PBT2.44M
Base PBT Margin21.1%
Find the break-even line
Know the revenue your cost structure needs before the business starts producing profit.
See where the plan gets fragile
Spot assumptions that leave too little room for slower growth, tighter margins or higher costs.
Turn growth into numbers
See what your goals actually require from revenue, margins and expenses month after month.
Template features
Make the assumptions prove themselves.
Conservative, Base and Upside scenarios
Build three versions of the future instead of betting everything on one forecast.
36-month projections
Follow the model month by month across three full years and see how small assumptions compound.
Revenue growth modelling
Set starting revenue and expected growth, then see what those numbers actually produce over time.
Gross margin modelling
See how changes in COGS and gross margin affect how much revenue survives after the sale.
Operating expense projections
Model the cost of running and growing the business instead of pretending revenue grows alone.
Profit projections
Track gross profit, operating profit and profit before tax so growth cannot hide weak economics.
Break-even revenue
See the revenue level required to support your projected cost structure.
Annual summaries
Compare Year 1, Year 2 and Year 3 without losing the month-by-month detail underneath them.
Get started
Use it where you already work.
Google SheetsBuild and test your projections online
Change assumptions, switch scenarios and keep the latest model accessible across your devices.
We’ll add the live Google Sheets link when it is shared.Microsoft ExcelDownload the spreadsheet
Work offline, keep your own copy and build the model into your existing planning process.
We’ll add the Excel file when it is shared.Step by step
Before you commit money to the plan, make the numbers defend it.
Start with reality
Enter current or expected revenue, growth, gross margin and operating costs. Start with assumptions you can explain, not the number you want to reach.
| Revenue | Growth | Margin |
|---|---|---|
| 400,000 | 3% | 48% |
Build three futures
Create Conservative, Base and Upside cases. Test slower sales, stronger margins and higher costs instead of relying on one outcome.
| Case | Growth | Margin |
|---|---|---|
| Conservative | 1% | 44% |
| Base | 3% | 48% |
| Upside | 5% | 52% |
Follow the consequences
Let the assumptions flow through revenue, COGS, gross profit, operating expenses and profit across 36 months.
| Month | Revenue | PBT |
|---|---|---|
| Jan 2027 | 400,000 | 22,000 |
| Feb 2027 | 412,000 | 25,360 |
Find the weak assumptions
Do not just ask which scenario makes the most money. Ask which assumptions your plan cannot afford to get wrong.
| Year 3 | PBT | Margin |
|---|---|---|
| Conservative | -742K | -14.4% |
| Base | 2.44M | 21.1% |
| Upside | 9.43M | 36.7% |
Useful for
For decisions where “we think it will work” is not enough.
Growing businesses
Test whether the next stage of growth creates stronger economics or simply bigger costs.
New ventures
Turn an exciting idea into assumptions you can challenge before committing serious money.
Funding conversations
Show how the business could develop and what assumptions sit behind the numbers.
Expansion decisions
Pressure-test new locations, staff, equipment or higher operating costs before committing.
How to read the model
A projection is a set of assumptions made visible.
Financial projections are most useful when they make the consequences of your decisions clear. If growth slows, margins tighten or operating costs rise, the model should show you what that means before the cash is committed.
Which assumptions does your plan need to get right?
FAQ
Frequently asked questions.
Is the Financial Projections Template free?
Yes. The template is free to use. The Google Sheets version and Excel file will remain marked Coming soon until their delivery links are approved and shared.
What are financial projections?
Financial projections estimate what your business could look like in the future based on assumptions about revenue, growth, margins and costs. They are not predictions. A useful projection answers a harder question: if these assumptions are true, what kind of business do they produce?
How far ahead does the template project?
The template models 36 months, covering Year 1, Year 2 and Year 3.
Why are there three scenarios?
One forecast can give you dangerous confidence. Conservative shows weaker performance, Base represents what you currently think is realistic and Upside shows what stronger performance could produce. The point is to understand how dependent your plan is on each assumption.
What numbers do I need?
Start with revenue, expected growth, gross margin and operating expenses. Use numbers you can defend. A sophisticated spreadsheet built on unrealistic assumptions is still an unrealistic forecast.
What is the difference between a budget and financial projections?
A budget tells you what you plan to spend and achieve. Financial projections show what your assumptions could produce. The budget helps you manage the plan; projections help you test whether the plan makes sense in the first place.
Can this template tell me whether my business will succeed?
No spreadsheet can predict that. What it can do is expose the financial logic behind your plan so you can see whether the outcome depends on reasonable assumptions or everything going perfectly.
How often should I update my projections?
Update them whenever reality materially changes the assumptions behind the model. If sales growth, margins or costs behave differently from the forecast, the projection should change too.