Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The income statement for Sweetwater Ltd. is shown below: SWEETWATER LTD. Income Statement Year Ended December 31 (in millions) 2018 2017 2016 Sales $ 1,603
The income statement for Sweetwater Ltd. is shown below:
SWEETWATER LTD. Income Statement Year Ended December 31 (in millions) | |||||||
---|---|---|---|---|---|---|---|
2018 | 2017 | 2016 | |||||
Sales | $ 1,603 | $ 1,403 | $ 1,205 | ||||
Cost of goods sold | 907 | 754 | 602 | ||||
Gross profit | 696 | 649 | 603 | ||||
Operating expenses | 516 | 407 | 401 | ||||
Income from operations | 180 | 242 | 202 | ||||
Interest expense | 80 | 50 | 40 | ||||
Income before income tax | 100 | 192 | 162 | ||||
Income tax expense | 25 | 48 | 41 | ||||
Net income | $ 75 | $ 144 | $ 121 |
Part 1
Using horizontal analysis, calculate the horizontal percentage of a base-year amount, assuming 2016 is the base year. (Round answers to 1 decimal place, e.g. 5.2%.)
SWEETWATER LTD. Horizontal Analysis of Income Statement (% of base-year amount) Year Ended December 31 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
2018 | 2017 | 2016 | ||||||||
Sales | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Cost of goods sold | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Gross profit | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Operating expenses | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Income from operations | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Interest expense | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Income before income tax | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Income tax expense | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Net income | enter percentages | % | enter percentages | % | enter percentages | % |
Part 2
Using vertical analysis, calculate the percentage of the base amount for each year. (Round answers to 1 decimal place, e.g. 5.2%. Enter negative amounts using either a negative sign preceding the number e.g. -45.1% or parentheses e.g. (45.1)%.)
SWEETWATER LTD. Vertical Analysis of Income Statement | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2018 | 2017 | 2016 | |||||||||||
Amount | Percent | Amount | Percent | Amount | Percent | ||||||||
Sales | $ 1,603 | enter percentages% | $ 1,403 | enter percentages% | $ 1,205 | enter percentages% | |||||||
Cost of goods sold | 907 | enter percentages% | 754 | enter percentages% | 602 | enter percentages% | |||||||
Gross profit | 696 | enter percentages% | 649 | enter percentages% | 603 | enter percentages% | |||||||
Operating expenses | 516 | enter percentages% | 407 | enter percentages% | 401 | enter percentages% | |||||||
Income from operations | 180 | enter percentages% | 242 | enter percentages% | 202 | enter percentages% | |||||||
Interest expense | 80 | enter percentages% | 50 | enter percentages% | 40 | enter percentages% | |||||||
Income before income tax | 100 | enter percentages% | 192 | enter percentages% | 162 | enter percentages% | |||||||
Income tax expense | 25 | enter percentages% | 48 | enter percentages% | 41 | enter percentages% | |||||||
Net income | $ 75 | enter percentages% | $ 144 | enter percentages% | $ 121 | enter percentages% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started