Please answer the question using excel and show the formula

Please answer the question using excel and show the formula

Case 1 (20pts) LO-4: apply Calculation of Cost of Capital, Capital Budgeting Cash Flow a. The following capital structure data has prepared by PT. Samantha during a certain financial year. The number of Bonds Payable are 1.000 at a nominal price of US$ 100 per-bond, coupon rate of 10%, maturity date 20 years, and sales price of $ 90 per-bond b. Ordinary Share - Capital has price at US$ 50 per-share, totaling 6,000 shares, with a final dividend payout of $4 per share at 4% annual growth. And a flotation cost of $5 per-share C. Preferred Share - Capital with a price of US$ 60 per-share, totaling 10,000 shares, dividend paid at 10%, and the cost of issued at $6 per-share. Based on the above information, if it assumed that the corporate tax rate is 20%, calculate Cost of Capital for each component of capital structure and the Weighted Average Cost of Capital (WACC)