I need the formulas in excel please!

$1.$ In the Expected Return column, calculate the Expected Return foreach

stock.

Assume:

beta$=$column A

Market return $=$ column B

Yield rate$=$ column C

Interest rate$=$column D

Dividend yield$=$ column E

Expected Return $=\frac{\text{b}\text{e}\text{t}\text{a}+(\text{M}\text{a}\text{r}\text{k}\text{e}\text{t}\text{R}\text{e}\text{t}\text{u}\text{r}\text{n}+\text{Y}\text{i}\text{e}\text{l}\text{d}\text{R}\text{a}\text{t}\text{e}{)}^2}{1-(\text{I}\text{n}\text{t}\text{e}\text{r}\text{e}\text{s}\text{t}\text{R}\text{a}\text{t}\text{e}+\text{D}\text{i}\text{v}\text{i}\text{d}\text{e}\text{n}\text{d}\text{Y}\text{i}\text{e}\text{l}\text{d}{)}^{1\mathrm{.}5}}$

$2.$ Use the Solver function to determine the Yield Rate's value when the

Median Expected Return equals $150\%.$

Assume:

yield rate$=$ column C