Flujo de Caja Ferremaule

Caja año 2024 [42]

ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Total ingresos 7,490,500 6,866,000 4,840,000 5,037,000 2,650,000 2,650,000 2,650,000 2,650,000 1,200,000 1,200,000 1,200,000 1,200,000 39,633,500 3,302,792
Total gastos 2,445,000 2,295,000 2,485,000 2,485,000 2,445,000 2,445,000 2,445,000 2,445,000 2,445,000 2,445,000 2,445,000 2,445,000 29,270,000 2,439,167
Caja neta 5,045,500 4,571,000 2,355,000 2,552,000 205,000 205,000 205,000 205,000 (1,245,000) (1,245,000) (1,245,000) (1,245,000) 10,363,500 863,625
Caja proyectada 5,045,500 9,616,500 11,971,500 14,523,500 14,728,500 14,933,500 15,138,500 15,343,500 14,098,500 12,853,500 11,608,500 10,363,500

Ingresos ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Ventas 6,090,500 5,466,000 2,890,000 5,085,000 19,531,500 1,627,625
Cuentas por cobrar 700,000 700,000 700,000 700,000 700,000 700,000 700,000 700,000 700,000 6,300,000 525,000
sueldo 1,400,000 1,400,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 11,500,000 958,333
arrendatario 0 0 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 5,000,000 416,667
0 0
0 0
0 0
Total Ingresos 7,490,500 6,866,000 4,840,000 7,735,000 2,650,000 2,650,000 2,650,000 2,650,000 1,200,000 1,200,000 1,200,000 1,200,000 42,331,500 3,527,625

Gastos casa ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Arriendos 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 180,000 2,160,000 180,000
Seguro casa 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 600,000 50,000
aseo tia 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 960,000 80,000
Gas 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 10,000
Agua y luz 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 180,000 15,000
Telefono 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 300,000 25,000
Internet 0 0
Ropa niños 0 0
perra 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000 30,000
C 0 0
D 0 0
E 0 0
F 0 0
Total Gastos casa 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 390,000 4,680,000 390,000

Transporte ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Cuota auto 0 0
Seguro 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 600,000 50,000
Petroleo 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 6,000,000 500,000
Mantenciones 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 600,000 50,000
Repuestos 0 0
Tags y peajes 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 480,000 40,000
B 0 0
Total Transporte 640,000 640,000 640,000 640,000 640,000 640,000 640,000 640,000 640,000 640,000 640,000 640,000 7,680,000 640,000

Salud ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Seguros 0 0
Isapre 0 0
Remedios 0 0
A 0 0
B 0 0
C 0 0
D 0 0
Total Salud 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Prestamos familia ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Donaciones 0 0
0 0
0 0
0 0
Total Prestamos familia 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Gastos personales ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Mercado 0 0
Aseo 0 0
Ropa 0 0
Colegio niños 0 0
Salidas a comer 0 0
Peluqueria 0 0
Comida hosteria 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 900,000 75,000
Aseo 0 0
Otros 0 0
Total Gastos personales 0 0 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 900,000 75,000

Tiempo libre ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Netflix 0 0
Cerveza 0 0
Juegos niños 0 0
Salida Leito 0 0
Salidas Joaquin 0 0
A 0 0
B 0 0
C 0 0
D 0 0
E 0 0
F 0 0
G 0 0
H 0 0
I 0 0
Total Tiempo libre 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Ahorros ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Fondo emergencia 0 0
Inversiones 0 0
A 0 0
B 0 0
C 0 0
D 0 0
Total Ahorros 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Obligaciones ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Pension alimenticia 410,000 410,000 410,000 410,000 410,000 410,000 410,000 410,000 410,000 410,000 410,000 410,000 4,920,000 410,000
Credito banco estado 230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 2,760,000 230,000
Credito bco Chile 325,000 325,000 325,000 325,000 325,000 325,000 325,000 325,000 325,000 325,000 325,000 325,000 3,900,000 325,000
Tarjeta crédito 450,000 300,000 400,000 400,000 360,000 360,000 360,000 360,000 360,000 360,000 360,000 360,000 4,430,000 369,167
Tarjeta 2 0 0
A 0 0
B 0 0
Total Obligaciones 1,415,000 1,265,000 1,365,000 1,365,000 1,325,000 1,325,000 1,325,000 1,325,000 1,325,000 1,325,000 1,325,000 1,325,000 16,010,000 1,334,167

Inventario ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
Quincalleria 0 0
Ropa 0 0
Puertas 0 0
Pinturas 0 0
Total Inventario 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Otros ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC Total Prom
A 0 0
B 0 0
C 0 0
D 0 0
Total Otros 0 0 0 0 0 0 0 0 0 0 0 0 0 0
 ventas

