In: Finance
Suppose you are given the following end of year returns for Large stocks, Long-term Bonds, Treasury Bills, and Inflation. Calculate the average real rate of return earned on Large stocks. (Enter percentages as decimals and round to 4 decimals).
Year | Large Stocks | Long-term Bonds | T-bills | Inflation |
1977 | -7.16% | 2.31% | 5.45% | 6.70% |
1978 | 6.57% | -2.07% | 7.64% | 9.02% |
1979 | 18.61% | -2.76% | 10.56% | 13.29% |
1980 | 32.50% | -5.91% | 12.10% | 12.52% |
1981 | -4.92% | -16.00% | 14.60% | 8.92% |
1982 | 21.55% | 49.99% | 10.94% | 3.83% |
1983 | 22.56% | -2.11% | 8.99% | 3.79% |
1984 | 6.27% | 16.53% | 9.90% | 3.95% |
The following are the data inputs in spreadsheet:
The following are the obtained results in spreadsheet:
The percentages entered as decimals and rounded up to 4 decimals