0

# Interest calculation issue in SAP Treasury

Jun 22, 2017 at 09:45 PM

106

Former Member

Hi Experts,

We would like to adjust interest earned amount first at the time of repayment of loan.

Let say, Company-A give a 2 Million loan to Company-B on 01 Jan. Company-B paid 2 Million back to Company- A on 20th Jan. Assume interest is 20000/- for first 20 days. Company-A adjust 20000/- as a interest from the repayment and they treat that Company-B paid principal amount 1980000 (2,000,000-20,000). The outstanding principal amount is 20000 as on 20th Jun.

when user enter 2 Million repayment, system should adjust 20000 to interest and 1980000 to principal amount automatically. (Note- Company never calculate interest on interest)

Can we achieve this scenario in SAP?

Pls suggest

Thanks

Former Member Jun 26, 2017 at 02:46 PM
0

Thanks Grigoriy !

I have tried Prod. type 53A. There are couple of limitations- A) Variable interest rates option is not available (B) If I enter interest rate is "Price" is updating automatically. (C) There is no option to enter the ongoing additional investments and repayments.

We are using interest rate instruments (Prod. Category - 550 ) for inter-company loans implementation.

Detailed Scenario-

1. Company-A Paid \$2Million to Company-B on 27 Feb 2017

2. Interest rate for Feb is 2.28% and the interest is 126.67 for 1 day

3. Company-A received payment \$2 Million from Company-B on 03 Mar 2017, which includes Interest \$ 508.33 and principal amount \$1,999,491.67. The outstanding principal amount is \$508.33

4. Company-A received total principal amount and interest together \$508.66 on 13 Mar 2017 from Company-B, which includes principal amount \$508.33 and interest \$0.32.

We would like to build this scenario.

Thanks

ic-interest.jpg (172.5 kB)
Share
Grigoriy Babitskiy Jun 26, 2017 at 07:19 AM
0

Check product type 53A

53a1.jpg (151.9 kB)
53a2.jpg (112.5 kB)
Share
Former Member
Jun 27, 2017 at 12:05 AM
0

HI,

You may also want to look at Bond product type which has a repayment type - Perpetual Bonds. Perpetual bonds can be created with no condition type of repayment. So there is no end date. You can enter a Sell transaction through FTR_CREATE to repay / close the loan.

Regards,

Nikhil

Share