Selected hypothetical financial data of Target and Walmart for 2022 are presentedhere (in millions). Target Corporation...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Selected hypothetical financial data of Target and Walmart for 2022 are presentedhere (in millions). Target Corporation Income Statement Data for Year $406,000 306,000 76,000 2.200 (390) 6,500 $14,910 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets $65.000 46.000 14,800 660 (70) 1.300 $2,170 Walmart Inc. Balance Sheet Data (End of Year) $49,000 123.000 $19.000 26,100 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Average net accounts receivable Average inventory $45,100 $12,000 17.400 15,700 $45.100 $45.000 12.900 10.300 Beginning-of-Year Balances $162,000 32.100 $172,000 $8.000 Other Data 6,800 $55,000 43,000 74,000 $172,000 66,000 57,000 96,000 $3,800 33,200 Net cash provided by operating activities Capital expenditures Cash dividends paid 5,900 1,700 510 27.400 11.600 4,200 For each company.compute the following ratios. Assume all sales were on credit. (Round current ratio to 2 decimal places eg. 1.85 and free cash flow to 0 decimal places and all other answers to 1 decimol place, e.g. 1.8 or 1.8%) (1) (2) Ratio Current ratio Accounts receivable turnover Target 1 times Walmart times (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio. Times interest earned i Free cash flow days times days % times * times days times days 96 times 56 times Selected hypothetical financial data of Target and Walmart for 2022 are presentedhere (in millions). Target Corporation Income Statement Data for Year $406,000 306,000 76,000 2.200 (390) 6,500 $14,910 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets $65.000 46.000 14,800 660 (70) 1.300 $2,170 Walmart Inc. Balance Sheet Data (End of Year) $49,000 123.000 $19.000 26,100 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Average net accounts receivable Average inventory $45,100 $12,000 17.400 15,700 $45.100 $45.000 12.900 10.300 Beginning-of-Year Balances $162,000 32.100 $172,000 $8.000 Other Data 6,800 $55,000 43,000 74,000 $172,000 66,000 57,000 96,000 $3,800 33,200 Net cash provided by operating activities Capital expenditures Cash dividends paid 5,900 1,700 510 27.400 11.600 4,200 For each company.compute the following ratios. Assume all sales were on credit. (Round current ratio to 2 decimal places eg. 1.85 and free cash flow to 0 decimal places and all other answers to 1 decimol place, e.g. 1.8 or 1.8%) (1) (2) Ratio Current ratio Accounts receivable turnover Target 1 times Walmart times (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio. Times interest earned i Free cash flow days times days % times * times days times days 96 times 56 times
Expert Answer:
Related Book For
Financial Reporting and Analysis
ISBN: 978-1259722653
7th edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these accounting questions
-
Figure 8.36 shows a contour map of a hill with two paths, A and B. (a) On which path, A or B, will you have to climb more steeply? (b) On which path, A or B, will you probably have a better view of...
-
Selected financial data of Target and Wal-Mart Stores, Inc. for a recent year are presented here (in millions). Instructions (a) For each company, compute the following ratios. (1) Current. (2)...
-
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Instructions a. For each company, compute the following ratios. 1. Current ratio. 2. Accounts...
-
: Transcellular fluid is Specialized type of intercellular fluid O Found in confined space O includes fluid in synovial C 2+3 None of the following O
-
Sunshine Enterprises included the following statement in its 2012 financial report: Required(a) Convert each of the accrual-basis income statement accounts to a cash basis. Would you classify this...
-
Would it help to place the section where each processor prints "Hello World" in Fig. 12.2 in the critical section? If so why and if not, why not?
-
Describe the six categories of early warning signs of potential fraud.
-
Chamberline Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. Required a. Explain the effect on...
-
Why socialism or communism doesn't work in Russia but does in China? as in other countries that we see today. What do you think was the cause of the end of socialism or communism?
-
One thousand kilomoles per hour of rich gas at 70F with 25% C1, 15% C2,25% C3, 20% nC4, and 15% nC5 by moles is to be absorbed by 500 kmol/h of nC10 at 90F in an absorber operating at 4 atm....
-
Requirement 2. For each asset, determine the book value as of December 31, 2018. Then, calculate the depreciation expense for the first six months of 2019 and the book value as of June 30, 2019....
-
A taxpayer uses a vehicle for his sole proprietorship. He purchased the vehicle for $35,000 in Year One and uses it 100% for business. By the end of Year Three he has taken $27,440 in depreciation...
-
Silicon Inc. has provided the following information for the year ended December 31, Year 1. Master Budget Actual Costs 5,000 units 4,500 units Direct materials $ 35,000 $ 32,500 Direct labor 15,000...
-
Annabelle, Boden, and Christy form ABC Partnership as equal partners. Annabelle and Boden contribute cash of $50,000 each and Christy contributes equipment with a $100,000 fair market value and...
-
On January 1, Jim purchased 50 shares of Potomac Corporation stock for $50,000. Potomac is a calendar year S corporation and Jim's share of the company's earnings for the year is $20,000. His...
-
Coco Corp. has the following selected account balances as of 12/31/Year5: Cash $13,500 Accounts receivable $128,000 Allowance for uncollectible accounts $12,000 (NORMAL, credit balance- a negative...
-
Answer all of the following questions. Show all calculations. Mama purchased 80% of Papa's equity on 1 January 2018 for 280,000 when Papa's retained earnings were 70,000. The fair value of the...
-
Suppose that a flow network G = (V, E) violates the assumption that the network contains a path s t for all vertices V. Let u be a vertex for which there is no path s u t. Show that there must...
-
Metge Corporation's worksheet for calculating taxable income for 2017 follows: ($ in thousands)________________________________2017 Pre-tax income..................................................
-
Lemon Corporation and Morley, Inc., have entered into an arrangement whereby Lemon will supply materials and 1,000 hours of its scientists' time for a project to be undertaken at Morley's research...
-
The following information appeared in the 2002 annual report of Lyondell Petrochemical Company, a manufacturer of petrochemicals and refined petroleum products such as gasoline, heating oil, jet...
-
Nina Lopez and Matt ORourke have been trying to raise capital to expand their growing chain of cupcake shops, Treasure Cup. They make a full range of traditional cupcakes, but they found immediate...
-
Wish You Wood is a toy boutique located in the main shopping strip of a resort town near Piney Lake. People who own cabins near the lake or come to visit the local state park enjoy browsing through...
-
Alyssia Franklin is a marketing manager for Or Earth Skin Care. Four years ago, when she was hired to help with promotional campaigns, she was thrilled because she loved Or Earths products. Above all...
Study smarter with the SolutionInn App