[URGENT] Explain which component of the ratio caused the change and why (i.e., Debt increased, net income decreased, COGS decreased, etc.)
TO EXPERTS, PLZ EXPLAIN AS MANY AS POSSIBLE. EVEN ANYTHING! THIS IS THE ALL THE INFO I GOT!
=(D26-D27)/D26 D E F 1 2 3 4 5 6 7 8 2018 11.04% 0.97% 0.001% 0.30% 0.002% 0.31% 1.02 1.08 $363.00 0.16 0.95 9 10 11 B [COMPANY NAME] FROM 2018-2019 CALCULATION INC/DEC (+/-) (Sales Rev-Cost of Goods sold)/Sales Revenue decreased (Sales Rev-operating expenses)/sales revenue decreased Profits>taxes/sales revenue constant (profits>taxes+interest)/total assets increased Profits>taxes/total assets constant Profitys>taxes/total stockholders equity increased Current Assets/Current Liabilities decreased (Current Assets-Inventory)/Current Liability decreased Current Assets-Current Liabilities decreased Total debt/total assets decreased long term debt/(long term debt+stockholders equity) constant total debt/total stoickholders equity increased long term debt/total stockholders equity increased Operating income/interests expense decreased Inventory/(cost of goods sold/365) increased Cost of goods sold/inventory decreased Accounts receivable/(total sales/365) decreased annual dividends per share/current market price per share constant current market price per share/earnings per share increased annual dividends per share/earnings per share constant after tax profits+depreciation decreased after tax profits+depreciation-Capital Expenditures-dividends increased 12 2019 11.02% 0.93% 0.001% 0.39% 0.002% 0.40% 1.01 1,03 $248.00 0.15 0.95 27.74 20.74 -31.58 -1.47 -247.92 3.67 0.01 346.40 3.75 $2,553.00 $187.00 G $ THOUSANDS 2017 INDUSTRY (2018) Apparel, Footwear, Accesories 11.33% 1.00% 0.001% 0.17% 0.003% 0.21% 0.99 1.04 $178.00 0.18 0.93 14.08 13.90 -30.68 -2.92 -125.15 4.05 0.06 315.74 17.80 $2,695.00 -$23,112.00 13 14 15 16 17 18 19 20.54 20.15 -28.18 -3.89 -93.79 4.30 0.01 321.28 3.75 $2,700.00 $421.00 20 21 22 23 24 26 27 28 29 30 31 32 33 34 35 36 37 sales revenue cost of goods sold operating expenses taxes profits > taxes total stockholders equity long term debt current assets current liabilities total debt total assets operating income interest income accounts receiveables annual dividends per share current market price per share (9/18/17) earnings per share depreciation capital expenditures dividends shares Total sales Inventory $ 149,351 $ 138,434 $ $ 132,886 $ 123,152 $ $ 147,966 $ 137,096 $ 1,061 $ 1,263 $ TRUE TRUE $ 247 $ 322 $ $ 5,124 $ 6,487 $ $ 23,485 $ 20,289 $ $ 23,237 $ 19,926 $ $ 6,852 $ 6,613 $ $ 45,400 $ 40,830 $ $ 4,737 $ 4,480 $ $ 178 $ 121 $ 1,535 $ 1,669 $ $ 2.44 $ 2.14 $ $ 225.16 $ 183.13 $ $ 0.65 $ 0.57 $ 1,492 $ 1,437 $ $ 3,404 $ 3,810 $ $ (1,038) $ (689) $ $ 1,097 $ 1,756 $ $ 152,703 $ 141,576 $ $ (536) $ (1,313) $ 126,172 111,882 124,914 1,325 TRUE 473 6,573 17,317 17,495 6,659 36,347 4,111 62 1,432 8.90 157.87 0.50 1,370 29,711 (3,904) 2,998 129,025 (894) 38 39 40 41 42 43 44 45 46 47 48 49 1 $ THOUSANDS 2019-12 2018-12 2 2017-12 3 4 5 6 4,546 1,233 7 8,384 $ 1,060 $ 1,535 $ 11,395 $ 6,055 $ 1,204 $ 1,669 $ 11,040 $ 8 1,432 9 9,834 10 11 1,111 23,485 $ $ 321 $ 20,289 $ 272 17,317 12 13 COMPANY NAME) BALANCE SHEET Fiscal year ends in December. USD in thousands except per share data Assets: Current assets: Cash Cash and cash equivalents $ Total cash $ Receivables $ Inventories $ Deferred income taxes Prepaid expenses $ Total current assets $ Non-current assets: Property, plant and equipment: Gross property, plant and equipment $ Accumulated Depreciation $ Net property, plant and equipment $ Goodwill Intangible assets Deferred income taxes Other long-term assets $ Total non-current assets Total assets $ Liabilities and stockholders' equity Liabilities Current liabilities 14 15 16 32,626 $ (11,736) $ 20,890 $ 30,714 $ (11,033) $ 19,681 $ 28,341 (10,180) 18,161 17 18 19 20 21 1,025 $ 860 $ 869 22 23 45,400 $ 40,830 $ 36,347 24 25 26 27 28 29 $ $ $ $ $ 3,410 $ 11,679 $ 4,356 $ 3,792 $ 23,237 $ 1,714 $ 11,237 $ 4,051 $ 2,924 $ 19,926 $ 1,498 9,608 3,664 2,725 17,495 30 31 32 33 $ $ 5,124 $ 1,455 $ 6,487 $ 1,314 $ 6,573 1,200 34 35 Short-term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities: Long-term debt Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity: Common stock Additional paid-in capital Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 36 $ 29,816 $ 27,727 $ 25,268 37 38 39 40 $ $ $ $ $ $ 4 $ 6,417 $ 10,258 $ (1,436) $ 15,243 $ 45,400 $ 4 $ 6,107 $ 7,887 $ (1,199) $ 12,799 $ 40,830 $ 4 5,800 5,988 (1,014) 10,778 36,347 41 42 43 44 B D E 1 2 3 $ THOUSANDS 2019-12 2018-12 2017-12 $ 152,703 $ 141,576 $ 129,025 $ 132,886 $ 123,152 $ 111,882 $ 19,817 $ 18,424 $ 17,143 4 5 6 7 8 9 $ 14,994 $ 13,876 $ 12,950 $ 86 $ 68 $ 82 $ 132,886 $ 123,152 $ 111,882 $ 147,966 $ 137,096 $ 124,914 $ 4,737 $ 4,480 $ 4,111 10 11 12 13 COSTCO INCOME STATEMENT Fiscal year ends in August. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Restructuring, merger and acquisition Other operating expenses Total operating expenses Operating income Other Income (expense) Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income Preferred dividend Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA (134) 62 14 $ $ $ $ (150) $ 178 $ 4,765 $ 1,061 $ (159) $ 121 $ 4,442 $ 1,263 $ 15 4,039 16 1,325 17 19 $ $ $ 3,704 $ (45) $ 3,659 $ 3,179 $ (45) $ 3,134 $ 2,714 (35) 2,679 20 21 22 $ $ 8.42 $ 8.36 $ 7.24 $ 7.19 $ 6.20 6.15 23 24 25 26 439,755 442,923 6,107 $ 438,515 441,834 5,720 $ 438,437 440,937 5,275 27 $ 28 A B D E 1 $ THOUSANDS 2019-12 2018-12 2 2017-12 3 4 $ $ 3,704 $ 1,492 $ 3,179 $ 1,437 $ 2,714 1,370 5 6 7 8 $ $ 147 $ 595 $ (49) $ 544 $ (29) 514 9 10 11 12 $ (536) $ (1,313) $ (894) 13 COSTCO Statement of CASH FLOW (Fiscal year ends in August. USD in millions except per share data.) Cash Flows From Operating Activities Net income Depreciation & amortization Amortization of debt discount/premium and issuance costs Investment/asset impairment charges Deferred income taxes Stock based compensation Change in working capital Accounts receivable Inventory Prepaid expenses Accounts payable Accrued liabilities Other working capital Other non-cash items Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Acquisitions, net Purchases of investments Sales/Maturities of investments Other investing activities Net cash used for investing activities Cash Flows From Financing Activities 14 $ 322 $ 1,561 $ 2,258 15 16 $ $ $ 17 623 $ 9 $ 6,356 $ 421 $ (6) $ 5,774 $ 807 (14) 18 6,726 19 20 $ (2,998) $ (2,969) $ (2,502) 21 22 23 $ $ $ $ (1,094) $ 1,231 $ (4) $ (2,865) $ (1,060) $ 1,078 $ 4 $ (2,947) $ (1,279) 1,385 30 (2,366) 24 25 26 27 28 29 30 31 $ $ $ $ $ $ $ $ $ $ Debt issued Debt repayment Excess tax benefit from stock based compensation Dividend paid Other financing activities Net cash provided by (used for) financing activities Effect of exchange rate changes Net change in cash Cash at beginning of period Cash at end of period Free Cash Flow Operating cash flow Capital expenditure Free cash flow 298 $ (89) $ (272) $ (1,038) $ (46) $ (1,147) $ (15) $ 2,329 $ 6,055 $ 8,384 $ $ (86) $ (217) $ (689) $ (289) $ (1,281) $ (37) $ 1,509 $ 4,546 $ 6,055 $ 3,782 (2,200) (164) (3,904) (732) (3,218) 25 1,167 3,379 4,546 32 33 34 35 36 37 38 39 $ $ $ 5,049 $ 3,404 $ 1,645 $ 4,665 $ 4,113 3,810 $ 29,711 855 $ (25,598) 40 41 =(D26-D27)/D26 D E F 1 2 3 4 5 6 7 8 2018 11.04% 0.97% 0.001% 0.30% 0.002% 0.31% 1.02 1.08 $363.00 0.16 0.95 9 10 11 B [COMPANY NAME] FROM 2018-2019 CALCULATION INC/DEC (+/-) (Sales Rev-Cost of Goods sold)/Sales Revenue decreased (Sales Rev-operating expenses)/sales revenue decreased Profits>taxes/sales revenue constant (profits>taxes+interest)/total assets increased Profits>taxes/total assets constant Profitys>taxes/total stockholders equity increased Current Assets/Current Liabilities decreased (Current Assets-Inventory)/Current Liability decreased Current Assets-Current Liabilities decreased Total debt/total assets decreased long term debt/(long term debt+stockholders equity) constant total debt/total stoickholders equity increased long term debt/total stockholders equity increased Operating income/interests expense decreased Inventory/(cost of goods sold/365) increased Cost of goods sold/inventory decreased Accounts receivable/(total sales/365) decreased annual dividends per share/current market price per share constant current market price per share/earnings per share increased annual dividends per share/earnings per share constant after tax profits+depreciation decreased after tax profits+depreciation-Capital Expenditures-dividends increased 12 2019 11.02% 0.93% 0.001% 0.39% 0.002% 0.40% 1.01 1,03 $248.00 0.15 0.95 27.74 20.74 -31.58 -1.47 -247.92 3.67 0.01 346.40 3.75 $2,553.00 $187.00 G $ THOUSANDS 2017 INDUSTRY (2018) Apparel, Footwear, Accesories 11.33% 1.00% 0.001% 0.17% 0.003% 0.21% 0.99 1.04 $178.00 0.18 0.93 14.08 13.90 -30.68 -2.92 -125.15 4.05 0.06 315.74 17.80 $2,695.00 -$23,112.00 13 14 15 16 17 18 19 20.54 20.15 -28.18 -3.89 -93.79 4.30 0.01 321.28 3.75 $2,700.00 $421.00 20 21 22 23 24 26 27 28 29 30 31 32 33 34 35 36 37 sales revenue cost of goods sold operating expenses taxes profits > taxes total stockholders equity long term debt current assets current liabilities total debt total assets operating income interest income accounts receiveables annual dividends per share current market price per share (9/18/17) earnings per share depreciation capital expenditures dividends shares Total sales Inventory $ 149,351 $ 138,434 $ $ 132,886 $ 123,152 $ $ 147,966 $ 137,096 $ 1,061 $ 1,263 $ TRUE TRUE $ 247 $ 322 $ $ 5,124 $ 6,487 $ $ 23,485 $ 20,289 $ $ 23,237 $ 19,926 $ $ 6,852 $ 6,613 $ $ 45,400 $ 40,830 $ $ 4,737 $ 4,480 $ $ 178 $ 121 $ 1,535 $ 1,669 $ $ 2.44 $ 2.14 $ $ 225.16 $ 183.13 $ $ 0.65 $ 0.57 $ 1,492 $ 1,437 $ $ 3,404 $ 3,810 $ $ (1,038) $ (689) $ $ 1,097 $ 1,756 $ $ 152,703 $ 141,576 $ $ (536) $ (1,313) $ 126,172 111,882 124,914 1,325 TRUE 473 6,573 17,317 17,495 6,659 36,347 4,111 62 1,432 8.90 157.87 0.50 1,370 29,711 (3,904) 2,998 129,025 (894) 38 39 40 41 42 43 44 45 46 47 48 49 1 $ THOUSANDS 2019-12 2018-12 2 2017-12 3 4 5 6 4,546 1,233 7 8,384 $ 1,060 $ 1,535 $ 11,395 $ 6,055 $ 1,204 $ 1,669 $ 11,040 $ 8 1,432 9 9,834 10 11 1,111 23,485 $ $ 321 $ 20,289 $ 272 17,317 12 13 COMPANY NAME) BALANCE SHEET Fiscal year ends in December. USD in thousands except per share data Assets: Current assets: Cash Cash and cash equivalents $ Total cash $ Receivables $ Inventories $ Deferred income taxes Prepaid expenses $ Total current assets $ Non-current assets: Property, plant and equipment: Gross property, plant and equipment $ Accumulated Depreciation $ Net property, plant and equipment $ Goodwill Intangible assets Deferred income taxes Other long-term assets $ Total non-current assets Total assets $ Liabilities and stockholders' equity Liabilities Current liabilities 14 15 16 32,626 $ (11,736) $ 20,890 $ 30,714 $ (11,033) $ 19,681 $ 28,341 (10,180) 18,161 17 18 19 20 21 1,025 $ 860 $ 869 22 23 45,400 $ 40,830 $ 36,347 24 25 26 27 28 29 $ $ $ $ $ 3,410 $ 11,679 $ 4,356 $ 3,792 $ 23,237 $ 1,714 $ 11,237 $ 4,051 $ 2,924 $ 19,926 $ 1,498 9,608 3,664 2,725 17,495 30 31 32 33 $ $ 5,124 $ 1,455 $ 6,487 $ 1,314 $ 6,573 1,200 34 35 Short-term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities: Long-term debt Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity: Common stock Additional paid-in capital Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 36 $ 29,816 $ 27,727 $ 25,268 37 38 39 40 $ $ $ $ $ $ 4 $ 6,417 $ 10,258 $ (1,436) $ 15,243 $ 45,400 $ 4 $ 6,107 $ 7,887 $ (1,199) $ 12,799 $ 40,830 $ 4 5,800 5,988 (1,014) 10,778 36,347 41 42 43 44 B D E 1 2 3 $ THOUSANDS 2019-12 2018-12 2017-12 $ 152,703 $ 141,576 $ 129,025 $ 132,886 $ 123,152 $ 111,882 $ 19,817 $ 18,424 $ 17,143 4 5 6 7 8 9 $ 14,994 $ 13,876 $ 12,950 $ 86 $ 68 $ 82 $ 132,886 $ 123,152 $ 111,882 $ 147,966 $ 137,096 $ 124,914 $ 4,737 $ 4,480 $ 4,111 10 11 12 13 COSTCO INCOME STATEMENT Fiscal year ends in August. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Restructuring, merger and acquisition Other operating expenses Total operating expenses Operating income Other Income (expense) Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income Preferred dividend Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA (134) 62 14 $ $ $ $ (150) $ 178 $ 4,765 $ 1,061 $ (159) $ 121 $ 4,442 $ 1,263 $ 15 4,039 16 1,325 17 19 $ $ $ 3,704 $ (45) $ 3,659 $ 3,179 $ (45) $ 3,134 $ 2,714 (35) 2,679 20 21 22 $ $ 8.42 $ 8.36 $ 7.24 $ 7.19 $ 6.20 6.15 23 24 25 26 439,755 442,923 6,107 $ 438,515 441,834 5,720 $ 438,437 440,937 5,275 27 $ 28 A B D E 1 $ THOUSANDS 2019-12 2018-12 2 2017-12 3 4 $ $ 3,704 $ 1,492 $ 3,179 $ 1,437 $ 2,714 1,370 5 6 7 8 $ $ 147 $ 595 $ (49) $ 544 $ (29) 514 9 10 11 12 $ (536) $ (1,313) $ (894) 13 COSTCO Statement of CASH FLOW (Fiscal year ends in August. USD in millions except per share data.) Cash Flows From Operating Activities Net income Depreciation & amortization Amortization of debt discount/premium and issuance costs Investment/asset impairment charges Deferred income taxes Stock based compensation Change in working capital Accounts receivable Inventory Prepaid expenses Accounts payable Accrued liabilities Other working capital Other non-cash items Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Acquisitions, net Purchases of investments Sales/Maturities of investments Other investing activities Net cash used for investing activities Cash Flows From Financing Activities 14 $ 322 $ 1,561 $ 2,258 15 16 $ $ $ 17 623 $ 9 $ 6,356 $ 421 $ (6) $ 5,774 $ 807 (14) 18 6,726 19 20 $ (2,998) $ (2,969) $ (2,502) 21 22 23 $ $ $ $ (1,094) $ 1,231 $ (4) $ (2,865) $ (1,060) $ 1,078 $ 4 $ (2,947) $ (1,279) 1,385 30 (2,366) 24 25 26 27 28 29 30 31 $ $ $ $ $ $ $ $ $ $ Debt issued Debt repayment Excess tax benefit from stock based compensation Dividend paid Other financing activities Net cash provided by (used for) financing activities Effect of exchange rate changes Net change in cash Cash at beginning of period Cash at end of period Free Cash Flow Operating cash flow Capital expenditure Free cash flow 298 $ (89) $ (272) $ (1,038) $ (46) $ (1,147) $ (15) $ 2,329 $ 6,055 $ 8,384 $ $ (86) $ (217) $ (689) $ (289) $ (1,281) $ (37) $ 1,509 $ 4,546 $ 6,055 $ 3,782 (2,200) (164) (3,904) (732) (3,218) 25 1,167 3,379 4,546 32 33 34 35 36 37 38 39 $ $ $ 5,049 $ 3,404 $ 1,645 $ 4,665 $ 4,113 3,810 $ 29,711 855 $ (25,598) 40 41
