Technical Guides

Common Mistakes in DCF Valuation

DCF valuation errors fall into recognizable categories: conceptual confusion between enterprise and equity value, accounting errors in the free cash flow build, Excel and modelling errors that a structural audit can detect directly, judgement errors in the terminal value and discount rate assumptions, and presentation errors that omit the sensitivity disclosure a DCF conclusion requires. This guide catalogs each category with its specific failure modes, cross-referenced to the technical guide addressing the correct construction and, where applicable, the FMAE structural rule that detects the modelling-layer version of the error.

Common Mistakes in Real Estate Financial Modelling

Across development appraisals, income-producing asset models, and entity-level structures such as REITs and joint ventures, the same handful of structural shortcuts recur, entering a top-line figure where a bottom-up build is required, smoothing lease- or unit-level detail into a portfolio average, and treating a calculated output as a static input. This guide draws together the recurring mistakes identified across every model-type and mechanic-specific guide in the Real Estate Financial Modelling domain into a single reference, organized by the underlying pattern rather than by property type.

Common Oil & Gas Modelling Errors

This guide consolidates the recurring structural errors identified throughout the Oil & Gas Financial Modelling domain into a single reference catalogue: decline curve drift from the reserve report, reserve-based lending borrowing base approximation, flat fiscal regime splits, and decommissioning under-provisioning, among others. Each entry links to the specific guide addressing it in full, so this page functions as a quick-reference index rather than a duplicate treatment of content covered elsewhere in the domain.

Common Renewable Modelling Errors

This guide indexes the structural mistakes that recur most frequently across renewable energy and power project financial models — from blended P50/P90 yield assumptions to unreconciled revenue stacks to circular debt sculpting instability — each cross-referenced to the detailed technical guide covering it in full. It is a capstone synthesis for this domain, not a replacement for the detailed guidance each error links back to.

Common Transaction Modelling Errors

This page synthesizes the specific errors that recur across every transaction type covered on this Knowledge Centre, cross-referenced back to the full guide covering each. It exists as a single, scannable reference for a deal team or reviewer who wants to know, at a glance, what tends to go wrong in a transaction model, without re-deriving each failure mode from first principles across a dozen separate guides.

Consolidation Model Structure

A consolidation model combines multiple legal entities' individually correct financial statements into a single group result, and requires three mechanics a single-entity three-statement model does not need: intercompany elimination, removing transactions between group entities so they do not double-count; non-controlling interest allocation, splitting a partially-owned subsidiary's results between the parent and minority shareholders; and currency translation, converting foreign-entity statements into the group's presentation currency. This guide covers how each mechanic should be structured, the standard consolidation worksheet layout, and the most common consolidation errors — most of which originate in an incomplete elimination rather than any individual entity's own statements being wrong.

Construction Period Modelling

The construction phase of a project finance model has no operating revenue and is governed entirely by funding mechanics, the construction cost curve, the drawdown profile, interest during construction, and contingency drawdown, culminating in a commercial operations date (COD) test that governs the transition to operations. This guide sets out how to build each of these mechanics and the common errors that misstate the total construction-phase funding requirement.

Cost Forecasting Methods

Costs cannot be forecast reliably using a single blanket method, because different cost lines behave differently as a business scales. This guide sets out the classification step that should precede any cost forecast — separating fixed from variable costs — followed by the three principal construction methods used in institutional financial models: the percent-of-revenue method for costs that scale proportionally with revenue, driver-based opex build-up for costs tied to a specific operational driver other than revenue, and cost of goods sold construction for the direct costs attributable to production. It is the companion guide to Revenue Forecasting Methods, covering the cost side of the same forecast.

Covenant Analysis and Headroom

Covenant analysis is the process of assessing how much buffer, or headroom, a borrower has against the financial covenant thresholds specified in its loan agreement, and how that headroom is expected to evolve over the life of the financing. Financial covenants generally fall into three categories — leverage covenants, coverage covenants, and minimum liquidity covenants — each tested periodically through a compliance-certificate process in which the borrower calculates and certifies the relevant metric against the applicable threshold. Covenant headroom, not simply a pass/fail compliance result, is the metric that matters most to both borrowers and lenders, because thin or narrowing headroom signals reduced financing flexibility and elevated risk of a technical default well before an actual breach occurs.

Credit Loss Provisions

Credit loss provisioning is the income statement charge that builds up the allowance for credit losses held against a bank's loan portfolio. Provisions should be derived from portfolio-segment loss-rate assumptions applied to segmented loan balances — not a single blended provisioning rate applied to the total book — since default risk varies substantially by product type and risk grade. This guide covers how to structure that segment-level provisioning build and how it connects to the allowance roll-forward on the balance sheet.

Cross Workbook Links in Financial Models

