Question

The following table shows the nominal returns on US. stocks and the rate of inflation, ㄧ Year Nominal Return (%) Inflation (%) 12.0 7.8 172 7.7 -43.5 2.4 3.2 4.0 4.3 .2 2010 2011 2014 a. What was the standard deviation of the nominal market returns? (Do not make the adjustment for degrees of freedom described in footnote 18) (Use decimals, not percents, in your caleulations. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places Standard deviation b. Calculate the arithmetic average real return. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Average real return
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

Real return = Nominal return - inflation

We can use excel functions to calculate the standard deviation and average return

Part A )

Standard deviation = 22.14%

Part B ) Average real return = -2.58%

3 Year Nominal return Inflation Real Return 42010 5 2011 6 2012 7 2013 8 2014 9 STD 10 11 Average 2.40%) 3.20%) 4.00%) 4.30%) 0.20%) 9.60%)-84-C4 4.60%)-85-C5 13.20%)-86-C6 3.40%)-87-C7 -43.70%)-88-C8 12.00%) 7.80%) 17.20%) 7.70%) -43.50%) 22.14% :STDEV.P(84:88 2.58%)-AVERAGE(D4:D8 13 15 16

Add a comment
Know the answer?
Add Answer to:
The following table shows the nominal returns on US. stocks and the rate of inflation, ㄧ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following table shows the nominal returns on U.S. stocks and the rate of inflation. Year...

    The following table shows the nominal returns on U.S. stocks and the rate of inflation. Year 1 2010 2011 2012 Nominal Retum (%) ITI Inflation (%)11 12.0 7.8 17.2 7.7 -43.5 2.4 3.2 4.0 4.3 .2 2014 a. What was the standard deviation of the nominal market returms? (Do not make the adjustment for degrees of freedom described in footnote 18.) (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Enter your answer as a percent rounded...

  • The following table shows the nominal returns on U.S. stocks and the rate of inflation Nominal...

    The following table shows the nominal returns on U.S. stocks and the rate of inflation Nominal Return(%) 10.4 8.3 16.0 3.9 Inflation (%) Year 2010 2011 2012 2013 2014 3.5 3.0 3.8 4.6 .2 -37.2 a. What was the standard deviation of the nominal market returns? (Do not make the adjustment for degrees of freedom described in footnote 18.) (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Enter your answer as a percent rounded to 2...

  • Consider the following information on large company stocks for a period of years. Large-company stocks Inflation...

    Consider the following information on large company stocks for a period of years. Large-company stocks Inflation Arithmetic Mean 15.58 3.6 a. What was the arithmetic average annual return on large-company stocks In nominal terms? (Do not round Intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.. 32.16.) Nominal return b. What was the arithmetic average annual return on large-company stocks in real terms? (Do not round Intermediate calculations and enter your answer as a...

  • 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 WN Treasury Bills 10.45% 11.36 9.06 8.34 8.88 11.23 14.11 15.97 Inflation 12.55% 16.00 10.29 7.97 10.29 12.77 16.98 16.90 00 O a. Calculate the arithmetic average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Average...

  • Consider the following table for a period of six years: Year Returns Large- U.S. Company Stocks...

    Consider the following table for a period of six years: Year Returns Large- U.S. Company Stocks Treasury Bills - 16.39% 7.63% -26.98 8.16 37.57 6.21 24.27 6.77 - 7.84 5.62 6.91 8.15 Un a-1. Calculate the arithmetic average returns for large-company stocks and T-bills over this time period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) a-2. Calculate the standard deviation of the returns for large-company stocks and T-bills...

  • Consider the following information on large-company stocks for a period of years. Series Arithmetic Mean Large-company...

    Consider the following information on large-company stocks for a period of years. Series Arithmetic Mean Large-company stocks 15.1 % Inflation 4.9 a. What was the arithmetic average annual return on large-company stocks in nominal terms? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Nominal return 15.1 % b. What was the arithmetic average annual return on large-company stocks in real terms? (Do not round intermediate calculations and enter your...

  • Problem 10-5 Nominal versus Real Returns [LO 2] Consider the following information on different asset classes...

    Problem 10-5 Nominal versus Real Returns [LO 2] Consider the following information on different asset classes from 1926 through 2011. Arithmetic Mean 11.8% 16.5 6.4 Series Large-company stocks Small-company stocks Long-term corporate bonds Long-term government bonds Intermediate-term government bonds U.S. Treasury bills Inflation 6.1 5.5 3.6 3.1 Required: (a) What was the arithmetic average annual return on large-company stocks in nominal terms? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).)...

  • Consider the following table for an eight-year period: Year T-bill return Inflation 1 7.44 % 8.56...

    Consider the following table for an eight-year period: Year T-bill return Inflation 1 7.44 % 8.56 % 2 8.79 12.19 3 6.02 6.79 4 5.82 5.01 5 5.60 6.55 6 8.39 8.87 7 10.71 13.14 8 12.85 12.37 Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Average return for Treasury...

  • Consider the following table for a period of six years: Returns Year Large-Company Stocks U.S. Treasury Bills...

    Consider the following table for a period of six years: Returns Year Large-Company Stocks U.S. Treasury Bills 1 –15.59 % 7.47 % 2 –26.74 8.08 3 37.41 6.05 4 24.11 5.97 5 –7.52 5.54 6 6.75 7.91    Calculate the arithmetic average returns for large-company stocks and T-bills over this time period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Arithmetic average returns Large-company stock % T-bills % Calculate...

  • Consider the following information on large-company stocks for a period of years. Arithmetic Mean 12.9% 3.4...

    Consider the following information on large-company stocks for a period of years. Arithmetic Mean 12.9% 3.4 Large-company stocks Inflation a. What was the arithmetic average annual return on large-company stocks in nominal terms? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What was the arithmetic average annual return on large-company stocks in real terms? (Do not round intermediate calculations and enter your answer as a percent rounded to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT