Reference no: EM13531254 , Length: 2000 Words
Write report and excel solution for the finance case study.This is the instruction:
Prepare a report based on the case entitled “InBev and Anheuser-Busch.” Please post your Excel sheet and analysis report on Blackboard. (A suggested outline for the report is as follows: (1) An executive summary that includes your recommendation; (2) A statement of the issue(s) the financial managers face; (3) A presentation and discussion of your Excel findings; (4) Your analysis; (5) Concluding remarks)
Your report should at least address the following questions
1. What is the intrinsic value? Why is it so important? How is it estimated in business valuation?
2. What is WACC? Why is it so important in business valuation? Please estimate WACC for Anheuser in 2008 using the Excel templateattached. In your estimation of cost of equity, use either CAPM or Dividend Discount Model but make sure to justify your model selection.
3. Assess InBev’s bids for Anheuser in 2008 based on discounted cash flow valuation model. How do they compare with the firm’s intrinsic value?
a. Complete the attached Excel sheet by projecting free cash flows, with the terminal date at the end. What should determine the “terminal date,” i.e., when you stop forecasting annual cash flows and estimate a terminal value? Do you think 2012 is the appropriate “terminal date” for Anheuser-Busch given its circumstances at the end of 2007? Why?
b. Could you recommend an appropriate growth-rate assumption for Anheuser-Busch in the estimation of its terminal value? Justify yourgrowth-rate assumption and estimate Anheuser’s terminal value.
c. What is your best estimate (or the range of your estimates) of Anheuser-Busch’s intrinsic value?
d. Should InBev’s shareholders endorse the acquisition of Anheuser at $70 per share?
Attachment:- HW2 AOL template.xlsx
|
Triacylglycerols in the intestinal lumen are incorporated
: Triacylglycerols in the intestinal lumen are incorporated intomicelles formed with the aid of bile salts secreated from the gallbladder. The index of energy chage varies between 0 and 1. Chylomicrons function in the transport of triacylglycerols,fa..
|
|
Humans hypercholesterolemia is condition involving dominance
: In humans hypercholesterolemia is a condition involving incomplete dominance , it causes elevated cholesterol levelsregardless of diet . sufferers of this disease are susceptible toheart attack at an early age because cholesterol build-up causeblo..
|
|
What are chances that their child wil exhibit dwarfism trait
: Achondroplasia is a dominant form of dwarfism in humans.heterozygous individuals exhibit the dwarfism trait, whilehomozygous dominant embryos die before birth. suppose that anindividual with achondroplasia is expecting a child with andindividual o..
|
|
Relationship between the carbon cycle andthe nitrogen cycle
: Describe and explain the relationship between the carbon cycle andthe nitrogen cycle.
|
|
What is wacc why is it so important in business valuation
: What is WACC? Why is it so important in business valuation? Please estimate WACC for Anheuser in 2008 using the Excel templateattached. In your estimation of cost of equity, use either CAPM or Dividend Discount Model but make sure to justify your mod..
|
|
Biomes-greatest rate of leachingand cycling of nutrients
: The growing season would be shortest in which of the following biomes? Which biome has soils with the greatest rate of leachingand cycling of nutrients? Which of the following involves a simple tupe of learningwhere there is a loss of sensitivity to ..
|
|
Explain the role of autotrophs
: Explain the role of autotrophs and give two reasons why they occupythe lowest level of the food chain. Compare and contrast seals and sea lions. How are they similar? How are they different? What characteristics do all marine mammals have in common?
|
|
Genotypes and phenotypes of their children
: suppose a female child from the previous question growsup to marry a man with normal color vision. what are the posssible genotypes and phenotypes of their children?
|
|
Red green colorblindness is a sex linke drecessive condition
: in humans , red green colorblindness is a sex linke drecessive condition. show a cross between a colorblind manand a woman with normal vision homozygous normal . what are the possible phenotypes of the children?
|