Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 17, Problem P17.36BPGB
Completing a comprehensive financial statement analysis
Learning Objectives 2, 4
3. 2018: Inventory turnover 8.86
In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary:
XYZ ATHlETIC SUPPLY. INC. Five-Year Financial Summary (Partial; adapted) |
||||||
(Dollar amounts in thousands except per share data) | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Net Sales Revenue | $275,000 | $ 222,000 | $ 199,000 | $171,000 | $131,000 | |
Net Sales Seles Revenue Increase | 24% | 12% | 16% | 31% | 17% | |
Domestic Comparative Store Sales increase | 6% | 6$ | 5% | 8% | 10% | |
Other Income—Net | 2,090 | 1,780 | 1,770 | 1,700 | 1,310 | |
Cost of Goods Sold | 208,725 | 169,386 | 154,822 | 134,235 | 103,883 | |
Selling and Administrative Expenses | 41,280 | 36,340 | 31,670 | 27,450 | 22,540 | |
Interest: | ||||||
Interest Expense | (1,070) | (1,370) | (1,330) | (1,100) | (800) | |
Interest income | 140 | 155 | 150 | 230 | 140 | |
Income Tax Expense | 4,420 | 3,900 | 3,610 | 3,390 | 2,730 | |
Net Income | 21,735 | 12,939 | 9,488 | 6,755 | 2,497 | |
Per Share of Common Stock: | ||||||
Net income | 1.10 | 0.80 | 0.70 | 0.50 | 0.28 | |
Dividends | 0.45 | 0.43 | 0.39 | 0.35 | 0.31 | |
Financial Position | ||||||
Current Assets. Excluding Merchandise Inventory | $30,900 | $ 27,200 | $ 26,800 | $24,400 | $ 21,800 | |
Merchandise inventory | 24,700 | 22,400 | 21,600 | 19,300 | 17,000 | $16,800 |
Property, Plant, and Equipment, Net | 51,600 | 46,200 | 40,500 | 35,000 | 25,200 | |
Total Assets | 107,200 | 95,800 | 88,900 | 78,700 | 64,000 | |
Current Liabilities | 32,600 | 27,800 | 28,800 | 25,600 | 17,000 | |
Long-term Debt | 23,000 | 21,200 | 16,800 | 18,600 | 12,900 | |
51,600 | 46,800 | 43,300 | 34,500 | 34,100 | ||
Financial Ratios | ||||||
Acid-Test Ratio | 0.9 | 1.0 | 0.9 | 1.0 | 1.3 | |
22.5% | 15.5% | 12.8% | 10.9% | 9.9% | ||
Rate of Return on Common Stockholders' Equity | 44.2% | 28.7% | 24.1% | 19.4% | 18.9% |
Requirements
Analyze the company's financial summary for the fiscal years 2014-2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis.
- Trend analysis for net sales revenue and net income (use 2014 as the base year).
- Profitability analysis.
- Evaluation of the ability to sell merchandise inventory.
- Evaluation of the ability to pay debts.
- Evaluation of dividends.
- Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Question
The income statement of Cheyenne Company is shown below.
CHEYENNE COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020
Sales revenue
$6,890,000
Cost of goods sold
Beginning inventory
$1,910,000
Purchases
4,410,000
Goods available for sale
6,320,000
Ending inventory
1,620,000
Cost of goods sold
4,700,000
Gross profit
2,190,000
Operating expenses
Selling expenses
460,000
Administrative expenses
700,000
1,160,000
Net income
$1,030,000
Additional information:
1.
Accounts receivable decreased $350,000 during the year.
2.
Prepaid expenses increased $160,000 during the year.
3.
Accounts payable to suppliers of merchandise decreased $300,000 during the year.
4.
Accrued expenses payable decreased $90,000 during the year.
5.
Administrative expenses include depreciation expense of…
Selected information from Bigg Company's financial statements follows:
Fiscal Year Ended December 31
2019
2018
2017
(in thousands)
Gross sales
$2,004,719
$1,937,021 $1,835,987
Less: Sales discounts
4,811
4,649
4,406
Less: Sales returns and allowances
2,406
2,324
2,203
Net sales
$1,997,502
$1,930,048 $1,829,378
Cost of goods sold
621,463
619,847
660,955
Gross profit
$1,376,039
$1,310,201 $1,168,423
Operating expenses
577,369
595,226
583,555
Operating income
$798,670
$714,975
$584,868
Other income (expenses)
15,973
(6,070)
(8,773)
Net income
$814,643
$708,905
$576,095
At December 31
2019
2018
2017
(in thousands)
Accounts receivable
$201,290
$195,427
$182,642
Less: Allowance for doubtful accounts
2,516
2,736
2,192
Net accounts receivable
$198,774
$192,691
$180,450
Required:
1. Calculate the following ratios for 2018 and 2019. Round your answers to two decimal places.
2018
2019
a. Gross profit margin
67.88
%
68.89
%
b. Operating margin
37.04
39.98
c. Net profit margin
х %
36.77
40.78
%
d.…
A company reports the following financial information:
Inventory, December 31, 2019
Inventory, December 31, 2020
Net Sales for 2020
$ 75,000
125,000
850,000
Cost of Goods Sold for 2020
400,000
The company's inventory turnover ratio is closest to
O 0.19 times
O 4.00 times
O 2.13 times
O 5.33 times
Chapter 17 Solutions
Horngren's Accounting (12th Edition)
Ch. 17 - Prob. 1QCCh. 17 - Prob. 2QCCh. 17 - Prob. 3QCCh. 17 - Prob. 4QCCh. 17 - Prob. 5QCCh. 17 - Prob. 6QCCh. 17 - Prob. 7QCCh. 17 - Prob. 8QCCh. 17 - Prob. 9QCCh. 17 - Prob. 10QC
Ch. 17 - Prob. 1RQCh. 17 - Prob. 2RQCh. 17 - Prob. 3RQCh. 17 - Prob. 4RQCh. 17 - Prob. 5RQCh. 17 - Prob. 6RQCh. 17 - What is benchmarking, and what are the two main...Ch. 17 - Prob. 8RQCh. 17 - Prob. 9RQCh. 17 - Prob. 10RQCh. 17 - Prob. 11RQCh. 17 - Prob. 12RQCh. 17 - Prob. 13RQCh. 17 - Prob. S17.1SECh. 17 - Prob. S17.2SECh. 17 - Prob. S17.3SECh. 17 - Prob. S17.4SECh. 17 - Prob. S17.5SECh. 17 - Prob. S17.6SECh. 17 - Computing inventory, gross profit, and receivables...Ch. 17 - Prob. S17.8SECh. 17 - Measuring profitability Learning Objective 4...Ch. 17 - Prob. S17.10SECh. 17 - Prob. S17.11SECh. 17 - Prob. S17.12SECh. 17 - Prob. E17.13ECh. 17 - Prob. E17.14ECh. 17 - Prob. E17.15ECh. 17 - Prob. E17.16ECh. 17 - Prob. E17.17ECh. 17 - Prob. E17.18ECh. 17 - Prob. E17.19ECh. 17 - Prob. E17.20ECh. 17 - Prob. E17.21ECh. 17 - Prob. E17.22ECh. 17 - Prob. P17.23APGACh. 17 - Prob. P17.24APGACh. 17 - Prob. P17.25APGACh. 17 - Prob. P17.26APGACh. 17 - Using ratios to evaluate a stock investment...Ch. 17 - Prob. P17.28APGACh. 17 - Prob. P17.29APGACh. 17 - Prob. P17.30BPGBCh. 17 - Prob. P17.31BPGBCh. 17 - Prob. P17.32BPGBCh. 17 - Prob. P17.33BPGBCh. 17 - Prob. P17.34BPGBCh. 17 - Prob. P17.35BPGBCh. 17 - Completing a comprehensive financial statement...Ch. 17 - Prob. P17.37CTCh. 17 - Prob. P17.38CPCh. 17 - Prob. 17.1DCCh. 17 - Prob. 17.1EICh. 17 - Financial Statement Case 17-1 Use Target...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Selected information from Bigg Company's financial statements follows: Fiscal Year Ended December 31 2019 2018(in thousands) 2017 Gross sales $2,004,719 $1,937,021 $1,835,987 Less: Sales discounts 4,811 4,649 4,406 Less: Sales returns and allowances 2,406 2,324 2,203 Net sales $1,997,502 $1,930,048 $1,829,378 Cost of goods sold 621,463 619,847 660,955 Gross profit $1,376,039 $1,310,201 $1,168,423 Operating expenses 577,369 595,226 583,555 Operating income $798,670 $714,975 $584,868 Other income (expenses) 15,973 (6,140) (8,773) Net income $814,643 $708,835 $576,095 At December 31 2019 2018(in thousands) 2017 Accounts receivable $201,290 $195,427 $182,642 Less: Allowance for doubtful accounts 2,516 2,736 2,192 Net accounts receivable $198,774 $192,691 $180,450 Required: 1. Calculate the following ratios for 2018 and 2019. Round your answers…arrow_forwardQUESTION 1The following are extracts of the income statement and the statement of financial position forMorula Industries.STATEMENT OF INCOME FOR THE YEAR ENDED 31 DECEMBER 2019PulaSales 500,000Less Cost of sales:Opening inventory 120,000Purchases 415,000Cost of goods available for sale 535,000Closing inventory (115,000) (420,000)Gross profit 80,000Operating expenses (40,000)Net surplus for the year 40,000 STAMENT OF FINANCIAL POSITION AS AT 31 DECEMBER 2019PulaCurrent assetsInventory 115,000Receivables 133,000Bank overdraft 124,000Current LiabilitiesPayables 96,000Capital and reservesShare capital 70,000General reserve 110,000Retained profit 110,000Additional Information The receivables and payables opening balances were P50, 000 each. All sales and purchases were made on credit.Required:a. Calculate the:i. Average payment period. ii. Average age of inventory. iii. Average collection period. iv. Cash conversion cycle. b. Explain five strategies that can improve the cash conversion…arrow_forwardSelected financial statement data for Schmitzer Inc. is shown below: 2021 2020 Balance sheet: Inventories 60,000 48,000 Ratios: Gross profit ratio for 2021 40 % Inventory turnover ratio for 2021 5 What was the amount of net sales for 2021?arrow_forward
- STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED DECEMBER 31 2020 2019 2018 Turnover 373,578 424,486 456,300 Cost of sales (253,604) (254,210) (198,900) Gross profit 119,974 170,276 257,400 Impairment of financial assets (2,477) (1,800) (5,400) Distribution costs (87,036) (91,309) (96,100) Administrative expenses (32,556) (50,656) (67,200) Other operating income 2,369 10,039 3,500 Operating profit 274 36,550 92,200 Finance income 2,594 4,949 7,200 Finance costs (2,069) (2,765) (3,400) Profit before income tax 799 38,734 96,000 Income tax expense (285) (13,718) (15,450) Profit for the year 514 25,016 80,550 Other comprehensive income - - - Total comprehensive income 514 25,016 80,550 Table 1 Source (Author, 2022) CLOUD 9 LTD STATEMENT OF FINANCIAL POSITION AS AT DECEMBER 31 Non-current…arrow_forwardLOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…arrow_forwardLOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…arrow_forward
- HIC GROUP OF Companies COMPARATIVE INCOME STATEMENT For years ended 3rd December 2019 2020 Revenue and gains Sales revenue 495,500 496,738.75 Interest revenue 278,500 279,196.25 Investment Income 71,700 71,879.25 Other revenue 101,500 101,753.75 Total revenue and gains 947,200 949,968 Expenses and losses Cost of good sold 450,000 447,750 Selling&administrative 185,000 184,075 Computer (operating) 42,500 42,288 Depreciation 50,000…arrow_forwardExcerpts from the annual report of XYZ Corporation follow: 2019 $675,138 $241,154 $64,150 $93,650 $25,100 2020 Cost of goods sold Inventory Net income $754,661 $219,686 $31,185 $68,685 $26,900 Retained earnings LIFO reserve Tax rate 20% 20% If XYZ used FIFO, its net income for fiscal 2020 would be O a. $34,165 O b. $30,375 O c. $32,625 d. $36,545arrow_forwardGlobal Corp. initially projected the 2019 income statement shown in the table E. Suppose that in 2019, Global launched an aggressive marketing campaign that boosted 2019 sales further by 14.1%. However, their operating margin fell from 5.56% to 4.49% Suppose that they had no other income, interest expenses were unchanged, and taxes were the same percentage of pretax income (26%) as in 2018. a. What was Global's EBIT in 2019? b. What was Global's income in 2019? c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? a. What was Global's EBIT in 2019? Global's EBIT was $ million. (Round to two decimal places.) b. What was Global's income in 2019? Net income was $ million. (Round to two decimal places.) c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? Global's share price in 2019 was $. (Round to the nearest cent.)arrow_forward
- Excerpts from Hulkster Company's December 31, 2024 and 2023, financial statements are presented below: Accounts receivable Merchandise inventory Net sales. Cost of goods sold Total assets Total shareholders' equity . Net income Hulkster's 2024 return on assets is closest to: Multiple Choice 13.5%. 7.1%. 47.7%.. 7,8%. 2024 2023 $ 40,000 $ 36,000 28,000 35,000 190,000 114,000 425,000 240,000 32,500 186,000 108,000 405,000 225,000 28,000arrow_forwardPrepare a vertical analysis for 2019 similar to 3rd column of Exhibit 14-2 on page 577 KOHL’S CORPORATION CONSOLIDATED STATEMENTS OF INCOME (Dollars in Millions, Except per Share Data) 2019 Common Size Net sales $18,885 Other revenue 1,089 Total revenue 19,974 Cost of merchandise sold 12,140 Operating expenses: Selling, general and administrative 5,705 Depreciation and amortization 917 Impairments, store closing and other costs 113 Operating income 1,099 Interest expense, net 207 (Gain) loss on extinguishment of debt (9) Income before income taxes 901 Provision for income taxes…arrow_forwardExcerpts from Dowling Company's December 31, 2021 and 2020, financial statements and key ratios are presented below (all numbers are in millions): 2021 2020 Accounts receivable (net) $ 20 $ 16 Net sales $ 115 100 Cost of goods sold $ 60 55 Net income $ 20 17 Inventory turnover 5.22 Return on assets 10.3 % Equity multiplier 2.36 Dowling's average total assets for 2021 is (rounded): Multiple Choice 32. 210. 115. 194.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License