Suppose you are a risk analyst working for M&T Bank and you are asked to estimate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose you are a risk analyst working for M&T Bank and you are asked to estimate potential operational risk losses for a particular risk type/business line combination. Combining the seven categories of risk with the eight business lines gives a total of 7 x 8 - 56 potential sources of operational risk for the bank. To improve the work efficiency, every analyst in the team is working on a different combination (see the Excel spreadsheet titled: "OTC Excel file Part C Q2 - Assignment for Risk Type Business Line Combination" to find out the combination assigned to you). Your task is to use Monte Carlo simulation to simulate the operational risk loss distribution. You have been given some relevant information as shown in the spreadsheet. Details of the columns are shown as follows: Risk Analyst ID: That is the same as your NTU Student ID. You should choose the risk type/business line combination that is assigned to you. Risk type/business line combination No.: The identifier for a particular risk type/business line combination. Number of years of Data recorded: The length of data available for the particular risk type/business combination. Different combinations have different length of data available. E.g., if the number is 100, it should read 100 years. Total number of losses: The total number of operation loss events that happened during the available data period. . Mean of logarithm of each loss: We assume a lognormal loss-severity distribution. This variable records the mean. The unit is in million $. To simplify our calculation, the mean is set to zero across all the combinations. .SD of logarithm of each loss: We assume a lognormal loss-severity distribution. This variable records the standard deviation. This variable records the standard deviation of the logarithm of the loss. The unit is in million $. E.g., if the number is 0.14, it should read $140,000. REQUIRED: (a) Critically discuss the advantages and limitations of the Monte Carlo simulation method. (4 marks) (b) Using the Poisson distribution for the risk loss frequency distribution. Let the parameter 2 be the mean and variance of the Poisson distribution. Calculate for the loss frequency distribution for your assigned combination. (2 marks) PART C [Continued] Question 2 [Continued] (c) In Monte Carlo simulation, we need to select the total number of counters . We choose the total number of counters it so that the cumulative probability of more than losses in a year is smaller than 0.001. Calculate the smallest n. (2 marks) (d) Perform the Monte Carlo simulation to estimate the Probability risk loss distribution in an Excel spreadsheet. The requirements for the Monte-Carlo Model are as follows: You should note down details about your assigned risk type/business line combination. Suppose you are a risk analyst working for M&T Bank and you are asked to estimate potential operational risk losses for a particular risk type/business line combination. Combining the seven categories of risk with the eight business lines gives a total of 7 x 8 - 56 potential sources of operational risk for the bank. To improve the work efficiency, every analyst in the team is working on a different combination (see the Excel spreadsheet titled: "OTC Excel file Part C Q2 - Assignment for Risk Type Business Line Combination" to find out the combination assigned to you). Your task is to use Monte Carlo simulation to simulate the operational risk loss distribution. You have been given some relevant information as shown in the spreadsheet. Details of the columns are shown as follows: Risk Analyst ID: That is the same as your NTU Student ID. You should choose the risk type/business line combination that is assigned to you. Risk type/business line combination No.: The identifier for a particular risk type/business line combination. Number of years of Data recorded: The length of data available for the particular risk type/business combination. Different combinations have different length of data available. E.g., if the number is 100, it should read 100 years. Total number of losses: The total number of operation loss events that happened during the available data period. . Mean of logarithm of each loss: We assume a lognormal loss-severity distribution. This variable records the mean. The unit is in million $. To simplify our calculation, the mean is set to zero across all the combinations. .SD of logarithm of each loss: We assume a lognormal loss-severity distribution. This variable records the standard deviation. This variable records the standard deviation of the logarithm of the loss. The unit is in million $. E.g., if the number is 0.14, it should read $140,000. REQUIRED: (a) Critically discuss the advantages and limitations of the Monte Carlo simulation method. (4 marks) (b) Using the Poisson distribution for the risk loss frequency distribution. Let the parameter 2 be the mean and variance of the Poisson distribution. Calculate for the loss frequency distribution for your assigned combination. (2 marks) PART C [Continued] Question 2 [Continued] (c) In Monte Carlo simulation, we need to select the total number of counters . We choose the total number of counters it so that the cumulative probability of more than losses in a year is smaller than 0.001. Calculate the smallest n. (2 marks) (d) Perform the Monte Carlo simulation to estimate the Probability risk loss distribution in an Excel spreadsheet. The requirements for the Monte-Carlo Model are as follows: You should note down details about your assigned risk type/business line combination.
Expert Answer:
Related Book For
Systems Analysis and Design
ISBN: 978-1285171340
10th edition
Authors: Shelly Cashman, Harry J. Rosenblatt
Posted Date:
Students also viewed these finance questions
-
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...
-
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...
-
Shortly after Murray began working in the tax department of the public accounting firm of Dewey, Cheatham, and Howe, he was preparing a tax return and discovered an error in last year's work papers....
-
For each of the following job responsibilities, identify the area of accounting (private accounting, public accounting, or both) that is most involved. ___ 1. Preparing financial statements for...
-
Find an equation of the following parabolas, assuming the vertex is at the origin. A parabola symmetric about the x-axis that passes through the point (1, -4)
-
In February 2014, defendant Ibrahim M. Shihadeh, d/b/a Creative Designs Kitchen and Baths, agreed to purchase 25% of his anticipated natural gas needs at a fixed price for the 201415 and 201516...
-
The Sudbury, South Carolina, plant of Saldanha Sports Company has the following standards for its soccer ball production: RequiredDetermine the following variances for October:(a) Total direct...
-
Pinehurst Company was formed in Year 1 and experienced the following accounting events during the year: 1. Issued common stock for $18,400 cash. 2. Earned cash revenue of $26,100. 3. Paid cash...
-
The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral. The company wants to run TV ads promoting its cruises to high-income men, high-income women, and retirees. The...
-
III. Ordinary least squares regression In the multiple regression setting, y is a Ixn vector of observations on the dependent variable. X is an nx(m+1) matrix of the observations of the independent...
-
Calculate two NPVs for the project at two different costs of capital. One NPV must be negative, and another one is positive. 2. Using the following formula to find the IRR: IRR = L + where: L =...
-
a) How many bits would be required if one wishes to code each of the seven days of a week with a binary number. b) How many bits would be required if one wishes to code all upper-case letters plus...
-
A cube made of aluminum 2 4 x1o -6 has sides of 5 . 0 0 0 0 cm , and it is subjected to a temperature change of + 5 0 0 C ? 1 . What will this temperature change be on the Kelvin scale? 2 . What is...
-
BCD Fund Ltd("Fund") was launched on 09/01/2020 and has two types of investors in the Fund, Class 2020 investors who pay management fees at 2% of commitment per annum and the new class 2021 where...
-
On an imaginary temperature scale, 1 0 0 0 C corresponds to 2 5 6 degrees and 0 0 C to 1 1 degrees. Convert 1 3 3 degrees on this scale to 0 C .
-
Find the number of cars in line at 6:10 a.m. Remember the drive-thru line has been open for ten min. An integral must be written. Find the length of the drive-thru line at 6:20 a.m. An integral must...
-
Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1
-
How would you plan an Internet research strategy?
-
What is Camtasia and why would you use it? What is the Windows Snipping Tool and why would you use it?
-
What strategies are Wal-Mart and Lowes using to gain more online customers?
-
The following unadjusted trial balance was taken from the ledger of Mirandas Management Services on 30 June 2019. Required (a) Prepare a 10column worksheet using the following additional information...
-
The adjusted trial balance columns in the worksheet of Elliot Painting Services are as follows. Required (a) Complete the worksheet. (b) Prepare the closing entries necessary at 30 June 2019,...
-
Michael Rau founded Michaels Fishing Supplies on 1 July 2019. The adjusted trial balance at 30 June 2020 (the end of the financial year) is shown below. Required (a) Prepare closing entries to be...
Study smarter with the SolutionInn App