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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education