Question: i need the vertical and horizontal analysis . A. Horizontal Analysis a. Compute the difference in each line item from 2018 to 2019. b. Using

i need the vertical and horizontal analysis .

A. Horizontal Analysis

a. Compute the difference in each line item from 2018 to 2019.

b. Using 2018 as a base year, determine the change and percentage change in each line item from 2018 to 2019.

c. Did sales to customers increase or decrease from 2015 to 2016?

d. Did net income increase for decrease from 2018 to 2019?

e. What line item(s) is (are) driving the differences between sales to customers and net income from 2018 to 2019?

B. Vertical Analysis

a. Compute each line item as a percentage of sales for 2018 and 2019.

b. Which line items makes up the largest proportion of sales in 2018 and 2019? (Keep in mind that some of the items like gross profit and earnings before provision for taxes on income are subtotals.)

c. Comment of any changes in the income and expenses as a percent of sales from 2018 and 2019.

SBI Corporation Income Statements (excerpt) (dollars in millions) 2019 2018 $71,890 $70,074 Sales to customers 21,685 21,536 48,538 Cost of products sold 50,205 Gross profit Selling, marketing and administrative expenses Rescarch and development expense In-process research and development 19,945 21,203 9,095 9,046 224 29 -128 Interest income -368 Interest expense, net of portion capitalized Other (income)expense, net Restructuring 726 552 484 -2,064 491 509 19,803 3,263 $16,540 19,196 Earnings before provision for taxes on income Provision for taxes on income 3.787 $15,409 Net earnings A. Horizontal Analysis a. Compute the difference in each line item from 2018 to 2019. b. Using 2018 as a base year, determine the change and percentage change in each line item from 2018 to 2019. c. Did sales to customers increase or decrease from 2015 to 2016? d. Did net income increase for decrease from 2018 to 2019? e. What line item(s) is (are) driving the differences between sales to customers and net income from 2018 to 2019? B. Vertical Analysis a. Compute each line item as a percentage of sales for 2018 and 2019. b. Which line items makes up the largest proportion of sales in 2018 and 2019? (Keep in mind that some of the items like gross profit and earnings before provision for taxes on income are subtotals.) c. Comment of any changes in the income and expenses as a percent of sales from 2018 and 2019

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Accounting HW 1: Due date Sep 9, 2019 Simplex Corporation provides the following information at the end of the year. Salaries payable to workers at the end of the year Advertising expense for the...

The balance sheet data of Randolph Company for two recent years appears below: Assets: : Year 2 Year 1 Current assets $445 $280 Plant assets 680 520 Total assets $1,125 $800 Liabilities and...

v2.cengagenow.com C + 88 23 South University Grades - ACC1002-Acco.. CengageNOWv2 | Online.. Untitled document - Goo.. M (no subject) - kathleen.d. OptiContacts.com -- Co. Course Hero Week 4: Chapter...

The balance sheet data of Randolph Company for two recent years appears below: Assets: Year 2 Year 1 Current assets $445 $280 Plant assets 680 520 Total assets $1,125 $800 Liabilities and...

The balance sheet data for Randolph Company for 2 recent years are as follows: Assets Year 2 Year 1 $445 $280 Current assets Plant assets Total assets 680 520 $1,125 $800 $285 255 Liabilities &...

The balance sheet data of Randolph Company for two recent years appears below: 1 Assets: Year 2 Year 1 2 Current assets $440.00 $280.00 3 Plant assets 675.00 520.00 4 Total assets $1,115.00 $800.00 5...

Assets: Year 2 Year 1 Current assets $ 4 4 5 $ 2 8 0 Plant assets 6 8 0 5 2 0 Total assets $ 1 , 1 2 5 $ 8 0 0 Liabilities and stockholders' equity: Year 2 Year 1 Current liabilities $ 2 8 5 $ 1 2 0...

The balance sheet data for Randolph Company for 2 recent years are as follows: Assets Year 2 Current assets Year 1 $280 $445 Plant assets 680 Total assets 520 $800 $1,125 $285 $120 160 255...

Question 25 The balance sheet data below for Randolph lance sheet data below for Randolph Company for two recent years Assets Year 2 Current assets Plant assets Total assets $ 445 680 $1,125 Year 1...

According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018 Required: 1....

how do I do a vertical analysis on the 10-k income statement? Net operating revenues Operating costs and expenses: Salaries and benefits Supplies COMMUNITY HEALTH SYSTEMS, INC. AND SUBSIDIARIES...

For HI the fundamental oscillation frequency we = 2100 cm and the anharmonicity constant Xe = 0.0174. Given that Ey We - Xe v+ the energy of the upper-most vibrational level that can be We occupied...

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA= 2.50% +0.95RM +eA RB 1.80% + 1.10RM + eB OM 27%; R-square = 0.23; R-squareg = 0.11...

EXERCISE 6-4. Reasons for Allocating Indirect Costs Star Production Company has a security department that provides security services to other departments within the company. Department managers are...

Mocking up working models to help everyone visualize possible solutions. Question 9 options: Rapid prototyping T - shaped people Brainstorming Design Thinking

Outline the regulatory framework for workplace health and safety

What is meant by sexual discrimination? Explain why an effective response to incidents of sexual harassment in the workplace is important for the employer and manager.

What challenges does the human resources department face in identifying the contribution that the wellness initiative has provided towards the Citys goals?