Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Enter the date of your calculation Cost of Capital Enter inputs in yellow cells. Key Output of Valuation: 5. Calculate the WACC for Steel Dynamics
Enter the date of your calculation Cost of Capital Enter inputs in yellow cells. Key Output of Valuation: 5. Calculate the WACC for Steel Dynamics Inc. using the same methodology we covered in class with data from Thomson Reuter's Elkon. On the column Cunder Suggested Sources in orange cells enter the detailed source as illustrated for cell C10. Estimated WACC #DIV/01 What Is Steel Dynamics' WACC in Thomson Reuters? Inputs to Estimate WACC Inputs Suggested Sources What is Steel Dynamics' WACC in Bloomberg? Thomson Reuters/Overview/ What is your WACC? Enter Current Market value for Equity Current stock price Number of shares common stock outstanding Market value of common stock Show the formulas in the orange section referencing the cells in green. Make the calculations in the turquoise cells. (4 points) Enter Current Market Value for Long-Term Debt Estimated value of long-term debt Enter Current Market value for Short-Term Debt Estimated value of short-term debt Enter Current Market value for Preferred Stock Estimated value of preferred stock SO Estimate Percent of Firm that will be Financed by Long-term Debt Current percent of firm financed with long-term debt #DIV/0! Target percent financed with long-term debt= DIV/0! Estimate Percent of Firm that will be Financed by Preferred Stock Current percent of firm financed with preferred stock d with preferred stock Target percent financed with preferred stock = #DIV/01 #DIV/0! Estimate Percent of Firm that will be Financed by Short- term Debt Current percent of firm financed with short-term debt #DIV/0! #DIV/0! Target percent financed with short-term debt = Estimate Cost of Equity Beta Risk-free rate= Market risk premium = Cost of equity= Estimate Cost of long-term Debt Bond rating for company's debt Spread for bond rating Tax rate= Enter the date of your calculation Cost of Capital Enter inputs in yellow cells. Key Output of Valuation: 5. Calculate the WACC for Steel Dynamics Inc. using the same methodology we covered in class with data from Thomson Reuter's Elkon. On the column Cunder Suggested Sources in orange cells enter the detailed source as illustrated for cell C10. Estimated WACC #DIV/01 What Is Steel Dynamics' WACC in Thomson Reuters? Inputs to Estimate WACC Inputs Suggested Sources What is Steel Dynamics' WACC in Bloomberg? Thomson Reuters/Overview/ What is your WACC? Enter Current Market value for Equity Current stock price Number of shares common stock outstanding Market value of common stock Show the formulas in the orange section referencing the cells in green. Make the calculations in the turquoise cells. (4 points) Enter Current Market Value for Long-Term Debt Estimated value of long-term debt Enter Current Market value for Short-Term Debt Estimated value of short-term debt Enter Current Market value for Preferred Stock Estimated value of preferred stock SO Estimate Percent of Firm that will be Financed by Long-term Debt Current percent of firm financed with long-term debt #DIV/0! Target percent financed with long-term debt= DIV/0! Estimate Percent of Firm that will be Financed by Preferred Stock Current percent of firm financed with preferred stock d with preferred stock Target percent financed with preferred stock = #DIV/01 #DIV/0! Estimate Percent of Firm that will be Financed by Short- term Debt Current percent of firm financed with short-term debt #DIV/0! #DIV/0! Target percent financed with short-term debt = Estimate Cost of Equity Beta Risk-free rate= Market risk premium = Cost of equity= Estimate Cost of long-term Debt Bond rating for company's debt Spread for bond rating Tax rate=
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started