Finance Need Excel Work
Sheet1
| Stock | No. of shares | Closing price on sep 6 | Total on Sep6 | Dividends per share | Beta | Adjusted beta |
| General Motors Co.( GM) | 3000 | 34.93 | 104,790 | 1.52 | 1.54 | 1.204 |
| Apple Inc. (AAPL) | 1000 | 225.06 | 225,060 | 2.40 | 1.6 | 1.09 |
| The Coca-Cola Co (CO) | 3000 | 45.37 | 136,110 | 1.48 | 0.48 | 0.773 |
| Starbucks Corporation (SBUX) | 2000 | 54.18 | 108,360 | 1.05 | 0.56 | 0.893 |
| Boeing Co. (BA) | 1000 | 351.17 | 351,170 | 5.68 | 1.66 | 1.045 |
| Investment Amount | 925,490 | |||||
| Remain Amount | 74,510 | |||||
| The beta of myinitial porfolio | 0.000 |