1. Eagle Creek Resources, Inc. is preparing its analysis of capital projects for the next capital budgeting cycle. As part of the preparation, Eagle Creek needs to estimate its cost of capital. Eagle Creek has a market to book ratio of 0, a 40% debt ratio, a 60% dividend payout ratio and a 40% marginal tax rate. Eagle Creek has no preferred stock. The companys most recent earnings per share were $4.17. Eagle Creek expects to earn a net income next year of $6 million. Eagle Creek has a bond issue outstanding that has an 8.2% coupon rate, a $1,000 face value, and 20 years remaining until maturity. The bonds currently sell for $877.48 each. New debt issued would have a 20-year maturity and would be privately placed thus incurring no flotation cost. The companys stock is currently quoted at a price of $28.00 per share. New stock issued would incur a 20% flotation charge. Eagle Creek uses the dividend growth model (DCF) to estimate the cost of equity capital and assumes that future growth will be constant. Calculate the following for Eagle Creek Resources:

1. Before tax cost of debt

2. After tax cost of debt

3. Cost of internal equity (retained earnings)

4. Cost of external equity (new common stock)

5. WACC using internal equity

6. WACC using external equity

7. Break point for internal equity

*NOTE* Please use Excel if possible along with showing formulas/cell references.