I need the manual solution Assap

The BEAR Company has 1800 bonds outstanding that have a market price of $1010 each and a face value of $1000. floatation cost is 0.023 the bond pays coupon of 0.03 quarterly for 20 years. The company also has 6,000 shares of preferred stock at a market price of $33 and dividends 1.3 each par value 20 dollars . The common stock is priced at $27 a share it is undervalued by $1.5 and there are 35000 shares outstanding, par value is 5 dollars the stock is pays $1.1 and will continue to grow at a rate of 0.05. TAXES ARE 0.35 what is the weight of the bond according to book value method what is the weight of the stock according to book value method what is the weight of preferred stock according to book value method what is the WACC? use the book value method