Please answer all three questions from chapter 8 case: Bullock Gold Mining. from essential of corporate finance.
1) Constructed a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposed mine.
2) Based on your analysis, should the company open the mine?
3) Most spreadsheet do not have a built-in formula to calculate the payback period. Write VBA scripts that calculate the payback period for a project.