Skip to main content

 

 

Coupa Success Portal

Valuations in Coupa Treasury

PDF Version

Basics

This document contains information on the calculation of present values for various instruments in Coupa Treasury. For this purpose, the valuation date is time 0 and the instrument is split into its future cash flows.

Interest methods and time factors

The period between the points in time s < t is measured depending on the day count convention of the deal or currency. This convention is referred to below as zs,t or zt = z0,t.

Discount factors

Within a year

The discount factor Dt is calculated from the money market rate rt for the point in time t and the time factor zt.

discount factor within a year.PNG

This is based on the usual simple interest method for deals within a year.

Not within a year

The discount factors for n = 2, …, N years are calculated from the capital market rates rn using the bootstrapping method. This is based on the discount factor D1 for one year (see above).

To calculate the discount factor Dn, all previous discount factors must already have been calculated.

discount factor not within a year.PNG

Missing interest rates for complete fiscal years are interpolated in a linear manner before the discount factors are calculated.

Forward interest rates

For the points in time s < t, the forward rate f(s,t) is calculated based on the discount factors Ds and Dt, interpolated in a linear manner if applicable.

Depending on the interest method, the time period between s and t is measured using the time factor zs,t.

For use with simple interest rates:

forward interest rate simple.PNG

For use with compound interest rates:

forward interest rate compound.PNG

Forward exchange rates (FX)

For two currencies W1 and W2, the time t, the interest rates r1 and r2 or the discount factors D1 and D2, and the FX spot K in price notation from the perspective of currency 1 (i.e. with the unit W1/W2), the forward rate T is calculated as

forward rate T.PNG

For simple interest, this corresponds to

forward rate simple interest.PNG

where z1 and z2 measure the period up to the date t, depending on the interest method of the currencies.

Fixed payments valuation

A cash flow C in currency 1 for future time t has the following value in currency 2

fixed payments valuation.PNG

where K is the spot rate, T is the forward rate, and Dt,I are the discount rates of the two currencies.

Variable payments valuation

A cash flow at time t whose value is unknown at the valuation date, but which is fixed at the time s < t, depending on a reference interest rate r known at that time (for the period of s to t), is evaluated using arbitrage considerations. This uses discount factors Ds and Dt or the forward rate f(s,t).

If the nominal amount N at any time t is paid for the payment rzs,tN, then the present value of the payment is 

variable payments valuation.PNG

Effective interest rate

To determine the effective interest rate of an interest-bearing deal, all actually flowing payment flows Cn at the points in time tn between creditors and debtors are needed (n = 0, …, N). The time factors zn are calculated from tn for the interest method act/act. All types of payments (loan disbursement, repayments, interest payments, fees, etc.) are treated equally. The two cash flow directions are distinguished by different signs. Each sign must occur at least once.

Then, the effective interest rate r is a solution to the following equation:

effective interest rate.PNG

In general, this equation cannot be solved algebraically. In Coupa Treasury, an approximate solution is determined using the Newton method.

Note: If the payments change their signs more than once over time, then this equation may have several solutions.

Deal valuation

FX forwards

The purchase at the date t of W1 currency units in currency 1 is valued against W2 currency units in currency 2 (i.e. at the deal rate K = W2/W1). For the valuation in currency 3, which may be identical to currency 1 or 2, the forward rates T3/1 and T3/2 (in price quotation from the perspective of currency 3) and the discount factor D3 of currency 3 for time t are used.

Then the present value of the forward is

FX forward with discounting.PNG

Without discounting, the factor D3 is omitted. If currency 2 is the valuation currency, the calculation is simplified to

FX forward without discounting.PNG

Commodity forwards

In contrast to FX forwards, the forward commodity price is not calculated from the cash prices and the interest curve but is linearly approximated from a price curve defined by the market.

In all other respects, this valuation equals the valuation of FX deals.

Money market, loans, interest rate swaps and leasing deals

