parts g and h please! not using excel

47. There are two bonds available for you to immunize a $15,000,000 payment that is due three years from today. Bond A has a coupon of 8.0% and seven years left until maturity, and bond B has a coupon of 5.0% and two years left until maturity. Bond B has convexity of 5.81. Market yields are 4.40% on all bonds, all bonds trade in par values of $1,000, and all bonds pay annual coupons. a. What must be the value of your immunization portfolio today? $13,182,257 b. What are the durations of the two bonds? 5.76:1.95 c. Using modified duration, estimate the price change of the two bonds given a 150bp increase in yield. 8.276%:2.802% d. Using modified duration, estimate the price change of the two bonds given a 100bp decrease in yield. 5.517%:1.868% e. Using modified duration and the convexity correction estimate the price change of bond B for an increase in YTM of 150 bp and for a decrease in YTM of 100 bp. 2.737%:1.897% f. What proportion of your portfolio will be invested in each bond? A:27.56%;B:72.44% 9. How many A bonds and B bonds will you have to purchase? A:2,995:B:9,443 h. Suppose instead that the $15 million cash flow to immunize occurs four years from today. What would be the value of your portfolio today, what percentage of it would be invested in A bonds, and how many A bonds would you have to purchase? $12,626,683;53.81% : 5, 602