Simon Company’s year-end balance sheets follow.
At December 31
2017
2016
2015
Assets
Cash
$
32,096...
Simon Company’s year-end balance sheets follow.
At December 31
2017
2016
2015
Assets
Cash
$
32,096
$
37,517
$
38,306
Accounts receivable, net
89,700
62,100
54,700
Merchandise inventory
115,000
83,500
54,000
Prepaid expenses
10,336
9,848
4,256
Plant assets, net
291,476
271,352
231,838
Total assets
$
538,608
$
464,317
$
383,100
Liabilities and Equity
Accounts payable
$
135,455
$
79,254
$
51,075
Long-term notes payable secured by
mortgages on plant assets
102,271
107,861
85,512
Common stock, $10 par value
162,500
162,500...
Tinker’s cost of goods sold in the year of sale (2016) was
$770,000 and 2015 cost...
Tinker’s cost of goods sold in the year of sale (2016) was
$770,000 and 2015 cost of goods sold was $790,000. The inventory at
the end of 2016 was $190,000 and at the end of 2015 the inventory
was $210,000. Tinker’s average number of days to sell its inventory
during 2016 is closest to: (Use 365 days a year. Do not round
intermediate calculations.)
92.41 days
90.06 days
97.03 days
94.81 days
Suppose this information is available for PepsiCo,
Inc. for 2015, 2016, and 2017.
(in millions)
2015...
Suppose this information is available for PepsiCo,
Inc. for 2015, 2016, and 2017.
(in millions)
2015
2016
2017
Beginning inventory
$2,100
$2,200
$2,800
Ending inventory
2,200
2,800
2,600
Cost of goods sold
17,951
20,435
20,445
Sales revenue
38,895
42,974
43,152
Calculate the inventory turnover for PepsiCo, Inc. for 2015,
2016, and 2017. (Round inventory turnover to 1 decimal
place, e.g. 5.1.)
2015
2016
2017
Inventory turnover
times
times
times
Calculate the days in inventory for PepsiCo, Inc. for 2015,
2016,...
2017
2016
2015
2014
2013
Sales
$
517,662
$
336,144
$
275,528
$
190,019
$
138,700...
2017
2016
2015
2014
2013
Sales
$
517,662
$
336,144
$
275,528
$
190,019
$
138,700
Cost of goods
sold
251,028
162,899
135,603
92,409
66,576
Accounts
receivable
25,003
19,564
18,901
11,116
9,473
Compute trend percents for the above accounts, using 2013 as the
base year.
Trend
Percent for Net Sales:
Choose Numerator:
/
Choose Denominator:
/
=
Sales
2017:
/
=
%
2016:
/
=
%
2015:
/
=
%
2014:
/
=
%
Trend
Percent for Cost of Goods...
Exercise 5-13 Inventory turnover and days' sales in inventory LO
A3
The following is information for...
Exercise 5-13 Inventory turnover and days' sales in inventory LO
A3
The following is information for Palmer Co.
Year 3
Year 2
Year 1
Cost of goods sold
$
593,825
$
376,650
$
341,300
Ending inventory
101,400
91,750
96,500
Use the above information to compute inventory turnover for Year 3
and Year 2, and its days' sales in inventory at December 31, Year 3
and Year 2
QS 14-15 Raw materials inventory management LO A1
3M Co. reports beginning raw materials inventory of...
QS 14-15 Raw materials inventory management LO A1
3M Co. reports beginning raw materials inventory of $1,070
million and ending raw materials inventory of $1,000 million. 3M
purchased $5,506 million of raw materials and used $5,576 million
of raw materials during the year. Compute raw materials inventory
turnover and the number of days' sales in raw materials inventory.
(Use 365 days per year. Enter your answers in
millions.)
Raw Materials Inventory turnover
Choose Numerator: / Choose Denominator: =. Raw
Materials...
Real World Financials
ABC Corporation reported the following information in its financial
statements for three successive...
Real World Financials
ABC Corporation reported the following information in its financial
statements for three successive quarters ($ in millions):
Three Months Ended
9/30/2017 (Q1)
6/30/2017 (Q4)
3/31/2017 (Q3)
Balance sheets:
Accounts receivable, net
$
16,161
$
19,815
$
12,905
Income statements:
Sales revenue
$
24,555
$
23,335
$
22,130
Required:
Compute the receivables turnover ratio and the average
collection period for Q1 and Q4. Assume that each quarter consists
of 91 days. (Round average accounts receivable answers to
nearest...
Zipper Corporation reported the following condensed income
statement for 2015:
Sales
$5,900,000
Cost of goods sold...
Zipper Corporation reported the following condensed income
statement for 2015:
Sales
$5,900,000
Cost of goods sold
4,130,000
Gross profit
$1,770,000
Less expenses
-1,520,000
Net income before taxes
$250,000
Less income taxes
100,000
Net income after taxes
$150,000
Assume the following:
Average inventory
$690,000
Average accounts
receivable
$1,220,000
Average accounts payable
$390,000
(Use 365 days a year)
Compute the following: (Round answers to 2 decimal
places, e.g. 52.75.)
Inventory turnover
times
Accounts receivable
turnover
times
Average number of days to
sell...
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...
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...