Question

Can someone please show me the steps on how to get these answers that are highlighted in yellow using excel !

Rework Problem, 5-19. Conroy Consulting Corporation (CCC) has been growing at a rate of 30% per year in recent years. This sama growth rate iS @xpected to last for another 2 years (g1-g2+ 20%). 7%, what is CCC's stock worth today? What are its expected dividend yield and lf D0 82.50, rs 1296, and gn capital gains yield at this time? 1 Find the price today 2.50 12.0% 30% 30% DO rS Short-un g: for Yoar 1 anly Short-run g:for Yaar 2 only Long-run g: far Year 3 and all fallowing years g1,2 30% 796 Year Dividend 82.50 3.25 4.225 4.52075 PV of dividends $2.901 4.52075 D20(1+g) # D3 $3.3 $72.07 90.4150Horizon value P2 570.3402PO 2. Find the oxpocted dividend yield Recall that the expected dividend yield is equsl to the next expected annual dividend divided by the price at the beginning of the period Dividend yield Dividend yield- Dividend yield- D1 83.250 4.15% PO 878.348 3. Find the expected capital gains yield. The capital gains yield can be calculated by simply subtracting the dividend yield from the total expected retum Cap. Gain yield Cap. Gain yield- Cap. Gain yield- Dividend yield Expected return 12.0% 7.85% 4.15% Alternatively, we can recognize that the capital gains yield measures capitel sppreciation, hence solve for the price in one year then divide the change in price trom todsy to one year trom now by the cument price. To tind the price one year from now, we will have to find the present values of the tenminal value and second year dividend to time periad ona P2 D2 P1 (1 rs) 90.415 54.225 P1 P1 884.50 Cap. Gain yield- Cap. Gain yield- Cap. Gain yield (P1 PO) 56.15 7.85% PO $78.3482