Ppf calculation unmatching in excel

Tax planning 2509 views 1 replies

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: 409 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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register