bafi517 financial management hw2 prepare a report based on the case entitled inbev and anheuser busch

/in /by

BAFI517 Financial Management
Business Valuation.
HW2
Please prepare a report based on the case entitled “InBev and Anheuser-Busch.” Please post your Excel sheet and analysis report.
I need the excel with formulas not only with the results.
Your report should at least address the following questions:

What is the intrinsic value? Why is it so important? How is it estimated in business valuation?
What is WACC? Why is it so important in business valuation? Please estimate WACC for Anheuser in 2008 using the Excel template attached. In your estimation of cost of equity, use either CAPM or Dividend Discount Model but make sure to justify your model selection.
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?

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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?
Could you recommend an appropriate growth-rate assumption for Anheuser-Busch in the estimation of its terminal value? Justify your growth-rate assumption and estimate Anheuser’s terminal value.
What is your best estimate (or the range of your estimates) of Anheuser-Busch’s intrinsic value?
Should InBev’s shareholders endorse the acquisition of Anheuser at $70 per share?

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.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.