a$.$ What is the value of a preferred stock where the dividend rate is $6\mathrm{.}0$ percent on a $$50$ par value, and the market's required yield on similar shares is $7\mathrm{.}0$ percent?

b$.$ Should you acquire the stock if the current market price is $$\frac{45\mathrm{.}00}{?}$ share?

c$.$ If you purchase the stock for the value $$\frac{45}{?}$ share what is your expected rate of return? $($Hint $-$ use the formula: Expected rate of return $=$ Dividend dollars on preferred stock$/$the price of a share of preferred stock$)$

Preferred Stock Valuation and Expected Rate of Return

$\backslash$table$[[$Par value,$],[$Current market price,$],[$Dividend rate,$],[$Dividend dollars,$],[$Required Rate of Return,$]]$

A$)$

Value

B$)$

C$)$

Expected rate of return

Please show how to solve step by step for Excel