Question: Spreadsheet Assignment Values for the S&P/ TSX composite index between October 31, 2018 and November 1, 2020 can be obtained in trading room. Calculate the

Spreadsheet Assignment

Values for the S&P/ TSX composite index between October 31, 2018 and November 1, 2020 can be obtained in trading room. Calculate the 1-day 99% VaR on November 2, 2020, for a $10 million portfolio invested in the index using (a) the basic historical simulation approach, (b) the exponential weighting scheme with =0.997. Discuss the reasons for the differences between the results you get. (c) the extreme value theory where u is set to equal to the 95th percentile of the empirical distribution of the TSX index. (d) Conduct back testing by using the data of the S&P/TSX composite index between October 31, 2017 and October 30, 2018.

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!

Values for the S&P/ TSX composite index between October 31, 2018 and November 1, 2020 can be obtained in trading room. Calculate the 1-day 99% VaR on November 2, 2020, for a $10 million portfolio...

Values for the S&P/ TSX composite index between October 31, 2018 and November 1, 2020 can be obtained on Yahoo finance, https://finance.yahoo.com/quote/%5EGSPTSE/history/ using the closing price....

Values for the S&P/ TSX composite index between October 31, 2018 and November 1, 2020 can be obtained ion Yahoo Finance, I can't attach a link unfortunately with the data. Calculate the 1-day 99% VaR...

Resources:Appendix A: The Home Depot, Inc. Annual Report inFundamentals of Financial Accounting Writea 1,050- to 1,750-word paper in which you answer the following questions: What does the...

Resources:Appendix A, The Home Depot, Inc. Annual Report inFundamentals of Financial Accounting Writea 1,050- to 1,750-word paper in which you address the following:...

HELP!! I don't think the tutor answered did this assignment properly and I am way behind on my other assignments. Can someone please help me? Writea 1,050- to 1,750-word paper in which you address...

Hello, solving the Rhone Poulenc Rorer case implies usually the use of montecarlo smulation to valuate the CVR. However the professor said to use only Black and Scholes and Binomial combined. I know...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Give the structures, including stereochemistry, of compounds A and B in the following sequence of reactions: pyrndine LiBT SO,CI > compound B CH3)C

Roofing Issues. Sally agrees to roof a house for Bob. After doing his research, Bob chooses Sally based on her great reputation for being conscientious and doing good work. Bob knows little about...

assume that all variables ( i . e . revenue, costs, income, assets, etc. ) will grow by the same percentage. Due to the assumed growth in income, debt plus equity does sum up to total assets because...

A job transfer should never be used as a disciplinary measure. Question 1 0 3 options: TRUE FALSE

Which conflict management style (Chapter 6) did Beth and Latoya use in setting the policy? Which conflict management style would you have used if you were in Latoyas situation?

(a) Should Ted Brown have spoken up in defense of Latoya during the meeting? (b) If you were Ted, would you have taken Latoyas side against the seven other members? (c) Would your answer change if...

If you were Latoya and Beth drafted a policy and department members agreed with it, what would you do? (a) Would you appeal the decision to the dean? (b) Again, would your answer change if you had...