Reference no: EM13202479
Computation of Dividend Growth Rate for Johnson and Johnson (JNJ) Employing Log-linear Regression
This is a project designed to get you familiar with using the log-linear regression method to determine the growth rate of dividends. A partial dividend history for JNJ is given below:
Year Annual dividend
1991 0.16000
1992 0.18625
1993 0.21500
1994 0.24500
1995 0.27750
1996 0.31500
1997 0.36000
1998 0.41250
1999 0.47000
2000 0.53500
2001 0.60500
2002 0.68500
2003 0.78500
2004 0.91000
2005 1.06000
2006 1.23000
2007 1.40500
2008 1.58000
2009 1.74000
2010 1.90500
2011 2.25000
As you can see, the data above starts from 1991 and ends in 2011. This represents 21 years of ANNUAL dividend per share data in a time-series sequence.
Please use the log-linear method to determine the growth rate of dividends for JNJ. To do this, you need to note down the dividends series above. You could probably cut and paste the data above into an excel worksheet. Then, create a column for the relative year (this is your X-variable for the regression), starting with 1 for 1991, 2 for 1992, etc. Then take natural log of the dividend and enter this into another column. You can use the excel function for this purpose called LN. So, for example, if you want to take the natural log of the value in cell B4, you would use the following formula in EXCEL : =LN(B4)
After creating the column of the natural log of the dividends, please realize that this is your Y-variable for the regression. Then, do the linear regression and compute the value of the constant growth rate, after doing the appropriate mathematical operations.
Note: You can compute the value of ex by using the excel function: =exp(x)
Expectations from the assignment:
The product from this assignment should be a report that consists of:
(1) A discussion which explains the process of the log-linear method of regression to determine the dividend growth rate. Please ensure that your answer is able to convince me that you understand the method thoroughly.
(2) A spreadsheet with all appropriate computations.
(3) A discussion which contains an interpretation of relevant statistical measures which refers explicitly to the numbers in your spreadsheet (see item 3 above), including whether you think that the constant growth model is appropriate to model the dividend stream of JNJ. Where is this growth rate used in corporate finance? Specifically, what applications is it employed in?
|
Determine the net cash needs to start the new project
: The NPV of the project and Acme's decision to go or not to go with the new project and the value of the seven annual cash from operations, by showing the seven high-level pro-forma income statements
|
|
How does fed implement monetary policy to manage economy
: 3.Should the Fed remain independent from political authority or should the President and Congress have a say in their operations Why Why not 4.What is FOMC What is the current Federal Funds Rate
|
|
How does tarp illustrate the problem of moral hazard
: 1.What factors led to the mortgage default crisis 2.How did mortgage defaults affect banks involved in mortgage lending and mortgage investing? 3.Securitization TARP What do these mean 4.How did mortgage-backed securities spread losses during the ..
|
|
Define how many people participate in the study
: (a) How many people participate in the study (b) Calculate the Relative Frequency and enter the results in the above table. (c) Calculate the Midpoint for each class and enter the results in the above table. (d) Calculate the Cumulative Frequency and..
|
|
Process of the log-linear method of regression
: A discussion which explains the process of the log-linear method of regression to determine the dividend growth rate.
|
|
When the same efforts must be made to uncork and pour bottle
: Most restaurant customers tip according to a percentage rule - between 15 and 25 percent of the bill. Diners who have dinner and a $20 bottle of wine usually pay the same percentage of the bottle price as diners who order a $100 bottle.
|
|
Do the opportunity costs of borrowing and using own funds
: Lenders perceive that you are risky, so you must pay 12 percent annual interest to borrow from one of them. You only receive 6 percent on funds that you have deposited in the bank. Do the opportunity costs of borrowing and using your own funds dif..
|
|
Explain why some countries experienced growth
: Read "A Possible Perspective on Growth and Stagnation Over the Past 200 Years" posted on Blackboard. a. Describe the 4 reasons that Acemoglu gives for why the world did not experience growth before 1800. Name the 3 structural transformations underwen..
|
|
Calculate the effective interest to compound quarterly
: What sum should you deposit into an account to yield 20 year end payments, starting with $10,000 at the end of the first year and increasing by 4% each year at an interest rate of 8% compounded quarterly.
|