use excel

Question Completion Status: QUESTIONS 40 points Speedy Ltd has 80,000 bonds outstanding that are selling at par. Bonds with similar characteristics are yielding 6.75 per cent. The company also has 750,000 shares of 7 per cent preference shares and 2.5 million shares of ordinary equity outstanding. The preference shares sell for 53 a share. The ordinary equity has a beta of 1.34 and sells for 42 a share. The government Treasury bill is yielding 2.8 per cent and the return on the market is 11.2 per cent. The corporate tax rate is 38 per cent. 1. What are the weight of the ordinary equity and cost of egity? (10 pts] II. What are the weight of the bond and cost of debt? [10 pts) III. What are the weight of the preference share and cost of preference shares? [10 pts) iv. What is WACC? [10 pts) Show your steps. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial