codigo cliente importe sucursal fecha de comnumero de cuotas importede cuotas
1a $ 1,005.00 NORTE 14-Jun 3 $ 3,015.00
2b $ 1,006.00 CENTRO 15-Jun 3 $ 3,018.00
8c $ 1,009.00 NORTE 16-Jun 6 $ 6,054.00
9d $ 1,112.00 NORTE 17-Jun 3 $ 3,336.00
7e $ 1,520.00 NORTE 18-Jun 6 $ 9,120.00
6f $ 1,110.00 CENTRO 19-Jun 3 $ 3,330.00
5g $ 1,420.00 CENTRO 20-Jun 3 $ 4,260.00
4h $ 1,630.00 CENTRO 21-Jun 3 $ 4,890.00
3y $ 1,910.00 CENTRO 22-Jun 6 $ 11,460.00
10 j $ 1,780.00 CENTRO 23-Jun 6 $ 10,680.00
TOTAL $ 59,163.00
PROMEDIO $ 5,916.30
MAX $ 11,460.00
MIN $ 3,015.00
codigo cliente SUCURSAL
1a NORTE
2b CENTRO
8c CENTRO
9d NORTE
7e NORTE
6f NORTE
5g CENTRO
4h CENTRO
3y NORTE
10 j CENTRO
recargo por cuotas por pesos subtotal iva total apagar
301.5 3,316.50 53064% 3,847.14
301.8 3,319.80 53117% 3,850.97
1210.8 7,264.80 116237% 8,427.17
333.6 3,669.60 58714% 4,256.74
1824 10,944.00 175104% 12,695.04
333 3,663.00 58608% 4,249.08
426 4,686.00 74976% 5,435.76
489 5,379.00 86064% 6,239.64
2292 13,752.00 220032% 15,952.32
2136 12,816.00 205056% 14,866.56
$ 9,647.70 $ 68,810.70 $11,009.71 $ 79,820.41
$ 964.77 $ 6,881.07 $ 1,100.97 $ 7,982.04
$ 2,292.00 $ 13,752.00 $ 2,200.32 $ 15,952.32
$ 301.50 $ 3,316.50 $ 530.64 $ 3,847.14
variables norte y centro
recargo si lor recargos son en 3 cuotas el recargo sera de
10%
si es en 6 sera de 20%
iva 16%
=BUSCARV(FA2 & "-" & G1, C:D, 2, FALSE)
DEUDAS Y RECARGOS
DEUDA ABONO PARCIAL PLAZO FECHA DE COMPRA
25,600,000.00 4,500,000.00 21,100,000.00 30 7/6/2024
785,000,000.0 6,200,000.00 778,800,000.00 30 7/7/2024
5,230,000,000.0 52,300,000.00 5,177,700,000.00 30 7/8/2024
2,800,000,000.0 14,000,000.00 2,786,000,000.00 30 7/9/2024
6,500,000,000.0 3,800,000.00 6,496,200,000.00 30 7/10/2024
945,000,000.0 4,250,000.00 940,750,000.00 30 7/11/2024
450,000,000.0 28,700,000.00 421,300,000.00 30 7/12/2024
3,240,000,000.0 26,250,000.00 3,213,750,000.00 30 8/12/2024
1,300,000,000.0 8,900,000.00 1,291,100,000.00 30 8/13/2024
2,350,000,000.0 1,425,000.00 2,348,575,000.00 30 8/14/2024
2,380,000,000.0 17,400,000.00 2,362,600,000.00 30 8/15/2024
750,000,000.0 5,260,000.00 744,740,000.00 30 8/16/2024
8,400,000,000.0 65,800,000.00 8,334,200,000.00 30 9/18/2024
1,750,000,000.0 9,600,000.00 1,740,400,000.00 30 9/19/2024
6,080,000,000.0 4,150,000.00 6,075,850,000.00 30 9/20/2024
4,100,000,000.0 2,900,000.00 4,097,100,000.00 30 9/21/2024
JULIO - AGOSTO - SEPTIEMBRE
CARGOS
fecha de pago demora RECARGO
7/8/2024 2 332,800.00
7/9/2024 2 10,205,000.00
7/11/2024 3 67,990,000.00
7/15/2024 6 36,400,000.00
7/13/2024 3 84,500,000.00
7/16/2024 5 12,285,000.00
7/18/2024 6 5,850,000.00
8/19/2024 7 42,120,000.00
8/14/2024 1 16,900,000.00
8/15/2024 1 30,550,000.00
8/17/2024 2 30,940,000.00
8/18/2024 2 9,750,000.00
9/20/2024 2 109,200,000.00
9/22/2024 3 22,750,000.00
9/24/2024 4 79,040,000.00
9/28/2024 7 53,300,000.00
TO - SEPTIEMBRE
INTERESES BANCARIOS
PRESTAMOS BANCO INTERESES
100,000 BANCOMER 127,000
450,000 BANAMEX 1,071,000
6,540,000 BANAMEX 11,052,600
789,000 BANCOMER 1,215,060
5,000 BANCOMER 17,150
12,000 BANCOMER 28,200
961,000 BANAMEX 2,950,270
562,000 BANAMEX 1,337,560
489,000 BANCOMER 8,557,500
652,000 BANCOMER 2,236,360
999,000 BANAMEX 1,228,770
#REF!
Columna1 Columna2 Columna3 Columna4
INTERES MESES
100,000 BANCOMER 27% 1
450,000 BANAMEX 23% 6
6,540,000 BANAMEX 23% 3
789,000 BANCOMER 27% 2
5,000 BANCOMER 27% 9
12,000 BANCOMER 27% 5
961,000 BANAMEX 23% 9
562,000 BANAMEX 23% 6
489,000 BANCOMER 275% 6
652,000 BANCOMER 27% 9
999,000 BANAMEX 23% 1
SI EL BANCO ES BANCOMER EL INTERES DEL 27% , DE
LO CONTRARIO SERA 23%
BANAMEX 23%
SUBCIDIO DE TRANSPORTE
BASICO MONETARIO
6,258,655.00 DERECHO
910,591.00 NO DERECHO
8,851,733.00 DERECHO
7,708,234.00 DERECHO
5,532,772.00 DERECHO
4,555,307.00 DERECHO
5,152,936.00 DERECHO
7,564,012.00 DERECHO
5,446,004.00 DERECHO SI GANA MENOS DE - $923,000
6,332,012.00 DERECHO CONTRARIO NO TIENE DERECHO
9,731,369.00 DERECHO
2,441,113.00 DERECHO
CANTIDADES DE 500 DEN ADEL
=SI(A5>=923.000,"DERECHO A
923,000
A MENOS DE - $923,000 EL RESULTADO SER A DERECHO ATRANSPORTE DE LO
ARIO NO TIENE DERECHO A TRANSPORTE ("")
ADES DE 500 DEN ADELANTE , ABARCAR F, SI
>=923.000,"DERECHO A TRANSPORTE","NO DERECHO A TRANSPORTE")
Recargo de boletas
NOMBRES EDADES VALOR BOLETA
Sofía 25 años $600
Francisco 24 años $600
Valentina 19 años $600
Alejandro 23 años $600
Camila 22 años $600
Daniel 21 años $600
Laura 20 años $600
Fernando 25 años $600
María 24 años $600
Martín 22 años $600
VALOR BOLETA
18 $450 MENORES DE 18 , $450
MAYOR 18 $600 PARA LOS DEMAS EN $600 MAYOR
=SI(A4>$E$17;"DERECHO";SI(A4<$
DERECHO"))
ALOR BOLETA
MENORES DE 18 , $450
RA LOS DEMAS EN $600 MAYORES DE 18
I(A4>$E$17;"DERECHO";SI(A4<$E$17;"NO
ERECHO"))
