Una desición para apalanrse correctamente

El Vendedor de celulares
Estado de Ganancia y Perdidas
10 10
0 1 2
Ventas 230,000 230,000
Costo de Venta 150,000 150,000
Utilidad Bruta 80,000 80,000
Margen Bruto 34.78% 34.78%

Gastos Operativos
Gasto en celular 12,000 12,000
Gasto en transporte 4,000 4,000
EBITDA 64,000 64,000
EBITDA margin 27.83% 27.83%
Gasto en depreciación 2,500 1,875
EBIT 61,500 62,125
Gasto en interes 30,069 19,881
EBT 31,431 42,244
EBT % 13.67% 18.37%
27% ISR (27%) 8,486.38 11,405.75
Utilidad Neta 22,945 30,838
Margen Neto 9.98% 13.41%

Balance General
Activos corrientes 156,336.62 129,753.87
Efectivo 156,336.62 129,753.87
CxC
Inventario
Inversiones a corto plazo
Activos Fijos 7,500 5,625
Celular 10,000 10,000
Depreciación Acum 2,500 4,375

Total de Activos 163,836.62 135,378.87

Pasivos 130,891.98 71,596.45

CXP
Deuda 180,000 130,891.98 71,596.45

Capital 10000 32,945

Utilidades retenidas 22,945 30,838
Patrimonio + Pasivos 163,837 135,379
A-P=C - -
Flujo de Caja Operativo 25,445 32,713
Utilidad Neta 22,945 30,838
Mas Depreciación 2,500 1,875
Var Activos Corrientes 0 0
Var Pasivos Corrientes 0 0
Fujo de caja de Financiamiento 130,891.98
Entrada de Financiamiento 180,000
Pago de Deuda - 49,108.02 - 59,295.53
Fujo de caja de inversión - 10,000

Efectivo Inical 10,000

Flujo de caja de efectivo 156,336.62 129,753.87

ROA 14.0% 22.8%

Interes 23.0% 27.8%
 10
3 CAPEX
230,000 25%
150,000 10,000
80,000 Gasto en de. 2,500
34.78%

12,000 Monto 180,000

4,000 Tasa 19%
64,000 Periodicidad 12
27.83% Tasa (p) 1.58%
1,406 Años 3
62,594 N 36
7,581 Cuota DOP6,598.08
55,013 Insteres Capital
23.92% 1 1 2,850.00 DOP3,748.08
14,853.56 2 2 2,790.66 DOP3,807.43
40,160 3 3 2,730.37 DOP3,867.71
17.46% 4 4 2,669.13 DOP3,928.95
5 5 2,606.92 DOP3,991.16
6 6 2,543.73 DOP4,054.35
99,723.30 7 7 2,479.54 DOP4,118.55
99,723.30 8 8 2,414.33 DOP4,183.76
9 9 2,348.08 DOP4,250.00
10 10 2,280.79 DOP4,317.29
11 11 2,212.43 DOP4,385.65
4,219 12 12 2,143.00 DOP4,455.09
10,000 1 13 2,072.46 DOP4,525.63
5,781 2 14 2,000.80 DOP4,597.28
3 15 1,928.01 DOP4,670.07
103,942.05 4 16 1,854.07 DOP4,744.02
5 17 1,778.95 DOP4,819.13
- 0.00 6 18 1,702.65 DOP4,895.43
7 19 1,625.14 DOP4,972.94
- 0.00 8 20 1,546.40 DOP5,051.68
9 21 1,466.42 DOP5,131.67
63,782 10 22 1,385.17 DOP5,212.92
40,160 11 23 1,302.63 DOP5,295.46
103,942 12 24 1,218.78 DOP5,379.30
- 1 25 1,133.61 DOP5,464.47
2 26 1,047.09 DOP5,550.99
 41,566 3 27 959.20 DOP5,638.88
