Please include all the formulas used in excel.

Answer these questions using Microsoft excel. 1. ABC Corporation need to pay 10 annual claims on a policy at the end of each year. The first payment is $350000 and each payment thereafter was adjusted for inflation with annual 2% (compounded). a) The company decide to match their liabilities and assets using absolute matching strategy with zero coupon bond. Determine the total cost for the company to implement this strategy. Hint - Calculate spot rate first. 2x = 0.05 + 0.0071 -0.0004t2 for 0