file:///Users/ munaal-saidi/Downloads/FINC5540%20HW4(1).pdf + Problem 1) Assume that Pepsico Inc. (PEP) released its earning report for the 3Q of 2020. Now you have selected Pesico's comparable companies are as below to forecast one quarter ahead (4Q 2020) its fundamental value. 1) Constellation Brand Inc. (STZ) 2) Keurig Dr Pepper Inc (KDP) 3) Monster Beverage Co. (MNST) 4) Molson Coors Beverage Co. (TAP) 5) Coca-Cola co (KO) 6) Boston Beer 'A' (SAM) 7) Coca-Cola Consolidated INC. (COKE) Let's use Bloomberg to collect the respective forecasted EV/EBITDA multiples for the above companies including Pepsico. Enter Ticker Press EQUITY (F8) yellow key Type EEO Select periodicity Quarters and Cur "USD Press GO green key (Enter) Find EV/EBITDA for next 4 Qtrs Est. Report the respective EV/EBITDA multiples for those companies including Pepsico Inc. and calculate the average of EV/EBITDA. Problem 2) Report the following financial values for Pepsico. 1) As of 2020 3Q (9/5/2020), Cash & Equivalents, Preferred & others, Total debt, Enterprise Value, Market Capitalization. 2) EBITDA (Adj) for 2020 4Q Est (12/31/2020) To find those values, access to Bloomberg. Enter Ticker Press EQUITY (F8) yellow key Type FA Select periodicity Quarters and Cur "USD" Press GO green key (Enter) Select Key Stats or B/S to find all the values Set Periodicity Quarters and Currency USD Press GO green key (Enter) Problem 3) Calculate estimated enterprise value and market value for 2020 40 Problem 4) Compute the target price of Pepsi Co. for the next quarter. file:///Users/ munaal-saidi/Downloads/FINC5540%20HW4(1).pdf + Problem 1) Assume that Pepsico Inc. (PEP) released its earning report for the 3Q of 2020. Now you have selected Pesico's comparable companies are as below to forecast one quarter ahead (4Q 2020) its fundamental value. 1) Constellation Brand Inc. (STZ) 2) Keurig Dr Pepper Inc (KDP) 3) Monster Beverage Co. (MNST) 4) Molson Coors Beverage Co. (TAP) 5) Coca-Cola co (KO) 6) Boston Beer 'A' (SAM) 7) Coca-Cola Consolidated INC. (COKE) Let's use Bloomberg to collect the respective forecasted EV/EBITDA multiples for the above companies including Pepsico. Enter Ticker Press EQUITY (F8) yellow key Type EEO Select periodicity Quarters and Cur "USD Press GO green key (Enter) Find EV/EBITDA for next 4 Qtrs Est. Report the respective EV/EBITDA multiples for those companies including Pepsico Inc. and calculate the average of EV/EBITDA. Problem 2) Report the following financial values for Pepsico. 1) As of 2020 3Q (9/5/2020), Cash & Equivalents, Preferred & others, Total debt, Enterprise Value, Market Capitalization. 2) EBITDA (Adj) for 2020 4Q Est (12/31/2020) To find those values, access to Bloomberg. Enter Ticker Press EQUITY (F8) yellow key Type FA Select periodicity Quarters and Cur "USD" Press GO green key (Enter) Select Key Stats or B/S to find all the values Set Periodicity Quarters and Currency USD Press GO green key (Enter) Problem 3) Calculate estimated enterprise value and market value for 2020 40 Problem 4) Compute the target price of Pepsi Co. for the next quarter
