Excel $,$ help please

Step $1$: Create a formula for Cell A$5$ that forecasts the Market$$s

rate of return for the month selected in Cell C$2$ based on the five

years immediately preceding it$.$

Step $2$: Create a formula for Cell A$6$ that shows the Market$$s rate

of return for the month selected in Cell C$2.$

Step $3$: Create a formula for Cell B$5$ that forecasts the Treasury$$s

rate of return for the month selected in Cell C$2.$

Step $4$: Create a formula for Cell B$6$ that shows the Treasury$$s rate

of return for the month selected in Cell C$2.$

Step $5$: To receive full credit, these formulas must adjust

automatically for any of the twelve possible months in Cell C$2.$

Step $6$: Make the formatting display for the returns $0\mathrm{.}0\%.$

$2$: Abnormal Returns

Step $1$: Create a formula for Cell D$5$ that uses the beta, Cell D$2,$

and the forecasted rates of return for the market and treasury, Cells

A$5$:B$5,$ to forecast the return for the industry in Cell D$10.$

Step $2$: Create a formula for Cell D$6$ that uses the beta, Cell D$2,$

and the forecasted rates of return for the market and treasury, Cells

A$6$:B$6,$ to forecast the return for the industry in Cell D$10.$

Step $3$: Create a formula for Cell D$6$ that computes the abnormal

return for the industry in Cell D$10$ in the month selected in Cell C$2.$

Step $4$: To receive full credit, these formulas must adjust

automatically for any of the twelve possible months in Cell C$2.$

Step $5$: Make the formatting display for the returns $0\mathrm{.}0\%.$