Hello, I need help with questions 1-5 on this homework assignment that I attached onto this file. I need to know how you received the answers, so if you could explain which cells you used that would be great!

Finance 320 Fall 2017 (100 points) Professor Sapp Allocation Project Due: Nov. 9, 2017 Asset Allocation: Riverdale College Objective: To engage you in a "real life" asset allocation exercise. The project will require you to apply fundamental concepts of modern portfolio theory to come up with an efficient portfolio allocation to meet certain objectives. In short, the project will require you to implement what you have learned in this course. Teri Riley is a consultant to several college investment offices around the country. She is a specialist in asset allocation studies. She has accumulated performance figures from a number of different college endowments, as well as information about the typical stocks/bonds/cash mixtures common in the endowment universe. She practices a broad policy approach, which means that she makes recommendations about allocations across asset classes, rather than about which managers to choose, or which stocks to pick. Riverdale College is a small mid-western, liberal arts college with a $50 million endowment as of Dec. 31, 2016. It has had a fixed investment policy of 40% domestic stocks (spread equally between small and large cap portfolios labeled SMLSTK and LRGSTK, respectively), 20% international stocks (EAFE), 15% investment-grade corporate bonds (CBOND), 15% U.S. government bonds (GBOND), and 10% T-bills. This portfolio has been held from 1997 through 2016. The monthly returns on these asset classes are contained in the Excel spreadsheet titled \"dataset2.xls\" (available on the course web site). The portfolio manager hired by the college to manage its endowment fund is a successful alumnus. Most of Riverdale's assets are liquid. Enrollment at Riverdale has decreased steadily since its peak of 2200 students in 1999 to a low of 1500 in 2016. Thus far, increased spending from endowment has offset the shortfall in revenue caused by declining tuition revenues. Since 1997, the annual average spending from endowment has been 4% (of the total value of the endowment fund) annually. In 2015 and 2016, the college had to spend 6% and 7%, respectively, and anticipates additional spending of $5 million for the year 2017. Contributions to the endowment have continued steadily at 2% per year. However, the poor record of the college's football team in recent years is a matter of concern since it directly affects contributions by alumni (in the mid-seventies the college won three consecutive Division III national championships). Since the role of the endowment in meeting budget needs has increased dramatically in the past few years, the college has decided to review its past performance and future contributions to the institution. Howard Weaver is the chairman of the endowment committee for the board of trustees of Riverdale. He found out about Ms. Riley from a friend of his who serves on the board of Rotter Dame University. Rotter Dame employed Riley in 2016 to review its investment policy and to recommend an optimal portfolio mix. Riley presented an asset mix for the Rotter Dame endowment that changed their exposure to stocks from 70% to 40% and increased their exposure to bonds and alternative assets to 50%. Should Riverdale consider a change in its long-standing investment policy? How has the endowment and its money managers performed over the period since 1997? Weaver decided to have Teri and her firm look into these issues. Weaver was also concerned with how risks should be defined in the context of Riverdale's investments. He anticipated the need to continue relying on the endowment fund in the coming years. He felt strongly that a return of 0.01 (or 1 %) per month represented a target portfolio return that the college should seek to achieve. He wanted Riley to suggest an efficient asset allocation to achieve this goal. Lastly, Weaver wanted to know whether the board should be concerned about whether the endowment is adequate for the school's future needs. Can any improvements be suggested that would help the college to meet its needs going forward? Based upon her consultations with Weaver, Riley has drawn up a list of issues that need to be addressed. She has decided to hire your group for this task. You are required to prepare a preliminary report, which will address the following questions/tasks. 1. How did the Riverdale portfolio perform over the 1997-2016 period? Report the portfolio mean, standard deviation, and Sharpe ratio. 2. Plot the portfolio frontier given the five risky assets the college is investing in (you may use the Solver module in Excel for this purpose). 3. Find the mean and standard deviation of the portfolio of risky assets (consisting of investments in three stock portfolios and two bond portfolios) currently chosen by the college's fund manager. Plot it. Is this an efficient portfolio? If not, calculate the investment proportions in the five assets required to construct an efficient risky portfolio, which would deliver the same expected return as the current choice of risky portfolio. 4. Calculate the investment proportions required to achieve the optimal (tangency) risky portfolio (you may use the Solver module in Excel for this purpose). What is the expected return and standard deviation of such a portfolio? Also, be sure to report the weights and the Sharpe ratio of the tangency portfolio. How does the Sharpe ratio compare to that of Riverdale's current risky portfolio? 5. Calculate the investment proportions required to construct a complete portfolio (i.e. one which mixes the optimal risky portfolio with T-bills) that has an expected return equal to the present (complete) portfolio's expected return. What is the expected standard deviation of return on such a portfolio? How does this compare with the standard deviation of Riverdale's current complete portfolio? 6. Suggest a complete portfolio allocation between the optimal risky portfolio and T-bills to achieve the college's objective of a rate of return equal to 0.01 (1%) per month. What is the expected standard deviation of the portfolio? 7. Weaver is also interested in knowing if the college should include some alternative asset classes specifically, real estate, commodities, private equity, hedge funds, and high-yield bonds in its portfolio. Make a case for or against the inclusion of five alternative assets (labeled REITs, OIL, PE, HFMACRO, and HYBOND) in the college's overall portfolio. Justify your decision by depicting the portfolio frontier that includes the five alternative assets. Plot it on the same graph you constructed for number (2). 8a. Find the optimal (tangency) portfolio consisting of all ten asset classes. 8b. Calculate the complete portfolio allocation between the optimal risky portfolio and T-bills required to achieve the target rate of return mandated by the college using this expanded universe of assets. What is the expected standard deviation of such a portfolio? 9. Find the 5-asset tangency portfolio, assuming no short sales of risky assets are allowed. Also, find the 10-asset tangency portfolio, assuming no short sales are allowed. Compare these results to the tangency portfolios when short sales are allowed. What happens to the Sharpe ratio? Which assets drop out and which assets dominate? 10. Present a forceful argument for using your services, summarizing what you have shown. Also, make a few succinct points that might help sway a board member skeptical of asset allocation methods (the member believes that individual stock selection is more important than asset allocation). Year 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2001 2001 2001 Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 REIT 0.01114 0.00086 -0.00925 -0.02279 0.03200 0.04800 0.02993 -0.00200 0.07988 -0.02548 0.01695 0.01969 -0.00468 -0.01697 0.01649 -0.03215 -0.00848 -0.00623 -0.06556 -0.10347 0.06347 -0.02723 0.01820 -0.03012 -0.01988 -0.02685 -0.00502 0.09710 0.02200 -0.01376 -0.03670 -0.02183 -0.03722 -0.02580 -0.02102 0.03002 0.00340 -0.01305 0.03242 0.06586 0.01047 0.02653 0.08498 -0.03966 0.03216 -0.04288 0.01191 0.06923 0.01456 -0.01296 0.00911 0.02630 0.02533 OIL 0.03965 -0.04820 0.03497 -0.00561 0.06455 0.02998 0.06454 -0.01358 0.06442 -0.03368 -0.01505 -0.01970 -0.04778 0.06428 0.03675 0.02287 -0.02867 -0.01379 -0.07572 -0.09629 0.12830 -0.01309 0.01901 -0.02289 -0.08823 -0.02534 0.17049 0.14312 -0.01881 0.00582 0.01249 0.01346 -0.02728 -0.00771 0.01623 -0.01689 -0.07000 -0.08014 0.16660 -0.02604 0.10032 -0.06064 -0.04900 0.08252 0.01236 -0.01483 -0.02654 0.06167 -0.01542 -0.00491 0.00771 0.10456 0.00233 PE 0.03864 -0.00851 -0.01982 0.03231 0.03944 0.03334 0.05261 -0.01790 0.04163 -0.01365 0.08547 0.01761 0.00947 0.04691 0.03763 0.01338 0.01029 0.02646 -0.00707 -0.10030 0.04530 0.05145 -0.02190 0.04481 0.02980 -0.00143 0.02964 0.03618 0.02576 0.03738 -0.01156 0.05790 -0.00687 0.04417 0.07185 0.05665 -0.01742 0.12216 0.04062 -0.02840 -0.01878 0.03728 -0.00365 0.02670 -0.02400 -0.00775 -0.07776 0.01902 0.03055 -0.05402 -0.03537 0.05717 -0.02364 HFMACRO HYBOND SMLSTK 0.05140 0.01590 -0.01240 -0.00220 0.01830 0.01820 0.05900 -0.01250 0.03050 -0.01600 -0.00250 0.02930 0.00200 0.01900 0.05050 -0.00130 0.00080 0.00570 0.00230 -0.03700 -0.00500 -0.01830 0.01980 0.02440 0.00810 -0.01240 0.01070 0.03860 -0.00900 0.02160 0.00460 -0.00550 0.01080 -0.00750 0.03830 0.06820 0.01140 0.03670 -0.02270 -0.03680 -0.01540 0.01240 0.00050 0.01730 -0.02190 -0.00730 0.00250 0.04610 0.02150 -0.01710 0.00830 -0.00120 -0.00100 0.00976 0.01654 -0.01489 0.01055 0.02139 0.01388 0.02746 -0.00228 0.01981 0.00090 0.00955 0.00877 0.01801 0.00585 0.00939 0.00394 0.00347 0.00360 0.00569 -0.05518 0.00452 -0.02050 0.04150 0.00110 0.01484 -0.00589 0.00954 0.01938 -0.01354 -0.00213 0.00403 -0.01105 -0.00720 -0.00664 0.01176 0.01125 -0.00431 0.00193 -0.02102 0.00160 -0.01025 0.02036 0.00763 0.00684 -0.00874 -0.03203 -0.03960 0.01930 0.07492 0.01332 -0.02355 -0.01245 0.01801 0.06480 -0.01440 -0.04610 -0.03010 0.07960 0.05170 0.04790 0.04230 0.10130 -0.02060 -0.02740 -0.03530 -0.00460 0.05230 0.05120 0.02830 -0.04260 -0.03120 -0.06260 -0.20850 0.01110 0.01090 0.07890 0.00640 0.07260 -0.05250 -0.03660 0.08130 0.03180 0.03850 0.02250 -0.02930 -0.02440 -0.00560 0.12180 0.12860 0.10670 0.29600 -0.10440 -0.18190 -0.10410 0.18520 -0.01890 0.03820 -0.03300 -0.07310 -0.09180 -0.02390 0.17750 -0.03240 -0.01130 0.02900 0.08910 EAFE -0.03477 0.01660 0.00387 0.00555 0.06532 0.05537 0.01638 -0.07448 0.05624 -0.07665 -0.00996 0.00895 0.04597 0.06440 0.03102 0.00814 -0.00463 0.00779 0.01036 -0.12367 -0.03040 0.10452 0.05148 0.03969 -0.00273 -0.02360 0.04198 0.04075 -0.05128 0.03922 0.02995 0.00388 0.01029 0.03767 0.03495 0.08995 -0.06336 0.02711 0.03896 -0.05244 -0.02423 0.03934 -0.04173 0.00888 -0.04849 -0.02342 -0.03729 0.03578 -0.00047 -0.07490 -0.06621 0.07014 -0.03450 LRGSTK 0.06820 0.00720 -0.04450 0.06690 0.05930 0.04770 0.08160 -0.06330 0.05360 -0.02900 0.05120 0.01710 0.01980 0.07130 0.05330 0.01630 -0.01590 0.05130 0.00010 -0.14430 0.06680 0.08070 0.06740 0.06820 0.04930 -0.03400 0.03940 0.02980 -0.02630 0.05420 -0.03330 -0.00210 -0.02600 0.07040 0.02540 0.06000 -0.04690 -0.02610 0.10640 -0.03400 -0.02560 0.02700 -0.01810 0.07310 -0.05540 -0.01590 -0.09810 -0.00200 0.03280 -0.10630 -0.07360 0.08010 0.00230 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 0.05846 -0.01730 0.03387 -0.04008 -0.02694 0.05353 0.02640 0.00381 0.01810 0.05987 0.01313 0.01445 0.02738 -0.05049 -0.00024 -0.03952 -0.04569 0.04530 0.01144 -0.02789 0.01620 0.02067 0.04770 0.06121 0.02601 0.05235 0.00430 0.03148 0.02154 0.04517 0.03429 0.04302 0.02193 0.05598 -0.15264 0.07062 0.02993 0.00042 0.07882 0.00194 0.04546 0.04637 0.04824 -0.07912 0.02254 -0.01860 0.04679 0.03576 0.04700 0.06567 -0.04246 -0.00101 -0.02734 0.04338 -0.06365 -0.00104 0.00104 -0.09236 0.01969 -0.03380 0.05947 -0.02267 0.03518 0.07563 -0.04289 0.00799 0.00462 -0.11921 0.01557 -0.09379 -0.03264 0.01576 0.02287 -0.04442 -0.00265 0.00965 0.00184 0.09409 0.00501 -0.02398 0.03853 0.00012 0.02108 0.00973 0.13647 0.00121 0.05349 0.00074 0.01803 0.00023 0.05416 0.02231 -0.01877 0.09272 -0.00445 0.06932 -0.03056 0.03382 0.15544 -0.01030 -0.04205 0.01193 0.07550 0.06081 0.07896 0.05801 -0.08426 -0.00891 -0.00367 -0.00418 -0.04201 -0.04809 0.02361 -0.03796 0.01751 -0.00283 -0.03222 0.03364 -0.02298 0.03140 -0.03533 -0.04186 0.04651 -0.05316 0.05179 -0.02177 -0.02517 -0.00724 -0.01062 0.01302 0.05650 -0.00593 0.01662 0.02070 0.03103 0.00136 0.04302 0.01295 0.03414 0.02066 0.01011 0.00041 -0.00770 0.02401 0.01976 -0.01579 0.01918 0.01915 0.01750 0.10152 0.02793 -0.00914 0.03213 -0.00332 -0.00830 0.08077 0.01372 0.03280 0.02837 0.01318 -0.00566 0.07336 0.00430 -0.00300 0.00570 0.00630 0.02710 0.00140 0.01510 0.00411 -0.01208 0.02112 0.00390 0.01874 0.01202 -0.00339 0.00629 0.00932 -0.01645 -0.00463 0.03414 0.02520 0.01910 -0.02231 0.01227 0.05665 0.00531 0.00726 0.01856 0.02258 0.01729 0.00193 0.03382 0.00646 0.01999 0.01123 -0.02840 -0.00695 -0.00110 -0.00329 -0.00233 0.00835 0.00838 0.02805 0.00606 -0.00576 0.01806 -0.00601 -0.01061 0.00345 0.01055 0.00741 0.00725 0.02108 -0.00634 0.01462 -0.02805 0.01472 0.01180 -0.06721 0.02474 0.03647 -0.00408 0.00696 -0.01395 0.02406 0.01559 -0.00517 -0.07372 -0.04369 0.02851 -0.01313 -0.00872 0.06194 0.01398 0.03329 0.01234 0.02876 0.05934 0.01032 0.02877 -0.01100 0.01150 0.02734 0.02019 0.01517 0.02264 0.01909 -0.00252 0.00680 -0.00681 -0.01694 0.01433 0.01360 0.01962 0.01451 0.01806 0.01206 0.01491 -0.00130 0.01471 -0.02907 -0.00975 0.01775 0.01963 0.01748 0.00191 -0.00998 -0.00698 0.00522 0.02040 -0.00820 -0.03190 -0.11160 0.06850 0.05750 0.06680 0.04400 -0.03880 0.07900 0.01980 0.01820 -0.04180 -0.11460 -0.00640 -0.08070 0.03400 0.11500 -0.03920 0.02050 -0.01190 0.01800 0.09480 0.14250 0.05620 0.09200 0.05220 0.04460 0.09460 0.04970 0.02730 0.08380 0.00260 -0.00410 -0.03990 -0.00290 0.01770 -0.07020 -0.01400 0.03860 0.01390 0.08160 0.06410 -0.03500 0.00930 -0.04170 -0.05840 0.04330 0.04030 0.07900 -0.01000 0.01180 -0.03500 0.03230 -0.04052 -0.01812 -0.02512 -0.10106 0.02557 0.03693 0.00596 -0.05762 0.01198 0.05575 0.01534 0.00523 -0.03295 -0.09534 -0.00958 -0.10374 0.03833 0.05627 -0.03359 -0.04284 -0.02128 -0.02324 0.10169 0.06444 0.01963 0.01508 0.03288 0.03030 0.06477 0.02539 0.08735 0.01126 0.02301 0.00073 -0.03384 0.01126 0.03365 -0.04260 0.01175 0.02076 0.03510 0.06080 0.04806 -0.01914 0.03796 -0.02624 -0.01613 -0.00884 0.01436 0.03003 0.03832 0.03690 -0.03172 0.02317 -0.02400 -0.00940 -0.06770 -0.07130 0.01730 0.07760 0.00410 -0.01820 -0.02280 0.03310 -0.07190 -0.00750 -0.07600 -0.06450 0.00820 -0.10880 0.09370 0.05320 -0.06230 -0.02990 -0.01970 0.01160 0.08460 0.04440 0.01490 0.01570 0.01300 -0.00980 0.05130 0.00650 0.05380 0.01560 0.01310 -0.01910 -0.01010 0.00970 0.01310 -0.03230 0.00460 0.00410 0.00890 0.03470 0.03500 -0.02570 0.01670 -0.01920 -0.01310 0.02960 -0.00640 0.03280 -0.00800 0.00480 -0.01090 0.03640 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2010 2010 2010 2010 2010 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 -0.00221 0.06998 0.01444 0.05004 -0.03103 -0.02783 0.04991 0.03013 0.03421 0.01980 0.06319 0.04456 -0.01220 0.07833 -0.02915 -0.02500 0.00109 0.00105 -0.09041 -0.08794 0.05497 0.04243 0.00815 -0.08623 -0.04423 -0.00305 -0.03847 0.03881 0.06101 0.00757 -0.11254 0.02811 0.02007 -0.00332 -0.30226 -0.21514 0.15874 -0.16494 -0.19464 0.04409 0.27975 0.02140 -0.02469 0.10179 0.12224 0.06367 -0.04802 0.06844 0.06427 -0.04678 0.05057 0.09419 0.06581 -0.05316 0.01023 0.15836 -0.09751 0.03772 0.05335 -0.02612 0.05025 0.04342 -0.04816 -0.05384 0.04702 0.06794 -0.01959 -0.02011 -0.01791 0.06375 0.04502 0.07615 0.03075 -0.03363 0.00239 0.05447 0.03857 -0.04417 0.09097 -0.12149 0.03688 -0.05847 0.10994 0.05714 -0.02179 -0.13422 -0.00196 -0.12847 -0.17258 0.01204 0.01183 -0.04529 -0.11703 0.03054 0.02976 0.12647 -0.06922 0.04603 0.01839 0.04654 0.02768 0.01498 -0.00034 -0.04815 0.00422 0.05889 0.01391 -0.12110 0.00892 0.03088 0.00693 0.01828 0.01462 0.01871 0.00658 0.00574 0.01526 0.01852 0.02908 0.07944 0.01330 0.01846 0.02866 0.01456 0.03076 0.04818 -0.00206 -0.01226 -0.00689 0.03136 0.02236 0.00575 0.00424 -0.03056 0.00779 0.00052 0.03748 0.01544 -0.04034 -0.00104 -0.02242 -0.05198 -0.10400 -0.07133 0.01972 -0.05167 -0.03372 0.05386 0.07122 -0.02101 -0.00307 0.05957 -0.03030 0.03099 -0.00806 0.05358 0.01465 -0.01544 0.01397 0.04546 0.01894 0.02183 0.01275 0.02401 -0.00472 0.01147 0.02764 -0.01364 -0.00484 -0.00260 0.00232 -0.00760 0.01137 0.02357 0.01270 0.00372 0.00223 -0.00090 0.01627 0.01811 0.01507 0.00793 -0.02111 0.03229 0.03258 -0.00892 0.00985 0.01083 0.04219 -0.01221 -0.00033 0.01205 0.01192 -0.02624 -0.01179 -0.01214 0.01632 0.00733 0.01113 -0.00099 -0.00123 -0.00615 -0.00089 0.03535 -0.01169 0.00492 0.00375 0.01709 -0.00516 0.02170 -0.01302 -0.01953 0.00160 0.01590 0.00818 -0.01583 0.00859 0.01596 0.00667 0.00599 0.00616 -0.00014 -0.00351 0.00979 0.01622 0.01417 0.01360 0.01681 0.01097 0.01116 0.01398 0.00106 0.01300 0.00748 -0.01797 -0.03540 0.01363 0.02617 0.00600 -0.02169 0.00291 -0.02340 -0.03440 0.00465 0.03724 0.00387 -0.03455 -0.01115 -0.00220 -0.07617 -0.19086 -0.08381 0.16979 -0.01575 -0.10195 0.05508 0.14220 0.07040 0.01735 0.06585 -0.00090 0.06185 -0.00299 0.01404 0.03665 0.00180 0.00664 0.03461 0.01865 -0.05207 0.01110 0.08640 0.01190 0.05370 0.00340 -0.05830 -0.01260 -0.03560 0.02140 0.00840 0.05310 0.02480 0.02410 0.01530 -0.00470 0.00780 0.01840 0.02190 -0.00380 -0.06080 -0.01470 0.01740 0.01000 -0.08810 -0.00460 -0.06760 -0.03270 -0.02290 0.00940 0.03470 -0.07030 0.02460 0.02700 -0.09490 -0.20350 -0.15620 0.02760 -0.07560 -0.12820 0.09070 0.15070 0.08820 0.05140 0.10210 0.07350 0.06320 -0.08150 0.01770 0.06610 -0.01250 0.04130 0.07950 0.10420 -0.08590 0.05174 0.05773 -0.00702 0.04012 0.04792 -0.03827 -0.00067 0.00810 0.02561 0.00212 0.03745 0.03076 0.03198 0.01402 -0.00131 0.02900 0.03752 0.02361 -0.00320 -0.02287 -0.00643 0.05318 0.04252 -0.03627 -0.02969 -0.07850 -0.01019 0.00412 0.05436 0.01195 -0.10492 -0.03314 -0.04253 -0.11435 -0.20827 -0.06381 0.08861 -0.13729 -0.10376 0.08398 0.11511 0.13176 -0.01403 0.10051 0.04506 0.03790 -0.02515 0.03917 0.00699 -0.05058 0.00269 0.06388 -0.02813 -0.11187 -0.00300 0.01790 0.00230 0.01150 0.01170 -0.02230 0.00130 0.01030 0.02390 0.02730 0.03200 0.01450 0.01800 0.01240 -0.02700 0.01190 0.04450 0.03460 -0.01640 -0.02660 0.02110 0.04040 0.01970 -0.03910 -0.00730 -0.05960 -0.03170 -0.00170 0.04020 0.00760 -0.08750 -0.00650 0.01270 -0.08030 -0.14860 -0.06370 0.00600 -0.08110 -0.09720 0.08700 0.07600 0.05630 0.00210 0.07030 0.02940 0.03140 -0.01060 0.06390 0.01070 -0.03450 0.02710 0.05670 0.00670 -0.08140 2010 2010 2010 2010 2010 2010 2010 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 -0.04533 0.08994 -0.01404 0.04455 0.04556 -0.01624 0.04674 0.03641 0.04486 -0.01380 0.04893 0.00839 -0.02682 0.00386 -0.05057 -0.10415 0.13313 -0.03527 0.04551 0.06470 -0.00664 0.04393 0.02799 -0.03949 0.05884 0.02296 0.00458 -0.00892 -0.00334 -0.00641 0.03196 0.04283 0.012942 0.032921 0.058019 -0.06561 -0.02275 0.005268 -0.06231 0.035469 0.040614 -0.04409 0.008421 0.03377 0.04687 0.00325 0.02882 0.02759 0.01178 -0.00190 0.03381 -0.05634 0.08724 0.02298 -0.08289 0.10753 -0.05390 0.11536 0.04538 0.01325 0.10906 0.06614 0.05543 0.01007 0.01750 -0.05044 -0.02093 -0.01518 -0.09362 -0.11375 0.18360 0.00941 -0.00296 0.02521 0.05392 -0.04564 -0.02516 -0.11566 0.06671 0.02679 0.02742 0.02321 -0.02330 -0.00994 0.02077 0.08933 -0.02213 0.027116 0.005859 0.01310 -0.03957 0.049437 -0.01948 0.022575 0.046161 0.007761 0.018961 -0.06371 0.04789 0.02317 0.06743 0.010256 0.033567 -0.02375 0.028833 -0.08121 -0.04314 -0.10045 -0.02438 0.05032 -0.05662 0.06232 0.03022 0.00486 0.04750 0.01894 0.02057 0.00856 0.02374 0.02643 -0.00428 -0.00728 0.00792 -0.04376 0.07600 -0.03111 0.00976 0.03718 -0.00913 0.02548 0.00178 -0.03143 0.03010 0.01156 0.00884 0.02332 -0.00362 0.02406 0.01396 0.04030 -0.02578 0.03100 0.01618 0.013948 -0.00044 0.04072 -0.01932 0.02938 0.03184 0.010155 0.02368 -0.01394 0.03700 0.00856 0.00484 0.02631 0.02164 -0.00626 0.02638 -0.00584 0.02110 -0.01806 -0.00116 -0.00062 0.01689 0.02735 0.02231 -0.00916 0.03340 -0.00721 0.01275 -0.01091 0.02371 -0.02302 -0.01741 0.01656 -0.00511 -0.01243 -0.00924 -0.00653 -0.00248 0.01267 0.00789 -0.01319 -0.00579 0.00404 -0.01420 0.020089 -0.00228 -0.0003 -0.01837 -0.00065 0.010211 0.01527 -0.00679 0.00407 0.00653 -0.01251 -0.01569 -0.00056 -0.01083 -0.00166 0.00829 0.00524 0.00471 -0.00852 0.01439 -0.00901 0.00063 0.00569 0.00696 -0.00395 0.01500 0.01080 -0.00201 0.02252 0.00907 0.05086 -0.00424 0.03548 0.02910 -0.01907 0.02735 0.01964 0.01347 -0.00037 0.01597 0.00581 -0.01007 0.00713 -0.03027 -0.06090 0.08382 -0.02195 0.03451 0.02653 0.02130 -0.01214 0.01539 -0.03480 0.04190 0.01672 0.01236 0.00734 0.00880 0.00545 0.01459 0.00270 0.007191 0.010446 0.02073 -0.02306 -0.02199 0.02530 -0.01030 0.00950 0.02503 0.00784 0.00514 0.00567 0.02311 -0.00019 0.00554 0.00916 0.00951 -0.02376 0.02510 -0.02435 0.00930 -0.01471 -0.09280 0.05440 -0.08480 0.11190 0.04510 0.02740 0.09300 0.00380 0.04380 0.01300 0.00270 -0.02690 -0.02510 -0.02520 -0.10590 -0.10990 0.10250 -0.02230 0.01360 0.08310 0.02720 0.04750 -0.01200 -0.05820 0.06030 -0.01830 0.02540 0.04730 -0.02990 -0.00810 0.01890 0.07180 0.00770 0.05380 0.00480 0.04540 0.01480 0.07910 -0.02760 0.06550 0.01870 0.05280 0.02600 0.00520 0.04360 -0.00970 -0.05550 -0.00750 0.04720 -0.06080 0.03780 -0.04910 0.03320 -0.01030 -0.03739 0.11610 -0.03811 0.09986 0.03804 -0.04834 0.08316 0.02091 0.03558 -0.02397 0.05633 -0.02211 -0.01197 -0.02389 -0.08757 -0.10807 0.09638 -0.02183 -0.02173 0.05263 0.04841 0.00416 -0.02073 -0.11143 0.07039 0.00081 0.03195 0.02723 0.01087 0.02774 0.04388 0.03727 -0.01287 0.013039 0.050232 -0.03030 -0.02668 0.05320 -0.01952 0.07824 0.032556 0.00549 0.021685 -0.05201 0.06131 -0.00459 0.01667 0.01595 0.00921 -0.02603 0.00180 -0.03882 -0.00265 0.00063 -0.05060 0.07110 -0.04340 0.08560 0.03930 -0.00550 0.06480 0.02460 0.03040 -0.00360 0.02970 -0.01390 -0.01660 -0.01460 -0.05060 -0.06190 0.10180 -0.00130 0.01390 0.04350 0.04560 0.03590 -0.00750 -0.05700 0.04350 0.01520 0.02120 0.02810 -0.01960 0.00360 0.00400 0.04840 0.01260 0.03710 0.02010 0.02500 -0.01510 0.05160 -0.02850 0.02980 0.04740 0.03380 0.02540 -0.03880 0.04100 0.01060 0.00930 0.02200 0.01660 -0.01090 0.03850 -0.00970 0.01980 0.02910 2014 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 0.01091 0.05595 -0.02581 0.01150 -0.04710 -0.00114 -0.04319 0.04855 -0.05676 0.01875 0.06143 -0.00258 0.01194 -0.03479 -0.00287 0.09989 -0.01665 0.02339 0.06684 0.03872 -0.03282 -0.01410 -0.04890 -0.02041 0.04201 0.009155 -0.03274 0.055461 -0.03319 0.072537 -0.06106 -0.02709 -0.07068 -0.05608 -0.07454 0.130145 -0.00427 -0.09931 -0.05651 -0.03063 0.092876 0.082129 -0.03874 0.027006 -0.02569 0.008781 0.023707 -0.00697 0.065821 0.039506 0.00562 -0.01268 0.04025 -0.00074 0.00952 0.03121 -0.00320 0.01522 -0.02064 -0.01244 0.05248 -0.01952 -0.00698 -0.02764 -0.01354 0.04880 0.01250 0.02019 0.00674 0.03074 -0.00042 0.00854 -0.00508 0.03184 0.01802 0.00242 0.02512 0.00196 0.00562 -0.01194 -0.00048 -0.02312 0.00891 -0.01605 -0.00034 -0.00233 0.01465 -0.01253 0.01020 0.01490 -0.00950 -0.00080 -0.00930 0.02220 0.00790 -0.01470 -0.00340 -0.01230 -0.00310 0.00900 -0.01520 0.00855 0.02157 -0.00942 0.01041 0.00433 -0.02044 -0.00731 -0.02047 -0.03181 0.02788 -0.02532 -0.03633 -0.00977 0.006625 0.029956 0.036517 0.003408 0.023549 0.015759 0.018649 0.010193 -0.00747 0.001211 0.014339 0.04680 -0.03630 0.04590 0.01510 -0.01820 0.01680 0.01100 -0.05020 -0.03930 -0.05960 0.03940 0.02800 -0.04070 -0.09660 -0.00680 0.05160 0.04460 -0.00110 -0.00210 0.04430 0.03270 0.04820 -0.06810 0.09740 0.03220 -0.03993 0.00625 0.06338 -0.01429 0.03647 0.00195 -0.04727 0.03755 -0.07425 -0.04419 0.06612 -0.00753 -0.03182 -0.04688 -0.03335 0.065821 0.022218 -0.00086 -0.04385 0.061146 0.005341 0.013368 -0.02215 -0.01781 0.016552 -0.00590 -0.03470 0.05930 -0.02000 0.01540 0.01190 -0.01790 0.02620 -0.06360 -0.02510 0.08710 0.00360 -0.01370 -0.05120 -0.00500 0.06240 0.00350 0.01780 -0.00180 0.03500 0.00270 -0.00040 -0.01380 0.03240 0.02150 CBOND 0.00141 0.00419 -0.01557 0.01515 0.01132 0.01416 0.03659 -0.01476 0.01749 0.01268 0.00565 0.01059 0.01187 -0.00032 0.00369 0.00631 0.01187 0.00739 -0.00095 0.00468 0.03240 -0.01543 0.01884 0.00291 0.00988 -0.02373 0.00708 0.00292 -0.01337 -0.00521 -0.00554 -0.00243 0.01086 0.00460 0.00107 -0.00530 -0.00353 0.00927 0.00853 -0.00878 -0.00373 0.02511 0.01213 0.01252 0.00548 0.00024 0.01187 0.01864 0.02862 0.00845 0.00613 -0.00327 0.00887 GBOND 0.00099 0.00122 -0.01080 0.01435 0.00864 0.01117 0.02868 -0.01013 0.01519 0.01742 0.00521 0.01052 0.01532 -0.00298 0.00273 0.00445 0.01039 0.01152 0.00157 0.02716 0.02787 -0.00320 -0.00023 0.00197 0.00580 -0.02552 0.00383 0.00238 -0.00933 -0.00209 -0.00085 0.00016 0.00766 0.00108 -0.00190 -0.00665 0.00261 0.01503 0.01986 -0.00316 0.00153 0.01686 0.01030 0.01469 0.00078 0.00975 0.02050 0.01908 0.00814 0.01208 0.00321 -0.01243 0.00311 TBILL 0.00401 0.00379 0.00431 0.00431 0.00426 0.00374 0.00429 0.00406 0.00458 0.00391 0.00377 0.00463 0.00420 0.00385 0.00449 0.00431 0.00381 0.00402 0.00387 0.00401 0.00388 0.00335 0.00323 0.00378 0.00349 0.00337 0.00408 0.00378 0.00346 0.00410 0.00366 0.00388 0.00371 0.00358 0.00381 0.00376 0.00434 0.00430 0.00438 0.00460 0.00478 0.00374 0.00477 0.00500 0.00509 0.00522 0.00527 0.00491 0.00524 0.00365 0.00432 0.00386 0.00318 0.00501 0.02710 0.01299 -0.00335 0.02461 -0.00845 -0.00724 0.00849 0.00660 -0.01858 0.01261 0.01407 0.00010 -0.00363 0.02652 0.01907 -0.01342 0.01563 0.03053 0.00421 0.02054 0.00043 0.01996 0.03241 -0.00228 -0.04344 0.00832 0.03581 -0.01052 0.00508 0.01139 0.01048 0.01245 0.00945 -0.03144 -0.00724 0.00441 0.01244 0.02378 0.00616 0.00976 -0.01017 0.01368 0.00797 -0.00596 -0.01325 0.01297 0.01375 0.00819 -0.00987 0.01531 -0.01614 -0.01155 0.00588 0.00537 0.02495 0.01324 0.01587 0.02770 -0.02476 -0.00974 0.00673 0.00901 -0.02406 0.02488 0.00560 0.01412 0.02369 0.02162 0.02696 -0.01107 -0.00990 0.02598 -0.00304 0.01720 -0.00416 0.00465 0.02884 -0.00612 -0.04393 0.00593 0.03015 -0.01526 0.00125 0.00886 0.00852 0.01239 0.00938 -0.03216 -0.00343 0.00401 0.00952 0.02068 0.00257 0.00793 -0.01343 0.00991 0.00730 -0.00817 -0.00325 0.01758 0.01222 0.00612 -0.01355 0.01588 -0.01327 -0.00782 0.00485 0.00278 0.00300 0.00300 0.00273 0.00215 0.00175 0.00148 0.00139 0.00129 0.00134 0.00155 0.00144 0.00131 0.00151 0.00140 0.00141 0.00133 0.00117 0.00108 0.00093 0.00087 0.00102 0.00094 0.00090 0.00098 0.00067 0.00069 0.00087 0.00070 0.00073 0.00083 0.00070 0.00062 0.00084 0.00080 0.00060 0.00082 0.00092 0.00112 0.00119 0.00113 0.00154 0.00167 0.00160 0.00160 0.00210 0.00210 0.00240 0.00230 0.00240 0.00300 0.00290 0.00270 0.00310 0.01011 -0.00210 0.00452 -0.01410 -0.00350 -0.00169 0.00126 0.01461 0.01864 0.01145 0.00809 0.01466 -0.00909 0.00007 0.02059 -0.00574 0.00734 -0.01000 -0.00489 0.00231 0.00809 0.00770 0.01201 0.00599 0.00158 0.01018 0.00111 -0.01271 0.00915 -0.00954 -0.00640 -0.00748 0.00719 -0.07769 -0.06444 0.04069 0.06797 0.00453 -0.01967 -0.00413 0.03472 0.03904 0.02732 0.04317 0.01833 0.01775 0.00703 0.01431 -0.00781 0.01631 0.00356 0.00299 0.01820 -0.00551 0.01036 -0.00298 0.00146 -0.01079 -0.00413 0.00033 0.00318 0.01238 0.01468 0.00928 0.00507 0.01045 -0.00822 -0.00160 0.01658 -0.00049 0.00515 -0.00898 -0.00043 0.01659 0.01568 0.00539 0.00786 0.03069 0.00080 0.02539 0.01140 0.00693 -0.01718 -0.01167 0.00785 0.00423 0.01249 0.00612 -0.00110 0.05307 0.03388 -0.02916 -0.00526 0.02179 -0.01824 -0.01009 -0.00212 0.00418 0.00890 0.00778 -0.00049 0.01392 -0.02612 0.01581 0.00395 -0.00847 0.01048 0.01710 0.00320 0.00350 0.00340 0.00370 0.00360 0.00430 0.00400 0.00400 0.00420 0.00410 0.00410 0.00420 0.00400 0.00440 0.00380 0.00430 0.00440 0.00410 0.00400 0.00400 0.00420 0.00320 0.00320 0.00340 0.00270 0.00210 0.00130 0.00170 0.00170 0.00170 0.00170 0.00150 0.00120 0.00150 0.00080 0.00020 0.00090 0.00000 0.00010 0.00010 0.00010 0.00000 0.00000 0.00010 0.00010 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00010 0.02131 0.01959 0.01983 0.00699 0.00118 -0.00811 -0.00918 0.00199 0.00792 -0.00133 0.01720 0.01444 -0.00876 0.02521 0.00065 0.00255 0.01788 -0.01960 0.02138 0.02214 0.00842 -0.00966 0.01396 0.00755 0.00355 0.02877 0.00222 0.00702 0.01288 -0.00159 -0.00064 -0.00945 0.00653 -0.00211 0.01090 -0.01687 -0.01469 -0.00036 -0.00790 0.01521 0.00553 -0.00337 -0.00445 -0.00228 0.00010 0.00137 -0.00023 0.000752 0.002092 0.00075 0.00078 -0.00052 -0.00150 0.00111 0.01857 0.00682 0.02008 0.00021 -0.00158 -0.00699 -0.01799 -0.00025 -0.00074 -0.00061 0.01154 0.01562 -0.00338 0.01823 0.02777 0.01747 -0.00815 0.00746 0.00966 0.00423 -0.00713 -0.01003 0.01455 0.01714 -0.00348 0.01007 -0.00129 -0.00306 -0.00169 0.00520 -0.00435 -0.02783 0.01218 -0.00150 0.04189 -0.06392 -0.03491 -0.01505 -0.01235 0.00839 0.01224 -0.02644 -0.01871 0.059826 0.00468 0.00602 0.01950 0.02826 -0.00127 0.00373 0.04319 -0.01849 0.02429 0.02729 0.00010 0.00010 0.00010 0.00010 0.00010 0.00010 0.00010 0.00000 0.00010 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00010 0.00000 0.00000 0.00010 0.00010 0.00010 0.00010 0.00010 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 -0.00330 0.00033 0.00174 0.00210 0.00245 0.00180 -0.00078 -0.00209 -0.00340 -0.00043 -0.00010 0.00352 -0.00079 0.00149 -0.00230 0.00168 0.00534 0.00053 -0.00039 0.00512 -0.00045 0.00449 -0.00105 0.00291 -0.00029 0.03332 0.08687 -0.05546 0.00939 -0.02974 -0.02285 -0.03589 0.04143 -0.00621 0.01786 -0.00327 -0.00869 -0.00252 0.05694 0.02516 0.00185 -0.00649 0.00686 0.06710 0.02038 -0.01037 -0.01355 -0.04216 -0.07920 -0.00660 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00010 0.00010 0.00020 0.00020 0.00010 0.00010 0.00020 0.00020 0.00020 0.00020 0.00020 0.00010 0.00030