Answer the following questions(Finance)

profileelenaseo
question.xlsx

Questions

Suggested Questions
1. Valuation using the DDM
1.1. Financial analysts believe that Volkswagen will increase its dividends at an annual rate of 3%.
Use the Dividend Discount Model (DDM) to estimate the value of Volkswagen stock for different discount rates (e.g. covering a range from 5.50% to 10.00%: 5.50%, 5.75%, 6.00%, etc.).
How sensitive is the valuation to the discount rate?
1.2. At what annual rate would dividends have to grow in the long term to justify paying €250 per share for Volkswagen stock? (Note: Use a discount rate of r=7%).
Is this a sensible number? Why?
1.3. Assume that Volkswagen increases its dividends at the annual rate of g1=2% over the period 2009-2015 and at g2=5% a year on from then.
What would the value of Volkswagen stock be then?
1.4. Financial analysts expect Volkswagen to be trading at €70 per share by the end of 2013.
What would the value of Volkswagen stock be then if this forecast is correct?
How sensitive is your result to the dividend growth rate that you use? Compare your results to the long-run stock price performance (Exhibit 2 in the case).
2. Valuation using the multiple P/E ratio
2.1. Volkswagen's P/E multiple is 21, while the industry average is 7.58.
Klaus Farra is thinking about multiplying the industry P/E ratio by Volkswagen's EPS to find a fair valuation of Volkswagen's shares.
Is this the right way to proceed? Does this imply that Volkswagen is over-valued, under-valued or correctly priced in December 2008?
2.2. What should be the comparable firms' set for the P/E analysis? Think about the factors affecting your choice. [Solution by the case's authors: consider Toyota, Honda, Fiat, Renault and BMW)
2.3. What is the value of Volkswagen stock using P/E multiples valuation?
3. Valuation using the multiple EV/EBITDA ratio
3.1. What are the right companies for the comparable set in the EV/EBITDA ratio analysis?
What value do you obtain for the multiple? [Solution by the case's authors: consider Daimler, Peugeot and Renault]
3.2. What is the value of Volkswagen stock using EV/EBITDA multiples valuation?

Exhibit 5

Exhibit 5
Financial Data - December 2008
This table shows a list of financial variables of Volkswagen and its competitors in 2008 based on financial statements released by each company
Variable Volkswagen2 Toyota General Ford Daimler Honda Peugeot Fiat Renault BMW Porsche
Motors
Enterprise Value (€ billions) 133.76 151.84 24.60 86.28 73.96 54.00 26.01 22.42 30.24 63.12 17.56
BV(Debt) (€ billions) 69.38 96.90 33.48 111.28 58.64 34.88 27.93 21.38 29.14 59.53 18.17
BV(Equity) (€ billions) 35.01 94.19 -61.98 -12.45 31.22 36.06 13.14 10.35 18.96 20.27 15.07
MV(Equity) (€ billions) 77.62 73.24 1.33 3.74 25.28 27.47 2.77 5.69 4.76 14.35 9.76
Cash (€ billions) 9.47 12.92 10.11 15.86 6.91 8.34 2.10 3.46 2.05 7.45 6.99
Net Debt (€ billions) 56.14 78.60 23.27 82.54 48.68 26.54 23.25 16.73 25.48 48.77 7.79
Net Sales (€ billions) 113.81 208.63 107.17 105.23 95.87 95.25 54.36 59.38 37.79 53.20 7.47
EBITDA (€ billions) 15.71 31.54 -7.80 5.78 10.05 11.36 2.85 6.41 4.08 8.15 9.93
Net Income (€ billions) 4.75 13.63 -22.20 -10.56 1.64 4.76 -0.34 1.61 0.57 0.32 6.29
Share Price (€) 194.19 23.05 2.30 1.65 26.40 15.13 12.15 4.59 18.55 21.97 55.79
Earnings per share (EPS) (€) 11.94 4.29 -38.34 -4.65 1.71 2.62 -1.51 1.30 2.23 0.50 35.95
Dividends per share (€) 1.93 1.11 0.36 0.00 0.60 0.68 0.00 0.00 0.00 0.30 2.70
Price/Earnings 16.33x 5.37x -0.06x -0.35x 15.44x 5.77x -8.06x 3.53x 8.33x 44.30x 1.55x
Enterprise Value/EBITDA 8.52x.10 4.81x -3.15x 14.92x 7.36x 4.76x 9.13x 3.50x 7.42x 7.74x 1.77x
EBITDA/employees 43.97 99.77 -32.11 27.15 36.79 63.45 13.71 32.31 31.13 81.51 813.46
ROIC (%) 5.56% 7.08% N/A -5.33% 1.91% 6.91% -0.08% 8.23% 1.75% 0.65% 28.21%
Market Beta 0.65 0.87 0.82 0.99 1.59 NA 1.20 1.56 2.32 1.07 1.71
Number of Employees 357.207 316.121 243.000 213.000 273.216 178.960 207.800 198.348 130.985 100.041 12.202
Shares Outstanding (thousands) 398.091 3,177,445 579.000 2,272,000 957.700 1,815,356 227.614 1,239,880 256.552 653.291 175.000
2 Volkswagen share price represents the weighted average price of the ordinary share price (€250.00) and preference share price (€38.02).

Exhibit 5-Use the EV for May7th

Exhibit 5
Financial Data - December 2008
This table shows a list of financial variables of Volkswagen and its competitors in 2008 based on financial statements released by each company
Selected Financial Data for Volkswagen AG (Dec. 31, 2008):
Variable Volkswagen Toyota General Motors Ford Motor Daimler Honda Peugeot Fiat Renault BMW Porsche
Enterprise Value (€ billions) 158.59 153.13 25.26 87.37 74.67 58.62 26.14 23.15 31.06 63.14 24.72
BV(Debt) (€ billions) 69.38 96.90 33.48 111.28 58.64 34.88 27.93 21.38 29.14 59.53 18.17
BV(Equity) (€ billions) 35.01 94.19 -61.98 -12.45 31.22 36.06 13.14 10.35 18.96 20.27 15.07
MV(Equity) (€ billions) 99.56 73.24 1.33 3.74 25.28 27.47 2.77 5.69 4.76 14.35 9.76
Cash (€ billions) 9.47 12.92 10.11 15.86 6.91 8.34 2.10 3.46 2.05 7.45 6.99
Net Debt (€ billions) 56.14 78.60 23.27 82.54 48.68 26.54 23.25 16.73 25.48 48.77 7.79
Net Sales (€ billions) 113.81 208.63 107.17 105.23 95.87 95.25 54.36 59.38 37.79 53.20 7.47
EBITDA (€ billions) 15.71 31.54 -7.80 5.78 10.05 11.36 2.85 6.41 4.08 8.15 9.93
Net Income (€ billions) 4.75 13.63 -22.20 -10.56 1.64 4.76 -0.34 1.61 0.57 0.32 6.29
Share Price (€) 250.10 23.05 2.30 1.65 26.40 15.13 12.15 4.59 18.55 21.97 55.79
Earnings per share (EPS) (€) 11.94 4.29 -38.34 -4.65 1.71 2.62 -1.51 1.30 2.23 0.50 35.95
Dividends per share (€) 1.93 1.11 0.36 0.00 0.60 0.68 0.00 0.00 0.00 0.30 2.70
Price/Earnings 20.95 5.37 -0.06 -0.35 15.44 5.77 -8.06 3.53 8.33 44.30 1.55
Enterprise Value/EBITDA 10.10 4.86 -3.24 15.11 7.43 5.16 9.17 3.61 7.62 7.74 2.49
EBITDA/employees 43.97 99.77 -32.11 27.15 36.79 63.45 13.71 32.31 31.13 81.51 813.46
ROIC (%) 5.56% 7.08% N/A -5.33% 1.91% 6.91% -0.08% 8.23% 1.75% 0.65% 28.21%
Market Beta 0.65 0.87 0.82 0.99 1.59 NA 1.20 1.56 2.32 1.07 1.71
Number of Employees 357,207 316,121 243,000 213,000 273,216 178,960 207,800 198,348 130,985 100,041 12,202
Shares Outstanding (thousands) 398,091 3,177,445 579,000 2,272,000 957,700 1,815,356 227,614 1,239,880 256,552 653,291 175,000

Exhibit 6

Exhibit 6
Financial Snapshot – May 7, 2009
This table shows a list of financial variables of Volkswagen and its competitors on May 7, 2009 based on financial statements and financial analysts’ forecasts
Variable Volkswagen3 Toyota General Ford Motor Daimler Honda Peugeot Fiat Renault BMW Porsche
Motors
Share Price (€) 181.20 30.45 1.19 4.52 27.57 23.36 17.88 7.47 26.72 27.91 46.99
EPS - Actual - Dec 2008 11.94 4.29 -38.34 -4.65 1.71 2.62 -1.51 1.30 2.23 0.50 35.95
EPS - Analyst Forecast - Dec 2009 3.99 0.79 -19.99 -1.49 -1.34 0.87 -5.94 -0.31 -9.93 0.07 7.48
EPS - Analyst Forecast - Dec 2010 5.54 1.37 -6.15 -0.24 1.37 1.29 -1.54 0.28 -1.23 1.62 5.28
EPS - Analyst Forecast - Dec 2011 7.85 NA -1.19 0.40 2.67 NA 2.57 0.65 2.87 3.24 8.16
EBITDA - Actual - Dec 2008 15.71 31.54 -7.80 5.78 10.05 11.36 2.85 6.41 4.08 8.15 9.93
EBITDA - Analyst Forecast - Dec 2009 13.95 7.30 N/A 4.98 7.99 4.40 3.13 4.90 3.10 6.30 -0.24
EBITDA - Analyst Forecast - Dec 2010 10.33 10.15 N/A N/A 7.04 5.00 3.09 4.36 2.79 6.65 1.63
3 Volkswagen share price represents the weighted average price of the ordinary share price (€229.44) and preference share price (€46.22).