Cashflows Columns

This document describes the cashflow columns in Calypso.

- The general cashflows may be used by any product.

- The product-specific cashflows apply to the specified corresponding product.


Contents

- General Cashflows

- Bond Cashflows

- Call Notice Cashflows

- Cap Floor Cashflows

- Cash Cashflows

- CDS ABS Index Cashflows

- CDS ABS Index Tranche Cashflows

- Commodity OTC Option Cashflows

- Commodity Swap Cashflows

- Constant Maturity Swap (CMS) Cashflows

- Credit Default Swap Cashflows

- Credit Default Swap ABS Cashflows

- Equity Linked Swap Cashflows

- In Arrears Cashflows

- Non-Deliverable Swap Cashflows

- Performance Swap Cashflows

- Precious Metal Deposit Lease Cashflows

- Quanto Swap (Differential Swap) Cashflows

- Sales Margin Cashflows

- Swap Cashflows

- Swaption Cashflows

- Structured Flows Cashflows


 

1. General Cashflows

Column Name

Description

Act Exch

Whether there is actual exchange of principal.

All-In Rate

Used in products where the secondary market loan is an underlying instrument, such as the Performance Swap.

The rate used to calculate the interest amount on the cash flow.

For floaters, All-in Rate = Rate + Spread

For fixed, All-In Rate = Fixed Rate

If there are caps or floors, apply those, too.

AllKnown

It is checked when the reset rate is known, or clear when it is missing.

If the rate reset has been explicitly set to "0", it will appear checked.

Amort Amt

Amortized amount.

Amort Rate

Amortization rate.

Annuity Rate

Cash

Displays the amortization rate entered in the scheduler.

Capitalization Factor

Brady Bond

Setting the capitalization rate will compute the capitalization factor, which will in turn compute the face value, notional amount, and amortization amount.

Capitalization Rate

Brady Bond

Pay-in-kind rate. The coupon cap that accrues on the outstanding principal.

Cmp Begin

Begin date of compounding period.

Cmp Calc Notional

Notional for calculation of compounding flows (notional + accumulated interest).

Cmp End

End date of compounding period.

Cmp Int Amt

Displays the compounded interest amount defined at that particular period. When the interest payments are made, the application resets the compounded interest amount, and the subsequent interest payments are made on the following accrued interest.

Currency

Specifies the currency of the cash flow, which you define in the Trade panel.

Day Ct

Day count convention.

Refer to the Calypso Navigator's Help > Day-Count Conventions for a description of the conventions.

Days

Payment period length.

DC Days

The number of days in the interest period, according to the Day Count convention of the flow.

Decimals

Bonds

Number of decimal places for the coupon; the coupon digits set in the bond product.

Default Date

Bonds

Displays the date that the issuer defaulted, which is set in the Bond product. The interest flow is zero.

df

Discount factor used to discount the payment when calculating the present value.

External Id

ID of some external system from which the flow has been imported.

Ex-Dividend

Bonds

Ex-dividend date of the coupon.

Face Value

Bonds

Value of the bond at maturity, set on the Bond product.

Final Index Level

Inflation Swap

The final inflation index level.

Final Publ Date

Inflation Swap

The final publication date of the inflation index level.

Final Rate

Interest Rate Derivatives

Rate * Index Factor + Spread = Final Rate

Spread Swap and Spread Cap Floor

(Rate 1 * Index Factor 1 + Spread 1) + (Rate 2 * Index Factor 2 + Spread 2) = Final Rate

 Ⓘ   [NOTE: Rounding can be applied in different ways based on the Rate Index attributes ROUND_FINAL_RATE and ROUND_FINAL_RATE_ISDA]

Final Ref Date

Inflation Swap

The final reference date when the inflation is effective.

Fixed

The checkbox is selected if the interest rate is fixed.

To use a floating rate for a flow, customize the cashflows. Deselect the Fixed checkbox. Double-click the Index Name column, and select the currency, index name, tenor, and rate source from the drop-down menu.

