Skip to content
Financial projections

Financial projections, built free for your business plan.

Five-year financial projections for a business plan, loan or grant, built free in Excel around your business, with every assumption sourced.

  • Free account
  • No card
  • Usually ready within the hour

We use generative AI in parts of our process, so mistakes can occur. Every model should be checked by a person before it is relied on. Read more

The short answer

What are financial projections?

Financial projections forecast a business’s revenue, costs, profit, cash and balance sheet, usually three to five years ahead, monthly at first and then yearly. Lenders, investors and grant bodies use them to judge whether a plan adds up. The Financial Modeller builds them free in Excel as a full three-statement model, ready for a business plan, loan or grant.

Key facts

Every model we build
Format
Excel (.xlsx), every formula intact, no macros
Statements
Profit and loss, balance sheet and cash flow, linked, with scenarios and a dashboard
Valuation
7 methods: DCF, EV/EBITDA, P/E, net asset value, dividend discount, sum of the parts, precedent transactions
Periods
Monthly, quarterly, half-yearly or annual, up to 30 years
Detail
Five levels, from very low to very high
Turnaround
Usually ready within the hour
Cost
Free, with a free account and no card
Checked
Balances in every period; reviewed by our team before it is sent
  • 01

    Driven, not guessed

    Revenue from customers, prices and volumes; costs from staff, rent and suppliers. Every line has a reason.

  • 02

    All three statements

    Profit, balance sheet and cash flow, linked, so lenders see repayments covered, not just a profit line.

  • 03

    Scenarios readers can test

    Switch on an upside or downside case and every statement moves with it.

On this page · 5 parts
  1. 01What are financial projections for?
  2. 02What do good financial projections include?
  3. 03How far out should projections go?
  4. 04Which mistakes sink financial projections?
  5. 05Can someone build my projections for free?
01

What are financial projections for?

Financial projections are a forecast of your business’s profit and loss, balance sheet and cash flow, usually by month for the first year or two and by year after that. They turn the story in your business plan into numbers: what you will sell, what it will cost, how much cash you need and when you can pay it back.

Who reads them changes what matters most. Built properly, one set of projections answers every reader:

  • A bank: can the business service the loan with room to spare, and what security is there?
  • An investor: how fast it grows, what margins it reaches and how far their money takes it.
  • A grant assessor: does the project budget tie to the plan, and is your share of the cost funded?
  • You: when does cash run lowest, and what has to go right for the plan to work?
02

What do good financial projections include?

Take a gym planning a second site. Members drive everything: 400 at opening, then 60 more a month up to 1,200, each paying $22 a week. Staff follow members, rent is fixed by the lease, and the fit-out is paid for before the first member walks in. Built that way, a bank can see the month cash bottoms out and when the gym starts covering its repayments.

Strip away the formatting and every credible set of business plan financial projections has the same parts:

  • Revenue drivers: customers, volumes and prices, and why each one grows. Not just “sales up 20% a year”.
  • Costs that follow those drivers: staff by role and start date, rent, suppliers and marketing.
  • Capital spending, such as a fit-out, equipment or vehicles, with its depreciation.
  • Funding: loans with their interest and repayments, equity raised and grants received.
  • Working capital: when customers pay, when you pay suppliers, the stock you carry and the GST in each BAS.
  • A linked profit and loss, balance sheet and cash flow, so projected profit becomes a cash balance you can trust.
  • The measures readers check: gross margin, break-even, cash runway and, if you borrow, debt service cover.
  • One sheet of assumptions that says where every number came from.
Members · GymBase case
Members at month 121,060400 at opening, 60 more a month
Weekly feePrice list$22
Club capacityFloor plan1,200
Revenue, year 1$835,120
The gym above, with made-up figures: members by month, and the revenue they bring.
03

How far out should projections go?

