A financial model that drives a borrowing decision, a board approval or an acquisition price carries a lot of weight for a spreadsheet. When the model is wrong, the decision is wrong, and the error usually sits quietly in a formula or an assumption that nobody thought to challenge. An independent review exists to find those issues before a lender, board or investor does.

This guide explains what an independent financial model review actually covers, what it costs in Australia, and when it is worth commissioning one. It is written for SME owners, advisors and finance managers who have built, inherited or been handed a model and need to know whether it can be trusted.

Why Models Need an Independent Set of Eyes

Models fail in predictable ways. Formula errors compound quietly. Assumptions get typed over formulas. Scenarios are built but never tested. Circular references sit unresolved. The frustrating part is that the finished model looks fine. Totals add up, charts render and the formatting is immaculate.

The problem is that the author has been staring at the model for weeks. They know what each cell is supposed to do, so their eyes fill in the gaps. A reviewer who has never seen the model has no such advantage, and no such blind spot. They test what the model actually does, not what it was meant to do.

The second reason is accountability. When a model goes to a bank with the owner's name on it, the bank assumes it has been checked. An independent review provides a documented check that the assumptions are reasonable, the logic is sound and the outputs can be defended. If a lender later challenges a number, the response is not "we think it is right", it is "it was independently reviewed and here is what was tested."

What a Financial Model Review Actually Checks

A structured review works through a defined list rather than poking at the model at random. The core areas are consistent across reviewers, and they map to where models most often fail.

Formula Consistency

The reviewer samples or systematically tests formulas across the model, checking whether the same lines are calculated the same way in every column, whether any formulas have been overwritten, whether the formulas in the middle of a schedule match the formulas at the edges, and whether hard-coded numbers sit where formulas should be. Hard-coded inputs are the classic finding. Someone typed a number over a formula once, and the model has carried that frozen value through every subsequent month.

Circular References and Iteration

Circular references are common in models with debt and interest, where interest depends on the debt balance and the debt balance depends on interest. A controlled circular reference with iteration enabled is acceptable if it converges. An accidental circular reference, often created when someone links two cells that should not link, produces numbers that drift and cannot be traced. The reviewer identifies which circularities are intentional and which are faults.

Scenario and Sensitivity Integrity

If the model carries base, upside and downside scenarios, the reviewer tests that switching scenarios actually changes the right cells and leaves the rest untouched. A scenario selector that is wired to only half the model gives false comfort: management believes they are looking at the downside case when the revenue changed and the costs stayed on base.

Debt Schedule Logic

Debt schedules are where small errors become expensive. The reviewer checks drawdowns, repayments, interest calculations and covenant headroom against the facility terms, including whether repayments are calculated on the right balance, whether interest uses the right rate basis and day count, and whether the balances tie to the balance sheet.

Tie-Outs

The model's statements and schedules should agree. Net profit on the P&L should flow to the balance sheet and cash flow. The closing cash balance should match the cash flow statement. The reviewer runs the tie-outs and traces any difference to its source. Models that do not tie out internally cannot be trusted externally.

Assumption Reasonableness

The reviewer also challenges the assumptions, not just the formulas. Is the growth rate consistent with the market? Does the margin reflect the business's actual cost structure? Are the tax and superannuation rates current for Australia? This step is what separates a technical check from a review that protects the decision.

A Typical Findings List

The output of a review is usually a table of findings ranked by severity. A typical list for an SME three-way model might look like this:

The table format matters because it makes the review actionable. The owner can see at a glance which findings change the decision, which need a fix before the model goes to the lender, and which are hygiene for the next version. A review that only says "the model looks broadly fine" has not done its job.

How a Review Works in Practice

A typical review starts with the reviewer receiving the model and any supporting documents, including the business case, the term sheet, prior versions and the assumptions documentation if one exists.

The reviewer then runs a structured testing process. In Excel this includes formula auditing tools, tracing precedents and dependents, testing scenario switches, and running the model with extreme inputs to see where it breaks. A model that returns a sensible answer when volume is set to zero, and an absurd one when price is doubled, tells the reviewer where the logic is fragile.

The output is a findings report, usually ranked by severity. Critical findings are errors that change the decision. Major findings are issues that could change it under plausible conditions. Minor findings are hygiene problems such as inconsistent formatting, undocumented assumptions and missing labels. Each finding includes where it is in the model, what the impact is, and what the fix should be.

