Questions below this table! Company Name Fiscal Period Price to Earnings Actual Earnings per Share Actual Price to Earnings FY1 Earnings per Share FY1 3/27/20 Price FY1 Date Average Median 18.51x 10.87x 6.27 5.08 19.41x 10.57x 6.30 5.12 214.78 62.47 Walmart 01/31/2020 CVS Health 12/31/2019 Macy's 02/01/2020 Nordstrom 02/01/2020 Dillard's A 02/01/2020 Gap 02/01/2020 Amazon.com 12/31/2019 Best Buy 02/01/2020 Ralph Lauren A 12/28/2019 Costco Wholesale 02/16/2020 Target 02/01/2020 Tiffany & Co 01/31/2020 Kohl's 02/01/2020 Comps Source: User Defined Comparables 21.12x 11.54x 3.06% 5.04x 9.15% 8.39% 82.64x 10.87% 7.95% 33.37x 14.89x 28.64x 4.01x 5.19 5.08 1.81 3.18 4.37 0.93 22.99 5.75 8.55 8.52 6.36 4.45 4.37 21.41x 8.19x 4.63x 7.16x 31.32x 5.93x 67.19x 10.57% 9.03% 32.33x 14.16x 33.54x 6.87% 5.12 7.16 1.20 2.24 1.28 1.31 28.28 5.91 7.53 8.80 6.69 3.80 2.55 109.58 01/2021 58.60 12/2020 5.53 01/2021 16.01 01/2021 40.02 01/2021 7.79 01/2021 1,900.10 12/2020 62.47 01/2021 67.99 03/2020 284.33 08/2020 94.74 01/2021 127,44 01/2021 17.55 01/2021 Averages (calc): 18.51x 19.41x 1) Replicate the P/E ratio values in column E by doing the calculation (with a formula) in column M 2) What does "FY1" represent? What is its definition? 3) Re-calculate the average PE Actual and PE FY1 in E27 and G27 by removing the one large PE value which may be distorting the average on the report Develop a list of "High" PE ratios and "Low" PE ratios using the PE Actual. Then develop a separate list using the PE FY1. PE Actual Low PE FY1 Low High High 5) Are there any companies on the "High" side for one list but the "Low" side for the other? 6) Which lists are longer ... the "High" lists or the "Low" lists? Why might that be, given what has been going on in the country for the last month or so? 7a) What is Ralph Lauren's fiscal year-end month? 7b) What are the 4 quarters that are in Ralph Lauren's LTM EPS calculation (the EPS Actual)? Identify them by calendar quarter and RL's fiscal quarter Calendar: Fiscal: Questions below this table! Company Name Fiscal Period Price to Earnings Actual Earnings per Share Actual Price to Earnings FY1 Earnings per Share FY1 3/27/20 Price FY1 Date Average Median 18.51x 10.87x 6.27 5.08 19.41x 10.57x 6.30 5.12 214.78 62.47 Walmart 01/31/2020 CVS Health 12/31/2019 Macy's 02/01/2020 Nordstrom 02/01/2020 Dillard's A 02/01/2020 Gap 02/01/2020 Amazon.com 12/31/2019 Best Buy 02/01/2020 Ralph Lauren A 12/28/2019 Costco Wholesale 02/16/2020 Target 02/01/2020 Tiffany & Co 01/31/2020 Kohl's 02/01/2020 Comps Source: User Defined Comparables 21.12x 11.54x 3.06% 5.04x 9.15% 8.39% 82.64x 10.87% 7.95% 33.37x 14.89x 28.64x 4.01x 5.19 5.08 1.81 3.18 4.37 0.93 22.99 5.75 8.55 8.52 6.36 4.45 4.37 21.41x 8.19x 4.63x 7.16x 31.32x 5.93x 67.19x 10.57% 9.03% 32.33x 14.16x 33.54x 6.87% 5.12 7.16 1.20 2.24 1.28 1.31 28.28 5.91 7.53 8.80 6.69 3.80 2.55 109.58 01/2021 58.60 12/2020 5.53 01/2021 16.01 01/2021 40.02 01/2021 7.79 01/2021 1,900.10 12/2020 62.47 01/2021 67.99 03/2020 284.33 08/2020 94.74 01/2021 127,44 01/2021 17.55 01/2021 Averages (calc): 18.51x 19.41x 1) Replicate the P/E ratio values in column E by doing the calculation (with a formula) in column M 2) What does "FY1" represent? What is its definition? 3) Re-calculate the average PE Actual and PE FY1 in E27 and G27 by removing the one large PE value which may be distorting the average on the report Develop a list of "High" PE ratios and "Low" PE ratios using the PE Actual. Then develop a separate list using the PE FY1. PE Actual Low PE FY1 Low High High 5) Are there any companies on the "High" side for one list but the "Low" side for the other? 6) Which lists are longer ... the "High" lists or the "Low" lists? Why might that be, given what has been going on in the country for the last month or so? 7a) What is Ralph Lauren's fiscal year-end month? 7b) What are the 4 quarters that are in Ralph Lauren's LTM EPS calculation (the EPS Actual)? Identify them by calendar quarter and RL's fiscal quarter Calendar: Fiscal