Reference no: EM131430217
Refer to the S&P 500 data below and copy into an Excel spreadsheet:
Date
|
Price
|
|
|
1-Jan-17 |
2,275.32
|
1-Jan-16 |
1,918.60
|
1-Jan-15 |
2,028.18
|
1-Jan-14 |
1,822.36
|
1-Jan-13 |
1,480.40
|
1-Jan-12 |
1,300.58
|
1-Jan-11 |
1,282.62
|
1-Jan-10 |
1,123.58
|
1-Jan-09 |
865.58
|
1-Jan-08 |
1,378.76
|
1-Jan-07 |
1,424.16
|
1. Compute the simple holding period returns without the dividend. Compute the arithmetic mean holding period return.
2. The geometric mean is the nth root of the product of a series. It won't work with negative numbers. Using the simple holding period returns from above, create a column that adds 1 to each return. Use the "=GEOMEAN" function in Excel to compute the geometric mean for that column. Subtract one and you have the geometric mean return.
3. Compute the continuously compounded return and the average return using logs (see online lectures). What do you notice about the continuously compounded average return and the geometric average return versus the arithmetic average return?
For the next 12 questions, you will need to collect some data and transfer them to a spreadsheet. Get the year-end (or Jan 1) prices for your stock (the company you have been following) for the last 20 years or the life of the company whichever is shorter. Get the year-end value of the Dow Jones Industrial Average for the same period. Yahoo Finance has what you need for both. Get the BofA Merrill Lynch US Corp AAA Bond Total Return Index Value and the 3-month Treasury bill rate for the same period. These can be found at the Federal Reserve website: https://fred.stlouisfed.org/ . Be nice to FRED, he's a friend.
4. Find the continuously compounded annual returns for each asset. T-bills are already listed as returns so don't bother with them.
5. Find the descriptive statistics for each asset return.
6. Are the means and medians the same for each asset? If not, what may account for the difference?
7. What were the returns for the best and worst years for each asset?
8. Create a histogram for each asset using six, equally-spaced bins with three above the mean and three below.
9. Comment about the return distribution and how it relates to a normal distribution for each of the four assets. Make sure you discuss your histogram as well as skewness and kurtosis in your comments.
10. Using Chebyshev's inequality and a little algebra (find k) and a little arithmetic and your knowledge of the definition of the standard deviation, what would be the upper and lower values that would contain 2/3 of the returns for each asset.
11. Find the Sharpe ratio for each asset. Use the 3-month Treasury bill rate as the risk-free interest rate.
12. Find the coefficient of variation for each asset.
13. Comment about the risk/reward of each asset. How did your stock compare to the other assets?
14. How do the skewness and range of each asset relate to risk reward?
15. Imagine you held a portfolio that had been rebalanced every year in the following way: 10% Treasury bills, 30% AAA bonds, 40% your stock, 20% Dow Jones Index fund. What would be your overall average annual return?
Molecule as a dash-wedge structure
: Draw the molecule as a dash-wedge structure from the IUPAC name with the correct stereochemistry: (2R,3S)-2,3 dichloropentane
|
Discuss employee engagement and provide example
: Which of the following is often a weakness of a strong organizational culture? How people dress in an organization is an example of Schein's observable artifacts? Define and discuss employee engagement and provide an example.
|
Conduct a literature review on the focusing event
: Choose a focusing event during this historical timeframe. Conduct a literature review on the focusing event. Write a two page essay and discuss the following: type of focusing event and date that it occurred; president and FEMA Director; type of Pr..
|
Illustrate how technology can benefit transfer of learning
: Illustrate how technology can benefit the transfer of learning. Explain how organizations have utilized technology in learning. Use your research or examples from your experience.
|
Compute the simple holding period returns
: Compute the simple holding period returns without the dividend. Compute the arithmetic mean holding period return and Compute the continuously compounded return and the average return
|
Calculate the maxium mass of carbon dioxide
: Calculate the maxium mass of carbon dioxide that could be produced by the chemical reaction. Be sure your answer has the correct number of significant digits.
|
Devise an algorithm for determining interior regions
: Devise an algorithm for determining interior regions for any input set of verbs using the nonzero winding-number rule and dot-product calculations to identify the direction for edge crossings.
|
Find the least squares regression line
: Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations.- Find the least-squares regression line and draw it on your plot. Give the results of the significance test for the slope.
|
Degree of accuracy and suggest sources of error
: A perfect percent yield would be 100%. Based on your results, describe your degree of accuracy and suggest sources of error.
|