1. 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 in the three (3) stocks. You must invest the $5,000,000 evenly across the stocks. The purchase date of the stock will be three (3) months ago. Track your stocks' daily performance for the 45 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 45 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 45 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 sh ares. 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 a believer in Oracle and Microsoft. With that, you will now invest your $5,000,000 evenly between the two (2) stocks. The purchase date of the stock will be three (3) months ago. Track your stocks' daily performance for the 45 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 45 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 45 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 a believer in Intuit and Microsoft. With that, you will now invest your $5,000,000 evenly between the two (2) stocks. The purchase date of the stock will be three (3) months ago. Track your stocks' daily performance for the 45 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 45 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 45 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 a believer in Oracle and Intuit. With that, you will now invest your $5,000,000 evenly between the two (2) stocks. The pur chase date of the stock will be three (3) months ago. Track your stocks' daily performance for the 45 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 45 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 45 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.
Assignment
Determine how much money you earned or lost with each stock on a daily basis.
Instructions on how to complete
There is no sample Excel workbook to use as part of the project; therefore, you will create your own workbook. In creating your workbook, be sure to include the following data (however, other data will be stored in your scenario) in a columnar format.
Stock name
Stock symbol
Number of shares purchased / acquired
Stock price
Date of stock transaction
Start your scenario using the opening-day price for each stock as your purchase price and use the closing stock price to calculate how much money you earned or lost each day.
At the end of your scenario, calculate the following for each stock in question.
The highest stock price for the period for the stock(s) selected
The lowest stock price for the period for the stock(s) selected
The average stock price for the period for the stock(s) selected
The largest amount of profit (loss) earned for the period for the stock(s) selected
The lowest amount of profit (loss) earned for the period for the stock(s) selected
Track th e stock for 45 consecutive days that the market is open.
Part II: Paper
2. Write a three to four (3-4) page paper in which you:
2a. Summarize your findings from each scenario, emphasizing your decisions on which stocks were used and the criteria for determining the number of stocks used. Suggest a strategy to improve your selection of courses.
2b. Describe an ideal scenario that would have exceeded the results from your best scenario in Part 1 of the assignment.
2c. Determine at least two ways accountants use Excel to support management decisions.
2d. Use at least two (2) quality academic resources in this assignment. Note: Wikipedia and other Websites do not qualify as academic resources.
Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Create and update spreadsheets with Microsoft Excel.
Discuss how automated accounting software can help management make better informed business decisions.
Use advanced features of Microsoft Excel to solve business problems.
Use technology and information resources to research issues in microcomputer applications for accountants.
Write clearly and concisely about microcomputer applications f or accountants using proper writing mechanics.