Technical Guides

Lender Model Review for Energy Projects

Lender model review for a power project financing applies the general transaction lender model review discipline with an added focus specific to this asset class: confirming the resource yield assessment feeds debt sizing at the correct confidence level, testing debt sculpting convergence under downside technical scenarios, and reconciling technical assumptions against the independent engineer's report. This guide covers these energy-specific additions to the lender review process.

Lender Model Review in Transactions

Lender model review in a transaction context tests the financing mechanics specific to an acquisition or transaction debt facility — new debt sizing against the target's pro-forma cash flow, covenant calculation integrity, and pro-forma leverage recalculated against the post-transaction capital structure. It shares its underlying covenant and debt-sculpting methodology with the existing lender model review discipline for ongoing project finance facilities, applied specifically to the acquisition-financing context, where pro-forma figures — not standalone historical ones — are what the lender is actually underwriting.

Lifecycle Cost Analysis

Lifecycle cost analysis is the analytical process built around the whole-life cost formula: where the cost inputs for each category should be sourced from, how uncertainty in long-dated maintenance and renewal cost estimates should be tested through sensitivity analysis, and how a lifecycle cost comparison result should actually be interpreted and used in an investment or procurement decision. This guide covers that process, distinct from the discounting mechanics themselves covered in whole-life cost modelling.

Lifecycle Cost Validation

Lifecycle cost validation is the independent check applied to a whole-life cost comparison or lifecycle cost analysis before its result is relied on for an investment, procurement, or design decision: verifying input sourcing against the defined hierarchy, confirming the discount rate is properly justified, and testing whether the sensitivity analysis actually covers the drivers the decision is sensitive to. This guide covers what this validation should test and why a lifecycle cost result should not be relied on for a material decision without it.

Liquidity Coverage Ratio

The liquidity coverage ratio (LCR) tests whether a bank holds enough high-quality liquid assets to survive a defined 30-day acute stress scenario. This guide covers how to model the LCR's two components — the stock of high-quality liquid assets and net cash outflows under the stress scenario — and how the deposit and funding behavioural assumptions built elsewhere in the model feed directly into the outflow calculation.

Loan Loss Forecasting

Loan loss forecasting extends the segment-level credit loss provisioning build into a forward-looking exercise, projecting how expected loss rates evolve across the forecast period as macroeconomic conditions and portfolio composition change. This guide covers how to structure that forward-looking loss-rate projection, how it should respond to defined economic scenarios, and how it connects the credit loss provisioning module to the base and stressed forecasts elsewhere in the model.

Loan Portfolio Modelling

Loan portfolio modelling is the asset-side counterpart to deposit modelling: the loan book should be segmented by product type, risk grade, or business line, each carrying its own origination, repayment, yield, and expected loss assumptions. This guide covers how to structure that segmentation, how to roll forward segment-level balances period over period, and how the segmented output feeds both the interest income build and credit loss provisioning.

Long-Term Asset Governance

Long-term asset governance establishes the accountability structure, escalation path, and reporting discipline that keeps an infrastructure asset management financial model genuinely governed across a multi-decade asset life, well beyond the tenure of any individual asset manager or board member. This guide covers how governance should be structured so it survives personnel turnover, how a renewal funding gap should escalate to a body with actual funding authority, and what a governing board needs to see to exercise real oversight.

Long-Term Care Facility Models

Long-term care and skilled nursing facilities generate revenue from resident census combined with acuity-tiered reimbursement, and carry occupancy dynamics that sit closer to residential real estate than to acute hospital operations. This guide covers how to model census-driven revenue and acuity mix, how length-of-stay dynamics differ fundamentally from acute care, and why occupancy stability, not turnover, is the central operating metric in this setting.

Maintenance Cost Models

Maintenance cost modelling for an infrastructure asset or portfolio forecasts routine (day-to-day) and major (periodic, large-scale) maintenance spend from asset condition and criticality data, structures the reactive-versus-planned maintenance mix, and connects major maintenance cost to its reserve funding mechanism. This guide covers general infrastructure maintenance cost modelling — buildings, transport assets, utility networks, and similar physical infrastructure — distinct from the power project O&M contract mechanics covered in Operations and Maintenance (O&M) Cost Models.

Maintenance Reserve Models

A maintenance reserve model builds the funding, drawdown, and adequacy-testing mechanics behind a maintenance reserve account or capital renewal reserve: how the periodic contribution is sized, how the reserve balance is tracked and tested against the forecast renewal cost curve, and how an adequacy test should be structured to catch underfunding before a scheduled event occurs. This guide covers that full modelling treatment, extending the glossary-level maintenance reserve account definition into the mechanics an operations financial model actually needs to build.

