calculo 5ta 2016.xlsx

3
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

Upload: sharun-cerna-berrios

Post on 13-Jul-2016

8 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: 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

Page 2: Calculo 5ta 2016.xlsx

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

Page 3: Calculo 5ta 2016.xlsx

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