Question: Arrange a solvency analysis by computing and using the appropriate ratios to assess solvency.Compute a minimum of three ratios and show supporting calculations. Analyze the
Arrange a solvency analysis by computing and using the appropriate ratios to assess solvency.Compute a minimum of three ratios and show supporting calculations. Analyze the ratios computed and discuss any insights or conclusions that can be drawn from the analysis. arrange a profitability analysis by computing and using the appropriate ratios to assess profitability.
DOLLAR TREE, INC. CONDENSED CONSOLIDATED BALANCE SHEETS (Unaudited) [in millions) April 29, 2023 January 28, 2023 April 30, 2022 ASSETS Current assets: Cash and cash equivalents 8728 S 642.8 $ 1,218.5 Merchandise inventories 5,112.0 5,449.3 1,801.1 Other current assets 282.8 275.0 262.7 Total current assets 6 267.6 6.367.1 6 282.3 Property, plant and equipment, net of accumulated depreciation of $6, 176.4, $6,025.4 and $5,525.9, respectively 5,1018 4,972.2 4,514.0 Restricted cash 69.2 68.5 53.4 Operating lease right-of-use assets 6,503.4 6,458.0 6,364.9 Goodwill 1,982.6 1.983.1 1,984.3 Trade name intangible asset 3,100.0 3,100.0 3,100.0 Deferred tax asset 13.9 15.0 19.3 Other assets 60.1 54.1 Total assets 23,108.6 23,022.1 $ 22,372.3 LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of operating lease liabilities S 1,456.9 $ 1,4496 $ 1,406.7 Accounts payable 1.597.6 1.899.8 1,794.1 Income taxes payable 144.1 58.1 162.8 Other current liabilities 942.9 817.7 26.3 Total current liabilities 4,141.5 4.225.2 1,289.9 Long-term debt, ne 3,422.7 3,421.6 3,418.1 Operating lease liabilities, long-term 5,269.0 5,255.3 5,087.9 Deferred income taxes, net 1,1078 1,105.7 1,060.7 Income taxes payable, long-term 17.6 17.4 21.2 Other liabilities 250.3 245.4 253.0 Total liabilities 14,208.9 14,270.6 14,130.8 Commitments and contingencies (Note 2) Shareholders' equily: Common stock, par value $0.01: 600,000,000 shares authorized, 220,648,374, 221,222,984 and 225,568,429 shares issued and outstanding, respectively 2.2 2.2 2.2 Additional paid-in capital $19.5 667.5 1,230.6 Accumulated other comprehensive loss (44.0) (41.2) (35.3) Retained earnings 8,422.0 8,123.0 7,044.0 Total shareholders' equity 8,8997 8,751.5 8,241.5 Total liabilities and shareholders' equity 23,108.6 $ 23,022.1 22,372.3 See accompanying Notes to Unaudited Condensed Consolidated Financial Statements.DOLLAR TREE, INC. CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS (Unaudited) 13 Weeks Ended in millions) April 29, 2023 April 30, 2072 Cash flows from operating activities: Net income 5 2990 $ 536.4 Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization 196.4 188.9 Provision for deferred income taxes 3.0 74.3 Stock-based compensation expense 28.3 35.8 Amortization of debt discount and debt-issuance costs 1.2 1.1 Other non-cash adjustments to net income 35.1 15.7 Changes in operating assets and liabilities: Merchandise inventories 335.9 (434.1) Other current assets (7.9) (5.7) Other assets (1.8) (23) Accounts payable (90.1) income taxes payable 86.0 80.2 Other current liabilities 1045 147.6 Other liabilities 5.2 (29) Operating lease right-of-use assets and liabilities, net 31.1) (6.4) Net cash provided by operating activities 752.0 538.5 Cash flows from investing activities: Capital expenditures (350.4) (253.4) Payments for fixed asset disposition (2.3) (29) Net cash used in investing activities 352.7) (256 3) Cash flows from financing activities: Proceeds from stock issued pursuant to stock-based compensation plans 29 2.9 Cash paid for taxes on exercises/vesting of stock-based compensation (27.1) (37.8) Payments for repurchase of stock (143.4) (142) Net cash used in financing activities (167.6) (49.1) Effect of exchange rate changes on cash, cash equivalents and restricted cash (1.0) 0.5 Net increase in cash, cash equivalents and restricted cash 230.7 233.6 Cash, cash equivalents and restricted cash at beginning of period 711.3 1.038.3 Cash, cash equivalents and restricted cash at end of period 942.0 1,271.9 Supplemental disclosure of cash flow information: Cash paid for: Interest, net of amounts capitalized S S Income taxes 66 Non-cash transactions: Right-of use assets obtained in exchange for new operating lease liabilities 416.8 5 297.3 Accrued capital expenditures 45.2 See accompanying Notes to Unaudited Condensed Consolidated Financial Statements.DOLLAR TREE, INC. CONDENSED CONSOLIDATED STATEMENTS OF SHAREHOLDERS' EQUITY (Unaudited) 13 Weeks Ended April 29, 2023 Accumulated Common Additional Other Stock Common Paid-in Comprehensive Retained Shareholders (in millions) Shares Stock Capital Loss Earnings Equity Balance al January 28, 2023 221.2 2.2 S 667.5 (41.2) 8,123.0 8,751.5 Net income 299.0 299.0 Total other comprehensive loss (2.8) (2.8) Issuance of stock under Employee Stock Purchase Plan 2.4 2.9 Exercise of stock options 0.1 0.1 Stock-based compensation, net 0.4 1.1 1.1 Repurchase of stock (1.0) (152.1) (152.1) Balance at April 29, 2023 220.6 $ 2.2 519.5 $ (44.0) 8,422.0 8,8997 13 Weeks Ended April 30, 2022 Accumulated Common Additional Other Stock Common Paid-in Comprehensive Retained Shareholders' (in millions] Shares Stock Capital Loss Earnings Equity Balance al January 29, 2022 225.1 S 2.2 1.243.9 (35.2) 6,507.6 7,718.5 Net income 536.4 536.4 Total other comprehensive loss (0. 1 (0.1) Issuance of stock under Employee Stock Purchase Plan 2.9 Stock-based compensation, net 0.5 (2.0) (2.0) Repurchase of stock 0.1) (14.2) (14.2) Balance al April 30, 2022 225.5 2.2 1,230.6 $ (35.3 $ 7,044.0 8,241.5 See accompanying Notes to Unaudited Condensed Consolidated Financial Statements. 7Operating Income 13 Weeks Ended (dollars in millions) April 29, 2023 April 30, 2022 Percentage Change Operating income 419.7 731.5 (42.6) % Operating income margin 5.7% 10.6% (4.9) % Operating income margin decreased to 5.7% for the 13 weeks ended April 29, 2023 compared to 10.6% for the same period last year, resulting from the decrease in gross profit margin and the increase in the selling, general and administrative expense rate, as described above. Interest Expense, Net 13 Weeks Ended (dollars in millions) April 29, 2023 April 30, 2022 Percentage Change Interest expense, net 25.9 (23.8) Interest expense, net decreased $8.1 million in the 13 weeks ended April 29, 2023 compared to the same period last year, resulting from higher interest income on investments. Provision for Income Taxes 13 Weeks Ended dollars in millions April 29, 202 April 30, 2022 Percentage Change Provision for income taxes 94.7 161.1 (41.2) % Effective tax rate 24.1 % 23.1% 10 % The effective tax rate was 24.1% for the 13 weeks ended April 29, 2023 compared to 23.1% for the comparable prior year period, resulting from lower stock-based compensation deductions and higher non-deductible expenses, offset partially by higher Work Opportunity Tax credits as a percentage of pre-lax income in the current year. Segment Information Our operating results for the Dollar Tree and Family Dollar segments and period over-period changes are discussed in the following sections. Dollar Tree The following table summarizes the operating results of the Dollar Tree segment: 13 Weeks Ended (dollars in millions) April 29, 2023 April 30, 2022 Percentage Change Net sales 3,931.7 3,781.8 4.0 % Gross profil 1.386.6 1.534.7 (9.5)1% Gross profit margin 35.3% 40.6% (5.3)% Operating income 535.7 764.2 (29.9)% Operating income margin 13.6% 20.2% (6.6) % Net sales for the Dollar Tree segment increased $149.9 million, or 4.0%, for the 13 weeks ended April 29, 2023 compared to the same period last year. The increase was due to an increase in comparable store net sales of 3.4% and $90.7 million of non-comparable store sales. Customer traffic increased 5.5% and average ticket decreased 2.1%. 19
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Students Have Also Explored These Related Accounting Questions!