I am trying to replicate mechanism behind SWPM function of Bloomberg.
As you can see from the screenshot from my excel file, I am able to find exact cash flows from excel file (it not discounted), but I am confused about floating leg. Is there anyone who knows how to calculate it?
If there is a need for clarity about calculations in excel, please let me know. Thanks in advance!