Hoja3ING x VENTA12345cambios de aceite2700270027003000300015 autos diarios 4-5aceites 10frenos 3alineacion 2mantencion de frenos60060060090090012 autos diarios 1-3aceites 9frenos 2alineacion 1alineacion y suspensin300300300600600MOD H.H10,000Precio cambio de aceite$ 30,000$ 30,000$ 30,000$ 30,000$ 30,000ACEITE 4000 LITROFILTRO 4000Precio mantencion de frenos$ 29,000$ 29,000$ 29,000$ 29,000$ 29,000PASTILLAS 15000RECTIFICADO 2000 X DISCOprecio alineacion$ 19,000$ 19,000$ 19,000$ 19,000$ 19,000BALANCEO 2000 X RUEDAingresos por venta$ 104,100,000$ 104,100,000$ 104,100,000$ 127,500,000$ 127,500,000
Pea: Pea:

CVT012345Cantidad cambios de aceite2,7002,7002,7003,0003,000materialesaceite1,3931,3931,3931,3931,393filtro de aceite2,0532,0532,0532,0532,053servicios anuales 4-54,500total9,304,2009,304,2009,304,20010,338,00010,338,000servicios anuales 1-33,600cantidad mantenciones de frenos600600600900900pastillas 7,3457,3457,3457,3457,345rectificado500500500500500total4,707,0004,707,0004,707,0007,060,5007,060,500cantidad alineaciones 300300300600600balanceo250250250250250alineacion529529529529529total233,700233,700233,700467,400467,400insumospaos de aseo159,000159,000159,000159,000159,000jabon de aseo161,280161,280161,280161,280161,280TOTAL320,280320,280320,280320,280320,280CVT14,565,18014,565,18014,565,18018,186,18018,186,180

CFT12345servicioValor mensualValor anualinternet9,840118,080118,080118,080118,080118,080118,080telefonia9,840118,080118,080118,080118,080118,080118,080electricidad400,0004,800,0004,800,0004,800,0004,800,0004,800,0004,800,000agua600,0007,200,0007,200,0007,200,0007,200,0007,200,0007,200,000cable9,840118,080118,080118,080118,080118,080118,080gas12,000144,000144,000144,000144,000144,000144,000mantencion de equipos240,000240,000240,000240,000240,000240,000gastos de oficina50,000600,000600,000600,000600,000600,000600,000SUELDOS BRUTOSAdministrador800,0009,600,0009,600,0009,600,0009,600,0009,600,0009,600,000Jefe de taller500,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,000Recepcionista500,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,000mecanicos ( 3)1,140,00013,680,00013,680,00013,680,00013,680,00013,680,00013,680,000total CFT48,618,24048,618,24048,618,24048,618,24048,618,24048,618,240amortizacion A.N.012345puesta en marcha650,000130,000130,000130,000130,000130,000PRESTAMOAoCuotaIntersAmortizacinSaldointeres0$ 25,000,0001$ 9,657,228.000$ 5,000,000$ 4,657,228$ 20,342,7720.22$ 9,657,228.000$ 4,068,554$ 5,588,674$ 14,754,0980.23$ 9,657,228.000$ 2,950,820$ 6,706,408$ 8,047,6900.24$ 9,657,228.000$ 1,609,538$ 8,047,690$ 00.2DEPRECIACIONarticulos de oficinacantidadvalorvida utildep. 1-5valor libropapelero oficina451,16868,5288,528contenedor basura359,97669,9969,996alarma155,99277,99915,998extintor3102,216714,60229,205estante metalico7662,480794,640189,280televisor1119,992619,99919,999refrigerador1183,992920,44481,774soporte tv110,392101,0395,196mueble cocina1116,792716,68533,369cocina gas1103,992911,55546,219microondas123,99292,66610,663comedor1103,992714,85629,712caja de seguridad175,992612,66512,665estante repisa3119,976717,13934,279futon3215,976730,85461,707silla235,18475,02610,053sillon ejecutivo3119,976717,13934,279escritorio139,99275,71311,426escritorio ejecutivo179,992711,42722,855computador3718,8486119,808119,808impresora245,05667,5097,509centro impresin195,744615,95715,957caja de dinero1129,536621,58921,589total3,271,248487,836832,066equipo tallercantidadvalorvida utilDep. 1-3Dep. 4-5Valor librogata hidraulico178,16089,7709,77029,310compresor1607,1921540,47940,479404,795kit llave impacto4142,368817,79617,79653,388lampara portatil212,78434,2610llave filtro29,26433,0880rectificadora discos11,200,0008150,000150,000450,000multimetro243,984314,6610scanner1183,326822,91622,91668,747grasera neumatica231,184310,3950elevador columna33,027,36015201,824201,8242,018,240elevador alineacion11,588,00015105,867105,8671,058,667balanceadora1680,0001545,33345,333453,333vacuometro de frenos138,800312,9330medidor espesor13,92031,3070prensa hidraulica1164,000820,50020,50061,500llave torque140,840313,6130total7,851,182674,744614,4854,597,980valorvida utildep 1-5valor libroTerreno 10,000,000000Contruccion21,400,000201,070,00016,050,000total31,400,0001,070,00016,050,000dep 1-3dep 4-5DEP. TOTAL ANUAL2,232,5802,172,321Flujo Puro012345Ingresos x Venta$ 104,100,000$ 104,100,000$ 104,100,000$ 127,500,000$ 127,500,000CVT-$ 14,565,180-$ 14,565,180-$ 14,565,180-$ 18,186,180-$ 18,186,180CFT-$ 48,618,240-$ 48,618,240-$ 48,618,240-$ 48,618,240-$ 48,618,240Depreciacin-$ 2,232,580-$ 2,232,580-2,232,580-$ 2,172,321-$ 2,172,321Amortizacion AN-$ 130,000-$ 130,000-$ 130,000-$ 130,000-$ 130,000valor libro$ 0RAI$ 38,554,000$ 38,554,000$ 38,554,000$ 58,393,259$ 58,393,259IMPTO (20%)-$ 7,710,800-$ 7,710,800-$ 7,710,800-$ 11,678,652-$ 11,678,652RDI$ 30,843,200$ 30,843,200$ 30,843,200$ 46,714,607$ 46,714,607Depreciacin$ 2,232,580$ 2,232,580$ 2,232,580$ 2,172,321$ 2,172,321Amortizacion AN$ 130,000$ 130,000$ 130,000$ 130,000$ 130,000Valor libro$ 0I AF-$ 20,277,570IANI KT-$ 10,530,570-$ 603,500RKT$ 11,134,070Valor de desecho$ 468,446,072VD 10%economicoFCN-$ 30,808,140$ 33,205,780$ 33,205,780$ 32,602,280$ 49,016,928$ 528,597,070

KT = (CT/12 )*2Flujo de deuda01234interes-5,000,000-4,068,554-2,950,820-1,609,538RAI-5,000,000-4,068,554-2,950,820-1,609,538Ipm.20%1,000,000813,711590,164321,908RDI-4,000,000-3,254,843-2,360,656-1,287,630amortizacion-4,657,228-5,588,674-6,706,408-8,047,690prestamo25,000,000FCN25,000,000-8,657,228-8,843,517-9,067,064-9,335,320