G H J Procter and Gamble (PG) paid an annual dividend of $2.87 in 2018. You expect PG to increase its dividends by 8% per year for the next five years (through 2023), and thereafter by 3% per year. If the appropriate equity cost of capital for Procter and Gamble is 8% per year, use the dividend- discount model to estimate its value per share at the end of 2018. 1 2 3 $2.87 5 4. Annual dividend Number of periods (years) Expected growth rate through 2023 (equal to Cost of capital) Expected growth rate thereafter 2023 5 8% 3% 6 7 8 9 PV of dividends through 2023 PV of the rest of the dividends in 2023 PV of the rest of the dividends in 2018 Value per share of P&G 10 11 12 13 14 Requirements 15 1. Start Excel - completed. 16 2. In cell E11, by using cell references, calculate the present value of dividends through 2023 (1 pt.). 3. In cell E12, by using cell references, calculate the present value of the rest of the dividends in 2023 (1 pt.). 4. In cell E13, by using cell references and the function PV, calculate the present value of the rest of the dividends in 2018 (1 pt.). 5. In cell E14, by using cell references, calculate the value per share of Procter and Gamble at the end of 2018 (1 pt.). 6. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 17 18 19 20