The $4 million cost of the land 10 years ago is a sunk cost and irrelevant. The $6.5 million after-tax sale price of the land today is an opportunity cost and is relevant.
Operating cash flow (OCF) each year = income after tax + depreciation - change in working capital
profit on sale of equipment at end of year 4 = sale price - book value
book value = original cost - accumulated depreciation
after-tax salvage value = salvage value - tax on profit on sale of equipment
Tax benefit in year 6 = charitable expense deduction * tax rate
NPV = sum of present values of cash flows
present value of each cash flow = cash flow / (1 + required return)n
where n = number of years after which the cash flow occurs
NPV = $10,692,628
IRR is calculated using IRR function in Excel
IRR = 15.98%
PI = (NPV + year 0 cash outflow) / year 0 cash outflow
PI = 1.10
Payback period is the time taken for the cumulative cash flows to equal zero
Payback period = 3 + (cash flow required in year 4 for cumulative cash flows to equal zero / year 4 cash flow) = 3 + ($19,697,375 / $76,287,375) = 3.26 years
NPV is $10,692,628
IRR is 15.98%
Yes, Bethesda Mining should take the contract because the NPV is positive and the IRR is higher than the required return.
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal raining company with 20 mines located in...
Please show ALL EXCEL FORMULAS! 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...
Bethesda Mining is a mid-sized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip minds. 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 an...
Bethesda Mining Company please answer neatly and organized, and I will give a thumbs up in return thank you. Please solve NPV and IRR and analyze the case and also answer if Bethesda can go forward with opening the mine. 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...
In March, 2017, Mayton Mining Co. purchased a coal mine for $12,000,000. Total possible coal to be mined is estimated at 2,000,000 tons. Mayton is required by law to restore the land to a reasonable condition after the conclusion of mining operations at an estimated cost of $750,000. Mayton estimates the land will then be worth $2,000,000. The company incurred $2,800,000 of development costs preparing the mine for production. During 2017, 400,000 tons were removed and 310,000 tons were sold....
Imperial Mining is a coal company that produces three grades of coal-High, Medium, and Low-in fixed proportions. The joint costs of mining total $1,770,000. In a typical month, the company will mine 20,480 tons of High-Grade, 30,720 tons of Medium-Grade, and 10,240 tons of Low-Grade coal. Market prices have been relatively stable at $60 per ton for High-Grade, $40 per ton for Medium- Grade, and $10 per ton for Low-Grade. There are no costs to refine the individual grades of...
In 2016, Western Maryland Company paid $3,000,000 for a mining tract with reserves of 100,000 tons of ore, which the company planned to mine over a 20-year period. The company spent $500,000 developing the mine. Western plans to spend $200,000 for reclamation when mining has been completed, after which the land will have an estimated value of $600,000. In 2016, Western mined and sold 8,000 tons of ore. What depletion should Western record for the year? A) $155,000 B) $296,000...
Imperial Mining is a coal company that produces three grades of coal-High, Medium, and Low-in fixed proportions. The joint costs of mining total $1,725,000. In a typical month, the company will mine 20,400 tons of High-Grade, 30,600 tons of Medium-Grade, and 10,200 tons of Low-Grade coal. Market prices have been relatively stable at $60 per ton for High-Grade, $40 per ton for Medium- Grade, and $10 per ton for Low-Grade. There are no costs to refine the individual grades of...
On April 17, 2018, the Loadstone Mining Company purchased the rights to a coal mine. The purchase price plus additional costs necessary to prepare the mine for extraction of the coal totaled $4,750,000. The company expects to extract 950,000 tons of coal during a four-year period. During 2018, 245,000 tons were extracted and sold immediately. Required: 1. Calculate depletion for 2018.
value 5.00 points On April 17,2016, the Loadstone Mining Company purchased the rights to a coal mine The purchase price plus additional costs necessary to prepare the mine for extraction of the coal totaled $2,790,000. The company expects to extract 930,000 tons of coal during a four year period. During 2016, 350,000 tons were extracted and sold immediately Required 1. Calculate depletion for 2016
Colorado Mining paid $644,000 to acquire a mine with 46,000 tons of coal reserves. The following statements model reflects Colorado Mining's financial condition just prior to purchasing the coal reserves. The company extracted 24,150 tons of coal in year 1 and 20,700 tons in year 2. Required a. Compute the depletion charge per unit b-1. Compute the depletion expense for years 1 and 2 in a financial statements 15 points Peint b-2. Record the acquisition of the coal reserves and...