Categories: HR

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

Hrformats

View Comments

  • There seems to be a mistake in the sheet. Final interest is shown only for four months from Dec. 11 to Mar. 12. We have to add the two interest amounts in the final interest. Further the subscriptions and refund of advances shown in summary also is not including the refund of advances. Otherwise ok in principle.

Recent Posts

Letter to Announce an Employee Training Session for skills improvement

Whenever a company announces employee training session for skills development then it is supposed to…

3 months ago

Example Immediate Resignation Letter for Various Reasons

If you are planning to immediately resign from your job but you can have your…

3 months ago

Sample Letter to Accept to Serve in a Honorary Position

If you have been invited to serve in an honorary position at any institution and…

3 months ago

Warning Letter for Policy Violations Template, Example

Violating the policy of the company will not be accepted by any organization and if…

3 months ago

Sample Warning Letter to Restaurant Manager Example

Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…

3 months ago

Sample Grievance Letter to Supervisor for Retaliation

If there is retaliation that you have observed in a particular team or department then…

3 months ago