Topic Guides

FourQuants offers prepackaged topic guides consisting of downloadable PDF notes with EXCEL examples and templates.

The following is a list of topic guides are available:

Asset Liability Management (ALM) Crash Course

PDF notes

  1. ALM Crash Course
  2. Value at Risk with Liquidity Premium

EXCEL Worksheets

  1. ALM Crash Course – Excel Examples [includes Cost of Close Liquidity Gaps, Cost of Close Interest Rate Risk, Earnings at Risk, Market Value of Equity]
  2. Duration Convexity Example 
  3. Value at Risk with Liquidity Premium – EXCEL Example

Basel & ICAAP

PDF notes

  1. ICAAP – Overview & Core Concepts
  2. ICAAP Sample Report Template & Executive Summary
  3. Basel III – Liquidity Framework

Black-Derman-Toy (BDT) Interest Rate Model

PDF notes

  1. How to construct a Black Derman Toy Model in EXCEL
  2. How to utilize results of a Black Derman Toy Model

EXCEL Worksheets

  1. Black-Derman-Toy Model Construction – EXCEL Example
  2. How to utilize results of a Black Derman Toy Model – EXCEL Example

Calculating Value at Risk (VaR)

PDF notes

  1. Calculating VaR – Includes case study
  2. Value at Risk with Liquidity Premium

EXCEL Worksheets

  1. Calculating VaR – EXCEL Example
  2. Portfolio VaR – EXCEL Example
  3. Value at Risk with Liquidity Premium – EXCEL Example

Constructing Volatility Surfaces in EXCEL

PDF notes

  1. Constructing Volatility Surfaces in EXCEL

EXCEL Worksheets

  1. Local Volatility Surface Model -NVIDIA

Credit Analysis & Credit Process

PDF notes

  1. Credit Analysis – First Course
  2. Credit Analysis – Financial Institution
  3. Credit Process

EXCEL Worksheets

  1. Credit Analysis – Financial Institution – EXCEL Example

Derivative Products

PDF notes

  1. Derivatives Terminology Crash Course
  2. Derivative Products

Forward Prices and Forward Rates – Calculation reference & detailed examples

PDF notes

  1. Calculating Forward Price and Forward Rates in EXCEL

EXCEL Worksheets

  1. Calculating Forward Prices, Rates, YTM & FRA Values

Heath Jarrow Merton (HJM) Interest Rate Model

EXCEL Worksheets

  1. Pricing IRS – Module I – Term Structures EXCEL Example
  2. Heath Jarrow Merton – HJM 3 – Factor Interest Rate Model
  3. Principal Component Analysis – PCA – US Treasury Yield Rates

Interest Rate Simulation Crash Course

PDF notes

  1. Interest Rate Simulation Crash Course

EXCEL Worksheets

  1. Pricing IRS – Module I – Term Structures EXCEL Example
  2. Calibration of CIR Model Example
  3. Black-Derman-Toy Model Construction – EXCEL Example
  4. How to utilize results of a Black Derman Toy Model – EXCEL Example
  5. Heath Jarrow Merton – HJM 3 – Factor Interest Rate Model
  6. Principal Component Analysis – PCA – US Treasury Yield Rates

Monte Carlo Simulation

EXCEL Worksheets

  1. Monte Carlo Simulation – Commodity – Example
  2. Monte Carlo Simulation – Currency – Example
  3. Monte Carlo Simulation – Equity – Example

Monte Carlo Simulation with Option Pricing

PDF Note

  1. Derivative Pricing
  2. Monte Carlo Simulation – Model and Applications

EXCEL Worksheets

  1. Valuing Options – Traditional Binomial Trees – Examples
  2. Valuing Options – Black Scholes – Examples
  3. Derivative Pricing – Binomial Trees – Example
  4. Derivatives Pricing using Monte Carlo Simlator
  5. Pricing Ladder Options using Monte Carlo Simlator

Pricing Interest Rate Swaps and Interest Rate Options

PDF notes

  1. Pricing IRS – Module I – Term Structures
  2. Pricing IRS – Module II – IRS and CCS
  3. Pricing Interest Rate Options – Module III

EXCEL Worksheets

  1. Pricing IRS – Module I – Term Structures EXCEL Example
  2. Pricing IRS – Module II – IRS and CCS EXCEL Example
  3. Pricing Interest Rate Options – Module III EXCEL Example

Setting Counterparty Limits

PDF notes

  1. Setting Counterparty Limits
  2. Sample Counterparty Limit Proposal

EXCEL Worksheets

  1. Setting Limits – EXCEL Example

Treasury Crash Course

PDF notes

  1. Treasury Crash Course
  2. Value at Risk with Liquidity Premium

EXCEL Worksheets

  1. ALM Crash Course – Excel Examples [includes Cost of Close Liquidity Gaps, Cost of Close Interest Rate Risk, Earnings at Risk, Market Value of Equity]
  2. Duration Convexity Example 
  3. Calculating VaR – EXCEL Example
  4. Value at Risk with Liquidity Premium – EXCEL Example

Understanding Delta Hedging and Greeks

PDF notes

  1. Understanding Delta Hedging and Greeks

EXCEL Worksheets

  1. Delta Hedging – Call Option
  2. Delta Hedging – Put Option
  3. Greeks

Random Testimonial

  • ~ Corporate Training Testimonials

    "A most amazing training - hands down the best, most useful, and most relevant I had during my tenure. Simply put, I loved it and will continue to build on the models. 

    Financial Modeling Course Participant
    FGB Training Academy, 
    First Gulf Bank, Abu Dhabi, UAE

     

    I have attended a number of training courses conducted by Alchemy technologies. Broadly, the areas covered have been Financial Risk Management aspects, Basel II implementation in Pakistan, as well as product knowledge for relatively new products in the our market for instance Financial Derivatives. As trainers, Mr. Jawwad Farid and his team bring in a wealth of conceptual knowledge entwined with their own professional experiences, adapting and honing it to our local market needs. The training courses are very informative and are delivered in a witty and energetic manner. The learning needs of the participants are kept in focus, and they are kept involved by interactive discussions and queries. Personally, I have always left these sessions with a much better understanding and grasp over the subjects delivered, which has helped me professionally.”

    Senior Manager & Team Leader
    Treasury Middle Office
    Habib Bank Limited

     

    “Jawwad Farid has admirably led the training piece on the Treasury side covering Treasury risk, Treausury products, Derivatives (basic & Advanced), Fixed income securities (Basic & Advanced) and ALM training modules. Jawwad in our opinion is an “Outstanding Senior Trainer” who has deep subject matter knowledge and an uncanny ability to keep the participants engaged in the training process. So far our clients have expressed maximum level of satisfaction in Jawwad’s capability to deliver high value training programs, that have tangibly enhanced their staff’s skill sets.

    Based on our direct more than satisfactory experience, Jawwad’s otherwise exceptional track record on the training side with over 90 technical skill building courses in South Asia, Middle Eastern and Far Easterm markets, we have no hesitation in strongly recommending Jawwad Farid for the training that for participants based out of Malaysia or the adjoining Far Eastern Markets.”

    Mohammad Nasr Ullah
    Principal Consultant
    Consultnomics, FZE

     

    I have loved each and every workshop from Alchemy. The workshops are extremely helpful in removing queries about Derivatives Pricing, Basel & Regulatory issues. I feel attending the workshops have added value to my knowledge and expertise. Moreover, the instructor is extremely knowledgeable on the subject area and ensures that each candidate returns with similar knowledge and expertise.

    Senior Vice President
    Compliance
    Allied Bank"

  • Read more testimonials »