Corporate Financial Modelling

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.

Corporate Finance and Capital Structure

Corporate finance and capital structure is the set of decisions a company makes about how to fund itself — the mix of debt and equity it carries, the blended return it must earn to satisfy both groups of capital providers, and how it returns surplus cash to shareholders once those obligations are met. These decisions are not made once and left alone: capital structure is actively managed against a trade-off between the tax and discipline benefits of debt and the real costs of financial distress, cost of capital sets the hurdle every investment decision is measured against, and dividend policy and share buybacks are the two channels through which excess cash returns to owners. This page is the hub for the Knowledge Centre's corporate finance and capital structure content: the debt-vs-equity financing decision, Modigliani-Miller's capital structure theory and its real-world violations, cost of capital as a capital-allocation hurdle rate, dividend policy and buybacks, the credit metrics lenders and rating agencies use to assess leverage capacity, and covenant analysis as the contractual mechanism through which lenders constrain capital structure after financing is in place.

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.

Statement Linking Mechanics

Statement linking mechanics are the specific formulas and connections that turn three independently understandable statements into one integrated three-statement model. This guide walks through each linkage step by step: net income flowing to retained earnings and to the top of the cash flow statement, the sign conventions that govern working-capital adjustments, capex and debt movements connecting the statements, and the final ending-cash-to-balance-sheet tie-out that confirms the whole structure holds together. It closes with the specific linking errors most responsible for an out-of-balance model.

Working Capital Schedule

A working capital schedule is the section of a financial model that calculates the period-by-period movements in a company's or project's net current assets — the difference between current assets (principally trade receivables) and current liabilities (principally trade payables and accrued liabilities). It translates revenue and cost accruals from the income statement into actual cash flows by capturing the timing difference between when economic activity is recognised and when cash is received or paid. Working capital is defined as: The working capital schedule calculates the change in net working capital in each period, which is a cash flow adjustment in the cash flow statement: - An increase in net working capital is a cash outflow (cash is being absorbed into receivables or inventory) - A decrease in net working capital is a cash inflow (cash is being released from payables or receivables)

Capital Expenditure

Capital expenditure (capex) is cash spent acquiring, upgrading, or extending the useful life of a fixed asset — property, plant, and equipment. In a financial model, capex is the investing outflow that increases gross fixed assets on the balance sheet, and the resulting depreciation schedule allocates that cost across the asset's useful life as a charge against the income statement. Capex is commonly split into maintenance capex (sustaining the existing asset base) and growth capex (expanding it), a distinction that matters directly for free cash flow and returns analysis.

Depreciation Schedule

A depreciation schedule in a financial model is a systematic calculation of the periodic reduction in the carrying value of a fixed asset over its useful economic life. The depreciation charge is expensed through the income statement each period, reducing EBITDA to operating profit (EBIT) and creating a non-cash charge that reduces taxable income. Two principal methods are used in financial models: straight-line depreciation (equal charge in each period) and reducing balance (declining charge in each period). The depreciation schedule feeds into three key statements: the income statement (depreciation charge), the balance sheet (net book value of assets), and the cash flow statement (depreciation added back as a non-cash item).

Debt Schedule

A debt schedule is the section of a financial model that tracks the periodic movement of a company's debt balances — drawdowns, scheduled and optional repayments, and the resulting interest expense — from an opening balance to a closing balance each period. It is the mechanism connecting the balance sheet's debt balance to the income statement's interest expense and the cash flow statement's financing section. This entry covers the generic corporate debt schedule; for the DSCR-driven repayment profiling used in project finance, see Debt Sculpting Mechanics.

How to Build a Debt Schedule

Building a debt schedule correctly means rolling each debt tranche forward from an opening balance through drawdowns and repayments to a closing balance, calculating interest expense on a consistent and disclosed basis, and connecting the result to all three financial statements. This guide walks through the build step by step: listing the tranches, the roll-forward mechanics, distinguishing mandatory amortization from optional cash-sweep repayment, using a revolving facility as the model's balancing mechanic, and the interest circularity that average-balance calculations introduce, along with the two standard techniques for resolving it.

