Homework Help is Here – Start Your Trial Now!
Business
Accounting
Hello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using:   2016 2017 2018  Sales 227,279 251,589 286,378  Less: Cost of Sales 152,108 168,460 194,236  Gross Profit 75,171 83,129 92,142  Less: Selling and Administrative Expenses 38,128 40,728 46,192  Operating Income 37,043 42,401 45,950  Other income and expenses 268 118 409  Net Income Before Finance Charges and Tax 37,311 42,519 46,359  Less: Finance charges 3,212 2,658 2,998  Net Income Before Tax 34,099 39,861 43,361  Less: Income Tax Expense 10,097 11,635 12,828  Net Income After Tax 24,002 28,226 30,533 using the index numbers: Horizontal Anaysis using index numbers 2016 2017 2018 Sales       Less: Cost of Sales       Gross Profit       Less: Selling and Administrative Expenses       Operating Income       and the increase/decrease method: horizontal using  Increase/decrease method 2016 2017 2018 Operating Income       Other income and expenses       Net income before finance charges and tax       Less: Finanche charges       Net incme before tax       Less: Income tax expenses       Net income after tax

Hello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using:   2016 2017 2018  Sales 227,279 251,589 286,378  Less: Cost of Sales 152,108 168,460 194,236  Gross Profit 75,171 83,129 92,142  Less: Selling and Administrative Expenses 38,128 40,728 46,192  Operating Income 37,043 42,401 45,950  Other income and expenses 268 118 409  Net Income Before Finance Charges and Tax 37,311 42,519 46,359  Less: Finance charges 3,212 2,658 2,998  Net Income Before Tax 34,099 39,861 43,361  Less: Income Tax Expense 10,097 11,635 12,828  Net Income After Tax 24,002 28,226 30,533 using the index numbers: Horizontal Anaysis using index numbers 2016 2017 2018 Sales       Less: Cost of Sales       Gross Profit       Less: Selling and Administrative Expenses       Operating Income       and the increase/decrease method: horizontal using  Increase/decrease method 2016 2017 2018 Operating Income       Other income and expenses       Net income before finance charges and tax       Less: Finanche charges       Net incme before tax       Less: Income tax expenses       Net income after tax

Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 87PSA: A Using Common Size Statements The following income statement and vertical analysis data are...
See similar textbooks
icon
Related questions
Question

Hello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using:

  2016 2017 2018
 Sales 227,279 251,589 286,378
 Less: Cost of Sales 152,108 168,460 194,236
 Gross Profit 75,171 83,129 92,142
 Less: Selling and Administrative Expenses 38,128 40,728 46,192
 Operating Income 37,043 42,401 45,950
 Other income and expenses 268 118 409
 Net Income Before Finance Charges and Tax 37,311 42,519 46,359
 Less: Finance charges 3,212 2,658 2,998
 Net Income Before Tax 34,099 39,861 43,361
 Less: Income Tax Expense 10,097 11,635 12,828
 Net Income After Tax 24,002 28,226 30,533

using the index numbers:

Horizontal Anaysis using index numbers 2016 2017 2018
Sales      
Less: Cost of Sales      
Gross Profit      
Less: Selling and Administrative Expenses      
Operating Income      

and the increase/decrease method:

horizontal using  Increase/decrease method 2016 2017 2018
Operating Income      
Other income and expenses      
Net income before finance charges and tax      
Less: Finanche charges      
Net incme before tax      
Less: Income tax expenses      
Net income after tax      

 

 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Ratio Analysis
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
SEE MORE TEXTBOOKS