Calculate the following ratios for the three years i) Current ratio, Quick ratio, Profit Margin, Debt To
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the following ratios for the three years
i) Current ratio, Quick ratio, Profit Margin, Debt To Total Asset Ratio
ii) Asset Turnover, ROA, ROE
iii) NOA, NOPAT, RNOA, NOPM, NOAT
DSG &CO. | |||
CONSOLIDATED STATEMENTS OF INCOME | |||
Fiscal Year Ended | |||
FY 2022 | FY 2021 | FY 2020 | |
1/28/2023 | 1/29/2022 | 1/30/2021 | |
Net sales | 12,368,198 | 12,293,368 | 9,584,019 |
Cost of goods sold, including occupancy and distribution costs | 8,083,640 | 7,581,482 | 6,533,312 |
GROSS PROFIT | 4,284,558 | 4,711,886 | 3,050,707 |
Selling, general and administrative expenses | 2,805,462 | 2,664,083 | 2,298,534 |
Pre-opening expenses | 16,077 | 13,300 | 10,696 |
INCOME FROM OPERATIONS | 1,463,019 | 2,034,503 | 741,477 |
Interest expense | 95,220 | 57,839 | 48,812 |
Other income | (15,949) | (17,774) | (19,070) |
INCOME BEFORE INCOME TAXES | 1,383,748 | 1,994,438 | 711,735 |
Provision for income taxes | 340,610 | 474,567 | 181,484 |
NET INCOME | 1,043,138 | 1,519,871 | 530,251 |
CONSOLIDATED BALANCE SHEETS | |||
FY 2022 | FY 2021 | FY 2020 | |
1/28/2023 | 1/29/2022 | 1/30/2021 | |
ASSETS | |||
CURRENT ASSETS: | |||
Cash and cash equivalents | 1,924,386 | 2,643,205 | 1,658,067 |
Accounts receivable, net | 71,286 | 68,263 | 53,149 |
Income taxes receivable | 8,187 | 1,978 | 6,396 |
Inventories, net | 2,830,917 | 2,297,609 | 1,953,568 |
Prepaid expenses and other current assets | 128,410 | 95,601 | 88,470 |
Total current assets | 4,963,186 | 5,106,656 | 3,759,650 |
Property and equipment, net | 1,312,988 | 1,319,681 | 1,300,265 |
Operating lease assets | 2,138,366 | 2,044,819 | 2,149,913 |
Intangible assets, net | 60,364 | 86,767 | 90,051 |
Goodwill | 245,857 | 245,857 | 245,857 |
Deferred income taxes | 41,189 | 35,024 | 51,475 |
Other assets | 230,246 | 202,872 | 155,648 |
TOTAL ASSETS | 8,992,196 | 9,041,676 | 7,752,859 |
LIABILITIES AND STOCKHOLDERS' EQUITY | |||
CURRENT LIABILITIES: | |||
Accounts payable | 1,206,066 | 1,281,322 | 1,258,093 |
Accrued expenses | 508,573 | 620,143 | 518,134 |
Operating lease liabilities | 546,755 | 480,318 | 472,670 |
Income taxes payable | 29,624 | 13,464 | 40,997 |
Deferred revenue and other liabilities | 350,428 | 317,433 | 260,304 |
Total current liabilities | 2,641,446 | 2,712,680 | 2,550,198 |
LONG-TERM LIABILITIES: | |||
Revolving credit borrowings | — | — | — |
Senior notes due 2032 and 2052 | 1,482,336 | 1,481,443 | — |
Convertible senior notes due 2025 | 58,271 | 449,287 | 418,493 |
Long-term operating lease liabilities | 2,117,773 | 2,099,146 | 2,259,308 |
Other long-term liabilities | 167,747 | 197,534 | 185,326 |
Total long-term liabilities | 3,826,127 | 4,227,410 | 2,863,127 |
Additional paid-in capital | 1,416,847 | 1,488,834 | 1,442,298 |
Retained earnings | 4,878,404 | 3,956,602 | 3,064,702 |
Accumulated other comprehensive loss | (252) | (82) | (49) |
Treasury stock, at cost; 69,630,710 and 63,269,166 shares at January 28, 2023 and January 29, 2022, respectively, and 52,481,010 shares at January 29, 2022 and January 30, 2021, respectively | (3,771,197) | (3,344,524) | (2,168,266) |
Total stockholders' equity | 2,524,623 | 2,101,586 | 2,339,534 |
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY | 8,992,196 | 9,041,676 | 7,752,859 |
Related Book For
Financial Management Theory And Practice
ISBN: 978-0176583057
3rd Canadian Edition
Authors: Eugene Brigham, Michael Ehrhardt, Jerome Gessaroli, Richard Nason
Posted Date: