Financial model review
Common financial model errors explained
Understand common Excel and financial model errors, from broken references and workbook links to cash-flow and balance-sheet checks that need manual review.

A financial model can contain a visible Excel error, an unintended formula, or a financial assumption that simply does not make sense. These are different problems. Start with the visible calculation errors, then review links and assumptions, and finally check whether the financial statements tell a consistent story.
FinModelCheck inspects a saved XLSX without recalculating Excel. Its score and error counts are a starting point for review. A high score does not establish that the forecasts or financial statements are correct.
Excel errors you may see
Division by zero: #DIV/0!
The formula divides by a value that is zero or empty. For example, revenue per customer cannot be calculated when the customer count is zero. Check the denominator and decide whether the missing result is expected. Avoid replacing it with zero just to hide the warning.
Checker coverage: a supported saved Excel error is counted as division by zero. The checker does not evaluate every division formula or prove what Excel would calculate now.
Broken reference: #REF!
A formula refers to a cell or range that is no longer valid. This often happens after deleting part of a workbook. Trace the intended source before replacing the reference. A formula can also refer to a worksheet that no longer exists.
Checker coverage: supported broken-reference tokens, saved reference errors and ordinary references to missing local worksheets. Guarded formulas can contain an unused broken branch, so inspect the formula before changing it.
Missing value: #N/A
A lookup may not have found its requested item. Check for a missing identifier, an inconsistent spelling or an incomplete source table. Some models deliberately use NA() to mark unavailable data; that is different from an unintended lookup failure.
Checker coverage: supported saved #N/A results are counted separately. The checker cannot decide whether a missing value was intentional.
Wrong value type: #VALUE!
A formula may receive text where it expects a number, or arguments that do not fit the operation. Review imported inputs and the formula's expected data types.
Checker coverage: supported saved #VALUE! results. The underlying input problem needs investigation in Excel.
Unrecognized name: #NAME?
Excel cannot recognize part of a formula, such as a misspelled function or an undefined name. Check the spelling and whether the workbook requires a function unavailable in the Excel version being used.
Checker coverage: supported saved #NAME? results; no claim that every named range or function has been resolved.
Invalid number or range: #NUM! and #NULL!
#NUM! can indicate an invalid numerical argument or a calculation that cannot produce the required result. #NULL! can indicate an invalid intersection of ranges. Review the formula and its inputs rather than guessing a replacement.
Checker coverage: supported saved errors are counted by their individual type. Newer errors and unsupported spreadsheet features may be reported as coverage limits instead.
Microsoft's guide to broken formulas explains common Excel error messages and how to investigate them. Our saved-error guide gives worked examples.
For product costs, exchange rates and reporting codes, also review the lookup key and matching method. A missing identifier may show #N/A, while a wrong approximate match or duplicate can return an ordinary number from an unintended row.
Links and assumptions that deserve a closer look
Links to another workbook or external source
A forecast may depend on an input file outside the uploaded workbook. If that file moves or becomes unavailable, refreshing the model can change or fail. Record which files supply the model and who maintains them. A legitimate external link is a dependency, not automatically an error.
Checker coverage: supported formula references to other workbooks and external-link metadata. The checker does not contact source files, refresh links or validate web queries and every other external data connection.
See the external workbook guide and Microsoft's workbook link management guide.
Numbers entered directly in formulas
In =Revenue*0.21, the number 0.21 is hidden inside the calculation. If it represents an assumption such as a tax rate, a clearly labelled input cell may make the model easier to maintain. A unit conversion or deliberate constant can be perfectly appropriate.
Checker coverage: supported numeric factors and divisors are flagged for review. These advisories carry no score penalty because the checker does not know their business purpose. See the embedded-assumption guide.
Inconsistent formulas and overwritten calculations
A single cell in a monthly forecast may use a different formula, or contain a typed value where the surrounding periods use formulas. Check that the difference has a reason. A yearly subtotal and a one-off opening balance can legitimately differ from nearby cells.
Checker coverage: automatic formula-pattern and overwritten-formula detection are not part of the current checker. Review these manually in Excel.
A valid total can also include rows that the report currently hides, or include both a detail row and its subtotal. Follow the hidden rows, filters and totals review to establish which records a financial report is intended to include. This is a manual review of reporting scope.
Financial checks to perform manually
A balance sheet that does not balance
Assets should equal liabilities plus equity for the same reporting date and under a consistent sign convention. Create a visible reconciliation row and investigate a non-zero difference. Possible causes include omitted opening balances, retained earnings that do not roll forward, or a transaction recorded on only one side.
Checker coverage: not checked automatically. The checker does not identify financial statement layouts or decide which rows represent assets, liabilities and equity.
Cash flow that does not reconcile
Opening cash plus the net cash movement should agree with closing cash when periods, scope and signs match. Review working capital, financing and non-cash adjustments if the cash flow statement disagrees with the balance sheet.
Checker coverage: not checked automatically. A correct-looking spreadsheet formula does not establish a correct cash flow reconciliation.
Wrong units, signs or periods
Mixing euros with thousands of euros, monthly rates with annual rates, or positive expense inputs with negative expense formulas can produce a plausible-looking wrong result. Label units and periods, and check the direction of important movements.
Checker coverage: financial units, sign conventions and period alignment require manual review.
Use the financial model date checks to inspect real date values, month-end sequences and the period receiving each cash movement. A correct annual total can still conceal a receipt assigned to the wrong month.
Small reconciliation differences also need an explanation. The rounding and precision guide shows how displayed rows can differ from their underlying total and how to investigate a tolerance in the correct units. These are manual checks, not automatic analyzer Findings.
Circular logic and unrealistic assumptions
Debt, interest and cash can refer back to each other; some models handle this intentionally with iterative calculation. An aggressive growth rate or an implausible margin can also make a technically valid model unusable for a decision.
Checker coverage: circularity, forecast plausibility and business assumptions are not evaluated by the current checker.
A simple review order
- Resolve unexpected visible Excel errors and missing references.
- Confirm that external inputs are available and belong to the intended model version.
- Review assumptions and formulas that differ across periods.
- Reconcile the balance sheet and cash flow, then check units and signs.
- Test a few changes to important assumptions and inspect the resulting movements.
Keep an unchanged original and save corrections as a separate file. Use the example workbook and report to see how the checker presents its results, or check your own workbook.


