Creating Structured Deals (W5)

This version is superseded. Click here to view the latest guide.

PURPOSE

This document shows how to structure or group trades in the CS Lucas system.

WHY IS THIS IMPORTANT?

This allows trades to be grouped/ linked for the purpose of reporting. One typical example is to link Interest Rate Swap trades that hedged with floating Term Loan trades.

PROCEDURE

1. From the main menu, select Transaction > Structured Deals.

2. To create new trade structure, click on New. The screen below will be displayed.

3. Fill out the mandatory fields. Enter a short name for the new trade structure.

4. Select the Accounting Centre or the Accounting Centre group of the trade structure.

5. Select the Type as “-IRS/TL HEDGE-“ for grouping Interest Rate Swap and Term Loan hedging trades.

6. Enter the description if any. This is optional.

7. Click Update. The Trade Structure/Composer main screen will show the newly created trade structure in the listing. The newly created trade structure will show with an N.

8. Tick on the checkbox beside the N.

9. Click Approve.

10. Once the trade structure created, click on the Trade ID to drill down to Amend Trade Structure/ Composer screen. Tick on the Maintain items checkbox to group/ link trades.

11. More fields will be displayed at the bottom of the page for you to filter out trades. Select the Accounting Centre, Transaction Type and TDate From. In this example, we will group one Term Loan and one Interest Rate Swap trade.

12. Choose the accounting centre, select the transaction type as Term Loan, TDate from 1-Jan-2015 and click Refrresh. System will filter out Term Loan trades which trade date start from 1-Jan-2015.

Term Loan

13. Click Add Button to add the Term Loan trade to the structure.

14. Continue to add for Interest Rate Swap trade. Select the transaction type as Interest Rate Swap this time and click Refresh.

15. Click Add Button to add the Interest Rate Swap trade to the structure.

16. Click on the Refrsh Button next to Term Loan’s weighting. System will recompute the Term Loan’s weight that are hedged with the Interest Rate Swap trade. Note that the system always based on the initial loan principal amount and does not assume for repayment of the principal when computing the Term Loan’s weight.

In this example, 10 mil out of the Term Loan’s 80 mil is hedged.

17. Click Update after the trade structure is properly set. Note that the weighting can be overwritten, change the values directly to the Weight(%) field and update.

18. Once the trade structure is created, reports can be printed from the system to show the hedging analysis as per below. These reports can be retrieved from Reporting > Standard from the main menu.

Creating Structured Deals (W5)

Published by admin on May 23, 2023