Practical techniques for calculating portfolio risk and hedging with automated curve bumping.
This course provides a technical framework for constructing spreadsheet-based risk management systems for interest rate swaps. It details the process of stripping input rates to derive zero-coupon curves and explains the mechanics of calculating portfolio sensitivity through curve bumping. The curriculum addresses the calculation of DV01 exposure, the reconciliation of hedge notionals, and the practical implications of various interpolation methods. Discussions focus on the technical implementation of risk reporting and the balance between system architecture, market conventions, and pricing accuracy.
4 activities • 12 videos • duration: 3h 36m

Risk Analyst
I spent 10 years in investment banking, trading Forex, bullions, commodities, swaps and credit products, both vanilla and structured, while also working on risk management, process control and system development. In 2001, I founded NitroX Consulting, where I advise on risk modelling and management and build tailor-made solutions for my clients. In 2014, I also served as Chief Risk Officer at RiverRock Asset Management.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.