Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
5th Edition
ISBN: 9780134078939
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.15E
1.
To determine
Horizontal Analysis
Horizontal analysis refers to the measurement of percentage change in the comparative financial statements. It compares the items from the financial statements from one to the other years, and indicates the trends.
To Prepare: The horizontal analysis of the comparative income statement of Company M.
2.
To determine
To Identify: The reasons of the higher percentage increase in net income than the sales revenue in 2016.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
VII. Direction: Compute and interpret.
The following comparative financial statements are provided by Avatar Industries. You were asked
to compute the different financial ratios and provide your interpretations with regards to
profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template
below to input your answer and solution.
AVATAR INDUSTRIES
AVATAR INDUSTRIES
Comparative Statement of Financial Position
For the years 2019 and 2018
Comparative Income Statement
For the years 2019 and 2018
2019
2018
2019
2018
ASSETS
Current Assets:
Sales
P200,000
P210,000
Cash & Cash Equivalent
P65,000
P70,000
Sales Returns and Allowances
40,000
25,000
Accounts Receivable
40,000
35,000
Net Sales
160,000
185,000
Marketable Secuities
40,000
35,000
Cost of Goods Sold
100,000
115,625
Inventory
100,000
80,000
Gross Profit
60,000
69,375
Total Current Assets
220,000
200,000 160,000
P445,000 P380,000
245,000
Operating Expenses:
Fixed Assets
Selling Expenses
22,000
25,000
Total…
VII. Direction: Compute and interpret.
The following comparative financial statements are provided by Avatar Industries. You were asked
to compute the different financial ratios and provide your interpretations with regards to
profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template
below to input your answer and solution.
AVATAR INDUSTRIES
AVATAR INDUSTRIES
Comparative Statement of Financial Position
For the years 2019 and 2018
Comparative Income Statement
For the years 2019 and 2018
2019
2018
2019
2018
ASSETS
Current Assets:
Sales
P200,000
P210,000
Cash & Cash Equivalent
P65,000
P70,000
Sales Returns and Allowances
40,000
25,000
Accounts Receivable
40,000
35,000
Net Sales
160,000
185,000
Marketable Securities
40,000
35,000
Cost of Goods Sold
100,000
115,625
Inventory
100,000
80,000
Gross Profit
60,000
69,375
Total Current Assets
245,000
220,000
Operating Expenses:
Fixed Assets
200,000
160,000
Selling Expenses
22,000
25,000
Total Assets
P445,000…
Income statements for Campbell Company for Year 3 and Year 4 follow:
CAMPBELL COMPANY
Income Statements
Year 4
Year 3
$180,800
120,400
19,900
14,500
Sales
$200,800
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
142,400
21,900
12,500
3,900
$180,700
5,900
$160,700
20,100
3,700
Income before taxes
20,100
Income taxes expense
6,500
Net income
$ 13,600
$ 16,400
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Complete this question by entering your answers in the tabs below.
Required A
Required B
Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year
4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234
should be entered…
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
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 - Prob. 10AQC
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. 14RQCh. 15 - Prob. 15RQCh. 15 - Prob. 15.1SECh. 15 - Performing horizontal analysis McDonald Corp....Ch. 15 - Calculating trend analysis Variline Corp. reported...Ch. 15 - Performing vertical analysis Hoosier Optical...Ch. 15 - Preparing common-size income statement Data for...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Prob. 15.9SECh. 15 - Prob. 15.10SECh. 15 - Prob. 15.11SECh. 15 - Using ratios to reconstruct a balance sheet...Ch. 15 - Prob. 15.13SECh. 15 - Prob. 15.14SECh. 15 - Prob. 15.15ECh. 15 - Computing trend analysis Grand Oaks Realty's net...Ch. 15 - Prob. 15.17ECh. 15 - Prob. 15.18ECh. 15 - Prob. 15.19ECh. 15 - Prob. 15.20ECh. 15 - Analyzing the ability to pay liabilities Big Bend...Ch. 15 - Analyzing profitability Varsity, Inc.s comparative...Ch. 15 - Prob. 15.23ECh. 15 - Using ratios to reconstruct a balance sheet The...Ch. 15 - Prob. 15.25ECh. 15 - Computing earnings per share Falconi Academy...Ch. 15 - Prob. 15.27APCh. 15 - Prob. 15.28APCh. 15 - Prob. 15.29APCh. 15 - Prob. 15.30APCh. 15 - Using ratios to evaluate a stock investment...Ch. 15 - Prob. 15.32APCh. 15 - Preparing an income statement The following...Ch. 15 - Computing trend analysis and return on common...Ch. 15 - Prob. 15.35BPCh. 15 - Prob. 15.36BPCh. 15 - Determining the effects of business transactions...Ch. 15 - Prob. 15.38BPCh. 15 - Prob. 15.39BPCh. 15 - Prob. 15.40BPCh. 15 - Prob. 15.41CPCh. 15 - Lance Berkman is the controller of Saturn, a dance...Ch. 15 - Prob. 15.1CTEI
Knowledge Booster
Similar questions
- The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardFinancial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardThe following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forward
- Horizontal Analysis of Income Statements consolidated income statements for Winged Manufacturing follow. Required: 1. Prepare common size income statements for horizontal analysis (in percentage terms, rounded to two decimal places). You do not need to include the actual dollar amounts shown above. 2. CONCEPTUAL CONNECTION Explain why net income decreased in 2018 and increased in 2019.arrow_forwardA company’s comparative statements are given below. Please conduct the following analyses: c. Calculate the three profitability ratios for year 2017 and show how ROE can be derived from the DuPont formula for this company. d. What do the analyses tell you about the company’s financial performance?arrow_forward- Please refer to the following Income Statement and Balance Sheet (see attached picture): Prepare a vertical analysis for both the income statement and balance sheet. Write a paragraph comparing the company’s performance with the industry average. Compute the following ratios and comment on what the results mean when evaluating the company: Current ratio Gross profit percentage ratio Debt ratio Profit margin ratioarrow_forward
- Requirements 1. Prepare a comparative common-size income statement for Mariner Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023 ? Explain your reasoningarrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 25.3% 53.2% Productivity (Sales/Average assets) 0.338 0.319 a. Was the company profitable in 2018?Answer b. Was the company more profitable in 2018 or 2017?Answer c. Is the change in productivity a positive or negative development?Answer d. Compute the company’s ROA for 2018 and for 2017. Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answer e. From the information provided, which of the following best explains the change in ROA during 2018? Answerarrow_forwardWhich of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.arrow_forward
- Given the income statement for the MLC (Table 4–7) and balance sheet(Table 4–4), answer the following:a. Calculate the following ratios for 2012: operating profit margin, net profitmargin, operating return on assets, net return on assets, and return onequity.b. In a written explanation, describe what each ratio means.c. In a brief paragraph, describe the overall profitability of the MLC.arrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309 a. Was the company profitable in 2018?AnswerYesNo b. Was the company more profitable in 2018 or 2017?Answer20172018 c. Is the change in productivity a positive or negative development?AnswerPositiveNegative d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answerarrow_forwardPrepare common size income statements Which company earns more net income? Which companies net income has a higher percentage of its net sales revenue?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning