Pension and commutation Calculator in Excel For Retired Employees
Vložit
- čas přidán 29. 02. 2020
- pension and commutation calculator 2020. Pension Calculator In Excel 2020
for All Retired Employees.
_/LINKS\
► Facebook:➜ / shahabislam123
► Twitter:➜ / shahabislam123
► Instagram:➜ / shahabislam6
► Website:➜ advanceexcelonline.blogspot.com/
================================================
#Excelpension #AdvanceExcel
جزاک اللہ واحسن الجزاء فی الدنیا و الآخرۃ
آمین
this information is very helpful and easy to understand.
Glad it was helpful!
Ma Sha Allah Zabardast Pension Calculation
Boht zabardast thank you sir
👍👍
Love From Bangladesh 🌼🌼🌼❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
Assalamualaikum marvellous
بہترین
Excellent
aap ne bhut acha samjaya
good
I think you should discuss how to maintain automatically ledgers on the basis of cash book and bank book.
data entry in cash book and then data transfer auto to its relevant ledger sheet and ledger should be maximum
thanks waiting for your reply.
Is this calculation ok for private employees under eps 95 too?
Is it applicable for also private sector's ?
Zabardast.
Sir, very good infirmatio
Please tell,
Whether amount of commuted pension is free from Income Tax or not ?
Nice teaching Sir Shahab
Nice effort, will you please share the formula how to calculate and revise the pay scale chart. I'll be grateful.
Very Excellent vedio
Dear sir, retire steno hun. Mujhay competant authrity nay retire nahin kia. Un non Officer nay retire kia hay. Jo keh ye officr long leave approve nahin kar sakta. Ab man retirement canclation karwana chahta hun date of brth.1-1-67. retirment 31-7-2020
Man kia tarika akhtiar karoon thanks Vehari
Hi sir, after independence 1947, is there any distribution of pentiion benifits to common tax payers in india or pakistan from uk or etc..? In the name of stock shares or through uk crown estates exchequer fund? Bcaz in my village, many caste families after death of elders.. getting huge settlements from hidden public trust or uk based or govt..., please guide how to trace if innocent cheats by relatives...?
Isn't Medical allowance for Gazzetted employees,
20% of the Net Salary,
and Medical Allowance 2,25% of the Medical Allowance 1 ?
Can you guide about adding previous pension increases for people retiring after July 2024 ?
Scale 1 to 15 medical allowance is 25 % h.
EPs95 pensioners presentlly getting max 1000 to 3000 how we relate with our pension
Next cricket match.
Thank you sir
All the best
Super sjr
Good
Thank you
Super presentation.
CONGRATS.
G. BALAJI SINGH.
Retd. HOD Mech. Engg.
.
Now, Gauhati High court has given a Judgement and upheld by the Supreme Court , to grant of Pension on the completion of 79 years, ie from his 80th Birthay itself. All pensioners may apply for this to their Pension Disbursing Authority. and get benefitted.
Super osuper message good thanks tosusira oprivated limited
Assalamo Alaikum I am new viewer of your video on pension very good informative video. Kindly narrate how download this excel sheet. Thanks. Muhammad Ismail.
Goob job! :) Keep it up! Would you like to be CZcams friends? :]
Medical may be calculated on gross pension rate of medical s 25% and increase of 50% on calculated medical. Is am right?
Excellent job done sir
..
Very good.
Assalam u alekum! Sir ye pension restore ye calculation comutation widow k lye b apply ho skty hn?k wo apny zindgy me apny saary pension cash krwa saken????kya main apny saary pension ek sath le skty hun?jo mjhe monthly milty ha?kya main ese restore kr skty hun?kindly mjhe b info or formula bata den
1. Earn leave kahsay add kartay hain . 2.Federal government employee ki earn leave at the time of retirement kahsay add karain gay. Kitni banay gi. Aur length of service earn leave k add karney se kiya banna gi. Thanks
You gave made the excell sheet little long and cumbersome. Pl.maki t as much as simple.
Assalamoalakum.Sir aap nay bohat acchi information share ki hain.kindly mujay bata dain keh iss waqt meri wife sindh govt main BPS 17 main hain wo 2035 main 24 year service kay baad 60 year age main retire hongi.un ko 24 year service per basic pay ka kitnay % pension Malay gi.kindly approximately bata dain aur formula ne share Kat Dain pl
Pl make the oension calculator simple and ver few columns,to br,filled
Pl make pension calculator very simple. Make a sheet which needs very few columns,to be,filled. I think you understand what we need.
Age at the time of retirement 60 normal service 26year 2 month which benefits we can get? sir
Sir mn 15 may 202q ko retire hiwa honn scal 2022 mn rehivise hiway h hn
Is video m ap ne 1 2010 ka medical ka zikr kia ha (1 se 16) k li jab k 2015 m bhe medical + hota ha
Iam retire on may 98 which formula applicable my basic pention is 7530/- +1132 old age benifit.
Nicely explained. This Calculation applicable for central/state/ private. For private company calculation ???
Yes
Please give estacode para reference mentioning Last pay drawn is the basic thing to calculate pension.
Sir
Begic Selry 38000
Age 56
Nokri. 23
Limited company se
If an employee after completing 31 years service in the age of 51 years when will his pen restored.
AOA bhae ye BTA den k biwa ki pension b increas hoti ha yani 72 saal age ho jay lady ki to inki b double ho gi.husband ki death k bad wife pension leti rhy or wife yani biwa ki age jub 72 saal ho gi to kya inki b double ho gi kindly BTA den
Gross pension ko 65% aur 35% m karte ha to 65% m 2011 2015 2022 aur 2023 ke adhoc shamir ko jate ha pher medical + or me total pension nikl aate ha
I am a family pensioner of local government sindh( kmc)please bataeen ke kia yeh maloomat jo apne deen wo federal government khein ya local government ?
Sir I was retd in 01 Mar 2008 In Hav rank total service 18 yrs 6 month , in served in Hav rank 10 yrs 06 month in X Group. I will be beneficial for OROP and how much my pension I will draw , I was entitled MACP and claim under process with record, waiting for e PPO, please explain me how much my pension after MACP and OROP , PLEASE
D . O . B . 31-08-1959
D . O , F. A 01-11-1977
D, O ,R 29-08-1998
TOTAL SER 28-09-0020
Pension double ho choki ha 15 sal kay bad wasol kar na ka trika mazid malomat malomat kay lia agha ki jia Makhdoom M Aslam
Massage sir,
Thanks for your video.
Please show the calculation of pension formula I. e 7/300 and age rate figure calculation. How it arrived.Show furnish the details.
Awaiting for details.
Pl make theeditable excel sheet simple. With very less and very much required columns to br filled.
Good vedeo. Help me to calculate my pension. I retired in 2006.39 yr service. I am getting 40376 after commutation 6500
Hello sir. I retired in Feb 2015 from punjab govt My basic pension is 13345, commutation 4003,medical 1000, because I am above 65, so 5% extra pension. Now I want to know about my DA. Please clear . Thanks in advance.
سر میری سروس 59 سال اور 6 ماہ ہو چکی ہے تو کیا بقیہ 6 ماہ کا L P R لے سکتا ہوں یا ریٹاٸرمنٹ لوں تو کیا نقصان ہو گا ?
20+ yrs service ho 50+age py kitny pention ho gi??sps7 ki?????
42 sal ki umar ma mae board out hoe thi 16 grade teacher. 1 january 2000. Kya mari double pension ho sakti hae. Plz
what was basic pay of scale 3 bank manager in 2001??
Make it simple.and amake for 12BPprnsiiners only.
Assalam 0 Aliykum Respected sir g
Please tell how much F.Pension is eligible for the eligible family pensioner, wherein the original pensioner retired in 1983, whose original pension was Rs.565 plus DR.
Sir mere father revenue department me 5 scale me the 1998 ko wo retire ho chuke he & un ki death ho gai he 2013 me ab meri mother pension leti hen Jo ke 24000 milti he mera question ye he sir ke ab ke budget ke baad un ki pention kitni milegi.
Ap ki boht mehrbani Hogi sir plz 🙏 help us
Sir gee ye bata din k agar aik lady government servant k husband ne usc lady government servant ki zindgi min he dusri shadi ki hoi ho tou kia wo pension lenay ka haq dar ho ga. Aur ici tarah agar wo banda bv ki death k baad dusri shadi ker lata ha tou kia pension ka haq dar rahay ga?
Assalam o Alekum sir,
Sir ap sy pochna ye tha k mery walid sb ny pre mature retirement li thi. Ap un k age 70 yrs hy. To kya un ka pension restoration time hogya hy. Details as under.
Date of retirement . 2004
Date of birth. 06.01.1951
Kindly help.
Sir my service 33 year and age 53 year basic pay 28070 and retiring date 24.11.2020 hai penshan kitni ho gi?
72 years pay medial allounce man izafa hota ha kya?
Sir
Namaskar
I want to learn, how to make formulas in excel.
بہت خوبصورت انداز میں اپ نے سمجھایا بہت بہت شکریہ محترم
ایک چیز کی سمجھ نہیں آئی کہ یہ جو Age No of Year Rate ہے اس میں 2 جو لکھا گیا ہے یہ کیا چیز ہے ؟
Aap ko ek cheese samajh nahin aa rahi hai to main samjhaane ka koshish karta hun. 2 is the ordinal number of Column B (2nd column) referred to in the VLOOKUP formula to find out the corresponding commutation factor against age at retirement. In the first row, the age of the pensioner at retirement in column 1 is 58 and the corresponding age/rate (commutation factor) in column 2 is 13.43. Command has been given to search the value of 58 from column 2 which is 13.43.
Ummid karta hun ki ab aapko samajh me aa gaya ki yeh 2 kahan se aa tapka.
Samajhne wala samajh gaye hain, jo na samjhe voh ........ hai. Thank you.
@@kushalmukhoti جزاک اللہ خیرا
@@ddoacii5384 جزاکم الله خیرا
What is the relation between bismillah and pension.
Ek ek principal ki salary kat kar 80000 milti hai principal suppose abhi 2019 main bane hai Na kabhi pf nikala or koi leave bhi nhi hai use ki job agar 1994 main lagi thi or 8th commision par retired honge
To kitna amount milega ? After retirement ?
Taqreeban 80 lac
Where is the link of that Pension Calculation Sheet??
Jb gross pension animal lete ha to hr year jo increase hota ha wo be pension m plus Kia jata ha ap ne nahi kia
Sir pen pay slip per month kaizen nikalna Rahmath Ali Baig Thankyou
Asalam alaikum sir, sir meri 11years service he kindly bataege k meri pension kitni banegi
12 scale age 60 pa tetired hu rha hu basic pay 34000 h total penssion ketni bne gi health dept
super,, informative video
amar service 16 year 8 month 16 days . service period koto hobe ?
I have retired on 31st May 2000 after serving more than 30years. My level of pension is 12 and sl.3. (BP 41800.00) pl. let me know the revised pension as per 7th pay commission.
sir..what was your basic pension in 2001??
2000??
Basic 19000 h. Retirement py kitny mily gy? 4 GRADE
Not possible to understand as it can be done by expert on excel sheet working. The same must have been simplified by auto formulas.
November main 69000 basic pay , penshion kaya ho ge
30y se kam service hone se pension milega ya nehi milaga
Brother ap nau commuted pension ku 122 say multiply ker diya ha. commuted pension ku her saal increase lgta ha govt ki taraf say wu commuted amount man nae daala ap nay.
Teacher ke medical a category me retirement le hy os ke bnift btae
Bsnl can pension come who much 17 year 2004 appointment
What about the EPs-95 pensioners excel sheet
Jan 2021 EPs95 ke pensioner ki excel sheet nahi batai, wait
HO P00144
4000 - 6000 pay scale main 4500 basic pay per kitni pension hogi
درخواست یہ ھیکہ ایک کیڈر جو کہ منسٹری آف ڈیفنس پروڈکشن میں بہت مشکل ڈیوٹیاں سرانجام دیتا ہے اسکو بھی اپگریڈیشن میں شامل کیا جاۓ وہ ہےسپلائ اسسٹنٹ کا
Ai pention ,1. 4. 93 Year W/C ,P,wD er Emploi belake paba ne
Assalamoalaykum Awesome JazakAllah
Pl explain in formula "7" and divided 300 (what are)
Sir ma ex.service complete kr chuka ho mjh ap sy apni pension k brye ma ap sy bt krna chahta ho
What is your departent
31 may 2014 ला रिटायर झाले आहेत theva 8900+1600 पेनशीन होती आत्ता किती होईल.
sir how to create inventory managment for glass and ply wood works in excel or access .please help me if you have any idea or links please share with me
czcams.com/channels/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos
Dear my first appointment is 03.06.1995.my basic pay is 41870.and my date of birth is 10.06.1975.plz calculate my graduty.and my monthly pension.
@@mukhtiardehani6768 o
If last total salary was 130000 (including allowances), service was 30 years and officer was 19 grade, what would be the monthly pension?
Gross Pension Column main jo 7/300 ap nay lagia ha us ka kia logic ha kindly define