For an answer to be graded as correct, you must use an Excel formula: Begin each formula with an $=$ sign. Reference cells, instead of entering values.Required:

Using the information in the tables above, please calculate the dividend yield, the capital gains yield, and the holding period return for each stock.

$($Use cells A$2$ to D$8$ from the given information to complete this question.$)$