Provide horizontal analysis of Ralph Lauren Corp (RL) companys income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).

Ralph Lauren's annual report can be found using an internet search engine or on the company website

An example of the excel spreadsheet is provided in the photo below:

Foods Group, Inc. E H Common Size Analysis Horizontal Analysis % Change Kraft Foods Group, Inc. Consolidated Statements of Earnings (in millions of U.S. dollars) For the Years Ended December 27, December 28, 2014 2013 Net revenues $ 18,205 $ 18,218 Cost of sales 13,360 11,395 Gross profit 4,845 6,823 Selling, general and administrative expenses 2,956 2,124 10 Asset impairment and exit costs (1) 108 Operating income 1,890 4,591 12 Interest and other expense, net (484) (501) 13 Royalty income from Mondelez International 4,090 14 1,406 Earnings before income taxes 363 1,375 15 Provision for income taxes $ 1,043 2,715 16 Net earnings 17 18 Source: 10-K, page 34 19 20 2014 100.00% 73.39% 26.61% 16.24% -0.01% 10.38% -2.66% 0.00% 7.72% 1.99% 5.73% 2013 100.00% 62.55% 37.45% 11.66% 0.59% 25.20% -2.75% 0.00% 22.45% 7.55% 14,90% $ Change $ (13) 1,965 (1,978) 832 (109) (2.701) 17 -0.07% 17.24% -28.99% 39.17% -100,93% -58.835 -3.39% (2,684 11.012) (1.672 -45.62% 73.606 61.58% $ Foods Group, Inc. E H Common Size Analysis Horizontal Analysis % Change Kraft Foods Group, Inc. Consolidated Statements of Earnings (in millions of U.S. dollars) For the Years Ended December 27, December 28, 2014 2013 Net revenues $ 18,205 $ 18,218 Cost of sales 13,360 11,395 Gross profit 4,845 6,823 Selling, general and administrative expenses 2,956 2,124 10 Asset impairment and exit costs (1) 108 Operating income 1,890 4,591 12 Interest and other expense, net (484) (501) 13 Royalty income from Mondelez International 4,090 14 1,406 Earnings before income taxes 363 1,375 15 Provision for income taxes $ 1,043 2,715 16 Net earnings 17 18 Source: 10-K, page 34 19 20 2014 100.00% 73.39% 26.61% 16.24% -0.01% 10.38% -2.66% 0.00% 7.72% 1.99% 5.73% 2013 100.00% 62.55% 37.45% 11.66% 0.59% 25.20% -2.75% 0.00% 22.45% 7.55% 14,90% $ Change $ (13) 1,965 (1,978) 832 (109) (2.701) 17 -0.07% 17.24% -28.99% 39.17% -100,93% -58.835 -3.39% (2,684 11.012) (1.672 -45.62% 73.606 61.58% $