Question: Record your responses in a spreadsheet. Part A: Horizontal Analysis Instructions: 1. Using horizontal analysis, calculate the trend percentages for net sales, cost of goods

Record your responses in a spreadsheet. Part A: Horizontal Analysis Instructions: 1. Using horizontal analysis, calculate the trend percentages for net sales, cost of goods sold, anc gross profit based on the data provided for Mason Corporation. Fill in the 3 missing values first. 2. Explain whether the trends are favourable or unfavourable for each item. Part B: Horizontal and Vertical Analysis Instructions: 1. Using the above data taken from the comparative balance sheet of Hargrove Corporation, complete a horizontal analysis comparing 2015 to the base year 2014. 2. Using the above data from the comparative balance sheet of Hargrove Corporation, complete vertical analysis that will compare accounts receivable and inventory to total assets for each year. 3. What conclusions can you draw
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
