Within an EXCEL spread sheet answer the following questions.

1) What stock did you choose? Procter and Gamble

2) Record the current stock price and the date. $139.61, October 4th, 2020

3) What is the last dividend that was paid? (The answer could be that the firm does not pay dividends)$2.95,

4) What is the current dividend yield (calculate by dividing the current annual dividend by the stock price)? 2.14%

5) What is the firms current earnings per share (EPS)? $5.12

Need Help with the last 3 on Excel

6) Estimate the intrinsic value of your firm by assuming that as the owner you will receive an amount equal to the EPS every year forever (you will use the perpetuity formula). Assume a required rate of return of 0.108 (this is a decimal - not a percentage).

7) Suppose you think the firms EPS will grow at the rate of 0.03 forever. Compute the current value of the stock by using the constant growth formula. (assume the required return of 0.108 and that next year you will receive EPS that grew at the 0.03 rate.

8) Graph the value of the stock assuming different growth rates that vary from 0 to 0.108. Use the EPS as an estimate of the current dividend (CF). Assume a required rate of return of 0.108.

RECORD THE REQUIRED RATE OF RETURN AS A DECIMAL IN THE BOX BELOW.