Author: admin

FX forward valuation excel

Here we’ll show how to value FX forwards (Foreign eXchange) on EURUSD exchange rate in excel with quantlib excel addin in this example we’ll need following market data: EURUSD spot EURUSD forward points (can get from bloomberg or reuters) EUR

Posted in OTC derivatives valuation

Amortizing interest rate swap valuation excel example

Amortizing interest rate swap valuation excel with 2 curves example: for online amortizing interest rate swap valuation with credit valuation adjustment see Online Amortizing Interest rate swap valuation with CVA and OIS discounting for quantlib python version see Amortizing Interest

Posted in OTC derivatives valuation, quantlib Tagged with: , ,

Simple Derivatives CVA Calculation Example (credit valuation adjustment) excel

Here we show simplest method called current net exposure for more elaborated Monte-Carlo method using python see CVA with monte carlo calculation for online interest rate swaps and OTC derivatives valuation with CVA see Derivatives accounting calculators CVA calculation online

Posted in OTC derivatives valuation Tagged with: , , ,

what is an OAS spread for bond

Option Adjusted spread (OAS) is usually calculated for bonds with embedded options (call or put) OAS is a constant spread over discounting curve you have to apply to back up market price of the bond this spread is adjusted to

Posted in OTC derivatives valuation

call option 101

what is a call option? it’s an option which give right (=option) to buyer to buy a stock at fixed price called strike example of call option company A buys a european call option on Microsoft stock with strike 10

Posted in OTC derivatives valuation

financial derivatives 101

what are the financial derivatives? basically it’s a contract which price is based on price of another financial asset example of a derivative company A buys a derivative form bank B by which B will pay 1 million euros if Ibex 35 index

Posted in OTC derivatives valuation Tagged with:

quanto adjustment formula example

what is a quanto adjustment? it’s an adjustment to forward price of underlying if payoff’s currency is diferent from underlying’s currency example if payoff currency is EUREUR and underlying is in USD (for example DowJones index) then we’ll need to

Posted in OTC derivatives valuation Tagged with:

how to value Eonia swap

what is an EONIA swap (call money swap)? it’s a swap where we exchange fixed rate for variable rate calculated with dayly EONIA rate (Euro OverNight Index Average) the payments are based on average EONIA rate , which corresponds to

Posted in OTC derivatives valuation Tagged with:

accounting for stock options

What is a stock option plan? it’s a executive’s incentive plan whoch consists in giving employee a number of stock options which can be exercised only after certain period have passed (vesting period), normally few years Accounting for stock options

Posted in OTC derivatives valuation Tagged with:

hedge effectiveness testing – hedge accounting

What is a hedge effectiveness testing? it’s a numerical test in hedge accounting to determine if hedging financial instrument effectively hedges underlying loan. In case when hedge is effective company can apply “hedge accounting” and would not be obliged to

Posted in hedge accounting Tagged with: , , , , , , ,