Crecimeinto anual
Mix de Producos 1 2
A 5% 16,200 17,010
B 5% 14,000 14,700
Mix de Precios (valores Netos)
A 3% 14,000 14,420
B 6% 16,500 17,490
Forma de Venta 30% contado
70% crédito 60 días
Costos de Compras (valores netos)
Mix de Producos Precios 1 2
A 65% 9,100 9,373
B 55% 9,075 9,620
Forma de Compra 50% contado
50% Crédito 60 días
Stock minimo 5% de la venta año sgte
Estructura de Gastos Crecimento
1 2
Remuneraciones 6% 36,000,000 38,160,000
Arriendos 5% 24,000,000 25,200,000
Servicios 5% 6,000,000 6,300,000
Otros 5% 1,200,000 1,260,000
Todo contado
Inversión Inicial
Activo Fijo 100,000,000
Terreno 30,000,000
Terreno contado
Activo Fijo crédito 10 años, tasa 6% anual
20 años de depreciacion
tasa 10%
Capital Inicial 100,000,000
3 4 5
17,861 18,754 19,691
15,435 16,207 17,017
14,853 15,298 15,757
18,539 19,652 20,831
3 4 5
9,654 9,944 10,242
10,197 10,808 11,457
3 4 5
40,449,600 42,876,576 45,449,171
26,460,000 27,783,000 29,172,150
6,615,000 6,945,750 7,293,038
1,323,000 1,389,150 1,458,608
Años Inicial 1 2
Activos
Caja -$35,541,302 $13,822,429
CLIENTES $381,347,400 $418,488,538
EXISTENCIAS $14,409,675 $30,777,447
TERRENO $30,000,000 $30,000,000 $30,000,000
ACTIVO FIJO $100,000,000 $100,000,000 $100,000,000
DEP. ACUM $5,000,000 $10,000,000
IVA CF $ 75,027,138 $ 61,357,755
TOTAL ACTIVOS $560,242,912 $644,446,169
Pasivos y patrimonio
PROVEEDORES $ 171,883,407 $ 188,398,154
CUENTAS POR PAGAR
IVA DF $ 86,982,000 $ 95,453,568
(PAGO IVA) $ 11,954,862 $ 34,095,813
PRESTAMOS $ 110,851,487 $ 101,204,943
PROVISION IMPTO RENTA $ 27,669,838 $ 32,042,054
TOTAL PASIVOS $ 385,431,869 $ 383,002,906
CAPITAL $100,000,000 $100,000,000
$100,000,000
RESULTADO ACUM $ 74,811,042
RESULTADO EJERCICIO $ 74,811,042 $ 86,632,221
TOTAL PATRIMONIO $ 100,000,000 $174,811,042 $261,443,264
PASIVO PATRIMONIO $ 560,242,912 $ 644,446,169
CONTROL $0 $0
ESTADO DE RESULTADO PROYECTADO 1 2
VENTAS $ 457,800,000 $ 502,387,200
(COSTOS) $ 274,470,000 $ 300,267,780
MARGEN $ 183,330,000 $ 202,119,420
REMUNERACIONES $ 36,000,000 $ 38,160,000
ARRIENDOS $ 24,000,000 $ 25,200,000
SERVICIOS $ 6,000,000 $ 6,300,000
OTROS $ 1,200,000 $ 1,260,000
GASTOS GENERALES $ 67,200,000 $ 70,920,000
DEPRECIACION $ 5,000,000 $ 5,000,000
ITE $ 952,000
PATENTE 0.50% $ 500,000 $ 874,055
INTERES 7,197,120 6,651,089
RESULTADO ANTES DE IMPUESTO $ 102,480,880 $ 118,674,276
IMPUESTO A LA RENTA 27% $ 27,669,838 $ 32,042,054
FLUJO NETO $ 74,811,042 $ 86,632,221
SITUACION INV. EXTRANJERO
AÑO 1 2 3
BASE IMPONIBLE 74811042.4 86632221.17885 99004539.4513
INCREMENTO 0.369863 27669836.5751912 32042053.22187 36618115.9751
BASE INCREMENTADA 102480878.975191 118674274.4007 135622655.426
TASA DE RETENCION 0.35 35868307.6413169 41535996.04025 47467929.3992
(CREDITO IPC) 0.27 27669836.5751912 32042053.22187 36618115.9751
IMPUESTO A RETENER 8198471.06612572 9493942.81838 10849813.4242
REMESA NETA 66612571.3338743 77138278.36047 88154726.0272
3 4 5
$70,919,751 $136,947,706 $221,384,622
$459,341,608 $504,286,529 $553,742,932
$49,326,227 $70,303,220 $73,285,127
$30,000,000 $30,000,000 $30,000,000
$100,000,000 $100,000,000 $100,000,000
$15,000,000 $20,000,000 $25,000,000
$ 67,211,457 $ 73,641,005 $ 76,748,085
$761,799,042 $895,178,461 $1,030,160,766
$ 206,542,059 $ 226,479,901 $ 236,003,329
$ 104,771,795 $ 115,023,338 $ 126,303,910
$ 37,560,338 $ 41,382,333 $ 49,555,825
$ 90,979,606 $ 80,140,749 $ 68,651,560
$ 36,618,117 $ 41,706,631 $ 47,397,857
$ 401,351,239 $ 421,968,286 $ 428,800,831
$100,000,000 $100,000,000 $100,000,000
$ 161,443,264 $ 260,447,803 $ 373,210,175
$ 99,004,539 $ 112,762,372 $ 128,149,760
$360,447,803 $473,210,175 $601,359,936
$ 761,799,042 $ 895,178,461 $ 1,030,160,766
$0 $0 $0
3 4 5
$ 551,430,501 $ 605,385,990 $ 664,757,422
$ 328,580,732 $ 359,661,495 $ 393,662,343
$ 222,849,770 $ 245,724,495 $ 271,095,078
$ 40,449,600 $ 42,876,576 $ 45,449,171
$ 26,460,000 $ 27,783,000 $ 29,172,150
$ 6,615,000 $ 6,945,750 $ 7,293,038
$ 1,323,000 $ 1,389,150 $ 1,458,608
$ 74,847,600 $ 78,994,476 $ 83,372,966
$ 5,000,000 $ 5,000,000 $ 5,000,000
$ 1,307,216 $ 1,802,239 $ 2,366,051
6,072,297 5,458,776 4,808,445
$ 135,622,657 $ 154,469,003 $ 175,547,617
$ 36,618,117 $ 41,706,631 $ 47,397,857
$ 99,004,539 $ 112,762,372 $ 128,149,760
4 5 TOTAL PROYECTADO
112762372.3778 128149760.2902 Err:522
41706629.33477 47397854.7902141 Err:522
154469001.7126 175547615.080414 Err:522
Err:522
54064150.5994 61441665.2781448 Err:522
41706629.33477 47397854.7902141 Err:522
12357521.26463 14043810.4879307 Err:522
100404851.1132 114105949.802269 Err:522
Mix de Producos 1 2
A 5% 16,200 17,010
B 5% 14,000 14,700
Mix de Precios (valores Netos)
A 3% 14,000 14,420
B 6% 16,500 17,490
Ventas proyectadas 1 2
A $ 226,800,000 $ 245,284,200
B $ 231,000,000 $ 257,103,000
TOTAL VENTAS NETAS $ 457,800,000 $ 502,387,200
IVA DF 19% $ 86,982,000 $ 95,453,568
TOTAL VENTAS BRUTAS $ 544,782,000 $ 597,840,768
CONTADO 30% $ 163,434,600 $ 179,352,230
CREDITO 70% $ 381,347,400 $ 418,488,538
3 4 5
17,861 18,754 19,691
15,435 16,207 17,017
14,853 15,298 15,757
18,539 19,652 20,831
3 5
$ 265,274,862 $ 286,894,764 $ 310,276,687
$ 286,155,639 $ 318,491,226 $ 354,480,735
$ 551,430,501 $ 605,385,990 $ 664,757,422
$ 104,771,795 $ 115,023,338 $ 126,303,910
$ 656,202,297 $ 720,409,328 $ 791,061,332
$ 196,860,689 $ 216,122,798 $ 237,318,400 CAJA
$ 459,341,608 $ 504,286,529 $ 553,742,932 CXC
Proyeccion de Compras
Producto A 1 2 3
Ventas esperadas 16,200 17,010 17,861
compras requeridas 16,200 17,010 17,861
Stock mínimo 5% 851 893 938
Total Compras A 17,051 17,903 18,798
Valor Referencia 14,000 14,420 14,853
Precio de Compra 65% 9,100 9,373 9,654
Total Compras A $ 155,159,550 167,805,053 181,481,165
Proyeccion de Compras
Producto B 1 2 3
Ventas esperadas 14,000 14,700 15,435
Compra requerida 14,000 14,700 15,435
Stock mínimo 5% 735 772 810
Total Compras A $ 14,735 $ 15,472 $ 16,245
Valor Referencia $ 16,500 $ 17,490 $ 18,539
Precio de Compra 55% $ 9,075 $ 9,620 $ 10,197
Total Compras B $ $ 133,720,125 $ 148,830,499 $ 165,648,346
total compras A y B 288,879,675 316,635,552 347,129,511
IVA Débito 0.19 54,887,138 60,160,755 65,954,607
Compra Total 343,766,813 376,796,307 413,084,118
Contado 50% 171,883,407 188,398,154 206,542,059
Crédito 50% 171,883,407 188,398,154 206,542,059
Cálculo Costo de Ventas Producto A
Saldo Inicial Unidades - 851 1,744
Unidades Compradas 17,051 17,903 18,798
Subtotal Disponible 17,051 18,754 20,542
Unidades Vendidas 16,200 17,010 17,861
Saldo Final Unidades 851 1,744 2,681
Saldo Inicial Valorizado - 7,739,550 16,320,473
Unidades Compradas 155,159,550 167,805,053 181,481,165
155,159,550 175,544,603 197,801,638
Total Unidades 17,051 18,754 20,542
Costo Promedio 9,100 9,361 9,629
Unidades Vendidas 16,200 17,010 17,861
Costo de Venta A 147,420,000 159,224,130 171,983,621
Saldo de Existencias 7,739,550 16,320,473 25,818,017
Total Control-------> 155,159,550 175,544,603 197,801,638
Cálculo Costo de Ventas Producto B
Saldo Inicial Unidades - 735 1,507
Unidades Compradas 14,735 15,472 16,245
Subtotal Disponible 14,735 16,207 17,752
Unidades Vendidas 14,000 14,700 15,435
Saldo Final Unidades 735 1,507 2,317
Saldo Inicial Valorizado - 6,670,125 14,456,974
Unidades Compradas 133,720,125 148,830,499 165,648,346
133,720,125 155,500,624 180,105,320
Total Unidades 14,735 16,207 17,752
Costo Promedio 9,075 9,595 10,146
Unidades Vendidas 14,000 14,700 15,435
Costo de Venta b 127,050,000 141,043,650 156,597,111
Saldo de Existencias 6,670,125 14,456,974 23,508,209
Total Control-------> 133,720,125 155,500,624 180,105,320
COSTO VENTA TOTAL 274,470,000 300,267,780 328,580,732
EXISTENCIAS TOTAL 14,409,675 30,777,447 49,326,227
4 5
18,754 19,691
18,754 19,691
985 -
19,738 19,691
15,298 15,757
9,944 10,242
196,271,880 201,679,846 902397495.05427
4 5
16,207 17,017
16,207 17,017
851 -
$ 17,058 $ 17,017
$ 19,652 $ 20,831
$ 10,808 $ 11,457
$ 184,366,609 $ 194,964,404 827529982.34432
380,638,489 396,644,251
72,321,313 75,362,408
452,959,802 472,006,658
226,479,901 236,003,329
226,479,901 236,003,329
2,681 3,666
19,738 19,691
22,419 23,357
18,754 19,691
3,666 3,666
25,818,017 36,313,759
196,271,880 201,679,846
222,089,898 237,993,605
22,419 23,357
9,906 10,189
18,754 19,691
185,776,139 200,641,670 865,045,560
36,313,759 37,351,935 37,351,935
222,089,898 237,993,605 902,397,495
2,317 3,168
17,058 17,017
19,375 20,185
16,207 17,017
3,168 3,168
23,508,209 33,989,461
184,366,609 194,964,404
207,874,818 228,953,865
19,375 20,185
10,729 11,343
16,207 17,017
173,885,356 193,020,673 791,596,790
33,989,461 35,933,192 35,933,192
207,874,818 228,953,865 827,529,982
359,661,495 393,662,343
70,303,220 73,285,127
Estructura de Gastos
1 2 3 4
Remuneraciones 6% 36,000,000 38,160,000 40,449,600 42,876,576
Arriendos 5% 24,000,000 25,200,000 26,460,000 27,783,000
Servicios 5% 6,000,000 6,300,000 6,615,000 6,945,750
Otros 5% 1,200,000 1,260,000 1,323,000 1,389,150
TOTAL GASTOS 67,200,000 70,920,000 74,847,600 78,994,476
IVA 19% 1,140,000 1,197,000 1,256,850 1,319,693
TOTAL GASTOS 68,340,000 72,117,000 76,104,450 80,314,169
0% - - - -
CONTADO 100% 68,340,000 72,117,000 76,104,450 80,314,169
5
45,449,171
29,172,150
7,293,038
1,458,608
83,372,966
1,385,677
84,758,643
-
84,758,643
Inversión Inicial
Activo Fijo 100,000,000
Terreno 30,000,000
Terreno contado
Activo Fijo crédito 10 años, tasa 6% anual
Inicial 1 2 3 4
Terreno 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000
Activo fijo $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000
Depreciación 20 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000
Depreciación Acum $ 5,000,000 $ 10,000,000 $ 15,000,000 $ 20,000,000
IVA AF $ 19,000,000 $ 19,000,000 $ 19,000,000 $ 19,000,000 $ 19,000,000
total bruto 119,000,000
5 6 7 8 9 10 11
30,000,000 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000
$ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000
$ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000
$ 25,000,000 $ 30,000,000 $ 35,000,000 $ 40,000,000 $ 45,000,000 $ 50,000,000 $ 55,000,000
$ 19,000,000 $ 19,000,000 $ 19,000,000 $ 19,000,000 $ 19,000,000 $ 19,000,000
12 13 14 15 16 17 18
30,000,000 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000 30,000,000
$ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000 $ 100,000,000
$ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000
$ 60,000,000 $ 65,000,000 $ 70,000,000 $ 75,000,000 $ 80,000,000 $ 85,000,000 $ 90,000,000
19 20
30,000,000 30,000,000
$ 100,000,000 $ 100,000,000
$ 5,000,000 $ 5,000,000
$ 95,000,000 $ 100,000,000
PROYECCIONES EMPRESA Pago cuota
COMPRA AF 100,000,000 PRESTAMO 119,952,000
IVA CF 19,000,000 PLAZO 10
ITE 0,80% 952,000 INTERES ANUAL 6%
TASA EFE. ANUAL 0.4416052231
TOTAL BRUTO 119,952,000
Año Saldo Cuota Interés Neto Saldo
1 119,952,000 16,297,633 7,197,120 9,100,513 110,851,487
2 110,851,487 16,297,633 6,651,089 9,646,544 101,204,943
3 101,204,943 16,297,633 6,072,297 10,225,337 90,979,606
4 90,979,606 16,297,633 5,458,776 10,838,857 80,140,749
5 80,140,749 16,297,633 4,808,445 11,489,188 68,651,560
6 68,651,560 16,297,633 4,119,094 12,178,540 56,473,021
7 56,473,021 16,297,633 3,388,381 12,909,252 43,563,769
8 43,563,769 16,297,633 2,613,826 13,683,807 29,879,961
9 29,879,961 16,297,633 1,792,798 14,504,836 15,375,126
10 15,375,126 16,297,633 922,508 15,375,126 0
162,976,333 43,024,333 119,952,000
1 2 3 4
IVA AF $ 19,000,000
IVA COMPRAS $ 54,887,138 $ 60,160,755 $ 65,954,607 $ 72,321,313
IVA SERVICIOS $1,140,000 $1,197,000 $1,256,850 $1,319,693
IVA SERVICIOS 1,140,000 1,197,000 1,256,850 1,319,693
TOTAL CREDITO $ 75,027,138 $ 61,357,755 $ 67,211,457 $ 73,641,005
IVA DEBITO $ 86,982,000 $ 95,453,568 $ 104,771,795 $ 115,023,338
IVA A PAG $ 11,954,862 $ 34,095,813 $ 37,560,338 $ 41,382,333
5
$ 75,362,408
$1,385,677
1,385,677
$ 76,748,085
$ 126,303,910
$ 49,555,825
1 2 3
PATRIMONIO $ 100,000,000 $ 174,811,042 $ 261,443,264
TASA 0.50% 0.50% 0.50%
PATENTE $500,000 $874,055 $1,307,216
4 5
$ 360,447,803 $ 473,210,175
0.50% 0.50%
$1,802,239 $2,366,051
1 2
RESULTADO CONTABLE $ 102,480,880 $ 118,674,276
TASA 27.00% 27.00%
Provision $27,669,838 $32,042,054
3 4 5
$ 135,622,657 $ 154,469,003 $ 175,547,617
27.00% 27.00% 27.00%
$36,618,117 $41,706,631 $47,397,857
* CAPITAL
1 2 3
SALDO INICIAL 100,000,000 -35,541,302 13,822,429
(TERRENO) 30,000,000
PRESTAMO 119,952,000
(ACTIVO FIJO) 119,000,000
VENTAS CONTADO 163,434,600 179,352,230 196,860,689
COBRAZA VENTAS 381,347,400 418,488,538
(COMPRAS CONTADO) 171,883,407 188,398,154 206,542,059
(COMPRAS CREDITO) 171,883,407 188,398,154
(PAGO GASTOS)
(PAGO GASTOS A CONTADO.) 68,340,000 72,117,000 76,104,450
(PAGO PRESTAMO) 16,297,633 16,297,633 16,297,633
(PAGO IVA) 11,954,862 34,095,813 37,560,338
(ITE) 952,000
(PATENTE) 500,000 874,055 1,307,216
MPUESTO RENTA - 27,669,838 32,042,054
Saldo Caja -35,541,302 13,822,429 70,919,751
4 5 6
70,919,751 136,947,706 221,384,622
216,122,798 237,318,400
459,341,608 504,286,529 553,742,932
226,479,901 236,003,329
206,542,059 226,479,901 236,003,329
80,314,169 84,758,643 -
16,297,633 16,297,633 16,297,633
41,382,333 49,555,825 -
1,802,239 2,366,051 -
36,618,117 41,706,631 47,397,857
136,947,706 221,384,622 475,428,736
1 2 3
Reultado antes de Impuestos 102,480,880 118,674,276 135,622,657
Impuesto Renta
Resultado Final 102,480,880 118,674,276 135,622,657
Tasa de Descuento 5% 5% 5%
Factor de Descuento 1.050 1.103 1.158
Flujo Descontado -100,000,000 97,600,838 107,641,066 117,155,950
Inversión Inicial
Excedente Inversión
TIR
1 2 3
Reultado antes de Impuestos 102,480,880 118,674,276 135,622,657
Impuesto Renta 27% 27,669,838 32,042,054 36,618,117
Resultado Final 74,811,042 86,632,221 99,004,539
Tasa de Descuento 5% 5% 5%
Factor de Descuento 1.05 1.1025 1.157625
Flujo Descontado -100,000,000 71,248,612 78,577,978 85,523,844
Inversión Inicial
Excedente Inversión
TIR
4 5
154,469,003 175,547,617
154,469,003 175,547,617 686,794,432
5% 5% 5%
1.216 1.276
127,082,031 137,546,151 587,026,037
-100,000,000
487,026,037
103%
4 5
154,469,003 175,547,617
41,706,631 47,397,857
112,762,372 128,149,760 501,359,936
5% 5%
1.21550625 1.2762815625
92,769,883 100,408,690 428,529,007
-100,000,000
328,529,007
74%
