Hoja1EJERCICIOINVERSIONEQUIPOS5500OBRA CIVIL25000ADECUACIONES3500VIDA UTIL25AOSREINVERSIONES100%DE LA OBRA CIVIL CADA 5 AOS

COSTOS DE OPERACIN Y MANTENIMIENTOMANO DE OBRA3PERSONAS1500MENSUALESMATERIALES2500MENSUALESSERVICIOS650MENSUALES

CREDITO100%INVERSIONPLAZO10AOSCUOTASTRIMESTRALESTASA16%NACT

INGRESOSUNIDADES6500MENSUALESPRECIO VENTA1.5C/UTASA CREC. VENTAS2%ANUAL

TASA INFLACION1.50%ANUAL

DETERMINE LA VIABILIDAD DEL PROYECTO

INVERSION INICIALRUBROVALOREQUIPOS$ 5,500.00OBRA CIVIL$ 25,000.00ADECUACIONES$ 3,500.00TOTAL$ 34,000.00COYMRUBRO# RECURSOSFRECUENCIAVALOR UNITARIOVALOR TOTALMANO DE OBRA312$ 4,500.00$ 54,000.00MATERIALES112$ 2,500.00$ 30,000.00SERVICIOS112$ 650.00$ 7,800.00TOTAL ANUAL$ 91,800.00

COSTO FINANCIEROpagarle al banco la cuota fija PERIODOCUOTAINTERESAMORTIZACIONSALDO00.00.00.0$ 34,000.001$ 1,717.80$ 1,360.00$ 357.80$ 33,642.202$ 1,717.80$ 1,345.69$ 372.11$ 33,270.093$ 1,717.80$ 1,330.80$ 387.00$ 32,883.104$ 1,717.80$ 1,315.32$ 402.47$ 32,480.625$ 1,717.80$ 1,299.22$ 418.57$ 32,062.056$ 1,717.80$ 1,282.48$ 435.32$ 31,626.737$ 1,717.80$ 1,265.07$ 452.73$ 31,174.008$ 1,717.80$ 1,246.96$ 470.84$ 30,703.169$ 1,717.80$ 1,228.13$ 489.67$ 30,213.4910$ 1,717.80$ 1,208.54$ 509.26$ 29,704.2311$ 1,717.80$ 1,188.17$ 529.63$ 29,174.6012$ 1,717.80$ 1,166.98$ 550.81$ 28,623.7913$ 1,717.80$ 1,144.95$ 572.85$ 28,050.9414$ 1,717.80$ 1,122.04$ 595.76$ 27,455.1815$ 1,717.80$ 1,098.21$ 619.59$ 26,835.5916$ 1,717.80$ 1,073.42$ 644.38$ 26,191.2117$ 1,717.80$ 1,047.65$ 670.15$ 25,521.0618$ 1,717.80$ 1,020.84$ 696.96$ 24,824.1119$ 1,717.80$ 992.96$ 724.83$ 24,099.2720$ 1,717.80$ 963.97$ 753.83$ 23,345.4421$ 1,717.80$ 933.82$ 783.98$ 22,561.4622$ 1,717.80$ 902.46$ 815.34$ 21,746.1223$ 1,717.80$ 869.84$ 847.95$ 20,898.1724$ 1,717.80$ 835.93$ 881.87$ 20,016.3025$ 1,717.80$ 800.65$ 917.15$ 19,099.1526$ 1,717.80$ 763.97$ 953.83$ 18,145.3227$ 1,717.80$ 725.81$ 991.99$ 17,153.3328$ 1,717.80$ 686.13$ 1,031.67$ 16,121.6729$ 1,717.80$ 644.87$ 1,072.93$ 15,048.7330$ 1,717.80$ 601.95$ 1,115.85$ 13,932.8931$ 1,717.80$ 557.32$ 1,160.48$ 12,772.4032$ 1,717.80$ 510.90$ 1,206.90$ 11,565.5033$ 1,717.80$ 462.62$ 1,255.18$ 10,310.3234$ 1,717.80$ 412.41$ 1,305.39$ 9,004.9435$ 1,717.80$ 360.20$ 1,357.60$ 7,647.3336$ 1,717.80$ 305.89$ 1,411.91$ 6,235.4337$ 1,717.80$ 249.42$ 1,468.38$ 4,767.0538$ 1,717.80$ 190.68$ 1,527.12$ 3,239.9339$ 1,717.80$ 129.60$ 1,588.20$ 1,651.7340$ 1,717.80$ 66.07$ 1,651.73$ 0.00

