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
Get step-by-step solutions from verified subject matter experts
