• Author / Uploaded
• Oscar Laya

Citation preview

CALCULO DE LAS PRESTACIONES DE ANTIGÜEDAD DE UN TRABAJADOR

NOMBRE DEL TRABAJADOR: CEDULA DEL TRABAJADOR: FECHA DE INGRESO FECHA DE EGRESO

AÑO

MES

TASA DE INTERES 2009

25.98%

2010

19.69%

2011

19.78%

13234569

2012

33.59%

Apr-10

2013

PEDRO PEREZ

TIEMPO

SERVICIO

SUELDO

SALARIO

ALICUOTA

ALICUOTA

SUELDO

AÑOS

MESES

DEL MES

DIARIO

UTILIDADES

BONO VACIONAL

INTEGRAL

23.89%

DIAS PRESTACIONES AL MES =

5.00

ART. 108.- LOT 1997

DIAS PRESTACIONES TRIMESTRALES =

15.00

ART. 142.- LOTT 2012

DIAS

TASA

PRESTACIONES

PRESTACIONES

INTERES

INTERES

PRESTAC

INTERES

DEL MES

ACUMULADAS

MENSUALES

ACUMULADOS

PRESTAC+INTERES ACUMULADOS

ARTIC.108 LOT

2010 2010 2010 2010 2010 2010 2010 2010 2010

ABRIL

0

1

2,100.00

70.00

2.92

0.057

72.97

0.00

19.69%

0.00

0.00

0.00

0.00

MAYO

0

2

2,100.00

70.00

2.92

0.057

72.97

0.00

19.69%

0.00

0.00

0.00

0.00

JUNIO

0

3

2,100.00

70.00

2.92

0.057

72.97

0.00

19.69%

0.00

0.00

0.00

0.00

0.00

JULIO

0

4

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

364.87

0.00

0.00

364.87

AGOSTO

0

5

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

729.73

5.99

5.99

735.72

SEPTIEMBRE

0

6

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

1,094.60

12.07

18.06

1,112.66

OCTUBRE

0

7

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

1,459.47

18.26

36.32

1,495.78

NOVIEMBRE

0

8

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

1,824.33

24.54

60.86

1,885.19

DICIEMBRE

0

9

2,100.00

70.00

2.92

0.057

72.97

5.00

19.69%

364.87

2,189.20

30.93

91.79

2,280.99

2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011

ENERO

0

10

2,100.00

70.00

2.92

0.057

72.97

5.00

19.78%

364.87

2,554.07

37.60

129.39

2,683.46

FEBRERO

0

11

2,100.00

70.00

2.92

0.057

72.97

5.00

19.78%

364.87

2,918.94

44.23

173.62

3,092.56

MARZO

0

12

2,100.00

70.00

2.92

0.057

72.97

5.00

19.78%

364.87

3,283.80

50.98

224.60

3,508.40

ABRIL

1

13

2,100.00

70.00

2.92

0.065

72.98

5.00

19.78%

364.91

3,648.71

57.83

282.43

3,931.14

MAYO

1

14

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

4,117.88

64.80

347.23

4,465.10

JUNIO

1

15

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

4,587.04

73.60

420.83

5,007.87

JULIO

1

16

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

5,056.21

82.55

503.37

5,559.58

AGOSTO

1

17

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

5,525.38

91.64

595.01

6,120.39

SEPTIEMBRE

1

18

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

5,994.54

100.88

695.90

6,690.44

OCTUBRE

1

19

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

6,463.71

110.28

806.18

7,269.89

NOVIEMBRE

1

20

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

6,932.88

119.83

926.01

7,858.89

DICIEMBRE

1

21

2,700.00

90.00

3.75

0.083

93.83

5.00

19.78%

469.17

7,402.04

129.54

1,055.55

8,457.59

2012 2012 2012 2012

ENERO

1

22

3,200.00

106.67

4.44

0.099

111.21

5.00

33.59%

556.05

7,958.09

236.74

1,292.29

9,250.39

FEBRERO

1

23

3,200.00

106.67

4.44

0.099

111.21

5.00

33.59%

556.05

8,514.14

258.93

