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
- CDS ABS Index Tranche Cashflows
- Commodity OTC Option Cashflows
- Constant Maturity Swap (CMS) Cashflows
- Credit Default Swap Cashflows
- Credit Default Swap ABS Cashflows
- Equity Linked Swap Cashflows
- Non-Deliverable Swap Cashflows
- Precious Metal Deposit Lease Cashflows
- Quanto Swap (Differential Swap) 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_ |
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_ |
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. |