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: 471 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
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
28 August 2026
Audit Manager

K A R M & CO

Mumbai

CMA

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details