FLUJO DE EFECTIVO

4/11/2024 24.7085
FLUJO EFECTIVO Jan-23 Feb-23
DETALLE Presupuestado Real Presupuestado
INGRESOS 1,005,127 1,008,857 1,005,127
Ingresos por Operación 1,005,127 1,008,857 1,005,127
Alquiler de Locales 594,992 595,288 594,992
Ingreso por Mantenimiento 139,544 157,888 139,544
Ingreso por Energía 122,067 107,659 122,067
Ingreso por Agua 21,380 33,146 21,380
Ingreso Valet Parking 14,751 1,704 14,751
Otros Ingresos
Ingreso por ISV 112,393 113,172 112,393

EGRESOS 991,310 947,273 969,512

Gastos de Personal 100,813 95,432 100,813
Sueldos y Salarios 83,489 81,606 83,489
Reserva Decimo cuarto mes 6,957 5,955 6,957
Reserva Decimo tercer mes 6,957 5,955 6,957
Horas extras 183 56 183
Vacaciones 0 0
Atenciones Empleados 1,410 100 1,410
IHSS 816 761 816
Combustible por Supervision 1,000 1,000 1,000
Indemnizaciones laborales
Servicios 306,734 279,573 306,734
Servicios de limpieza y fumigacion 3,450 3,450 3,450
Seguridad y vigilancia 25,300 25,300 25,300
Servicios administrativos 96,072 102,081 96,072
Asesorías Legales 10,899 11,367 10,899
Servicios Profesionales 4,500 4,500 4,500
Comunicaciones (Internet) 2,100 2,352 2,100
Energia electrica 114,554 82,466 114,554
Agua Potable (UMAPS) 2,435 1,962 2,435
Cisternas 26,913 26,000 26,913
Valet Parking 20,512 20,095 20,512

Suministros y mantenimiento 22,433 13,595 22,433

Supervisión de Mantenimiento 11,500 11,500 11,500
Mantenimiento de Edificio 8,000 1,525 8,000
Combustible generador 2,222 2,222
Papeleria y utiles 253 253
Materiales de Aseo y Limpieza 458 570 458

Marketing y Publicidad 14,520 17,290 14,520

Publicidad (Galeano/ Carlos Fraño) 14,520 17,290 14,520

Impuestos 96,000 92,614 96,000

AMDC / Volumen de Ventas
AMDC / Bienes Inmuebles
Impuesto Sobre la Ventas y Retencio 96,000 92,614 96,000
Impuesto Sobre la Renta y Activo Neto

Otros Gastos 8,488 7,666 8,488

Gastos Varios 8,488 7,666 8,488

Gastos Financieros 439,822 439,181 418,024

Préstamos $
Prestamos LPS 407,860 407,860 407,860
Comisión Bancaria 761 120 761
Seguro de Todo Riesgo 21,798 21,798
Extrafinanciamiento- Mini Cuotas 9,403 9,403 9,403

Gastos No Deducibles 2,500 1,922 2,500

Tasas de Seguridad 2,500 1,922 2,500

FLUJO DE CAJA MENSUAL 13,817 61,584 35,615

+ SALDO ANTERIOR 585,647 585,647 599,464

- REMANENTE O NECESIDAD DE 13,817 61,584 35,615
FLUJO DE CAJA ACUMULADO 599,464 647,231 635,078

Menos CxC de enero 322,744.36

Menos Pagos proveedores de diciembre 2022 270,492.09
Menos Pagos T/C de diciembre 2022 20,073.60
Menos préstamo Naaman Martinez 50,000.00
Mas cobros del periodo anterior 130,296.17
Mas cuentas por pagar enero 2023 331,236.64
445,453.54

Saldo en bancos 31-01-2023 444,935.55

517.99
Feb-23 Mar-23 Apr-23 May-23
Real Presupuestado Real Presupuestado Real Presupuestado
987,485 1,005,127 979,429 1,005,127 984,345 1,005,127
987,485 1,005,127 979,429 1,005,127 984,345 1,005,127
551,214 594,992 600,565 594,992 600,799 594,992
158,185 139,544 139,462 139,544 139,514 139,544
111,931 122,067 109,283 122,067 120,772 122,067
33,390 21,380 26,888 21,380 29,895 21,380
22,272 14,751 23,366 14,751 1,305 14,751
1,000
109,491 112,393 79,864 112,393 92,061 112,393

949,187 969,512 954,590 1,073,705 1,073,281 969,512

99,139 100,813 96,467 100,813 99,058 100,813
85,372 83,489 80,888 83,489 83,366 83,489
5,955 6,957 6,437 6,957 6,919 6,957
5,955 6,957 6,437 6,957 6,919 6,957
183 551 183 183
0 0 0
100 1,410 400 1,410 100 1,410
757 816 753 816 753 816
1,000 1,000 1,000 1,000 1,000 1,000

298,103 306,734 324,521 306,734 312,603 306,734

3,450 3,450 3,450 3,450 3,450 3,450
25,300 25,300 25,300 25,300 25,300 25,300
102,515 96,072 95,231 96,072 100,774 96,072
11,357 10,899 11,362 10,899 11,352 10,899
4,500 4,500 1,960 4,500 4,500
2,346 2,100 2,717 2,100 4,689 2,100
97,348 114,554 135,170 114,554 114,945 114,554
2,472 2,435 1,962 2,435 3,746 2,435
30,000 26,913 29,500 26,913 29,000 26,913
18,815 20,512 17,869 20,512 19,348 20,512

26,287 22,433 28,919 22,433 21,839 22,433

11,500 11,500 11,500 11,500 11,500 11,500
10,036 8,000 16,738 8,000 6,026 8,000
3,931 2,222 2,222 3,994 2,222
520 253 253 253
300 458 682 458 319 458

19,788 14,520 25,761 14,520 15,718 14,520

19,788 14,520 25,761 14,520 15,718 14,520

85,154 96,000 56,589 200,193 196,110 96,000

 85,154 96,000 56,589 96,000 70,825 96,000
104,193 125,284

0 8,488 2,635 8,488 0 8,488

0 8,488 2,635 8,488 8,488

417,679 418,024 417,444 418,024 417,383 418,024

407,860 407,860 407,860 407,860 407,860 407,860

416 761 182 761 120 761
0
9,403 9,403 9,403 9,403 9,403 9,403

3,036 2,500 2,253 2,500 10,571 2,500

3,036 2,500 2,253 2,500 10,571 2,500

38,298 35,615 24,838 -68,579 -88,936 35,615

647,231 635,078 685,529 670,693 710,367 602,114

38,298 35,615 24,838 -68,579 -88,936 35,615
685,529 670,693 710,367 602,114 621,431 637,729

8032.1285140562
 FLUJO DE EFECTIVO

May-23 Jun-23 Jul-23 Aug-23

Presupuesta
Real Presupuestado Real do Real Presupuestado
1,029,706 1,005,127 1,036,727 1,005,127 1,005,289 1,005,127
1,029,706 1,005,127 1,036,727 1,005,127 1,005,289 1,005,127
603,580 594,992 604,130 594,992 604,519 594,992
139,358 139,544 139,484 139,544 139,575 139,544
133,806 122,067 137,058 122,067 135,070 122,067
29,794 21,380 32,948 21,380 29,336 21,380
3,914 14,751 20,957 14,751 1,304 14,751

119,256 112,393 102,150 112,393 95,485 112,393

970,968 990,109 1,008,536 960,109 937,972 1,076,749

100,207 100,813 109,233 100,813 106,155 100,813
82,602 83,489 82,602 83,489 82,602 83,489
6,919 6,957 12,148 6,957 6,919 6,957
6,919 6,957 6,919 6,957 6,919 6,957
697 183 1,004 183 1,045 183
0 3527.45 0 5,696 0
196 1,410 525 1,410 467 1,410
1,873 816 1506.86 816 1,507 816
1,000 1,000 1000 1,000 1,000 1,000

337,379 336,734 355,757 306,734 318,350 306,734

3,450 3,450 10,450 3,450 3,450 3,450
25,300 25,300 25,300 25,300 25,300 25,300
109,586 96,072 97,759 96,072 106,908 96,072
11,354 10,899 11,371 10,899 11,369 10,899
34,500 11,064 4,500 - 4,500
2,462 2,100 2,466 2,100 2,466 2,100
128,050 114,554 127,794 114,554 120,760 114,554
626 2,435 1,962 2,435 2,326 2,435
35,000 26,913 41,200 26,913 26,400 26,913
21,550 20,512 26,390 20,512 19,371 20,512

19,499 22,433 29,992 22,433 15,362 22,433

11,500 11,500 11,500 11,500 11,500 11,500
3,250 8,000 14,398 8,000 1,664 8,000
3,557 2,222 3,277 2,222 - 2,222
495 253 253 1,661 253
697 458 816.95 458 537 458

8,745 14,520 6,250 14,520 12,403 14,520

8,745 14,520 6250 14,520 12,403 14,520

81,750 96,000 93,841 96,000 74,726 96,000

 81,750 96,000 93,841 96,000 74,726 96,000

0 8,488 200 8,488 - 8,488

8,488 200 8,488 - 8,488

421,084 408,621 407,980 408,621 408,227 525,261

407,860 407,860 407,860 407,860 407,860 502,702

3,821 761 120 761 367 761
21,798
9,403

2,306 2,500 5,284 2,500 2,748 2,500

2,306 2,500 5,284 2,500 2,748 2,500

58,738 15,018 28,191 45,018 67,317 -71,623

621,431 637,729 680,170 652,746 708,360 697,764

58,738 15,018 28,191 45,018 67,317 -71,623
680,170 652,746 708,360 697,764 775,678 626,141
Aug-23 Sep-23 Oct-23
Real Presupuestado Real Presupuestado Real
1,037,234 1,005,127 1,073,060 1,005,127 994,138
1,037,234 1,005,127 1,073,060 1,005,127 994,138
601,854 594,992 601,854 594,992 599,510
139,482 139,544 139,678 139,544 139,865
145,368 122,067 160,490 122,067 132,920
36,801 21,380 37,531 21,380 32,532
3,689 14,751 30,552 14,751 1,260
2,150
110,041 112,393 100,806 112,393 88,051

