can someone help me solve this on excel please?

eBook Nonconstant Dividend Growth Valuation Conroy Consulting Corporation (CCC) has a current dividend of Do = $1.00. Shareholders require a 10% rate of return. Although the dividend has been growing at a rate of 26% per year in recent years, this growth rate is expected to last only for another 2 years (90,1 = 91,2 = 26%). After Year 2, the growth rate will stabilize at OL = 4%. a. What is CCC's stock worth today? Do not round intermediate calculations. Round your answer to the nearest cent. $ 2.5 b. What is the expected stock price at Year 1? Do not round intermediate calculations. Round your answer to the nearest cent. 12.1 c. What is the Year 1 expected (1) dividend yield, (2) capital gains yield, and (3) total return? Do not round intermediate calculations. Round your answers to two decimal places. 10.68 % Dividend yield: Capital gains yield: 0.68 % % Total return; 10.00 d. What is its expected dividend yield for the second year? The expected capital gains yield? The expected total return? Do not round intermediate calculations. Round your answers to two decimal places. % Dividend yield: 6.23 Capital gains yield: 17.36 Total return; 10.00 X X % %