Research Resources
Supporting research, data and reference material on financial model risk.
-
Sources and Uses Model Template
This template sets out how a project finance sources and uses statement should be structured as a standalone, auditable schedule: a labelled sources section (senior debt, subordinated debt, sponsor equity), a labelled uses section (construction cost, interest during construction, fees, contingency, reserve funding), and a live reconciliation between the two that resolves through formula alone, following the build methodology in Sources and Uses Modelling. It is a structural template, not a source of specific cost or financing assumptions, which must be sourced for each specific transaction.
-
Terminal Value Calculator Template
This template sets out how to calculate DCF terminal value using both the perpetuity growth (Gordon Growth) method and the exit multiple method side by side, with a built-in cross-check cell that back-solves each method's implied value under the other method's assumptions. Calculating both methods together, rather than relying on a single approach, surfaces an unreasonable growth rate, discount rate, or multiple assumption that either method alone might not reveal.
-
WACC Calculator Template
This template sets out how a WACC calculation should be structured as a standalone, auditable block within a financial model: a labelled input section for the risk-free rate, beta, equity risk premium, and cost of debt, a separate capital structure weighting section, and a final blended WACC cell that references every input rather than embedding any value directly. It is a structural template, not a source of specific rate assumptions, which must be sourced and justified for each specific valuation.