Download Term Deposit User Manual

Rounding Required
Check this box.
Click ‘Formula Wizard’ button and invoke the ‘Formula Wizard’ screen.
Formula 1
Specify the following expressions:
Case
Result
(TENOR<=90) AND
(DLY_NET_BAL_M>0) AND PENALTY_BASIS = 0
((DLY_NET_BAL_M * DAYS * TD_1) / (100 *
YEAR))
(TENOR>90 AND TENOR<=180) AND
(DLY_NET_BAL_M>0) AND PENALTY_BASIS = 0
((DLY_NET_BAL_M * DAYS * TD_2) / (100 *
YEAR))
(TENOR>180 AND TENOR<=730) AND
(DLY_NET_BAL_M>0) AND PENALTY_BASIS = 0
((DLY_NET_BAL_M * DAYS * TD_3) / (100 *
YEAR))
(TENOR<=90) AND
(DLY_NET_BAL_M>0) AND (PENALTY_BASIS = DLY_NET_BAL_M)
((PENALTY_BASIS * DAYS) * (TD_1TD_PNL)) / (100 * YEAR)
(TENOR>90 AND TENOR<=180) AND
(DLY_NET_BAL_M>0) AND (PENALTY_BASIS = DLY_NET_BAL_M)
((PENALTY_BASIS* DAYS) * (TD_2TD_PNL)) / (100 * YEAR)
(TENOR>180 AND TENOR<=730) AND
(DLY_NET_BAL_M>0) AND (PENALTY_BASIS = DLY_NET_BAL_M)
((PENALTY_BASIS * DAYS) * (TD_3TD_PNL)) / (100 * YEAR)
Formula 2
Specify the following details:
Book Flag
Select ‘Booked’ from the adjoining drop-down list.
Debit/Credit
Select ‘Debit’ from the adjoining drop-down list.
Days in a Month
Select ‘Actuals’ from the adjoining drop-down list.
Days in a Year
Select ‘Actuals’ from the adjoining drop-down list.
Rounding Required
Check this box.
9-7