Question: help me to solve by using M.Excel and show the formula as well. thank you in advanced! Question 3 Alexa has liabilities of RM540.00 at

 help me to solve by using M.Excel and show the formula

help me to solve by using M.Excel and show the formula as well. thank you in advanced!

Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM1,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) Question 3 Alexa has liabilities of RM540.00 at the end of year 1 and RM1,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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!