Reference no: EM133068044
1. Please provide 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 (25 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?
|
What is the value of the stock the tax rate
: The cost of debt is 7.3% and the cost of equity is 14.9%. What is the value of the stock if the tax rate is 28%?
|
|
What is the cost of the nil paid rights
: On 25 February 2018, Jane bought 2 500 ordinary shares in XYZ Ltd at a cost of $8 125. What is the cost of the nil paid rights
|
|
Compute the incremental income before taxes
: Apollo Data Systems is considering extending trade credit to some customers previously considered poor risks. Sales would increase by $140,000 if credit is exte
|
|
What is the cost of capital for team
: Your team is valued for $2,000,000. $1,300,000 is equity paying dividends of 12% to owners. $700,000 is debt consisting of two leans, one is worth $500,000 and
|
|
What is the total profit earned from project
: 1. Please provide 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 pot
|
|
What was the balance on the loan at the end of two years
: Taylor had a loan of $101,000 and made payments of $2,500 at the end of every month to settle it. What was the balance on the loan at the end of two years
|
|
Cash flow under different hedging alternatives
: P&G Limited considers hedging its receivables of €500000 due in 4 months. It can obtain a forward contract to purchase Euro in 4 months.
|
|
Equivalent annual cost of the project
: If a project has an NPV of $140,00 over 7 years with a 10% discount rate, what is the equivalent annual cost of the project rounded to the nearest dollar?
|
|
Examine the techniques of testing controls
: Examine the techniques of testing controls that should be applied by the auditing firm. Given an example for each technique identified
|