Posts tagged "CALCULATOR"

Employee Leave Calculator and Annual Leave Policy

I have made an excel sheet to know Earned Leave,Sick Leave and Casual Leave also attached annual leave policy guidelines and procedure.

FOR STAFF MEMBERS

 

1.   All the categories of staff members (Below Sr. Officer cadre) (i.e., Trainees, Probationers, Confirmed

      and Contract employees) are eligible for eighteen days of privilege leave (paid leave) in a year.

 

2.   If any employee joins in the middle of the year he / she will be eligible for privilege leave on Pro rata

      basis.

 

3.   The employees should intimate the leave well in advance (atleast two days prior taking leave) and get

      it sanctioned in the leave card from the department head / Reporting authority and the same has to be

      Submitted to the Time office.

 

4.   Balance of leave, if any, at the end of the year will be carry forwarded to the next year up to maximum    

      30days.

 

5.   In case of Resignation / Termination / Superannuation the balance leave, if any, will be reimbursed on

Prorate basis (Up to maximum of 30days).

 

6. If the employee proceeds ‘on leave ’due to unavoidable reasons in the middle of the shift or before the end

    of the shift, it will be treated as half a day leave. 

Sr.OFFICERS & ABOVE GRADE

 

1.   All the categories of staff members (ie., Trainees, Probationers, Confirmed and Contract employees) are

      eligible for  twenty two days of privilege leave (paid leave) in a year.

 

2.   If an employee joins in the middle of the year he / she will be eligible for privilege leave on Pro rata

      basis.

 

3.   Leave cards will be issued to the employees.

 

4.   An employee should intimate the leave well in advance (atleast two days prior taking leave) and get

      it sanctioned from the  Reporting authority in the leave card and the same has to be  submitted to the

      Time  office.

 

5.   Balance of leave, if any, at the end of the year will be carry forwarded to the next year. Balance leave can

      be  forwarded up to a maximum of 30 days.

 

6. In case of Resignation / Termination / Superannuation, the balance leave if any will be reimbursed on 

    Prorate basis (Up to maximum of 30days).

 

7. If the employee proceeds ‘on leave ’due to unavoidable reasons in the middle of the shift or before the end

    of the shift, it will be treated as half a day leave. 

Click here to download automatic leave calculator

Click here to download leave policy

3 comments - What do you think?
Posted by Hrformats - June 14, 2013 at 2:41 PM

Categories: HR   Tags: , , , ,

NSC Interest Auto Calculator

I am pleased to upload herewith NSC interest auto calculator.

