Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show excel function, ex B6-F7/2 Date 31-Dec-89 31-Dec-90 31-Dec-91 31-Dec-92 31-Dec-93 31-Dec-94 31-Dec-95 31-Dec-96 31-Dec-97 31-Dec-98 31-Dec-99 31-Dec-00 31-Dec-01 31-Dec-02 31-Dec-03 31-Dec-04 31-Dec-05 31-Dec-06
please show excel function, ex B6-F7/2
Date 31-Dec-89 31-Dec-90 31-Dec-91 31-Dec-92 31-Dec-93 31-Dec-94 31-Dec-95 31-Dec-96 31-Dec-97 31-Dec-98 31-Dec-99 31-Dec-00 31-Dec-01 31-Dec-02 31-Dec-03 31-Dec-04 31-Dec-05 31-Dec-06 31-Dec-07 31-Dec-08 31-Dec-09 31-Dec-10 31-Dec-11 31-Dec-12 31-Dec-13 31-Dec-14 STANDARD & POOR'S 500 (S&P 500) SHARPE RATIO S&P 500 Annua One year S&P adjusted 1 risk-free minus S&P 500 minus price retum retum risk-free risk-free return 329.08 Mean 343.93 6.82% Standard deviation 408.78 4.12% Sharpe ratio 438.78 3.61% 481.61 3.63% 470.42 7.20% 636.02 5.18% 786.16 5.51% 980.28 5.51% 1,279.64 4.53% 1,394.46 5.98% 1,366.01 5.32% 1,130.20 2.17% 855.7 1.32% 1,131.13 1.26% 1,181.27 2.75% 1,280.08 4.38% 1,438.24 5.00% 1,378.55 3.34% 825.88 0.37% 1,073.87 0.47% 1,286.12 0.29% 1,312.41 0.12% 1,498.11 0.16% 1,782.59 0.13% 1,994.99 0.10%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