Identify and Obtain Information from Last Accrual Date

For the given Run ID, the Previous Execution Date is considered as the Last Accrual Date. Based on the Last accrual date, the following account level information is obtained:

• Ending Net Book Value or the Modified Net Book Value, based on the Modified Flag as of the Last Accrual Date.
• Compounded Interest
• Ending Deferred Balances
• Cumulative EIR Interest recognized till date (till Last Accrual Date)
• Cumulative Interest Adjustment recognized till date (Last Accrual Date)

If the account is new (originated between the Last Accrual Date and Current MIS Date), then these values are computed as follows:

• Book Value = First Transaction Amount + Deferred Balance (Fees + Premium or Discount - Cost of Interest Subvention)
• Compounded Interest = 0
• Ending Deferred Balances = Deferred Balance (Fees + Premium or Discount - Cost of Interest Subvention)
• Cumulative EIR Interest recognized till date (till Last Accrual Date) = 0
• Cumulative Interest Adjustment recognized till date (Last Accrual Date) = 0

Note:

During the initial Run, historical data for the last accrual date will not be available for computation. You need to ensure that historical data is manually populated for the last accrual date for each EIR-based adjustment Run that is available. The FSI EIR-based Income Adjustment Accounts (FSI_ACCT_EIR_ADJUSTMENT) table needs to be populated with this date. The last accrual date is the date from which interest adjustments have to be made for the initial Run.

Historical data needs to be populated to the columns of the FSI_ACCT_EIR_ADJUSTMENT table.