Introduction

Every business decision - from launching a new product to buying equipment, hiring staff, or seeking investment - needs a financial model behind it. But here's the question that stops most business owners and finance managers cold: which model do you actually need?

A cash flow forecast? A break-even analysis? A full three-way model? A pricing calculator? A DCF valuation? The answer depends on your business stage, the type of decision you're making, and who needs to see the output.

This article provides a structured decision framework to help you choose the right Excel financial model for your situation. We'll walk through the most common model types, map them to real business scenarios, and link to detailed guides for each one so you can dive deeper where it matters.

Whether you're a start-up founder in Sydney, a finance manager at a mid-market firm in Melbourne, or an entrepreneur planning your next move, this guide will save you time and help you build the model that actually supports your decision.

The Decision Matrix: Which Model When?

Use the table below as your starting point. Find your primary decision type and business stage, then read the linked guide for that model.

1. Cash Flow Forecasting: The Foundation Model

Every business needs a cash flow forecast. It's the single most important financial model for SMEs because cash flow - not profit - determines survival.

A good cash flow forecast projects your cash inflows (receipts from customers, debt drawdowns, capital injections) and outflows (supplier payments, payroll, rent, tax, loan repayments) over a rolling period - typically 13 weeks or 12 months.

When to use it: You're managing working capital, approaching a seasonal peak, planning a major purchase, or concerned about your cash runway. Read our detailed guide on cash flow forecasting and the automated cash flow forecasting with Power Query walkthrough.

Watch out for: Cash flow forecasts often miss GST timing, supplier payment terms, and seasonal fluctuations. We see this constantly in our financial model audit work - small timing errors compound quickly.

2. Break-Even Analysis: Know Your Floor

Break-even analysis answers the most fundamental business question: how much do I need to sell to cover my costs? It separates fixed costs (rent, salaries, insurance) from variable costs (materials, commissions, delivery) and calculates the volume or revenue needed to reach zero profit.

When to use it: Launching a new product, entering a new market, considering a price change, or assessing the viability of a new venture.

Break-even is the fastest model you can build and often reveals uncomfortable truths - like that your new product line needs 40% more volume than you initially assumed. For pricing decisions, pair it with our pricing calculator guide for a fuller picture.

3. Three-Way Financial Models: The Gold Standard

If cash flow forecasting is the foundation, the 3-way financial model is the skyscraper. It integrates the profit and loss statement, balance sheet, and cash flow statement into a single, internally consistent framework.

Every change you make to revenue flows through to profit, working capital, debt, and cash automatically. This makes it the model type that banks, investors, and boards expect to see.

When to use it: You're raising capital, seeking bank finance, planning a strategic pivot, or running a business with more than $1M in revenue and significant working capital or debt.

Key design features:

• Driver-based assumptions (not hard-coded growth rates)
• Centralised assumptions sheet with scenario toggles
• Consistent timeline structure across all three statements
• Circular reference handling for debt and interest

The discipline of building a three-way model forces you to understand how your entire business model hangs together, which is why it's the first thing professional financial modellers build.

4. Pricing Calculators: Get Your Margins Right

Pricing is the highest-leverage decision most businesses make. A 5% price increase, if volume holds, can double your profit. But get it wrong and you lose customers to competitors.

A pricing calculator model breaks down your full cost-to-serve - direct materials, labour, overhead allocation, delivery, payment processing, and any post-sale support - and compares it against market pricing to show unit and gross margin.

When to use it: Setting initial prices, reviewing pricing annually, entering a tender, or introducing a new product line. For subscription or recurring revenue businesses, see our pricing for recurring business post.

Pro tip: Build scenario toggles for volume discounts, payment terms, and customer acquisition cost. Pair with sensitivity analysis to understand which pricing assumptions move the needle most.

5. DCF Valuation Models

Discounted Cash Flow (DCF) is the most theoretically sound approach to business valuation. It values a business based on its ability to generate future cash, discounted back to present value at an appropriate rate.

We walk through the entire process in our DCF valuation walkthrough. It covers free cash flow projection, terminal value calculation, discount rate selection, and sensitivity tables.

When to use it: Preparing for business sale, acquisition target evaluation, capital raising, or major investment decisions. DCF is also a key component of broader business valuation methods.

