Complete the risk determination worksheets
Course:- Risk Management
Reference No.:- EM132257410

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Risk Management

Risk Determination & Decision Tree Analysis

1. Review Module-5 Lecture Notes and Chapter Readings

2. Use the Risk Determination Excel Workbook and complete the following worksheets:
a. Corporate Assets Risk Summary - Tab
i. Use the Reference Tab in the workbook to select the appropriate values from the respective tables and complete Columns C, D, E, F, & G (Hint: use the Threat Vulnerability Reference Table; return the numerical value for the corresponding probability and impact).

Threat Vulnerability Work Table



















ii. Column H (Risk Score) is a calculated field already formatted
iii. Column I (Possible Safeguards) provide the safeguards you would put in place to mitigate the threat (e.g., controls, policies, etc.); provide sufficient level of detail
iv. Column J (Cost Estimates) provide cost estimates/ranges for the safeguards you would put in place to mitigate the threat; provide sufficient level of detail in the Comments Section Column K.
v. Provide thorough summary analysis of each section
b. Occupation Analysis - Tab
i. Use the Risk Level Table provided on worksheet (Cells B25-C31) to assign the appropriate value for each occupation and the corresponding threats outlined in Columns C,D,E,& F
ii. Column G (Total) is a calculated filed already formatted
iii. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment; provide sufficient level of detail in your responses.
c. Decision Tree Analysis - Tab
i. Examine the Decision Tree Analysis for enterprise CRM solution approach
ii. Complete the corresponding tables for both paths and individual branches referencing the values in the decision tree diagram.
iii. Some of the data is already populated
iv. Total fields, Branch Total fields, and Value Fields are calculated fields and are already formatted
v. Answer the question regarding which options provides the best overall value
vi. Explain your reasoning for the choice you made, response should be based on your analysis of the decision tree results.
vii. Hint: Only one of the value fields should have a negative value when finished

3. Complete the Risk Determination Worksheets (M.S. Excel Document not PDF).

Attachment:- Risk Determination Worksheet.rar

Put your comment
View Conversion
  1. user image

    Please read guidelines in the attached document and proceed accordingly. upload the file using the designated link on Moodle on or before the assignment due date. Review Module-5 Lecture Notes and Chapter Readings

Ask Question & Get Answers from Experts
Browse some more (Risk Management) Materials
Define in detail the communication approach (audiences, frequencies, mechanisms, and exceptions) you will take to share risk updates. Discuss the risks with the vendor that y
Seger, Inc., is an unlevered firm with expected annual earnings before taxes of $21 million in perpetuity. The current required return on the firm’s equity is 16 percent, and
Maxwell Mining Company's ore reserves are being depleted, so its sales are falling. Also, because its pit is getting deeper each year, its costs are rising. As a result, the c
Russia suffered a currency and stock market crisis in 1998 that drove the dollar value of Russian stocks down to 10 percent of their pre-crash value. Is the risk of a market
During the race, he slips on some gravel when going down a hill at 50 miles per hour and is thrown from his bike. His bike helmet cracks and he has serious head injuries. If
How would you define and describe a risk management system? How would a risk management system differ for a bank/investment firm compared to a construction firm that has high
Using the matrix that is located in the additional Phase Resources and your analysis, conduct a notional risk analysis of your county courthouse or another government buildi
Hypothetical Bank Ltd's credit portfolio comprises only two customers. Explain how the credit portfolio approach is reflected in the calculation of regulatory and economic cap