NSC Accrued Interest Calculation can use only yellow cells
Select Tax Computation Year:
[email protected]
Purchase between Purchase between Purchase between Purchase between Purchase between Purchase on or
1-Jan-89 to 31-Dec-98 1-Jan-99 to 14-Jan-00 15-Jan-00 to 28-Feb-01 1-Mar-01 to 28-Feb-02 1-Mar-02 to 28-Feb-03 after 1-Mar-03
The year for which [Vide Rule 15(1) of the [Vide Rule 15(2) of the [Vide Rule 15(3) of the [Vide Rule 15(4) of the [Vide Rule 15(5) of the [Vide Rule 15(6) of the
interest accruess NSC (VIII) Issue Rules,1989 NSC (VIII) Issue Rules,1989 NSC (VIII) Issue Rules,1989 NSC (VIII) Issue Rules,1989 NSC (VIII) Issue Rules,1989 NSC (VIII) Issue Rules,1989
12.00% 11.50% 11.00% 9.50% 9.00% 8.00%
First year 12.40 11.83 11.30 9.72 9.20 8.16
Second year 13.90 13.23 12.58 10.67 10.05 8.83
Third year 15.60 14.80 14.00 11.71 10.97 9.55
Fourth year 17.50 16.54 15.58 12.85 11.98 10.33
Fifth year 19.70 18.51 17.35 14.10 13.09 11.17
Sixth year 22.40 20.69 19.31 15.47 14.29 12.08
Interest Total: 111.50 95.60 90.12 74.52 69.59 60.12
NAME :
Certificate No. Date of Purchase Amount Invested Rs Accrued Interest Rs Purchase Year Rate Applied
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total Accrued Interest 0.00
NOTES:
1. Enter details of all NSCs purchased between 1-Apr-2002 and 31-Mar-2008
2. NSCs purchased before or after this date will not accrue the interest for this financial year
3. Entry of certificate number is optional By: Vijaykumar Vyas

 

Click Here To Download Nsc Interest Auto Calculator

Be the first to comment - What do you think?
Posted by Hrformats - September 26, 2012 at 8:24 AM

Categories: HR   Tags: , , ,

Calculate your Loan Interest by EMI Calculator

I have Attached EMI Calculator in Excel.


EMI CALCULATOR
Loan Amount 400000 Created by
Loan Term (Years) 10 JITENDRA PATEL
Payments Per Year 12 Gozaria High School
Rate of Interest 8.75% Gozaria
Monthly Installment 5013 Email-  [email protected]
Total Interest 201568
S.No Monthly Installment Interest Principal Balance
0 400000
1 5013 2917 2096 397904
2 5013 2901 2112 395792
3 5013 2886 2127 393665
4 5013 2870 2143 391522
5 5013 2855 2158 389364
6 5013 2839 2174 387190
7 5013 2823 2190 385000
8 5013 2807 2206 382794
9 5013 2791 2222 380573
10 5013 2775 2238 378335
11 5013 2759 2254 376080
12 5013 2742 2271 373809
13 5013 2726 2287 371522
14 5013 2709 2304 369218
15 5013 2692 2321 366897
16 5013 2675 2338 364559
17 5013 2658 2355 362204
18 5013 2641 2372 359832
19 5013 2624 2389 357443
20 5013 2606 2407 355036
21 5013 2589 2424 352612
22 5013 2571 2442 350170
23 5013 2553 2460 347710
24 5013 2535 2478 345233
25 5013 2517 2496 342737
26 5013 2499 2514 340223
27 5013 2481 2532 337691
28 5013 2462 2551 335140
29 5013 2444 2569 332571
30 5013 2425 2588 329983
31 5013 2406 2607 327376
32 5013 2387 2626 324750
33 5013 2368 2645 322105
34 5013 2349 2664 319440
35 5013 2329 2684 316756
36 5013 2310 2703 314053
37 5013 2290 2723 311330
38 5013 2270 2743 308587
39 5013 2250 2763 305824
40 5013 2230 2783 303041
41 5013 2210 2803 300238
42 5013 2189 2824 297414
43 5013 2169 2844 294569
44 5013 2148 2865 291704
45 5013 2127 2886 288818
46 5013 2106 2907 285911
47 5013 2085 2928 282983
48 5013 2063 2950 280033
49 5013 2042 2971 277062
50 5013 2020 2993 274069
51 5013 1998 3015 271054
52 5013 1976 3037 268018
53 5013 1954 3059 264959
54 5013 1932 3081 261878
55 5013 1910 3104 258774
56 5013 1887 3126 255648
57 5013 1864 3149 252499
58 5013 1841 3172 249327
59 5013 1818 3195 246132
60 5013 1795 3218 242914
61 5013 1771 3242 239672
62 5013 1748 3265 236407
63 5013 1724 3289 233117
64 5013 1700 3313 229804
65 5013 1676 3337 226467
66 5013 1651 3362 223105
67 5013 1627 3386 219719
68 5013 1602 3411 216308
69 5013 1577 3436 212872
70 5013 1552 3461 209411
71 5013 1527 3486 205925
72 5013 1502 3512 202413
73 5013 1476 3537 198876
74 5013 1450 3563 195313
75 5013 1424 3589 191724
76 5013 1398 3615 188109
77 5013 1372 3641 184468
78 5013 1345 3668 180800
79 5013 1318 3695 177105
80 5013 1291 3722 173383
81 5013 1264 3749 169635
82 5013 1237 3776 165858
83 5013 1209 3804 162055
84 5013 1182 3831 158223
85 5013 1154 3859 154364
86 5013 1126 3887 150476
87 5013 1097 3916 146561
88 5013 1069 3944 142616
89 5013 1040 3973 138643
90 5013 1011 4002 134641
91 5013 982 4031 130610
92 5013 952 4061 126549
93 5013 923 4090 122459
94 5013 893 4120 118338
95 5013 863 4150 114188
96 5013 833 4180 110008
97 5013 802 4211 105797
98 5013 771 4242 101555
99 5013 741 4273 97283
100 5013 709 4304 92979
101 5013 678 4335 88644
102 5013 646 4367 84277
103 5013 615 4399 79879
104 5013 582 4431 75448
105 5013 550 4463 70985
106 5013 518 4495 66490
107 5013 485 4528 61961
108 5013 452 4561 57400
109 5013 419 4595 52806
110 5013 385 4628 48178
111 5013 351 4662 43516
112 5013 317 4696 38820
113 5013 283 4730 34090
114 5013 249 4764 29325
115 5013 214 4799 24526
116 5013 179 4834 19692
117 5013 144 4869 14823
118 5013 108 4905 9918
119 5013 72 4941 4977
120 5013 36 4977 0
121 0 0 0 0
122 0 0 0 0
123 0 0 0 0
124 0 0 0 0
125 0 0 0 0
126 0 0 0 0
127 0 0 0 0
128 0 0 0 0
129 0 0 0 0
130 0 0 0 0
131 0 0 0 0
132 0 0 0 0
133 0 0 0 0
134 0 0 0 0
135 0 0 0 0
136 0 0 0 0
137 0 0 0 0
138 0 0 0 0
139 0 0 0 0
140 0 0 0 0
141 0 0 0 0
142 0 0 0 0
143 0 0 0 0
144 0 0 0 0
145 0 0 0 0
146 0 0 0 0
147 0 0 0 0
148 0 0 0 0
149 0 0 0 0
150 0 0 0 0
151 0 0 0 0
152 0 0 0 0
153 0 0 0 0
154 0 0 0 0
155 0 0 0 0
156 0 0 0 0
157 0 0 0 0
158 0 0 0 0
159 0 0 0 0
160 0 0 0 0
161 0 0 0 0
162 0 0 0 0
163 0 0 0 0
164 0 0 0 0
165 0 0 0 0
166 0 0 0 0
167 0 0 0 0
168 0 0 0 0
169 0 0 0 0
170 0 0 0 0
171 0 0 0 0
172 0 0 0 0
173 0 0 0 0
174 0 0 0 0
175 0 0 0 0
176 0 0 0 0
177 0 0 0 0
178 0 0 0 0
179 0 0 0 0
180 0 0 0 0
181 0 0 0 0
182 0 0 0 0
183 0 0 0 0
184 0 0 0 0
185 0 0 0 0
186 0 0 0 0
187 0 0 0 0
188 0 0 0 0
189 0 0 0 0
190 0 0 0 0
191 0 0 0 0
192 0 0 0 0
193 0 0 0 0
194 0 0 0 0
195 0 0 0 0
196 0 0 0 0
197 0 0 0 0
198 0 0 0 0
199 0 0 0 0
200 0 0 0 0
201 0 0 0 0
202 0 0 0 0
203 0 0 0 0
204 0 0 0 0
205 0 0 0 0
206 0 0 0 0
207 0 0 0 0
208 0 0 0 0
209 0 0 0 0
210 0 0 0 0
211 0 0 0 0
212 0 0 0 0
213 0 0 0 0
214 0 0 0 0
215 0 0 0 0
216 0 0 0 0
217 0 0 0 0
218 0 0 0 0
219 0 0 0 0
220 0 0 0 0
221 0 0 0 0
222 0 0 0 0
223 0 0 0 0
224 0 0 0 0
225 0 0 0 0
226 0 0 0 0
227 0 0 0 0
228 0 0 0 0
229 0 0 0 0
230 0 0 0 0
231 0 0 0 0
232 0 0 0 0
233 0 0 0 0
234 0 0 0 0
235 0 0 0 0
236 0 0 0 0
237 0 0 0 0
238 0 0 0 0
239 0 0 0 0
240 0 0 0 0
201568

 

Click Here To Download EMI Calculator

Be the first to comment - What do you think?
Posted by Hrformats - September 10, 2012 at 6:01 AM

Categories: HR   Tags: ,

Paycheck Calculator

I have Attached Paycheck Calculator

Paycheck Calculator
For Wages Paid in 2011 © 2010 Vertex42 LLC
Paycheck Calculator
 Gross Pay
Gross Pay:  $      3,500.00
Pay Period: Monthly
Est. Gross Annual Pay:  $   42,000.00
 Filing Status and Withholdings
Filing Status: Single
Number of Allowances: 2
 Pre-Tax Adjustments
Tax Deferral Plan, 401(k): 5.00%
Other Pre-Tax Deductions:  $                  –
Federal Taxable Gross:  $      2,708.34
 Post-Tax Adjustments
State & Local Taxes: 5.30%
Other Post-Tax Deductions:  $                  –
Post-Tax Reimbursements:  $                  –
 Estimated Pay Check
NET Take-Home Pay 2,569.12
FICA Social Security (6.2%) 217.00
FICA Medicare (1.45%) 50.75
Federal Tax 344.58
Tax Deferral Plan 175.00
Pre-Tax Deductions 0.00
State & Local Taxes 143.54 [42]
Post-Tax Deductions 0.00
Post-Tax Reimbursements 0.00
Caution:
This calculator is for educational and illustrative purposes only and should not be construed as financial or tax advice.
The results are only estimates and may not apply to your specific situation.
Please consult a qualified professional regarding financial decisions.

 

Click Here To Download Paycheck Calculator

1 comment - What do you think?
Posted by Hrformats - September 4, 2012 at 4:35 AM

Categories: HR   Tags: ,

Salary Break Up Calculator

I have attached salary break Up calculator in excel format.

Yearly & Monthly Break Up of  Gross Salary
            Basic                            30%
            HRA                             20%
            City Compensatory All.   30%
            Conveyance                   Rs.800 per month
            Special Allowance          Balance
Yearly Grand Totals Monthly
Gross Salary                                     200,000     16,667
Basic                                      60,000      5,000
HRA                                      40,000      3,333
City Compensatory All                                      60,000      5,000
Employers Contribution 12% of basic or Rs. 780/- whichever is less                                        7,200         600
Conveyance                                        9,600         800
Special Allowance                                      23,200         200,000      1,933     16,667
Less : Deduction
P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less                                        7,200         600
P.F. ( Employers Contribution 12% of Basic or Rs 780/- whicever is less                                        7,200         600
Professional Tax                                        2,500           16,900         200      1,400
Net Salary Payable         183,100     15,267
Add Performance Bonus 30000
        213,100
Enter Values only in Yellow Cells

 

Click Here To Download Salary Break Up Calculator

2 comments - What do you think?
Posted by Hrformats - May 29, 2012 at 10:40 AM

Categories: HR   Tags: , , ,

Gpf Interest Calculator

I have Attached Gpf Interest Calculator

Name C MURUGAN GPF A/C No 786
Department CM
Closing Balance as at 31 March
Year 2011-12 Rate of Interest 8% upto Nov 11 & 8.6% from Dec 11 onwards 10000
Month Subscription Refund Advance/ Withdrawal Balance
April 3000 1000 14000
May 3000 1000 18000
June 3000 1000 22000
July 3000 1000 26000
August 3000 1000 30000
September 3000 1000 34000
October 3000 1000 15000 23000
November 3000 1000 27000 1293
December 3000 1000 31000 Interest @ enhanced rate of 8.6%
January 3000 1000 35000
February 3000 1000 39000
March 3000 1000 43000 1061
TOTAL 36000 12000 15000 342000
INTEREST 1061 1061
OPENING BALANCE AS ON 01 APRIL 10000
ADD:  SUBSCRIPTION & REPAYMENTS MADE DURING THE YEAR 36000
LESS:  ADVANCES & WITHDRAWALS MADE DURING THE YEAR -15000
CLOSING BALANCE AS ON 31 MARCH 47061

 

Click Here To Download Gpf Interest Calculator

2 comments - What do you think?
Posted by Hrformats - May 9, 2012 at 10:40 AM

Categories: HR   Tags: , ,

Gpf Interest Calculator

 I have Attached Gpf Interest Calculator

Name C MURUGAN GPF A/C No 786
Department CM
Closing Balance as at 31 March
Year 2011-12 Rate of Interest 8% upto Nov 11 & 8.6% from Dec 11 onwards 10000
Month Subscription Refund Advance/ Withdrawal Balance
April 3000 1000 14000
May 3000 1000 18000
June 3000 1000 22000
July 3000 1000 26000
August 3000 1000 30000
September 3000 1000 34000
October 3000 1000 15000 23000
November 3000 1000 27000 1293
December 3000 1000 31000 Interest @ enhanced rate of 8.6%
January 3000 1000 35000
February 3000 1000 39000
March 3000 1000 43000 1061
TOTAL 36000 12000 15000 342000
INTEREST 1061 1061
OPENING BALANCE AS ON 01 APRIL 10000
ADD:  SUBSCRIPTION & REPAYMENTS MADE DURING THE YEAR 36000
LESS:  ADVANCES & WITHDRAWALS MADE DURING THE YEAR -15000
CLOSING BALANCE AS ON 31 MARCH 47061

 

Click Here To Download Gpf Interest Calculator

2 comments - What do you think?
Posted by Hrformats - May 1, 2012 at 11:38 AM

Categories: HR   Tags: , ,

EMI Calculator

Calculate your loan interest by EMI CALCULATOR.

Click Here To Download EMI Calculator

Be the first to comment - What do you think?
Posted by Hrformats - September 7, 2011 at 9:06 AM

Categories: Others   Tags: ,

Income Tax Calculator

Download Income Tax Calculator for financial year 2009-10 and assessment year 2010-11 and also form 16 for Salary Person.

Click Here To Download Income Tax and Form 16

Be the first to comment - What do you think?
Posted by Hrformats - August 27, 2011 at 9:00 AM

Categories: Tax Format   Tags: , ,

Workmen’s Compensation Calculator

Enclose find a Workman’s Compensation Calculator for calculation of compensation in case of death, Permanent Total Disablement, Permanent Partial Disablement (Covered under Schedule I and not covered under Schedule I) with a WC Insurance Premium Calculator.

Enter only Serial Number mentioned against List of Injuries Sheet in place of NATURE OF INJURY AS PER LIST OF INJURY SHEET (ENTER SL.NO ONLY).

Click Here To Download Workmen Compensation Calculator

Be the first to comment - What do you think?
Posted by Hrformats - August 24, 2011 at 5:20 AM

Categories: Acts   Tags: , ,

Next Page »