Question

In: Finance

CALCULATE THE COST OF DEBT; Walmart has at least 50 long-term bonds, the weighted average yield...

CALCULATE THE COST OF DEBT;

Walmart has at least 50 long-term bonds, the weighted average yield on these bonds is 3.2%. On the other hand, a simplified cost of debt can be calculated as the interest expenses divided by two year average of book value of debt. For Walmart, the book and market value of debt is nearly identical. This estimated cost of debt is 4.49%.

For our purposes, we will take the average, and use 3.85% as the pre-tax cost of debt (preliminary).

Now that we have the average pre-tax cost of debt, we need to account for the underwriter spread. We are simplifying from flotation costs calculated for equity. The adjusted pre-tax cost of debt should be estimated rate (from above)/(1-UW spread). Estimated pre-tax cost after accounting for underwriter spread and other flotation costs (the total of 1.5%). We calculate this adjusted pre-tax cost of debt as: original pre-tax estimate/(1-flotation cost %)

1) What is the adjusted pre-tax cost of debt (rd)? [show your work below]

WEIGHTED AVERAGE COST OF CAPITAL

1) What is the Weighted average cost of capital? Be sure to show your inputs in your WACC above and be sure to adjust for taxes as appropriate.

2) Discuss: Is this weighted average cost of capital a “good” hurdle rate to use for all new Walmart projects?

Solutions

Expert Solution

1) Pre tax cost of debt = Original pre tax estimate /(1-flotation cost)

Pre tax cost of debt 3.85%/(1-1.5%)
Pre tax cost of debt 3.91%
Beta 0.62
Rf 2% Income Before Tax
Rm-Rf 5.50% Income Tax Expense
So cost of equity Rf + beta*(Rm-Rf)
Cost of equity 5.41%
Walmart
2019 2018 Average
Long Term Debt 43,948,000 30,231,000 37,089,500 33%
Equity 72,496,000 77,869,000 75,182,500 67%
Total 116,444,000 108,100,000 112,272,000
Tax rate 34%
WACC Cost Post tax cost %
Debt 3.91% 2.58% 33%
Equity 5.41% 5.41% 67%
WACC 4.47%
WACC is the ideal rate to consider for Walmart as any project with returns above WACC adds to firm value and projects with returns below WACC
erodes firm value

Related Solutions

compare average yield .85 of CVS long-term debt with the cost of equity7.6 and comment on...
compare average yield .85 of CVS long-term debt with the cost of equity7.6 and comment on the difference. IN general you should ovserce that expected return of debt is lower than expected return of equity, in another word, cost of devt is cheaper than cost of equity.
Calculate the weighted average cost of capital for the following firm: it has $600000 in debt,...
Calculate the weighted average cost of capital for the following firm: it has $600000 in debt, $400000 in common stock and $200000 in preferred stock. It has a 4% cost of debt, 14% cost of common stock, 12% cost of preferred stock and a 34% tax rate.
yield-to-maturity on long-term government bonds 3.4%. Yield-to maturity on TM Industry's long-term bonds 8.1%. Market risk...
yield-to-maturity on long-term government bonds 3.4%. Yield-to maturity on TM Industry's long-term bonds 8.1%. Market risk premium 6% estimated company equity beta 1.4 stock prince per share $30.00 number of share outstanding 60 million TM industries debt value $1.2 million tax rate 25% 1. It's WACC is: a. 6.46% b. 9.51% c. 8.35% d. 10.16%
The firm's weighted average cost of capital is 13% and it has $2550000 of debt at...
The firm's weighted average cost of capital is 13% and it has $2550000 of debt at market value and $510000 of preferred stock in terms of market value. The estimated free cash flow over next 5 years are in the table. Beyond 2024 to infinity, the firm expects its free cash flow to grow by 6% annually. 2020 - $250000, 2021 - $310000, 2022 - $380000, 2023 - $430000, 2024 - $470000 a. Estimate the value of the entire company...
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term...
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term debt plus equity) of .43 and a current ratio of 1.27. Current liabilities are $2,395, sales are $10,465, profit margin is 11 percent, and ROE is 16 percent. What is the amount of the firm’s long-term debt? (Do not round intermediate calculations and your answer to 2 decimal places, e.g., 32.16.) What is the amount of the firm’s total debt? (Do not round intermediate...
What is the term used to refer to the yield on a long-term (20-year) debt obligation...
What is the term used to refer to the yield on a long-term (20-year) debt obligation issued by the U.S. government?
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
The Arkham Company has a ratio of long-term debt to long-term debt plus equity of .43...
The Arkham Company has a ratio of long-term debt to long-term debt plus equity of .43 and a current ratio of 1.5. Current liabilities are $990, sales are $6,410, profit margin is 9.3 percent, and ROE is 20.4 percent. What is the amount of the firm’s net fixed assets? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)    Net fixed assets = neither of these are the answer  5362.74, 3,683.75, 5378.53
The Arkham Company has a ratio of long-term debt to long-term debt plus equity of .39...
The Arkham Company has a ratio of long-term debt to long-term debt plus equity of .39 and a current ratio of 1.7. Current liabilities are $950, sales are $6,370, profit margin is 9.8 percent, and ROE is 20 percent. What is the amount of the firm’s net fixed assets? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
Last year KRJ Enterprises reported average short-term debt of $228, average current portion of long-term debt...
Last year KRJ Enterprises reported average short-term debt of $228, average current portion of long-term debt of $126, average long-term debt of $567, and average total stockholders’ equity of $1,809. It also reported operating earnings (EBIT) of $1,159 and an effective tax rate of 22%. What was the company’s return on invested capital for the year? Present your answer in percentage terms, rounded to two decimal places, e.g., 20.00%.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT