EC7 Bluffs Mining Company Net Present Value Analysis hi! having some trouble with this net present value problem.. would love some help! If you could put t

EC7 Bluffs Mining Company Net Present Value Analysis hi! having some trouble with this net present value problem.. would love some help! If you could put the solution in an Excel sheet that would be great! Thank you! EC7 – Capital Budget
“All of the engineering studies say that tar sand is excellent for use in road construction,” said Heather Jenkins,
chief engineer for Bluffs Mining Company. “With road construction projected to be at peak levels over the
next 10 years, now is the time for us to extract and sell the tar sand off of tract 370 in the southern part of
the state.”
“I’m not so sure,” replied Leo Lyon, the vice president. “Prices are really soft for tar sand. The best we can
hope to get is $7 a ton, and the accounting people say it will cost us at least $3 a ton for utilities, supplies. and
selling expenses. That doesn’t leave much in the way of contribution margin.”
“I know we won’t get much per ton,” replied Heather, “but our studies show that we have 1,735,000 tons of tar
sand in the area. I figure we can extract 90,000, 145,000, and 240,000 tons the first three years, respectively, and
then the remainder evenly over the next seven years. Even at only $7 a ton, that’ll bring a lot of cash flow into the
company.”
“But you’re forgetting that we have other costs, too,” said Leo. “Fixed costs for salaries, insurance, and so
forth, directly associated with the tar sand project would be $450,000 a year. Besides that, we would have to
pay out an additional $250,000 at the end of the project for filling and leveling the land. You know how tough
those environmental people can get if things don’t look right. And all of this doesn’t even consider the
$800,000 cost of special equipment that we would need or the $75,000 we would have to put up for working
capital to carry inventories and accounts receivable. I’m uneasy about the whole idea.”
“You’ve got to look at the big picture, Leo. You’ll get the working capital back in 10 years when the project is
completed. In addition, we can depreciate that equipment and save a bundle in taxes at our 30% tax rate.
Besides that, since the equipment would have a 12-year useful life, it would still have some use left when the
project was completed. I’m sure we could sell it to someone for at least 5% of its original cost.”
“All of that sounds fine, Heather, but I’ll still bet the project won’t provide the 18% after-tax return we
require. Let’s give all this to accounting and have them do a present value analysis for us.”
Required
1. Compute the before-tax net cash receipts each year from the extraction and sale of the tar
sand. (Do not include the cost of filling and leveling the land in this computation.)
2. Using the data from (1) above and other data from the problem as needed, prepare a net
present value analysis to determine whether the company should purchase the equipment
and extract the tar sand. Round all dollar amounts to the nearest whole dollar.
You may assume that the company as a whole will have a positive taxable income in
every year so that a tax benefit would be realized from any operating losses associated
with the tar sand project. Also assume that the special equipment belongs in the MACRS
seven-year property class.
NOTE – In order to receive credit for this problem, both parts must be completed. All computations must be
shown. The net present value analysis must be shown in the same format as demonstrated in class.

Purchase answer to see full
attachment