Glossary

Cost-to-Income Ratio

The cost-to-income ratio divides operating expense by operating income (net interest income plus fee and other non-interest income), giving the standard measure of how efficiently a bank converts revenue into profit before credit costs. A lower ratio indicates greater efficiency, though the ratio should be read alongside profitability and asset-quality metrics rather than optimized in isolation.

Country Risk Premium (CRP)

The country risk premium (CRP) is an additional premium added to the cost of equity for cash flows or assets exposed to a specific country's sovereign or political risk, beyond the general equity risk premium applicable in mature, well-diversified markets. CRP is relevant whenever a DCF valuation involves cash flows exposed to a country carrying meaningfully higher sovereign risk than the base market used to estimate the equity risk premium, commonly proxied using sovereign credit default swap spreads, sovereign bond yield spreads over a risk-free benchmark, or published country risk ratings. CRP should be applied transparently and only once, since double-counting country risk (for example, in both the discount rate and the cash flow forecast) is a common and material valuation error.

Credit Metrics

Credit metrics are the standard ratios lenders, rating agencies, and companies themselves use to assess how much debt a corporate borrower can safely carry and how comfortably it can service it. The two principal families are leverage ratios, most commonly net debt divided by EBITDA, which measure the overall quantum of debt relative to the cash-generating capacity of the business, and coverage ratios, including the interest coverage ratio (EBIT or EBITDA divided by interest expense) and the fixed charge coverage ratio, which measure the cushion between operating cash generation and required debt-service and lease payments. Credit metrics are the corporate-finance equivalents of the project-finance-specific DSCR and LLCR metrics, calculated against a going-concern corporate balance sheet rather than a defined project cash flow and loan life.

Critical IT Load

Critical IT load is the amount of power a data centre facility delivers directly to IT equipment, servers, storage, and networking, and is the industry-standard unit for expressing a facility's billable and sellable capacity. It excludes the additional, non-IT power drawn by cooling and power distribution overhead, which is instead captured separately through power usage effectiveness (PUE). Critical IT load, in kW or MW, is the capacity figure that data centre revenue, capacity planning, and portfolio scale metrics are all built around.

Cross-Connect Revenue

Cross-connect revenue arises from recurring fees charged for physical cabling connections between tenants within a colocation facility, or between a tenant and a network carrier present in the facility's meet-me room. Cross-connects typically carry materially higher margin than base space and power revenue, since the incremental cost of provisioning a connection is low relative to its recurring fee, and cross- connect density is often used as a proxy for a facility's network ecosystem value.

Curtailment

Curtailment is a reduction in a generation asset's output due to grid capacity constraints or contractual limits, independent of the equipment's own availability or resource conditions. It should be modelled as its own distinct output reduction, separate from availability, so that grid or contractual exposure can be tested and reported independently of equipment uptime.

DSCR (Debt Service Coverage Ratio)

The Debt Service Coverage Ratio (DSCR) is the primary metric lenders use to assess a project's ability to service its debt from operating cash flow in a given period. It is calculated as cash available for debt service (CADS) divided by total debt service (interest plus scheduled principal) due in that period. A DSCR of 1.00x means the project generates exactly enough cash to cover its debt obligations for the period; lenders typically require a minimum DSCR above 1.00x, specified in the loan agreement, to provide a buffer against downside performance. DSCR is one of the most frequently independently recalculated figures in a project finance model audit, given its direct link to covenant compliance.

Data Room

A data room is the controlled repository of documents and information a target company makes available to due diligence teams during a transaction process. Almost universally a virtual data room today, access is permissioned by workstream and phase, with activity logged, so that a seller can disclose progressively more sensitive information as a process moves from preliminary to confirmatory diligence while retaining an auditable record of who accessed what and when.

Data Table

In Excel, a data table is a range of cells that performs a series of what-if calculations by substituting a set of input values into one or two designated cells and recording the resulting output from a specified formula. Data tables are the standard mechanism for producing sensitivity matrices in financial models. A one-variable data table varies one input and shows the output for each value; a two-variable data table varies two inputs simultaneously. Data table results are stored as array formulas using the TABLE function and update automatically when the model recalculates, unless the workbook's calculation mode excludes data tables from automatic recalculation.