Cross workbook links are formula references in one Excel workbook file that draw data from cells in a separate workbook file. When the source workbook is available and open, the link resolves dynamically. When the source workbook is closed or unavailable, Excel either updates the link by reading the file directly, or retains the last cached value without indicating that the displayed value may be stale. Cross workbook links introduce fragility through path dependency: any change to the name or location of the source file will break the link. In institutional financial models submitted for audit or lender review, cross workbook links that cannot be verified against available source files are a material structural finding.

Cross-Border DCF: Multi-Currency and Country Risk Premium

A cross-border DCF introduces two mechanical requirements beyond a single-currency valuation: the currency of the forecast cash flows must match the currency of the discount rate at every point in the model, and where the target operates in a market with sovereign or political risk beyond a developed-market baseline, that risk must be reflected in the valuation exactly once. This guide sets out the currency-matching principle, the two standard approaches to building a country risk premium into the discount rate, how purchasing power parity and interest rate parity keep a currency-converted valuation internally consistent, and the double-counting error — applying a country risk premium to the discount rate and a separate haircut to the cash flows for the same risk — that is the most common structural defect specific to cross-border DCF models.

Curtailment Risk Modelling

Curtailment risk modelling goes beyond applying a static curtailment percentage: it involves analyzing historical curtailment data at the specific node or zone, forecasting how grid congestion is expected to evolve over the asset's life as more generation connects to the same constrained network, and representing the applicable compensation mechanism accurately. This guide covers how to build a forward-looking curtailment risk model rather than a single static assumption.

DCF Interview Questions: The Complete List

This guide compiles the DCF valuation questions most commonly asked in equity research, investment banking, private equity, and corporate finance technical interviews, organized from conceptual walk-throughs through formula-level technical questions to applied case-style prompts. Each question is answered concisely and institutionally, with links to the fuller technical treatment elsewhere in this Knowledge Centre for candidates who want to go deeper than an interview-length answer requires.

DCF Under IFRS 16 (Lease Capitalization Effects)

IFRS 16 requires lessees to capitalize substantially all leases as a right-of-use asset and a lease liability on the balance sheet, replacing a single straight-line operating lease expense with depreciation of the right-of-use asset and interest on the lease liability. This mechanically inflates reported EBITDA, since lease expense moves from operating expense to below-EBITDA depreciation and interest, and requires a deliberate choice in FCFF construction over whether to treat the lease liability as debt-like. This guide sets out the balance sheet and EBITDA effects, the two internally consistent approaches to building FCFF under IFRS 16, why comparability against US GAAP (ASC 842) or pre-IFRS-16 peers requires a disclosed normalization choice, and the double-counting and historical-forecast inconsistency errors most common in practice.

DCF Valuation Best Practices

This guide synthesizes the construction and disclosure disciplines addressed throughout this Knowledge Centre's DCF coverage into a single, stage-by-stage best-practice reference: how to build free cash flow and the discount rate so every input is traceable, how to calculate and cross-check terminal value, how to disclose sensitivity so the concentration of value in a small number of assumptions is visible, and how to triangulate the DCF conclusion against other valuation methods rather than presenting it in isolation.

Data Centre Acquisition Models

Acquiring an operating data centre requires verifying the quality and durability of its existing contracted revenue, confirming its actual remaining capacity headroom against the binding constraint, and assessing synergy potential specific to combining data centre operations, shared power procurement, network ecosystem consolidation, and overhead rationalisation. This guide sets out how to model a data centre acquisition, distinct from a greenfield development or an internal expansion decision.

Data Centre Business Models

Data centre operators run under several structurally different business models, wholesale colocation, retail colocation, hyperscale build-to-suit, enterprise/captive, and managed services, each of which ties revenue, contract tenor, and capital intensity to a different mechanism. This guide sets out how each business model's revenue and cost mechanism differs and, correspondingly, how the financial model architecture appropriate to each differs, since applying a retail colocation-style model to a hyperscale build-to-suit facility, or vice versa, misrepresents the operator's actual revenue and risk exposure.

Data Centre Capacity Planning Models

Data centre capacity is jointly constrained by power, floor space, and cooling capability, and the binding constraint can shift as tenant rack density changes. This guide sets out how to model capacity planning across all three constraints simultaneously, how phased capacity delivery should be scheduled against demand, and why treating any single constraint as the sole capacity driver risks overstating achievable revenue.

Data Centre Cooling Cost Models

Cooling cost is one of the largest non-IT power draws in a data centre and the primary driver of power usage effectiveness (PUE). This guide sets out how to model cooling cost as a function of cooling technology choice, climate and free cooling opportunity, and rising rack density, and why cooling cost should be modelled explicitly rather than absorbed into a single blended power cost assumption.