Question
1. Please provide a print- out of the excel workbook for each part of the problem below along with the answer to each part. You
1. Please provide a print- out of the excel workbook for each part of the problem below along with the answer to each part.
You are deciding on the financial viability of a potential coal project that will provide a stream of profits for the next 25 years. The start-up costs for this project is $336,500.00, and the marginal extraction cost per ton is $49. You may assume that the rate of return on the next best investment alternative is 6.8%. There is a total of 18,000 short tons that can be mined. In the analysis, assume that you will extract the exact same amount of coal each year over the life of the project (15 years).
a. Assuming that you are able to sell at a price of $76.05 per short ton
i. What is the total profit earned from this project?
ii. What is the net present value of profit over the lifetime of this project?
iii. What is the internal rate of return on this project?
b. Determine the minimum price per short ton that will allow the project to break-even.
c. Suppose that as the economy improves the interest rate increases. How will this affect the net present value of profit at the price found in part (b)? Explain the intuition behind your result.
d. (return to default specification from the question prompt): Suppose that the price of coal begins at $76.05 per short ton and increases at a rate of 2.5% per year.
i. What is the total profit earned from this project?
ii. What is the net present value of profit over the lifetime of this project?
iii. What is the internal rate of return on this project?
HELP!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started