Hi chegg! I'd really appreciate it if you could solve these questions accurately, and in a short time. I'll make sure to give it a thumbs up, and will definitely recommend the app to everyone. Thanks!

All you need to do is:

Using a spreadsheet, Analysis both the Income Statement and the Balance sheet of the years 2021 and 2022, Using Horizontal and Vertical Analysis for both the B/S and I/S.

For Horizontal Analysis

a) Prepare a Horizontal Analysis of the balance sheet. Calculate the increase or decrease in each account from the previous year, in both $ and %.

b) Using a spreadsheet, prepare a horizontal analysis of the income statement. Calculate the increase or decrease in each account from the previous year in both $ and %.

For Vertical Analysis

a) Prepare a Vertical Analysis of this years balance sheet and the previous years balance sheet. Calculate component % for each balance sheet account, compute as a % of total assets.

b) Using a spreadsheet, prepare a Vertical Analysis of this years income statement and the previous years income statement. Calculate component % for each income statement account, compute as a % of net sales.

Transcribed Image Text:

Annual Data | Millions of US $ except per share data 2022-12-31 2021-12-31 Cash On Hand $9.653,083 $11.362,49 Receivables $6.830,489 $7,383,727 Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEEE EEEEEEEEEE $3.440,004 $2.829,975 $1.428,682 $1.609,016 $21.352,26 $23.185,21 $2.123,004 $2 276,284 $1.816,406 $1.184,283 $7.301,448 $8.342,038 $7.381,521 $9.541,701 $23.892,49 $24.196,76 $45.244,75 $47.381,97 $13.458,69 $14.316,69 $4.476,747 $5.367,725 $781,771 $1.181,917 $9 211,626 $12.405,99 $22.670,31 $26.722,68 $259,186 $291,043 $1.448,7 $-3.001,525 $20.609,47 $23.128.42 $22.574,43 $20.659,29 $45.244,75 $47.381,97 EEE Annual Data | Millions of US $ except per share data 2022-12-31 2021-12-31 Cash On Hand $9.653,083 $11.362,49 Receivables $6.830,489 $7,383,727 Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEEE EEEEEEEEEE $3.440,004 $2.829,975 $1.428,682 $1.609,016 $21.352,26 $23.185,21 $2.123,004 $2 276,284 $1.816,406 $1.184,283 $7.301,448 $8.342,038 $7.381,521 $9.541,701 $23.892,49 $24.196,76 $45.244,75 $47.381,97 $13.458,69 $14.316,69 $4.476,747 $5.367,725 $781,771 $1.181,917 $9 211,626 $12.405,99 $22.670,31 $26.722,68 $259,186 $291,043 $1.448,7 $-3.001,525 $20.609,47 $23.128.42 $22.574,43 $20.659,29 $45.244,75 $47.381,97 EEE