Glossary

AI Copilot

An AI copilot is a generative AI assistant, typically built on a large language model, embedded directly within a finance workflow tool, a spreadsheet, an FP&A platform, a reporting system, to support tasks such as drafting, formula assistance, and summarisation through an interactive, conversational interface. A copilot accelerates specific tasks within existing workflow; it does not itself constitute a verification or governance control over the output it produces.

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

Adjusted Present Value (APV)

Adjusted Present Value (APV) is an alternative DCF methodology that separates a company's value into two distinct components: the value of the business as if it were entirely equity-financed (the unlevered firm value), and the value of financing side effects arising from its actual use of debt, principally the tax shield generated by deducting interest expense before tax. Rather than blending the cost of debt into a single weighted average discount rate as the standard WACC-based DCF does, APV discounts unlevered free cash flow at the unlevered cost of equity, and separately values the tax shield (and any other financing side effects) at an appropriate discount rate, then sums the two present values. APV is particularly useful where capital structure is expected to change materially over the forecast period, such as in leveraged buyouts, since it avoids the need to continuously re-lever a single blended discount rate as leverage changes.

Allowance for Credit Losses

The allowance for credit losses is a contra-asset account on a bank's balance sheet, representing the reserve held against expected credit losses on the loan portfolio. It is built up through periodic provision charges against the income statement and drawn down as specific loans are written off, following the same roll-forward discipline a corporate model applies to a bad debt reserve, but at a scale and centrality that makes it one of the most closely scrutinized figures on a bank's balance sheet.

Asset Register

An asset register is the structured inventory of an owner's infrastructure assets, recording each asset's identity, location, original cost, installation date, condition, and criticality, among other attributes. It is the foundational data source from which asset management plans, whole-life cost models, and renewal forecasts are all built, and its completeness and accuracy directly determine the reliability of every downstream financial model that depends on it.

Asset-Based Valuation

Asset-based valuation values a business as the fair value of its underlying assets less its liabilities, rather than as a function of its earnings or cash-generating capacity. It is the practical implementation of the asset-based approach, one of the three classical valuation approaches alongside the income approach (DCF) and the market approach (comparable company analysis and precedent transactions). Asset-based valuation is most relevant for asset-heavy, holding-company, investment-fund, or liquidation scenarios, where the fair value of specific, often independently appraisable assets is a more reliable indicator of value than a going-concern earnings or cash flow forecast.

Audit Trail

An audit trail is the documented chain of evidence connecting a financial model audit's findings and conclusions back to the specific cells, formulas, and inputs that support them, and connecting any change made to the model back to who made it, when, and why. It is what allows a third party, a lender, an investment committee, or a subsequent reviewer, to verify a review's conclusions without re-performing the entire exercise from scratch.

Availability Factor

Availability factor is the percentage of a period during which a generation asset is capable of producing output, whether or not it is actually dispatched or the resource is present. It reflects planned outages (scheduled maintenance) and unplanned outages (equipment failure), and should be modelled distinctly from both capacity factor and curtailment.

Availability Payment Model

An availability payment model is a project finance structure in which the public authority (the contracting authority) pays the private concessionaire a periodic payment contingent on the asset being available for use according to defined performance and availability standards, regardless of actual usage levels. The payment is not linked to traffic volumes, passenger numbers, or other demand metrics. Revenue risk remains with the public sector; the private sector takes construction risk, availability risk, and performance risk. Availability payment models are common in hospitals, schools, prisons, roads, and rail infrastructure where the contracting authority wishes to retain demand risk while transferring construction and maintenance risk.

Average Length of Stay (ALOS)

Average length of stay (ALOS) is the mean number of days patients remain admitted per inpatient episode over a defined period, calculated as total inpatient days divided by total discharges. ALOS is a central driver of a hospital's effective bed capacity, occupancy rate, and cost per case: for a fixed bed base, a lower ALOS allows more discharges (and therefore more revenue-generating admissions) to pass through the same physical capacity, while a rising ALOS, whether from clinical necessity or inefficiency, consumes capacity and increases the cost of each admission. ALOS should be modelled as an explicit, service-line-specific driver rather than a single hospital-wide average.

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.

