In: Finance
I am trying to determine the weight of long-term debt but don't know where to begin.
I know the answer is 22.58% but I don't know how to get there.
This is the problem:
Problem 9-17
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 | 10 | |||
Inventories | 20 | Short-term debt | 5 | |||
Current assets | $50 | Current liabilities | $25 | |||
Net fixed assets | 50 | Long-term debt | 30 | |||
Preferred stock | 5 | |||||
Common equity | ||||||
Common stock | $10 | |||||
Retained earnings | 30 | |||||
Total common equity | $40 | |||||
Total assets | $100 | Total liabilities and equity | $100 |
The following facts also apply to TII:
I know the answer is 22.58% but I don't know how to get there.
We will calculate the market value of each of the three components:
Long term Debt
Market value can be calculated using the PV function in excel. Inouts are:
Rate = YTM = 12%; Nper = 30 years, FV = Par value = $ 30 million (this figure appears on the balance sheet against long term debt); PMT = anual coupon = 10% of par value = 10% x 30 = $ 3 million
Hence, Market value of long term debt = D = - PV (Rate, Nper, PMT, FV) = - PV (12%, 30, 3, 30) = $ $25.17
Preferred Stock
Current market price = Annual dividend / yield = 4 x quarterly dividend / 8% = (4 x 2.50 x Par value) / 8% = (4 x 2.50 x 100) / 8% = $ 125 / share
Book value of preferred stock = $ 5 million ((this figure appears on the balance sheet against preferred stock)
Number of preferred stock = Ns = Book value / Par value = 5 million / 100 = 5,000,000 / 100 = 50,000
Market value of preferred stock, S = Current market price x Number of preferred stock = 125 x 50,000 = $ 6.25 million
Common Equity
Market value, E = Price x Number = P0 x N = 20 x 4 million = $ 80 million
Hence, the weight of long-term debt = D / (D + S + E) = 25.17 / (25.17 + 6.25 + 80.00) = 22.58%
I sincerely hope that you now got a much needed headstart.