Question

In: Finance

Following table is the data of past dividend payments.   dividend (in millions) 2012 $1.00 2013 $1.50...

Following table is the data of past dividend payments.



  dividend (in millions)
2012 $1.00
2013 $1.50
2014 $2.00
2015 $2.35
2016 $3.15
2017 $4.00
2018 $4.65
2019 $5.25
2020 $5.96


Using the past dividend data, you will forecast the future growth rate.

The most recent dividend paid by New Technologies was an annual dividend of $5.96 million in total and there are 20 million shares outstanding .

Assume T-bill rate is 3%, S&P500 market return is 7%, beta of New Technologies is 0.88.



#1. What is the appropriate discount rate (required rate of return)?

#2. You forecast that future dividends will grow for 3 years at the geometric average of historical dividend growth rate using the data given. What is the geometric average of historical dividend growth rate?

#3. You assume that dividends for the next 3 years will be increased at the rate you just calculated from #2. After that, you assume dividends are expected to increase by 4% each year forever. What should be today’s stock price per share?

#4. If the H-model is applied to the above question, at what rate should the growth rate decline each year to reach the constant growth rate of 4%?

#5. Using the H-model, what should be the stock price per share today?




#1. k = 5.54%


#1. k = 6.52%


#1. k = 9.24%


#2. geometric avg growth rate = approx. 25%


#2. geometric avg growth rate = approx. 21%


#2. geometric avg growth rate = approx. 28%


#3. approx. $15.50 per share


#3. approx. $40.30 per share


#3. approx. $21.10 per share


#4. each year it should decline by 5% per year


#4. each year it should decline by 7% per year


#4. each year it should decline by 9% per year


#5. approx. $17.80 per share


#5. approx. $20.90 per share


#5. approx. $15.20 per share

Solutions

Expert Solution

1. The appropriate required/discount rate (r) is determined from CAPM model

Required rate = risk free rate + beta *( market rate of return - risk free rate)

T- bills rate can be taken as risk free rate

So, Required rate (r) = 3%+0.88*(7%-3%) = 6.52%

2. The geometric average return = (last year value/1st year value) ^ (1/no. of periods) - 1

There are 9 values given for 8 periods (2012-13 is one period and so on)

Geometric average return = (5.96/1)^(1/8) -1 = 0.249988 = 25%

3. Here

Last dividend per share = C0 = $5.96 million/20million shares = $0.298

C1= 0.298*1.25 =$0.3725

C2 = 0.3725*1.25 = $0.465625

C3 = 0.465625*1.25 = $0.582031

C4 = 0.582031*1.04 = $0.605313

So, Terminal value of share at the end of 3rd year (as per constant growth model)

V3 = C4/(r-g) where C4 is the 4th year dividend , r is the required rate and g is the constant growth rate

= 0.605313/0.0252 = $24.02034

So value of share today

V0 = C1/1.0652+ C2/1.0652^2+C3/1.0652^3 + V3/1.0652^3

= 0.3497+0.410368+0.481563+19.87402

=$ 21.10

4) If the H model is to be applied. the growth rate declines every year from 25% to reach 4%in 3 years

So, it should decline by (25%-4%)/3 =7% each year


