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?
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Horngren's Accounting, The Financial Chapters, Student Value Edition Plus MyLab Accounting with Pearson eText - Access Card Package (12th Edition)
- 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
- Ratios For Amazon.com, Inc. (AMZN) 2018 2019 Current Ratio Acid test Ratio Ave. Days Collection Total Debt to Total Assets Return on Equity Asset Turnover Profit Margin on net Sales Inventory Turnover***arrow_forward1. 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…arrow_forwardProblem I. The following data represent selected information from the comparative income statement and balance sheet for Little CPA Company for the years ended December 31, 2020 and 2019: 2020 2019 Net Sales (all on credit) P370,000 P333,000 Cost of goods sold 160,000 150,000 Gross profit 210,000 183,000 Income from operations 95,000 87,000 Interest expense 8,000 8,000 Net income 70,000 57,000 Cash 10,000 14,000 Accounts receivable, net 30,000 25,000 Inventory 43,000 40,000 Prepaid expenses 5,000 7,000 Total current assets 88,000 86,000 Total noncurrent assets 112,000 104,000 Total current liabilities 70,000 60,000 Total noncurrent liabilities 40,000 45,000 Ordinary share capital, no par* 60,000 60,000 Retained earnings 30,000 25,000 Note: 10,000 ordinary shares have been issued and outstanding since the company was established. They had a…arrow_forward
- Problem I. The following data represent selected information from the comparative income statement and balance sheet for Little CPA Company for the years ended December 31, 2020 and 2019: 2020 2019 Net Sales (all on credit) P370,000 P333,000 Cost of goods sold 160,000 150,000 Gross profit 210,000 183,000 Income from operations 95,000 87,000 Interest expense 8,000 8,000 Net income 70,000 57,000 Cash 10,000 14,000 Accounts receivable, net 30,000 25,000 Inventory 43,000 40,000 Prepaid expenses 5,000 7,000 Total current assets 88,000 86,000 Total noncurrent assets 112,000 104,000 Total current liabilities 70,000 60,000 Total noncurrent liabilities 40,000 45,000 Ordinary share capital, no par* 60,000 60,000 Retained earnings 30,000 25,000 Note: 10,000 ordinary shares have been issued and outstanding since the company was established. They had a…arrow_forwardGIVE 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 - - -…arrow_forwardView 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_forward
- Please answer required 1,2,3arrow_forwardFind return on financial leverage and return of financial leverage ratio for years 2017, 2018, and 2019arrow_forwardCalculate the profit margin (net income or net profit/total sales)for Rock Castle construction for this fiscal year. What’s the percentagearrow_forward
- 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