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
Whenever a company announces employee training session for skills development then it is supposed to…
If you are planning to immediately resign from your job but you can have your…
If you have been invited to serve in an honorary position at any institution and…
Violating the policy of the company will not be accepted by any organization and if…
Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…
If there is retaliation that you have observed in a particular team or department then…
View Comments
Great Job done!!! I have calculated interest as my own through developer suite 10g which shows a difference with your excel sheet unless i rectify formula =sum(f20,f16) at F22 and =sum(e22:e25)at E26.
You could please check for benefits of all who would like to avail the opportunity.
Very Nice and very good some minor mistakes in formula which has been rectified. it may happen while doing some good ideas, I appreciate your initiative to do this job. Keep it up