Given the CAPE CHEMICAL: CAPITAL BUDGETING ISSUES study I need help with the computations $of$ study question #$5.$ Calculate the Cash Payback Period, Discounted Cash Payback Period, $NPV,$ IRR and MIRR

for each alternative. For these calculations, assume a WACC $of15\%.$ Based strictly $on$ the

results $of$ these methods, should either option $be$ selected? Why? Solution requires

preparation $of$ a spreadsheet.