show the excel formulas that should be input in the blue sections.

Complete the steps below aving cell references to given data or previous calculations. In some cases, a timple cell reference is all you need. To copyipaste a formals across = rew or down = celumn, an absalute cell referrnce or a mixed cell reference may be preferred. If a specifie Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data inte a cell or function. Instead, make a reference to the cell in which the data is foend. Male your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, ase the earliest appearanee of the data in your formulas, uvally the Given Data section. Procter ind Gimble (PG) peid ten tanent 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 thereafler by 3% per year, If the appropriate equify 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