1) What is the yield to maturity of the following bond?

Coupon 9%

Maturity date 2027

Interest paid semiannually

Par Value $1000

Market price $955.00

What is the excel formula to solve this?

Also, What is the current yield of bond?

2. The risk free rate is 7%, the return in the market is 10%, and the beta is 1.30. What return must you receive to be satisfied that you are being fairly compensated for the risk of the firm? What is the excel formula to solve this?

3. What should a zero coupon bond maturing for $1000 in 9 years with a 7% market rate sell for? Please solve in excel formula

4. Preferred stock has a dividend of $12 per year. The required return is 6%. What should the price per share be? Please solve in excel.

Thank You!