Null

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 48

CAPITAL

SOCIOS APORTE EN $ TOTAL


3 490,877.15 1,472,631.44
TERRENO
METRO PRECIO EN $ TOTAL
450 185.00 83,250.00
OBRAS CIVILES
METRO PRECIO EN $ TOTAL
300 340.00 102,000.00
MATERIA PRIMA
Tarjeta PRECIO EN $ TOTAL ANUAL TOTAL BI.
21 1,450.00 30,450.00 5,075.00
INSUMOS
Caja PRECIO EN $ TOTAL ANUAL TOTAL BI.
15 600.00 9,000.00 1,500.00
AGUA POTABLE
Mes TOTAL BI. e TOTAL BI.
1.5 6,595.00 9,892.50 6.96 1,421.34 118710
ELECTRICIDAD
Kwh/Mes Mes COSTO MES TOTAL BI. e TOTAL BI.
788 0.27 317.16 3,805.92 6.96 546.83
TELEFONIA
Mes TOTAL BI. e TOTAL BI.
765.60 1,531.20 6.96 220.00
ESTRUCTURA DE CAPITAL
En bolivianos
APORTE APORTE
DESCRPCION REF
PROPIO EXTERNO

ACTIVOS FIJOS
Terrenos 278,800.00
Obras civiles 150,000,000.00
Muebles y enseres 6,231.00
Equipo de computacion 6,198.00
Maquinaria 10,398,000.00
Equipo 0.00
Vehiculos 116,928.00
Escalamiento de precios 3,039,236.37
SUB TOTAL ACTIVOS FIJOS 0.00 163,845,393.37

ACTIVOS DIFERIDOS

Tramites legales 4,885.00


Montaje 4,000.00
SUB TOTAL ACTIVOS DIFERIDOS 8,885.00 0.00
CAPITAL DE OPERACIONES
Materia Prima 442,034.00
Materiales Directos 6,864.00
Materiales Indirectos 4,048.00
MOD 200,772.00
MOI 525,897
Pago Beneficios Sociales 22,5% 163,500.53
Servicios de Energia Electrica 3,805.92
Servicios de Agua Potable 118,710.00
Servicio de Telefonia 7,000.00
Servicio de Internet 0.00

SUB TOTAL 1,472,631.44 0.00


TOTAL INVERSIONES 1,481,516.44 163,845,393.37
PARTICIPACION 0.90% 99.10%
0.0089611331 0.99103886689
En bolivianos ESCALAMIENTO DE PRECIOS
INVERSION
DETALLE REF MONTO $us
TOTAL
ACTIVOS FIJOS
Terrenos 278,800.00
278,800.00 Obras civiles 150,000,000.00
150,000,000.00 Muebles y enseres 6,231.00
6,231.00 Equipo de computacion 6,198.00
6,198.00 Maquinaria 10,398,000.00
10,398,000.00 Equipo 0.00
0.00 Vehiculos 116,928.00
116,928.00 TOTAL ESCALAMIENTO 160,806,157.00
3,039,236.37
163,845,393.37

4,885.00
4,000.00
8,885.00

442,034.00
6,864.00
4,048.00
200,772.00 726,669
525,897.00 163500.525
163,500.53
3,805.92
118,710.00
7,000.00
0.00

1,472,631.44
165,326,909.81
100%
LAMIENTO DE PRECIOS
% tasa VALOR
TOTAL
inflacionaria ESCALAMIENTO

1.89% 5,269.32 284,069.32


1.89% 2,835,000.00 152,835,000.00
1.89% 117.77 6,348.77
1.89% 117.14 6,315.14
1.89% 196,522.20 10,594,522.20
1.89% 0.00 0.00
1.89% 2,209.94 119,137.94
3,039,236.37 163,845,393.37
CUADRO DE DEPRECIACIONES Y AMORTIZACIONES
Años
CONCEPTO INVERSION $us % DEPRECIACION
Depreciacion
ACTIVOS FIJOS
Terrenos 284,069.32 0.00% 0
Obras civiles 152,835,000.00 2.50% 40
Muebles y enseres 6,348.77 10.00% 10
Equipo de computacion 6,315.14 25.00% 4
Maquinaria 10,594,522.20 12.50% 8
Equipo 0.00 12.50% 8
Vehiculos 119,137.94 20.00% 5
SUB TOTAL 163,845,393.37

ACTIVOS DIFERIDOS

Tramites legales 4,885.00 50.00% 2


Montaje 4,000.00 50.00% 2
SUB TOTAL 8,885.00
CAPITAL DE TRABAJO
Capital de Operación 1,472,631.44 0.00% 0
SUB TOTAL 1,472,631.44
TOTAL DEPRECIACIONES Y 165,326,909.81
AMORTIZACIONES Año
CUADRO DE DEPRECIACIONES Y AMORTIZACIONES
1 2 3 4 5 6 7 8
2023 2024 2025 2026 2027 2028 2029 2030

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00


### ### ### ### ### ### ### ###
634.88 634.88 634.88 634.88 634.88 634.88 634.88 634.88
1,578.79 1,578.79 1,578.79 1,578.79 1,549.50 1,549.50 1,549.50 1,549.50
### ### ### ### ### ### ### ###
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
23,827.59 23,827.59 23,827.59 23,827.59 23,827.59 23,385.60 23,385.60 23,385.60
### ### ### ### ### ### ### ###

2,442.50 2,442.50 0.00 0.00 0.00 0.00 0.00 0.00


2,000.00 2,000.00 0.00 0.00 0.00 0.00 0.00 0.00
4,442.50 4,442.50 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
### ### ### ### ### ### ### ###
2023 2024 2025 2026 2027 2028 2029 2030
CUADRO DE DCUADRO DE DEPRECIACIONES Y AMORTIZACIONES
9 10 1 2 3
VALOR RESIDUAL CONCEPTO
2031 2032 2022 2023 2024
ACTIVOS FIJOS
0.00 0.00 0.00 Terrenos 0.00 0.00 0.00
### ### 114,626,250.00 Obras civiles 1,306.79 1,306.79 1,306.79
634.88 634.88 0.00 Muebles y en 1,107.29 1,107.29 1,107.29
1,549.50 1,549.50 3,099.00 Equipo de co 1,180.00 1,180.00 1,180.00
### ### 7,798,500.00 Maquinaria 3,479.63 3,479.63 3,479.63
0.00 0.00 0.00 Equipo 931.77 931.77 931.77
23,385.60 23,385.60 0.00 Vehiculos 30,930.00 30,000.00 30,000.00
### ### 122,427,849.00 SUB TOTAL 38,935.48 38,005.48 38,005.48

