Technical Guides

Data Centre Sensitivity Analysis

Data centre sensitivity analysis flexes one driver at a time, holding all others constant, to rank which individual assumptions, occupancy, pricing, power cost, and PUE, most affect model outputs such as revenue, EBITDA, or debt service coverage. This guide sets out how to construct a driver-by-driver sensitivity table for a data centre model and how it complements, rather than substitutes for, correlated scenario analysis.

Data Centre Valuation Models

Data centre valuation applies standard discounted cash flow methodology but requires bifurcating contracted (take-or-pay or long-dated lease) cash flow from uncontracted, renewal-dependent cash flow, and selecting a discount rate appropriate to each business model's risk profile, hyperscale build-to-suit versus diversified colocation versus enterprise/captive. This guide sets out how to structure a data centre valuation model and the sector-specific inputs a generic DCF template does not supply on its own.

Data Room Best Practices

Building on the Data Room glossary definition, this guide sets out the practical discipline for structuring and managing a virtual data room well — a consistent indexing structure, correctly staged access by transaction phase and workstream, disciplined activity logging, and a Q&A process for bidder-submitted questions. A well-run data room reduces process friction and shortens the diligence timeline; a poorly run one creates exactly the kind of disorganized disclosure that is itself a due diligence risk signal.

Debt Sculpting Mechanics in Project Finance Models

Debt sculpting is a technique used in project finance financial models to derive the periodic debt repayment schedule from the projected cash flows available for debt service, rather than from a fixed amortisation schedule. The repayment in each period is sized such that the debt service coverage ratio (DSCR) in that period equals a defined target, or such that a defined proportion of available cash flow is applied to debt service. Sculpting shapes the repayment profile to match the project's cash flow profile, front-loading repayment in high-cash-flow periods and reducing repayment in lower-cash-flow periods, which increases the project's ability to service debt throughout the loan life.

Decline Curve Financial Models

A decline curve financial model translates the underlying production decline curve into a full revenue, cost and cash flow schedule, and represents the genuine uncertainty in future production through probabilistic P10, P50 and P90 cases rather than a single deterministic line. This guide sets out how decline parameters flow through into a bankable cash flow model, and why the model's uncertainty treatment should reflect the same probabilistic basis used in the underlying reserve estimate.

Decommissioning Cost Models

Decommissioning cost models estimate and provision the mandatory end-of-life obligation to plug wells and remove oil and gas infrastructure, an obligation that should be funded progressively across the production life rather than treated as a single terminal-year cost. This guide sets out how decommissioning cost is estimated, the funding mechanisms, sinking funds, parent company guarantees, and letters of credit, regulators typically require, and why timing and discounting of the liability matter to how it is represented in a financial model.

Degradation Modelling

Degradation modelling methodology goes beyond applying a flat annual percentage: it involves choosing between a linear and non-linear degradation curve shape appropriate to the technology, sourcing technology-specific degradation profiles, reconciling a warranty-guaranteed rate against actual measured performance once operational, and understanding how degradation feeds refinancing and repowering decisions later in the asset's life. This guide covers the methodology behind the degradation schedule already introduced as a core technical mechanic.

Dependency Analysis in Financial Models

Dependency analysis in financial models is the process of mapping the relationships between input cells and output cells to determine which inputs drive which outputs and by how much. A dependency map shows, for any given cell, which cells it depends upon (its precedents) and which cells depend upon it (its dependents). In a model audit or risk assessment context, dependency analysis is used to identify the inputs that have the greatest influence on key outputs, to verify that the dependency structure matches the model's intended design, and to detect structural anomalies such as outputs that are unexpectedly disconnected from their intended inputs.

Deposit Modelling

Deposit modelling is the liability-side counterpart to loan portfolio modelling: deposits should be segmented by product type — transactional, savings, and term — each carrying its own volume, cost, and behavioural assumptions. Behavioural modelling matters more on the deposit side than almost anywhere else in a bank model, since a deposit's contractual maturity (or lack of one, for transactional accounts) frequently does not match its actual behavioural stickiness, and that gap is central to both funding and liquidity risk management.

