Question: 8) Return data for mutual fund XYZ, the S&P 500, and 90-day T-Bills can be found in the attached Excel file Download attached Excel file.

8) Return data for mutual fund XYZ, the S&P 500, and 90-day T-Bills can be found in the attached Excel file Download attached Excel file.

a) Plot the risk premium of Fund XYZ vs. the market premium

b) What is Fund XYZ's beta?Hint: use the "slope function" in Excel.

c) What is Fund XYZ's alpha? Hint: use the "intercept function" in Excel.

Please show me the calculation/ computation in excel calculator for the risk premium of Fund XYZ vs. the market premium.

Also show me the step for creating the regression and scatter plot when creating the graph to show the risk premium of Fund XYZ vs. the market premium.

8) Return data for mutual fund XYZ, the S&P 500, and 90-day

AutoSave O OFF A A 9 . C ... Module 6 - Homework Comments E Share Page Layout Formulas Data Review View Automate Tell me Home Insert Draw Calibri (Body) 12 A A de Wrap Text Percentage Insert Delete Format Sort & Find & Analyze Sensitivity Conditional Format Cell Filter BIU DVAv Merge & Center $ ~ % 9 DV Data Paste Formatting as Table Styles Select C23 X fx =PRODUCT(1+C3:C22)^(1/COUNT(C3:C22))-1 P Q R S U G H 1 K L M N 0 A Yea Fund XYZ S&P 500 90d T-Bills 2000 19.40% 13.409 1.10% 2001 39.709 29.70% 1.30% 2002 17.009 17.00% 1.50% 2003 29.609 1.609 1.90% 2004 -10.40% -4.40% 2.00% 2005 23.10% 22.109 1.60% 2006 24.00% 18.00% 1.90% 10 2007 -1.20% 0.80% 1.20% 11 2008 26.80% -17.80% 1.60% 12 2009 -3.00% -5.00% 1.00% 13 2010 -24.00% -17.00% 1.10% 14 2011 32.70% 22.70% 1.10% 15 2012 29.20% 21.20% 1.20% 16 2013 10.60% 3.60% 1.70% 17 2014 -23.10% 20.109 1.50% 18 2015 16.10% 11.10% 1.00% 19 2016 7.80% 12.80% 1.90% 20 2017 23.609 15.60 1.20% 21 2018 37.80% 27.809 1.30% 22 2019 9.60% 13.60% 1.70% 23 Total Return (p.a) 3.20% 4.14% 1.44% 24 25 26 27 28 Sheet1 + Q J - 100% Ready 1 Accessibility: Good to go

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 Accounting Questions!

8) Return data for mutual fund XYZ, the S&P 500, and 90-day T-Bills can be found in the attached Excel file Download attached Excel file. a) Plot the risk premium of Fund XYZ vs. the market premium...

8) Return data for mutual fund XYZ, the S&P 500, and 90-day T-Bills can be found below: Year Fund XYZ S&P 500 90d T-Bills 2000 -19.40% -13.40% 1.10% 2001 39.70% 29.70% 1.30% 2002 17.00% 17.00% 1.50%...

PLEASE IGNORE THIS QUESTION. IT NO LONGER NEEDS TO BE ANSWERED. CHEGG DOES NOT ALLOW DELETION OF QUESTIONS. THANK YOU. Please provide downloadable excel sheet and graphs, not pictures. Do not bother...

Return data for mutual fund XYZ, the S&P 500, and 90-day T-Bills can be found below: Year Fund XYZ S&P 500 90d T-Bills 2000 -19.40% -13.40% 1.10% 2001 39.70% 29.70% 1.30% 2002 17.00% 17.00% 1.50%...

2. A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that...

1. An investment advisor is comparing performance of two mutual funds each of which is designed to outperform the S&P 500. The Freedelity Fund returned 19% The JPStanley Fund returned 16%. The betas...

please provide step by step excel You have been assigned to construct an optimal portfolio comprising two risky assets (Portfolios A \& B) while considering your client's risk tolerance. The attached...

Flash Corporation borrowed $120,000 from the bank on November 1, 2010. The note had an 8 percent annual rate of interest and matured on April 30, 2011. Interest and principal were paid in cash on the...

An initially uncharged air-filled capacitor is connected to a 2.37 V charging source. As a result, the capacitor acquires 5.87 10-5 C of charge. Then, while the capacitor remains connected to the...

The coupon is the annual interest divided by the current bond price. True False

Operations Management The average demand for an item is 120 units/year. The lead time is 1 month and the demand during lead time follows normal distribution with average of 10 units and standard...

10. First test yourself and then let another member of the group test you in relation to the following questions. If deviations occur, discuss why this might be. What can the results of this test be...

5. Based on your desired future, answer the following questions: (a) What do you want, i.e. what goals have you set yourself? Set up three goals in order of priority. (b) Why do you want this? (c)...

1. Discuss the following statements: (a) Its what you are best at that will be your downfall. (b) How can we learn but not learn? (c) Learning to see is different from seeing. (d) Creativity is...