ACTIVOS DIFERIDOS

0.00 0.00 0.00 Tramites lega 0.00 0.00 0.00


0.00 0.00 0.00 Montaje 0.00 0.00 0.00
0.00 0.00 0.00 SUB TOTAL 0.00 0.00 0.00
CAPITAL DE TRABAJO
0.00 0.00 0.00 Capital de Op 0.00 0.00 0.00
0.00 0.00 0.00 SUB TOTAL 0.00 0.00 0.00
ONES Y
### ### 122,427,849.00 AMORTIZAC 38,935.48 38,005.48 38,005.48
2031 2032 RESIDUAL IONES 2027 2028 2029
ES Y AMORTIZACIONES
4 5 6
2025 2026 2032 VALOR RESIDUAL

0.00 0.00 0.00 0.00


1,306.79 1,306.79 1,306.79 39,203.78
1,107.29 1,107.29 1,107.29 0.00
1,180.00 1,180.00 1,180.00 2,360.00
3,479.63 3,375.00 3,375.00 20,250.00
931.77 903.75 903.75 5,422.50
30,000.00 30,000.00 30,000.00 0.00
38,005.48 37,872.84 37,872.84 67,236.28

0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00
38,005.48 37,872.84 37,872.84 67,236.28
2030 2031 2032 RESIDUAL
CUADRO DE AMORTIZACIONES Y COSTO FINANCIERO
CUOTAS ANUALES CONSTANTES (FRANCES)
PERIODO 0.06
INTERESES
AÑO SEMESTRE AMORTIZACION
SALDO CAPITAL 6.00%
0
0 163,845,393.37
1 163,845,393.37 9,830,723.60 4,454,064.43
1
2 159,391,328.94 9,563,479.74 4,721,308.30
3 154,670,020.64 9,280,201.24 5,004,586.80
2
4 149,665,433.84 8,979,926.03 5,304,862.00
5 144,360,571.84 8,661,634.31 5,623,153.72
3
6 138,737,418.12 8,324,245.09 5,960,542.95
7 132,776,875.17 7,966,612.51 6,318,175.52
4
8 126,458,699.65 7,587,521.98 6,697,266.05
9 119,761,433.59 7,185,686.02 7,099,102.02
5
10 112,662,331.58 6,759,739.89 7,525,048.14
11 105,137,283.44 6,308,237.01 7,976,551.03
6
12 97,160,732.41 5,829,643.94 8,455,144.09
13 88,705,588.32 5,322,335.30 8,962,452.73
7
14 79,743,135.59 4,784,588.14 9,500,199.90
15 70,242,935.69 4,214,576.14 10,070,211.89
8
16 60,172,723.80 3,610,363.43 10,674,424.61
17 49,498,299.19 2,969,897.95 11,314,890.08
9
18 38,183,409.11 2,291,004.55 11,993,783.49
19 26,189,625.62 1,571,377.54 12,713,410.50
10
20 13,476,215.13 808,572.91 13,476,215.13
21 0.00 0.00 14,284,788.03
TOTALES 121,850,367.30 178,130,181.40

AMORTIZACION -14,284,788.03 14,284,788.03


IZACIONES Y COSTO FINANCIERO
LES CONSTANTES (FRANCES)

AMORTIZACION
CUOTA PERIODICA INTERES ANUAL CUOTA ANUAL
ANUAL

14,284,788.03
14,284,788.03 19,394,203.34 9,175,372.73 28,569,576.07
14,284,788.03
14,284,788.03 18,260,127.27 10,309,448.80 28,569,576.07
14,284,788.03
14,284,788.03 16,985,879.40 11,583,696.67 28,569,576.07
14,284,788.03
14,284,788.03 15,554,134.49 13,015,441.58 28,569,576.07
14,284,788.03
14,284,788.03 13,945,425.91 14,624,150.16 28,569,576.07
14,284,788.03
14,284,788.03 12,137,880.95 16,431,695.12 28,569,576.07
14,284,788.03
14,284,788.03 10,106,923.43 18,462,652.63 28,569,576.07
14,284,788.03
14,284,788.03 7,824,939.57 20,744,636.50 28,569,576.07
14,284,788.03
14,284,788.03 5,260,902.50 23,308,673.57 28,569,576.07
14,284,788.03
14,284,788.03 2,379,950.44 26,189,625.62 28,569,576.07
14,284,788.03
299,980,548.70 121,850,367.30 163,845,393.37 285,695,760.67
COSTOS TOTALES: PRIMER AÑO
En bolivianos
COSTO
DESCRIPCION COSTO FIJO
VARIABLES
COSTOS
Materia Prima 442,034.00
Materiales Directos 6,864.00
Materiales Indirectos 4,048.00
MOD 200,772.00
Previsiones Sociales 22,5% 2,750.13
MOI 525,897.00
Previsiones Sociales 22,5% 4,623.66
Servicios de Energia Electrica 3,805.92
Servicios de Agua Potable 118,710.00
Servicio de Telefonia 7,000.00
Servicio de Internet 0.00
DEPRECIACIONES Y AMORTIZACIONES
Activo Fijo 5,171,231.52
Activo Diferido 4,442.50
COSTO FINANCIERO
Intereses Credito Externo 19,394,203.34
TOTAL COSTO ANUAL 25,233,961.94 652,420.13

Q= 69,930.45
CVMe= 9.33
CF Cme= 370.17
PEqV 
 CVMe  Pv= 435.50
1  
 Pu  Pf= 500.57

CF PEqV= 25,713,198.88
PEqQ 
Pu  CVMe PEqQ= 51,367.60
VENTAS P*Q 25,713,198.88
En bolivianos
COSTO TOTAL

442,034.00
6,864.00
4,048.00
200,772.00
2,750.13
525,897.00
4,623.66
3,805.92
118,710.00
7,000.00
0.00

5,171,231.52
4,442.50