Some reviewers will fix the issues as part of the engagement; others report and leave the fixing to the model owner. The choice depends on whether the owner wants to learn the fix and keep control of the model, or simply wants it correct.

What It Costs in Australia

Pricing for model reviews varies widely, and the spread reflects real differences in scope rather than price gouging.

A light review of a single-sheet operating budget or a simple cash flow projection, focused on the highest-risk formulas and tie-outs, might start in the low thousands of dollars. A full review of a three-way model with debt schedules, tax and multiple scenarios typically runs higher, and a complex project finance or acquisition model with formal documentation costs more again.

The main cost drivers are the number of sheets and formulas, the presence of debt and tax logic, the quality of the model's existing documentation, and whether the review is a check or a formal audit with sign-off. A messy, undocumented model costs more to review because the reviewer must first work out what the model is doing before testing whether it does it correctly.

The frame that matters is economic. If the model supports a decision worth hundreds of thousands or millions of dollars, the review cost is a rounding error on the downside it protects against. The cheapest review is the one that finds the error before the lender does.

When to Commission a Review

Four situations justify an independent review more than any others.

The first is a bank or lender submission. Lenders run their own credit analysis, but a reviewed model signals that the borrower's numbers have been tested. It shortens the conversation and reduces the chance of a request being declined on credibility grounds.

The second is a board or investor decision. Directors who approve a capital spend or an acquisition on the back of an unreviewed model carry personal exposure. A review gives the board a documented basis for the decision and the directors a defence if the numbers are later challenged.

The third is a major transaction, such as buying a business, raising capital or committing to a large project. The model sets the price or the commitment, so an error in the model is an error in the price.

The fourth is handover. When the person who built the model leaves, or an inherited spreadsheet becomes the basis for planning, an independent review establishes whether the model is worth keeping or should be rebuilt. It is often cheaper to review and repair a sound model than to rebuild from scratch.

Preparing Your Model for Review

A review runs faster, and costs less, when the model is ready for it. The habits that make a model reviewable are the same habits that make it reliable.

Keep assumptions on a dedicated sheet with one input per cell, clearly labelled. Use consistent colour conventions for inputs, calculations and outputs. Document the model with a notes sheet covering purpose, version, key assumptions and known limitations. Avoid hard-coding numbers inside formulas, and avoid merging cells inside calculation ranges. Use named ranges and Excel tables where they reduce error, and keep the model's file version and change history recorded.

A model with these habits can be reviewed quickly because the reviewer can see what it does. A model without them costs more to review because the reviewer must reverse-engineer it first, and the findings list will be longer.

The other side of preparation is knowing what the model is for. A review is only meaningful against the decision the model supports. If the model is a cash flow forecast for a loan application, the reviewer needs the facility terms, the repayment schedule and the lender's key ratios. If it is a pricing model for a business sale, they need the valuation approach and the transaction structure. Sending the model alone invites a generic review; sending the model with its decision context invites one that protects the actual decision.

A useful pre-review checklist runs in a set order. Confirm the model version is the one going to the lender or board. Export or copy the assumptions sheet to a readable format. List any known shortcuts or workarounds in the model, and note the decisions the model is expected to support. That short package lets the reviewer spend their time on the model rather than on reconstructing its purpose.

The Limits of a Review

A review tests what is in the model. It cannot guarantee the future. The assumptions can be internally consistent and completely wrong, because markets move and businesses change. What a review does is separate the model's mechanics from its assumptions, so the decision-maker knows which risk is which. One risk is that the model is built wrong, and that is the risk a review addresses. The other is that the assumptions prove optimistic, and that is a business judgment the owners must own.

Reviews also do not replace good modelling. A model built without discipline, then reviewed and patched, is still weaker than a model built properly and reviewed as a final check. The review is the quality gate, not the quality system.

Conclusion

An independent financial model review is a structured check that the numbers a decision rests on can be trusted. It tests formula consistency, circular references, scenario integrity, debt logic and tie-outs, challenges the assumptions, and reports what it finds in terms a decision-maker can act on.

For an Australian SME borrowing money, taking a decision to the board, or buying or selling a business, the review is cheap relative to the downside it protects against. The models that most need reviewing are the ones that look the most polished, because polish is not the same as correctness. An independent set of eyes is the difference between hoping the model is right and knowing what was tested.

Related reading

• Financial Model Audit: Ensuring Decision-Grade Numbers
• 10 Common Financial Modelling Mistakes
• Financial Modelling Best Practices in Excel