EBK HORNGREN'S ACCOUNTING
12th Edition
ISBN: 9780134491523
Author: Matsumura
Publisher: YUZU
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
(Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?
(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Jubilee Corporation yield the following datafor the year ended June 30, 2018 (assume sales returns are non-existent):Inventory, June 30, 2017.......................................................................... $ 7,000Purchases of inventory (on account)......................................................... 61,000Sales of inventory—77% on account; 23% for cash (cost $49,000).........Inventory at FIFO, June 30, 2018 ............................................................100,00019,000Requirements1. Journalize Jubilee’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statement.
(Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?
Chapter 17 Solutions
EBK HORNGREN'S ACCOUNTING
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
- (Learning Objective 2: Calculate purchases by analyzing inventory account activity)On Willow Grove Department Stores’ most recent balance sheet, the balance of its inventory at the beginning of the year was $12,000. At the end of the year, the inventory balancewas $14,500. During that year, its cost of goods sold was $55,000. All purchases of inventorythroughout the year were on account. What was the total of Willow Grove’s purchases duringthe year?arrow_forwardQuestion: Capital Technologies Inc. began 2020 with inventory of $20,000. During the year, Capital purchased inventory costing $100,000 and sold goods for $140,000, with all transactions on account. Capital ended the year with inventory of $30,000. Use the data in exercise to do the following for Capital Technologies Inc.: 1. Post to the Inventory and Cost of Goods Sold accounts. 2. Compute cost of goods sold by the cost-of-goods-sold model. 3. Prepare the December 2020 income statement of Capital Technologies Inc. through gross profit. (Please explain how to get the amount for Sales Revenue, I did not understand)arrow_forward16. New attempt is in progress. Some of the new entries may impact the last attempt grading. Your answer is partially correct. The income statement of Bonita Company is shown below. BONITA COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,470,000 Cost of goods sold Beginning inventory $2,050,000 Purchases 4,300,000 Goods available for sale 6,350,000 Ending inventory 1,650,000 Cost of goods sold 4,700,000 Gross profit 1,770,000 Operating expenses Selling expenses 430,000 Administrative expenses 700,000 1,130,000 Net income $640,000 Additional information: 1. Accounts receivable decreased $290,000 during the year. 2. Prepaid expenses increased $170,000 during the year. 3. Accounts payable to suppliers of merchandise decreased $280,000 during the year. 4. Accrued…arrow_forward
- Learning Objective 7: Calculate return on assets) In 2018, Ambrosia Corporation LO 7reported $100 million in sales, $18 million in net income, and average total assets of $200 million.What is Ambrosia’s return on assets in 2018?arrow_forwardGeelong Publishers’ selected accounts as of 30 November 2020 follow: Selling expenses $ 18 100 Inventory $44 000 Furniture 37 300 Cash 36 100 Sales returns and allowances 3 000 Loan payable 21 700 Salary payable 1 400 Accumulated depreciation 23 100 Alawa, capital 29 400 Cost of sales 53 000 Sales revenue 114 200 Sales discounts 2 400 Accounts payable 13 400 General expenses 9 300 Requirements: 1. Prepare the functional format income statement, statement of changes in equity and balance sheet for the first year of operations. 2. Prepare closing entries for the first year of operations. Please don't give solution in an image thnxarrow_forward(Learning Objective 3: Account for the purchase and sale of treasury stock) OnJanuary 10, 2019, Mahlon Design Services purchased treasury stock at a cost of $26 million.On July 3, 2019, Mahlon resold some of the treasury stock for $11 million; this resold treasurystock had cost the company $4 million. Record the purchase and resale of Mahlon’s treasurystock. Overall, how much did stockholders’ equity increase or decrease as a result of the twotreasury-stock transactions?arrow_forward
arrow_back_ios
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