Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please do it in excel format and formula: 1) giv

Please do it in Excel Format and Formula: 1) Given are the inputs...

80.2K

Verified Solution

Question

Finance

Please do it in Excel Format and Formula:

image

1) Given are the inputs for valuing a Fortune 500 Company The average yield to maturity on the 30-year Treasury bond during the period 2014-2016 is 2.94% Beta value estimated by regressingthe monthlystock returns on monthly market index S& P 500 returns during the three-year period 2014-2016 is 0.373. The return on market index is the average returns on the S&P 500 index during the three-year period 2014-2016. The return on market index is estimated as 11.23%. Table: 1 Dividend and Return highlights 2014 201s 2016 4.57 2013 Year EPS DPS ROE 3.71 1.09 0.21 2011 4.47 1.21 - 5.02 4.88 | 5.05 1.461.59 1.88 192 2012 4.52 2.00 0.24 0.22 0.23 021 0.21 0.182 Other Inputs for Valuation The high growth period is assumed five years. The growth rate of US GDP during the period 2015-2016 is estimated 2.3 per cent. Return on equity of the industry sector in the year 2016=19.2%. 10 Marks Find the value of the company using the two stage DDM

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