Question 5 (45 points, solve questions with Excel and then submit your file via Brightspace) The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 5 (45 points, solve questions with Excel and then submit your file via Brightspace) The S&P/TSX Composite Index is the benchmark Canadian stock market index, representing about 77% of the total market capitalization on the Toronto Stock Exchange as of August 2022. It provides investors with a premier gauge regarding Canadian equity market performance. The index is also an investable portfolio for individual investors through mutual funds and exchange-traded funds (ETF) that track it. Suppose an investor invested $30,000 in an ETF that tracks the S&P/TSX Composite Index. She wants to know the maximum potential daily loss in the worst scenarios with a 95% confidence level. In other words, she needs to know the daily return at the 5% percentile of her daily return distribution, which is the VaR. A 5% VaR defines that 95% of returns will exceed the VaR and 5% below the VaR. She reached out to you to help predict the loss. You downloaded index data for the S&P/TSX Composite Index from Yahoo finance from January 1, 2020, to January 31, 2023. (1) (10 points) Compute the VaR values at the 5% percentile using historical data. (2) (10 points) Assuming the daily returns of S&P/TSX Composite Index are normally distributed, re-computing the 5% VaR. (3) (5 points) What is the 10% expected shortfall? (4) (10 points) Compute the lower partial standard deviation. (5) (10 points) Are the daily returns of the index normally distributed? Using Histogram to describe the data distribution. Hints: you need to compute the skewness and kurtosis of the returns and compare them with the values of a standard normal distribution. Hint: the daily index return is computed by r = In, where P and Po are prices of consecutive Po days when the market closed. That is, we assume stock returns are distributed normally, and stock prices are distributed log-normally. You need to use three years of data to compute the mean and daily volatility. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2222782 23 24 25 26 29 Date A B Open High 17100 17100 17033.2 17066.1 17066.1 17041.2 17105.5 17105.5 17110.3 17168.1 17168.1 02/01/2020 17131.6 17164.6 17043.5 03/01/2020 17054.8 17105.7 06/01/2020 17042.3 17105.5 07/01/2020 17119.6 17178 08/01/2020 17172.7 17229.9 17164.6 17167.8 17167.8 09/01/2020 17205.9 17255.5 17201.3 17235.6 17235.6 10/01/2020 17223.2 17254.1 17187.2 17234.5 17234.5 13/01/2020 17237.6 17301.8 17198.9 17293.4 17293.4 14/01/2020 17288.6 17356.5 17281.3 17352.9 17352.9 17364.8 17421.7 17345.1 17415.2 17415.2 17443.5 17489.6 17438.5 17484.8 17484.8 17502.4 17559 17559 15/01/2020 16/01/2020 17/01/2020 17507.7 20/01/2020 17548.1 17572.2 17620.2 17538.4 17597.4 17597.4 21/01/2020 17551.5 17572.3 17572.3 17589.5 17536.3 17666.5 22/01/2020 17570.3 17558 17599.9 17599.9 23/01/2020 17564.8 17621.8 17540.8 17621.8 17621.8 24/01/2020 17629.4 17646.4 17514.7 17565.3 17565.3 27/01/2020 17376.8 17466.1 17360 17442.5 17442.5 28/01/2020 17475 17519 17500.9 17500.9 17456.1 17496.7 17511.8 17511.8 29/01/2020 17547.5 17561.9 30/01/2020 17429.6 17502.9 17395.9 17490.6 17490.6 17442.3 17450.7 17272.7 17318.5 17318.5 17441.6 17351 17379.8 17379.8 04/02/2020 17548.8 17493.8 17512.7 17512.7 31/01/2020 03/02/2020 17351 17504.6 05/02/2020 17629.4 17674 17606.1 17651.6 17651.6 06/02/2020 17686.1 17758.5 17670.6 17757.5 17757.5 07/02/2020 17705.4 17716.7 17633 17655.5 10/02/2020 17646.6 17743.6 17646.6 17740.6 17740.6 17655.5 ^GSPTSE (1) Low D E Close F Adj Close Volume G 156213500 185492100 195351800 171935800 246980100 222501200 192514100 268086800 235495600 207645200 261420600 224673300 111821100 241563100 213329700 330914300 193689100 203774000 198139800 169412800 191070300 239157000 196331500 235045300 223399700 199327500 209827800 210735600 H Question 5 (45 points, solve questions with Excel and then submit your file via Brightspace) The S&P/TSX Composite Index is the benchmark Canadian stock market index, representing about 77% of the total market capitalization on the Toronto Stock Exchange as of August 2022. It provides investors with a premier gauge regarding Canadian equity market performance. The index is also an investable portfolio for individual investors through mutual funds and exchange-traded funds (ETF) that track it. Suppose an investor invested $30,000 in an ETF that tracks the S&P/TSX Composite Index. She wants to know the maximum potential daily loss in the worst scenarios with a 95% confidence level. In other words, she needs to know the daily return at the 5% percentile of her daily return distribution, which is the VaR. A 5% VaR defines that 95% of returns will exceed the VaR and 5% below the VaR. She reached out to you to help predict the loss. You downloaded index data for the S&P/TSX Composite Index from Yahoo finance from January 1, 2020, to January 31, 2023. (1) (10 points) Compute the VaR values at the 5% percentile using historical data. (2) (10 points) Assuming the daily returns of S&P/TSX Composite Index are normally distributed, re-computing the 5% VaR. (3) (5 points) What is the 10% expected shortfall? (4) (10 points) Compute the lower partial standard deviation. (5) (10 points) Are the daily returns of the index normally distributed? Using Histogram to describe the data distribution. Hints: you need to compute the skewness and kurtosis of the returns and compare them with the values of a standard normal distribution. Hint: the daily index return is computed by r = In, where P and Po are prices of consecutive Po days when the market closed. That is, we assume stock returns are distributed normally, and stock prices are distributed log-normally. You need to use three years of data to compute the mean and daily volatility. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2222782 23 24 25 26 29 Date A B Open High 17100 17100 17033.2 17066.1 17066.1 17041.2 17105.5 17105.5 17110.3 17168.1 17168.1 02/01/2020 17131.6 17164.6 17043.5 03/01/2020 17054.8 17105.7 06/01/2020 17042.3 17105.5 07/01/2020 17119.6 17178 08/01/2020 17172.7 17229.9 17164.6 17167.8 17167.8 09/01/2020 17205.9 17255.5 17201.3 17235.6 17235.6 10/01/2020 17223.2 17254.1 17187.2 17234.5 17234.5 13/01/2020 17237.6 17301.8 17198.9 17293.4 17293.4 14/01/2020 17288.6 17356.5 17281.3 17352.9 17352.9 17364.8 17421.7 17345.1 17415.2 17415.2 17443.5 17489.6 17438.5 17484.8 17484.8 17502.4 17559 17559 15/01/2020 16/01/2020 17/01/2020 17507.7 20/01/2020 17548.1 17572.2 17620.2 17538.4 17597.4 17597.4 21/01/2020 17551.5 17572.3 17572.3 17589.5 17536.3 17666.5 22/01/2020 17570.3 17558 17599.9 17599.9 23/01/2020 17564.8 17621.8 17540.8 17621.8 17621.8 24/01/2020 17629.4 17646.4 17514.7 17565.3 17565.3 27/01/2020 17376.8 17466.1 17360 17442.5 17442.5 28/01/2020 17475 17519 17500.9 17500.9 17456.1 17496.7 17511.8 17511.8 29/01/2020 17547.5 17561.9 30/01/2020 17429.6 17502.9 17395.9 17490.6 17490.6 17442.3 17450.7 17272.7 17318.5 17318.5 17441.6 17351 17379.8 17379.8 04/02/2020 17548.8 17493.8 17512.7 17512.7 31/01/2020 03/02/2020 17351 17504.6 05/02/2020 17629.4 17674 17606.1 17651.6 17651.6 06/02/2020 17686.1 17758.5 17670.6 17757.5 17757.5 07/02/2020 17705.4 17716.7 17633 17655.5 10/02/2020 17646.6 17743.6 17646.6 17740.6 17740.6 17655.5 ^GSPTSE (1) Low D E Close F Adj Close Volume G 156213500 185492100 195351800 171935800 246980100 222501200 192514100 268086800 235495600 207645200 261420600 224673300 111821100 241563100 213329700 330914300 193689100 203774000 198139800 169412800 191070300 239157000 196331500 235045300 223399700 199327500 209827800 210735600 H
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To compute the VaR values at the 5 percentile we can use the following steps 1 Calculate th... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
Susan Norman seeks your financial advice. She wants to know how long it will take for her to become a millionaire. She tells you that she has $1,330 today and wants to invest it in an aggressive...
-
Jannie is your first client. She wants to know about some tax-related provisions and practices. She asks some questions - what are the legal provision related to Taxable income, Medicare levy, and...
-
She wants to know the average performance score for entry level employees (job level 1) that work at the california location. Which formula should she use? Assume there that the dataset she is...
-
You want to short a 6-month forward contract on a stock. You contacted your bank and were offered a forward price of $39.85 [Note: This forward price is available only to customers who want to take a...
-
A sporting goods retailer is running a monthly special, with snow skis and snowboards being priced to yield a negative contribution margin . What would motivate a retailer to do this?
-
Smith and Sons Inc. has a capital structure that consists of 40 percent debt, 10 percent preferred stock, and 50 percent common equity. The firm's bond YTM is 6 percent, cost of preferred stock is 8...
-
A hydraulic engineer wants to analyze steady flow in a rectangular channel featuring a hydraulic jump immediately downstream from a sluice gate that is open to a vertical clearance of \(3...
-
1. Is the pressure for Richard Branson to change Virgins business strategy coming from the internal or external environment? 2. In order to better compete with its rivals, should Virgin focus on a...
-
The length of nylon rope from which a mountain climber is suspended has a force constant of 1.5010 4 N/m. Given his mass plus the mass of his equipment are 87.6 kg, how much would this rope stretch...
-
The International Lodging Merger Role of AAA Hotels Executive Committee, discuss the major negotiation point between the two hotels and how to gain a result from the AAA Hotels point of view. How to...
-
A luxurious Asian cruise to Asia is the trip that I would like to introduce to my audience. They are mostly experiencers(primary) and innovators(secondary) who want everything and have international...
-
A girl with a mass of 40 kg is swinging from a rope with a length of 2.5 m. What is the frequency of her swinging?
-
Jane and her former partner, Maria, are in the process of moving out of their shared apartment following a mutually agreed break - up . They are actively attempting to split their shared resources...
-
Let P be a prime number. Prove that if a #p 0, ap-1 Ep 1.
-
Create a green city Discuss how your city will generate its energy. Will it use solar panels, wind turbines, or geothermal energy? How will these sources be integrated into the city's infrastructure?...
-
When would it be more advantageous for a firm to use more debt to finance its business? How might this affect the cost and riskiness of the business? How would we determine the cost of both debt and...
-
Cash flows for an investment is given as follows: 0 1 2 3 4 5 6 CF -$150.00 $25.00 $25.00 $60.00 -$30.00 $60.00 $25.00 There is one internal rate of return (IRR) for this investment, which is 6.49%....
-
What can you do to reduce hunger where you live? To reduce hunger globally?
-
In the Great Threads model, the production quantities in row 16 were not constrained to be integers. Presumably, any fractional values could be safely rounded to integers. See whether this is true....
-
The lifetime of a certain manufacturers washing machine is normally distributed with mean 4 years. Only 15% of all these washing machines last at least 5 years. What is the standard deviation of the...
-
Use @RISK to draw a uniform distribution from 400 to 750. Then answer the following questions. a. What are the mean and standard deviation of this distribution? b. What are the 5th and 95th...
-
Create a complete stable pattern by using the tips and heuristics provided in this chapter.
-
Develop the following systems using the fairness pattern: 1. Tax fairness: A tax platform based on an ideal that aims to create a system of taxation that is fair, clear, and equivalent for all...
-
BOs make this pattern stable and extendible. Do you agree?
Study smarter with the SolutionInn App