FLUJO DE PROYECTOcada periodo es anual PERIODOINVERSIONCOYMCFTOTAL0$ 34,000.000.00.0$ 34,000.0010.0$ 91,800.00$ 5,351.82$ 97,151.8220.0$ 93,177.00$ 5,093.74$ 98,270.7430.0$ 94,574.66$ 4,791.82$ 99,366.4740.0$ 95,993.27$ 4,438.62$ 100,431.895$ 25,000.00$ 97,433.17$ 4,025.43$ 126,458.6060.0$ 98,894.67$ 3,542.05$ 102,436.7270.0$ 100,378.09$ 2,976.56$ 103,354.6680.0$ 101,883.76$ 2,315.03$ 104,198.7990.0$ 103,412.02$ 1,541.12$ 104,953.1410$ 25,000.00$ 104,963.20$ 635.77$ 130,598.97110.0$ 106,537.650.0$ 106,537.65120.0$ 108,135.710.0$ 108,135.71130.0$ 109,757.750.0$ 109,757.75140.0$ 111,404.110.0$ 111,404.1115$ 25,000.00$ 113,075.180.0$ 138,075.18160.0$ 114,771.300.0$ 114,771.30170.0$ 116,492.870.0$ 116,492.87180.0$ 118,240.270.0$ 118,240.27190.0$ 120,013.870.0$ 120,013.8720$ 25,000.00$ 121,814.080.0$ 146,814.08210.0$ 123,641.290.0$ 123,641.29220.0$ 125,495.910.0$ 125,495.91230.0$ 127,378.350.0$ 127,378.35240.0$ 129,289.020.0$ 129,289.0225$ 25,000.00$ 131,228.360.0$ 156,228.36VAN$ 56,164.36$ 610,629.67$ 19,599.50$ 686,393.53

INGRESOSPERIODOVALOR001$ 117,000.002$ 119,340.003$ 121,726.804$ 124,161.345$ 126,644.566$ 129,177.457$ 131,761.008$ 134,396.229$ 137,084.1510$ 139,825.8311$ 142,622.3512$ 145,474.7913$ 148,384.2914$ 151,351.9815$ 154,379.0216$ 157,466.6017$ 160,615.9318$ 163,828.2519$ 167,104.8120$ 170,446.9121$ 173,855.8522$ 177,332.9623$ 180,879.6224$ 184,497.2125$ 188,187.16VAN$ 802,170.48

FLUJO TOTALPERIODOCOSTOINGRESOTOTAL0$ 34,000.000.0-$ 34,000.001$ 97,151.82$ 117,000.00$ 19,848.182$ 98,270.74$ 119,340.00$ 21,069.263$ 99,366.47$ 121,726.80$ 22,360.334$ 100,431.89$ 124,161.34$ 23,729.445$ 126,458.60$ 126,644.56$ 185.966$ 102,436.72$ 129,177.45$ 26,740.737$ 103,354.66$ 131,761.00$ 28,406.358$ 104,198.79$ 134,396.22$ 30,197.439$ 104,953.14$ 137,084.15$ 32,131.0010$ 130,598.97$ 139,825.83$ 9,226.8711$ 106,537.65$ 142,622.35$ 36,084.7012$ 108,135.71$ 145,474.79$ 37,339.0813$ 109,757.75$ 148,384.29$ 38,626.5414$ 111,404.11$ 151,351.98$ 39,947.8615$ 138,075.18$ 154,379.02$ 16,303.8416$ 114,771.30$ 157,466.60$ 42,695.2917$ 116,492.87$ 160,615.93$ 44,123.0518$ 118,240.27$ 163,828.25$ 45,587.9819$ 120,013.87$ 167,104.81$ 47,090.9420$ 146,814.08$ 170,446.91$ 23,632.8321$ 123,641.29$ 173,855.85$ 50,214.5622$ 125,495.91$ 177,332.96$ 51,837.0523$ 127,378.35$ 180,879.62$ 53,501.2724$ 129,289.02$ 184,497.21$ 55,208.1925$ 156,228.36$ 188,187.16$ 31,958.80VAN$ 686,393.53$ 802,170.48$ 115,776.94TIR60.33%

Hoja2INVERSIONEQUIPOS 15500TERRENOS 35000OBRA CIVIL45000ADECUACIONES 3500VIDA UTIL20AOSREINVERSIONES 100%DE EQUIPOS +ADECUACIONES CADA 5 AOSCOSTO DE OPERACIONES Y MANTENIMIENTOMANO DE OBRA10PERSONAS 850MENSUALESMATERIALES1800MENSUALESSERVICIOS620MENSUALESCREDITO100%INVERSIONPLAZO12AOSCUOTASSEMESTRALESTASA14%NACTINGRESOSUNIDADES5000MENSUALESPRECIO VENTA6.5C/UTASA CREC.VENTAS 2%ANUALTASA INFLACION1.50%ANUAL

INVERSION INICIALRUBROVALOREQUIPOS$ 15,500.00TERRENOS$ 35,000.00OBRA CIVIL$ 45,000.00ADECUACIONES$ 3,500.00TOTAL$ 99,000.00

COYMRUBRO# RECURSOSFRECUENCIAVALOR UNITARIOVALOR TOTALMANO DE OBRA1012$ 8,500.00$ 102,000.00MATERIALES112$ 1,800.00$ 21,600.00SERVICIOS112$ 620.00$ 7,440.00TOTAL ANUAL$ 131,040.00

