must be done in excel

CHAPTER 10 Some Lessons from Capital Market History Inflows Time Dollar returns Initial investment Calculating Returns Refer to Table 10.1 in the text and look at the period from 1973 through 1980. a. Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. b. Calculate the standard deviation of Treasury bill returns and inflation over this time period. c. Calculate the real return for each year. What is the average real return for Treasury bills? d. Many people consider Treasury bills to be risk-free. What does this tell you about the potential risks of Treasury bills? CHAPTER 10 Some Lessons from Capital Market History Inflows Time Dollar returns Initial investment Calculating Returns Refer to Table 10.1 in the text and look at the period from 1973 through 1980. a. Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. b. Calculate the standard deviation of Treasury bill returns and inflation over this time period. c. Calculate the real return for each year. What is the average real return for Treasury bills? d. Many people consider Treasury bills to be risk-free. What does this tell you about the potential risks of Treasury bills