using this video https://www.youtube.com/watch?v=7PM4sYl3dsI&t=74s how would i anwser these questions 3 and 4

A F . CGE ... W- BUS 325 YourPace Final Assessment Guide - Last Modified: 57m ago v Q Search (Cmd + Ctrl + U) Home Insert Draw Design Layout References Mailings Review View Comments Editing Share Cambria * 11 ~ A" A | Aa | Ap AaBbCcDdEe AaBbCcDdEe AaBbCcDi AaBbCcDdl AaBbCcDdl Paste BIUvab X x |A DAY Norma No Spacing Heading 1 Heading 2 Heading 3 Styles Dictate Add-ins Editor Pane The Tokyo Olympics After watching How the Tokyo Olympics Became the Most Expensive Summer Game Ever video answer the following questions. 3. 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 and Excel spreadsheet to estimate the NPV and IRR of hosting the Olympic Games for the city 4. How would the number in your Excel spreadsheet change because of the COVID-19 pandemic? Create a NPV profile for Tokyo's Olympic Games given the changes that were caused by the pandemic. Check Before Submission: Before submitting, double-check, have you have met the criteria noted below. Did you.... Identify correct calculations and formulas for the NPV & IRR Include the logical answers for each question. V Utilize the financial formulas application in your Excel spreadsheet. Implement course materials and research materials to support your formulas. Check for accuracy in composition, APA format, and meeting the guidelines as delineated step 2. Make certain you are well practiced and articulate materials in a professional manner, (limit ums, like's and other communication flaws). Additional Resource Below are additional resources to aid you in the development of your product or service plan. > Using APA when referencing: https://www.youtube.com/watch?v=f7vhZVIIND8 > Using Excel to calculate NPV and IRR: https:/www.youtube.com/watch?v=IWY3abc4hzo Submit your Work . Your completed final assessment documents should be submitted through the Final Assessment link of your competency. . Please note, that you can upload multiple files to the Final Assignment link. . Make sure the files are converted to a doc, docx, ppt, pptx file. (you can share Google Doc and MS OneDrive documents from Page 3 of 5 962 words |English (United States) to Accessibility: Investigate Focus GOE - - + 100%