Browse Our Courses

Pricing Interest Rate Options – Module III EXCEL Example
About the course
The course consists of an EXCEL file that illustrates the pricing of various interest rate options and derivative products, which include:
- the valuation of caps and floors using constant and varying volatilities,
- the use of the cap-floor parity to price a fixed for floating interest rate swap,
- the pricing of accrual swaps, commodity linked notes and range accrual notes
and a PDF file which explains the derivation of the Zero Curve and Forward Rates.
Learning Objectives
After taking this course you will be able to:
- Price caps and floors
- Use the cap floor parity to price a fixed for floating interest rate swap
- Price accrual swaps
- Price commodity linked notes
- Price range accrual note
- The file also contains the derived zero rate and forward rate term structures used in the pricing of the swaps
Prerequisites
The student should be comfortable with basic mathematics, statistics, probability, EXCEL including the use & interpretations of the EXCEL NORMSDIST, STDEV, VLOOKUP & HLOOKUP functions.
They must also be familiar with linear interpolation, the derivation of spot and forward rate term structures & the concepts behind the pricing of caps & floors, interest rate swaps, accrual swaps, range accrual notes and commodity linked notes.
Target Audience
This course is for individuals involved in pricing and valuation of derivatives, in particular interest rate sensitive instruments.