write my assignment 3273

5. Calculate the Cash Payback Period, Discounted Cash Payback Period, NPV, IRR and MIRR for each alternative. For the calculations, assume a WACC of 15%. Based on the results of these methods, should either option be selected? Why? Solution requires preparation of a spreadsheet.

6. Stewart is concerned that the projected annual sales growth rate of 15% for incremental blended material may be optimistic. Recalculate the Cash Payback Period, Discounted Cash Payback Period, NPV, IRR and MIRR for each alternative assuming the annual sales growth rates of 10% and 5%. Assume a WACC of 15%. Does the change in growth rate alter the recommendation made in question 5? Solution requires preparation of spreadsheets.