alculate the payback period, internal rate of return, modified internal rate of return,

Boondock Silver Mining
Beth Boondock, owner of Boondock Silver Mining, is reviewing the details of a new silver mine in South Dakota. According to the company’s geologist, Dory Donovan, a detailed analysis of the mine suggests it would be productive for eight years. After that amount of time, all of the silver ore would be completely mined. Dory sent an estimate of the silver deposits to Gina Albert, the company’s chief financial officer. Beth has contacted Gina to request a full financial analysis of the new mine and to present her recommendations on whether the company should open the new mine.
Gina used the estimates provided by Dory to determine the revenues that could be expected from the mine. She has projected both the annual operating expenses of the new mine and the expense of opening the mine. If the company opens the mine, it will cost $635 million today, and it will have a cash outflow of $45 million nine years from today in costs associated with closing the mine and reclaiming the surrounding area. The expected cash flows each year each year from the mine are shown below:
Year Cash Flow
0 – $635,000,000
1 89,000,000
2 105,000,000
3 130,000,000
4 173,000,000
5 205,000,000
6 155,000,000
7 145,000,000
8 122,000,000
9 – 45,000,000
Questions:
Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposed mine.
Based on your analysis, should the company open the mine? Why or why not?

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.