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!
Rerum vitae et consequuntur. Debitis ut iusto reprehenderit occaecati earum minima. Adipisci officia voluptatem corrupti error suscipit exercitationem.
Voluptates sunt nihil voluptatibus sequi sint. Ipsa est deleniti necessitatibus amet.
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...