SC_ex19 Module 7 1a
jj3869623
SC_EX19_7a_.xlsxDocumentation
| Shelly Cashman Excel 2019 | Module 7: SAM Project 1a | |
| Ballantyne Investments | |
| IMPORT DATA AND WORK WITH SMARTART AND IMAGES | |
| Author: | |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Asset Management
| Asset Management Team | ||||||
| Name | Position | Specialty | Years Experience | From | Performance Summary ($ millions) | |
Ballantyne Investments
Performance Summary
| Total Cost of Accounts | Value of Accounts | Difference $ | Difference % |
| $ 5,968.24 | $ 6,655.96 | $ 687.72 | 12% |
Client Investment Tracker
| Client Investment Tracker | |||||
| Total invested | $ 8,300.00 | Gain (Loss) | $ 450.00 | ||
| Total value | $ 8,750.00 | % Gain (Loss) | 5.4% | ||
| Date | Investment | Total Value | Total Invested | Total Gain (Loss) | Total % Gain (Loss) |
| 1/12/21 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ - 0 | 0.0% |
| 2/10/21 | $ 1,000.00 | $ 3,100.00 | $ 3,000.00 | $ 100.00 | 3.3% |
| 3/8/21 | $ 500.00 | $ 3,425.00 | $ 3,500.00 | $ (75.00) | -2.1% |
| 4/12/21 | $ 500.00 | $ 3,995.00 | $ 4,000.00 | $ (5.00) | -0.1% |
| 5/11/21 | $ (200.00) | $ 3,900.00 | $ 3,800.00 | $ 100.00 | 2.6% |
| 6/3/21 | $ 1,000.00 | $ 5,050.00 | $ 4,800.00 | $ 250.00 | 5.2% |
| 7/5/21 | $ 1,500.00 | $ 6,775.00 | $ 6,300.00 | $ 475.00 | 7.5% |
| 8/2/21 | $ 2,000.00 | $ 8,750.00 | $ 8,300.00 | $ 450.00 | 5.4% |
| Total invested: | |||||
Total Value of Investments
Jan Total Value Total Invested 2000 2000 Feb Total Value Total Invested 3100 3000 Mar Total Value Total Invested 3425 3500 Apr Total Value Total Invested 3995 4000 May Total Value Total Invested 3900 3800 Jun Total Value Total Invested 5050 4800 Jul Total Value Total Invested 6775 6300 Aug Total Value Total Invested 8750 8300
Ballantyne Investments
