Excel Online Structured Activity: WACC and optimal capital budget Adamson Corporation is considering four average-risk p

[answerhappygod]

Excel Online Structured Activity Wacc And Optimal Capital Budget Adamson Corporation Is Considering Four Average Risk P 1 (51.26 KiB) Viewed 16 times

Excel Online Structured Activity: WACC and optimal capital budget Adamson Corporation is considering four average-risk projects with the following costs and rates of return: Project 1 2 3 4 Cost of debt Cost $2,000 3,000 5,000 2,000 Cost of preferred stock The company estimates that it can issue debt at a rate of rg 9%, and its tax rate is 40%. It can issue preferred stock that pays a constant dividend of $4 per year at $59 per share. Also, its common stock currently sells for $33 per share; the next expected dividend, D₁, is $3.75; 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. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Project 1 X Open spreadsheet a. What is the cost of each of the capital components? Round your answers to two decimal places. Do not round your intermediate calculations. Project 2 Project 3 Project 4 Expected Rate of Return 16.00% 15.00 % % 13.75 12.50 Cost of retained earnings b. What is Adamson's WACC? Round your answer to two decimal places. Do not round your intermediate calculations. % c. Only projects with expected returns that exceed WACC will be accepted. Which projects should Adamson accept? 1% C