[size=100%][size=100%]Hi All, This is the interest rate swap model I developed for my company, but here is simplified for your using. The formula and calculation tradition follows JP Morgan's tradition. So this file's calculation is very close to market price. Here the full code can be found in VBA Editors. Enjoy.