Final Ing Economica

Hoja1

Proposito: Encontrar los indicadoresHorizonte 5 aosFlujo de caja a precios corrientesVPN>=0Inversion fija$ 156,000,000.00R C/B>=1Capital de trabajo$ 14,000,000.00TIR>iInversion diferida$ 13,200,000.00Ingresos x venta ao 1$ 203,000,000.00PartidasAo 0 Ao 1Ao 2Ao 3Ao 4Informacin:Credito bancario$ 22,000,000.00i20%0.20GastosEntradas de efectivoinflacin8%0.08Operacin$ 6,000,000.00Ingresos por ventas$ 150,000,000.00$ 162,000,000.00$ 174,960,000.00$ 188,956,800.00Horizontes4 aosGenerales$ 4,960,000.00Creditos bancariosAdmon$ 1,000,000.00TOTAL ENTRADAS DE EFECTIVO$ 0.00$ 150,000,000.00$ 162,000,000.00$ 174,960,000.00$ 188,956,800.00Inversiones:Inflacion2%Fija$ 180,000,000.00Tasa oportunidad mdo14%InversionesDiferida$ 20,000,000.00Fijas$ 180,000,000.00Capital de trabajo$ 18,000,000.00Encontrar:Diferidas$ 20,000,000.00Flujo de cajaCapital de trabajo$ 18,000,000.00Ingresos por ventas:Valor presente netoGastos$ 150,000,000.00Relacin costo beneficioAdministracin$ 15,000,000.00$ 16,200,000.00$ 17,496,000.00$ 18,895,680.00Tasa interna del retorno de la inversionGenerales$ 20,000,000.00$ 21,600,000.00$ 23,328,000.00$ 25,194,240.00Gastos:Operacin$ 12,000,000.00$ 12,960,000.00$ 13,996,800.00$ 15,116,544.00Administracin$ 15,000,000.00Pareja de 2DEPRECIACIN$ 45,000,000.00$ 45,000,000.00$ 45,000,000.00$ 45,000,000.00Generales$ 20,000,000.00TOTAL SALIDA DE EFECTIVO$ 218,000,000.00$ 92,000,000.00$ 95,760,000.00$ 99,820,800.00$ 104,206,464.00Operacin$ 12,000,000.00

SALDO EN CAJA-$ 218,000,000.00$ 58,000,000.00$ 66,240,000.00$ 75,139,200.00$ 84,750,336.00Depreciacin=Inversion fija/aosDEPRECIACIN$ 45,000,000.00$ 45,000,000.00$ 45,000,000.00$ 45,000,000.00FLUJO NETO DE CAJA-$ 218,000,000.00$ 103,000,000.00$ 111,240,000.00$ 120,139,200.00$ 129,750,336.00Factor=1/(1+i)^n

Calculo VPN a precios corrientes

AoFlujo netoFactor VPN

0-$ 218,000,000.001-$ 218,000,000.001$ 103,000,000.000.8333333333$ 85,833,333.332$ 111,240,000.000.6944444444$ 77,250,000.003$ 120,139,200.000.5787037037$ 69,525,000.004$ 129,750,336.000.4822530864$ 62,572,500.005$ 0.000.401877572$ 0.00VPN$ 77,180,833.33

VPN Egresos

AoEgresosFactor VPN

0$ 218,000,000.001$ 218,000,000.001$ 92,000,000.000.8333333333$ 76,666,666.672$ 95,760,000.000.6944444444$ 66,500,000.003$ 99,820,800.000.5787037037$ 57,766,666.674$ 104,206,464.000.4822530864$ 50,253,888.895$ 0.000.401877572$ 0.00VPN$ 469,187,222.22

VPN Ingresos

AoIngresosFactor VPN

1$ 150,000,000.000.8333333333$ 125,000,000.002$ 162,000,000.000.6944444444$ 112,500,000.003$ 174,960,000.000.5787037037$ 101,250,000.004$ 188,956,800.000.4822530864$ 91,125,000.005$ 0.000.401877572$ 0.00VPN$ 429,875,000.00

R C/BVPN Ingresos/ VPN EgresosR C/B0.9162120783

Calculo de la TIR

TIR es la tasa que me permite obtener el VPN con un valor de 0.Tasa inferior=0.3737.00%Tasa superior=0.370137.01%Metodo de Gitinger

Tasa superior


0-$ 218,000,000.001-$ 218,000,000.001$ 103,000,000.000.7298737318$ 75,176,994.382$ 111,240,000.000.5327156644$ 59,259,290.513$ 120,139,200.000.38881517$ 46,711,943.474$ 129,750,336.000.2837859791$ 36,821,326.145$ 0.000.2071279316$ 0.000.3701VPN-$ 30,445.49

