Write a 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, using the following outline:
2. 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. Are they positive? Negative? Why?
3. Explain the results from the four (4) scenarios. Be sure to discuss where you obtained your stock prices from and why you chose that source.
4. Analyze the four (4) scenarios and develop a scenario that would have exceeded the results from your best scenario. (NOTE: This will result in a fifth scenario that shows your best scenario).
5. Explain how Excel helped you with this activity and what other activities you could have done in Excel with the data provided.
To write a 3-4 page paper summarizing your findings from the four scenarios and discussing how Microsoft Excel aided the process, you can follow the following outline:
1. Introduction
- Provide a brief overview of the research objective and the purpose of the paper.
2. Summarize the various accounting systems that each firm provides
- Start by addressing each firm individually and describing the different types of accounting systems they offer.
- For each firm, provide specific examples of accounting systems they sell. For instance, Oracle sells both Oracle Financials and PeopleSoft Financials.
- Next, discuss the industries that each firm targets or markets its products to. For instance, mention if a firm primarily sells its products to banking or construction firms.
- Lastly, include an analysis of how Wall Street views each firm. Assess if the overall view is positive or negative and explain the reasons behind it.
3. Explain the results from the four scenarios
- Begin by discussing the data sources you utilized for obtaining stock prices during the scenarios.
- Clearly state the reasons you chose the particular data source, discussing the reliability and relevance of the data.
- Present the outcomes of each scenario, summarizing the key findings.
- Include any notable trends or patterns that emerged from the analysis.
4. Analyze the four scenarios and develop a scenario that would have exceeded the results from your best scenario
- Evaluate the results from each scenario and identify the best-performing scenario.
- Identify the factors that contributed to the success of the best scenario.
- Based on your analysis, propose a fifth scenario that would have yielded even better results than the best scenario.
- Explain the rationale behind your proposed scenario and provide supporting evidence.
5. Explain how Excel helped in this activity and mention other possible uses of Excel for the available data
- Discuss the specific ways in which you utilized Microsoft Excel during the research process.
- Highlight the features and functions of Excel that were beneficial for analyzing the data and drawing conclusions.
- Mention any additional calculations, visualizations, or data manipulations that could have been performed with the data set by leveraging Excel.
6. Conclusion
- Summarize the main findings from the four scenarios and the implications of your research.
- Provide a closing statement that emphasizes the value of using Microsoft Excel in financial analysis and decision-making processes.
Remember to expand on each section and include appropriate references or citations to substantiate your findings.