Days in Accounts Receivable (Healthcare)

Days in accounts receivable (Days in AR) measures the average number of days between a healthcare service being delivered and billed and the resulting payment being collected, calculated as accounts receivable balance divided by average daily net patient service revenue. It is one of the primary quantitative indicators of revenue cycle management performance, and a rising Days in AR figure signals either a payer mix shift toward slower-paying categories, a deterioration in claims accuracy, or a genuine breakdown in collections follow-through, each of which has a different implication for the financial model.

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.

Debt Sculpting

Debt sculpting is the project finance modelling technique by which the periodic loan repayment schedule is derived from the project's projected cash flows available for debt service, sized in each period to maintain a minimum debt service coverage ratio (DSCR). Rather than specifying equal principal repayments or equal total debt service payments over the loan life, debt sculpting produces a repayment profile whose shape mirrors the project's cash flow curve: larger repayments in periods of high cash generation, smaller repayments in periods of lower cash flow. The result is a higher achievable debt quantum than flat or annuity amortisation while maintaining covenant compliance throughout the loan life.

Debt Service

Debt service is the total periodic payment obligation on a loan facility, comprising interest payable in the period and scheduled principal repayment due in the period. In project finance, debt service is the denominator of the debt service coverage ratio (DSCR). The DSCR measures the ratio of cash available for debt service (CADS) to total debt service, and must exceed the minimum threshold specified in the loan agreement throughout the loan life. Debt service is applied at a defined step in the cash waterfall, after operating costs and before reserve contributions and equity distributions.

Debt Service Reserve Account (DSRA)

The debt service reserve account (DSRA) is a cash reserve, typically sized to the next one or two periods of scheduled debt service, held to protect lenders against a temporary shortfall in operating cash flow. It is one of the most common reserve mechanics in project finance and sits within the cash waterfall as a funded, ring-fenced tier: the account must be topped up to its target balance from available cash flow before any distribution to equity is permitted, and if operating cash flow is insufficient to cover a scheduled debt service payment, the shortfall may be drawn from the DSRA rather than triggering an immediate default.

Degradation Rate

Degradation rate is the annual decline in equipment output over a generation asset's operating life, reflecting expected panel, turbine, or other equipment performance decline. It should be applied as an explicit, consistent annual schedule reconciled to the technical basis used elsewhere in the model, since even a small inconsistency compounds materially over a multi-decade asset life.

Demand Risk Model

A demand risk model is a financial model for a project finance concession in which the concessionaire's revenue is derived from user charges (tolls, fares, or fees) paid by users of the asset. The concessionaire's revenue therefore depends directly on actual demand for the asset's services, rather than on contractual availability payments from the public authority. Demand risk models are used for toll roads, airports, ports, urban transit systems, and other infrastructure assets where users pay directly for the service. The key risk in a demand risk model is that actual usage may be materially lower than projected, reducing revenue below debt service requirements.

Depreciated Replacement Cost (DRC)

Depreciated replacement cost (DRC) is the current cost to construct or acquire a modern equivalent of an existing asset, reduced to reflect the proportion of its useful life already consumed. It is a standard valuation basis for specialised infrastructure assets that lack an active resale market, and it is the input against which a renewal or replacement cost estimate is commonly benchmarked in a whole-life cost model.

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

Deterministic Audit

A deterministic audit is a financial model audit performed by applying a fixed, disclosed rule set systematically to a model's formulas and structure, such that running the same audit against the same model produces the same findings every time. It is distinguished from both manual, judgement-based review and generative AI-based review, neither of which is guaranteed to be repeatable in this sense.

Diluted Share Count

Diluted share count is the number of shares used as the divisor when converting total equity value into value per share, and it differs from basic shares outstanding by including the potential dilutive effect of options, warrants, convertible debt, and convertible preferred stock. Options and warrants are incorporated using the treasury stock method; convertible securities are incorporated using the if-converted method, which also requires adding back the interest or dividend the company would no longer pay if conversion occurred. Using the correct diluted share count is the final step in a DCF's enterprise-to-equity value bridge, and understating dilution is a common source of overstated value per share.