how to solve this exercise plus excel?

Problem Given a survival data below: Po Pr[K(0)=1] 197 P7 Pr[K(0)=1] 0.3 0.7 1.0000 0.3000 0.0000 1.0000 0.7000 0.9615 0.9246 0.1 0.9 0.7000 0.0700 0.7000 0.3000 0.2400 0.9246 0.8548 0.2 0.8 0.6300 0.1260 0.9400 0.0600 0.0540 0.8890 0.7903 0.2 0.8 0.5040 0.1008 0.9940 0.0060 0.0060 0.8548 0.7307 0.4 0.6 0.4032 0.1613 1.0000 0.0000 0.0000 0.8219 0.6756 0.5 0.5 0.2419 0.1210 0.7903 0.6246 FOG. JOUAWN-O 0.4 0.1210 0.0726 0.7599 0.5775 0.3 0.0484 0.0339 0.7307 0.5339 0.8 0.2 0.0145 0.0116 0.7026 0.4936 0.9 0.1 0.0029 0.0026 0.6756 0.4564 - 0 0.0003 0.0003 0.6496 0.4220 Let vi denotes the discount factor for one year and where vi denotes the discount factor for two years. You are also given that a2 = 2.95162, A) = 0.88312 and A, 1 = 0.00350. Calculate each of the following: a. A7and the (approximate) probability that the present value of the associated benefit paid will exceed 0.99195; b. 7:31 c. a7; d. d26; (use this identity: doxin + Arm = 1 ) e. Az; (use this identity: da, + A, = 1 )