Provide common-size analysis of Ralph Lauren Corp (RL) company’s 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:

Transcribed Image Text:

A1 6 x ✓ 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 29 Deferred income taxes Accrued pension costs Accrued postretirement health care costs 30 31 Other liabilities Kraft Foods Group, Inc. 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 issued at December 27, 2014 and 596,843,449 at December 28, 2013) 35 36 Additional paid-in capital 37 Retained earnings 38 39 40 41 1 Accumulated other comprehensive losses. Treasury stock, at cost TOTAL EQUITY TOTAL LIABILITIES AND EQUITY Bal Sht Inc Stmt Type here to search Ratio Graph + O|| 11 B 511 163 324 192 641 4,773 8,627 340 1,105 3,399 338 18,582 4,678 1,045 (562) (796) 4,365 22,947 3 C 685 184 313 197 479 3,410 9,976 662 405 3,080 428 17,961 4,434 1.281 (499) (29) 5,187 23,148 DP D E 2.23% 0.71% 1.41% 0.84% 2.79% 20.80% 37.60% 1.48% 4.82% 14.81% 1.47% 80.98% 0.00% 20.39% 4.55% -2.45% -3.47% 19.02% 100.00% 4 F 2.96% 0.79% 1.35% 0.85% 2.07% 14.73% 43.10% 2.86% 1.75% 13.31% 1.85% 77.59% 0.00% 19.16% 5.53% -2.16% -0.13% 22.41% 100.00% G H (174) (21) 11 (5) 162 1,363 (1,349) (322) 700 319. (90) 621 244 (236) (63) (767) (822) (201) 2 1 -25.40% -11.41% 3.51% -2.54% 33.82% 39.97% B -13.52% -48.54% 172.84% 10.36% -21.03% 3.46% 5.50% -18.42% 12.63%9 2644.83% -15.85% -0.87% 122 10 A1 6 x ✓ 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 29 Deferred income taxes Accrued pension costs Accrued postretirement health care costs 30 31 Other liabilities Kraft Foods Group, Inc. 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 issued at December 27, 2014 and 596,843,449 at December 28, 2013) 35 36 Additional paid-in capital 37 Retained earnings 38 39 40 41 1 Accumulated other comprehensive losses. Treasury stock, at cost TOTAL EQUITY TOTAL LIABILITIES AND EQUITY Bal Sht Inc Stmt Type here to search Ratio Graph + O|| 11 B 511 163 324 192 641 4,773 8,627 340 1,105 3,399 338 18,582 4,678 1,045 (562) (796) 4,365 22,947 3 C 685 184 313 197 479 3,410 9,976 662 405 3,080 428 17,961 4,434 1.281 (499) (29) 5,187 23,148 DP D E 2.23% 0.71% 1.41% 0.84% 2.79% 20.80% 37.60% 1.48% 4.82% 14.81% 1.47% 80.98% 0.00% 20.39% 4.55% -2.45% -3.47% 19.02% 100.00% 4 F 2.96% 0.79% 1.35% 0.85% 2.07% 14.73% 43.10% 2.86% 1.75% 13.31% 1.85% 77.59% 0.00% 19.16% 5.53% -2.16% -0.13% 22.41% 100.00% G H (174) (21) 11 (5) 162 1,363 (1,349) (322) 700 319. (90) 621 244 (236) (63) (767) (822) (201) 2 1 -25.40% -11.41% 3.51% -2.54% 33.82% 39.97% B -13.52% -48.54% 172.84% 10.36% -21.03% 3.46% 5.50% -18.42% 12.63%9 2644.83% -15.85% -0.87% 122 10

Answer rating: 100% (QA)

Stepbystep explanation General Information What is the name of your corporation Ralph Lauren Corporation Where are the corporate headquarters 650 Madison Avenue New York New York What is the corporati... View the full answer