0

Amortisation Proc 4000, SAC - Gross Calculation

Jan 25 at 07:10 AM

74

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.

capture1.png

capture2.png

capture.png

Regards,

Sarfaraz

capture.png (30.8 kB)
capture1.png (21.8 kB)
capture2.png (26.2 kB)

Former Member
Jan 29 at 01:33 AM
0

Hi,

check note 864857 for complete explanation on SAC Amortization method.

Regards,

Nikhil

Share
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

discount-irr.png (30.7 kB)
Show 4 Share

Hi,

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

What difference do you get ?

Kind Regards

Former Member

Hello Gustavo,

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

Regards,

Sarfaraz

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

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

Kind Regards

captura.png (10.0 kB)
Former Member

Dear Gustavo Vazquez,

My Int Calcultation Method is Act/360.

capture.png

Regards,

Sarfaraz

capture.png (30.8 kB)
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
Gustavo Vazquez Jan 29 at 11:05 AM
0

analysis-02.png (51.9 kB)
analysis-03.png (41.5 kB)
analysis-04.png (41.7 kB)
analysis-00.png (28.9 kB)
analysis-01.png (31.4 kB)
Share