Financial Statements in Financial Modelling

Income Statement

The income statement measures a company's or project's profitability over a period, moving from revenue down through cost of goods sold, operating expenses, depreciation and amortization, interest, and tax to arrive at net income. In a financial model it is the statement most readers look to first, and its net income line is the single figure that connects it to both the balance sheet and the cash flow statement in an integrated three-statement model.

Balance Sheet

The balance sheet is a snapshot of a company's or project's financial position at a single point in time, structured around the accounting identity Assets equal Liabilities plus Equity. In a financial model, one line — typically cash or a revolving credit facility — is designated the balancing mechanic, absorbing the residual funding surplus or shortfall the rest of the model produces so the identity holds exactly in every period. A balance sheet that fails to balance is the single most diagnostic signal that a model's statement linkage contains a structural error.

Cash Flow Statement

The cash flow statement reconciles the income statement's accrual-based net income to the actual cash generated or consumed over the same period, split into operating, investing, and financing activities. Its output, the net change in cash, added to the opening cash balance, must equal the closing cash balance — which must, in turn, equal the cash line on the balance sheet. In a financial model, this tie-out is one of the clearest mechanical tests of whether the three statements are correctly linked.

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.

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.

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.

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.

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.

Direct vs. Indirect Cash Flow Method

The direct and indirect methods are the two ways to construct the operating section of the cash flow statement, and both arrive at the same operating cash flow figure. The direct method lists actual cash receipts and payments — cash collected from customers, cash paid to suppliers and employees. The indirect method starts from net income and adjusts for non-cash items and working capital changes. The indirect method is near-universal in financial models because it ties directly to the income statement and balance sheet, making it far easier to build and audit within an integrated three-statement model.

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.

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)

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).

Financial Modelling Best Practices — Standards Compared

Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.

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.

Discounted Cash Flow (DCF) Valuation

Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.

Financial Forecasting in Financial Models

Financial forecasting is the process of projecting a business's future financial performance from a defined set of operating drivers and assumptions, structured so that every forecast line traces back to a labelled, auditable input rather than a value typed directly into a calculation. It underpins every model built for valuation, budgeting, financing, or investment decision-making, and it is also one of the areas of a financial model most prone to silent structural failure, since a forecast that looks complete can still rest on drivers that are hardcoded, undocumented, or inconsistently applied from one period to the next. This page is the hub for the Knowledge Centre's forecasting content: what a forecast driver is, the major forecasting methodologies and when each applies, the governance distinction between a budget and a forecast, rolling forecasts, and how forecasting failure modes map onto FMAE's existing structural audit rule taxonomy.

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.