How to Build an Equity Schedule

An equity schedule rolls forward each component of shareholders' equity — common stock and additional paid-in capital, treasury stock, and retained earnings — from an opening balance through the period's activity to a closing balance, and separately tracks the diluted share count used in per-share calculations. This guide walks through each component step by step: the common stock and APIC roll- forward, treasury stock from buybacks, the retained earnings roll-forward connecting to net income and dividends, and the diluted share count roll-forward reflecting new issuances, buybacks, and option exercises.

Revenue Forecasting Methods

Revenue can be forecast using several structurally different methods, and the choice of method has a direct effect on how defensible and auditable the resulting forecast is. This guide sets out the four principal methods used in institutional financial models — top-down forecasting from market size and share, bottom-up forecasting from unit economics, trend and growth-rate extrapolation from historical results, and cohort-based forecasting for subscription and other recurring-revenue businesses — with guidance on when each method is appropriate and how the methods can be combined within a single forecast.

Cost Forecasting Methods

Costs cannot be forecast reliably using a single blanket method, because different cost lines behave differently as a business scales. This guide sets out the classification step that should precede any cost forecast — separating fixed from variable costs — followed by the three principal construction methods used in institutional financial models: the percent-of-revenue method for costs that scale proportionally with revenue, driver-based opex build-up for costs tied to a specific operational driver other than revenue, and cost of goods sold construction for the direct costs attributable to production. It is the companion guide to Revenue Forecasting Methods, covering the cost side of the same forecast.

Forecast Driver

A forecast driver is a labelled input cell, most commonly a growth rate, a margin percentage, a unit count, or a price, that a forecast formula references rather than embeds directly. It is the structural unit that makes a forecast auditable and sensitizable, because changing the driver cell changes every downstream calculation that depends on it, consistently and traceably. A forecast driver is structurally distinct from a hardcode, a value typed directly into a calculation cell with no traceable source, even where the two produce an identical output in a given period.

Rolling Forecast

A rolling forecast is a forecast structure that maintains a constant forward-looking horizon — for example, always the next twelve months — and is updated on a regular cadence, commonly monthly or quarterly, rather than resetting to a fixed calendar or fiscal period once per year. As each period closes, the horizon rolls forward by the same interval, so the forecast always looks the same distance ahead regardless of the current date. It stands in contrast to a static annual budget, which is set once and covers a fixed period.

Budget vs Forecast — What's the Difference?

A budget and a forecast are frequently used as if they were interchangeable terms, and treating them that way obscures a governance distinction that matters to how each is actually used. A budget is a fixed, formally approved plan, typically set once per year, used as a performance benchmark against which actual results are measured. A forecast is a forward-looking estimate that is updated frequently as new information arrives, and it is not used as a fixed target. Both are legitimate, complementary tools, and most organizations of any size run both together rather than choosing one over the other.

Budget Model Structure

A budget model is built on the same three-statement mechanics as any other corporate forecast, but its defining discipline is governance rather than formulas: a fixed period, an assumption freeze once the budget is approved, and a variance-tracking structure that compares actuals against that unchanging baseline throughout the period. This guide covers how to structure a budget model correctly — top-down and bottom-up build methods and when each is appropriate, the assumption freeze and formal change-control process that distinguishes a budget from a forecast, and how the variance schedule should be built so that a variance is explained by its driver, not just its size.

Driver-Based Model Structure

A driver-based model forecasts each line from an operational unit — units sold, headcount, price per unit, capacity utilization — rather than a percentage growth rate applied to a prior period. This guide covers how to structure a driver-based build: selecting the right driver for a given revenue or cost line, separating volume drivers from price/rate drivers so each can be sensitized independently, building a driver tree that shows how granular drivers roll up into the income statement, and why this structure is materially more auditable than a blended growth-rate shortcut even where the two produce a similar headline result in the base case.

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.

