Project - Stock Valuation , homework help

Jul 27th, 2016
Anonymous
Category:
Art Design
Price: $35 USD

Question description

Project+2+Instructions.docx Project 2: Stock Valuation 

 Assume someone you know and care about came up to you with an idea to purchase some stock in a company, and they want your advice. Pick a publicly traded company that has paid dividends for at least five years, come up with a value estimate for the company’s stock, and offer a recommendation on whether someone should buy, hold or sell shares in this company. Refer to my Starbucks example in the Financial Planning and Forecasting lecture for as a guide. In order to estimate the company’s value, please compute the following metrics based on at least five years of company data: 1. Retention Ratio – the bare minimum would be to simply use a five year average. If there seems to be a trend, feel free to project the trend into the future. Use one retention ratio for the calculation of internal and sustainable growth rates. 2. ROA & ROE – again, feel free to use an average or project future amounts based on the recent trend. Use on ROA and one ROE figure for the internal and sustainable growth rates. Using these three variables and any other data you find relevant, calculate the internal and sustainable growth rates to use for dividend forecasts. You may pick one or the other or use a growth rate somewhere in between; discuss briefly (even as little as one sentence) why you chose the dividend growth rate you did. Apply this dividend growth rate to forecast six years of dividends (the sixth year is used to calculate terminal value). Estimate a terminal growth rate (I suggest average revenue growth for the company or simply a 3% growth rate to mimic long-run economic growth), and use present value calculations with a 10% discount rate to compute the present value of future dividends. As I did in my Starbucks example, calculate investments and debt per share and apply those to determine a final stock price valuation. Please turn in an Excel file and a Word document. The Excel file should show your work so I can award partial credit if need be. The Word document should be no more than a page and include your recommendation along with key assumptions you made. Email me with any questions you have about including non-recurring income or any other financial statement considerations.

Tutor Answer

(Top Tutor) Studypool Tutor
School: UIUC
PREMIUM TUTOR

Hi there!Attached are the documents for the completed assignment (the word document and the Excel document). Please look them over. There is an hour and a half remaining for me to perform any corrections you deem necessary :)Thanks again!Selenica

Sony (SNE)
Net Income
Non-Recurring Events
Effective Net Income
Dividends
Retention Rate
Average Retention Rate
Sony (SNE)
Effective Net Income
Total Assets
Average Assets
-0.18 ROA
Total Equity
Average Equity
ROE
Average ROE
Revenue Growth
Revenues
Revenue Growth
Average Rev Growth
Dividend Projections
Dividend Growth
3-year average

2016
2015
2014
2013
2012
14.77
-12.6
-12.8
41.54
-45.66
0
0
0
0
0
14.77
-12.6
-12.8
41.54
-45.66
25.08
25.06
25.64
13.16
12.75
-0.69804 2.988889 3.003125 0.683197 1.279238
1.451282
2016
14.77
13.30
13.76
1.07
24.60
23.90
0.62
-0.07

2015
-12.60
14.21
14.77
-0.85
23.20
22.90
-0.55

2014
-12.80
15.33
15.58
-0.82
22.60
22.25
-0.58

2013
41.54
15.83
16.25
2.56
21.90
21.10
1.97

2012
-45.66
16.67
16.13
-2.83
20.30
25.52
-1.79

2016
2015
2014
2013
72.06
73.04
69.05
60.42
-0.01342 0.057784 0.142833 0.046778
-1%

2012
57.72
-0...

Studypool has helped 1,244,100 students

Review from student
Studypool Student
" Wow this is really good.... didn't expect it. Sweet!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors