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

Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

CA Inter

View Details
Company
ARTICLESHIP 23 July 2026
Article

Gianender & Associates

New Delhi

CA Inter

View Details
Company
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

Sahil Agarwal & Company

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
22 July 2026
Senior Chartered Accountant

SKSS

Patna

CA

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Follow