Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

from the following data of balance sheet and income statement of lows, calculate and compare 8 ratios of year one and two and complete Cash

from the following data of balance sheet and income statement of lows, calculate and compare 8 ratios of year one and two and complete Cash Flow Statement Ratios and answer questions, also compare with industry average

Cash Flow Statement Ratios

Year 2 Year 1
CFO / Revenue =
CFO / Operating Income =
CFO / Total Assets =
CFO / Total Equity =
CFO / Total Debt =

1. In general terms, what do these ratios & ratios like these tell you?

2. In general, would you like these ratios to be higher or lower? Why?

3. Compute these ratios for Years 1 & 2 in the columns above:

4. Trend Analysis: In general terms, did the ratios generally get better or worse?

5. Industry Analysis: Why would it be valuable to evaluate how a firms CFO ratios (such as the ones above) compare with the industry averages for the ratios?

6. What are some risks or concerns if these ratios are TOO LOW?

7. What are some actions that could INCREASE these ratios?

8. What are some risks or concerns if these ratios are TOO HIGH?

9. What are some actions that could DECREASE these ratios?

10. Why would these ratios be commonly considered as key ratios at your organization, and in organizations in general?

11. What actions and/or decisions (if any) in your operational area/unit could influence these ratios?

Balance sheet

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
Liabilities, Debt, and Equity Accounts
Current Liabilities
Short-term borrowings 0 0
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

----------------------------------------------------------------------------------------------------

Income statement

Dollar Values
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 578000000

475,000,000

Net earnings 1,773,000,000 154,000,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To answer the questions and calculate the cash flow statement ratios we need to use the provided data from the balance sheet and income statement Lets go through each question and perform the necessar... 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

Step: 3

blur-text-image

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

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408066621, 1408066629, 1408076861, 978-1408076866

More Books

Students also viewed these Accounting questions