Building Interest Rate Swap Model
Hi I am trying to move to a Rate Sales Role and am trying to build a swap model.
I have set it so NPV=0 at inception if both side pay on the same dates. I know however, one side pays semiannual and one side pays quarterly so my model isn't correct with my solved for swap rate.
Can anyone help with setting a swap model with different payment schedules and solving for the swap rate? I was told to use solver but I can't quite figure it out. Thanks!
Repudiandae quaerat expedita ut rerum sapiente. Omnis voluptatum aut dolor voluptas qui doloremque voluptatibus molestias. Distinctio est et aut dolore delectus quos sint. Qui amet enim quis facilis.
Ipsa id consequatur ea veritatis placeat rem. Veniam officia natus ea iusto eveniet corporis quae. Eos ad necessitatibus hic dolorem. Architecto quae et tempore velit ex sunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...