TAREA 7 FLUJO 3
INGRESOS VENT VENTAS AS CONT CONTAD ADO O (35% (35%)) VENTAS A 30 DIAS (40%) VENT VENTAS AS A 60 DIAS (25%) 25%) PRESTAMO
Q
TOTAL INGRESOS EGRESOS
Q 57 57,270.00
TERRENO INTERESES ABONO A CAPITA PRESTAMO COMPRAS !ASTOS DE VENTAS !ASTOS DE ADMON. !AST !ASTOS OS DE DIST DISTRI RIB" B"CI CION ON OTROS !ASTOS RET RETIRO IRO DE PROP PROPIIETAR ETARIO IO BONO 14 # A!"INADO CONVIVIO
Q
Q Q Q Q Q Q
4
18,2 18,270 70.0 .00 0 Q Q 39,0 39,000 00.0 .00 0 Q
27,000.00 14,0 00 00.00 5,000.00 4,20 4,200. 0.00 00 3,700.00 10,0 10,000 00.0 .00 0
TOTAL EGRESOS
Q 63 63,900.00
$" O O NETO DE $ONDOS SADO INICIA E&CEDENTE E$ECTIVO $INANCIAMIENTO REQ"ERIDO
Q Q Q
25,2 25,200 00.0 .00 0 Q 20,880.00 Q 19,0 19,000 00.0 .00 0 Q
Q 65 65,080.00
Q Q Q Q Q Q
37,000.00 14,000 .0 .00 5,000.00 4,20 4,200. 0.00 00 3,700.00 10,0 10,000 00.0 .00 0
Q 73 73,900.00
(6,630 .0 .00) Q 22,805.00 Q 16,175.00 Q
5 22,0 22,050 50.0 .00 0 Q 28,800.00 Q 13,0 13,050 50.0 .00 0 Q
Q 63 63,900.00
Q Q Q Q Q Q
33,000.00 1 4, 4,000.00 5,000.00 4,20 4,200. 0.00 00 3,700.00 10,0 10,000 00.0 .00 0
Q 69 69,900.00
(8,820.00 ) Q 16,175.00 Q 7,355.00 Q
6 20,4 20,475 75.0 .00 0 Q 25,200.00 Q 18,0 18,000 00.0 .00 0 Q
Q 63 63,675.00
Q Q Q Q Q Q
29,000.00 16,0 00 00.00 5,000.00 4,20 4,200. 0.00 00 3 ,7 0 0 .0 0 10,0 10,000 00.0 .00 0
Q 67 67,900.00
(6,0 00 00.00) Q 7,355.00 Q 1,355.00 Q
7 37,8 37,800 00.0 .00 0 Q 2 3 ,4 0 0 . 0 0 Q 15,7 15,750 50.0 .00 0 Q Q
Q 76 76,950.00
Q Q Q Q Q Q Q
8
57,000.00 16,000. 00 00 4,900.00 5,50 5,500. 0.00 00 6,000.00 10,0 10,000 00.0 .00 0 15,500.00
Q 114,900.00
9
25,2 25,200 00.0 .00 0 Q 43,200.00 Q 14,6 14,625 25.0 .00 0 Q 75,000.00
Q 158,025.00
Q 87 87,300.00
Q Q
175,000.00 750.00 Q
Q Q Q Q Q Q
37,000.00 16,000 .0 .00 4,900.00 5,50 5,500. 0.00 00 6,000.00 10,0 10,000 00.0 .00 0
Q 255,150.00
31,5 31,500 00.0 .00 0 28,800.00 27,0 27,000 00.0 .00 0
Q Q Q Q Q Q
750.00 47,000.00 1 8, 8,000.00 4,900.00 5,50 5,500. 0.00 00 6,000.00 10,0 10,000 00.0 .00 0
Q 92 92,150.00
(4,225.0 0) 0) Q 1,355.00
(3 7, 7,950.00 ) Q
(9 7, 7,125.00 ) Q
(4,8 50 50.00)
(2,870.00) Q
(37,950.00) Q
(97,125.00) Q
(4,850.00)
10 Q Q Q
29,610.00 36,000.00 18,000.00
11 Q Q Q
25,200.00 33,840.00 22,500.00
12 Q Q Q
39,375.00 28,800.00 21,150.00
Q 83,610.00 Q 81,540.00 Q 89,325.00
Q
750.00
Q
750.00
Q Q Q Q Q Q
45,000.00 Q 18,000.00 Q 4,900.00 Q 5,500.00 Q 6,000.00 Q 10,000.00 Q
36,000.00 18,000.00 4,900.00 5,500.00 6,000.00 10,000.00
Q 90,150.00
Q 81,150.00
Q
(6,540.00) Q
390.00
Q
390.00
Q
(6,540.00)
Q Q Q Q Q Q Q Q Q Q
750.00 15,000.00 59,000.00 18,000.00 4,900.00 5,500.00 6,000.00 10,000.00 15,500.00 32,000.00
Q 166,650.00 Q Q
(77,325.00) 390.00
Q
(76,935.00)
TAREA 7 ESCENARIO 1 3
INGRESOS VENTAS CONTADO (35%) VENTAS A 30 DIAS (40%) VENTAS A 60 DIAS (25%) PRESTAMO VENTA DE VE'IC"O
Q
TOTAL INGRESOS EGRESOS
Q 57,270.00
TERRENO INTERESES ABONO A CAPITA PRESTAMO COMPRAS !ASTOS DE VENTAS !ASTOS DE ADMON. !ASTOS DE DISTRIB"CION OTROS !ASTOS RETIRO DE PROPIETARIO BONO 14 # A!"INADO CONVIVIO
Q
4
18,270.00 Q Q 39,000.00 Q
5
25,200.00 Q 20,880.00 Q 19,000.00 Q
6
22,050.00 Q 28,800.00 Q 13,050.00 Q
7
20,475.00 Q 25,200.00 Q 18,000.00 Q Q
Q Q Q Q Q Q
27,000.00 14,0 00.00 5,000.00 4,200.00 3,000.00 3,000.00
TOTAL EGRESOS
Q 56,200.00
$" O NETO DE $ONDOS SADO INICIA E&CEDENTE E$ECTIVO $INANCIAMIENTO REQ"ERIDO
Q Q Q
Q 65,080.00
Q Q Q Q Q Q
37,000.00 14,000 .00 5,000.00 4,200.00 3,000.00 6,000.00
Q 69,200.00
1,0 70.00 Q 22,805.00 Q 23,8 75.00 Q
Q 63,900.00
Q Q Q Q Q Q
33,000.00 1 4,000.00 5,000.00 4,200.00 3,000.00 6,000.00
Q 65,200.00
(4,120.00 ) Q 23,875.00 Q 19,755 .00 Q
Q 63,675.00
Q Q Q Q Q Q
29,000.00 16,0 00.00 5,000.00 4,200.00 3,000.00 6,000.00
Q 63,200.00
(1,3 00.00) Q 19,755.00 Q 1 8,455.00 Q
57,000.00 16,000. 00 4,900.00 5,500.00 3,000.00 6,000.00 15,500.00
Q 107,900.00
475 .00 Q 18,455.00 Q 18,9 30.00 Q
9
37,800.00 Q 25,200.00 Q 23,400.00 Q 43,200.00 Q 15,750.00 Q 14,625.00 Q Q 120,000.00 20,000.00
Q 96,950.00
Q Q Q Q Q Q Q
8
Q 203,025.00
Q 87,300.00
Q Q
175,000.00 750.00 Q
Q Q Q Q Q Q
37,000.00 16,000 .00 4,900.00 5,500.00 3,000.00 6,000.00
Q 248,150.00
(1 0,950.00 ) Q 18,930.00 Q 7,980.0 0 Q
31,500.00 28,800.00 27,000.00
Q Q Q Q Q Q
750.00 47,000.00 1 8,000.00 4,900.00 5,500.00 3,000.00 6,000.00
Q 85,150.00
( 45,125.00 ) Q 7,980.00 Q (37,145.00)
2 ,150.00 2 ,150.00
10 Q Q Q
29,610.00 36,000.00 18,000.00
11 Q Q Q
25,200.00 33,840.00 22,500.00
12 Q Q Q
39,375.00 28,800.00 21,150.00
Q 83,610.00 Q 81,540.00 Q 89,325.00
Q
750.00
Q
750.00
Q Q Q Q Q Q
45,000.00 18,000.00 4,900.00 5,500.00 3,000.00 6,000.00
Q Q Q Q Q Q
36,000.00 18,000.00 4,900.00 5,500.00 3,000.00 6,000.00
Q 83,150.00 Q Q Q
Q 74,150.00
460.00 Q 2,150.00 Q 1,690.00 Q
7,390.00 1,690.00
Q Q Q Q Q Q Q Q Q Q
750.00 15,000.00 59,000.00 18,000.00 4,900.00 5,500.00 3,000.00 6,000.00 15,500.00 32,000.00
Q 159,650.00 Q
(70,325.00)
(5,700.00) Q
(70,325.00)
TAREA 7 ESCENARIO 2 3
INGRESOS VENTAS CONTADO (35%) VENTAS A 30 DIAS (40%) VENTAS A 60 DIAS (25%) PRESTAMO
Q
TOTAL INGRESOS
Q 57,270.00
E!RESOS TERRENO INTERESES ABONO A CAPITA PRESTAMO COMPRAS !ASTOS DE VENTAS !ASTOS DE ADMON. !ASTOS DE DISTRIB"CION OTROS !ASTOS BONO 14 # A!"INADO CONVIVIO
Q
Q Q Q Q Q
4
18,270.00 Q Q 39,000.00 Q
27,000.00 14,0 00.00 5,000.00 4,200.00 3,700.00
TOTAL EGRESOS
Q 53,900.00
$"O NETO DE $ONDOS SADO INICIA E&CEDENTE E$ECTIVO $INANCIAMIENTO REQ"ERIDO
Q Q Q
25,200.00 Q 20,880.00 Q 19,000.00 Q
Q 65,080.00
Q Q Q Q Q
37,000.00 14,000 .00 5,000.00 4,200.00 3,700.00
Q 63,900.00
3,370.00 Q 22,805.00 Q 26,1 75.00 Q
5 22,050.00 Q 28,800.00 Q 13,050.00 Q
Q 63,900.00
Q Q Q Q Q
33,000.00 1 4,000.00 5,000.00 4,200.00 3,700.00
Q 59,900.00
1,180.00 Q 26,175.00 Q 27,355 .00 Q
6 20,475.00 Q 25,200.00 Q 18,000.00 Q
Q 63,675.00
Q Q Q Q Q
29,000.00 16,0 00.00 5,000.00 4,200.00 3,700.00
Q 57,900.00
4,000.00 Q 27,355.00 Q 3 1,355.00 Q
7 37,800.00 Q 23,400.00 Q 15,750.00 Q Q
Q 76,950.00
Q Q Q Q Q Q
57,000.00 16,000. 00 4,900.00 5,500.00 6,000.00 15,500.00
Q 104,900.00
5,775.00 Q 31,355.00 Q 37,1 30.00 Q
8
9
25,200.00 Q 43,200.00 Q 14,625.00 Q 75,000.00
Q 158,025.00
Q 87,300.00
Q Q
175,000.00 750.00 Q
Q Q Q Q Q
37,000.00 16,000 .00 4,900.00 5,500.00 6,000.00
Q 245,150.00
(27,950.00) Q 37,130.00 Q 9,180.0 0 Q
31,500.00 28,800.00 27,000.00
Q Q Q Q Q
750.00 47,000.00 1 8,000.00 4,900.00 5,500.00 6,000.00
Q 82,150.00
(87,125.00) Q 9,180.00 Q (77,945.00)
5,150.00 5 ,150.00
10 Q Q Q
29,610.00 36,000.00 18,000.00
11 Q Q Q
25,200.00 33,840.00 22,500.00
12 Q Q Q
39,375.00 28,800.00 21,150.00
Q 83,610.00 Q 81,540.00 Q 89,325.00
Q
750.00
Q
750.00
Q Q Q Q Q
45,000.00 Q 18,000.00 Q 4,900.00 Q 5,500.00 Q 6,000.00 Q
36,000.00 18,000.00 4,900.00 5,500.00 6,000.00
Q Q Q Q Q Q Q Q Q
750.00 15,000.00 59,000.00 18,000.00 4,900.00 5,500.00 6,000.00 15,500.00 32,000.00
Q 80,150.00
Q 71,150.00
Q 156,650.00
Q Q Q
Q Q Q
Q Q
(67,325.00) 19,000.00
Q
(48,325.00)
3,460.00 5,150.00 8,610.00
10,390.00 8,610.00 19,000.00
TAREA 7 ESCENARIO 3 3
INGRESOS VENTAS CONTADO (35%) VENTAS A 30 DIAS (40%) VENTAS A 60 DIAS (25%) PRESTAMO VENTA VE'IC"O
Q
TOTAL INGRESOS EGRESOS
Q 57,270.00
TERRENO INTERESES ABONO A CAPITA PRESTAMO COMPRAS !ASTOS DE VENTAS !ASTOS DE ADMON. !ASTOS DE DISTRIB"CION OTROS !ASTOS RETIRO DE PROPIETARIO BONO 14 # A!"INADO CONVIVIO
Q
4
18,270.00 Q Q 39,000.00 Q
5
25,200.00 Q 20,880.00 Q 19,000.00 Q
6
22,050.00 Q 28,800.00 Q 13,050.00 Q
7
20,475.00 Q 25,200.00 Q 18,000.00 Q Q
Q Q Q Q Q Q
27,000.00 14,0 00.00 5,000.00 4,200.00 2,500.00
TOTAL EGRESOS
Q 52,700.00
$"O NETO DE $ONDOS SADO INICIA E&CEDENTE E$ECTIVO $INANCIAMIENTO REQ"ERIDO
Q Q Q
Q 65,080.00
Q Q Q Q Q Q
37,000.00 14,000 .00 5,000.00 4,200.00 2,500.00
Q 62,700.00
4,570.00 Q 22,805.00 Q 27,3 75.00 Q
Q 63,900.00
Q Q Q Q Q Q
Q 58,700.00
2,380.00 Q 27,375.00 Q 29,755 .00 Q
PROP"ESTA REAI*AR A VENTA DE VE'IC"O EN "IO POR Q.20,000.00. EIMINAR OS RETIROS DE PROPIETARIO. IMITE DE Q.2,500 PARA OTROS !ASTOS EN TODOS O MESES
33,000.00 1 4,000.00 5,000.00 4,200.00 2,500.00
Q 63,675.00
Q Q Q Q Q Q
29,000.00 16,0 00.00 5,000.00 4,200.00 2,500.00
Q 56,700.00
5,200.00 Q 29,755.00 Q 3 4,955.00 Q
57,000.00 16,000. 00 4,900.00 5,500.00 2,500.00 15,500.00
Q 101,400.00
6,975.00 Q 34,955.00 Q 41,9 30.00 Q
9
37,800.00 Q 25,200.00 Q 23,400.00 Q 43,200.00 Q 15,750.00 Q 14,625.00 Q Q 130,000.00 20,000.00
Q 96,950.00
Q Q Q Q Q Q Q
8
Q 213,025.00
Q 87,300.00
Q Q
175,000.00 750.00 Q
Q Q Q Q Q Q
37,000.00 16,000 .00 4,900.00 5,500.00 2,500.00
Q 241,650.00
(4,450.00) Q 41,930.00 Q 37,480. 00 Q
31,500.00 28,800.00 27,000.00
Q Q Q Q Q Q
750.00 47,000.00 1 8,000.00 4,900.00 5,500.00 2,500.00
Q 78,650.00
(28,625.00) Q 37,480.00 Q 8,855.0 0 Q
8,650.00 8,855.00 1 7,505.00
A"MENTAR E PRESTAMO EN A!OSTO A Q.130,000.00.
CON ESTO SE REQUERIRÍA UN FINANCIAMIENTO UNICAMENTE AL FINAL DE ERÍODO.
10 Q Q Q
29,610.00 36,000.00 18,000.00
11 Q Q Q
25,200.00 33,840.00 22,500.00
12 Q Q Q
39,375.00 28,800.00 21,150.00
Q 83,610.00 Q 81,540.00 Q 89,325.00
Q
750.00
Q
750.00
Q Q Q Q Q Q
45,000.00 18,000.00 4,900.00 5,500.00 2,500.00
Q Q Q Q Q Q
36,000.00 18,000.00 4,900.00 5,500.00 2,500.00
Q 76,650.00 Q Q Q
Q 67,650.00
6,960.00 Q 17,505.00 Q 24,465.00 Q
13,890.00 24,465.00 38,355.00
Q Q Q Q Q Q Q Q Q Q
750.00 15,000.00 59,000.00 18,000.00 4,900.00 5,500.00 2,500.00 15,500.00 32,000.00
Q 153,150.00 Q Q
(63,825.00) 38,355.00
Q
(25,470.00)