Question

In: Finance

1) You own a mining company and are trying to decide which of three mines to...

1) You own a mining company and are trying to decide which of three mines to lease to extract ore from. For mine A you pay a leasing fee of $1,040 in period 0, and then earn net profits of $400 per year for years 1-8; in year 9 you have to pay a fee of $2,500 to rehabilitate the mining site.

For mine B you pay a fee of $240 in period 0 to lease the mine and then earn $80 per year for the next 4 years. Finally, for mine C you pay a leasing fee of $400 in period 0 and then receive profits of $90 per year for years 1-6..


a) Graph the NPV profiles for all three mines (do all of your NPV calculations before graphing). (8) B) What are the IRRs (at least to the 1st decimal point) for each of the mines? (8) c) Explain in detail which mine you would choose if your goal is to maximize the NPV. Be as specific as possible. (13) d) What is the MIRR for project A using the combination approach? Assume a discount rate of 10%.

Solutions

Expert Solution

Ans a)

PV profiles: It provides Chart of NPV of projects at different Discount rates.

Here to calculate NPV of all Mines we have used NPV Function in Excel .

Arguments are : NPV(Rate, Cash Flows in Periods) [Rate : It is discount Rate , periods Cash flow from Year 01 to till end of the Project]

Further we Have add Cash flow of Year 0 with NPV Function to Calculate NPV of All Mines in different discount rates.

Excel Calculn :

Next We draw charts of NPV profiles of all 03 Mines :

X Axis - Discount Rates

Y Axis - NPV

Ans b)

IRR Calculation :

To Calculate we have used Excel IRR Function.  

We have to keep in Mind unlike NPV function IRR consider cash flow from Year 0. So we do not need to add Cash flow of year zero seperately.

Project A Project B Project C
7.55% 12.59% 9.31%

Ans C)

To maximize the NPV we need to choose project accordingly what is the expected discount rate of the project. I.E. whats is the return investor looking for from the project.

From the given table of NPV profile: If the Investor looking for a Discount rate Below 6% No doubt Project C will be the best choice.

If the discount rate Increases project B will be preferred till 8% return.

Over 8% to till around 21% discount rate Project A will be preferred.

Ans D)

To calculate MIRR we have used MIRR Function

Here We have to Provide Cash flows from Year 0. Investment Rate and Reinvestment Rate of Cash flows..

Investment Rate and Reinvestment Rate of Cash flows are 10%.

So MIRR of Project a is 10.195% given a discount rate of 10%.


Related Solutions

BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies...
You are a Canadian manufacturer of mining equipment which is used for underground coal mines. You...
You are a Canadian manufacturer of mining equipment which is used for underground coal mines. You are selecting a potential market for export. How would you find the right market? Preliminary export market research indicates the following countries as potential markets: Australia, China, England, India, Indonesia, Kazakhstan, Russia, Ukraine and South Africa. Assess these markets in order to determine (select) the best market for your mining equipment.
Question: BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located...
Question: BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located i... BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit...
Pickins Mining Pickins Mining is a midsized coal mining company with 20 mines located in Ohio,...
Pickins Mining Pickins Mining is a midsized coal mining company with 20 mines located in Ohio, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Pickins, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led...
Pickins Mining Pickins Mining is a midsized coal mining company with 20 mines located in Ohio,...
Pickins Mining Pickins Mining is a midsized coal mining company with 20 mines located in Ohio, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Pickins, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led...
1. You are trying to decide which 2 devices to install. The following are the details...
1. You are trying to decide which 2 devices to install. The following are the details for the devices with a useful life of 5 years. Your MARR is 10%. What is the Benefit-Cost Ratio of Device 1?: Device 1 Device 2 Device 3 Initial Cost $110,000 $200,000 $150,000 Salvage Value $10,000 $30,000 $20,000 O&M Costs $5,000 $2,000 $6,000 Annual Benefits $35,000 $40,000 $35,00 Year 1, increasing $5,000 each subsequent year 2. what is the benefit - cost ratio for...
Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West...
Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT