stock valuation model, prepare a pro forma Income Statement in MS Excel using a minimum projection of three years,You need to include the most recent income statement for your company Ralph Lauren Corp that is part of the 10-K This information can then be used to calculate the fair value of the companys stock price, as based on the stock valuation formulas All assumptions and formulas used for the pro forma projections and the companys fair value must be included at the end of your model. Once a fair value is reached, this can be compared to a recent quote of the companys stock price to determine whether or not the company is fairly valued at its most recent trading price.

Download CSV Year Ending Year Ending Mar 2020 (Update) Year Ending Mar 2019 (Update) Year Ending Mar 2018 (Update) Apr 2017 (Update) Net Sales 6,159.80 6,313.00 6,182.30 6,652.80 Revenue 6,159.80 6,313.00 6.182.30 6,652.80 Total Revenue 6,159.80 6,313.00 6,182.30 6,652.80 Cost of Revenue 2,504.30 2,419.80 2,423.00 3,001.70 Cost of Revenue, Total 2,504.30 2.419.80 2.423.00 3.001.70 Gross Profit 3,655.50 3,893.20 3,759.30 3,651.10 Selling/General/Administrative Expense 3,132.10 3,079.70 3,021.00 2.802 40 Labor & Related Expense 100.60 88.60 74 50 63.60 Selling/General/Administrative Expenses, Total 3,232.70 3.168.30 3.095.50 2,866.00 18.10 - 283.40 Depreciation Amortization of Intangibles, Operating 24.10 Depreciation/Amortization 18.10 307.50 Restructuring Charge 56.10 137.30 115.60 318.60 Impairment-Assets Held for Use 31.60 25.80 50.00 253.80 Other Unusual Expense (Income) Unusual Expense (Income) 87.70 163.10 165.60 572.40 Total Operating Expense 5,842.80 5,751.20 5,684.10 6,747.60 317.00 561.80 498.20 Operating Income -94.80 -36.60 Interest Expense - Non-Operating -20.70 -18.20 -12.40 209.00 458.50 384.20 Extraordinary Item -99.30 125.30 -27.60 -221.40 Total Extraordinary Items 125.30 -27.60 -221.40 Net Income 384.30 430.90 162.80 -99.30 259.00 458.50 384.20 -99.30 Income Available to Common Excluding Extraordinary Items Income Available to Common Stocks Including Extraordinary Items Basic Weighted Average Shares 384.30 430.90 162.80 -99.30 75.80 80.60 81.70 82.70 3.42 5.69 Basic EPS Excluding Extraordinary Items Basic EPS Including Extraordinary Items 4.70 -1.20 5.07 5.35 1.99 -1.20 Diluted Net Income 384.30 430.90 162.80 -99.30 Diluted Weighted Average Shares 77.20 81.70 82.50 82.70 3.35 5.61 4.66 Diluted EPS Excluding Extraordinary Items Diluted EPS Including Extraordinary Items -1.20 4.98 5.27 1.97 -1.20 DPS - Common Stock Primary Issue 2.69 2.38 2.00 2.00 Gross Dividends - Common Stock 204.90 198.90 162.50 163.80 Total Special Items 87.70 163.10 165.60 572.40 Normalized Income Before Taxes 414.10 745.60 654.80 467.50 18.11 34.72 35.54 200.34 Effect of Special items on Income Taxes Income Taxes Excluding Impact of Special Items 85.51 158.72 140.54 194.74 Normalized Income After Taxes 328.59 586.88 514.26 272.76 Normalized Income Available to Common 328.59 586.88 514.26 272.76 Basic Normalized EPS 4.33 7.28 6.29 3.30 4.26 Diluted Normalized EPS 7.18 6.23 3.30 22.90 23.50 24.00 24.10 Amortization of Intangibles, Supplemental Depreciation Supplemental 246.60 257.80 271.20 283.40 24.10 18.10 307.50 56.10 137.30 115.60 318.60 31.60 25.80 50.00 253.80 87.70 163.10 165.60 572.40 Depreciation/Amortization Restructuring Charge Impairment-Assets Held for Use Other Unusual Expense (Income) Unusual Expense (Income) Total Operating Expense Operating Income Interest Expense - Non-Operating Interest Expense, Net Non-Operating Interest Income, Non-Operating Investment Income, Non-Operating 5,842.80 5,751.20 5,684.10 6,747.60 317.00 561.80 498.20 -94.80 -36.60 -20.70 -18.20 -12.40 -36.60 -20.70 -18.20 -12.40 34.40 40.80 12.30 6.40 35.00 3.10 2.40 -4. 10 Interest/Investment Income, Non-Operating 69.40 43.90 14.70 2.30 32.80 23.20 -3.50 -10.10 Interest Income (Expense), Net-Non-Operating, Total Other Non-Operating Income (Expense) -23.40 -2.50 -5.50 Other Net -23.40 -2.50 -5.50 Net Income Before Taxes 326.40 582.50 489.20 -104.90 67.40 124.00 105.00 Income Tax Total -5.60 259.00 458.50 384.20 Income After Tax -99.30 259.00 458.50 384.20 199.30 Net Income Before Extraordinary Items Extraordinary Item 125.30 7.60 -221.40 125.30 -27.60 -221.40 Total Extraordinary Items Download CSV Year Ending Year Ending Mar 2020 (Update) Year Ending Mar 2019 (Update) Year Ending Mar 2018 (Update) Apr 2017 (Update) Net Sales 6,159.80 6,313.00 6,182.30 6,652.80 Revenue 6,159.80 6,313.00 6.182.30 6,652.80 Total Revenue 6,159.80 6,313.00 6,182.30 6,652.80 Cost of Revenue 2,504.30 2,419.80 2,423.00 3,001.70 Cost of Revenue, Total 2,504.30 2.419.80 2.423.00 3.001.70 Gross Profit 3,655.50 3,893.20 3,759.30 3,651.10 Selling/General/Administrative Expense 3,132.10 3,079.70 3,021.00 2.802 40 Labor & Related Expense 100.60 88.60 74 50 63.60 Selling/General/Administrative Expenses, Total 3,232.70 3.168.30 3.095.50 2,866.00 18.10 - 283.40 Depreciation Amortization of Intangibles, Operating 24.10 Depreciation/Amortization 18.10 307.50 Restructuring Charge 56.10 137.30 115.60 318.60 Impairment-Assets Held for Use 31.60 25.80 50.00 253.80 Other Unusual Expense (Income) Unusual Expense (Income) 87.70 163.10 165.60 572.40 Total Operating Expense 5,842.80 5,751.20 5,684.10 6,747.60 317.00 561.80 498.20 Operating Income -94.80 -36.60 Interest Expense - Non-Operating -20.70 -18.20 -12.40 209.00 458.50 384.20 Extraordinary Item -99.30 125.30 -27.60 -221.40 Total Extraordinary Items 125.30 -27.60 -221.40 Net Income 384.30 430.90 162.80 -99.30 259.00 458.50 384.20 -99.30 Income Available to Common Excluding Extraordinary Items Income Available to Common Stocks Including Extraordinary Items Basic Weighted Average Shares 384.30 430.90 162.80 -99.30 75.80 80.60 81.70 82.70 3.42 5.69 Basic EPS Excluding Extraordinary Items Basic EPS Including Extraordinary Items 4.70 -1.20 5.07 5.35 1.99 -1.20 Diluted Net Income 384.30 430.90 162.80 -99.30 Diluted Weighted Average Shares 77.20 81.70 82.50 82.70 3.35 5.61 4.66 Diluted EPS Excluding Extraordinary Items Diluted EPS Including Extraordinary Items -1.20 4.98 5.27 1.97 -1.20 DPS - Common Stock Primary Issue 2.69 2.38 2.00 2.00 Gross Dividends - Common Stock 204.90 198.90 162.50 163.80 Total Special Items 87.70 163.10 165.60 572.40 Normalized Income Before Taxes 414.10 745.60 654.80 467.50 18.11 34.72 35.54 200.34 Effect of Special items on Income Taxes Income Taxes Excluding Impact of Special Items 85.51 158.72 140.54 194.74 Normalized Income After Taxes 328.59 586.88 514.26 272.76 Normalized Income Available to Common 328.59 586.88 514.26 272.76 Basic Normalized EPS 4.33 7.28 6.29 3.30 4.26 Diluted Normalized EPS 7.18 6.23 3.30 22.90 23.50 24.00 24.10 Amortization of Intangibles, Supplemental Depreciation Supplemental 246.60 257.80 271.20 283.40 24.10 18.10 307.50 56.10 137.30 115.60 318.60 31.60 25.80 50.00 253.80 87.70 163.10 165.60 572.40 Depreciation/Amortization Restructuring Charge Impairment-Assets Held for Use Other Unusual Expense (Income) Unusual Expense (Income) Total Operating Expense Operating Income Interest Expense - Non-Operating Interest Expense, Net Non-Operating Interest Income, Non-Operating Investment Income, Non-Operating 5,842.80 5,751.20 5,684.10 6,747.60 317.00 561.80 498.20 -94.80 -36.60 -20.70 -18.20 -12.40 -36.60 -20.70 -18.20 -12.40 34.40 40.80 12.30 6.40 35.00 3.10 2.40 -4. 10 Interest/Investment Income, Non-Operating 69.40 43.90 14.70 2.30 32.80 23.20 -3.50 -10.10 Interest Income (Expense), Net-Non-Operating, Total Other Non-Operating Income (Expense) -23.40 -2.50 -5.50 Other Net -23.40 -2.50 -5.50 Net Income Before Taxes 326.40 582.50 489.20 -104.90 67.40 124.00 105.00 Income Tax Total -5.60 259.00 458.50 384.20 Income After Tax -99.30 259.00 458.50 384.20 199.30 Net Income Before Extraordinary Items Extraordinary Item 125.30 7.60 -221.40 125.30 -27.60 -221.40 Total Extraordinary Items