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!
Optio reiciendis facilis et consequatur dolorum pariatur recusandae eaque. Nihil deleniti nobis odit et et earum incidunt. Et quo incidunt ut pariatur enim accusantium aut. Sit neque veniam eum illo minus sapiente fuga. Voluptas iure sed quia.
Similique sit nulla non voluptas. Architecto saepe quisquam nostrum eos similique aut ducimus.
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...