This assessment is designed to assess your analytical skills in risk management. A case study will be given to you (unique to each student) for which you need to analyse the problem. There will be data analysis parts that need to be done in MS Excel. You are highly recommended to have enough practice with MS Excel functions to make sure you can implement the analysis. It is also required to understand concepts in order to connect them to your data analysis. To improve your knowledge and skills, you are recommended to find real-world examples to practice in advance and challenge yourself.
Please check the Attached Case study and provide me the appropriate output. The last four digits required for calculation is 0126
One single MS Excel file needs to be submitted for this assignment. In your file, you should have two different spreadsheets as below:
– One spreadsheet dedicated to Part (a) [including a report of 600 – 700 words]
– One spreadsheet dedicated to Part (b) [including your Monte Carlo Simulation and its trials]