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
Get step-by-step solutions from verified subject matter experts
