please show example through Excel

Vertical Analysis of Income Statement

For 2014, Othere Technology Company initiated a sales promotion campaign that included the expenditure of an additional $15,000 for advertising. At the end of the year, George Wallace, the president, is presented with the following condensed comparative income statement:

Othere Technology Company Comparative Income Statement For the Years Ended December 31, 2014 and 2013
	2014		2013
Sales	$529,240		$455,510
Sales returns and allowances	5,240		4,510
Net sales	$524,000		$451,000
Cost of goods sold	246,280		230,010
Gross profit	$277,720		$220,990
Selling expenses	$104,800		$85,690
Administrative expenses	52,400		54,120
Total operating expenses	$167,680		$139,810
Income from operations	$110,040		$81,180
Other income	26,200		13,530
Income before income tax	$136,240		$94,710
Income tax expense	52,400		36,080
Net income	$83,840		$58,630

Required:

1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to net sales for each of the years. Enter percentages as whole numbers. Enter all amounts as positive numbers.

Othere Technology Company
Comparative Income Statement
For the Years Ended December 31, 2014 and 2013
		2014 Amount		2014 Percent		2013 Amount		2013 Percent
Sales		$ 529,240		%		$ 455,510		%
Sales returns and allowances		5,240		%		4,510		%
Net sales		$ 524,000		%		$ 451,000		%
Cost of goods sold		246,280		%		230,010		%
Gross profit		$ 277,720		%		$ 220,990		%
Selling expenses		$ 104,800		%		$ 85,690		%
Administrative expenses		52,400		%		54,120		%
Total operating expenses		$ 167,680		%		$ 139,810		%
Income from operations		$ 110,040		%		$ 81,180		%
Other income		26,200		%		13,530		%
Income before income tax		$ 136,240		%		$ 94,710		%
Income tax expense		52,400		%		36,080		%
Net income		$ 83,840		%		$ 58,630		%