Finance and Economics Discussion Series: Data for paper 2011-14
♣
The Expected Real Return to Equity
Missaka Warusawitharana
Figure 1: Aggregate earnings. Panel A: Annual data
Time |
Earnings to Assets |
1966 |
8.173 |
1967 |
7.4513 |
1968 |
6.812 |
1969 |
6.1704 |
1970 |
4.783 |
1971 |
4.9308 |
1972 |
5.3665 |
1973 |
6.952 |
1974 |
6.8422 |
1975 |
5.0776 |
1976 |
6.1566 |
1977 |
6.4069 |
1978 |
6.703 |
1979 |
7.6303 |
1980 |
6.4929 |
1981 |
5.7934 |
1982 |
4.2063 |
1983 |
4.8013 |
1984 |
5.1028 |
1985 |
4.913 |
1986 |
3.725 |
1987 |
4.8244 |
1988 |
5.6401 |
1989 |
4.6121 |
1990 |
4.0109 |
1991 |
2.8626 |
1992 |
2.9801 |
1993 |
3.3489 |
1994 |
4.2018 |
1995 |
4.5911 |
1996 |
5.0174 |
1997 |
4.8747 |
1998 |
4.091 |
1999 |
4.188 |
2000 |
3.6973 |
2001 |
0.9142 |
2002 |
1.923 |
2003 |
4.1383 |
2004 |
5.2268 |
2005 |
5.6573 |
2006 |
6.7008 |
2007 |
6.315 |
2008 |
4.7434 |
2009 |
4.3254 |
Figure 1: Aggregate earnings. Panel B: Quarterly data
Time |
Earnings to assets (annualized) |
1984:Q1 |
4.8417 |
1984:Q2 |
6.0614 |
1984:Q3 |
4.933 |
1984:Q4 |
4.5965 |
1985:Q1 |
3.9855 |
1985:Q2 |
4.6916 |
1985:Q3 |
3.9446 |
1985:Q4 |
4.0573 |
1986:Q1 |
3.2769 |
1986:Q2 |
4.0703 |
1986:Q3 |
3.482 |
1986:Q4 |
2.825 |
1987:Q1 |
4.026 |
1987:Q2 |
4.6537 |
1987:Q3 |
4.6266 |
1987:Q4 |
4.5543 |
1988:Q1 |
4.7247 |
1988:Q2 |
5.0962 |
1988:Q3 |
4.8016 |
1988:Q4 |
5.0142 |
1989:Q1 |
4.6382 |
1989:Q2 |
4.5668 |
1989:Q3 |
3.5772 |
1989:Q4 |
3.6749 |
1990:Q1 |
3.5797 |
1990:Q2 |
3.9538 |
1990:Q3 |
3.5646 |
1990:Q4 |
2.756 |
1991:Q1 |
2.4536 |
1991:Q2 |
2.6876 |
1991:Q3 |
2.56 |
1991:Q4 |
2.1961 |
1992:Q1 |
2.6509 |
1992:Q2 |
2.9659 |
1992:Q3 |
2.7365 |
1992:Q4 |
2.9743 |
1993:Q1 |
3.121 |
1993:Q2 |
3.2489 |
1993:Q3 |
3.2549 |
1993:Q4 |
3.5325 |
1994:Q1 |
3.5784 |
1994:Q2 |
4.1645 |
1994:Q3 |
4.0697 |
1994:Q4 |
4.692 |
1995:Q1 |
4.7195 |
1995:Q2 |
5.104 |
1995:Q3 |
4.6092 |
1995:Q4 |
4.7974 |
1996:Q1 |
4.8371 |
1996:Q2 |
5.117 |
1996:Q3 |
4.8772 |
1996:Q4 |
5.122 |
1997:Q1 |
4.6077 |
1997:Q2 |
5.0884 |
1997:Q3 |
4.569 |
1997:Q4 |
4.8409 |
1998:Q1 |
4.6721 |
1998:Q2 |
4.2374 |
1998:Q3 |
3.526 |
1998:Q4 |
3.1382 |
1999:Q1 |
3.9062 |
1999:Q2 |
4.254 |
1999:Q3 |
3.9854 |
1999:Q4 |
4.0131 |
2000:Q1 |
3.8818 |
2000:Q2 |
3.8062 |
2000:Q3 |
3.2774 |
2000:Q4 |
1.8412 |
2001:Q1 |
0.7751 |
2001:Q2 |
0.6441 |
2001:Q3 |
0.1804 |
2001:Q4 |
0.3006 |
2002:Q1 |
1.7554 |
2002:Q2 |
1.3889 |
2002:Q3 |
2.3794 |
2002:Q4 |
2.4815 |
2003:Q1 |
3.8253 |
2003:Q2 |
3.764 |
2003:Q3 |
3.9948 |
2003:Q4 |
4.5656 |
2004:Q1 |
4.8259 |
2004:Q2 |
5.1526 |
2004:Q3 |
5.2158 |
2004:Q4 |
5.4481 |
2005:Q1 |
5.0142 |
2005:Q2 |
5.9425 |
2005:Q3 |
5.5571 |
2005:Q4 |
5.798 |
2006:Q1 |
5.6926 |
2006:Q2 |
6.413 |
2006:Q3 |
6.0038 |
2006:Q4 |
5.8861 |
2007:Q1 |
5.918 |
2007:Q2 |
6.4708 |
2007:Q3 |
4.7226 |
2007:Q4 |
5.625 |
2008:Q1 |
5.7727 |
2008:Q2 |
6.1568 |
2008:Q3 |
5.647 |
2008:Q4 |
-0.4301 |
2009:Q1 |
1.2422 |
2009:Q2 |
4.0166 |
2009:Q3 |
4.4548 |
2009:Q4 |
5.1733 |
Figure 2: Time variation in expected returns. Panel A: Annual data
Time |
Expected return |
1966 |
0.4918 |
1967 |
2.1678 |
1968 |
3.7651 |
1969 |
5.4887 |
1970 |
9.8874 |
1971 |
9.3938 |
1972 |
7.9384 |
1973 |
3.4063 |
1974 |
3.6876 |
1975 |
8.9036 |
1976 |
5.5302 |
1977 |
4.8024 |
1978 |
4.044 |
1979 |
1.7523 |
1980 |
4.5823 |
1981 |
6.6258 |
1982 |
11.8506 |
1983 |
9.8261 |
1984 |
8.8192 |
1985 |
9.4531 |
1986 |
13.5099 |
1987 |
9.7489 |
1988 |
-3.6164 |
1989 |
1.9943 |
1990 |
5.6567 |
1991 |
12.6882 |
1992 |
12.2273 |
1993 |
10.0753 |
1994 |
4.4518 |
1995 |
2.1143 |
1996 |
-0.2205 |
1997 |
0.544 |
1998 |
5.152 |
1999 |
4.5394 |
2000 |
7.6457 |
2001 |
20.3327 |
2002 |
16.3746 |
2003 |
4.853 |
2004 |
-1.3262 |
2005 |
-3.7211 |
2006 |
-10.0749 |
2007 |
-7.726 |
2008 |
1.2483 |
2009 |
3.6713 |
Figure 2: Time variation in expected returns. Panel B: Quarterly data
Time |
Expected return |
1984:Q1 |
0.7276 |
1984:Q2 |
-4.2619 |
1984:Q3 |
0.4498 |
1984:Q4 |
1.5926 |
1985:Q1 |
4.296 |
1985:Q2 |
1.2552 |
1985:Q3 |
4.5015 |
1985:Q4 |
3.9351 |
1986:Q1 |
8.0529 |
1986:Q2 |
3.87 |
1986:Q3 |
7.201 |
1986:Q4 |
10.3152 |
1987:Q1 |
4.0924 |
1987:Q2 |
1.3897 |
1987:Q3 |
1.4859 |
1987:Q4 |
1.7421 |
1988:Q1 |
1.1378 |
1988:Q2 |
-0.0474 |
1988:Q3 |
0.8652 |
1988:Q4 |
0.2024 |
1989:Q1 |
1.4448 |
1989:Q2 |
1.6979 |
1989:Q3 |
6.6332 |
1989:Q4 |
6.0502 |
1990:Q1 |
6.6182 |
1990:Q2 |
4.4553 |
1990:Q3 |
6.7084 |
1990:Q4 |
10.9632 |
1991:Q1 |
13.7716 |
1991:Q2 |
11.6067 |
1991:Q3 |
12.8057 |
1991:Q4 |
14.6122 |
1992:Q1 |
11.951 |
1992:Q2 |
9.0896 |
1992:Q3 |
11.1466 |
1992:Q4 |
9.0618 |
1993:Q1 |
8.5726 |
1993:Q2 |
8.1461 |
1993:Q3 |
8.1262 |
1993:Q4 |
6.9 |
1994:Q1 |
6.6263 |
1994:Q2 |
3.3968 |
1994:Q3 |
3.8728 |
1994:Q4 |
1.2539 |
1995:Q1 |
1.1563 |
1995:Q2 |
-0.071 |
1995:Q3 |
1.5473 |
1995:Q4 |
0.8801 |
1996:Q1 |
0.7416 |
1996:Q2 |
-0.1108 |
1996:Q3 |
0.6197 |
1996:Q4 |
-0.126 |
1997:Q1 |
1.5529 |
1997:Q2 |
-0.0237 |
1997:Q3 |
1.6899 |
1997:Q4 |
0.7301 |
1998:Q1 |
1.3245 |
1998:Q2 |
3.0303 |
1998:Q3 |
6.9389 |
1998:Q4 |
8.5152 |
1999:Q1 |
4.694 |
1999:Q2 |
2.9471 |
1999:Q3 |
4.2962 |
1999:Q4 |
4.1571 |
2000:Q1 |
4.8166 |
2000:Q2 |
5.2673 |
2000:Q3 |
8.051 |
2000:Q4 |
15.7706 |
2001:Q1 |
19.2508 |
2001:Q2 |
19.6782 |
2001:Q3 |
21.1919 |
2001:Q4 |
20.7996 |
2002:Q1 |
16.051 |
2002:Q2 |
17.2472 |
2002:Q3 |
14.0141 |
2002:Q4 |
13.5431 |
2003:Q1 |
5.153 |
2003:Q2 |
5.5188 |
2003:Q3 |
4.2494 |
2003:Q4 |
1.7023 |
2004:Q1 |
0.779 |
2004:Q2 |
-0.2189 |
2004:Q3 |
-0.4115 |
2004:Q4 |
-1.2018 |
2005:Q1 |
0.2024 |
2005:Q2 |
-3.2489 |
2005:Q3 |
-1.6225 |
2005:Q4 |
-2.5525 |
2006:Q1 |
-2.1456 |
2006:Q2 |
-7.2568 |
2006:Q3 |
-3.7712 |
2006:Q4 |
-2.8925 |
2007:Q1 |
-3.0404 |
2007:Q2 |
-7.7495 |
2007:Q3 |
1.1453 |
2007:Q4 |
-1.8847 |
2008:Q1 |
-2.4546 |
2008:Q2 |
-5.0745 |
2008:Q3 |
-1.9693 |
2008:Q4 |
23.1846 |
2009:Q1 |
17.726 |
2009:Q2 |
4.1395 |
2009:Q3 |
2.0951 |
2009:Q4 |
-0.2821 |
Figure 3: Optimal portfolio allocation to equity
Risk Aversion Coefficient |
Historical Data |
Model implied - annual |
Model implied - quarterly |
2 |
0.9758 |
0.8049 |
0.6037 |
2.1 |
0.9299 |
0.7666 |
0.5748 |
2.2 |
0.888 |
0.7317 |
0.5484 |
2.3 |
0.8496 |
0.6999 |
0.5244 |
2.4 |
0.8144 |
0.6706 |
0.5024 |
2.5 |
0.7818 |
0.6438 |
0.4821 |
2.6 |
0.7519 |
0.6188 |
0.4635 |
2.7 |
0.7239 |
0.5958 |
0.4461 |
2.8 |
0.698 |
0.5743 |
0.4301 |
2.9 |
0.6739 |
0.5544 |
0.415 |
3 |
0.6514 |
0.5358 |
0.4011 |
3.1 |
0.6303 |
0.5184 |
0.3881 |
3.2 |
0.6104 |
0.5021 |
0.3758 |
3.3 |
0.5918 |
0.4867 |
0.3644 |
3.4 |
0.5743 |
0.4723 |
0.3535 |
3.5 |
0.5578 |
0.4587 |
0.3434 |
3.6 |
0.5422 |
0.4458 |
0.3337 |
3.7 |
0.5274 |
0.4337 |
0.3246 |
3.8 |
0.5135 |
0.4222 |
0.316 |
3.9 |
0.5002 |
0.4112 |
0.3078 |
4 |
0.4876 |
0.4009 |
0.3 |
4.1 |
0.4756 |
0.391 |
0.2927 |
4.2 |
0.4642 |
0.3816 |
0.2856 |
4.3 |
0.4532 |
0.3727 |
0.2789 |
4.4 |
0.4429 |
0.3641 |
0.2726 |
4.5 |
0.4329 |
0.356 |
0.2664 |
4.6 |
0.4234 |
0.3481 |
0.2605 |
4.7 |
0.4144 |
0.3406 |
0.255 |
4.8 |
0.4057 |
0.3335 |
0.2496 |
4.9 |
0.3973 |
0.3267 |
0.2445 |
5 |
0.3893 |
0.32 |
0.2396 |
5.1 |
0.3815 |
0.3137 |
0.2349 |
5.2 |
0.3742 |
0.3076 |
0.2303 |
5.3 |
0.3671 |
0.3018 |
0.2259 |
5.4 |
0.3602 |
0.2961 |
0.2217 |
5.5 |
0.3536 |
0.2907 |
0.2177 |
5.6 |
0.3473 |
0.2854 |
0.2137 |
5.7 |
0.3411 |
0.2804 |
0.21 |
5.8 |
0.3352 |
0.2755 |
0.2062 |
5.9 |
0.3294 |
0.2708 |
0.2027 |
6 |
0.3238 |
0.2663 |
0.1994 |
6.1 |
0.3186 |
0.2619 |
0.1961 |
6.2 |
0.3134 |
0.2576 |
0.1929 |
6.3 |
0.3083 |
0.2535 |
0.1898 |
6.4 |
0.3034 |
0.2495 |
0.1868 |
6.5 |
0.2987 |
0.2456 |
0.1839 |
6.6 |
0.2941 |
0.2419 |
0.1812 |
6.7 |
0.2897 |
0.2383 |
0.1784 |
6.8 |
0.2854 |
0.2347 |
0.1758 |
6.9 |
0.2812 |
0.2312 |
0.1732 |
7 |
0.2772 |
0.2279 |
0.1707 |
7.1 |
0.2733 |
0.2247 |
0.1683 |
7.2 |
0.2694 |
0.2216 |
0.1659 |
7.3 |
0.2657 |
0.2186 |
0.1637 |
7.4 |
0.2621 |
0.2155 |
0.1614 |
7.50000000000001 |
0.2586 |
0.2126 |
0.1593 |
7.6 |
0.2552 |
0.2099 |
0.1571 |
7.7 |
0.2519 |
0.2071 |
0.1551 |
7.80000000000001 |
0.2485 |
0.2044 |
0.1531 |
7.90000000000001 |
0.2454 |
0.2018 |
0.1512 |
8.00000000000001 |
0.2423 |
0.1992 |
0.1492 |
8.1 |
0.2393 |
0.1968 |
0.1474 |
8.20000000000001 |
0.2363 |
0.1943 |
0.1456 |
8.30000000000001 |
0.2335 |
0.192 |
0.1438 |
8.40000000000001 |
0.2307 |
0.1897 |
0.1421 |
8.50000000000001 |
0.2279 |
0.1875 |
0.1404 |
8.60000000000001 |
0.2253 |
0.1853 |
0.1388 |
8.70000000000001 |
0.2227 |
0.1831 |
0.1372 |
8.80000000000001 |
0.2201 |
0.1811 |
0.1356 |
8.90000000000001 |
0.2177 |
0.179 |
0.1341 |
9.00000000000001 |
0.2152 |
0.177 |
0.1326 |
9.10000000000001 |
0.2128 |
0.175 |
0.1312 |
9.20000000000001 |
0.2104 |
0.1731 |
0.1297 |
9.30000000000001 |
0.2082 |
0.1712 |
0.1283 |
9.40000000000001 |
0.206 |
0.1694 |
0.127 |
9.50000000000001 |
0.2038 |
0.1676 |
0.1256 |
9.60000000000001 |
0.2017 |
0.1658 |
0.1242 |
9.70000000000001 |
0.1996 |
0.1642 |
0.1229 |
9.80000000000001 |
0.1976 |
0.1624 |
0.1217 |
9.90000000000001 |
0.1955 |
0.1608 |
0.1205 |
10 |
0.1936 |
0.1592 |
0.1192 |