Son datos
Presupuesto de ventas y compras de efectivo
Mes 1 Mes 2 Mes 3
Ventas 470,000 574,000 454,000
40% Ventas al contado 188,000 229,600 181,600
37% Ventas al crèdito (1 mes) 173,900 212,380
23% Ventas al crèdito (1 mes) 108,100
Total Ingresos 188,000 403,500 502,080
Compras 282,000 344,400 272,400
43% Compras al contado 121,260 148,092 117,132
33% Compras al crèdito (1 mes) 93,060 113,652
24% Compras al crèdito (1 mes) 67,680
Total Egresos 121,260 241,152 298,464
Presupuesto de Efectivo
Mes 1 Mes 2 Mes 3
INGRESOS
Ingreso 188,000.0 403,500.0 502,080.0
Prestamo 30,000.0
Otros ingresos
Total ingresos 403,500.0 532,080.0
EGRESOS
Egresos 121,260.0 241,152.0 298,464.0
30% mensual Planilla 141,000.0 172,200.0 136,200.0
6000 mensual alquiler 6,000.0 6,000.0 6,000.0
1.50% mensual publicidad 7,050.0 8,610.0 6,810.0
6.00% mensual Servicios 28,200.0 28,200.0 28,200.0
dividendos
1.50% de las ventas Impuesto 8,610.0 6,810.0
Inversiòn 30,000.0
Interès
Amortizacion
Total egresos 464,772.0 512,484.0
Flujo Neto de Fondos -61,272.0 19,596.0
Saldo inicial 5,000.0 -56,272.0
Saldo final -56,272.0 -36,676.0
Caja mínima 10,000.0 10,000.0
Financiamiento 66,272.0 46,676.0
Escedente
Inversiòn 30,000
Prestamo 30,000
TEA 27.0%
Periodicidad mensual
Forma de pagos Cuotas fijas
TEM 2.0118%
Cuota 3,341.9
Perìodo (meses) S. inicial Interés Amortiz
1 30,000.0 603.5 2,738.3
2 27,261.7 548.4 2,793.4
3 24,468.3 492.2 2,849.6
4 21,618.7 434.9 2,906.9
5 18,711.7 376.4 2,965.4
6 15,746.3 316.8 3,025.1
7 12,721.2 255.9 3,085.9
8 9,635.3 193.8 3,148.0
9 6,487.3 130.5 3,211.3
10 3,275.9 65.9 3,275.9
Cuota
0.0201178 1.22040253
R= 30,000.0 ---------------------------------------------
0.22040253
0.0245518
R= 30,000.0 ---------------------------------------------
0.220402534
R= 3,341.85
Mes 4 Mes 5 Mes 6 Mes 7 Mes 8
445,000 408,000 415,000 427,000 443,000
178,000 163,200 166,000 170,800 177,200
167,980 164,650 150,960 153,550 157,990
132,020 104,420 102,350 93,840 95,450
478,000 432,270 419,310 418,190 430,640
267,000 244,800 249,000 256,200 265,800
114,810 105,264 107,070 110,166 114,294
89,892 88,110 80,784 82,170 84,546
82,656 65,376 64,080 58,752 59,760
287,358 258,750 251,934 251,088 258,600
Mes 4 Mes 5 Mes 6 Mes 7 Mes 8
478,000.0 432,270.0 419,310.0 418,190.0 430,640.0
1,880.0 1,880.0
478,000.0 434,150.0 419,310.0 420,070.0 430,640.0
287,358.0 258,750.0 251,934.0 251,088.0 258,600.0
133,500.0 122,400.0 124,500.0 128,100.0 132,900.0
6,000.0 6,000.0 6,000.0 6,000.0 6,000.0
6,675.0 6,120.0 6,225.0 6,405.0 6,645.0
28,200.0 28,200.0 28,200.0 28,200.0 28,200.0
28,800.0 28,800.0
6,675.0 6,120.0 6,225.0 6,405.0 6,645.0
603.5 548.4 492.2 434.9 376.4
2,738.3 2,793.4 2,849.6 2,906.9 2,965.4
471,749.9 430,931.9 455,225.9 429,539.9 471,131.9
6,250.1 3,218.1 -35,915.9 -9,469.9 -40,491.9
-36,676.0 -30,425.9 -27,207.7 -63,123.6 -72,593.4
-30,425.9 -27,207.7 -63,123.6 -72,593.4 -113,085.3
10,000.0 10,000.0 10,000.0 10,000.0 10,000.0
40,425.9 37,207.7 73,123.6 82,593.4 123,085.3
Cuota S. final
3,341.9 27,261.7
3,341.9 24,468.3
3,341.9 21,618.7
3,341.9 18,711.7
3,341.9 15,746.3
3,341.9 12,721.2
3,341.9 9,635.3
3,341.9 6,487.3
3,341.9 3,275.9
3,341.9 0.0
-----------------
-----------------
Son datos
Presupuesto de ventas y compras de efectivo
Mes 1 Mes 2 Mes 3
Ventas 470,000 574,000 454,000
40% Ventas al contado 188,000 229,600 181,600
37% Ventas al crèdito (1 mes) 173,900 212,380
23% Ventas al crèdito (1 mes) 108,100
Total Ingresos 188,000 403,500 502,080
Compras 282,000 344,400 272,400
43% Compras al contado 121,260 148,092 117,132
33% Compras al crèdito (1 mes) 93,060 113,652
24% Compras al crèdito (1 mes) 67,680
Total Egresos 121,260 241,152 298,464
Presupuesto de Efectivo
Mes 1 Mes 2 Mes 3
INGRESOS
Ingreso 188,000.0 403,500.0 502,080.0
Prestamo 30,000.0
Otros ingresos
Total ingresos 403,500.0 532,080.0
EGRESOS
Egresos 121,260.0 241,152.0 298,464.0
30% mensual Planilla 141,000.0 172,200.0 136,200.0
6000 mensual alquiler 6,000.0 6,000.0 6,000.0
1.50% mensual publicidad 7,050.0 8,610.0 6,810.0
6.00% mensual Servicios 28,200.0 28,200.0 28,200.0
dividendos
1.50% de las ventas Impuesto 8,610.0 6,810.0
Inversiòn 30,000.0
Interès
Amortizacion
Total egresos 464,772.0 512,484.0
Flujo Neto de Fondos -61,272.0 19,596.0
Saldo inicial 27,000.0 -34,272.0
Saldo final -34,272.0 -14,676.0
Caja mínima 10,000.0 10,000.0
Financiamiento 44,272.0 24,676.0
Escedente
Inversiòn 30,000
Prestamo 30,000
TEA 27.0%
Periodicidad mensual
Forma de pagos Cuotas fijas
TEM 2.0118%
Cuota 3,341.9
Perìodo (meses) S. inicial Interés Amortiz
1 30,000.0 603.5 2,738.3
2 27,261.7 548.4 2,793.4
3 24,468.3 492.2 2,849.6
4 21,618.7 434.9 2,906.9
5 18,711.7 376.4 2,965.4
6 15,746.3 316.8 3,025.1
7 12,721.2 255.9 3,085.9
8 9,635.3 193.8 3,148.0
9 6,487.3 130.5 3,211.3
10 3,275.9 65.9 3,275.9
Cuota
0.0201178 1.22040253
R= 30,000.0 ---------------------------------------------
0.22040253
0.0245518
R= 30,000.0 ---------------------------------------------
0.220402534
R= 3,341.85
Mes 4 Mes 5 Mes 6 Mes 7 Mes 8
445,000 408,000 415,000 427,000 443,000
178,000 163,200 166,000 170,800 177,200
167,980 164,650 150,960 153,550 157,990
132,020 104,420 102,350 93,840 95,450
478,000 432,270 419,310 418,190 430,640
267,000 244,800 249,000 256,200 265,800
114,810 105,264 107,070 110,166 114,294
89,892 88,110 80,784 82,170 84,546
82,656 65,376 64,080 58,752 59,760
287,358 258,750 251,934 251,088 258,600
Mes 4 Mes 5 Mes 6 Mes 7 Mes 8
478,000.0 432,270.0 419,310.0 418,190.0 430,640.0
1,880.0 1,880.0
478,000.0 434,150.0 419,310.0 420,070.0 430,640.0
287,358.0 258,750.0 251,934.0 251,088.0 258,600.0
133,500.0 122,400.0 124,500.0 128,100.0 132,900.0
6,000.0 6,000.0 6,000.0 6,000.0 6,000.0
6,675.0 6,120.0 6,225.0 6,405.0 6,645.0
28,200.0 28,200.0 28,200.0 28,200.0 28,200.0
28,800.0 28,800.0
6,675.0 6,120.0 6,225.0 6,405.0 6,645.0
603.5 548.4 492.2 434.9 376.4
2,738.3 2,793.4 2,849.6 2,906.9 2,965.4
471,749.9 430,931.9 455,225.9 429,539.9 471,131.9
6,250.1 3,218.1 -35,915.9 -9,469.9 -40,491.9
-14,676.0 -8,425.9 -5,207.7 -41,123.6 -50,593.4
-8,425.9 -5,207.7 -41,123.6 -50,593.4 -91,085.3
10,000.0 10,000.0 10,000.0 10,000.0 10,000.0
18,425.9 15,207.7 51,123.6 60,593.4 101,085.3
Cuota S. final
3,341.9 27,261.7
3,341.9 24,468.3
3,341.9 21,618.7
3,341.9 18,711.7
3,341.9 15,746.3
3,341.9 12,721.2
3,341.9 9,635.3
3,341.9 6,487.3
3,341.9 3,275.9
3,341.9 0.0
-----------------
-----------------
