Horngren's Financial & Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780133866292
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 15, Problem 15.7SE
Shine's Companies, a home improvement store chain, reported the following summarized figures:
Shine's has 100,000 common shares outstanding during 2016.
Computing inventory, gross profit, and receivables ratios Requirements
- 1. Compute the inventory turnover, days' sales in inventory, and gross profit percentage for Shine's Companies for 2016.
- 2. Compute days' sales in receivables during 2016. Round dollar amounts to three decimal places. Assume all sales were on account.
- 3. What do these ratios say about Shine's Companies' ability to sell inventory and collect receivables?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The Cullumber Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.)
Cullumber Supply CompanyIncome Statement for the Fiscal Year Ended June 30, 2017($ thousands)
% of Net Sales
Net sales
$2,111,000
enter percentages of net sales %
Cost of goods sold
1,464,000
enter percentages of net sales %
Selling and administrative expenses
312,200
enter percentages of net sales %
Nonrecurring expenses
27,600
enter percentages of net sales %
Earnings before interest, taxes, depreciation, and amortization (EBITDA)
$307,200
enter percentages of net sales %
Depreciation
117,000
enter percentages of net sales %
Earnings before interest and taxes (EBIT)
190,200
enter percentages of net sales %
Interest expense
118,600
enter percentages of net sales %
Earnings before taxes (EBT)…
Excel's Companies, a home improvement store chain, reported the following summarized figures:
E (Click the icon to view the income statement.)
Excel's has 100,000 common shares outstanding during 2018.
E (Click the icon to view the balance sheets.)
Read the requrements
Requirement 1. Compute the inventory turnover, days' sales in inventory, and gross profit percentage for Excel's Companies for 2018.
Compute the inventory turnover. (Round your answer to two decimal places, X.XX.)
The inventory tumover
times.
i Income Statement
i Balance Sheets
Excel's Companies
Excel's Companies
Balance Sheet
Income Statement
May 31, 2018 and 2017
Years Ended May 31, 2018 and 2017
2018
2017
Assets
Liabilities
2018
2017
2018
2017
Net Sales Revenue
51.200 S
39, B00
Cost of Goods Sold
22,500
23 700
Cash
2,000 $
1 800 Total Current Liabilities
25,000 $
13,300
14,100
10,200
500
280
Short-tem Investments
26,000
10,000 Long-tem Liabilities
Interest Expense
6,200
7,100
Accounts Receivable
7,300
5,500 Total…
The comparative financial statements of Bettancort Inc. are as follows. The market price of Bettancort Inc. common stock was $71.25 on December 31, 2014.
InstructionsDetermine the following measures for 2014, rounding to one decimal place:1. a.Working capital
b. Current ratio
c. Quick ratiod. Accounts receivable turnovere. Number of days' sales in receivablesf. Inventory turnoverg. Number of days' sales in inventoryh. Ratio of fixed assets to long-term liabilitiesi. Ratio of liabilities to stockholders’ equityj. Number of times interest charges are earnedk. Number of times preferred dividends are earned2. a. Ratio of net sales to assetsb. Rate earned on total assetsc. Rate earned on stockholders' equityd. Rate earned on common stockholders' equitye. Earnings per share on common stockf. Price-earnings ratiog. Dividends per share of common stockh. Dividend yield
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting (5th Edition)
Ch. 15 - What part of the Libertys annual report is written...Ch. 15 - Horizontal analysis of Liberty's balance sheet for...Ch. 15 - Vertical analysis of Liberty's balance sheet for...Ch. 15 - Which statement best describes Liberty's acid-test...Ch. 15 - Liberty's inventory turnover during 2017 was...Ch. 15 - Prob. 6QCCh. 15 - Prob. 7QCCh. 15 - Liberty's rate of return on common stockholders'...Ch. 15 - The company has 2,500 shares of common stock...Ch. 15 - Prob. 10AQC
Ch. 15 - What ate the three main ways to analyze financial...Ch. 15 - What is an annual report? Briefly describe the key...Ch. 15 - Prob. 3RQCh. 15 - What is trend analysis, and how does it differ...Ch. 15 - Prob. 5RQCh. 15 - Prob. 6RQCh. 15 - Prob. 7RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 9RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 12RQCh. 15 - Prob. 13RQCh. 15 - Prob. 14RQCh. 15 - Prob. 15RQCh. 15 - Prob. 15.1SECh. 15 - Performing horizontal analysis McDonald Corp....Ch. 15 - Calculating trend analysis Variline Corp. reported...Ch. 15 - Performing vertical analysis Hoosier Optical...Ch. 15 - Preparing common-size income statement Data for...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Prob. 15.9SECh. 15 - Prob. 15.10SECh. 15 - Prob. 15.11SECh. 15 - Using ratios to reconstruct a balance sheet...Ch. 15 - Prob. 15.13SECh. 15 - Prob. 15.14SECh. 15 - Prob. 15.15ECh. 15 - Computing trend analysis Grand Oaks Realty's net...Ch. 15 - Prob. 15.17ECh. 15 - Prob. 15.18ECh. 15 - Prob. 15.19ECh. 15 - Prob. 15.20ECh. 15 - Analyzing the ability to pay liabilities Big Bend...Ch. 15 - Analyzing profitability Varsity, Inc.s comparative...Ch. 15 - Prob. 15.23ECh. 15 - Using ratios to reconstruct a balance sheet The...Ch. 15 - Prob. 15.25ECh. 15 - Computing earnings per share Falconi Academy...Ch. 15 - Prob. 15.27APCh. 15 - Prob. 15.28APCh. 15 - Prob. 15.29APCh. 15 - Prob. 15.30APCh. 15 - Using ratios to evaluate a stock investment...Ch. 15 - Prob. 15.32APCh. 15 - Preparing an income statement The following...Ch. 15 - Computing trend analysis and return on common...Ch. 15 - Prob. 15.35BPCh. 15 - Prob. 15.36BPCh. 15 - Determining the effects of business transactions...Ch. 15 - Prob. 15.38BPCh. 15 - Prob. 15.39BPCh. 15 - Prob. 15.40BPCh. 15 - Prob. 15.41CPCh. 15 - Lance Berkman is the controller of Saturn, a dance...Ch. 15 - Prob. 15.1CTEI
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
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forwardFINANCIAL RATIOS Based on the financial statements for Jackson Enterprises (income statement, statement of owners equity, and balance sheet) shown on pages 596597, prepare the following financial ratios. All sales are credit sales. The Accounts Receivable balance on January 1, 20--, was 21,600. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and average number of days required to collect receivables 6. Inventory turnover and average number of days required to sell inventoryarrow_forwardBerry Farms has an accounts receivable balance at the end of 2018 of $425,650. The net credit sales for the year are $924,123. The balance at the end of 2017 was $378,550. What is the number of days sales in receivables ratio for 2018 (round all answers to two decimal places)?arrow_forward
- The following select financial statement information from Vortex Computing. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days sales in receivables ratio is 85 days?arrow_forwardMillennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?arrow_forwardFINANCIAL RATIOS Based on the financial statements, shown on pages 603604, for McDonald Carpeting Co. (income statement, statement of owners equity, and balance sheet), prepare the following financial ratios. All sales are credit sales. The balance of Accounts Receivable on January 1, 20--, was 6,800. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and average number of days required to collect receivables 6. Inventory turnover and average number of days required to sell inventoryarrow_forward
- Last year, Tobys Hats had net sales of 45,000,000 and cost of goods sold of 29,000,000. Tobys had the following balances: Refer to the information for Tobys on the previous page. Required: Note: Round answers to one decimal place. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.arrow_forwardBarga Co. reported net sales for 2016 and 2017 of $665,000 and $742,000, respectively. Its year-end balances of accounts receivable follow: December 31, 2016, $63,000; and December 31, 2017, $89,000. a. Complete the below table to calculate the days' sales uncollected at the end of each year. (Round your "Days' Sales Uncollected" answer to 1 decimal place.) ok Days' Sales Uncollected Choose Numerator: Choose Denominator: Days Days' Sales Uncollected %3D Days' sales uncollected 2016: days %3D 2017: days %3D ces < Prev 4 of 4 Nextarrow_forwardThe following information is taken Aiello Corporation's fiscal 2016 annual report. Selected Balance Sheet Data 2016 2015 Inventories........................ $221,418 $226,893 Accounts Receivable........... $121,333 $122,087 Assume that Aiello Corporation had $1,003,881 sales on credit during fiscal year 2016. What amount did the company collect from credit customers during the year? a. $1,003,881 b. $1,004,635 c. $1,003,127 d. $1,247,301arrow_forward
- Operating data for Flounder Corp. are presented below. 2017 2016 Sales revenue $825,400 $628,400 Cost of goods sold 527,300 412,700 Selling expenses 125,600 76,800 Administrative expenses 75,500 52,800 Income tax expense 36,700 29,200 Net income 60,300 56,900 Prepare a schedule showing a vertical analysis for 2017 and 2016. (Round percentages to 1 decimal place, e.g. 12.1%.)arrow_forwardWhat is the times interest earned ratio on these accounting question?arrow_forwardSuppose the 2017 financial statements of 3M Company report net sales of $23.1 billion. Accounts receivable (net) are $3.40 billion at the beginning of the year and $3.54 billion at the end of the year. Compute 3M Company's receivable turnover. (Round answer to 1 decimal place, e.g. 12.5.) times Accounts receivable turnover ratio SHOW LIST OF ACCOUNTS LINK TO TEXT INTERACTIVE TUTORIAL Compute 3M Company's average collection period for accounts receivable in days. (Round answer to 1 decimal place, e.g. 12.5. Use 365 days for calculation.) Average collection period daysarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License