Fwd Begin/End

Start/end date of the forward period for which the pricer forecasts the floating rate in the swap.

Fwd Rate

Forecasted forward rate for the interest or compounding period.

Fwd Rate * Index Factor

Interest Rate Derivatives

Forward rate for factored indices.

FX Rate

The FX rate used in conversion from one currency to another (trade currency to settlement currency for example).

FX Reset Date

Date that the FX rate is reset on the cash flow.

Has Coupon Schedule

Repos and Security Lending

Selected if the underlying Bond has a custom coupon schedule.

Index Factor

Index factor.

Index Name

A flow using a floating interest rate displays the name of the index from which it receives the rate. Uses the index that you selected in the Trade panel, however, you can select a different index in the Cashflows panel for an individual flow.

Idx Term

Tenor of the reference index.

Inflation Factor

Inflation Swap using Inflation Indexation

Final inflation level /Initial inflation level

Init Index Level

Inflation Swap

The initial inflation index level.

Init Publ Date

Inflation Swap

The initial publication date of the inflation index level.

Init Ref Date

Inflation Swap

The initial reference date when the inflation is effective.

Int Face Value

Interest face value.

Int Total Amt

Cash

The interest amount and the compounding interest amount.

Interest Amt + Cmp Int Amt

Interest Amt

Payment amount. For floating rate payments, this will be zero until the rate is set.

Interp

Checkbox that indicates if the index tenor for the flow is interpolated.

Interp Rounding

Interpolating rounding method.

Interp Rounding Dec

Interpolating rounding method decimal places.

Is Compound Period

When this checkbox is selected, the Compounding occurs at the End of the Period.

Lower/Floor Proj Amt

Floor and Collar

Projected amount of a floorlet.

Manual Amt

Specifies that the payment amount is a calculated amount that you have changed to a fixed amount by entering the amount manually. Applies to interest and price change flows. Changing parameters normally used in the amount calculation (fixed rate, interest start and end dates) do not change the payment amount when Manual Amt is selected.

Manual Reset

The application selects this checkbox when you edit the Interest Amt manually. Allows you to modify the interest amount independently of the reset rate.

NB. Days

The number of calendar days in the interest period, between the Pmt Begin date and the Pmt End date.

Notional

Principal amount for the period.

Notional Reset

The accretion index last reset date.

Ntnl+Int

Notional principal + interest amount.

Ntl Index Value

Inflation Indexed Bond

Notional index value set on the bond.

Option Type

Capped Swap

Payout formula type, for example, Range Floater.

Commodity Cap Floor

Specifies whether the option type is Cap, Floor, Collar, or Straddle.

Payout Rate

In floating rate bonds, the real rate used to calculate the interest amount (includes the spread and considers the floor and cap).

Period

Period length expressed in years.

Pmt Amt

Payment amount of the flow.

Pmt Begin

Payment period start date.

Pmt Dt

Payment date.

Pmt End

Payment period end date.

PreConverted Fwd Rate

Forward rate before basis conversion of projected forward rate.

PreConverted Rate

Rate before basis conversion of automatic reset rates.

Principal Amt

The principal amount exchanged in that flow.

Proj Amt

Projected amount for the flow.

Proj FX Rate

The projected FX rate.

Proj Notional

Projected notional.

PV Disc

Interest Amt * df

Pmt Amt * df

Rate

Interest rate.

Rate Rounding

Rounding method for the stub period.

Rate Rounding Dec

Rounding method decimal places.

Record Date

Bonds

Displays the record date for information purposes, only. The record date is the ex-dividend date of the coupon unless the Bond product includes a record days offset.

ReFixed Rate

Repo

Displays the reset rate set in Reset Samples on the flow generated to clean-up the interest.

Reset

Reset date for the floating interest rate.

Sample Begin

Sample begin date for averaging resets.

Sample End

Sample end date for averaging resets.

Spread

Spread to be applied to the floating interest rate.

