PLEASE SHOW WORK WITH EXCEL

\begin{tabular}{|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F \\ \hline 3 & \multicolumn{2}{|c|}{ Spyder Company } & & & & \\ \hline 4 & Current Price & $25.00 & & & & \\ \hline 5 & Expected Price, One Year & $27.00 & & & & \\ \hline 6 & Expected Dividend & $2.00 & & & & \\ \hline 7 & Beta & 1.20 & & & & \\ \hline \multicolumn{7}{|l|}{8} \\ \hline 9 & \multicolumn{2}{|c|}{ Market Data } & & & & \\ \hline 10 & Market Return & 0.110 & & & & \\ \hline 11 & Risk-free Rate & 0.025 & & & & \\ \hline \multicolumn{7}{|l|}{12} \\ \hline 13 & \multicolumn{6}{|l|}{ Action Taken } \\ \hline 14 & Buy & & & & & \\ \hline 15 & Hold & & & & & \\ \hline 16 & Sell & & & & & \\ \hline \multicolumn{7}{|l|}{17} \\ \hline 18 & Required: & & & & & \\ \hline 19 & \multicolumn{5}{|c|}{Usingtheinformationinthetablesabove,pleasecalculatetheholdingperiodreturn,capitalizationrate(usingtheCAPM),andtheintrinsicvalueofthisstock.Thenusethatinformationtodetermineifthisisabuy,hold,orsellopportunity.} & \\ \hline \multicolumn{7}{|l|}{20} \\ \hline 21 & \multicolumn{2}{|c|}{ (Use cells A4 to B16 from the given information to complete this question.) } & & & & \\ \hline 22 & & & & & & \\ \hline 23 & \multicolumn{2}{|c|}{ Spyder Company } & & & & \\ \hline 24 & Expected Holding Period Return & 16.00% & & & & \\ \hline 25 & Capitalization Rate & 12.70% & & & & \\ \hline 26 & Instrinsic Value & r & & & & \\ \hline \multicolumn{7}{|l|}{27} \\ \hline 28 & \multicolumn{6}{|c|}{ The investor believes the Intrinsic Value reflects reality; test if this is a buy, hold, or sell opportunity. (Hint: Use IF function.) } \\ \hline \multicolumn{7}{|l|}{29} \\ \hline 30 & Action Taken & & & & & \\ \hline \multicolumn{7}{|l|}{31} \\ \hline 32 & & & & & & \\ \hline \end{tabular}