Question: 2. Based on your analysis, should the company open the mine? Based on the results of payback period, IRR, MIRR and NPV, it can be

2. Based on your analysis, should the company open the mine?

2. Based on your analysis, should the company open the mine? Based on the results of payback period, IRR, MIRR and NPV, it can be said that the company show open the mine since it will be able to recover its investment in less than 5 years, with a IRR of 13. and a MIRR of 12.51% which are greater than the 12 percent of required return of capital for the investment plus a positive NPV of $28,451,509.51. 3. Bonus question: Most spreadsheets do not have a bult-In formula to calculate the payback pe Write a VBA script that calculates the payback perlod for a project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Can someone see if I answered all the questions correctly, please 5) Use the information in Chapter 8 Case of your textbook to calculate the payback, IRR, NPV. Based on your analysis should the...

5) Use the information in Chapter 8 Case of your textbook to calculate the payback, IRR, NPV. Based on your analysis should the company open the mine? Chapter 8 Case Study: Bullock Gold Mining Seth...

Construct SPREADSHEET!!! Make sure that I can review your tomvulas in excel. Thank You NPN Dazision Explinin your detision MIRR|Modified IRR| Detision Explain your declsion Paylaack Dazision Explain...

Question #1 Consider the following potential investment, which has the same risk as the firm?s other projects: Time Cash Flow 0 -$95,000 1 $20,000 2 $24,000 3 $24,000 4 $24,000 5 $24,000 6 $32,000 a)...

Alligator Clothing Company Balance Sheet December 31, 2014 and December 31, 2015 2014 2015 Assets Current Assets Cash $120,000,000 $88,000,000 Accounts Receivable $224,000,000 $192,000,000 Inventory...

Assignments to complete this module: Reading: Chapter 11: Project Analysis and Evaluation Submit Course Learning Assessment #1 by Sunday at 11:59 p.m Course Learning Assessment #1 CLO #1 - Recall...

Fundamentals of Financial Management, Chapter 12 The Bigbee Bottling Company is considering the replacement of one of its bottling machines with a newer and more efficient one. The old machine has a...

Question 1 Start with the partial model in the attached. The stock of Matrix Computing sells for $65, and last year's dividend was $2.53. Security analysts are projecting that the common dividend...

1. Assuming that the variable cost per ton is the most important influencing factor, use the variable cost as the variable factor in the Sensitive Analysis, and try to calculate the NPV when the...

What is a computer virus.

Two large diversified consumer product firms X and Y are about to enter the market for a new chemical agent, with very similar products. The two firms are also similar in strategic approach and as no...

Find a power series representation for the function. ( Give your powerkerles representation centered at x = 0 . ) f ( x ) = 3 1 - x 2 ) Determine the interval of tenuergence. ( Inter your answer...

On April 15, 2011, the board of directors for Auction.com declared a cash dividend of 65 cents per share payable to stockholders of record on May 20. The dividends will be paid on June 14. The...

On April 15 of this year, the board of directors for Jedi Company declared a cash dividnd of 65 cents per share payable to stockholders of record on May 20. The dividends will be paid on June14. The...

Carbide Corporation purchased 20,000 shares of its own stock for $45 per share. The next year, the company sold 5,000 shares for $50 per share and the following year, it sold 10,000 shares for $37...

To expand operations, Aragon Consulting issued 170,000 shares of previously unissued stock with a par value of $1. The selling price for the stock was $21 per share. Record the sale of this stock....

Dick Hammaker has been fascinated with Corvette cars, especially convertibles, since he was a teenager. Dick grew up in Michigan and worked part-time through his high school and college years at a...

What is the difference between X . 5 0 9 and PGP certificate types?

7. Give examples of the following when you formulate a social problem or phenomenon: a) When you generalize from reality. b) When you choose something from social reality and do not choose some-thing...

5. Give examples of binary thinking.

2. In this chapter, the reader should reflect on the following concepts: Social facts, concrete fallacy, constructs, overestimation error.