Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Dollar Values Year 2 Year 1 Balance Sheet Accounts 11/3/2023 10/28/2022 Asset Accounts Current Assests Cash and cash equivalents $ 1,210,000,000 $ 3,192,000,000 Short-term investments
Dollar Values | ||
Year 2 | Year 1 | |
Balance Sheet Accounts | 11/3/2023 | 10/28/2022 |
Asset Accounts | ||
Current Assests | ||
Cash and cash equivalents | $ 1,210,000,000 | $ 3,192,000,000 |
Short-term investments | $ 321,000,000 | $ 464,000,000 |
Merchandise inventory net | $ 17,530,000,000 | $ 19,817,000,000 |
Other current assets | $ 907,000,000 | $ 1,518,000,000 |
Total current assests | $ 19,968,000,000 | $ 24,991,000,000 |
Property, less accumulated depreciation | $ 17,527,000,000 | $ 17,275,000,000 |
Operating lease right-of-use assets | $ 3,647,000,000 | $ 3,512,000,000 |
Long-term investments | $ 238,000,000 | $ 63,000,000 |
Deferred income taxes net | $ 280,000,000 | $ 301,000,000 |
Other assets | $ 859,000,000 | 831,000,000 |
Total assests | $ 42,519,000,000 | $ 46,973,000,000.00 |
Liabilities, Debt, and Equity Accounts | ||
Current Liabilities | ||
Short-term borrowings | $ - | $ - |
Current maturities of long-term debt | $ 544,000,000 | $ 609,000,000 |
Current operating lease liabilities | $ 533,000,000 | $ 651,000,000 |
Accounts payable | $ 9,914,000,000 | $ 12,249,000,000 |
Accrued compensation and employee benefits | $ 750,000,000 | $ 1,405,000,000 |
Deferred revenue | $ 1,499,000,000 | $ 1,736,000,000 |
Income taxes payable | $ 121,000,000 | 913,000,000 |
Other current liabilities | $ 3,135,000,000 | 3,313,000,000 |
Total current liabilities | $ 16,496,000,000 | $ 20,876,000,000 |
Long-term debt, excluding current maturities | $ 35,374,000,000 | $ 32,904,000,000 |
Noncurrent operating lease liabilities | $ 3,602,000,000 | $ 4,048,000,000 |
Deferred revenue Lowe's protection plans | $ 1,228,000,000 | $ 1,184,000,000 |
Other liabilities | $ 966,000,000 | $ 829,000,000 |
Total Liabilities | $ 57,666,000,000 | $ 59,841,000,000 |
Year 2 | Year 1 | |
Income Statement Line Items | 11/3/2023 | 10/28/2022 |
Current Earnings | ||
Net sales | $ 20,471,000,000 | $ 23,479,000,000 |
Cost of sales | $ 13,580,000,000 | $ 15,661,000,000 |
Gross Margin | $ 6,891,000,000 | $ 7,818,000,000 |
Expenses: | ||
Selling, general and administrative | $ 3,761,000,000 | $ 6,443,000,000 |
Depreciation and amortization | $ 434,000,000 | 451,000,000 |
Operating Income | $ 2,696,000,000 | $ 924,000,000 |
Interest net | $ (345,000,000) | $ (295,000,000) |
Pre-tax earnings | $ 2,351,000,000 | $ 629,000,000 |
Income tax provision | $ 578,000,000 | 475,000,000 |
Net earnings | $ 1,773,000,000 | $ 154,000,000 |
From the given data please calculate following ratio for both years and how their affect;
Current Ratio |
Days Cash on Hand |
Net Profit Margin |
Days in Accounts Receivables |
Operating Profit Margin |
Debt to Equity |
Net Profit Margin |
Return on Assets |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started