Arithmetic Average, Standard Deviation and Returns

Calculate the arithmetic average, the geometric average, the variance and standard deviation For the S&P 500 index for the decade of 1980-1990. Do the same calculations for the S&P 500 index for 2000-2010. Compare and contrast your answers and provide explanations for the similarities and differences. Calculate the statistical measures using both annual and monthly returns, but compare and contrast using only annual data. [answer should only be approximately 1/2 page in length, spreadsheet calculations not included]

2. Find the adjusted monthly prices for the past year for both Novartis AG (NVS) and Pfizer (PFE). Assume you just inherited $3000. You plan to use half of your inheritance in Novartis AG and the other half in Pfizer. You purchase (go long) in Novartis and sell short Pfizer. Both transactions are done using margin where the initial margin is 50% and the maintenance margin is 30%. Using only monthly prices, determine if either strategy received a margin call and if so how much. What is the return on both investments? Explain the differences or similarities in returns. [answer should only be approximately 1/2 -2/3, spreadsheet calculations not included]

Solution Preview

See the attached file. Thanks

1. Performance of S&P500 during different decades

The calculations for the performance of S&P500 in 1980s, 1990s and 2000s is done in Excel file. The data is analyzed both at monthly level and annual level. However, for discussion purpose, I am presenting the annual figures. Based on annual data the performance of S&P500 is shown below:
2000-2010 1990-2000 1980-1990
Arithmetic Average 1.687% 15.772% 9.98%
Geometric Average -0.485% 14.865% 9.296%
Standard Deviation 20.73% 14.93% 12.77%
Variance 0.0429561 0.0223039 0.0163112

The return during the 1990s is highest among the three decades, followed by 1980s. 2000s saw almost zero return on the S&P500 index. While the arithmetic average return is slightly positive at ...

Solution Summary

This post has two problems. First query shows how to calculate arithmetic average, geometric average, variance and standard deviation. Second query shows how to calculate adjusted monthly prices, returns and discusses about the similarities and differences in returns.

Suppose the security I and security J have the following historical returns:
Year kI kJ
2001 20% 40%
2002 29 36
2003 -12 -25
1. What is the (arithmetic) average return on security I?
2. What is the standarddeviation of the return on security I? (U

During the past five years you owned two stocks that had the following annual rates of return:
Year Stock A Stock B
1 0.18 0.09
2 0.6 0.04
3 -0.15 -0.11
4 -0.01 0.04
5 0.11 0.05
a) compute the arithmetic annual rate of return for each stock. Which stock is most desirable by this measure?
b) Compute th

The following table shows the nominal returns on U. S. stocks and the rate of inflation.
a. What was the standarddeviation of the market returns?
b. Calculate the average real return.
Year Nominal Return (%) Inflation (%)
2004 12.5 3.3
2005 6.4

Calculate the expected return andstandarddeviation of returns for asset A are (See below.)
Possible Outcomes Probability Returns (%)
Pessimistic 0.25 5
Most likely 0.55 10
Optimistic 0.20 13

1) The following table provides month end prices and cash dividends from Exxon Mobil (XOM) for a recent two year period. Use these data to complete the following analyses.
Date Price Dividend
Dec-06 76.63
Nov-06 76.81 0.32
Oct-06 71.42
Sep-06 67.1
Aug-06 67.67 0.32

1) From the following information, compute the average annual return, the variance, standarddeviation,and coefficient of variation for each asset.
Asset Annual Returns
A 5%, 10%, 15%, 4%
B -6%, 20%, 2%, -5%, 10%
C 12%,15%, 17%

1. Returns: Suppose you bought a 6 percent coupon bond one year ago for $1040. The bond sells for 1,063 today.
a. Assuming a $1,000 face value, what was your total dollar return on this investment over the past year?
b. What was your total nominal rate of return on this investment over the past Year?
c. If the inflation

I need some help with this assignment, I am not sure how to answer the questions based on the scenario provided: The Allied Group has acquired Kramer Industries and is now considering additional investments. They have determined that there is a firm that is a good fit for their portfolio, the Kramer firm of Montana. The firm was