Hedging is a risk management strategy that minimizes the risk of future price fluctuations, and possible future losses, by agreeing on a price and quantity of items to be exchanged at a future date. In some instances, the items to be exchanged at a future date may include securities, such as bond, stocks, mutual funds, notes, or mortgages.
In computing systems, such as enterprise resource planning systems, data relating to hedging transactions involving these securities may be stored in data objects known as forward securities transactions. The forward securities transactions may include a link to a hedged item, such as a security, and agreed terms of existing hedging relationship between parties, such as price, quantity, and date terms.
In some instances, data relating to the terms of an existing hedging relationship may be extended or changed before the end of the hedging relationship. In this situation the existing hedging relationship terms may be rolled over into a modified forward securities transaction containing the renegotiated terms.
Current enterprise resource planning systems 14 shown in
For example, an initial forward securities transaction business object 15 may be entered in an existing system 14 to be effective at time 10, mature at time 11, and contain other transaction related data, such as spot price, mature price, quantity, and/or a link to the securities data or object. If the terms of the forward securities transaction are subsequently extended from time 11 to time 12, in existing system 14 either a second transaction object 16 may be entered to be effective at time 11 and mature at time 12, or the initial transaction object 15 may be deleted and replaced with a new transaction object 17 that is effective at time 10, matures at time 12, and contains other transaction related data.
However, in the situation where a second securities transaction object 16 is entered to cover the securities extension from time 10 to time 11, the new transaction object 16 is independent of the existing object 15 and the two object are not linked or otherwise associated with each other, making accounting and transaction management difficult. The situation where the existing transaction object 15 is deleted and replaced with a new transaction object 17 also makes accounting and transaction management difficult because data relating to the transition and extension of the forward securities transaction 17 at time 11 is not stored in the business object.
There is a need for enterprise resource planning systems that are able to manage and properly account for roll overs of forward securities transactions.
Embodiments provide systems and methods enabling roll overs of forward securities transactions by updating or superseding existing forward securities transaction data to accept extensions to maturity date terms or other changes to the terms of a hedging agreement. The updated data may then be automatically linked to existing data in some embodiments and both the updated data and the linked data may be used to perform automated effectiveness testing of the existing and new forward securities transactions. Upon passing the effectiveness tests, accounting data may be automatically extracted from the forward securities transaction according to hedge accounting principles and sent to an accounting system.
In an embodiment, data relating to a forward securities transaction may be stored in a forward securities transaction business object. In some embodiments, the forward securities transaction business object may enable a roll over of a securities transaction if the transaction object includes an attribute confirming the existence of a compound derivative or the forward securities transaction includes documentation or a link to documentation of a roll-over strategy. A compound derivative may be designated for a forward transaction with roll-over option.
In various embodiments, once the transaction object contains data enabling a roll over, additional data relating to the hedging transaction in the transaction object may be automatically changed. These changes may include changes to the hedging terms; such as price, quantity, or date; the link within the object to a hedged security; the documentation of the roll over strategy; or accounting calculations related to the transaction. In an embodiment, if a roll over is later reversed, these changes may be undone.
In some embodiments, data relating to a maturity date extension of a hedging agreement may be stored in a forward securities transaction business object as an additional data field. In some embodiments, maturity date data may only be extended if the documentation of the roll over strategy in the forward securities transaction permits maturity date extensions. In an embodiment, the process of adding or changing a data field in a business object may result in a new rate of return being automatically calculated for the extended forward securities transaction. In an embodiment, these and other financial calculation may be performed by a separate system, such as financial calculation system 48, which may be configured to efficiently perform such calculations. In some embodiments, when the maturity date data is extended, the calculation may be based on the rate of return before the maturity date extension. In some instances, the data representing a new rate of return may also include intermediate returns, such as dividends between roll over and maturity. In some embodiments, the return data may be compounded to the new maturity date.
In some embodiments, data fields in transaction objects may be automatically amended when a new hedging agreement in a forward securities transaction replaces or supersedes an existing hedging agreement in a forward securities transaction. In these situation, not only may the terms of the hedging agreement in the forward securities transaction be updated, but the documentation of the roll over strategy may also be updated, though a record of the existing hedging agreement may still be maintained. In some embodiments, the forward or future price may be calculated based on the spot or cash prices at the time the new hedging agreement was created.
In an embodiment, once a roll over date and new maturity have been identified, a processor may review the forward securities transaction to identify a quantity of securities that are available to be rolled over as of the date the roll over is to occur. Some or all of the identified quantity of securities may then be identified as eligible for roll over. In some embodiments, a roll over attribute may be used to prevent a user from selecting a forward securities transaction that may not be rolled over or eligible for roll over.
Hedge Effectiveness Testing
As discussed previously, hedging is typically used as part of a risk management strategy, and when used in accordance with accounting standards, may enable an entity to use hedge accounting to better reflect the reduced risk. However, before hedge accounting may be used, effectiveness tests must be conducted to verify that the hedging agreement offers adequate risk protection.
In some embodiments when data in forward securities transaction object indicates that the maturity date of a hedging agreement in a forward securities transaction has been extended, the system may ensure that the spot rate or cash price of the securities at the time of the original hedging agreement in the forward securities transaction is not changed during the roll over and extension of the maturity date. In embodiments enabling a user to extend the maturity date of some securities in the hedging agreement, the system may ensure that only the rolled over units are taken into account during effectiveness testing after the roll over date.
In embodiments enabling a user to assign a new hedging agreement in a forward securities transaction to replace or supersede an existing hedging agreement in a forward securities transaction, the effectiveness tests may require using multiple spot rates or cash prices of the securities at the time each new hedging agreement was entered into. This is because, as shown in
These or other embodiments may use the following formula as an effective test for a series of forward securities transactions, HInstrm,m+1, with forward rates, fm,m+1, and spot rates, sm,m+1, being designated in xthe hedging agreement in the time intervals (tm, tm+1). The respective underlying securities corresponding to HInstrm,m+1 may be designated as HUnderm,m+1 with security price SUnder, the designation time may be tdes=t1, and the security price of the hedged item at time t may be SHItem(t), then:
Accordingly, in an embodiment one cumulative retrospective effectiveness test at time t may be:
This formula may also be used as an effectiveness test in other embodiments, such as in the case of extending the maturity date of a hedging agreement in a roll over forward securities transaction. Other formulas that calculate the change in the fair value of the hedging agreement(s) may also be used in different embodiments. These formulas may include the difference of the intrinsic values of previously matured portions of hedging agreement(s) at the time the agreement become effective and the date the agreement(s) matured added to the current change intrinsic value from the original intrinsic value of the non-matured portion of the hedging agreement(s).
For the second transaction FST2, the cash price at the start of term on Jun. 1, 2008 was $70, but the second hedging transaction FST2 did not take effect until Jan. 1, 2009, one day after the end of the first hedging transaction FST1. If the cash price on Jan. 1, 2009 was $150, this price increase from $70 reduced the value of the hedging agreement by $80. If a $2 dividend is paid on Jun. 1, 2008, the value of the hedging agreement was further reduced to $78. If the cash price at maturity was $81 compared to the cash price of $70 at the start of the term, the value of the hedging agreement at maturity has reduced by $11 compared to the value at the start of the term. Thus, the instrument has gained $67 in value since transaction FST2 took effect on Jan. 1, 2009: −$11−(−$78)=+$67.
If the cash price of FST2 was $81 at maturity, $150 at the time the transaction FST2 was designated on Jan. 1, 2009, and a $2 dividend was paid at the start of the term of FST2, then the change in value of the security is: $81−$2−$150=−$67. For the third transaction FST3, if the cash price at the effective date of Jan. 1, 2010 is $80, and the cash price at maturity is $75, the hedging agreement will have gained $5 in value, $80−$75=+$5. On the other hand, the value of the security itself will have lost $5 in value. Using the results from these calculations, the total change in instrument value is +$23, where as the total change in item value is −$23. Dividing these two number gives a value of 1 or 100%. Thus, the example in
Other formulas may be used in other embodiments to calculate hedge effectiveness. For example, in a second formula, following definitions may be used to calculate hedge efficiency:
If, in an embodiment, a forward securities transaction is created to have a net present value of zero at an effective date, the price at maturity may be:
The price of the forward securities transaction at time t between tm and tn may be determined by:
Hedge efficiency may be measured in some embodiments as the change in spot rate or cash price in relation to the change in forward rate. Changes in the spot rate, resulting solely from a dividend payout, may be eliminated in some embodiments for the change in forward rate to remain consistent with the above definition of a forward transaction price fm,n in the above formula (3).
In these embodiments, hedge efficiency may then calculated as follows:
If interest rate effects are eliminated, the denominator in (4) can be converted to:
and the hedge effectiveness, after neglecting interest rate changes, is exactly 100%.
In some embodiments, an exact value of the forward securities transaction at maturity may be calculated using the following formula:
f
m,m+1(tm+1)=S(tm+1)−Kn,m+1 (6)
Although the parties may opt to settle exact value at maturity with a cash payment in some circumstances, for purposes of hedge accounting, the exact value should be transferred to a follow-up agreement to retain the reserves relating to the corresponding forward securities transaction. In some embodiments, this may mean that the forward rate to be agreed on in the new roll over transaction needs to be adjusted by a cash settlement amount, including interest, from the previous transaction. When this transaction is concluded, the new forward may not have the value zero, but rather the value of the cash settlement of the previous transaction:
f
m+1,m+2(tm+1)=fm,m+1(tm+1) (7)
The new forward may have this value when the maturity price of the follow-up transaction is:
Note that this result differs from the standard definition (2) by the cash settlement amount, including interest, of the previous transaction. If the contracted rate Km+1, m+2 is then applied to formula (3), the price of the second formula may be determined, thereby automatically fulfilling the conditions for formula (7).
The hedge efficiency of this rolling hedge for the period tA to tB, in which tA is a time during the term of the first forward and tB is a time during the term of the follow-on transaction may now be calculated as follows (assuming the price term remains constant when transferred to the follow-on transaction):
By using (7), we rearrange the denominator:
Formula (10) can be simplified considerably by excluding all the interest effects:
This result corresponds exactly to the result for a single forward (from tm to tm+2). In this case, hedge efficiency for the rolling hedge may also be 100%, excluding the effects of interest changes. In effect, this result confirms that from an economics point of view, the two matching forwards may have the same effect as a single forward with a longer term. The calculation shown above can be applied to additional follow-on transactions in other embodiments because of this principle. In this way, a number of rolled forwards can always be cleared in the simplest case using a single rollover.
In some embodiments, upon passing the effectiveness tests, some of the above calculated accounting data may be sent to an accounting system to be processed according to hedge accounting principles under the appropriate accounting standard, such as International Financial Reporting Standards. In some embodiments, a calculation system, such as financial calculation system 48 may retrieve relevant financial hedging data from forward securities transaction business objects stored in securities management system 41, perform financial calculations, such as effectiveness tests, and forward the results of the tests and/or relevant financial data to an accounting system 46, which may incorporate the data in appropriate financial statements using appropriate accounting standards.
In some embodiments, when a forward securities transaction is rolled over or substituted by another hedging agreement, a change in the end date or maturity date of the forward securities transaction may result in further changes to other objects. For example, in some embodiments, various tests may be performed on a period basis, such as monthly or quarterly, to measure ongoing hedging effectiveness. In some instances, the tests may depend on the maturity dates of forward securities transactions, so a change to the forward securities transaction maturity date may result in a corresponding change in testing as well, with additional being adding to a testing plan when the maturity date is increased, for example. In some embodiments, the financial calculation system 48 may be configured to automatically retrieve necessary data for these calculations from the forward securities transaction business object. Moreover, in some instances, such as when rollover is cancelled, embodiments may undo changes to these and other objects.
In some embodiments, new or modified roll overs may not be permitted in certain circumstances, such as after a hedging agreement has matured, is planned to mature, or has been revoked. In these situations, the user may be prevented from initiating a roll over until certain other conditions have occurred, such as canceling the planned maturity date.
In an embodiment, securities management system 41 may be used to store forward securities transaction business objects. In some embodiments, securities management system 41 may also perform financial calculations involving data stored in these business objects. In other embodiments, a financial calculations system 48 may be used to perform some or all of these financial calculations, such as effectiveness tests. After completing these financial calculations, relevant accounting data, which may include the results of the calculations or data based on the results of the calculations, may be sent to an accounting system 46, which may generate corresponding financial statement data or entries. In an embodiment, changes to some data in the forward securities transaction business object, such as changes to a roll over date or maturity date, may be manually entered by a user through a user system 47. These changes may then be stored in the transaction objects, which may be stored in the securities management system 41.
In an embodiment, memory 43 may contain different components for retrieving, presenting, changing, and saving data. Memory 43 may include a variety of memory devices, for example, Dynamic Random Access Memory (DRAM), Static RAM (SRAM), flash memory, cache memory, and other memory devices. Additionally, for example, memory 43 and processor(s) 42 may be distributed across several different computers that collectively comprise a system. The memory 43 and/or database 45 may be used in the securities management system 41 to store one or more forward securities transaction business objects.
Processor 42 may perform computation and control functions of a system and comprises a suitable central processing unit (CPU). Processor 42 may comprise a single integrated circuit, such as a microprocessor, or may comprise any suitable number of integrated circuit devices and/or circuit boards working in cooperation to accomplish the functions of a processor. Processor 42 may execute computer programs, such as object-oriented computer programs, within memory 43. In some embodiments, the processor 42 in the securities management system 41 may be used to perform effectiveness tests, and other financial calculations on data stored in the securities management system 41. In other embodiments, one or more processors 42 in financial calculation system 48, which may specially configured to enable high speed financial calculations, may be used to perform the financial calculations, such as effectiveness tests on the forward securities transactions.
Sometime later, preparations to begin creating periodic financial reports or statements may commence. In an embodiment, an accounting system 46 may sent a request for an accounting update 52 when it is time to begin creating update financial reports or statements. In other embodiments, the calculation system 48 and/or the accounting system 46 may keep track of and initiated accounting update procedures at predetermined intervals, such at the close of every quarter.
The calculation system 48 may then retrieve financial data 53 relevant to the accounting update 52 from forward securities transaction objects in the securities system 41. The calculation system 48 may then perform calculations 54, such as effectiveness tests, on the retrieved financial data 53, and then send the results of the calculations 55 and/or other financial data 55 based on the results of the calculations to the accounting system 46.
Some time later, new or updated agreement terms 56 may be entered at a user system 47 and sent to the securities system 41 to be stored in a forward securities transaction business object. In some embodiments, the securities system 41 may send an automatic notification to the calculation system 48 whenever forward securities transaction business objects have been updated or changed. In other embodiments, the calculation system 48 may periodically check the securities system 41 to identify any changes to forward securities transaction business objects.
In an embodiment, upon ascertaining that a forward securities transaction business object has been changed, the calculation system 48 may then retrieve financial data 57 relevant to the updated object from the securities system 41. The calculation system 48 may then perform calculations 58, such as effectiveness tests, on the retrieved financial data 57, and then send the results of the calculations 59 and/or other financial data 59 based on the results of the calculations to the accounting system 46.
Note that while embodiments of the present invention are described in the context of a fully functional computer system, those skilled in the art will appreciate that modules of the present invention are capable of being distributed in a variety of forms across a plurality of systems. Embodiments consistent with the invention may also include one or more programs or program modules on different computing systems running separately and independently of each other, while in their entirety being capable of performing business transactions in a large enterprise environment or in a “software on demand” environment. These programs or program modules may be contained on signal bearing media that may include: recordable type media such as floppy disks and CD ROMS, and transmission type media such as digital and analog communication links, including wireless communication links.
The foregoing description has been presented for purposes of illustration and description. It is not exhaustive and does not limit embodiments of the invention to the precise forms disclosed. Modifications and variations are possible in light of the above teachings or may be acquired from the practicing embodiments consistent with the invention. For example, some of the described embodiments may include software and hardware, but some systems and methods consistent with the present invention may be implemented in software or hardware alone. Additionally, although aspects of the present invention are described as being stored in memory, one skilled in the art will appreciate that these aspects can also be stored on other types of computer-readable media, such as secondary storage devices, for example, hard disks, floppy disks, or CD-ROM; the Internet or other propagation medium; or other forms of RAM or ROM.