19,394,203.34
25,886,382.07
5333 320
31998 5333.33333
1663896
COSTOS TOTALES PROYECTADOS
Año 2023
CAPACIDAD INSTALADA DE PRODUCCION %: 100.00%
CONCEPTO
COSTO VARIABLE 652,420.13
Costos de Produccion
Materia Prima 442,034.00
Materiales Directos 6,864.00
MOD 200,772.00
Previsiones Sociales 34.38% 2,750.13
COSTO FIJO 25,234,537.60
Materiales Indirectos 525,897.00
MOI 4,623.66
Previsiones Sociales 34.38% 4,623.66
Servicios de Energia Electrica 3,805.92
Servicios de Agua Potable 118,710.00
Servicio de Telefonia 7,000.00
Servicio de Internet 0.00

DEPRECIACIONES Y AMORTIZACIONES
Activo Fijo 5,171,231.52
Activo Diferido 4,442.50
COSTO FINANCIERO
Intereses Credito Externo 19,394,203.34
TOTAL COSTO FIJO 25,234,537.60
TOTAL COSTO VARIABLE 652,420.13
COSTO TOTAL EN BOLIVIANOS 25,886,957.73
MONTO PARA CREDITO FISCAL 1,309,706.58

COSTOS TOTALES PROYECTADOS


Año 2028
CAPACIDAD INSTALADA DE PRODUCCION %: 1
CONCEPTO
COSTO VARIABLE 3,017,857.61
Costos de Produccion
Materia Prima 3,000,243.48
Materiales Directos 6,864.00
MOD 8,000.00
Previsiones Sociales 34.38% 2,750.13
COSTO FIJO 137,233.68
Materiales Indirectos 13,450.00
MOI 4,623.66
Previsiones Sociales 34.38% 4,623.66
Servicios de Energia Electrica 45,442.00
Servicios de Agua Potable 3,367.19
Servicio de Telefonia 942.00
Servicio de Internet 1,548.00

DEPRECIACIONES Y AMORTIZACIONES
Activo Fijo 38,005.48
Activo Diferido 0.00
COSTO FINANCIERO
Intereses Credito Externo 25,231.70
TOTAL COSTO FIJO 137,233.68
TOTAL COSTO VARIABLE 3,017,857.61
COSTO TOTAL EN BOLIVIANOS 3,155,091.29
MONTO PARA CREDITO FISCAL 3,084,480.33
COSTOS TOTALES PROYECTADOS
2024 2025 2026 2027 2028 2029 2030
100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

652,420.13 652,420.13 652,420.13 652,420.13 652,420.13 652,420.13 652,420.13

442,034.00 442,034.00 442,034.00 442,034.00 442,034.00 442,034.00 442,034.00


6,864.00 6,864.00 6,864.00 6,864.00 6,864.00 6,864.00 6,864.00
200,772.00 200,772.00 200,772.00 200,772.00 200,772.00 200,772.00 200,772.00
2,750.13 2,750.13 2,750.13 2,750.13 2,750.13 2,750.13 2,750.13
24,100,461.53 ### ### ### ### ### ###
525,897.00 525,897.00 525,897.00 525,897.00 525,897.00 525,897.00 525,897.00
4,623.66 4,623.66 4,623.66 4,623.66 4,623.66 4,623.66 4,623.66
4,623.66 4,623.66 4,623.66 4,623.66 4,623.66 4,623.66 4,623.66
3,805.92 3,805.92 3,805.92 3,805.92 3,805.92 3,805.92 3,805.92
118,710.00 118,710.00 118,710.00 118,710.00 118,710.00 118,710.00 118,710.00
7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00

5,171,231.52 5,171,231.52 5,171,231.52 5,171,202.24 ### ### ###


4,442.50 0.00 0.00 0.00 0.00 0.00 0.00

18,260,127.27 ### ### ### ### ### ###


24,100,461.53 ### ### ### ### ### ###
652,420.13 652,420.13 652,420.13 652,420.13 652,420.13 652,420.13 652,420.13
24,752,881.66 ### ### ### ### ### ###
1,309,706.58 1,309,706.58 1,309,706.58 1,309,706.58 ### ### ###

2029 2030 2031 2032


1 1 1 1

3,017,857.61 3,017,857.61 3,017,857.61 3,017,857.61

3,000,243.48 3,000,243.48 3,000,243.48 3,000,243.48


6,864.00 6,864.00 6,864.00 6,864.00
8,000.00 8,000.00 8,000.00 8,000.00
2,750.13 2,750.13 2,750.13 2,750.13
132,970.37 128,202.69 122,738.32 116,775.81
13,450.00 13,450.00 13,450.00 13,450.00
4,623.66 4,623.66 4,623.66 4,623.66
4,623.66 4,623.66 4,623.66 4,623.66
45,442.00 45,442.00 45,442.00 45,442.00
3,367.19 3,367.19 3,367.19 3,367.19
942.00 942.00 942.00 942.00
1,548.00 1,548.00 1,548.00 1,548.00

38,005.48 38,005.48 37,872.84 37,872.84


0.00 0.00 0.00 0.00

20,968.39 16,200.70 10,868.97 4,906.46


132,970.37 128,202.69 122,738.32 116,775.81
3,017,857.61 3,017,857.61 3,017,857.61 3,017,857.61
3,150,827.98 3,146,060.30 3,140,595.93 3,134,633.42
3,084,480.33 3,084,480.33 3,084,480.33 3,084,480.33
2031 2032
100.00% 100.00%

652,420.13 652,420.13
100 12.0000
442,034.00 442,034.00 80 9.6000
6,864.00 6,864.00 50 6.0000
200,772.00 200,772.00 27.6000
2,750.13 2,750.13 46.6000
### ###
525,897.00 525,897.00
4,623.66 4,623.66
4,623.66 4,623.66
3,805.92 3,805.92
118,710.00 118,710.00
7,000.00 7,000.00
0.00 0.00

### ###
0.00 0.00

### ###
### ###
652,420.13 652,420.13
### ###
### ###
Q 69,930.45 AAA
Pf 500.57 $us

ESTADO DE RESULTADO FINANCIERO


En bolivianos
CANTIDAD DE
CAPACIDAD PRECIOS INGRESOS COSTOS
AÑO PRODUCCION
INSTALADA % FACTURADOS PROYECTADOS TOTALES
unidad/Año

1 100.00% 69,930.45 500.57 35,005,249.59 25,886,957.73


