Input area: | ||
Land cost | $ 4,000,000 | |
Aftertax land value | $ 6,500,000 | |
Equipment | $ 95,000,000 | |
Equipment salvage | 60% | |
Contract sales/tons | 500,000 | |
Contract $/ton | $86 | |
Year 1 production | 620,000 | |
Year 2 production | 680,000 | |
Year 3 production | 730,000 | |
Year 4 production | 590,000 | |
Spot market $/ton | $77 | |
Variable cost/ton | $31 | |
Fixed costs | $4,100,000 | |
NWC percent | 5% | |
Reclamation costs | $2,700,000 | |
Charitable expense | $6,000,000 | |
Tax rate | 38% | |
Required return | 12% | |
Year 1 depreciation | 14.29% | |
Year 2 depreciation | 24.49% | |
Year 3 depreciation | 17.49% | |
Year 4 depreciation | 12.49% | |
Output area: | ||||||
Time 0 cash flow | ||||||
Equipment | $ (95,000,000) | |||||
Land | (6,500,000) | |||||
NWC | (2,612,000) | |||||
Total | ($104,112,000) | |||||
Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Contract | $ 43,000,000 | $ 43,000,000 | $ 43,000,000 | $ 43,000,000 | ||
Spot | 9,240,000 | 13,860,000 | 17,710,000 | 6,930,000 | ||
Total | $ 52,240,000 | $ 56,860,000 | $ 60,710,000 | $ 49,930,000 | ||
Sales | $ 52,240,000 | $ 56,860,000 | $ 60,710,000 | $ 49,930,000 | ||
VC | 19,220,000 | 21,080,000 | 22,630,000 | 18,290,000 | ||
FC | 4,100,000 | 4,100,000 | 4,100,000 | 4,100,000 | $ 2,700,000 | |
Dep | 13,575,500 | 23,265,500 | 16,615,500 | 11,865,500 | ||
EBT | $ 15,344,500 | $ 8,414,500 | $ 17,364,500 | $ 15,674,500 | $ (2,700,000) | |
Tax | 5,830,910 | 3,197,510 | 6,598,510 | 5,956,310 | (1,026,000) | (2,280,000) |
NI | $ 9,513,590 | $ 5,216,990 | $ 10,765,990 | $ 9,718,190 | $ (1,674,000) | $ 2,280,000 |
+ Dep | 13,575,500 | 23,265,500 | 16,615,500 | 11,865,500 | - | - |
OCF | $ 23,089,090 | $ 28,482,490 | $ 27,381,490 | $ 21,583,690 | $ (1,674,000) | $ 2,280,000 |
Beginning NWC | $ 2,612,000 | $ 2,843,000 | $ 3,035,500 | $ 2,496,500 | ||
Ending NWC | 2,843,000 | 3,035,500 | 2,496,500 | |||
NWC cash flow | $ (231,000) | $ (192,500) | $ 539,000 | $ 2,496,500 | ||
Total cash flow | $ 22,858,090 | $ 28,289,990 | $ 27,920,490 | $ 24,080,190 | $ (1,674,000) | $ 2,280,000 |
Book value | $ 81,424,500 | $ 58,159,000 | $ 41,543,500 | $ 29,678,000 | ||
Salvage | MV | $ 57,000,000 | ||||
BV | 29,678,000 | |||||
Taxes | (10,382,360) | |||||
Salvage CF | $ 46,617,640 | |||||
Time | Cash flow | |||||
0 | $ (104,112,000) | |||||
1 | 22,858,090 | |||||
2 | 28,289,990 | |||||
3 | 27,920,490 | |||||
4 | 70,697,830 | |||||
5 | (1,674,000) | |||||
6 | 2,280,000 | |||||
Profitability index | 1.0371 | |||||
Average accounting return | 9.76% | |||||
IRR | 13.45% | |||||
IRR | 13.45% | |||||
NPV | $ 3,857,864.51 | |||||
Please show ALL EXCEL FORMULAS! BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company...
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal raining company with 20 mines located in Ohio, Pennsyl- vania, 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 and new pollution reduction...
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
PLEASE NOTE: THE ANSWER IS NOTE THAT 1,634,248 FOR PART A Salter Mining Company purchased the Northern Tier Mine for $68 million cash. The mine was estimated to contain 3.27 million tons of ore and to have a residual value of $1.2 million. During the first year of mining operations at the Northern Tier Mine, 80,000 tons of ore were mined, of which 14,000 tons were sold. a. Prepare a journal entry to record depletion during the year. b. Show...