Question

In: Finance

Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock...

Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock Market Return (%) T-Bill Return (%) 2011 ?34.33 4.30 2012 31.70 0.70 2013 14.56 0.27 2014 3.58 0.04 2015 19.46 0.06

a. What was the risk premium on common stock in each year? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)

b. What was the average risk premium? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

c. What was the standard deviation of the risk premium? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

Solutions

Expert Solution

The following are the data inputs in spreadsheet:

The following are the obtained results in spreadsheet:

Note: Stock market return in 2011 is taken as negative as there is question mark, so calculated answer is based on negative value in year 2011. However, same can be calculated using positive value, answer would be different if you put positive value instead of negative.


Related Solutions

Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock...
Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock Market Return (%) T-Bill Return (%) 2013 34.20 0.14 2014 13.90 0.14 2015 −3.80 0.14 2016 14.80 0.09 2017 24.30 0.11 Required: a. What was the risk premium on common stock in each year? b. What was the average risk premium? c. What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.)
Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock...
Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock Market Return T-Bill Return   Year 1 − 35.73 3.10   Year 2 30.10 1.50   Year 3 15.56 .21   Year 4 2.38 .06   Year 5 18.26 .08 a. What was the risk premium on common stock in each year? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Year   Risk...
Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock...
Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock Market Return (%) T-Bill Return (%) 2011 −36.53 2.10 2012 29.10 0.60 2013 16.46 0.16 2014 1.58 0.08 2015 16.86 0.10 a. What was the risk premium on common stock in each year? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) b. What was the average risk premium? (Do not round intermediate calculations. Enter your answer...
Assume these were the inflation rates and stock market and Treasury bill returns between 1929 and...
Assume these were the inflation rates and stock market and Treasury bill returns between 1929 and 1933: Year    Inflation          Stock Market Return T-Bill Return 1929          .4                      –16.0                                 6.0 1930    –4.4                       –27.2    3.0 1931    –9.1                        –41.9 1.2 1932    –11.1    –8.5    .9 1933    1.1                           63.6 .3 a. What was the real return on the stock market in each year? (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Enter...
Assume these were the inflation rates and stock market and Treasury bill returns between 1929 and...
Assume these were the inflation rates and stock market and Treasury bill returns between 1929 and 1933: Year Inflation Stock Market Return T-Bill Return 1929 .2 –11.9 5.0 1930 –5.8 –29.2 3.2 1931 –9.2 –42.3 1.6 1932 –13.3 –6.7 .7 1933 .8 59.1 .5 a. What was the real return on the stock market in each year? (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2...
Assume these were the inflation rates and U.S. stock market and Treasury bill returns between 1929...
Assume these were the inflation rates and U.S. stock market and Treasury bill returns between 1929 and 1933: Year Inflation(%) Stock Market Return(%) T-Bill Return(%) 1929 0.5 –14.2 7.0 1930 –3.4 –31.5 2.3 1931 –9.2 –47.2 1.4 1932 –11.4 –10.4 0.9 1933 0.7 63.2 0.2 What was the real return on the stock market in each year? What was the average real return? What was the risk premium in each year? What was the average risk premium?
Here are Costaguanan inflation rates and stock market and Treasury bill returns between 1929 and 1933:...
Here are Costaguanan inflation rates and stock market and Treasury bill returns between 1929 and 1933:    Year Inflation Stock Market Return T-Bill Return      1929 –0.1      –11.3              6.4               1930 –3.4      –28.3              3.8               1931 –8.7      –47.2              1.2               1932 –13.7      –7.1              0.7               1933 1.3      64.2              0.2             a. What was the real return on the stock market in each year? (Negative values should be indicated by a...
Suppose we have the following Treasury bill returns and inflation rates over an eight-year period: Year...
Suppose we have the following Treasury bill returns and inflation rates over an eight-year period: Year Treasury Bills Inflation 1 8.11%         9.83%         2 8.92            13.36            3 6.74            7.87            4 5.88            5.61            5 6.32            7.63            6 8.57            10.01            7 11.55            14.32            8 13.21            13.77            a. Calculate the average return for Treasury bills and the average annual inflation rate...
Suppose we have the following Treasury bill returns and inflation rates over an eight year period:...
Suppose we have the following Treasury bill returns and inflation rates over an eight year period: Year Treasury Bills Inflation 1 9.23%         11.07%         2 10.10            14.66            3 7.84            9.03            4 6.92            6.59            5 7.42            8.79            6 9.73            11.23            7 12.57            15.40            8 14.35            15.20            a. Calculate the average return for Treasury bills and the average annual inflation...
Suppose we have the following Treasury bill returns and inflation rates over an eight year period:...
Suppose we have the following Treasury bill returns and inflation rates over an eight year period: Year Treasury Bills Inflation 1 7.37%         8.79%         2 8.07            12.42            3 5.95            7.02            4 5.15            4.94            5 5.53            6.78            6 7.72            9.10            7 10.64            13.37            8 12.18            12.60 Calculate the standard deviation of Treasury bill returns and inflation over this period. (Do...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT