Are you able to help please with what functions I need to use to fill in this spreadsheet?

Additional Bond data Tax rate coupon rate face value Maturity Flotation co st D ebt Prefee d Co mmon Totals Additional Preferred Data Dividend Flotation co st Additional Common Data Dividend O Gro wth rate Flotation co st Units Questions Total Market Value % of Total After-tax Cost After-tax Cost(flotaton) Answ ers: I. is the after-tax WACC of the corporation? 2. is the after-tax WACC after consider flotaiton costs? The existing capital structure of ABC Ltd is as follows: 60,000 ordinary shares 20,000 Sl 00 nominal value 8% preferred shared, and 40,000 S 1000 nominal value 6% debentures (bond) The ordinary shares of the firm currently pay a dividend of S4.50 per share, and the dividend growth rate as measured by the past dividend payments is The current value of the ABC stock is S60. The current value of the debentures is SS 10 with a maturity of 7 years. The corporate tax rate is 35%.