INSTRUCTIONS

For the required task, you are required to write a small reportand a Microsoft Excel file for your calculations. For the Excelcalculations, you might be needed to do a small research on how to employ the Investment appraisal functions such as NPV, IRR, MIRR And Payback period. provide your answers by writing a short report. In addition to that, you have to set an Excel template to show your calculations. it should be in Word format and an accompanying Excel file.

EQUIRED TASK Years Cashow 0 $675,000,000 1 90,000,000 135,000,000 204,000,000 235,000,000 210,000,000 164,000,000 108,000,000 86,000,000 50,000,000 KOOOQONLII-P-UJM In the table above, the cashows are provided for you. By using the gures above, please answer the following questions. Please be aware that you must write a short report to assess if you are willing to take on this project. You need to calculate NPV, IRR, MIRR and Payback Period, so your Excel le should incorporate formulas and no hardcoded numbers to calculate the abovementioned measures. You will need the following info for your preparation report: - Required Return 13% Cut off period for Payback is four years