Technical Guides
Step-by-step technical guidance for identifying and remediating structural risk in Excel financial models.
-
Infrastructure Operating Cash Flow Models
An infrastructure operating cash flow model translates the operations-phase revenue and cost build into distributable cash, applying the specific priority in which reserve funding, debt service where applicable, and reinvestment obligations are met before any surplus becomes available for distribution to the asset owner or shareholders. This guide covers how to structure that cash flow waterfall from an ongoing asset management perspective, and why accounting profit and distributable cash diverge materially once maintenance and renewal reserve funding are properly represented.
-
Infrastructure Operations Audit
An infrastructure operations audit tests the structural integrity of an asset owner or operator's ongoing operations financial model, formula correctness across revenue, cost, reserve funding, and renewal forecasting, distinct from a project finance model audit scoped to a transaction and debt tenor. This guide covers what an operations audit tests, how it differs from the periodic asset performance review, and how findings should be reported to asset owners and their oversight bodies.
-
Infrastructure and Energy Transactions
A secondary-market acquisition of an operating infrastructure, renewable energy, or PPP asset — as distinct from financing its original construction — introduces transaction-specific mechanics on top of the construction-stage modelling already covered elsewhere on this Knowledge Centre: valuing the asset's remaining concession or power purchase agreement life rather than a full-life projection, sizing an acquisition or refinancing debt facility against the asset's already-established operating track record, and securing consent from existing project lenders whose facility terms may restrict a change in ownership. This guide covers each of these transaction-specific mechanics, common to infrastructure, renewable energy, and PPP secondary-market transactions alike.
-
Infrastructure-Linked Real Estate Model Structure
Real estate value is sometimes directly contingent on infrastructure delivered by a public authority or jointly funded between public and private parties, transit-oriented development being the clearest example, and this dependency should be modelled explicitly, both the developer's own infrastructure funding contribution and the value capture mechanism through which infrastructure investment is recovered. This guide sets out how these dependencies differ from a standard development appraisal and from formal project finance.
-
Insurance Financial Models
An insurance company's financial model shares the balance-sheet-first architecture of a bank model but is driven by an entirely different mechanic: premiums collected and claims paid, with technical reserves — not deposits — as the primary balance sheet liability. This guide covers how an insurance model should be structured: premium and claims forecasting, the reserve build, investment income from the float, and the combined ratio that measures underwriting profitability independent of investment returns.
-
Insurance Mix Modelling
Insurance mix modelling is the technical discipline of forecasting how a provider's payer composition, government, commercial, managed care, and self-pay, evolves over time and translating that composition into a blended revenue and collection outcome. This guide covers how to build a payer mix projection from historical trend and market data, how to test payer concentration and downside shift risk, and how payer mix should connect to the reimbursement method and collection performance assumptions used elsewhere in the model.
-
Integrated Energy Company Models
Integrated energy companies, international majors and national oil companies, operate across upstream, midstream, downstream and, frequently, petrochemicals simultaneously. This guide sets out how a consolidated model for an integrated company should build each segment on its own correct structural basis before consolidating, why segment-level reporting is preserved for capital allocation and valuation purposes, and how integration provides a degree of natural commodity price diversification a single-segment company does not have.
-
Interest Income Modelling
Interest income modelling is the core mechanic of a bank financial model: interest income and expense are derived from forecast asset and liability volumes and their associated yields and costs, not from a standalone revenue assumption. This guide covers how to structure that build at a segment-by-segment level, how net interest income and net interest margin are calculated from it, and how to construct the net interest margin bridge that separates a period's margin change into volume, rate, and mix effects — the single most useful diagnostic output in a bank model.
-
Internal Carbon Pricing
Internal carbon pricing applies a company-determined carbon price, either as a notional shadow price used in investment appraisal or as an actual internal fee charged to business units, to inform capital allocation ahead of, or independent of, an external compliance carbon price. This guide covers the distinction between the shadow price and internal fee mechanisms, how the price level should be set and justified, and how it should be applied consistently across capital expenditure decisions.
-
Investment Banking Models
An investment bank's model must represent several structurally distinct revenue lines — advisory fees, underwriting fees, and trading income — each with a different driver and a materially different volatility profile, rather than blending them into a single fee-income figure the way a simpler institution model might. This guide covers how each revenue line should be modelled, why trading income in particular requires distinct treatment from fee-based revenue, and how capital markets cyclicality should be represented rather than smoothed away.
-
Investor Model Review
Investor model review, commissioned by an equity investor or limited partner ahead of a transaction, focuses on return calculation integrity — IRR and multiple-of-invested-capital mechanics, waterfall and carried interest calculation, and the completeness of sensitivity and scenario analysis around the base case return. It shares underlying structural audit methods with lender and independent model review, but its focus — the return the investor will actually realize, and how that return is allocated among co-investors — is distinct from a lender's focus on covenant compliance and debt service capacity.
-
Islamic Banking Models
An Islamic bank does not earn interest in the conventional sense; instead, it structures financing through Shariah-compliant contracts — murabaha (cost-plus sale), ijarah (leasing), and mudarabah (profit-sharing partnership) among others — each with its own economics that a model must represent structurally rather than simply relabelling conventional interest income. This guide covers how these core contract types should be modelled, how profit-sharing investment accounts differ from conventional deposits, and why treating them as economically identical to conventional banking understates the structural difference.
-
JV Development Model Structure
A joint venture development model layers a partner-level capital call, distribution, and dilution structure on top of the underlying development appraisal or income model, and this partner-level layer should be modelled as its own explicit structure distinct from the project-level cash flow it is calculated from. This guide sets out how capital calls, funding default and dilution, and the JV-level waterfall should be represented, building on the development waterfall and promote treatment covered elsewhere in this domain.
-
Joint Venture Financial Models
Oil and gas assets are frequently developed and operated through joint ventures, with an operator managing day-to-day activity on behalf of itself and non-operating partners holding working interests. This guide sets out how joint venture financial models represent working interest versus net revenue interest, the cash call process funding joint operations, and the authorization for expenditure (AFE) mechanism governing capital commitments under a joint operating agreement.
-
Joint Venture Transactions
A joint venture transaction creates a jointly controlled entity between two or more partners, introducing modelling mechanics that differ from a straightforward acquisition — capital contributions that may be unequal or staged, ownership and governance rights that may not track ownership percentage exactly, a profit distribution or dilution mechanism specific to the venture agreement, and defined exit provisions for when a partner wishes to leave. This guide covers each of these mechanics and how they should be reflected in a joint venture model.
-
LNG Financial Models
LNG financial models sit across the upstream and midstream boundary, depending on a depleting natural gas reserve base for feed gas while also requiring capital-intensive liquefaction infrastructure and long-term offtake sale and purchase agreements to underpin financing. This guide sets out how LNG models are structured around liquefaction train capacity, offtake pricing mechanisms, shipping and regasification economics, and the specific risks, boil-off, price indexation mismatch, and offtake counterparty concentration, that distinguish LNG from both pure upstream and pure midstream modelling.
-
Laboratory Financial Models
Clinical laboratories generate revenue from processing high volumes of relatively low-cost individual tests, with profitability driven by test mix, automation-enabled scale efficiency, and turnaround-time service tiers that command different pricing. This guide covers how to model laboratory test volume and mix, why automation and scale materially change the cost curve, and how turnaround-time commitments should be reflected in both service tier pricing and cost.
-
Land Acquisition Model Structure
Land acquisition in real estate development rarely takes the simple form of a single upfront cash payment. Deferred payment terms, staged payments linked to planning or construction milestones, overage or clawback provisions sharing upside with the seller, and option agreements all introduce structure that a development appraisal model must represent explicitly rather than collapsing into a single land cost input. This guide sets out how each acquisition structure should be modelled and how it interacts with residual land value.
-
Lease Modelling Mechanics
Every lease within a real estate rent roll carries a set of terms beyond the headline rent figure that materially affect cash flow: a free rent or incentive period at the start of the term, a tenant improvement allowance funded by the landlord, and any renewal or early termination options the tenant holds. This guide sets out how each of these lease-level mechanics should be modelled explicitly rather than netted into a simplified effective rent figure.
-
Legal Due Diligence
Legal due diligence investigates a target's corporate structure, material contracts, litigation exposure, and regulatory compliance, establishing both the legal risks a buyer would assume and the contractual protections needed against them. Its findings do not usually enter the transaction model as operating assumptions the way commercial or operational findings do; instead, they typically translate into representations and warranties, indemnities, escrow holdbacks, or specific closing conditions in the purchase agreement, with only quantifiable exposures (a specific pending claim, a contingent liability) entering the model directly as a balance sheet adjustment.