Ppf calculation unmatching in excel

Tax planning 2611 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: 459 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  

Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details