Mar-23 Feb-23
1,400,000 60,000 1,050,000 10,000 200,000
140,000 60,000 146,000 130,000 100,000
125,000 80,000 188,000 115,000 186,000
55,000 490,000 48,000 310,000 500,000
70,000 100,000 672,000 300,000 3,950,000
155,000 202,000 223,000 129,000 70,000
175,000 620,000 90,000 150,000 400,000
210,000 155,000 90,000
2,000,000 400,000 70,000 6,550,000

935,000
174,000 538,000 28,000
Total ### Total 6,550,000

Feb-24
Ejemplo 187,000 160,000 950,000
230,000 100,000 100,000
Numero Concepto Monto 156,000 677,000 10,000
Venta 1 1,400,000 2,620,500 60,000 191,000
Venta 2 140,000 25,000
Venta 3 125,000
Venta 4 55,000
Venta 5 70,000
Venta 6 155,000 5,466,500
Venta 7 175,000
Venta 8 210,000 Marzo 03/2024
Venta 9 2,000,000 480,000 125,000 185,000
Venta 10 60,000 310,000 470,000 186,000
Venta 11 60,000 157,000 316,000 306,000
Venta 12 80,000 286,000 69,000
Venta 13 490,000
Venta 14 100,000
Venta 15 202,000
Venta 16 620,000
Venta 17 155,000 2,890,000
Venta 18 400,000
Venta 19 1,050,000
Venta 20 146,000
Venta 21 188,000
Venta 22 48,000
Venta 23 672,000
Venta 24 223,000
Venta 25 90,000
Venta 26 90,000
Venta 27 70,000
 Jan-23
220,000 170,000
330,000 1,740,000
240,000 265,000
255,000 101,000
56,000 825,000
350,000
250,000

4,802,000

Total 9,604,000

Jan-24

2,620,500 69,000 68,000

570,000 225,000
853,000
207,000 448,000
199,000 376,000
165,000 290,000

6,090,500 277,000

ABRIL 04/2024
102,000 380,000 77,000
377,000 252,000 230,000
110,000 168,000 108,000
193,000 375,000 183,000
30,000 280,000 200,000
92,000 282,000 35,000
480,000 48,000 400,000
359,000 218,000 106,000
5,085,000
 Inversión

Fecha Detalle inventario Monto compra stock,

unidades

Odis 9,670,066
febrero Stretto 4,000,000
febrero Odis bisagras 6,330,263
febrero Odis chapas 6,900,000
abril Odis 206 negra colonial 300,000
abril Sercogas 1,000,000
mayo Puertas 1,820,000
mayo Focos solares
mayo Odis Trancura
mayo servicios 1,550,000
Marzo 10 marcos 90 mm 80,000
Marzo terciado primera 70cm 364,000
2 puertas Lenga 90cm 160,000
2 puertas cocina 90 120,000
tinetas pintura 2,000,000
otras pinturas 2,000,000

ConLuz debe10 caj 600.000

Total inventario, $ 36,294,329

inversión con Luz 15de20

Total inversión 36,294,329

Préstamos
En mercadería 7.4
Inventario final, $ 36,294,329

bisagras 3900 pares 1,139,000

30 inalambricas
20 total percutor

TOTAL 1,139,000
Precio
unitario real, Unidades Disponibles vendido haberes
vendidas
$/unidad

0
0
0
0
0
0
0
0
Enero
Febrero
Marzo
Abril
Mayo
Fecha : 20-07-22
FERREMAULE SPA
RUT: 77.299.501-7
Rauco Calle1 nro 4
Fono: +56982896460
Email: luis.olivares@ferremaule.cl

ESTIMADO: Joel Fabián Parra

rut :
fono:
direccion:

PRODUCTO CANTIDAD VALOR TOTAL

