1. UnitedHealth Group Incorporated has 25,000 shares of common stock outstanding at a market price of $48 a share. The common stock just paid a $2.20 annual dividend and has a growth rate of 2.5 percent. There are 12,000 shares of 6 percent preferred stock outstanding at a market price of $62 a share. The outstanding bonds mature in 13 years, have a total face value of $750,000, a face value per bond of $1,000, and a market price of $1,011.92 each. The bonds pay 7 percent coupon, semiannually. The tax rate is 34 percent. What is the firms weighted average cost of capital? Show all your work using Excel.