Horngren's Financial & Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780133866292
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…
Performing horizontal analysis—income statement
Data for Mulberry Designs, Inc. follow:
Requirements
Prepare a horizontal analysis of the comparative income statement of Mulberry Designs, Inc. Round percentage changes to one decimal place.
Why did 2018 net income increase by a higher percentage than net sales revenue?
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting (5th Edition)
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_forwardPerform a horizontal and vertical analysis. Use 1 decimal place for percentage result on vertical analysis.arrow_forwardA. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place. B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.arrow_forward
- Computing 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_forwardGiven 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_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