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.

 

Transcribed Image Text:

REQUIRED TASK Years Cashflow 0 $675,000,000 1 90,000,000 2 135,000,000 3 204,000,000 4 235,000,000 5 210,000,000 6 164,000,000 7 108,000,000 8 86,000,000 - 50,000,000 9 In the table above, the cashflows are provided for you. By using the figures 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 file 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 REQUIRED TASK Years Cashflow 0 $675,000,000 1 90,000,000 2 135,000,000 3 204,000,000 4 235,000,000 5 210,000,000 6 164,000,000 7 108,000,000 8 86,000,000 - 50,000,000 9 In the table above, the cashflows are provided for you. By using the figures 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 file 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