Use the following data inside the excel file to calculate the savings of applying a each countermeasure to each threat. Upload the excel file with the Savings column filled up with your answer.

Threat Category Cost per Incident $($SLE$)$ Frequency of Occurrence $($Before Control$)$ Type of Control Cost of Control Frequency of Occurrence $($After Control$)$ Savings

Programmer Mistakes $$5,0001$ per week Training $$20,0001$ per month

Loss of Intellectual Property $$75,0001$ per year Firewall $$15,0001$ per $2$ years

Software Piracy $$5001$ per week Firewall $$30,0001$ per month

Theft of Information $($Hacker$)$ $$2,5001$ per quarter Firewall $$15,0001$ per $6$ months

Theft of Information $($Employee$)$ $$5,0001$ per $6$ months Physical Security $$15,0001$ per year

Web Defacement $$5001$ per month Firewall $$10,0001$ per quarter

Theft of Equipment $$5,0001$ per year Physical Security $$15,0001$ per $2$ years

Viruses, worms, Trojan Horses $$1,5001$ per week Antivirus $$15,0001$ per month

DDoS $$2,5001$ per quarter Firewall $$10,0001$ per $6$ months

Earthquake $$250,0001$ per $20$ years Insurance Backups $$5,0001$ per $20$ years

Flood $$250,0001$ per $10$ years Insurance Backups $$10,0001$ per $10$ years

Fire $$500,0001$ per $10$ years Insurance Backups $$10,0001$ per $10$ years