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 the scope and boundaries for the plan. Research and summarize RA approaches. Identify the key roles and responsibilities of individuals and departments within the organ
BSBRSK401 - Identify risk and apply risk management processes Review the scenario information contained in the Appendices of this assessment task and identify the internal and
1. What are the two reasons liquidity risk arises? How does liquidity risk arising from the liability side of the balance sheet differ from liquidity risk arising from the ass
Explain how the main tenets of the Markowitz Portfolio Theorem are applied in credit risk management. What are the limitations of applying Modern Portfolio Theory (MPT), esp
Prepare a 1-2 page Word document as a summary that expands on the slides and any other talking points. In a business setting this would be a handout to the staff members pre
Company A offer 30,000 the first year. During the next four years, the salary is guaranteeed to increase by 6% per year. Company B offers 32,000 the first year, with guarant
Play the Social Security Game (links to an external site) to solve the Social Security problem. Detail your choices, noting the why's of your choices and also discuss the ef
List at least four sources you will use to obtain information about the firms strength, weakness, opportunities, and threats. Discuss what categories of the SWOT elements of