Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: I need the answer in excel sheet with formulas. Please proper explain and do not copy from Chegg. otherwise i have to report the
Question:
I need the answer in excel sheet with formulas.Please proper explain and do not copy from Chegg. otherwise i have to report the answer.
Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2015 Stocks 12.6% Long-Term Treasury Bonds T-bills 4.40% 6.6% Average 20.9 0.0 2.00 1950 to 2015 Average 1950 to 1959 1960 to 1969 1970 to 1979 1980 to 1989 1989 8.7 1.6 4.00 Average Average 7.5 5.7 6.30 Average 18.2 13.5 8.90 1990 to 1999 1333 Average 19.0 9.5 4.90 4.30 2000 to 2009 Average 0.9 0.2 8.0 0.0 2.70 2.10 2010 2010 Annual Return Annual 15.1 15.1 9.4 0.01 ** 2011 2011 Annual Return Annual 2.1 29.9 0.02 2.2 0.02 Annual Return 16.0 10.0 3.0 3.6 0.02 0.02 2012 2012 2013 2014 Annual Return Annual Return 32.4 -12.7 0.07 13.7 25.1 0.05 2015 Annual Return -1.2 0.21 1.4 13.4 2010 to 2015 Average 9.0 0.06 You have a portfolio with an asset allocation of 50 percent stocks, 32 percent long-term Treasury bonds, and 18 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.) Portfolio Return . 2010 :% 2011 2012 2013 2014 2015 Average Standard deviation % % % % % % %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