Deliverable 7 - Senior Risk Analyst PresentationCompetenciesConstruct a framework for identifying, evaluating, and categorizing risk and risk management tools.Appraise the relationship between a heightened regulatory environment and corporate governance.Evaluate the components of operational risk and the application of corresponding risk management plans.Evaluate the principles of risk and reward in the investment sector and its applications to the broader area of risk management.ScenarioLTD Acceptance is a private property and auto insurance carrier that specializes in sports cars and motorcycles. This organization is owned by LTD Capital, a large equity group with over 15 holdings. LTD Acceptance is the parent company's single largest holding as it drives 70% of total revenue. Due to the inherent risk involved in that segment of the market, many of LTD Acceptance's competitors do not offer policies for sports cars or motorcycles. This market segment is underserved which is why the organization has 20,000 active policies for a sports car or a motorcycle.LTD is headquartered in Houston, TX. LTD does not sell insurance directly to the public. Instead, it uses third-party agents to sell its policies. LTD handles all customer service needs including claims intake, policy services, and general questions. The company operates in four states: California, Texas, Louisiana, and Florida. Currently, LTD does not have an active system in place to ensure that its agents are in fact using LTD guidelines to screen potential policyholders. However, no evidence of negligence has emerged so far as the organization has yet to have a year in which it was not profitable. LTD has also had the good fortune of not suffering losses because of natural disasters or catastrophic events.InstructionsYou have been hired for the role of Senior Risk Analyst. This means that you are responsible for overseeing and managing the organization's all risk management activities. Before you can design a plan to manage risks, your first task is to identify the primary risk exposures the organization should acknowledge. The organization is also concerned about threats to its operational efficacy. Therefore, you need to also identify operational risk exposures and explain why operational losses must be categorized. The board is also seeking your input on the relationship between risk and reward and how it pertains to the company's investment portfolio. Your supervisor has asked you to create a PowerPoint presentation of your report. Remember your audience when crafting your presentation, and include the following slides:Title slideEvaluate the significance of identifying risks and address the ramifications of failing to do so.Identify two insurance regulations and analyze their roles in managing risks within the insurance industry.Identify the market, business, and compliance risks LTD encounters.Explain why the operational losses cannot be broadly managed. Why do they have to be categorized?Examine the relationship between risk and reward and how it pertains to investing.Explain why effective financial management correlates with risk management.Your conclusion slide should include at least three risk management activities relevant to insurance (and your rationale for choosing them specifically) and how they link to enhanced organizational effectiveness.Grading RubricFFCBA01234Not SubmittedNo PassCompetenceProficiencyMasteryNot SubmittedAt least one slide requirement is missing.All required slides are included.All required slides are included, along with any supporting explanations or examples.All required slides are included, along with any supporting explanations or examples and are professionally presented.Not SubmittedInaccurate discussion on the importance of identifying risks is included OR no discussion on the importance of identifying risks is included OR appropriate consequences of failing to identify risks are not included.Accurate discussion on the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are included.Accurate discussion that utilizes specific examples of the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are included.Thorough and accurate discussion that utilizes specific examples of the importance of identifying risks is included AND appropriate consequences of failing to identify each risk mentioned are fully explained.Not SubmittedLess than two insurance regulations are accurately analyzed in their role in managing risk in the insurance industry.Two insurance regulations (laws or acts) are accurately analyzed in their role in managing risk in the insurance industry.Two insurance regulations (laws or acts) are thoroughly and accurately analyzed in their role in managing risk in the insurance industry.More than two insurance regulations (laws or acts) are thoroughly and accurately analyzed in their role in managing risk in the insurance industry.Not SubmittedNo valid risks are identified for at least one area (market, compliance, and business).At least one valid risk relevant to LTD is identified for each area (market, compliance, and business).At least one valid risk relevant to LTD is identified and explained for each area (market, compliance, and business).More than one valid risk relevant to LTD is identified and explained for each area (market, compliance, and business).Not SubmittedInaccurate discussion of why operational losses must be categorized is included OR no discussion of why operational losses must be categorized is included.Accurate discussion of why operational losses must be categorized is included.Accurate explanation that utilizes specific examples of why operational losses must be categorized is included.Thorough and accurate explanations that utilize specific examples of why operational losses must be categorized are included.Not SubmittedInaccurate discussion of how the relationship between risk and reward relates to investing is included OR no discussion of how the relationship between risk and reward relates to investing is included.Accurate discussion of how the relationship between risk and reward relates to investing.Accurate explanation that utilizes specific examples of how the relationship between risk and reward relates to investing.Thorough and accurate explanations that utilize specific examples of how the relationship between risk and reward relates to investingNot SubmittedInaccurate discussion that utilizes specific examples to explain how effective financial management correlates with risk management OR no discussion to explain how effective financial management correlates with risk management.Accurate discussion of how effective financial management correlates with risk management.Accurate explanation that utilizes specific examples to examine how effective financial management correlates with risk management.Thorough and accurate explanations that utilize specific examples to examine how effective financial management correlates with risk management.Not SubmittedConclusion slide(s) does not summarize at least three pertinent risk management activities OR does not describe how at least one affects organizational effectiveness.Conclusion slide(s) summarizes at least three pertinent risk management activities AND describes how each affects organizational effectiveness. Includes rationale for selection.Conclusion slide(s) thoroughly summarizes the details of at least three pertinent risk management activities AND explains how each affects organizational effectiveness. Includes rationale for selection.Conclusion slide(s) thoroughly summarizes the details of more than three pertinent risk management activities AND provides deep and meaningful insight on how each affects organizational effectiveness. Includes rationale for selection

Please see attachment for questions. Pick 11 questions and answer.  Please Post the excel file that shows your calculations.  If you chose a problem that requires Crystal Ball, please post the file that includes your assumptions, forecast and the results of your simulations as well as a picture of the forcast chart. Also please post any MS Project file you used to answer a question.