Homework help

Controlling - Evaluation

Please

1. Get the last 2 annual financial statement and discuss profitability

trends (sales, gross profit, net profit). Include a copy of each page

used in an appendix.

2. Calculate 3 liquidity ratios, Debt to Equity Ratio, GP Ratio, and

Net Profit ratio for three consecutive years, show graphically and discuss trends and insights.

Fiscal year is June-May. All values USD Millions. 2019 2018 2017 2016 2015 5-year trend Sales/Revenue 39,122 36,363 34,254 32,464 30,696 Sales Growth 7.59% 6.16% 5.51% 5.76% Cost of Goods Sold (COGS) incl. D&A 21,696 20,351 19,377 17,991 16,754 COGS excluding D&A 20,991 19,604 18,671 17,342 16,148 Depreciation & Amortization Expense 705 747 706 649 606 Depreciation 705 747 706 649 606 COGS Growth 6.61% 5.03% 7.70% 7.38% Gross Income 17,426 16,012 14,877 14,473 13,942 Gross Income Growth 8.83% 7.63% 2.79% 3.81% Gross Profit Margin 44.54% SG&A Expense 12,702 11,512 10,563 10,469 9,892Other SG&A 12,702 11,512 10,563 10,469 9.892 SGA Growth 10.34% 8.98% 0.90% 5.83% EBIT 4,724 4,500 4,050 Unusual Expense (173) 61 46 68 (615) Non Operating Income/Expense (54) (67) 673 708 (427) Non-Operating Interest Income 82 70 27 12 6 Interest Expense 124 117 82 33 39 Interest Expense Growth 5.98% 42.68% 148.48% -15.38% Gross Interest Expense 124 117 82 33 39 Pretax Income 4,801 4,325 4,886 4,623 4,205 Pretax Income Growth 11.01% -11.48% 5.69% 9.94% Pretax Margin 12.27%Income Tax 772 2,392 646 863 932 Income Tax - Current Domestic 130 1,212 180 375 676 Income Tax - Current Foreign 608 533 439 568 369 Income Tax - Deferred Domestic (42) 620 (288) (73) (77) Income Tax - Deferred Foreign 76 27 15 (7) (36) Consolidated Net Income 4,029 1,933 4,240 3,760 3,273 Net Income 4,029 1.933 4.240 3,760 3,273 Net Income Growth 108.43% -54.41% 12.77% 14.88% Net Margin 10.30% Net Income After Extraordinaries 4,029 1,933 4,240 3,760 3,273 Net Income Available to Common 4.029 1,933 4,240 3,760 3,273 EPS (Basic) 2.49 1.17 2.51 2.16 1.85\f