SDX Interest Rates Help > Working with SDX Interest Rates > Working With the Cash Flow Dates Window > Columns in the Cash Flow Dates Window

Columns in the Cash Flow Dates Window

In the Cash Flow Dates window each coupon is displayed in its own row, each of which has its own number for reference purposes.

Which columns are displayed depends on the type of instrument chosen. The available columns are listed in Table 1.

 

Any change to the general input data for the leg, for example, a change to the frequency or the stub settings, etc., disables the coupons displayed at the bottom of the window. That is, the coupon rows are grayed out, and you must then click the Calculate button to recalculate the coupons and their results.
Any change to the input data for a coupon removes all calculated fields (including the Discount Factor, the Cash Flow, the Cash flow PV, the Principal Payment and Total Payment columns, etc., as relevant) for all the displayed coupons. You must then click the Calculate button to recalculate the coupons’ results.

 

Table 1: Columns in the Cash Flow Dates Window

Column

Description

Fixing Date

Defines the fixing date for the coupon.

* This is only displayed for the floating leg.

Start Date

Defines the start date of the coupon’s period. It is editable.

For more information on this field see Start Date.

End Date

Defines the end date of the coupon’s period. It is editable.

For more information on this field see End Date.

Days

Displays the actual number of days used in the interest rate/implied rate calculation.

This is calculated according to the day count basis defined in the pricing page.

Zero Rate

* This is displayed for a Zero Coupon Inflation Swap.

Real Rate

This defines the fixed real interest rate that is paid on an inflation-adjusted notional. For more information see Real Rate.

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Inflation Rate

Defines the inflation rate for the zero coupon inflation swap’s inflation leg. It is displayed as an annually compounded rate.

* This is displayed for a Zero Coupon Inflation Swap.

Implied CPI

Displays:

For a future date what the market thinks the defined inflation index (or CPI) will be on each coupon’s payment date.

For a historical date what the actual inflation index was on that coupon’s payment date.

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Base CPI

Displays the CPI from which the CPI change on the coupon's payment date is measured.

For a coupon for which there was no accretion payment in any of the previous coupons, this is the instrument's base reference index—as displayed in the pricing page in the Reference Index (Start) field. For a coupon for which there was an accretion payment in a previous coupon, this is the CPI on that previous coupon’s payment date.

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Margin

Defines the margin for a double period loan. This is the amount to be added to each coupon rate of both periods, i.e., to the fixed rate in the first period and the floating rate in the second period, to calculate the payout. If you leave this field blank in the pricing page, in the Cash Flow Dates window the system calculates the margin that will give a swap NPV of zero. This means that there will be no upfront payment, but that instead there will be a fixed annuity that amortizes the upfront payment over the life of the structure.

Coupon Type

Defines the type of coupon. It can be either Fixed Rate, Floater or Path Dependant.

* This is only displayed for a Snowball and a reverse snowball.

Fixed Rate

Defines the mid fixed rate to be paid or received for each individual coupon. For more information on this field see Fixed Rate.

If you update the fixed rate for individual coupons, when you click Accept the Fixed Rate field or the Market Rate button in the pricing page (as relevant to the instrument type) will display a Variable value. For more information on this feature see Manually Adjusting Values for Individual Coupons

Floating Spread

Defines the floating spread fixed rate to be used for each individual coupon.

If you update the floating spread for individual coupons, when you click Accept the Floating Spread button in the pricing page will display a Variable value. For more information on this feature see Manually Adjusting Values for Individual Coupons

Implied Rate

For:

Most instruments, for a future fixing date this column defines the forward rate (which is taken from the yield curve).

For a historical fixing date (i.e., any fixing date that is the same as or prior to the trade date) the forward rate is replaced with the actual fixing rate. However, if a trade is carried out prior to the day’s fixing time then the previous fixing rate (i.e., of the previous business day) is used until the new one is published. For a historical fixing date, the displayed rate is also editable.

For a YoY Inflation Cap or YoY Inflation Floor, the implied rate is the expected % change in the year-over-year inflation rate.

Ref Index

This column defines the inflation index measured on the date a year prior to the caplet/floorlet’s end date. So, for example, if the caplet/floorlet’s end date is set to 10 October 2012, the reference index is displayed for 10 October 2011.

Note: This can be for a date in the future.
* This read-only column is only displayed for a YoY inflation cap/floor.

End Index

This column defines the inflation index expected on the caplet/floorlet’s end date.

* This read-only column is only displayed for a YoY inflation cap/floor.

Strike

This column defines the cap or floor of each caplet/floorlet.

* This column is only displayed for a YoY inflation cap/floor.

Cap Rate

Defines the cap for the floating rate used for the coupon payments in the second payment period of a double period loan.

You must enter this amount manually in the pricing page.

Coupon

Displays a Variable button which lets you access the Digital Swap Coupon Builder where you can define the payment conditions for this particular coupon. For more information on this feature see Working With the Digital Swap Coupon Builder Window.

* This is only displayed for a digital swap’s coupons.

Coupon Rate

For a future fixing date this column defines the forward rate (which is taken from the yield curve).