Intercompany Elimination

Intercompany elimination is the process of removing transactions between entities within the same consolidated group — intercompany sales and purchases, loans and associated interest, dividends, and unrealized profit sitting in inventory transferred between group entities but not yet sold externally — from the consolidated financial statements. Each individual entity correctly records these transactions on its own books, but from the group's perspective they are internal movements, not external economic activity, and including them would double-count revenue, cost, and balance sheet items that never left the group.

Non-Controlling Interest

Non-controlling interest (also called minority interest) is the portion of a partially-owned subsidiary's net income and equity attributable to shareholders other than the parent company. Where a parent consolidates a subsidiary it does not own 100% of, the subsidiary's full financial statements are still combined into the group result, and non-controlling interest is the mechanism that then allocates the correct share of that combined income and equity to the minority shareholders who actually own the remaining stake.

Budget Variance Analysis

Budget variance analysis is the process of comparing actual financial performance against a fixed budget baseline and decomposing any material difference into its underlying components — a price variance, a volume variance, a mix variance, or a timing variance — rather than reporting only the net dollar or percentage gap between actual and budget. Decomposing a variance this way identifies what actually drove the difference and, because each component implies a different management response, is what makes variance analysis useful for decision-making rather than simply descriptive.

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.

Business Unit and Segment Model Structure

A business unit or segment model extends the standard three-statement foundation across more than one internal operating unit within a single legal entity, requiring two mechanics a single-unit model does not need: a defined, consistently applied method for allocating shared corporate overhead across units, and a reconciliation ensuring the sum of segment-level results ties exactly to the group total. This guide covers how to structure each unit's own detail before allocation, the common overhead allocation methods and when each is appropriate, and how to build the reconciliation that catches an allocation or roll-up error before it reaches a report.

Key Performance Indicator (KPI)

A key performance indicator (KPI) is a defined metric selected to track performance against a specific business objective, calculated with a single documented formula and data source, and tracked consistently across reporting periods so that period-over-period comparison reflects an actual change in performance rather than a change in how the metric was calculated. In a financial model, a KPI should be formula-linked to its source data rather than re-keyed each period, and its formula should be maintained in one location and referenced consistently wherever it is reported.

Contribution Margin

Contribution margin is revenue less directly attributable variable cost, calculated before any shared corporate overhead is allocated. It measures the amount a unit, product, or segment's own sales activity contributes toward covering shared fixed costs and, beyond that, toward group profit — distinct from a fully allocated profit figure, which also deducts a share of overhead the unit's own management typically does not control.

Board Reporting Model Checklist

This checklist covers what should be verified in a financial model before its outputs are used in a board reporting pack. It focuses on traceability of board-facing figures back to source data, consistency with prior board reporting periods, and clear disclosure of variances and their drivers. It is intended for CFOs, finance teams preparing board materials, and boards themselves as a basis for questioning the figures they are presented with.

Scenario Planning for Forecasting

Building a base, upside, and downside case is a planning and governance process, distinct from the Excel mechanics used to implement a scenario switch. This guide covers that process: how to define a coherent set of driver changes for each case, how to govern which assumptions are allowed to move between cases and by how much, how to document the rationale behind each case so it can be defended to a reviewer, and how the process relates to the underlying switch-cell mechanism that makes the resulting cases operable inside the model.

Sensitivity Analysis

Sensitivity analysis is the quantitative assessment of how much a financial model's output changes when a single input variable is changed by a defined amount, while all other variables are held at their base case values. It measures the responsiveness — or sensitivity — of outputs to individual assumption changes. Sensitivity analysis is distinct from scenario analysis, which changes multiple assumptions simultaneously to reflect a coherent alternative state. Sensitivity analysis isolates the effect of individual variables; scenario analysis tests the combined effect of assumption sets.

Forecast Model Build Checklist

