Assignment
Calculate ARO, ALE, and CBA
Learning Objective: Use existing conceptual frameworks to evaluate risk controls, and formulate a cost-benefit analysis.
Assignment Requirements
One year ago, the Mesusa Corporation conducted a threat evaluation and created a list of threats, the cost per incident and the projected frequency of occurrence. During the year, Mesusa decided to implement controls designed to reduce the cost per incidence and the number of threats. The spreadsheet, MesusaControls.xls, indicates the pre-control cost and frequency of occurrence, the cost of controls for each type of threat, and the post-control cost and frequency of occurrence. Calculate the AROs, the ALEs and the CBA for this initiative, and return the completed spreadsheet. You can use the websites linked above to help you out. Please include your name on your spreadsheet posted above before submission.
Submission Requirements
• Format: Microsoft Excel
• Font: Arial, 12-Point
• Help website to facilitate the work:
• https://www.windowsecurity.com/articles-tutorials/misc_network_security/Risk_Assessment_and_Threat_Identification.html
• https://www.pearsonitcertification.com/articles/article.aspx?p=728428&seqNum=4
INSTRUCTOR NOTES
ALE is a common quantitative method for assessing risk.
The first step in calculating ALE is to calculate Single Loss Expectancy (SLE). --> SLE = asset value * exposure factor
ALE is then calculated by multiplying SLE by Annualized Rate of Occurrence (ARO). --> ALE = SLE * ARO
For example, to calculate the exposure factor, assume the asset value of a small office building and its contents is $2 million. Also assume that this building houses the call center for a business, and the complete loss of the center would take away about half of the capability of the company. Therefore, the exposure factor is 50 percent. The SLE is $2 million * 0.5 = $1 million
The ALE is then calculated simply by multiplying the SLE by the number of times the event is expected to occur in a year, which is called the annualized rate of occurrence (ARO): --> ALE = SLE * ARO
Do NOT overthink ARO. If it is weekly, ARO is 52. If the event is expected to occur once in 20 years, then the ARO is 1/20. Typically the ARO is defined by historical data, either from a company's own experience or from industry surveys. Continuing our example, assume that a fire at this business's location is expected to occur about once in 20 years. Given this information, the ALE is: $1 million * 1/20 = $50,000.
Therefore, in order to protect the office building the company should spend no more than $50,000 on countermeasures protecting the building from complete loss.
•Office building and contents = $2 million
•Exposure factor 50%
•SLE = $2 million * 0.5 = $1 million
•ALE = SLE * ARO
•ARO = 1/20 (One occurrence every 20 years)
•ALE = $1 million * 1/20 = $50,000
Attachment:- Mesusacontrols.xls