Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Having trouble with questions 5a and 5c. I attached the questions. FIN 431 Project # 2 (Due March 23 in class) Instruction: All answers must
Having trouble with questions 5a and 5c.
I attached the questions.
FIN 431 Project # 2 (Due March 23 in class) Instruction: All answers must be typed. Please note that for graphs, you are encourage use Excel or any other software to do the job. Alternatively, you can also use a graph paper and draw by hand. You should turn in a hard copy this project in class on the due date. Email me the spreadsheet (Excel) file with supporting calculations. Late submissions will result in a grade of zero without exception! 1. Data: This project makes use of annual data for two risky securities: the S&P 500 Index and Gold. Annual values for each of these securities during the period from 1975-2015 are provided in a spreadsheet posted on Blackboard. You should use an annual risk-free rate of 4% for this project. 2. Return Calculations: Calculate annual returns for each of the two securities from 1976 through 2015. Calculate the average annual return, the standard deviation of annual returns, and the correlation between the returns of the two securities during this period and fill in the table provided. (Note: all of these calculations are based on annual security % returns NOT index values). Attach the spreadsheet showing all of the relevant calculations as Exhibit 1. Average Annual Return S&P 500 9.52% Gold 7.45% Standard Deviation of Annual Returns 16.76% 24.51% Return Correlation(S&P,Gold) 0.18% 3. Capital Allocation Lines: Assume that the mean return, standard deviation, and correlation estimates you calculated above provide a reasonable forecast of the expected returns and risks of these securities for the coming year. Based on these forecasts, plot the two risky securities on an expected return - standard deviation graph. Also, plot the risk-free security. Be sure to label all three securities on the graph. Draw the Capital Allocation Line for each of the risky securities (S&P and Gold). Attach the graph as Exhibit 2. 10.00% 9.00% 8.00% 7.00% 6.00% S&P Risk Free Gold 5.00% 4.00% 3.00% 2.00% 1.00% 0.00% 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 4. Risky Portfolios: Calculate the expected returns and standard deviations of portfolios that combine the two risky securities (S&P and Gold), varying weights from 0% to 100% in increments of 5% (note: this should result in 21 portfolios). Attach the spreadsheet showing all relevant calculations as Exhibit 3. Portfolio Frontier 10.0% 8.0% 6.0% Mean 4.0% 2.0% 0.0% 14.00% 16.00% 18.00% 20.00% 22.00% Standard Deviation 24.00% 26.00% 5. The Opportunity Set and the Tangency Portfolio: Plot the risk-free security and the 21 portfolios described in question 4 on an expected return - standard deviation graph. Be sure to clearly label the S&P 500, Gold, and the risk-free security on the graph. Identify and label the minimum variance portfolio on the graph. Identify and label the optimal risky (a.k.a. tangency) portfolio on the graph and draw the Capital Allocation Line (CAL) for this portfolio. Attach the graph as Exhibit 4. (a) What are the portfolio weights in the Tangency Portfolio? What are the mean and standard deviation of the Tangency Portfolio? (b) What are the portfolio weights in the Minimum Variance Portfolio? What are the mean and standard deviation of the Minimum Variance Portfolio? S&P 71.79% Gold 28.21% Mean 8.94% Standard Deviation 14.92% (c) What are the portfolio weights in the Equal-Weighted Portfolio? What are the mean and standard deviation of the Equal-Weighted Portfolio? DATE 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 S&P 500 Index 90.19 107.46 95.10 96.11 107.94 135.76 122.55 140.64 164.93 167.24 211.28 242.17 247.08 277.72 353.40 330.22 417.09 435.71 466.45 459.27 615.93 740.74 970.43 1229.23 1469.25 1320.28 1148.08 798.55 1111.92 1211.92 1248.29 1418.30 1468.36 903.25 1115.10 1257.64 1257.60 1426.19 1848.36 2058.90 2043.94 Gold Prices Ret S&P 139.30 R=p1/p0-1 133.80 160.45 207.83 455.08 594.92 410.09 444.30 389.36 320.14 320.81 391.23 486.31 418.49 409.39 378.16 361.06 334.80 383.35 379.29 387.44 369.00 288.74 291.62 282.37 271.45 275.45 321.18 417.25 435.60 513.00 635.70 836.50 869.75 1087.50 1420.25 1531.00 1664.00 1204.50 1135.80 1060.30 average 19.15% -11.50% 1.06% 12.31% 25.77% -9.73% 14.76% 17.27% 1.40% 26.33% 14.62% 2.03% 12.40% 27.25% -6.56% 26.31% 4.46% 7.06% -1.54% 34.11% 20.26% 31.01% 26.67% 19.53% -10.14% -13.04% -30.44% 39.24% 8.99% 3.00% 13.62% 3.53% -38.49% 23.45% 12.78% 0.00% 13.41% 29.60% 11.39% -0.73% 9.52% std dev correlation 16.76% 0.18% S&P average std dev 9.52% 16.76% 10.00% 9.00% 8.00% 7.00% 6.00% S&P Risk Free 5.00% 4.00% 3.00% 2.00% 1.00% 0.00% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00% 18.00% Ret Gld -3.95% 19.92% 29.53% 118.97% 30.73% -31.07% 8.34% -12.37% -17.78% 0.21% 21.95% 24.30% -13.95% -2.17% -7.63% -4.52% -7.27% 14.50% -1.06% 2.15% -4.76% -21.75% 1.00% -3.17% -3.87% 1.47% 16.60% 29.91% 4.40% 17.77% 23.92% 31.59% 3.97% 25.04% 30.60% 7.80% 8.69% -27.61% -5.70% -6.65% 7.45% 24.51% Risk Free % 16.00% 18.00% Gold 4% 0 7.45% 24.51% 30.00% 25.00% 20.00% S&P Risk Free Gold Risk 15.00% 10.00% 5.00% 0.00% 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% 7.00% 8.00% % Gold Risk Free 7.00% 8.00% X1 10% 7% 16.76% 24.51% 0.18 X2 0% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00% 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 85.00% 90.00% 95.00% 100.00% 100% 95% 90% 85% 80% 75% 70% 65% 60% 55% 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Mean (portfolio) Sigma (portfolio) 7.5% 24.51% 7.6% 23.45% 7.7% 22.42% 7.8% 21.43% 7.9% 20.48% 8.0% 19.58% 8.1% 18.73% 8.2% 17.94% 8.3% 17.23% 8.4% 16.59% 8.5% 16.04% 8.6% 15.60% 8.7% 15.26% 8.8% 15.03% 8.9% 14.93% 9.0% 14.94% 9.1% 15.08% 9.2% 15.34% 9.3% 15.71% 9.4% 16.19% 9.5% 16.76% Using Solver to find MVP 71.79% 28.21% Portfolio Fronti 10% 8% Mean Mean (S&P) Mean (Gold) sigma (S&P) sigma (Gold) correlation 6% 4% 2% 0% 14.00% 16.00% 14.92% 20.00% Standard Dev MVP found using Solver ### 18.00% MVP found using formula .00% Portfolio Frontier S&P Gold 18.00% 20.00% 22.00% Standard Deviation 24.00% 26.00%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started