Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Request: Should we invest $100,000 in the proposed security solution to reduce the risk of an issue below 10%? Answer: Year 0 1 2 3
Request: | Should we invest $100,000 in the proposed security solution to reduce the risk of an issue below 10%? | |||||||||
Answer: | ||||||||||
Year | ||||||||||
0 | 1 | 2 | 3 | 4 | 5 | Total | ||||
Purchase Cost (initial) | $100,000 | $100,000 | ||||||||
Annual fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
Training costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
Savings due to efficiency | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
Reduction in threat: | ||||||||||
Impact | $500,000 | |||||||||
Current risk | 10% | |||||||||
Expected loss | $50,000 | |||||||||
New risk | 4.0% | |||||||||
New expected loss | $20,000 | |||||||||
Benefit | $30,000 | annually | $0 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $150,000 | |
Total Cash Outflows | $100,000 | $0 | $0 | $0 | $0 | $0 | $100,000 | |||
Total Benefits | $0 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $150,000 | |||
Net Benefits | -$100,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $50,000 | |||
Discount rate | 10% | |||||||||
Discounted value | -$100,000 | $27,273 | $24,793 | $22,539 | $20,490 | $18,628 | $13,724 | |||
NPV | $13,723.60 | |||||||||
IRR | 15% | |||||||||
Instructions | |
Using the spreadsheet provided, edit the cells to include the following controls:
(Enter the annual training costs in cell B10 and enter initial year 0 training costs in cell D10).
(hint: use cells A30 and A31 as the source for a dropdown list).
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started