The aim of this assignment is to elaborate a report describing stock market price evolution of two publicly traded companies
• Analysis of two data sets using the descriptive toolsCourse: Data Analysis for Managers. Banking and Finance major
Submission deadline: 24th Nov 2021, 6:00pm GMT+8 time, Quality of Work:
• Must be provided in a high-quality with appropriate theories, calculation, methodologies, explanation for MBA-Banking and Finance level.
• Demonstrate deep understanding of a company’s capital structure apply and critically evaluate different sources of financing.
• Demonstrate advanced knowledge and understanding treasury risk and interest rate risk.
OBJECTIVE of the Assignment:
The aim of this assignment is to elaborate a report describing stock market price evolution of two publicly traded companies. Prepare a business report that will answer the assessment questions and that should be supported with all the necessary analysis (plots, tables etc.).
Please follow the order of questions and provide a clear answer to each of them, attach an excel file with all the calculations conducted.
Please notice that the excel file alone will not be evaluated as the assessment should be elaborated using the standard business report format.
Assessment REQUIREMENT:
• Demonstrate a knowledge of advanced quantitative business methodologies (principles, theories, and methods) and their applicability.
• Analyze and classify different management problems using a variety of quantitative methods.
• Apply and use analytical techniques to make recommendations that solve complex business problems.
• Analyze business data within business decision making and determine its importance to draw conclusions and produce business reports.
• Frame and apply different types of decision-making exercises applying the different quantitative business methodologies.
Assessment INSTRUCTION:
Choose two well-known companies listed on the New York stock exchange (or any other stock exchange). For the sake of this exercise please select these companies from two different sectors.
Find the data for its daily stock price for the period of at least 5 last years (you need to use the same time span for both companies). I recommend using the finance.yahoo.com web page that allow to download a data for publicly traded companies for free (please see the appendix how to download data from finance.yahoo.com). You can also use Google Finance and spreadsheet in Google to download the data as well.
You will need to convert stock prices into returns as than the analysis for two companies will make sense – the easiest way to calculate the daily return is to take: closing price of day t / closing price of day (t-1) – the previous day. Then divide the difference by the price of the previous day to get the return in % terms.
In such way you will generate the time series of daily returns for these two companies. Please check if the data span is of the same length.
Now please prepare a business report that should be supported with all the necessary analysis (plots, tables etc.). The excel file must be submitted as well however will not be graded as all the solutions and comments must be presented in the business report.
The Business report should be a professional document that contains the following 5 points/answers to the questions:
Part 1. Company description and price evolution:
1. Describe briefly both companies – industry, product, market position (MS word file with 300 words no spaces and MS excel with graph, formula, calculations)
2. Present the graph of both the daily price evolution and daily returns – comment on the price changes and the daily returns. Do you observe any extreme changes? What would be an explanation for them (please support any facts that can support your answer) (MS word file with 300 words no spaces and MS excel with graph, formula, calculations)
Part 2. Statistical analysis:
Please prepare the measures of the central tendency, dispersion and association of variables and based on this answer the following questions:
3. What is the mean stock price return for both companies? What is the meaning of the number you have obtained? Please compare the results obtained for both companies (MS word file with 300 words no spaces and MS excel with graph, formula, calculations)
4. What is the median stock price return for both companies? What is the meaning of the number you have obtained? Please compare the results obtained for both companies (MS word file with 300 words no spaces and MS excel with graph, formula, calculations)
5. Construct a frequency distribution of your choice (the intervals should be chosen by you for showing the distribution of the data in the best way) and percent frequency distribution of the stock price return for the indicated period for both companies. Evaluate the results and compare (MS word file with 300 words no spaces and MS excel with graph, formula, calculations)
Deliverables:
• Remember to show all your calculations, cash flow statement in detail as MS excel file. Excel file with all the problems solutions, graphs and all the necessary calculations, with proper formulas and formatting
• Number of words: 1,500 words with detailed explanation for a business report (excluding excel file)
• Make sure you clearly explain, describe assumptions, if any and reference the source of the information used in your calculations.
• Use Harvard Referencing System and 100% plagiarism free
WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
TO BE RE-WRITTEN FROM THE SCRATCH
GET SOLUTION FOR THIS ASSIGNMENT
TO BE RE-WRITTEN FROM THE SCRATCH
- Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
- Timely Delivery- primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
- Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
- Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
- Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
- Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals Briefly, what was your reaction to the Brandon Teena Video?
Get Professionally Written Papers From The Writing Experts
Comments
Post a Comment