Please answer the questions on excel formula.

Clipboard II l-ont I: styles 5 A1 V? x V r A B C V D E F G H I J 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 $ 2.04 Dividend growth rate 4.5% Stock price $ 37.00 Complete the following analysis. Do not hard code values in your calculations. Dividend yield Capital gains yield E '3 ' C" 3' : Calculatingthe required retum-Exoel ? E HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In n & % .H. .. an ea Eill D EE _ - I E Paste v 3 1 u . iiiiiii . b. v A . Alignment Number Conditional Format as C9" Cells Editing v \\ v v Formatting ' Table ' Styles ' v v Clipboard G Font G Styles v ' a f; V B C D E F G H I J K Tell Me Why Co. is expected to maintain a constant 3.9 percent growth rate in its dividends indenitely. If the company has a dividend yield of 5.9 percent, what is the required return on the company's stock? Dividend growth rate Dividend yield Complete the following analysis. Do not hard code values in your calculations. Required return