Question

Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from...

Exercise 9-11 Accounts receivable turnover, inventory turnover, and net margin LO 9-2, 9-4 Selected data from Stuart Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable $ 396,000 $ 380,000 Allowance for doubtful accounts (19,800 ) (15,200 ) Net accounts receivable $ 376,200 $ 364,800 Inventories, lower of cost or market $ 476,500 $ 435,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales $ 2,017,000 $ 1,757,000 Net cash sales 419,000 308,000 Net sales 2,436,000 2,065,000 Cost of goods sold 1,600,000 1,422,000 Selling, general, and administrative expenses 239,600 214,800 Other expenses 39,600 22,600 Total operating expenses $ 1,879,200 $ 1,659,400 Required Compute the accounts receivable turnover for 2018. Compute the inventory turnover for 2018. Compute the net margin for 2017. (For all requirements, round your answers to 2 decimal places.)

Homework Answers

Answer #1

SOLUTION

(A) Accounts Receivable Turnover ratio=Net Credit sales / Average Accounts Receivable

Average Accounts Receivable = (Beginning Accounts Receivable + Ending Accounts Receivable)/2

= ($364,800+$376,200) / 2

=$741,000/2 = $370,500

Accounts Receivable Turnover ratio = $2,017,000 / $370,500

= 5.44 times

(B) Inventory Turnover ratio=Net Cost of good sold / Average Inventory

Average Inventory = (Beginning inventory + Ending Inventort)/2

= ($435,000 + $476,500) / 2

= $911,500 / 2 = $455,750

Inventory Turnover ratio= $1,600,000 / $455,750

= 3.51times

(C) Net margin = (Net income / Net sales) * 100

Net income = Net sales - Total operating expenses

= $1,757,000 - $1,659,400 = $97,600

Net margin = $97,600 /  $1,757,000 = 5.55%

Know the answer?
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
Similar Questions
Question 2 Selected financial statement data for Mure Company are presented below. December 31, 2017 December...
Question 2 Selected financial statement data for Mure Company are presented below. December 31, 2017 December 31, 2016 Cash $ 40,000 $30,000 Short-term investments 20,000 18,000 Accounts receivable (net) 100,000 90,000 Inventory 80,000 60,000 Total current liabilities 100,000 90,000 During 2017, net sales were $950,000, and cost of goods sold was $770,000. Compute the current ratio at December 31, 2017. (Round answer to 1 decimal place, e.g. 2.1:1) Current ratio :1 LINK TO TEXT Compute the acid-test ratio at December...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements of Apple Inc (AAPL). Year 2 Year 1 Sales $233,715 $182,795 Cost of goods sold 140,089 112,258 Operating income 71,230 52,503 Average accounts receivable 33,713 27,816 Average inventory 2,230 1,938 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. Accounts Receivable Turnover Year 2 Year 1 2. Compute the number of days' sales in receivables for Years...
Exercise 7-17 Accounts receivable turnover LO A1 The following information is from the annual financial statements...
Exercise 7-17 Accounts receivable turnover LO A1 The following information is from the annual financial statements of Raheem Company. Year 3 Year 2 Year 1 Net sales $ 405,140 $ 335,280 $ 388,000 Accounts receivable, net (year-end) 44,800 41,400 34,800 (1) Compute its accounts receivable turnover for Year 2 and Year 3.
The following data are taken from the financial statements of Rainsberger Company. 2018 2017 Accounts receivable...
The following data are taken from the financial statements of Rainsberger Company. 2018 2017 Accounts receivable (net), end of year $590,000 $505,000 Net sales on account 4,100,000 3,200,000 Terms for all sales are 1/10, n/60. Compute for each year the accounts receivable turnover. At the end of 2016, accounts receivable (net) was $515,000. (Round answers to 1 decimal place, e.g. 1.6.) 2018 2017 Accounts receivable turnover times times Compute for each year the average collection period. At the end of...
Cash $66,500 $50,500 Accounts receivable (net) 91,000 59,000 Inventories 91,000 111,000 Plant assets (net) 381,500 321,000...
Cash $66,500 $50,500 Accounts receivable (net) 91,000 59,000 Inventories 91,000 111,000 Plant assets (net) 381,500 321,000 Accounts payable 54,500 40,000 Salaries and wages payable 10,000 4,500 Bonds payable 69,000 69,500 8% Preferred stock, $40 par 100,000 100,000 Common stock, $10 par 120,000 90,000 Paid-in capital in excess of par 80,000 70,000 Retained earnings 196,500 167,500 Net credit sales 930,000 Cost of goods sold 705,000 Net income 81,000 Compute the following ratios: (Round answers to 2 decimal places e.g. 15.25.) (a)...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $56,900; total assets, $249,400; common stock, $81,000; and retained earnings, $51,308.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 298,350 Gross profit 155,250 Operating expenses 99,000 Interest expense 4,100 Income before taxes 52,150 Income taxes 21,008 Net income $...
CARLA VISTA CO. Balance Sheets December 31 2017 2016 Cash $ 16,140 $ 32,280 Accounts receivable...
CARLA VISTA CO. Balance Sheets December 31 2017 2016 Cash $ 16,140 $ 32,280 Accounts receivable (net) 75,320 64,560 Inventory 64,560 53,800 Plant assets (net) 215,200 193,680 $371,220 $344,320 Accounts payable $ 53,800 $ 64,560 Mortgage payable (15%) 107,600 107,600 Common stock, $10 par 150,640 129,120 Retained earnings 59,180 43,040 $371,220 $344,320 Additional information for 2017: 1. Net income was $32,500. 2. Sales on account were $392,900. Sales returns and allowances amounted to $27,300. 3. Cost of goods sold was...
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet...
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $51,900; total assets, $179,400; common stock, $85,000; and retained earnings, $48,534.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 451,600 Cost of goods sold 297,250 Gross profit 154,350 Operating expenses 98,600 Interest expense 4,900 Income before taxes 50,850 Income taxes 20,484 Net income $ 30,366 CABOT CORPORATION Balance Sheet December 31, 2017 Assets...
Exercise 17-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed...
Exercise 17-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,000 $ 36,250 $ 37,600 Accounts receivable, net 89,400 61,500 51,000 Merchandise inventory 111,000 82,400 53,500 Prepaid expenses 10,700 9,200 5,300 Plant assets, net 280,000 250,500 228,000 Total assets $ 523,100 $ 439,850 $ 375,400 Liabilities and Equity Accounts payable $ 128,000 $ 73,500 $ 51,600 Long-term notes...
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the...
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,200 $ 35,000 $ 37,400 Accounts receivable, net 86,100 63,500 50,500 Merchandise inventory 112,000 82,400 53,500 Prepaid expenses 10,550 9,400 4,800 Plant assets, net 278,000 249,500 229,000 Total assets $ 518,850 $ 439,800 $ 375,200 Liabilities and Equity Accounts payable $ 128,400 $ 74,250 $ 50,400...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT