Calculate an index of multinationality based upon the geographical distribution of sales revenue and noncurrent assets

Sheet1
Porsche and Mercedes-Benz, both based in Germany, are two of the largest automobile manufacturers in the world. The following information was provided in each company’s 2019 annual report.
Porsche 2019 Annual report Mercedes-Benz 2019 Annual Report
* In millions of euros * In millions of euros
Required:
Calculate an index of multinationality based upon the geographical distribution of sales revenue and noncurrent assets (employee information is not available) to determine which of these two companies is more multinational.
Use the above 2019 data and complete the 2019 Annual Report with multinational Index (MNI) for each company. The detail calculation must be provided. The MNI only will not receive credit for the assignment.