COSTO FINANCIEROPERIODOCUOTAINTERESAMORTIZACIONSALDO00.00.00.0$ 99,000.001$ 8,631.71$ 6,930.00$ 1,701.71$ 97,298.292$ 8,631.71$ 6,810.88$ 1,820.83$ 95,477.453$ 8,631.71$ 6,683.42$ 1,948.29$ 93,529.164$ 8,631.71$ 6,547.04$ 2,084.67$ 91,444.495$ 8,631.71$ 6,401.11$ 2,230.60$ 89,213.896$ 8,631.71$ 6,244.97$ 2,386.74$ 86,827.157$ 8,631.71$ 6,077.90$ 2,553.81$ 84,273.348$ 8,631.71$ 5,899.13$ 2,732.58$ 81,540.769$ 8,631.71$ 5,707.85$ 2,923.86$ 78,616.9010$ 8,631.71$ 5,503.18$ 3,128.53$ 75,488.3711$ 8,631.71$ 5,284.19$ 3,347.53$ 72,140.8412$ 8,631.71$ 5,049.86$ 3,581.85$ 68,558.9913$ 8,631.71$ 4,799.13$ 3,832.58$ 64,726.4114$ 8,631.71$ 4,530.85$ 4,100.86$ 60,625.5415$ 8,631.71$ 4,243.79$ 4,387.93$ 56,237.6216$ 8,631.71$ 3,936.63$ 4,695.08$ 51,542.5417$ 8,631.71$ 3,607.98$ 5,023.74$ 46,518.8018$ 8,631.71$ 3,256.32$ 5,375.40$ 41,143.4019$ 8,631.71$ 2,880.04$ 5,751.67$ 35,391.7320$ 8,631.71$ 2,477.42$ 6,154.29$ 29,237.4421$ 8,631.71$ 2,046.62$ 6,585.09$ 22,652.3422$ 8,631.71$ 1,585.66$ 7,046.05$ 15,606.2923$ 8,631.71$ 1,092.44$ 7,539.27$ 8,067.0224$ 8,631.71$ 564.69$ 8,067.02$ 0.00

FLUJO DE PROYECTOPERIODOINVERSIONCOYMCFTOTAL0$ 99,000.000.00.0$ 99,000.0010.0$ 131,040.00$ 13,740.88$ 144,780.8820.0$ 133,005.60$ 13,230.463$ 45,000.00$ 135,000.68$ 12,646.0940.0$ 137,025.69$ 11,977.0350.0$ 139,081.08$ 11,211.0460.0$ 141,167.30$ 10,334.0470.0$ 143,284.81$ 9,329.9880.0$ 145,434.08$ 8,180.4290.0$ 147,615.59$ 6,864.29100.0$ 149,829.82$ 5,357.46110.0$ 152,077.27$ 3,632.28120.0$ 154,358.43$ 1,657.13130.0$ 156,673.810.0140.0$ 159,023.910.0150.0$ 161,409.270.0160.0$ 163,830.41$ -170.0$ 166,287.87$ -180.0$ 168,782.18$ -190.0$ 171,313.92$ -200.0$ 173,883.63$ -VANERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

INGRESOSPERIODOVALOR001$ 390,000.002$ 397,800.003$ 405,756.004$ 413,871.125$ 422,148.546$ 430,591.517$ 439,203.348$ 447,987.419$ 456,947.1610$ 466,086.1011$ 475,407.8212$ 484,915.9813$ 494,614.3014$ 504,506.5915$ 514,596.7216$ 524,888.6517$ 535,386.4218$ 546,094.1519$ 557,016.0420$ 568,156.3621$ 579,519.4822$ 591,109.8723$ 602,932.0724$ 614,990.7125$ 627,290.53VAN$ 3,048,504.03

FLUJO TOTALPERIODOCOSTOINGRESOTOTAL0$ 99,000.000.0-$ 99,000.001$ 97,151.82$ 117,000.00$ 19,848.182$ 98,270.74$ 119,340.00$ 21,069.263$ 99,366.47$ 121,726.80$ 22,360.334$ 100,431.89$ 124,161.34$ 23,729.445$ 126,458.60$ 126,644.56$ 185.966$ 102,436.72$ 129,177.45$ 26,740.737$ 103,354.66$ 131,761.00$ 28,406.358$ 104,198.79$ 134,396.22$ 30,197.439$ 104,953.14$ 137,084.15$ 32,131.0010$ 130,598.97$ 139,825.83$ 9,226.8711$ 106,537.65$ 142,622.35$ 36,084.7012$ 108,135.71$ 145,474.79$ 37,339.0813$ 109,757.75$ 148,384.29$ 38,626.5414$ 111,404.11$ 151,351.98$ 39,947.8615$ 138,075.18$ 154,379.02$ 16,303.8416$ 114,771.30$ 157,466.60$ 42,695.2917$ 116,492.87$ 160,615.93$ 44,123.0518$ 118,240.27$ 163,828.25$ 45,587.9819$ 120,013.87$ 167,104.81$ 47,090.9420$ 146,814.08$ 170,446.91$ 23,632.83VANERROR:#VALUE!ERROR:#VALUE!$ 62,277.18TIR22.45%

Hoja3