40,160 4 28 869.92 DOP5,728.17
1,406 5 29 779.22 DOP5,818.86
0 6 30 687.09 DOP5,911.00
0 7 31 593.50 DOP6,004.59
8 32 498.43 DOP6,099.66
9 33 401.85 DOP6,196.24
- 71,596.45 10 34 303.74 DOP6,294.34
11 35 204.08 DOP6,394.00
12 36 102.84 DOP6,495.24
57,531.01
99,723.30 Costo efectivo 31.96%

tasa lineal 10.65%

38.6%
5.3%
 7,500 5,625 4,219
1,875 1,406.25 1,054.69

Balance
176,251.92 30,068.98 49,108.02 30,068.98 19,881.47 7,580.56
172,444.49 19,881.47 59,295.53 49,108.02 59,295.53 71,596.45
168,576.78 7,580.56 71,596.45
164,647.82
160,656.66
156,602.31
152,483.76
148,300.01
144,050.01
139,732.72
135,347.07
130,891.98
126,366.35
121,769.07
117,098.99
112,354.98
107,535.85
102,640.42
97,667.47
92,615.79
87,484.12
82,271.20
76,975.75
71,596.45
66,131.97
60,580.98
 54,942.10
49,213.93
43,395.07
37,484.07
31,479.48
25,379.83
19,183.59
12,889.25
6,495.24
- 0.00
 MARK DOWN
60% 60%
Vendedor de celulares
Estado de Ganancia y Perdidas
10 10
0 1 2
Ventas 375,000 375,000
Costo de Venta 150,000 150,000
Utilidad Bruta 225,000 225,000
Margen Bruto 60.00% 60.00%

Gastos Operativos
Gasto en ceular 12,000 12,000
Gasto en transporte 4,000 4,000
EBITDA 209,000 209,000
EBITDA margin 55.73% 55.73%
Gasto en depreciación 2,500 1,875
EBIT 206,500 207,125
Gasto en interes 30,069 19,881
EBT 176,431 187,244
EBT % 47.05% 49.93%
27% ISR (27%) 47,636.38 50,555.75
Utilidad Neta 128,795 136,688
Margen Neto 34.35% 36.45%
461%
Balance General
Activos corrientes 262,186.62 341,453.87
Efectivo 262,186.62 341,453.87
CxC
Inventario
Inversiones a corto plazo
Activos Fijos 7,500 5,625
Celular 10,000 10,000
Depreciación Acum 2,500 4,375

Total de Activos 269,686.62 347,078.87

Pasivos 130,891.98 71,596.45

CXP
Deuda 180,000 130,891.98 71,596.45

Capital 10000 138,795

Utilidades retenidas 128,795 136,688
Patrimonio + Pasivos 269,687 347,079
A-P=C - -
Flujo de Caja Operativo 131,295 138,563
Utilidad Neta 128,795 136,688
Mas Depreciación 2,500 1,875
Var Activos Corrientes 0 0
Var Pasivos Corrientes 0 0
Fujo de caja de Financiamiento 130,891.98
Entrada de Financiamiento 180,000
Pago de Deuda - 49,108.02 - 59,295.53
Fujo de caja de inversión - 10,000

Efectivo Inical 10,000

Flujo de caja de efectivo 262,186.62 341,453.87

ROA 47.8% 39.4%

Interes 23.0% 27.8%
 60%

10
3 CAPEX
375,000 25%
150,000 10,000
225,000 Gasto en de. 2,500
60.00%

12,000 Monto 180,000

4,000 Tasa 19%
209,000 Periodicidad 12
55.73% Tasa (p) 1.58%
1,406 Años 3
207,594 N 36
7,581 Cuota DOP6,598.08
200,013 Insteres Capital
53.34% 1 1 2,850.00 DOP3,748.08
54,003.56 2 2 2,790.66 DOP3,807.43
146,010 3 3 2,730.37 DOP3,867.71
38.94% 4 4 2,669.13 DOP3,928.95
5 5 2,606.92 DOP3,991.16
6 6 2,543.73 DOP4,054.35
417,273.30 7 7 2,479.54 DOP4,118.55
417,273.30 8 8 2,414.33 DOP4,183.76
9 9 2,348.08 DOP4,250.00
10 10 2,280.79 DOP4,317.29
11 11 2,212.43 DOP4,385.65
4,219 12 12 2,143.00 DOP4,455.09
10,000 1 13 2,072.46 DOP4,525.63
5,781 2 14 2,000.80 DOP4,597.28
3 15 1,928.01 DOP4,670.07
421,492.05 4 16 1,854.07 DOP4,744.02
5 17 1,778.95 DOP4,819.13
- 0.00 6 18 1,702.65 DOP4,895.43
7 19 1,625.14 DOP4,972.94
- 0.00 8 20 1,546.40 DOP5,051.68
9 21 1,466.42 DOP5,131.67
275,482 10 22 1,385.17 DOP5,212.92
146,010 11 23 1,302.63 DOP5,295.46
421,492 12 24 1,218.78 DOP5,379.30
- 1 25 1,133.61 DOP5,464.47
2 26 1,047.09 DOP5,550.99
 147,416 3 27 959.20 DOP5,638.88
146,010 4 28 869.92 DOP5,728.17
1,406 5 29 779.22 DOP5,818.86
0 6 30 687.09 DOP5,911.00
0 7 31 593.50 DOP6,004.59
8 32 498.43 DOP6,099.66
9 33 401.85 DOP6,196.24
- 71,596.45 10 34 303.74 DOP6,294.34
11 35 204.08 DOP6,394.00
12 36 102.84 DOP6,495.24
57,531.01
417,273.30 Costo efectivo 31.96%

tasa lineal 10.65%

34.6%
5.3%
 7,500 5,625 4,219
1,875 1,406.25 1,054.69

Balance
176,251.92 30,068.98 49,108.02 30,068.98 19,881.47 7,580.56
172,444.49 19,881.47 59,295.53 49,108.02 59,295.53 71,596.45
168,576.78 7,580.56 71,596.45
164,647.82
160,656.66
156,602.31
152,483.76
148,300.01
144,050.01
139,732.72
135,347.07
130,891.98
126,366.35
121,769.07
117,098.99
112,354.98
107,535.85
102,640.42
97,667.47
92,615.79
87,484.12
82,271.20
76,975.75
71,596.45
66,131.97
60,580.98
 54,942.10
49,213.93
43,395.07
37,484.07
31,479.48
25,379.83
19,183.59
12,889.25
6,495.24
- 0.00
 MARK UP
60% 60%
Vendedor de celulares
Estado de Ganancia y Perdidas
10 10
0 1 2
Ventas 240,000 240,000
Costo de Venta 150,000 150,000
Utilidad Bruta 90,000 90,000
Margen Bruto 37.50% 37.50%

Gastos Operativos
Gasto en ceular 12,000 12,000
Gasto en transporte 4,000 4,000
EBITDA 74,000 74,000
EBITDA margin 30.83% 30.83%
Gasto en depreciación 2,500 1,875
EBIT 71,500 72,125
Gasto en interes 30,069 19,881
EBT 41,431 52,244
EBT % 17.26% 21.77%
27% ISR (27%) 11,186.38 14,105.75
Utilidad Neta 30,245 38,138
Margen Neto 12.60% 15.89%
32%
Balance General
Activos corrientes 163,636.62 144,353.87
Efectivo 163,636.62 144,353.87
CxC
Inventario
Inversiones a corto plazo
Activos Fijos 7,500 5,625
Celular 10,000 10,000
Depreciación Acum 2,500 4,375

Total de Activos 171,136.62 149,978.87

Pasivos 130,891.98 71,596.45

CXP
Deuda 180,000 130,891.98 71,596.45

Capital 10000 40,245

Utilidades retenidas 30,245 38,138
Patrimonio + Pasivos 171,137 149,979
A-P=C - -
Flujo de Caja Operativo 32,745 40,013
Utilidad Neta 30,245 38,138
Mas Depreciación 2,500 1,875
Var Activos Corrientes 0 0
Var Pasivos Corrientes 0 0
Fujo de caja de Financiamiento 130,891.98
Entrada de Financiamiento 180,000
Pago de Deuda - 49,108.02 - 59,295.53
Fujo de caja de inversión - 10,000

Efectivo Inical 10,000

Flujo de caja de efectivo 163,636.62 144,353.87

ROA 17.7% 25.4%

Interes 23.0% 27.8%
 60%

10
3 CAPEX
240,000 25%
150,000 10,000
90,000 Gasto en de. 2,500
37.50%

12,000 Monto 180,000

4,000 Tasa 19%
74,000 Periodicidad 12
30.83% Tasa (p) 1.58%
1,406 Años 3
72,594 N 36
7,581 Cuota DOP6,598.08
65,013 Insteres Capital
27.09% 1 1 2,850.00 DOP3,748.08
17,553.56 2 2 2,790.66 DOP3,807.43
47,460 3 3 2,730.37 DOP3,867.71
19.77% 4 4 2,669.13 DOP3,928.95
5 5 2,606.92 DOP3,991.16
6 6 2,543.73 DOP4,054.35
121,623.30 7 7 2,479.54 DOP4,118.55
121,623.30 8 8 2,414.33 DOP4,183.76
9 9 2,348.08 DOP4,250.00
10 10 2,280.79 DOP4,317.29
11 11 2,212.43 DOP4,385.65
4,219 12 12 2,143.00 DOP4,455.09
10,000 1 13 2,072.46 DOP4,525.63
5,781 2 14 2,000.80 DOP4,597.28
3 15 1,928.01 DOP4,670.07
125,842.05 4 16 1,854.07 DOP4,744.02
5 17 1,778.95 DOP4,819.13
- 0.00 6 18 1,702.65 DOP4,895.43
7 19 1,625.14 DOP4,972.94
- 0.00 8 20 1,546.40 DOP5,051.68
9 21 1,466.42 DOP5,131.67
78,382 10 22 1,385.17 DOP5,212.92
47,460 11 23 1,302.63 DOP5,295.46
125,842 12 24 1,218.78 DOP5,379.30
- 1 25 1,133.61 DOP5,464.47
2 26 1,047.09 DOP5,550.99
 48,866 3 27 959.20 DOP5,638.88
47,460 4 28 869.92 DOP5,728.17
1,406 5 29 779.22 DOP5,818.86
0 6 30 687.09 DOP5,911.00
0 7 31 593.50 DOP6,004.59
8 32 498.43 DOP6,099.66
9 33 401.85 DOP6,196.24
- 71,596.45 10 34 303.74 DOP6,294.34
11 35 204.08 DOP6,394.00
12 36 102.84 DOP6,495.24
57,531.01
121,623.30 Costo efectivo 31.96%

tasa lineal 10.65%

37.7%
5.3%
 7,500 5,625 4,219
1,875 1,406.25 1,054.69

Balance
176,251.92 30,068.98 49,108.02 30,068.98 19,881.47 7,580.56
172,444.49 19,881.47 59,295.53 49,108.02 59,295.53 71,596.45
168,576.78 7,580.56 71,596.45
164,647.82
160,656.66
156,602.31
152,483.76
148,300.01
144,050.01
139,732.72
135,347.07
130,891.98
126,366.35
121,769.07
117,098.99
112,354.98
107,535.85
102,640.42
97,667.47
92,615.79
87,484.12
82,271.20
76,975.75
71,596.45
66,131.97
60,580.98
 54,942.10
49,213.93
43,395.07
37,484.07
31,479.48
25,379.83
19,183.59
12,889.25
6,495.24
- 0.00