Download - IGV.xlsx
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 1/10
DETALLE 1 2 3 4 5
INGRESOS 160000 160000 160000 160000 180000EGRESOSMATERIA PRIMA 42372.9 42372.9 42372.9 42372.9 42372.9MANO DE OBRA 25000 25000 25000 25000 25000
ENERGIA 20000 20000 20000 20000 20000G ADM 10000 10000 10000 10000 10000G VTAS 4237.3 4237.3 4237.3 4237.3 4237.3UAD 58389.8 58389.8 58389.8 58389.8 78389.8DEPRECIACIÓN 46271.2 46271.2 46271.2 46271.2 0.0UDD 12118.6 12118.6 12118.6 12118.6 78389.8IR (30 %) 3635.6 3635.6 3635.6 3635.6 23516.9
UTILIDAD NETA 8483.1 8483.1 8483.1 8483.1 54872.9
% 5 5 5 5 30
DETALLE 0 1 2 3 4
INVERSIÓN 218400.0
INGRESOS 188800 188800 188800 188800
EGRESOS
MATERIA PRIMA 50000 50000 50000 50000
MANO DE OBRA 25000 25000 25000 25000
ENERGIA 23600 23600 23600 23600
G ADMIN 11800 11800 11800 11800G VTAS 5000 5000 5000 5000I.R (30%) 3635.6 3635.6 3635.6 3635.6
IGV 0.0 0.0 11715.3 15010.2
SALDO DE CAJA 218400.0 69764.4 69764.4 58049.2 54754.2
17761.4962951518
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 2/10
INVERSION
V VENTA IGV
MAQUINARIA 150000.0 27000.0
FLETES 5084.7 915.
OTROS 0000.0 5400.0
TOTAL 185084.7 15.
CREDITO FISCAL 15.
5
212400
50000
25000
23600
11800 IGV NETO 19525.4
500023516.9
18610.2
54872.9
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 3/10
V. TOTAL
177000.0
6000.0
5400.0
218400.0
DEPRECIACION 46271.2
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 4/10
ANALISIS DEL IGV
CREDITO FISCAL 15.254
A!O"1#
VENTAS V.VTA IGV V.TOTAL
160000 28800 188800
COMPRAS
V. COMPRA IGV C.TOTAL
M PRIMA 4272.88 7627.12 50000
ENERGIA 20000.00 600 2600
G. ADM 10000.00 1800 11800
G VTAS 427.29 762.7 5000
IGV COMP 1427.29 1789.8 16800
IGV NETO$IGV VENTAS%IGV COMPRAS
IGV NETO 15010.17
A PAGAR 0
SALDO DE CRED FISCAL 1805.08
IGV NETO"2# 15010.17
A PAGAR 0
SALDO CRED FISCAL 294.92
IGV NETO"# 15010.17
A PAGAR 11715.25
SALDO CRED FISCAL 0.00
IGV NETO"4# 15010.17
A PAGAR 15010.17
A!O"5#
VENTAS V.VTA IGV V.TOTAL
180000 2400 212400
COMPRAS
V. COMPRA IGV C.TOTAL
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 5/10
M PRIMA 4272.88 7627.12 50000
ENERGIA 20000.00 600 2600
G. ADM 10000.00 1800 11800
G VTAS 427.29 762.7 5000
IGV COMP 1427.29 1789.8 16800
IGV NETO 18610.17
A PAGAR 18610.17
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 6/10
DETALLE 1 2 3 4 5
INGRESOS 160000 184000 192000 192000 212000EGRESOSMATERIA PRIMA 42372.9 48728.8 50847.5 50847.5 50847.5MANO DE OBRA 25000 25000 25000 25000 25000ENERGIA 20000 23000 24000 24000 24000
G ADM 10000 10000 10000 10000 10000G VTAS 4237.3 4872.9 6355.9 6355.9 6355.9UAD 58389.8 72398.3 75796.6 75796.6 95796.6DEPRECIACIÓN 46271.2 46271.2 46271.2 46271.2 0.0UDD 12118.6 26127.1 29525.4 29525.4 95796.6IR (30 %) 3635.6 7838.1 8857.6 8857.6 28739.0
UTILIDAD NETA 8483.1 18289.0 20667.8 20667.8 67057.6
% 5 10 11 11 32
DETALLE 0 1 2 3 4
INVERSIÓN 218400.0
INGRESOS 188800 217120 226560 226560
EGRESOS
MATERIA PRIMA 50000 50000 50000 50000
MANO DE OBRA 25000 25000 25000 25000ENERGIA 23600 27140 28320 28320
G ADMIN 11800 11800 11800 11800G VTAS 5000 5750 6000 6000I.R (30%) 3635.6 7838.1 8857.6 8857.6
IGV 0.0 0.0 17598.8 18372.2
SALDO DE CAJA 218400.0 69764.4 89591.9 78983.6 78210.2
S&. 45'602.18
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 7/10
INVERSION
V VENTA IGV
MAQUINARIA 150000.0 27000.0
FLETES 5084.7 915.
OTROS 0000.0 5400.0
TOTAL 185084.7 15.
CREDITO FIS 15.
5
250160
50000
25000
28320
11800
600028739.0
21972.2
78328.8
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 8/10
V. TOTAL
177000.0
6000.0
5400.0
218400.0
DEPRECIACIO 46271.2
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 9/10
ANALISIS DEL IGV
CREDITO FISCAL 15.254
A!O"1#
VENTAS V.VTA IGV V.TOTAL
160000 28800 188800
COMPRAS
V. COMPRA IGV C.TOTAL
M PRIMA 4272.88 7627.12 50000
ENERGIA 20000.00 600 2600
G. ADM 10000.00 1800 11800
G VTAS 427.29 762.7 5000
IGV COMP 1427.29 1789.8 16800
IGV NETO$IGV VENTAS%IGV COMPRAS
IGV NETO 15010.17
A PAGAR 0
SALDO DE CRED FISCAL 1805.08
A!O"2#
VENTAS V.VTA IGV V.TOTAL
184000 120 217120
COMPRAS
V. COMPRA IGV C.TOTAL
M PRIMA 48728.81 8771.19 57500
ENERGIA 2000.00 4140 27140
G. ADM 10000.00 1800 11800
G VTAS 4872.88 877.1 5750
IGV COMP 14872.88 15588.1 17550
IGV NETO 1751.69
A PAGAR 0
SALDO CRED 77.9
A!O"#
VENTAS V.VTA IGV V.TOTAL
192000 4560 226560
7/23/2019 IGV.xlsx
http://slidepdf.com/reader/full/igvxlsx 10/10
COMPRAS
V. COMPRA IGV C.TOTAL
M PRIMA 50847.46 9152.54 60000
ENERGIA 24000.00 420 2820
G. ADM 10000.00 1800 11800
G VTAS 5084.75 915. 6000
IGV COMP 15084.75 16187.80 17800
IGV NETO"# 1872.20
A PAGAR 17598.81
SALDO CRED 0.00
IGV NETO"4# 1872.20
A PAGAR 1872.20
A!O"5#
VENTAS V.VTA IGV V.TOTAL
212000 8160 250160
COMPRAS
V. COMPRA IGV C.TOTAL
M PRIMA 50847.46 9152.54 60000
ENERGIA 24000.00 420 2820
G. ADM 10000.00 1800 11800
G VTAS 5084.75 915. 6000
IGV COMP 15084.75 16187.80 17800
IGV NETO 21972.20
A PAGAR 21972.20