This checklist sets out the construction-time checks a model builder should apply while building a financial forecast, covering the areas most commonly responsible for a forecast that looks complete but is not structurally reliable. It checks that every forecast line traces to a labelled driver, that the assumptions tab is complete and sensitizable, that any scenario switch is documented and does not silently break dependent formulas, that drivers are applied consistently period-over-period, and, where relevant, that a rolling forecast's cadence and version control are clear. It is a builder's self-check, applied during construction, complementary to the DCF-specific Forecast Assumptions & Driver Checklist.

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.

Capital Allocation Model Structure

A capital allocation model ranks the competing uses of a company's available free cash flow — reinvestment in the business, debt paydown, dividends, share buybacks, and acquisitions — against a common hurdle rate, and builds an explicit waterfall showing how each dollar of available capital is actually deployed across those uses in priority order. This guide covers how to structure that ranking and waterfall: measuring each use's return against the same cost-of-capital hurdle, building the priority waterfall as an explicit, traceable calculation rather than a set of independent, unreconciled decisions, and reconciling the total capital deployed back to the free cash flow actually available in the period.

Treasury Model Structure

A treasury model forecasts a company's cash and liquidity position at a shorter horizon and finer granularity than the three-statement model it draws from, and adds mechanics the standard forecast does not need: a rolling daily or weekly cash position, cash pooling and intercompany funding between group entities, headroom against committed facilities, and FX and interest rate exposure on non-functional- currency cash and debt balances. This guide covers how to structure the cash position build, how cash pooling and intercompany loans should be modelled without double-counting group cash, how to size facility headroom against a minimum liquidity buffer, and how FX and interest rate exposure are surfaced without duplicating the debt schedule's own mechanics.

Strategic Planning Model Structure

A strategic planning model projects a company's financial position over a multi-year horizon, typically three to five years, to test whether a set of strategic choices — market entry, capacity expansion, an acquisition programme, a shift in capital allocation policy — is financially achievable and what capital and financing it would require. This guide covers how a strategic plan differs structurally from a budget (single fixed year, high assumption precision) and a rolling forecast (short window, updated every cycle), how to frame the plan around a small number of strategic scenarios rather than a single base case, the appropriate level of granularity for a multi-year horizon, and how the plan links into the capital allocation model that governs how the resulting cash is actually deployed.

Covenant Analysis and Headroom

Covenant analysis is the process of assessing how much buffer, or headroom, a borrower has against the financial covenant thresholds specified in its loan agreement, and how that headroom is expected to evolve over the life of the financing. Financial covenants generally fall into three categories — leverage covenants, coverage covenants, and minimum liquidity covenants — each tested periodically through a compliance-certificate process in which the borrower calculates and certifies the relevant metric against the applicable threshold. Covenant headroom, not simply a pass/fail compliance result, is the metric that matters most to both borrowers and lenders, because thin or narrowing headroom signals reduced financing flexibility and elevated risk of a technical default well before an actual breach occurs.

Purchase Price Allocation

Purchase price allocation (PPA) is the process, required under both IFRS and US GAAP acquisition accounting, of allocating the price paid for an acquired business between its identifiable net assets, recorded at fair value as of the acquisition date, and goodwill, the residual representing value the acquirer paid beyond those identifiable assets. The allocation directly determines the combined entity's post-transaction depreciation and amortization, since revalued tangible assets and newly recognized intangible assets each carry their own schedule going forward, distinct from goodwill, which is not amortized but is tested periodically for impairment.

Synergies

Synergies are the cost savings or revenue benefits a combined entity is expected to achieve that neither the acquirer nor the target could achieve standalone — eliminating a duplicated corporate function, negotiating better procurement terms at greater combined scale, or cross-selling one company's products through the other's customer base. In a merger model, synergies should be traced to specific, named drivers and phased in over a stated, realistic timeline rather than entered as a single aggregate addition to combined EBITDA, since an untraceable synergy figure is one of the most common ways a deal's headline accretion is overstated.

Accretion/Dilution