Each cash flow generated by the deal is valued as a fixed or variable cash flow in accordance with the sections Fixed payments valuation and Variable payments valuation. The market value of the deal is the sum of the cash flow values.

FX options

Historical volatilities

Historical volatilities in Coupa Treasury are calculated from the performance of the currency pair in the year prior to the cut-off date. If for N days of this year, the rates K1, …, KN are available, then the historical daily volatility volatility.PNG is calculated as

historical daily volatility.PNG

The annualized daily volatility renders the annual volatility annual volatility.PNG.

Implied volatilities

In Coupa Treasury, implied volatilities can be maintained in the market data depending on the strike and the remaining term of the option. To valuate an option with strike E and remaining time to maturity t, the volatility is interpolated from the existing volatility as follows:

If E1 is the largest strike with E1 ≤ E, and E2 is the smallest strike with E2 > E, t1 the largest remaining term t1 ≤ t and t2 the smallest remaining term t2 > t, so that for the four support points (E1, t1), (E1,  t2), (E2, t1), (E2, t2), the volatilities are

volatility 11.png, volatility 12.png, volatility 21.png, and volatility 22.png

then

interpolated volatility 1.PNG

is used to calculate the interpolated volatility σ as

interpolated volatility 2.PNG

Plain vanilla options

Plain vanilla options are valuated using the Black-Scholes method modified by Garman and Kohlhagen. For the valuation of an option for one unit of currency 1 using currency 2 as the counter currency, the following parameters and functions are used:

plain vanilla parameters and functions.PNG

The continuous compounded interest rates are calculated from the corresponding factors as

continuous compunded interest rate.PNG

All rates are quoted in relation to currency 2. 

With

value of put 1.PNG and value of put 2.PNG

the resulting value of a call is

resulting value of call.PNG

and the value of a put is 

value of put.PNG

Single barrier options

For the valuation of the different single-barrier options, the Up And In Call (UIC) and the Down And In Call (DIC) are valued as basic types. The barrier is B. The directions up and down rates in price quotations are from the perspective of currency 2. All other types of single-barrier options can be valuated from this and from the plain vanilla call as a linear combination or through permutation of the two currencies.

For valuation of the UIC and DIC, the following parameters are used:

UIC and DIC parameters.PNG
UIC and DIC parameters 2.PNG

and Ni = Ф(di) for i = 3, …, 8.

Thus, the value of a UIC is

value of UIC.PNG

For E > B, the value of a DIC is

value of DIC.PNG

and for E < B, it is

value of DIC where E less than B.PNG

In addition to the options values, the Greeks are also calculated (i.e. various partial derivatives of the option value):

calculated greeks.PNG

For plain vanilla options, the Greeks are calculated exactly. For single-barrier options, they are approximated using appropriate difference quotients.

Interest rate options

In Coupa Treasury, caps, floors, and collars are valuated on the Black-Scholes method extended by Black (Black 76) or based on the Bachelier method. For the valuation of an individual caplet or floorlet, whose interest rate was fixed at point in time s1 and whose compensation may take place at time s2, the following parameters are used:

caplet floorlet parameters.PNG

Valuation according to the Black-Scholes Model

The period of the option’s reference interest rate is derived from the payment period of the option.

With

value of caplet 1.PNG and  value of caplet 2.PNG

the market value of a caplet is

value of caplet.PNG
and the market value of a floorlet is

value of floorlet.PNG.

The value of the whole cap (or floor) is the sum of the values of the individual caplets (or floorlets). The value of a collar is the difference between the values underlying the cap and floor.

The intrinsic value of a caplet is

D ⋅ max(f − x, 0) Nz

and the intrinsic value of a floorlet is

D ⋅ max(x − f, 0) Nz.

Valuation according to the Bachelier Model

If negative forward rates or strikes are involved, the Black-Scholes formula is no longer applicable due to the logarithm. In this case, the Bachelier model can be applied in the normal volatilities-based valuation.

