Compute selected ratios,and compare liquidity,profitability, and solvency forP18-5 Selected financial data of Target Corporation and Wal-Mart Stores, Inc. for arecent year are presented here (in millions).two companies.Wal-MartTargetCorporationIncome Statement Data for Year(LO 2)Stores, Inc.$374,526$61,47141,89516,200Net salesCost of goods soldSelling and administrative expensesInterest expenseOther income (expense)Income tax expense6471,8961,776286,51570,8471,7984,2736,908$ 2,849$ 12,731Net incomeBalance Sheet Data (End of Year)$ 47,585115,929Current assets$18,90625,654Noncurrent assetsTotal assets$44,560$163,514Current liabilities$ 58,454$11,78217,471Long-term debtTotal stockholders' cquity40,45215,30764,608Total liabilities and stockholders' equity$44,560$163,514Problems 827TargetCorporationBeginning-of-Year BalancesWal-MartStores, Inc.Total assetsTotal stockholders' equityCurrent liabilities$37,34915,63311,117$151,58761,57352,148Total liabilities21,71690,014Other DataAverage net accounts receivableAverage inventoryNet cash provided by operating activities$ 7,1246,5174,125$ 3,24734,43320,354Instructions(a) For each company, compute the following ratios.(1) Current ratio.(7) Asset turnover.(8) Return on assets.(9) Return on common stockholders' equity.(10) Debt to assets ratio.(11) Times interest earned.(2) Accounts receivable turnover.(3) Average collection period.(4) Inventory turnover.(5) Days in inventory.(6) Profit margin.(b) Compare the liquidity, profitability, and solvency of the two companies.

Solution:- a)1-Calculation of Current ratio as follows under:-

Problems 827 Wal-Mart Stores, Inc. Target Corporation Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $151,587 61,573 52,148 $37,349 15,633 11,117 21,716 90,014 Average net accounts receivable Average inventory Net cash provided by operating activities Other Data $ 7,124 6,517 4,125 $ 3,247 34,433 20,354 Instructions (a) For each company, compute the following ratios. (1) Current ratio. (2) Accounts receivable turmover. (3) Average collection period. (4) Inventory turnover. (7) Asset turnover. (8) Return on assets. (9) Return on common stockholders' equity. (10) Debt to assets ratio. (5) Davy in inventory (11) Times interest earned

Problems 827 Wal-Mart Stores, Inc. Target Corporation Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $151,587 61,573 52,148 $37,349 15,633 11,117 21,716 90,014 Average net accounts receivable Average inventory Net cash provided by operating activities Other Data $ 7,124 6,517 4,125 $ 3,247 34,433 20,354 Instructions (a) For each company, compute the following ratios. (1) Current ratio. (2) Accounts receivable turmover. (3) Average collection period. (4) Inventory turnover. (7) Asset turnover. (8) Return on assets. (9) Return on common stockholders' equity. (10) Debt to assets ratio. (5) Davy in inventory (11) Times interest earned

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

