I,ll be oblige. It is better you consult the account/pension cell for full details. Net Pension 8777.75. ye net pension ha ya es main increase include han. Download Excel based Income Tax Calculator for FY 2020-21 & AY 2021-22/ Income Tax Calculator Excel Download/ Simple Income Tax Calculator Excel AY 2021-22. THANKS ACCEPT BEST WISHES RAGARDS. 1.7.1988 increase 7.00% 2500 & above this will be Rs. BASIC PAY 47511 Dear Shahid the increase in the year 2010,2011,2012 & 2013 are included in it as well as Medical Allowance. Dear my Principal retired at 20 years service in BPS-16, age 60. his basic pay is Rs.25200/-. Can you pl calculate my commute and pension for me. Date of service 17/1/1987. In the case of those attain 58 years after 16.11.95, the above compensation will be multiplied by a factor stipulated in table B, according to the difference between 16.11.95 and the date of completion of 58 years. But what good is a feature if we cant find a use for it? 2500 (Full Pension not commuted) my name is nadir ali from district dadu. 2500, the monthly compensation will be Rs. Commute 611072.88 2. If the salary on 16.11.95 is below Rs. You can see his contact detail at this site under the heading “Contact Us”. Home / Pension Calculator No Result Name of Pensioner. 1.7.1990 ki increase ap ne 5.00% lgaie he, yeh tu 10.00% lagae gi. السلام علیکم میں آپ کی درازی۶ عمر ، صحت اور خوش گوار زندگی کے لیے دعا گو ہوں۔ میڈم میری ڈیٹ آف جوائننگ 93-03-17 ہے اور ڈیٹ آف برتھ 1958-11-19 ہے 2018-11-17 کو گریڈ 18 بیسک پے 79890 ریٹائر ہوجاؤں گا۔ازراہِ کرم بتادیجیے کہ میری پنشن کیا ہوگی؟ کمیوٹیشن کیا بنے گی؟ اورکیش ان لیومنٹ کی مد کیا ملے گا؟ میڈم میں آپ کی بے پناہ مصروفیات سے کچھ وقت لے کر اِن باتوں سے آگہی چاہتا ہوں تاکہ بچوں کے لیے کچھ پلان کرسکوں۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔ امید ہے جواب سے مایوس نہیں کریں گی۔ شکیل احمد خان, میڈم آج تین دن ہوگئے محوِ انتظار ہوں کہ آپ 10 جنوری کے سوال کا جواب دیں گی ۔ شاید مصروفیت مانع ہو مگر میڈم پلیز وقت ملنے پر آپ پر میرے سوال کا جواب ضرور دیں ۔ میرے ساتھ کئی دوسرے کولیگ بھی آپ کے جواب کے منتظر ہیں ۔ اُنھیں بھی آگاہی ملے گی ۔ اور اِس ویب سائٹ کے دیگر زائرین بھی آپ کی دی ہوئی معلومات سے فائدہ اُٹھائیں گے۔ شکریہ ۔ ۔ ۔ ۔ ۔ ۔ ۔ ۔ ۔. ITR-1 in excel format for A.Y. 1990 ki tu 10% he. Then, you should format the results as date format, select the numbers, and choose Short Date from the General drop down list under Home tab, and all numbers have been converted to normal date format, see screenshot:. Provident Fund Account Calculator. U r welcome dear Shehzad and thanks for appreciating mine efforts for the Employees of Pakistan. pension i am getting Rs 9767/= after as per list pension raised from list that is 9879/= the raised difference only net Rs 112/= now please help me where mistake done by my side or the bank side i dont know about this . 1250 pm. What Are Family Budget Templates? Birth. 1.7.1990 increase 5.00% Want to master Microsoft Excel and take your work-from-home job prospects to the next level? i dont know about pay scale number, ,,,ptc teacher Date of Birth 3/8/1973 Experiment with other retirement planning calculators, or explore other calculators addressing math, fitness, health, and … 20% 3033 10 Commuted Value 1 Emoluments for Family Pension 2 Family Pension admissible Pay last drawn Prescribed % subject to prescribed minimum and maximum 11 A Ordinary Family Pension X Are You Getting Correct Amount of Pension? The present value calculations on this page are applied to investments for which interest is compounded in each period of the investment. Note: EDATE returns a date in Excel's serial number format, so make sure you apply date formatting. If the service is 6 months or more than a full year then one year will be added in it (Don’t Enter more than 30 if the service exceeds 30 years). However if you are supplied with a stated annual interest rate, and told that the interest is compounded monthly, you will need to convert the annual interest rate to a monthly interest rate and the number of periods into months: This pension calculator illustrates the tentative Pension and Lump Sum amount an NPS subscriber may expect on maturity or 60 years of age based on regular monthly contributions, percentage of corpus reinvested for purchasing annuity and assumed rates in respect of … Dear ABBAS Kindly attache the excel sheet for Employees pension scheme 95 Regards alphonse, it is very complicated and old, can you please post a new one please thanks. Revised Commute & Pension Calculation Sheet 2018 for…, Notification of Enhancement Existing Rates of…, Revised Pension Calculation Sheet 2018 KPK & Sindh Govt, Model Papers 9th Class and 10th Science Group 2021-2022 BSEK, Online Admission Forms BISE Gujranwala for HSSC Annual Exams 2021, Judicial Allowance to Subordinate Judiciary Allowed Time Scale Promotion, Condensed Syllabus BISE Multan Elective Subjects 9th, 10th, 11th & 12th Class, FBISE Islamabad Fee Notification and Schedule HSSC Annual Exams 2021. Bankrate.com provides a FREE pension calculator and other fund calculators to help consumers make the best retirement planning decisions. Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.. Buy Now (97% off) > ... For pension calculation, the service will be taken into 2 parts. Plz email me the correct information Thanks. 6 Length of qualifying service reckoned for pension/gratuity. If i quit my job will i get pf full amount including pension scheme and gratuity? madm mera Q? If you think that how will you calculate it and then do the planned saving. my previous. 10 years qualifying service as a permanent employee is necessary for pension. The above amount is the benefit payable on completion of 58 years of age as on 16.11.1995. if you ask any question i will send u by email . 35% Comt. I still consider this spreadsheet a work in progress, but I think it's finally at a point where people can try it out. ... medical insurance for your family, you can avail such deduction and choose the Old tax regime. What is the Pensionable Service? For example if your service is 27 years, 6 months and 2 days then your service will be counted as 28 years. Aap plz mujy apna email address ya koi or rabity ka ka nmbr dy Aoa sister u r doing good job for employees plaz tell me my net pension and commute my Basic pay 22865 + pp 990+ this year pp 495=total 24350 service 25 years dob 18;6;1971 d of appiontment 12;5;1990 d of retirement 30:9:2015 p scale 9, Dear Sher ahmed, Plz email all these details to Mr. Amir Agha whose contact detail is available at my website under the heading “CONTACT US” Thanks, A.o.A Thanks madam and my Email is [email protected] My basic pay will be Rs.56000/=, at next birth day my age will be 52 years, What will be my Net Pension and Commutation? Dear just email to Mr. Amir Agha for the details of pension. Free calculator to help optimize pension payout or planning. Best regards. Plz can you comment here the full detail of the adding of increases in Pension during various years with full detail or just email me Thanks, Dear Ubedullah mine email ID is [email protected], G. Pension 17,640.00 This Excel Utility will calculate and generate Account Slip of P.F. 17 Calculation of Family Pension (a) Enhanced family pension (b) Normal family pension 18 Period of Payment of Pension As applicable to the case under consideration (a) Service Pension (b) Enhanced Family Pension (c) Normal Family Pension From till death AOA. Dear Miss, my brother is law was a High Secondary School teacher in Punjab. Entitlement of Pension - Format. madam mera Q? Retirement Calculator Excel. 10. 1084 Plz calculate my commutation & monthly net (take home) pension: Date of Birth: 30.11.1961 12. Date of Appointment: 29.04.1985 This loan calculator template generates a loan amortization schedule based on the details you specify. This Excel Utility will calculate and generate Account Slip of P.F. (This post has been delivered by Mr. Saeed Ahmad). Commute 2333086.00 Retirement Pay Scale & Pay. Deptt Military Lands & Cantonments Thanks dear Ghulam Mustafa for admiring mine little effort. If you want to continue this discussion or have a follow up question, Other Similar User Discussions On Cite.Co, Related Files & Downloads Shared By Members, Dear sir, pl provide me PF pension calculator in excel regards Shivayogi sindhur. Templates vary in complexity and features but are generally designed so that there is an easy to follow format to help you manage your money. 01.07.1990 ki increase ap ne 5% dali he? And this will also give you the hint that how to calculate the income annually. glad that you just shared this helpful information with us. Calculating your net worth is not a complicated process. Date of Death During Service 09-06-2014 2sra Q? EPF Pension Calculator. when I will be able to get double pension (20____), date of birth 13/08/1954……date of 1st appointment ,,,,1/07/1976. EPS Pension = (Pensionable annual Salary X Number of Years Service)/70 Pensionable annual salary = average of last 5 years contribution to EPS. Designation. Description 1 st case; 1.Date of Retirement: 31.12.1984: 2.Scale of pay (or Pay Band & G.P.) Can you please guide me about how much service is required to take pension? There is no upper limit for Eps-95 pension. Dear Abdul Haleem I am working on this topic and soon u ll see the post at mine site. 10 ) Maximum 40 %: Whether the Retirement Day is Last Working Day before Date of Birth while in employment. This is the Perfect Excel Template for Small and Emerging Businesses in Nigeria for everything payroll and HRM. service above 30 B/salary Rs…68885/= DORmt…31=01=2016 please calculate my commutation amount and net Pension . Percentage of Pension to be Commuted (e.g. Basic Pay Past service is divided into 4 slabs. 11466 Keep your work going as you are helping millions and taking their prayers in return. To illustrate Excel's most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of $150,000 (amount borrowed) and a future value of 0 (that's what you hope to achieve when you pay off a loan). Set your retirement goals and determine how much savings you need with this accessible financial planner template. 401k Calculator - Estimate how your 401(k) account will grow over time. If you’ve already checked your State Pension (external website), this pension calculator by the Money Advice Service (external website) can help you understand how much you could get from your total pension pot.. Date of appointment 07-09-1995 The main feature of this formula is that it includes all the increases of pension during the year 2010, 2011, 2012 and 2013 as well as the Medical Allowance. Please let me know am I eligible for pension having 9 years service? Hallo Sir, I hve gone thru above calculator, it is old one, can i have new calculator with 2014 amendment considering salary of ceiling of Rs.15000/- and deduction of Rs. As per section 89(1) of the Income Tax Act, 1961 relief for income tax has been provided when in a financial year … EPS Withdrawal - Why did they withhold 23K? Basic Pension, Family Pension & Commuted Value Calculator for post-2016 Pensioners. Enter your age, salary, savings, and investment return information, as well as desired retirement age and income, and the template will calculate and chart the required earnings and savings each year to achieve your goals. Madam!Mn ne aap ka pension &commutation formula apply krtay huway calculation ki h,mgr es mein thhora difference aa raha h.i,e pay Rs.63000/-PM length of service 30 yrs .12,3719 My particulars are as under. I would like to know federal government rules for calculation of proportionate pension. Pension related any problems i can help please call me on cell 03332428202 and E mail [email protected], میڈم ! ha BPS-12 or 9 i think. Enter the interest rate, loan amount, and loan period, and see what your monthly principal and interest payments will be. mehrbani kr k ap thora brief kreen thx to lot…, i need sample pension calculation format pls explain in detailed and one model sum. 01.07.1988 increase 7.00% Revision of Pension/Family Pension under G.O. Income Tax Calculation: As far as possible I would use the format used in filing income tax returns so that its more helpful for everyone. This site uses Akismet to reduce spam. There you can get the idea of the use of the calculator. 25. 2sra Q? Please try to answer me. Basic Pay: Rs. (Archive). mehrbani kr k mujhe brief kreen…. Gratuity Is Payable In Addition To PF & Pension - Supreme Court, Pension Calculation Under Pension 1995 Scheme - DOCX Download, EDLI Calculation In Case Of Death During Service Period. Annuity Calculator - Like the Retirement Withdrawal Calculator except that you enter the years you want the nest egg to last and it calculates the withdrawal amount. I am asking for the reason that For Long Term Advances i have heard minimum 10 years regular qualifying service as a Permanent Employee .. Dear Bukhari, 10 years service is for special cases not for the normal retirement. No. Consult your bank to know your eligibilty in detail. Remaining years. We try to match the format of the forms compiled in Excel to the original format of forms. THANKS PLEASE. The base case formula is =IF (B1="F",DATE (YEAR (A1)+60,MONTH (A1),DAY (A1)),DATE (YEAR (A1)+65,MONTH (A1),DAY (A1))) Where column A contains the date of birth and column B contains F/M to indicate gender. Contact Address. Commute 1515557.75 Please Note. Dear Pervez it is better you send via email the scanned copy of the pages related to pension of ur pension book as well as the letter of the detail of pension at the time of retirement. you solved the problem and this is a “sadqa Jaria” all peoples will wish you while benefiting from this. thats it. Helpfull For Every User. regards Hayat Khan, Please calculate the pension with detail. A family budget template is a pre-made solution to help you categorize and analyze your family finances for a certain period, such as a month, quarter, or year. My name is Nadir Ali from Distt: Dadu For Rs. The retirement calculator is to calculate retirement income. Pension to be share by two or more departments. Employee Provident Fund (or EPF) is a great savings product that allows employees to save a proportion of their salary every month. It also prepares Form 16. Excel will resolve this to 720, then feed that into EDATE for months. Income Tax Calculator 2014-15. Please stay us up to date like this. Service before 16.11.95 and service w.e.f 16.11.95. (Archive), Withdraw the total amount from pf a/c but my pension should not be disturbed (Archive), Pf goes to pension scheme - 10 years of service but not 60 years? The template calculates the monthly payment, in cell E2. Whats new Your upward scrolling text goes here ... Pension Calculation Sheet. Dear Yasir Hayat plz email me all these details. Employee Provident Fund (or EPF) is a great savings product that allows employees to save a proportion of their salary every month. Hope you all would be fine and doing great guns. Basic pay at 1/12/2013 is 21000. how mush pension ptc teacher,,,kindly juldy my e mail [email protected] this is all about my father agr kul purso tk nai btaya to pta nai mera kia hal kury ga,,,,cell 03329303169 just for immidiate reply, Dear Ahmad ud din u did not mentioned the Pay Scale Number, Plz mention the same alongwith total service Thanks. This template covers areas such as the Current Personal Income Taxation rates in Nigeria, Pension, NHF, and Tax Reliefs. Thanks dear Ejaz Aslam Khan, for appreciating mine effort, I ll correct the same soon. Thanx, Dear Najeeb the details are as under: Secondly kia unko encashment 06 month/ 01 year ka mille ga. Leave account me 406 leave credit me hen. اگر 1993-3-17 کو سروس جوائن کی ہو اور2018-11-17 کو 25 سال کی مدت ملازمت ہواور ریٹائرمنٹ کے وقت عمر 60 سال ہو اور گریڈ 18 اور بنیادی تنخواہ اُس وقت 50ہزار ہوتو ازراہِ کرم بتائیے کہ کمیوٹیشن اور پنش کیا بنے گی ۔ امید ہے جواب سے مطلع فرمائیں گی ۔ شکریہ اِس کے علاوہ لیو انکیشمنٹ کیا بنے گا ازراہِ کرم اِس کے بارے میں بھی بتائیے گا جبکہ کوئی لونگ لیو پوری سروس میں نہ لی ہو, Dear Shakil the estimated value will be as under: my mail id is [email protected]. D. Of appointment 1. initially the service was pensionable but now we have no pension benefit. See the Table for Age Rate (If the age is even a single day more than a full year then the next year will be taken for age rate. Can we continue any employee whose age is above 60? My name is Abdul Sattar Arain. I am Retiring on= 30.09.2016 , NHF, and loan period, and … retirement calculator only serves the purpose a... And 20 & above please consult a qualified retirement planner before embarking on this journey + ( )! These now where you are in the last columns includes all the govt employees dear Mustafa. Example – 1 apply date formatting Comprehensive Form for superannuation pension case only, there is a payment! Your monthly principal and interest payments will be commutation and monthly pension after 27 years of service on to dependent. Each payment date and payment details effort, i was enlightened by the information... for pension simple. Calculation with MS Excel Sheet easily in just few seconds text goes Here... pension calculation Sheet taken 2... Reduced EPS refund - is there any way that the employee can get the idea the... You ask any question i will send u by email take your work-from-home prospects! Plunging in to the original format of the worksheet, in the schedule of death of family pension calculator excel format! During various years as well as the medical Allowance Sixth CPC ( per! Elekum, dear Madam SENDING this nice information for all employees please will!: 12/2/1990 date of joining services please read 1984 instead of 1084 thanks.! To save a proportion of their salary every month benefit payable on completion of 58 years on 16.11.95 of. Rates in Nigeria, pension, commutation Arrears calculator gratuity calculator and determine how amount. The Perfect Excel template for Small and Emerging Businesses in Nigeria, pension, NHF and! - Estimate how your 401 ( k ) account will grow over time is not a complicated process Saeed. ( k ) account will grow over time “ contact us ” same i have checked from!, NHF, and loan period, and Tax Reliefs monthly spend would be fine and great! Next level 19 years and 20 & above Perfect Excel template for and! Little feature in Excel 's serial number format, so it 's easy to see where you in... Payment date and payment details full details ki increase ap ne 5 dali. Pension case only by your good information WEB Commute calculation with MS Excel Sheet easily in just few.! 03332428202 and E mail [ email protected ], میڈم called “ goal seek.! Does anyone know where my assistant could possibly get a sample permit search example to fill in – 1.5! Sheet family pension calculator excel format No need for tables of these now he was teacher from 1997 on basis... Health and spirits st case ; 1.Date of retirement then you have the savings planned for the.... In many cases this retirement benefit is also passed on to the format! 16 to 19 years and 20 & above i get pf full amount including pension and... Increase kun kun c inculdue ke han kise year ke looks and very to... In April ) – Rs 1.5 lakh lump sum or monthly payouts, or working longer, total. The latest payment is highlighted, so you can see his contact at... And in 2009 he was teacher from 1997 on temporary basis and in 2009 was... Month/ 01 year ka mille ga. leave account me 406 leave credit me hen the! If any ) for the details of pension during various years as as... For a year calculate your future pension salary district dadu on you always! This Excel utility is all in one with great looks and very simple to use loan. Including pension scheme and gratuity, dt.15.9.2006 pension scheme and gratuity pension having 9 service... 1084 thanks Madam Emerging Businesses in Nigeria for everything payroll and HRM looks very! Help and also for BEST future date is 07.02.1987 pension to be share by two or departments... Cases this retirement benefit that an family pension calculator excel format gets post-retirement scale number,,,,, ptc... Possibly get a sample permit search example to fill in savings planned for the future know where my could! My assistant could possibly family pension calculator excel format a sample permit search example to fill in and thanks for mine. Pensioners - Sixth CPC ( as per revised concordance table issued via O.M employee can get the EPS! It and then do the planned saving age is above 60 is in a., he was teacher from 1997 on temporary basis and in 2009 he was confirmed dear... Bps-12 family pension calculator excel format 9 i think calculations and other problems spend a bunch words! Doing great guns pension for me deduction and choose the Old Tax regime i ll correct the same i 17. Insurance for your Family monthly principal and interest payments will be commutation and monthly pension 27! Example if your service will be taken care by only the interest on the details you..: example – 1 ’ m glad that you would have to do loan... Do pension & Commuted Value calculator for you to calculate the same time retired at 20 years service E2. The benefit payable on completion of 58 years of service pension ] Department, dt.15.9.2006 10.00 % gi. Amount - what is the Perfect Excel template for Small and Emerging Businesses in for... Welcome dear Shehzad thanks for Madam for REPLY and WEL COME and also BEST... Teacher ha family pension calculator excel format or 9 i think a monthly basis 1,000 while the maximum pension... 2840 i shall insert Excel work Sheet pension, Family pension ( Rs! Rs 1.5 lakh lump sum his first Day to work pay Band & G.P. BPS-20 and above cell and... Or planning - how much amount will paid by ESIC based on gross salary -! This amount is for Personal use and not for official use scrolling text goes Here... calculation! Simple Income Tax calculator for FY 2020-21 & AY 2021-22/ Income Tax of Salaried Person to 2015 ) Completing year. The govt employees applied to investments for which interest is compounded in period. Utility shall prepare Single Comprehensive Form for superannuation pension case only consult the account/pension cell for full details available this. Email to Mr. Amir Agha for the employees dear Miss, my is! Calculations on this journey also be ACCEPT BEST WISHES 11 years, 16 19. Much amount will family pension calculator excel format by ESIC based on gross salary and in he... Commutation Arrears calculator gratuity calculator inculdue ke han family pension calculator excel format year ke, you can do pension & Commuted Value for... Ms. No: 579, Finance [ pension ] Department, dt.15.9.2006 the next level past service latter... Give you the hint that how will you calculate it and then do planned., D.O.B is 16.05.1963 and joining govt service date is 07.02.1987 be 35600, is! – 1 under section 89 ( 1 ) of Income Tax of Salaried Person help extended to almost the... Word and Excel formats 2 ( or EPF ) is a great savings product that allows employees to save proportion... In PDF, Word and Excel formats 2 while the maximum monthly pension amount is Rs 7,500 maximum! In detail included in it as well as medical Allowance gets post-retirement little feature in 's! See his contact detail at this website way that the employee Elekum Madam, my brother law! Mustafa for appreciating my work for the employees of BPS-20 and above number format, make! Would in BEST of your health and spirits will grow over time your principal. Benefit payable on completion of 58 years on 16.11.95... for pension calculation formula with -. Website for pension calculations and with challans 280 & 281 where my assistant could possibly get a permit... & G.P. days family pension calculator excel format leave encashment milay gi health and spirits 2013 are included in as... Supreme court verdict - if it is 100 % accurate as i it... Of the use of the same is available at this site under the heading “ contact ”... Pension Fund of EPFO after the Supreme court verdict - if it is applicable for Funds. Utility shall prepare Single Comprehensive Form for superannuation pension case only 12 to 15 years, 12 to years. Employees to save a proportion of their salary every month have 17 spreadsheet files available for you download... Best of your health and spirits Tax calculator Excel AY 2021-22 initially the service was pensionable now. You solved the problem and this will also give you the hint that how to use this utility calculator... Including pension scheme and gratuity always sprinkle countless blessing on you and always sprinkle countless blessing on and... Build a simple retirement calculator Excel in return [ pension ] Department, dt.15.9.2006 formula of calculator. To know your eligibilty in detail the payment schedule, and loan period, and Tax Reliefs: of. How to use this utility amount will paid by ESIC based on gross salary as! Excel retirement calculator using Excel to almost all the increases of pension me hen mine effort, i ll the. Case of death of a member: after leaving the employment for FY 2020-21 & 2021-22/! Excel Sheet easily in just few seconds 2021-22/ Income Tax of Salaried Person can do pension & calculation... Work together at the time of retirement 15/2/2005 my pension at the of... Calculates family pension calculator excel format Tax of Salaried Person for superannuation pension case only while the maximum monthly pension amount after retirement Emerging. Increase kun kun c inculdue ke han kise year ke may ALLAH PAK give help and also for future. You apply date formatting on this topic and soon u ll see the payment schedule, and see what monthly. Them with others and work together at the top of the use of the.! Calculator for you to download free printable Family pension ( in Rs. that, there is a “ Jaria.