PLEASE FILL OUT THE PICTURE AS YOUR ANSWER THANK YOY Your company, Deep Rock Mining LLC, is considering an expansion of operations into iron ore mining Your engineers have just completed a 6 month survey designed to determine whether or not a viable mining operation can be mounted on a particular piece of land This survey cost $500,000 to complete The results of the survey, along with several other pieces of information, are detailed below Survey Results Your engineers estimate that there are 650,000 700,000 tons of recoverable iron ore underneath this land Investment in CapEx If you choose to move forward with the project, you will need to invest in several new pieces of mining equipment The cost of this new equipment is $10,000,000 This equipment will need to be manufactured to your specific needs Design and construction of this equipment will take one year Payment is due upon delivery of the new equipment to your site at the end of this year Once the equipment is built, it will need to be transported and installed onsite at an additional cost of $1,500,000 An additional $500,000 will need to be spent to prepare the site itself for the installation of the new equipment This includes grading the land, running electrical and water lines, ensuring proper drainage, and making sure all environmental requirements are followed Operations After the equipment has been installed onsite at the end of Year 1, mining operations will commence in Year 2 Your team estimates you can produce 125,000 tons of ore in the first year of mining operations The amount of ore produced will remain constant for the first four years of operations at 125,000 tons per year Beginning with the 5th year of mining operations, as the easier to access ore becomes more scarce, your team estimates that the amount of ore produced will begin to decrease by 60 per year, relative to the year prior This will continue for three years After the 7th year of mining operations, it is estimated that the mine will no longer be viable and will be shut down Accounting Assumptions For the purposes of this analysis, the price of ore is assumed to remain constant for the life of the project Iron ore currently sells for $125 ton The operating costs to extract the ore are estimated to be $70 per ton for the life of the project 1 Forecast the incremental free cash flows that will result from an investment in this project 2 Based upon the cash flows calculated in question 1, what is the NPV of this project 3 A significant source of uncertainty in this project lies in the base case assumptions made surrounding the prevailing price of iron ore, assumed to be $125 ton, and the costs of production, assumed to be $70 ton Perform the following sensitivity analysis to give your board a better sense of just how much margin for error there is in this project a Holding all other assumptions constant, what is the NPV break even price of iron ore for this project Put another way, what price of iron ore must be realized throughout the life of this project to result in an NPV of zero b Holding all other assumptions constant, what is the NPV break even level of production costs 4 Your HSSE Director (Health, Safety, Security, Environment) informs you that there will likely be ongoing costs associated with maintaining the decommissioned mine once operations cease It is estimated that these costs will reduce your firms pretax income by $500,000 per year and will last forever If these costs begin in the year immediately after the termination of operations, what is your adjusted NPV calculation for this project 5 As previously stated, one of the more significant sources of uncertainty in this project lies in the variable cost of production Though you have a sense of how difficult and expensive the mining operation will be as a result of your geological survey, past experience tells you that you really wont know until you begin operations Your base case assumption of variable production costs of $70 ton is the result of several different scenarios identified by one of your analysts, along with some associated probabilities These scenarios are Scenario Description Cost of Production ($ ton) Probability A Very easy mining No additional processing required $40 25 B Easy mining Some additional processing required $60 25 C Somewhat difficult and slow mining Additional processing required $80 25 D Very difficult mining Significant additional processing required $100 25 At the end of the first year of production, you will have a much better sense of what production costs will be for this mine You are going to assume that whatever variable production costs are realized over the course of the first year of operations will remain constant for the remaining 6 years of operations In other words, after the first year of operations, you will know for certain which of the above scenarios has come to fruition Always one to look ahead and leave your options open, you have purchased what amounts to a put contract for this mine that expires at the end of Year 2 This contract gives you the right, but not the obligation, to sell the mine for $7,500,000 and simply walk away at the end of Year 2 Selling the mine in this manner would also transfer ownership of any and all equipment onsite It would also transfer the legal obligation and cost of maintaining the mine post shutdown to the new owner (For the purposes of this case study, you may assume that the $7,500,000 selling price is an after tax amount ) You secured this option because you knew how much uncertainty there is in mining and that there may be a chance that skyrocketing production costs may make the operation uneconomical Given the existence of this option to abandon the project, recalculate the projects T 0 NPV, using your base case price cost assumptions, as well as the additional HSSE maintenance costs outlined in question 4 Assumptions PRING21 Case Study 1 Assumptions Price in $ ton COGS In $ tan Year 1 Tons Tax Rate Cost of Capital 4 5 6 7 8 8 the table below, please forecast the incremental free cash flows that would result from an investment in this project using your base case sumptions At this point, do NOT include any incremental effect of the shutdown costs referenced in part 4, nor any impact from the option to andon detailed in part 5 Question 1) Year 0 1 2 3 Revenue Cost of Production (COGS) ou may make use of any formulas you'd Gross Profit ce when filling in this table, but please SG A not insert remove any cells, rows, R D d or columns Do not make any rmatting changes Other Expenses Depreciation EBIT Income Tax Incremental Earnings PLUS Depreciation LESS Capex LESS Increase in NWC Salvaged Equip Cash Flow Free Cash Flows Question 2) NPV of this project given our base case assumptions dollars Student Names NetID Question 3a) 1 2 Break even (NPV 0) price of iron ore for this project $ ton 3 Question 3b) Break even (NPV 0) level of production costs for this project $ ton 4 51 Question 4) Adjusted NPV forecast incorporating additional HSSE costs dollars Question 5) Updated NPV reflecting option to abandon mine after Year 2 dollars Assumptions PRING21 Case Study 1 Assumptions Price in $ ton COGS In $ tan Year 1 Tons Tax Rate Cost of Capital 4 5 6 7 8 8 the table below, please forecast the incremental free cash flows that would result from an investment in this project using your base case sumptions At this point, do NOT include any incremental effect of the shutdown costs referenced in part 4, nor any impact from the option to andon detailed in part 5 Question 1) Year 0 1 2 3 Revenue Cost of Production (COGS) ou may make use of any formulas you'd Gross Profit ce when filling in this table, but please SG A not insert remove any cells, rows, R D d or columns Do not make any rmatting changes Other Expenses Depreciation EBIT Income Tax Incremental Earnings PLUS Depreciation LESS Capex LESS Increase in NWC Salvaged Equip Cash Flow Free Cash Flows Question 2) NPV of this project given our base case assumptions dollars Student Names NetID Question 3a) 1 2 Break even (NPV 0) price of iron ore for this project $ ton 3 Question 3b) Break even (NPV 0) level of production costs for this project $ ton 4 51 Question 4) Adjusted NPV forecast incorporating additional HSSE costs dollars Question 5) Updated NPV reflecting option to abandon mine after Year 2 dollars

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 04, 2024

