Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer only question 3 and show work in excel Martin Mining has the following information regarding its debt and equity. Find the weighted average

Please answer only question 3 and show work in excel

  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.

  1. 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?

  1. 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 only question 3 and show work in excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Aircraft Finance Strategies For Managing Capital Costs In A Turbulent Industry

Authors: Bijan Vasigh, Reza Taleghani, Darryl Jenkins

1st Edition

1604270713, 9781604270716

More Books

Students also viewed these Finance questions

Question

Did you add the logo at correct size and proportion?

Answered: 1 week ago

Question

Did you ask for action?

Answered: 1 week ago