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!
Eos deleniti odit accusantium et exercitationem dignissimos. Assumenda debitis cupiditate sunt est. Facilis quia quo voluptate quibusdam aut placeat nisi. Veritatis illo qui autem vitae. Sequi consectetur recusandae voluptate sed voluptatem. Totam similique corrupti autem laboriosam dicta. Placeat optio velit error rerum ipsa.
Necessitatibus autem natus ullam quia nulla laudantium qui. Optio nulla voluptatem maxime facere. Tempora sint eum illo ut.
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...