(The time-series of returns) In the Excel spreadsheet PS1_Q1_raw.xlsx, I provide you three time-series: the performance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(The time-series of returns) In the Excel spreadsheet "PS1_Q1_raw.xlsx," I provide you three time-series: the performance index of selling S&P 500 put options from Bloomberg (Put Selling), the S&P 500 index (SP500), and the S&P 500 total return index (SP500_TR). You will work on this spreadsheet to solve the following problems. Always round off your answers to two decimal place. (a) Calculate the monthly returns for the three indices (don't report these return series). Then fill out the following table: Monthly Returns Put Selling S&P 500 S&P 500 total return ) sample estimators for: ER SDIR] Skew[R] Kurt[R] I Note 1: report E[Re]-and SD [Re] in percentage points; estimate E[Re] using the arithmetic average return r. Note 2: since the Excel function KURT gives excess kurtosis, you should add 3 to the Excel output when filling in the kurtosis estimates into the table. Note 3: the numbers from my slides are calculated from data for a different time period, don't copy them! Put Selling SP500 175.92 200.19 228.5 244.71 286.01 332.93 425.09 503.91 609.8 689.44 616.15 563.31 685.97 751 12/30/2005 801.42 12/29/2006 922.88 12/31/2007 1010.61 12/31/2008 740.1 12/31/2009 973.28 12/31/2010 1061.04 12/30/2011 1126.54 12/31/2012 1218.24 12/31/2013 1367.79 12/31/2014 1455.01 12/31/2015 1548.16 12/30/2016 1668.39 Date 12/31/1991 12/31/1992 12/31/1993 12/30/1994 12/29/1995 12/31/1996 12/31/1997 12/31/1998 12/31/1999 12/29/2000 12/31/2001 12/31/2002 12/31/2003 12/31/2004 12/29/2017 12/31/2018 1849.34 1739.67 12/31/2019 1974.62 12/31/2020 2016.7 12/31/2021 2456.08 12/30/2022 2267.98 417.09 479.63 435.71 516.18 466.45 568.2 459.27 575.7 615.93 792.04 740.74 973.9 970.43 1298.82 1229.23 1670.01 1469.25 2021.4 1320.28 1837.37 1618.98 1261.18 1622.94 1799.55 1148.08 879.82 1111.92 1211.92 1248.29 1418.3 1468.36 903.25 1115.1 1257.64 1257.61 1426.19 1848.36 2058.9 2043.94 2238.83 2673.61 2506.85 SP500 TR 3230.78 3756.07 4766.18 3839.5 1887.94 2186.13 2306.23 1452.98 1837.5 2114.29 2158.94 2504.44 3315.59 3769.44 3821.6 4278.66 5212.76 4984.22 6553.57 7759.35 9986.7 8178.02 (The time-series of returns) In the Excel spreadsheet "PS1_Q1_raw.xlsx," I provide you three time-series: the performance index of selling S&P 500 put options from Bloomberg (Put Selling), the S&P 500 index (SP500), and the S&P 500 total return index (SP500_TR). You will work on this spreadsheet to solve the following problems. Always round off your answers to two decimal place. (a) Calculate the monthly returns for the three indices (don't report these return series). Then fill out the following table: Monthly Returns Put Selling S&P 500 S&P 500 total return ) sample estimators for: ER SDIR] Skew[R] Kurt[R] I Note 1: report E[Re]-and SD [Re] in percentage points; estimate E[Re] using the arithmetic average return r. Note 2: since the Excel function KURT gives excess kurtosis, you should add 3 to the Excel output when filling in the kurtosis estimates into the table. Note 3: the numbers from my slides are calculated from data for a different time period, don't copy them! Put Selling SP500 175.92 200.19 228.5 244.71 286.01 332.93 425.09 503.91 609.8 689.44 616.15 563.31 685.97 751 12/30/2005 801.42 12/29/2006 922.88 12/31/2007 1010.61 12/31/2008 740.1 12/31/2009 973.28 12/31/2010 1061.04 12/30/2011 1126.54 12/31/2012 1218.24 12/31/2013 1367.79 12/31/2014 1455.01 12/31/2015 1548.16 12/30/2016 1668.39 Date 12/31/1991 12/31/1992 12/31/1993 12/30/1994 12/29/1995 12/31/1996 12/31/1997 12/31/1998 12/31/1999 12/29/2000 12/31/2001 12/31/2002 12/31/2003 12/31/2004 12/29/2017 12/31/2018 1849.34 1739.67 12/31/2019 1974.62 12/31/2020 2016.7 12/31/2021 2456.08 12/30/2022 2267.98 417.09 479.63 435.71 516.18 466.45 568.2 459.27 575.7 615.93 792.04 740.74 973.9 970.43 1298.82 1229.23 1670.01 1469.25 2021.4 1320.28 1837.37 1618.98 1261.18 1622.94 1799.55 1148.08 879.82 1111.92 1211.92 1248.29 1418.3 1468.36 903.25 1115.1 1257.64 1257.61 1426.19 1848.36 2058.9 2043.94 2238.83 2673.61 2506.85 SP500 TR 3230.78 3756.07 4766.18 3839.5 1887.94 2186.13 2306.23 1452.98 1837.5 2114.29 2158.94 2504.44 3315.59 3769.44 3821.6 4278.66 5212.76 4984.22 6553.57 7759.35 9986.7 8178.02
Expert Answer:
Answer rating: 100% (QA)
Sample Estimators for Monthly Returns Index ER SDR SkewR KurtR Put Selling 092 478 057 534 SP 500 0... View the full answer
Related Book For
Managerial Economics
ISBN: 978-0133020267
7th edition
Authors: Paul Keat, Philip K Young, Steve Erfle
Posted Date:
Students also viewed these finance questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Investor's Report Objectives: You will conduct financial statement analysis of two comparable companies and provide recommendations about the financial position about each for two investors. Select...
-
Jessica Kimble and Carlos Segura form a partnership by combining assets of their former businesses. The following balance sheet information is provided by Kimble, sole proprietorship: Kimble obtained...
-
Factor completely: 2x-4x+10x-20 Factor completely: -2x-8x3+1 10.x
-
The tapered rod has a radius of r = (2 x/6) in. and is subjected to the distributed loading of w = (60 + 40x) lb/in. Determine the average normal stress at the center of the rod, B. w= (60+40x)...
-
Carr, Inc., has the following plant asset accounts: Land, Buildings, and Equipment, with a separate accumulated depreciation account for each of these except land. Carr completed the following...
-
Google AI, formerly known as Google Research, is Google's artificial intelligence (AI) research and development branch for its AI applications. One of the numerous offshoots from Google AI is its...
-
Financial information for Buckle is presented in Appendix B at the end of the book. Required: 1. Determine the amounts Buckle reports for total assets, total liabilities, and total stockholders...
-
Mildred is a single person who is a 25 percent owner of a local business that operates using the name Four Rivers. The business reports $500,000 of taxable business income for the year 2020. Assume...
-
There are various guidelines on sustainability that companies can use to report on CSR. Discuss.
-
The following information is available for World Wide Corporation's operating subsidiaries throughout the world, in thousands of Canadian dollars: Required: Determine which regions you would suggest...
-
What are sustainability issues?
-
What is the distinction between social shopping and social commerce?
-
An e-mail requesting sign-up for a leadership seminar on mediation: a. Organization leaders are responsible for creating a work environment that enables people to thrive. If turf wars, disagreements,...
-
Your bank offers you a personal loan of $14,000.00 at an interest rate of 4.3% compounded quarterly. At the end of the term, interest of $4,290.34 was charged on the loan. Calculate the term of this...
-
You purchase a bond with a coupon rate of 6.7 percent, a par value $1,000, and a clean price of $905. Assume a par value of $1,000. If the next semiannual coupon payment is due in two months, what is...
-
Manhattan was allegedly purchased from Native Americans in 1626 for $24. If the sellers had invested this sum at a 6 percent interest rate compounded semiannually, how much would it amount to today?
-
Briefly discuss the Coase theorem. What does this theory imply about the role of government in dealing with market externalities?
-
What is the identification problem? What effect will this problem have on the regression estimates of a demand function? Explain.
-
If the liquid has a high thermal conductivity, the heat transfer coefficient depends on \(\mathrm{Pr}^{1 / 2}\). What is the root cause of the increase dependence on \(\mathrm{Pr}\) ?
-
The boundary layer analysis performed in Section 12.6.1 assumed that the fluid was flowing over a stationary plate. However, there is no reason why the fluid cannot be quiescent while the plate moves...
-
At high mass transfer rates, the mass transfer coefficient depends on both the magnitude and direction of mass transfer. Why?
Study smarter with the SolutionInn App