What is company's Sales Growth Rate (%) for current year (from above) and how compare to industry average? |
Analyze your findings in narrative below: | | | link here | link here |
narrative here |
What is the company's Gross Margin % for each year (from above) and how compare to industry average? |
Analyze your findings in narrative below: | | link here | link here | link here |
narrative here |
Which inventory costing method(s) does your company use? Include where you found this info. | |
narrative here |
Analyze the % change in Sales vs. COGS vs. Inventory. In narrative below, discuss the meaning or implications of similarities and/or differences of % change you observe for these three accounts (do they align or not, explain). |
narrative here |
Calculate Inventory Turnover and Average Days to Sell Inventory below for each year (linking to V&H schedules) and compare to industry average. Analyze your findings in narrative below. |
narrative here |
Ratio Formula (in words) | Current Year Ratio | Prior Year Ratio | Industry Ratio | | | |
COGS/Avg Inventory | link/calc | link/calc | link | | |
365/inventory turnover | link/calc | link/calc | link/calc | |
Balance Sheets: Vertical Analysis May 31, $'s in millions) Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories Other Current Assets Total Current Assets Property, Plant and Equipment, net Total Intangibles and Other Assets Total Assets 2018 $4,249 3,498 5,261 2,126 15,134 4,454 2,948 $22,536 % of Total Assets 18.85% 15.52% 23.34% 9.43% 67.15% 19.76% 13.08% 100.00% % of Total Assets 10.11% 14.51% 2017 $3,808 3,677 5,055 3,521 16,061 3,989 3,209 $23,259 % of Total Assets 16.37% 15.81% 21.73% 15.14% 69.05% 17.15% 13.80% 100.00% % of Total Assets 8.81% 12.95% 1.78% 23.53% 14.92% 8.20% 46.66% % of 2016 Total Assets $3,138 14.68% 3,241 15.16% 4,838 22.63% 3,808 17.81% 15,025 70.28% 3,520 16.46% 2,834 13.269 $21,379 100.00% % of 2016 Total Assets $2,191 10.25% 3,037 14.21% 130 0.61% 5,358 25.06% 1,9939.32% 1,770 8.28% 9,121 42.66% 2.Ft 2018 $2,279 3,269 492 6,040 3,468 3,216 12,724 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Long-Term Debt Other Noncurrent Liabilities Total Liabilities Stockholders' Equity Common Stock Additional Paid-in Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Less: Treasury Stock at cost Total Stockholders' Equity Total liabilities and Stockholders' Fauity 26.80% 15.39% 14.27% 56.46% 2017 $2,048 3,011 415 5,474 3,471 1,907 10,852 6,384 3 7,786 4,151 3,517 5,710 6,907 (213) 0.01% 28.33% 15.61% -0.41% 0.00% 43.5% 100 (92) 0.01% 24.55% 29.70% -0.92% 0.00% 53.34% 100 318 0.01% 36.42% 19.42% 1.49% 0.00% 57.34% 100 % 0 9,812 $22536 12,407 $23.259 12,258 $ 21 379 S Increase (Decrease) % Increase (Decrease) Current Year Prior Year 206 Inventory 5,261 Sales revenue 36,397 Cost of goods sold 20,441 Gross profit 15,956 Gross profit margin (%) 44%% 5,055 34,350 19,038 15,312 2,047 1,403 644 -1.00% 4.08% 5.96% 7.37% 4.21% -1.65% 45%% Balance Sheets: Vertical Analysis May 31, ($'s in millions) Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories Other Current Assets Total Current Assets Property, Plant and Equipment, net Total Intangibles and Other Assets Total Assets 2018 $4,249 3,498 5,261 2,126 15,134 4,454 2,948 $22,536 % of Total Assets 18.85% 15.52% 23.34% 9.43% 67.15% 19.76% 13.08% 100.00% % of Total Assets 10.11% 14.51% 2.FF7 26.80% 15.39% 14.27% 56.46% % of 2017 Total Assets $3,808 16.37% 3,677 15.81% 5,055 21.73% 3,521 15.14% 16,061 69.05% 3,989 17.15% 3,209 13.80% $23,259 100.00% % of 2017 Total Assets $2,048 8.81% 3,011 12.95% 4 151.78% 5,474 23.53% 3,471 14.92% 1,907 8 .20% 10,852 46.66% 2016 $3,138 3,241 4,838 3,808 15,025 3,520 2,834 $21,379 % of Total Assets 14.68% 15.16% 22.63% 17.81% 70.28% 16.46% 13.26% 100.00% % of Total Assets 10.25% 14.21% 0.61% 25.06% 9.32% 8.28% 42.66% 2018 $2,279 3,269 492 6,040 3,468 3,216 12,724 2016 $2,191 3,037 130 5,358 1,993 1,770 9,121 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Long-Term Debt Other Noncurrent Liabilities Total Liabilities Stockholders' Equity Common Stock Additional Paid-in Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Less: Treasury Stock at cost Total Stockholders' Equity Total Liabilities and Stockholders' Equity 3 6,384 3,517. (92) 0.01% 28.33% 15.61% -0.41% 0.00% 43.5% 100.0% 5,710 6,907 (213) 0.01% 24.55% 29.70% -0.92% 0.00% 53.34% 100.00% 3 7,786 4,151 318 0.01% 36.42% 19.42% 1.49% 0.00% 57.34% 100.00% 0 9,812 $22,536 12,407 $23,259 12,258 $21,379 Balance Sheets: Vertical Analysis May 31, $'s in millions) Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories Other Current Assets Total Current Assets Property, Plant and Equipment, net Total Intangibles and Other Assets Total Assets 2018 $4,249 3,498 5,261 2,126 15,134 4,454 2,948 $22,536 % of Total Assets 18.85% 15.52% 23.34% 9.43% 67.15% 19.76% 13.08% 100.00% % of Total Assets 10.11% 14.51% 2017 $3,808 3,677 5,055 3,521 16,061 3,989 3,209 $23,259 % of Total Assets 16.37% 15.81% 21.73% 15.14% 69.05% 17.15% 13.80% 100.00% % of Total Assets 8.81% 12.95% 1.78% 23.53% 14.92% 8.20% 46.66% % of 2016 Total Assets $3,138 14.68% 3,241 15.16% 4,838 22.63% 3,808 17.81% 15,025 70.28% 3,520 16.46% 2,834 13.269 $21,379 100.00% % of 2016 Total Assets $2,191 10.25% 3,037 14.21% 130 0.61% 5,358 25.06% 1,9939.32% 1,770 8.28% 9,121 42.66% 2.Ft 2018 $2,279 3,269 492 6,040 3,468 3,216 12,724 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Long-Term Debt Other Noncurrent Liabilities Total Liabilities Stockholders' Equity Common Stock Additional Paid-in Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Less: Treasury Stock at cost Total Stockholders' Equity Total liabilities and Stockholders' Fauity 26.80% 15.39% 14.27% 56.46% 2017 $2,048 3,011 415 5,474 3,471 1,907 10,852 6,384 3 7,786 4,151 3,517 5,710 6,907 (213) 0.01% 28.33% 15.61% -0.41% 0.00% 43.5% 100 (92) 0.01% 24.55% 29.70% -0.92% 0.00% 53.34% 100 318 0.01% 36.42% 19.42% 1.49% 0.00% 57.34% 100 % 0 9,812 $22536 12,407 $23.259 12,258 $ 21 379 S Increase (Decrease) % Increase (Decrease) Current Year Prior Year 206 Inventory 5,261 Sales revenue 36,397 Cost of goods sold 20,441 Gross profit 15,956 Gross profit margin (%) 44%% 5,055 34,350 19,038 15,312 2,047 1,403 644 -1.00% 4.08% 5.96% 7.37% 4.21% -1.65% 45%% Balance Sheets: Vertical Analysis May 31, ($'s in millions) Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories Other Current Assets Total Current Assets Property, Plant and Equipment, net Total Intangibles and Other Assets Total Assets 2018 $4,249 3,498 5,261 2,126 15,134 4,454 2,948 $22,536 % of Total Assets 18.85% 15.52% 23.34% 9.43% 67.15% 19.76% 13.08% 100.00% % of Total Assets 10.11% 14.51% 2.FF7 26.80% 15.39% 14.27% 56.46% % of 2017 Total Assets $3,808 16.37% 3,677 15.81% 5,055 21.73% 3,521 15.14% 16,061 69.05% 3,989 17.15% 3,209 13.80% $23,259 100.00% % of 2017 Total Assets $2,048 8.81% 3,011 12.95% 4 151.78% 5,474 23.53% 3,471 14.92% 1,907 8 .20% 10,852 46.66% 2016 $3,138 3,241 4,838 3,808 15,025 3,520 2,834 $21,379 % of Total Assets 14.68% 15.16% 22.63% 17.81% 70.28% 16.46% 13.26% 100.00% % of Total Assets 10.25% 14.21% 0.61% 25.06% 9.32% 8.28% 42.66% 2018 $2,279 3,269 492 6,040 3,468 3,216 12,724 2016 $2,191 3,037 130 5,358 1,993 1,770 9,121 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Long-Term Debt Other Noncurrent Liabilities Total Liabilities Stockholders' Equity Common Stock Additional Paid-in Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Less: Treasury Stock at cost Total Stockholders' Equity Total Liabilities and Stockholders' Equity 3 6,384 3,517. (92) 0.01% 28.33% 15.61% -0.41% 0.00% 43.5% 100.0% 5,710 6,907 (213) 0.01% 24.55% 29.70% -0.92% 0.00% 53.34% 100.00% 3 7,786 4,151 318 0.01% 36.42% 19.42% 1.49% 0.00% 57.34% 100.00% 0 9,812 $22,536 12,407 $23,259 12,258 $21,379