1,551.23

10,065.37

MARZO

1

24

3,200.00

106.67

4.44

0.099

111.21

5.00

33.59%

556.05

9,070.19

281.75

1,832.97

10,903.16

ABRIL

2

25

3,200.00

106.67

4.44

111.22

5.00

33.59%

556.11

9,626.30

305.20

2,138.17

11,764.47

2012 2012 2012 2012 2012 2012 2012 2012

MAYO

2

26

6,210.00

207.00

69.00

2.875

278.88

33.59%

0.00

9,626.30

0.00

2,138.17

JUNIO

2

27

6,210.00

207.00

69.00

2.875

278.88

JULIO

2

28

6,210.00

207.00

69.00

2.875

278.88

AGOSTO

2

29

6,210.00

207.00

69.00

2.875

278.88

SEPTIEMBRE

2

30

7,545.33

251.51

83.84

3.493

338.84

OCTUBRE

2

31

8,012.00

267.07

89.02

3.709

359.80

NOVIEMBRE

2

32

11,022.00

367.40

122.47

5.103

494.97

DICIEMBRE

2

33

11,782.00

392.73

130.91

5.455

529.10

2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013

ENERO

2

34

5,900.00

196.67

16.39

0.410

213.47

FEBRERO

2

35

5,900.00

196.67

16.39

0.410

MARZO

2

36

5,900.00

196.67

16.39

0.410

ABRIL

3

37

5,900.00

196.67

16.39

0.728

213.78

MAYO

3

38

6,200.00

206.67

17.22

0.765

224.65

JUNIO

3

39

6,200.00

206.67

17.22

0.765

224.65

JULIO

3

40

6,200.00

206.67

17.22

0.765

224.65

AGOSTO

3

41

6,200.00

206.67

17.22

0.765

SEPTIEMBRE

3

42

6,200.00

206.67

17.22

OCTUBRE

3

43

6,500.00

216.67

NOVIEMBRE

3

44

6,500.00

DICIEMBRE

3

45

2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014

ENERO

3

FEBRERO

3

MARZO

3

ABRIL

2015 2015 2015 2015 2015 2015 2015 2015

0.111 0.000

0.00 ARTIC.142 LOTT

0.00 0.00

2,138.17 11,764.47

33.59%

0.00

9,626.30

0.00

2,138.17

11,764.47

33.59%

4,183.13

13,809.43

329.31

2,467.48

16,276.91

33.59%

0.00

13,809.43

0.00

2,467.48

16,276.91

33.59%

0.00

13,809.43

0.00

2,467.48

16,276.91

33.59%

5,396.97

19,206.40

455.62

2,923.10

22,129.50

33.59%

0.00

19,206.40

0.00

2,923.10

22,129.50

33.59%

0.00

19,206.40

0.00

2,923.10

22,129.50

23.89%

3,201.98

22,408.38

440.56

3,363.66

25,772.04

213.47

23.89%

0.00

22,408.38

0.00

3,363.66

25,772.04

213.47

23.89%

0.00

22,408.38

0.00

3,363.66

25,772.04

15.00

23.89%

3,206.76

25,615.14

513.08

3,876.74

29,491.87

4.00

23.89%

898.62

26,513.76

587.13

4,463.87

30,977.62

23.89%

0.00

26,513.76

0.00

4,463.87

30,977.62

23.89%

3,369.81

29,883.57

616.71

5,080.58

34,964.15

224.65

23.89%

0.00

29,883.57

0.00

5,080.58

34,964.15

0.765

224.65

23.89%

0.00

29,883.57

0.00

5,080.58

34,964.15

18.06

0.802

235.52

23.89%

3,532.87

33,416.44

696.08

5,776.66

39,193.10

216.67

18.06

0.802

235.52

23.89%

0.00

33,416.44

780.27

6,556.93

39,973.37

6,500.00

216.67

18.06

0.802

235.52

23.89%

0.00

33,416.44

795.80

7,352.73

40,769.17

46

7,133.33

79.26

62.09

94.01

6.60

0.294

242.25

23.89%

3,633.80

37,050.24

811.65

8,164.38

45,214.62

47

6,933.33

77.04

60.35

94.01

6.42

0.285

238.10

23.89%

0.00

37,050.24

900.15

9,064.53

46,114.76

48

6,210.00

69.00

54.05

94.00

5.75

0.256

223.06

23.89%

0.00

37,050.24

918.07

9,982.60

47,032.83

4

49

6,876.67

76.41

59.85

94.00

6.37

0.283

236.90

15.00

23.89%

3,553.56

40,603.79

936.35

10,918.94

51,522.74

MAYO

4

50

7,730.00

85.89

67.28

94.00

7.16

0.318

254.64

6.00

23.89%

JUNIO

4

51

8,186.67

90.96

71.25

93.99

7.58

0.337

264.12

JULIO

4

52

7,963.33

88.48

69.31

94.00

7.37

0.328

259.49

AGOSTO

4

53

7,567.33

84.08

65.86

93.99

7.01

0.311

SEPTIEMBRE

4

54

7,110.67

79.01

62.05

94.24

6.58

OCTUBRE

4

55

6,667.33

74.08

58.18

94.24

NOVIEMBRE

4

56

6,210.00

69.00

54.19

DICIEMBRE

4

57

6,210.00

69.00

ENERO

4

58

6,210.00

FEBRERO

4

59

6,210.00

MARZO

4

60

6,210.00

ABRIL

5

61

MAYO

5

JUNIO

15.00

15.00

15.00

15.00

15.00

15.00

1,527.87

42,131.66

1,025.73

11,944.67

54,076.34

23.89%

0.00

42,131.66

1,076.57

13,021.24

55,152.91

23.89%

3,892.38

46,024.04

1,098.00

14,119.24

60,143.29

251.25

23.89%

0.00

46,024.04

1,197.35

15,316.60

61,340.64

0.293

242.18

23.89%

0.00

46,024.04

1,221.19

16,537.79

62,561.83

6.17

0.274

232.95

23.89%

3,494.27

49,518.32

1,245.50

17,783.29

67,301.61

94.24

5.75

0.256

223.44

23.89%

0.00

49,518.32

1,339.86

19,123.15

68,641.47

54.19

94.24

5.75

0.256

223.44

23.89%

0.00

49,518.32

1,366.54

20,489.69

70,008.01

51.75

54.19

125.66

4.31

0.192

236.10

23.89%

3,541.53

53,059.85

1,393.74

21,883.43

74,943.28

51.75

54.19

125.66

4.31

0.192

236.10

23.89%

0.00

53,059.85

1,492.00

23,375.43

76,435.28

51.75

54.19

125.66

4.31

0.192

236.10

23.89%

0.00

53,059.85

1,521.70

24,897.13

77,956.97

6,210.00

51.75

54.19

125.66

4.31

0.192

236.10

15.00

23.89%

3,541.53

56,601.38

1,551.99

26,449.12

83,050.50

62

7,545.33

62.88

65.85

125.67

5.24

0.233

259.87

8.00

23.89%

2,078.98

58,680.36

1,653.40

28,102.52

86,782.88

5

63

8,012.00

66.77

69.92

125.67

5.56

0.247

268.17

23.89%

0.00

58,680.36

1,727.70

29,830.22

88,510.58

JULIO

5

64

11,022.00

91.85

128.25

167.56

7.65

0.340

395.65

23.89%

5,934.75

64,615.12

1,762.10

31,592.32

96,207.43

AGOSTO

5

65

11,782.00

98.18

137.09

167.55

8.18

0.364

411.37

23.89%

0.00

64,615.12

1,915.33

33,507.65

98,122.76

PRESTACIONES ACUMULADAS PARA EL MOMENTO DEL RETIRO.

33,003.97

PRESTACIONES CALCULO DE LA RETROACTIVIDAD SALARIO DIARIO INTEGRAL DIAS A COBRAR POR AÑO. TOTAL DIAS A COBRAR TOTAL A COBRAR DIRENCIA ENTRE LOS CALCULOS

235.52 30 120 28,262.96 4,741.01

15.00

15.00

15.00

15.00