Please provide excel formula.

2. Suppose you are a private wealth manager. You have a client that has asked you to invest some money for them ($1,000,000) for exactly 15 years. Based on your assessment of client's risk tolerance and risk capacity, Investment-grade Corporate bonds are the best fit for the client. Note: Settlement date is 4/27/2021 Bond ask yield S&P rating coupon 2.0% 2.5% 1.5% Alpha Beta AA maturity 7/1/2030 7/1/2050 7/1/2030 7/1/2050 3.0% 7.0% BBB Gamma 3.5% 5.0% Delta 9.5% D a. Choose appropriately from the above bond list and calculate Prices and Duration for selected bond(s). (8 points) b. Specify how much of the client's money (how many dollars) should be invested in which of these bonds in order to immunize the portfolio from Interest Rate Risk. (7 points) C. Specify how many of each of the bonds should be purchased (rounded to the nearest whole number of bonds). (8 points) 2. Suppose you are a private wealth manager. You have a client that has asked you to invest some money for them ($1,000,000) for exactly 15 years. Based on your assessment of client's risk tolerance and risk capacity, Investment-grade Corporate bonds are the best fit for the client. Note: Settlement date is 4/27/2021 Bond ask yield S&P rating coupon 2.0% 2.5% 1.5% Alpha Beta AA maturity 7/1/2030 7/1/2050 7/1/2030 7/1/2050 3.0% 7.0% BBB Gamma 3.5% 5.0% Delta 9.5% D a. Choose appropriately from the above bond list and calculate Prices and Duration for selected bond(s). (8 points) b. Specify how much of the client's money (how many dollars) should be invested in which of these bonds in order to immunize the portfolio from Interest Rate Risk. (7 points) C. Specify how many of each of the bonds should be purchased (rounded to the nearest whole number of bonds). (8 points)