Three to five years suits most business plans, and 5-year financial projections are a common ask from investors. Lenders look hardest at the first few years, when repayments start. Long-lived assets, such as a farm, a hotel or a solar farm, justify ten years or more.

Go monthly while the business is new or cash is tight, so a slow start or a seasonal dip shows up. A café’s first winter or a builder’s gap between contracts can vanish inside an annual total. Once the business settles, quarters or years are enough.

Match the detail to what you can support. A start-up with no history is better served by a few honest drivers, such as customers, price, churn and headcount, than by a hundred lines it can’t back up. An established business can build from its own accounts, line by line.

04

Which mistakes sink financial projections?

Readers rarely argue with the arithmetic. They argue with the assumptions, and these are the ones they catch first:

  • The hockey stick: flat history, then 50% growth a year, with nothing in the plan to explain it.
  • Sales that double while staff, marketing and stock stay flat.
  • No wage for the founder, or owner’s drawings that never appear in the cash flow.
  • Profit with no cash: no allowance for customers paying late, stock on the shelves or GST owed to the ATO.
  • Costs held at today’s prices while revenue rises with inflation.
  • No downside case. Show what happens if sales come in 20% lower, and when the cash would run out.
  • Numbers with no source. Tie the first year to your actuals, quotes and leases, and label what is an estimate.
05

Can someone build my projections for free?

A free financial projections template hands you blank rows and leaves the hard part to you: deciding how each line should work, linking the statements, and finding the error when the balance sheet won’t balance.

Tell us about the business and what the projections are for, and attach what you have: last year’s accounts, a budget, supplier quotes, a lease or your pitch deck. We build them free in Excel. Say they are for raising debt and the model adds covenant tests, headroom and debt capacity; for an equity raise, sources and uses and the share register.

Ask for your history too, and your last three years of accounts sit beside the forecast, with the forecast’s opening balances checked against them. Pick from five levels of detail, from a one-page view of the whole business to every driver built up.

You get the three statements, scenarios, a dashboard and a valuation, monthly, quarterly, half-yearly or annual for up to 30 years. Every input sits in blue with its source. Every model is checked to balance in every period and reviewed by our team before it reaches you, usually within the hour.

In every model

Everything a model needs, in one workbook.

A standard .xlsx with every formula intact and no macros: monthly, quarterly, half-yearly or annual, for up to 30 years.

InputsEvery assumption in blue, with its source noted.
Profit and lossBuilt up from your revenue and cost drivers.
Balance sheetLinked to profit and cash, every period.
Cash flowClosing cash ties to the balance sheet.
Valuation7 methods, from DCF to precedent deals.
ScenariosSwitch cases and every sheet moves with it.
DashboardThe figures your reader looks for first.
ChecksProof that it balances in every period.
How it worksA guide sheet that explains each part.
FAQ

Questions, answered.

Straight answers about the model and how we build it.

  • Yes. Building, previewing, changes, research, historical financials, branding and the Excel download are all free, with no end date. You need a free account, and no card.

  • A forecast profit and loss, balance sheet and cash flow; the drivers behind revenue and costs; capital spending and funding; and a sheet of assumptions with their sources. Lenders and investors also expect a downside case.

  • Three to five years for most business plans, with the first year or two by month. Businesses with long-lived assets, such as property, farms or infrastructure, often project ten years or more.

  • Build up from drivers you can evidence: customers or sales per day, prices, staff, rent, supplier quotes and industry benchmarks. Then test what happens if sales start slower than planned.

  • Whether cash flow covers interest and repayments with room to spare, how the forecast compares with your recent results, and what the balance sheet offers as security. Realistic, sourced assumptions count for more than big growth.

  • Many people use the words interchangeably. Strictly, a forecast is what you expect to happen, while a projection shows what would happen under a set of assumptions, such as opening a second site. Scenarios in a model let you show both.

  • Yes. Tell us the grant and what it pays for, and the projections can show the grant, the project spending and how your share of the cost is funded.