The expected cash flows each year from the mine are shown in the table on this page. Bullock Mining has a 12 percent required return on all of its gold mines. Year Cash Flow QUESTIONS 1.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. 2.