$($SOLVE IN EXCEL$)$

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:

The long$-$term debt consists of $29,412$ bonds, each having a $20-$year maturity, semiannual payments, a coupon rate of $7\mathrm{.}6\%,$ and a face value of $$1,000.$ Currently, these bonds provide investors with a yield to maturity of $11\mathrm{.}8\%.$ If new bonds were sold, they would have an $11\mathrm{.}8\%$ yield to maturity.

TII's perpetual preferred stock has a $$100$ par value, pays a quarterly dividend per share of $$3,$ and has a yield to investors of $8\%.$ New perpetual preferred stock would have to provide the same yield to investors, and the company would incur a $3\mathrm{.}95\%$ flotation cost to sell it$.$

The company has $3\mathrm{.}8$ million shares of common stock outstanding, a price per share $=$ P$0=$ $$20,$ dividend per share $=$ D$0=$ $$1,$ and earnings per share $=$ EPS$0=$ $$5.$ The return on equity $($ROE$)$ is expected to be $10\%.$

The stock has a beta of $1\mathrm{.}6.$ The T$-$bond rate is $5\%,$ and RPM is estimated to be $5\%.$

TII's financial vice president recently polled some pension fund investment managers who hold TII's securities regarding what minimum rate of return on TII's common would make them willing to buy the common rather than TII bonds, given that the bonds yielded $11\mathrm{.}8\%.$ The responses suggested a risk premium over TII bonds of $3$ percentage points.

TII is in the $25\%$ federal$-$plus$-$state tax bracket.

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.

What are the current market value weights for debt, preferred stock, and common stock? $($Hint: Do your work in dollars, not millions of dollars.$)$

Weight

Debt

$\%$

Preferred stock

$\%$

Common stock

$\%$

What is the after$-$tax cost of debt?

$\%$

What is the cost of preferred stock?

$\%$

What is the required return on common stock using CAPM?

$\%$

Use the retention growth equation to estimate the expected growth rate. Then use the expected growth rate and the dividend growth model to estimate the required return on common stock.

$\%$

What is the required return on common stock using the own$-$bond$-$yield$-$plus$-$judgmental$-$risk$-$premium approach?

$\%$

What is Travellers' WACC? Use the required returns on stock from part e$.$

$\%$