{a} Calculate each scenano's Payback Period. (answers to be in excel sheet) [5 marks} {b} Calculate each scenario's Net Present Value (MPH!) {answers to be in excel sheet} .E-riefl).r discuss the result under the different scenarios. Word format with citations for each scenario} [15 marks} {c} Calculate each scenano's Protability Index (PI) [answers to be in excel sheet). Brieyr discuss the result under the different scenarios {Word format with citations for each scenario] [3 marks} [d] Critically.r evaluate the strengths and weaknesses of both the Net Present Value and Payback Period methods as a basis of evaluation for this project. {Word format with citations about iii page answer} [10 marks} {1!} The proposed new production could also be appraised with the Internal Rate of Return HER) method. Criticallyr discuss the strength and weaknesses of the IRR method. (Word format with citations about 3:4 page answer] {9 marks}