FIXED-FOREIGN-RATE CROSS-CURRENCY SWAP CASH-FLOW MAPPING AND VALUE-AT-RISK CALCULATION PROCEDURE

IDENTIFICATION OF STANDARD MATURITY ZERO-COUPON BONDS FOR AGGREGATION-CORRELATION-MATRIX POPULATION

1. The rationale for using standard maturity bonds is that these are usually actively traded in deep and liquid markets and therefore reliable market-consistent data for valuation parameters such as bond returns volatilities and correlations is readily available. Decomposing cash-flows from our instrument and mapping them to standard maturity zero coupon bond cash-flows therefore makes the output from our calculations market-consistent.
2. The standard maturity bonds chosen for cash-flow mapping should ideally be the ones that closely straddle the swap contract payment times, or where possible match the swap contract payment times.
3. To understand the language used in this application, suppose we have a bond that pays a coupon at time T(i) whose value-at-risk we want to calculate. We have chosen standard maturity times for zero coupon bonds in our market as T(0),T(1),T(2),T(3), and T(4) in ascending order. In this application, the shortest standard maturity time T(0) is called the zero-indexed sorted time, and T(4) is called longest standard maturity time. Suppose that after sorting the coupon payment time T(i) and standard marturity times, we get the following array of values in ascending order: T(0), T(1), T(i), T(2), T(3), T(4). The time T(1) to the left of T(i) is called the left adjacent time for this particular coupon payment time and the time T(2) to the right of T(i) is called the right adjacent time. If the time T(1) is of the same value as T(i), T(1) will then be called the matching time . When the system displays output allocation for coupon payment at T(i), it will allocate them between T(1) and T(2) then display values at other standard maturity times as zero. The process will be repeated for all other bond's coupon payments. This is for curious users who may want to understand intermediate output data.
4. Volatilities and zero-rates are assumed to be flat for maturities below the shortest standard maturity domestic bond, and flat for maturities above the longest standard maturity domestic bond.
5. If the swap payment time is shorter than the shortest standard maturity domestic bond, the bond with maturity equal to the swap payment time is the first adjacent domestic bond and shortest standard maturity domestic bond becomes the second adjacent domestic bond.
6. If the swap payment time is longer than the longest standard maturity domestic bond, the longest standard maturity domestic bond becomes the first adjacent domestic bond and the bond with maturity equal to the swap payment time becomes the second adjacent domestic bond.
7. Volatilities and zero rates are assumed to be flat for maturities below the shortest standard maturity foreign bond, and flat for maturities above the longest standard maturity foreign bond.
8. If the swap payment time is shorter than the shortest standard maturity foreign bond, the bond with maturity equal to the swap payment time is the first adjacent foreign bond and shortest standard maturity foreign bond becomes the second adjacent foreign bond.
9. If the swap payment time is longer than the longest standard maturity foreign bond, the longest standard maturity foreign bond becomes the first adjacent foreign bond and the bond with maturity equal to the swap payment time becomes the second adjacent foreign bond.
10. The system automatically checks for standard maturity bonds matching swap payment times where possible and calculates cash-low allocating proportions based on that.

Financial solutions home page

1. Log into your account or if you are a new user, register your account and enable two factor authentication.
2. Click on the [FFR Cross-currency swap value-at-risk] button, this will take you to the Dynamic-text-blocks parameters page.

Dynamic text-blocks parameters page

1. Default option to enter pairwise-varying correlations between domestic and foreign standard maturity zero-coupon bonds, and exchage rate.
2. Enter number of outstanding swap payment times.
3. Enter number of domestic zero-coupon bonds standard maturity times.
4. Enter number of foreign zero-coupon bonds standard maturity times.
5. Enter time till next swap payment.
6. Enter swap payment frequency per year.
7. Click the submit button, this will take you to the array populating page.

Array populating page

1. Enter domestic zero-rates at indicated swap payment times. The zero rates are used to calculate forward rates and then future coupon payments under the assumption that forward rates are realised. The future coupons are then cash-flow mapped to standard maturity times. It is possible to assume that the domestic floating rate bond is just the coupon and principal payable on the next coupon payment and map the cash-flow to standard maturity times. This approach, although it gives an accurate answer when valuing the floating rate bond, will give an inconsistent result when calculating value at risk especially if maturity time differs significantly from time of next coupon payment. This is because by assuming payment occurs on next payment we under-state the duration and therefore the volatility of the floating rate bond which is crucial in calculating value-at-risk. In this application, we use the forward-rates-are-realised assumption to map floating rate bond cash-flows for the purpose of value-at-risk calculation.
2. Enter domestic zero-coupon bonds standard maturity times.
3. Enter domestic zero-rates at zero-coupon bonds standard maturity times.
4. Enter domestic standard maturity zero-coupon bonds daily volatilities.
5. Enter foreign zero-coupon bonds standard maturity times.
6. Enter foreign zero-rates at zero-coupon bonds standard maturity times.
7. Enter foreign standard maturity zero-coupon bonds daily volatilities.
8. Enter pairwise correlations between domestic and foreign standard maturity zero-coupon bonds, and exchage rate.
9. Click the submit button, this will take you to the Fixed-foreign-rate cross-currency swap value-at-risk calculation parameters page.

Fixed-foreign-rate cross-currency swap value-at-risk calculation parameters page

1. Select the name of domestic currency of valuation from the drop-down list.
2. Select the name of foreign currency of valuation from the drop-down list.
3. If the time till next swap payment is less than or equal to the tenor period, enter the observed domestic floating rate convertible swap-payment-frequency times per year resulting in next swap payment.
4. Enter the fixed foreign swap rate convertible swap-payment-frequency times per year.
5. Enter domestic principal value.
6. Enter foreign principal value.
7. Enter the spot-exchange-rate: domestic currency units per unit of foreign currency.
8. Enter the exchange rate daily volatility.
9. Enter the confidence level for value-at-risk calculation.
10. Enter number of days for value-at-risk calculation horizon.
11. Click the submit button and this will take you to the output display page.

Output display page

1. You can view pricing model output together with input parameters you entered.
2. At the bottom of the page you can click on the button to create database record for the current model output. This will take you to the create database record page where you should click on the create button to create the database record.
3. After clicking on the create button to create the database record, you will be taken to the database records view page, where you can scroll vertically or horizontally to view database records including the one you just created.
4. You can filter database records according to the currency of valuation using the filter box. You can click on the details link on the extreme right of a particular database record, this will take you to the particular database record details page.