Using Excel calculate the payback, discounted payback, NPV, and IRR of the proposed deal below.

Your CEO is afraid of a cyber attack. He wants to know if investing in a cyber security system is a smart idea so he calls up an associate. The associate gives you the following information

Cyber attacks are up 600% from pre-pandemic levels.

The average cost of a cyber attack on a small business ranges from $120,000 to $1.24 million per successful attack.

71.1 million people fall victim to cyber crimes yearly.

Your company has been quoted $.15 million for a new cyber defense system. This program will likely protect the company for 3 years and then will need to be replaced.

Here are statistics of the current state of the company website.

- Website faces approximately 800 cyber security incidences a day, 365 days a year.

- 1 in 500 attacks are successful, the cost of the average attack is $1,000 after tax

- Your company estimates it's cost of capital is 7.5% (not sure if this is the cost of the system or the cyber attacks). I think cost of the system makes more sense but I am unsure.