TABLE 16-3 Wal-Mart Balance Sheet Amounts stated are in millions of dollars, and
ID: 1171197 • Letter: T
Question
TABLE 16-3 Wal-Mart Balance Sheet Amounts stated are in millions of dollars, and the date of the balance sheet is January 31, 1993 ASSETS Current assets $10,197 9,794 ty, plant, and equipment assets AL ASSETS $20,565 BUTIES AND EQUITIES Accounts payable Commercial paper $ 3,873 1,588 1,233 expenses and taxes m debt maturing within 1 year lease obligations due within 1 year 46 liabiliies Long-lerm debt Capitol lease obligations Deferred income toxes 3,073 1,772 207 equity: Common slock Capital in excess of par Rainvested earnings TAL LIABIUTIES AND STOCKHOLDERS EQUITY 230 527 $20,565 cost. Details of the long-term capitalized lease obligations and additional operating sumed to be 8 percent lease obligations are as follows: ket value of these lease obligations is as- There were no shares of preferred stock AGGREGATE MINIMUM LEASE PAYMENTS DUE N $ MILLIONSI outstanding. Wal-Mart had a 37 percent combined federal and state marginal tax rate in 1992. YEAR Case Questions 1993 1994 1995 1996 1997 Thereafter 486 476 470 475 464 5,316 1. Estimate the market value of each 2. Estimate the required return for each 3. Estimate the weighted average cost of 4. In which area of your analysis is there component of the capital structure compo capital for Wal-Mart. nent of the capital structure The "thereafter" amount is assumed to be due at $443 million per year for the next 12 years from 1998 to 2009. The market rate of interest to be used to find the mar- the greatest potential for error? Why? Is there anything that could be done to improve estimates in this area?Explanation / Answer
1. Since most of company's debt were not actively traded, their market value would be their book value given in the balance sheet. However one longterm debt with book value as 3.073 B dollars has a fair value( market value) = 3.357 B dollars. Also unlesss otherwise given, book value of equity would be its market value.
Therefore market value of : 1.) Total Debt = Total Assets - Equity -book value of long term debt + market values of long term debt = (20565 - (230+527+8003)-3073)+3357= 12089 M dollars
2.) Total Equity = 230+527+8003= 8760 M dollars
2. Cost of Long term debt = 6.87% (as given in the problem)
Cost of Commercial paper = 3.5% (as given in the problem)
Cost of Capital Lease Obligation = 8 % ( lower value is taken as given in the problem)
Cost of Equity = 9.49 % ( From Gordon Growth----> Stock Price = .12/(cost of equity - .0909) ----->(D1/(cost of equity - growth))
3. WACC = % debt * cost of debt *(1-T) + % equity * cost of equity
= (CP)-->.104*.035*(1-0.37) +(LTD)--->.2023*.0687*(1-0.37) +(Cap Lease)---> .119*.08*(1-0.37) + (equity)- 0.57*.0949
= 0.002293 + 0.008755 + 0.00599 + 0.054
= 0.0711=7.11%
Here CP = Commercial paper , LTD = Long Term Debt
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.