Question: Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. Note: Do not round intermediate calculations

  1. Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.
  2. Calculate the standard deviation of Treasury bill returns and inflation over this time period. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.
  3. Calculate the real return for each year. Note: A negative answer should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.
  4. What is the average real return for Treasury bills? Note: 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.
 Calculate the average return for Treasury bills and the average annual

Consider the following table for an elght-year period: a. Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. b. Calculate the standard deviation of Treasury bill returns and inflation over this time period. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.9., 32.16. c. Calculate the real return for each year. Note: A negative answer should be indicated by a minus sign. Leave no cells blank - be certain to enter "o" wherever required. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. d. What is the average real return for Treasury bilis? Note: 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.9., 32.16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!