Financial Model Audit for Corporate Finance

What Is a Financial Model Audit?

A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.

Corporate Financial Modelling

Corporate financial modelling is the discipline of building financial models for operating companies — as distinct from a single asset, project, or development. Nearly every corporate model type is built on the same foundation, a fully integrated three-statement structure, and then specializes that foundation toward a specific purpose: a budget model constrains it to a fixed annual period, a driver-based model rebuilds it from operational units rather than percentage growth, a consolidation model extends it across multiple legal entities and currencies, a management reporting model extracts and re-presents its outputs as KPIs, and a transaction model (a merger model, an LBO) repurposes it to answer a specific capital-structure or ownership-change question. This page is the hub for the Knowledge Centre's corporate financial modelling content: the shared three-statement foundation, how each model type specializes it, and where each mechanic is covered in full technical depth elsewhere on this platform.

Financial Modelling Best Practices for Corporate Finance

Corporate finance models, covering budgeting, forecasting, and capital allocation across operating companies, are built around an integrated three-statement structure: income statement, balance sheet, and cash flow statement, linked so that a change in one assumption flows correctly through all three. This page sets out how such a model should be constructed: building the three-statement linkage and balance-sheet plug correctly, scheduling working capital and capex/depreciation consistently, and matching model depth to materiality. It also scopes capex-heavy industrial and manufacturing corporate models, which share this structure with an emphasis on capacity utilisation and fixed-asset scheduling. It addresses the construction question as a discipline applied while the model is built, distinct from the audit-risk perspective covered on Financial Model Auditing.

Spreadsheet Review vs Model Audit

"Spreadsheet review" is one of the loosest, least defined terms in this field. It can mean anything from a five minute visual check to something close to a full audit, and that ambiguity causes real scope confusion when it appears in an engagement letter or an internal request. This page draws a clear line between an informal spreadsheet review and a formally scoped financial model audit, so that anyone specifying either term knows exactly what they are asking for.

Consolidation Model Structure

A consolidation model combines multiple legal entities' individually correct financial statements into a single group result, and requires three mechanics a single-entity three-statement model does not need: intercompany elimination, removing transactions between group entities so they do not double-count; non-controlling interest allocation, splitting a partially-owned subsidiary's results between the parent and minority shareholders; and currency translation, converting foreign-entity statements into the group's presentation currency. This guide covers how each mechanic should be structured, the standard consolidation worksheet layout, and the most common consolidation errors — most of which originate in an incomplete elimination rather than any individual entity's own statements being wrong.

Merger Model and Accretion/Dilution Structure

A merger model tests whether a proposed acquisition increases or decreases the acquirer's earnings per share — the accretion/dilution result — by combining standalone projections for the acquirer and target with the mechanics specific to the transaction itself: purchase price allocation and the resulting goodwill, the financing structure (cash, new debt, or newly issued stock, in any combination), and any synergies expected from the combination. This guide covers the build sequence in full: standalone projections first, then purchase price allocation, then the financing structure and its effect on pro-forma shares and interest expense, then synergies traced to specific line items rather than a single aggregate assumption, and finally the accretion/dilution calculation itself, with the structural checks that catch the errors most specific to this model type.

Management Reporting and KPI Dashboard Model Structure

A management reporting or KPI dashboard model is not a separate calculation engine — it is a presentation layer that extracts, re-derives, and re-presents figures already produced by an underlying three-statement model. This guide covers how that layer should be structured: every dashboard figure formula-linked back to its source in the underlying model rather than re-keyed or pasted, KPIs defined once with a documented formula rather than calculated inconsistently across different reports, and a clear separation between the calculation engine (where figures are produced) and the reporting layer (where they are selected, formatted, and presented) so that a change to the underlying model flows through to every report automatically.

Three-Statement Model

A three-statement model is a financial model in which the income statement, balance sheet, and cash flow statement are dynamically linked into a single integrated system, so that a change in any assumption flows through correctly to all three, and the balance sheet balances in every forecast period as a direct consequence of that linkage rather than as a plug engineered to force it. It is the structural foundation most other financial models — DCF, LBO, project finance — are built on top of.