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
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