Transcribed Image Text
*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITHANY RELEVANT FORMULAS, thank you!*You are an analyst in charge of valuing common stocks. You havebeen asked to value two stocks. The first stock AB Inc. just paid adividend of $4.50. The dividend is expected to increase by 60%,40%, 30% and 10% per year respectively in the next four years.Thereafter the dividend will increase by 4% per year inperpetuity.The second stock is CD Inc. CD will pay its first dividend of $8in 5 years. The dividend will increase by 40% per year for thefollowing 3 years after its first dividend payment. Thereafter thedividend will increase by 3% per year in perpetuity.Both stocks have a required rate of return of 25% per year forthe next 2 years, and thereafter the required rate of return willbe 10%.Calculate AB’s expected dividend for t = 1, 2, 3, 4, and5.What is the current price of AB?Calculate CD’s expected dividend for t = 1, 2, 3, 4, 5, 6, 7, 8and 9.What is the current price of CD?