Stock Analysis
At the bottom of the column in your holdings tab, calculate the weighted average for P/E ratio, Beta, and Market Cap. Below your weighted average put the S&P 500 average for each of the above.
| Group Name: The Game of Loans | |||||||||||
| Memebers: Natalie Beaini, Giovanni Barba, Abner Melendez, Taylor Cunningham | |||||||||||
| Ticker | Company Desc. | Sector | Price as of 1/21/2020 | Number of Shares | Market Value | Beta | Price to Earnings Ratio | Dividend Yield | Dividend Yield | Market Capitalization(Billions) | Portfolio Weight |
| INTC | Intel Corporation | Information Technology | $ 60.55 | 6117 | 370384.35 | 0.9 | 14.28 | 1.32 | 1.96% | 287.714 | 3.70% |
| CRM | salesforce.com,inc. | Information Technology | $ 185.27 | 2000 | 370540 | 1.22 | 212 | 0 | 0.00% | 168.486 | 3.71% |
| AAPL | Apple Inc. | Information Technology | $ 316.57 | 1170 | 370386.9 | 1.28 | 25.8 | 3.08 | 0.95 | 1422 | 3.70% |
| TXN | Texas Instruments Incorporated | Information Technology | $ 130.86 | 2830 | 370333.8 | 1.21 | 25.25 | 3.6 | 2.71% | 123.224 | 3.70% |
| ADBE | Adobe Inc. | Information Technology | $ 350.00 | 1058 | 370300 | 1.05 | 63.28 | 0 | 0.00% | 185.175 | 3.70% |
| VGT | Vanguard Info Tech EFT | $ 259.30 | |||||||||
| DVA | DaVita Inc. | Health Care | $ 79.90 | 4635 | 370336.5 | 1.77 | 16.27 | 0 | 0.00% | 10.795 | 3.70% |
| JNJ | Johnson & Johnson | Health Care | $ 149.27 | 2481 | 370338.87 | 0.71 | 26.67 | 3.8 | 2.53% | 392.507 | 3.70% |
| BDX | Becton, Dickinson and Company | Health Care | $ 277.53 | 1335 | 370502.55 | 1.09 | 94.18 | 3.16 | 1.25% | 70.565 | 3.71% |
| VHT | Vanguard Health Care EFT | $ 196.80 | |||||||||
| C | CitiGroup | Financials | $ 76.74 | 4826 | 370347.24 | 1.77 | 9.8 | 2.08 | 2.58% | 166.5 | 3.70% |
| JPM | JpMorganChase | Financials | $ 132.20 | 2801 | 370292.2 | 1.14 | 12.82 | 3.6 | 2.61% | 423.927 | 3.70% |
| AIG | American International Group | Financials | $ 50.13 | 7388 | 370360.44 | 1.07 | 24.1 | 1.28 | 2.51% | 42.175 | 3.70% |
| VFH | Vanguard Financials EFT | $ 76.42 | |||||||||
| NFLX | Netflix | Communication Services | $ 338.11 | 1095 | 370230.45 | 1.48 | 92.11 | 0 | 0.00% | 166.922 | 3.70% |
| CHTR | Charter Communications, Inc. | Communication Services | $ 503.59 | 735 | 370138.65 | 1.06 | 71.8 | 0 | 0.00% | 112.31 | 3.70% |
| EA | Electronic Arts Inc. | Communication Services | $ 112.41 | 3294 | 370278.54 | 1.05 | 11.55 | 0 | 0.00% | 31.77 | 3.70% |
| VOX | Vanguard Comm. Services EFT | $ 183.14 | |||||||||
| NKE | Nike | Consumer Discretionary | $ 100.26 | 3694 | 370360.44 | 0.84 | 36.2 | 0.98 | 0.95% | 161.25 | 3.70% |
| LOW | Lowes | Consumer Discretionary | $ 120.04 | 3085 | 370323.4 | 1.27 | 33.59 | 2.2 | 1.76% | 96.131 | 3.70% |
| SBUX | Starbucks | Consumer Discretionary | $ 88.63 | 4179 | 370384.77 | 0.53 | 30.58 | 1.64 | 1.90% | 103.101 | 3.70% |
| VCR | Vanguard Consumer Disc. EFT | $ 194.02 | |||||||||
| RTN | Raytheon Company | Industrials | $ 228.99 | 1617 | 370276.83 | 0.83 | 19.05 | 3.77 | 1.66% | 63.256 | 3.70% |
| WM | Waste Management | Industrials | $ 120.41 | 3076 | 370381.16 | 0.59 | 32.16 | 2.05 | 1.65% | 53.348 | 3.70% |
| RHI | Robert Half International Inc. | Industrials | $ 62.58 | 5918 | 370348.44 | 1.38 | 15.44 | 1.24 | 2.05% | 6.989 | 3.70% |
| VIS | Vanguard Industrials EFT | S&P 500 Industrials | $ 157.75 | ||||||||
| COST | Costco | Consumer Staples | $ 313.26 | 1182 | 370273.32 | 0.9 | 37.76 | 2.6 | 0.08% | 140.616 | 3.70% |
| PG | Proctor & Gamble | Consumer Staples | $ 125.35 | 2955 | 370409.25 | 0.36 | 70.71 | 2.6 | 0.82% | 311.496 | 3.70% |
| VDC | Vanguard Consumer Staples EFT | S&P 500 Consumer Staples | $ 163.45 | ||||||||
| XOM | Exxon Mobile Corporation | Energy | $ 67.58 | 5480 | 370338.4 | 1.03 | 18.06 | 3.48 | 5.71% | 256.791 | 3.70% |
| RDS-A | Royal Dutch Shell plc | Energy | $ 57.46 | 6456 | 370961.76 | 0.82 | 12.95 | 3.76 | 7.37% | 185.976 | 3.71% |
| VDE | Vanguard Energy EFT | S&P 500 Energy | $ 78.19 | ||||||||
| EIX | Edison International | Utilities | $ 78.20 | 4736 | 370355.2 | 0.21 | 0 | 2.55 | 3.30% | 27.662 | 3.70% |
| VPU | Vanguard Utilities EFT | S&P 500 Utilities | $ 148.49 | ||||||||
| HST | Host Hostels & Resorts | Real Estate | $ 16.65 | 22245 | 370379.25 | 1.28 | 10.91 | 0.8 | 4.74% | 12.127 | 3.70% |
| VNQ | Vanguard Real Estate EFT | S&P 500 Real Estate | $ 95.62 | ||||||||
| NUE | Nucor Corp | Materials | $ 49.19 | 7530 | 370400.7 | 1.64 | 11.39 | 1.61 | 3.36% | 14.23 | 3.70% |
| VAW | Vanguard Materials EFT | S&P 500 Materials | $ 131.77 | 0 | |||||||
| Weighted Averages | 87.7821188 | 0.0003 | 0.009030267 | ||||||||
| S&P 500 Averages | 43891.0594 | 0.125 | 4.515133693 | ||||||||
ORDER A PLAGIARISM-FREE PAPER HERE
We’ll write everything from scratch
Question 
Stock Analysis
At the bottom of the column in your holdings tab, calculate the weighted average for P/E ratio, Beta, and Market Cap.
Stock Analysis
Below your weighted average put the S&P 500 average for each of the above.
| Group Name: The Game of Loans | |||||||||||
| Memebers: Natalie Beaini, Giovanni Barba, Abner Melendez, Taylor Cunningham | |||||||||||
| Ticker | Company Desc. | Sector | Price as of 1/21/2020 | Number of Shares | Market Value | Beta | Price to Earnings Ratio | Dividend Yield | Dividend Yield | Market Capitalization(Billions) | Portfolio Weight |
| INTC | Intel Corporation | Information Technology | $ 60.55 | 6117 | 370384.35 | 0.9 | 14.28 | 1.32 | 1.96% | 287.714 | 3.70% |
| CRM | salesforce.com,inc. | Information Technology | $ 185.27 | 2000 | 370540 | 1.22 | 212 | 0 | 0.00% | 168.486 | 3.71% |
| AAPL | Apple Inc. | Information Technology | $ 316.57 | 1170 | 370386.9 | 1.28 | 25.8 | 3.08 | 0.95 | 1422 | 3.70% |
| TXN | Texas Instruments Incorporated | Information Technology | $ 130.86 | 2830 | 370333.8 | 1.21 | 25.25 | 3.6 | 2.71% | 123.224 | 3.70% |
| ADBE | Adobe Inc. | Information Technology | $ 350.00 | 1058 | 370300 | 1.05 | 63.28 | 0 | 0.00% | 185.175 | 3.70% |
| VGT | Vanguard Info Tech EFT | $ 259.30 | |||||||||
| DVA | DaVita Inc. | Health Care | $ 79.90 | 4635 | 370336.5 | 1.77 | 16.27 | 0 | 0.00% | 10.795 | 3.70% |
| JNJ | Johnson & Johnson | Health Care | $ 149.27 | 2481 | 370338.87 | 0.71 | 26.67 | 3.8 | 2.53% | 392.507 | 3.70% |
| BDX | Becton, Dickinson and Company | Health Care | $ 277.53 | 1335 | 370502.55 | 1.09 | 94.18 | 3.16 | 1.25% | 70.565 | 3.71% |
| VHT | Vanguard Health Care EFT | $ 196.80 | |||||||||
| C | CitiGroup | Financials | $ 76.74 | 4826 | 370347.24 | 1.77 | 9.8 | 2.08 | 2.58% | 166.5 | 3.70% |
| JPM | JpMorganChase | Financials | $ 132.20 | 2801 | 370292.2 | 1.14 | 12.82 | 3.6 | 2.61% | 423.927 | 3.70% |
| AIG | American International Group | Financials | $ 50.13 | 7388 | 370360.44 | 1.07 | 24.1 | 1.28 | 2.51% | 42.175 | 3.70% |
| VFH | Vanguard Financials EFT | $ 76.42 | |||||||||
| NFLX | Netflix | Communication Services | $ 338.11 | 1095 | 370230.45 | 1.48 | 92.11 | 0 | 0.00% | 166.922 | 3.70% |
| CHTR | Charter Communications, Inc. | Communication Services | $ 503.59 | 735 | 370138.65 | 1.06 | 71.8 | 0 | 0.00% | 112.31 | 3.70% |
| EA | Electronic Arts Inc. | Communication Services | $ 112.41 | 3294 | 370278.54 | 1.05 | 11.55 | 0 | 0.00% | 31.77 | 3.70% |
| VOX | Vanguard Comm. Services EFT | $ 183.14 | |||||||||
| NKE | Nike | Consumer Discretionary | $ 100.26 | 3694 | 370360.44 | 0.84 | 36.2 | 0.98 | 0.95% | 161.25 | 3.70% |
| LOW | Lowes | Consumer Discretionary | $ 120.04 | 3085 | 370323.4 | 1.27 | 33.59 | 2.2 | 1.76% | 96.131 | 3.70% |
| SBUX | Starbucks | Consumer Discretionary | $ 88.63 | 4179 | 370384.77 | 0.53 | 30.58 | 1.64 | 1.90% | 103.101 | 3.70% |
| VCR | Vanguard Consumer Disc. EFT | $ 194.02 | |||||||||
| RTN | Raytheon Company | Industrials | $ 228.99 | 1617 | 370276.83 | 0.83 | 19.05 | 3.77 | 1.66% | 63.256 | 3.70% |
| WM | Waste Management | Industrials | $ 120.41 | 3076 | 370381.16 | 0.59 | 32.16 | 2.05 | 1.65% | 53.348 | 3.70% |
| RHI | Robert Half International Inc. | Industrials | $ 62.58 | 5918 | 370348.44 | 1.38 | 15.44 | 1.24 | 2.05% | 6.989 | 3.70% |
| VIS | Vanguard Industrials EFT | S&P 500 Industrials | $ 157.75 | ||||||||
| COST | Costco | Consumer Staples | $ 313.26 | 1182 | 370273.32 | 0.9 | 37.76 | 2.6 | 0.08% | 140.616 | 3.70% |
| PG | Proctor & Gamble | Consumer Staples | $ 125.35 | 2955 | 370409.25 | 0.36 | 70.71 | 2.6 | 0.82% | 311.496 | 3.70% |
| VDC | Vanguard Consumer Staples EFT | S&P 500 Consumer Staples | $ 163.45 | ||||||||
| XOM | Exxon Mobile Corporation | Energy | $ 67.58 | 5480 | 370338.4 | 1.03 | 18.06 | 3.48 | 5.71% | 256.791 | 3.70% |
| RDS-A | Royal Dutch Shell plc | Energy | $ 57.46 | 6456 | 370961.76 | 0.82 | 12.95 | 3.76 | 7.37% | 185.976 | 3.71% |
| VDE | Vanguard Energy EFT | S&P 500 Energy | $ 78.19 | ||||||||
| EIX | Edison International | Utilities | $ 78.20 | 4736 | 370355.2 | 0.21 | 0 | 2.55 | 3.30% | 27.662 | 3.70% |
| VPU | Vanguard Utilities EFT | S&P 500 Utilities | $ 148.49 | ||||||||
| HST | Host Hostels & Resorts | Real Estate | $ 16.65 | 22245 | 370379.25 | 1.28 | 10.91 | 0.8 | 4.74% | 12.127 | 3.70% |
| VNQ | Vanguard Real Estate EFT | S&P 500 Real Estate | $ 95.62 | ||||||||
| NUE | Nucor Corp | Materials | $ 49.19 | 7530 | 370400.7 | 1.64 | 11.39 | 1.61 | 3.36% | 14.23 | 3.70% |
| VAW | Vanguard Materials EFT | S&P 500 Materials | $ 131.77 | 0 | |||||||
| Transaction | Company Name | Shares | Transaction Price | Amount | Cash Balance | Notes | ||
| Cash Deposit | $10,000,000.00 | $10,000,000.00 | ||||||
| BUY | Intel Corporation | 6117 | $ 60.55 | $370,384.35 | $9,629,615.65 | 6116.769123 | 370370.3704 | |
| BUY | salesforce.com,inc. | 2000 | $ 185.27 | $370,540.00 | $9,259,075.65 | 1999.084419 | ||
| BUY | Apple Inc. | 1170 | $ 316.57 | $370,386.90 | $8,888,688.75 | 1169.947785 | ||
| BUY | Texas Instruments Incorporated | 2830 | $ 130.86 | $370,333.80 | $8,518,354.95 | 2830.279462 | ||
| BUY | Adobe Inc. | 1058 | $ 350.00 | $370,300.00 | $8,148,054.95 | 1058.201058 | ||
| BUY | DaVita Inc. | 4635 | $ 79.90 | $370,336.50 | $7,777,718.45 | 4635.42391 | ||
| BUY | Johnson & Johnson | 2481 | $ 149.27 | $370,338.87 | $7,407,379.58 | 2481.211029 | ||
| BUY | Becton, Dickinson and Company | 1335 | $ 277.53 | $370,502.55 | $7,036,877.03 | 1334.523728 | ||
| BUY | CitiGroup | 4826 | $ 76.74 | $370,347.24 | $6,666,529.79 | 4826.301412 | ||
| BUY | JpMorganChase | 2801 | $ 132.20 | $370,292.20 | $6,296,237.59 | 2801.591304 | ||
| BUY | American International Group | 7388 | $ 50.13 | $370,360.44 | $5,925,877.15 | 7388.198092 | ||
| BUY | Netflix | 1095 | $ 338.11 | $370,230.45 | $5,555,646.70 | 1095.413831 | ||
| BUY | Charter Communications, Inc. | 735 | $ 503.59 | $370,138.65 | $5,185,508.05 | 735.460137 | ||
| BUY | Electronic Arts Inc. | 3294 | $ 112.41 | $370,278.54 | $4,815,229.51 | 3294.816923 | ||
| BUY | Nike | 3694 | $ 100.26 | $370,360.44 | $4,444,869.07 | 3694.099046 | ||
| BUY | Lowes | 3085 | $ 120.04 | $370,323.40 | $4,074,545.67 | 3085.391289 | ||
| BUY | Starbucks | 4179 | $ 88.63 | $370,384.77 | $3,704,160.90 | 4178.837531 | ||
| BUY | Raytheon Company | 1617 | $ 228.99 | $370,276.83 | $3,333,884.07 | 1617.408491 | ||
| BUY | Waste Management | 3076 | $ 120.41 | $370,381.16 | $2,963,502.91 | 3075.910393 | ||
| BUY | Robert Half International Inc. | 5918 | $ 62.58 | $370,348.44 | $2,593,154.47 | 5918.350437 | ||
| BUY | Costco | 1182 | $ 313.26 | $370,273.32 | $2,222,881.15 | 1182.309808 | ||
| BUY | Proctor & Gamble | 2955 | $ 125.35 | $370,409.25 | $1,852,471.90 | 2954.689831 | ||
| BUY | Exxon Mobile Corporation | 5480 | $ 67.58 | $370,338.40 | $1,482,133.50 | 5480.473074 | ||
| BUY | Royal Dutch Shell plc | 6456 | $ 57.46 | $370,961.76 | $1,111,171.74 | 6445.707803 | ||
| BUY | Edison International | 4736 | $ 78.20 | $370,355.20 | $740,816.54 | 4736.193995 | ||
| BUY | Host Hostels & Resorts | 22245 | $ 16.65 | $370,379.25 | $370,437.29 | 22244.46669 | ||
| BUY | Nucor Corp | 7530 | $ 49.19 | $370,400.70 | $36.59 | 7529.383419 | ||
| $9,999,963.41 |
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.