Consider the following table for an eight-year period: Year T-bill return Inflation 1 7.47 % 8.53 % 2 8.94 12.16 3 6.05 6.76 4 5.97 5.04 5 5.63 6.52 6 8.54 8.84 7 10.74 13.11 8 13.00 12.34 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 bills % Average annual inflation rate % Calculate the standard deviation of Treasury bill returns and inflation 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.) Standard deviation of Treasury bills % Standard deviation of inflation % Calculate the real return for each year. (A negative answer should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Year Real return 1 % 2 % 3 % 4 % 5 % 6 % 7 % 8 % What is the average real return for Treasury bills? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Average real return for Treasury bills %
Consider the following table for an eight-year period:
Year | T-bill return | Inflation | ||
1 | 7.47 | % | 8.53 | % |
2 | 8.94 | 12.16 | ||
3 | 6.05 | 6.76 | ||
4 | 5.97 | 5.04 | ||
5 | 5.63 | 6.52 | ||
6 | 8.54 | 8.84 | ||
7 | 10.74 | 13.11 | ||
8 | 13.00 | 12.34 | ||
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 bills | % |
Average annual inflation rate | % |
Calculate the standard deviation of Treasury bill returns and inflation 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.)
Standard deviation of Treasury bills | % |
Standard deviation of inflation | % |
Calculate the real return for each year. (A negative answer should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
Year | Real return |
1 | % |
2 | % |
3 | % |
4 | % |
5 | % |
6 | % |
7 | % |
8 | % |
What is the average real return for Treasury bills? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Average real return for Treasury bills %

Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images









