Answered You can hire a professional tutor to get the answer.
Having trouble with the work below. I am using walmart and have the financials and some of the work done, but am getting hung up with things.
1. Calculate the Weighted Average Cost of Capital (WACC) for the company:
a. Cost of Debt
i. Determine the market value of the firm's debt issues. Be sure to review the firm's 10-K. Also, the website http://finra-markets.morningstar.com/BondCenter may be of assistance.
ii. You will need to calculate the firm's composite YTM on its bonds. This can be achieved by calculating a weighted-average YTM for its bond issues.
iii. After calculating the YTM for the bond issues, calculate the firm's after-tax cost of debt. If the firm's marginal tax rate cannot be identified in its 10-K, assume that the tax rate will be 35%.
b. Cost of Equity
i. Calculate the firm's cost of equity using the capital asset pricing model (CAPM). The formula for the CAPM is ri = rf + βi × (RMkt - rf).
ii. Assume the risk-free rate (rf) is the current rate of 10-year U.S. Treasury Bonds.
iii. Calculate the market rate (RMkt) by calculating the market return on the Standard & Poor's 500 for the past 2 calendar years.
iv. The beta for the firm can be obtained from Yahoo! Finance.
c. Calculate the WACC
i. Determine the market capitalization of the firm's common equity and preferred equity, if any.
ii. Determine the firm's capital structure based on the market value of the firm's equity and debt. The market value of the firm's debt can be obtained from the Morningstar website, listed in the Cost of Debt section above.
iii. Calculate the WACC. As you recall, the formula for WACC is rWACC = E ÷ (E + D) rE + D ÷ (E + D) rD (1 - TC).
