Ctc- Salary Calculator
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ctc- Salary Calculator as PDF for free.
More details
- Words: 379
- Pages: 4
Grand CTC Yearly & Monthly Break Up of Salary for F.Y. 2008-09 Basic HRA Medical Misc. Conveyance Education.
50% 20% 10% 1% 6% (13% - E P F + ESIC)
Particulars
Annual CTC without Bonus & L. T. A. Basic H. R. A. Misc. Allowance Medical Allowance Conveyance Allowance Education Allowance Mobile and Car Expense ( On Actual) *Gratuity **Superannuation Gross Salary (A) Performance Bonus + L.T.A. Less : Deduction (B) PF - Employers Contribution 12% of basic or Rs. 780/- whichever is less P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less) ESIC - Employers Contribution 4.75% of Gross Salary. ESIC - Employees Contribution 1.75% of Gross Salary. Professional Tax Net Salary Payable (A-B) Conveyance Re-imbursement Total Cost to the Company (Annual)
Monthly salary x 12 + 8000+E.P.F. yearly Yearly
Grand Totals
2 49 360 1 24 680 49 872 2 494 24 936 14 962 23 057
Monthly Monthly Salary Break Salary Total up 20 780 10 390 4 156 208 2 078 1 247 1 921
Cross Check
2 40 000
257,360 21,447 667
9 360
780
780
9 360
780
780
-
-
2 500
11 860 2 28 140 2 57 360
There are 6 variables (mark in yellow cells) in this file only that we need to punch the figure. Insert the Gross Salary in the mentioned cell (Extreme right). 1 20000 Cell "M8"
20000*12+8000+9360
20 000 (A)
8 000
NOTES:
2
14961.6
Insert Monthy Salary multiply by 12 months + 8000 (yearly Bonus +LTA) +9360 P.F. Yearly. If E.S.I.C is applicable you have to insert that amount as well from Diff column
Cell "K8"
200
980 (B) 19 020 (A-B) 19 020
200 19,020
3
0
ESIC Diff. amount - It will show us the difference if any for ESIC. (for their Addition and Substraction .On basis of that we have add or substract.)
Cell "M12" 4
Mobile and Car Expense ( On Actual) Cell "C26"
5
*Gratuity (Eligibility for Gratuity: 5 years of Service ) Cell "C27"
6
*Superannuations (Eligibility for Superannuation: 10 years of Service ) Cell "C28"
hly x 12 + E.P.F.
2 57 360 ESIC
20 000
Gross Salary ESIC Diff amount
0
Diff. amount (This cell should be Zero)
1246.8
20,000
980 19,020
50% 20% 10% 1% 6% (13% - E P F + ESIC)
Particulars
Annual CTC without Bonus & L. T. A. Basic H. R. A. Misc. Allowance Medical Allowance Conveyance Allowance Education Allowance Mobile and Car Expense ( On Actual) *Gratuity **Superannuation Gross Salary (A) Performance Bonus + L.T.A. Less : Deduction (B) PF - Employers Contribution 12% of basic or Rs. 780/- whichever is less P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less) ESIC - Employers Contribution 4.75% of Gross Salary. ESIC - Employees Contribution 1.75% of Gross Salary. Professional Tax Net Salary Payable (A-B) Conveyance Re-imbursement Total Cost to the Company (Annual)
Monthly salary x 12 + 8000+E.P.F. yearly Yearly
Grand Totals
2 49 360 1 24 680 49 872 2 494 24 936 14 962 23 057
Monthly Monthly Salary Break Salary Total up 20 780 10 390 4 156 208 2 078 1 247 1 921
Cross Check
2 40 000
257,360 21,447 667
9 360
780
780
9 360
780
780
-
-
2 500
11 860 2 28 140 2 57 360
There are 6 variables (mark in yellow cells) in this file only that we need to punch the figure. Insert the Gross Salary in the mentioned cell (Extreme right). 1 20000 Cell "M8"
20000*12+8000+9360
20 000 (A)
8 000
NOTES:
2
14961.6
Insert Monthy Salary multiply by 12 months + 8000 (yearly Bonus +LTA) +9360 P.F. Yearly. If E.S.I.C is applicable you have to insert that amount as well from Diff column
Cell "K8"
200
980 (B) 19 020 (A-B) 19 020
200 19,020
3
0
ESIC Diff. amount - It will show us the difference if any for ESIC. (for their Addition and Substraction .On basis of that we have add or substract.)
Cell "M12" 4
Mobile and Car Expense ( On Actual) Cell "C26"
5
*Gratuity (Eligibility for Gratuity: 5 years of Service ) Cell "C27"
6
*Superannuations (Eligibility for Superannuation: 10 years of Service ) Cell "C28"
hly x 12 + E.P.F.
2 57 360 ESIC
20 000
Gross Salary ESIC Diff amount
0
Diff. amount (This cell should be Zero)
1246.8
20,000
980 19,020
Related Documents
Ctc- Salary Calculator
June 2020 3
Quikchex Ctc Calculator April
August 2019 9
Ibm Salary Calculator
November 2019 5
Ctc Salary Slip Form (legal)(1)
April 2020 2
Ctc _ Salary Slip - The Very Basic Version
July 2020 7