Optional Google Analytics cookies help us understand visits and improve Business Launchpad. Your choice lasts 180 days. Change it anytime in Cookies & Storage.

Section 11 of 13: Build

Startup Financial Projections: 12-Month Forecast

Startup financial projections estimate what a new business will earn and spend over its first months and when it will stop losing money. Business Launchpad's Financial Projections section produces a 12-month P&L from your brief, Competitors, Your Customers, MVP Planner, Launch Roadmap and Licences & Insurance: monthly revenue, costs and net profit in pounds, three revenue models compared, the break-even month, start-up costs, total funding needed, and a sensitivity analysis on the three assumptions that matter most. Licence and insurance costs arrive as named lines. On the Founder plan it exports as a six-sheet Excel workbook with live formulas.

No account for the brief. Free accounts build three ideas. Downloads need Founder or an eligible trial.

What you walk away with

Outcomes

A forecast you can interrogate

Every month's revenue, cost and profit is visible, with the assumptions listed. Change an assumption and you can see which months move.

A break-even month

Calculated from the monthly figures and shown on a cumulative profit chart, so you know how long the runway must be.

A start-up cost list

Each item with an amount and a one-off or recurring flag, which is what a Start Up Loan or bank application asks for.

An Excel model that still works when you edit it

Financial-Model.xlsx is the model itself. The drivers (price, new customers, growth, churn, cost to deliver, running and set-up costs) are blue input cells, and every month of revenue, costs, cash position, break-even and the funding need is a formula from them. Change the price and they all move.

Inside the section

What you get

Assumptions
Revenue streams and pricing assumptions, stated explicitly so they can be challenged.
Monthly projections
Twelve rows of revenue, costs and net profit in GBP, shown as a table and as revenue-versus-costs and cumulative-profit charts in the builder.
Break-even month
The first month where cumulative profit turns positive, marked on the chart.
Start-up costs
Itemised, with an amount for each. The licences, registrations and insurance from Licences & Insurance are merged in as named lines, so the cost of being allowed to trade is in the model rather than a surprise.
Funding needed
A total figure derived from the costs and the losses before break-even. The funding route finder starts from this and your break-even to ask whether you should raise at all.
Three revenue models compared
Three ways this business could charge, set side by side so you can see which one reaches break-even and what each assumes about volume and price.
Sensitivity
The three critical assumptions, and what happens to the forecast when each one moves. In the pack this becomes the sensitivity tornado in the PDF.
Excel financial model
Financial-Model.xlsx in the Business Pack: the drivers as input cells, 24 months of formulas from them, live break-even and funding need, and the revenue models compared on the same costs.

Step by step

How it works

  1. 1

    Financial Projections close the Build group, after the Launch Roadmap. Pricing comes from Competitors, volumes from Your Customers, costs from the MVP Planner and Licences & Insurance, and timing from the roadmap. The section is deliberately built in one pass so the projections, the three revenue models and the sensitivity agree with each other.

  2. 2

    Read the assumptions first. If a price or volume is wrong, edit it in place or regenerate; on the Founder plan you can give the correct figures as instructions.

  3. 3

    Check the break-even month against your personal runway. If it is too far out, revisit costs in the MVP section or pricing in the brief.

  4. 4

    On the Founder plan, download the pack and open Financial-Model.xlsx. Change any blue cell on the Assumptions sheet and revenue, costs, cash, break-even and the funding need recalculate.

Who uses it

Use cases

Start Up Loan applicant

The Start Up Loans programme asks for a 12-month cash-flow forecast. A founder builds the financials, replaces the rent and insurance figures with real quotes, exports the Excel model and attaches it alongside the business plan PDF.

Deciding whether to quit

Someone employed full-time wants to know how many months of savings they need. The break-even month and cumulative losses give a first answer, and the sensitivity analysis shows what happens if volumes come in below plan.

Two founders splitting equity

Co-founders disagree about how much the business needs to raise. The funding-needed figure and the start-up cost list give them a shared number to argue about, rather than two mental models.

Free or Founder?

Free Founder

Free accounts build Financial Projections for up to three ideas and see the table, charts and assumptions in the builder, and can read the funding route finder that works from them. The six-sheet Excel model with live formulas, and the break-even curves and sensitivity tornado inside the business plan PDF, are part of the Business Pack on the Founder plan (£19 a month or £149 a year, 14-day trial with no card).

Frequently asked questions

How accurate are AI-generated financial projections?

As accurate as the assumptions, and the assumptions are estimates until you replace them with real quotes, prices and volumes. The value is the structure: every figure is stated, every month is visible and the break-even is calculated rather than guessed. Treat the first build as a draft, check each assumption and edit. Anyone reviewing the forecast will ask where the numbers came from, so keep notes.

What is a break-even month and how is it calculated?

It is the first month in which cumulative net profit turns positive, meaning the business has earned back everything it has spent since month one. The section calculates it from the twelve monthly net profit figures and marks it on the cumulative profit chart. If the business does not break even within twelve months, the funding-needed figure reflects the shortfall.

Can I use this for a Start Up Loan application?

Yes, as your starting point. Start Up Loans requires a business plan and a cash-flow forecast, and the Excel model covers monthly revenue, costs and profit for twelve months. Adjust the figures to match your quotes and add anything specific to your situation, such as personal drawings. The loan is a personal loan of up to £25,000, so assessors focus on affordability.

Does the Excel model have real formulas or just numbers?

Real formulas. The Assumptions sheet holds the drivers as blue input cells: price, new customers, growth, churn and cost to deliver for each revenue stream, plus running and set-up costs. The Model sheet works out 24 months from them, and Break-even shows the break-even month and funding need, all live. A Try a change section multiplies price, customers, churn or costs so you can test a case without retyping. It is deliberately plain so an accountant or mentor can follow every formula. Plans built before October 2026 have a simpler month-by-month sheet until Financial Projections is regenerated.

What is the sensitivity analysis for?

Every forecast rests on a few assumptions that matter far more than the rest, usually a price, a volume and a cost. The section names the three critical ones for your business and shows how the forecast moves when each changes. That tells you which numbers to test with real customers first, and it is what a lender means when they ask for a downside case.

Does it cover VAT, corporation tax or National Insurance?

No. The forecast is a pre-tax profit and loss projection. VAT registration is only required once turnover exceeds the HMRC threshold, corporation tax depends on your structure and profits, and employer National Insurance depends on hiring. These belong in a conversation with an accountant once the underlying model looks right. Treat the section as the operating forecast that conversation starts from.

Keep reading

See your break-even month

A 12-month forecast, built from the pricing and costs in your plan.