*Could you help me develop a ratio analysis for all three years, and include the...

50.1K

Verified Solution

Question

Accounting

imageimageimageimageimage

*Could you help me develop a ratio analysis for all three years, and include the formulas so I could properly understand the calculations? (Current Ratio, Quick Ratio, Inventory Turnover, Days in Inventory, Total Assets Turnover, Total Fixed Assets Turnover, Accounts Receivable Turnover, Days in AR,Debt to Total Assets Ratio, Debt Equity Ratio, Long-term Debt to Equity, Times Interest Earned Ratio, GrossProfit Margin, Operating Profit Margins, Net Profit Margin, RETURN ON TOTAL ASSETS (ROA), RETURN ON STOCKHOLDERS' EQUITY (ROE), Earnings Per Share (EPS), Price Earnings Ratio).

Consolidated Statements of Cash Flows - USD ($) $ in Thousands 12 Months Ended Feb. 02, % Change $ Change 2020 Jan. 31, 2021 $ Change % Change Feb. 03, 2019 $ 680,714 324,652 91.18% $ 356,062 $ 22,378 6.71% $ 333,684 896 0.48% $ (1,049) $ (8,454) $ 18,485 -0.56% -82.81% -70.56% 188,808 10,209 (26,199) 188,655 32,365 (5,783) 216,368 (13,061) 73,185 (264) 30,610 1,931 558 (10,504) 9,022 (238) 1744.16% -25.03% 0.26% 410.79% 14.06% 915.38% 187,759 1,755 (7,714) 215,810 (2,557) 64,163 (26) $ (26,196) $ 4,361 $ 553 -110.82% 7.29% -95.51% 23,639 59,802 (579) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by (used in) operating activities: Depreciation and amortization Loss on disposal/impairment of assets Amortization of deferred lease incentives Non-cash lease expense Deferred income taxes Stock-based compensation expense Other Changes in: Accounts receivable Merchandise inventories Prepaid expenses and other assets Accounts payable Accrued expenses and other liabilities Gift card and other deferred revenue Deferred rent and lease incentives Operating lease liabilities Income taxes payable Net cash provided by operating activities (31,503) 99,144 (16,388) 25,489 129,142 82,841 0 (232,989) 46,933 1,274,848 (26,469) 74,925 (13,199) 36,540 115,883 83,481 0 (6,732) 46,198 667,554 525.80% 309.36% 413.89% -330.65% 874.00% -13043.91% 0.00% 2.98% 6285.44% 109.92% (5,034) 24,219 (3,189) (11,051) 13,259 (640) 0 (226,257) 735 607,294 $ 10,295 $ 94,550 $ 51,502 $ (73,428) $ (32,717) $ (39,539) $ (24,929) -67.16% -134.44% -94.17% -117.72% -71.16% -101.65% -100.00% (15,329) (70,331) (54,691) 62,377 45,976 38,899 24,929 $ 35,943 $ 21,308 -102.09% 3.64% (35,208) 585,986 (169,513) 629 (168,884) 16,763 (99) 16,664 -9.00% -13.60% -8.98% (186,276) 728 (185,548) $ 3,826 $ (1,475) $ 2,351 -2.01% -66.95% -1.25% (190,102) 2,203 (187,899) 387.82% 387.82% 4.65% 0.78% 14.33% 100,000 (100,000) (150,640) (148,834) (27,752) $ 40,000 $ (40,000) $ (10,315) $ 146,470 $ (13,315) 66.67% 66.67% 7.35% -49.60% 92.23% Cash flows from investing activities: Purchases of property and equipment Other Net cash used in investing activities Cash flows from financing activities: Borrowings under revolving line of credit Repayments of borrowings under revolving line of credit Payment of dividends Repurchases of common stock Tax withholdings related to stock-based awards Debt issuance costs Net cash used in financing activities Effect of exchange rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information: Cash paid during the year for interest Cash paid during the year for income taxes, net of refunds Non-cash investing activities: Purchases of property and equipment not yet paid for at end of year 487,823 (487,823) (157,645) (150,000) (31,729) (3,645) (343,019) 5,230 768,175 432,162 1,200,337 387,823 (387,823) (7,005) (1,166) (3,977) (3,645) (15,793) 6,542 674,967 93,208 768,175 60,000 (60,000) (140,325) (295,304) (14,437) 0 (450,066) 797 (51,182) 390,136 338,954 4.83% -498.63% 724.15% (327,226) (1,312) 93,208 338,954 432,162 $ 122,840 $ (2,109) $ 144,390 $ (51,182) $ 93,208 -27.29% -264.62% -282.11% 27.50% 177.75% -13.12% 27.50% 18,346 162,842 5,664 49,498 44.66% 43.67% 12,682 113,344 $ 1,258 $ 5,393 11.01% 5.00% 11,424 107,951 $ 753 (1,633) -68.44% $ 2,386 $ (387) -13.96% $ 2,773 Consolidated Statements of Earnings - USD ($) shares in Thousands, $ in Thousands Jan. 31, 2021 $ Change Net revenues Cost of goods sold Gross profit Selling, general and administrative expenses Operating income Interest expense, net Earnings before income taxes Income taxes Net earnings Basic earnings per share Diluted earnings per share Shares used in calculation of earnings per share: Basic Diluted $ 6,783,189 4,146,920 2,636,269 1,725,572 910,697 16,231 894,466 213,752 $ 680,714 $ 8.81 $ 8.61 $ 885,181 388,004 497,177 52,354 444,823 7,378 437,445 112,793 324,652 12 Months Ended Feb. 02, % Change $ Change 2020 15.01% $ 5,898,008 $ 226,415 10.32% 3,758,916 188,336 23.24% 2,139,092 38,079 3.13% 1,673,218 8,158 95.48% 465,874 29,921 83.34% 8,853 2,147 95.72% 457,021 27,774 111.72% 100,959 5,396 91.18% $ 356,062 22,378 93.20% $ 4.56 0 91.76% $ 4.49 0 Feb. 03, % Change 2019 3.99% $ 5,671,593 5.27% 3,570,580 1.81% 2,101,013 0.49% 1,665,060 6.86% 435,953 32.02% 6,706 6.47% 429,247 5.65% 95,563 6.71% $333,684 11.22% $ 4.10 10.86% $ 4.05 4 4 77,260 79,055 (848) (170) -1.09% -0.21% 78,108 79,225 (3,312) (3,115) -4.07% -3.78% 81,420 82,340 Consolidated Balance Sheets - USD ($) $ in Thousands Jan. 31, 2021 $ Change % Change Feb. 02, 2020 $ Change % Change Feb. 03, 2019 177.75% 28.63% -8.56% 3.76% 10.25% 40.52% Current assets Cash and cash equivalents Accounts receivable, net Merchandise inventories, net Prepaid expenses Other current assets Total current assets Property and equipment, net Operating lease right-of-use assets Deferred income taxes, net Goodwill Other long-term assets, net Total assets Current liabilities Accounts payable Accrued expenses Gift card and other deferred revenue Income taxes payable Current debt Operating lease liabilities Other current liabilities Total current liabilities Deferred lease incentives Long-term operating lease liabilities $ 1,200,337 $ 768,175 143,728 31,991 1,006,299 (94,245) 93,822 3,396 22,894 2,128 2,467,080 711,445 873,894 (55,144) 1,086,009 (80,374) 61,854 13,877 85,446 103 87,141 17,475 4,661,424 607,382 $ 432,162 111,737 1,100,544 90,426 20,766 1,755,635 929,038 1,166,383 47,977 85,343 69,666 4,054,042 $ 93,208 4,635 (24,448) (10,930) (1,173) 61,292 (597) 0 3,922 (39) 10,237 1,241,198 0 (5,467) 11,444 (832) 1,040 -5.94% -6.89% 28.92% 0.12% 25.08% 14.98% 27.50% 4.33% -2.17% -10.78% -5.35% 3.62% -0.06% 0.00% 8.90% -0.05% 17.23% 44.13% 0.00% -1.04% 7.00% -0.29% 4.85% $ 338,954 107,102 1,124,992 101,356 21,939 1,694,343 929,635 0 44,055 85,382 59,429 2,812,844 526,702 163,559 290,445 21,461 542,992 267,592 373,164 69,476 299,350 209,754 85,672 1,848,000 20,612 1,025,057 21,757 92,589 83,551 46,975 (468) (18,169) 12,210 238,445 (7,047) (69,522) 4.17% 52.91% 28.85% 208.77% -0.16% -7.97% 16.62% 14.81% -25.48% -6.35% 521,235 175,003 289,613 22,501 299,818 227,923 73,462 1,609,555 27,659 1,094,579 817 534,743 (173,715) 794,959 1.12% 49.75% -86.26% 265.32% 72,645 1,074,812 201,374 299,620 116,570 3,010,239 30,181 192,057 34.94% 6.81% 86,389 2,818,182 2,736,858 (1,657,130) 3365.38% -100.00% 81,324 1,657,130 764 (8) -1.04% 772 (17) -2.15% 789 Other long-term liabilities Total liabilities Stockholders' equity Preferred stock: $.01 par value; 7,500 shares authorized; none issued Common stock: $.01 par value; 253,125 shares authorized; 76,340 and 77,137 shares issued and outstanding at January 31, 2021 and February 2, 2020, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost: 8 and 14 shares as of January 31, 2021 and February 2, 2020, respectively Total stockholders' equity Total liabilities and stockholders' equity 638,375 1,019,762 (7,117) (599) 32,553 374,968 7,470 342 5.37% 58.15% -51.21% -36.34% 605,822 644,794 (14,587) (941) 23,922 60,461 (3,514) (706) 4.11% 10.35% 31.73% 300.43% 581,900 584,333 (11,073) (235) 1,651,185 $ 4,661,424 415,325 607,382 33.61% 1,235,860 14.98% $ 4,054,042 80,146 1,241,198 6.93% 1,155,714 44.13% $ 2,812,844 Consolidated Statements of Cash Flows - USD ($) $ in Thousands 12 Months Ended Feb. 02, % Change $ Change 2020 Jan. 31, 2021 $ Change % Change Feb. 03, 2019 $ 680,714 324,652 91.18% $ 356,062 $ 22,378 6.71% $ 333,684 896 0.48% $ (1,049) $ (8,454) $ 18,485 -0.56% -82.81% -70.56% 188,808 10,209 (26,199) 188,655 32,365 (5,783) 216,368 (13,061) 73,185 (264) 30,610 1,931 558 (10,504) 9,022 (238) 1744.16% -25.03% 0.26% 410.79% 14.06% 915.38% 187,759 1,755 (7,714) 215,810 (2,557) 64,163 (26) $ (26,196) $ 4,361 $ 553 -110.82% 7.29% -95.51% 23,639 59,802 (579) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by (used in) operating activities: Depreciation and amortization Loss on disposal/impairment of assets Amortization of deferred lease incentives Non-cash lease expense Deferred income taxes Stock-based compensation expense Other Changes in: Accounts receivable Merchandise inventories Prepaid expenses and other assets Accounts payable Accrued expenses and other liabilities Gift card and other deferred revenue Deferred rent and lease incentives Operating lease liabilities Income taxes payable Net cash provided by operating activities (31,503) 99,144 (16,388) 25,489 129,142 82,841 0 (232,989) 46,933 1,274,848 (26,469) 74,925 (13,199) 36,540 115,883 83,481 0 (6,732) 46,198 667,554 525.80% 309.36% 413.89% -330.65% 874.00% -13043.91% 0.00% 2.98% 6285.44% 109.92% (5,034) 24,219 (3,189) (11,051) 13,259 (640) 0 (226,257) 735 607,294 $ 10,295 $ 94,550 $ 51,502 $ (73,428) $ (32,717) $ (39,539) $ (24,929) -67.16% -134.44% -94.17% -117.72% -71.16% -101.65% -100.00% (15,329) (70,331) (54,691) 62,377 45,976 38,899 24,929 $ 35,943 $ 21,308 -102.09% 3.64% (35,208) 585,986 (169,513) 629 (168,884) 16,763 (99) 16,664 -9.00% -13.60% -8.98% (186,276) 728 (185,548) $ 3,826 $ (1,475) $ 2,351 -2.01% -66.95% -1.25% (190,102) 2,203 (187,899) 387.82% 387.82% 4.65% 0.78% 14.33% 100,000 (100,000) (150,640) (148,834) (27,752) $ 40,000 $ (40,000) $ (10,315) $ 146,470 $ (13,315) 66.67% 66.67% 7.35% -49.60% 92.23% Cash flows from investing activities: Purchases of property and equipment Other Net cash used in investing activities Cash flows from financing activities: Borrowings under revolving line of credit Repayments of borrowings under revolving line of credit Payment of dividends Repurchases of common stock Tax withholdings related to stock-based awards Debt issuance costs Net cash used in financing activities Effect of exchange rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information: Cash paid during the year for interest Cash paid during the year for income taxes, net of refunds Non-cash investing activities: Purchases of property and equipment not yet paid for at end of year 487,823 (487,823) (157,645) (150,000) (31,729) (3,645) (343,019) 5,230 768,175 432,162 1,200,337 387,823 (387,823) (7,005) (1,166) (3,977) (3,645) (15,793) 6,542 674,967 93,208 768,175 60,000 (60,000) (140,325) (295,304) (14,437) 0 (450,066) 797 (51,182) 390,136 338,954 4.83% -498.63% 724.15% (327,226) (1,312) 93,208 338,954 432,162 $ 122,840 $ (2,109) $ 144,390 $ (51,182) $ 93,208 -27.29% -264.62% -282.11% 27.50% 177.75% -13.12% 27.50% 18,346 162,842 5,664 49,498 44.66% 43.67% 12,682 113,344 $ 1,258 $ 5,393 11.01% 5.00% 11,424 107,951 $ 753 (1,633) -68.44% $ 2,386 $ (387) -13.96% $ 2,773 Consolidated Statements of Earnings - USD ($) shares in Thousands, $ in Thousands Jan. 31, 2021 $ Change Net revenues Cost of goods sold Gross profit Selling, general and administrative expenses Operating income Interest expense, net Earnings before income taxes Income taxes Net earnings Basic earnings per share Diluted earnings per share Shares used in calculation of earnings per share: Basic Diluted $ 6,783,189 4,146,920 2,636,269 1,725,572 910,697 16,231 894,466 213,752 $ 680,714 $ 8.81 $ 8.61 $ 885,181 388,004 497,177 52,354 444,823 7,378 437,445 112,793 324,652 12 Months Ended Feb. 02, % Change $ Change 2020 15.01% $ 5,898,008 $ 226,415 10.32% 3,758,916 188,336 23.24% 2,139,092 38,079 3.13% 1,673,218 8,158 95.48% 465,874 29,921 83.34% 8,853 2,147 95.72% 457,021 27,774 111.72% 100,959 5,396 91.18% $ 356,062 22,378 93.20% $ 4.56 0 91.76% $ 4.49 0 Feb. 03, % Change 2019 3.99% $ 5,671,593 5.27% 3,570,580 1.81% 2,101,013 0.49% 1,665,060 6.86% 435,953 32.02% 6,706 6.47% 429,247 5.65% 95,563 6.71% $333,684 11.22% $ 4.10 10.86% $ 4.05 4 4 77,260 79,055 (848) (170) -1.09% -0.21% 78,108 79,225 (3,312) (3,115) -4.07% -3.78% 81,420 82,340 Consolidated Balance Sheets - USD ($) $ in Thousands Jan. 31, 2021 $ Change % Change Feb. 02, 2020 $ Change % Change Feb. 03, 2019 177.75% 28.63% -8.56% 3.76% 10.25% 40.52% Current assets Cash and cash equivalents Accounts receivable, net Merchandise inventories, net Prepaid expenses Other current assets Total current assets Property and equipment, net Operating lease right-of-use assets Deferred income taxes, net Goodwill Other long-term assets, net Total assets Current liabilities Accounts payable Accrued expenses Gift card and other deferred revenue Income taxes payable Current debt Operating lease liabilities Other current liabilities Total current liabilities Deferred lease incentives Long-term operating lease liabilities $ 1,200,337 $ 768,175 143,728 31,991 1,006,299 (94,245) 93,822 3,396 22,894 2,128 2,467,080 711,445 873,894 (55,144) 1,086,009 (80,374) 61,854 13,877 85,446 103 87,141 17,475 4,661,424 607,382 $ 432,162 111,737 1,100,544 90,426 20,766 1,755,635 929,038 1,166,383 47,977 85,343 69,666 4,054,042 $ 93,208 4,635 (24,448) (10,930) (1,173) 61,292 (597) 0 3,922 (39) 10,237 1,241,198 0 (5,467) 11,444 (832) 1,040 -5.94% -6.89% 28.92% 0.12% 25.08% 14.98% 27.50% 4.33% -2.17% -10.78% -5.35% 3.62% -0.06% 0.00% 8.90% -0.05% 17.23% 44.13% 0.00% -1.04% 7.00% -0.29% 4.85% $ 338,954 107,102 1,124,992 101,356 21,939 1,694,343 929,635 0 44,055 85,382 59,429 2,812,844 526,702 163,559 290,445 21,461 542,992 267,592 373,164 69,476 299,350 209,754 85,672 1,848,000 20,612 1,025,057 21,757 92,589 83,551 46,975 (468) (18,169) 12,210 238,445 (7,047) (69,522) 4.17% 52.91% 28.85% 208.77% -0.16% -7.97% 16.62% 14.81% -25.48% -6.35% 521,235 175,003 289,613 22,501 299,818 227,923 73,462 1,609,555 27,659 1,094,579 817 534,743 (173,715) 794,959 1.12% 49.75% -86.26% 265.32% 72,645 1,074,812 201,374 299,620 116,570 3,010,239 30,181 192,057 34.94% 6.81% 86,389 2,818,182 2,736,858 (1,657,130) 3365.38% -100.00% 81,324 1,657,130 764 (8) -1.04% 772 (17) -2.15% 789 Other long-term liabilities Total liabilities Stockholders' equity Preferred stock: $.01 par value; 7,500 shares authorized; none issued Common stock: $.01 par value; 253,125 shares authorized; 76,340 and 77,137 shares issued and outstanding at January 31, 2021 and February 2, 2020, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost: 8 and 14 shares as of January 31, 2021 and February 2, 2020, respectively Total stockholders' equity Total liabilities and stockholders' equity 638,375 1,019,762 (7,117) (599) 32,553 374,968 7,470 342 5.37% 58.15% -51.21% -36.34% 605,822 644,794 (14,587) (941) 23,922 60,461 (3,514) (706) 4.11% 10.35% 31.73% 300.43% 581,900 584,333 (11,073) (235) 1,651,185 $ 4,661,424 415,325 607,382 33.61% 1,235,860 14.98% $ 4,054,042 80,146 1,241,198 6.93% 1,155,714 44.13% $ 2,812,844

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students