Question

Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2015 Stoeks Longter Treasury Bonds 1-bills Average 12.60 4.400 2.00 th 1950 to 2015 1950 ta 1959 1960 to 1969 1970 to 1979 1980 to 1989 1990 to wa 1999 0.01 0.02 16.0 0.02 2000 to 2009 Annual 2010 Return Annual 2011 Return Annual Return Annual Return Annual 2014 Return annual 2015 Return 2010 to Average 2015 0.07 0.05 0.0€ You have a portfolio with an asset allocation of 50 percent stocks, 38 percent long-term Treasury bonds, and 12 percent T-bills. Use these weights and the returns given in the above table to compute the return of the portfolio in the year 2010 and each year since. Then compute the average annual return and standard deviation of the portfolio. (Do not round Intermediate calculations. Round your answers to 2 decimal places) Porta Return 2010 2015 Average Suncard de viata

Answer 1

Annual portfolio return = sum of weighted returns

Average portfolio return = sum of annual returns/number of returns

Standard deviation = [1/number of returns*(sum of (annual return - average return)^2)]^0.5

Year (n) 2010 2011 2012 2013 2014 2015 Weights Average Standard deviation Stocks 15.10% 2.10% 16.00% 22.40% 13.70% 1.40% 50.00% Long-term T-bonds T-bills 9.40% 0.01% 29.90% 0.02% 2.60% 0.02% -12.70% 0.07% 25.10% 0.05% -1.20% 0.21% 38.00% 12.00% Portfolio return 11.12% 12.41% 8.99% 6.38% 16.39% 0.27% 9.26% 5.06%

Excel formulas:

Year (n) 2010 2011 2012 2013 Stocks Long-term T-bonds T-bills Portfolio return 0.151 0.094 0.0001 -SUMPRODUCT($C$173:$E$173,C167:E167) 0.021 0.299 0.0002 -SUMPRODUCT($C$173:$E$173,C168:E168) 0.16 0.026 0.0002 -SUMPRODUCT($C$173:$E$173,C169:E169) 0.224 -0.127 0.0007 -SUMPRODUCT($C$173:$E$173,C170:E170) 0.137 0.251 0.0005 =SUMPRODUCT($C$173:$E$173,C171:E171) 0.014 -0.012 0.0021fSUMPRODUCT($C$173:$E$173,C172:E172) 0.5 0.38 0.12 =AVERAGE(F167:F172) =SQRT(((F167-F174)^2+(F168-F174)^2+(F169-174)^2+(F170-F174)^2+(F171-F174)^2+(F172-F174)^2)/6) 2014 2015 Weights Average Standard deviation