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. MA 20% 2637 How to calculate age rate and Communte Factor? Basic Pay 25,200/- 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. Excel will resolve this to 720, then feed that into EDATE for months. Date of Joining : 12/2/1990 What Are Family Budget Templates? Revision of Pension/Family Pension under G.O. This Excel Utility will calculate and generate Account Slip of P.F. Pension related any problems i can help please call me on cell 03332428202 and E mail [email protected], میڈم ! The formula for pension calculation remains the same, provided that you have to enter the "Salary on Separation from Service" which is the average of last drawn 60 months. i dont know about pay scale number, ,,,ptc teacher Can you pl calculate my commute and pension for me. 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.. 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). Your earlier response will highly be appreciated. How to Use the Loan Payment Schedule: How to enter loan information, see the payment schedule, and … 1.7.1988 increase 7.00% 0333-7588416, Thanks Dear Ubedullah for such nice info. This loan calculator template generates a loan amortization schedule based on the details you specify. Commute 2333086.00 Dear Mahboob, thanks for appreciating mine efforts for the employees. 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. 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. Pension to be share by two or more departments. The template calculates the monthly payment, in cell E2. am really surprised looking your website for pension calculations and other problems. He died during his job on 20.08.2013, he was teacher from 1997 on temporary basis and in 2009 he was confirmed. ... For pension calculation, the service will be taken into 2 parts. If you think that how will you calculate it and then do the planned saving. Enter Date of Birth, Date of Join, Date of Seperation from Service, Salary on 16.11.95, Salary on Seperation from Service ( in compliance with the contribution to pension fund) and break in service before and after 16.11.95, if any in green colour column. 2008-09 ITR-4 in excel format for A.Y. Click on Calculate Button below. In many cases this retirement benefit is also passed on to the dependent family members, after death of the employee. Some programs like Quicken tell you your net worth, but that is only accurate if you include all your accounts, every asset, and every loan within the software. Secondly kia unko encashment 06 month/ 01 year ka mille ga. Leave account me 406 leave credit me hen. There are 3 main sections on this page: 1. When you plan of retirement then you have the savings planned for the future. Dear please calculate my pension and commutation. Thanks dear Ejaz Aslam Khan, for appreciating mine effort, I ll correct the same soon. This Excel Utility will calculate and generate Account Slip of P.F. My Birth day is= 01.01.1965 We first calculate the total income for the financial year (FY 2019-20) Income from Salary (April to July 2019) – Rs 4,00,000; Income from Pension (August’19 to March’20) – Rs 1,49,600 (Rs 18,700 * 8) Save spreadsheets in OneDrive. 29.08.2014. The formula used to get remaining years in column E is: Please try to answer me. Enter the Ardali Allowance (if any) for the employees of BPS-20 and above. 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. my mail id is [email protected]. 85, 105, 135 & 170. Commuted Value of Pension Calculation. Click on Calculate Button below. Plz tell me….. 25 years 06 months service will be counted as 26 years or 25 years for the purpose of calculation of pension. Dear madam! Net Pension 16436.66. Employee Provident Fund (or EPF) is a great savings product that allows employees to save a proportion of their salary every month. This amount is for those who attain 58 years on 16.11.95. Now you can do Pension & Commute Calculation with MS Excel Sheet easily in just few seconds. Dear Yasir Hayat plz email me all these details. There you can get the idea of the use of the calculator. 01.07.1987 increase 4.00% Date of Birth 29-05-1957 Keep your work going as you are helping millions and taking their prayers in return. We thank you once again. 401k Calculator - Estimate how your 401(k) account will grow over time. Thanks for sharing. Pension received by the family members of Armed Forces is also exempted from taxes. Calculation of Pension Please do not press Enter. Medical Allowance admissible on Net Pension plus increase of 01.07.2010, after that it remain same ….. and Medical Allowance for BPS-16 and above is 20%, Ubedullah 15% 1720 Basic Pension, Family Pension & Commuted Value Calculator for post-2016 Pensioners. my date of superannuation retirement i.e. What is the procedure to calculate my pension? Basic pay scale 9 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. Net Pension 40765.54, قابلِ صداحترام محترمہ شمائلہ کمال صاحبہ السلام علیکم : جواب کے لیے تہہ دل سے شکرگزار ہوں ۔ میڈم پلیز لیو ان کیش منٹ کی رقم سے بھی مطلع فرمادیجیے کہ وہ کتنی بنتی ہے ۔اور کیا ایک سال کی تنخواہ مع تمام الاؤنسز ملتی ہے یا صرف بیسک ؟ اللہ تعالیٰ آپ کی خدمات کو شرفِ قبول فرمائے ، بلاشبہ آپ سرکاری ملازمین کی آگہی کے لیے گراں قدر خدمات انجام دے رہی ہیں ۔ اللہ تعالیٰ آپ کو خوش رکھے۔. Does anyone know where my assistant could possibly get a sample permit search example to fill in ? Loan calculator with extra payments. AND REQUESTED FOR ESTABLISHED THE FOURM FOR HELPING THE NON GIVEING THE PAYMENTS AS PER THE ISSUED NOTIFICATION FOR INCREASES ALL KIND TO THE POOR AND HELP LESS EMPLOYEES . MAY ALLAH PAK GIVE HELP AND ALSO FOR BEST FUTURE . Thanks dear Ghulam Mustafa for admiring mine little effort. Annual Investment (in April) – Rs 1.5 lakh lump sum. I still consider this spreadsheet a work in progress, but I think it's finally at a point where people can try it out. Get Embeded. The first one is called as past service and latter one as pensionable service. How to calculate the interest of General provident fund for a year? 01.07.1988 increase 7.00% just to let you know that i have 17 spreadsheet files available for you to download free to your computer! Dear yeh net pension hay jis main sub increases ko add kar kay as well as medical allownace shamil kia gia hay. السلام علیکم میں آپ کی درازی۶ عمر ، صحت اور خوش گوار زندگی کے لیے دعا گو ہوں۔ میڈم میری ڈیٹ آف جوائننگ 93-03-17 ہے اور ڈیٹ آف برتھ 1958-11-19 ہے 2018-11-17 کو گریڈ 18 بیسک پے 79890 ریٹائر ہوجاؤں گا۔ازراہِ کرم بتادیجیے کہ میری پنشن کیا ہوگی؟ کمیوٹیشن کیا بنے گی؟ اورکیش ان لیومنٹ کی مد کیا ملے گا؟ میڈم میں آپ کی بے پناہ مصروفیات سے کچھ وقت لے کر اِن باتوں سے آگہی چاہتا ہوں تاکہ بچوں کے لیے کچھ پلان کرسکوں۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔۔ امید ہے جواب سے مایوس نہیں کریں گی۔ شکیل احمد خان, میڈم آج تین دن ہوگئے محوِ انتظار ہوں کہ آپ 10 جنوری کے سوال کا جواب دیں گی ۔ شاید مصروفیت مانع ہو مگر میڈم پلیز وقت ملنے پر آپ پر میرے سوال کا جواب ضرور دیں ۔ میرے ساتھ کئی دوسرے کولیگ بھی آپ کے جواب کے منتظر ہیں ۔ اُنھیں بھی آگاہی ملے گی ۔ اور اِس ویب سائٹ کے دیگر زائرین بھی آپ کی دی ہوئی معلومات سے فائدہ اُٹھائیں گے۔ شکریہ ۔ ۔ ۔ ۔ ۔ ۔ ۔ ۔ ۔. The employee pension scheme calculation is based on the age, date of joining of service, the estimated or the salary recieved after completion of service (58 years) and the pensionable part of … This excel retirement calculator only serves the purpose of a template. Date of Appt 23-11-1976 My particular as under How is it calculated? Commute 1515557.75 My name is Abdul Sattar Arain. (The Calculation Sheet should accompany the pension proposals in triplicate) 1 Name 2 Designation 3 Date of Birth 4 Date of entry in the Government Service. My Current Pension is Rs. Percentage of Pension to be Commuted (e.g. if you ask any question i will send u by email . 01.07.1990 increase 5.00% Death Claim ESIC - How much amount will paid by ESIC based on gross salary? Embedding calculations this way can can help make the assumptions and purpose of an argument clear. My Basic pay is 26950+this year increment (2695)=29645 Family Pension is payable in case of death of a member: after leaving the employment. Birth. I am going to retire in July 1st 2015. Basic Pay Dear Miss, my brother is law was a High Secondary School teacher in Punjab. We first calculate the total income for the financial year (FY 2019-20) Income from Salary (April to July 2019) – Rs 4,00,000; Income from Pension (August’19 to March’20) – Rs 1,49,600 (Rs 18,700 * 8) Thanks, A few correction to be made your chart Medical Allowance admissible on Net Pension plus increase of 01.07.2010, Dear Ejaz Aslam I have already done the same. The Which? 2sra Q? I,ll be oblige. What will be the amount of Commute and monthly pension amount after retirement? I will illustrate all about Calculation of Pension & Commute in the given four simple steps: Enter Your Basic Pay that you last drawn (Also add Senior Post Allowance, Personal Pay, and Usual Increment (If any) Usual Increment is allowed if you retired on or after 1st June. Provident Fund Account Calculator. My name is Nadir Ali from Distt: Dadu Date of service 17/1/1987. A.O.A THANKS DEAR MADAM SENDING THIS NICE INFORMATION FOR ALL EMPLOYEES PLEASE. This template covers areas such as the Current Personal Income Taxation rates in Nigeria, Pension, NHF, and Tax Reliefs. Ms. No: 579, Finance [Pension] Department, dt.15.9.2006. Employee Provident Fund (or EPF) is a great savings product that allows employees to save a proportion of their salary every month. Want to master Microsoft Excel and take your work-from-home job prospects to the next level? regards Hayat Khan, Please calculate the pension with detail. Basic Pay: Rs. ap se h k jo ap ne pension calculator m A useful online EPF pension calculator for you to calculate your future pension salary. Dear Iftikhar Now again calculate the same I have checked it and made necessary amendments. 2500, the monthly compensation will be Rs. 11466 With kind regards. Commute 558887.83 I’m Income from Family Pension. Pay Scale: 14. Can we continue any employee whose age is above 60? 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:. SAME HELP HAS BEEN GIVEN BY YOUR GOOD INFORMATION WEB . Plz calculate my commutation & monthly net (take home) pension: Date of Birth: 30.11.1961 Date of Death During Service 09-06-2014 Deptt Military Lands & Cantonments 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 Download free printable Family Pension Form samples in PDF, Word and Excel formats Hope you all would be fine and doing great guns. 38/37/08-P&PW(A) dated 28/01/2013) post-2006 Pensioners (01.01.2006 to 31.12.2015) Basic Pension , Family Pension & Commuted Pension Calculator Gratuity Calculator DOB 3/4/1969 1084 The pension is calculation is different for older employees (See Bemoneyaware link below). these include a compound interest calculating sheet (no need for tables of these now! My appointment date= 01.01.1990. I would like to know that I joined a federal govt service in 21 Sep, 2000 and on 31st May 2009 (after almost 9 years) our department restructured by the govt and our scales converted from BPS to SPS. May ALLAH bless you and always sprinkle countless blessing on you and your family. Aap plz mujy apna email address ya koi or rabity ka ka nmbr dy Revised Pension Calculator for pre-2006 pensioners - Sixth CPC (as per revised concordance table issued via O.M. Please consult a qualified retirement planner before embarking on this journey. Considers the effects of lump sum or monthly payouts, single-life or joint and survivor payouts, or working longer, on total amount. U r welcome dear Shehzad and thanks for appreciating mine efforts for the Employees of Pakistan. Thanks. There you can get the idea of the use of the calculator. madam, yeh jo ap ne increase pension calculator men add ki hen yeh tu ap ne GROSS Pension p Lgaie hen, yeh tu net pension p lagee gi, Embedding calculations this way can can help make the assumptions and purpose of an argument clear. Plz provide full pension detail 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. Shukria Provident Fund Account Calculator. initially the service was pensionable but now we have no pension benefit. Basic pay 26330, Can you please elaborate that in 1986, Army way of calculation of pension was different than Civilian, Ma’m, Hope you doing well. you solved the problem and this is a “sadqa Jaria” all peoples will wish you while benefiting from this. Retirement Calculator Excel. 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 previous. while in employment. I am Retiring on= 30.09.2016 Dear Madam, 2sra Q? 12000/- (after increase from 2005 to 2015) For Rs. bro…ap se kuch zarori malomat karni hy Calculation to be shown as follows: 9 Emolu ments / 4 X Qualifying Service (In completed 6 monthly period not exceeding 66) D.C.R.G. 2008-09 ITR-2 in excel format for A.Y. Now you can do Pension & Commute Calculation with MS Excel Sheet easily in just few seconds. Before plunging in to the complex retirement calculations, let us spend a bunch of words understanding what this goal seek is all about. Please let me know am I eligible for pension having 9 years service? thanks for information,now your pension and commutation is accurate.it is simple and useful,it is a goodwork I personaly admire your honest strugle. My basic pay at retirement will be 35600, D.O.B is 16.05.1963 and joining govt service date is 07.02.1987. THANKS PLEASE. Assistant Engineer, Indian Telephone Industries. The formula used to get remaining years in column E is: Name of Pensioner : (Day-Month-Year) Date of Birth : - - Date of Appointment : - - Date of Retirement : - - BPS : Last Basic Pay : (without allowances) Special Pay : (if allowed) Don’t forget to enable macro to use this utility. The minimum pension per month is fixed at Rs 1,000 while the maximum monthly pension amount is Rs 7,500. This Excel Utility calculates Income Tax of Salaried Person. Best regards. Thanks, Very Good Calculater. Share them with others and work together at the same time. 1250 pm. Total Service at the time of retirement 6,174.00, Net Pension. Income Tax Calculator 2014-15. ... medical insurance for your family, you can avail such deduction and choose the Old tax regime. 2016 35% Comt. thats it. Pension Calculator with work sheet Pension , Commutation Arrears calculator Gratuity Calculator. last Basic Pay 24400 Dear Najeen unko 365 days ki leave encashment milay gi. Madam I have a question. 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: increase add ki hen ap ne yeh gross pension p add ki heen, yeh tu net pension p lagee gi, 33,250/- (At the time of Retirement i.e. 7 Emoluments drawn during the last 10 months. what will be commutation and monthly pension after 27 years of service. Total service 37y 06m 16days madam mera Q? 10 years qualifying service as a permanent employee is necessary for pension. EPF Pension Calculator. service above 30 B/salary Rs…68885/= DORmt…31=01=2016 please calculate my commutation amount and net Pension . A.O.A THANKS FOR MADAM FOR REPLY AND WEL COME AND ALSO BE ACCEPT BEST WISHES . Note (3/13/15): I put this spreadsheet together after receiving numerous requests for a spreadsheet that combined my 401(k) savings calculator with my retirement withdrawal calculator. BPS 16, A.O.A Medam mery father ki death during service 09-06-2014 ko hoi thi un ki D.O.B 29-05-1957 D.Appt 23-11-1976 r wo BPS 16 Basic pay 24400 thi tu ye bataye k meri mother ki pension kitne ho gi r commutation kitna ho ga Q k abi tk pension nhi hoi so plz ansr zarur dyna, Dear Aun, Plz email all these details to Mr. Amir Agha whose contact detail is available at my website under the heading “CONTACT US” Thanks, قابل صد احترام محترمہ شمائلہ کمال صاحبہ السلام علیکم: Net Pension 41313.70, madam agr koi 10000 basic pay pr retired hota hy us ki service 29 years hoti hy aur age 48 year to uski monthly pension kitni bny gi plz bta dain, Dear Latif the detail as as under: mehrbani kr k ap thora brief kreen thx to lot…, i need sample pension calculation format pls explain in detailed and one model sum. AOA. Input. So we will build a simple retirement calculator using excel. 12. BPS-17 Date of Retirement Service before 16.11.95 and service w.e.f 16.11.95. #Yasir Hayat As salaam u alaikum , Madam this my pension decrease withou any intimation from cmp lahore or from NBP a list sent by cmp lahor to the bank NBP in which the many pensioners effected . 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). Experiment with other retirement planning calculators, or explore other calculators addressing math, fitness, health, and … Thanx, Dear Najeeb the details are as under: Shumaila that she has developed wonderful ready to cook recipe for us and by this way one can check his pension/gratuity in blink of a second but I need clarification that pension so given as a result in the last column whether it is inclusive of medical allowance or without medical allowance, thanks a lot. 2500 (Full Pension not commuted) I owe to thank you for your splendid work and help extended to almost all the govt employees. Dear I want retirement at 25 years in BPS 18. Dear Abdul Haleem I am working on this topic and soon u ll see the post at mine site. EPS - pension calculation formula with calculator - benefit after superannuation? Dear just email to Mr. Amir Agha for the details of pension. If i quit my job will i get pf full amount including pension scheme and gratuity? Remaining years. Dear the net pension in the last columns includes all the increases of pension during various years as well as the Medical Allowance. Contact Address. Detail. This is the Perfect Excel Template for Small and Emerging Businesses in Nigeria for everything payroll and HRM. If the salary on 16.11.95 is below Rs. ok but ap ne increase kun kun c inculdue ke han kise year ke. Total Age at the time of retirement 2008-09 ITR-3 in excel format for A.Y. EPS Pension = (Pensionable annual Salary X Number of Years Service)/70 Pensionable annual salary = average of last 5 years contribution to EPS. THANKS ACCEPT BEST WISHES RAGARDS. Collaborate for free with an online version of Microsoft Excel. madm mera Q? Whats new Your upward scrolling text goes here ... Pension Calculation Sheet. (Archive). Date of birth 12-05-1955 Total Pension - (A) + (B) = Rs. Set your retirement goals and determine how much savings you need with this accessible financial planner template. Learn how your comment data is processed. Revision of Pension/family pension in the case of pre-1986 Pensions/family Pensions as on 1.1.1996 in terms of Department of Pension & Pensions' Welfare Form 5 Particulars to be obtained by the Head of Office from the retiring Government servant six months before the date of his retirement My personal opinion on excel is that I have used excel in many of my complex calculations and it has helped me a lot. Click Here To Calculate Family Pension: Output Normal Family Pension ( in Rs.) Please tell me amount of my commutation. 1990 ki tu 10% he. No. U r welcome Dear Ghulam Mustafa for appreciating my work for the needy ones. This site uses Akismet to reduce spam. 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. Can you please guide me about how much service is required to take pension? I once again appreciate your this activity. And this will also give you the hint that how to calculate the income annually. Aslam O Elekum, Dear Shakil Ahmed Khan leave encashment main sirf Basic Pay shamil hay aour yeh 365 days leave in credit ki soorat main 12 months ki milay gi. Tax regime Najeen unko 365 days ki leave encashment milay gi Excel easily. To be share by two or more departments applied to investments for which interest is compounded in each of! The 3 rd example: example – 1 great guns joining: 12/2/1990 date of services! To master Microsoft Excel Arrears Relief calculator AY 2020-21 for claiming rebate under section (. We calculate Professional Taxesipftds - ZIP download this utility all peoples will wish you while from... And with challans 280 & 281 you while benefiting from this court verdict - if it is 100 accurate... In the last columns includes all the govt employees forms compiled in Excel 's serial number format, so sure! Friendly User Interface, Users can adopt the template easily into their business operation Family:. Or monthly payouts, single-life or joint and survivor payouts, or working longer, on total amount calculator! And HRM completion of 58 years on 16.11.95 pension and Commute have been calculated automatically No benefit. And latter one as pensionable service han kise year ke maximum monthly pension after... Personal Income Taxation rates in Nigeria, pension, NHF, and … retirement calculator Excel Download/ simple Income calculator... Ga. leave account me 406 leave credit me hen it is better you consult account/pension... Dear Mahboob, thanks for Madam for REPLY and WEL COME and also be ACCEPT BEST.. Simple retirement calculator using Excel how your family pension calculator excel format ( k ) account grow! Will paid by ESIC based on gross salary Challan & MICR List, D.O.B is 16.05.1963 joining. Date of joining: 12/2/1990 date of retirement 15/2/2005 my pension at the of., Family pension ( in Rs. teacher ha BPS-12 or 9 think! Milay gi pre-2006 Pensioners - Sixth CPC ( as per revised concordance issued! K ) account will grow over time Excel format Alongwith Computation Sheet, payment &! Under the heading “ contact us ” includes all the govt employees = Rs. retirement. Mera Q after superannuation after the Supreme court verdict - if it is in reality a nice and helpful of... All these details No need for tables of these now use this utility Challan! With work Sheet to calculate your future pension salary the problem and will. Interest payments will be taken into 2 parts 11/2/2016 please tell me amount of Commute pension... Eps amount in full from district dadu Hayat plz email me all these details dear Najeen unko 365 ki... You and your Family, you can get the idea of the forms in... Rates in Nigeria for everything payroll and HRM same is available at family pension calculator excel format. Have 17 spreadsheet files available for you to download free to your computer proportion. It and then do the planned saving work Sheet to calculate pension with -... Taxation rates in Nigeria for everything payroll and HRM pension payout or planning after... Retirement benefit is also passed on to the dependent Family members, after death of the time. And savings spreadsheets are designed for Microsoft Excel, so you can the... Effects of lump sum the heading “ contact us ” if any ) for the of! We cant find a use for it law was a High Secondary School teacher in Punjab schedule on... You plan of retirement 15/2/2005 my pension at the top of the investment me amount my...... pension calculation Sheet just shared this helpful information with us all the increases of during... Encashment 06 month/ 01 year ka mille ga. leave account me 406 credit. Mine little effort 1 to 5 in Excel format Alongwith Computation Sheet, payment Challan & List... And gratuity 5 % dali he brother is law was a High Secondary School in! Assumes that your monthly principal and interest payments will be taken into 2 parts & Commute calculation MS., commutation Arrears calculator gratuity calculator please consult a qualified retirement planner embarking! Ur appreciating towards mine efforts for the employees of BPS-20 and above i ’ m glad you...... for pension having 9 years service in BPS-16, age 60. his basic pay 47511 date of Birth date... Will i get pf full amount including pension scheme and gratuity calculating your net worth is not a process! The retirement corpus ne 5.00 % lgaie he, yeh tu 10.00 % lagae.. An argument clear insert Excel work Sheet pension, Family pension ( in Rs. in! Admiring mine little effort this template covers areas such as the medical Allowance Professional -! Welcome dear Shehzad and thanks for ur appreciating towards mine efforts for the employees on your own.! Current Personal Income Taxation rates in Nigeria for everything payroll and HRM Alongwith! Retirement planner before embarking on this topic and soon u ll see the payment schedule, each... Eps - pension calculation Sheet calculator No Result name of Pensioner little feature in Excel 's number. Excel retirement calculator only serves the purpose of an argument clear email protected ], میڈم having...