Accretion/dilution analysis compares an acquirer's pro-forma (post-transaction, combined) earnings per share against its standalone (pre-transaction) earnings per share to determine whether a proposed acquisition would increase (accretive) or decrease (dilutive) the acquirer's EPS. It is the headline output of a merger model, and depends on the combined entity's pro-forma net income (driven by both companies' standalone earnings, synergies, and incremental depreciation and interest from the deal itself) and the pro-forma diluted share count (driven by the financing mix).

How to Build an LBO Valuation

Building an LBO-implied valuation requires constructing a full leveraged buyout model and solving it backward for the entry price consistent with a target return. This guide walks through the build in order — the sources and uses of funds, the opening debt and equity structure, the debt paydown mechanics over the hold period, the exit multiple assumption, and the final step of solving for the maximum entry price at a target IRR or multiple of money — along with the structural checks that confirm the model is internally consistent and the resulting entry price is defensible.

LBO Valuation

LBO-implied valuation derives the maximum price a financial sponsor could pay for a target and still achieve a target internal rate of return or multiple of money at a defined exit, given an assumed capital structure and debt paydown schedule over the hold period. Unlike DCF, comparable company analysis, or asset-based valuation, which each build a value estimate forward from cash flows, market multiples, or assets, LBO valuation works backward from a required return — it is properly understood as an implied-value technique used alongside the three classical valuation approaches in a private equity context, not as a substitute for them.

Acquisition Model Checklist

This checklist covers the structural checks specific to acquisition and M&A models, on top of the general financial model audit baseline. It focuses on the mechanics unique to deal models — synergy assumption traceability, purchase price allocation, debt and equity funding structures, and consistency between standalone and pro-forma combined entity figures. It is intended for buy-side and sell-side teams, and advisors, reviewing a model ahead of a transaction decision.

Dividend Policy

Dividend policy is the framework a company follows to decide how much cash to distribute to shareholders as dividends, and how consistently. The two archetypal approaches are a residual dividend policy, in which dividends are whatever cash remains after funding all positive-NPV investment opportunities, and a stable or smoothed dividend policy, in which a company targets a consistent or gradually growing dividend regardless of short-term earnings fluctuations. Because markets tend to read dividend changes as a signal of management's view of future prospects — a phenomenon known as the signalling effect — dividend policy carries a reputational and market-reaction dimension beyond its direct cash impact, making it a comparatively rigid, hard-to-reverse commitment relative to a share buyback.

Share Buyback

A share buyback (or share repurchase) is a transaction in which a company buys back its own outstanding shares, either through open-market purchases over time or via a tender offer to shareholders at a specified price. The immediate mechanical effect is a reduction in shares outstanding, which increases each remaining shareholder's proportional ownership and, all else equal, earnings per share. Buybacks are one of the two primary channels — alongside dividends — through which a company returns surplus cash to shareholders, and are generally considered more flexible than dividends because a buyback program can be scaled up, scaled down, or paused without the same negative signalling effect as a dividend cut.

Dividend vs. Share Buyback

Dividends and share buybacks are the two primary channels through which a company returns surplus cash to shareholders. A dividend is a direct, pro-rata cash distribution to every shareholder, and because markets read dividend changes as a signal of management's confidence in future prospects, it functions as a relatively explicit and hard-to-reverse commitment — cutting an established dividend carries a pronounced negative signalling cost. A share buyback returns cash by repurchasing shares from willing sellers, reducing share count rather than distributing cash to every shareholder directly, and is generally more flexible: a buyback program can be scaled up, scaled down, or paused in response to changing conditions without the same market reaction as a dividend cut. Tax treatment of the two also commonly differs, though the specific treatment is jurisdiction-dependent rather than universal.

Three-Statement Model Build Checklist

This checklist sets out the specific structural checks that confirm a three-statement model's income statement, balance sheet, and cash flow statement are correctly integrated, once the individual statements and supporting schedules have been built. It is a construction-time self-check, applied progressively as the model is assembled, distinct from a full independent structural audit performed after the model is complete.

