Download - 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