Technical Guides

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.

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.

Human-in-the-Loop Review

A human-in-the-loop review step is only as effective as its design: the reviewer must have genuine authority to reject or modify AI-assisted output, a workload calibrated to allow genuine review rather than nominal sign-off, and a clear escalation path for findings. This guide sets out what distinguishes a genuinely effective human-in-the-loop review from a rubber-stamp step that exists on paper but does not actually catch errors in practice.

Hybrid Renewable Models

A hybrid renewable project combines two or more generation and storage technologies at a shared site, typically to share interconnection infrastructure and improve combined output profile and revenue certainty. This guide covers the modelling mechanics specific to hybrid projects: the shared interconnection capacity constraint that can force curtailment of one technology in favor of another, allocation of shared costs and revenue between the constituent technologies, and how combined versus separate offtake structures should be represented.

Hydro Power Models

A hydropower financial model is built from a flow duration curve representing the site's hydrology, converted through the plant's head and turbine specification into output, with a materially different revenue and risk profile depending on whether the plant is run-of-river (no meaningful storage, output follows river flow directly) or reservoir/storage-based (able to store and dispatch water flexibly). This guide covers these hydro-specific technical mechanics and the water rights and environmental flow constraints that shape them.

Hyperscale Data Centre Models

Hyperscale data centre models finance a facility developed and leased to a single large cloud or technology tenant under a long-dated contract, structured around phased, capacity-denominated capex drawdown rather than a single completion event. This guide sets out how to model phased delivery, contracted revenue recognition, and the concentrated counterparty and power availability risks distinctive to this business model.

Income-Producing Asset Model Structure

An income-producing asset model differs structurally from a development appraisal because it starts from an existing or near-complete asset's rent roll and builds forward to a stabilised net operating income, valued through direct capitalization or a full discounted cash flow, rather than building value forward from construction cost. This guide sets out the module architecture — rent roll, operating expense and NOI build, valuation module, and returns output — that makes such a model auditable, and how lease-level detail should be represented.

Independent Assurance for Data Centre Models

Independent assurance for a data centre financial model requires the reviewer to have direct access to the underlying engineering capacity data and contract documents, not just the model's own summarised figures, and genuine independence from the party whose capacity and pricing assumptions are being tested. This guide sets out what independent assurance should cover and the access and independence conditions that make it meaningful rather than a review of the model's own self-reported figures.

Independent Assurance for Energy Models

Genuinely independent assurance for an energy or power project financial model requires that the technical (resource yield, degradation), commercial (PPA, price forecasting), and structural (formula integrity) review each be performed by a party independent of the project's sponsor and developer, not an internal team applying rigorous but ultimately non-independent scrutiny. This guide sets out what genuine independence requires across each of these assurance dimensions specific to this asset class.

Independent Assurance for Healthcare Models

Independent assurance for a healthcare financial model requires more than a title of "independent reviewer" — it requires genuine access to underlying clinical, payer, and revenue cycle data, and freedom from the operational incentives that can shape how a provider's internal team reports its own performance. This guide covers what access and independence should look like in practice, and why ongoing, not one-time, assurance is particularly important given how frequently the sector-specific assumptions in this pillar require revisiting.

Independent Climate Model Review

Independent climate model review requires the reviewer to have genuine access to source MRV and carbon pricing data, and genuine separation from the assumptions and capital structure being tested, the same independence discipline applied to financial model review generally, specialised to this domain's concessional capital and climate outcome verification mechanics. This guide covers what independence actually requires for a climate model reviewer.

Independent Model Review in Transactions

An independent model review, in a transaction context, is commissioned by the deal team itself for its own internal assurance ahead of investment committee approval — testing the transaction model's structural integrity separately from, and in addition to, the commercial and financial due diligence already underway. It shares its underlying methodology with the general independent model audit discipline, applied specifically to the transaction model and its combination mechanics.

Independent Power Producer (IPP) Models

An independent power producer (IPP) model represents a single-purpose generation asset — solar, wind, thermal, or otherwise — that generates electricity for sale to one or more offtakers under a defined commercial arrangement, rather than for its own retail or distribution network as a vertically integrated utility would. This guide covers the model structure specific to an IPP: offtake concentration and counterparty risk, project-company ring-fencing, and how the base power project model structure specializes for a single-asset, single-purpose entity.

Independent Review for Asset Management Models

Independent review of an infrastructure asset management model requires a reviewer with no stake in the model's conclusions, direct access to the underlying asset register and condition data rather than only the model's summary output, and the standing to challenge the asset owner's own assumptions. This guide covers how to structure that independence in practice, what access an independent reviewer needs, and the specific categories of finding this review is best positioned to surface that an internal self-review typically cannot.

Independent Review in Banking

Independent review of a bank model — performed by a party outside the bank's own model risk management function — provides a perspective distinct from internal model validation, even when both disciplines cover similar technical ground. This guide covers why independence from the institution itself matters beyond independence from the first-line business unit, when a bank should seek external independent review in addition to its internal second-line validation function, and how a lending syndicate or regulator might rely on independent review differently than the bank's own governance process.

Industrial and Logistics Model Structure

Industrial and logistics models specialize the income-producing asset structure around a small number of long-dated leases, often a single tenant, which concentrates income risk in a way a diversified multi-let office or retail asset does not, together with a specification-driven yield basis (clear height, loading, power capacity) distinct from other property types. This guide sets out how single-tenant concentration risk, specification-linked pricing, and rack-rent reversion at expiry should be modelled.

Inflation and Indexation in Project Finance Models

Many project finance revenue streams, particularly availability payments in PPP and concession structures, are contractually indexed to inflation, while cost lines and debt structures may be indexed differently or not at all. This guide sets out how to build the indexation mechanism directly from the contract's formula, how to keep real and nominal cash flows and discount rates consistent, and the risk of an indexation basis mismatch between revenue and cost lines that a model can silently misrepresent.

Infrastructure Asset Best Practices

This capstone guide synthesises the construction and governance disciplines set out across Infrastructure Asset Management Financial Modelling into a single reference: build from component-level condition data, connect reserve funding explicitly to the renewal forecast, disaggregate funding gap disclosure by criticality, maintain genuine independence in review and assurance, and structure governance to survive personnel turnover across a multi-decade asset life. Together these practices distinguish a model an asset owner and its lenders, oversight bodies, and future successors can actually rely on from one that only appears rigorous.

Infrastructure Bank Models

An infrastructure bank finances long-dated infrastructure assets — transport, energy, water, digital infrastructure — typically through project finance structures rather than general-purpose corporate lending. This guide covers how an infrastructure bank model should represent long tenor and drawdown-phased lending, co-financing arrangements with commercial lenders and multilateral partners, and the project-finance-specific credit mechanics (cash flow waterfalls, coverage ratio covenants) that differ from the general bank lending discipline covered elsewhere in this domain.