The DCF is not for:

• Early-stage start-ups with negative cash flow (terminal value dominates unrealistically)
• Businesses where you can't reasonably forecast 5+ years of cash flows
• Quick "ballpark" valuations (use multiples instead)

6. EBITDA Adjustments and Normalisation

Before any valuation model can produce meaningful results, the underlying earnings need to be "normalised." This means adjusting accounting profit to reflect the true sustainable earnings of the business.

Our EBITDA adjustments guide covers the most common adjustments: owner salary above or below market, one-off legal or advisory costs, personal expenses run through the business, non-recurring revenue, and related-party transactions.

When to use it: Always - no valuation is reliable without normalising earnings first. This is the first step in any business valuation process.

7. Lease vs Buy and Capital Investment Models

Should you lease that new excavator or buy it outright? Is the new ERP system worth the capital outlay? These questions need a capital investment model comparing the net present value (NPV) and internal rate of return (IRR) of each option.

Our lease vs buy analysis guide walks through building the comparison model in Excel, including tax treatment differences, residual values, and discount rate selection.

When to use it: Any significant capital expenditure (equipment, vehicles, property, software systems). Also useful for comparing financing options in project feasibility work.

8. Scenario and Sensitivity Analysis

No model is complete without understanding which assumptions matter most. Sensitivity analysis systematically varies key inputs - price, volume, cost of goods, interest rates - and measures the impact on your output.

Our posts on scenario analysis and sensitivity testing and Monte Carlo simulations cover everything from simple data tables to probabilistic modelling.

When to use it: Every model you build should include at least a simple sensitivity table showing the two or three most important drivers. For board presentations and investor reports, scenario analysis (base case / upside / downside) is expected.

9. Industry-Specific Models

Some decisions require specialised models:

Construction and trades: Project-based businesses need construction job costing models that track labour, materials, subcontractor costs, and variations against budget.

Property and real estate: Investors need rental property sensitivity analysis, and negative gearing calculators. Developers building townhouses or apartments should see our townhouse feasibility guide.

Services and consulting: Services capacity planning models that map headcount against utilisation and billable rates are essential for professional services firms.

Financial services: Portfolio managers use portfolio risk analysis models, while lenders rely on securing bank loans feasibility models.

Putting It All Together: A Decision Flow

Not sure where to start? Walk through these questions:

1. What decision are you making?

   • Cash management → Cash flow forecast
   • Pricing → Pricing calculator + break-even analysis
   • Investment → Lease vs buy or NPV model
   • Valuation → DCF + EBITDA adjustments + market multiples
   • Strategic planning → 3-way model with scenario analysis

2. Who needs to see the output?

   • Just you → Simple model is fine
   • Your management team → Add scenario analysis and driver-based assumptions
   • A bank or investor → Full 3-way model with audit trail

3. What's your time horizon?

   • < 12 months → Cash flow forecast
   • 1-3 years → Budget and forecast model
   • 3-5+ years → 3-way model, DCF for valuation

4. How complex is your business?

   • Single product, simple operations → Break-even + cash flow suffices
   • Multiple revenue streams, inventory, debt → Need a 3-way model
   • Multiple entities, consolidation, group structures → Professional-grade 3-way with audit

Common Mistakes to Avoid

Building too much model too early. A start-up doesn't need a 3-way model with 60-month projections. A simple cash flow forecast with break-even analysis is more useful at that stage.

Building too little model too late. If you're raising capital and you only have a cash flow forecast, you'll waste weeks rebuilding it as a 3-way model under investor pressure. Know what your audience needs.

Ignoring the audit. Every model should be checked for structural errors - broken links, circular references that won't converge, inconsistent time periods, hard-coded numbers embedded in formulas. Our financial model audit framework covers what to look for.

Not planning for updates. If your model takes two days to rebuild every time you change an assumption, it's not a model - it's a spreadsheet. Build for reusability from day one.

Further Reading

For a complete overview of this topic, see the Financial Modelling in Excel: The Complete Guide for Australian Businesses (2026).

Start Building the Right Model Today

Choosing the right financial model doesn't have to be overwhelming. Start with the decision matrix above, pick the model that matches your current decision, and build it step by step.