Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Worksheet Financial Statement Ratios. Lowe's Companies, Inc Jan 28, 2022 and Jan. 29, 2021 Current Ratio Current Assets / Current Liabilities Acid Test Current

Worksheet Financial Statement Ratios. Lowe's Companies, Inc Jan 28, 2022 and Jan. 29, 2021 Current Ratio Current Assets / Current Liabilities Acid Test Current Assets Current Liabilities (Cash + ST Investments + Current Receivables)/Current Liabilities Cash ST Investments Trade Receivables Current Liabilities Debt Ratio Total Liabilities/Total Assets Total Liabilities Total Assets Equity Ratio Total Equity/Total Assets Total Equity Total Assets Debt to Equity Ratio Total Liabilities/Total Equity Total Liabilities Total Equity Profit Margin Net Income/Net Sales Net Income Net Sales: Earnings per Share (from Net Income/weighted average # of the income statement) shares outstanding Price-Earnings Ratio Net Income Weighted average # of shares outstanding Market price per common share/Earnings per share Market price ovalable online Market price per common share Earnings per share Jan. 29, 2022 Jan. 29, 2021 Answer format: Round decimal to two places und decimal to two pes Answer as percentage with two decimal places decimal places Answer as percentage with two decimal places Answer as percentage with tw decimal places Provide date of your market price Lowes Companies Inc Consolidated Statements of Cash Flows - USD ($) $ in Millions Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash Depreciation and amortization Noncash lease expense 12 Months Ended Jan. 28, 2022 Jan. 29, 2021 Jan. 31, 2020 $8,442 $5,835 $4,281 1,882 1,594 1,410 517 479 468 Deferred income taxes 135 (108) 177 Loss on property and other assets - net 34 139 117 Loss on extinguishment of debt Share-based payment expense 0 1,060 0 230 155 98 Changes in operating assets and liabilities: Merchandise inventory-net Other operating assets (1,413) (2,967) (600) (23) 326 (364) Accounts payable 466 3,211 (637) Deferred revenue 413 512 (15) Other operating liabilities (570) 813 (639) Net cash provided by operating activities 10,113 11,049 4,296 Cash flows from investing activities: Purchases of investments (3,065) (3,094) (743) Proceeds from sale/maturity of investments 3,293 2,926 695 Capital expenditures (1,853) (1,791) (1,484) Proceeds from sale of property and other long-term 113 90 163 Other net (134) (25) 0 Net cash used in investing activities (1,646) (1,894) Cash flows from financing activities: Net change in commercial paper 0 Net proceeds from issuance of debt 4,972 (941) 7,929 Repayment of debt (2,118) (5,618) Proceeds from issuance of common stock under share- 132 Cash dividend payments Repurchases of common stock Other net Net cash used in financing activities (1,984) (13,012) (1,704) (4,971) 152 (1,369) 220 3,972 (1,113) (1,618) (4,313) 118. (6) (12,016) (38) (5,191) (1) (2,735) Effect of exchange rate changes on cash Net (decrease)/increase in cash and cash equivalents, including cash classified within current assets held for Less: Net decrease in cash classified within current Net (decrease)/increase in cash and cash equivalents Cash and cash equivalents, beginning of year (3,557) (8) 10 1 3,974 193 0 12 (3,557) 3,974 205 4,690 716 511 Lowes Companies Inc Consolidated Balance Sheets- USD ($) $ in Millions Jan. 28, 2022 Jan. 29, 2021 Current assets: Cash and cash equivalents Short-term investments $1,133 271 $ 4,690 506 Merchandise inventory - net 17,605 16,193 Other current assets 1,051 937 Total current assets 20,060 22,326 Property, less accumulated depreciation 19,071 19,155 Operating lease right-of-use assets 4,108 3,832 Long-term investments 199 200 Deferred Income taxes - net 164 340 Other assets 1,038 882 Total assets 44,640 46,735 Current liabilities: Current maturities of long-term debt 868 1,112 Current operating lease liabilities 636 541 Accounts payable 11,354 10,884 Accrued compensation and employee benefits 1,561 1,350 Deferred revenue 1,914 1,608 Other current liabilities 3,335 3,235 Total current liabilities 19,668 18,730 Long-term debt, excluding current maturities 23,859 20,668 Noncurrent operating lease liabilities 4,021 3,890 Deferred revenue-Lowe's protection plans 1,127 1,019 Other liabilities 781 991 Total liabilities 49,456 45,298 Commitments and contingencies Shareholders' (deficit)/equity: Preferred stock-$5 par value: Authorized-5.0 million shares; Issued Common stock $0.50 par value: Authorized-5.6 billion shares; Issued and outstanding-670 million and 731 million, respectively Capital in excess of par value (Accumulated deficit)/retained earnings Accumulated other comprehensive loss Total shareholders' (deficit)/equity Total liabilities and shareholders' (deficit)/equity 0 335 366 0 90 (5,115) 1,117 (36) (136) (4,816) 1,437 $44,640 $ 46,735 Lowes Companies Inc Consolidated Statements of Earnings - USD ($) $ in 12 Months Ended Millions Jan. 28, 2022 Jan. 29, 2021 Jan. 31, 2020 Current Earnings Net sales Cost of sales $ 96,250 $89,597 $ 72,148 64,194 60,025 49,205 Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt Pre-tax earnings 32,056 29,572 22,943 18,301 18,526 15,367 1,662 1,399 1,262 12,093 9,647 6,314 885 848 691 0 1,060 0 11,208 7,739 5,623 Income tax provision 2,766 1,904 1,342 Net earnings $8,442 $5,835 $4,281 Basic earnings per common share (in dollars per $12.07 $7.77 $5.49 Diluted earnings per common share (in dollars per $12.04 $7.75 $5.49 Current Earnings (Percentages) Net sales 100.00% 100.00% 100.00% Cost of sales 66.70% 66.99% 68.20% Gross margin 33.30% 33.01% 31.80% Expenses (Percentages) Selling, general and administrative 19.01% 20.68% 21.30% Depreciation and amortization 1.73% 1.56% 1.75% Operating income 12.56% 10.77% 8.75% Interest-net 0.92% 0.95% 0.96% Loss on extinguishment of debt 0.00% 1.18% 0.00% Pre-tax earnings 11.64 % 8.64% 7.79% Income tax provision 2.87% 2.13% 1.86% Net earnings 8.77% 6.51% 5.93%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Here are the calculations for the financial statement ratios for Lowes Companies Inc for Jan 28 2022 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

16th Edition

0357517571, 978-0357517574

More Books

Students also viewed these Accounting questions

Question

In what situation does gravity do work on an object?

Answered: 1 week ago

Question

Discuss the use of third-wave therapies in psychotherapy practice.

Answered: 1 week ago