Development Appraisal Model Structure

A development appraisal model differs structurally from a standing-asset model because it builds value forward from land and construction cost, through a phased sales or leasing velocity schedule, to a gross development value, with a residual land value calculated as an output rather than assumed as an input. This guide sets out the module architecture — assumptions, GDV build, cost and drawdown schedule, finance, and residual land value or returns output — that makes such a model auditable across the development lifecycle from feasibility through to completion.

Development Finance Institution Models

A development finance institution (DFI) pursues development impact alongside, and sometimes in place of, pure commercial return, financing projects a purely commercial lender might not otherwise fund. This guide covers how a DFI model should represent concessional and blended finance structures — where DFI capital is combined with commercial capital at different risk-return positions — the additionality question a DFI investment should be tested against, and how development impact metrics should sit alongside, not replace, standard financial modelling discipline.

Development Management Model Structure

A development management engagement, where a developer manages a scheme on behalf of a landowner or capital partner for a fee rather than holding the development risk directly, requires its own model distinct from the underlying project appraisal, built around a base fee, an incentive fee tested against performance hurdles, and a clear separation between the development manager's own fee income and the project's underlying cash flow. This guide sets out how this fee structure should be represented.

Development Phasing Model Structure

A multi-phase development should be modelled as a set of distinct phase-level cost and revenue blocks, each with its own timeline, rather than a single project-wide schedule with an internal phasing overlay. This guide sets out how phase-level segmentation should be structured, how costs shared across phases (site-wide infrastructure, marketing suite) should be allocated, and how phase-specific returns should be reported alongside the consolidated whole-scheme view.

Development Waterfall and Promote Structure

A real estate waterfall and promote structure allocates returns between sponsor and investor across defined hurdle rates of return, and should be built as an explicit, tiered calculation, one clearly labelled block per tier, sequenced against actual cash distribution timing, rather than a single blended split formula. This guide sets out how each waterfall tier, including catch-up and clawback mechanics, should be structured and tested.

Diagnostic Centre Models

Diagnostic centres (imaging, cardiology testing, and similar specialised diagnostic services) carry a distinctive cost structure dominated by high fixed equipment cost relative to variable per-scan cost, making equipment utilisation the central profitability driver. This guide covers how to model equipment utilisation economics, why diagnostic centre volume is predominantly referral-driven rather than direct-demand-driven, and how reimbursement rate differs by modality and study type.

Distressed Transactions

A distressed transaction — the acquisition of a financially troubled business, typically in or approaching insolvency — introduces mechanics an ordinary acquisition model does not need. Going-concern uncertainty means standard forecasting assumptions may not hold, liquidation value establishes a price floor distinct from a going-concern valuation, diligence timelines are frequently compressed relative to a standard process, and creditor priority under the applicable insolvency framework directly determines how transaction proceeds are actually distributed. This guide covers each of these mechanics.

District Cooling Financial Models

A district cooling operations financial model represents connection charge and consumption-based tariff revenue, a plant-and-network asset base combining centralised chiller plant equipment with a buried distribution pipe network, and capacity utilisation as the central operating and financial metric determining plant efficiency and expansion timing. This guide covers how to build that operations-phase model, particularly relevant to GCC and other markets where district cooling is a significant utility infrastructure category.

Downstream Financial Models

Downstream financial models cover refining and petrochemical manufacturing, where revenue and margin are driven by the spread between crude oil or feedstock input cost and refined product or petrochemical output prices, combined with plant utilization and complexity. This guide sets out how downstream models are structured around crack spread economics, capacity and turnaround planning, and product yield, and why the segment's modelling risk centres on margin volatility rather than reserve or volume risk.

Drawdown and Funding Mechanics

The drawdown schedule translates the total funding requirement from the sources and uses statement into a period-by-period draw of debt and equity during construction, governed by a funding competition rule that determines the relative proportion of debt versus equity drawn each period. This guide sets out how to build pro-rata, equity-first, and debt-first funding competition mechanics, how to sequence multi-tranche debt drawdowns, and how standby facilities interact with the base drawdown schedule.

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.