I need the formulas in excel please!

$$Use the $"$Q$8-9"$ worksheet to answer Questions $8$ to $9.$

I dont have the values right now, but you can assume them $($ex$.$ assume beta$=$ cell A$45$ or something idk$)$

$8)$ In the Expected Return column, calculate the Expected Return for each

stock. $(5$ marks$)$

Expected Return $=[$beta $+($Market Return $+$ Yield Rate$)^2]/1($Interest Rate $+$ Dividend Yield$)^1\mathrm{.}5]$

$9)$ Use the Solver function to determine the Yield Rate's value when the

Median Expected Return equals $150\%.(2$ marks$)$