Your final assignment requires you to utilize all the material you have covered thus far. You will need to develop a model using the material provided and any additional material you might find from researching this subject (and similar subjects) elsewhere.

The final assessment requires a PowerPoint with voiceover submission (approximately 12 to 15 minutes) answering the final assessment case study explaining the process taken with supporting calculations when developing

The Tokyo Olympics

After watching "How the Tokyo Olympics Became the Most Expensive Summer Game Ever "video answer the following questions. 1. As you saw in the video, the capital investment a city must undertake to host the Olympic Games is massive. Given the costs discussed in the video, create an Excel spreadsheet to estimate the NPV and IRR of hosting the Olympic Games for the city.

2) How would the number in your Excel spreadsheet change because of the COVID-19 pandemic? Create a NPV profile for Tokyos Olympic Games given the changes that were caused by the pandemic.