Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am having difficulties answering the question in the red box. This is what I solved for the first part of the question Please try

I am having difficulties answering the question in the red box.

image text in transcribed

This is what I solved for the first part of the question

image text in transcribed

image text in transcribedPlease try to demonstrate the answer in excel and show some explanation!

I greatly appreciate your help.

Consider a mining and processing project for an oil tar sands project. From the data given below, calculate the after-tax cash flows for a 30-year life of the project and the NPV for an MARR of 15% Initial capital expenditures totaled $415.5 million and were distributed over four years (10% in year 0,30% in year 1, 40% in year 2, and 20% in year 3). Beginning in year 4: 17.666 million tons of ore will be mined per year -Bitumen production rate will be 7.347 million barrels per year -Product yield will be 0841 barrels of oil per barrel of bitumen -Product selling price will be $80 per bamel -Operating costs: $10.47 per barrel of bitumen for plant and upgrading costs $9.02 per ton of ore for mining costs -10-year straight-line depreciation -4% tax rate (state and federal) After completing the analyses determine the sensitivity of a possible reduced selling price of the product on the profitability (rate of return) of the project. Perform this analyses in 10% increments until the project does not produce a rate of return that meets the MARR. At each increment of reduction in selling price what production increase will be required to maintain the profit margin achieved at $80 per barrel. Place your sensitivity analyses on a separate tab from the NPV analyses of your excel file. Include graphics/excel charts to summarize your analyses and conclusions Consider a mining and processing project for an oil tar sands project. From the data given below, calculate the after-tax cash flows for a 30-year life of the project and the NPV for an MARR of 15% Initial capital expenditures totaled $415.5 million and were distributed over four years (10% in year 0,30% in year 1, 40% in year 2, and 20% in year 3). Beginning in year 4: 17.666 million tons of ore will be mined per year -Bitumen production rate will be 7.347 million barrels per year -Product yield will be 0841 barrels of oil per barrel of bitumen -Product selling price will be $80 per bamel -Operating costs: $10.47 per barrel of bitumen for plant and upgrading costs $9.02 per ton of ore for mining costs -10-year straight-line depreciation -4% tax rate (state and federal) After completing the analyses determine the sensitivity of a possible reduced selling price of the product on the profitability (rate of return) of the project. Perform this analyses in 10% increments until the project does not produce a rate of return that meets the MARR. At each increment of reduction in selling price what production increase will be required to maintain the profit margin achieved at $80 per barrel. Place your sensitivity analyses on a separate tab from the NPV analyses of your excel file. Include graphics/excel charts to summarize your analyses and conclusions

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

Management Control Systems Performance Measurement Evaluation And Incentives

Authors: Kenneth Merchant, Wim Van Der Stede

4th Edition

1292110554, 978-1292110554

More Books

Students also viewed these Accounting questions

Question

=+ Is the information source free from bias on the subject?

Answered: 1 week ago

Question

=+ Is the information source knowledgeable about the subject?

Answered: 1 week ago

Question

=+2. How will it be used?

Answered: 1 week ago