please solve using excel. thank you.

a) How does a portfolio manager use repurchase agreements or roverse repurchase agreements to increase the duration of the portfolio? Calculate the duration if the portfolio Manager purchases a bond with a duration of 5.4 and finances the purchase with a repo with a haircut of 5.0%, (b) How does a portfolio manager use interest rate futures to adjust the duration of a fixed income portfolio? What position does a manager take if they wish to increase the duration of the portfolio? What position does the manager take if they wish to decrease the duration of the portfolio? (c) How does a portfolio manager uso interest rate swaps to adjust the duration of a fixed income portfolio? What position does a manager take if they wish to increase the duration of the portfolio? What position does the manager take if they wish to decrease the duration of the portfolio? a) How does a portfolio manager use repurchase agreements or roverse repurchase agreements to increase the duration of the portfolio? Calculate the duration if the portfolio Manager purchases a bond with a duration of 5.4 and finances the purchase with a repo with a haircut of 5.0%, (b) How does a portfolio manager use interest rate futures to adjust the duration of a fixed income portfolio? What position does a manager take if they wish to increase the duration of the portfolio? What position does the manager take if they wish to decrease the duration of the portfolio? (c) How does a portfolio manager uso interest rate swaps to adjust the duration of a fixed income portfolio? What position does a manager take if they wish to increase the duration of the portfolio? What position does the manager take if they wish to decrease the duration of the portfolio