Stock Returns $-$ Microsoft.

$26.$ In the next two problems, you'll use the information below to calculate Microsoft's dividend yield, capital gains yield, total return, average return and coefficient of variation.

$\backslash$table$[[\backslash$table$[[$Company$/],[$Stock Symbol$]],$Date,$\backslash$table$[[$Dividend$],[$per Share$]],\backslash$table$[[$Price Per$],[$Share$]]],[$Microsoft$/$ MSFT$,$Apr. $2024,2\mathrm{.}860,427\mathrm{.}93],[,$Apr. $2023,2\mathrm{.}600,304\mathrm{.}74],[,$Apr. $2022,2\mathrm{.}360,272\mathrm{.}59],[,$Apr. $2021,2\mathrm{.}140,245\mathrm{.}70]]$

Using the data above, calculate the missing information. Then answer the questions that follow.

$\backslash$table$[[\backslash$table$[[12$ Months$],[$Ending

Apr.$]],\backslash$table$[[$Dividend Yield,$],[$DY$]],\backslash$table$[[$Capital Gains Yield,$],[$CGY$]],\backslash$table$[[$Total Annual$],[$Return$,r$ whats the average rate or return and coefficient of variation? microsoft stock has a beta of $0\mathrm{.}88.$ what is its required rate of return if t bills return $5\mathrm{.}06\%$ and the return total market index fund is $10\mathrm{.}68\%$