Question: Using Excel, calculate the payback, discounted payback, NPV, and IRR of the proposed new cybersecurity system.Your company has been quoted $1.5 million for a new

Using Excel, calculate the payback, discounted payback, NPV, and IRR of the proposed new cybersecurity system.Your company has been quoted $1.5 million for a new cyber defense system. The new program will likely protect the company for 3 years and then need to be replaced as technology improves. Using sophisticated detection skills, they determine that your companys website faces approximately 800 cyber security incidences a day, 365 days a year. They also estimate that 1 in 500 attacks are successful, and the cost of the average attack is $1,000, after tax due to lost merchandise, notification of the customers affected and time spent by employees following up on the incidents. Should you buy the system? Your company estimates its cost of capital is 7.5%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!