Financial model review
Financial model formula checks in Excel
Review formulas in a monthly Excel financial forecast. Use worked examples to check copied references, overwritten calculations and incomplete subtotal ranges.

A forecast can show reasonable numbers while using the wrong formulas. A copied reference may point to a blank input, a typed value may replace a calculation, or a total may omit the last month. These problems do not necessarily produce an Excel error message. Review how a number was calculated, not only whether it looks plausible.
Start with one important row, such as revenue, and follow its calculation across the forecast. The examples below are invented, simplified monthly figures, not a recommended forecast or pricing assumption.
Work through one revenue calculation
Suppose Forecast uses columns B, C and D for January, February and March. Row 4 holds units sold: 100, 120 and 140. The unit price is EUR 25 in Inputs!B2. Row 5 calculates revenue, using:
=B4*Inputs!$B$2
January revenue should be EUR 2,500. Copying the formula one column right should produce =C4*Inputs!$B$2, giving February revenue of EUR 3,000. March should be EUR 3,500. The three-month total is EUR 9,000.
Two different movements are intentional: the units reference follows the month, while the price stays in its original cell. Write down that expectation before comparing formulas. A model with monthly prices might legitimately require the price reference to move too.
Check what moves when a formula is copied
A relative reference such as B4 changes when copied. An absolute reference such as $B$2 keeps both its row and column fixed. Mixed references lock only one: $B2 fixes the column, while B$2 fixes the row. Microsoft explains these behaviors in its reference guide.
If the January formula instead uses =B4*Inputs!B2, copying it right points February at Inputs!C2. A blank or unrelated value there could give an unintended result without an obvious broken-reference error.
Inspect January, one middle month and the final month in the formula bar. Compare the relationships rather than expecting identical text: B4, C4 and D4 are different references serving the same monthly role. Check fixed inputs separately. Do not replace every reference with dollar signs; that could make every month use January's units.
Find typed values in calculation rows
Imagine February revenue displays EUR 3,000, but its cell contains the typed number 3000. It agrees with the example today, yet changing February units to 130 should make revenue EUR 3,250. The typed number would stay unchanged.
In desktop Excel, use Formulas > Show Formulas to inspect the sheet's calculations. Choose the command again to return to results. Microsoft's Show Formulas documentation explains the view.
For a defined calculation range in Excel for Windows, select the range, press Ctrl+G, select Special, then Constants. Inspect the selected cells for unexpected typed values. You can instead choose Formulas to see which cells contain calculations. Microsoft documents these selections in its Go To Special guide.
A constant is only a lead for review. Historical actuals, opening balances and approved one-off adjustments may belong in the model. Establish what the row is supposed to contain before changing a cell.
Inspect the first and last cells in each subtotal
For the invented three-month forecast, =SUM(B5:D5) includes all three revenue cells. =SUM(B5:C5) returns EUR 5,500 and omits March's EUR 3,500. Both are valid formulas; only the model's intended period tells you which total is appropriate.
Check range endpoints against the period headings and row labels. Also look for totals that include another subtotal, causing double counting. Blank spacer rows or newly added months deserve particular attention. Microsoft's SUM guide explains range behavior, including why an addition outside the referenced range is not automatically covered.
For a total whose visible rows seem inconsistent, also inspect the hidden rows and subtotal rules. SUM, SUBTOTAL and the report's filter state can represent different scopes even when every formula is syntactically valid.
Follow the inputs and affected outputs
Select a revenue formula and use Formulas > Formula Auditing > Trace Precedents to inspect its inputs. Select the price input and use Trace Dependents to inspect formulas that reference it. Follow a key calculation to an output such as operating profit rather than stopping at revenue.
These commands help investigate cell relationships; they do not prove business logic. Some references cannot be traced, and another referenced workbook must be open for tracing its cells. See Microsoft's formula-relationship guide. Menu availability varies by Excel version.
A repeatable review checklist
- Keep an unchanged original and work on a separate copy.
- Identify the row's meaning, units, periods and expected calculation.
- Compare references in the first, middle and last forecast periods.
- Inspect unexpected constants and formula changes before correcting them.
- Check the endpoints of monthly and yearly subtotal ranges.
- Change one input in the copy, predict the expected result and inspect affected outputs. Restore the input afterward.
Where the checker fits
FinModelCheck currently reports supported saved Excel errors, broken references, external workbook links and embedded numeric coefficients. It does not automatically detect formula inconsistency, overwritten formulas, omitted subtotal ranges or financial unit, sign and period logic. It does not reconcile financial statements or recalculate Excel.
Use the checker for the supported saved-evidence checks, then download the free detailed PDF in your current valid browser session, without registration. The example shows its format. Continue manual review with our units, signs and periods guide, and use the saved-error guide when Excel displays an error.


