Question: Operating data for Taylor Corporation are presented below. Using the Excel spreadsheet provided, prepare a schedule showing a vertical analysis for 2018 and 2017. 2018

Operating data for Taylor Corporation are presented below. Using the Excel spreadsheet provided, prepare a schedule showing a vertical analysis for 2018 and 2017.

2018

2017

Sales revenue

$800,000

$600,000

Cost of goods sold

520,000

408,000

Selling expenses

120,000

72,000

Administrative expenses

60,000

48,000

Income tax expense

30,000

24,000

Net income

70,000

48,000

(CGS percent. = CGS Sales rev.)

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!