Balloon Payment

A balloon payment is a large lump-sum repayment of outstanding loan principal that falls due at or near the maturity of a loan, following a period during which scheduled amortisation payments have been lower than would be required to fully repay the loan by maturity. Balloon payments arise in project finance when the debt sculpting algorithm sizes periodic repayments at the minimum required to satisfy the DSCR covenant, which may not be sufficient to fully repay the facility within the loan term. The balloon represents the residual outstanding balance after all scheduled repayments have been made and must be refinanced or repaid from asset sale proceeds at maturity.

Base Case

The base case in a financial model is the central scenario that represents the model developer's primary projection of expected outcomes. It uses the most likely or central estimate for each assumption, rather than optimistic or pessimistic values. All other scenarios (upside, downside, stress) are defined in relation to the base case. The base case is the scenario used for investment decisions, credit approvals, and board presentations unless otherwise stated. Its key outputs — typically IRR, NPV, DSCR, and equity returns — are the primary reference metrics for any decision made in reliance on the model.

Beta

Beta is a measure of a stock's systematic risk — the portion of its return volatility that is correlated with movements in the broader market and cannot be diversified away. A beta of 1.0 moves in line with the market; a beta above 1.0 indicates higher-than-market sensitivity, and a beta below 1.0 indicates lower sensitivity. Beta is the key input to the Capital Asset Pricing Model (CAPM), which is used to estimate the cost of equity component of the discount rate in a DCF valuation. Beta can be sourced from a regression of a company's historical stock returns against a market index, or taken from published data services, and for private companies or specific projects is typically derived from a set of unlevered comparable betas re-levered to the subject's target capital structure.

Blended Finance

Blended finance is the structured use of concessional capital, most commonly from a development finance institution, multilateral development bank, or dedicated climate fund, to mobilise additional commercial capital toward a climate or development outcome that commercial capital alone would not finance. The concessional layer typically absorbs first-loss risk or provides a guarantee, changing the risk profile of the commercial capital sitting alongside it.

Broken Link

A broken link in a financial model is a formula reference that cannot be resolved to a currently valid source. The referenced cell, named range, worksheet, or external workbook file no longer exists at the location specified by the formula. Broken links manifest in two ways: as visible error values (most commonly #REF! for deleted internal references, or #NAME? for deleted named ranges) or as silent stale cached values (in the case of external links to unavailable workbook files where Excel has retained the last known value). The silent form is more dangerous because it produces plausible-looking outputs without any visible indication of the problem.

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.

CAPM (Capital Asset Pricing Model)

The Capital Asset Pricing Model (CAPM) is the standard methodology for estimating the cost of equity — the return equity investors require to hold a company's stock, given its systematic risk relative to the broader market. CAPM expresses cost of equity as the risk-free rate plus the company's beta multiplied by the equity risk premium (the excess return the market as a whole is expected to earn over the risk-free rate). CAPM is the most widely used cost-of-equity methodology in institutional valuation practice and is the standard input to the cost-of-equity component of WACC.

CET1 Ratio

The CET1 ratio expresses Common Equity Tier 1 capital — a bank's highest-quality, most loss-absorbing capital — as a percentage of risk-weighted assets. It is the most closely watched capital adequacy metric under Basel III, subject to both a hard minimum requirement and additional capital buffers, and it should be built as a live output of the model's balance sheet forecast rather than a separately calculated reporting figure.

Capacity Factor

Capacity factor expresses a generation asset's actual energy output over a period as a percentage of the output it would have produced running at full nameplate capacity continuously over that same period. It is the core utilization metric for comparing generation assets and technologies, distinct from availability, which measures uptime rather than realized output.