CHAPTER 9
BULLOCK GOLD MINING
1. An example spreadsheet is:
Note, there is no Excel function to directly calculate the payback period. We used “If” statements in
our spreadsheet. The IF statement we used is:
=IF(-D8>(D9+D10+D11+D12+D13+D14),”Greater than 6 years”,IF(-
2. Since the NPV of the mine is positive, the company should open the mine. We should note, it may be
3. There are many possible variations on the VBA code to calculate the payback period. Below is a
VBA program from http://www.vbaexpress.com/kb/getarticle.php?kb_id=252.
Function PAYBACK(invest, finflow)
Dim x As Double, v As Double
Dim c As Integer, i As Integer
x = Abs(invest)
i = 1
c = finflow.Count
n