This chapter provides an overview of the deal capture process and discusses how to:
Define deals.
Define amortization functionality for interest-rate, physical deals and interest-rate, swap deals.
Enter margin and reset rates.
Specify common deal-capture functionality.
Set deals.
Create on-behalf-of deals.
Create trade tickets.
This section lists prerequisites and common elements.
Before you capture deals, you need to:
Define instruments.
(Optional) Create instrument templates.
Establish deal trees.
Establish position limits.
See Setting Up Trees and Positions.
The value that you select from this drop-down list determines which set of accounting templates on the Accounting Templates page to use when generating accounting events for the deal. You can create additional accounting treatment types by adding or modifying translate values for the TRA_ACTG_TREATMENT field by using PeopleSoft Application Designer. The Financial Accounting Standards Board (FASB) defines these options: Available for Sale: Indicates that the deal could be sold before its maturity date. Held to Maturity: Indicates that the deal will be held until its maturity date. Loans and Receivables: Indicates that the deal is a loan that is granted by the enterprise's treasury. Trading: Indicates that the deal will likely be sold before its maturity date. Other: Indicates that items do not fall within the previously listed parameters. |
|
Amort Method (amortization method) |
See Defining an Amortization Method for an IRP or IR Swap Deal |
Business Day Convention |
For the purposes of calculating interest, a business day convention is used for establishing the beginning and end of interest periods. The options are:
|
Cash Flows |
Click to view the cash flows that result from this deal. This button initially generates cash flows if none exist. After cash flows have been generated—and if the parameters of the deal have not been changed—clicking this button displays the previously generated cash flows. The existence of the Cash Flow button is dependant upon the instrument type that is selected. |
Compound Frequency |
Define at what interval the interest compounds. |
Day Count Basis |
Select a day count basis. Values are: 30/360: Assumes that a year consists of 12 months with an equal length of 30 days. A special rule applies when you are dealing with the end of a month. 30E/360: Assumes that a year consists of 12 months with an equal length of 30 days. This is also known as Euro 30/360. Note. The difference between the 30/360 calculation and the 30E/360 calculation occurs when a period ends on the 31st but did not start on the 30th or 31st. In this case, the 30/360 calculation uses the 31st day as equal to 31, while the 30E/360 calculation uses the 31st day as equal to 30. For example, using the 30/360 calculation, the period starting December 1 and ending December 31 contains 30 days. Using the 30E/360 calculation, however, the same December time period contains only 29 days. Actual/360: Assumes that a year consists of 360 days, but the months are counted as actual calendar days. Actual/365: Assumes that a year consists of 365 days, but the months are counted as actual calendar days. Actual/Actual: Assumes that the number of days between two dates is the actual number of calendar days. |
Day Counted Interest |
Select to have the system use the actual number of days between interest dates to calculate interest payments. If you select this value, then select Use Actual Interest Dates or Use Nominal Datesto determine which interest dates to use when calculating interest payments. If you select Use Nominal Dates, the nominal interest dates (the interest dates before adjusting for nonbusiness days and weekends) determine the amount of the interest payment. If you select Use Actual Interest Dates, the actual interest dates (the interest dates after adjusting for nonbusiness days and weekends) determine the amount of the interest payment. |
Deal Status |
This field has the default value of Open until you change it. The security level dictates whether you can change this value. Open deal status is the standard for preapproved deals or deals that require approval. Values are: Deactivated: Indicates an open deal, erroneously entered and canceled. Forecasted: Indicates a forecasted transaction. Matured: Indicates a contractual deal past its maturity date. Open: Indicates an active and open contractual deal. This is the default status for all deals. Sample: Indicates a sample-only deal; do not use as an actual deal transaction. Sold / Bought Back: Indicates a deal sold that is to another counterparty or bought back from the counterparty. Under Negotiation: Indicates a deal that’s in the process of being entered or preauthorized. Partially Sold / Bought Back: Indicates a part of a deal that is sold to another counterparty or bought back from the counterparty. |
Deal Test |
Click to ensure that this deal meets the conditions that are specified on the Deal Conditions page. If the deal meets the specified conditions, a message states that the deal passed checks. If not, the Deal Checking page displays the conditions that were not met. You can use this function only if a deal exists in a position tree to use this function. A deal exists in a tree if you select the Deal Must Exist as a Leaf check box in the Tree Wide Options page. |
Description |
For a single line instrument or for futures, if the Description field is blank, the system populates the description when you save the deal. Leave the Description field blank, enter all deal specifics, save the deal, and then edit the system-generated description according to your requirements. |
Exclude from Position |
Select to exclude this deal from position analysis. Use this as a flag when you set up selection criteria in position analysis. When excluding a position from position analysis, you must add a selection condition to the top node of the position tree. For example: EXCLUDE FROM POSITION Not Equal Y |
Fees |
Click to access the Fee Entry page to enter fees that are associated with a deal. The existence of the Fees link is dependant upon the instrument type that is selected. See Creating Fee Entries. |
First Coupon Period |
You must select a value for this field if you selected the Same Interest for each Period option. Define the term for the first interest payment. The values are:
|
Forwards from Issue Date |
See Interest Date Rule |
Index Margin |
For interest calculations, the index margin is the value that is added to the reset index, or the value by which the reset index is multiplied. Use the Margin Operator field to specify whether the interest calculation involves adding or multiplying of the index margin value. |
Interest Calculation |
Specify the method to use to calculate interest from the: Discount to Yield: Select for discount securities that are quoted using a money market yield. This method uses the rate to derive the settlement amount. The difference between the settlement amount and the par amount is the interest. Interest Bearing: Select for interest-bearing instruments. This method calculates interest for each period and pays interest on each period end date. Straight Discount: Select for money market instruments that are quoted on a straight discount or discount rate basis. This method uses the rate to calculate a discount amount, and then subtracts this amount from the par amount to obtain the purchase price or settlement amount. |
Select an interest date rule to use to define how interest is calculated and when payments will be paid. Depending on the values that you select in this list, complete the related fields. Values are:
|
|
Interest Dates |
The values are:
|
Interest Frequency |
Select an interval that reflects the cash flow frequency for the deal. Options are Annual, At Maturity, Every 28 Days, Every 35 Days, Every 49 Days, Monthly, Quarterly, Semi-Annual, and Weekly. In the Compounds field, define how frequently this interest interval compounds. Options are Annual, At Maturity, Every 28 Days, Every 35 Days, Every 49 Days, Monthly, Quarterly, Semi-Annual, and Weekly. |
Interest Period Start Date |
The Interest Period Start Date and Issue Date fields display the settlement date by default for both investments and debt instruments. In the case of investments, the interest period start date can be changed to a date in the past. The system then calculates the purchased interest. |
Instrument Notes |
Click to access the Show Treasury Instrument Notes page to review notes about the deal's underlying instrument. This text field is for reference only; you cannot modify the notes. |
Last Coupon Period |
You must select a value for this field if you selected the Same Interest for each Period option. Define the term for the last interest payment. The values are:
|
Margin Operator |
Select the operation—add or multiply—by which the rate as per the reset index is acted upon by the index margin to calculate the adjusted rate. |
Maturity Date |
The date on which your deals matures or ends. Enter a date or have the system calculate a maturity date based on the issue date and term that is entered. |
Net Deal Settlement Cash Flows |
Select this check box if your instrument has more than one instrument base type or contains an interest rate swap, and you require that cash flow from one instrument base type or swap leg net with cash flow from another instrument base type or swap leg. |
Payment Date |
Select from the following options and enter a value in the +/- Payment Days field:
|
Pool Information |
Click to access the Pool Information page for details regarding the investment pool that is the source of funds that are used to finance the deal. |
Portfolio |
Select the portfolio that categorizes the deal. |
Rate |
Enter the interest rate for the deal. |
Rate Type |
Select whether the interest rate for this instrument is fixed or floating. If you select Fixed, enter the rate. If you select Floating, enter the reset index for the floating rate. |
Reference |
If the trade is assigned any unique reference numbers by the counterparty, you can record them in this field. |
Repeat Interest Dates |
This check box is automatically selected if the interest-rate physical or interest-rate swap transaction has multiple interest cash flows. This is defined at the instrument type level. |
Reset Date |
Select from the following options and enter a value in the +/- Reset Days field: Set in Arrears: Indicates that the reset date equates to the interest date that marks the end of the interest period. Set in Advance: Indicates that the reset date equates to the interest date that marks the beginning of the interest period |
Reset Frequency |
Specify the reset parameter for the interest calculation. Field values ending in the suffix - Comp indicate the interest compounds (per the field value time period). Select fromAnnual, At Maturity, Daily, Every 28 Days, Every 35 Days, Every 49 Days, Monthly, Quarterly, Semi-Annual, Weekly or the appropriate - Comp value. |
Reset Index |
Select a reset index for this instrument; for example, LIBOR. (London Interbank Offer Rate). |
Reserve |
Click to reserve headroom for this deal below the limit's ceiling. This button is available only when the deal status is Under Negotiation. Use the button to ensure that deals under negotiation have enough headroom reserved within the defined position limits. You must enter detail data on the Deal Detail page before using this feature. You can click the UnReserve button to reverse any limits that are established for deals that are under negotiation. |
Same Interest each Period |
Select to have the system use a fixed amount to calculate interest payments, regardless of the number of days between interest dates. For IR Swap deals, if you select this value and the leg is a fixed-rate leg, the second list is replaced by two drop-down list boxes that enable odd (broken) first and last coupon periods to be handled. Select either Normal First Coupon Period, Short First Coupon Period,or Long First Coupon Period in the first drop-down list box. Select Normal Last Coupon Period, Short Last Coupon Period,or Long Last Coupon Period in the second drop-down list box. |
Security ID |
You can use this field to record either:
|
Submit for Preview |
A treasury organization can gauge the feasibility of hypothetical deals and ensure that limits exist for deals that are planned for the near future. When you enter provisional deals, select this check box and select Under Negotiation from the Deal Status drop-down list on the Deal Detail page. When you save a deal, Pending Review is the default value as the deal status type, and the Workflow feature routes the deal to the designated manager for review. |
Term |
Displays the number of days between the settlement or commencement date and maturity dates on the Deal Detail page. The value is calculated by the system. If you enter a term value, then the system calculates the maturity date by adding the term to the commencement or settlement date. |
Test Limits |
Click to test whether a deal falls within established position limits. |
This section provides overviews of deal entry and limited checked workflow and discusses how to:
Enter commodity deal details.
Enter commodity settlement details.
Define futures deal details.
Enter equity deal details.
Enter generic deal details.
Define option and option - binary payoff deal details.
Update option exercise status.
Enter FX deal physical details.
Define roll-specific details.
Specify IRP deal details.
Define IR swap deal details.
Note. Examples of deal entry are available in the appendix.
The deal entry process can be complex. Deal Management takes a simplified approach to the deal entry process. You can define the type, level, and depth of risk-limit-validation processing that is necessary for the instruments that you organization uses. The deal entry process can handle the intricacies of deals and their underlying instruments, as well as the unique practices of any treasury organization. You can capture as many deals—and you can process as many trades—as you need. For each deal, you can define transaction and counterparty information in addition to providing preapproval requirements.
Note that the Deal Management pages are similar for all deal instrument types. In general, only the fields on the Deal Detail page vary. The overall deal-capture process is described in the discussion of IRP deals. The deal input details for each instrument type are discussed in the respective discussions of the Deal Detail page.
In this chapter, the individual deal types are discussed in order of their frequency of use.
To create deals:
Define deal details for each instrument type.
Define settlement instructions.
If you have implemented the Limit Checked workflow and established position limits, the system automatically routes notification of deals that exceed limits to a defined user (or users) work list when you test deal limits.
See Also
Delivered Workflows for Deal Management
Page Name |
Object Name |
Navigation |
Usage |
Deal Detail |
TRX_DETAIL_TR |
Deal Management, Capture Deals, Deals, Deal Detail |
Define the conditions for a deal. |
Commodities Settlement |
TRX_COMO_STL |
Click Settle Commodity on the Deal Detail page for a commodity instrument deal. |
Set up the settlement of commodities. |
Settle Option by Cash Difference |
TRX_OPT_EXRCS_CASH |
Click Exercise on the Deal Detail page for an options deal. |
Exercise an option or update or change the exercise status for an option. |
Roll Specific Details - Swap FX |
TRX_ROLL_PHYS_SP |
Click the Swap Cash link on the Deal Detail page for an FX deal physical. |
Enter information that is required to swap this foreign exchange deal forward or backward. |
Roll Specific Details - Interest Rate Physical |
TRX_ROLL_PHYS_SP |
Click the Rollover link on the Deal Detail page for an IRP. |
Enter the investment terms for moving funds from one investment to another. |
Access the Deal Detail page for a commodity deal.
Spot Date |
The spot date is typically two working days after the current trading date. Certain currencies (Canadian dollar, Mexican peso, Hong Kong dollar, and Japanese yen) may clear one working day after the trade date. Holidays affect the spot date in various ways:
|
Settle Commodity |
Click to access the Commodities Settlement page to define commodity settlement information. |
See Also
Entering Commodity Instrument Details
Access the Commodities Settlement page.
Current Status |
Select the current status of the option. The values are:
|
Settlement by |
Select from the following:
|
Access the Deal Detail page for a futures deal.
Buy or Sell |
Select whether the contract is a buy or sell contract. |
# of Contracts (number of contracts) |
Indicate the number of contracts held. |
Original Price |
Indicate the contract's original price. |
Note. Default display-only fields for futures contract information are defined on the instrument page.
See Also
Entering Futures Contract Instrument Details
Access the Deal Detail page for an equity deal.
Use this page to record a stock purchase transaction. For deals that involve selling stocks, use the Sale Details page that is accessible from the Sell link on the Equity Definition page.
Note. You must define the equity on the Equity Definition page before you can use it in a deal.
See Defining Equities.
Ticker Symbol |
Enter the stock exchange symbol that is used in trading the particular corporation's shares. |
Exchange |
Enter the market exchange with which the corporation is listed. |
Number of Shares |
Enter the number of shares that are being traded. |
Price per Share |
Enter the price of a single share of stock. |
Transaction Amount |
Enter the monetary total of the transaction based on the number of shares that are being sold multiplied by the price per share. |
Currency |
You must select the currency that is used by the country that is associated with the market exchange—entered in the Exchange field—on which the equity is traded. |
Trade Date |
Enter the date of stock purchase. |
See Also
Access the Deal Detail page for a generic deal.
Pay or Receive |
Specify whether the cash-flow line value is to be paid or received. |
Asset or Liability |
Indicate whether you are capturing data on an asset or liability. |
Term |
The term is the number of days between the specified start and maturity dates. If you enter a start date and term, the system calculates the maturity date. If you enter a start date and maturity date, the system calculates the term. |
See Also
Entering Generic Instrument Details
Access the Deal Detail page for an option or an option - binary payoff deal.
Note. This section discusses deal details for both options and options - binary payoff. The application pages for these deals are identical, with the exception of the second line of Option Details. In the example above, Details Line 1 of 2 is an option, and line 2 of 2 is an option - binary payoff.
Option Barriers
Barrier |
You can define none, single, or double barriers. If the option has a single barrier, a single row exists with the Barrier field set to 1. If the option has double barriers, two rows exist, the first row with the Barrier field set to 1 and the second set to 2. |
Period Start and Period End |
Enter the specified date range for the barriers by entering dates in these boxes. Often, the period start date is the same as the option start date on the Deal Detail page, and the period end date is the same as the option expiry date on the Deal Detail page. |
Barrier Type |
Select the type of barrier. Possible values are: Up and In: The option that is currently inactive. If the underlying price exceeds the barrier, the option becomes active, and the payoff equals the payoff of a standard option. Up and Out: The option that is currently active with a payoff that is identical to a standard option. If the underlying price exceeds the barrier, the option becomes inactive and worthless. Down and Out: The option that is currently active with a payoff that is identical to a standard option. If the underlying price falls below the barrier, the option becomes inactive and worthless. Down and In: The option that is currently inactive. If the underlying price falls below the barrier, the option becomes active, and the payoff equals the payoff of a standard option. |
Barrier Level |
Enter the barrier breach rate. |
Breached |
If, during the life of the option, one of the barriers is breached, select this check box to indicate a breached barrier. This causes the current date to be the default value in the Breach Date field. Adjust the date to reflect the date on which the breach occurred. |
Rebate Paid When |
If you pay a rebate, select from the following values:
|
Rebate Amount |
Enter the rebate amount. If the option barrier does not pay a rebate, select No Rebate Paid. |
Interest Date Rule
Purchase/Write |
Select from the following values: Purchase: Select if you are purchasing the option; this means that you pay premiums. Write: Select if you are selling the option; this means that you receive premiums. |
Option Status |
Select the options status. Values are: Inactive: Option ineligible for exercise due to an Up and Out or Down and Out option barrier breach or cancellation. Options with Down and In or Up and In barriers start with Inactive selected in the Option Status field. If the option breaches the barrier, then the current option status becomes Active. Active: Option eligible for exercise. Options with Down and Out or Up and Out barriers start with Active selected in the Current Option Status field. If the option breaches the barrier, then the current option status becomes Inactive. Exercised: Option exercised. Expired: Option exceeded its expiry date and is no longer eligible for exercise. See Barrier Type field definition. |
Strike Rate |
Enter the rate at which the stock or commodity that underlies a put or call option can be purchased (call) or sold (put) over the period that is specified by the start and expiry dates. |
Option Delta |
Enter the absolute value, a number between 0.00 and 1.00, of the option delta. Do not enter a negative value for a put option. |
Initial Intrinsic Value |
Enter the difference between the strike price of an option and the market value of the underlying security. A purchased option that is in the money has a nonzero, positive intrinsic value. A written option that is in the money has a nonzero, negative intrinsic value. An option that is purchased (or written) that is out of the money has zero intrinsic value. |
Start Date |
Enter the first date that an option is eligible for exercise (for American or Bermudan options), and the first date on which accrual on the option premium begins. |
Expiry Date |
Enter the last day that an option is eligible for exercise or conversion into the underlying common stock. You can enter a value, or the system calculates the expiry date based on the term that you enter. |
Term |
Enter a value to establish the contractual period for the option agreement. |
Exercise Dates |
This link is available if the exercise type on the Instrument Detail page is Bermudan, or if the Strike Rate Varies Over Time check box is selected on the Instrument Detail page. If the option has a European exercise type, then the option can be exercised only on the expiry date. If the option has an American exercise type, then the option exercise can occur on any date between the start and expiry dates. |
Enter the appropriate period start and expiry dates and a valid value in the Strike Rate field. To enter a one-day period, set the period end date equal to the period start date.
Premium Payment/Receipts
Payment Date |
Enter a date for the premium payment. |
Payment Amount |
Specify an amount for the premium payment. |
See Also
Entering Option and Option - Binary Payoff Instrument Details
Access the Settle Option by Cash Difference page.
Current Option Status |
Select the option's status. Values are: Active: Option eligible for exercise. Exercised: Option exercised. Expired: Option that exceeded its expiry date. No longer eligible for exercise. Inactive: Option that is ineligible for exercise due to an Up and Out or Down and Out option barrier breach or cancellation. |
Access the Deal Detail page for an FX physical.
Note. An FX physical deal has a buy side and sell side. When you select the Buy or Sell option for one currency, the system selects the corresponding value for the other currency. If you are entering a cross-currency deal, change the domestic currency field to a foreign currency. The system changes the label for that region to Foreign. Enter the monetary amount of the traded currency. Once you enter one currency’s amount and rate, the system calculates the other amount and rate.
Spot Rate |
Enter the deal's spot rate. |
Spot Date |
Enter the spot date. The default value is two working days after the current date, but you can override this value. |
Term |
Enter the deal's term. If you enter a spot date and a maturity date, the system calculates the value in this field. If you enter a value in this field, then the system calculates the maturity date by adding the term to the spot date. |
Forward Rate |
Specify the contracted forward rate for this deal. You can enter the quoted rate, or the system calculates the rate based on the data that you enter in the Amount fields. |
Swap Cash |
Click to access the Roll Specific Details - Swap FX page to specify information that is required to swap this foreign exchange forward or backward. |
See Also
Entering FX Deal Physical Instrument Details
Access the Roll Specific Details - Swap FX page.
To enter the roll details for a foreign exchange swap:
Specify to swap the foreign exchange at the historic rate or the current rate in the FX Swap at region.
Enter the spot and forward rates.
From these values, the system calculates the points.
Click OK.
Access the Deal Detail page for an IRP.
Many of the deals that you enter into are IRP deals—for example, loans, bonds, and deposits—that represent actual payments of principal and interest that occur in generally predictable amounts at fixed points in time.
Settlement Date |
The system populates this field with a date after the specified transaction date. The value in the Time to Settlement field on the instrument determines the number of days after the transaction date. You can edit this field. |
Issue Date |
Displays the first day that an IRP deal begins accruing interest. The value of this field by default becomes the settlement date for both investments and debt. This value can be overwritten for investments. |
Classification |
Identifies whether the instrument is for Debt raising or an Investment. This is determined on the Instrument Details page. If you select Investment, you can complete the Issuer and Guarantor fields on the Deal Detail page. |
Issuer and Guarantor |
These fields are active only if the following conditions are met:
|
Par Amount |
The amount that is paid or received when the IRP matures. For Debt, the settlement amount is the amount that is borrowed on the settlement date. For Investment, the settlement amount is the amount that is invested on the settlement date. If the deal's amount is amortized, the amortization conditions must be defined. See Defining Amortization Functionality for IRP and IR Swap Deals |
Price % of Par |
The system uses the values in the Par Amount and Settlement Amount fields to calculate the displayed value. |
Settlement Amount |
If this deal is a Debt, the settlement amount is the amount that is borrowed on the settlement date. If this deal is an Investment, the settlement amount is the amount that is invested on the settlement date. |
Purchased Interest |
Displays the accrued interest as calculated from the interest-period start date to the maturity date. |
Discount/Premium |
This field is available when the Interest Calculation field is set to Interest Bearing. It dictates how to account for and treat any discount or premium that is associated with an interest rate physical. Select whether you use a straightline or constant yield method to amortize the bond’s discount (or premium). This also affects the calculation method for calculating interest accruals. Options are: None (blank): The discount amount is added to the interest amount (or, the premium is deducted), and that total is accounted for by using the Treasury accounting event Interest Accrual. Constant Yield Method: The discount (or premium) amount is separately amortized (accounted for) using the Discount Accrual accounting event. The discount amount (or premium) that is amortized in each period is set so that the sum of the amortization amount plus the interest that is accrued provides a constant rate of interest (yield) when applied to the amount outstanding at the beginning of a period. Straightline Method: The discount (or premium) amount is separately amortized (accounted for) using the Discount Accrual accounting event. The discount amount (or premium) that is amortized in each period is set so that the total amortized portion equals the total amount of the discount (or premium) divided by the total life of the deal (term) in days, multiplied by the number of days that the deal is outstanding (by using 30/360-day counts if appropriate). See Accounting Events. |
Yield |
Enter the annual rate of return on the investment, expressed as a percentage. This field is calculated for interest bearing IRPs. |
Initial Reset Rate |
This field appears only for floating-rate deals. If you enter an initial reset rate in the Rate field, the system stores and displays it here for the life of the deal. You cannot edit this field. |
Estimated Maturity Date |
This field appears only for interest-bearing, debt type instrument. Use this field to amortize the discount or premium to a different schedule based on an estimated maturity date. For fixed-rate deals that use the straightline discount or premium method, enter the estimated maturity date and click the Cash Flows button. The system builds a table containing two sets of information: the payment schedule, first, the cash flows, positions, and accounting events data for both the maturity date and estimated maturity date; and second, information that is segregated by source code. When the accounting module calculates discount accrual for an estimated maturity date, it uses information from the estimated maturity date side of the table. |
Next Interest Payment |
Specify whether the next interest payment is:
|
Access the Deal Detail page for an IR swap.
Note. In addition to all other IR swap instruments that you define, you should define two instruments to handle IR swap, cash-flow,
processing scenarios. Associate each instrument with its respective preconfigured accounting template.
Also, IR swap fields exist for both the Pay and Receive regions, but they are described only once in this section. The PeopleSoft system requires data entry for both sets of fields.
Amount |
Enter the monetary amounts for this instrument. These amounts are the principal amounts that the system uses to calculate interest payments for an interest rate swap. |
Term |
If you entered the commencement and maturity dates, the system calculates the term. If you enter a term value, then the system calculates the maturity date by adding the term to the commencement date. |
Swap Principals |
Select an option to exchange principal amounts on the commencement date of the swap and on the maturity date. Specify Don’t Swap,At Commencement, At Commencement and Maturity, or At Maturity. |
Amort Method (Amortization Method) |
Select to indicate how the deal is amortized. See Defining Amortization Functionality for IRP and IR Swap Deals Note. Defining deal amortization is an optional step, depending on certain deal conditions. As such, establishing deal amortization is discussed in a separate section. However, it is a part of setting up deal detail information. Once you have entered deal amortization information, you should continue capturing the deal by entering settlement instructions. |
See Also
Entering Interest Rate Swap Instrument Details
This section provides overviews of amortization for IRP deals and amortization for IR swap deals and discusses how to:
Specify an amortization method for an IRP or IR swap deal.
Specify an IR swap amortization method.
Define IR swap amortization details.
View and modify interest and payment dates.
Note. The information in the section describes functionality common only to IRP and IR swap deals.
Before specifying amortization methods for an IRP deal, the following conditions must be set on the Deals Detail page for an IRP deal:
The Discount/Premium field value on the Deal Detail page must be Straightline.
The Same Interest each Period option must be selected in the Interest Calculation section.
Fixed-rate deals—which you define by selecting Fixed in the Rate Type field—can use an amortization method of Constant Term, Constant Payment, or Factored. You select the amortization method from the Amort Method field menu.
Floating rate deals—which you define by selecting Floating in the Rate Type field—can only use the Factored amortization method.
You cannot use the constant term and constant payment amortization methods with floating-rate deal types because the interest rate changes on a frequent basis.
This table describes the options for IRP deals:
Amortization Method |
Rate Type |
Interest Calculation |
Constant Term/Payment Note. You cannot use the constant amortization methods for floating-rate deals. |
Fixed |
Same Interest each Period |
Factored |
Fixed |
Either of the following two options:
|
Factored |
Floating |
Day Counted Interest |
Entering amortization methods for IR swap deals is similar to the process that you use for IRP deals.
For you to specify amortization methods for an IR swap deal, the Interest Calculation field in the Interest Rate Swap Details section of the Deal Detail page must be set to Interest Bearing, and the following conditions must be met:
Amortization Method |
Rate Type - Leg 1 |
Rate Type - Leg 2 |
Interest Calculation (Specified on the Dates Page) |
Constant Payment / Term Selected in the Amort Method field. Note. You cannot use a constant payment or a constant-term amortization method if either leg is set to Floating. |
Fixed |
Fixed |
Same Interest each Period |
Factored |
Fixed |
Fixed |
Either of the following two methods:
|
Factored |
Floating |
Fixed |
For Leg 1: Day Counted Interest For Leg 2, either of the following two methods:
|
Fixed Paydown |
Fixed |
Fixed |
Either of the following two methods:
|
Fixed Paydown |
Floating |
Fixed |
For Leg 1: Day Counted Interest For Leg 2, either of the following two methods:
|
Page Name |
Object Name |
Navigation |
Usage |
Deal Detail |
TRX_DETAIL_TR |
Deal Management, Capture Deals, Deals, Deal Detail |
Define the conditions for amortizing an IRP or IR swap deal. |
Interest and Payment Dates |
TRX_INTEREST_TR |
Click Interest Dates on the Deal Detail page. |
View detailed information about payment dates. |
Access the Deal Detail page for an IRP or IR swap deal.
Amort Method (Amortization Method) |
Select the method for amortizing the principal to zero or an end principal. Values are:
|
Access the Deal Detail page for an IR swap deal.
This page is similar to the Deal Detail page for IRP deals; however, the two regions—the Pay region and the Receive region—exist for both sides of the swap.
Note. For definitions of the payment results of the constant or factored amortization method, see the section that covers amortization for IRP deals. This discussion focuses on using these amortization methods with an IR swap deal.
Select a method of amortization from the following values:
Constant Payment or Constant Term |
When you select one of these values, the End Principal fields for the Pay and Receive regions appear on the Deal Detail page with a 0 value by default; you can edit these fields. |
Factored |
When you select this value, the Beginning Amount and End Amount fields are unavailable. You must complete the setup for this factored swap on the Amortization Details page. The factors can be added on the Interest and Payments pages. |
Fixed Paydown |
Select this amortization method to make changes to the principal balance (after the system has generated the payment schedule) by amount or percentage. When you select this value, the Percent/Amountfields for the Pay and Receive regions appear on the Deal Detail page. |
Access the Interest and Payment Dates page.
This page displays comprehensive payment information results for a Constant, Factored, or Fixed Paydown method type amortization. If you selected the Constant method on the Deal Detail page, no further setup is required. However, if you selected the Factored or Fixed Paydown method, you must enter a value so that the system can correctly calculate the factored or fixed-paydown, amortization amount.
Factored |
To enter a factored value:
|
Fixed Paydown |
To edit the fixed-paydown, principal amount:
|
Access the Interest and Payment Dates page.
Reset Date |
The date that interest rate is reset. Available for IR swap deals and IRP floating-rate deals. |
Override |
Select to override the interest payment amount that is calculated by the system. If the deal is unlocked and you attempt to edit the existing fields to add principal, you will receive a message indicating that making a change will lock this deal. |
Modifying IRP Floating-Rate Deal Interest Information
Access the Interest and Payment Dates page for a floating-rate, IRP deal.
All the dates on this page are system generated, but can be changed. Use this page to view interest information for a specific deal, or add a payment type.
The Reset Date field displays the date on which the floating rate is set or reset; the entered rate calculates the payment amount.
To modify payment and interest information:
In the Payment Type field, select from Drawdown, Interest, or Paydown.
Enter the amount in the Principal Amount field.
Click Adjust Principal.
Save the new information.
Interest and Payment Dates Page for Interest Information for an IR Swap Deal
Access the Interest and Payment Dates page for an IR swap deal.
Reset Date |
Reflects the date on which the floating rate is set or reset; the entered rate calculates the payment amount. |
Amount |
Displays the system-generated nominal principal amount from the Par Amount fields on the Deal Detail page. You can change the amount for each interest period, allowing for the entry of accreting or amortizing swaps. |
Leg |
Displays the pay and receive legs for the instrument. |
Adjusting Principal for IR Swap Deals
For IR swap deals, this page displays comprehensive payment information results for the method of amortization that is selected in the Amort Method field on the Deal Detail page. If you selected the Constant Payment or Constant Term method, no further setup is required on this page. If you selected a Factoredor Fixed Paydown method, however, you must enter a value here so that the system can correctly calculate the factored or fixed paydown amortization amount.
Payment Type |
Factored: To enter a factored value:
Fixed Paydown: To edit the fixed paydown principal amount:
|
This section discusses how to specify reset rates.
Note. The information in this section is relevant only for IRP and IR Swap deals.
Page Name |
Object Name |
Navigation |
Usage |
Deal Detail |
TRX_DETAIL_TR |
Deal Management, Capture Deals, Deals |
Adjust margin figures on floating-rate instruments for IRP or IR swap deals. |
Interest and Payment Dates |
TRX_INTEREST_TR |
Click Dates Detail on the Deal Detail page. |
Specify reset rates and payment amounts. See Viewing and Modifying Interest and Payment Dates |
Access the Interest and Payment Dates page.
Rate |
Enter a rate. The Rate Set check box is automatically selected for interest periods for which the rate is set. Set rates exist for all interest periods for fixed legs. You set reset rates for floating legs as you reach reset dates. When you reach floating-leg reset dates, select the Rate Set check box, enter the rate, and click Save. The system uses the rate to calculate a payment or receipt amount. Note. The Rate Set check box may not be available for a deal, depending on the setting that you have specified with the Allow Fixed Rate Change check box at the instrument level. |
Override |
Select to override the system-generated amount. If the cash flow is Firm, an accounting event is generated if you selectRate Set. If the cash flow is Provisional, no accounting event is generated if you clear Rate Set. |
See Also
The pages that are discussed in this section appear for all deal-capture transactions, regardless of the deal instrument type.
This section discusses how to:
Test position limits.
Define additional holiday lists.
Record counterparty competitive bids.
Page Name |
Object Name |
Navigation |
Usage |
Event Log |
TR_EVENT_LOG_2_PG |
Click the Event Log link on the Deal Detail page. |
View events that are associated with a deal. |
Cash Flows |
TRX_CASHFLOWS_TR |
Click Cash Flows on the Deal Detail page. |
View the resultant cash flows after saving a completed deal. |
Treasury Deal Limit Test |
TRX_LIMIT_TEST_PNL |
Click Test Limits on the Deal Detail page. |
Test whether a deal is within the established position limits. |
Deal Checking |
POS_LMT_CHK_MSG |
Click the Deal Test button on the Deal Detail page. |
Determine whether the deal passes certain conditions that are specified on deal trees. |
Show Treasury Instrument Notes |
INSTR_NOTES_SHOW |
Click Instrument Notes on the Deal Detail page. |
View notes on the instrument that is associated with the deal. |
Additional Holiday Lists |
TRX_DEAL_HOLLST |
Click the Additional Holidays link on the Deal Detail page. |
Specify additional holiday list IDs for a deal, for example, holidays that affect a bank from another country. |
Counterparty Competitive Bids |
TRX_COMPETITVE_BID |
Click the Bids link on the Deal Detail page. |
Enter counterparty, competitive-bid information for a deal. |
Extra Attributes |
INSTR_ADHOC_ATR |
Click Extra on the Deal Detail page for a generic instrument-type deal. |
Review extra deal attributes that are assigned at the instrument type level. |
Enter Fees |
FEE_GENERATOR_PNL |
Click the Fees link on the Deal Detail page. |
Define fees that are associated with a deal. The existence of the Fees link is dependant upon the instrument type that is selected. See Creating Fee Entries. |
Access the Treasury Deal Limit Test page.
Tree Name |
Review the name of the position tree for the deal. |
Tree Node |
Review the name of the position node for the deal. |
Int/Ext (internal or external) |
Displays I for an internal deal or E for an external deal. |
Limit Min (limit minimum) |
Review the minimum deal-limit amount of the positions. |
Limit Max (limit maximum) |
Review the maximum, deal-limit amount of the positions. |
Total Utilization |
Review the amount of the position limit that is used so far, including this deal. |
Refresh |
Click to perform the limit testing calculations again. |
See Also
Access the Additional Holiday Lists page.
Select a holiday list ID to associate with the deal.
Access the Counterparty Competitive Bids page.
Use this page to record the bids that are being considered for a deal. Various counterparties offer different rates and are recorded here for audit purposes. This page is used most often for IRP or FX deals.
Done |
Select to specify the bid quote. You can select a quote other than the one offering the best rate. If the best rate—marked with a check in the Best Rate column—is not selected, then the system issues a warning; “Best bid is not chosen.” |
Counterparty |
Enter the counterparty that is making the bid. |
Bid Quote Type |
Specify whether you are recording bids on rates, yield, or price. |
Best Rate |
Designates the best rate quote for the deal. |
|
Click to enter the system time for either the request or quote time. |
Request Time |
Enter the bid request time. |
Quote Time |
Enter the bid quote time. |
Bid Quote |
Enter the bid quote rate. |
Best Rate |
Displays the best bid rate (as determined by the system). |
Exclude |
Select to eliminate particular bids from consideration. |
Their Dealer |
Select the counterparty’s dealer name. |
This section discusses how to specify instructions for settling deals.
Page Name |
Object Name |
Navigation |
Usage |
Settlement Instructions |
TRD_DETAIL_STL_TR |
Deal Management, Capture Deals, Deals, Settlement Instructions |
Specify instructions for settling deals. |
Access the Settlement Instructions page for any deal.
Payment Method |
Displays a payment method for the settlement. If the field is editable, you can select from the available values. Note. You should not edit this value. A bank account's payment method is established on the External Accounts - Payment Methods page at implementation. |
See Also
This section provides an overview of on-behalf-of deals and discusses how to use on-behalf-of deals.
On-behalf-of deals enable Deal Management to interact with other internal units in an organization. You use this feature to assist other internal units in obtaining outside loans or deals through the organization's treasury.
Organizational treasuries generally have more trading volume and established counterparty relationships than other internal units. Consequently, the treasury can facilitate a large block trade on behalf of several internal units, obtaining a better rate than the units can obtain independently.
On-behalf-of deals can contain several types of deals, depending on the originator and receiver of the deal. The deal types are outside deal, back-to-back deal, and mirror deal.
A treasury outside deal is a large block trade between the treasury and the outside counterparty. To the outside counterparty, the deal appears to be a single deal, but it consists of all the trades for the individual business units.
Treasury internally manages the deal by dividing the single outside deal among the other internal units. Two additional deals are needed for each subdivision. The first deal involves the treasury's selling off a portion of the original position. This is called a back-to-back deal. The second deal is the reverse of the back-to-back sale; the individual unit receives the sold-off portion. It is called a mirror deal.
For example, suppose that the treasury buys a 50 million USD certificate of deposit on behalf of other units. The treasury will then use two deals to transfer a portion of this purchase to another unit. The first deal, the back-to-back deal, is a sale of 10 million USD that removes that amount from the treasury's position. The second deal, the mirror deal, is a purchase from treasury 10 million USD by the internal unit, which puts the 10 million USD onto its books.
Page Name |
Object Name |
Navigation |
Usage |
On Behalf of Deals |
TRX_INTERNAL_TR |
Deal Management, Capture Deals, On Behalf of Deals |
Create the treasury’s on-behalf-of deal transactions. |
Access the On Behalf of Deals page.
To use on-behalf-of deal functionality:
Enter an external deal using the deal-capture pages.
Select the external deal on the On Behalf of Deals page.
Offset the original deal with back-to-back deals that move the external position out of treasury's net holdings.
For each deal, first select a counterparty, and then request a back-to-back deal. The back-to-back counterparty can be external, but normally it is an internal unit.
Specify the amount of principal to be transferred by modifying the principal on the Deal Detail page of the newly created deal, save the page, and return to the On Behalf of Deals page.
Select the back-to-back deal and create a mirror deal.
The system stores the mirror deal with the internal unit as the owner, the treasury as the counterparty, and the position amount added to the internal unit's ledger.
The mirror deal reverses the back-to-back deal, causing the mirror to act in a similar fashion as the external deal. Therefore, if the original deal is a buy, the mirror is a buy.
Note. To use this page, the deal status must be Under Negotiation.
Back to Back Counterparty |
Click to select a counterparty for the back-to-back deal. |
Create Back to Back |
Click to automatically create a back-to-back deal. The system uses the defined back-to-back counterparty and the original deal information. You can edit information for the back-to-back deal in the deal component, as necessary. |
List Related |
Click to list all back-to-back and mirror deals that are created for the displayed deal ID. |
Deal ID |
Click to access the deal-capture pages and view back-to-back deal or mirror deal details. |
Click to automatically create a mirror deal for the internal treasury. You can create mirror deals only from back-to-back deals that are defined with an internal business unit counterparty. |
Trade tickets are used to group deals to facilitate buying and selling multiple deals simultaneously. The Trade Tickets component is similar to the deal-capture pages. Refer to the previous sections in this chapter that provide field descriptions for the deal-capture pages.
This section discusses how to enter trade detail information.
Page Name |
Object Name |
Navigation |
Usage |
Trade Detail |
TRD_DETAIL_TR |
Deal Management, Capture Deals, Trade Tickets |
Enter trade detail information. |
Access the Trade Detail page.
Transaction Date |
Enter the trade’s transaction date if it differs from the system date. |
Trade Type |
Select:
|
Trade Status |
Select Deactivated, Open, or Under Negotiation. |
Confirm Status (confirmation status) |
Select Pending, Approved, or Rejected. |