5.3.1.3.3 From Instrument to Instrument

Instrument-to-Instrument is a common use case.

  • For each Instrument, calculate and update a Target Column as a fixed relationship to some other column. For example, calculate a loan loss reserve as a fixed percentage of the current balance of each mortgage loan.
  • For each Instrument, calculate a rate times a balance and multiply it by an accrual basis factor and divide it by 100 to update a revenue or expense column. This allocation uses Expression as a Source where the expression contained a Rate Time Balance Calculation. The Static Driver would consist of (1) an accrual basis macro and (2) and factor of 0.01.