*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 Income Statement - USD ($) $ in Thousands Feb. 27, 2021 12 Months Ended Feb. 29, % Change 2020 $ Change $ Change % Change Mar. 02, 2019 Income Statement Net sales Cost of sales Gross profit Selling, general and administrative expenses Goodwill and other impairments Restructuring and transformation initiative expenses Loss on sale of businesses, including impairment of assets held for sale Operating loss Interest expense, net Gain on extinguishment of debt Loss before benefit from income taxes Benefit from income taxes Net loss Net loss per share - Basic (in dollars per share) Net loss per share - Diluted (in dollars per share) Weighted average shares outstanding - Basic (in shares) Weighted average shares outstanding - Diluted (in shares) Dividends declared per share (in dollars per share) $ 9,233,028 6,114,947 3,118,081 3,224,363 127,341 102,202 1,062 (336,887) 76,913 (77,038) (336,762) (185,989) $ (150,773) $ (1.24) $ (1.24) 121,446 121,446 $ 0 $ (1,925,552) (1,501,973) (423,579) (508,135) (381,885) 102,202 1,062 363,177 12,124 (77,038) 428,091 (34,952) 463,043 -17.26% $ 11,158,580 $ (870,217) -19.72% 7,616,920 (307,897) -11.96% 3,541,660 (562,320) -13.61% 3,732,498 51,288 -74.99% 509,226 (679) 0.00% 0 0 0.00% 0 0 -51.88% (700,064) (612,929) 18.71% 64,789 (4,685) 0.00% 0 0 -55.97% (764,853) (608,244) 23.14% (151,037) (131,652) -75.44% $ (613,816) (476,592) -74.90% $ (4.94) (4) -74.90% $ (4.94) (4) -2.34% 124,352 (9,940) -2.34% 124,352 (9,940) -100.00% $ 0.68 0 -7.23% $ 12,028,797 -3.89% 7,924,817 -13.70% 4,103,980 1.39% 3,681,210 -0.13% 509,905 0.00% 0 0.00% 0 703.42% (87,135) -6.74% 69,474 0.00% 388.38% (156,609) 679.14% (19,385) 347.31% $ (137,224) 384.31% $ (1.02) 384.31% $ (1.02) -7.40% 134,292 -7.40% 134,292 6.25% $ 0.64 - 4 4 (2,906) (2,906) (1) Feb. 27, 2021 $ Change % Change Feb. 29, 2020 $ Change % Change Mar. 02, 2019 Consolidated Balance Sheet - USD ($) $ in Thousands 96.54% -20.62% -20.05% -16.18% $ 1,352,984 0 1,671,909 595,152 0 3,620,045 19,545 918,418 1,587,101 0 311,821 6,456,930 $ 352,644 (385,642) (421,960) 346,810 (98,092) (206,240) (835) (512,186) (419,865) 0 (194,459) (1,333,585) 35.25% $ 1,000,340 -100.00% 385,642 -20.15% 2,093,869 139.65% 248,342 -100.00% 98,092 -5.39% 3,826,285 -4.10% 20,380 -35.80% 1,430,604 -20.92% 2,006,966 0.00% 0 -38.41% 506,280 -17.12% 7,790,515 $ 491,369 (100,157) (525,053) (47,938) 98,092 (83,687) 370 (422,487) 2,006,966 (391,052) 109,864 1,219,974 $ 508,971 485,799 2,618,922 296,280 0 3,909,972 20,010 1,853,091 0.00% -2.14% 1.85% -22.80% 0.00% -100.00% 27.71% 18.57% 391,052 396,416 6,570,541 Cash and cash equivalents Short term investment securities Merchandise inventories Prepaid expenses and other current assets Assets held-for-sale Total current assets Long term investment securities Property and equipment, net Operating lease assets Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other current liabilities Merchandise credit and gift card liabilities Current operating lease liabilities Liabilities related to assets held-for-sale Current income taxes payable Total current liabilities Other liabilities Operating lease liabilities Income taxes payable Long term debt 986,045 636,329 312,486 360,061 0 -13.70% 8.34% 0.32% 1,094,078 623,734 339,322 0 0 41,851 (39,447) (27,921) (102,944) (43,144) 0 (171,605) (122,647) (309,016) 55,719 (298,037) 4.43% -5.84% -8.20% -22.23% -100.00% 0.00% -6.96% -59.85% -16.99% 118.69% -20.02% 944,194 675,776 340,407 463,005 43,144 0 2,466,526 204,926 1,818,783 46,945 1,488,400 (149,884) 52,042 1,085 463,005 43,144 (20,498) 388,894 (190,483) 1,818,783 (2,290) 466 -100.00% 18.72% -48.17% 20,498 2,077,632 395,409 2,294,921 82,279 1,509,767 102,664 1,190,363 -4.65% 0.03% 49,235 1,487,934 5,179,994 (845,586) -14.03% 6,025,580 2,015,370 50.26% 4,010,210 0 0 3,432 0 (4) 0.00% -0.12% 0 3,436 0.00% 0.29% 0 3,426 10 Total liabilities Shareholders' equity: Preferred stock - $0.01 par value; authorized - 1,000 shares; no shares issued or outstanding Common stock - $0.01 par value; authorized - 900,000 shares; issued 343,241 and 343,683, respectively; outstanding 109,621 and 126,528 shares, respectively Additional paid-in capital Retained earnings Treasury stock, at cost; 233,620 and 217,155 shares, respectively Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity 2,152,135 10,225,253 (11,048,284) (55,600) 1,276,936 $ 6,456,930 (15,202) (149,573) (332,529) 9,309 (487,999) (1,333,585) -0.70% 2,167,337 -1.44% 10,374,826 3.10% (10,715,755) -14.34% (64,909) -27.65% 1,764,935 -17.12% $ 7,790,515 48,664 (738,061) (99,710) (6,299) (795,396) 1,219,974 2.30% 2,118,673 -6.64% 11,112,887 0.94% (10,616,045) 10.75% (58,610) -31.07% 2,560,331 18.57% $6,570,541 Consolidated Statements of Cash Flows - USD ($) $ in Thousands Feb. 27, 2021 $ Change % Change Feb. 29, 2020 $ Change % Change Mar. 02, 2019 $ (150,773) $ 463,043 -75.44% $ (613,816) $ (476,592) 347.31% $ (137,224) 1.09% 342,511 27,357 0 0 340,912 0 0 (77,038) 1,062 127,341 31,594 148,741 (396) -0.47% -100.00% 0.00% 0.00% 0.00% -74.99% -30.83% -202.20% -88.51% 0 (1,599) (27,357) 0 (77,038) 1,062 (381,885) (14,082) 294,284 3,050 0 (441,387) (21) (382,391) 1,301 Cash Flows from Operating Activities: Net loss Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Loss on sale leaseback transaction Gain on sale of building Gain on extinguishment of debt Loss on sale of businesses, including impairment of assets held for sale Goodwill and other impairments Stock-based compensation Deferred income taxes Other Decrease (increase) in assets: Merchandise inventories Trading investment securities Other current assets Other assets (Decrease) increase in liabilities: Accounts payable Accrued expenses and other current liabilities Merchandise credit and gift card liabilities Income taxes payable Operating lease assets and liabilities, net Other liabilities 509,226 45,676 (145,543) (3,446) 3,686 27,357 29,690 412 0 (679) (12,838) (41,454) (2,632) 0 399,406 (86,256) (273,967) 0 338,825 0 (29,690) (412) 0 509,905 58,514 (104,089) (814) -100.00% -100.00% 0.00% -0.13% -21.94% 39.83% 323.34% 0.00% 373.53% 64,947 0 (387,172) 1,519 -87.17% -100.00% 7998.14% 596.79% 506,334 21 (4,781) 218 -99.98% -101.78% 0.00% 106,928 86,277 269,186 218 168,556 15,538 (12,110) 54,958 (32,813) (26,758) 292,762 (46,326) (13,264) 77,741 (29,914) (40,812) -235.71% -74.88% -1149.39% -341.22% 1031.87% -290.39% (124,206) 61,864 1,154 (22,783) (2,899) 14,054 (33,549) 139,011 (14,862) (31,143) (2,899) 49,972 37.01% -180.19% -92.79% -372.52% (90,657) (77,147) 16,016 8,360 -139.13% (35,918) 268,108 (322,833) -54.63% 590,941 (327,337) -35.65% 918,278 -39.61% 1.13% (734,424) 538,925 0 0 386,500 534,457 0 0 (183,077) 737,880 443,500 (158,500) 534,457 (267,277) 0 94,324 646,504 -100.00% -29.08% 0.00% -100.00% 0.00% -34.00% (443,500) 545,000 0 267,277 0 (277,401) 91,376 290,924 6,075 0 267,277 (11,183) 47,965 601,058 0.00% 0.00% -100.00% -14.74% -117.93% 11,183 (325,366) (509,682) 707.52% 0 Net cash provided by operating activities Cash Flows from Investing Activities: Purchases of held-to-maturity investment securities Redemption of held-to-maturity investment securities Net proceeds from sales of businesses Proceeds from sale-leaseback transaction Proceeds from sale of a building Capital expenditures Net cash provided by (used in) investing activities Cash Flows from Financing Activities: Borrowing of long-term debt Repayments of long-term debt Repurchase of common stock, including fees Prepayment under share repurchase agreement Payment of dividends Payment of deferred financing fees Proceeds from exercise of stock options Net cash used in financing activities Effect of exchange rate changes on cash, cash equivalents, and restricted cash Net increase in cash, cash equivalents and restricted cash Change in cash balances classified as held-for-sale Net increase in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash: Beginning of period End of period 0 4,224 48,363 0 805 236,400 (457,827) (332,529) (47,550) (23,108) (7,690) 0 (632,304) 5,075 378,759 4,815 383,574 236,400 (457,827) (232,819) (47,550) 62,374 (7,690) (2,346) (449,458) 6,052 (119,735) 9,630 (110,105) 0.00% 0.00% 233.50% 0.00% -72.97% 0.00% -100.00% 245.81% -619.45% -24.02% -200.00% -22.30% 0 (99,710) 0 (85,482) 0 2,346 (182,846) (977) 498,494 (4,815) 493,679 0 2,346 55,738 6,204 335,663 (4,815) 330,848 0.00% -100.00% -32.66% 0.00% -0.93% 0.00% 0.00% -23.36% -86.39% 206.14% 0.00% 203.18% 0 (4,224) (148,073) 0 (86,287) 0 0 (238,584) (7,181) 162,831 0 162,831 1,023,650 $ 1,407,224 493,679 383,574 93.15% 529,971 37.47% $ 1,023,650 162,831 493,679 44.35% 93.15% 367,140 $ 529,971 Consolidated Income Statement - USD ($) $ in Thousands Feb. 27, 2021 12 Months Ended Feb. 29, % Change 2020 $ Change $ Change % Change Mar. 02, 2019 Income Statement Net sales Cost of sales Gross profit Selling, general and administrative expenses Goodwill and other impairments Restructuring and transformation initiative expenses Loss on sale of businesses, including impairment of assets held for sale Operating loss Interest expense, net Gain on extinguishment of debt Loss before benefit from income taxes Benefit from income taxes Net loss Net loss per share - Basic (in dollars per share) Net loss per share - Diluted (in dollars per share) Weighted average shares outstanding - Basic (in shares) Weighted average shares outstanding - Diluted (in shares) Dividends declared per share (in dollars per share) $ 9,233,028 6,114,947 3,118,081 3,224,363 127,341 102,202 1,062 (336,887) 76,913 (77,038) (336,762) (185,989) $ (150,773) $ (1.24) $ (1.24) 121,446 121,446 $ 0 $ (1,925,552) (1,501,973) (423,579) (508,135) (381,885) 102,202 1,062 363,177 12,124 (77,038) 428,091 (34,952) 463,043 -17.26% $ 11,158,580 $ (870,217) -19.72% 7,616,920 (307,897) -11.96% 3,541,660 (562,320) -13.61% 3,732,498 51,288 -74.99% 509,226 (679) 0.00% 0 0 0.00% 0 0 -51.88% (700,064) (612,929) 18.71% 64,789 (4,685) 0.00% 0 0 -55.97% (764,853) (608,244) 23.14% (151,037) (131,652) -75.44% $ (613,816) (476,592) -74.90% $ (4.94) (4) -74.90% $ (4.94) (4) -2.34% 124,352 (9,940) -2.34% 124,352 (9,940) -100.00% $ 0.68 0 -7.23% $ 12,028,797 -3.89% 7,924,817 -13.70% 4,103,980 1.39% 3,681,210 -0.13% 509,905 0.00% 0 0.00% 0 703.42% (87,135) -6.74% 69,474 0.00% 388.38% (156,609) 679.14% (19,385) 347.31% $ (137,224) 384.31% $ (1.02) 384.31% $ (1.02) -7.40% 134,292 -7.40% 134,292 6.25% $ 0.64 - 4 4 (2,906) (2,906) (1) Feb. 27, 2021 $ Change % Change Feb. 29, 2020 $ Change % Change Mar. 02, 2019 Consolidated Balance Sheet - USD ($) $ in Thousands 96.54% -20.62% -20.05% -16.18% $ 1,352,984 0 1,671,909 595,152 0 3,620,045 19,545 918,418 1,587,101 0 311,821 6,456,930 $ 352,644 (385,642) (421,960) 346,810 (98,092) (206,240) (835) (512,186) (419,865) 0 (194,459) (1,333,585) 35.25% $ 1,000,340 -100.00% 385,642 -20.15% 2,093,869 139.65% 248,342 -100.00% 98,092 -5.39% 3,826,285 -4.10% 20,380 -35.80% 1,430,604 -20.92% 2,006,966 0.00% 0 -38.41% 506,280 -17.12% 7,790,515 $ 491,369 (100,157) (525,053) (47,938) 98,092 (83,687) 370 (422,487) 2,006,966 (391,052) 109,864 1,219,974 $ 508,971 485,799 2,618,922 296,280 0 3,909,972 20,010 1,853,091 0.00% -2.14% 1.85% -22.80% 0.00% -100.00% 27.71% 18.57% 391,052 396,416 6,570,541 Cash and cash equivalents Short term investment securities Merchandise inventories Prepaid expenses and other current assets Assets held-for-sale Total current assets Long term investment securities Property and equipment, net Operating lease assets Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other current liabilities Merchandise credit and gift card liabilities Current operating lease liabilities Liabilities related to assets held-for-sale Current income taxes payable Total current liabilities Other liabilities Operating lease liabilities Income taxes payable Long term debt 986,045 636,329 312,486 360,061 0 -13.70% 8.34% 0.32% 1,094,078 623,734 339,322 0 0 41,851 (39,447) (27,921) (102,944) (43,144) 0 (171,605) (122,647) (309,016) 55,719 (298,037) 4.43% -5.84% -8.20% -22.23% -100.00% 0.00% -6.96% -59.85% -16.99% 118.69% -20.02% 944,194 675,776 340,407 463,005 43,144 0 2,466,526 204,926 1,818,783 46,945 1,488,400 (149,884) 52,042 1,085 463,005 43,144 (20,498) 388,894 (190,483) 1,818,783 (2,290) 466 -100.00% 18.72% -48.17% 20,498 2,077,632 395,409 2,294,921 82,279 1,509,767 102,664 1,190,363 -4.65% 0.03% 49,235 1,487,934 5,179,994 (845,586) -14.03% 6,025,580 2,015,370 50.26% 4,010,210 0 0 3,432 0 (4) 0.00% -0.12% 0 3,436 0.00% 0.29% 0 3,426 10 Total liabilities Shareholders' equity: Preferred stock - $0.01 par value; authorized - 1,000 shares; no shares issued or outstanding Common stock - $0.01 par value; authorized - 900,000 shares; issued 343,241 and 343,683, respectively; outstanding 109,621 and 126,528 shares, respectively Additional paid-in capital Retained earnings Treasury stock, at cost; 233,620 and 217,155 shares, respectively Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity 2,152,135 10,225,253 (11,048,284) (55,600) 1,276,936 $ 6,456,930 (15,202) (149,573) (332,529) 9,309 (487,999) (1,333,585) -0.70% 2,167,337 -1.44% 10,374,826 3.10% (10,715,755) -14.34% (64,909) -27.65% 1,764,935 -17.12% $ 7,790,515 48,664 (738,061) (99,710) (6,299) (795,396) 1,219,974 2.30% 2,118,673 -6.64% 11,112,887 0.94% (10,616,045) 10.75% (58,610) -31.07% 2,560,331 18.57% $6,570,541 Consolidated Statements of Cash Flows - USD ($) $ in Thousands Feb. 27, 2021 $ Change % Change Feb. 29, 2020 $ Change % Change Mar. 02, 2019 $ (150,773) $ 463,043 -75.44% $ (613,816) $ (476,592) 347.31% $ (137,224) 1.09% 342,511 27,357 0 0 340,912 0 0 (77,038) 1,062 127,341 31,594 148,741 (396) -0.47% -100.00% 0.00% 0.00% 0.00% -74.99% -30.83% -202.20% -88.51% 0 (1,599) (27,357) 0 (77,038) 1,062 (381,885) (14,082) 294,284 3,050 0 (441,387) (21) (382,391) 1,301 Cash Flows from Operating Activities: Net loss Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Loss on sale leaseback transaction Gain on sale of building Gain on extinguishment of debt Loss on sale of businesses, including impairment of assets held for sale Goodwill and other impairments Stock-based compensation Deferred income taxes Other Decrease (increase) in assets: Merchandise inventories Trading investment securities Other current assets Other assets (Decrease) increase in liabilities: Accounts payable Accrued expenses and other current liabilities Merchandise credit and gift card liabilities Income taxes payable Operating lease assets and liabilities, net Other liabilities 509,226 45,676 (145,543) (3,446) 3,686 27,357 29,690 412 0 (679) (12,838) (41,454) (2,632) 0 399,406 (86,256) (273,967) 0 338,825 0 (29,690) (412) 0 509,905 58,514 (104,089) (814) -100.00% -100.00% 0.00% -0.13% -21.94% 39.83% 323.34% 0.00% 373.53% 64,947 0 (387,172) 1,519 -87.17% -100.00% 7998.14% 596.79% 506,334 21 (4,781) 218 -99.98% -101.78% 0.00% 106,928 86,277 269,186 218 168,556 15,538 (12,110) 54,958 (32,813) (26,758) 292,762 (46,326) (13,264) 77,741 (29,914) (40,812) -235.71% -74.88% -1149.39% -341.22% 1031.87% -290.39% (124,206) 61,864 1,154 (22,783) (2,899) 14,054 (33,549) 139,011 (14,862) (31,143) (2,899) 49,972 37.01% -180.19% -92.79% -372.52% (90,657) (77,147) 16,016 8,360 -139.13% (35,918) 268,108 (322,833) -54.63% 590,941 (327,337) -35.65% 918,278 -39.61% 1.13% (734,424) 538,925 0 0 386,500 534,457 0 0 (183,077) 737,880 443,500 (158,500) 534,457 (267,277) 0 94,324 646,504 -100.00% -29.08% 0.00% -100.00% 0.00% -34.00% (443,500) 545,000 0 267,277 0 (277,401) 91,376 290,924 6,075 0 267,277 (11,183) 47,965 601,058 0.00% 0.00% -100.00% -14.74% -117.93% 11,183 (325,366) (509,682) 707.52% 0 Net cash provided by operating activities Cash Flows from Investing Activities: Purchases of held-to-maturity investment securities Redemption of held-to-maturity investment securities Net proceeds from sales of businesses Proceeds from sale-leaseback transaction Proceeds from sale of a building Capital expenditures Net cash provided by (used in) investing activities Cash Flows from Financing Activities: Borrowing of long-term debt Repayments of long-term debt Repurchase of common stock, including fees Prepayment under share repurchase agreement Payment of dividends Payment of deferred financing fees Proceeds from exercise of stock options Net cash used in financing activities Effect of exchange rate changes on cash, cash equivalents, and restricted cash Net increase in cash, cash equivalents and restricted cash Change in cash balances classified as held-for-sale Net increase in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash: Beginning of period End of period 0 4,224 48,363 0 805 236,400 (457,827) (332,529) (47,550) (23,108) (7,690) 0 (632,304) 5,075 378,759 4,815 383,574 236,400 (457,827) (232,819) (47,550) 62,374 (7,690) (2,346) (449,458) 6,052 (119,735) 9,630 (110,105) 0.00% 0.00% 233.50% 0.00% -72.97% 0.00% -100.00% 245.81% -619.45% -24.02% -200.00% -22.30% 0 (99,710) 0 (85,482) 0 2,346 (182,846) (977) 498,494 (4,815) 493,679 0 2,346 55,738 6,204 335,663 (4,815) 330,848 0.00% -100.00% -32.66% 0.00% -0.93% 0.00% 0.00% -23.36% -86.39% 206.14% 0.00% 203.18% 0 (4,224) (148,073) 0 (86,287) 0 0 (238,584) (7,181) 162,831 0 162,831 1,023,650 $ 1,407,224 493,679 383,574 93.15% 529,971 37.47% $ 1,023,650 162,831 493,679 44.35% 93.15% 367,140 $ 529,971
