Question

P2-50. Compare Cash Flows Across Retailers Following are selected accounts from the income statement and the statement of cas

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Particulars Macy's Home Depot Best Buy Target Walmart Stores
Net Income (a)     1,108.00         11,121.00     1,464.00     2,937.00                6,670.00
Sales (b) 25,739.00       108,203.00 42,879.00 75,356.00            511,729.00
Net Income Ratio(c=(a/b)x100) 4.30% 10.28% 3.41% 3.90% 1.30%
Rank based on "c" 2 1 4 3 5
Cash flow from operating (d)     1,735.00         13,038.00     2,408.00     5,973.00              27,753.00
Cash flow from operating to Sales(e=(d/b)x100) 6.74% 12.05% 5.62% 7.93% 5.42%
Rank based on "e" 3 1 4 2 5
Cash flow from Investing (f)      (456.00)          (2,416.00)        508.00 (3,416.00)            (24,036.00)
Cash flow from investing to Sales(g=(f/b)x100) -1.77% -2.23% 1.18% -4.53% -4.70%
Rank based on "g" 2 3 1 4 5

based on ranking of net income to sales retailer Home depot showing a very good performance (it might be because of any abnormal activity or non operating income like profit on sale of fixed asset) retailer walmart stores showing very bad performance (it might be because of any non operating activites like loss on sale of fixed asset) and other 3 retailers showing an average of 3-4 percentage

Based on ranking of oerating cashflow macy and target rank changed while comparing with net income ranking

Add a comment
Know the answer?
Add Answer to:
P2-50. Compare Cash Flows Across Retailers Following are selected accounts from the income statement and the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • P2-41. Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for...

    P2-41. Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies in different industries. Cost of Goods Sold Gross Profit Net Income $ millions Sales Assets Liabilities Target Corp............. Nike Inc. .............. Harley-Davidson ...... Cisco Systems ........... $73,785 32,376 5,995 49,247 $51,997 17,405 3,620 18,287 $21,788 14,971 2,375 30,960 $3,363 3,760 752 10,739 $ 40,262 21,396 9,991 121,652 $27,305 9,138 8,151 58,067 Stockholders' Equity $12,957 12,258 1,840 63,585 Required a. Compute the following ratios...

  • Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies...

    Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies in different industries. $ millions Sales Net Income Assets Liabilities Cost of Goods Sold $53,299 20,441 Stockholders' Equity $11,297 9,812 $75,356 36,397 $2,937 1,933 $41,290 22,536 $29,993 12,724 Target Corp. Nike, Inc. Harley- Davidson 531 5,717 53,647 3,352 11,248 10,666 159,422 8,892 95,664 1,774 63,758 Pfizer 11,188 (a) Compute the following ratios for each company. • Round all answers to one decimal place (percentage...

  • Compare the quality of cash flows from three major retailers Walmart (WMT) Amazon (AMZN) and eBay...

    Compare the quality of cash flows from three major retailers Walmart (WMT) Amazon (AMZN) and eBay (EBAY) for 2013, 2014 and 2015. Go to one of the financial databases to recover the information on net income and operating cash flows. Use the ratio for Quality of Income = cash flows from operating activities / Net Income. Submit a table that completes the following. Rank each for the trends in the quality of income ratio. Which firm does the best at...

  • Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at...

    Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at December 31 of 2016 and 2015 are shown below: ce WOLFF COMPANY Income Statement For the Year Ended December 31, 2016 Sales Revenue $645,000 Cost of Goods Sold $430,000 Wages Expense 86,000 Insurance Expense 12,000 Depreciation Expense 13,000 Interest Expense 12,000 Income Tax Expense 29,000 582,000 Net Income $63,000 We were unable to transcribe this imageRequired a. Calculate the change in cash that occurred...

  • The following selected data are from a recent statement of cash flows: Net cash flow from...

    The following selected data are from a recent statement of cash flows: Net cash flow from operating activities $ 35,000 Net cash flow used for investing activities (20,000) Net cash flow used for financing activities 60,000 Ending cash balance 50,000 What is the net change in cash for the period? a.$125,000 b.$(75,000) c.$115,000 d.$75,000

  • Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at...

    Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at December 31 of 2013 .. and 2012 are shown below: WOLFF COMPANY Income Statement For the Year Ended December 31, 2013 Sales Revenue $762,000 Cost of Goods Sold $516,000 Wages Expense 103,200 Insurance Expense 9,600 Depreciation Expense 20,400 Interest Expense 10,800 Income Tax Expense 34,800 694,800 Net Income $67,200 WOLFF COMPANY Balance Sheets Dec. 31, 2013 Dec. 31, 2012 Assets Cash $13,200 $6,000 Accounts...

  • Compute Ratios from Statement of Cash Flow Information Use the following information, taken from each of...

    Compute Ratios from Statement of Cash Flow Information Use the following information, taken from each of the company's 2018 financial statements to complete the requirements. Cash from Current Company Operations Liabilities CAPEX Arconic Inc. $217 $3,520 $768 Carmax Inc. 163 1,312 305 Flowserve Corp. 191 1,081 84 Fluor Corp. 162 3,553 211 a. Compute the operating cash flow to current liabilities ratio for each company. b. Rank-order each company from low to high liquidity (ability to pay liabilities as they...

  • Required: Discuss the relations between net income and cash flow from operations and among cash flows...

    Required: Discuss the relations between net income and cash flow from operations and among cash flows from operating, investing, and financing activities for the firm over the three year period. Identify characteristics of coca cola's cash flows that you would expect for a mature company. Cash flow from operations Cash flow from investing Cash flow from financing One of these firms is eBay, an (3,491) 1,657 (1,654) online retailer with a three-year growth in sales of 3373%, and other is...

  • Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 The following financial...

    Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 104,500 $ 49,000 Accounts receivable, net 72,500 56,000 Inventory 68,800 94,000 Prepaid expenses 4,900 6,400 Total current assets 250,700 205,400 Equipment 129,000 120,000 Accum. depreciation—Equipment (29,500 ) (11,500 ) Total assets $ 350,200 $ 313,900 Liabilities and Equity Accounts payable $ 30,000 $...

  • The following information is taken from the operating section of the statement of cash flows (direct...

    The following information is taken from the operating section of the statement of cash flows (direct method) of Battery Builders, Inc.: Collections from customers Payments to suppliers for purchases Payments for operating expenses Payments for income taxes Cash provided by operating activities $ 28,000 (13,000) (9,000) (4,000) 2,000 The following information is obtained from the income statement of Battery Builders: Net income Depreciation expense Gain on sale of equipment Write-off of intangibles $ 4,000 4,000 2,000 1,000 In addition, the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT