Skip to content
How to Build a DCF Model

How to Build a DCF Model: Step-by-Step Tutorial

By Andrew Stotz

A DCF model projects a company’s future cash flows, discounts them to today’s value, and produces an estimate of what the business is intrinsically worth. It is the core analytical tool in DCF valuation, the method used by investment banks, equity research analysts, and corporate finance teams to value companies based on fundamentals rather than…

Read More

P&L Forecasting

By Andrew Stotz

Three things that really matter on “Profit and Loss statement” or what we also call “Income statement” in the US or “P&L” in the UK. First …

Read More

Abbreviations

By Andrew Stotz

Abbreviations you might encounter working with the ValueModel or any forecasting and valuation: WACC, COE, ROIC, DPR, CAPEX, FCFF, EPS…

Read More

Data updates

By Andrew Stotz

Gaining advantage by exploiting new data instantly is only possible if done immediately. This is how to manually update the data …

Read More

Valuation Master Class forecasting guidance

By Andrew Stotz

ValueModel is a three-stage model to cover three phases of a company’s growth life cycle divided into three categories: P&L, balance sheet …

Read More

Total asset growth, net fixed asset growth and CAPEX-to-depreciation

By Andrew Stotz

ValueModel checks if your total asset growth, net fixed asset growth, and CAPEX-to-depreciation forecast deviate substantially from the past.

Read More

Theory

By Andrew Stotz

P/E is an easy to use and commonly used measure of company value, it can be described as what you would pay in price for one in earnings.

Read More

Terminal multipliers

By Andrew Stotz

We estimate the terminal value of cash flows by valuing the company as a perpetuity using the Gordon Growth model.

Read More

Sector specific issues

By Andrew Stotz

All industry-related issues regarding your forecast. Common-sized P&L and Balance Sheet data will help put your forecast into perspective

Read More

Misclassification

By Andrew Stotz

We help you with the identification and correction of misclassifications. Here are some of the data difficulties we encountered in the past:

Read More