Royal Dutch Shell (RDSA.AS) is a petroleum and petrochemicals company. It engages primarily in the exploration, production, and sale of crude oil and natural gas and the manufacture, transportation, and sale of petroleum and petrochemical products. The company operates in approximately 200 countries in North America, Europe, Asia-Paci?c, Africa, South America, and the Middle East. Analysts project 5% growth in earnings over the next ?ve years.

Assuming concurrent 5% growth in dividends, the following table provides the amounts that analysts project for Royal Dutch Shells total dividends for each of the next ?ve years. In Year +6, total dividends are projected for Royal Dutch Shell assuming that its income statement and balance sheet will grow at

a long-term growth rate of 3%. At the end of Year 0, Royal Dutch Shell had a market beta of 0.71. At that time, yield onU.S. Treasury securities was 3.5%. Assume that the market required a 5.0% risk premium (i.e., market risk premium, MRP). Suppose Royal Dutch Shell had 6,241 million shares outstanding at the beginning of Year +1 that traded at a share price of $24.87.

Answer the following questions.

1) Calculate the required rate of return on equity for Royal Dutch Shell (use CAPM).

2) Calculate the sum of the present value of total dividends for Years +1 through +5.

3) Calculate the continuing value of Royal Dutch Shell at the start of Year +6 (i.e., as of the end of Year+5) using the perpetuity-with-growth model with Year +6 total dividends. Also compute the present

value of continuing value as of the beginning of Year +1.

4) Compute the total present value of dividends for Royal Dutch Shell as of the beginning of Year +1. Remember to adjust the present value for midyear discounting.

5) Compute the value per share of Royal Dutch Shell as of the beginning of Year +1 (i.e., as of the end of Year 0).

6) Given the share price at the start of Year +1, do Royal Dutch Shell shares appear underpriced, overpriced, or correctly priced?

MFor you convenience, I provide a spread sheet template for your workout below. You can answer all of the six questions by completing all highlighted cells. Rememberyou should do all of your necessary calculations on the template so I can figure out how all of the numbers are computed. Just giving numbers in the cells won't work.