The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Part I: Excel Spreadsheet Assignment
|
Scenario 1 |
You have been given $5,000,000 to invest the five (5) stocks. You must invest the $5,000,000 accordingly:
The purchase date of the stock will be six (6) months ago. Track your stocks' daily performance for the 120 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 120 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 120 days. Develop the appropriate charts that highlight your performance. You will create a minimum of two (2) charts. Note: Your purchase must be in whole shares. For example, you cannot purchase 100.5 shares. You must purchase either 100 or 101 shares. For this reason, you may not total to exactly $5,000,000, but you will come close. |
|
Scenario 2 |
You are now skeptical of the Medium-Market stock. With that, you will now invest your $5,000,000 accordingly:
The purchase date of the stock will be six (6) months ago. Track your stocks' daily performance for the 120 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 120 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 120 days. Develop the appropriate charts that highlight your performance. You will create a minimum of two (2) charts. Note: Your purchase must be in whole shares. For example, you cannot purchase 100.5 shares. You must purchase either 100 or 101 shares. For this reason, you may not total to exactly $5,000,000, but you will come close. |
|
Scenario 3 |
You are now skeptical of the Large-Market Stock. With that, you will now invest your $5,000,000 accordingly:
The purchase date of the stock will be six (6) months ago. Track your stocks' daily performance for the 120 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 120 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 120 days. Develop the appropriate charts that highlight your performance. You will create a minimum of two (2) charts. Note: Your purchase must be in whole shares. For example, you cannot purchase 100.5 shares. You must purchase either 100 or 101 shares. For this reason, you may not total to exactly $5,000,000, but you will come close. |
|
Scenario 4 |
You are now a believer of only the Medium Market Stock. With that, you will now invest your $5,000,000 into that stock. Note: Your purchase must be in whole shares. For example, you cannot purchase 100.5 shares. You must purchase either 100 or 101 shares. For this reason, you may not total to exactly $1,000,000, but you will come |
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll