Please answer in excel formula.

XD Calculating dividend yield and capital gains yield - Excel ? x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 Paste BIU- A % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 A B D E F G H J K 1 2 3 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? 4 5 6 $ 7 Next year's dividend Dividend growth rate Stock price 2.04 4.5% 37.00 8 $ 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 Dividend yield 13 14 15 Capital gains yield 16 17