29/08/2011 · Bullock gold mining case study, need to write a VBA script that calculates the payback period for project. ... IRR, PI, and MIRR on the spreadsheet and I can manually calculate the payback period. what i needis " to create is a VBA script so that the spreadsheet calculates the payback period." If you provided then I dont understand the answer ...