0

Variable interest rate with Surcharge

Aug 16, 2017 at 09:53 AM

64

Former Member

Hello friends, I need your help.

I have next interest structure:

In view V_T056P i have next entry:

CBRF СтРефЦБРФ 19.06.2017 9,0000000

CBRF СтРефЦБРФ 02.05.2017 9,2500000

CBRF СтРефЦБРФ 27.03.2017 9,7500000

CBRF СтРефЦБРФ 19.09.2016 10,0000000

The problem is that some cash flow dont take a a surcharge:

next flow (when the rate changes):

It must 9,75% + 3,15%.

Help me please with it.

structure.png (42.8 kB)
good.png (30.3 kB)

Gustavo Vazquez Aug 16, 2017 at 12:51 PM
1

Hi Artem,

Have you run TI10 or TJ05 ? The first Interest rate ( 13,5 ) is set mannually in the conditions.

Kind Regards

Show 13 Share
Former Member

Hello Gustavo, thx for reply. Yes, i run TJ05, tj05.png but nothing change. Any other ideas?

tj05.png (18.9 kB)

Check cashflow tab

interest-1.png (29.8 kB)
interest-2.png (44.8 kB)
interest-3.png (31.2 kB)
Former Member

I check cash flow tab:

right-rate.png

I dont undestand, why 9.75? Why not add 3.15?

If you change date interest rate, for example set a date 05.04.2017. What will be the flows?

Can you attach screen-shot with detail interest condition. May be i miss something important...

right-rate.png (29.1 kB)
wrong-rate.png (29.0 kB)
wrong-rate2.png (29.1 kB)
Former Member

Hi Artem,

The condition of Interest is 20.10.2016 (day included) with no shift on working day, so first day is 21.XX.XXXX.

Why is the start period of Interest calculation on 27.03.2017 ? . Is there any other conditions for the Interest ?

Kind regards

Former Member

You're right. In the system the calculation of the rate starts from 21.09.2016:

Error percentage rate occurs when reference interest rate change (first time on 27.03.2017).

On 27.03.2017 invalid percentage rate. I need 9.75+3.15=12.9%, but it 9.75..

cf.png (94.6 kB)
Former Member

Try to change it manually with TI11 and see if both interest payments gets updated.

Check if the same scenario happens with a simple transaction (Final repayment, same dates)

If not, open a OSS .

Here is my interest conditions, same as yours

interest-4.png (51.0 kB)
Former Member

Gustavo, thank you!

change it manually and interest payments update, but still doesn`t take 3,15.

On 31.05.2017 first two flows right (9.9045+3.15), but third flow again incorrect, 9.25 instead 9.25+3.15

1.png (64.1 kB)
Former Member

On Date 28.04.2017 you have fixing date 27.03.2017 and rate 9,7545 and but ......

on date 31.05.2017 you have fixing date 27.03.2017 and rate 12,9045 ( 9,7545 + 3,15) .

The same goes for the next month (9,25 + 3,15 = 12,40).

There is something with the due dates and end of periods in the interest conditions (End of Month - Due date on Previous Day). Try to simplify them to detect the error.

Why do you have 3 Nominal Interest positions ? When does capital change ?

How many Interest Conditions do you have ?

The Interest Adjustment works fine, the problem are the conditions in the transaction.

Kind Regards

Former Member

Gustavo, I agree, 3 nominal Interest positions - wrong. I fix it, i have 2 nominal positions now:

first flow:

second flow:

Conditions:

wrong-percente.png (51.4 kB)
ooc.png (30.0 kB)
cd.png (25.3 kB)
firstflow.png (25.1 kB)
secondflow.png (25.1 kB)

Check condition 1210 Dates.

condition-1210.png (50.6 kB)
Former Member

Hello Gustavo!

If I setup "interest rate adjustment" like you "at start of period"

it will wrong, because first new rate must be Eff. from 27/03/2017 (12.80%)

second from 02/05/2017 (12.40%)

third from 19/06/2017 (12.15%).

dates.png (48.8 kB)
Former Member

I could reproduce your situation adding an empty entry in trx OB83

.

int-table.png (20.0 kB)
int-conditions.png (38.5 kB)
Former Member

omg, whats wrong with it! :-(

Gustavo, thank you for trying to help me.

dates.png (87.9 kB)
Jain varghese Aug 23, 2017 at 11:17 AM
0

Hi,

In normal process surge charge or basis point will be same though out the life depend on loan. Please check if you have multiple condition for loan and in case yes, Kindly check the basis point.

Normally we never face this issue until human error.

Regards,

Jain

Share