Excel solution preferred.

4. A company enters into a 5-year interest rate swap contract with a level notional amount of $1 million. The settlement period is 1 year. The floating interest rate is defined by the spot rates for investments horizons of 1, 2, 3, 4, and 5 years, respectively of 3.5%, 3.6%, 4.2%, 4,6%, and 4.8%. Determine the swap rate. ANS: 4.7405%. 4. A company enters into a 5-year interest rate swap contract with a level notional amount of $1 million. The settlement period is 1 year. The floating interest rate is defined by the spot rates for investments horizons of 1, 2, 3, 4, and 5 years, respectively of 3.5%, 3.6%, 4.2%, 4,6%, and 4.8%. Determine the swap rate. ANS: 4.7405%