If you customize the Spread, that flow changes; any remaining open flows keep the original spread.

Commodities

Specifies the spread entered according to the delivery location. You can enter the spread in the Definition panel, or customize the spread for each delivery period in the cashflows.

Spread Interest

Interest Rate Derivatives

Notional * Spread * Period

Strike-lower

The floor rate.

Strike-upper

The cap rate.

Tax

Bonds

Withholding tax set in the Bond product.

Type

Displays the type of flow. Examples include: COMMODITY, DIVIDEND, INTEREST, PRICE_CHANGE, and PRINCIPAL.

UnAdjusted Principal Amount

Inflation Swap using Inflation Indexation on Principal Flows

The principal amount prior to applying any inflation indexation. See Inflation Factor.

UnAdjusted Interest Amount

Inflation Swap using Inflation Indexation on Interest Flows

The interest amount prior to applying any inflation indexation. See Inflation Factor.

Upper/Cap Proj Amt

Cap and Collar

Projected amount of the caplet.

Vol-Barrier

Exotic Cap Floor

The barrier volatility.

You can overwrite the barrier volatility value in the BARRIER_VOL transient parameter.

Vol-lower

The put volatility.

Vol-upper

The call volatility.

 

2. Bond Cashflows

Column Name

Description

FX Rate

In dual currency bonds, the coupon currency is different than the nominal currency. You can customize the FX rate for each coupon.

Has Varying Schedule

Selected if the pay-down schedule is varying.

Interest ShortFall

Intex integration. Interest shortfall.

Interest ShortFall Reim

Intex integration. Interest shortfall payback.

Pool Factor

Outstanding pool principal divided by original principal, expressed as a decimal between 0 and 1.

Principal ShortFall

Intex integration. Principal shortfall.

Principal Writedown

Intex integration. Principal writedown.

Quantity

Principal for the period.

Scheduled Principal Amt

Intex integration. Scheduled principal amount.

Unscheduled Principal Amt

Intex integration. Unscheduled principal amount.

Inflation Indexed Bonds

Infl. Factor

Point on the Inflation Curve on the payment date of the flow.

Infl. Index Factor

On the base date of the Inflation Curve we try to get the index factor from the quote set, for example 122. Then we normalize it to calculate the inflation factor by dividing it by the notional index value (for example 101, which is product specific).

Infl. Unadj. Proj. Amt

Unadjusted flow amount.

Inflation

Inflation by which we adjust the notional amount of a flow at time t = indexFactor * inflationFactor.

Init Infl Reset Date

Initial Inflation Reset date.

Initial Reference Number Projection Date

Initial reference number projection date. Taken from the Bond Product Definition.

Projected Initial Reference Number

Projected initial reference number. Taken from the Bond Product Definition.

Final Infl Reset Date

Final inflation reset date.Reset is computed based on the end period of the cashflows.

Final Reference Number Projection Date

Final reference number projection date.

Projected Final Reference Number

Projected final reference number.

PricerBond

Credit Coupon

Credit Derivatives

Present value of the credit coupon. Proj Amt = Credit Coupon + Credit Principal

