Please solve in Excel and show formulas. Thank you!

1. You are provided with the following Treasury Bond quotes: Settlement date Issue date Maturity Bid Asked Annual Coupon rate (coupons are paid semi- annually) 10/26/2021 11/15/2020 11/15/2044 3% 116.28 116.30 10/26/2021 5/15/2020 5/15/2046 2.5% 107.28 107.30 a) Compute the Modified duration of a portfolio of $10 million par of each of the above two bonds. (10 points) b) Compute the PVBP of a portfolio of $10 million par of each of the above two bonds. (10 points) c) Compute the Duration of a portfolio of $10 million par of each of the above two bonds. (10 points) 1. You are provided with the following Treasury Bond quotes: Settlement date Issue date Maturity Bid Asked Annual Coupon rate (coupons are paid semi- annually) 10/26/2021 11/15/2020 11/15/2044 3% 116.28 116.30 10/26/2021 5/15/2020 5/15/2046 2.5% 107.28 107.30 a) Compute the Modified duration of a portfolio of $10 million par of each of the above two bonds. (10 points) b) Compute the PVBP of a portfolio of $10 million par of each of the above two bonds. (10 points) c) Compute the Duration of a portfolio of $10 million par of each of the above two bonds. (10 points)