Valuation using discounted cash flows

From Wikipedia, the free encyclopedia

A method for determining the current value of a company using future cash flows adjusted for time value. The future cash flow set is made up of the cash flows within the determined forecast period and a continuing value that represents the cash flow stream after the forecast period.

Contents

[edit] Basic formula for firm valuation using DCF model

value of firm = 
\sum_{t=1}^n \frac{FCFF_t}{(1+WACC_{hg})^t} +
 \frac{\left[\frac{FCFF_{n+1}}{(WACC_{st}-g_n)}\right]}{(1+WACC_{hg})^n}

where

[edit] Process Data Diagram

The following diagram shows an overview of the process of company valuation. All activities in this model are explained in more detail in section 3: Using the DCF method.

Image:DCFMDPD.gif

[edit] Using the DCF Method

[edit] Determine Forecast Period

The forecast period is the time period for which the individual yearly cash flows are input to the DCF formula. Cash flows after the forecast period can only be represented by a fixed number such as annual growth rates. There are no fixed rules for determining the duration of the forecast period.

Example:

‘MedICT’ is a medical ICT startup that has just finished their business plan. Their goal is to provide medical professionals with software solutions for doing their own bookkeeping. Their only investor is required to wait for 5 years before making an exit. Therefore MedICT is using a forecast period of 5 years.

[edit] Determine the yearly Cash Flow

Cash flow is the difference between the amount of cash flowing in and out a company. Make sure to consistently include the different types of cash flows.

Example: MedICT has chosen to use only operational cash flows in determining their estimated yearly cash flow:

In thousand €

 

 

Year 1

Year 2

Year 3

Year 4

Year 5

Revenues

 

+30

+100

+160

+330

+460

Personnel

 

-30

-80

-110

-160

-200

Car Lease

 

-6

-12

-12

-18

-18

Marketing

 

-10

-10

-10

-25

-30

IT

 

-20

-20

-20

-25

-30

Cash Flow

 

-36

-22

+8

+102

+182

[edit] Determine Discount Factor / Rate

Determine the appropriate discount rate and discount factor for each year of the forecast period based on the risk level associated with the company and its market.

Example:

MedICT has chosen their discount rates based upon their company maturity.

 

 

 

Year 1

Year 2

Year 3

Year 4

Year 5

Risk Group

 

Seeking Money

Early Startup

Late Start Up

Mature

Risk Rate

 

50 - 100

40 – 60

30 – 50%

10- 25%

Discount Rate

 

65%

55%

45%

35%

25%

Discount Factor

 

0.61

0.42

0.33

0.30

0.33

[edit] Determine Current Value

Calculate the current value of the future cash flows by multiplying each yearly cash flow by the discount factor for the year in question. This is known as the time value of money.

Example:

 

 

 

Year 1

Year 2

Year 3

Year 4

Year 5

Cash Flow

 

-36

-22

+8

+102

+182

Discount Factor

 

0.61

0.42

0.33

0.30

0.33

Current Value

 

€ -21.96

€ -9.24

€ 2.64

€30.6

€60.1

Total current value = 62.14

[edit] Determine the Continuing Value

Calculating cash flows after the forecast period is much more difficult as uncertainty, and therefore the risk factor, rises with each additional year into the future. The continuing value, or terminal value, is a solution that represents the cash flows after the forecast period.

Example:

MedICT has chosen the perpetuity growth model to calculate the value of cash flows after the forecast period. They estimate that they will grow at about 6% for the rest of these years.

(182*1.06 / (0.25-0.06)) = 1015.34 This value however is a future value that still needs to be discounted to a current value: 1015.34 * 1/(1.25)^5 = 332.72

[edit] Determining Equity Value

The value of the equity can be calculated by subtracting any outstanding debts from the total of all discounted cash flows.

Example:

MedICT doesn’t have any debt so it only needs to add up the current value of the continuing value and the current value of all cash flows during the forecast period:

62.14 + 332.72= 394.86 The equity value of MedICT : € 394.86

[edit] See also

[edit] Literature

  • Kubr, Marchesi, Ilar, Kienhuis. 1998. Starting Up. Mckinsey & Company
  • Pablo Fernandez. 2004. Equivalence of ten different discounted cash flow valuation methods. IESE Research Papers. D549
  • Ruback, R. S., 1995, An Introduction to Cash Flow Valuation Methods, Harvard Business School Case # 295-155.
  • Keck, T., E. Levengood, and A. Longfield, 1998, Using Discounted Cash Flow Analysis in an International Setting: A Survey of Issues in Modeling the Cost of Capital, Journal of Applied Corporate Finance, Fall, pp. 82-99.
  • Aswath Damodaran 2001 Investment Valuation: Tools and Techniques for Determining Value. Wiley
  • McKinsey & Co., Tim Koller, Marc Goedhart, David Wessels. 2005. Valuation: Measuring and Managing the Value of Companies. John Wiley & Sons.

[edit] External links