If the INCL_RECOVERY_COUPON and INCL_RECOVERY_PRINCIPAL pricing parameters are true, then Credit Coupon = Pmt Amt * (End Survival Prob. + (Recovery Rate * (Start Survival Prob. - End Survival Prob.))

If INCL_RECOVERY_COUPON and INCL_RECOVERY_PRINCIPAL are false, then Credit Coupon = Pmt Amt * End Survial Prob.

Credit Principal

Credit Derivatives

Present value of the credit principal. Proj Amt = Credit Coupon + Credit Principal

If INCL_RECOVERY_PRINCIPAL is true, then Credit Principal = Notional * (End Survival Prob. + Recovery Rate * (Start Survival Prob. - End Survival Prob.))

If INCL_RECOVERY_PRINCIPAL is false, then Credit Principal = Notional * End Survival Prob.

Probable Amount

The probable amount that will be received. This is the fixed or floating amount adjusted by the riskiness of the bond. This is stored in the user data of the flow, not in the projected amount.

Probable PV

The npv of the flow. This is stored for display purposes only and is used by the cashflow table. This is the discount factor times the probable amount.

Recovery Rate

Credit Derivatives

Displays the expected recovery if the issuer defaults.

Start Default Prob.

End Default Prob.

Credit Derivatives

Probability that default will occur. 1 - Start Survival Prob.

Probability that default will occur. 1 - End Survival Prob.

Start Survival Prob.

End Survival Prob.

Credit Derivatives

Probability that default will not occur based on the Pmt Begin date.

Survival probability (interpolated) based on Pmt End date.

PricerBondAssetBacked

CPR

Prepay annual rate %.

Estimate Face Value

Face Value included in the Principal PrePayment Estimation.

Estimate Interest

Projected amount.

Estimate Pool Factor

Pool Factor included in the Principal PrePayment Estimation.

Estimate Principal PrePayment

Scheduled Principal * CPR

Projected Notional

Original notional amount + estimated principal prepayment amount.

Scheduled Mortgage Payment

The scheduled mortgage payment for the period.

Scheduled Principal

Value of the Scheduled Principal Payment (Scheduled Payment - Scheduled Interest).

PricerBondAusCPI – Australian Capital Indexed Bonds

K-Factor

The compounded inflation-adjusted principal value.

p-Factor

Average inflation between the reported Consumer Price Index (CPI) for that date and the figure six months previous.

 

3. Call Notice Cashflows

Column Name

Description

All In Rate

Internal Rate + Internal Spread + Sales Margin

Internal Rate

Internal Rate from the yield curve.

Internal Spread

Internal spread from the Quote Engine.

Sales Margin

Sales margin entered in the trade or from the Customer Quote Engine.

 

4. Cap Floor Cashflows

Column Name

Description

Payoff Factor(%)

Displays the payoff factor that you entered in the Trade panel. This factor applies to all caplets that payout.

In the Cashflows panel you can customize the factor for an individual caplet by changing the factor percentage.

PricerCapFloor

PRICER_LOWERSTRIKEVOL

The put volatility.

For Collar or Straddle trades, both PRICER_UPPERSTRIKEVOL and PRICER_LOWERSTRIKEVOL are populated. For Cap trades, PRICER_UPPERSTRIKEVOL only; for Floor trades, PRICER_LOWERSTRIKEVOL only.

PRICER_UPPERSTRIKEVOL

The call volatility.

PricerCapFloorBpVol

BLACK_EQUIV_VOL

The Black equivalent volatility.

DELTA

The DELTA measures how the options' value (which is the same as the current premium) varies with changes in the underlying price. Mathematically, Delta is the first partial derivative of the option price with respect to the underlying.

GAMMA

GAMMA measures how much the Delta of an option changes with changes in the underlying price. Mathematically this is the second partial derivative of the option price with respect to the underlying price.

NPV_INTRINSIC

Intrinsic value of the option.

THETA

Theta is the change in an option's value relative to a change in the time left to expiry. In other words, Theta measures how much an option's value changes with changes in time to maturity. Mathematically, this is the partial derivative of the option price with respect to the time to maturity.

TIME_VALUE

Time value of the option.

VEGA

Change in an option's value relative to a change in the underlying instrument's volatility. Mathematically, this is the first partial derivative of the option price with respect to volatility.

PricerCapFloorCMSHagan

UNADJ SWAP RATE

Unadjusted forward rate for the period.

 

5. Cash CashFlows

Column Name

Description

All In Rate

Internal Rate + Internal Spread + Sales Margin

Internal Rate

Internal Rate from the yield curve.

Internal Spread

Internal spread from the Quote Engine.

Sales Margin

Sales margin entered in the trade or from the Customer Quote Engine.

WithHoldingTax Rate

Displays the withholding tax fee applied to the cash flow.

 

6. CDS ABS Index Cashflows

Column Name

Description

Fixed Correction

The amount of correction corresponding to a shortfall amount that was understated and a recovery amount overstated.

Float Correction

The amount of correction corresponding to a shortfall that was overstated and a recovery amount understated.

Int. ShortFall

The interest amount shortfall, which is the difference between the expected interest payment and the actual interest payment paid on the reference obligation.

Int. ShortFall Reim

The recovery amount of an interest shortfall previously reported.

Pool Factor

The pool factor for coupon and principal reduction factors. The initial value of the pool factor is 1, and it decreases with the reduction factors.

Prin. ShortFall

The principal shortfall amount, which occurs if the reference ABS fails to pay off principal by its legal final maturity, or when the collateral pool supporting the reference obligation is liquidated.

Prin. ShortFall Reim

Recovery amount of the a principal shortfall previously reported.

Writedown

The writedown amount, or a reduction in the principal.

Writedown Reim

The recovery amount of a writedown previously reported.

 

7. CDS ABS Index Tranche Cashflows

Column Name

Description

Loss Amount

The loss amount.

Pool Factor

The pool factor for coupon and principal reduction factors. The initial value of the pool factor is 1, and it decreases with the reduction factors.

Reim Amount

Reimbursement amount.

 

8. Commodity OTC Option Cashflows

Column Name

Description

ATM Volatility

ATM volatility for the option.

BreakEven Price

Price at which a zero profit is recorded for the optionlet in deal currency per deal unit.

Buy/Sell

Direction of the optionlet.

Commodity Reset

Commodity reset selected in the trade.

Custom Fixing Dts B

You can select custom fixing dates when you select a cash flow, right-click and choose Show Fixings.

Deal Currency

Defaults to the payment currency selected in the trade.

Deal Delta

Delta in deal currency per deal unit.

Deal Gamma

Gamma in deal currency per deal unit.

Deal Proj. Amount

Projected amount in deal currency.

Max(0, (Deal Proj. Price in strik units - Strike)) * deal quantity

Deal Proj. Price

Projected price in deal currency per reference unit.

Deal Quantity

Quantity captured in the trade.

Deal Unit

Units specified in the trade.

Deal/Strike Proj. Price

Projected price in deal currency per strike unit.

Forward Delta

Deal Delta (dealUnits) / discount factor

Forward Premium

PV (dealCurr) / discount factor

OptionPrice

Price for the optionlet.

Period Start

Period End

Start and end dates for the cash flow.

PV

PV in deal currency.

Reference Currency

Reference currency as specified in the commodity reset.

Ref. Delta

Delta in deal currency per reference unit.

Ref Floating Price

Floating price in reference currency per reference unit.

Ref. Gamma

Gamma in deal currency per reference unit.

Ref Proj. Price

Projected price in reference currency per reference unit.

Reference Quantity

Quantity specified in reference currency and unit.

Ref Realized Price

Realized price in reference currency per reference unit.

Reference Unit

Reference unit as specified in the commodity reset.

Ref/Strike Floating Price

Floating price in reference currency per strike unit.

Ref/Strike Proj. Price

Projected price in reference currency per strike unit.

Ref/Strike Realized Price

Realized price in reference currency per strike unit.

Strike

Lower Strike

Upper Strike

Strike price in deal currency.

Lower Strike price in deal currency.

Upper Strike price in deal currency.

Strike Unit

Units for the strike.

Theta

Measures the optionlet’s value relative to a change in the time left to expiry.

Total Commodity Fixings

Known Commodity Fixings

Unknown Commodity Fixings

Total commodity fixings for a cash flow period.

Fixings with known prices.

Fixing with prices not yet known.

Vega

Vega in deal currency.

Volatility

LowerVol

UpperVol

Volatility from the surface.

 

9. Commodity Swap Cashflows

The cashflows also display a set of the net columns, which includes Price Diff columns for the difference in price between the pay and the receive leg.

Column Name

Description

Average FX Rate

The FX Quote averaged across the fixings by the Averaging Policy.

Currency

Payment currency for the cash flow.

Custom Fixing Dates

This checkbox is select if you have specified custom fixing dates for the period in the Commodity Fixings dialog window.

Days

Number of days in the period.

Deal Quantity

The deal quantity specified for the period.

Deal Units

Units specified in the trade.

Delta (RefUnit)

Delta in the reference unit as specified in the commodity reset definition.

Df Weighted FX Rate

This column does not appear by default, as the Average FX Rate column may be used.

For the DF Weighted FX Rate column, the known fixings have a discount factor of 1.

Fixing Date

The date that the price is fixed for the settlement.

Fixing Price

The price that is fixed for the settlement.

Fixing Start

Fixing End

The start and end dates of the fixing period.

Floating Price (DealCurr/DealUnit)

Floating price in deal currency per deal unit.

Floating Price (DealCurr/RefUnit)

Floating price in deal currency per reference unit.

Floating Price (DealCurr/StrikeUnit)

Floating price in deal currency per strike unit.

Known Fixings

Number of known fixing dates in the period.

Payment Amount (DealCurr)

Payment amount in the deal currency.

Payment Date

Date that the swaplet payment date occurs.

Period Start

Period End

Start and end date of the swaplet period.

Projected Amount (DealCurr)

Projected amount in deal currency.

Projected Amount (RefCurr)

Projected Price in Reference Currency per Reference Unit * Reference Quantity

Projected Price (DealCurr/DealUnit)

Projected price in deal currency per deal unit.

Projected Price (DealCurr/RefUnit)

Projected price in deal currency per reference unit.

Projected Price (DealCurr/StrikeUnit)

Projected price in deal currency per strike unit.

Projected Price (RefCurr/RefUnit)

Projected price in reference currency per reference unit.

PV (DealCurr)

PV in the deal currency.

Realized Price (DealCurr/DealUnit)

Realized price in deal currency per deal unit.

Realized Price (DealCurr/RefUnit)

Realized price in deal currency per reference unit.

Realized Price (DealCurr/StrikeUnit)

Realized price in deal currency per strike unit.

Reference Currency

Currency of the underlying commodity as defined in the commodity reset definition.

Reference Quantity

The deal quantity converted to the reference units.

Reference Units

The units specified for the underlying commodity in the commodity reset definition.

Spread Adjusted Price (DealCurr/DealUnit)

Spread adjusted price in deal currency per deal unit.

Spread Adjusted Price (RefCurr/DealUnit)

Spread adjusted price in reference currency per deal unit.

Swaplet Breakeven Price (DealCurr/DealUnit)

Price at which a zero profit is recorded for the swaplet in deal currency per deal unit.

Swaplet Breakeven Price (DealCurr/RefUnit)

Price at which a zero profit is recorded for the swaplet in deal currency per reference unit.

Swaplet Breakeven Price (DealCurr/StrikeUnit)

Price at which a zero profit is recorded for the swaplet in deal currency per strike unit.

Total Fixings

Total number of fixings for the swaplet.

Unknown Fixings

Number of the fixings that have not yet occurred for the swaplet.

 

10. Constant Maturity Swap (CMS) Cashflows

Column Name

Description

CMS_ADJUSTMENT

Displays the total adjustment in CMS rate.

CMS_CORR_RATE_INDEX_
PAYMENT_INDX

Displays the correlation between payment index and rate index.

CMS_PAYMENT_INDEX_VOL

Displays the payment index volatility in percentage.

CMS_RATE_INDEX_VOL

Displays the rate index volatility in percentage.

 

11. Credit Default Swap Cashflows

Column Name

Description

PV Credit

PV Credit = - (termination payment * (Start Survival Prob. – End Survival Prob.) * df)

Termination payment is typically notional – recovery.

PV Premium

Interest Amt * df * Start Survival Prob.

Start Survival Prob.

End Survival Prob.

Survival probability based on Pmt Begin date.

Survival probability (interpolated) based on Pmt End date.

 

12. Credit Default Swap ABS Cashflows

Column Name

Description

Int. ShortFall

The interest amount shortfall, which is the difference between the expected interest payment and the actual interest payment paid on the reference obligation.

Int. ShortFall Reim

The recovery amount of an interest shortfall previously reported.

Pool Factor

The pool factor for coupon and principal reduction factors. The initial value of the pool factor is 1, and it decreases with the reduction factors.

Prin. ShortFall

The principal shortfall amount, which occurs if the reference ABS fails to pay off principal by its legal final maturity, or when the collateral pool supporting the reference obligation is liquidated.

Prin. ShortFall Reim

Recovery amount of the a principal shortfall previously reported.

Writedown

The writedown amount, or a reduction in the principal.

Writedown Reim

The recovery amount of a writedown previously reported.

Implied Writedown Amt If the reference ABS does not allow for writedown, an Implied Writedown may apply as a credit event. The amount of Implied Writedown is calculated based on the under-collateralization of the reference security, or any shortfall between the reference obligation's pool balance and the aggregate balance of all pari passu obligations and senior securities backed by the same pool.
Implied Writedown Reimbursement Amount If the underlying instruments do not provide for writedowns, applied losses, principal deficiencies or realized losses in regard to the reference obligation, an amount determined by the Calc Agent will be provided.

 

13. Equity Linked Swap Cashflows

Column Name

Description

Price Change Cashflows

Fixing Dt

Date that a price or rate is fixed on the cash flow.

Pay Proj. Start Price

Pay Proj. End Price

The projected start and end price of the equity in the pay currency.

Pay Start Price

Pay End Price

The start and end price of the equity in the pay currency.

Proj. Start FX

Proj. End FX

If the reference currency does not match the pay currency, then the Proj. Start Price and Proj. End Price will be converted into the pay currency using the projected FX rates.

Proj. Start Price

Proj. End Price

Projected Start and End price of the equity from the dividend curve.

Proj. Start Qty

Proj. End Qty

Projected start and end quantity.

Ref. Ccy

The currency of the underlying equity.

Start FX rate

End FX rate

If the reference currency does not match the pay currency, then the Start Price and End Price will be converted into the pay currency using the FX rates.

Start Price

End Price

Start and End Price of the equity.

Start Quantity

End Quantity

Start and end quantity of the equity.

Dividend Cashflows

Div Ex Date

Projected dividend ex-date based on the dividend rule associated with the trade.

Div Qty

Number of shares negotiated at transaction level.

Div Ratio

100%.

Div Record Date

Projected dividend date based on the dividend curve associated with the trade.

Div retro rate

Retrocession Rate negotiated at transaction level. Final Dividend Amount adjusted by this coefficient.

Div Tax Refund

Refund the taxes attached to the dividend.

Div Unit Amt

The dividend unit amount is based on the projected dividend of the dividend curve associated with the trades.

Note that in order to generate projected dividends, the dividend curve associated with the trade must be a discrete dividend curve.

Proj Div Unit Amt

Projected dividend unit amount.

 

14. In Arrears Cashflows

Column Name

Description

IA_ADJUSTMENT

Displays the total adjustment.

IA_CORR_RATE_INDEX_
PAYMENT_INDX

Displays the correlation between the payment index and the rate index.

IA_PAYMENT_INDEX_VOL

Displays the payment index volatility in percentage.

IA_RATE_INDEX_VOL

Displays the rate index volatility in percentage.

 

15. Non-Deliverable Swap Cashflows

Column Name

Description

df Settle

The discount factor converted to the settlement currency.

Interest Amt in Native Ccy

The interest amount in the native or non-deliverable currency.

Native Ccy

The native or non-deliverable currency.

PV Disc in Settlement Currency

Interest Amount (settle ccy) * df (settle ccy)

Settlement FX Description

Includes the currency pair and the FX Reset name.

Settlement FX Rate

The FX reset rate used to convert the interest amount to the settlement currency.

Settlement Reset

Date of the FX Reset.

 

16. Performance Swap Cashflows

Column Name

Description

Price Change Cashflows

Fixing Dt

Date that a price or rate is fixed on the cash flow.

Proj. Start FX

Proj. End FX

If the reference currency does not match the pay currency, then the Proj. Start Price and Proj. End Price will be converted into the pay currency using the projected FX rates.

Proj Start Price

Proj End Price

Projected Start and End price of the equity from the dividend curve.

Proj Start Qty

Proj End Qty

Projected start and end quantity.

Ref. Ccy

The currency of the underlying equity.

Start FX rate

End FX rate

If the reference currency does not match the pay currency, then the Start Price and End Price will be converted into the pay currency using the FX rates.

Start Price

End Price

Start and End Price of the underlying.

Start Notional

End Notional

Start and end notional of the underlying.

Sub Id

Id of the underlying.

Dividend Cashflows

Div Ex Date

Projected dividend ex-date based on the dividend rule associated with the trade.

Div Qty

Number of shares negotiated at transaction level.

Div Ratio

100%.

Div Record Date

Projected dividend date based on the dividend curve associated with the trade.

Div retro rate

Retrocession Rate negotiated at transaction level. Final Dividend Amount adjusted by this coefficient.

Div Tax Refund

Refund the taxes attached to the dividend.

Div Unit Amt

The dividend unit amount is based on the projected dividend of the dividend curve associated with the trades.

Note that in order to generate projected dividends, the dividend curve associated with the trade must be a discrete dividend curve.

Proj Div Unit Amt

Projected dividend unit amount.

Bond Index Cashflows

Start Mod Adj Duration

Bond index - start modified adjusted duration for the period.

End Mod Adj Duration

Bond index - end modified adjusted duration for the period.

Start Spread

Bond index - start spread for the period.

End Spread

Bond index - end spread for the period.

 

17. Precious Metal Deposit Lease Cashflows

Column Name

Description

Interest Amt in Native Ccy

Interest amount in the precious metal currency before it is converted using the FX rate.

 

18. Quanto Swap (Differential Swap) Cashflows

Column Name

Description

QTO_ADJUSTMENT

Displays the total adjustment.

QTO_CORR_RATE_INDEX_FX

Displays the correlation between the FX rate and the rate index.

QTO_FX_VOL

Displays the FX rate volatility.

QTO_RATE_INDEX_VOL

Displays the index rate volatility in percentage.

 

19. Sales Margin Cashflows

Column Name

Description

Disc. Interest Amt (Sales Margin)

Interest Amt(Sales Margin) * df.

Present value of the sales margin cash flow.

Interest Amt (Sales Margin)

Sales margin amount for the payment period.

Sales Margin

Percentage of the notional applied on the premium date.

 

20. Swap Cashflows

Column Name

Description

Coupon Formula

The quotable variable defined in the exotic structure.

Exotic Capital

Displays the notional or variable that represents the notional amount in the exotic structure.

Net Proj Amt

Displays the net projected amount from both legs’ flows. If the net projected amount contains flows that are more than 5 days apart, then the amount has an asterisk (*) displayed after the number.

Net PV Amt

Displays the net amount from both legs’ flows. If the net amount contains flows that are more than 5 days apart, then the amount has an asterisk (*) displayed after the number.

Redemption Formula

The redemption formula defined in the exotic structure.

 

21. Swaption Cashflows

See also Swap Cashflows.

Column Name

Description

Adj FX

Displays the FX rate used to calculate the adjustment amount.

Adj Reset

Displays the FX Adjustment reset date.

Prin Adj

Shows which period requires the FX Adjustment.

Prin Adj Amt

Shows the adjustment amount for the period.

 

22. Structured Flows Cashflows

Column Name

Description

Int Pmt Amt

Displays the interest payment amount.