need this excel assignment done by tomorrow at 11:59. need formulas to be put in excel not just the answers
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. | ||||||||