FINANCIAL FORECAST TEMPLATE FOR STARTUPS
This Financial Forecast Template has been designed to help new businesses and startups apply for a Start Up Loan.
A realistic and well-researched financial forecast is an essential part of the Start Up Loan application process.
Download the financial forecast template below
You might need to right-click and select 'save as'
The template is in Excel, so you'll need a spreadsheet programme to open it
If you can't download it, contact your Business Adviser to receive a copy via email
Complete the template to the best of your abilities
Send your completed form back to your business adviser
QUICK VIDEO GUIDE
5 tips for completing your financial forecast template
Applying for a Start Up Loan with Transmit Startups? Here are our five top tips on how to complete your financial forecast template.
1. Work in stages
The forecast spreadsheet contains 4 tabs which can feel overwhelming at first, so it’s a good idea to break it down into chunks.
Start with the Personal Survival Budget which is about your personal expenses and how much you need to maintain your current lifestyle. Then move onto the sales forecast, thinking only about the income your business will generate. And finally, complete the cashflow forecast tab and expenses you will incur.
2. Consider seasonal variations
When completing the sales forecast, plot out the different months of the year and consider how events and customer behaviour at different times of the year may affect your sales.
For example, retailers may find that the run-up to Christmas is the busiest time of the year but for garden maintenance businesses December may be one of the quietest months.
3. Think about your average sales prices
If you have a lot of different products or services then it won’t be possible to list every separate item in your sales forecast. Instead you could consider what your average customer will spend and use that for your forecasts, or take it a step further and identify groups of customers such as high spend, medium spend and low spend.
4. Don’t forget the small expenses
When thinking through your business expenses when starting a business, it is easy to think about the big costs you incur such as rent, equipment, stock or marketing.
While these expenses have the largest impact on your cashflow, remember to also include the expenses that come around month after month and are easily overlooked – things like stationery, postage, credit card processing costs and online software subscriptions.
5. Calculate your breakeven sales from your expenses
Figuring out your sales before you’ve started your business can be tricky. One solution is to start with your monthly expenses, then work backwards to figure out how many units you need to sell to cover those expenses.
This will give you a basic breakeven point from which you can work on your sales forecasts further.
Still wondering what financial forecasting is all about?
We know you're not going to become an expert in small business finance and bookkeeping overnight. Our Startup Advice section has lots of articles to help you get to grips with the fundamentals of funding and finance.