Related Solutions

Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $...
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $ 8,052 $ 7,175 Cost of products sold 5,370 5,140 4,365 Gross margin $ 2,898 $ 2,912 $ 2,810 (a) Calculate the gross profit ratio for each of the past three years. (Round your answers to 1 decimal place.) (b) Assume that Campbell’s net sales for the first four months of 2015 totaled $2.7 billion. Calculate an estimated cost of goods sold and gross profit...
Using the data in the following​ table,    2010   2011   2012   2013   2014   2015 Stock A  ...
Using the data in the following​ table,    2010   2011   2012   2013   2014   2015 Stock A   -10%   20%   5%   -5%   2%   9% Stock B   21%   7%   30%   -3%   -8%   25% consider a portfolio that maintains a 50% weight on stock A and a 50% weight on stock B. a. What is the return each year of this​ portfolio? b. Based on your results from part ​(a​), compute the average return and volatility of the portfolio.
Use the following table to answer the questions below. Country GDP in 2012 GDP in 2013...
Use the following table to answer the questions below. Country GDP in 2012 GDP in 2013 Population in 2013 United States 16,244,575 16,724,272 316,438,601 Mexico 1,177,398 1,327,021 118,818,228 United Kingdom 2,476,665 2,489,674 63,395,574 Kenya 40,697 45,311 44,037,656 Note that GDP numbers are presented in millions (add six zeros on to each of the reported numbers). 1. Calculate the GDP growth rate for each country between 2012 and 2013. Round to one decimal place. US: Mexico: UK: Kenya: 2. Calculate GDP...
Snap-On Incorporated Consolidated Statements of Earnings (Amounts in millions) For the fiscal year ended 2013 2012...
Snap-On Incorporated Consolidated Statements of Earnings (Amounts in millions) For the fiscal year ended 2013 2012 Net sales $3,056.50 $2,937.90 Cost of goods sold -1,583.60 -1,547.90 Gross profit 1,472.90 1,390.00 Operating expenses -1,012.40 -980.3 Operating earnings before financial services 460.5 409.7 Financial services revenue 181 161.3 Financial services expenses -55.3 -54.6 Operating income from financial services 125.7 106.7 Operating earnings 586.2 516.4 Interest expense -56.1 -55.8 Other income (expense) -- net -3.9 -0.4 Earnings before income taxes and equity earnings...
Snap-On Incorporated Consolidated Statements of Earnings (Amounts in millions) For the fiscal year ended 2013 2012...
Snap-On Incorporated Consolidated Statements of Earnings (Amounts in millions) For the fiscal year ended 2013 2012 Net sales $3,056.50 $2,937.90 Cost of goods sold -1,583.60 -1,547.90 Gross profit 1,472.90 1,390.00 Operating expenses -1,012.40 -980.3 Operating earnings before financial services 460.5 409.7 Financial services revenue 181 161.3 Financial services expenses -55.3 -54.6 Operating income from financial services 125.7 106.7 Operating earnings 586.2 516.4 Interest expense -56.1 -55.8 Other income (expense) -- net -3.9 -0.4 Earnings before income taxes and equity earnings...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0. a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places. b) Set up...
1. The following data were included in a recent Papaya Inc. annual report (in millions): 2013...
1. The following data were included in a recent Papaya Inc. annual report (in millions): 2013 2014 2015 2016 Net revenue $ 79,225 $ 131,559 $ 183,500 $ 191,920 Net property, plant, and equipment 4,930 9,080 15,590 16,200 Required: Compute Papaya's fixed asset turnover ratio for 2014, 2015, and 2016. (Do not round intermediate calculations. Round your answers to 1 decimal place.) During 2016, Mellow reported a fixed asset turnover ratio of 9.9. Was Papaya's turnover better or worse than...
The table below shows the average annual consumption bundle and prices in 2012 and 2013: Streaming...
The table below shows the average annual consumption bundle and prices in 2012 and 2013: Streaming Movies Popcorn 2012 {quality, price/unit} {10000 hrs, $1.00/hr} {5000 bags, $2.00/bag} 2013 {quantity, price/unit} {12000 hrs, $0.95/hr} {4000 bags, $2.20/bag} (a) What is the percentage change in the price of each good? Calculate the consumer price index (CPI) for 2012 and 2013 using 2012 as the base year. What is the inflation rate in the CPI? (b) Are all consumers equally affected by the...
Case #4 Valuing Stock   The dividend has grown from $1.00 per share on November 13, 2012...
Case #4 Valuing Stock   The dividend has grown from $1.00 per share on November 13, 2012 to $2.80 during 2018. You think this growth rate will continue for three more years and then fall to the long-term growth rate of 9.29 percent predicted by analysts. Discount rate is 13 percent. Given these parameters, the company’s stock is worth____________ per share. I'm still learning finance, may i have step-by-step how to slove these four case, it will be very greatful if...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT