MES1 MES2 MES3

Ventas 196,552.00 156,768.00 132,882.00

Otros Ingresos operacionales - - -
Total Ingresos Operativos 196,552.00 156,768.00 132,882.00
Costo 121,862.24 97,196.16 82,386.84
Caja o Flujo Bruto 74,689.76 59,571.84 50,495.16
Gasto 27,576.00 22,405.35 22,456.00
Caja o Flujo Operativo 47,113.76 37,166.49 28,039.16
Otros Ingresos no operacionales - - 420,000.00
Otros Egresos no operacionañes - - -
Caja antes de financiamiento 47,113.76 37,166.49 448,039.16
Cuota Nuevo Prestamo LP
Cuota Nuevo Prestamo CP 1,154.87 1,131.45 187.63
Cuota Nueva TC 2,182.55 2,182.55 306.59

Caja después de financiamiento(Flujo Neto) 43,776.34 33,852.49 447,544.94

Gastos Familiares 712.00 712.00 712.00
Caja final 43,064.34 33,140.49 446,832.94

Indice capacidad pago (ICP) 14.12 11.21 906.56

Año Monto Var. %

2018 253,789.00
2019 1,341,632.00 428.6%
20-Jul 1,117,429.74
2020 (p) 1,915,593.84 43%
AÑO 1 1,917,664.00 0.11%
AÑO 2 2,013,547.20 5.0%
AÑO 3 2,114,224.56 5.0%
AÑO 4 2,219,935.79 5.0%
AÑO 5 2,330,932.58 5.0%
 MES4 MES5 MES6 MES7 MES8 MES9
181,154.00 225,321.00 131,214.00 124,941.00 135,263.00 129,862.00
- - - - - -
181,154.00 225,321.00 131,214.00 124,941.00 135,263.00 129,862.00
112,315.48 139,699.02 81,352.68 77,463.42 83,863.06 80,514.44
68,838.52 85,621.98 49,861.32 47,477.58 51,399.94 49,347.56
24,356.00 26,895.00 22,560.00 23,561.00 22,506.00 22,500.00
44,482.52 58,726.98 27,301.32 23,916.58 28,893.94 26,847.56
- - - - - -
- - - - - -
44,482.52 58,726.98 27,301.32 23,916.58 28,893.94 26,847.56
8,874.24 8,874.20 8,874.20 8,874.20 8,874.20 8,874.20
- - 1,703.47 1,841.58 2,184.59 2,178.39
- - 2,351.23 7,562.87 11,484.67 11,308.43

35,608.28 49,852.78 14,372.42 5,637.93 6,350.48 4,486.54

712.00 712.00 712.00 712.00 712.00 712.00
34,896.28 49,140.78 13,660.42 4,925.93 5,638.48 3,774.54

5.01 6.62 2.11 1.31 1.28 1.20

Año % Costo de Ventas % Gtos. de Vtas %Gtos. Adm.

2018 82.71% 0.00% 11.98%

2019 70.95% 0.00% 17.56%

20-Jul 71.17% 0.00% 17.56%

2020 (p)
AÑO 1 62.00% 14.72%

AÑO 2 62.59% 14.72%

AÑO 3 63.78% 14.72%

AÑO 4 65.00% 14.72%

AÑO 5 66.24% 14.72%

 MES10 MES11 MES12 TOTAL AÑO 1 TOTAL AÑO 2
165,230.00 167,563.00 170,914.00 1,917,664.00 2,013,547.20
- - - - -
165,230.00 167,563.00 170,914.00 1,917,664.00 3,638,776.00
102,442.60 103,889.06 105,966.68 1,188,951.68 1,260,288.78
62,787.40 63,673.94 64,947.32
22,500.00 22,500.00 22,500.00 282,315.35 296,431.12
40,287.40 41,173.94 42,447.32 1,471,267.03 1,556,719.90
- - - 420,000.00
- - - - -
40,287.40 41,173.94 42,447.32 1,891,267.03 1,556,719.90
8,874.20 8,874.20 8,874.20 79,867.84
2,149.67 2,036.17 2,284.57 16,852.39
11,381.68 11,468.68 11,542.46 71,771.71
- -
- -
- -
17,881.85 18,794.89 19,746.09 1,722,775.09 1,556,719.90
712.00 712.00 712.00 8,544.00 16,376.00
17,169.85 18,082.89 19,034.09 689,361.03 1,335,657.72

1.80 1.84 1.87 11.22 #DIV/0!

%Mg. Neto
5.31%
11.48%
11.28%

23.28%
22.69%
21.50%
20.28%
19.04%
TOTAL AÑO 3 TOTAL AÑO 4 TOTAL AÑO 5
2,114,224.56 2,219,935.79 2,330,932.58
- - -
7,120,784.00 14,108,686.00 28,036,218.00
1,348,509.00 1,442,904.63 1,543,907.95

311,252.67 326,815.31 343,156.07

1,659,761.67 1,769,719.93 1,887,064.02

- - -
1,659,761.67 1,769,719.93 1,887,064.02

- - -
- - -
- - -
1,659,761.67 1,769,719.93 1,887,064.02
32,040.00 63,368.00 126,024.00
2,638,174.95 4,829,516.96 9,624,137.64

#DIV/0! #DIV/0! #DIV/0!

 MES1 MES2 MES3
Ventas 196,552.00 156,768.00 132,882.00
Otros Ingresos operacionales - - -
Total Ingresos Operativos 196,552.00 156,768.00 132,882.00
Costo 147,296.07 117,481.94 99,581.77
Caja o Flujo Bruto 49,255.93 39,286.06 33,300.23
Gasto 30,858.66 24,612.58 20,862.47
Caja o Flujo Operativo 18,397.27 14,673.48 12,437.76
Otros Ingresos no operacionales - -
Otros Egresos no operacionañes - - -
Caja antes de financiamiento 18,397.27 14,673.48 12,437.76
Aporte
Banco Pichincha AF NUEVO
Productivo BP 1,323.85 1,323.85 1,323.85
Guayaquil 3,011.00 3,011.00 3,011.00
CFN 1,468.00 1,468.00 1,468.00
CFN 1,343.00 1,343.00 1,343.00
CFN 6,035.00 6,035.00 6,035.00
Convenio SRI 450.00 450.00 450.00

Caja después de financiamiento(Flujo Neto) 4,766.42 1,042.63 -1,193.09

Caja final 4,766.42 1,042.63 -1,193.09

Indice capacidad pago (ICP) 1.35 1.08 0.91

Año Monto Var. %

2018 253,789.00
2019 1,341,632.00 428.6%
20-Jul 1,117,429.74
2020 (p) 1,915,593.84 43%
AÑO 1 1,917,700.99 0.11%
AÑO 2 2,013,586.04 5.0%
AÑO 3 2,114,265.35 5.0%
AÑO 4 2,219,978.61 5.0%
AÑO 5 2,330,977.54 5.0%
 MES4 MES5 MES6 MES7 MES8 MES9
181,154.00 225,321.00 131,214.00 124,941.00 135,263.00 129,862.00
- - - - - -
181,154.00 225,321.00 131,214.00 124,941.00 135,263.00 129,862.00
135,756.81 168,855.56 98,331.77 93,630.79 101,366.09 97,318.58
45,397.19 56,465.44 32,882.23 31,310.21 33,896.91 32,543.42
28,441.18 35,375.40 20,600.60 19,615.74 21,236.29 20,388.33
16,956.01 21,090.05 12,281.63 11,694.48 12,660.62 12,155.08
- - - - - -
- - - - - -
16,956.01 21,090.05 12,281.63 11,694.48 12,660.62 12,155.08

8,874.24 8,874.24 8,874.24 8,874.24 8,874.24 8,874.24

1,323.85 1,323.85 1,323.85
3,011.00 3,011.00 3,011.00
1,468.00 1,468.00 1,468.00 1,468.00 1,468.00 1,468.00
1,343.00 1,343.00 1,343.00 1,343.00 1,343.00 1,343.00
6,035.00 6,035.00 6,035.00 6,035.00 6,035.00 6,035.00
450.00 450.00 450.00 450.00 450.00

-5,549.08 -1,415.05 -10,223.46 -6,475.76 -5,509.63 -5,565.16

-5,549.08 -1,415.05 -10,223.46 -6,475.76 -5,509.63 -5,565.16

0.75 0.94 0.55 0.64 0.70 0.69

Año % Costo de Ventas % Gtos. de Vtas %Gtos. Adm.

2018 82.71% 0.00% 11.98%

2019 70.95% 0.00% 17.56%

20-Jul 71.17% 0.00% 17.56%

2020 (p)
AÑO 1 74.94% 15.70%

AÑO 2 74.94% 15.70%

AÑO 3 74.94% 15.70%

AÑO 4 74.94% 15.70%

AÑO 5 74.94% 15.70%

 MES10 MES11 MES12 TOTAL AÑO 1 TOTAL AÑO 2
165,230.00 167,563.00 170,914.00 1,917,664.00 2,013,586.04
- - - - -
165,230.00 167,563.00 170,914.00 1,917,664.00 3,638,776.00
123,823.36 125,571.71 128,082.95 1,437,097.40 1,508,981.38
41,406.64 41,991.29 42,831.05
25,941.11 26,307.39 26,833.50 301,073.25 316,133.01
15,465.53 15,683.90 15,997.55 1,738,170.65 1,825,114.39
- - - -
- - - - -
15,465.53 15,683.90 15,997.55 179,493.35 188,471.65
-
8,874.24 8,874.24 8,874.24 79,868.18 79,868.18
7,943.10
18,066.00
1,468.00 1,468.00 1,468.00 17,616.00 17,616.00
1,343.00 1,343.00 1,343.00 16,116.00 16,116.00
6,035.00 6,035.00 6,035.00 72,420.00 30,175.00
3,600.00
-
- -
- -
- -
-2,254.71 -2,036.35 -1,722.69 -36,135.93 44,696.48
-2,254.71 -2,036.35 -1,722.69 -36,135.93 -77,038.27

0.87 0.89 0.90 0.83 1.31

%Mg. Neto ICP

5.31% -
11.48% -
11.28% -
-
9.36% 0.83
9.36% 1.31
9.36% 1.83
9.36% 2.60
9.36% 2.73
TOTAL AÑO 3 TOTAL AÑO 4 TOTAL AÑO 5
2,114,265.35 2,219,978.61 2,330,977.54
- - -
7,120,784.00 14,108,686.00 28,036,218.00
1,584,430.45 1,663,651.97 1,746,834.57

331,939.66 348,536.64 365,963.47

1,916,370.11 2,012,188.61 2,112,798.04

- - -
197,895.24 207,790.00 218,179.50

79,868.18 79,868.18 79,868.18

14,680.00
13,430.00

- - -
- - -
- - -
89,917.06 127,921.82 138,311.32
-155,119.18 -309,045.27 -612,541.45

1.83 2.60 2.73