esmalte al agua 1/4 galón 105 $ 3,990 $ 418,950
galones 4lts esmalte al agua 10 $ 13,000 $ 130,000
galones chicos esmalte sintético vendidos 36
calzado seguridad 30 $ 28,990 $ 869,700
caja bisagras 3"Odis 34 $ 60,000 $ 2,040,000
llave monomando Roma 64 $ 5,500 $ 352,000
50 proyectores led 30w byp 10 $ 3,500 $ 35,000
proyector led sensor mov 30w by 9 $ 8,000 $ 72,000
huinchas 50 $ 2,500 $ 125,000
alargadores $ 5,190 $0
chapa odis baño segunda 47 $ 4,500 $ 211,500
Chapa Odis dormitorio inox 96 $ 5,900 $ 566,400
chapa oister cilindrica 444 $ 4,990 $ 2,215,560
dushy 16 $ 6,000 $ 96,000
ampolletas philips 3 escenas $ 2,000 $ 0 23 vendidas
galones tinta madera caoba 0 $ 3,000 $0
Chapa colonial acceso Trancura 1 $ 29,990 $ 29,990
chapa colonial acceso Odis 3 $ 36,990 $ 110,970
perillones odis 10 $ 4,500 $ 45,000
candado Odis 60 mm 96 $ 5,000 $ 480,000
candado Odis 50 mm 96 $ 3,500 $ 336,000
candado Odis 40 mm 12 $ 2,500 $ 30,000
candado Odis 30 mm 46 $ 2,500 $ 115,000
llaves tina ducha stretto 15 $ 18,990 $ 284,850
ampolletas 11w byp 64 $ 900 $ 57,600
calefont 7 lts 2 $ 109,990 $ 219,980
calefont 13 lts 4 $ 169,990 $ 679,960
cable electrico eva 1.5 1 $ 15,000 $ 15,000
generadores 1150w 3 $ 139,990 $ 419,970
servicios tramontina 28 $ 11,990 $ 335,720
dushy monomando 5 $ 6,000 $ 30,000
dushy combinación lavaplatos 18 $ 6,500 $ 117,000 10 vendidos
tramontina servicios 70 $ 11,990 $ 839,300
chapas odis colonial negras 5 $ 36,990 $ 184,950
flexible de gas Stretto 100 $ 5,490 $ 549,000
32 manerales stretto 32 $ 4,590 $ 146,880

VALIDO X 7 DIAS TOTAL $ 12,159,280

RAZON SOCIAL: FERREMAULE SpA

Banco Chile
Cuenta corriente
Cuenta Nº: 2080959500
Rut:77.299.501-6
Correo: luis.olivares@ferremaule.cl
4 cajas de chapas de 24 unidades c/u se retiran
5 chapas oister Trancura
alex carrito wc+jeans+behr +62 21,000 Haberes
pilar 5,000 visa Chile
linea estado
berny martin 44,000 linea Chile
sacarina 35,000 billetera
comadreja 140,000 cte estado
paola chicho 79,000
paola flores 97,000
luly 664.954 1,244,760 cte chile
tio lalo pension Chile 37,500 pyme bco chile
gallegos eduardo 150,000 Total
chery 70,000 debo
Celín 90,000
sra Isabel 28,000 papá $ entregado
mesa carito 50 1,930,000
chica javi 52,000
sugei 48,000
juaco 753- 2 michelada +1 royal 753,000 foco solar 900w ,briggs
quiero 936,500
mambo 2,964,500 deudores qls
teresita gallegos 128,000 nano miramar 5 mil
tia maria teresa 60000hija 230,000 diva5.5
marin pinturas 140,000 viejo lora20
con luz debo 1360 debe enero-febr 1,290,000 rumpy 10
Mi pastor préstamo 1,000,000 catri 15
tia Angie 160,000 flaco gustavo 93
verito ahijada 70,000 fabiola del vaca 30
padrino193500 +calce+guantes+17s 244,500 matias carne 74
franchisca 55,000 muu34
volantin 70,000 Gamer21.@
Total deben 12,112,760

con luz 10 bisagras +foco solar+llaves briggs

billy 450 de 1500

 Joaquín 210000
leonor 200000
visa 250000
200,000 entel 33000
400 préstamo bco 240000
casa 220000
petróleo 600000
0 celular 25000
146300 tags furgon 70000
346700 hosteria 90000
perros 30000
desayunos 20000
1200000

nv Total 1988000

junio
Billy 90,000
contribuciones 165,000
Angélica 425,000
casa arriendo 150,000
consola 110,000
agras +foco solar+llaves briggs celular 25,000
Leito 100,000
Julián 90,000
mamá calzado 40,000
petroleo 90,000
visa 50,000
Total 1,335,000
septiembre Mayo
casa arriendo 150000 casa arriendo 150000
diesel 320000 petroleo 106000
visa 170000
visa 300000 billy 90000
sillón 400000 Joaquín 175000
deuda Angélica 250000
joaquin 200000 viajes stgo 30000
deuda Angélica 250000 asado 1 mayo 30000
Leito 150000
celular 32000 Celular 25000
agua luz rauco 30000
pago furgón 1000000
mantencion auto 400000

Total 3232000 Total 1026000

julio Agosto
casa y comida fija 70000 casa y comida fija 60000
bencina 06/07 24000 bencina 06/07 160000
mantencion furgón 450000 Mac 30000
credito 138000

casa yoyo 160,000 casa y comida fija

bencina 06/07 450,000 bencina 06/07 25000
Seguro auto 40,000 lumbago 140000
mantención boxer 450,000
joaquin y leito 400,000 pegueot 450000
deuda Angélica 250,000 1 cambio de aceite 70000
crlular 35,000 petroleo 37000
aseo 40,000
credito bco estado 270,000
visa 250,000

Total 2,345,000 Total 722000

106000
 Jan-23 Feb-23 Mar-23 Apr-23 May-23

Ingresos $CLP 10,749,000 6,550,000 9,604,000

Costos
Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23