The period of the option’s reference interest rate is derived from the payment period of the option.

With

bachelier reference interest rate.png

the market value of the caplet is

bacheliermarket value caplet.png

and the market value of the floorlet is

bacheliermarket value floorlet.png.

The value of the whole cap (floor) is the sum of the values of the individual caplets (floorlets). The value of a collar is the difference between the values of the underlying cap and floor. 

The intrinsic value of a caplet is

D ⋅ max(f − x, 0) Nz

and the intrinsic value of a floorlet is

D ⋅ max(x − f, 0) Nz.

Interpolation of the Bachelier volatilities

The volatilities for evaluation with the Bachelier model are interpolated bilinearly with strike and time till exercise.  A bilinear interpolation is done as follows:

Given four points on the volatility surface σ(t,X):  (t1, X1, σ1), (t1, X2, σ2), (t2, X3),  (t2, X2, σ4),
where t = time till exercise of the option, and X = its strike value. Then for an option with the time till exercise toption and with the strike Xoption to which: X≤ Xoption ≤ X2 and t≤ toption ≤ t2, its volatility value σoption is computed via bilinear interpolation as follows:

bachelier volatility value.png

where bachelier volatility t-option.pngand bachelier volatility x-option.png

For estimation of the volatilities outside of the delivered market data, the constant extrapolation is used.

Commodity options

Call and put options on commodities are typically traded as Asian options. This means that the option price is determined on the basis of the arithmetic average prices instead of closing rates. In this case, Coupa Treasury also relies on an extended Black-Scholes model, the so-called Modified Geometric Approximation model of Lévy and Turnbull (1992). It is based on the assumption of a log normal distributed stochastic commodity price curve (Geometric Brownian Motion), and in special cases (i.e. when only one closing rate is used) it corresponds exactly to the standard Black-Scholes model.

To evaluate a commodity option at the time T with maturity t, the following parameters will generally be used:

commodity option parameters.PNG

If the valuation date T is within the period for average calculation (T > t1), some adjustments to various parameters need to be made. These can be summarized as follows:

commodity options adjusted parameters.PNG

For valuations during the corresponding period, all cut-off dates can be considered for the final option value. This is essential to allow a correct calculation of the settlement profile of Asian options, which depends on the average of all period rates.

Valuation of call and put options

Two special cases are worth looking at first. Only in the third case, the familiar Black-Scholes formula is needed for evaluating calls and puts.

  1. All period rates are known (i.e. T > tn) and therefore m = n:

    The expected value is omitted, and the value of the option is derived directly from the settlement profile using the average exchange rate A.

    call and put all period rates are known.PNG
  2. The adjusted strike adjusted strike.PNG drops below zero, so adjusted strike les than zero.PNG:

    Call: The portion Afix of the known rates in the overall average exceeds the agreed strike. In consequence, it is clear before the expiry of the option exercising it will be beneficial. Thus, the option value is calculated directly from Commodity forwards using the linearly approximated forward prices.

    call adjusted strike below zero.PNG
    Put: Already becomes worthless before the expiry of the option, as a higher resale value is guaranteed to be achieved without the option.

    put adjusted strike below zero.PNG
  3. From the still unknown rates, an arithmetic average is calculated. This is also the first moment of the normal distribution used in the Black-Scholes formula.

    call and put unknown rates.PNG

The standard deviation from the normal distribution is also adjusted to fit the period of the unknown rates, based on the (implicit) commodity volatility commodity volatility.PNG. The formula is based on the assumption of log normally distributed specified prices X(ti) and using a calculation of the moments of the arithmetic mean A, cf. Lévy and Turnbull (1992).

For valuations of the total average period: 

valuations to the total average period.PNG

For valuations of the closing rate (i.e. only one rate affects the valuation):

valuation of the closing rate.PNG

Now d1 and d2 can be calculated directly:

d1 and d2 calculated directly.PNG

The option values will then be calculated as follows:

option values.PNG
 

  • Was this article helpful?