Skip to Content
0

Amortisation Proc 4000, SAC - Gross Calculation

Jan 25 at 07:10 AM

74

avatar image
Former Member

Dear Expert,

We are implementing Fixed Interest Bonds with Premium and Discount with 04I.

Nominal Value - 10000, with 1000 as Premium, so Total Payment Value = 11000.

Amortisation Proc 4000, SAC - Gross Calculation.

Contract start Date 01.01.2018, End Date 31.12.2018, Int. Cal. Method - ACT/360. 5% Interest.

When I check in Amortisation Log per day 2.88 and when ran on 31.01.2018 getting the value as 86.07.

I want to understand the calculation. Can anybody explain me the calculation with the above example.

Attachment for your help.

capture1.png

capture2.png

capture.png

Regards,

Sarfaraz

capture.png (30.8 kB)
capture1.png (21.8 kB)
capture2.png (26.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member
Jan 29 at 01:33 AM
0

Hi,

check note 864857 for complete explanation on SAC Amortization method.

Regards,

Nikhil

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 30 at 01:39 PM
0

Hello Gustavo Vazquez,

Thank you for the screen shot and the link, still I am not able to achieve the results.

I have achieved the result in Excel with IRR formula and the same is matching with SAP.

Attached is the working of Premium & Discount.

Kindly assist me to achieve the result manually to show it to client.

Regards,

Sarfaraz

discount-irr.png

premium-irr.png


premium-irr.png (30.2 kB)
discount-irr.png (30.7 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi,

With end date 26.12.2018, total days is 356. Check with trx FIMA.

What difference do you get ?

Kind Regards

0
Former Member

Hello Gustavo,

When I check in FWZZ in Condition type, it shows me as 360 days.

Regards,

Sarfaraz

0

The condition could be 360 days, but day calculation is 356

If you don't trust SAP, trus Excel with DAYS360 function :-P

please share your screenshot

Kind Regards

captura.png (10.0 kB)
0
Former Member

Dear Gustavo Vazquez,

My Int Calcultation Method is Act/360.

capture.png

Regards,

Sarfaraz

capture.png (30.8 kB)
0
avatar image
Former Member Jan 29 at 10:15 AM
0

Hello Nikhil,

Thank you for the Note. I did not find the calculation in specific for Premium/ Discount.

Can you please give the calculation (Working) here with the above example I have given.

Regards,

Sarfaraz

Share
10 |10000 characters needed characters left characters exceeded
Gustavo Vazquez Jan 29 at 11:05 AM
0
Share
10 |10000 characters needed characters left characters exceeded