Horngren's Financial & Managerial Accounting
7th Edition
ISBN: 9780136503743
Author: MILLER-NOBLES
Publisher: RENT PEARS
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 15, Problem 2QC
Horizontal analysis of Liberty's
a. Cash as 9.50% of total assets.
b. a 17% increase in Cash and Cash Equivalents.
c. a
d. inventory turnover of 6 times.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Liberty Corporation reported the following figures:
Account
2016
2015
Cash and cash equivalents
$ 2 450
$ 2 094
Receivables
1 813
1611
Inventory
1 324
1 060
Prepaid expenses
1 709
2 120
Total current assets
$ 7 296
$ 6 885
Other assets
18 500
15 737
$25 796
$ 7 230
Total assets
$22 622
Total current liabilities
$ 8 467
Non-current liabilities
4 798
3 792
Share capital
6 568
4 363
Retained earnings
7 200
6 000
Total liabilities and equity
$25 796
$22 622
2006
Sales
$20 941
Cost of sales
7 055
Selling and general expenses
7 065
Interest expense
210
Income tax expense
2 563
Profit
$ 4 048
Calculate each of following ratios for year 2017 using the financial statement in Table 1-3.
Accounts receivable turnover
Days sales outstanding (DSO)
Accounts payable turnover
Days payable outstanding (DPO)
Total Asset turnover
Fixed asset turnover
Liquidity Ratio
Current ratio
Quick ratio
Liability to assets
Interest coverage ratio
Profitability Ratios
ROA
ROE
Gross profit margin
Operating profit margin
Net operating profit margin
Table 1: Balance Sheet Statement for 2017
Cash $7,282
Short-Term invest. 20,000
Accounts Receivable 632,160
Inventories 1,287,360
Total Current Assets 1,946,802
Gross Property, Plant & Equipment 1,202,950
Less: Depreciation 263,160
Net Property, Plant & Equipment 939,790
Total assets $2,886,592
Accounts payable $324,000
Notes payable 720,000
Accruals 284,960
Total Current Liability 1,328,960
Long-term debt 1,000,000
Common stock 460,000
Retained earnings 97,632
Total equity 557,632
Total Liability & Equity $2,886,592
Table 2:…
Selected ratios of Company X are shown below:
Inventory turnover
Days' sales uncollected
Days' purchases in accounts payable
Total asset turnover
Equity ratio
Times interest earned
2021
5.3
32.4
21.0
2.6
0.8
N.A.
2020
7.1
18.3
20.0
2.5
0.8
N.A.
Using the financial ratios provided, analyse the performance of Company X in 2021
compared to the previous year.
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting
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 - 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. 15.1SE
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
- Suppose 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_forward1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution. d. Accounts Receivable Turnover Ratio e. Average Collection Period f. Inventory Turnover Ratio g. Average Days in Inventory h. Number of days in Operating Cycle i. Debt to Total Assets Ratio j. Debt to Equity Ratio k. Times Interest Earned Ratio l. Gross Profit Ratio m. Profit Margin Ratio n. Return on Assets o. Return on Equity p. Assets Turnover Ratioarrow_forwardIn analysing the financial statements of Regis Ltd, the following ratios were calculated. Current ratio Quick ratio Receivables turnover Inventory turnover Payables turnover Gross profit margin Return on equity Required: 2023 1.1:1 0.5:1 30 days 3 times 60 days 10% 15% 2022 1.3:1 0.7:1 45 days 4 times 45 days 7% 12% (a) Evaluate the entity's liquidity using the above information. (b) A condition of obtaining a long-term loan from the Scots Bank is that the current ratio should not fall below 1.25:1. Examine the effect on this condition if Regis Ltd considers two courses of action: either to borrow cash with a long-term loan of $90,000 from the bank; or by negotiating with creditors to settle $90,000 of payables with a long-term Note Payable. Assuming the current assets and current liabilities are 660,000 and 600,000 respectively, what course of action would you recommend and why?arrow_forward
- 3. Complete the below table to calculate the balance sheet data in trend percents with 2017 as base year. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Balance Sheet Data in Trend Percents December 31, 2019, 2018 and 2017 2019 2018 2017 Assets Current assets % % 100.00 % Long-term investments 100.00 Plant assets, net 100.00 Total assets % % 100.00 % Liabilities and Equity Current liabilities % % 100.00 % Common stock 100.00 Other paid-in capital 100.00 Retained earnings 100.00 Total liabilities and equity % % 100.00 % see picturesarrow_forwardYou have been presented with the following selected information from the financial statements of one of Canada's largest dairy producers, Saputo Inc. (in $ millions): Statement of financial position 2021 2020 2019 Accounts receivable $1,217 $1,372 $1,248 Inventory 2,294 2,221 1,681 Total current assets 3,948 4,069 3,134 Total assets 13,123 13,793 9,886 Current liabilities 2,146 2,494 1,932 Total liabilities 6,679 7,234 4,465 Statement of income Sales $14,294 $14,944 $13,502 Cost of goods sold 9,575 10,181 9,179 Interest expense 79 96 67 Income tax expense 218 217 230 Net income 626 583 755arrow_forwardA) Calculate the following liquidity ratios for 2020. 1. Working capital- 2.Current Ratio- 3. Acid test ratio- 4. Accounts receivable turnover- B) calculate the following liquidity ratios for 2020. 1. Average collection period (in days)- 2. Inventory turnover (in times)- C) calculate the average days to sell inventory for 2020. 1. Average days to sell inventory-arrow_forward
- Calculate each of following ratios for year 2017 using the financial statement in Table 1-3. Total Asset turnover Fixed asset turnover Liquidity Ratio Current ratio Quick ratio Liability to assets Interest coverage ratio Profitability Ratios ROA ROE Gross profit margin Operating profit margin Net operating profit margin Table 1: Balance Sheet Statement for 2017 Cash $7,282 Short-Term invest. 20,000 Accounts Receivable 632,160 Inventories 1,287,360 Total Current Assets 1,946,802 Gross Property, Plant & Equipment 1,202,950 Less: Depreciation 263,160 Net Property, Plant & Equipment 939,790 Total assets $2,886,592 Accounts payable $324,000 Notes payable 720,000 Accruals 284,960 Total Current Liability 1,328,960 Long-term debt 1,000,000 Common stock 460,000 Retained earnings 97,632 Total equity 557,632 Total Liability & Equity $2,886,592 Table 2: Income Statement for 2017 Sales $5,834,400 COGS 4,980,000 Depreciation 116,960 Other expenses…arrow_forwardSelected financial statement data for Schmitzer Inc. is shown below:2018 2017Balance sheet:Inventories 60,000 48,000Ratios:Gross profit ratio for 2018 40 %Inventory turnover ratio for 2018 5What was the amount of net sales for 2018?arrow_forwardFind the following financial ratios for LVMH Moet Hennessy Louis Vuitton SA (use year-end figures rather than average values where appropriate) (Round your answers to 2 decimal places (e.g., 32.16).) : 2015 2016 Short-term solvency ratios: Current ratio Quick ratio Cash ratio Asset utilization ratios: Total asset turnover Inventory turnover Receivables turnover Long-term solvency ratios: Total debt ratio Debt–equity ratio Equity multiplier Times interest earned ratio Profitability ratios: Profit margin % % Return on assets % % Return on equity % %arrow_forward
- 2. Calculate each ratio for Company A using the 2020 information from the balance sheets and income statements given below. Current Ratio Quick Ratio Debt/Equity Times Interest Earned Inventory Turnover Return on Assets (ROA) Return on Equity (ROE) Market-to-book Ratio Company A Consolidated Balance Sheet (in thousands) December 31 2020 2019 Assets Current Assets: Cash and Cash Equivalents $380,626 $349,953 Accounts Receivable, net $80,545 $62,312 Inventory $30,096 $21,555 Prepaid Expenses and other current assets $57,076 $54,129 Total Current Assets $548,343 $914,794 Property and Equipment $1,458,690 $1,379,254 Operating Lease Assets $2,800,222 $1,258,293arrow_forward1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution. a. Working Capital b. Current Ratio c. Acid Test Ratio d. Accounts Receivable Turnover Ratio e. Average Collection Period f. Inventory Turnover Ratio g. Average Days in Inventory h. Number of days in Operating Cycle i. Debt to Total Assets Ratio j. Debt to Equity Ratio k. Times Interest Earned Ratio l. Gross Profit Ratio m. Profit Margin Ratio n. Return on Assets o. Return on Equity p. Assets Turnover Ratioarrow_forwardThe comparative balance sheets of SandhillClothiers are as follows: Cash Accounts receivable Inventory Total assets Cash December 31, 2014 $58,800 31,360 45,080 Inventory Total assets Perform horizontal analysis for SandhillClothiers. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, eg. 12.1%) 2014 Accounts receivable 31,360 $58,800 588,000 45,080 2013 $41,160 19,600 37,240 December 31, 2013 $41,160 19,600 588,000 568,400 37,240 568,400 Amount Increase (Decrease) Percentage % % % %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License