I need help please …
If you like, you can use the YTM on a bond issue that is not callable as the pre-tax cost of debt for the company.
As you recall, the formula for WACC is:
rWACC = (E/E+D) rE + D/(E+D) rD (1-TC)
The formula for the required return on a given equity investment is:
ri= rf + βi * (RMkt-rf)
RMkt-rf is the Market Risk Premium. For this project, you may assume the Market Risk Premium is 5% unless you can develop a better number.
rf is the risk free rate. The risk free rate is normally the yield on US Treasury securities such as a 10-year treasury. For this assignment, please use 3.5%.
You may assume a corporate tax rate of 40%.
Conplete areport that contains the following elements:
· Your calculated WACC.
· How data was used to calculate WACC. This would be the formula and the formula with your values substituted.
· Sources for your data.
· A discussion of how much confidence you have in your answer. What were the limiting assumptions that you made, if any?
Include a Microsoft® Excel® file showing your WACC calculations discussed above.