Conduct a Sensitivity Analysis for Google Vary the following inputs to the two-tier valuation...

90.2K

Verified Solution

Question

Accounting

  1. Conduct a Sensitivity Analysis for Google
    1. Vary the following inputs to the two-tier valuation model and indicate the new valuation amount and the percentage change from the above "base" case.
      • Free Cash Flows
        • Increase the FCF by 10%
        • Decrease the FCF by 10%
      • Terminal Growth Rate
        • Increase the Terminal Growth Rate from 2.5% to 3.5%
        • Decrease the Terminal Growth Rate from 2.5% to 1.5%
      • WACC
        • Add 2% to the WACC (that is if the WACC is 7.5% make it 9.5%)
        • Subtract 2% from the WACC (that is if the WACC is 7.5% make it 5.5%)
    2. Observations
      • State your observations from the sensitivity analysis. How important (conceptually) is the terminal growth rate to overall value? How important is the WACC to overall value?
      • FCF $29,129,252
        WACC 12.00%
        Year FCF PV @12% Present Value
        Growth rate = 8% 1 $31,380,480 0.8929 $28,018,286.00
        Growth rate = 8% 2 $33,890,918 0.7972 $27,017,633.00
        Growth rate = 8% 3 $36,602,192 0.7118 $26,052,717.00
        Terminal Value 4 $394,918,387.00 0.7118 $281,095,108.00
        Total firm Value $362,183,744.00
        Market cap $958,950,000,000
        Firm Value $362,183,744.00
        Total debt (mrq) $16,800,000,000
        Intrinsic value = Firm Value - debt ($16,437,816,256.00)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students