In: Accounting
WACC Estimation
The following table gives the balance sheet for Travellers Inn Inc. (TII), a company that was formed by merging a number of regional motel chains.
Travellers Inn: (Millions of Dollars) | ||||||
Cash | $ 10 | Accounts payable | $ 10 | |||
Accounts receivable | 20 | Accruals | 15 | |||
Inventories | 20 | Short-term debt | 0 | |||
Current assets | $ 50 | Current liabilities | $ 25 | |||
Net fixed assets | 50 | Long-term debt | 30 | |||
Preferred stock (50,000 shares) | 5 | |||||
Common equity | ||||||
Common stock (3,800,000 shares) | $ 10 | |||||
Retained earnings | 30 | |||||
Total common equity | $ 40 | |||||
Total assets | $100 | Total liabilities and equity | $100 |
The following facts also apply to TII:
Assume that you were recently hired by TII as a financial analyst and that your boss, the treasurer, has asked you to estimate the company's WACC under the assumption that no new equity will be issued. Your cost of capital should be appropriate for use in evaluating projects that are in the same risk class as the assets TII now operates. Based on your analysis, answer the following questions. Do not round intermediate calculations. Round your answers to two decimal places.
Weight | |
Debt | % |
Preferred stock | % |
Common stock | % |
%
%
%
%
%
%
First Compute WACC | a) | b), c) & e) | g) | |
Market Value | Weights | Cost | WACC | |
Debt | $19,552,091.94 | 19.25% | 8.85% | 1.70% |
Common Stock | $76,000,000.00 | 74.84% | 5.10% | 3.82% |
Preferred Stock | $6,000,000.00 | 5.91% | 3.10% | 0.18% |
Total | $101,552,091.94 | 100.00% | 5.70% | |
WACC | 10.39% | |||
Debt | ||||
Face Value | $1,000.00 | |||
Coupon Payment = 1000 x 7.4%/2 | $37.00 | |||
Nper = 20 x 2 | 40 | |||
Semi Annual Cost of Debt = YTM = Rate = 11.8%/2 | 5.90% | |||
Present Value = $1000 x 94.5% | $664.77 | |||
Market Value = 29412 x 664.77 | $19,552,091.94 | |||
After tax of debt = 11.8% x (1-25%) | 8.85% | (b) | ||
Common Stock | ||||
Cost of Equity = Risk free rate + Beta x Market Risk Premium = 7% + 1.6 x 5% | 15.00% | (d) | ||
Market Value = 3,800,0000 shares x $20 | $76,000,000.00 | |||
Preferred Stock | ||||
Value of Preferred = Dividend /Yield = $3/(10% /4) | $ 120.00 | |||
Market Value = 50,000 shares x 120 | $6,000,000.00 | |||
Cost of preferred =$3/$100 x (1 - 3.25%) = | 3.10% | ( c) | ||
e) | ||||
Growth rate = 10% x $1/$5 | 2.00% | |||
Required Return = ($1 x (1+2%))/$20 | 5.10% | |||
f) | ||||
Return on common stoc k = 11.8% + 2% | 13.800% | |||