Submit a ratio analysis for your company for the years 2019,2020, and 2021
COST Financial Data xisx (13,2KB) REVENUE Total revenue \begin{tabular}{|lllll} $226,954 & $195,929 & $166,761 & $152,703 & $141,576 \end{tabular} OPERATING EXPENSES Merchandise costs Seling, general and administrative Operating income OTHER INCOME (EXPENSE) Interest expense lnterest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests NET INCONE ATTRIBUTABLE TO COSTCO 199,38219,7797,793(158)2057,8401,9255,915(71)$5,844170,68418,5376,708(171)1436,6801,6015,079(72)55,007144,93916,3875,435(160)925,3671,3084,059(57)54,002132,83614,994864,737(150)1784,7651,0613,704(45)53,659123,15213,876654,480(159)1214,4421,2633,179(45)53,134 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Alasic (in dollars per share) Diluted (in dollars per share) Shares used in calculation (000 's) Basic (shares) Diluted (shares) $13,17$13.14443,651444,757$11,30$11.27443,089444,346$9.05$9.02442,297443,901$8.32$8.26439,755442,923$7.15$7.09436,515441,334 Net sales RIVENUE Total revenue Membership fees REVENUE Total revenue 1 Consolidat 2 CURRENT ASSETS 3 Cash and cash equivalents 4 Short-term investments 5 Receivables, net 6 Merchandise inventories 7 Othercurrent assets 8 Total current assets 9 OTHER Assets $10,2038462,24117,9071,49932,696$11,2589171,80314,2151,31229,505$12,2771,0281,59012,2421,02328,120$8,3841,0601,53511,3951,11123,485$6,0551,2041,66911,04012120,289 10 Property and Equipment, net 11 Operating lease right-of-use assets 12 Other longeterm assets 13 Total assets 14 CURRENT LABUUTIES \begin{tabular}{rrrrr} \hline 24,646 & 23,492 & 21,807 & 20,890 & 19,681 \\ 2,774 & 2,890 & 2,788 & 0 & 0 \\ 4,050 & 3,381 & 2,841 & 1,025 & 860 \\ 64,166 & 59,268 & 55,556 & 45,400 & 40,830 \end{tabular} 15 Accounts payable 16 Accrued salaries and benefits 17 Accrued member rewards 18 Deferred membership fees 19 Current portion of long-term debt 20 Other current liabilities 21 Total current liabilities 22 OTHER UABHITIES 23 Long-term debt, excluding current portion 24 Long-term operating lease liabilities 25 Other long-term liabilities 26 Total liabilities \begin{tabular}{|r|r|rrr|} \hline 17,848 & 16,278 & 14,172 & 11,679 & 11,2377 \\ \hline 4,381 & 4,090 & 3,605 & 3,176 & 2,994 \\ 1,911 & 1,671 & 1,393 & 1,180 & 1,057 \\ \hline 2,174 & 2,042 & 1,851 & 1,711 & 1,624 \\ 73 & 799 & 95 & 1,699 & 90 \\ \hline 5,611 & 4,561 & 3,728 & 3,792 & 2,924 \\ 31,998 & 29,441 & 24,844 & 23,217 & 19,926 \\ \hline 6,424 & & & & \\ \hline 2,482 & 6,692 & 7,514 & 5,124 & 6,437 \\ \hline 2,555 & 2,642 & 2,558 & 0 & 0 \\ \hline 43,519 & 2,415 & 1,935 & 1,455 & 1,314 \\ & 41,190 & 36,851 & 29,815 & 27,727 \\ \hline \end{tabular} 27 EqumTy Preferred stock $,005 par value; 100,000,000 shares authorized; 28 no shares issued and outstariding Common Stock $.005 par value; 100,000,000 shares authorized; 442,664,000 and 441,825,000 shares issued and outstanding 29 30 31 Additional paid-in capital 31 Acumulated other comprehensive loss 32 Retained earnings 33 rotal Costco stockholders' equity 34 Noncontrolling interests. 35 Total equity 36. TOTAL UAEIUTIES AND EQUITY Financial Statement Liquidity and Solvency Ratios CurrentRatioQuickRatioDebtEquityRatioFinancialLeverage2020130.640.642.9720211.0020.520.653.28 Profitability Ratios \begin{tabular}{lrr} & 2020 & 2021 \\ \hline Operating Profit & 3.26% & 3.42% \\ \hline Net Profit Ratio & 2.43% & 2.59% \\ \hline Return to Equity & 21.70% & 28.09% \\ ROCE & 17.70% & 22.49% \\ \hline \end{tabular} COST Financial Data xisx (13,2KB) REVENUE Total revenue \begin{tabular}{|lllll} $226,954 & $195,929 & $166,761 & $152,703 & $141,576 \end{tabular} OPERATING EXPENSES Merchandise costs Seling, general and administrative Operating income OTHER INCOME (EXPENSE) Interest expense lnterest income and other, net INCOME BEFORE INCOME TAXES Provision for income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests NET INCONE ATTRIBUTABLE TO COSTCO 199,38219,7797,793(158)2057,8401,9255,915(71)$5,844170,68418,5376,708(171)1436,6801,6015,079(72)55,007144,93916,3875,435(160)925,3671,3084,059(57)54,002132,83614,994864,737(150)1784,7651,0613,704(45)53,659123,15213,876654,480(159)1214,4421,2633,179(45)53,134 NET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: Alasic (in dollars per share) Diluted (in dollars per share) Shares used in calculation (000 's) Basic (shares) Diluted (shares) $13,17$13.14443,651444,757$11,30$11.27443,089444,346$9.05$9.02442,297443,901$8.32$8.26439,755442,923$7.15$7.09436,515441,334 Net sales RIVENUE Total revenue Membership fees REVENUE Total revenue 1 Consolidat 2 CURRENT ASSETS 3 Cash and cash equivalents 4 Short-term investments 5 Receivables, net 6 Merchandise inventories 7 Othercurrent assets 8 Total current assets 9 OTHER Assets $10,2038462,24117,9071,49932,696$11,2589171,80314,2151,31229,505$12,2771,0281,59012,2421,02328,120$8,3841,0601,53511,3951,11123,485$6,0551,2041,66911,04012120,289 10 Property and Equipment, net 11 Operating lease right-of-use assets 12 Other longeterm assets 13 Total assets 14 CURRENT LABUUTIES \begin{tabular}{rrrrr} \hline 24,646 & 23,492 & 21,807 & 20,890 & 19,681 \\ 2,774 & 2,890 & 2,788 & 0 & 0 \\ 4,050 & 3,381 & 2,841 & 1,025 & 860 \\ 64,166 & 59,268 & 55,556 & 45,400 & 40,830 \end{tabular} 15 Accounts payable 16 Accrued salaries and benefits 17 Accrued member rewards 18 Deferred membership fees 19 Current portion of long-term debt 20 Other current liabilities 21 Total current liabilities 22 OTHER UABHITIES 23 Long-term debt, excluding current portion 24 Long-term operating lease liabilities 25 Other long-term liabilities 26 Total liabilities \begin{tabular}{|r|r|rrr|} \hline 17,848 & 16,278 & 14,172 & 11,679 & 11,2377 \\ \hline 4,381 & 4,090 & 3,605 & 3,176 & 2,994 \\ 1,911 & 1,671 & 1,393 & 1,180 & 1,057 \\ \hline 2,174 & 2,042 & 1,851 & 1,711 & 1,624 \\ 73 & 799 & 95 & 1,699 & 90 \\ \hline 5,611 & 4,561 & 3,728 & 3,792 & 2,924 \\ 31,998 & 29,441 & 24,844 & 23,217 & 19,926 \\ \hline 6,424 & & & & \\ \hline 2,482 & 6,692 & 7,514 & 5,124 & 6,437 \\ \hline 2,555 & 2,642 & 2,558 & 0 & 0 \\ \hline 43,519 & 2,415 & 1,935 & 1,455 & 1,314 \\ & 41,190 & 36,851 & 29,815 & 27,727 \\ \hline \end{tabular} 27 EqumTy Preferred stock $,005 par value; 100,000,000 shares authorized; 28 no shares issued and outstariding Common Stock $.005 par value; 100,000,000 shares authorized; 442,664,000 and 441,825,000 shares issued and outstanding 29 30 31 Additional paid-in capital 31 Acumulated other comprehensive loss 32 Retained earnings 33 rotal Costco stockholders' equity 34 Noncontrolling interests. 35 Total equity 36. TOTAL UAEIUTIES AND EQUITY Financial Statement Liquidity and Solvency Ratios CurrentRatioQuickRatioDebtEquityRatioFinancialLeverage2020130.640.642.9720211.0020.520.653.28 Profitability Ratios \begin{tabular}{lrr} & 2020 & 2021 \\ \hline Operating Profit & 3.26% & 3.42% \\ \hline Net Profit Ratio & 2.43% & 2.59% \\ \hline Return to Equity & 21.70% & 28.09% \\ ROCE & 17.70% & 22.49% \\ \hline \end{tabular}
