Gpf Interest Calculator

 I have Attached Gpf Interest Calculator

Name C MURUGAN GPF A/C No 786
Department CM
Closing Balance as at 31 March
Year 2011-12 Rate of Interest 8% upto Nov 11 & 8.6% from Dec 11 onwards 10000
Month Subscription Refund Advance/ Withdrawal Balance
April 3000 1000 14000
May 3000 1000 18000
June 3000 1000 22000
July 3000 1000 26000
August 3000 1000 30000
September 3000 1000 34000
October 3000 1000 15000 23000
November 3000 1000 27000 1293
December 3000 1000 31000 Interest @ enhanced rate of 8.6%
January 3000 1000 35000
February 3000 1000 39000
March 3000 1000 43000 1061
TOTAL 36000 12000 15000 342000
INTEREST 1061 1061
OPENING BALANCE AS ON 01 APRIL 10000
ADD:  SUBSCRIPTION & REPAYMENTS MADE DURING THE YEAR 36000
LESS:  ADVANCES & WITHDRAWALS MADE DURING THE YEAR -15000
CLOSING BALANCE AS ON 31 MARCH 47061

 

Click Here To Download Gpf Interest Calculator