Technical Guides
Step-by-step technical guidance for identifying and remediating structural risk in Excel financial models.
-
Power Project Financial Model Structure
A power generation financial model is architected around a technical output schedule — generation volume for a variable-output asset or available capacity for a dispatchable one — that drives every downstream calculation: the electricity revenue stack, the operating cost build, and, where the asset is project-financed, debt sculpting and covenant testing. This guide sets out that architecture as a sequence of explicit, separately built modules, distinct from a standard corporate model's revenue-growth-first structure.
-
Power Purchase Agreement (PPA) Modelling
A power purchase agreement is rarely a single flat price for the life of a project — it typically carries a specific pricing formula, a defined volume structure (take-or-pay versus as-available), a tenor shorter than the asset's full operating life, and its own escalation mechanics. This guide covers how each of these PPA components should be built explicitly into a power project financial model, and how the model should represent the transition once the PPA expires.
-
Power Transmission Asset Management Models
A power transmission or distribution network asset management model represents regulated network revenue, a diverse asset base spanning towers, cables, transformers, and substations each with their own renewal cycle, and network reliability metrics as both a regulatory and financial driver. This guide covers how to build that ongoing asset management model, distinct from the project-level interconnection cost and queue-risk treatment covered in Transmission and Grid Models.
-
Precedent Transactions Analysis
Building a precedent transaction analysis requires screening a population of historical M&A deals down to a genuinely comparable set, calculating each deal's transaction multiple on a consistent basis, and adjusting where necessary for disclosed synergies or deal-specific circumstances that would not transfer to the subject transaction. This guide walks through the full build in order — deal screening by timing relevance, deal size, and buyer type; transaction multiple calculation; and adjustment for deal-specific dynamics — along with the structural checks that confirm the resulting multiple range is defensible and reproducible.
-
Production Forecast Models
A company or portfolio-level production forecast aggregates the individual production profiles of many wells and fields, each at a different stage of its own decline, into a single consolidated volume forecast. This guide sets out how production forecasts are built at this aggregate level, the distinction between organic decline and the effect of an ongoing drilling or development programme, and why a portfolio forecast requires reconciliation back to its underlying asset-level building blocks rather than being projected directly from historical aggregate volume.
-
Production Sharing Contract Models
Building a production sharing contract (PSC) into a financial model requires a specific waterfall structure: a cost recovery ceiling limiting how much cost oil or cost gas can be claimed in a period, a carry-forward mechanism for unrecovered cost, and a profit oil or profit gas split that frequently varies with production rate or a cumulative revenue-to-cost ratio known as an R-factor. This guide sets out how to construct that waterfall as a modelling exercise, extending the conceptual definition covered in the Production Sharing Contract glossary entry.
-
Project Finance Model Structure
A project finance model differs structurally from a standard corporate model because it spans a construction phase with no revenue, an operations phase with a debt-sculpted repayment profile and a tiered cash waterfall, and, for concession-based assets, a defined end-of-term handback or termination position. This guide sets out the module architecture that makes such a model auditable and maintainable, building on the general workbook design discipline with the specific sequencing project finance mechanics require.
-
REIT Financial Model Structure
A REIT financial model differs from a single-asset income-producing asset model because it operates at the entity level across a portfolio of assets, is measured against REIT-specific metrics (FFO, AFFO, NAV per share) rather than standard corporate earnings, and is typically subject to a mandated minimum distribution payout ratio that directly constrains retained capital for growth. This guide sets out how these entity-level mechanics should be represented.
-
Rack Revenue Models
Rack revenue is the core billing unit of colocation data centre revenue, priced per rack, per kW of committed power, or a hybrid of the two, with premium pricing for higher-density racks. This guide sets out the mechanics of rack-based pricing, density tiering, and how to model power draw billing and contract escalation without conflating them into a single blended average rate per rack.
-
Railway Operations Financial Models
A railway operations financial model represents the asset's ongoing passenger fare and freight revenue, alongside the two structurally distinct asset classes it depends on: fixed infrastructure (track, signalling, stations) and rolling stock, each renewing on its own separate cycle. This guide covers how to build that operations-phase model, including rolling stock maintenance contract structure and the specific asset lifecycle mechanics that distinguish rail from road-based transport infrastructure.
-
Real Estate Assumption Validation Guide
Validating a real estate model's commercial assumptions, whether its pricing, absorption pace, capitalization rate, or construction cost figures are themselves reasonable, is a distinct discipline from structural audit, which tests whether the model's formulas calculate correctly from whatever assumptions are entered. This guide sets out how each major real estate assumption category should be validated against independent market evidence, and how validation and structural audit fit together as complementary, not overlapping, review functions.
-
Real Estate Exit Valuation Methods
A real estate model's exit assumption, sale, refinance, or continued hold, determines how the model's final value is calculated and what returns metrics are meaningful, and should be stated explicitly rather than left ambiguous. This guide sets out how each exit strategy should be modelled, how exit timing sensitivity should be tested, and why switching exit strategy assumptions mid-model without updating the returns calculation is a common structural error.
-
Refinancing Model Construction
A project finance refinancing model tests replacing an existing debt facility with new terms, typically once a project has de-risked following construction completion or a stable operating track record, and warrants its own construction discipline distinct from the original financial close model. This guide sets out how to build the refinancing switch as a single controlled toggle, how refinancing gain sharing mechanics between sponsors and lenders are typically structured, and the difference between a par and a discounted refinancing.
-
Refinery Financial Models
Refinery financial models build on the segment-level crack spread economics covered in Downstream Financial Models with process unit-level detail: refinery complexity and its effect on achievable product yield, crude slate flexibility, and the explicit scheduling of periodic turnaround capital expenditure. This guide sets out how a refinery model is structured at this level of detail, and the modelling errors that arise from collapsing unit-level detail into a single blended margin assumption.
-
Regulatory Model Governance
Regulatory model governance is the framework a bank uses to inventory, tier, approve, and monitor every model it relies on for a material business or regulatory purpose. This guide covers the core components of that framework — a comprehensive model inventory, a risk-based tiering methodology, a formal approval process before a model is used in production, and ongoing performance monitoring — and why an incomplete inventory is the single most common gap regulators identify in bank model governance frameworks.
-
Regulatory Reporting Models
Regulatory reporting models translate a bank's underlying financial position into the specific format and definitions required by its regulatory returns — capital adequacy, liquidity, and credit exposure reporting among others. This guide covers why these reporting models should reconcile explicitly to the same underlying balance sheet, capital, and liquidity calculations built across this domain rather than being maintained as a separate, disconnected reporting exercise, and the specific reconciliation discipline that keeps regulatory and management reporting internally consistent.
-
Rehabilitation Centre Models
Rehabilitation facilities generate revenue from therapy sessions and bundled care-episode payments tied to functional recovery progress, with length of stay driven by clinical outcome milestones rather than a fixed diagnosis-based expectation alone. This guide covers how to model therapy-session-based and episode-based revenue structures, how functional outcome progress should inform length-of-stay forecasting, and how the interdisciplinary staffing model specific to rehabilitation should be reflected in the cost structure.
-
Reliability Modelling
Reliability modelling estimates the probability that an infrastructure asset or component will continue to perform its intended function over a given period, typically expressed through failure rate or mean time between failure, and uses that estimate to inform maintenance strategy and renewal timing decisions. This guide covers how to build a reliability model for infrastructure asset management: sourcing failure data, distinguishing random failure from wear-out failure, and connecting reliability estimates to the broader asset management financial model.
-
Renewable Energy Best Practices
This guide is the capstone synthesis of the construction and governance discipline recommended across the Energy Financial Modelling pillar: building the technical output chain and revenue stack as explicit, separately sourced modules; sourcing every technical assumption from independent evidence; and applying structural audit, validation, and independent assurance before a model is relied upon for a financing or investment decision. It indexes the domain's recommended practices into a single reference, cross-linked to the detailed guidance behind each.
-
Renewable Energy Climate Models
Modelling renewable energy as a climate finance asset class addresses a different question than building a single power project's financial model: how to quantify a renewable investment's avoided emissions and climate additionality, construct the climate-specific investment case a climate fund or development finance institution requires, and structure blended finance for deployment in markets commercial capital alone would not reach. This guide covers each of these portfolio- and investment-level drivers, building on the project-level mechanics covered elsewhere in this Knowledge Centre's energy content.