A. Based on the above, construct a spreadsheet to calculate the Net Present Value, internal rate of return, the payback period and the disocunted payback period (Assume a cut off of 5 years for the...

A. Based on the above, construct a spreadsheet to calculate the Net Present Value, internal rate of return, the payback period and the disocunted payback period (Assume a cut off of 5 years for the payback and disocunted payback period).

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

Please use the excel template to answer the case. Note one sheet contains the Case and the other is for you to fill out and answer. PLEASE upload this in connect and do NOT email it to me. Please contact connect if you encounter issues submitting.