Question: please show excel functions and work Strip Mining incorporated can develop a new mine at an initial cost of $5 million. The mine will provide

please show excel functions and work

Strip Mining incorporated can develop a new mine at an initial cost of $5 million. The mine will provide a cash flow of $30 million in 1 yeat. The land then must be reclaimed at a cost of $28 million in the second year. a. What are the IRRs of this project? Note: Enter your answers in ascending order. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. b. Should the firm develop the mine if the discount rate is 10% ?, or 20% ?, or 350%, or 400% ? Note: Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers in millions rounded to 3 decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Strip Mining Incorporated can develop a new mine at an initial cost of $5 million. The mine will provide a cash flow of $30 million in 1 year. The land then must be reclaimed at a cost of $28 million...

please help Check my w 2 Strip Mining Inc. can develop a new mine at an initial cost of $8 million. The mine will provide a cash flow of $30 milion in 1 year. The land then must be reclaimed at a...

Strip Mining Incorporated can develop a new mine at an initial cost of $13 million. The mine will provide a cash flow of $40 million in 1 year. The land then must be reclaimed at a cost of $30...

Strip Mining Incorporated can develop a new mine at an initial cost of $ 1 2 million. The mine will provide a cash flow of $ 4 0 million in 1 year. The land then must be reclaimed at a cost of $ 3 1...

Strip Mining Incorporated can develop a new mine at an initial cost of $ 1 4 million. The mine will provide a cash flow of $ 4 1 million in 1 year. The land then must be reclaimed at a cost of $ 2 9...

Old MathJax webview please help Check my work 2 Strip Mining Inc. can develop a new mine at an initial cost of $8 million. The mine will provide a cash flow of $30 million in 1 year. The land then...

O lu. 1:1 FINA 306 MINICASE EXCEL Spring... A Administrative matters 1. Assignment will be done by using Microsoft Excel and Word. 2. The deadline for the assignment is 13th May, 2020, Wednesday....

LISTING OF EQUATIONS 8.1 NPV = PV - required investment 8.2 Profitability index = net present value initial investment 8.3 Equivalent annual annuity = present value of costs annuity factor QUESTIONS...

Strip Mining Inc. can develop a new mine at an initial cost of $11 million. The mine will provide a cash flow of $34 million in 1 year. The land then must be reclaimed at a cost of $25 million in the...

Hi, can u help me figure out problem 34. Growth Enterprises believes its latest project, which will cost $80,000 to install, will generate a perpetual growing stream of cash flows. Cash flow at the...

A 50-cm-long metal rod rotates about the z-axis at 90 revolutions per minute, with end 1 fixed at the origin as shown in Fig. 6-21 (P6.9). Determine the induced emf V12 if B = z2 x 104 T.

Go through the transaction list (Document1) and identify which cycle each transaction belongs to. A transaction will belong to only one cycle; either the Sale to Cash Receipt (S/CR) Cycle, Purchases...

In 2 0 1 1 , Elmira inherited considerable property when her father died. When Elmira dies in 2 0 2 3 , her estate may be able to use the credit for tax on prior transfers to reduce some of the...

What opportunities does it have? aStrong and large community of Harley - Davidson motorcyclists bStrong appeal of Harley - Davidson in the Chinese market cGrowth in the super heavyweight market...

3.11 In a city of 120,000 people there are 20,000 Norwegians. What is the probability that a randomly selected person from the city will be Norwegian?

Suppose that Karlyns store now contains 10 Hewlett-Packard computers, 5 Dell computers, and 5 Sony computers. Susan enters the store and wants to purchase 3 computers. The computers are selected...

The Web site for a specialty clothing retailer receives 1,000 hits on a particular day. From past experience it has been determined that every 1,000 hits results in 10 large sales of at least $500...