2 100.00% 69,930.45 500.57 35,005,249.59 24,752,881.66
3 100.00% 69,930.45 500.57 35,005,249.59 23,474,191.29
4 100.00% 69,930.45 500.57 35,005,249.59 22,042,446.38
5 100.00% 69,930.45 500.57 35,005,249.59 20,433,708.52
6 100.00% 69,930.45 500.57 35,005,249.59 18,625,721.57
7 100.00% 69,930.45 500.57 35,005,249.59 16,594,764.06
8 100.00% 69,930.45 500.57 35,005,249.59 14,312,780.19
9 100.00% 69,930.45 500.57 35,005,249.59 11,724,177.84
10 100.00% 69,930.45 500.57 35,005,249.59 8,843,225.79
ESTADO DE RESULTADOS O DE PERDIDAS O GANANCIAS

UTILIDAD CREDITO FISCAL IVA IT


AÑO MONTO PCF $us
BRUTA $us
13.00% 13.00% 3.00%

1 9,118,291.86 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49


2 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
3 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
4 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
5 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
6 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
7 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
8 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
9 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49
10 ### 1,309,706.58 170,261.86 4,550,682.45 1,050,157.49

FLUJO DE CAJA NETO FINANCIERO


En bolivianos
FLUJO DE CAJA
UTILIDAD DEPRECIACION Y AMORTIZACION Y NETO
AÑO INVERSION
NETA $us AMORTIZACION CREDITO
FINANCIERO
0 -8,885.00
1 2,765,785.33 5,175,674.02 9,175,372.73 -1,233,913.37 -1,472,631.44
2 3,616,342.39 5,175,674.02 10,309,448.80 -1,517,432.39
3 4,575,360.17 5,171,231.52 11,583,696.67 -1,837,104.98
4 5,649,168.85 5,171,231.52 13,015,441.58 -2,195,041.21
5 6,855,722.24 5,171,202.24 14,624,150.16 -2,597,225.67 -4,720.00
6 8,211,712.46 5,170,760.25 16,431,695.12 -3,049,222.41 -150,000.00
7 9,734,930.59 5,170,760.25 18,462,652.63 -3,556,961.79
8 ### 5,170,760.25 20,744,636.50 -4,127,457.75 -38,950.00
9 ### 5,146,194.98 23,308,673.57 -4,774,608.34
10 ### 127,574,043.98 26,189,625.62 116,933,002.65
163,845,393.37
En bolivianos

UTILIDAD BRUTA

9,118,291.86
10,252,367.93
11,531,058.30
12,962,803.21
14,571,541.07
16,379,528.02
18,410,485.54
20,692,469.40
23,281,071.75
26,162,023.80
DAS O GANANCIAS
En bolivianos
DEBITO FISCAL RESULTADO IUE UTILIDAD
GESTION
NETA $us
13%+3% ANTES IUE 25.00%

5,600,839.93 ### 921,928.44 ###


5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###
5,600,839.93 ### ### ###

En bolivianos
FLUJO
MONETARIO
FM
-8,885.00
-2,706,544.81
-1,517,432.39
-1,837,104.98
-2,195,041.21
-2,601,945.67
-3,199,222.41
-3,556,961.79
-4,166,407.75
-4,774,608.34
116,933,002.65
Q 69,930.45 AAA
Pf 500.57 $us

ESTADO DE RESULTADO

CANTIDAD DE
CAPACIDAD PRECIOS INGRESOS
AÑO PRODUCCION
INSTALADA % FACTURADOS PROYECTADOS
Unidad/Año

1 100.00% 69,930.45 500.57 35,005,249.59


2 100.00% 69,930.45 500.57 35,005,249.59
3 100.00% 69,930.45 500.57 35,005,249.59
4 100.00% 69,930.45 500.57 35,005,249.59
5 100.00% 69,930.45 500.57 35,005,249.59
6 100.00% 69,930.45 500.57 35,005,249.59
7 100.00% 69,930.45 500.57 35,005,249.59
8 100.00% 69,930.45 500.57 35,005,249.59
9 100.00% 69,930.45 500.57 35,005,249.59
10 100.00% 69,930.45 500.57 35,005,249.59
ESTADO DE RESULTADOS O DE PERDIDAS O GANANCIAS

CREDITO FISCAL DEBITO FISCAL RESULTADO IUE


AÑO GESTION ANTES
13.00% 13%+3% IUE 25.00%

1 170,261.86 5,600,839.93 23,081,917.12 5,770,479.28


2 170,261.86 5,600,839.93 23,081,917.12 5,770,479.28
3 170,261.86 5,600,839.93 23,086,359.62 5,771,589.90
4 170,261.86 5,600,839.93 23,086,359.62 5,771,589.90
5 170,261.86 5,600,839.93 23,086,388.90 5,771,597.23
6 170,261.86 5,600,839.93 23,086,830.89 5,771,707.72
7 170,261.86 5,600,839.93 23,086,830.89 5,771,707.72
8 170,261.86 5,600,839.93 23,086,830.89 5,771,707.72
9 170,261.86 5,600,839.93 23,111,396.17 5,777,849.04
10 170,261.86 5,600,839.93 23,111,396.17 5,777,849.04

VANE SIN INFLACION


FLUJO TMAR
AÑO MONETARIO POND VANE
F.M. 11.53%
0 -163,854,278.37 1.000000 -163,854,278.37
1 21,014,480.42 0.896609 18,841,767.62
2 22,487,111.86 0.803907 18,077,553.42
3 22,486,001.24 0.720790 16,207,692.56
4 22,486,001.24 0.646267 14,531,959.43
5 22,481,273.92 0.579449 13,026,743.15
6 22,335,883.42 0.519539 11,604,356.27
7 22,485,883.42 0.465823 10,474,441.14
8 22,446,933.42 0.417661 9,375,207.98
9 22,479,742.10 0.374478 8,418,179.92
10 144,907,591.10 0.335761 48,654,274.70
VANE= 5,357,897.82
VANE= 5,357,897.82

VANE CON INFLACION


FLUJO TMAR
AÑO MONETARIO POND VANE
F.M. 13.64%
0 -163,854,278.37 1.000000 -163,854,278.37
1 21,411,654.10 0.879977 18,841,767.62
2 23,345,157.31 0.774360 18,077,553.42
3 23,785,205.99 0.681419 16,207,692.56
4 24,234,746.38 0.599633 14,531,959.43
5 24,687,591.83 0.527664 13,026,743.15
6 24,991,510.60 0.464332 11,604,356.27
7 25,634,856.48 0.408602 10,474,441.14
8 26,074,111.38 0.359560 9,375,207.98
9 26,605,742.57 0.316405 8,418,179.92
10 174,745,805.24 0.278429 48,654,274.70
VANE= 5,357,897.82
En bolivianos

