Project - Stock Valuation , homework help

Jul 27th, 2016
SoccerBoss
Category:
Other
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) Daniel C.
(997)
School: Carnegie Mellon University
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

8 Reviews


Summary
Quality
Communication
On Time
Value
tinytim47
Dec 2nd, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
Five Star Tutor
Nov 21st, 2016
" Outstanding Job!!!! "
mixedballz
Nov 18th, 2016
" excellent work as always thanks for the help "
lilmoe415
Nov 9th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
darnay
Oct 27th, 2016
" The best tutor out there!!!! "
dontuwannaknow
Oct 18th, 2016
" Excellent work as always thanks so much "
SjSurvivor143
Oct 4th, 2016
" Thanks for the help. "
Joemoe
Sep 21st, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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