Floor - Maple Help

Finance

 Floor
 create new interest rate floor

 Calling Sequence Floor(floatingleg, exerciserates)

Parameters

 floatingleg - list of floating-rate coupons; floating leg exerciserates - non-negative number or a list of non-negative numbers; exercise rates

Description

 • The Floor command creates a new interest rate floor instrument with the specified parameters. This instrument can be viewed as a payer interest rate swap where each exchange payment is executed only if it has positive value. (see Brigo and Mercurio (2001) for more details).
 • Assume that we have a set of coupon payments to occur at the times ${T}_{1}$, ${T}_{2}$, ..., ${T}_{n}$. At each time instance ${T}_{i}$ the floor pays

$N{\mathrm{dT}}_{i}{\left({K}_{i}-P\left({T}_{i}\right)\right)}^{\mathrm{+}}$

where

 – $N$ is the nominal value,
 – ${\mathrm{dT}}_{i}$ is the year fraction between dates ${T}_{i-1}$ and ${T}_{i}$,
 – $P\left({T}_{i}\right)$ is a coupon payment at the time ${T}_{i}$,
 – ${K}_{i}$ is the fixed rate at time ${T}_{i}$.
 • The parameter floatingleg defines floating-rate coupon payments. The parameter exerciserates defines the corresponding fixed rates. The first exercise rate corresponds to the first floating rate coupon, the second exercise rate corresponds to the second floating rate coupon, etc. If the size of the exerciserates list is smaller than the size of the floatingleg list then the last exercise rate will be used for all the remaining coupons.
 • The LatticePrice command can be used to price an interest rate floor using any given binomial or trinomial tree. The BlackPrice command will compute the price of an interest rate floor using the Black model.

Examples

 > $\mathrm{with}\left(\mathrm{Finance}\right):$

Set the global evaluation date. This date is taken as the reference date for all yield curves and benchmark rates unless another date is specified explicitly.

 > $\mathrm{SetEvaluationDate}\left("November 17, 2006"\right):$
 > $\mathrm{EvaluationDate}\left(\right)$
 ${"November 17, 2006"}$ (1)

The nominal amount is 100.

 > $\mathrm{nominal}≔100$
 ${\mathrm{nominal}}{≔}{100}$ (2)

Create a 6-month EURIBOR benchmark rate with a forecasted rate of 5%. No history is available for this rate.

 > $\mathrm{benchmark}≔\mathrm{BenchmarkRate}\left(6,\mathrm{Months},\mathrm{EURIBOR},0.05\right)$
 ${\mathrm{benchmark}}{≔}{\mathbf{module}}\left({}\right)\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{}\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{\mathbf{end module}}$ (3)

Construct a discount interest rate curve.

 > $\mathrm{discount_curve}≔\mathrm{ForwardCurve}\left(0.05,'\mathrm{daycounter}'=\mathrm{Actual360}\right)$
 ${\mathrm{discount_curve}}{≔}{\mathbf{module}}\left({}\right)\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{}\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{\mathbf{end module}}$ (4)

Construct floating-leg payments.

 > $\mathrm{start_date}≔\mathrm{AdvanceDate}\left(2,\mathrm{Days}\right)$
 ${\mathrm{start_date}}{≔}{"November 19, 2006"}$ (5)
 > $\mathrm{end_date}≔\mathrm{AdvanceDate}\left(\mathrm{start_date},20,\mathrm{Years},'\mathrm{convention}'=\mathrm{ModifiedFollowing}\right)$
 ${\mathrm{end_date}}{≔}{"November 19, 2026"}$ (6)
 > $\mathrm{coupon_dates}≔\left[\mathrm{seq}\left(\mathrm{AdvanceDate}\left(\mathrm{start_date},6i,\mathrm{Months}\right),i=0..40\right)\right]:$
 > $\mathrm{floating_leg}≔\left[\mathrm{seq}\left(\mathrm{ParCoupon}\left(\mathrm{nominal},\mathrm{discount_curve},\mathrm{coupon_dates}\left[i\right],\mathrm{coupon_dates}\left[i+1\right]\right),i=1..40\right)\right]:$

Construct an interest rate floor with a fixed floor rate of 3% for all payments in the floating leg.

 > $\mathrm{ir_floor}≔\mathrm{Floor}\left(\mathrm{floating_leg},0.03\right)$
 ${\mathrm{ir_floor}}{≔}{\mathbf{module}}\left({}\right)\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{}\phantom{\rule[-0.0ex]{0.5em}{0.0ex}}{\mathbf{end module}}$ (7)

Price this instrument using the Black model with a discount rate of 5% and a volatility of 20%.

 > $\mathrm{BlackPrice}\left(\mathrm{ir_floor},0.05,0.2\right)$
 ${2.642595692}$ (8)

References

 Brigo, D., Mercurio, F., Interest Rate Models: Theory and Practice. New York: Springer-Verlag, 2001.
 Glasserman, P., Monte Carlo Methods in Financial Engineering. New York: Springer-Verlag, 2004.
 Hull, J., Options, Futures, and Other Derivatives, 5th. edition. Upper Saddle River, New Jersey: Prentice Hall, 2003.

Compatibility

 • The Finance[Floor] command was introduced in Maple 15.