Please show process and formulas in excel

1. You are provided with the following Treasury Bond quotes: 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)