Please use the provided excel to solve this problem and please shows work / formula on working cells. Compano Inc. was founded in 1986 in Baytown, Texas. The firm provides oil-field services to the Texas Gulf Coast region, including the leasing of drilling barges. Its balance sheet for year-end 2014 describes a firm with $830, 541,000 in book value assets that has a market value of $1.334 billion.

December 31, 2014

	Balance Sheet (Book Values)	Invested Capital (Market Values)
Liabilities and Owner's Capital
Current liabilities:
Accounts Payable	$8,250,000
Notes Payable	-	-
Other current liabilities	$7,266,000
Total current liabilities	$15,516,000
Long-term debt (8.5% interest paid semiannually, due in 2015)	$420,000,000	$434,091,171
Total liabilities	$435,516,000	$434,091,171
Owner's capital:
Common stock ($1 par value per share	$40,000,000
Paid-in-capital	$100,025,000
Accumulated earnings	$255,000,000
Total owner's capital	$395,025,000	$900,000,000
Total liabilities and owner's capital	$830,541,000	$1,334,091,171

Companos executive management team is concerned that its new investments be required to meet an appropriate cost of capital hurdle before capital is committed. Consequently, the firms CFO has initiated a cost of capital study by one of his senior financial analysts, Jim Tipolli. Jims first action was to contact the firms investment banker to get input on current capital costs.

Jim learned that, although the firms current debt capital required an 8.5% coupon rate of interest (with annual interest payments and no principal repayments until 2025), the current yield on similar debt had declined to 8% if the firm were to raise debt funds today. When he asked about the beta for Companos debt, Jim was told that it was standard practice to assume a beta of .30 for the corporate debt of firms such as Compano.

1. What are Companos capital structure weights for debt and equity that should be used to compute its cost of capital?

2. Based on Companos corporate income tax rate of 40%, the firms mix of debt and equity financing, and an unlevered beta estimate of .90 what is Compano's levered equity beta? (Hint: Compano plans on maintaining the mix of financing over time).

3. Assuming a long-tern U.S. Treasury bond yield of 5.42% and an estimated market risk premium of 5%, what should Jims estimate of Companos cost of equity be if he uses the CAPM?

4. What is your estimate of Companos WACC?

Please use the provided excel to solve this problem and please shows work / formula on working cells.

Given December 31, 2014 Balance Sheet Invested Capital (Book Values) (Market Values) Liabilities and Owner's Capital s 8,250.000 Current liabilities Accounts payable Notes payable Other current liabilities Total current liabilities Solution Legend = Value given in problem - Formula/Calculation/Analysis required 7,266,000 15,516,000 $ $ $ 420,000,000 $ 434,091,171 Long-term debt (8.5% interest paid semi-annually, due in 2015) Total liabilities $ 435,516,000 $ 434,091,171 $ 40,000,000 Owners' capital Common stock (S1 par value per share) Paid-in-capital Accumulated earnings Total owners' capital Total liabilities and owners' capital 100,025,000 255,000,000 395 025,000 830,541,000 $ $ $ 900,000,000 1,334,091,171 Capital Market Data Treasury Bond Yield Market Risk Premium Unlevered equity beta (SIC 4924) 5.42% 5.00% 0.90 22.50 Stock price 8.00% 0.30 Market capitalization Yield on debt Bond beta Short-term interest bearing debt New long-term debt total Tax Rate $ 40.00% Solution a. Evaluate the capital structure weights Enterprise Value = Market Capitalization + Debt Debt / Enterprise Value Equity / Enterprise Value b. Estimate leverged equity beta Cost of Debt (after taxes) Debt/Equity Ratio Levered equity beta c. Estimate cost of equity Cost of equity d. Etimate WACC (using workheet below) WACC Worksheet: Capital Structure Weighting After-Tax Cost Weighted After-Tax Cost Source of Capital Debt Equity WACC