please help me to solve this question 2&3 by using Microsoft Excel and show me the formula too. thankyou!

Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual coupon bond prices. Term Prices 1 year 1028 2 years 1054 3 years 1079 4 years 1102 5 years 1123 6 years 1143 7 years 1162 Determine the implied set of spot rates. (10 Marks) Question 2 Alana Insurance Sdn Bhd is obligated to pay 10 annual claims on a policy at the end of every year. The first payment is RM250,000 and each payment thereafter is to be adjusted for inflation of 2% annually (compounded). a) If the company wishes to match their liabilities and assets using absolute matching strategy with zero coupon bond. Given below yield curve, determine the total cost to implement this strategy. [Hint: calculate set of spot rates first] de = 0.05 +0.007 -0.0004c for 0 st s 10 (15 Marks) b) Rework (a) using coupon bonds with annual coupons. Assume that the coupon bonds all have the same yield rate as the zero coupon bond above and that all sell at par (15 marks) Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM 1,166.40 at the end of year 2. Under the immunization technique, Alexa has set up an investment fund to meet these obligations using money market earning 8% currently with the rate changing daily and 3 year zero coupon bond also earning 8%. Determine the modified duration and convexity of Alexa's asset portfolio. [Hint: calculate the price for each assets first] (15 Marks) Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual coupon bond prices. Term Prices 1 year 1028 2 years 1054 3 years 1079 4 years 1102 5 years 1123 6 years 1143 7 years 1162 Determine the implied set of spot rates. (10 Marks) Question 2 Alana Insurance Sdn Bhd is obligated to pay 10 annual claims on a policy at the end of every year. The first payment is RM250,000 and each payment thereafter is to be adjusted for inflation of 2% annually (compounded). a) If the company wishes to match their liabilities and assets using absolute matching strategy with zero coupon bond. Given below yield curve, determine the total cost to implement this strategy. [Hint: calculate set of spot rates first] de = 0.05 +0.007 -0.0004c for 0 st s 10 (15 Marks) b) Rework (a) using coupon bonds with annual coupons. Assume that the coupon bonds all have the same yield rate as the zero coupon bond above and that all sell at par (15 marks) Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM 1,166.40 at the end of year 2. Under the immunization technique, Alexa has set up an investment fund to meet these obligations using money market earning 8% currently with the rate changing daily and 3 year zero coupon bond also earning 8%. Determine the modified duration and convexity of Alexa's asset portfolio. [Hint: calculate the price for each assets first] (15 Marks) Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual coupon bond prices. Term Prices 1 year 1028 2 years 1054 3 years 1079 4 years 1102 5 years 1123 6 years 1143 7 years 1162 Determine the implied set of spot rates. (10 Marks) Question 2 Alana Insurance Sdn Bhd is obligated to pay 10 annual claims on a policy at the end of every year. The first payment is RM250,000 and each payment thereafter is to be adjusted for inflation of 2% annually (compounded). a) If the company wishes to match their liabilities and assets using absolute matching strategy with zero coupon bond. Given below yield curve, determine the total cost to implement this strategy. [Hint: calculate set of spot rates first] de = 0.05 +0.007 -0.0004c for 0 st s 10 (15 Marks) b) Rework (a) using coupon bonds with annual coupons. Assume that the coupon bonds all have the same yield rate as the zero coupon bond above and that all sell at par (15 marks) Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM 1,166.40 at the end of year 2. Under the immunization technique, Alexa has set up an investment fund to meet these obligations using money market earning 8% currently with the rate changing daily and 3 year zero coupon bond also earning 8%. Determine the modified duration and convexity of Alexa's asset portfolio. [Hint: calculate the price for each assets first] (15 Marks) Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual coupon bond prices. Term Prices 1 year 1028 2 years 1054 3 years 1079 4 years 1102 5 years 1123 6 years 1143 7 years 1162 Determine the implied set of spot rates. (10 Marks) Question 2 Alana Insurance Sdn Bhd is obligated to pay 10 annual claims on a policy at the end of every year. The first payment is RM250,000 and each payment thereafter is to be adjusted for inflation of 2% annually (compounded). a) If the company wishes to match their liabilities and assets using absolute matching strategy with zero coupon bond. Given below yield curve, determine the total cost to implement this strategy. [Hint: calculate set of spot rates first] de = 0.05 +0.007 -0.0004c for 0 st s 10 (15 Marks) b) Rework (a) using coupon bonds with annual coupons. Assume that the coupon bonds all have the same yield rate as the zero coupon bond above and that all sell at par (15 marks) Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM 1,166.40 at the end of year 2. Under the immunization technique, Alexa has set up an investment fund to meet these obligations using money market earning 8% currently with the rate changing daily and 3 year zero coupon bond also earning 8%. Determine the modified duration and convexity of Alexa's asset portfolio. [Hint: calculate the price for each assets first] (15 Marks)