Question: Help what do I do X DCF Valuation AmBev Notes Info Hist Tax Reinv Acq Growth Value Data--> Ind Avg Country tax NOTES Yellow cells

Help what do I do

Help what do I do X DCF Valuation AmBev NotesHelp what do I do X DCF Valuation AmBev Notes
X DCF Valuation AmBev Notes Info Hist Tax Reinv Acq Growth Value Data--> Ind Avg Country tax NOTES Yellow cells = Your input; Green cells = Model's calculations (don't override). Date format: The model is set up to display dates in U.S. format, i.e., Month/Day/Year (e.g., 12/31/2013). On U.S. configured computers, you input dates in the same way, i.e., Month/Day/Year. On other computers (e.g., Chinese configured) you input dates in the format Year-Month-Day (e.g., 2013-12-31). --> The display format is still U.S. format.Notes Info Hist Tax Reinv Acq Growth Value Data--> Ind Avg Country ta General Comments: -Acquisitions can be very "lumpy," i.e., companies do not make acquisitions every year, but when companies do make them it's a significant amount. --> Normalization is important. - Include all acquisitions, i.e., both those financed with cash and those financed with stock. Total Transaction Value for Re $0.00 $0.00 $0.00 12/31/16 12/31/17 12/31/18 Transaction ID Target Name Transaction Value Effective Date Include? -4 -3 -2 IQTR208413475 Bar Leo 6/4/12 Yes IQTR58965839 Obras e Investimentos SA $0.02 1/16/08 Yes IQTR39657633 Quilmes Industrial (QUINSA) S.A. $621.13 2/11/08 Yes IQTR36434721 Companhia Cervecera Ambev Ecuador S.A. 3/5/07 Yes IQTR33426233 Cervejarias Cintra Industria e Comercio Lida, 2 Breweries In Rio de Janeiro and Sao Paulo $304.95 4/17/07 Yes IQTR31341210 Quilmes Industrial (QUINSA) S.A. Yes QTR26748603 Quilmes Industrial (QUINSA) S.A. $2,733.25 8/8/06 Yes IQTR9244192 Labatt Brewing Company Limited 24,567.36 8/27/04 Yes IQTR36452840 Compania Cervecera Ambev Dominicana, C. Por A. $174.42 2/12/04 Yes IQTR11610091 Cerveceria SurAmericana S.A. (nka:Companhia Cervecera Ambev Ecuador S.A.) $105.30 12/2/03 Yes IQTR12436442 Quilmes International (Bermuda), Ltd. $363.77 1/31/03 Yes IQTR26166274 Cervejaria Astra S.A. $104.00 6/4/02 Yes IQTR11899750 Quilmes Industrial (QUINSA) S.A. $1,227.57 1/31/03 Yes IQTR12072987 Cerveceria y Malteria Paysandu SA $55.04 2/14/01 Yes IQTR7414950 Compania SALUS S.A 9/30/00 Yes IQTR105310665 Cia Cervejaria Brahma 9/15/00 Yes IQTR253929557 AmBev Brasil Bebidas Ltda. $1.04 1/2/14 Yes Yes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!