Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Record your responses on the spreadsheet provided. Part A: Horizontal Analysis Item 2015 2014 2013 Net Sales $980 000 $900 000 $650 000 Cost of
Record your responses on the spreadsheet provided.
Part A: Horizontal Analysis
Item | 2015 | 2014 | 2013 |
---|---|---|---|
Net Sales | $980 000 | $900 000 | $650 000 |
Cost of Goods Sold | 700 000 | 640 000 | 480 000 |
Gross Profit | $280 000 | $260 000 | $170 000 |
Instructions:
- Using horizontal analysis, calculate the trend percentages for net sales, cost of goods sold, and gross profit based on the data provided for Mason Corporation.
- Explain whether the trends are favourable or unfavourable for each item.
spreasheet
Mason Corporation | |||||||
Comparative Income Statement | |||||||
December 31 | |||||||
Increase (Decrease) | Increase (Decrease) | ||||||
during 2015 | during 2014 | ||||||
2015 | 2014 | 2013 | Amount | % | Amount | % | |
Net Sales | 980,000 | 900,000 | 650,000 | ||||
Cost of Goods Sold | 700,000 | 640,000 | 480,000 | ||||
Gross Profit |
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