Part 1: Excel Spreadsheet Assignment
You have been given $1,000,000 to invest the five (5) stocks. You must invest the $1,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 6 months ago. Track your stocks' daily performance for the 90 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 90 days' tracking period, calculate your net gain (or loss) for each stock and your total investment at the end of the 90 days. Develop the appropriate charts that highlight your performance. You will create a minimum of two 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 close.
You are now a believer of only the Medium Market stock. With that, you will now invest your $1,000,000 into that stock.
The purchase date of the stock will be six (6) months ago. Track your stocks' daily performance for the 90 trading days following the purchase date. During this time, you will note the gains and losses each day. At the end of the 90 days' tracking period, calculate your net gain (or loss) for the stock and your total investment at the end of the 90 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 close.
Part II: Paper
Write a three to four (3-4) page paper that summarizes your findings from the four (4) scenarios as well as how using Microsoft Excel helped you with this process. Use the following outline:
1. Summarize the various accounting systems that each firm provides. Be sure to address the following for each firm: a. The various types of accounting systems it sells (e.g., Oracle sells Oracle Financials as well as PeopleSoft financials)
b. The industries that it markets itself to (e.g., most firms sell their products to banking firms, construction firms)
c. Explain how Wall Street views the firm. Is it positive? Negative? Why?
2. Analyze the results from the four (4) scenarios to determine how creditable your sources were and how your selection of sources
may have been improved.
3. Develop one (1) additional scenario that would have exceeded the results from your best scenario.
4. Determine how your findings could be used to better drive management decisions.
Your assignment must follow these formatting requirements:
- Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
- 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:
- Discuss how automated accounting software can help management make better informed business decisions.
- Organize information between Word and Excel to communicate to internal and external users.
- Use technology and information resources to research issues in microcomputer applications for accountants.
- Write clearly and concisely about microcomputer applications for accountants using proper writing mechanics.
Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills. Click here to access the rubric for this assignment.