Discounted Cash Flow (DCF)

Reviewed byDheeraj Vaidya, CFA, FRM

What is Discounted Cash Flow (DCF)?

The Discounted Cash Flow (DCF) valuation model determines the company’s present value by adjusting future cash flows to the time value of money. This DCF analysis assesses the current fair value of assets or projects/companies by addressing inflation, risk, and cost of capital, analyzing the company’s future performance.

In other words, the DCF valuation model uses a company’s forecasted free cash flows and discounts them back to arrive at the present value estimate, which forms the basis for the potential investment now.

Key Takeaways

  • The Discounted Cash Flow (DCF) valuation model determines the present value of a company by adjusting future cash flows to account for the time value of money. 
  • It assesses the current fair value of assets or projects/companies by considering factors such as inflation, risk, and the cost of capital and predicts the company’s future performance. 
  • The seven steps involved in DCF analysis include projecting financial statements, calculating free cash flow to the firm, determining the discount rate, calculating the terminal value, performing present value calculations, making necessary adjustments, and conducting sensitivity analysis.

Discounted Cash Flow (DCF) Valuation Analogy


You are free to use this image o your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Discounted Cash Flow (DCF) (

Let us take a simple discounted cash flow example. Suppose you can choose between receiving $100 today and obtaining $100 in a year. Which one will you take?

Here the chances are more that you will consider taking the money now because you can invest that $100 today and earn more than $100 in the next twelve months. So, you thought about the money today because it is worth more than the money in the future due to its potential earning capacity (time value of money conceptTime Value Of Money ConceptThe Time Value of Money (TVM) principle states that money received in the present is of higher worth than money received in the future because money received now can be invested and used to generate cash flows to the enterprise in the future in the form of interest or from future investment appreciation and more).

Now, apply the same calculation for all the cash you expect a company to be producing in the future and discount it to arrive at the net present value. You can have a good understanding of the company’s value.

Assuming that you understood this simple DCF stock example, we will move to the practical discounted cash flow example of Alibaba IPOAlibaba IPOAlibaba is the most profitable Chinese e-commerce company and its IPO is a big deal due to its size. With its huge size and network, Alibaba IPO may look at international expansion beyond China and may lead to price wars and intensive competition in the more.

Financial Modeling & Valuation Course (25+ Hours of Video Tutorials)

If you want to learn Financial Modeling & Valuation professionally , then do check this ​Financial Modeling & Valuation Course Bundle​ (25+ hours of video tutorials with step by step McDonald’s Financial Model). Unlock the art of financial modeling and valuation with a comprehensive course covering McDonald’s forecast methodologies, advanced valuation techniques, and financial statements.

7 Steps of Discounted Cash Flow Valuation Model

As a professional investment banker or an Equity Research AnalystEquity Research AnalystAn equity research analyst is a qualified professional who interprets financial information and trends of an organization or industry to provide recommendations, opinions, reports, and projections on the corporate stocks to facilitate equity more. You are expected to perform DCF comprehensively. Below is a step-by-step approach to discounted cash flow analysis (as done by professionals).

Seven Steps to DCF

You are free to use this image o your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Discounted Cash Flow (DCF) (

Here are the seven steps to Discounted Cash Flow (DCF) Analysis –

Step #1 – Projections of the Financial Statements

The first thing that needs your attention while applying discounted cash flow analysis is determining the forecasting period, as firms, unlike humans, have infinite lives. Therefore, analysts’ have to decide how far they should project their cash flow in the future. The analysts’ forecasting period depends on the company’s stages, such as early to business, high growth rate, stable growth rate, and perpetuity growth rate.

Step 1 - DCF

IMPORTANT – Look at this step-by-step guide to Financial Modeling in Excel.

The forecasting period plays a critical role because small firms grow faster than more mature firms and thus carry a higher growth rate. So, the analysts do not expect the firms to have infinite lives because the small firms are more open to acquisition and bankruptcy than the larger ones. The thumb rule says that DCF analysis is widely used during a firm’s estimated excess return period in the future. In other words, for a company that stops covering its costs through investments or fails to generate profits, you need not perform a DCF analysis for the next five years or so.

Forecasting is done professionally using Financial modelingFinancial ModelingFinancial modeling refers to the use of excel-based models to reflect a company's projected financial performance. Such models represent the financial situation by taking into account risks and future assumptions, which are critical for making significant decisions in the future, such as raising capital or valuing a business, and interpreting their more. Here you prepare a three statement modelThree Statement ModelA 3 statement model is a type of financial modeling that connects three key financial statements: income statements, balance sheets, and cash flow statements. It prepares a dynamically linked single economic model used as the base of complex financial models like leverage buyout, discounted cash flow, merger models, and other financial more and all the supporting schedules like the depreciationDepreciationDepreciation is a systematic allocation method used to account for the costs of any physical or tangible asset throughout its useful life. Its value indicates how much of an asset’s worth has been utilized. Depreciation enables companies to generate revenue from their assets while only charging a fraction of the cost of the asset in use each year. read more, working capital, intangibles, shareholder’s equity EquityShareholder’s equity is the residual interest of the shareholders in the company and is calculated as the difference between Assets and Liabilities. The Shareholders' Equity Statement on the balance sheet details the change in the value of shareholder's equity from the beginning to the end of an accounting more schedule, other long term items schedule, debt scheduleDebt ScheduleA debt schedule is the list of debts that the business owes, including term loans, debentures, cash credit, etc. Business organizations prepare this schedule to know the exact amount of the company's liability to others and manage its cash flows to prevent the financial crisis and enable better debt more, etc.

Projecting the Income Statement

Alibaba DCF Step 1

Projecting the Balance Sheet

Alibaba DCF Step 1 - balance sheet

Projecting the Cash Flow Statements

Alibaba DCF Step 1 - Cash Flows

Step #2 – Calculating Free Cash Flow to Firm

The second step in discounted cash flow analysis is calculating the firm’s free cash flow.

Step 2 - DCF

Before we estimate future free cash flow, we must first understand what free cash flow is. Free cash flow is the cash left out after the company pays all operating and required capital expenditures. The company uses this free cash flow to enhance its growth by developing new products, establishing new facilities, paying dividends to its shareholders or initiating share buybacksShare BuybacksShare buyback refers to the repurchase of the company’s own outstanding shares from the open market using the accumulated funds of the company to decrease the outstanding shares in the company’s balance sheet. This is done either to increase the value of the existing shares or to prevent various shareholders from controlling the more.

Free cash flow reflects the firm’s ability to generate money out of its business, strengthening the financial flexibility it can use to pay its outstanding net debt and increase shareholder value.

Calculate FCFFCalculate FCFFFCFF (Free cash flow to firm), or unleveled cash flow, is the cash remaining after depreciation, taxes, and other investment costs are paid from the revenue. It represents the amount of cash flow available to all the funding holders – debt holders, stockholders, preferred stockholders or more is as follows –

Free Cash Flow to Firm or FCFF Calculation = EBIT x (1-tax rate) + Non-Cash Charges + Changes in Working capital – Capital Expenditure

EBIT x (1-tax rate)Flow to total capital removes capitalization effects on earnings
Add: Non-Cash ChargesNon-cash charges like depreciation, amortization
Add: Changes in Working CapitalIt can be an outflow or inflow of cash. Watch for large swings year-to-year in forecasted working capital
Less: Capital ExpenditureCritical to determining CapEx levels required to support sales and margins in the forecast

After projecting the financials of Alibaba, you can link the individual items below to find the free cash flow projections for Alibaba.

Discounted Cash Flow Step 2 - FCFF

Having estimated the free cash flows for the next five years, we have to figure out the worth of these cash flows at the present time. However, to get to know the present value of these future cash flows, we would require a discount rate that one can use to determine the net present value or NPVNet Present Value Or NPVNet Present Value (NPV) estimates the profitability of a project and is the difference between the present value of cash inflows and the present value of cash outflows over the project’s time period. If the difference is positive, the project is profitable; otherwise, it is more of these future cash flows.

Step 3- Calculating the Discount Rate

The discounted cash flow valuation analysis’s third step is calculating the discount rate.

Step 3 - DCF

Several methods are being used to calculate the discount rate. But, the most appropriate way to determine the discount rate is to apply the concept of the weighted average cost of capital, known as WACC. First, however, you have to keep in mind that you have taken the right figures of equity and the after-tax cost of debtAfter-tax Cost Of DebtCost of debt is the expected rate of return for the debt holder and is usually calculated as the effective interest rate applicable to a firms liability. It is an integral part of the discounted valuation analysis which calculates the present value of a firm by discounting future cash flows by the expected rate of return to its equity and debt more, as the difference of just one or two percentage points in the cost of capital will make a vast difference in the fair valueFair ValueThe fair value of an investment is the asset sale price that is agreeable to both the buyer and the seller. There is a caveat; the amount should be agreeable in a free trade scenario; there should be no external pressure or more of the company. So, let us find out how the cost of equity and debt is determined.

Cost of Equity

Unlike the debt portion, which pays a set interest rate, equity does not have an actual price it pays to the investors. However, it does not mean that equity does not bear a cost. We know that the shareholders expect the company to deliver absolute returnsAbsolute ReturnsAbsolute return refers to the percentage of value appreciation or depreciation of an asset or fund over a certain period. Such assets include mutual funds, stocks and fixed more on their investment in the company. Thus, from the firm’s viewpoint, the required rate of return from the investors is the cost of equity. If the company fails to deliver the necessary rate of return, the shareholders will sell their positions in the company. As a result, it will hurt the share price movement in the stock market.

The most common method to calculate the capital cost is apply the capital asset pricing modelApply The Capital Asset Pricing ModelThe Capital Asset Pricing Model (CAPM) defines the expected return from a portfolio of various securities with varying degrees of risk. It also considers the volatility of a particular security in relation to the more or (CAPM). As per this method, the cost of equity would be (Re)= Rf + Beta (Rm-Rf).


Cost of Debt

The cost of debt is easy to calculate compared to equity. The rate implied to determine the cost of debt is the current market rate that the company pays on its current debt.

For simplicity in the context of the discussion, I have taken the WACC figures directly as 9%.

Discounted Cash Flow Step 3 - WACC

IMPORTANT – You can refer to our detailed + [Cost of Debt * % of Debt * (1-Tax Rate)]” url=””]WACC guide”WACC”The, wherein we have discussed how to calculate this professionally with multiple examples, including that of Starbucks WACC.

Step 4 – Calculating the Terminal Value

The fourth step in discounted cash flow analysis is calculating the terminal value.

Step 4 - DCF

We have already calculated the critical components of DCF analysis, except the terminal value. Therefore, we will now calculate the terminal value, followed by the discounted cash flow analysis calculation. There are several ways to calculate the terminal value of cash flows.

However, the most commonly known method is to apply a perpetuity method using the Gordon Growth ModelGordon Growth ModelGordon Growth Model is a Dividend Discount Model variant used for stock price calculation as per the Net Present Value (NPV) of its future dividends. read more to value the company. The formula to calculate the terminal value for future cash flow is:

Terminal Value = Final Year Projected Cash Flow * (1+ Infinite Growth Rate)/ (Discount Rate-Long Term Cash Flow Growth Rate)

Discounted Cash Flow Step 4 - Terminal Value 1

Step 5 – Present Value Calculations

The fifth step in discounted cash flow analysis is to find the present values of free cash flows to the firm and terminal values.

Step 5 - DCF

Find the present value of the projected cash flows using NPV formulas and XNPV formulas.

The projected cash flows of the firm are divided into two parts: –

  • Explicit Period (the period for which FCFF was calculated – till 2022E)
  • Period after the explicit period (post 2022E)
Discounted Cash Flow Step 5

Present Value of Explicit Forecast Period (the year 2022)

Calculate the Present Value of the Explicit Cash Flows using the WACC derived above.

Discounted Cash Flow Step 5 - present value

Present Value of Terminal Value (beyond 2022)

Discounted Cash Flow Step 5 - present value of terminal value

Step 6- Adjustments

The sixth step in discounted cash flow analysis is to adjust your enterprise valuation.

Step 6 - DCF

Adjustments to the discounted cash flow valuations are made for all the non-core assets and liabilities that have not been accounted for in the free cash flow projections. To find the adjusted fair equity valueEquity ValueEquity Value, also known as market capitalization, is the sum-total of the values the shareholders have made available for the business and can be calculated by multiplying the market value per share by the total number of shares more, one may adjust valuation by adding unusual assets or subtracting liabilities.

Common discounted cash flow valuation adjustments include: –

ItemsAdjustments to DCF (Discounted Cash Flows)
Net Debt (Total Debt – Cash)Market Value
Underfunded/overfunded pension liabilitiesMarket Value
Environmental LiabilitiesBased on company reports
Operating Lease LiabilitiesEstimated Value
Minority InterestMarket Value or Estimated Value
InvestmentsMarket Value or Estimated Value
AssociatesMarket Value or Estimated Value

Adjust your valuation for all assets and liabilities. For example, cash flow projections do not account for non-core assets and liabilities. As a result, the enterprise value may need to be adjusted by adding other unusual assets or subtracting liabilities to reflect the company’s fair value. These adjustments include: –

DCF Valuation Summary

Discounted Cash Flow Step 6 - Adjustments1

Step 7 – Sensitivity Analysis

The seventh step in discounted cash flow analysis is calculating the output’s sensitivity analysisCalculate Sensitivity AnalysisSensitivity analysis is a type of analysis that is based on what-if analysis, which examines how independent factors influence the dependent aspect and predicts the outcome when an analysis is performed under certain more.

Step 7 - DCF

It is important to test your DCF model with the changes in assumptions. The two of the most important beliefs that have a major impact on valuations are: –

  • Changes in the infinite growth rate
  • Changes in weighted average cost of capital

We can easily do Sensitivity Analysis in excelSensitivity Analysis In ExcelSensitivity analysis in excel helps us study the uncertainty in the output of the model with the changes in the input variables. It primarily does stress testing of our modeled assumptions and leads to value-added insights. In the context of DCF valuation, Sensitivity Analysis in excel is especially useful in finance for modeling share price or valuation sensitivity to assumptions like growth rates or cost of more using DATA TABLES.

The below chart shows the sensitivity analysis of Alibaba’s DCF valuation model.

Discounted Cash Flow Step 7 - Sensitivity analysis
  • We note that the base case valuation of Alibaba is $78.3 per share.
  • When WACC changes from 9% to, say, 11%, then the DCF valuation decreases to $57.7.
  • Likewise, if we change the infinite growth rates from 3% to 5%, the fair DCF valuation becomes $106.5.


We know that discounted cash flow analysis helps calculate the company’s value today based on the future cash flow. That is because the company’s value depends upon the sum of the cash flow that the company produces in the future. However, we must discount these future cash flows to arrive at the present value.

Frequently Asked Questions (FAQs)

1. What are the benefits of applying the DCF valuation model?

The DCF valuation model offers several benefits. It provides a systematic approach to evaluating the intrinsic value of an investment. Incorporating the time value of money enables a more accurate assessment of future cash flows and adjusts them to their present value. This allows investors to compare and make informed decisions based on their present value between different investment opportunities. 

2. What are the applications of the DCF valuation model?

The DCF valuation model finds applications in various areas. It is commonly used to value companies and determine their fair market value. By projecting future cash flows and discounting them back to the present, the model helps assess the worth of investment projects and evaluate their potential returns. It is also utilized in analyzing mergers and acquisitions, as it helps estimate the target company’s value. 

3. What are the limitations of the DCF valuation model?

While the DCF valuation model offers valuable insights, it has certain limitations to consider. One limitation is its reliance on future projections, which are subject to uncertainty and can be challenging to predict accurately. The accuracy of inputs, such as cash flow estimates and the discount rate, can significantly impact the final valuation. 

This article guides Discounted Cash Flow Valuation (DCF) Analysis. We discuss the 7-step approach to building a DCF valuation model for Alibaba. You may also have a look at the following articles to learn more about valuations: –

Reader Interactions


  1. Dheeraj G says

    Excellent article!!! as always, best site for financial knowledge

    • Dheeraj Vaidya says

      Thanks for your kind words!

  2. Asif Ishaq says

    very well explained . Excellent stuff !!

    • Dheeraj Vaidya says

      Thanks for your kind words!

  3. Barry says

    very well spelled out thanks for the tutorial

    • Dheeraj Vaidya says

      thanks Barry!

  4. Manoj Jangid says

    It has been a great learning platform for me to know more about finance.

    Many thanks …!

    • Dheeraj Vaidya says

      thanks Manoj!