Tasa inferior


0-$ 218,000,000.001-$ 218,000,000.001$ 103,000,000.000.7299270073$ 75,182,481.752$ 111,240,000.000.532793436$ 59,267,941.823$ 120,139,200.000.3889003182$ 46,722,173.114$ 129,750,336.000.2838688454$ 36,832,078.075$ 0.000.2072035368$ 0.000.37VPN$ 4,674.76

TIR= Tasa inf +(Tasa sup - Tasa inf-)(VPN +)/(VPN +)-(VPN -)TIR0.37008737.01%

Hoja2PartidasAo 0 Ao 1Ao 2Ao 3Ao 4

Entradas de efectivoinflacion0.02Ingresos por ventas$163,040,860.00$166,301,677.20$169,627,710.74$173,020,264.96interes0.15Creditos bancariosTOTAL ENTRADAS DE EFECTIVO$163,040,860.00$166,301,677.20$169,627,710.74$173,020,264.96factor(1/1+i)^-nInversionesFijas$120,000,000.00Diferidas$7,830,332.40Capital de trabajo$20,486,943.00GastosAdministracin$5,569,694.00$5,681,087.88$5,794,709.64$5,910,603.83Generales$16,086,693.00$16,408,426.86$16,736,595.40$17,071,327.31Operacin$4,316,000.00$4,402,320.00$4,490,366.40$4,580,173.73ERROR:#REF!DEPRECIACIN$30,000,000.00$30,000,000.00$30,000,000.00$30,000,000.00TOTAL SALIDA DE EFECTIVO$148,317,275.40$55,972,387.00$56,491,834.74$57,021,671.43$57,562,104.86

SALDO EN CAJA-$ 148,317,275.40$ 107,068,473.00$ 109,809,842.46$ 112,606,039.31$ 115,458,160.10DEPRECIACIN$ 30,000,000.00$ 30,000,000.00$ 30,000,000.00$ 30,000,000.00FLUJO NETO DE CAJA-$ 148,317,275.40$ 137,068,473.00$ 139,809,842.46$ 142,606,039.31$ 145,458,160.10Calculo VPN a precios corrientes


0-$ 148,317,275.401-$ 148,317,275.401$ 137,068,473.000.8695652174$ 119,189,976.522$ 139,809,842.460.7561436673$ 105,716,327.003$ 142,606,039.310.6575162324$ 93,765,785.694$ 145,458,160.100.5717532456$ 83,166,175.13VPN$ 253,520,988.94

Calculo VPN egresos


0$ 148,317,275.401$ 148,317,275.401$ 55,972,387.000.8695652174$ 48,671,640.872$ 56,491,834.740.7561436673$ 42,715,943.093$ 57,021,671.430.6575162324$ 37,492,674.574$ 57,562,104.860.5717532456$ 32,911,320.28VPN$ 310,108,854.21

Calculo VPN ingresos


1$ 163,040,860.000.8695652174$ 141,774,660.872$ 166,301,677.200.7561436673$ 125,747,960.083$ 169,627,710.740.6575162324$ 111,532,973.284$ 173,020,264.960.5717532456$ 98,924,898.04VPN$ 477,980,492.27

RC/B1.5413313286

Calculo de la TIR

Tasa inferior=0.860786.07%Tasa superior=0.860886.08%

Tasa superior


0-$ 148,317,275.40TRUE-$ 148,317,275.401$ 137,068,473.000.5374032674$ 73,661,045.252$ 139,809,842.460.2888022718$ 40,377,400.133$ 142,606,039.310.1552032845$ 22,132,925.694$ 145,458,160.100.0834067522$ 12,132,192.72VPN-$ 13,711.62Tasa inferior


0-$ 148,317,275.401-$ 148,317,275.401$ 137,068,473.000.5374321492$ 73,665,004.032$ 139,809,842.460.288833315$ 40,381,740.273$ 142,606,039.310.1552283092$ 22,136,494.374$ 145,458,160.100.0834246838$ 12,134,801.02VPN$ 764.280.8607052797Tasa makia


0-$ 148,317,275.401-$ 148,317,275.401$ 137,068,473.000.5374306242$ 73,664,795.012$ 139,809,842.460.2888316759$ 40,381,511.103$ 142,606,039.310.1552269879$ 22,136,305.934$ 145,458,160.100.083423737$ 12,134,663.29VPN-$ 0.06

Hoja3

Final Ing Economica

Documents

Transcript of Final Ing Economica