Please explain the steps in Excel for the answers! thank you:)

An asset has a value of $100,000 . In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to %20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB.
An asset has a value of $100,000. In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to \%20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB. An asset has a value of $100,000. In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to \%20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB

Question

image text in transcribed

Please explain the steps in Excel for the answers! thank you:)

An asset has a value of $100,000 . In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to %20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB.

An asset has a value of $100,000. In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to \%20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB. An asset has a value of $100,000. In an attack, it is expected to lose 80 percent of its value. The annual chance is 50%. Countermeasure A (CMA) will decrease EF to \%20. Countermeasure B (CMB) will cut the frequency of successful attack (ARO) in half. 1. Calculate SLE and ALE using Excel. 2. Use what-if analysis to create scenarios to compare Base, CMA and CMB

Accepted Answer

The Answer is in the image, click to view ...

Question

Please explain the steps in Excel for the answers! thank you:) An asset has a value of $100,000 . In an attack, it is expected

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Advanced Bond Portfolio Management

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question