need this excel assignment done by tomorrow at 11:59. need formulas to be put in excel not just the answers Sheet1

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.

image1.png

image2.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

  Problem I                                            Manaia Manufacturing had the following operating results for 2022: sales = $32,861; cost of

  Problem I                                            Manaia Manufacturing had the following operating results for 2022: sales = $32,861; cost of goods sold = $23,795; depreciation expense = $3,817; interest expense = $565; dividends paid = $908. At the beginning of the year, net fixed assets were $21,859, current assets were $3,913, and current