Financial Modelling Best Practices for Investment Analysis
Executive Summary
Key Takeaways
- ✓ Each valuation method used, discounted cash flow, comparable companies, precedent transactions, should be built as its own structurally separate module, cross-checked against the others rather than blended into a single output.
- ✓ Terminal value should be built as an explicit, isolated assumption (a terminal growth rate or exit multiple), clearly separated from the explicit forecast period, since it frequently represents the majority of a DCF's total value and warrants its own visible sensitivity.
- ✓ Discount rate construction (cost of equity, cost of debt, WACC) should be built as its own transparent module with each input assumption visible, not a single hardcoded discount rate.
- ✓ Scenario and sensitivity analysis on the key value drivers should be a structured, first-class output, not a manual reconstruction of the base case under alternative assumptions.
- ✓ Following these construction disciplines makes an investment analysis model easier to review and more likely to pass structural verification cleanly, but it is not itself a verification step.
Why Investment Analysis Models Need a Distinct Build Approach¶
Investment analysis models are built to inform a buy, sell, or hold decision on a security or asset, not to run an operating business day to day. Their central construction challenge is different from a corporate or transaction model: they typically apply more than one valuation method to the same underlying business, and a disproportionate share of the resulting value frequently sits in a single assumption, terminal value, that a builder must isolate and expose clearly rather than let dominate the model implicitly. How a builder separates these methods and isolates that assumption is the central construction question this page addresses.
This is the construction question — how should the model be built — distinct from the audit question addressed on Financial Model Auditing, which covers what an independent structural check verifies once the model already exists.
Core Modelling Components¶
Structurally separate valuation methods. Where more than one valuation method is used, discounted cash flow, comparable companies, precedent transactions, each should be built as its own module producing its own output, with the methods compared side by side (commonly a football-field summary chart or table) rather than blended into a single number. This lets a reviewer see which method is actually driving the investment conclusion.
Discounted cash flow build. The explicit forecast period, building operating assumptions to unlevered free cash flow, should be clearly separated from the terminal value calculation, and both should be discounted using a transparently built weighted average cost of capital rather than an assumed discount rate with no visible derivation.
Terminal value isolation. Terminal value, whether built as a terminal growth rate applied to final-year cash flow or an exit multiple applied to a terminal-year metric, should be built as its own explicit, clearly labelled assumption, separated visually and structurally from the explicit forecast period, and sensitised independently given how large a share of total value it typically represents.
Transparent discount rate module. Cost of equity, cost of debt, and the capital-structure weights feeding the weighted average cost of capital should each be built as visible, separately labelled inputs, not compressed into a single hardcoded discount rate figure that hides its own basis.
Scenario and sensitivity as a first-class output. Because valuation conclusions are typically sensitive to a small number of drivers, near-term growth, discount rate, and terminal assumption, the model should build a structured sensitivity output (a data table or grid) against these drivers as a primary output, not a manual reconstruction after the fact.
Typical Workbook Structure¶
A well-structured investment analysis model sequences the operating forecast, each valuation method as its own module (DCF, comparables, precedents), a summary comparison of the resulting ranges, and a sensitivity output — following the same inputs-to-outputs discipline described on Workbook Design and Model Architecture.
Common Construction Pitfalls¶
Blended valuation outputs. Combining multiple valuation methods into a single averaged figure, rather than presenting each method's own range and comparing them explicitly, hides which method and which assumptions are actually driving the investment conclusion.
Buried terminal value. Embedding the terminal value calculation inside the same formula as the explicit forecast period, rather than isolating it as its own labelled assumption, makes it difficult for a reviewer to see how much of total value depends on an assumption about cash flows beyond the explicit forecast horizon.
Opaque discount rates. Entering a single hardcoded discount rate with no visible cost-of-equity, cost-of-debt, or weighting basis prevents a reviewer from testing whether the rate itself is internally consistent with the model's capital-structure assumptions.
Relationship to Financial Model Audit¶
Building an investment analysis model to these disciplines makes it easier to review and more likely to pass structural verification cleanly, but construction discipline is not itself verification, and it is not investment advice. These practices do not assess whether the growth, margin, discount-rate, or terminal-value assumptions are themselves reasonable — that is a judgement question for the analyst and investment committee. See Financial Model Auditing for the independent structural-verification perspective that applies once the model is built.
Recommended Practices¶
- Build each valuation method used as its own structurally separate module, compared side by side rather than blended.
- Isolate terminal value as an explicit, separately labelled, independently sensitised assumption.
- Build the discount rate as a transparent module showing cost of equity, cost of debt, and capital-structure weights.
- Build scenario and sensitivity analysis on the key value drivers as a structured, first-class output.
- Keep the explicit forecast period and terminal value visually and structurally distinct throughout the model.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Case Studies¶
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
How should a discounted cash flow model be structured?
As an explicit forecast period building to unlevered free cash flow, a clearly separated terminal value calculation, a transparent discount rate (WACC) build, and a present value calculation, with each component visible and independently checkable rather than compressed into a single formula.
Should multiple valuation methods be blended into one output?
No. Each method, discounted cash flow, comparable companies, precedent transactions, should be built as its own module producing its own valuation range, with the methods compared side by side rather than blended into a single number that obscures which method is actually driving the conclusion.
How should terminal value be built?
As an explicit, isolated assumption, either a terminal growth rate applied to the final forecast year's cash flow or an exit multiple applied to a terminal-year metric, clearly separated from the explicit forecast period and sensitised on its own given how much of total value it typically represents.
How should the discount rate be constructed?
As its own transparent module showing the cost of equity, cost of debt, and capital-structure weights feeding the WACC calculation, rather than a single hardcoded discount rate with no visible basis.
How should scenario and sensitivity analysis be built?
As a structured, first-class output, typically a data table or sensitivity grid varying the key value drivers, discount rate, terminal growth or exit multiple, and near-term growth, against the resulting valuation, built to be read directly rather than manually reconstructed.
Does following these construction practices mean the model has been audited?
No. These are disciplines applied by the model's own builder. An independent audit is a distinct check applied after the model exists. See Financial Model Auditing for that perspective.
References
Related Articles
Financial Modelling Best Practices — Standards Compared
Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.
Workbook Design and Model Architecture
Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.
Model Review and QA Workflow
Model review and QA workflow is the internal process lifecycle a modelling team runs on a financial model before it is relied on externally — build, self-check, peer review, and sign-off. This page is not a description of how FMAE audits a model — that is the subject of Audit Methodologies for Financial Models, a distinct page addressing FMAE's own deterministic rule-based engine. This guide addresses the general process a modelling team runs internally, independent of any specific standard, methodology, or audit tool, and applicable whether or not the model is later submitted for independent audit at all.