it is not policy 1. must be done in Excel, please show your work.

Question 2 0/20 pts You just bought a new car and want to get an insurance policy for it for the next 5 years. You will either have only one car accident in year 3 with the probability of 30%, or you will have no accident at all with the probability of 70%. The insurance company has three policies. The annual cost and the cost of having an accident under each policy is given in the following table. These payments are at the beginning of the year and start from year zero to 4. Also, the right column shows how much money you should pay for the accident in addition to the amount which the insurance company pays for the accident. Which policy should you choose assuming you can earn 10% on your money? Plan Annual Cost (5 Accident cost in case of an payments from accident in year 3 zero to year 4) $400 $12,400 Policy 1 - High Deductable Policy 2 - Medium Deductable Policy 3 - Low Deductable $600 $7600 $800 $4,200 Policy 2 Policy 1 Policy None of them