Technical Guides
Step-by-step technical guidance for identifying and remediating structural risk in Excel financial models.
-
Capital Replacement Planning
Capital replacement planning takes the component-level renewal forecast produced by an asset renewal model and turns it into a prioritised, funding-constrained multi-year capital plan: which replacements proceed on schedule, which are deferred, and what risk that deferral creates. This guide covers how to build that prioritisation and constraint logic, connecting the technical renewal timeline to the capital budget an owner actually has available in a given year.
-
Carbon Credit Financial Models
Modelling carbon credits as an investable asset class, at the level of a carbon credit project developer, aggregator, or portfolio investor, requires a different set of drivers than modelling carbon credit revenue as a single line item within a power project's cash flow, issuance methodology and vintage, buffer pool and reversal risk, and the structural distinction between voluntary and compliance markets. This guide covers each of these investor- and developer-level drivers.
-
Carbon Credit Models
Carbon credits or offsets can provide a meaningful additional revenue stream for a renewable or emissions-reducing power project, but require their own explicit modelling treatment: verification and certification cost, credit price volatility distinct from electricity price, and additionality requirements that determine eligibility in the first place. This guide covers how to model carbon credit revenue as its own distinct, appropriately risk-adjusted component rather than folding it into general electricity revenue.
-
Carbon Market Modelling
Carbon market modelling addresses the trading mechanics of compliance and voluntary carbon markets themselves, allowance supply and price discovery in a compliance emissions trading scheme, liquidity and price formation in a voluntary market, and the price relationships, or lack of them, between markets. This guide covers how a financial model exposed to carbon market price risk should represent these market-level mechanics.
-
Carbon Offset Project Models
A carbon offset project model represents the economics of developing and operating an offset-generating project itself, afforestation, methane capture, and similar activities, distinct from modelling an investor's exposure to already-issued credits. This guide covers capital and operating cost structure, the lag between project development activity and credit issuance, and the monitoring cost that persists over the project's full crediting period.
-
Carbon Pricing Models
Carbon pricing models forecast a specific carbon price, whether a carbon tax rate or emissions trading scheme allowance price, and apply it as a direct cash flow driver against a portfolio's or entity's emissions exposure. This is a distinct task from choosing a discount-rate-premium or cash-flow-scenario methodology for reflecting climate risk in a single valuation; this guide covers building the carbon price forecast itself and applying it consistently across exposed cash flows.
-
Carve-Out Transactions
A carve-out transaction separates a business unit, division, or subsidiary from its parent and sells it as a standalone entity — a structurally distinct challenge from an ordinary acquisition, because the carved-out business has typically never had its own standalone financial statements. Shared corporate costs, shared systems and infrastructure, and intercompany relationships with the remaining parent must all be explicitly disentangled and allocated, and a transitional service agreement typically bridges the gap between separation and full operational independence. This guide covers the specific modelling discipline a carve-out requires.
-
Cash Waterfall Construction
The cash waterfall is the defined priority order in which a project's cash is applied each period, operating costs, debt service, reserve account funding, and distributions, with each tier's payment conditional on the tiers above it being satisfied first. This guide sets out how to build the waterfall as an explicit, tier-by-tier calculation, including cash sweep mechanics that accelerate debt repayment from surplus cash, and the distribution lock-up tests that block a distribution when a coverage ratio or reserve condition is not met.
-
Circular Economy Models
Circular economy investments, material recovery and recycling infrastructure and product-as-a-service business models, generate financial returns and climate benefit through mechanisms distinct from both standard industrial investment and pure emissions-reduction projects. This guide covers material recovery and recycling economics, product-as-a-service revenue structures, and how the avoided-virgin-material climate benefit should be calculated.
-
Circular References in Financial Models
A circular reference in a financial model occurs when a formula in one cell depends, directly or through a chain of intermediate cells, on its own value. In Excel, circular references are flagged by default and cause the affected cells to display zero rather than a calculated result. When iterative calculation is enabled, Excel resolves circular references by repeatedly recalculating the sheet until a convergence threshold is met, which can produce different results depending on the starting conditions and may mask non-convergence. In financial models, circular references arise most frequently in interest-on-drawn-debt calculations, cash sweep mechanics, and tax shield computations.
-
Circularity in Debt Models
Circularity in debt models arises from the interdependence of interest expense and cash availability in the same period. In a project finance model, interest is charged on the drawn debt balance; the interest payment reduces available cash; available cash determines the repayment amount; the repayment amount determines the closing debt balance; and the closing balance determines the next period's interest charge. When a model calculates interest on the average of opening and closing balances, or when a cash sweep mechanism uses the same period's interest cost in determining sweep amounts, a circular dependency is introduced. The two principal resolution techniques are: calculating interest on the opening balance rather than the average balance, and using a defined debt repayment algorithm that determines the repayment amount without reference to the closing interest charge.
-
Climate Adaptation Investments
Climate adaptation investments, building resilience against physical climate risk rather than reducing emissions, require avoided loss as the primary return metric rather than the avoided emissions metric used for mitigation investment, and frequently involve public or quasi-public resilience infrastructure with financing structures distinct from a standard commercial investment. This guide covers how to quantify avoided loss, distinguish adaptation from mitigation investment, and structure financing for resilience infrastructure.
-
Climate Assurance
Climate assurance is the ongoing, recurring verification of a climate investment's carbon and MRV claims and capital structure compliance over its life, distinct from a one-time climate model audit performed at a single point such as financial close. This guide covers how assurance cadence should be tied to the investment's actual reporting cycle and what should be re-verified at each cycle.
-
Climate Documentation Standards
A climate finance model's documentation should make its capital structure terms, carbon and MRV methodology sourcing, and climate scenario construction basis traceable to a named source, durable across personnel turnover rather than dependent on an individual builder's memory. This guide sets out what a climate model's documentation should cover and how it should be maintained.
-
Climate Due Diligence
Climate due diligence assesses the climate-specific dimensions of a prospective investment, transition plan credibility, carbon exposure and pricing risk, and MRV process integrity, a narrower and more technical workstream than the broader ESG due diligence already covered in this Knowledge Centre's transaction content. This guide covers what climate due diligence should assess and how its findings should translate into the investment model.
-
Climate Finance KPIs
Climate finance performance is read through a small set of KPIs, mobilisation ratio, cost per tonne abated, green asset ratio, and avoided emissions, each capturing a different dimension of a climate investment's effectiveness and none sufficient as a standalone measure. This guide sets out how each KPI is defined, how they should be disclosed together as a system rather than in isolation, and the common ways each metric is calculated inconsistently across the industry.
-
Climate Finance Overview
Climate finance draws on a distinct set of capital sources, multilateral development banks, dedicated climate funds, development finance institutions, sovereign wealth funds, and private capital, each entering a climate investment at a different point on the concessionality spectrum. This guide maps the main sources and instruments, and sets out how concessionality varies across the capital stack, as the foundation for the more specific climate financial modelling, sustainable finance, and climate investment model guides that follow it.
-
Climate Financial Modelling
Climate financial modelling is not a separate mathematical discipline from standard corporate or project financial modelling, but it requires explicit representation of drivers a generic template does not carry by default: concessional and catalytic capital layering, additionality assessment, carbon-adjusted cash flows, and measurement, reporting, and verification (MRV) of the climate outcome itself. This guide sets out each of these structural differences and how they should be built into a climate-specific financial model.
-
Climate Governance
Climate governance establishes ownership, event-driven update triggers, and board-level reporting for a climate finance model or portfolio, applying the general financial model governance discipline to this domain's specific update cadence, MRV cycles, carbon price refreshes, and evolving scenario frameworks. This guide covers what a climate governance framework should establish.
-
Climate Infrastructure Models
Climate infrastructure investment, transport, water, and energy infrastructure designed and financed with explicit climate resilience and mitigation objectives, requires justifying a resilience design premium against avoided future loss, framing return where an asset delivers both mitigation and adaptation benefit simultaneously, and applying long-tenor project finance structuring suited to infrastructure's multi-decade life. This guide covers each of these drivers, building on the general project finance conventions covered elsewhere in this Knowledge Centre.