How to create a detailed financial forecast for your store

To create a robust financial forecast, you need to build a spreadsheet that details every single cost required to start and run your shop, and then realistically project your monthly sales for the first two years. This forecast is the most critical part of your business plan, showing you how much money you need to get started, when you might break even, and whether your idea is financially viable before you commit a penny.

Why a Financial Forecast is Non-Negotiable

It might seem like guesswork, but a detailed forecast is your most powerful planning tool. It helps you:

• Prove Viability: It answers the fundamental question: "Can this business actually make money?"
• Secure Funding: No bank or investor will consider funding you without a thorough financial plan.
• Manage Cash Flow: It acts as an early warning system, highlighting future months where cash might be tight, allowing you to plan ahead.
• Set Goals: It provides clear financial targets to aim for once you are open.

The Three Pillars of Your Forecast

Your forecast is built from three key components. Let's tackle them one by one.

1. Startup Costs: The one-off expenses you'll pay before you make your first sale.
2. Ongoing Expenses: The regular, recurring costs of keeping the lights on.
3. Sales Projections: Your educated guess at how much you will sell each month.

Part 1: Calculating Your Startup Costs

This is a list of everything you need to buy or pay for to get your doors open. Be brutally thorough and get real quotes wherever possible. Your list will likely include:

Shop Premises:

• Rent Deposit (often 3-6 months' rent upfront)
• Legal fees for the lease agreement
• Shop fit-out (e.g., flooring, lighting, decorating, counters, shelving)

Equipment:

• Electronic Point of Sale (EPOS) system and card machine
• Refrigeration units or specialist equipment
• CCTV and security alarm systems
• A computer, printer, and phone

Stock & Suppliers:

• Your entire initial stock order to fill the shelves
• Design and printing of signage and window displays

Admin & Professional:

• Licence application fees (e.g., Premises Licence for alcohol)
• Accountant or solicitor fees
• Business insurance policy (first payment)

Top Tip: Once you have totalled all your estimated startup costs, add a 15-20% contingency fund. Unexpected expenses always crop up, and this buffer can be a lifesaver.

Part 2: Estimating Your Ongoing Expenses (Overheads)

These are the bills you'll have to pay every month or year, regardless of how much you sell. Split them into a monthly spreadsheet. Key expenses include:

• Premises Costs: Rent, Business Rates, utilities (electricity, gas, water, internet), and waste collection.
• Staff Costs: Wages for you and any staff, plus Employer's National Insurance and pension contributions (budget around 15% on top of gross salary).
• Stock Costs (Cost of Goods Sold - COGS): What you pay suppliers for the products you sell. This will vary with sales, but you need to estimate an average monthly figure.
• Business & Admin: Insurance (monthly premium), accounting software (e.g., Xero, QuickBooks), bank fees, phone bills, and music licence fees.
• Marketing: A monthly budget for flyers, social media ads, or local advertising.

Part 3: Projecting Your Sales

This is the most challenging part, as you have no historical data. The key is to be realistic and base your figures on research, not just hope.

1. Use a "Bottom-Up" Approach: This is often the most realistic method. Estimate the average amount a customer will spend (£5? £10?). Then, estimate how many customers you can realistically serve per hour, and multiply that by your opening hours.
2. Research Industry Benchmarks: Look for data on the average turnover for a convenience store of your size in the UK. This provides a useful sense-check for your own figures.
3. Consider Seasonality: Your sales won't be the same every month. Factor in quiet periods (like January/February) and busy peaks (like December). Map these out over your two-year forecast.
4. Start Conservatively: It's better to project lower sales and exceed them than to project high sales and run out of cash. Assume a slow start for the first 3-6 months as you build a customer base.

Bringing It All Together: Your Cash Flow Forecast

The final step is to combine these three elements into a single spreadsheet. This is your cash flow forecast. For each month over a 24-month period, you will have:

• Opening Bank Balance
• (+) Total Monthly Sales (Income)
• (-) Total Monthly Expenses (Outgoings)
• (=) Closing Bank Balance

The closing balance of Month 1 becomes the opening balance for Month 2, and so on. This model will show you, month by month, how much cash you have in the bank. It will highlight your 'break-even point' (the month you start making a profit) and, crucially, any months where you might dip into the red, giving you time to arrange an overdraft or extra funding.