Finance: Stock analysis.
Not what you're looking for?
1. The accompanying Excel file provides you with monthly price and dividend data for CVS Caremark (Ticker symbol: CVS) from Yahoo Finance. (If you want to see where the data came from, go to Yahoo Finance. Type in the ticker, CVS. Then, click historical prices.)
2. Expand the spreadsheet and compute monthly HPRs for each of the 24 months using the HPR formula
Make sure to include the dividends.
3. Calculate arithmetic and geometric mean monthly HPRs for CVS.
4. Continue to expand the spreadsheet to calculate the standard deviation of the monthly HPRs .
5. Calculate the annualized version of your answers from parts 3 and 4. Your answers should be the annualized versions of only the final answers of parts 3 and 4, not annualized versions of each monthly HPR.
Note:
You may notice the use a divisor of n-1 for calculation of variance and standard deviation instead of n. In statistics, this is appropriate if we have a sample of returns rather than the entire population of returns. While this difference is not a big deal if you have over 30 observations, it can make a difference if you have a modest number of monthly returns to work with. Use the divisor of n-1 for this exercise.
Purchase this Solution
Solution Summary
The problem deals with determining the Holding period return (HPR) from stock prices.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.