please include excel instructions

A1 fx Question 3: 100 Points B D E F G H 4 5 1 Question B: 100 Points 2 3 West Inc. has hired you to calculate its WACC. In preparation for your calculations, you have dug up the following information: West Inc. has one issue of outstanding bonds. The bonds have a maturity of 8 years, with a coupon rate of 6% and pay coupons semi-annually. The par value of the bonds is $1,000 and today's market price of the bonds is $1,033.50. The company's common shares have a current market price of $27.45. The company just paid a dividend of $2.55 and expects dividends to grow at 4.5% for the foreseeable future. 10 The company's preferred shares have a market price of $36.50 and pay a dividend of $4.00. West Inc. has a corporate tax rate of 31.5% The target weight for financing West Inc. is 48% bonds, 8% preferred shares, and 44% common shares. What is the appropriate WACC for West Inc.? 6 7 8 9 11 12 13 I 15 16 17 18 19 20 21 22 23 24