Course description
Using Excel to Value Derivatives
The Using Excel to Value Derivatives course is an intensive one-day course that gives participants expertise in using Excel to value and price a range of derivative products that includes swaps, options, and credit derivatives.
What really sets our program apart is the way in which we explain, step-by-step, how to create real-world pricing models within Excel. Our approach demystifies the complexities and really brings the topics to life.
Participants will have access to fully working derivatives valuation spreadsheets, and will be able to download these for their own use after the seminar is over.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
Who Should Attend
Anyone who needs to understand the pricing and valuation of derivatives using Excel.
Prerequisites
A good working knowledge of Excel, and a basic understanding of derivatives.
Outcome / Qualification etc.
CPD: 7 hours
Learning Outcomes
By attending this course, you will:
- Explore how Excel can be used to create accurate and effective models for valuing derivatives
- See how some of the practical hurdles can be overcome
- Bridge the gap between finance theory and financial practice
Training Course Content
Valuing Interest Rate Swaps
- Swap valuation principles
- Valuing a swap
- Sensitivity to movements in swap rates
- LIBOR vs. SOFR swaps
- 💻 Pricing and valuing vanilla and non-standard swaps
Valuing Options
- Introduction
- Programming the Black-Scholes model and variants
- Converting from market to continuously compounded rates
- 💻 Creating an initial model
- Handling limit and extreme inputs
- 💻 Creating an improved model
Valuing Credit Default Swaps
- An intuitive approach to CDS pricing
- Calculating CDS premiums
- 💻 Obtaining CDS premiums from default probabilities
- 💻 Converting between premiums running and points up-front
- The ISDA CDS Standard Model
- 💻 Bootstrapping default probabilities from CDS premiums
Why choose ACF Academy
Over 100,000 professionals trained globally
Award-winning practical financial simulations
Consistently high ratings
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Expenses
- London: £925 (plus VAT)
- New York: $1,150
- Virtual: £800 (plus VAT)