Management Reporting and KPI Dashboard Model Structure

A management reporting or KPI dashboard model is not a separate calculation engine — it is a presentation layer that extracts, re-derives, and re-presents figures already produced by an underlying three-statement model. This guide covers how that layer should be structured: every dashboard figure formula-linked back to its source in the underlying model rather than re-keyed or pasted, KPIs defined once with a documented formula rather than calculated inconsistently across different reports, and a clear separation between the calculation engine (where figures are produced) and the reporting layer (where they are selected, formatted, and presented) so that a change to the underlying model flows through to every report automatically.

Masterplan Model Structure

A masterplan spans multiple land parcels, asset classes, and often decades of delivery, requiring a model architecture built around parcel-level disposal or development strategy, infrastructure cost recovery across the full plan life, and land value uplift capture as later parcels benefit from infrastructure and placemaking delivered by earlier phases. This guide sets out how these masterplan-specific mechanics should be represented, extending the phasing and mixed-use treatment covered elsewhere in this domain.

Medical Device Financial Models

Medical device companies operate under regulatory approval pathways that vary by device risk classification, and many, particularly capital equipment manufacturers, generate revenue through a razor-and-blade model: device placement followed by recurring consumables revenue. This guide covers how regulatory classification affects approval timeline and cost modelling, how device-generation unit economics should be tracked through product iteration, and how razor-and-blade revenue should be modelled as two distinct, linked revenue streams.

Merchant Power Models

Merchant power revenue is sold at prevailing market price rather than under a fixed-price contract, carrying genuine, undetermined price risk that a static assumption understates. This guide covers how to build merchant exposure into a power project model: constructing a forward price curve, testing an explicit sensitivity range around it, representing any hedging arrangement, and modelling the merchant tail that follows PPA or contract expiry.

Merger Model and Accretion/Dilution Structure

A merger model tests whether a proposed acquisition increases or decreases the acquirer's earnings per share — the accretion/dilution result — by combining standalone projections for the acquirer and target with the mechanics specific to the transaction itself: purchase price allocation and the resulting goodwill, the financing structure (cash, new debt, or newly issued stock, in any combination), and any synergies expected from the combination. This guide covers the build sequence in full: standalone projections first, then purchase price allocation, then the financing structure and its effect on pro-forma shares and interest expense, then synergies traced to specific line items rather than a single aggregate assumption, and finally the accretion/dilution calculation itself, with the structural checks that catch the errors most specific to this model type.

Mid-Year Convention and Stub Periods in DCF

Standard period-end discounting assumes every period's cash flow arrives as a single lump sum on the last day of that period, which understates present value for a business that generates cash continuously throughout the year. The mid-year convention corrects for this by discounting each period's cash flow as though received at its midpoint. This guide sets out why period-end discounting understates value, the mid-year discount factor formula, how to build a pro-rated stub-period discount factor when the first forecast period is not a full year, how mid-year convention should be applied consistently to terminal value, and the common Excel implementation errors that arise from mixing conventions inconsistently across a forecast.

Midstream Financial Models

Midstream financial models cover the gathering, transport, processing and storage of produced hydrocarbons, assets that are effectively non-depleting and whose revenue is instead driven by contracted throughput volumes, regulated or negotiated tariffs, and take-or-pay commitments. This guide sets out how midstream models are structured, the contract mechanics that determine revenue certainty, and why the segment is modelled closer to conventional project finance infrastructure than to upstream reserve depletion.

Model Documentation Standards for Financial Models

Model documentation standards define what written records must accompany an institutional financial model to enable its outputs to be understood, verified, and relied upon by parties other than its original developer. The minimum documentation package for an institutional financial model includes an assumption log recording the source and rationale for every input, a version history recording all material changes, a model map describing the structure and purpose of each worksheet, instructions for use, and a disclosure of known limitations. The ICAEW Financial Modelling Code and the FAST Standard both establish specific documentation requirements that define institutional expectations.

Model Governance During Transactions

Model governance during a live transaction faces a specific pressure the general discipline described on the existing Model Governance glossary page does not fully anticipate — a deal model typically changes rapidly, across multiple contributing parties (the deal team, advisors, sometimes the target's own team), against hard external deadlines, with version discipline the first casualty when time pressure is highest. This guide extends general model governance practice to that specific context: which version is authoritative at any given moment, who has sign-off authority to change a live deal model, and how documentation discipline should be maintained even as the model itself is under constant revision.