Dr. equinox only"
mesalo
20161106235403finance_pro-2-2.docTERM PROJECT FIN 331
· Answer each question in a chronological order.
· I will not accept any hand written projects.
Pick four stocks ( from Dow or S&P500 ) from yahoo finance and answer the following questions :
use a 5 year holding period (example 2010-2016).
a. Give business summary and key statistics for each.
b. Calculate the average annual return for each stock.
Hint: Use the formula
1
1
-
-
-
=
t
t
t
t
P
P
P
R
wheret
R
is the return on the security,t
P
is the price of the security a time period t and1
-
t
P
is the price of the security at time1
-
t
c. Which is the riskiest security and which is the least riskiest based on the SD?
(remember higher the standard deviation the riskier the stock will be).
d. Please comment on the best performing stock and the worst performing stock and provide some justification.
e. Calculate all possible cross-correlations. Briefly discuss the results.
f. Build a portfolio and allocate weights as you wish. Calculate portfolio return (based on average annual return that you calculated in question b)
using the formula:
n
n
p
R
W
R
W
R
W
R
´
+
+
´
+
´
=
.....
2
2
1
1
Where
s
W
i
are the weights to you allocate to each security ands
R
i
are the average rate of return from each security.Where W’s are the weights and R’s are the returns.
g. How does your answer in f. compare to the answer that you found in b.? Please comment.
h. Calculate the beta of each individual security.
i. How does your results compare with the one found in c?
j. Calculate the portfolio beta using the formula:
n
n
p
R
W
W
´
+
+
´
+
´
=
b
b
b
b
.....
2
2
1
1
Where
s
W
i
are the weights to you allocate to each security ands
i
b
are betas of each security.k. Calculate the expected rate of return of your portfolio using the CAPM:
)
(
rf
rm
rf
R
p
p
-
´
+
=
b
whererf
is the risk free rate (assume 2.9%) andrf
is the rate of return of the market.
