Cornerstones of Financial Accounting
4th Edition
ISBN: 9781337690881
Author: Jay Rich, Jeff Jones
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 97.4C
To determine
Concept introduction:
Horizontal analysis is a way of making a comparison of financial statements of two years in which one year is taken to be the base year and the comparison is done with the like items and results are given in terms of percentage.
Vertical analysis is a way of comparison of two items in the respective statement. This means that every item of
Whether there is any change in the proportion of asset investments from
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Using the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 indicated using the EXCEL template provided:
Gross profit percentage
Return on sales
Asset turnover
Return on assets
Return on common stockholders’ equity
Current ratio
Quick ratio
Operating-cash-flow-to-current-liabilities ratio
9. Accounts receivable turnover
Total assets 2017 = $21,812.6
Total stockholders’ equity 2017 = $4,327.9
Total current liabilities 2017 = $5,330.8
Accounts receivable 2017 = $1,430.1
Inventory 2017 = $1,483.6
Year-end closing stock price May 2019 = $50.93
Year-end closing stock price May 2018 = $39.37
Not Graded
Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56
Forecasting an Income Statement
ADP reports the following income statement.
AUTOMATIC DATA PROCESSING INC.
Statement of Consolidated Earnings
For Year Ended June 30, 2019, $ millions
Total revenues
Operating expenses
Systems development and programming costs
Depreciation and amortization
Total cost of revenues
Selling, general, and administrative expenses
Interest expense
Total expenses
Other (income) expense, net
Earnings before income taxes
Provision for income taxes
Net earnings
Forecast ADP's 2020 income statement assuming the following income statement relations. All percentages (other than total revenue growth and provision for income taxes) are based on historic percent of total revenues. Dollar figures are in millions
Assumptions
Total revenues growth
Depreciation and amortization
Interest expense
Other (income) expense, net
Income tax rate
13.00%
$460.5
No change
No change
25.00%
$14,175.0
7,146.0
636.0
304.4
8,086.4
3,064.0
130.0
11,280.4
(111.0)
3,005.6
713.0
$2,292.6
Note:…
Chapter 12 Solutions
Cornerstones of Financial Accounting
Ch. 12 - Describe how some of the primary groups of users...Ch. 12 - Prob. 2DQCh. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - Prob. 8DQCh. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 11DQCh. 12 - 12. Why are higher asset turnover ratios...Ch. 12 - Prob. 13DQCh. 12 - Prob. 14DQCh. 12 - Prob. 15DQCh. 12 - Prob. 16DQCh. 12 - Which of the following use financial statement...Ch. 12 - Prob. 2MCQCh. 12 - Prob. 3MCQCh. 12 - Prob. 4MCQCh. 12 - Prob. 5MCQCh. 12 - Prob. 6MCQCh. 12 - Prob. 7MCQCh. 12 - Which type of analysis compares a single...Ch. 12 - Which of the following types of analysis compares...Ch. 12 - Which of the following types of analysis is...Ch. 12 - Prob. 11MCQCh. 12 - Prob. 12MCQCh. 12 - Prob. 13MCQCh. 12 - Partial information from Fabray Companys balance...Ch. 12 - Hummel Inc. has $30,000 in current assets and...Ch. 12 - Prob. 16MCQCh. 12 - A firms quick ratio is typically computed as: a....Ch. 12 - Prob. 18MCQCh. 12 - Prob. 19MCQCh. 12 - Prob. 20MCQCh. 12 - Prob. 21MCQCh. 12 - Prob. 22MCQCh. 12 - Prob. 23MCQCh. 12 - When analyzing a companys debt to equity ratio,...Ch. 12 - Prob. 25MCQCh. 12 - Prob. 26MCQCh. 12 - Prob. 27MCQCh. 12 - Prob. 28MCQCh. 12 - Prob. 29MCQCh. 12 - Prob. 30MCQCh. 12 - Which of the following ratios is used to measure...Ch. 12 - Prob. 32MCQCh. 12 - Selected information for Berry Company is as...Ch. 12 - Which of the following ratios is used to measure a...Ch. 12 - Prob. 35MCQCh. 12 - Prob. 36MCQCh. 12 - Prob. 37MCQCh. 12 - Prob. 38MCQCh. 12 - Which of the following are not part of common...Ch. 12 - Prob. 40MCQCh. 12 - Prob. 41MCQCh. 12 - Prob. 42MCQCh. 12 - Which of the following is not included in the...Ch. 12 - When a Dupont analysis reveals that a company has...Ch. 12 - Prob. 45MCQCh. 12 - Cross Sectional Analysis Cross sectional analysis...Ch. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Short-Term Liquidity Ratios Three ratios...Ch. 12 - Debt Management Ratios Selected data from the...Ch. 12 - Debt Management and Short-Term Liquidity Ratios...Ch. 12 - Asset Efficiency Ratios Selected financial...Ch. 12 - Profitability Ratios The following data came from...Ch. 12 - Prob. 54CECh. 12 - Prob. 55CECh. 12 - Prob. 56CECh. 12 - Prob. 57BECh. 12 - Prob. 58BECh. 12 - Prob. 59BECh. 12 - Short-Term Liquidity Ratios Larry, Curly, and Moe...Ch. 12 - Debt Management Ratios Glow Corporation provides...Ch. 12 - Debt Management and Short-Term Liquidity Ratios...Ch. 12 - Asset Efficiency Ratios Rumsford Inc.s financial...Ch. 12 - Prob. 64BECh. 12 - Profitability Ratios Tinker Corporation operates...Ch. 12 - Profitability Ratios Katrina Corp. is a publicly...Ch. 12 - Prob. 67BECh. 12 - Prob. 68ECh. 12 - Prob. 69ECh. 12 - Prob. 70ECh. 12 - Prob. 71ECh. 12 - Horizontal Analysis of Income Statements...Ch. 12 - Prob. 73ECh. 12 - Prob. 74ECh. 12 - Prob. 75ECh. 12 - Prob. 76ECh. 12 - Prob. 77ECh. 12 - Prob. 78ECh. 12 - Prob. 79ECh. 12 - Asset Efficiency Ratios Refer to financial...Ch. 12 - Prob. 81ECh. 12 - Prob. 82ECh. 12 - Prob. 83ECh. 12 - Prob. 84PSACh. 12 - Prob. 85PSACh. 12 - Prob. 86PSACh. 12 - A Using Common Size Statements The following...Ch. 12 - Prob. 88PSACh. 12 - Prob. 89PSACh. 12 - Prob. 90PSACh. 12 - A Comparing Financial Ratios Presented below are...Ch. 12 - A Preparation of Ratios Refer to the financial...Ch. 12 - Accounting Alternatives and Financial Analysis...Ch. 12 - Prob. 84PSBCh. 12 - Prob. 85PSBCh. 12 - Prob. 86PSBCh. 12 - Prob. 87PSBCh. 12 - Prob. 88PSBCh. 12 - Prob. 89PSBCh. 12 - Prob. 90PSBCh. 12 - Comparing Financial Ratios Presented below are...Ch. 12 - Prob. 92PSBCh. 12 - Problem 1 2-93B Accounting Alternatives and...Ch. 12 - Prob. 94CCh. 12 - Prob. 95.1CCh. 12 - Prob. 95.2CCh. 12 - Prob. 96.1CCh. 12 - Prob. 96.2CCh. 12 - Prob. 97.1CCh. 12 - Prob. 97.2CCh. 12 - Prob. 97.3CCh. 12 - Prob. 97.4CCh. 12 - Analyzing Growth Consolidated financial statements...Ch. 12 - Analyzing Growth Consolidated financial statements...Ch. 12 - Prob. 98.1CCh. 12 - Prob. 98.2CCh. 12 - Prob. 98.3CCh. 12 - CONTINUING PROBLEM: FRONT ROW ENTERTAINMENT The...Ch. 12 - Prob. 99.2CCh. 12 - Prob. 99.3CCh. 12 - Prob. 99.4CCh. 12 - Prob. 99.5C
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
- Analyzing Growth Consolidated financial statements for Initech Corporation follow Did the income statement change as between 2018 and 2019 as the balance sheet?arrow_forwardProfitability Ratios Katrina Corp. is a publicly traded company on a large stock exchange. Katrinas financial statement for 2019 and 2018 included the following data: Required: Calculate Katrinas earnings per share as it would be reported on the 2019 income statement.arrow_forwardRatio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?arrow_forward
- Debt Management and Short-Term Liquidity Ratios The following items appear on the balance sheet of Figgins Company at the end of 2018 and 2019: Required: Between 2018 and 2019, indicate whether Figgins debt to equity ratio increased or decreased. Also, indicate whether Figgins current ratio increased or decreased. Interpret these ratios.arrow_forwardBalance sheet data for Brimstone Company follows: a.Determine the working capital and current ratio for 2016 and 2015. b.Does the change in the current ratio from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardVarious Dividends Carlyon Company listed the following items in its December 31, 2018, financial statements: During 2019, the following transactions occurred: Required:arrow_forward
- What amount of total assets does the company report on its balance sheet? What amount of total liabilities does the company report on its balance sheet?arrow_forwardWhat is the year-over-year revenue change percent? Use the attached financial data to calculate the ratios for 2022. Round to the nearest decimal. Abercrombie & Fitch Co (ANF) Financial Data Revenues Cost of Sales Total Operating Expenses Interest Expense Income Tax Expense Diluted Weighted Shares Outstanding Cash + Equivalents Accounts Receivable Inventories Total Current Assets Total Assets Accounts Payable Total Current Liabilities Total Stockholders' Equity ANF Stock Price = $10.30 Select one O A. 5.3% B. 14.4% C. -1.4% O D. -3.5% 2022 $3,659.3 $1,545.9 $2,026.9 $28.5 $37.8 52.8 $257.3 $108.5 $742.0 $1,220.4 $2,694.0 $322.1 $935.5 $656.1 2021 $3,712.8 $1,400.8 $1,968.9 $34.1 $38.9 62.6 $823.1 $69.1 $525.9 $1,507.8 $2,939.5 $374.8 $1,015.2 $826.1arrow_forwardUsing the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 indicated using the EXCEL template provided: Gross profit percentage Return on sales Asset turnover Return on assets Return on common stockholders’ equity Current ratio Quick ratio Operating-cash-flow-to-current-liabilities ratio Accounts receivable turnover Average collection period Inventory turnover Days’ sales in inventory Debt-to-equity ratio Times-interest-earned ratio Operating-cash-flow-to-capital-expenditures ratio Earnings per share Price-earnings ratio Dividend yield Dividend payout ratio Total assets 2017 = $21,812.6 Total stockholders’ equity 2017 = $4,327.9 Total current liabilities 2017 = $5,330.8 Accounts receivable 2017 = $1,430.1 Inventory 2017 = $1,483.6 Year-end closing stock price May 2019 = $50.93 Year-end closing stock price May 2018 = $39.37 Perform a comparative analysis of the…arrow_forward
- Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56 To calculate averages use (current year balance + poor year balance) / 2) Round percentages to 1 decimal place; round other answers to 2 decimal places.arrow_forwardDIRECTION: Compute the following PROFITABILITY RATIOS Gross Margin= Gross Profit/Net Sales Net Profit Margin= Net Profit/ Net Sales Return on Equity= Profit/Shareholder's Equity Return on Asset= Profit/Total Asset TREND ANALYSIS Net Income Growth Rate Total Assets Growth Rate And also compute the percentage beside the columns December 31, December 31, PERCENTAGE 2021 2020 USD USD Assets Current assets Cash and cash equivalents 34,115,412 25,681,845 Short-term financial instruments 71,417,748 80,798,680 Short-term financial assets at amortized cost 2,944,705 2,409,853 Short-term financial assets at fair value through profit or loss 35,624 62,452 Trade receivables 35,585,565 27,065,012 Non-trade receivables 3,930,828 3,150,548 Prepaid expenses 2,042,001 1,980,685 Inventories 36,172,043 28,007,314 Other current assets 4,441,629 3,281,589 Assets held-for-sale - 812,370 Total Current Assets…arrow_forwarddiscuss in details the result of the Company's Horizontal and Vertical Analysis from 2014-2018arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license