Question
Case: First: You are kindly requested to go to yahoofinance, pick a company of your choice, find its ticker, retrieve its historical prices data for
Case: First: You are kindly requested to go to yahoofinance, pick a company of your choice, find its ticker, retrieve its historical prices data for at least 5 years (on monthly basis), calculate its mean/average return. Second: Retrieve the historical prices data of an index that you believe represents the market for at least 5 years (on monthly basis) calculate its mean/average return. Third: You are kindly requested to use the retrieved data of the stock and the index to calculate the beta of the stock using the covariance variance method and the slope method. Fourth: Try you best to elaborate and discuss the importance of the company and its industry and the sector that it works in by discussing its SWOT analysis and its market and industry position versus its peers. N.B.: 1- you can choose any company in any country/market with a respective representative index. 2- the excel sheet should be neatly and well organized to display the collected data and the results
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started