Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

use these data to answer the following questions via excel: date year quarter cogs revenue op income op exp sga exp net income 31-Mar-90 1989 4 8.498 9.908 0.6 9.028 0.53 0.122 30-Jun-90 1990 1 9.962...

i am trying to understand the behavior of discount rates in order to see whether you can assume rates follow a normal distribution in simulations. contains monthly data on the 10-year Treasury rates,...

please show excel function ex. (B4-C3)/2 FEDEX AND S&P 500 Excess return S&P Excess retum FedEx 500 Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 S&P total return -23.37%...

please show excel formula. Only need Market Cap and price (everything shown in red). PLEASE SHOW EXCEL FUNCTION. This is all the information given on the question. I only need the answers to the...

Please Calculate the Market Value of the capital structure components DEBT ISSUANCE 1: Book value on this debt is 140,000 Coupon is 12% paid SEMI annually (please account for semiannual nature in...

PLEASE SHOW EXCEL FUNCTION / WORK PLEASE SHOW EXCEL FUNCTION / WORK 1 - Your firm bought a new sanding machine for its factory floor two years ago for $40,000. The current market value (Year O) of...

Please show excel functions. ex: =b2/a1 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 7.62% 10.08% 1.32% 37.58% 22.96% 33.36% 28.58% 21.04% -9.10% -11.89% -22.10% 3.89% 3.43% 5.32% 5.94%...

If you have $10,000 in a savings account earning 10 percent, how large an annuity can you draw out each year if you want nothing left at the end of 7 years? Please show excel function formula

I invested $800,000 in a cattle ranch and I sold that ranch for $2,500,000 ten years later. What was my annual percentage rate return? Please show excel function formula

Please, show excel function. Thank you! Professors Annuity Corp. offers a lifetime annuity to retiring professors. For a payment of $100,000 at age 65, the firm will pay the retiring professor $800 a...

Change in liquid height with time (Fig. 7.1-1). (a) Derive Eq. 7.1-4 by using integral calculus. (b) In Example 7.1-1, obtain the expression for the liquid height h as a function of time t. (c) Make...

A vessel at rest at the origin of an xy coordinate system explodes into three pieces. Just after the explosion, one piece, of mass m, moves with velocity (-30 m/s)i and a second piece, also of mass...

If a bank pays 4 percent compounded semi - annually, the true rate of interest is less than 4 percent annually. a . True b . False

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

This book covers four human resource management practice areas: managing the human resource environment, acquiring and preparing human resources, assessment and development of human resources, and...

Carry out a risk assessment exercise for an activity that you take part in. It might be a local amateur football or netball team, drama event or similar.