PLEASE ANSWER QUESTION 3 ONLY IN EXCEL AND SHOW WORK

1. Martin Mining has the following information regarding its debt and equity. Find the weighted average cost of capital. Assume the tax rate is 25%.

Beta	1.25
Expected Return on Market	11.25%
Treasury Bond Rate	3.8%
Flotation Cost of Equity	5%
Book Value of Debt	$2,000,000,000
Market Value of Debt	$2,500,000,000
Book Value of Equity	$3,500,000,000
Market Value of Equity	$4,000,000,000
Bond Information	Coupon rate = 8%, maturity = 20 years, maturity value =$1,000 and the current price is 1,082.25. Assume interest is paid semiannually.

2. Martin Mining is considering a new investment that will last for six years. The project has projected sales of $1,557,000. Variable costs are 55 percent of sales and fixed costs are $85,000; depreciation $91,000 per year. Prepare a pro forma income statement assuming a tax rate of 25 percent. Assume the project costs $1,500,000. What is projected net income? What is operating cash flow?

3. Now assume that Martin Mining is planning to evaluate the project in problem (2) using the information on the cost of capital from problem (1). In addition to the previous information, assume that Martin will need to invest $500,000 in net working capital and that it will be recovered at the end of the project. Evaluate the project using NPV and IRR.

PLEASE ANSWER QUESTION 3 IN EXCEL AND SHOW WORK