I need help with 4, 5 and 6 **Selected Hypothetical Financial Data of Target and Wal-Mart for 2022***Presented in millions.*### Target Corporation#### Income Statement Data for Year- **Net sales:** $66,100- **Cost of goods sold:** 44,000- **Selling and administrative expenses:** 15,400- **Interest expense:** 660- **Other income (expense):** (70)- **Income tax expense:** 1,400- **Net income:** $4,570### Balance Sheet Data (End of Year)- **Current assets:** $17,000- **Noncurrent assets:** 26,800- **Total assets:** $43,800- **Current liabilities:** $12,000- **Long-term debt:** 17,600- **Total stockholders’ equity:** 14,200- **Total liabilities and stockholders’ equity:** $43,800### Beginning-of-Year Balances- **Total assets:** $43,000- **Total stockholders’ equity:** 14,400- **Current liabilities:** 10,600- **Total liabilities:** 28,600---### Wal-Mart Stores, Inc.#### Income Statement Data for Year- **Net sales:** $411,000- **Cost of goods sold:** 302,000- **Selling and administrative expenses:** 81,000- **Interest expense:** 2,100- **Other income (expense):** (420)- **Income tax expense:** 7,300- **Net income:** $18,180### Balance Sheet Data (End of Year)- **Current assets:** $49,000- **Noncurrent assets:** 120,000- **Total assets:** $169,000- **Current liabilities:** $54,000- **Long-term debt:** 45,000- **Total stockholders’ equity:** 70,000- **Total liabilities and stockholders’ equity:** $169,000### Beginning-of-Year Balances- **Total assets:** $162,000- **Total stockholders’ equity:** 66,000- **Current liabilities:** 57,000- **Total liabilities:** 96,000**Graphs and Diagrams:**There are no graphs or diagrams included in this data presentation. The information is presented in ### Financial Ratio Analysis**Other Data**| Metric | Target ($ in millions) | Wal-Mart ($ in millions) ||-----------------------------------------|-----------------------:|-------------------------:|| Average net accounts receivable | 7,900 | 4,200 || Average inventory | 7,200 | 33,700 || Net cash provided by operating activities| 5,800 | 26,200 || Capital expenditures | 1,700 | 12,400 || Dividends | 460 | 3,600 |### Compute the Following Ratios:*(Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.)*#### Ratio Computations for Target and Wal-Mart1. **Current Ratio** - Target: _______ :1 - Wal-Mart: _______ :12. **Accounts Receivable Turnover** - Target: _______ times - Wal-Mart: _______ times3. **Average Collection Period** - Target: _______ days - Wal-Mart: _______ days4. **Inventory Turnover** - Target: _______ times - Wal-Mart: _______ times5. **Days in Inventory** - Target: _______ days - Wal-Mart: _______ days6. **Profit Margin** - Target: _______ % - Wal-Mart: _______ %7. **Asset Turnover** - Target: _______ times - Wal-Mart: _______ times8. **Return on Assets** - Target: _______ % - Wal-Mart: _______ %9. **Return on Common Stockholders' Equity** - Target: _______ % - Wal-Mart: _______ %10. **Debt to Assets Ratio** - Target: _______ % - Wal-Mart: _______ %11. **Times Interest Earned** - Target: _______ times - Wal-Mart: _______ times12. **Free Cash Flow** - Target: $_______ - Wal-Mart: $_______Complete these ratios using

Other Data Average net accounts receivable $7,900 $4,200 Average inventory 7,200 33,700 Net cash provided by operating activities 5,800 26,200 Capital expenditures 1,700 12,400 Dividends 460 3,600 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to O decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio :1 :1 (2) Accounts receivable turnover times times (3) Average collection period days days (4) Inventory turnover times times (5) Days in inventory days days (6) Profit margin % (7) Asset turnover times times

Other Data Average net accounts receivable $7,900 $4,200 Average inventory 7,200 33,700 Net cash provided by operating activities 5,800 26,200 Capital expenditures 1,700 12,400 Dividends 460 3,600 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to O decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio :1 :1 (2) Accounts receivable turnover times times (3) Average collection period days days (4) Inventory turnover times times (5) Days in inventory days days (6) Profit margin % (7) Asset turnover times times

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please answer 4a above
I have no idea what B5, B2, B3, B6 means. Can you explain how you got those numbers? With an equation???
need help with T account balance. How do you total T accounts?
please help me to answer 8, 9, 10 and 11.
Need help for part C an D
I just need questions 6 and 12 answer.
6
You didnt answer the question 4, 5 , 6
How did you get those numbers?
when i type in the same formula for cell B7 i get a different answer 101,000 why are our answers different?
Is there a way you can provide an example for number 3?
What about requirement 4+5