Ppf calculation unmatching in excel

Hello Friends,

can anyone help me in getting exact interest calcualtion of PPF that match with the bank and my mainained excel sheet.  For E.g. 

Opening Balance ( 01.04.2011 )                                                  = 26406/-

Addition during the year ( 05.05.2011 )                                        = 12000/-

Available Balance for Interest Calculation                                   = 38406/-

Interest Recd. from Bank On PPF Balance                                 =   1968/-

But As per my xls. Sheet Interest Comes to PPF Balance       =   3184/-

Pls. Correct me or my xls. sheet if found to be wrong.

Pls. find the attachement.

 

Regards

Sanjay

 


Attached File : 31653 972377 ppf.xls downloaded: 468 times
Replies (1)

1968 is interest rate upto 1/12/2011. I think interest from 1/12/2011 isn't calculated. As per me interest upto 31/3/2012 shd be 3069. 26406 26406 0.666666667(1*8/12) 176.04 38406 4.666666667(7*8/12) 1792.28 38406 2.866666667(4*8.6/12) 1100.972 Total 3069.292

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register