1,068,064 1,076,749 995,314 1,076,749 940,612

100,557 100,813 101,288 100,813 160,229
82,602 83,489 82,974 83,489 82,602
6,919 6,957 6,919 6,957 6,776
6,919 6,957 6,919 6,957 6,651
1,393 183 1,741 183 2,299
0 0
216 1,410 228 1,410 450
1507 816 1506.86 816 1,507
1000 1,000 1000 1,000 1,000
58,944
321,017 306,734 325,066 306,734 217,595
3,450 3,450 3,450 3,450 3,450
25,300 25,300 25,300 25,300 25,300
95,254 96,072 96,246 96,072 104,312
11,373 10,899 11,383 10,899 11,398
0 4,500 0 4,500
2,347 2,100 2,349 2,100 2,353
135,520 114,554 124,125 114,554 -
2,363 2,435 1,210 2,435 -
26,000 26,913 41,000 26,913 32,000
19,410 20,512 20,002 20,512 19,392

20,398 22,433 37,079 22,433 32,992

11,500 11,500 11,500 11,500 11,500
5,194 8,000 11,966 8,000 16,741
3,234 2,222 12,519 2,222 4,544
- 253 - 253
470 458 1,095 458 207

3,376 14,520 3,310 14,520 1,728

3,376 14,520 3,310 14,520 1,728

70,375 96,000 0 96,000 0

 70,375 96,000 96,000

5,300 8,488 0 8,488 270

5,300 8,488 8,488 270

544,946 525,261 526,392 525,261 525,214

502,702 502,702 502,702 502,702 502,744

120 761 1310 761 90
42,124 21,798 22,380 21,798 22,380

2,096 2,500 2,178 2,500 2,584

2,096 2,500 2,178 2,500 2,584

-30,830 -71,623 77,746 -71,623 53,526

775,678 626,141 744,848 554,519 822,594

-30,830 -71,623 77,746 -71,623 53,526
744,848 554,519 822,594 482,896 876,120
 Nov-23 Dec-23 TOTAL
Presupuestado Real Presupuestado Real Presupuestado
1,005,127 - 1,005,127 - 13,066,647
1,005,127 0 1,005,127 0 13,066,647
594,992 594,992 7,734,893
139,544 139,544 1,814,072
122,067 122,067 1,586,869
21,380 21,380 277,937
14,751 14,751 191,766
0
112,393 0 112,393 0 1,461,110
0
1,076,749 0 1,076,749 0 13,277,029
100,813 0 100,813 0 1,310,568
83,489 83,489 1,085,358
6,957 6,957 90,446
6,957 6,957 90,446
183 183 2,373
0 0 0
1,410 1,410 18,330
816 816 10,614
1,000 1,000 13,000
0
306,734 0 306,734 0 4,017,544
3,450 3,450 44,850
25,300 25,300 328,900
96,072 96,072 1,248,937
10,899 10,899 141,692
4,500 4,500 88,500
2,100 2,100 27,300
114,554 114,554 1,489,198
2,435 2,435 31,652
26,913 26,913 349,863
20,512 20,512 266,652
0
22,433 0 22,433 0 291,634
11,500 11,500 149,500
8,000 8,000 104,000
2,222 2,222 28,884
253 253 3,291
458 458 5,960
0
14,520 0 14,520 0 188,760
14,520 14,520 188,760
0
96,000 0 96,000 0 1,352,193
 0
0
96,000 96,000 1,248,000
104,193
0
8,488 - 8,488 - 110,344
8,488 8,488 110,344
0
525,261 0 525,261 0 5,973,485
0
502,702 502,702 5,776,386
761 761 9,893
21,798 21,798 130,788
56,418
0
2,500 - 2,500 - 32,500
2,500 2,500 32,500
0
-71,623 - -71,623 - -210,382

482,896 876,120 411,273 876,120 339,650

-71,623 - -71,623 - -210,382
411,273 876,120 339,650 876,120 129,269
- 574,551.84
65,904.12
- 508,647.72
298,265.72
TOTAL
Real
11,165,977
11,165,977
6,566,891
1,571,848
1,428,162
352,056
114,237
3,150
1,129,633
0
10,816,765
1,167,970
909,818
78,787
73,433
9,482
9,223
2,978
14,305
11,000
58,944
3,427,343
44,950
278,300
1,120,251
125,039
22,024
29,009
1,194,229
19,256
351,100
223,791
0
265,461
126,500
90,787
38,614
3,170
6,390
0
123,114
123,114
0
832,909
 0
0
707,625
125,284
0
16,071
16,071
0
4,946,612
0
4,771,024
10,488
108,682
56,418
0
37,284
37,284
0
349,212

876,120
349,212
1,225,332

6032423.64
5,776,386
256,037.79 42,227.93