Workbook Design and Model Architecture

Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.

Financial Model Audit for Corporate Finance

Corporate financial models span a wide range of structurally distinct types — three-statement operating models, budgets, consolidations, management reporting dashboards, and transaction models like mergers and LBOs — each carrying its own specific structural risk on top of the general model-audit baseline. This page sets out the audit-risk perspective specific to corporate finance: the balance-sheet plug as the central three-statement risk, incomplete intercompany elimination in a consolidation, an untraceable or unphased synergy assumption in a merger model, and a re-keyed rather than formula-linked figure in a management reporting dashboard. It maps each of these to FMAE's existing structural rule set, distinct from the construction-discipline perspective covered on Financial Modelling Best Practices for Corporate Finance and the model-type-specific build guides on the Corporate Financial Modelling pillar.

Common Mistakes in Corporate Financial Modelling

This guide synthesizes the structural mistakes that recur most often across every corporate model type covered on this Knowledge Centre — the hidden balance-sheet plug in a three-statement model, flat percentage-of-revenue working capital instead of day-count drivers, an incomplete intercompany elimination in a consolidation, an unsupported synergy figure in a merger model, a re-keyed value in a management reporting dashboard, and a budget baseline silently overwritten by a reforecast. Each entry is drawn from, and cross-referenced to, the full technical guide covering that model type in depth, so this page functions as a single navigable index across the domain rather than a duplicate treatment of any one mechanic.

Model Review and QA Workflow

Model review and QA workflow is the internal process lifecycle a modelling team runs on a financial model before it is relied on externally — build, self-check, peer review, and sign-off. This page is not a description of how FMAE audits a model — that is the subject of Audit Methodologies for Financial Models, a distinct page addressing FMAE's own deterministic rule-based engine. This guide addresses the general process a modelling team runs internally, independent of any specific standard, methodology, or audit tool, and applicable whether or not the model is later submitted for independent audit at all.

Model Documentation Standards for Financial Models

Model documentation standards define what written records must accompany an institutional financial model to enable its outputs to be understood, verified, and relied upon by parties other than its original developer. The minimum documentation package for an institutional financial model includes an assumption log recording the source and rationale for every input, a version history recording all material changes, a model map describing the structure and purpose of each worksheet, instructions for use, and a disclosure of known limitations. The ICAEW Financial Modelling Code and the FAST Standard both establish specific documentation requirements that define institutional expectations.

Version Control for Financial Models

Version control for financial models is the systematic management of changes to a model over time, ensuring that each version of the model is identifiable, that all material changes are recorded with their date and author, and that previous versions can be recovered when needed. Unlike software version control systems (such as Git), financial model version control is typically implemented through a combination of file naming conventions, an in-model change log, and an archive of previous model files. The FAST Standard and the ICAEW Financial Modelling Code both require a version control protocol as a core component of institutional model governance.

Financial Model Audit Checklist

This checklist sets out the core structural checks that apply to any financial model regardless of sector or transaction type — formula integrity, circularity, linking, formatting, and output consistency. It is the flagship, general-purpose reference for teams running an internal review before a model is submitted for external audit, financing, or committee approval. Sector-specific and audience-specific checklists elsewhere in this section build on it rather than repeating it.

Audit vs Validation — What's the Difference?

Financial model audit and model validation are frequently used as interchangeable terms, and specifying the wrong one in a lender requirement or an internal policy leads to real confusion about what has actually been checked. They test different things. An audit tests whether a model's mechanics are correct. Validation tests whether the model's methodology and assumptions are appropriate for its intended purpose. Both are legitimate, useful exercises. They are not substitutes for each other.

Internal Review vs Independent Audit

Organisations relying on financial models can check them internally, using their own team, or externally, through an independent audit performed by a party with no prior involvement in the model. Both have a legitimate place inside a well designed financial model governance framework. This page compares them on independence, consistency, cost, and appropriate use case, without suggesting internal review is dispensable or that independent audit is always required.