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 9, Problem P9.41BPGB
Using ratio data to evaluate a company’s financial position
Leaming Objective 5
1. Days’ sales in receivables (2018) 18 days
The comparative ?nancial statements of Newton Cosmetic Supply for 2018, 2017 and 2016 include the data shown here:
2018 | 2017 | 2016 | |
Current Assets: | |||
Cash | $ 80,000 | $50,000 | $20,000 |
Short-term investment | 150,000 | 170,000 | 125,000 |
310,000 | 260,000 | 220,000 | |
Merchandise Inventory | 360,000 | 335,000 | 330,000 |
Prepaid Expenses | 50,000 |
30,000 |
35,000 |
Total Current Assets | 950,000 | 345,000 | 740,000 |
Total Current Liabilities | 530,000 | 630,000 | 670,000 |
Income statement—partial | |||
Net Sales (all on account) | 5,850,000 | 5,110,000 | 425,000 |
Requirements
1. Compute these ratios for 2018 and 2017:
a. Acid-test ratio (Round to two decimals.)
b. Accounts receivable turnover (Round to two decimals.)
c. Days‘ sales in receivables (Round to the nearest whole day.)
2. Considering each ratio individually, which ratios improved from 2017 to 2018 and which ratios deteriorated? ls the trend favorable or unfavorable for the company?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
please help me solve
1. Use ratios to analyze a company's liquidity and solvency.
Calculate Select Ratios - Excel
FILE
НОМE
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign In
Calibri
11
A A
%
Alignment Number Conditional Format as
Formatting - Table -
Paste
I
Cell
Cells
Styles -
Clipboard
Font
Styles
B36
fx
A
B
C
D
1 Condensed financial statements for Games Galore are summarized below:
2
3 Balance Sheet
2016
2015
185,000 $
80,000
4 Cash
$
143,000
59,000
134,000
5 Accounts Receivable, Net
6 Inventory
104,000
7 Prepaid Insurance
11,900
5,880
Total Current Assets
380,900
341,880
9 Property and Equipment, Net
514,500
407,000
10
Total Assets
$
895,400 $
748,880
11
12 Current Liabilities
2$
85,300 $
96,800
13 Long-term Liabilities
284,000
224,000
Total Liabilities
369,300
299,000
320,800
299,000
14
15 Contributed Capital
16 Retained Earnings
Total Stockholders' Equity
227,100
129,080
428,080
17
526,100
18
Total Liabilities and Stockholders' Equity
$
895,400 $
748,880
19
20 Income Statement
$ 3,031,000…
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW
JOLLIBEE INCOME STATEMENT
ITEM
2016
2017
2018
2019
2020
Sales/Revenue
113.81B
133.61B
161.17B
179.63B
129.31B
Sales Growth
-
17.40%
20.62%
11.45%
-28.01%
Cost of Goods Sold (COGS) incl. D&A
-
-
132.96B
150.88B
115.39B
COGS Growth
-
-
-
13.47%
-23.52%
COGS excluding D&A
89.27B
105.39B
121.08B
137.38B
100.82B
Depreciation & Amortization Expense
4B
4.75B
11.89B
13.5B
14.57B
Depreciation
3.93B
4.66B
11.73B
13.34B
14.32B
Amortization of Intangibles
68.99M
78.95M
151.82M
145.42M
245.23M
Gross Income
20.54B
23.48B
28.21B
28.75B
13.92B
Gross Income Growth
-
14.30%
20.12%
1.93%
-51.57%
Gross Profit Margin
-
-
-
-
10.77%
SG&A Expense
-
-
17.64B
20.21B
20.42B
SGA Growth
-
-
-…
Chapter 9 Solutions
Horngren's Accounting (12th Edition)
Ch. 9 - 1. With good internal controls, the person who...Ch. 9 - Which of the following is a limitation of the...Ch. 9 - 3. The entry to record a write-off of an...Ch. 9 - Brickman Company uses the allowance method to...Ch. 9 - Brickman’s ending balance of accounts Receivable...Ch. 9 - During the year, Bernard Company had net credit...Ch. 9 - At December 31 year-end, Crain Company has an...Ch. 9 - Using the data in the preceding question, what...Ch. 9 - At year-end, Schultz Company has cash of $11,600,...Ch. 9 - Using the data in the preceding question, assume...
Ch. 9 - What is the difference between accounts receivable...Ch. 9 - List some common examples of other receivables,...Ch. 9 - Prob. 3RQCh. 9 - When dealing with receivables, give an example of...Ch. 9 - What type of account must the sum of all...Ch. 9 - Prob. 6RQCh. 9 - What occurs when a business factors its...Ch. 9 - What occurs when a business pledges its...Ch. 9 - What is the expense account associated with the...Ch. 9 - When is bad debts expense recorded when using the...Ch. 9 - What are some limitations of using the direct...Ch. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - When using the allowance method, what account is...Ch. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - How do the percent-of-receivables and...Ch. 9 - What is the difference between the...Ch. 9 - In accounting for bad debts, how do the income...Ch. 9 - What is the formula to compute interest on a note...Ch. 9 - Prob. 21RQCh. 9 - Prob. 22RQCh. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. S9.1SECh. 9 - Recording credit sales and collections Learning...Ch. 9 - Applying the direct write-off method to account...Ch. 9 - Collecting a receivable previously written...Ch. 9 - Applying the allowance method to account for...Ch. 9 - Applying the allowance method (percent-of-sales)...Ch. 9 - Applying the allowance method...Ch. 9 - Applying the allowance method...Ch. 9 - Computing interest amounts on notes receivable...Ch. 9 - Accounting for a note receivable Learning...Ch. 9 - Accruing interest revenue and recording collection...Ch. 9 - Recording a dishonored note receivable Learning...Ch. 9 - Prob. S9.13SECh. 9 - Defining common receivables terms Learning...Ch. 9 - E9-15 Identifying and correcting internal control...Ch. 9 - Recording credit sales and collections Learning...Ch. 9 - Journalizing transactions using the direct...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Prob. E9.21ECh. 9 - Journalizing credit sales, note receivable...Ch. 9 - Journalizing note receivable transactions...Ch. 9 - Journalizing note receivable transactions Learning...Ch. 9 - Journalizing note receivable transactions Learning...Ch. 9 - Evaluating ratio data Learning Objective 5 Abanaki...Ch. 9 - Computing the collection period for receivables...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Prob. P9.31APGACh. 9 - Accounting for notes receivable and accruing...Ch. 9 - Prob. P9.33APGACh. 9 - Using ratio data to evaluate a company’s financial...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Accounting for uncollectible accounts using the...Ch. 9 - Prob. P9.37BPGBCh. 9 - Prob. P9.38BPGBCh. 9 - Prob. P9.39BPGBCh. 9 - Accounting for notes receivable, dishonored notes,...Ch. 9 - Using ratio data to evaluate a company’s financial...Ch. 9 - Prob. P9.42CTCh. 9 - Prob. P9.43CPCh. 9 - Prob. P9.44PSCh. 9 - Prob. 9.1TIATCCh. 9 - Decision Case 9-1 Weddings on Demand sells on...Ch. 9 - Decision Case 9-2 Pauline’s Pottery has always...Ch. 9 - Prob. 9.1FCCh. 9 - Financial Statement Case 9-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
- Ratio Analysis The following information was taken from Logsden Manufacturings trial balances as of December 31, 2018, and December 31, 2019. Required: 1. Calculate the gross profit margin and operating margin percentage for 2019. ( Note: Round answers to two decimal places.) 2. Assuming that all of the operating expenses are fixed (or, wont change as sales increase or decrease), what will be the operating margin percentage if sales increase by 25%?arrow_forwardReal-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory' h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardFinancial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forward
- View Policies Current Attempt in Progress The financial statements of winery Andrew Peller Limited reported net sales of $342606 thosand for s year ended March 31. 2017. Accounts receivable were $26.973 thousand at March 31, 2017. and $2223 thousand at Marth 31,2016 Calculate the company's accounts receivable turnover ratio and the average collestion peried for accouts receivite inys Oo answers to 2 decimal places ng 15.25. Ue 365 days for caloulation) times Accounts receivable turnover ratio day Average collection period for accounts receivable in days e Textbook and Media Attempts:0 of 3 used SutAm Save for Later OT5ZenBookarrow_forwardExplain comprehensively what happened with Dana Dairy Between 2016 and 2017 Explain Dana position comprehensively compared to the industryarrow_forwardFrom the data, how to calculate net profit margin for hwa tai industries in year 2018 and 2019?arrow_forward
- Solve the Followingarrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forward
- What is the gross margin ratio of Company B? How much purchases did Company A have for 2021? What is the Accounts Receivable Turnover for Company B?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 2021 average collection period is (rounded)? Show your work. Question 44 options:arrow_forwardComputing times-interest-earned ratio The following financial information was obtained from the year ended 2018 income statements for Cash Automotive and Pennington Automotive: Requirements Compute the times-interest-earned ratio for each company Round to two decimals. Which company was better able to cover its interest expense?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License