cancel
Showing results for 
Search instead for 
Did you mean: 
MilanH
New member
2 1 0 0
Message 1 of 3
1,844
Flag Post

Solved!

How to calculate EMI with a grace period?

HP Recommended
HP12C Platinum

I am trying to calculate the equated loan instalment for a loan with a grace period.  This can be done easily using MS Excel however I need to do the calculation using my HP12CP.  

Details of the loan:

Principal  : 1 million

Int. Rate  : 12% p.a

Tenor       : 36 months

Grace period : 3 months

Payment frequency : monthly

Loan instalment calculated with Excel : 1st three months - zero; 4th to 36th month: 36,810/- per month

0 Kudos
2 REPLIES 2
calcpeace
Level 4
54 54 7 7
Message 2 of 3
Flag Post
HP Recommended

Hello MilanH

 

May be this helps, if you work it out in two steps:

 

1)

 

n=3 grace period

ir/a=12%

pv=1 million

fmt=0.00

 

fv= -1030301.00 (- because you have to pay it back)

 

2)

 

n=33

ir/a = 12%

pv = 1030301.00

vf = 0.00

 

fmt = -36810.01 (- because you have to pay it )

 

I have no 12C, but if that kind of loan isn't built in, you can manage it this way.

 

 

MilanH
Author
New member
2 1 0 0
Message 3 of 3
Flag Post
HP Recommended

Thank you. Appreciate your input!

Now I will use this way to calculate different scenarios like a grace period in the middle of the tenor, end of tenor etc.

0 Kudos
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation