Apply the residual income valuation (RIV) model to

Apply the residual income valuation (RIV) model to calculate the intrinsic price of Nike. The consolidated financial statements for 2014 and 2015 are provided. In addition, the following information and assumptions are provided:

• Nike’s cost of equity capital is 10%.

• As at May 31, 2015, Nike had 855,351,589 common shares outstanding.

• The share price Nike as at May 31, 2015 was $50.94.

• From 2016 to 2020, Nike’s earning per share is expected to grow at 6% on average per annum.

• The Net Dividend Payout ratio (i.e. net dividend paid to shareholders relative to income earned), is projected to be at 0.3 per annum on average from 2016 onwards.

• Assume 1% terminal growth in abnormal earnings.

Required:

You are required to develop an Excel spreadsheet to:

1) Calculate the intrinsic equity price of Nike as at year-end 2015 using the residual income valuation (RIV) model and the information provided above.

2) Calculate by hand the implied growth of abnormal earnings for Nike as at 2010, assuming that all other assumptions are correct. Note that this calculation must be done by hand and show the manual calculation steps in the Word. Then, explain how you can use this knowledge of the implied growth rate for investment decision-making.

3) Using the Goal Seek tool in Excel to calculate the implied expected rate of return, assuming that all other input including the 1% growth in abnormal earnings are correct. Report this calculation in the Word report. Then, explain how you can use this knowledge of the implied expected rate of return for investment decision-making.

4) Describe the appropriateness and the limitations of the RIV model and the assumptions employed in this valuation exercise, specifically within the context of Nike Ltd. Provide arguments that are specifically relevant to Nike Ltd.