PLEASE FILL OUT THE PICTURE AS YOUR ANSWER. THANK YOY Your company, Deep Rock Mining LLC, is considering an expansion of operations into iron ore

PLEASE FILL OUT THE PICTURE AS YOUR ANSWER. THANK YOY

image text in transcribed

Your company, Deep Rock Mining LLC, is considering an expansion of operations into iron ore mining. Your engineers have just completed a 6-month survey designed to determine whether or not a viable mining operation can be mounted on a particular piece of land. This survey cost $500,000 to complete. The results of the survey, along with several other pieces of information, are detailed below: Survey Results: Your engineers estimate that there are 650,000-700,000 tons of recoverable iron ore underneath this land. Investment in CapEx: If you choose to move forward with the project, you will need to invest in several new pieces of mining equipment. The cost of this new equipment is $10,000,000. This equipment will need to be manufactured to your specific needs. Design and construction of this equipment will take one year. Payment is due upon delivery of the new equipment to your site at the end of this year. Once the equipment is built, it will need to be transported and installed onsite at an additional cost of $1,500,000. An additional $500,000 will need to be spent to prepare the site itself for the installation of the new equipment. This includes grading the land, running electrical and water lines, ensuring proper drainage, and making sure all environmental requirements are followed. Operations: After the equipment has been installed onsite at the end of Year 1, mining operations will commence in Year 2. Your team estimates you can produce 125,000 tons of ore in the first year of mining operations. The amount of ore produced will remain constant for the first four years of operations at 125,000 tons per year. Beginning with the 5th year of mining operations, as the easier-to-access ore becomes more scarce, your team estimates that the amount of ore produced will begin to decrease by 60% per year, relative to the year prior. This will continue for three years. After the 7th year of mining operations, it is estimated that the mine will no longer be viable and will be shut down. Accounting Assumptions: For the purposes of this analysis, the price of ore is assumed to remain constant for the life of the project. Iron ore currently sells for $125/ton. The operating costs to extract the ore are estimated to be $70 per ton for the life of the project.

1. Forecast the incremental free cash flows that will result from an investment in this project.

2. Based upon the cash flows calculated in question 1, what is the NPV of this project?

3. A significant source of uncertainty in this project lies in the base case assumptions made surrounding the prevailing price of iron ore, assumed to be $125/ton, and the costs of production, assumed to be $70/ton. Perform the following sensitivity analysis to give your board a better sense of just how much margin for error there is in this project.

a. Holding all other assumptions constant, what is the NPV break-even price of iron ore for this project.? Put another way, what price of iron ore must be realized throughout the life of this project to result in an NPV of zero?

