Técnico

FLUJO NETO DE EFECTIVO

AÑO | PIB | INFLACION |
2007 | 22409,653 | 0,46 |
2008 | 24032,489 | 3,61 |
2009 | 24119,455 | 2,28 |
2010 | 24983,318 | 1,34 |
2011 | 26928,19 | 1,58 |
TOTAL |  | 9,27 |
Ẋ | 4,71 | 1,854 |
i= 4.71+1.854
i= 6.56%
Utilidad neta último año 13.080.373
+ Depreciaciones 3.004.138
+Amortizaciones 1.620.411
= Flujo Base 17.704.922

Vf=Vp1+in
Vp= valor presente
Vf= valor futuro
I= tasa de interés
N=numero de periodos
VF= 17.704.922(1+0.066) 1
VF= 18.873.45
VF= 18.873.45(1+0.066) 2
VF= 27.094.72
VF= 27.094.72(1+0.066) 3
VF= 32.821.34
VF= 32.821.34 (1+0.066) 4
VF= 42.382.36
VF=42.382.36(1+0.066)5
VF= 58.340.64
VALOR FUTURO |  FNE |
2011 | 18.873.45 |
2012 | 27.094.72 |
2013 | 32.821.34 |
2014 | 42.382.36 |
2015 | 58.340.64 |
TOTAL | 179512.51 |

VF=18.873.45/(1+0.066) 1
VF= 17.704.92
VF= 27.094.72/(1+0.066) 2
VF= 26.977.21
VF= 32.821.34/(1+0.066) 3
VF= 32.811.91
VF= 42.382.36 /(1+0.066) 4
VF= 42.381.56
VF= 58.340.64/(1+0.066)5
VF=58.340.57
VALOR FUTURO |   |
2011 | 17.704.92 |
2012 | 26.977.21 |
2013 | 32.811.91 |
2014 | 42.381.56 |
2015 | 58.340.57 |
TOTAL | ∑VP 158216.17 |VAN=ΣFlujonetodeefectivo1+In−inversionincicial
VAN=ΣValorespresentes−inversioninicial
Vp=FNE1+in
FNE= 179512.51
I= 6.56%
i°=12660,13

VAN= ∑ VP- IO
VAN= 158216.17-905.919.154
VAN= - 747702.98
VAN<0 SE RECHAZA
TIRTIR=iinferior+iinferior−isuperiorVANsuperior−VANinferiorVANINFERIOR
Método de Interpolación Lineal
4%
VF= 18.873.45/(1+0.04) 1
VF= 18.147.55
VF= 27.094.72/(1+0.04) 2
VF= 27.051.44
VF= 32.821.34/(1+0.04)3
VF= 29.178.05
VF= 42.382.36 /(1+0.04) 4
VF= 36.228.62
VF= 58.340.64/(1+0.04)5
VF= 47.951.75
VF= 18.147.55+ 27.051.44 + 29.178.05 + 36.228.62 + 47.951.75
VF= 158.557.41
VAN= -...