Make this spreadsheet below and edit it to include the following controls:

Retrieve the spreadsheet from Canvas

& edit it to include the following

controls:

1.Annual fee cannot exceed 8% of purchase cost

2.Training costs cannot exceed $12,000 in year 0 and $3,000 thereafter

3.Savings due to efficiency cannot exceed $5000, but must be zero in year 0

4. Cell C2 must force entry of either YES or NO no other values can be accepted

5. Your name must appear in cell C3 and must not exceed 30 characters total

6.Cell B8 (annual fee) must NOT permit any alphabetic text

Only requires you to create controls in EXCEL. You do not have to fill out the values in the applicable cells.

Hint: A useful tool for this is the data validation tool in EXCEL, which is easy to learn & use via Google Search

.

1 Request: 2 Answer: 3 Your name: Should we spend $100K to reap benefits of $30K per year? Year Total $100,000 $100,000 7 Purchase Cost (initial) 8 Annual fee 10 Training costs 12 Savings due to efficiency 13 14 Reduction in threat: 15 Impact 16 Current risk 17 Expected loss 18 New risk 19 New loss 20 Benefit 21 22 Total Cash Outflows 23 Total Benefits 24 Net Benefits 25 Discount rate 26 Discounted value 27 NPV 28 IRR 500,000 1096 $50,000 4.0% $20,000 30,000 Annually $O$30,000 $30,000$30,000 30,000 $30,000$150,000 O $100,000 0$30,000 $30,000 $30,000 $30,000 $30,000 $150,000 100,000 $30,000 $30,000 $30,000 $30,000 30,000 $50,000 $100,000 S0 1096 $100,000 $27,273 $24,793 S22,539 $20,490 $18,628 $13,724 $13,723.60 15% 1 Request: 2 Answer: 3 Your name: Should we spend $100K to reap benefits of $30K per year? Year Total $100,000 $100,000 7 Purchase Cost (initial) 8 Annual fee 10 Training costs 12 Savings due to efficiency 13 14 Reduction in threat: 15 Impact 16 Current risk 17 Expected loss 18 New risk 19 New loss 20 Benefit 21 22 Total Cash Outflows 23 Total Benefits 24 Net Benefits 25 Discount rate 26 Discounted value 27 NPV 28 IRR 500,000 1096 $50,000 4.0% $20,000 30,000 Annually $O$30,000 $30,000$30,000 30,000 $30,000$150,000 O $100,000 0$30,000 $30,000 $30,000 $30,000 $30,000 $150,000 100,000 $30,000 $30,000 $30,000 $30,000 30,000 $50,000 $100,000 S0 1096 $100,000 $27,273 $24,793 S22,539 $20,490 $18,628 $13,724 $13,723.60 15%