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