COSTOS COSTOS UTILIDAD


TOTALES FINANCIEROS BRUTA

25,886,957.73 19,394,203.34 28,512,495.20 6,492,754.39 6,492,754.39


24,752,881.66 18,260,127.27 28,512,495.20
23,474,191.29 16,985,879.40 28,516,937.70
22,042,446.38 15,554,134.49 28,516,937.70
20,433,708.52 13,945,425.91 28,516,966.98
18,625,721.57 12,137,880.95 28,517,408.97
16,594,764.06 10,106,923.43 28,517,408.97
14,312,780.19 7,824,939.57 28,517,408.97
11,724,177.84 5,260,902.50 28,541,974.25
8,843,225.79 2,379,950.44 28,541,974.25

En bolivianos
FLUJO
UTILIDAD NETA Depreciacion y MONETARIO
FCN INVERSION
$us Amortizacion
FM
0.00 -163,854,278.37 -163,854,278.37
17,311,437.84 5,175,674.02 22,487,111.86 -1,472,631.44 21,014,480.42
17,311,437.84 5,175,674.02 22,487,111.86 0.00 22,487,111.86
17,314,769.71 5,171,231.52 22,486,001.24 0.00 22,486,001.24
17,314,769.71 5,171,231.52 22,486,001.24 0.00 22,486,001.24
17,314,791.68 5,171,202.24 22,485,993.92 -4,720.00 22,481,273.92
17,315,123.17 5,170,760.25 22,485,883.42 -150,000.00 22,335,883.42
17,315,123.17 5,170,760.25 22,485,883.42 0.00 22,485,883.42
17,315,123.17 5,170,760.25 22,485,883.42 -38,950.00 22,446,933.42
17,333,547.12 5,146,194.98 22,479,742.10 0.00 22,479,742.10
17,333,547.12 127,574,043.98 144,907,591.10 0.00 144,907,591.10

VANE CO

PONDERACION DE LA TMAR AÑO


INVERSION % APORTACION TMAR PONDERACION
Propio 0.90% 15.00% 0.13% 0
Externo 99.10% 11.50% 11.40% 1
11.53% 2
3
4
5
6
7
8
9
10

PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR PONDERACION
Propio 0.90% 17.17% 0.15%
Externo 99.10% 13.61% 13.49%
13.64%

inflacion 1.89%
VANE CON INFLACION-MONETARIO
TMAR
FLUJO PONDERAD TASA DE VANE CON
MONETARIO O INFLACION ### INFLACION
F.M. 11.53% 1.89%
-163,854,278.37 1.000000 1.000000 ### ###
21,411,654.10 0.896609 0.981451 18,372,417.73 18,031,620.11
23,345,157.31 0.803907 0.963245 23,345,157.31 22,487,111.86
23,785,205.99 0.720790 0.945378 26,712,894.74 25,253,772.63
24,234,746.38 0.646267 0.927841 23,912,563.94 22,187,067.03
24,687,591.83 0.579449 0.910630 24,285,800.28 22,115,390.28
24,991,510.60 0.519539 0.893739 24,540,285.36 21,932,605.90
25,634,856.48 0.465823 0.877160 25,238,426.03 22,138,150.28
26,074,111.38 0.417661 0.860890 25,678,961.62 22,106,753.07
26,605,742.57 0.374478 0.844921 26,213,858.73 22,148,631.34
174,745,805.24 0.335761 0.829248 ### ###
VANE= ###
14.26% TIR= 14.05% 11.93%

350
Q 69,930.45 AAA
Pf 500.57 $us

ESTADO DE RESULTADO

CANTIDAD DE
CAPACIDAD PRECIOS INGRESOS
AÑO PRODUCCION
INSTALADA % FACTURADOS PROYECTADOS
Unidad/Año

1 100.00% 69,930.45 500.57 35,005,249.59


2 100.00% 69,930.45 500.57 35,005,249.59
3 100.00% 69,930.45 500.57 35,005,249.59
4 100.00% 69,930.45 500.57 35,005,249.59
5 100.00% 69,930.45 500.57 35,005,249.59
6 100.00% 69,930.45 500.57 35,005,249.59
7 100.00% 69,930.45 500.57 35,005,249.59
8 100.00% 69,930.45 500.57 35,005,249.59
9 100.00% 69,930.45 500.57 35,005,249.59
10 100.00% 69,930.45 500.57 35,005,249.59
ESTADO DE RESULTADOS O DE PERDIDAS O GA

CREDITO FISCAL DEBITO FISCAL RESULTADO IUE


AÑO GESTION ANTES
13.00% 13%+3% IUE 25.00%

1 170,261.86 5,600,839.93 3,687,713.78 921,928.44


2 170,261.86 5,600,839.93 4,821,789.85 1,205,447.46
3 170,261.86 5,600,839.93 6,100,480.22 1,525,120.06
4 170,261.86 5,600,839.93 7,532,225.13 1,883,056.28
5 170,261.86 5,600,839.93 9,140,962.99 2,285,240.75
6 170,261.86 5,600,839.93 10,948,949.94 2,737,237.49
7 170,261.86 5,600,839.93 12,979,907.46 3,244,976.86
8 170,261.86 5,600,839.93 15,261,891.32 3,815,472.83
9 170,261.86 5,600,839.93 17,850,493.67 4,462,623.42
10 170,261.86 5,600,839.93 20,731,445.72 5,182,861.43

VANE SIN INFLACION


TMAR
AÑO FLUJO MONETARIO POND VANE
F.M. 11.53%
0 -8,885.00 1.000000 -8,885.00
1 -2,706,544.81 0.896609 -2,426,711.84
2 -1,517,432.39 0.803907 -1,219,874.98
3 -1,837,104.98 0.720790 -1,324,167.53
4 -2,195,041.21 0.646267 -1,418,582.58
5 -2,601,945.67 0.579449 -1,507,693.83
6 -3,199,222.41 0.519539 -1,662,119.91
7 -3,556,961.79 0.465823 -1,656,914.53
8 -4,166,407.75 0.417661 -1,740,145.90
9 -4,774,608.34 0.374478 -1,787,988.13
10 116,933,002.65 0.335761 39,261,507.21
VANE= 24,508,422.97
VANE= 24,508,422.97

VANE CON INFLACION