For a historical fixing date (i.e., any fixing date that is the same as or prior to the trade date) the forward rate is replaced with the actual fixing rate. However, if a trade is carried out prior to the day’s fixing time then the previous fixing rate (i.e., of the previous business day) is used until the new one is published.

For a historical fixing date, the displayed rate is also editable.

* This is only displayed for a digital swap’s coupons.

Prev Cpn Leverage

Defines by how much to multiply the previous coupon’s payout for a snowball or a reverse snowball.

It cannot be a negative value.

Index Leverage

Defines the value by which the index is multiplied in the payout formula. As the index is always multiplied by a leverage factor, if you want to just use the floating rate, set the index leverage to 1.

It cannot be a negative value

Minimum Coupon

Defines the minimum coupon payment that can be made.

Maximum Coupon

Defines the maximum coupon payment that can be made, regardless of the value of the coupon payout.

Trigger

Defines the trigger for barrier/digital options.

The default value for this column is set in the Low Barrier/Lower Barrier/Low Trigger field in the pricing page.

Lower Trigger

Low Trigger

Lower Barrier

Defines the bottom of the range within which the observed fixing must fall.

The default value for this column is set in the Low Barrier/Lower Barrier/Low Trigger field in the pricing page.

Upper Trigger

High Trigger

Upper Barrier

Defines the top of the range within which the observed fixing must fall.

The default value for this column is set in the High Barrier/Upper Barrier/High Trigger field in the pricing page.

Notional

Defines the notional amount (in the defined currency) on which the interest (whether fixed or floating) is to be paid.

By default this is the notional entered for the instrument in the Single Option or Portfolio page.

Notional UDI

Notional UF

Defines the notional amount in UDI/UF units.

By default this is the notional entered for the instrument in the Single Option or Portfolio page.

* This is only displayed for the UDI leg of an UDI swap and the UF leg of an UF swap.

Accreted Notional

Displays the inflation-adjusted notional for this coupon.

This is calculated as follows:

notional x (change in inflation index measured from the instrument's start date or, if relevant, from the last accretion payback payment date to the coupon’s end date)

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Payment Date

Defines the date on which the payment must be made.

Acc. Payback

Lets you activate an accretion payment for each interim coupon in the instrument. You do this by checking the checkbox for each relevant coupon.

This functionality is useful as it lets the receiver of the leg reduce the credit risk of its counterparty not being able to pay the CPI change on the notional in full on the last coupon’s payment date.

The accretion payment cannot be disabled for the last coupon.

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Spread bp

Defines the spread in basis points which must be added to or subtracted from the interest rate index defined.

To indicate that the spread should be subtracted from the interest rate index, use the - sign.

Discount Factor

Defines the discount factor used to convert the payment amount (displayed in the Cash Flow column) to the present value (displayed in the Cash Flow PV column).

This factor is obtained from the yield curve for the defined tenor. See Yield Curve for more details on the Yield Curve page.

Cash Flow

The value amount of the payment to be made.

Cash Flow PV

The present value of the cash flow, discounted by the discount factor.

Principal Payment

Displays the payment of the principal, which is the difference in notional between the current and the previous coupon.

Total Payment

Defines the total payment.

For most instruments the total payment amount is calculated as follows:

The interest payment (as shown in the Cash Flow column) + the principal payment amount

However for a:

Double period loan, this amount shows the total that will be paid or received, i.e., it includes both the cashflow and the margin.

Cross currency swap where there is an exchange of notionals on the end date, the total payment amount for the last coupon is simply the cash flow amount This is because the cash flow amount for the last coupon has already taken into account the exchange of notional which is carried out at the end of the deal.

Actual Payments PV

Displays the actual amount to be paid on each coupon.

For each coupon in a real rate swap it is calculated as follows:

Cash flow PV + (if activated for this coupon) the accretion payback payment PV

Where the Cash flow PV is the present value of the interest payment on the accreted notional, which is the amount displayed in the Cash Flow PV column.

For each coupon in a cross currency real rate swap, this calculation also includes any principal payment PV—as long as there is an exchange of notionals on the end date (and then this is the present value of the amount seen in the Principal Payment column).

* This is displayed for a Cross CCY Real Rate Swap and Real Rate Swap.

Margin

Defines the Margin as an amount.

Margin PV

Displays the Margin as a present value (i.e., the amount which must be paid/received in addition to the cashflow).

For a double period loan this value, which is not included in the cash flow amount, must be paid/received in addition to the cashflow.

Implied Start Date

Displays the start of the period used in the calculation of the implied rate from the yield curve.

This information is important as the implied rate’s reference dates are not always the same as the actual coupon dates. For instance, they are different if the coupon's fixing date is not the default value, if you have in arrears fixings, and if the index tenor is different then payment frequency tenor (for example, you have semi annual payments and 3m libor index fixings).

* This read-only column is only displayed for a floating leg of a vanilla swap and a general swap.

Implied End Date

Displays the end of the period used in the calculation of the implied rate from the yield curve.

This information is important as the implied rate’s reference dates are not always the same as the actual coupon dates. For instance, they are different if the coupon's fixing date is not the default value, if you have in arrears fixings, and if the index tenor is different then payment frequency tenor (for example, you have semi annual payments and 3m libor index fixings).

* This read-only column is only displayed for a floating leg of a vanilla swap and a general swap.