using the material provided solve for Covariance (sample), Beta, and Cost of equity: E(Rt), % of Total MV, YTM (of last sale), "YTM based on BV", and "YTM based on MV" by using Excel

\begin{tabular}{|c|r|} \hline Date & Adj Close \\ \hline 20190901 & 2,976.74 \\ \hline 20191001 & 3,037.56 \\ \hline 20191101 & 3,140.98 \\ \hline 20191201 & 3,230.78 \\ \hline 20200101 & 3,225.52 \\ \hline 20200201 & 2,954.22 \\ \hline 20200301 & 2,584.59 \\ \hline 20200401 & 2,912.43 \\ \hline 20200501 & 3,044.31 \\ \hline 20200601 & 3,100.29 \\ \hline 20200701 & 3,271.12 \\ \hline 20200801 & 3,500.31 \\ \hline 20200901 & 3,363.00 \\ \hline 20201001 & 3,269.96 \\ \hline 20201101 & 3,621.63 \\ \hline 20201201 & 3,756.07 \\ \hline 20210101 & 3,714.24 \\ \hline 20210201 & 3,811.15 \\ \hline 20210301 & 3,972.89 \\ \hline 20210401 & 4,181.17 \\ \hline 20210501 & 4,204.11 \\ \hline 20210601 & 4,297.50 \\ \hline 20210701 & 4,395.26 \\ \hline 20210801 & 4,522.68 \\ \hline 20210901 & 4,307.54 \\ \hline 20211001 & 4,605.38 \\ \hline 20211101 & 4,567.00 \\ \hline 20211201 & 4,766.18 \\ \hline 20220101 & 4,515.55 \\ \hline 20220201 & 4,373.94 \\ \hline 20220301 & 4,530.41 \\ \hline 20220401 & 4,131.93 \\ \hline 20220501 & 4,132.15 \\ \hline 20220601 & 3,785.38 \\ \hline 20220701 & 4,130.29 \\ \hline 20220801 & 3,955.00 \\ \hline 20220901 & 3,585.62 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|} \hline Date & GS1M (in \%) \\ \hline 20190901 & 1.99 & 0.0199 & 0.00165833 \\ \hline 20191001 & 1.73 & 0.0173 & 0.00144167 \\ \hline 20191101 & 1.58 & 0.0158 & 0.00131667 \\ \hline 20191201 & 1.55 & 0.0155 & 0.00129167 \\ \hline 20200101 & 1.53 & 0.0153 & 0.001275 \\ \hline 20200201 & 1.58 & 0.0158 & 0.00131667 \\ \hline 20200301 & 0.37 & 0.0037 & 0.00030833 \\ \hline 20200401 & 0.11 & 0.0011 & 0.00009167 \\ \hline 20200501 & 0.10 & 0.001 & 0.00008333 \\ \hline 20200601 & 0.13 & 0.0013 & 0.00010833 \\ \hline 20200701 & 0.11 & 0.0011 & 0.00009167 \\ \hline 20200801 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20200901 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201001 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201101 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201201 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20210101 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20210201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20210301 & 0.02 & 0.0002 & 0.00001667 \\ \hline 20210401 & 0.02 & 0.0002 & 0.00001667 \\ \hline 20210501 & 0.01 & 0.0001 & 0.00000833 \\ \hline 20210601 & 0.03 & 0.0003 & 0.000025 \\ \hline 20210701 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20210801 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20210901 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20211001 & 0.06 & 0.0006 & 0.00005 \\ \hline 20211101 & 0.07 & 0.0007 & 0.00005833 \\ \hline 20211201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20220101 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20220201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20220301 & 0.18 & 0.0018 & 0.00015 \\ \hline 20220401 & 0.31 & 0.00310.00025833 \\ \hline 20220501 & 0.0058 & 0.00048333 \\ \hline 20220601 & 0.0261 & 0.002175 \\ \hline 20220701 & 0.00088333 \\ \hline 20220801 & 0.00154167 \\ \hline 20220901 & 0.0019 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline Date & \multicolumn{1}{|c|}{ Adj Close } \\ \hline 20190901 & 215.196106 \\ \hline 20191001 & 218.899109 \\ \hline 20191101 & 205.769638 \\ \hline 20191201 & 203.782028 \\ \hline 20200101 & 214.213669 \\ \hline 20200201 & 204.578262 \\ \hline 20200301 & 175.343414 \\ \hline 20200401 & 207.828339 \\ \hline 20200501 & 234.914169 \\ \hline 20200601 & 236.833344 \\ \hline 20200701 & 252.494232 \\ \hline 20200801 & 271.087311 \\ \hline 20200901 & 264.116028 \\ \hline 20201001 & 254.992157 \\ \hline 20201101 & 265.222076 \\ \hline 20201201 & 253.950027 \\ \hline 20210101 & 260.333405 \\ \hline 20210201 & 248.336624 \\ \hline 20210301 & 293.430176 \\ \hline 20210401 & 313.086639 \\ \hline 20210501 & 308.4823 \\ \hline 20210601 & 308.462982 \\ \hline 20210701 & 319.123535 \\ \hline 20210801 & 317.169067 \\ \hline 20210901 & 319.191589 \\ \hline 20211001 & 363.308258 \\ \hline 20211101 & 391.523407 \\ \hline 20211201 & 405.596832 \\ \hline 20220101 & 360.139526 \\ \hline 20220201 & 309.942963 \\ \hline 20220301 & 293.750519 \\ \hline 20220401 & 296.579651 \\ \hline 20220501 & 298.89978 \\ \hline 20220601 & 270.781921 \\ \hline 20220701 & 298.989197 \\ \hline 20220801 & 286.550354 \\ \hline 20220901 & 275.940002 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|} \hline Average & 0.000433 & 0.009902 & 0.006863 & 0.009469 & 0.006430 \\ \hline Variance (sample) & 0.000000403 & 0.006221913 & 0.003428186 & 0.006239356 & 0.003448347 \\ \hline Standard deviation (sample) & 0.000634696 & 0.0788791 & 0.058550709 & 0.078989591 & 0.058722623 \\ \hline Covariance (sample) & \multicolumn{3}{|c|}{} \\ \hline Beta & & & & \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline Date & Adj Close \\ \hline 20190901 & 2,976.74 \\ \hline 20191001 & 3,037.56 \\ \hline 20191101 & 3,140.98 \\ \hline 20191201 & 3,230.78 \\ \hline 20200101 & 3,225.52 \\ \hline 20200201 & 2,954.22 \\ \hline 20200301 & 2,584.59 \\ \hline 20200401 & 2,912.43 \\ \hline 20200501 & 3,044.31 \\ \hline 20200601 & 3,100.29 \\ \hline 20200701 & 3,271.12 \\ \hline 20200801 & 3,500.31 \\ \hline 20200901 & 3,363.00 \\ \hline 20201001 & 3,269.96 \\ \hline 20201101 & 3,621.63 \\ \hline 20201201 & 3,756.07 \\ \hline 20210101 & 3,714.24 \\ \hline 20210201 & 3,811.15 \\ \hline 20210301 & 3,972.89 \\ \hline 20210401 & 4,181.17 \\ \hline 20210501 & 4,204.11 \\ \hline 20210601 & 4,297.50 \\ \hline 20210701 & 4,395.26 \\ \hline 20210801 & 4,522.68 \\ \hline 20210901 & 4,307.54 \\ \hline 20211001 & 4,605.38 \\ \hline 20211101 & 4,567.00 \\ \hline 20211201 & 4,766.18 \\ \hline 20220101 & 4,515.55 \\ \hline 20220201 & 4,373.94 \\ \hline 20220301 & 4,530.41 \\ \hline 20220401 & 4,131.93 \\ \hline 20220501 & 4,132.15 \\ \hline 20220601 & 3,785.38 \\ \hline 20220701 & 4,130.29 \\ \hline 20220801 & 3,955.00 \\ \hline 20220901 & 3,585.62 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|} \hline Date & GS1M (in \%) \\ \hline 20190901 & 1.99 & 0.0199 & 0.00165833 \\ \hline 20191001 & 1.73 & 0.0173 & 0.00144167 \\ \hline 20191101 & 1.58 & 0.0158 & 0.00131667 \\ \hline 20191201 & 1.55 & 0.0155 & 0.00129167 \\ \hline 20200101 & 1.53 & 0.0153 & 0.001275 \\ \hline 20200201 & 1.58 & 0.0158 & 0.00131667 \\ \hline 20200301 & 0.37 & 0.0037 & 0.00030833 \\ \hline 20200401 & 0.11 & 0.0011 & 0.00009167 \\ \hline 20200501 & 0.10 & 0.001 & 0.00008333 \\ \hline 20200601 & 0.13 & 0.0013 & 0.00010833 \\ \hline 20200701 & 0.11 & 0.0011 & 0.00009167 \\ \hline 20200801 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20200901 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201001 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201101 & 0.09 & 0.0009 & 0.000075 \\ \hline 20201201 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20210101 & 0.08 & 0.0008 & 0.00006667 \\ \hline 20210201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20210301 & 0.02 & 0.0002 & 0.00001667 \\ \hline 20210401 & 0.02 & 0.0002 & 0.00001667 \\ \hline 20210501 & 0.01 & 0.0001 & 0.00000833 \\ \hline 20210601 & 0.03 & 0.0003 & 0.000025 \\ \hline 20210701 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20210801 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20210901 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20211001 & 0.06 & 0.0006 & 0.00005 \\ \hline 20211101 & 0.07 & 0.0007 & 0.00005833 \\ \hline 20211201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20220101 & 0.05 & 0.0005 & 0.00004167 \\ \hline 20220201 & 0.04 & 0.0004 & 0.00003333 \\ \hline 20220301 & 0.18 & 0.0018 & 0.00015 \\ \hline 20220401 & 0.31 & 0.00310.00025833 \\ \hline 20220501 & 0.0058 & 0.00048333 \\ \hline 20220601 & 0.0261 & 0.002175 \\ \hline 20220701 & 0.00088333 \\ \hline 20220801 & 0.00154167 \\ \hline 20220901 & 0.0019 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline Date & \multicolumn{1}{|c|}{ Adj Close } \\ \hline 20190901 & 215.196106 \\ \hline 20191001 & 218.899109 \\ \hline 20191101 & 205.769638 \\ \hline 20191201 & 203.782028 \\ \hline 20200101 & 214.213669 \\ \hline 20200201 & 204.578262 \\ \hline 20200301 & 175.343414 \\ \hline 20200401 & 207.828339 \\ \hline 20200501 & 234.914169 \\ \hline 20200601 & 236.833344 \\ \hline 20200701 & 252.494232 \\ \hline 20200801 & 271.087311 \\ \hline 20200901 & 264.116028 \\ \hline 20201001 & 254.992157 \\ \hline 20201101 & 265.222076 \\ \hline 20201201 & 253.950027 \\ \hline 20210101 & 260.333405 \\ \hline 20210201 & 248.336624 \\ \hline 20210301 & 293.430176 \\ \hline 20210401 & 313.086639 \\ \hline 20210501 & 308.4823 \\ \hline 20210601 & 308.462982 \\ \hline 20210701 & 319.123535 \\ \hline 20210801 & 317.169067 \\ \hline 20210901 & 319.191589 \\ \hline 20211001 & 363.308258 \\ \hline 20211101 & 391.523407 \\ \hline 20211201 & 405.596832 \\ \hline 20220101 & 360.139526 \\ \hline 20220201 & 309.942963 \\ \hline 20220301 & 293.750519 \\ \hline 20220401 & 296.579651 \\ \hline 20220501 & 298.89978 \\ \hline 20220601 & 270.781921 \\ \hline 20220701 & 298.989197 \\ \hline 20220801 & 286.550354 \\ \hline 20220901 & 275.940002 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|} \hline Average & 0.000433 & 0.009902 & 0.006863 & 0.009469 & 0.006430 \\ \hline Variance (sample) & 0.000000403 & 0.006221913 & 0.003428186 & 0.006239356 & 0.003448347 \\ \hline Standard deviation (sample) & 0.000634696 & 0.0788791 & 0.058550709 & 0.078989591 & 0.058722623 \\ \hline Covariance (sample) & \multicolumn{3}{|c|}{} \\ \hline Beta & & & & \\ \hline \end{tabular}