TMAR
AÑO FLUJO MONETARIO POND VANE
F.M. 13.64%
0 -8,885.00 1.000000 -8,885.00
1 -2,757,698.51 0.879977 -2,426,711.84
2 -1,575,333.37 0.774360 -1,219,874.98
3 -1,943,249.93 0.681419 -1,324,167.53
4 -2,365,750.42 0.599633 -1,418,582.58
5 -2,857,301.28 0.527664 -1,507,693.83
6 -3,579,594.29 0.464332 -1,662,119.91
7 -4,055,086.62 0.408602 -1,656,914.53
8 -4,839,653.50 0.359560 -1,740,145.90
9 -5,650,954.53 0.316405 -1,787,988.13
10 141,010,912.90 0.278429 39,261,507.21
VANE= 24,508,422.97
En bolivianos

COSTOS TOTALES UTILIDAD BRUTA

25,886,957.73 9,118,291.86
24,752,881.66 10,252,367.93
23,474,191.29 11,531,058.30
22,042,446.38 12,962,803.21
20,433,708.52 14,571,541.07
18,625,721.57 16,379,528.02
16,594,764.06 18,410,485.54
14,312,780.19 20,692,469.40
11,724,177.84 23,281,071.75
8,843,225.79 26,162,023.80
DOS O DE PERDIDAS O GANANCIAS
En bolivianos
FLUJO
UTILIDAD NETA Depreciacion y AMORTIZ MONETARIO
FCN INVERSION
$us Amortizacion CREDITO
FM
0.00 -8,885.00 -8,885.00
2,765,785.33 5,175,674.02 9,175,372.73 -1,233,913.37 -1,472,631.44 -2,706,544.81
3,616,342.39 5,175,674.02 ### -1,517,432.39 0.00 -1,517,432.39
4,575,360.17 5,171,231.52 ### -1,837,104.98 0.00 -1,837,104.98
5,649,168.85 5,171,231.52 ### -2,195,041.21 0.00 -2,195,041.21
6,855,722.24 5,171,202.24 ### -2,597,225.67 -4,720.00 -2,601,945.67
8,211,712.46 5,170,760.25 ### -3,049,222.41 -150,000.00 -3,199,222.41
9,734,930.59 5,170,760.25 ### -3,556,961.79 0.00 -3,556,961.79
11,446,418.49 5,170,760.25 ### -4,127,457.75 -38,950.00 -4,166,407.75
13,387,870.25 5,146,194.98 ### -4,774,608.34 0.00 -4,774,608.34
15,548,584.29 127,574,043.98 ### 116,933,002.65 0.00 116,933,002.65

VAN

PONDERACION DE LA TMAR AÑO


INVERSION % APORTACION TMAR PONDERACION
Propio 0.90% 15.00% 0.13% 0
Externo 99.10% 11.50% 11.40% 1
11.53% 2
3
4
5
6
7
8
9
10

PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR PONDERACION
Propio 0.90% 17.17% 0.15%
Externo 99.10% 13.61% 13.49%
13.64%

inflacion 1.89%
VANE CON INFLACION-MONETARIO
TMAR
FLUJO PONDERAD TASA DE VANE CON
MONETARIO O INFLACION 163,845,393.37 INFLACION
F.M. 11.53% 1.89%
-8,885.00 1.000000 1.000000 -8,885.00 -8,885.00
-2,757,698.51 0.896609 0.981451 -5,796,934.88 -5,689,405.12
-1,575,333.37 0.803907 0.963245 -1,575,333.37 -1,517,432.39
-1,943,249.93 0.720790 0.945378 -1,943,091.18 -1,836,954.90
-2,365,750.42 0.646267 0.927841 -2,264,094.20 -2,100,720.35
-2,857,301.28 0.579449 0.910630 -2,830,188.35 -2,577,255.81
-3,579,594.29 0.519539 0.893739 -3,546,772.25 -3,169,888.08
-4,055,086.62 0.465823 0.877160 -4,017,551.71 -3,524,037.65
-4,839,653.50 0.417661 0.860890 -4,793,604.03 -4,126,764.24
-5,650,954.53 0.374478 0.844921 -5,594,316.12 -4,726,753.38
141,010,912.90 0.335761 0.829248 141,073,879.12 116,985,217.25
VANE= 87,707,120.34
35.16% TIR= 29.82% 27.41%

350
TASA INTERNA DE RETORNO TASA INTERNA DE RETORNO
ECONOMICO SIN INFLACION FINANCIERO SIN INFLACION

FLUJO
AÑO MONETARIO AÑO FLUJO
FM MONETARIO FM
0 ### 0 -8,885.00
1 21,014,480.42 1 -2,706,544.81
2 22,487,111.86 2 -1,517,432.39
3 22,486,001.24 3 -1,837,104.98
4 22,486,001.24 4 -2,195,041.21
5 22,481,273.92 5 -2,601,945.67
6 22,335,883.42 6 -3,199,222.41
7 22,485,883.42 7 -3,556,961.79
8 22,446,933.42 8 -4,166,407.75
9 22,479,742.10 9 -4,774,608.34
10 ### 10 116,933,002.65

TIR= 12.14% TIR= 32.65%


TASA INTERNA DE RETORNO TASA INTERNA DE RETORNO
ECONOMICO SIN INFLACION FINANCIERO SIN INFLACION

AÑO FLUJO AÑO FLUJO


MONETARIO FM MONETARIO FM
0 -163,854,278.37 0 -8,885.00
1 21,411,654.10 1 -2,757,698.51
2 23,345,157.31 2 -1,575,333.37
3 23,785,205.99 3 -1,943,249.93
4 24,234,746.38 4 -2,365,750.42
5 24,687,591.83 5 -2,857,301.28
6 24,991,510.60 6 -3,579,594.29
7 25,634,856.48 7 -4,055,086.62
8 26,074,111.38 8 -4,839,653.50
9 26,605,742.57 9 -5,650,954.53
10 174,745,805.24 10 141,010,912.90

TIR= 14.26% TIR= 35.16%

VANE CON INFLACION-MONETARIO


