Answer using Excel and show formulas please.

Consider the following portfolio of bonds Suppose you invested $100 Million in total in this portfolio. How much is your portfolio worth in \$ Millions (Ignoring any reinvestment of coupons), if a) Interest rates go up by 25 basis points ( 1 basis point =1/100%) ? b) Interest rates go down by 200 basis points? Consider the following portfolio of bonds Suppose you invested $100 Million in total in this portfolio. How much is your portfolio worth in \$ Millions (Ignoring any reinvestment of coupons), if a) Interest rates go up by 25 basis points ( 1 basis point =1/100%) ? b) Interest rates go down by 200 basis points