POSB Interest Calculator in Excel Format- updated - 01/04/2014

(Last updated - 01/04/2014)


Click Here to Download


Features in this File:
        Updated on 01/04/2014:
  • New Interest rates w.e.f. 01/04/2014 configured for RD, TD schemes. Old interest rates can also be calculated by entering the concerned Date of opening 
  • RD PMC Calculator link is added in the Main page of Calculator.
  • Option for calculation of "Maturity Amount for Discontinued/Extended RD accounts" is provided in RD-View more Link.
  • "Print Tables/Forms" link is provided in Main calculator page to Print Ready reckoner tables for RD/TD/MIS and Pamphlet, Forms. (Ready reckoners and tables have been updated for new interest rates w.e.f 01.04.2014)
  • Changes have been made for PMC of TD accounts before 1 year.


      Updated on 12/05/2013: (As per suggestion/request received from users)
  • In SCSS "View more" link, Initial partial interest and Final partial interest payable (for fraction of days) according to the date of opening will be displayed in addition to the quarterly interest payable for SCSS deposit. For SCSS PMC also, final partial interest applicable will be displayed. 
  • Possibility of extension of SCSS account will be displayed along with the interest rate applicable for such accounts. 
  • To calculate maturity amount of Discontinued/Extended RD accounts, option has been included In RD "View more" link, and the the same will be displayed if 5 years completed. 
  • Navigation link to "Home page" has been uniformly placed in all pages at bottom.
    
     Updated on 28/04/2013:
  • "MIS Total Interest" shown in the table for Today's date (i.e.,Date of Opening is not entered and left as blank cell) has been corrected for 60 months instead of wrongly calculated 72 months in old calculator. 
  • (But, If you enter Date of opening in MIS, it will correctly calculate "Total Interest" for 60(or)72 months according to the entered Date of opening, even in old calculator)
  • "PPF Loan/Withdrawal" calculation link and "MIS to RD Automatic credit Maturity" calculation link have been included in main table; 
  • Welcome message will be displayed at the bottom of calculator (according to the time of opening calculator file)
Updated on 15/04/2013:
  • In the Link "PPF Interest Calculation", Provision has been added to find out Eligible Loan and Withdrawal amount that can be taken in PPF account.
  • In the Link "Print Tables/Forms", Claim Forms for SB/SC and Application for Reinvestment of Maturity value, and Interest Rate Table (in Tamil) and link to access "Indiapost Forms page" are included.
Updated on 01/04/2013:
  • New Interest rates w.e.f. 01/04/2013 configured for all schemes. 
  • Old interest rates can also be calculated by entering the concerned Date of opening 
  • RD PMC Calculator can be downloaded from RD "View More" link
  • "Print Tables/Forms" link is provided in Main calculator page to Print Ready reckoner tables for RD/TD/MIS and Pamphlet, Forms.
Updated on 06.11.2012:
  • Validation for KVP Date of Purchase (Now Date can be entered only from 01.03.2003 to 30.11.2011)
  • Feedback form modified.
Updated on 31.10.2012
  • Option for Entering Date of Opening of Accounts
  • Their Respective Maturity/Interest Amounts, A/c periods, Date of maturity,etc.,
  • Current status of A/c for Closure/PMC/extn., etc.,
  • Reduced Int. for TD, Bonus, Deductions, PMI details,etc.,
  • KVP discharge value calc,
  • SB,PPF,PMI calc,
  • PPF approx maturity value calc,
  • Easy Initialisation of Interest rates for schemes, if changed...
  • Option to download the latest excel calculator (if any), right from this excel file itself...  
 Source : https://sites.google.com/site/posbinterestcalculator/
Prepared by :
M. Dhamotharan, CDL,
email : dhamotharan@outlook.com

Comments

  1. Unknown24 March 2015 at 01:30

    This is very helpful to me thanks for sharing.. looking forward for more masterpieces in the near future.
    interest calculator

    ReplyDelete

Post a Comment

Popular posts from this blog

Download Data Entry Software for Postal/Sorting Assistant (PA/SA) Exam- Phase 2

Image
As promised in our earlier post, in this post we are providing you the Data Entry Software (Offline) to Practice Data Entry for Postal/Sorting Assistant Exam. Almost all are conversant with what the typing test is as a lot of online and offline software’s are available in the internet. But when it comes to Data Entry options are limited. Here we are providing you one of the best Data Entry Software that will be handy for PA/SA Phase 2 exam preparation. Features of Software: 1) 3 types of data entry tests are included: alpha, numeric, alphanumeric. 2) Gross and net keystrokes per hour as well as accuracy are measured and saved in a results database for printing or viewing. 3) User decides width of numeric field and decimal display or suppress fornumeric tests. 4) Alphanumeric test is in the form of a typical invoice. 5) With the click of a button, new data entry tests can be created by the program. 5) You decide the duration of the tests; up to 30 minu
CLICK HERE FOR MORE

Letter to CPMG on latest issues of SBCO

ALL INDIA SAVINGS BANK CONTROL EMPLOYEES UNION KERALA CIRCLE (Recognized Union of Department of Posts) CHQ: Nirmalyam, Erezha North, Chettikulangara, Mavelikara 690106 The Chief Postmaster General, Kerala Circle, Trivandrum 695 033 L No. AISBCEU/Circle/2017-18                                      dated at Mavelikara the   19 th June 2017 Respected Sir,         May I invite your kind attention to some major issues relating to SBCO requiring immediate remedial action. 1)             On migration to Core banking solution, vide SB order No. 14/2015 and its addendums issued by the Directorate, work of SBCO has been drastically changed.  The work erstwhile done at HO SB branch was discontinued and entrusted to SBCO with a consolation of direction to provide the staff of SB branch to SBCO. This instruction has not been complied by the Postmasters & Divisional Heads at many HOs.  In a very few HOs, on the strict order of their Divisional Heads, Postmasters
CLICK HERE FOR MORE

PRESERVATION PERIOD FOR POSTAL RECORDS ( SBCO BRANCH ) Updated

PRESERVATION PERIOD FOR POSTAL RECORDS ( SBCO BRANCH) SL NO            DETAILS OF OLD RECORDS Period of preservation  1 List of Transactions 2 Years (After Agreement ) 2 All categories of vouchers ( Dep / Wdl ) 5 Years All categories of vouchers - Closures  5 Years As per SB order no. 14/2012 & 08/2013 3  Consolidation journals  ( Local/Credit/Debit  ) 2 Years 4 Consolidation journals SB/RD / MIS/ TD  Dep & Wdl 2 Years 5 Register of SB62, 62a, SB63, RD85, 85a, of all  categories 3 Years 6 Register of OMs 2 Years ( after closure of all OMs in the register ) 7 Interest Statement  summary 3 Years 8 Miscellaneous  Registers a) Discrepancy Register b) Binder verification Regis
CLICK HERE FOR MORE