Prepare your answers for all of the following problems in one Excel and submit the Excel file in Canvas. Use one file that contains solutions on different sheets; do not try to submit separate Excel files. Clearly indicate your answers. The solutions in your Excel file should be very organized with every number labeled. Follow the examples in the textbook for the proper format. Problem 1. [20 points] BassFishingKY.com had its website shut down for two days due to a cyberattack on January 1st and 2nd. During those two days, it is estimated that a total of 300 potential new registered customers were permanently lost because they could not access the website. Once registered, customers on average visit the site once a month and spend $15 on each visit, and remain registered for three years visiting (and buying) monthly. What is the present value of the lost sales from those potential new customers assuming a cost of capital of 6%? [Assume earnings are earned on the last day of the year.]

Note: only 2 days of potential lost revenue not an entire year... your figures is calculating a years worth of lost revenue - should be ONLY 2 days = 300*15