The following condensed income statement is for Technology, Inc., a manufacturer of consumer technology products including smartphones, tablets, and laptop computers:

Technology, Inc. Income Statement Years Ended September 30, 2020 and 2019 (In millions)
	2020		2019
Net sales	$	233,715	$	182,795
Cost of goods sold		140,089		112,258
Gross margin		93,626		70,537
Research and development		8,067		6,041
Selling and administrative expenses		14,329		11,993
Operating income		71,230		52,503
Other income (expenses), net		1,285		980
Income before taxes		72,515		53,483
Income tax expense		19,121		13,973
Net income	$	53,394	$	39,510

REQUIRED:

1. Using the Excel worksheet provided, prepare a trend analysis (horizontal analysis) from 2019 to 2020. Round percent computations to one decimal place.
2. Using the Excel worksheet provided, prepare a common-size analysis (vertical analysis) for 2019 and 2020. Round percent computations to one decimal place.

For example, net sales increase of 27.9% equals $50,920/182,795

...2020 cost of goods sold percent of 59.9% equals $140,089 cost of goods sold/$233,715 net sales

Please help with 1-2!! Will give like!! thanks

1. Trend Analysis Technology, Inc. Income Statement Years ended September 30, 2020 and 2019 (dollar amounts are in millions) Increase (Decrease) from 2019 to 2020 2020 2019 Amount Percent Net sales $233,715 $182.795 $50,920 27.9% Cost of goods sold Gross margin Selling and administrative expenses Operating income Other income (expenses), net Income before taxes Income tax expense Net income Note: Percent change for each line item is found by dividing the increase (decrease) amount by the 2019 amount. For example, net sales increase of 27.9% equals $50,920 - $182,795. 2021 by Flat World Knowledge, Inc. TREND ANALYSIS 2. Common Size Analysis Technology, Inc. Income Statement Years ended September 30, 2020 and 2019 (dollar amounts are in millions) 2020 2019 Amount Percent Amount Percent Net sales $233,715 100.0% $182,795 100.0% Cost of goods sold 140,089 59.9% 112,258 61.4% Gross margin Selling and administrative expenses Operating income Other income (expenses), net Income before taxes Income tax expense Net income Note: All percentages use net sales as the base. For example, 2020 cost of goods sold percent of 59.9% equals $140,089 cost of goods sold - $233,715 net sales. Note that rounding issues sometimes cause subtotals in the percent column to be off by a small amou 2021 by Flat World Knowledge, Inc. COMMON SIZE (HORIZONTAL)