INTERESES

5,400,000,000
Días Capital Intereses
1 1-30 15,000,000.00 250,000 450,000,000.00
2 31-60 15,000,000.00 250,000 450,000,000.00
3 61-90 15,000,000.00 250,000 450,000,000.00
4 91-120 15,000,000.00 250,000 450,000,000.00
5 121-150 15,000,000.00 250,000 450,000,000.00
6 151-180 15,000,000.00 250,000 450,000,000.00
7 181-210 15,000,000.00 250,000 450,000,000.00
8 211-240 15,000,000.00 250,000 450,000,000.00
9 241-270 15,000,000.00 250,000 450,000,000.00
10 271-300 15,000,000.00 250,000 450,000,000.00
11 301-330 15,000,000.00 250,000 450,000,000.00
12 331-360 15,000,000.00 250,000 450,000,000.00
1 3,000,000.0 5,400,000,000.00
2
3 #DIV/0! (/) 360
4 (=)SPDI 15,000,000.00
5 (*) Factor 0.06770
6 (=)Ajuste por inflación 1,015,500.00
15,000,000 Intereses que cobro -
360 Interes real Acumulable - 1,015,500.00
5,400,000,000 Perdida Inflacionaria
Retención 36,000,000.00

Tasa efectiva -3545.05%

33.56%
3578.61%
 Retencion 20%
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
3,000,000.00 12,000,000.00
36,000,000.00 180000000 144,000,000.00

NOV 125.9970
Ene 118.0020
1.0677
1
0.0677
-3545.052%

Dec-22
Dec-21
 periodo CAPITAL INTERES
450,000,000.00 1 1-30 $ 15,000,000 $ 250,000
456,000,000.00 2 31-60 $ 15,200,000 $ 253,333
462,080,000.00 3 61-90 $ 15,402,667 $ 256,711
468,241,066.67 4 91-120 $ 15,608,036 $ 260,134
474,484,280.89 5 121-150 $ 15,816,143 $ 263,602
480,810,737.97 6 151-180 $ 16,027,025 $ 267,117
487,221,547.81 7 181-210 $ 16,240,718 $ 270,679
493,717,835.11 8 211-240 $ 16,457,261 $ 274,288
500,300,739.58 9 241-270 $ 16,676,691 $ 277,945
506,971,416.11 10 271-300 $ 16,899,047 $ 281,651
513,731,034.99 11 301-330 $ 17,124,368 $ 285,406
520,580,782.12 12 331-360 $ 17,352,693 $ 289,212
5,814,139,441.24 $ 18,230,077 $ 3,230,077
360 $ 0.18
16,150,387.34

#DIV/0!

(=)Ajuste por infl

Intereses que
Interes real Acum
 SPDI RETENCION
$ 450,000,000 $ 50,000 $ 200,000
$ 456,000,000 $ 50,667 $ 202,667 NOV
INPC
$ 462,080,000 $ 51,342 $ 205,369 ENE
$ 468,241,067 $ 52,027 $ 208,107
$ 474,484,281 $ 52,720 $ 210,882 SPDI
$ 480,810,738 $ 53,423 $ 213,694 (*) INPC
$ 487,221,548 $ 54,136 $ 216,543 (=) Ajuste x inflación
$ 493,717,835 $ 54,858 $ 219,430
$ 500,300,740 $ 55,589 $ 222,356 Interes cobrado
$ 506,971,416 $ 56,330 $ 225,321 (-) ajuste x inflación
$ 513,731,035 $ 57,081 $ 228,325 (=) Interes Real
$ 520,580,782 $ 57,842 $ 231,369
$ 5,814,139,441 $ 646,015

5,814,139,441
(/) 360
(=)SPDI 16,150,387.34
(*) Factor 0.0677 NOV 125.997
(=)Ajuste por inflación 1,093,381.22 Ene 118.002
Intereses que cobro 3,230,077.47 1.0677
Interes real Acumulable 2,136,696.24 747,843.69 1
0.0677
Retención 646,015.49 30.23% 2,136,696.24
0.34
Inter 30.23% 726,476.72
PAGANDO 33.56% ANTICPO $ 646,015.49
3.32% $ 80,461.2

Intereses BANCARIOS
2023
100,000,000.00
INFLACIÓN 6.7700%
RETENCIÓN 0.15%
Tasa de Interes 11.25%

intereses 11,250,000
retención 150,000
Ajuste por Inflación 6,770,000

Interes Acumulable 4,480,000

 Interes Acumulable
Prestamo Normal - 1,015,500.00
Prestamo Capitalizable 2,136,696.24
Total Base Gravable 1,121,196.24

Inversión Bancario 4,480,000

Inversión Bancario 6,720,000
Interes Real Acumulable 12,321,196.24

0.35
4,312,418.69
 150
-1 0.48221344
101.2

$ 16,150,387
0.4822
flación $ 7,787,934

brado $ 3,230,077
flación $ 7,787,934
al - 4,557,856.35

int 3,230,077.47
RETN $ 646,015.49
ISR EJE $ 80,461.2
$ 2,503,600.74
15,000,000.00
17,503,600.74

ses BANCARIOS
2022
150,000,000.00
6.7700%
0.15%
11.25%

16,875,000
225,000
10,155,000

6,720,000
Retenciones
36,000,000.00 -3545.05%
646,015.49 30.23%
36,646,015.49 3268.47%

150,000 3.35%
225,000 3.35%
37,021,015.49 300.47%

37,021,015.49 - 32,708,596.81 - 2.6547

Por Pagar en la Anual
0.35
30 1 ene 1 2 3 4 5 6
30 2 feb. 1 2 3 4 5 6
30 3 mar. 1 2 3 4 5 6
30 4 abr. 1 2 3 4 5 6
30 5 may. 1 2 3 4 5 6
30 6 jun. 1 2 3 4 5 6
30 7 jul. 1 2 3 4 5 6
30 8 ago. 1 2 3 4 5 6
30 9 sep. 1 2 3 4 5 6
30 10 oct. 1 2 3 4 5 6
30 11 nov. 1 2 3 4 5 6
30 12 dic. 1 2 3 4 5 6

mzo 3M 3,000,000 retención cuando APLIC

 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

retención cuando APLICA? 20 Ó 21

27 28 29 30 31
27 28
27 28 29 30 31
27 28 29 30
27 28 29 30 31
27 28 29 30
27 28 29 30 31
27 28 29 30 31
27 28 29 30
27 28 29 30 31
27 28 29 30
27 28 29 30 31