September 2023 Create one 1 Excel workbook that contains each of the four 4 scenarios detailed below Use the appropriate Excel formulas

2024 Excel Spreadsheet Assignment Assignment Help

Create one 1 Excel workbook that contains each of the four 4 scenarios detailed below Use the appropriate Excel formulas 2023

Create one (1) Excel workbook that contains each of the four (4) scenarios (detailed below). Use the appropriate Excel formulas and functions to justify your derived results. Note: Follow the completion and submission instructions provided in the table below. Scenario 1 You have been given $5,000,000 to invest the five (5) stocks. You must invest the $5,000,000 accordingly: No more than 35% of your investment will be in the Large-Market Stocks, with a minimum of 15% investment in any given stock No more than 30% of your investments will be in the Medium-Market Stock, with a minimum of 15% investment in the stock No more than 35% of your investment will be in the Small-Market Stocks, with a minimum of 15% investment in any given stock 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: No more than 50% of your investment will be in the Large-Market Stocks, with a minimum of 20% investment in any given stock No more than 50% of your investment will be in the Small-Market Stocks, with a minimum of 20% investment in any given stock 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: No more than 50% of your investment will be in the Medium-Market Stock, with a minimum 20% investment here No more than 50% of your investment will be in the Small-Market Stocks, with a minimum 20% investment here 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. 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 the 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 $1,000,000, but you will come

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational