calculo 5ta 2016.xlsx

TRABAJADOR :

DETALLE ENE FEB MAR ABR

REMUNERACION MENSUAL 3,800.00 3,800.00 3,800.00 3,800.00

N° Meses que faltan 12 11 10 9

REMUNERACION PROYECTADA 45,600.00 41,800.00 38,000.00 34,200.00

GRATIFICACION ORDINARIA

Julio 1,900.00 1,900.00 1,900.00 1,900.00

Diciembre 1,900.00 1,900.00 1,900.00 1,900.00

BONIFICACION POR GRATIFICACIÓN

Julio 171.00 171.00 171.00 171.00

Diciembre 171.00 171.00 171.00 171.00

REMUNERACIONES ANTERIORES 3,800.00 7,600.00 11,400.00

COMISIONES - ### - ###

RENTA ANUAL 49,742.00 49,742.00 49,742.00 49,742.00

(-) 7 UIT 3,950.00 -27,650.00 -27,650.00 -27,650.00 -27,650.00

RENTA NETA GLOBAL ANUAL 22,092.00 22,092.00 22,092.00 22,092.00

Hasta 5 UIT 8% 19,750.00 19,750.00 19,750.00 19,750.00 19,750.00

Hasta 20 UIT 14% 79,000.00 2,342.00 2,342.00 2,342.00 2,342.00

Hasta 35 UIT 17% 134,750.00 -

Hasta 45 UIT 20% 177,750.00 -

CALCULO RENTA POR ESCALA

Impuesto 1era Escala 1,580.00 1,580.00 1,580.00 1,580.00

Impuesto 2da Escala 327.88 327.88 327.88 327.88

IMPUESTO RESULTANTE 1,907.88 1,907.88 1,907.88 1,907.88

RETENCIONES - - - 476.97

IMPUESTO 1,907.88 1,907.88 1,907.88 1,430.91

N° de meses 12 12 12 9

RETENCION MENSUAL S/. 158.99 S/. 158.99 S/. 158.99 S/. 158.99

MAY JUN JUL AGO SET OCT NOV

3,800.00 3,800.00 3,800.00 3,800.00 3,800.00 3,800.00 3,800.00

8 7 6 5 4 3 2

30,400.00 26,600.00 22,800.00 19,000.00 15,200.00 11,400.00 7,600.00

1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00

1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00

171.00 171.00 171.00 171.00 171.00 171.00 171.00

171.00 171.00 171.00 171.00 171.00 171.00 171.00

15,200.00 19,000.00 22,800.00 26,600.00 30,400.00 34,200.00 38,000.00

-

49,742.00 49,742.00 49,742.00 49,742.00 49,742.00 49,742.00 49,742.00

-27,650.00 -27,650.00 -27,650.00 -27,650.00 -27,650.00 -27,650.00 -27,650.00

22,092.00 22,092.00 22,092.00 22,092.00 22,092.00 22,092.00 22,092.00

19,750.00 19,750.00 19,750.00 19,750.00 19,750.00 19,750.00 19,750.00

2,342.00 2,342.00 2,342.00 2,342.00 2,342.00 2,342.00 2,342.00

1,580.00 1,580.00 1,580.00 1,580.00 1,580.00 1,580.00 1,580.00

327.88 327.88 327.88 327.88 327.88 327.88 327.88

1,907.88 1,907.88 1,907.88 1,907.88 1,907.88 1,907.88 1,907.88

635.96 635.96 635.96 1,112.93 1,271.92 1,271.92 1,271.92

1,271.92 1,271.92 1,271.92 794.95 635.96 635.96 635.96

8 8 8 5 4 4 4

S/. 158.99 S/. 158.99 S/. 158.99 S/. 158.99 S/. 158.99 S/. 158.99 S/. 158.99

DIC

3,800.00

1

3,800.00

1,900.00

1,900.00

171.00

171.00

41,800.00

49,742.00

-27,650.00

22,092.00

19,750.00

2,342.00

1,580.00

327.88

1,907.88

1,748.89

158.99

1

S/. 158.99