Discounted Cash Flow (DCF): Learn Formulas, Examples, Uses


What is a DCF model?

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.

Discounted Cash Flow (DCF): Learn Formulas, Examples, Uses

1. Estimate Free Cash Flows (FCF)


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.

2. Determine a Discount Rate


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.

3. Calculation of Terminal Value

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.

4. Discounting Cash Flows to Present Value

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

5. Calculating Equity Value

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.

6. Sensitivity Analysis

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.

Conclusion of Discounted Cash Flow (DCF): Learn Formulas, Examples, Uses



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.

Browse All Courses

TRENDING
Discounted Cash Flow (DCF): Learn Formulas, Examples, Uses


4.7

Financial Planning & Analysis (FP&A)

Switch your career in core finance profile

983398

935834



Financial Planning & Analysis (FP&A)

DURATION : 4.5 MONTHS

ACCESS : Lifetime

ELIGIBLE FOR : 3+ Year Experience in Any Field (MBA/PGDM Finance, CA, CFA, CS, CMA, M.Com, B.Com, BBA, BE, M.Tech, CIMA)

COURSE FEE : 30000/-

TRENDING


4.7

Financial Modelling Equity Research - Short Term Financial Analyst

Gain skills and experience to land in your dream job!

1211044

1195731



Financial Modelling Equity Research - Short Term Financial Analyst

DURATION : 3.5 Months

ACCESS : Lifetime

ELIGIBLE FOR : Any graduate/Fresher as well as Experience

COURSE FEE : 20000/-

TRENDING


4.7

Financial Analyst-1 Year - CERTIFIED FINANCIAL ANALYSIS

100% Job Guaranteed - 1 yr on Job Experience as an Analyst

987126

937656



Financial Analyst-1 Year - CERTIFIED FINANCIAL ANALYSIS

DURATION : 12 Months on Job Training

ACCESS : Lifetime

ELIGIBLE FOR : BCom, BBA, BMS, BE,B.Tech. BSC, BA, CA, CFA, MBA

COURSE FEE : 299000/-

TRENDING


4.7

Investment Banking (IB)

Become a top-tier investment banker

95288

91983



Investment Banking (IB)

DURATION : 4.5 months

ACCESS : Lifetime

ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA, BBA, Mcom, BCom

COURSE FEE : 30000/-

TRENDING


4.7

Startup Valuation

Acquire job ready skills to work in PE/VC/IB

52656

51567



Startup Valuation

DURATION : 4 MONTHS

ACCESS : Lifetime

ELIGIBLE FOR : Any Graduate, Bcom, BBA, BE, CA, CFA, MBA

COURSE FEE : 30000/-

TRENDING


4.7

Microsoft Power BI

Master the art of storytelling with data visualization

33462

25247



Microsoft Power BI

DURATION : 24 Hrs.

ACCESS : Lifetime

ELIGIBLE FOR : Any professional , fresher Students

COURSE FEE : 10000/-

TRENDING


4.7

Excel Expert

Excel Expert

10163

10034



Excel Expert

DURATION : 4 MONTHS

ACCESS : Lifetime

ELIGIBLE FOR : Bcom, BBA, BE, CA, CFA, MBA

COURSE FEE : 3000/-

 Enquiry