b. Holding all other assumptions constant, what is the NPV break-even level of production costs?

4. Your HSSE Director (Health, Safety, Security, & Environment) informs you that there will likely be ongoing costs associated with maintaining the decommissioned mine once operations cease. It is estimated that these costs will reduce your firms pretax income by $500,000 per year and will last forever. If these costs begin in the year immediately after the termination of operations, what is your adjusted NPV calculation for this project?

5. As previously stated, one of the more significant sources of uncertainty in this project lies in the variable cost of production. Though you have a sense of how difficult and expensive the mining operation will be as a result of your geological survey, past experience tells you that you really wont know until you begin operations. Your base case assumption of variable production costs of $70/ton is the result of several different scenarios identified by one of your analysts, along with some associated probabilities. These scenarios are:

Scenario	Description	Cost of Production ($/ton)	Probability
A	Very easy mining. No additional processing required.	$40	25%
B	Easy mining. Some additional processing required.	$60	25%
C	Somewhat difficult and slow mining. Additional processing required	$80	25%
D	Very difficult mining. Significant additional processing required.	$100	25%

At the end of the first year of production, you will have a much better sense of what production costs will be for this mine. You are going to assume that whatever variable production costs are realized over the course of the first year of operations will remain constant for the remaining 6 years of operations. In other words, after the first year of operations, you will know for certain which of the above scenarios has come to fruition.

Always one to look ahead and leave your options open, you have purchased what amounts to a put contract for this mine that expires at the end of Year 2. This contract gives you the right, but not the obligation, to sell the mine for $7,500,000 and simply walk away at the end of Year 2. Selling the mine in this manner would also transfer ownership of any and all equipment onsite. It would also transfer the legal obligation and cost of maintaining the mine post-shutdown to the new owner. (For the purposes of this case study, you may assume that the $7,500,000 selling price is an after-tax amount.)

You secured this option because you knew how much uncertainty there is in mining and that there may be a chance that skyrocketing production costs may make the operation uneconomical.

Given the existence of this option to abandon the project, recalculate the projects T=0 NPV, using your base case price/cost assumptions, as well as the additional HSSE maintenance costs outlined in question 4.

Assumptions : PRING21 Case Study #1 Assumptions: Price in $/ton: COGS In $/tan: Year 1 Tons Tax Rate Cost of Capital: 4 5 6 7 8 8 the table below, please forecast the incremental free cash flows that would result from an investment in this project using your base-case sumptions. At this point, do NOT include any incremental effect of the shutdown costs referenced in part 4, nor any impact from the option to andon detailed in part 5. Question 1) Year 0 1 2 3 Revenue Cost of Production (COGS) ou may make use of any formulas you'd Gross Profit ce when filling in this table, but please SG&A not insert/remove any cells, rows, R&D d/or columns. Do not make any rmatting changes. Other Expenses Depreciation EBIT Income Tax Incremental Earnings PLUS: Depreciation LESS: Capex LESS: Increase in NWC Salvaged Equip Cash Flow Free Cash Flows Question 2) NPV of this project given our base-case assumptions: dollars Student Names NetID Question 3a) 1 2 Break-even (NPV=0) price of iron ore for this project: $/ton 3 Question 3b) Break-even (NPV=0) level of production costs for this project: : $/ton 4 51 Question 4) Adjusted NPV forecast incorporating additional HSSE costs: dollars Question 5) Updated NPV reflecting option to abandon mine after Year 2: dollars Assumptions : PRING21 Case Study #1 Assumptions: Price in $/ton: COGS In $/tan: Year 1 Tons Tax Rate Cost of Capital: 4 5 6 7 8 8 the table below, please forecast the incremental free cash flows that would result from an investment in this project using your base-case sumptions. At this point, do NOT include any incremental effect of the shutdown costs referenced in part 4, nor any impact from the option to andon detailed in part 5. Question 1) Year 0 1 2 3 Revenue Cost of Production (COGS) ou may make use of any formulas you'd Gross Profit ce when filling in this table, but please SG&A not insert/remove any cells, rows, R&D d/or columns. Do not make any rmatting changes. Other Expenses Depreciation EBIT Income Tax Incremental Earnings PLUS: Depreciation LESS: Capex LESS: Increase in NWC Salvaged Equip Cash Flow Free Cash Flows Question 2) NPV of this project given our base-case assumptions: dollars Student Names NetID Question 3a) 1 2 Break-even (NPV=0) price of iron ore for this project: $/ton 3 Question 3b) Break-even (NPV=0) level of production costs for this project: : $/ton 4 51 Question 4) Adjusted NPV forecast incorporating additional HSSE costs: dollars Question 5) Updated NPV reflecting option to abandon mine after Year 2: dollars