Fundamentals of Financial Accounting
5th Edition
ISBN: 9780078025914
Author: Fred Phillips Associate Professor, Robert Libby, Patricia Libby
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 13, Problem 13.1ME
Calculations for Horizontal Analyses
Using the following income statements, perform the calculations needed for horizontal analyses. Round percentages to one decimal place.
| LOCKEY FENCING CORPORATION Income Statements For the Years Ended December 31 |
||
| Current | Previous | |
| Net Sales | $100,000 | $75,000 |
| Cost of Goods Sold | 58,000 | 45,000 |
| Gross Profit | 42,000 | 30,000 |
| Selling, General, and Administrative Expenses | 9,000 | 4,500 |
| Income from Operations | 33,000 | 25,500 |
| Interest Expense | 3,000 | 3,750 |
| Income before Income Tax | 30,000 | 21,750 |
| Income Tax Expense | 9,000 | 6,525 |
| Net Income | $ 21,000 | $15,225 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Required:
Using the following income statements, perform the calculations needed for vertical analyses.
Note: Round percentage values to 1 decimal place.
LOCKEY FENCING CORPORATION
Income Statements
For the Years Ended December 31
Current
Previous
Net Sales
$ 210,000
%
$ 141,000
%
Cost of Goods Sold
102,000
%
78,000
%
Gross Profit
108,000
%
63,000
%
Selling, General, and Administrative Expenses
15,600
%
8,900
%
Income from Operations
92,400
%
54,100
%
Interest Expense
5,200
%
7,050
%
Income before Income Tax
87,200
%
47,050
%
Income Tax Expense
26,160
%
14,115
Net Income
$ 61,040
% $ 32,935
%
b. The vertical analysis indicates that the cost of goods sold as a percent of sales
by 8 percentage points, while selling expenses
- by 4 percentage points, and administrative expenses
by 1 percentage points. Thus, net income as a percent of
sales
by 3 percentage points.
Vertical Analysis of Income Statement
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:
Previous Year
Sales
Cost of goods sold
Selling expenses
Administrative expenses
Income tax expense
Current Year
$447,000
272,670
71,520
71,520
13,410
$384,000
215,040
69,120
57,600
15,360
Chapter 13 Solutions
Fundamentals of Financial Accounting
Ch. 13 - What is the general goal of trend analysis?Ch. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Prob. 6QCh. 13 - Slow Cellars current ratio increased from 1.2 to...Ch. 13 - From last year to this year, Colossal Companys...Ch. 13 - From last year to this year, Berry Bam reported...Ch. 13 - Explain whether the following situations, taken...
Ch. 13 - What are the two essential characteristics of...Ch. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - 1. Which of the following ratios is not used to...Ch. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Analysts use ratios to a. Compare different...Ch. 13 - Which of the following ratios incorporates stock...Ch. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - A bank is least likely to use which of the...Ch. 13 - Prob. 9MCCh. 13 - (Supplement 13A) Which of the following items is...Ch. 13 - Calculations for Horizontal Analyses Using the...Ch. 13 - Calculations for Vertical Analyses Refer to M13-1....Ch. 13 - Interpreting Horizontal Analyses Refer to the...Ch. 13 - Interpreting Vertical Analyses Refer to the...Ch. 13 - Prob. 13.5MECh. 13 - Prob. 13.6MECh. 13 - Prob. 13.7MECh. 13 - Analyzing the Inventory Turnover Ratio A...Ch. 13 - Inferring Financial Information Using the Current...Ch. 13 - Prob. 13.10MECh. 13 - Identifying Relevant Ratios Identify the ratio...Ch. 13 - Prob. 13.12MECh. 13 - Analyzing the Impact of Accounting Alternatives...Ch. 13 - Describing the Effect of Accounting Decisions on...Ch. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Computing Profitability Ratios Use the information...Ch. 13 - Prob. 13.5ECh. 13 - Matching Each Ratio with Its Computational Formula...Ch. 13 - Computing and Interpreting Selected Liquidity...Ch. 13 - Prob. 13.8ECh. 13 - Prob. 13.9ECh. 13 - Prob. 13.10ECh. 13 - Prob. 13.11ECh. 13 - Prob. 13.12ECh. 13 - Prob. 13.13ECh. 13 - Prob. 13.14ECh. 13 - Analyzing the Impact of Alternative Inventory...Ch. 13 - Prob. 13.1CPCh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3CPCh. 13 - Prob. 13.4CPCh. 13 - Prob. 13.5CPCh. 13 - Prob. 13.6CPCh. 13 - Prob. 13.7CPCh. 13 - Prob. 13.1PACh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3PACh. 13 - Prob. 13.4PACh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PACh. 13 - Prob. 13.1PBCh. 13 - Prob. 13.2PBCh. 13 - Prob. 13.3PBCh. 13 - Prob. 13.4PBCh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PBCh. 13 - Prob. 13.1SDCCh. 13 - Prob. 13.2SDCCh. 13 - Prob. 13.5SDCCh. 13 - Prob. 13.6SDCCh. 13 - Prob. 13.7SDCCh. 13 - Prob. 13.1CC
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
- Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forward
- The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardMeasures of liquidity, solvency, and profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was 82.60 on December 31, 20Y2. Instructions Determine the following measures for 20Y2, rounding to one decimal place, including percentages, except for per-share amounts: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days sales in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forwardMeasures of liquidity, solvency, and profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was 82.60 on December 31, 20Y2. Instructions Determine the following measures for 20Y2 (round to one decimal place, including percentages, except for per-share amounts): 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days sales in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forward
- Scherer Company provided the following income statements for its first 3 years of operation: Refer to the information for Scherer Company on the previous page. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)arrow_forwardThe income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Includes both state and federal taxes. Refer to the information for Somerville Company on the previous pages. Also, assume that the price per common share for Somerville is 8.10. Required: Compute the price-earnings ratio. (Note: Round the answer to two decimal places.)arrow_forwardProfitability Ratios The following data came from the financial statements of Israel Company: Revenue $900,000 Assets $600,000 Expenses 600,000 Liabilities 100,000 Net income 300,000 Average equity 500,000 Required:arrow_forward
- Jasmine Company provided the following income statements for its first 3 years of operation: Refer to the information for Jasmine Company above. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)arrow_forwardFINANCIAL RATIOS Based on the financial statements for Jackson Enterprises (income statement, statement of owners equity, and balance sheet) shown on pages 596597, prepare the following financial ratios. All sales are credit sales. The Accounts Receivable balance on January 1, 20--, was 21,600. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and average number of days required to collect receivables 6. Inventory turnover and average number of days required to sell inventoryarrow_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
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 Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License