Companies A and B have been offered the following rates per annum on a

$20

\ million five-year loan:\ Company A requires a floating-rate loan; company B requires a fixed-rate loan. Design a\ swap that will appear equally attractive to both companies.\ Answer the question by using excel and explain what did you do in all the parts.

2. Companies A and B have been offered the following rates per annum on a $20 million five-year loan: Company A requires a floating-rate loan; company B requires a fixed-rate loan. Design a swap that will appear equally attractive to both companies. Answer the question by using excel and explain what did you do in all the parts. 2. Companies A and B have been offered the following rates per annum on a $20 million five-year loan: Company A requires a floating-rate loan; company B requires a fixed-rate loan. Design a swap that will appear equally attractive to both companies. Answer the question by using excel and explain what did you do in all the parts