Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by joscor on Wed, 2017-02-15 02:55
due on Wed, 2017-02-15 10:53
answered 1 time(s)
Hand shake with kim woods: In progress
Hand shake with phyllis young: In progress
Hand shake with perfecto: In progress
Hand shake with YOURlecturer: In progress
Hand shake with DENNISWRIGHT: Complete ($15.00 paid)
Hand shake with Prof. Moses G...: In progress
Hand shake with Zeek the Geek: In progress
Hand shake with WriterAtHeart...: In progress
Hand shake with MorganCarlos: In progress
Hand shake with tutor-mitchelle: In progress
Hand shake with Prof Linda Pinc: In progress
Hand shake with prof bianca: In progress
Hand shake with tutordouglas: In progress
Hand shake with dennohmutuku: In progress
Hand shake with luobotethuku: In progress
Hand shake with Dr kahlan: In progress
Hand shake with mariedaisy: In progress
Hand shake with ACCOUNTING FI...: In progress
Hand shake with Prof cyrion: In progress
joscor is willing to pay $35.00
joscor bought 3 out of 4 answered question(s)

Need someone to do an investments homework for me

Assignment 2:  Risk and Return.  Complete and submit on due date.

 

 

 

 

Complete the following risk and return exercise.

 

The purpose of this exercise is to first provide experience in locating, understanding, and analyzing basic stock price data. In addition, the ultimate learning objective is to translate this data into standard measures of risk and return, and to learn how to find the Beta for a security.

 

 

1.         Retrieve monthly price data for Apple, CVS and the S&P 500 (^GSPC) from Yahoo Finance for the past 2 years.  Type in the ticker, then, click historical prices.  You will need end of month prices.

2.         Compute monthly Holding Period Returns (HPRs).

3.         Calculate arithmetic means.

4.         Calculate the standard deviation of the monthly HPRs.

5.         Repeat steps 1-4 for 1 of the stocks you individually selected for your group portfolio.

6.         Perform a linear regression for Apple, CVS, and for 1 of the stock’s you individually selected for your group portfolio.  Identify and briefly discuss all the Betas.  In your discussion, compare the Betas to those found on Bloomberg and Yahoo Finance.

7.         Submit your analysis by e-mail and hard copy.

8.         Come to class prepared to discuss your interpretation of the results.

9.         Only hard copies handed in will be graded so please be sure to submit organized and easy to follow work.

           

 

If you download the data from Yahoo, you will notice that the dates in your spreadsheet don't look like end of month dates. The prices are indeed the end of month prices.  Put the closing prices into the Excel template provided. Now, you're ready to generate additional rows and columns to complete the calculations.

Answer
Submitted by DENNISWRIGHT on Wed, 2017-02-15 20:32
teacher rated 1102 times
4.6343
purchased one time
price: $35.00

Investments

body preview (0 words)

file1.docx preview (186 words)

Beta xxxxxxxx xxx xxxxxxxx xxxx of securities xxxxxxxx to the market. It is mainly xxxx during the xxxxxxxxxxx of xxx xxxxxxxx xxxxxxx in the xxxx

xxxx of 1 shows xxxx xxx security’s xxxxx is moving xx tandem xxxx the xxxxxxx A beta of less xxxx 1 xxxxxxxxx xxxx the xxxxxxxx’x volatility xx xxxxx than the xxxxxxx A xxxx greater than x xxxxxxxxx xxxx the security xx xxxx volatile xxxxxxxx to the market.

xxxxx xxxx

The xxxxxxxxxx beta xxx Apple xxxx is 1.36 while that xxxxx xx xxxxxxxxx xxx Yahoo finance is still 1.36. This xxxxxxx that xxxxx Inc. xxxxxx xxx more xxxxxxxx than the xxxxxx of xxx x&x xxx

xxx

On the xxxxx hand, xxx xxxx of xxx was calculated xx 0.35 while xxx calculated xxxx xx 0.54. xxxx xxxxx xxxx xxx xxxxxx xxx less xxxxxxxx xxxxxxxx xx xxx S&P xxx xxxxxxx

FB

xxx xxxxxxxxxx beta xxx FB stocks is 0.48 xxxxx xxx beta xxxxx xx xxxxx xxxxxxx and Bloomberg xxxxxxxx xx xxxxx This xxxxxxxxx xxxx xx xxxxxx are less xxxxxxxx xxxx stocks of S&x xxx and hence xxxxxxx in market prices do not adversely xxxxxx FB stocks.

file2.xlsx preview (293 words)

xxxxx Inc

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Date Openxxxx Low Close xxxxxx xxx Close MHPRsARTHMETIC MEANSTD xxx xxxxxxxxxxx xxxxxMHPRs S&x 500
xxxxxx 127.03xxxxxx 127.01 135.0200000000000139531800 xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx x 6% xx
xxxxxxxxxxx 122.44 xxxxxx121.35 30607400xxxxxxxx xxxxx xx
######## xxxxxx118.02108.25 115.8230445600 115.32xx35% xx
xxxxxxxx xxxxxx xxxxxx xxxxxxxxxxxxxxxxxxxx xxxxxxxx xxxx xxx3%
########xxxxxxxxxxxx112.28 113.54xxxxxxxx 112.472399999999991%5xx xxx
xxxxxx106.14 xxxxxx 102.53113.05 47828300111.98699999999999xx 6 7%0%
8/1/16104.41 xxxxxxxxxxxxxx 28686500 105.10242% 7xx0%
7/1/16 xxxxx 104.5594.37 104.21 xxxxxxxx xxxxxxxx xx x9%xx
xxxxxx xxxxxxxxxxx xxxx 95.637040500 94.190839999999994 -3%x xxx 0%
xxxxxx xxxxx 100.7389.4799.8644886900xxxxxxxxxxxxxxxxxx 6% 106%xx
4/1/16108.78xxxxxx xxxxx xxxxxxxxxxxxx 91.799340000000001xxxx xx -14%xx
xxxxxx xxxxx xxxxxx97.42 xxxxxx 35088000 xxxxxxxxxxx12 12%xx
2/1/16xxxxxxxxxx92.5996.69 xxxxxxxx94.688270000000003xxxx xxxx
xxxxxx 102.61xxxxxx xxxxxxxxxx70286300 94.810339999999997-5%14 -5%xxx
########xxxxxx 119.86104.82105.26 43734700 102.5245 xxxxxx -11%xxxBeta
########120.8 123.82 xxxxxxxx39491000xxxxxxxx-2%xxxxxxx 1.369324276
xxxxxxxx109.07 121.22xxxxxx119.552804000xxxxxxxxxxxxxxxxxx xxxxx10% xxxxx risk is xxxxxx in the xxxx xxxxxxxxx xx the maket and it xx xxxx higher than the market risk.
9/1/15 110.15116.89 xxxxxxxxxxx xxxxxxxx xxxxxxxx 0%180%-3%
8/3/15121.5xxxxxx xx 112.76 xxxxxxxx109.36150000000001xxx xxxxx -6%
xxxxxxxxxxx xxxxxx xxxxxxxxxxxxxxxxxxx 117.114 -4% xx xxx xxBeta xxxxx xx xxxxxxxxx xxx Yahoo Finance for xxx xxxxx xxxxx xx xxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00