The DCF model, in very simple words, is a way of calculating the value of a company today on the
basis of its future cash flows. In other words, the argument is that money in the future equals little
or no cash today owing to inflation, risk, and because one cannot use this money for some other
good or service now. For example, a DCF model will bring forward future earnings into present terms
by bringing them back to the present.
There are many tried and tested approaches to set about establishing the intrinsic value of a
company or an investment based on its expected performance in the future, but the best tool within
the investor's armoury remains the Discounted Cash Flow, or DCF model. It is the tool which is
widely used by investors, analysts, and professionals in the finance sector in deciding whether an
asset or a company is overvalued or undervalued. But people often find this tricky to build from
scratch.
I'm going to walk you through how to make a DCF model in super friendly words. That way, even
though you don't have finance or else don't know it, we can break it down step by step by the end of
that presentation, and you will know exactly what this thing does and how to apply it.
The heart of any DCF model is the company's free cash flow, basically cash a company generates
after it has covered its operating expenses and capital expenditures like buying new equipment or
investing in growth. Its money left over to return back to investors; therefore, it is the number on
which the DCF model hinges.
How you forecast it:
Estimate Revenue Growth: Estimate a number for the company revenues for the next few years. This
would be based on historical growth rate for the company, what the industry is expected to do or
guidance from management. Generally, you will estimate revenue 5 to 10 years.
Calculate Operating Expenses and EBIT: Net off all the operating expenses, be it salary expense,
rental, or cost of goods sold. That is Earnings before Interest and Taxes, or EBIT. This is how much
money the company generates from its core operations before it pays any interest or taxes.
Taxes: Deduct the taxes paid. Applying this, we get the Net Operating Profit after Taxes, or NOPAT.
The NOPAT is what the firm gets to keep after the government has taken its share.
Lower Capital Expenditures (CapEx): This represents the cash the business requires reinvested to
sustain or expand itself-that is, new machinery, new buildings, new technology, et cetera. Cash here
is being used and not available for distribution to investors.
Adjust for the Changes in Working Capital: It is the amount a company requires to operate on a day-
to-day basis. The change in working capital related to items like inventory and accounts payable will
impact cash flow, and therefore FCF shall be adjusted as well.
Having projected the company's cash flows into the future, you next discount them back to a
present value. You observe that money in the future is worth less than money currently available.
But what discount rate do you use?
Most DCF models apply the WACC of the firm as a discount rate. WACC represents the average rate
at which all forms of debt and equity expect the company to earn. It assumes that the firm finances
its operations using both debt and equity.
WACC Formula can be presented in a simplified mathematical form as
follows:
WACC= [E / V] × Cost of Equity + [D / V] × Cost of Debt × (1 - Tax Rate)
E = market value of equity
D = market value of debt
V = total value, or sum of debt and equity
Cost of Equity is generally determined by reference to CAPM. This takes the risk of investing in the
company compared to the risk associated with the general market.
Since the cash flows of the company cannot be projected into infinity, we make use of a shortcut
known as terminal value in order to estimate and approximate the value of the company beyond our
forecast period, and this forecast period is at least 5-10 years. It therefore represents all cash flows
remaining from that point into infinity.
There are two primary methods of calculating terminal value.
1. Perpetual Growth Method This considers that the cash flow of the company will continue to grow
infinitely. A relatively low growth rate, in the form of long-term GDP or inflation rate, is applied.
================
Terminal Value =
Last Year FCF × (1 + Growth Rate)
WACC - Growth Rate \\
2. Exit Multiple Method It is a method in which a multiple-like an EBITDA multiple-driven by
comparable companies in the same industry, is applied.
You take all the cash flows and the terminal value and bring them back to the present using the
discount rate, WACC. Thus, you have a PV for every cash flow in every single year.
Discounting each year's cash flow by the discount rate is described as
follows:
PV of FCF = FCF/(1 + WACC)^n
Subtract net debt - total debt, minus cash - from enterprise value to find out how much the company
is worth to shareholders. This will be equity value.
Equity Value = Enterprise Value - Net Debt
Equity value is what amount, according to the DCF model, the company's shares are worth today.
You compare this value to how highly the company is priced in the market right now, as found by
taking its current market capitalization.
Lastly, a sensitivity analysis must be done to see the effects of changes in assumptions, especially on the most important assumptions such as revenue growth, WACC or terminal growth rate, on the valuation. This would therefore make you see the kind of uncertainty that bases the valuation and risks that are attached.
Building a Discounted Cash Flow model looks pretty intimidating at first, but breaking it down to
such manageable steps really makes a lot clearer. You're just trying to forecast how much cash the
business will generate, discount that back to what it's worth today and then an intelligent decision
as to whether you want to invest in it or not.
Although the DCF model has its weaknesses-mostly because it rests on many assumptions-it is
nevertheless a very potent tool in that it'll better help you realize what the underlying value is for
some company or asset when used responsibly.