Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedplease 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Emerald Handbook On Cryptoassets Investment Opportunities And Challenges

Authors: H. Kent Baker, Hugo Benedetti, Ehsan Nikbakht, Sean Stein Smith

1st Edition

1804553212, 978-1804553213

More Books

Students also viewed these Finance questions