TMAR
FLUJO PONDERAD TASA DE VANE CON
AÑO MONETARIO O INFLACION 163,845,393.37 INFLACION
F.M. 11.53% 1.89%
0 -163,854,278.37 1.000000 1.000000 -163,854,278.37 -163,854,278.37
1 21,411,654.10 0.896609 0.981451 18,372,417.73 18,031,620.11
2 23,345,157.31 0.803907 0.963245 23,345,157.31 22,487,111.86
3 23,785,205.99 0.720790 0.945378 26,712,894.74 25,253,772.63
4 24,234,746.38 0.646267 0.927841 23,912,563.94 22,187,067.03
5 24,687,591.83 0.579449 0.910630 24,285,800.28 22,115,390.28
6 24,991,510.60 0.519539 0.893739 24,540,285.36 21,932,605.90
7 25,634,856.48 0.465823 0.877160 25,238,426.03 22,138,150.28
8 26,074,111.38 0.417661 0.860890 25,678,961.62 22,106,753.07
9 26,605,742.57 0.374478 0.844921 26,213,858.73 22,148,631.34
10 174,745,805.24 0.335761 0.829248 174,350,248.81 144,579,576.76
VANE= 179,126,400.91
14.26% TIR= 14.05% 11.93%
VANE CON INFLACION-MONETARIO
TMAR
FLUJO PONDERAD TASA DE VANE CON
AÑO MONETARIO O INFLACION 163,845,393.37 INFLACION
F.M. 11.53% 1.89%
0 -8,885.00 1.000000 1.000000 -8,885.00 -8,885.00
1 -2,757,698.51 0.896609 0.981451 -5,796,934.88 -5,689,405.12
2 -1,575,333.37 0.803907 0.963245 -1,575,333.37 -1,517,432.39
3 -1,943,249.93 0.720790 0.945378 -1,943,091.18 -1,836,954.90
4 -2,365,750.42 0.646267 0.927841 -2,264,094.20 -2,100,720.35
5 -2,857,301.28 0.579449 0.910630 -2,830,188.35 -2,577,255.81
6 -3,579,594.29 0.519539 0.893739 -3,546,772.25 -3,169,888.08
7 -4,055,086.62 0.465823 0.877160 -4,017,551.71 -3,524,037.65
8 -4,839,653.50 0.417661 0.860890 -4,793,604.03 -4,126,764.24
9 -5,650,954.53 0.374478 0.844921 -5,594,316.12 -4,726,753.38
10 141,010,912.90 0.335761 0.829248 141,073,879.12 116,985,217.25
VANE= 87,707,120.34
35.16% TIR= 29.82% 27.41%
PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR PONDERACION
PROPIO 0.90% 15.00% 0.13%
EXTERNO 99.10% 11.50% 11.40%
TMAR GLOBAL PONDERADA = 11.53%

RELACION BENEFICIO COSTO SIN INFLACION FINANCIERA


INGRESOS FACTOR DE INGRESOS
COSTOS TOTALES
AÑO TOTALES ACTUALIZACION TOTALES
PROYECTADOS
PROYECTADOS 11.53% ACTUALIZADOS
0 1
1 35,005,249.59 25,886,957.73 0.8966087784 31,386,014.07
2 35,005,249.59 24,752,881.66 0.8039073015 28,140,975.74
3 35,005,249.59 23,474,191.29 0.7207903436 25,231,445.88
4 35,005,249.59 22,042,446.38 0.6462669494 22,622,735.87
5 35,005,249.59 20,433,708.52 0.5794486201 20,283,743.57
6 35,005,249.59 18,625,721.57 0.5195387194 18,186,582.54
7 35,005,249.59 16,594,764.06 0.4658229765 16,306,249.56
8 35,005,249.59 14,312,780.19 0.4176609699 14,620,326.50
9 35,005,249.59 11,724,177.84 0.3744784921 13,108,713.08
10 35,005,249.59 8,843,225.79 0.3357607033 11,753,387.22
201,640,174.04

R B/C= 1.73
INVERSION=
PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR
PROPIO 0.90% 17.17%
Tasa de inflacion= 1.89% EXTERNO 99.10% 13.61%
TMAR GLOBAL PONDERADA =

RA RELACION BENEFICIO COSTO SIN INFLACION FIN


COSTOS
INGRESOS
COSTOS TOTALES TOTALES
AÑO TOTALES
ACTUALIZADOS
PROYECTADOS PROYECTADO
S
0
23,210,473.55 1 35,666,848.81 ###
19,899,022.30 2 36,340,952.25 ###
16,919,970.41 3 37,027,796.25 ###
14,245,304.58 4 37,727,621.60 ###
11,840,284.20 5 38,440,673.65 ###
9,676,783.53 6 39,167,202.38 ###
7,730,222.39 7 39,907,462.50 ###
5,977,889.66 8 40,661,713.54 ###
4,390,452.44 9 41,430,219.93 ###
2,969,207.71 10 42,213,251.09 ###
116,859,610.78

R B/C=
8,885.00
E LA TMAR
PONDERACION
0.15%
13.49%
13.64%

NEFICIO COSTO SIN INFLACION FINANCIERA


FACTOR DE
ACTUALIZACIO INGRESOS
COSTOS TOTALES
N TOTALES
ACTUALIZADOS
13.64% ACTUALIZADOS
1
0.8966087784 31,979,209.74 23,649,151.50
0.8039073015 29,214,756.86 20,658,313.48
0.7207903436 26,689,277.98 17,897,578.91
0.6462669494 24,382,114.92 15,353,167.51
0.5794486201 22,274,395.30 13,002,292.69
0.5195387194 20,348,878.17 10,827,305.72
0.4658229765 18,589,812.97 8,812,779.90
0.4176609699 16,982,810.72 6,943,850.98
0.3744784921 15,514,726.29 5,196,289.48
0.3357607033 14,173,550.87 3,580,603.26
220,149,533.81 125,921,333.43

1.75
PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR PONDERACION
PROPIO 0.90% 15.00% 0.13%
EXTERNO 99.10% 11.50% 11.40%
TMAR GLOBAL PONDERADA = 11.53%

RELACION BENEFICIO COSTO SIN INFLACION ECONOMICA


INGRESOS COSTOS FACTOR DE INGRESOS TOTALES
AÑO TOTALES TOTALES ACTUALIZACION ACTUALIZADOS
PROYECTADOS PROYECTADOS 11.53%
0 1
1 35,005,249.59 45,281,161.07 0.8966087784 31,386,014.07
2 35,005,249.59 43,013,008.93 0.8039073015 28,140,975.74
3 35,005,249.59 40,460,070.69 0.7207903436 25,231,445.88
4 35,005,249.59 37,596,580.87 0.6462669494 22,622,735.87
5 35,005,249.59 34,379,134.43 0.5794486201 20,283,743.57
6 35,005,249.59 30,763,602.52 0.5195387194 18,186,582.54
7 35,005,249.59 26,701,687.49 0.4658229765 16,306,249.56
8 35,005,249.59 22,137,719.76 0.4176609699 14,620,326.50
9 35,005,249.59 16,985,080.34 0.3744784921 13,108,713.08
10 35,005,249.59 11,223,176.24 0.3357607033 11,753,387.22
201,640,174.04

