Data
| Date | Home Price Index | Stocks | T.Bonds | REITs | CPI Index | index | stocks | t.bonds | reits | | index c | stocks c | t.bond c | reits c |
| 1974 | n.a. | -25.90% | 1.99% | n.a. | n.a. | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! |
| 1975 | 5.44% | 37.00% | 3.61% | 36.34% | 7.13% | -0.2266459652 | 0.2788309353 | -0.0328491007 | 0.2726911091 | | 0.7733540348 | 1.2788309353 | 0.9671508993 | 1.2726911091 |
| 1976 | 8.74% | 23.83% | 15.98% | 48.98% | 5.04% | -0.2701163896 | 0.1789294521 | 0.1041931507 | 0.4183734435 | | 0.7298836104 | 1.1789294521 | 1.1041931507 | 1.4183734435 |
| 1977 | 14.83% | -6.98% | 1.29% | 19.07% | 6.68% | -0.0356602635 | -0.1280308186 | -0.0505078652 | 0.1161729328 | | 0.9643397365 | 0.8719691814 | 0.9494921348 | 1.1161729328 |
| 1978 | 16.17% | 6.51% | -0.78% | -1.64% | 8.99% | 0.1811186777 | -0.022743299 | -0.0896309278 | -0.0975675136 | | 1.1811186777 | 0.977256701 | 0.9103690722 | 0.9024324864 |
| 1979 | 12.80% | 18.52% | 0.67% | 30.53% | 13.25% | -0.1358021546 | 0.046489987 | -0.1111192458 | 0.1525149119 | | 0.8641978454 | 1.046489987 | 0.8888807542 | 1.1525149119 |
| 1980 | 7.18% | 31.74% | -2.99% | 28.02% | 12.35% | -0.1627967265 | 0.1725469907 | -0.136566088 | 0.1394750875 | | 0.8372032735 | 1.1725469907 | 0.863433912 | 1.1394750875 |
| 1981 | 4.83% | -4.70% | 8.20% | 8.58% | 8.91% | -0.0344896912 | -0.1249819341 | -0.0065377258 | -0.0030737307 | | 0.9655103088 | 0.8750180659 | 0.9934622742 | 0.9969262693 |
| 1982 | 0.88% | 20.42% | 32.81% | 31.64% | 3.83% | -0.2336510231 | 0.1598282497 | 0.2791628454 | 0.2678787248 | | 0.7663489769 | 1.1598282497 | 1.2791628454 | 1.2678787248 |
| 1983 | 4.65% | 22.34% | 3.20% | 25.47% | 3.79% | -0.1659470592 | 0.1787591716 | -0.0056568047 | 0.2089409512 | | 0.8340529408 | 1.1787591716 | 0.9943431953 | 1.2089409512 |
| 1984 | 4.74% | 6.15% | 13.73% | 14.81% | 4.04% | -0.0877795362 | 0.0202473934 | 0.0931016114 | 0.1035142874 | | 0.9122204638 | 1.0202473934 | 1.0931016114 | 1.1035142874 |
| 1985 | 7.76% | 31.24% | 25.71% | 5.92% | 3.79% | 0.0174125577 | 0.2644584475 | 0.2111785388 | 0.020500511 | | 1.0174125577 | 1.2644584475 | 1.2111785388 | 1.020500511 |
| 1986 | 9.61% | 18.49% | 24.28% | 19.18% | 1.19% | -0.0802743676 | 0.1709977437 | 0.2282184116 | 0.1778008401 | | 0.9197256324 | 1.1709977437 | 1.2282184116 | 1.1778008401 |
| 1987 | 7.61% | 5.81% | -4.96% | -10.67% | 4.33% | 0.2046123078 | 0.0141650519 | -0.0890629758 | -0.1437934285 | | 1.2046123078 | 1.0141650519 | 0.9109370242 | 0.8562065715 |
| 1988 | 7.33% | 16.54% | 8.22% | 11.36% | 4.41% | -0.0361331002 | 0.1161577465 | 0.0364732394 | 0.0665081592 | | 0.9638668998 | 1.1161577465 | 1.0364732394 | 1.0665081592 |
| 1989 | 3.94% | 31.48% | 17.69% | -1.81% | 4.64% | 0.0585752611 | 0.2565032462 | 0.1247175772 | -0.0616624587 | | 1.0585752611 | 1.2565032462 | 1.1247175772 | 0.9383375413 |
| 1990 | -1.31% | -3.06% | 6.24% | -17.34% | 6.25% | 0.194038617 | -0.0876660209 | -0.0001406855 | -0.2221063374 | | 1.194038617 | 0.9123339791 | 0.9998593145 | 0.7778936626 |
| 1991 | 0.23% | 30.23% | 15.00% | 35.68% | 2.98% | -0.2613070153 | 0.2646068017 | 0.1167149059 | 0.3175190184 | | 0.7386929847 | 1.2646068017 | 1.1167149059 | 1.3175190184 |
| 1992 | 0.92% | 7.49% | 9.36% | 12.17% | 2.97% | -0.1002840529 | 0.0439295854 | 0.0620907941 | 0.0894196484 | | 0.8997159471 | 1.0439295854 | 1.0620907941 | 1.0894196484 |
| 1993 | 2.37% | 9.97% | 14.21% | 18.55% | 2.81% | -0.1364747919 | 0.0696330144 | 0.1108737526 | 0.1530668358 | | 0.8635252081 | 1.0696330144 | 1.1108737526 | 1.1530668358 |
| 1994 | 2.35% | 1.33% | -8.04% | 0.81% | 2.60% | 0.0153438491 | -0.0123531646 | -0.1036810127 | -0.0174615789 | | 1.0153438491 | 0.9876468354 | 0.8963189873 | 0.9825384211 |
| 1995 | 1.76% | 37.20% | 23.48% | 18.31% | 2.53% | -0.1398627714 | 0.3381234568 | 0.2043111111 | 0.1538713671 | | 0.8601372286 | 1.3381234568 | 1.2043111111 | 1.1538713671 |
| 1996 | 2.58% | 23.82% | 1.43% | 35.75% | 3.38% | -0.2443847419 | 0.1977308611 | -0.0188512256 | 0.3131724014 | | 0.7556152581 | 1.1977308611 | 0.9811487744 | 1.3131724014 |
| 1997 | 4.36% | 31.86% | 9.94% | 18.86% | 1.70% | -0.1220283623 | 0.2965961681 | 0.0810540173 | 0.168770468 | | 0.8779716377 | 1.2965961681 | 1.0810540173 | 1.168770468 |
| 1998 | 6.36% | 28.34% | 14.92% | -18.82% | 1.61% | 0.3102784426 | 0.2631029197 | 0.1310253041 | -0.2010666661 | | 1.3102784426 | 1.2631029197 | 1.1310253041 | 0.7989333339 |
| 1999 | 7.82% | 20.89% | -8.25% | -6.48% | 2.68% | 0.1528160707 | 0.1773883886 | -0.1064158768 | -0.0891320303 | | 1.1528160707 | 1.1773883886 | 0.8935841232 | 0.9108679697 |
| 2000 | 9.22% | -9.03% | 16.66% | 25.89% | 3.44% | -0.1324182033 | -0.1205191294 | 0.1278469645 | 0.2170822926 | | 0.8675817967 | 0.8794808706 | 1.1278469645 | 1.2170822926 |
| 2001 | 6.61% | -11.85% | 5.57% | 15.50% | 1.60% | -0.0769790143 | -0.1324131905 | 0.0390373168 | 0.136786934 | | 0.9230209857 | 0.8675868095 | 1.0390373168 | 1.136786934 |
| 2002 | 9.63% | -21.97% | 15.12% | 5.22% | 2.48% | 0.0419265288 | -0.2385851485 | 0.1233381738 | 0.0266945652 | | 1.0419265288 | 0.7614148515 | 1.1233381738 | 1.0266945652 |
| 2003 | 10.23% | 28.36% | 0.38% | 38.47% | 2.04% | -0.2039120875 | 0.2579971968 | -0.0162218868 | 0.3570413434 | | 0.7960879125 | 1.2579971968 | 0.9837781132 | 1.3570413434 |
| 2004 | 13.81% | 10.74% | 4.49% | 30.41% | 3.34% | -0.1272968436 | 0.0715842462 | 0.0111056338 | 0.2619150371 | | 0.8727031564 | 1.0715842462 | 1.0111056338 | 1.2619150371 |
| 2005 | 12.92% | 4.83% | 2.87% | 8.29% | 3.34% | 0.0427723945 | 0.0144326603 | -0.0045341242 | 0.0478974173 | | 1.0427723945 | 1.0144326603 | 0.9954658758 | 1.0478974173 |
| 2006 | 1.06% | 15.61% | 1.96% | 34.35% | 2.52% | -0.2478221532 | 0.1276386509 | -0.0055009355 | 0.3104400331 | | 0.7521778468 | 1.1276386509 | 0.9944990645 | 1.3104400331 |
| 2007 | -6.36% | 5.48% | 10.21% | -17.83% | 4.11% | 0.1395549842 | 0.0131707063 | 0.0586039396 | -0.2107420062 | | 1.1395549842 | 1.0131707063 | 1.0586039396 | 0.7892579938 |
| 2008 | -12.69% | -36.55% | 20.10% | -37.34% | -0.02% | 0.3933341142 | -0.365358932 | 0.2012670177 | -0.3732180496 | | 1.3933341142 | 0.634641068 | 1.2012670177 | 0.6267819504 |
| 2009 | -2.95% | 25.94% | -11.12% | 27.45% | 2.81% | -0.2384709522 | 0.22492899 | -0.1355273254 | 0.23959026 | | 0.7615290478 | 1.22492899 | 0.8644726746 | 1.23959026 |
| 2010 | -4.11% | 14.82% | 8.46% | 27.58% | 1.44% | -0.2483969174 | 0.1319252576 | 0.0692267326 | 0.2577183942 | | 0.7516030826 | 1.1319252576 | 1.0692267326 | 1.2577183942 |
| 2011 | -3.49% | 2.07% | 16.04% | 7.28% | 3.03% | -0.100353626 | -0.0092858289 | 0.126310105 | 0.0412591249 | | 0.899646374 | 0.9907141711 | 1.126310105 | 1.0412591249 |
| 2012 | 7.59% | 15.83% | 2.97% | 20.14% | 1.77% | -0.1044653602 | 0.1381569593 | 0.0117933359 | 0.1805532937 | | 0.8955346398 | 1.1381569593 | 1.0117933359 | 1.1805532937 |
| 2013 | 10.48% | 32.15% | -9.10% | 3.21% | 1.53% | 0.0704471634 | 0.301612494 | -0.1046797147 | 0.0165533669 | | 1.0704471634 | 1.301612494 | 0.8953202853 | 1.0165533669 |
| 2014 | 4.38% | 13.48% | 10.75% | 27.15% | 0.68% | -0.1790459871 | 0.1271781229 | 0.1000614832 | 0.2629341787 | | 0.8209540129 | 1.1271781229 | 1.1000614832 | 1.2629341787 |
| | 0.05 | | | | | ERROR:#VALUE! | | | | | ERROR:#VALUE! |
index c 0.0 0.773354034821267 0.729883610424927 0.964339736513844 1.181118677680032 0.864197845352497 0.837203273534176 0.965510308767434 0.76634897689473 0.834052940753218 0.912220463841723 1.017412557652242 0.919725632392565 1.204612307830731 0.963866899842951 1.058575261132304 1.19403861695825 0.738692984735444 0.899715947087992 0.863525208050758 1.0153438491 21528 0.860137228614363 0.755615258129429 0.877971637664924 1.310278442608193 1.152816070723198 0.867581796684827 0.923020985677213 1.041926528824923 0.796087912534728 0.872703156372811 1.042772394532273 0.752177846750451 1.139554984178113 1.393334114158086 0.761529047788446 0.751603082551598 0.899646374005069 0.895534639839215 1.070447163397233 0.820954012918668 stocks c 0.0 1.278830935251799 1.178929452054795 0.871969181380417 0.977256701030928 1.046489986996099 1.172546990740741 0.875018065887354 1.159828249744115 1.178759171597633 1.020247393364929 1.264458447488584 1.17099774368231 1.014165051903114 1.116157746478873 1.256503246239113 0.912333979135619 1.264606801736613 1.043929585382993 1.069633014354067 0.987646835443038 1.338123456790123 1.197730861093652 1.296596168108776 1.263102919708029 1.177388388625592 0.879480870561283 0.867586809470124 0.761414851485148 1.257997196765499 1.071584246218049 1.01443266027259 1.127638650910881 1.013170706330251 0.63464106803281 1.224928990048172 1.131925257629087 0.990714171124172 1.138156959314775 1.301612493981602 1.127178122936805 t.bond c 0.0 0.967150899280576 1.104193150684932 0.949492134831461 0.910369072164948 0.888880754226268 0.863433912037037 0.993462274176408 1.279162845445241 0.994343195266272 1.093101611374408 1.211178538812785 1.228218411552346 0.910937024221453 1.03647323943662 1.12471757719715 0.999859314456036 1.11671490593343 1.062090794096978 1.110873752563226 0.896318987341772 1.204311111111111 0.981148774355751 1.081054017305315 1.131025304136253 0.893584123222749 1.127846964490264 1.039037316798196 1.123338173817382 0.983778113207547 1.011105633802817 0.995465875820293 0.994499064500246 1.058603939558751 1.201267017663365 0.864472674571078 1.069226732646322 1.12631010499901 1.011793335928882 0.89532028530403 1.100061483215114 reits c 0.0 1.27269110914477 1.418373443484017 1.11617293282903 0.902432486398809 1.152514911923447 1.139475087515181 0.996926269349201 1.267878724794569 1.208940951221711 1.103514287404468 1.020500511036052 1.177800840131791 0.856206571450246 1.066508159247729 0.938337541313353 0.777893662578209 1.317519018449989 1.089419648400137 1.153066835774211 0.98253842114079 1.153871367090212 1.313172401405584 1.168770467956671 0.798933333865258 0.910867969663313 1.217082292630312 1.136786933971097 1.026694565218071 1.357041343411269 1.261915037133153 1.047897417265978 1.310440033109177 0.789257993784462 0.626781950375238 1.239590260022725 1.257718394220567 1.041259124887828 1.180553293676824 1.016553366890078 1.262934178702961
tea521
assignment_2_data.xlsx
