please answer the questions provided in an excel sheet like the exampled format above:

Part A: Horizontal Analysis

Item	2022	2021	2020
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:

1. 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. Round all percentages to the nearest tenth of a percent.
2. Explain whether the trends are favourable or unfavourable for each item.

Part B: Horizontal and Vertical Analysis

	December 31, 2022	December 31, 2021
Accounts Receivable	$960 000	$600 000
Inventory	920 000	750 000
Total Assets	4 000 000	3 000 000

Instructions:

1. Using the above data taken from the comparative balance sheet of Hargrove Corporation, use a horizontal analysis comparing 2022 to the base year 2021. Round all percentages to the nearest tenth of a percent.
2. Using the above data from the comparative balance sheet of Hargrove Corporation, use a vertical analysis that will compare accounts receivable and inventory to total assets for each year. Round all percentages to the nearest tenth of a percent.
3. What conclusions can you draw?                                                                                                          
   Part C: Comparative Balance Sheet - Horizontal and Vertical Analysis

Assets	2022	2021
Current assets	$322	$280
Capital assets	678	520
Current liabilities	$180	$120
Long-term debt	200	160
Common shares	320	320
Retained earnings	300	200

Instructions:

1. Using horizontal analysis, show the percentage change for each balance sheet item of Martin Corporation, using 2021 as a base year.
2. Using vertical analysis, use a common size comparative balance sheet for Martin Corporation for each year.

Round all percentages to the nearest tenth of a percent.