Part 1 Simple Computation for PE Multiples T12M EPS Announcing Date 4/17/2019 7/9/2019 10/3/2019 2/13/2020 4/28/2020 7/13/2020 10/1/2020 Fiscal Period Q1 2019 Q2 2019 Q3 2019 Q4 2019 Q1 2020 Q2 2020 Q3 2020 Reported EPS (Actual) 0.972 1.539 1.555 1.452 1.075 1.318 1.664 Stock Price (Quarter-End) 127.010 131.740 137.930 146.470 136.320 134.910 140.800 ? ? ? ? Problem 1) Compute trailing EPS for Q4 2019, Q1 2020, Q2 2020, and Q3 2020. (Note: In the above table, all the reported EPS values are expressed as quarterly ratios. Thus, all the trailing EPS should be annualized.)! Problem 2) Using trailing EPS for Q4 2019, Q1 2020, Q2 2020, and Q3 2020, compute the respective trailing PE multiples. Problem 3) The following table summarizes the estimated PE, estimated EPS, and estimated trailing EPS. Compute the forward PE multiple as of 10/1/2020 using the next 12 month estimated EPS 2 Problem 4) Compare the trading PE and the forward PE on 10/1/2020. Problem 5) The price for the company on 10/22/2020 is trading at 139.5. Using the trailing PE and forward PE multiples, identify your target price and discuss whether the price is cheap or expensive. 1 The trailing EPS (T12M EPS) for 2/13/2020 (Q4 2019) is, EPS01-2019+EPS Q2-2019+EPS932019 +EPSQ42019) 4 2 The average of the estimated EPS for 10/1/2020 (Q4 20120) is, EPS042020+EP SQ12021 +EPSQ2-2021 +EP SQ32021) 4 Announcing Date 2/12/2021 4/28/2021 7/13/2021 10/1/2021 Fiscal Period Q4 2020 Q1 2021 Q2 2021 Q3 2021 Estimated EPS 1.455 1.137 1.511 1.705 T12M Estimated EPS 5.51 5.57 5.77 5.81 Estimated PE 25.34 25.06 24.20 24.03 Part 1 Simple Computation for PE Multiples T12M EPS Announcing Date 4/17/2019 7/9/2019 10/3/2019 2/13/2020 4/28/2020 7/13/2020 10/1/2020 Fiscal Period Q1 2019 Q2 2019 Q3 2019 Q4 2019 Q1 2020 Q2 2020 Q3 2020 Reported EPS (Actual) 0.972 1.539 1.555 1.452 1.075 1.318 1.664 Stock Price (Quarter-End) 127.010 131.740 137.930 146.470 136.320 134.910 140.800 ? ? ? ? Problem 1) Compute trailing EPS for Q4 2019, Q1 2020, Q2 2020, and Q3 2020. (Note: In the above table, all the reported EPS values are expressed as quarterly ratios. Thus, all the trailing EPS should be annualized.)! Problem 2) Using trailing EPS for Q4 2019, Q1 2020, Q2 2020, and Q3 2020, compute the respective trailing PE multiples. Problem 3) The following table summarizes the estimated PE, estimated EPS, and estimated trailing EPS. Compute the forward PE multiple as of 10/1/2020 using the next 12 month estimated EPS 2 Problem 4) Compare the trading PE and the forward PE on 10/1/2020. Problem 5) The price for the company on 10/22/2020 is trading at 139.5. Using the trailing PE and forward PE multiples, identify your target price and discuss whether the price is cheap or expensive. 1 The trailing EPS (T12M EPS) for 2/13/2020 (Q4 2019) is, EPS01-2019+EPS Q2-2019+EPS932019 +EPSQ42019) 4 2 The average of the estimated EPS for 10/1/2020 (Q4 20120) is, EPS042020+EP SQ12021 +EPSQ2-2021 +EP SQ32021) 4 Announcing Date 2/12/2021 4/28/2021 7/13/2021 10/1/2021 Fiscal Period Q4 2020 Q1 2021 Q2 2021 Q3 2021 Estimated EPS 1.455 1.137 1.511 1.705 T12M Estimated EPS 5.51 5.57 5.77 5.81 Estimated PE 25.34 25.06 24.20 24.03
