Provide common-size analysis of Ralph Lauren Corp (RL) companys income statement and balance sheet for the 2 most recent years (must be done using Excel 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:

A1 Kraft Foods Group, Inc. C D E F G H 1 511 685 163 184 324 313 192 641 4,773 8,627 340 1,105 3,399 338 18,582 21 Accrued marketing 22 Accrued employment costs 23 Dividends payable 24 Accrued postretirement health care costs 25 Other current liabilities 26 Total current liabilities 27 Long-term debt 28 Deferred income taxes 29 Accrued pension costs 30 Accrued postretirement health care costs 31 Other liabilities 32 TOTAL LIABILITIES 33 Commitments and Contingencies (Note 11) 34 EQUITY Common stock, no par value (5,000,000 shares authorized; 601,402,816 shares 35 issued at December 27, 2014 and 596,843,449 at December 28, 2013) 36 Additional paid-in capital 37 Retained earnings 38 Accumulated other comprehensive losses 39 Treasury stock, at cost TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 197 479 3,410 9,976 662 405 3,080 428 17,961 2.23% 0.71% 1.41% 0.84% 2.79% 20.80% 37.60% 1.48% 4.82% 14.81% 1.47% 80.98% 2.96% 0.79% 1.35% 0.85% 2.07% 14.73% 43.10% 2.86% 1.75% 13.31% 1.85% 77.5996 (174) (21) 11 (5) 162 1,363 (1,349) (322) 700 319 (90) -25.40% -11.41% 3.51% -2.54% 33.82% 39.97% -13,52% -48.64% 172,84% 10.36% -21.03% 3.46% 621 244 5.5096 -18.42% 4,678 1,045 (562) (796) 4,365 22,947 0.00% 20.39% 4,55% =2.4596 -3.47% 19.02% 100.00% 4,434 1,281 (499) (29) 5,187 23,148 12.639 0.00% 19.16% 5.53% -2.1696 -0.13% 22.41% 100.00% (236) (63) 1767) (822) 201) 2644.83% 15.8596 -0,8796 40 Bal Sht Inc Stmt Ratio Graph 1 1 HH Type here to search Foods Group, Inc. D E F G H Common Size Analysis Horizontal Analysis 2013 100.00% 62.55% 37.45% B Kraft Foods Group, Inc. Consolidated Statements of Earnings (in millions of U.S. dollars) For the Years Ended December 27, December 28, 2014 2013 6 Net revenues $ 18,205 $ 18,218 Cost of sales 13,360 11,395 3 Gross profit 4,845 6,823 9 Selling, general and administrative expenses 2,956 2,124 10 Asset impairment and exit costs (1) 108 11 1,890 4,591 Operating income 12 Interest and other expense, net (484) (501) 13 Royalty income from Mondelez International 1,406 4,090 14 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 21 $ Change $ (13) 1.965 (1,978) 832 (109) (2,701) 17 2014 100.00% 73.39% 26.61% 16.24% -0.01% 10.38% -2.66% 0.00% 7.72% 1.99% 5.73% 11.66% % Change -0.07% 17.24% -28.99% 39.17% -100.999 -58.835 -3.39% 0.59% 25.20% -2.75% 0.00% 22.4596 7.55% 14,90% -65.62% (2.684 (2012 (1.672 -61.56% 22 A1 Kraft Foods Group, Inc. C D E F G H 1 511 685 163 184 324 313 192 641 4,773 8,627 340 1,105 3,399 338 18,582 21 Accrued marketing 22 Accrued employment costs 23 Dividends payable 24 Accrued postretirement health care costs 25 Other current liabilities 26 Total current liabilities 27 Long-term debt 28 Deferred income taxes 29 Accrued pension costs 30 Accrued postretirement health care costs 31 Other liabilities 32 TOTAL LIABILITIES 33 Commitments and Contingencies (Note 11) 34 EQUITY Common stock, no par value (5,000,000 shares authorized; 601,402,816 shares 35 issued at December 27, 2014 and 596,843,449 at December 28, 2013) 36 Additional paid-in capital 37 Retained earnings 38 Accumulated other comprehensive losses 39 Treasury stock, at cost TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 197 479 3,410 9,976 662 405 3,080 428 17,961 2.23% 0.71% 1.41% 0.84% 2.79% 20.80% 37.60% 1.48% 4.82% 14.81% 1.47% 80.98% 2.96% 0.79% 1.35% 0.85% 2.07% 14.73% 43.10% 2.86% 1.75% 13.31% 1.85% 77.5996 (174) (21) 11 (5) 162 1,363 (1,349) (322) 700 319 (90) -25.40% -11.41% 3.51% -2.54% 33.82% 39.97% -13,52% -48.64% 172,84% 10.36% -21.03% 3.46% 621 244 5.5096 -18.42% 4,678 1,045 (562) (796) 4,365 22,947 0.00% 20.39% 4,55% =2.4596 -3.47% 19.02% 100.00% 4,434 1,281 (499) (29) 5,187 23,148 12.639 0.00% 19.16% 5.53% -2.1696 -0.13% 22.41% 100.00% (236) (63) 1767) (822) 201) 2644.83% 15.8596 -0,8796 40 Bal Sht Inc Stmt Ratio Graph 1 1 HH Type here to search Foods Group, Inc. D E F G H Common Size Analysis Horizontal Analysis 2013 100.00% 62.55% 37.45% B Kraft Foods Group, Inc. Consolidated Statements of Earnings (in millions of U.S. dollars) For the Years Ended December 27, December 28, 2014 2013 6 Net revenues $ 18,205 $ 18,218 Cost of sales 13,360 11,395 3 Gross profit 4,845 6,823 9 Selling, general and administrative expenses 2,956 2,124 10 Asset impairment and exit costs (1) 108 11 1,890 4,591 Operating income 12 Interest and other expense, net (484) (501) 13 Royalty income from Mondelez International 1,406 4,090 14 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 21 $ Change $ (13) 1.965 (1,978) 832 (109) (2,701) 17 2014 100.00% 73.39% 26.61% 16.24% -0.01% 10.38% -2.66% 0.00% 7.72% 1.99% 5.73% 11.66% % Change -0.07% 17.24% -28.99% 39.17% -100.999 -58.835 -3.39% 0.59% 25.20% -2.75% 0.00% 22.4596 7.55% 14,90% -65.62% (2.684 (2012 (1.672 -61.56% 22