BUS 5180: Investment Analysis Case Study
(Hint: Table 7.5 on page 279 and the discussion regarding that table in your text should be extremely helpful in completing this case study.)
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 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 technologies has led to an improved market demand for high-sulfur coal. Bethesda has just been approached by Mid-Ohio Electric Company with a request to supply coal for its electric generators for the next four years. Bethesda Mining does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine in Ohio. The land needed for this strip mine may be purchased for $5 million.
Bethesda will also need to purchase additional mining equipment, which will cost $30 million. The equipment will be depreciated using the straight-line method over 6 years, with no estimated salvage value. Since the coal will be completely mined from the proposed site and the contract will expire at the end of four years, Bethesda would plan to sell the equipment at the end of the contract. Bethesda believes that it will be able to sell the equipment for $15 million at that time.
Under the terms of the contract, Bethesda would provide Mid-Ohio with 600,000 tons of coal per year at a price of $34 per ton. Bethesda believes that coal production from the mine will be 650,000 tons, 725,000 tons, 810,000 tons, and 740,000 tons, respectively, over the next four years. The excess production will be sold on the spot market at an average of $40 per ton. Bethesda expects variable costs of $13 per ton and fixed costs other than the depreciation of $2,500,000 per year. The mine will require an investment in net working capital of 5% of the expected sales for the next year. At the end of the contract, this working capital will be freed up for use in other projects.
Bethesda will be responsible for reclaiming the land at the termination of the mining operation. This reclamation will occur at the end of year 4, at a cost of $4 million. At the conclusion of reclamation (still within year 4), Bethesda will donate the property to charity and will receive a resulting in a tax savings of $2 million.
Bethesda's income tax rate is expected to be 35%. Assume that losses in any year will result in a tax credit (negative income taxes). Bethesda has a required return of 12% on new strip mine projects.
You have been approached by the president of the company to analyze the proposed investment. You should compute the free cash flows for each year of this project (Year 0 through Year 4). Then, you should compute the payback period, accounting rate of return, benefit-cost ratio, net present value, and internal rate of return for this project. Then provide a recommendation to the president as to whether Bethesda should accept the contract and open the mine.
This question has the following supporting file(s):
- BUS_5180--Investment_Analysis_Case_Study--V2.doc
- Investment Analysis Case Study.xls
File Viewer (Click To Zoom)
File Viewer (Click To Zoom)
Solution Summary
The problem is a case study for Bethesda Mining. The company is evaluating whether to undertake an investment.
$2.19 
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- Investment Analysis.xls
Active since 2009
Responses 947
Extracted Content from Question Files:
- BUS_5180--Investment_Analysis_Case_Study--V2.doc
BUS 5180
Investment Analysis Case Study
(Hint: Table 7.5 on page 279 and the discussion regarding that table in your text should
be extremely helpful in completing this case study.)
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 and new pollution reduction technologies has led to an
improved market demand for high-sulfur coal. Bethesda has just been approached by
Mid-Ohio Electric Company with a request to supply coal for its electric generators for
the next four years. Bethesda Mining does not have enough excess capacity at its
existing mines to guarantee the contract. The company is considering opening a strip
mine in Ohio. The land needed for this strip mine may be purchased for $5 million.
Bethesda will also need to purchase additional mining equipment, which will cost
$30 million. The equipment will be depreciated using the straight-line method over 6
years, with no estimated salvage value. Since the coal will be completely mined from the
proposed site and the contract will expire at the end of four years, Bethesda would plan to
sell the equipment at the end of the contract. Bethesda believes that it will be able to sell
the equipment for $15 million at that time.
Under the terms of the contract, Bethesda would provide Mid-Ohio with 600,000
tons of coal per year at a price of $34 per ton. Bethesda believes that coal production
from the mine will be 650,000 tons, 725,000 tons, 810,000 tons, and 740,000 tons,
respectively, over the next four years. The excess production will be sold on the spot
market at an average of $40 per ton. Bethesda expects variable costs of $13 per ton and
fixed costs other than the depreciation of $2,500,000 per year. The mine will require an
investment in net working capital of 5% of the expected sales for the next year. At the
end of the contract, this working capital will be freed up for use in other projects.
Bethesda will be responsible for reclaiming the land at the termination of the
mining operation. This reclamation will occur at the end of year 4, at a cost of $4
million. At the conclusion of reclamation (still within year 4), Bethesda will donate the
property to charity and will receive a resulting in a tax savings of $2 million.
Bethesda’s income tax rate is expected to be 35%. Assume that losses in any year
will result in a tax credit (negative income taxes). Bethesda has a required return of 12%
on new strip mine projects.
You have been approached by the president of the company to analyze the
proposed investment. You should compute the free cash flows for each year of this
project (Year 0 through Year 4). Then, you should compute the payback period,
accounting rate of return, benefit-cost ratio, net present value, and internal rate of return
for this project. Then provide a recommendation to the president as to whether Bethesda
should accept the contract and open the mine.
- Investment Analysis Case Study.xls
Investment Analysis Case Study
Year
0 1 2
Purchase of Land -$5,000,000.00
Purchase of Mining Equipment -$30,000,000.00
Increased Working Capital -$1,120,000.00 -$150,000.00 -$170,000
Total Cash Outflows -$36,120,000.00 -$150,000.00 -$170,000
After Tax Cash Flow from Sale $0.00 $0.00 $0.00
After Tax Cash Flow fom Reclamation $0.00 $0.00 $0.00
Sales $22,400,000.00 $25,400,000.00
Variable Costs $8,450,000.00 $9,425,000.00
Fixed Costs $2,500,000.00 $2,500,000.00
Depreciation $5,000,000.00 $5,000,000.00
Income Before Tax $6,450,000.00 $8,475,000.00
Tax at 35% $2,257,500.00 $2,966,250.00
Income After Tax $4,192,500.00 $5,508,750.00
Add Back Depreciation $5,000,000.00 $5,000,000.00
After Tax Cash Flow $9,192,500.00 $10,508,750.00
Free Cash Flow -$36,120,000.00 $9,042,500.00 $10,338,750.00
Present Value -$36,120,000.00 $8,073,661.00 $8,241,988.00
Payback Period 3.20
Accounting Rate of Return 37.96%
Benefit Cost Ratio 1.10
Net Present Value $3,658,570.00
Internal Rate of Return 16.02% My recommendation should accept the contract and open
3 4
$140,000 $1,300,000
$140,000 $1,300,000
$0.00 $13,250,000
$0.00 -$2,000,000.00
$28,800,000.00 $26,000,000.00
$10,530,000.00 $9,620,000.00
$2,500,000.00 $2,500,000.00
$5,000,000.00 $5,000,000.00
$10,770,000.00 $8,880,000.00
$3,769,500.00 $3,108,000.00
$7,000,500.00 $5,772,000.00
$5,000,000.00 $5,000,000.00
$12,000,500.00 $10,772,000.00
$12,140,500.00 $23,322,000.00
$8,641,368.00 $14,821,553.00
should accept the contract and open the mine
"Wow! I thank you so much for your help... Its a little difficult to type and do the normal things right now with only one hand. I just had carpel tunnel surgery on my right hand and will have it on my left on Wed. Your help is GREATLY appreciated. Have a great week. P.S. I may need your assistance on a couple more things at the end of the week if thats ok. take care."
"Have Q please, Part d in the problem ask " When do critical activities need to start and finish to meet the project completion time?" And part e ask "When could the critical activities start and finish at the earliest (if no delays occur)?" You have answer both of them with the same answer. Is this possible? Thanks"
"Thank you so much. You actually did way more than i expected. THANK YOU THANKYOU THANK YOU!!!!!"
"The questions were not answered, please go back and complete. Or I request a full refund and will resubmit"
"Thank you for explaining...as I desire to understand and not simply regurgitate. Your explanations are concise; yet, clear (in laymen's terms). Again, thanks."