please show in excel formula form

Companles often buy bonds to meet a future liability or cash outlay. Such an investment is called a dedicated portfolio since the proceeds of the portfolio are dedicated to the future liabllity. In such a case, the portfolio is subject to roinvestment risk. Reinvestment risk occurs because the company wili be reinvesting the coupon paryments it reccives, If the YTM on similtar bonds falls, these coupon payments will be reinvested at a lower interest rate, which will result in a portfolio value that is lower than desired at maturity. Of course, if interest rates increase, the portfolio value at maturify will be higher than needed. Suppose lce Cubes, inc, has the following liability due in five years-The company is going to buy bonds today in order to meet the future obligation, The liability and current YTM are below. At the current YTM, what is the face value of the bonds the company has to purchase today in order to meet its future obligation? Assume that the bonds in the relevant range will have the same coupon rate as the current YTM and these bonds make semiannual coupon payments. Assume that the interest rates remain constant for the next five years. Thus, when the company relmests the coupon payments, it will reinvest at the current YTM. What is the value of the portiolio in tive years? Assume that immediately aiter the cumpany purchases the bonds, interest rates either rise or fall by one percent. What is the value of the portfolso in five years under these circumstances