PORTFOLIO PROJECT PART 3

profilebarkersbaseball
portfolio_part_2_-_thomas_barker.xlsx
Home>Business & Finance homework help>PORTFOLIO PROJECT PART 3

Sheet1

My Required Rate of Return is based on return to be greater than that generated by S&P 500 index. The only constranit is not to invest in tabacco and oil stocks.
Based on above the following stocks were selected
Sr No Stock Name Ticker Symbol Price Today 20 November 2014 Beta
1 Accenture plc ACN 79.93 1.28
2 Air Products & Chemicals Inc. (APD) 134.5 1.32
3 American Express Company (AXP 89.7 1.18
4 American International Group, Inc. (AIG) 55.24 1.42
5 Analog Devices, Inc. (ADI) 49.99 1.19
6 Bank of America Corporation (BAC) 16.95 1.92
7 Avery Dennison Corporation (AVY) 47.79 1.03
8 Caterpillar Inc. (CAT) 102.51 1.64
http://finance.yahoo.com/q/ks?s=ACN
http://finance.yahoo.com/q/ks?s=APD
http://finance.yahoo.com/q/ks?s=AXP
https://finance.yahoo.com/q/ks?s=AIG
https://finance.yahoo.com/q/ks?s=BAC
http://finance.yahoo.com/q/ks?s=AVY
http://finance.yahoo.com/q/ks?s=YHOO+Key+Statistics
http://finance.yahoo.com/q/ks?s=CAT
http://finance.yahoo.com/q/ks?s=ACN

Sheet2

Sr No Stock Name Ticker Symbol Price Today 20 Sept 2014 Price Once year ago 19 Sept 2014 Dividents Return generated Return in percentage Return of S&P 500 Index Performace better than S&P 500 Index
1 Accenture plc ACN 79.93 75.63 1.86 6.16 8.14% 16.72% No
2 Air Products & Chemicals Inc. (APD) 134.5 107.27 2.96 30.19 28.14% 16.72% Yes
3 American Express Company (AXP 89.7 76.73 0.95 13.92 18.14% 16.72% Yes
4 American International Group, Inc. (AIG) 55.24 49.41 0.475 6.305 12.76% 16.72% No
5 Analog Devices, Inc. (ADI) 49.99 47.02 1.45 4.42 9.40% 16.72% No
6 Bank of America Corporation (BAC) 16.95 14.54 0.08 2.49 17.13% 16.72% Yes
7 Yahoo (YHOO) 40.93 31.03 0 9.9 31.90% 16.72% Yes
8 Caterpillar Inc. (CAT) 102.51 85.53 0.88 17.86 20.88% 16.72% Yes
Return on S&P 500 Index
Sr No Name Price Today 26 April 2014 Price Once year ago 25 April 2013 Dividents Return generated Return in percentage
1 S&P 500 Index 2010.4 1,722.34 0 288.06 16.72%
Portfolio return
Total invetsment USD80,000 divided equally in all stocks
Sr No Stock No of shares purchased Price of share now Value of Shares Total divident
1 Accenture plc 132.2226629644 79.93 10568.5574507471 245.9341531138
2 Air Products & Chemicals Inc. 93.2227090519 134.5 12538.4543674839 275.9392187937
3 American Express Company 130.3271210739 89.7 11690.3427603284 123.8107650202
4 American International Group, Inc. 202.3881805303 55.24 11179.9230924914 96.1343857519
5 Analog Devices, Inc. 212.6754572522 49.99 10631.6461080391 308.3794130157
6 Bank of America Corporation 687.757909216 16.95 11657.4965612105 55.0206327373
7 Yahoo 322.268772156 40.93 13190.4608443442 0
8 Caterpillar Inc. 116.9180404536 102.51 11985.2683269028 102.8878755992
Total 93,442.15 1,208.11
Starting Value 80000
Ending Value 93,442.15
Dividents 1,208.11
Return 14,650.26
Percentage return 18.3%
Sr No Stock Name Ticker Symbol Beta Value Weight Weighted beta
1 Accenture plc ACN 1.22 10138.3143743537 10% 0.124168144
2 Air Products & Chemicals Inc. (APD) 1.34 13986.1475997134 14% 0.1881427598
3 American Express Company (AXP 1.11 13457.5537343436 14% 0.1499594042
4 American International Group, Inc. (AIG) 1.35 12541.9198055893 13% 0.1699739601
5 Analog Devices, Inc. (ADI) 1.21 12033.6999765972 12% 0.1461736712
6 Bank of America Corporation (BAC) 1.95 12988.5993485342 13% 0.2542620456
7 Yahoo (YAHO) 0.9 12028.6986640277 12% 0.1086790315
8 Caterpillar Inc. (CAT) 1.64 12437.9232505643 12% 0.2047747128
99612.8567537234 1.3461337291
My Initial Investment was an amount of $80,000.00. I chose to invest in 8 different securities. At the end of a one year period my portfolio value is $93,442 representing a gain of 18.3%.
The said return meets my return requiremnts i.e. return is greater than that generated by the S&P 500 index.

Sheet3