Calculate summary statistics of monthly returns on INSUR using historical data from January 2016 to December 2020 Details on INSUR INSUR is an exotic insurance product that aims to help investors manage its exposure to market risk. This product requires policyholders (i.e., buyers of INSUR) to pay insurance premium (i.e., purchasing price of INSUR) at the beginning of the calendar month. INSUR matures at the end of the month and makes payment (if any) to policyholders according to the performance of the S&P 500 Index in that month. If (1) the return on the S&P 500 Index is negative and (2) the monthly standard deviation of return on S&P 500 exceeds 0.025, INSUR will reimburse the insurance premium paid at the beginning of the month and provide additional compensation to its policyholders. The additional compensation amount is the product of the following two components: (1) 150 times the insurance premium, and (2) the monthly standard deviation on the S&P 500 return in excess of 0.025. If the return on S&P 500 is positive or if the monthly standard deviation does not exceed 0.025, INSUR does not make any payment at the end of the month and the policyholder loses all her investment. That is, the monthly return of holding INSUR is (-100% if rt ≥ 0 or at s 0.025 (or -0.025) x 15000% if rt <0 and ot> 0.025, where rt is the return on the S&P 500 Index for month t,\sigma_t()is the monthly (non-annualized) standard deviation of return on S&P 500. or 2 is estimated using the Exponentially Weighted Moving Average (EWMA) method with a decay factor of 0.85 and historical monthly return prior to month t (i.e., rt is not used to estimate\sigma_t()). As an example, suppose an investor holds INSUR in January 2022. Also assume that the monthly return on S&P 500 for the month is -0.6%, and the monthly standard deviation of return on S&P 500 is 0.0415, calculated using historical data until December 2021. In this case, this investor's monthly return for holding INSUR is 15,000 % × (0.0415 -0.025) = 247.5%. from the given information, how is the INSUR calculated, please provide excel formula?

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
Please answer fast I will rate for you sure please give typed answer.....
Calculate summary statistics of monthly
returns on INSUR using historical data from
January 2016 to December 2020
Details on INSUR INSUR is an exotic insurance
product that aims to help investors manage its
exposure to market risk. This product requires
policyholders (i.e., buyers of INSUR) to pay
insurance premium (i.e., purchasing price of
INSUR) at the beginning of the calendar
month. INSUR matures at the end of the
month and makes payment (if any) to
policyholders according to the performance
of the S&P 500 Index in that month. If (1) the
return on the S&P 500 Index is negative and
(2) the monthly standard deviation of return
on S&P 500 exceeds 0.025, INSUR will
reimburse the insurance premium paid at the
beginning of the month and provide
additional compensation to its policyholders.
The additional compensation amount is the
product of the following two components: (1)
150 times the insurance premium, and (2) the
monthly standard deviation on the S&P 500
return in excess of 0.025. If the return on S&P
500 is positive or if the monthly standard
deviation does not exceed 0.025, INSUR does
not make any payment at the end of the
month and the policyholder loses all her
investment. That is, the monthly return of
holding INSUR is ( -100% if rt 20 or ot s
0.025 (ot-0.025) x 15000% if rt < 0 and ot>
0.025, where it is the return on the S&P 500
Index for month t,\sigma_t()is the monthly
(non-annualized) standard deviation of return
on S&P 500. ot 2 is estimated using the
Exponentially Weighted Moving Average
(EWMA) method with a decay factor of 0.85
and historical monthly return prior to month t
(i.e., rt is not used to estimate\sigma_t{}). As
an example, suppose an investor holds INSUR
in January 2022. Also assume that the
monthly return on S&P 500 for the month is
-0.6%, and the monthly standard deviation of
return on S&P 500 is 0.0415, calculated using
historical data until December 2021. In this
case, this investor's monthly return for holding
INSUR is 15,000% x (0.0415 -0.025) =
247.5%.
from the given information, how is the INSUR
calculated. please provide excel formula?
Transcribed Image Text:Calculate summary statistics of monthly returns on INSUR using historical data from January 2016 to December 2020 Details on INSUR INSUR is an exotic insurance product that aims to help investors manage its exposure to market risk. This product requires policyholders (i.e., buyers of INSUR) to pay insurance premium (i.e., purchasing price of INSUR) at the beginning of the calendar month. INSUR matures at the end of the month and makes payment (if any) to policyholders according to the performance of the S&P 500 Index in that month. If (1) the return on the S&P 500 Index is negative and (2) the monthly standard deviation of return on S&P 500 exceeds 0.025, INSUR will reimburse the insurance premium paid at the beginning of the month and provide additional compensation to its policyholders. The additional compensation amount is the product of the following two components: (1) 150 times the insurance premium, and (2) the monthly standard deviation on the S&P 500 return in excess of 0.025. If the return on S&P 500 is positive or if the monthly standard deviation does not exceed 0.025, INSUR does not make any payment at the end of the month and the policyholder loses all her investment. That is, the monthly return of holding INSUR is ( -100% if rt 20 or ot s 0.025 (ot-0.025) x 15000% if rt < 0 and ot> 0.025, where it is the return on the S&P 500 Index for month t,\sigma_t()is the monthly (non-annualized) standard deviation of return on S&P 500. ot 2 is estimated using the Exponentially Weighted Moving Average (EWMA) method with a decay factor of 0.85 and historical monthly return prior to month t (i.e., rt is not used to estimate\sigma_t{}). As an example, suppose an investor holds INSUR in January 2022. Also assume that the monthly return on S&P 500 for the month is -0.6%, and the monthly standard deviation of return on S&P 500 is 0.0415, calculated using historical data until December 2021. In this case, this investor's monthly return for holding INSUR is 15,000% x (0.0415 -0.025) = 247.5%. from the given information, how is the INSUR calculated. please provide excel formula?
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Bond
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education