Miscellaneous financial information Amount Retained earnings 786 Total stockholders' equity 14, 971 Operating net working capital 28,483 Net working capital 29,102 Nonoperating current assets other than cash 347 Short-term debt 1, 126 Total current liabilities 13, 613 Total long-term liabilities 107,872 Inventory ? ? Current portion of long-term debt 561 Accounts receivable 2,052 Treasury stock -5,279 What did Madison Makeup report as long-term assets? 93,741 What did Madison Makeup report as cash? 42,368
Brock Company's financial information is listed below. Assume that all balance sheet amounts represent both average and ending balance figures and that all sales were on credit. Assets Cash and short-term investments $35,766 Accounts receivable (net) 32,541 Inventory 34,460 Property, plant, and equipment 215,693 Total assets $318,460 Liabilities and Stockholders' Equity Current liabilities $67,513 Long-term liabilities 90,221 Common stock, $10 par 61,070 Retained earnings 96,656 Total liabilities and stockholders' equity $318,460 Income Statement Sales $99,202 Cost of goods sold 44,641 Gross margin $54,561 Operating expenses 28,479 $26,082 Net income
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $329,800 $259,200 Marketable securities 381,900 291,600 Accounts and notes receivable (net) 156,300 97,200 Inventories 900,200 560,000 Prepaid expenses 463,800 358,000 Total current assets $2,232,000 $1,566,000 Current liabilities: Accounts and notes payable (short-term) $359,600 $378,000 Accrued liabilities 260,400 162,000 Total current liabilities $620,000 $540,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital $fill in the blank 1 $fill in the blank 2 2. Current ratio fill in the blank 3 fill in the blank 4 3.…
Current Position Analysis The following data were taken from the balance sheet of Albertini Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $446,900 $372,400 Marketable securities 517,400 419,000 Accounts and notes receivable (net) 211,700 139,600 Inventories 1,071,800 807,000 Prepaid expenses 552,200 516,000 Total current assets $2,800,000 $2,254,000 Current liabilities: Accounts and notes payable (short-term) $324,800 $343,000 Accrued liabilities 235,200 147,000 Total current liabilities $560,000 $490,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital $fill in the blank 1 $fill in the blank 2 2. Current ratio fill in the blank 3 fill in the blank…
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $395,200 $324,000 Marketable securities 457,600 364,500 Accounts and notes receivable (net) 187,200 121,500 Inventories 617,800 411,800 Prepaid expenses 318,200 263,200 Total current assets $1,976,000 $1,485,000 Current liabilities: Accounts and notes payable (short-term) $301,600 $315,000 Accrued liabilities 218,400 135,000 Total current liabilities $520,000 $450,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital %24 2. Current ratio 3. Quick ratio
Current Position Analysis The following data were taken from the balance sheet of Albertini Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $620,200 $495,600 Marketable securities 718,100 557,600 Accounts and notes receivable (net) 293,700 185,800 Inventories 314,200 179,900 Prepaid expenses 161,800 115,100 Total current assets $2,108,000 $1,534,000 Current liabilities: Accounts and notes payable (short-term) $394,400 $413,000 Accrued liabilities 285,600 177,000 Total current liabilities $680,000 $590,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital $fill in the blank 1 $fill in the blank 2 2. Current ratio fill in the blank 3 fill in the blank 4…
5
Current Position Analysis The following items are reported on a company's balance sheet: Cash $537,500 Marketable securities 419,900 Accounts receivable (net) 334,600 Inventory 387,600 Accounts payable 646,000 Determine (a) the current ratio and (b) the quick ratio. Round your answers to one decimal place. a. Current ratio fill in the blank 1 b. Quick ratio
Clean Company Balance Sheet Cash 68,200 Accounts payable 113,500 Accounts 295,000 Notes payable 73,900 receivable Other current Inventories 212,000 101,000 liabilities Total Current Total Current 575,200 288,400 assets liabilities PP&E Net 257,400 Long-term debt 226,500 Total Equity 317,700 Total Liabilities + Total Assets 832,600 832,600 Equity Clean Company Income Statement Sales $1,414,600 Cost of sales 1,190,640 Gross profit 223,960 Operating expenses 125,840 Depreciation 36,520 EBIT 61,600 Interest expenses 21,560 Earnings before 40,040 taxes Taxes (40%) 16,016 Net profit 24,024
balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity Problem 13-5A (Algo) Part 1 $ 19,500 37,400 84,640 5,900 350,000 $ 497,440 $ 33,000 56,400 134,500 6,900 304,400 $ 535,200 $ 68,340 86,800 190,000 152,300 $ 497,440 $ 535,200 $ 91,300 115,000 206,000 122,900 statement Sales Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividends per share Beginning-of-year balance sheet data Accounts receivable, net Merchandise inventory Total assets Common stock, $5 par value Retained earnings Required: 1a. For both companies compute the (a) current ratio, (b) acid-test ratio, (c) accounts receivable turnover, (d) invent sales in inventory, and () days' sales uncollected. Note: Do not round intermediate calculations. 1b. Identify the company…
Prior Year Current Year Accounts payable 3,153.00 5,915.00 Accounts receivable 6,935.00 9,046.00 Accruals 5,794.00 6,085.00 Additional paid in capital 19,655.00 13,876.00 Cash. ??? ??? Common Stock 2,850 2,850 COGS 22,169.00 18,794.00 Current portion long-term debt 500 500 Depreciation expense 1,016.00 1,037.00 Interest expense 1,276.00 1,138.00 Inventories 3,041.00 6,672.00 Long-term debt 16,904.00 22,546.00 Net fixed assets 75,987.00 73,861.00 Notes payable 4,002.00 6,534.00 Operating expenses (excl. depr.) 19,950 20,000 Retained earnings 35,536.00 34,724.00 Sales 46,360 45,799.00 Taxes 350 920 Category ww What is the firm's total change in cash from the prior year to the current year?
Current Position Analysis The following data were taken from the balance sheet of Albertini Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $486,400 $392,000 Marketable securities 563,200 441,000 Accounts and notes receivable (net) 230,400 147,000 Inventories 792,000 469,700 Prepaid expenses 408,000 300,300 Total current assets $2,480,000 $1,750,000 Current liabilities: Accounts and notes payable (short-term) $464,000 $490,000 Accrued liabilities 336,000 210,000 Total current liabilities $800,000 $700,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital $fill in the blank 1 $fill in the blank 2 2. Current ratio fill in the blank 3 fill in the blank 4…