1 / 2 114% + ysis Project - 2021 Spring.pdf Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation When showing all of these items you will receive as many points as possible. For example, if the current ratio is = $10,296 / $8,876 = 1.16. When the work is submitted in this manner, I can see where you may have made an error, but still provide some points. An answer showing of just 1.24, for example, you receive no points (it's incorrect and I can't see what numbers you used). An answer of $11,006 / $8,876 = 1.24 would receive partial credit (the denominator is correct, but an incorrect numerator was used). = - Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement - 1 point 5. Net profit margin - 2 points Page 12 Home Insert Draw Page Layout Formulas Data Review View Help CherOffice19 Tell what you want Calibri 11 General X Cut Copy Format Painter Clipboard & Wrap Text A. Mergo & Center Paste BTU- $ - % 0.00 Conditional Formatas Coll on 0 Formatting Table Styles Font Alignment Nurnber N4 f D F G H E 265 3,630 (24) 3,606 2.68 2.66 1,344.90 1,354.00 $ $ $ A B C 20 Income tax provision (benefit) 21 Net income 22 Net income attributable to non 23 Net income attributable to Me $ 24 Basic earnings per share $ 25 Diluted earnings per share $ 26 Basic weighted average shares 27 Diluted weighted average shar 28 29 30 31 32 33 34 35 36 K (751) 4,806 (17) 4,789 3.57 3.54 1,340.70 1,351.10 37 38 consolidated balance sheets income Ratios Ready Format Format Painter Clipboard Table Styles Styles Font Alignment Number E F G H 2020 30,117 $ 28,913 N4 A B C 2 Consolidated Statements of income 3 4 5 Fiscal Year 6 (in millions, except per share d: 2021 7 Net sales $ 8 Costs and expenses: 9 Cost of products sold 10 Research and development exp! 11 Selling, general, and administra 12 Amortization of intangible asset 13 Restructuring charges, net 14 Certain litigation charges 15 Other operating expense, net 16 Operating profit 17 Other non-operating income, ne 18 Interest expense 19 Income before income taxes 20 Income tax provision (benefit) consolidated balance sheets income 10,483 2,493 10,148 1,783 293 118 315 4,484 (336) 925 3,895 265 Ratios 9,424 2,331 10,109 1,756 118 313 71 4,791 (356) 1,092 4,055 (751) Ready Type here to search Templates Project Draw Page Layout Formats D Chemoffice Toll me what you want to do Home X Cut Copy Format Paint Colhel BIU- Wimplot A Merge Center Nlignment General - % * Conditional Format C Formatting Styles Nam Styles Insert De Font P14 f E E F M H 51,428 174 51,602 93,083 N 50,737 135 50,872 90,689 $ 5 D 40 Total shareholders' equity 41 Noncontrolling interests 42 Total equity 43 Total liabilities and equity 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 consolidated balance sheets income Ratios Type here to search O 5F Insert Draw Data Page Layout Formula Review File View Home Chemoffice19 Help Tell me what you want to do Gabari -11 9. AA A.ES Insert De Xcut Copy Paste Format Paint Clbord 15 BIU Wrap Text General Merge & Center - $ % & Conditional Formats Formatting Table Styles Number Styles Font Alig FT G H M $ $ P14 > 1 B D F 20 LIABILITIES AND EQUITY 21 Current liabilities: 22 Current debt obligations 23 Accounts payable 24 Accrued compensation 25 Accrued income taxes 26 Other accrued expenses 27 Total current liabilities 28 Long-term debt 29 Accrued compensation and retirement benefits 30 Accrued income taxes 31 Deferred tax liabilities 32 Other liabilities 33 Total liabilities 34 Commitments and contingencies (Notes 3, 16, and 18) 35 Shareholders' equity: 36 Ordinary shares- par value $0.0001, 2.6 billion shares authoriz- 37 Additional paid-in capital 38 Retained earnings 39 Accumulated other comprehensive loss consolidated balance sheets income Ratios 11 2,106 2,482 435 3,475 8,509 26,378 1,557 2,251 1,028 1,756 41,481 2.776 1,996 2,099 502 2.993 10,366 22,021 1,910 2,682 1,174 1,664 39,817 26,319 28,594 (3,485) 26,165 28,132 (3,560) Type here to search O 5F Font Alime M April 24, 2020 $ 1 PI4 A B D F G H 1 2 Consolidated Balance Sheets 3 4 5 in millions) April 30, 2021 6 ASSETS 7 Current assetst 8 Cash and cash equivalents $ 3,593 9 Investments 7,224 10 Accounts receivable, less allowances and credit losses of $241 a 5,462 11 Inventories, net 4,313 12 Other current assets 1,955 13 Total current assets 22,548 14 Property, plant, and equipment, net 5,221 15 Goodwill 41,961 16 Other intangible assets, net 17,740 17 Tax assets 3,169 18 Other assets 2,443 19 Total assets $ 93,083 20 LIABILITIES AND EQUITY consolidated balance sheets income Ratios Ready 4,140 6,808 4,645 4,229 2,209 22,031 4,828 39,841 19,063 2,832 2,094 90,689 $ Type here to search o RI 5F 1 / 2 114% + ysis Project - 2021 Spring.pdf Within the ratio tab, you need to show 3 things for each of the ratios: 1. Written formula 2. Detailed numbers for the calculation 3. Result of the calculation When showing all of these items you will receive as many points as possible. For example, if the current ratio is = $10,296 / $8,876 = 1.16. When the work is submitted in this manner, I can see where you may have made an error, but still provide some points. An answer showing of just 1.24, for example, you receive no points (it's incorrect and I can't see what numbers you used). An answer of $11,006 / $8,876 = 1.24 would receive partial credit (the denominator is correct, but an incorrect numerator was used). = - Calculations to Perform (on the most recent year): 1. Prepare a horizontal (trend) analysis for the balance sheet - 1 point 2. Prepare a horizontal (trend) analysis for the income statement - 1 point 3. Prepare a vertical (common size) analysis for the balance sheet - 1 point 4. Prepare a vertical (common size) analysis for the income statement - 1 point 5. Net profit margin - 2 points Page 12 Home Insert Draw Page Layout Formulas Data Review View Help CherOffice19 Tell what you want Calibri 11 General X Cut Copy Format Painter Clipboard & Wrap Text A. Mergo & Center Paste BTU- $ - % 0.00 Conditional Formatas Coll on 0 Formatting Table Styles Font Alignment Nurnber N4 f D F G H E 265 3,630 (24) 3,606 2.68 2.66 1,344.90 1,354.00 $ $ $ A B C 20 Income tax provision (benefit) 21 Net income 22 Net income attributable to non 23 Net income attributable to Me $ 24 Basic earnings per share $ 25 Diluted earnings per share $ 26 Basic weighted average shares 27 Diluted weighted average shar 28 29 30 31 32 33 34 35 36 K (751) 4,806 (17) 4,789 3.57 3.54 1,340.70 1,351.10 37 38 consolidated balance sheets income Ratios Ready Format Format Painter Clipboard Table Styles Styles Font Alignment Number E F G H 2020 30,117 $ 28,913 N4 A B C 2 Consolidated Statements of income 3 4 5 Fiscal Year 6 (in millions, except per share d: 2021 7 Net sales $ 8 Costs and expenses: 9 Cost of products sold 10 Research and development exp! 11 Selling, general, and administra 12 Amortization of intangible asset 13 Restructuring charges, net 14 Certain litigation charges 15 Other operating expense, net 16 Operating profit 17 Other non-operating income, ne 18 Interest expense 19 Income before income taxes 20 Income tax provision (benefit) consolidated balance sheets income 10,483 2,493 10,148 1,783 293 118 315 4,484 (336) 925 3,895 265 Ratios 9,424 2,331 10,109 1,756 118 313 71 4,791 (356) 1,092 4,055 (751) Ready Type here to search Templates Project Draw Page Layout Formats D Chemoffice Toll me what you want to do Home X Cut Copy Format Paint Colhel BIU- Wimplot A Merge Center Nlignment General - % * Conditional Format C Formatting Styles Nam Styles Insert De Font P14 f E E F M H 51,428 174 51,602 93,083 N 50,737 135 50,872 90,689 $ 5 D 40 Total shareholders' equity 41 Noncontrolling interests 42 Total equity 43 Total liabilities and equity 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 consolidated balance sheets income Ratios Type here to search O 5F Insert Draw Data Page Layout Formula Review File View Home Chemoffice19 Help Tell me what you want to do Gabari -11 9. AA A.ES Insert De Xcut Copy Paste Format Paint Clbord 15 BIU Wrap Text General Merge & Center - $ % & Conditional Formats Formatting Table Styles Number Styles Font Alig FT G H M $ $ P14 > 1 B D F 20 LIABILITIES AND EQUITY 21 Current liabilities: 22 Current debt obligations 23 Accounts payable 24 Accrued compensation 25 Accrued income taxes 26 Other accrued expenses 27 Total current liabilities 28 Long-term debt 29 Accrued compensation and retirement benefits 30 Accrued income taxes 31 Deferred tax liabilities 32 Other liabilities 33 Total liabilities 34 Commitments and contingencies (Notes 3, 16, and 18) 35 Shareholders' equity: 36 Ordinary shares- par value $0.0001, 2.6 billion shares authoriz- 37 Additional paid-in capital 38 Retained earnings 39 Accumulated other comprehensive loss consolidated balance sheets income Ratios 11 2,106 2,482 435 3,475 8,509 26,378 1,557 2,251 1,028 1,756 41,481 2.776 1,996 2,099 502 2.993 10,366 22,021 1,910 2,682 1,174 1,664 39,817 26,319 28,594 (3,485) 26,165 28,132 (3,560) Type here to search O 5F Font Alime M April 24, 2020 $ 1 PI4 A B D F G H 1 2 Consolidated Balance Sheets 3 4 5 in millions) April 30, 2021 6 ASSETS 7 Current assetst 8 Cash and cash equivalents $ 3,593 9 Investments 7,224 10 Accounts receivable, less allowances and credit losses of $241 a 5,462 11 Inventories, net 4,313 12 Other current assets 1,955 13 Total current assets 22,548 14 Property, plant, and equipment, net 5,221 15 Goodwill 41,961 16 Other intangible assets, net 17,740 17 Tax assets 3,169 18 Other assets 2,443 19 Total assets $ 93,083 20 LIABILITIES AND EQUITY consolidated balance sheets income Ratios Ready 4,140 6,808 4,645 4,229 2,209 22,031 4,828 39,841 19,063 2,832 2,094 90,689 $ Type here to search o RI 5F