To explain how Interest Rate Swap are revalued in the CS Lucas system.
WHY IS THIS IMPORTANT?
The gains and losses incurred arising from interest rate swap transaction has implications for financial risk management and the accounting instrument.
1. The appropriate rate structure has been set up in the system at the date for the revaluation.
2. The exchange change has been set up in the system at the date for the valuation.
1. Navigate to the IRS module and filter the trade to revalue. (Transaction > Interest Rate Swap)
2. Click on the hyperlink MTM against the trade.
3. The system brings you to the tool for MTM IRS.
4. If you do not have access rights to the IRS module to select the trades in the steps above, you may launch the tool directly. Tools > MTM IRS. Then select the accounting centre and enter the TradeID of the relevant trade.
5. Select the As At Date for the MTM and the reporting currency you wish to use to revalue this position.
6. Select the Rate Structure that you want to use to revalue.
7. Click Refresh.
8. The system displays the MTM of the outstanding individual legs of the IRS and a total in the reporting currency.
ANALYSIS OF THE COMPUTATION
(In the illustration below, numbers may have been rounded for display purposes.)
Consider the following scenario.
Rate Structure (USD)
Rate Structure (SGD)
I. Computation of the implied forward interest rate.
The forward rate is the future yield that can be implied from the prevailing zero coupon curve. The formula is given as:
Illustration of computing zero coupon rates from known implied rates and vice versa using the above formula.
To compute the forward rate on SGD between 11 Jul 11 and 11 Jan 12.
In general, the dates of the zero coupon rate curve do not coincide with the periodic cash flow date of the interest rate swap.
For example, the fixed leg, on the USD leg.
The rate of 3.157158% is then used as in Example 1 to compute the forward rate between 11 Jan 09 and 11 Jul 09.
II. Compute the present value of all cash flow differences between contracted and implied rate.
All the fixed leg cash flow will be revalued between the contracted rate and the implied forward rate.
In the case of the floating legs, the appropriate reset rates in the future would be best represented by the implied forward rate. The exception will be the current float leg, where the interest rate has been determined. This leg is, in fact, fixed.
III. Translating to reporting currency
To translate the present value of currency amount to the reporting currency, the system will compute the forward rates using the End Date of each periodic item.
FREQUENTLY ASKED QUESTIONS
FAQ01. What happens when there is no zero coupon rate curve at the As At Date of the valuation?
The system will look up the latest available curve before the As At Date and use that curve for revaluation.
Illustration of computing zero coupon rates from known implied rates and vice versa