Please solve using an excel format and show me the formulas used to get the solution. Thank you

fx 4 A B D F G H 1 K L N 0 P Q R s T U 10-18 1 2 3 4 WACC AND OPTIMAL CAPITAL BUDGET Adamson Corporation is considering four average-risk projects with the following costs and rates of return; Project 5 6 Cost $2,000 1 3,000 2 3 Expected Rate of Return 16.00% 15.00 13.75 12.50 5,000 2,000 4 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 The company estimates that it can issue debt at a rate of r = 10%, and its tax rate is 30%. Il can issue preferred stock that pays a constant dividend of $5.00 per year at $50.00 per share. Also, its common stock currently sells for $38.00 per share; the next expected dividend, D, is $4.25, and the dividend is expected to grow at a constant rate of 5% per year. The target capital structure consists of 75% common stock, 15% debt, and 10% preferred stock. a. What is the cost of each of the capital components? b. What is Adamson's WACC? c. Only projects with expected returns that exceed WACC will be accepted. Which proiects should Adamson accept