his chapter contains the following section:
This section contains details of the suggested accounting entries that can be set up, for the Loans module of Oracle Lending. The details of the suggested accounting entries are given event-wise.
The following is an exhaustive list of events that can take place during the life cycle of a Loans contract.The accounting entries and advices for each of the events are listed below.
Event Code |
Event Description |
Remarks |
BOOK |
Booking a contract Contingent entries are passed at the time of Booking a future valued contract. This corresponds to Event - Booking. If a contract with value date as the system date or with a back value date is input these entries are not passed. |
All Types |
INIT |
Contract Initiation The actual take down entries passed on the value date of the contract correspond to Initiation. |
All Types |
LIQD |
Liquidation of contract/schedules |
All Types |
ACCR |
Accrual of various components for a contract |
All Types |
CAMD |
Contract Amendment |
|
DLNK |
Release of Linkage to Loan |
Discounted loans |
FLIQ |
Advance/Arrears Fee Liquidation |
|
FELR |
Fee Liquidation |
|
FACR |
Fee Accrual |
|
LINK |
Linkage to Loan |
|
LIQD |
Liquidation of contract/schedules |
All Types |
NOTC |
Billing of Notice |
|
REAS |
Reassign User |
|
RESD |
Reversal of Residual Accrual In case the status of a contract changes to Non Accrual basis, all the accrued amounts are reversed using this Event Code. |
|
REVC |
Contract Reversal |
|
REVN |
Rate Revision |
|
REVP |
Reversal of payments/contract |
|
RFND |
Refund of Interest |
|
ROLL |
Rollover of Contract |
All Types |
RCHG |
Rate Change (Revision) |
|
RTFX |
Rate Fixing |
|
RTAM |
Rate Amendment |
|
SPRO |
Provisioning |
|
SPWB |
Write Back |
|
STCH |
Status Change |
All Types |
VAMB |
Value Dated Amendment Booking |
|
VAMI |
Value Dated Amendment Initiation |
|
YACR |
Yield To Maturity based Discount Accrual |
|
CREB |
Contra Rebalance |
|
FREB |
FAS114 Rebalance |
|
WREB |
Write-off Rebalance |
|
FRSV |
Unfunded and Funded FAS114 Reserve Increase/ Decrease |
|
TRCL |
Trade Reclassification |
|
RESR |
Reserve Decrease |
|
CICR |
Contra Increase |
|
CDCR |
Contra Decrease |
|
SPWV |
Special Penalty Waiver |
|
RSPW |
Reversal of Special Penalty Waiver |
|
PNTC |
Event to generate Payment Notice and Payoff Notice |
|
INNC |
Event to generate Insurance Expiry Notice and 45 Day Flood Notice – Escrow and Non Escrow |
|
RFLR |
Reversal of Fee Refund / Liquidation |
|
RFRV |
Reversal of FAS114 Reserve for commitment and loan |
|
RVCR |
Reversal of Contra Increase/Decrease |
|
REWR |
Reversal of Reserve/Write-off |
|
The amount tags listed below are hard-coded in Oracle Lending.
Amount Tag |
Description |
COMMUTIL_DECR |
Commitment Amount Reinstated |
COMMUTIL_INCR |
Commitment Amount Utilized |
INT_DISC_ADJ |
Discounted Interest Adjusted |
PRINCIPAL |
Principal Amount |
PRINCIPAL_ADDL |
Additional Principal |
PRINCIPAL_DECR |
Decrease in principal on amendment |
PRINCIPAL_FWD |
Forward takedown amount |
PRINCIPAL_INCR |
Increase in principal on amendment |
PRINCIPAL_LIQD |
Principal Amount Liquidated |
PRINCIPAL_ROLL |
Principal Amount Rolled over |
PRINCPAL_XFWD |
Principal Amount Reclassified |
PRINCPAL_XREV |
Principal Amount Unclassified |
PRO_AMT |
Provision Amount |
ROLLOVER_AMT |
Rollover Amount |
WB_AMT |
Write Back Amount |
INT_RESINC / INT_LIQD |
Restricted Interest Income liquidated / Interest Income Liquidated |
UNRLZD-LOSS |
LD Unrealized Loss |
UNRLZD-PRFT |
LD Unrealized Profit |
COMPONENT_MCICR |
Manual Contra Increase |
Deferred Interest _Component_LIQD |
Deferred interest component liquidated |
<Fee_Component>_FRFD |
Fee Component |
<Fee Component>_FRLQ |
Fee component liquidation |
<Fee Component>_FRRF |
Fee component refund |
In addition to these you can define amount tags as per your requirements for interest and charges that are attached to your product.
In this section we have provided a list of sample accounting roles.
Accounting Role |
Description |
Role Type |
CHGSINC |
Charges on the Loan Product |
Income |
FEESINC |
Liquidation Fees |
Income |
INTREC |
Interest Receivable |
Asset |
ASSETGL |
Asset GL for loans |
Asset |
INTAQR |
Interest on Principal |
Asset |
INTINC |
Interest on Principal |
Income |
FRTAX1_PAY |
Tax Payable role for FRTAX1 |
Liability |
FRTAX1_EXP |
Tax Expense role for FRTAX1 |
Expense |
FRTAXS_PAY |
Tax Payable role for FRTAXS |
Liability |
FRTAXS_EXP |
Tax Expense role for FRTAXS |
Expense |
FWDASSETGL |
GL for Future Dated Loans |
Contingent Asset |
FWDASSETOFF |
Offset for Future Dated Loans |
Contingent Liability |
ROLLFEESINC |
Rollover Fees |
Income |
VAMBFEESINC |
VAMB Fees |
Income |
P_PRNINC |
Penalty on Overdue Principal |
Income |
P_PRNREC |
Penalty Interest Receivable |
Asset |
P_INTINC |
Penalty Interest Income |
Income |
P_INTREC |
Penalty Interest Receivable |
Asset |
ASSETGL_REF |
Asset GL for Refinance |
Asset |
LAIBGL_REF |
Liability GL for Refinance |
Liability |
ASSETGL_REF_OFF |
Offset GL |
Asset |
LAIBGL_REF_OFF |
Offset GL |
Liability |
RESINT |
Restricted Interest |
Income |
UNREAL_MTM_INC |
Unrealized MTM Income |
Asset |
UNREAL_MTM_OFF |
Unrealized MTM Offset |
Asset |
UNREAL_MTM_EXP |
Unrealized MTM Expense |
Asset |
<Fee Component>FLR |
|
|
<Fee Component>FIA |
|
|
Note
In the accounting roles listed above the prefixes CHGS (charges), FEES (Fees), INT (Interest), FRTAX1, FRTAXS (Tax), P_PRN (Penalty), ROLLFEES (rollover fees), VAMBFEES (value dated amendment fees) are ICCF components.
The suffixes stand for:
AQR |
Acquired interest receivable |
EXP |
Expense |
INC |
Income |
PAY |
Payable |
REC |
Receivable |
Given below is a possible set of events and the advices that could be generated during the life cycle of a loan:
A payment was liquidated today by the Automatic Contract Update function of LD module |
An advice is generated addressed to the customer intimating him about the payment that was liquidated today. |
A back dated loan with a value date as of today was initiated |
An advice is generated addressed to the customer. If any components like discounted interest, tax on principal and so on are liquidated on initiation, an advice is generated for each of them. |
A change entered through the value dated changes function fell due today and was executed. |
An advice is generated notifying the customer about the changed terms of the loan. |
A floating rate/periodic rate of a loan has changed. |
An advice is generated telling the customer of the new interest rate applicable on the loan. |
A loan was rolled over into a new loan. |
An advice is generated addressed to the customer intimating him of the rolling over of the loan and the initiation of a new loan. |
In the subsequent sections we have defined suggested accounting entries and advices for each of the events in the life cycle of a Loan deal. Samples of accounting entries, advices, and events have been given for three different types of Loan and Commitment deals. They are:
Note
Some of the Amount Tag’s linked to the Accounting Roles are user defined.
The preferences set for this product are as follows:
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
INTREC |
INT_ACQD |
Debit |
INTAQR |
INT_ACQD |
Credit |
P_PRNREC |
P_PRN_ACQD |
Debit |
P_PRNAQR |
P_PRN_ACQD |
Credit |
ASSETGL |
PRINCIPAL |
Debit |
CUSTOMER |
PRINCIPAL |
Credit |
FWDASSETGL |
PRINCIPAL_FWD |
Credit |
FWDASSETOFF |
PRINCIPAL_FWD |
Debit |
Advices
Advice Name |
Description |
DEAL_SLIP |
Contract Advice |
CONT_ADV |
Contract Advice |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CUSTOMER |
LIQD |
Debit |
BOOKCHGINC |
LIQD |
Credit |
FWDASSETGL |
PRINCIPAL_FWD |
Debit |
FWDASSETOFF |
PRINCIPAL_FWD |
Credit |
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
INTINC |
INT_ACCR |
Credit |
INTREC |
INT_ACCR |
Debit |
P_PRNREC |
P_PRN_ACCR |
Debit |
P_PRNINC |
P_PRN_ACCR |
Credit |
Advices
No Advices allowed for this Event.
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
FRTAX1_PAY |
FRTAX1_AMT |
Credit |
FRTAX1_EXP |
FRTAX1_AMT |
Debit |
FRTAXS_PAY |
FRTAXS_AMT |
Credit |
FRTAXS_EXP |
FRTAXS_AMT |
Debit |
CUSTOMER |
INT_ADJ |
Debit |
INTREC |
INT_ADJ |
Credit |
INTREC |
INT_CAP |
Credit |
ASSETGL |
INT_CAP |
Debit |
CUSTOMER |
P_INT_LIQD |
Debit |
P_INTREC |
P_INT_LIQD |
Credit |
CUSTOMER |
PRINCIPAL_LIQD |
Debit |
ASSETGL |
PRINCIPAL_LIQD |
Credit |
CUSTOMER |
INT_LIQD |
Debit |
INTREC |
INT_LIQD |
Credit |
RESINTINC |
INT_RESINC |
Debit * |
INTINC |
INT_RESINC |
Credit * |
* - This entry is only for liquidation of interest on overdue loans on cash basis.
Advices
Advice Name |
Description |
CAP |
Capitalization Advice |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
COMPONENT_REC |
COMPONENT_RFND |
Debit |
CUSTOMER |
COMPONENT_RFND |
Credit |
Advices
Advice Name |
Description |
OVERPAYAMT |
Overpayment Advice |
GL |
Amount Tag |
Dr/Cr |
Customer |
INT_LIQD |
Dr |
INT_REC |
INT_LIQD |
Cr |
ADJ GL |
INT_WAIV |
Dr |
INT_REC |
INT_WAIV |
Cr |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ROLLFEESINC |
LIQD |
Credit |
CUSTOMER |
LIQD |
Debit |
CUSTOMER |
INT_LIQD |
Debit |
INTREC |
INT_LIQD |
Credit |
ASSETGL |
INT_ROLL |
Debit |
INTREC |
INT_ROLL |
Credit |
CUSTOMER |
P_INT_LIQD |
Debit |
P_INTREC |
P_INT_LIQD |
Credit |
CUSTOMER |
PPR_LIQD |
Debit |
PPRREC |
PPR_LIQD |
Credit |
ASSETGL |
PRINCIPAL_ADDL |
Debit |
CUSTOMER |
PRINCIPAL_ADDL |
Credit |
Advices
Advice Name |
Description |
CAP |
Capitalization Advice |
ROLL_ADV |
Rollover Advice |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Nil
Advices
No Advices allowed for this Event.
Accounting Entries
Nil
Advices
Nil
Accounting Entries
No Accounting Entries allowed for this Event.
Advices
Advice Name |
Description |
BILNOTC |
Billing Notice |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
PRINCIPAL_INCR |
Debit |
CUSTOMER |
PRINCIPAL_INCR |
Credit |
VAMBFEESINC |
LIQD |
Credit |
CUSTOMER |
LIQD |
Debit |
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
Reprice Suspense |
PRINCIPAL_SPTI |
Dr |
Asset |
PRINCIPAL_SPTI |
Cr. |
Reprice Suspense |
INTERESTFL_SPTI |
Dr. |
Interest Receivable |
INTERESTFL_SPTI |
Cr. |
Accounting Entries
Nil
Advices
Advice Name |
Description |
AMDADV |
Amendment Advice |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Nil
Advices
Advice Name |
Description |
AMDADV |
Amendment Advice |
The preferences set for this product are as follows:
Accounting Entries
No Accounting Entries allowed for this Event.
Advices
Advice Name |
Description |
BILNOTC |
Billing Notice |
Accounting Entries
Nil
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
BOOK: Booking of Contract
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CHGSINC |
LIQD |
Credit |
CUSTOMER |
LIQD |
Debit |
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CUSTOMER |
INT_LIQD |
Debit |
INTREC |
INT_LIQD |
Credit |
CUSTOMER |
P_INT_LIQD |
Debit |
P_INTREC |
P_INT_LIQD |
Credit |
CUSTOMER |
P_PRN_LIQD |
Debit |
P_PRNREC |
P_PRN_LIQD |
Credit |
CUSTOMER |
PRINCIPAL_LIQD |
Debit |
ASSETGL |
PRINCIPAL_LIQD |
Credit |
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
INTAQR |
INT_ACQD |
Credit |
INTREC |
INT_ACQD |
Debit |
CUSTOMER |
PRINCIPAL |
Credit |
ASSETGL |
PRINCIPAL |
Debit |
Advices
Advice Name |
Description |
PAYMENT_MESSAGE |
Payment Message |
CONT_ADV |
Contract Advice |
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
INTINC |
INT_ACCR |
Credit |
INTREC |
INT_ACCR |
Debit |
P_INTINC |
P_INT_ACCR |
Credit |
P_INTREC |
P_INT_ACCR |
Debit |
P_PRNINC |
P_PRN_ACCR |
Credit |
P_PRNREC |
P_PRN_ACCR |
Debit |
Advices
No Advices allowed for this Event.
Accounting Entries
Nil
Advices
Nil
Accounting Entries
Nil
Advices
Nil
The preferences set for this product are as follows:
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CUSTOMER |
CHARGES |
Debit |
CHARGEINC |
CHARGES |
Credit |
Advices
Nil
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
PRINCIPAL_FWD |
Debit |
ASSETOFF |
PRINCIPAL_FWD |
Credit |
Advices
Nil
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
COMMUTIL_INCR |
Credit |
ASSETOFF |
COMMUTIL_INCR |
Debit |
Advices
No Advices allowed for this Event.
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
PRINCIPAL |
Credit |
ASSETOFF |
PRINCIPAL |
Debit |
Advices
Nil
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
PRINCIPAL_DECR |
Credit |
ASSETOFF |
PRINCIPAL_DECR |
Debit |
ASSETGL |
PRINCIPAL_INCR |
Debit |
ASSETOFF |
PRINCIPAL_INCR |
Credit |
Advices
Nil
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ASSETGL |
COMMUTIL_DECR |
Debit |
ASSETOFF |
COMMUTIL_DECR |
Credit |
Advices
No Advices allowed for this Event.
The End of Day Batch Function marks the Expiry of the commitment availability on the Last Availability Date. The event “EXPY” is activated to mark the expiry of the commitment. The contingent accounting entries maintained for EXPY Event are as follows:
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CONASSETOFF |
PRINCIPAL |
Debit |
CONASSETGL |
PRINCIPAL |
Credit |
EOD batch posts reversal entries for past revaluation entry on commitment, if the market price is maintained for the CUSIP.
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
UNREAL_MTM_OFF |
UNRLZD-LOSS |
Credit |
UNREAL_MTM_EXP |
UNRLZD-LOSS |
Debit |
UNREAL_MTM_OFF |
UNRLZD-PRFT |
Debit |
UNREAL_MTM_INC |
UNRLZD-PRFT |
Credit |
You can maintain the following entries for change of status from ‘Non-performing’ to ‘Performing’ in order to reverse the memo interest and also to move the memo interest into real GLs.
Accounting Entries
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
INTERESTMINC |
INTEREST_ACCR |
Debit |
INTERESTMRC |
INTEREST_ACCR |
Credit |
INTERESTREC |
INTEREST_ACCR |
Debit |
INTERESTINC |
INTEREST_ACCR |
Credit |
If the Commitment Level Net Funded Carrying Value (CLNFCV) goes negative, refund will have to be triggered proportionally at the commitment contract to release each of the FAS91 amortization fee components, including Asset Transfer Marks and Deferred Interest Components, associated with the commitment. You need to set up the following entries for such unamortized refund:
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
<Fee Component>FIA |
<Fee Component>_FRFD |
Debit |
AMORTFEE-PNL |
<Fee Component>_FRFD |
Credit |
If the value of backend parameter ‘ALLOW_REPERFORMING_LOAN_FUNC’ is set to ‘Y’, amortization fee liquidation will be done on deferred fee interest component for the memo interest amount that is moved to Real GL. The effective date for this movement will be as of the status change date.
The following entries need to be set up for liquidating deferred interest fees:
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
<Deferred Interest Component>INC |
<Deferred Interest_ Component> _LIQD |
Debit |
<Deferred Interest Component>FIA |
<Deferred Interest_ Component> _LIQD |
Credit |
Note that the Accounting Head for Accounting Role <Deferred Int_component>INC should be the same as Income GL mapped to the Accounting Role ‘INTERESTINC_GL’ so that the GL balance will be zero after processing memo interest transfer. Alternately, a Wash GL can be mapped to the accounting role ‘<Deferred Int_component> INC’ in which case the balance in this GL will mirror the balance in the interest Income GL.
The following entries need to be set up for manual liquidation and refund for amortization fees:
Liquidation
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
Customer |
<Fee Component>_LIQD |
Debit |
<Fee Component>FIA |
<Fee Component>_LIQD |
Credit |
Refund
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
<Fee Component>FIA |
<Fee Component>_DECR |
Debit |
Customer |
<Fee Component>_DECR |
Credit |
The following entries need to be set up for systematic liquidation and refund for amortization fees:
Liquidation
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
<Fee Component>FLR |
<Fee Component>_FRLQ |
Debit |
<Fee Component>FIA |
<Fee Component>_FRLQ |
Credit |
Refund
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
<Fee Component>FIA |
<Fee Component>_FRRF |
Debit |
<Fee Component>FLR |
<Fee Component>_FRRF |
Credit |
The following accounting entries need to be maintained for release of FAS114 Reserve Funded balance when the commitment status changes from ‘Non-performing’ to ‘Performing’:
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
FASFNDEDRSV |
FUND_FASDEC |
Debit |
FASFUNDEDREL |
FUND_FASDEC |
Credit |
The following accounting entries need to be maintained for release of FAS114 Reserve Unfunded balance when the commitment status changes from ‘Non-performing’ to ‘Performing’:
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
FASUNFNDEDRSV |
UNFUND_FASDEC |
Debit |
FASUNFUNDRLS |
UNFUND_FASDEC |
Credit |
Note that these accounting entries will be posted only if ‘Cost of Credit’ box is checked for the loan.
The following accounting entries need to be maintained for ‘LIQD’ and ‘SPWV’ events at loan product level to process late payment charges.
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CUSTOMER |
<Special Penalty Component>_LIQD |
Debit |
<Special Penalty Component>INC |
<Special Penalty Component>_LIQD |
Credit |
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ADJMNT_GL |
<Special Penalty Component>_WAIV |
Debit |
ADJMNT_GL_OFF |
<Special Penalty Component>_WAIV |
Credit |
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
CUSTOMER |
<Special Penalty Component>_PAY |
Credit |
<Special Penalty Component>PAY |
<Special Penalty Component>_PAY |
Debit |
CUSTOMER |
<Special Penalty Component>_REC |
Debit |
<Special Penalty Component>REC |
<Special Penalty Component>_REC |
Credit |
Accounting entries for RSPW event will be derived by the system from the entries defined for SPWV.
Accounting Role |
Amount Tag |
Dr./Cr. Indicator |
ADJMNT_GL |
<Special Penalty Component>_WAIV |
Credit |
ADJMNT_GL_OFF |
<Special Penalty Component>_WAIV |
Debit |
Contract Ref No |
Account |
Amount Tag |
EVENT |
DrCr |
FCY Amt |
LCY Amt |
CIPLBN105118F3V4 |
160100501 |
PRINCIPAL_ADJ |
CADJ |
Cr |
|
2,000,000.00 |
CIPLBN105118F3V4 |
330850401 |
PRINCIPAL_ADJ |
CADJ |
Dr |
|
2,000,000.00 |
CIPLBN105118F3V4 |
0701000511 |
CONTRA-INT-ADJ |
CADJ |
Cr |
|
1,000,000.00 |
Contract Ref No |
Account |
Amount Tag |
EVENT |
DrCr |
FCY Amt |
LCY Amt |
CIPLBN105118F3V4 |
0702000921 |
CONTRA-INT-ADJ |
CADJ |
Dr |
|
1,000,000.00 |
Note
PRLQ: - Liquidation of the Payables/Receivables
RVPR: - Reversal of the Payable/Receivable Payment
Accounting Role |
Account |
Dr/Cr Indicator |
Expense |
COMPONENT_PAY |
Dr |
Customer |
COMPONENT_PAY |
Cr |
Asset |
PRINCIPAL_PAY |
Dr |
Customer |
PRINCIPAL_PAY |
Cr |
Customer |
COMPONENT_REC |
Dr |
Accounting Role |
Account |
Dr/Cr Indicator |
Income |
COMP_REC |
Cr |
Customer |
PRINCIPAL_REC |
Dr |
Asset |
PRINCIPAL_REC |
Cr |
In this section, we shall discuss the manner in which you can define attributes and pass accounting entries specific to a Discounted Loan product.
A discounted loan is one for which the interest is collected upfront.
Example
On Jan 01, 2002, you lend USD 100 to customer ABC for a tenor of 1 year at a rate of interest of 10% per year. On Dec 31, 2002, he would pay you back USD 110 – repayment of principal amount of USD 100 and payment of interest of USD 10.
Instead, in a Discounted Loan, you collect the interest of USD 10 upfront.
Therefore, you book a loan of USD 100 while disbursing USD 100 – USD 10 = USD 90.
For each event (INIT, ACCR, LIQD), the Product Event Accounting Entries Maintenance Screen allows you to select the Accounting Roles, the corresponding Amount Tags and the Debit/Credit Indicator.
Event INIT
For the above example, the following accounting entries will be passed on INIT:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
Amount |
ASSETGL |
PRINCIPAL |
Dr |
100.00 |
CUSTOMER |
PRINCIPAL |
Cr |
100.00 |
LDDL-INTRIA |
LDDL-INT_LIQD |
Cr |
10.00 |
CUSTOMER |
LDDL-INT_LIQD |
Dr |
10.00 |
Event: ACCR
Accrued interest is pro-rated over the life of the loan. Accrual entries passed are as follows:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
LDDL-INTREC |
LDDL-INT_ACCR |
Dr |
LDDL-INTINC |
LDDL-INT_ACCR |
Cr |
Event: LIQD
For the above example, let us assume that the principal amount of USD 100 is liquidated in equal installments as shown in the graph above, i.e., USD 20 is liquidated in each of five tranches. Entries for liquidation of accrued interest are passed along with the installment liquidation entries.
Note
During each liquidation, the entire interest accrued till that date will be liquidated, irrespective of the whether the customer is repaying the full installment or not.
For the above example, the entries passed during each of the five liquidations are:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
Amount |
ASSETGL |
PRINCIPAL_LIQD |
Cr |
20.00 |
CUSTOMER |
PRINCIPAL_LIQD |
Dr |
20.00 |
LDDL-INTRIA |
LDDL-INT_LIQD |
Dr |
2.00 |
LDDL-INTREC |
LDDL-INT_LIQD |
Cr |
2.00 |
The following entries are applicable when interest payment is done for non-performing loans:
LIQD: Interest Payment
Account |
Amount |
Dr/Cr Indicator |
CUSTOMER |
INTEREST |
Dr |
RECEIVABLE |
INTEREST |
Cr |
ACCR: Memo To Real Movement
Account |
Amount |
Dr/Cr Indicator |
MEMO INCOME |
INTEREST |
Dr |
MEMO RECEIVABLE |
INTEREST |
Cr |
RECEIVABLE |
INTEREST |
DR |
INCOME |
INTEREST |
CR |
CICR: Contra Increase
Account |
Amount |
Dr/Cr Indicator |
INCOME |
INTEREST |
Dr |
CONTRA |
INTEREST |
Cr |
The following entries are passed when interest payment for non-performing loans is reversed:
REVP: Interest Payment Reversal
Account |
Amount |
Dr/Cr Indicator |
RECEIVABLE |
INTEREST |
Dr |
CUSTOMER |
INTEREST |
Cr |
ACCR: Memo To Real Movement
Account |
Amount |
Dr/Cr Indicator |
MEMO RECEIVABLE |
INTEREST |
Dr |
MEMO INCOME |
INTEREST |
Cr |
INCOME |
INTEREST |
DR |
RECEIVABLE |
INTEREST |
CR |
CICR: Contra Increase
Account |
Amount |
Dr/Cr Indicator |
CONTRA |
INTEREST |
Dr |
INCOME |
INTEREST |
Cr |
The following are the entries for interest payment for non-performing loans which are partially or fully reserved:
LIQD: Interest Payment
Account |
Amount |
Dr/Cr Indicator |
CUSTOMER |
INTEREST |
Dr |
RECEIVABLE |
INTEREST |
Cr |
ACCR: Memo To Real Movement
Account |
Amount |
Dr/Cr Indicator |
MEMO INCOME |
INTEREST |
Dr |
MEMO RECEIVABLE |
INTEREST |
Cr |
RECEIVABLE |
INTEREST |
DR |
INCOME |
INTEREST |
CR |
CICR: Contra Increase
Account |
Amount |
Dr/Cr Indicator |
INCOME |
INTEREST |
Dr |
CONTRA |
INTEREST |
Cr |
FRSV: FAS114 Reserve Decrease
Account |
Amount |
Dr/Cr Indicator |
FAS114 FUNDED RESERVE |
Least of (Reserve Decrease Amt, Existing FAS 114 Reserve) |
Dr |
FAS114 FUNDED RELEASE |
Least of (Reserve Decrease Amt, Existing FAS 114 Reserve) |
Cr |
RESR: Reserve Decrease
Account |
Amount |
Dr/Cr Indicator |
RESERVE |
Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve) |
Dr |
RECOVERY |
Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve) |
Cr |
The following entry is posted when a manual contra increase is performed for an Non-reserved Loan:
CICR: Contra Increase
Account |
Amount |
Dr/Cr Indicator |
CUSTOMER |
INTEREST |
Dr |
CONTRA |
INTEREST |
Cr |
The following entries are posted when a manual contra increase is performed for a reserved Loan:
CICR: Contra Increase
Account |
Amount |
Dr/Cr Indicator |
CUSTOMER |
INTEREST |
Dr |
CONTRA |
INTEREST |
Cr |
FRSV: FAS114 Reserve Decrease
Account |
Amount |
Dr/Cr Indicator |
FAS114 FUNDED RESERVE |
Least of (Reserve Decrease Amt, Existing FAS 114 Reserve) |
Dr |
FAS114 FUNDED RELEASE |
Least of (Reserve Decrease Amt, Existing FAS 114 Reserve) |
Cr |
RESR: Reserve Decrease
Account |
Amount |
Dr/Cr Indicator |
RESERVE |
Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve) |
Dr |
RECOVERY |
Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve) |
Cr |
The following entries are posted for cost of credit valuation:
FELR: Fee Liquidation
The entries posted for fee liquidation are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
COMPONENT_FIA |
COMPONENT_DECR |
D |
MARKWOOFFSET |
COMPONENT_DECR |
C |
CUSTOMER |
COMPONENT_LIQD |
D |
COMPONENT_FIA |
COMPONENT_LIQD |
C |
COMPONENT_FIA |
COMPONENT_DECR |
D |
CUSTOMER |
COMPONENT_DECR |
C |
COMPONENT_FIA |
COMPONENT_LIQD |
C |
CUSTOMER |
COMPONENT_LIQD |
D |
FACR: Fee Accrual
The entries for fee accrual are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
COMPONENT_FIN |
COMPONENT_ACCR |
C |
COMPONENT_FIA |
COMPONENT_ACCR |
D |
FRSV: Unfunded and Funded FAS114 Reserve Increase/ Decrease
The entries for unfunded FAS114 reserve decrease are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
FASUNFNDEDRSV |
UNFUND_FASDEC |
Dr |
FASUNFUNDRLS |
UNFUND_FASDEC |
Cr |
The entries for unfunded FAS114 reserve increase are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
FASUNFUNDBLD |
UNFUND_FASINC |
Dr |
FASUNFNDEDRSV |
UNFUND_FASINC |
Cr |
The entries for funded FAS114 reserve increase are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
FASFUNDEDBUILD |
FUND_FASINC |
D |
FASFNDEDRSV |
FUND_FASINC |
C |
The entries for funded FAS114 reserve decrease are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
FASFNDEDRSV |
FUND_FASDEC |
D |
FASFUNDEDREL |
FUND_FASDEC |
C |
TRCL: Trade Reclassification
The entries posted for trade reclassification are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
CONASSETGL |
PRINC_HFS_DECR |
D |
CONASSETGLHFS |
PRINC_HFS_DECR |
C |
CONASSETGLHFS |
PRINC_HFS_INCR |
D |
CONASSETGL |
PRINC_HFS_INCR |
C |
ASSETGL |
PRINC_HFS_DECR |
D |
ASSETGLHFS |
PRINC_HFS_DECR |
C |
ASSETGLHFS |
PRINC_HFS_INCR |
D |
ASSETGL |
PRINC_HFS_INCR |
C |
CREB: Contra Rebalance
The entries posted for contra rebalancing are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
CONTRAGL |
LD-FX-INT_CDCR |
D |
WASHACC |
LD-FX-INT_CDCR |
C |
WASHACC |
LD-FX-INT_CICR |
D |
CONTRAGL |
LD-FX-INT_CICR |
C |
FREB: FAS114 Rebalance
The entries posted for FAS114 rebalancing are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
FASFNDEDRSV |
FUND_FASDEC |
D |
WASHACC |
FUND_FASDEC |
C |
WASHACC |
FUND_FASINC |
D |
FASFNDEDRSV |
FUND_FASINC |
C |
WREB: Write-off Rebalance
The entries posted for write-off rebalancing are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
RESERVEGL |
PRINCIPAL_RDEC |
D |
WASHACC |
PRINCIPAL_RDEC |
C |
WASHACC |
PRINCIPAL_RINC |
D |
RESERVEGL |
PRINCIPAL_RINC |
C |
RESR: Reserve Decrease
The entries posted for reserve decrease are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
RESERVEGL |
PRINCIPAL_RDEC |
D |
URECOVERY_GL |
PRINCIPAL_RDEC |
C |
WRITEOFFEXP |
PRINCIPAL_RINC |
D |
RESERVEGL |
PRINCIPAL_RINC |
C |
CDCR: Contra Decrease
The entries posted for contra decrease are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
CONTRAGL |
COMPONENT_CDCR |
D |
CUSTOMER |
COMPONENT _CDCR |
C |
CICR: Contra Increase
The entries posted for contra increase are listed below:
Accounting Role |
Amount Tag |
Dr/Cr Indicator |
COMPONENTINC |
COMPONENT_CICR |
D |
CONTRAGL |
COMPONENT_CICR |
C |
CUSTOMER |
COMPONENT_MCICR |
D |
CONTRAGL |
COMPONENT_MCICR |
C |
The possible accounting entries for the event TRCL are given below:
Event |
Amount Tag |
Accounting Role |
Dr/Cr |
TRCL |
LCLMT_HFS_INCR |
LCSUBLIMITHFS |
Dr |
TRCL |
LCLMT_HFS_INCR |
LCSUBLIMIT |
Cr |
TRCL |
LCLMT_HFS_DECR |
LCSUBLIMIT |
Dr |
TRCL |
LCLMT_HFS_DECR |
LCSUBLIMITHFS |
Cr |
The following error codes are available for exchange details:
Error_Code |
Description |
CF-NRTE01 |
Amort Exch Rate cannot be less than equal to Zero |
The following error codes are available for effective date:
Error Code |
Message |
Type |
LD-EXAMD102 |
Effective date cannot be earlier than the last commitment fee liquidation date |
E |
LD-EXAMD101 |
Effective date cannot be earlier or equal to VAMI date. + code change |
E |
The following error codes are available for adjustment reversal details:
Error_Code |
Description |
LD-ADJ-022 |
Invalid Debit GL Account. |
LD-ADJ-023 |
Invalid Credit GL Account. |
LD-ADJ-026 |
Accounting entries not found for the Debit account type |
LD-ADJ-025 |
Accounting entries not found for the Credit account type |
LD-ADJ-027 |
Adjustments Reversal Processing Failed |
LD-ADJ-028 |
Value Date cannot be less than today for Operation Adjustments |
LD-ADJ-029 |
Auto reversal is not allowed for Operation Adjustments |
The following error codes are available for the cost of credit valuation process:
Error_Code |
Description |
LD-COC-01 |
COC Revaluation failed |
LD-COC-02 |
Failed in COC balances population |
LD-COC-03 |
Failed in commitment COC population |
LD-COC-04 |
Failed in commitment COC balances population |
LD-COC-05 |
Failed in loan balances population for a commitment |
LD-COC-06 |
Failed in populating loan balance |
LD-COC-07 |
Error in loan COC balance population |
LD-COC-08 |
Error in updating commitment COC balance |
LD-COC-09 |
Error in updating loan COC balance |
LD-COC-10 |
Net carry value for a loan cannot be negative |
LD-COC-11 |
Failed in updating loan COC rebalance values |
LD-COC-12 |
Failed in Transfer Asset Marks processing |
LD-COC-13 |
Failed in populating Transfer Asset Marks |
LD-COC-14 |
Failed in FAS114/ Write-off processing |
LD-COC-15 |
Failed in populating FAS114/ Write-off amounts |
LD-COC-16 |
Failed in Recovery processing |
LD-COC-17 |
Failed in Rebalance processing |
LD-COC-18 |
Failed in Cost of Credit Validation |
LD-COC-19 |
Error in populating Cost of Credit details |
LD-COC-20 |
Error in setting Cost of Credit valuation required flag |
LD-COC-21 |
Failed in Cost of Credit valuation status update |
LD-COC-22 |
Cannot set Cost of Credit Valuation, as Product is not checked for Cost Of Credit Valuation |
LD-COC-23 |
Failed in computing FAS114 Reserve Release values |
LD-COC-24 |
Failed in CoC balances archiving |
LD-COC-26 |
FAS91 Fee Refund / Liquidation population failed |
LD-COC-27 |
FAS91 Fee Refund / Liquidation process failed |
LD-COC-28 |
At least one event should be chosen for reversal |
LD-COC-29 |
Only one event at a time can be reversed |
LD-COC-30 |
Failed in Deferred interest component processing on commitments |
LD-COC-31 |
Failed in Negative carrying value processing on commitments |
LD-COC-33 |
Failed in Amort fee accrual restart |
LD-COC-39 |
Contra/Writeoff/Fas114 Reserve balance will be in negative after reversal. Do you want to continue? |
LD-COC-34 |
COC Valuation required flag will be defaulted from product as contract is in Non-Performing Status. Do you want to proceed? |
LD-COC-40 |
COC balance is negative after rebalancing |
CF-AC005 |
Only one component is allowed to check as Deferred interest component |
The following error codes are available for LC Sublimit Balance (HFI) Update:
Error_Code |
Description |
LD-STP-LC06 |
LC Sublimit HFI Balance Update failed |
The following error codes are available for late payment charges:
Error_Code |
Description |
Error Type |
LD-CON-310 |
Grace days for the Loan is defaulted from the commitment contract |
O |
LD-CON-311 |
Grace period is defaulted from loan product |
O |
LD-VAM-61 |
For special rate type Amount/Rate change should be current dated |
E |
CS-WVR-001 |
Penalty Waiver Details need to be captured |
E |
CS-WVR-002 |
Amendment is not allowed on the Reversed Transactions |
E |
CS-WVR-003 |
Transaction did not happen from here, amend it from appropriate screen |
E |
CS-WVR-004 |
Transactions can be saved only with waive flag checked |
E |
CS-WVR-005 |
Prior schedules are unpaid for this component. Please pay/waive all such schedules before proceeding |
E |
CF-CL0021 |
For the given amount category, Accrual Required flag should be set to N |
E |
CS-WVR-006 |
Reversal of Waiver not allowed as nothing is due on the given due date |
E |
CS-WVR-007 |
Reversal not allowed, Latest due date should be reversed first. |
E |
CS-WVR-008 |
Later schedules are waived for this component. Please reverse waiver for all such schedules before proceeding |
E |
Error Code |
Description |
Error Type |
LD-FLR-001 |
Rate for $1 component is lesser than the Floor defined at Commitment Level. Do you want to override? |
O |
LD-FLR-002 |
Rate for $1 component is greater than the Ceiling defined at Commitment Level. Do you want to override? |
O |
LD-FLR-003 |
Failed in getting the floor and ceiling rate |
E |
LD-FLR-004 |
Rate for $1 component is lesser than the Floor defined at Commitment Level. Do you want to Continue? |
O |
LD-FLR-005 |
Rate for $1 component is greater than the Ceiling defined at Commitment Level. Do you want to Continue? |
O |
LD-FLR-006 |
Maintenance was not done from here, so authorize it from appropriate screen. |
E |
LD-FLR-007 |
Maintenance was not done from here, so delete it from appropriate screen |
E |
The following error codes are available for Pool Funds:
Error Code |
Description |
LD-POOL-01 |
Pool Amount cannot be Blank or zero or negative |
LD-POOL-02 |
Cannot Copy Unauthorized Record |
LD-POOL-05 |
Pool funding ref no cannot be null. |
LD-POOL-06 |
Master funding ref no cannot be null. |
LD-POOL-07 |
Contract Amount is not maintained. |
LD-POOL-08 |
Contract currency is not maintained |
LD-POOL-09 |
Unable to compute available amount for the pool $1. |
LD-POOL-10 |
Insufficient balance in the Pool $1, booking not allowed. |
LD-POOL-11 |
Failed in validating funding pool details. |
LD-POOL-12 |
Pool $1 is either unauthorized or locked by another process. Cannot proceed. |
LD-POOL-16 |
Loan and Commitment currency should be same for Commitments linked to a Pool. |
LD-POOL-17 |
This Commitment is linked to loans in a different currency; hence Pool cannot be attached. |
The following error code is available for Chinese Characters in payment:
Error Code |
Description |
LD-BR103 |
Do you want to disable Chinese characters in Payment ? |
The following error codes are available for UCC processing of disclosure codes and contract disclosure schedule:
Error Code |
Description |
LS-DSC-017 |
Expiry Date cannot be less than Application Date |
LS-DSC-018 |
Expiry Date is Mandatory if UCC code is selected |
LS-DSC-019 |
Expiry Date will be propagated to UCC linked contracts upon authorization, do you want to continue? |
LS-DSC-022 |
Contract Disclosure schedule for $1 is being amended by another user; expiry date will not be propagated |
LS-DSC-028 |
Expiry Date will not be propagated to contracts, do you want to continue? |
LS-DSC-031 |
Multiple schedules are not allowed for UCC disclosure codes |
LS-DSC-032 |
End date cannot be lesser than Start date |
LS-DSC-033 |
Cannot delete the schedule for UCC disclosure codes |
The following error codes are available for marking the status of a loan or commitment contract from ‘Active’ to ‘Liquidated’.
Err Code |
Error Message |
LD-PMT304 |
Active Loans exist for the commitment. Liquidation not allowed. |
LD-PMT306 |
Contract will be liquidated. Proceed? |
LD-PMT307 |
Maturity date is greater than application date. Liquidation not allowed. |
LD-PMT308 |
Validation for marking the liquidation is failed. |
LD-PMT309 |
Principal Outstanding/amount due balance still exists. Liquidation not allowed. |
LD-PMT310 |
Active STP contract exists. Liquidation not allowed. |
LD-PMT311 |
The escrow balances linked to this contract is not zero. Liquidation not allowed. |
LD-PMT313 |
Pending STP contract yet to be processed. Liquidation not Allowed |
The following error codes are available for clearing line and credit line validation on Tranche and Drawdown contracts.
Err Code |
Error Message |
LD-C0802 |
Approved Clearing Line is Not Specified. |
LD-C0812 |
Origination self participant $1 of the tranche is not linked to credit line. |
LD-C0813 |
Self Participant $1''s amount $2 is more than credit limit amount $3. |
LD-C0814 |
Clearing line limit check for tranche is failing .Tranche non HFI amount $1 is more than limit amount $2 |
LD-C0815 |
Tranche is linked to an unavailable clearing line. |
LD-C0816 |
Origination self participant $1 is linked to an unavailable credit line. |
LD-C0817 |
The Credit line GFRN value cannot change to clearing line GFRN. |
LD-C0818 |
The Clearing line GFRN value cannot change to credit line GFRN. |
The following error codes are available for participant level margin maintenance on Tranche and Drawdown contracts.
Err Code |
Error Message |
LN-PMAR-001 |
Lender margin maintenance is not allowed as this functionality is not enabled at Loan parameter maintenance level |
LN-PMAR-002 |
Margin maintenance for lenders is not applicable for LOR type of contracts |
LN-PMAR-003 |
NPVAMI is already performed on $1 hence participant margin can not be changed |
LN-PMAR-005 |
Lender margin can be maintained only for main interest margin components |
LN-PMAR-006 |
Floor/Ceiling is already maintained. Do you want to override it? |
LN-PMAR-007 |
Total margin rate of all the participants is not same with borrower margin rate |
LN-PMAR-010 |
Participant margin is not allowed on the tranche $1 having non prorata payment captured on underlying drawdowns |
LN-PMAR-011 |
Lender margin can not be maintained for non-cascade participation types of tranche |
LN-PMAR-016 |
Please visit the participant margin screen to correct the margin there |
LN-PMAR-015 |
Participant margin maintained for effective date $1 will also be cleared. Do you want to proceed. |
The following error codes are available for CUSIP reclass.
Error Code |
Error Description |
LD-RCLS-001 |
Batch No/No of job for CUSIP no reclass is not available could not proceed with reclass processing |
LD-RCLS-002 |
Cusip No Reclass has happened for this contract. Do you want to proceed?. |
LD-RCLS-003 |
CUSIP Reclass reprocessed successfully |
LD-PMT317 |
Marking the tranche as Inactive is failed |
The Loan details are as follows:
Date (Outflow) |
Period |
Outflow Amount |
Sub Periods Fraction |
Discounted Outflow |
Date (Receipts) |
Periods |
Total Pay |
Sub Period Fraction |
Discounted Value of Receipts |
1/1/2002 |
0 |
10000 |
0.0000 |
10000 |
1/1/2002 |
0 |
|
0.0000 |
0.00 |
2/1/2002 |
1.00 |
|
0.0333 |
|
2/1/2002 |
1.00 |
100 |
0.0333 |
98.99 |
3/1/2002 |
1.00 |
|
0.9667 |
|
3/1/2002 |
1.00 |
100 |
0.9667 |
98.09 |
4/1/2002 |
3.00 |
|
0.0000 |
|
4/1/2002 |
3.00 |
100 |
0.0000 |
97.10 |
5/1/2002 |
4.00 |
|
0.0000 |
|
5/1/2002 |
4.00 |
100 |
0.0000 |
96.15 |
6/1/2002 |
5.00 |
|
0.0333 |
|
6/1/2002 |
5.00 |
100 |
0.0333 |
95.18 |
7/1/2002 |
6.00 |
|
0.0333 |
|
7/1/2002 |
6.00 |
100 |
0.0333 |
94.25 |
8/1/2002 |
7.00 |
|
0.0667 |
|
8/1/2002 |
7.00 |
100 |
0.0667 |
93.30 |
9/1/2002 |
8.00 |
|
0.1000 |
|
9/1/2002 |
8.00 |
100 |
0.1000 |
92.36 |
10/1/2002 |
9.00 |
|
0.1000 |
|
10/1/2002 |
9.00 |
100 |
0.1000 |
91.45 |
11/1/2002 |
10.00 |
|
0.1333 |
|
11/1/2002 |
10.00 |
100 |
0.1333 |
90.53 |
12/1/2002 |
11.00 |
|
0.1333 |
|
12/1/2002 |
11.00 |
100 |
0.1333 |
89.65 |
1/1/2003 |
12.00 |
|
0.1667 |
|
1/1/2003 |
12.00 |
10100 |
0.1667 |
8,962.96 |
The Loan details are as follows:
Date (Outflow) |
Period |
Outflow Amount |
Sub Periods Fraction |
Discounted Outflow |
Date (Receipts) |
Periods |
Total Pay |
Sub Period Fraction |
Discounted Value of Receipts |
1/1/2002 |
0 |
10000 |
0.0000 |
10000 |
1/1/2002 |
0 |
$0.00 |
0.0000 |
0.00 |
2/1/2002 |
0.00 |
|
0.0861 |
|
2/1/2002 |
0.00 |
0 |
0.0861 |
0.00 |
3/1/2002 |
0.00 |
|
0.1639 |
|
3/1/2002 |
0.00 |
0 |
0.1639 |
0.00 |
4/1/2002 |
0.00 |
|
0.2500 |
|
4/1/2002 |
0.00 |
0 |
0.2500 |
0.00 |
5/1/2002 |
0.00 |
|
0.3333 |
|
5/1/2002 |
0.00 |
0 |
0.3333 |
0.00 |
6/1/2002 |
0.00 |
|
0.4194 |
|
6/1/2002 |
0.00 |
0 |
0.4194 |
0.00 |
7/1/2002 |
0.00 |
|
0.5028 |
|
7/1/2002 |
0.00 |
0 |
0.5028 |
0.00 |
8/1/2002 |
0.00 |
|
0.5889 |
|
8/1/2002 |
0.00 |
0 |
0.5889 |
0.00 |
9/1/2002 |
0.00 |
|
0.6750 |
|
9/1/2002 |
0.00 |
0 |
0.6750 |
0.00 |
10/1/2002 |
0.00 |
|
0.7583 |
|
10/1/2002 |
0.00 |
0 |
0.7583 |
0.00 |
11/1/2002 |
0.00 |
|
0.8444 |
|
11/1/2002 |
0.00 |
0 |
0.8444 |
0.00 |
12/1/2002 |
0.00 |
|
0.9278 |
|
12/1/2002 |
0.00 |
0 |
0.9278 |
0.00 |
1/1/2003 |
1.00 |
|
0.0139 |
|
1/1/2003 |
1.00 |
11071.43 |
0.0139 |
10,000.00 |
The Loan details are as follows:
Date (Outflow) |
Period |
Outflow Amount |
Sub Periods Fraction |
Discounted Outflow |
Date (Receipts) |
Periods |
Total Pay |
Sub Period Fraction |
Discounted Value of Receipts |
1/1/2002 |
0 |
10000 |
0.0000 |
10000 |
1/1/2002 |
0 |
$0.00 |
0.0000 |
0.00 |
2/1/2002 |
1.00 |
|
0.2917 |
|
2/1/2002 |
1.00 |
100 |
0.2917 |
98.99 |
3/1/2002 |
2.00 |
|
0.4583 |
|
3/1/2002 |
2.00 |
100 |
0.4583 |
98.09 |
4/1/2002 |
3.00 |
|
0.7500 |
|
4/1/2002 |
3.00 |
100 |
0.7500 |
97.10 |
5/1/2002 |
5.00 |
|
0.0000 |
|
5/1/2002 |
5.00 |
100 |
0.0000 |
96.15 |
6/1/2002 |
6.00 |
|
0.2917 |
|
6/1/2002 |
6.00 |
100 |
0.2917 |
95.18 |
7/1/2002 |
7.00 |
|
0.5417 |
|
7/1/2002 |
7.00 |
100 |
0.5417 |
94.25 |
8/1/2002 |
8.00 |
|
0.8333 |
|
8/1/2002 |
8.00 |
100 |
0.8333 |
93.30 |
9/1/2002 |
10.00 |
|
0.1250 |
|
9/1/2002 |
10.00 |
100 |
0.1250 |
92.35 |
10/1/2002 |
11.00 |
|
0.3750 |
|
10/1/2002 |
11.00 |
100 |
0.3750 |
91.45 |
11/1/2002 |
12.00 |
|
0.6667 |
|
11/1/2002 |
12.00 |
100 |
0.6667 |
90.53 |
12/1/2002 |
13.00 |
|
0.9167 |
|
12/1/2002 |
13.00 |
100 |
0.9167 |
89.64 |
12/5/2002 |
14 |
|
.0833 |
|
12/5/2002 |
14.00 |
13.33 |
0.0833 |
11.93 |
12/12/2002 |
14 |
|
.3750 |
|
12/12/2002 |
14.00 |
23.33 |
0.3750 |
20.84 |
12/27/2002 |
14 |
|
.0000 |
|
12/27/2002 |
15.00 |
50 |
0.0000 |
44.44 |
1/1/2003 |
15.00 |
|
0.2083 |
|
1/1/2003 |
15.00 |
10013.33 |
0.2083 |
8,885.76 |
The Loan details are as follows:
Date (Outflow) |
Period |
Outflow Amount |
Sub Periods Fraction |
Discounted Outflow |
Date (Receipts) |
Periods |
Total Pay |
Sub Period Fraction |
Discounted Value of Receipts |
1/1/2002 |
0 |
10000 |
0.0000 |
10000 |
1/1/2002 |
0 |
$0.00 |
0.0000 |
0.00 |
2/1/2002 |
1.00 |
|
0.0333 |
|
2/1/2002 |
1.00 |
100 |
0.0333 |
98.58 |
3/1/2002 |
1.00 |
|
0.9667 |
|
3/1/2002 |
1.00 |
100 |
0.9667 |
97.32 |
4/1/2002 |
3.00 |
|
0.0000 |
|
4/1/2002 |
3.00 |
150 |
0.0000 |
143.91 |
5/1/2002 |
4.00 |
|
0.0000 |
|
5/1/2002 |
4.00 |
150 |
0.0000 |
141.93 |
6/1/2002 |
5.00 |
|
0.0333 |
|
6/1/2002 |
5.00 |
150 |
0.0333 |
139.92 |
7/1/2002 |
6.00 |
|
0.0333 |
|
7/1/2002 |
6.00 |
150 |
0.0333 |
138.00 |
8/1/2002 |
7.00 |
|
0.0667 |
|
8/1/2002 |
7.00 |
150 |
0.0667 |
136.04 |
9/1/2002 |
8.00 |
|
0.1000 |
|
9/1/2002 |
8.00 |
150 |
0.1000 |
134.11 |
10/1/2002 |
9.00 |
|
0.1000 |
|
10/1/2002 |
9.00 |
150 |
0.1000 |
132.27 |
11/1/2002 |
10.00 |
|
0.1333 |
|
11/1/2002 |
10.00 |
150 |
0.1333 |
130.40 |
12/1/2002 |
11.00 |
|
0.1333 |
|
12/1/2002 |
11.00 |
150 |
0.1333 |
128.61 |
1/1/2003 |
12.00 |
|
0.1667 |
|
1/1/2003 |
12.00 |
10150 |
0.1667 |
8,578.91 |
The Loan details are as follows:
Date |
Period |
Outflow Amount |
Sub Periods Fraction |
VP Outflow |
Date (Receipts) |
Periods |
Total Pay |
Sub Period Fraction |
Discounted Value of Receipts |
1/1/2002 |
0 |
10000 |
0.0000 |
10000 |
1/1/2002 |
0 |
$0.00 |
0.0000 |
0.00 |
1/31/2002 |
1.00 |
|
0.0333 |
|
1/31/2002 |
1.00 |
96.67 |
0.0000 |
95.70 |
3/1/2002 |
1.00 |
|
0.9667 |
|
3/1/2002 |
1.00 |
10103.33 |
0.9667 |
9,904.30 |
4/1/2002 |
3.00 |
|
0.0000 |
|
4/1/2002 |
3.00 |
0 |
0.0000 |
0.00 |
5/1/2002 |
4.00 |
|
0.0000 |
|
5/1/2002 |
4.00 |
0 |
0.0000 |
0.00 |
6/1/2002 |
5.00 |
|
0.0333 |
|
6/1/2002 |
5.00 |
0 |
0.0333 |
0.00 |
7/1/2002 |
6.00 |
|
0.0333 |
|
7/1/2002 |
6.00 |
0 |
0.0333 |
0.00 |
8/1/2002 |
7.00 |
|
0.0667 |
|
8/1/2002 |
7.00 |
0 |
0.0667 |
0.00 |
9/1/2002 |
8.00 |
|
0.1000 |
|
9/1/2002 |
8.00 |
0 |
0.1000 |
0.00 |
10/1/2002 |
9.00 |
|
0.1000 |
|
10/1/2002 |
9.00 |
0 |
0.1000 |
0.00 |
11/1/2002 |
10.00 |
|
0.1333 |
|
11/1/2002 |
10.00 |
0 |
0.1333 |
0.00 |
12/1/2002 |
11.00 |
|
0.1333 |
|
12/1/2002 |
11.00 |
0 |
0.1333 |
0.00 |
1/1/2003 |
12.00 |
|
0.1667 |
|
1/1/2003 |
12.00 |
0 |
0.1667 |
0.00 |