R B/C= 0.56
INVERSION=
PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR
PROPIO 0.90% 17.17%
Tasa de inflacion= 1.89% EXTERNO 99.10% 13.61%
TMAR GLOBAL PONDERADA =

OMICA RELACION BENEFICIO COSTO SIN INFLACI


INGRESOS COSTOS
COSTOS TOTALES
AÑO TOTALES TOTALES
ACTUALIZADOS
PROYECTADOS PROYECTADOS
0
40,599,486.51 1 35,666,848.81 46,136,975.02
34,578,471.94 2 36,340,952.25 44,654,265.35
29,163,228.25 3 37,027,796.25 42,797,788.08
24,297,427.63 4 37,727,621.60 40,520,481.73
19,920,942.00 5 38,440,673.65 37,753,111.38
15,982,882.66 6 39,167,202.38 34,421,244.24
12,438,259.55 7 39,907,462.50 30,441,051.12
9,246,061.51 8 40,661,713.54 25,714,932.19
6,360,547.27 9 41,430,219.93 20,102,573.82
3,768,301.55 10 42,213,251.09 13,534,163.08
196,355,608.88

R B/C=
163,854,278.37
N DE LA TMAR
PONDERACION
0.15%
13.49%
13.64%

N BENEFICIO COSTO SIN INFLACION ECONOMICA


FACTOR DE INGRESOS
COSTOS TOTALES
ACTUALIZACION TOTALES
ACTUALIZADOS
13.64% ACTUALIZADOS
1
0.8966087784 31,979,209.74 41,366,816.81
0.8039073015 29,214,756.86 35,897,889.96
0.7207903436 26,689,277.98 30,848,232.37
0.6462669494 24,382,114.92 26,187,048.12
0.5794486201 22,274,395.30 21,875,988.29
0.5195387194 20,348,878.17 17,883,169.15
0.4658229765 18,589,812.97 14,180,141.04
0.4176609699 16,982,810.72 10,740,123.52
0.3744784921 15,514,726.29 7,527,981.53
0.3357607033 14,173,550.87 4,544,240.11
220,149,533.81 211,051,630.91

0.59
PONDERACION DE LA TMAR
INVERSION % APORTACION TMAR PONDERACION
PROPIO 0.90% 15.00% 0.13%
EXTERNO 99.10% 11.50% 11.40%
TMAR GLOBAL PONDERADA = 11.53%

PERIODO DE RECUPERACION DE LA INVERSION ECONOMICA CON VALORES ACTUALIZADOS

FLUJO CAJA NETO TMAR FLUJO CAJA NETO FCN ACTUAL


AÑO PONDERADO
FCN ACTUALIZADO ACUMULADO
11.53%
0 -163,854,278.37 1 -163,854,278.37 -163,854,278.37
1 21,014,480.42 0.8966087784 18,841,767.62 -145,012,510.75
2 22,487,111.86 0.8039073015 18,077,553.42 -126,934,957.33
3 22,486,001.24 0.7207903436 16,207,692.56 -110,727,264.78
4 22,486,001.24 0.6462669494 14,531,959.43 -96,195,305.35
5 22,481,273.92 0.5794486201 13,026,743.15 -83,168,562.20
6 22,335,883.42 0.5195387194 11,604,356.27 -71,564,205.93
7 22,485,883.42 0.4658229765 10,474,441.14 -61,089,764.79
8 22,446,933.42 0.4176609699 9,375,207.98 -51,714,556.80
9 22,479,742.10 0.3744784921 8,418,179.92 -43,296,376.88
10 144,907,591.10 0.3357607033 48,654,274.70 5,357,897.82

DEL 8 AÑO= 6.52


78.19
2015.79
PRI= 7 años 11 meses y 4 dias

PERIODO DE RECUPERACION DE LA INVERSION ECONOMICA CON VALORES ACTUALIZADOS

FLUJO CAJA NETO TMAR FLUJO CAJA NETO FCN ACTUAL


AÑO PONDERADO
FCN ACTUALIZADO ACUMULADO
11.53%
0 -8,885.00 1 -8,885.00 -8,885.00
1 -2,706,544.81 0.8966087784 -2,426,711.84 -2,435,596.84
2 -1,517,432.39 0.8039073015 -1,219,874.98 -3,655,471.81
3 -1,837,104.98 0.7207903436 -1,324,167.53 -4,979,639.34
4 -2,195,041.21 0.6462669494 -1,418,582.58 -6,398,221.93
5 -2,601,945.67 0.5794486201 -1,507,693.83 -7,905,915.76
6 -3,199,222.41 0.5195387194 -1,662,119.91 -9,568,035.67
7 -3,556,961.79 0.4658229765 -1,656,914.53 -11,224,950.20
8 -4,166,407.75 0.4176609699 -1,740,145.90 -12,965,096.10
9 -4,774,608.34 0.3744784921 -1,787,988.13 -14,753,084.23
10 116,933,002.65 0.3357607033 39,261,507.21 24,508,422.97

DEL 8 AÑO= -6.45


-77.41
-2442.21
PRI= 7 años 4 meses y 2 dias
7 AÑOS

Años
Meses
Dias
s 11 meses y 4 dias

7 AÑOS
Años
Meses
Dias
s 4 meses y 2 dias
VALOR ESPERADO DE LA DISTRIBUCION DE PROBABILIDADES DE LOS FCN:
FLUJO DE CAJA NETA: A

AÑO FCN=A Prob A*P A A-A


1 ### 10% ### ### ###
2 ### 10% ### ### ###
3 ### 10% ### ### ###
4 ### 10% ### ### ###
5 ### 10% ### ### ###
6 ### 10% ### ### ###
7 ### 10% ### ### ###
8 ### 10% ### ### ###
9 ### 10% ### ### ###
10 ### 10% ### ### ###
100% ###

A= ###
S FCN:

(A-A)^2 (A-A)^2*P
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### Varianza

36,726,623.63 Desviacion estandar

1.0576 Coeficiente de variacion o


105.76% de riesgo
###
36,726,623.63

También podría gustarte