please use excel and show the full formula use to get the answer.

K The next dividend payment by Halestorm, Inc., will be $2.04 per share. The dividends are anticipated to maintain a growth rate of 4.5 percent forever. The stock currently sells for $37 per share. What is the dividend yield? What is the expected capital gains yield? Next year's dividend Dividend growth rate Stock price 2.04 4.5% 37.00 8. 10 Complete the following analysis. Do not hard code values in your calculations. 11 12 Dividend yield 13 14 Capital gains yield 15 16 17 18 19 B. 3