Please solve step by step and I need excel sheets and diagram in excel also, please..

10 companies List:

Company 1 - Name *

AEGIS LOGISTICS

Company 1 - Industry *

Oil Gas and Chemical Logistics

Company 1 - Country *

India

Company 1 - Business Activities *

Major importer and exporter of oil gas and chemicals along with other logistical services.

Company 2 - Name *

HCL Technologies

Company 2 - Industry *

Information Technology and Communications

Company 2 - Country *

India

Company 2 - Business Activities *

IT Consulting, Business process outsourcing, computer production.

Company 3 - Name *

Larsen and Toubro

Company 3 - Industry *

Construction, Energy, Automobile Production

Company 3 - Country *

India

Company 3 - Business Activities *

Buildings & Factories, Transport Infrastructure, Heavy Civil Infrastructure, Smart World & Communication, Water & Renewable Energy and Power Transmission & Distribution.

Company 4 - Name *

Sula Vineyards

Company 4 - Industry *

Hospitalty and Wine Production

Company 4 - Country *

India

Company 4 - Business Activities *

Heavily in production of indian based wines and functioning and working of vineyards in india.

Company 5 - Name *

Wells Fargo

Company 5 - Industry *

Banking and Finance

Company 5 - Country *

USA

Company 5 - Business Activities *

Checking, Savings & CDs, Credit Cards, Home Loans, Personal Loans, Auto Loans

Company 6 - Name *

Sun Pharmaceuticals Ltd

Company 6 - Industry *

Healthcare and Medicine

Company 6 - Country *

India

Company 6 - Business Activities *

Healthcare Equipment production, medicine production, vaccination supply

Company 7 - Name *

Walt Disney

Company 7 - Industry *

Entertainment

Company 7 - Country *

USA

Company 7 - Business Activities *

Entertainment , Film prodution, Recreational facilities

Company 8 - Name *

The Indian Hotels Company Ltd.

Company 8 - Industry *

Services and Hospitality

Company 8 - Country *

India

Company 8 - Business Activities *

Hotels and resort management all over india.

Company 9 - Name *

Rogers Communications Inc.

Company 9 - Industry *

Telecommunications

Company 9 - Country *

Canada

Company 9 - Business Activities *

Telecommunications.

Company 10 - Name *

Nike

Company 10 - Industry *

Sports Goods

Company 10 - Country *

USA

Company 10 - Business Activities *

Sportwears production, sports shoes and player sponsorships.

For the 10 companies you earlier chose in assignment 1 , create a " 100% stacked bar chart" (for each company) of their: - 1. Total long-term assets and total short-term assets, 2. Total long-term liabilities and total short-term liabilities, 3. Total debt and total equity 4. Total capital and total retained earnings. Write your observations in approximately 200 words. * Note that short-term assets means current assets. Similarly, short-term liabilities means current liabilities. This assignment will result into total 4 charts i.e, one chart for each of the four items mentioned above. All companies' data for an item should be stacked in a single chart. For the 10 companies you earlier chose in assignment 1 , create a " 100% stacked bar chart" (for each company) of their: - 1. Total long-term assets and total short-term assets, 2. Total long-term liabilities and total short-term liabilities, 3. Total debt and total equity 4. Total capital and total retained earnings. Write your observations in approximately 200 words. * Note that short-term assets means current assets. Similarly, short-term liabilities means current liabilities. This assignment will result into total 4 charts i.e, one chart for each of the four items mentioned above. All companies' data for an item should be stacked in a single chart