Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 3.27P
Learning Goal 6
P3-27 Complete ratio analysis, recognizing significant differences Home Health Inc. has come to Jane Ross for a yearly financial checkup. As a first step, Jane has prepared a complete set of ratios for fiscal years 2018 and 2019. She will use them to look for significant changes in the company's situation from one year to the next.
Home Health Inc. Financial Ratios
Ratio | 2018 | 2019 |
Current ratio | 3.25 | 3.00 |
Quick ratio | 2.50 | 2.20 |
Inventory turnover | 12.80 | 10.30 |
Average collection period | 42.6 days | 31.4 days |
Total asset turnover | 1.40 | 2.00 |
Debt ratio | 0.45 | 0.62 |
Times interest earned ratio | 4.00 | 3.85 |
Gross profit margin | 68% | 65% |
Operating profit margin | 14% | 16% |
Net profit margin | 8.3% | 8.1% |
11.6% | 16.2% | |
21.1% | 42.6% | |
Price/earnings ratio | 10.7 | 9.8 |
Market/book ratio | 1.40 | 1.25 |
- a. To focus on the degree of change, calculate the year-to-year proportional change by subtracting the year 2018 ratio from the year 2019 ratio and then dividing the difference by the year 2018 ratio. Multiply the result by 100. Preserve the positive or negative sign. The result is the percentage change in the ratio from 2018 to 2019. Calculate the proportional change for the ratios shown here.
- b. For any ratio that shows a year-to-year difference of 10% or more, state whether the difference is in the company’s favor or not.
- c. For the most significant changes (25% or more), look at the other ratios and cite at least one other change that may have contributed to the change in the ratio you are discussing.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial
performance and identify areas for making decisions for improvement
REQUIREMENT: Financial Statement Analysis
Question
Refer to the following financial statements of Delima Corporation for 2019 and 2020:
Delima Corporation
Income Statements
For the year ended 31 December (in millions)
2020
$13,198
7,750
2019
$12,397
7,108
Net sales
Cost of goods sold
Gross profit
Selling and administrative expenses
Income from operations
5,448
5,289
3,472
3,299
1,976
1,990
Interest expense
233
248
Other (income) expense, net
11
1,732
503
1,229
Income before income taxes
1,742
Income tax expense
502
Net income
1,240
Delima Corporation
Balance Sheets
31 December (in millions)
2020
2019
Assets
Current assets
Cash
$460
$444
Accounts receivables (net)
1,188
1,132
1,190
1,056
225
2,915
3,128
Inventories
Other current assets
247
Total current assets
3,027
3,281
Property (net)
5,593
$11,901
Other assets…
Problem 1: Viance Queen Company
Required:
Compute for the company’s profitability and operating efficiency ratios for 2019
Compute for the financial health ratios of the company for 2019
B.Operating Efficiency
Days in Inventory
AR Turnover
Days in AR
You have been hired as a financial analyst of a firm and your team is working on an
independent assessment of XYZ Inc. Your assistant has provided you with the following
data for XYZ Inc. and their industry.
R
r
e
d
:
Ratio 2020 2019 2018
2020-
Industry
Average
Inventory Turnover 62.65 42.42 32.25 53.25
Receivables in days 94 63 50 115
Debt to Equity 0.75 0.85 0.90 0.88
Quick Ratio 1.028 1.03 1.029 1.031
Current Ratio 1.33 1.21 1.15 1.25
Required:
a) In annual report of firm CEO wrote, we had higher liquidity largely due to an increase in highly liquid current assets (cash, account receivable and short-term marketable securities). Is the CEO correct?
b) what can you say about the firm's collection period and inventory turnover?
Chapter 3 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Ch. 3.1 - Prob. 3.1RQCh. 3.1 - Describe the purpose of each of the four major...Ch. 3.1 - Prob. 3.3RQCh. 3.1 - Prob. 3.4RQCh. 3.2 - With regard to financial ratio analysis, how do...Ch. 3.2 - What is the difference between cross-sectional and...Ch. 3.2 - Prob. 3.7RQCh. 3.2 - Prob. 3.8RQCh. 3.3 - Under what circumstances would the current ratio...Ch. 3.3 - In Table 3.5, most of the specific firms listed...
Ch. 3.4 - To assess the firms average collection period and...Ch. 3.5 - What is financial leverage?Ch. 3.5 - What ratio measures the firms degree of...Ch. 3.6 - What three ratios of profitability appear on a...Ch. 3.6 - Prob. 3.15RQCh. 3.6 - Prob. 3.16RQCh. 3.7 - What do the price/earnings (P/E) ratio and the...Ch. 3.8 - Financial ratio analysis is often divided into...Ch. 3.8 - Prob. 3.19RQCh. 3.8 - What three areas of analysis are combined in the...Ch. 3 - For the quarter ended January 28, 2017, Kroger...Ch. 3 - Learning Goals 3, 4, 5 ST3-1 Ratio formulas and...Ch. 3 - Prob. 3.2STPCh. 3 - Prob. 3.1WUECh. 3 - Learning Goal 1 E3-2 Explain why the income...Ch. 3 - Prob. 3.3WUECh. 3 - Learning Goal 3 E3-4 Bluestone Metals Inc. is a...Ch. 3 - Learning Goal 6 E3-5 If we know that a firm has a...Ch. 3 - Financial statement account identification Mark...Ch. 3 - Learning Goal 1 P3-2 1ncome statement preparation...Ch. 3 - Prob. 3.3PCh. 3 - Learning Goal 1 P3-4 Calculation of EPS and...Ch. 3 - Prob. 3.5PCh. 3 - Prob. 3.6PCh. 3 - Learning Goals 1 P3-7 Initial sale price of common...Ch. 3 - Prob. 3.8PCh. 3 - Learning Goal 1 P3-9 Changes In stockholders...Ch. 3 - Learning Goals 2, 3, 4, 5 P3-10 Ratio comparisons...Ch. 3 - Learning Goal 3 P3-11 Liquidity management Bauman...Ch. 3 - Prob. 3.12PCh. 3 - Inventory management Three companies that compete...Ch. 3 - Accounts receivable management The table below...Ch. 3 - Prob. 3.15PCh. 3 - Learning Goal 4 P3-16 Debt analysis Springfield...Ch. 3 - Prob. 3.17PCh. 3 - Learning Goals 2, 3, 4 P3-18 Using Tables 3.1,...Ch. 3 - Learning Goals 5 P3-19 Common-size statement...Ch. 3 - The relationship between financial leverage and...Ch. 3 - Learning Goal 4 P3-21 Analysis of debt ratios...Ch. 3 - Learning Goal 6 P3-22 Ratio proficiency McDougal...Ch. 3 - Learning Goal 6 P3-23 Cross-sectional ratio...Ch. 3 - Learning Goal 6 P3-24 Financial statement analysis...Ch. 3 - Learning Goals 6 P3- 25 Integrative: Complete...Ch. 3 - Learning Goal 6 P3-26 DuPont system of analysis...Ch. 3 - Learning Goal 6 P3-27 Complete ratio analysis,...Ch. 3 - Spreadsheet Exercise The income statement and...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forwardDirection: The following list of accounts for Pazado, Inc is available at the end of December 2020. Make a summary of Income Statement from the given information below with the following required data. 1. Calculate the turnover/ROI 2. Calculate the consumption of goods for sale 3. Prepare the Income Statement of Pazado, Inc for year 2020. Sales Rent Expense Depreciation Expense Utilities Expense Taxes and Licenses Goods Available for Sale Merchandise, Inventory, January 31 Salaries Expense Freight, out Uncollectible Accounts Sales Discount Sales Returns and Allowance 902,000 30,000 11,250 18,000 15,000 714,900 102,000 50,000 3.920 19,100 5,000 13,000arrow_forwardGIVE THE FORMULAS FOR THE FOLLOWING EFFICIENCY RATIOS OF NESTLE. THANK YOU Ratio Analysis Efficiency Asset turnover Inventory turnover Receivables turnover Summary of Financial Ratios of Nestle 2020 2019 Average collection period (days) 0.68 4.254 7.849 46.519 0.724 4.993 7.867 46.323 Industry Average 449 days 68 days 34 daysarrow_forward
- The following table shows data for Tommy Bourke Health Centre for the past 5 years ending the 31 December 2020 2020 2019 2018 2017 2016 Net $19,500 $17,400 $18,200 $16,500 $14,900 Sales COGS 9,500 10,300 9,500 8,900 8,000 Inventory 13,000 12,200 8,700 9,500 9,300 Net A/R 7,500 6,800 7,200 7,000 6,500 Assume 2016 is the base year. What is the trend % in Net Accounts Receivable in 2018? Select one: a. 104.62 b. 107.69 c. 110.77 O d. 100arrow_forwardUsing Excel for financial statement analysis Download an Excel temp/ate for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren Riverside Sweets, a retail candy store chain, reported the following figures: Additional financial information: a. 75% of net sales revenue are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Requirements Perform a horizontal analysis on the balance sheet for 2018 and 2019. Perform a vertical analysis on the income statement. Compute the following ratios: a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o. Asset…arrow_forwardGGG Traders recruited you as their accountant for 30 June 2020 financial year. The business has the following information Credit sales 305 000 Mark-up 30% Opening stock 18 600 Closing stock 24 800 Total expenses 34 250 Debtors Turnover 15 times Creditors turnover 8 times Current Assets 68 400 Current Liabilities 35 500 Calculate the following: a . Gross profit b. Cost of sales c. Purchases d. Inventory turnover e. Net profit f. Debtors balance g. Creditors balance h. Current Ratio i. Cash balance j. Bank overdraftarrow_forward
- ASSESSMENT: Problem #1: On June 30, 2020, PSA Trading Co. has the following informatign: revenue from sales is Po8,760; sales return is P35,50o; cost of goods sold is P8.490: salaries cost P 14,600; rent is P8,090; light and water expenses are P7.550 and miscellaneous expenses are Po,520.Generate an income statement and find: a. Gross Profit b. Net Profit or Loss Problem #2: AMA 6operative store had the following activities for year ended 2021: gross sales amounting to Po4,653, the cost of goods sold was P48,923, the operating expensés were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income slatemeni and find: a. Net Sales b. Gross Profit c. Net Profit Problem #3: AMA cooperative store had the following activities for year ended 2021: gross sales amounting to P94,653, the cost of goods sold was P48,923, the operating expenses were, P8,723.15, and refunds for defective goods amounted to P26,497.15. Generate an income statement and find: a. Net Sales…arrow_forwardK Find online the annual 10-K report for Costco Wholesale Corporation (COST) as of August 30, 2020. a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. b. Verify the DuPont Identity for Costco's ROE. c. Repeat the analysis from parts (a) and (b) using Walmart Stores (WMT) instead. Specifically, use Walmart's data as of January 31, 2020. Based on the DuPont Identity, what explains the difference between the two firms' ROE? a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. The net profit margin is%. (Round to two decimal places.) (Round to two decimal places.) The total asset turnover is The total asset turnover is The equity multiplier is b. Verify the DuPont Identity for Costco's ROE. The ROE is%. (Round to two decimal places.) c. Repeat the analysis from parts (a) and (b) using Walmart Stores (WMT) instead. Specifically, use Walmart's data as of January 31, 2020. The net profit margin is%. (Round to two decimal places.)…arrow_forwardProblem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 A.Profitability ratio a.Gross Profit Ratio b. Operating income margin c. Net profit margin d. Return on Assets: ROA (NI/Total Assets) ROA (NI/Average Assets) ROA (EBIT/Total Assets) ROA (EBIT/Average Assets) ROE (NI/Capital) ROE (NI/Average Capital B.Operating Efficiency a. Asset Turnover b. Fixed Asset Turnover c. Inventory Turnover d. Days in Inventory e. AR Turnover f. Days in AR C.Financial Health/ (Solvency and Liquidity) Solvency ratio: a. Debt to equity ratio b. Debt Ratio c. Equity Ratio d. Interest Coverage Ratio Liquidity ratio: a. Current Ratio b. Quick Ratioarrow_forward
- Problem 4-7 (IAA) Raven Company started business in March 2019. Sales for the first year totaled P4,000,000. The entity priced its merchandise to yield a 40% gross profit based on sales. Industry statistics suggest that 10% of the merchandise sold to customers will be returned. The entity estimated sales returns based on the industry average. During the year, customers returned goods with sale price of P300,000. Required: Prepare journal entries to record sales, sales returns and the year-end adjusting entry for. estimated sales returns.arrow_forwardAy 1. Using your financial analysis of Gap Clothing company, Refer to the Annual Reports located in the Class Resources. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel: Three liquidity ratios for the past 2 years Three solvency ratios for the past 2 years Three profitability ratios for the past 2 yearsarrow_forwardPreparation of SCI for a Merchandising Business Using the Multistep Approach Instructions: Prepare a Statement of Comprehensive Income for the year ended December 31,2020 the using the following account titles listed. Cost of Sales ₱2,675,000 Depreciation expense ₱105,000 Rent expense ₱240,000 Salaries expense ₱360,000 Sales Discount ₱826,500 Sales Returns and Allowances ₱275,500 Sales ₱5,510,000 Supplies expense ₱540,000 Taxes ₱92,400 Utilities expense ₱180,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License