Skip to Content
0

Interest calculation issue in SAP Treasury

Jun 22, 2017 at 09:45 PM

102

avatar image
A R

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

A R Jun 26, 2017 at 02:46 PM
0

Thanks Grigoriy !

I was waiting for your response. Appreciate your response.

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
10 |10000 characters needed characters left characters exceeded
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
10 |10000 characters needed characters left characters exceeded
Nikhil Adke
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
10 |10000 characters needed characters left characters exceeded