examen.xlsx

9
Problema 1 Dado los costos de operación y mantenimiento de la situacion con Año Situacion con Proyecto Co Cm Total Costo OYM 1 0 0 0 2 0 0 0 3 0 0 0 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 8 0 0 0 9 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0

Upload: susan-alcalde

Post on 08-Nov-2015

236 views

Category:

Documents


1 download

TRANSCRIPT

Problema 1Problema 1Dado los costos de operacin y mantenimiento de la situacion con proyecto, Calcular los Costos incrementales de operacin y mantenimiento del sistema de agua portable del cuadro que se muestraAoSituacion con ProyectoSituacion con ProyectoCostos incrementales CoCmTotal Costo OYMCOCMTotal Costo OYMCOCMTotal Costo OYM10004860.001880.006740.004860.001880.006740.0020004878.001880.006758.004878.001880.006758.0030004878.001880.006758.004878.001880.006758.0040004878.001880.006758.004878.001880.006758.0050004896.001880.006776.004896.001880.006776.0060004932.001880.006812.004932.001880.006812.0070004932.001880.006812.004932.001880.006812.0080004932.001880.006812.004932.001880.006812.0090004932.001880.006812.004932.001880.006812.00100004950.001880.006830.004950.001880.006830.00110004986.001880.006866.004986.001880.006866.00120004986.001880.006866.004986.001880.006866.00130004986.001880.006866.004986.001880.006866.00140004986.001880.006866.004986.001880.006866.00150004986.001880.006866.004986.001880.006866.00160005058.001880.006938.005058.001880.006938.00170005076.001880.006956.005076.001880.006956.00180005076.001880.006956.005076.001880.006956.00190005076.001880.006956.005076.001880.006956.00200005094.001880.006974.005094.001880.006974.00

Problema 2Problema 2i=0.090.09Calcular el cuadro de la alternativa 01 los guientes parametros: Flujo Neto A precios sociales, Factor de actualisacion (TSD i = 9%), VAN TIR B/CAos Costos de la Invercion a Precios Sociales Beneficios Costos incrementales de operacin y manteniminetoflujosFactor de actualisacionFlujo neto a precios socialesBeneficio*factor de actualisaconC Oy M * factor de actualisacion1753114.22155256.485747.32149509.160.9174311927137164.366972477142437.1376146795272.77064220182156908.145762.57151145.570.8416799933127216.20233987132066.4422186684850.23987879813158559.515762.57152796.940.7721834801117987.272871882122437.0342285774449.76135669554160211.475762.57154448.90.7084252111109415.494581287113497.8444498154082.3498685285160211.475777.81154433.660.6499313863100371.282734927104126.4627979963755.18006306846161863.145808.3156054.840.596267326993050.402293363796513.70180807633463.29951471267163514.805808.3157706.50.547034244886270.856134382689448.19513870613177.33900432348163514.805808.3157706.50.501866279779147.574435213482062.56434743672914.98991222339165166.475808.3159358.170.460427779573372.928360881276047.23103264572674.302671764510165166.475823.55159342.920.422410806967308.171410315269768.10186481262459.930454497411166818.135838.8160979.330.387532850462384.778604428864647.50541112842262.726806699612168469.805854.04162615.760.355534725157815.549529126959896.86403127292081.31450214613168469.805854.04162615.760.326178646953041.78855883254951.25140483751909.462846005514170121.465854.04164267.420.29924646549156.444754811650908.24553096341751.800776151815171773.135854.04165919.090.274538041345551.101985054947158.25866042351607.156675368616171773.135915.03165858.10.251869762741774.640284325943264.45748662711489.817202301217173424.795930.27167494.520.231073176838703.490826934540073.81715490181370.326327967318175076.465930.27169146.190.211993740235857.933450275237115.11356767641257.180117401219175076.465930.27169146.190.194489669932897.186651628634050.56290612511153.376254496520176728.125945.52170782.60.178430889830472.89127732931533.75570114731060.8644238183TOTAL1492004.5473565253044.1892991691

Calculo del VAN685846.138057348

Calculo del TIR

B/C28.128

Problema 2i=0.20064619650.09

Aos Costos de la Invercion a Precios Sociales Beneficios Costos incrementales de operacin y manteniminetoflujosFactor de actualisacionFlujo neto a precios socialesBeneficio*factor de actualisaconC Oy M * factor de actualisacion1753114.22155256.485747.32149509.160.8328848273124523.910905426129310.7665310284786.85562560162156908.145762.57151145.570.6936971355104849.248957964108846.727260293997.4783023263158559.515762.57152796.940.577769818988281.460356106691610.89938154973329.43902544314160211.475762.57154448.90.481215715974323.237975888677096.27722357972773.03924769115160211.475777.81154433.660.400797268461896.589075086364212.31954034832315.73046526216161863.145808.3156054.840.333817963752093.908908199854032.82378653041938.91487833067163514.805808.3157706.50.27803191743847.440520110345462.33330368581614.89278357558163514.805808.3157706.500.231568565236519.867924862837864.8876220091345.01969714629165166.475808.3159358.170.192869944430735.401390485331855.64788864951120.246498164210165166.475823.55159342.920.160638450325596.599742549126532.0857900667935.486047517711166818.135838.8160979.330.13379332821537.960295708722319.1527790827781.19248337412168469.805854.04162615.760.111434432918120.994990119218773.3366174742652.341627354913168469.805854.04162615.760.092812048415092.701782735515636.0272263715543.32544363614170121.465854.04164267.420.077301746912698.158520955613150.6860392426452.52751828715171773.135854.04165919.090.064383452110682.443782999211059.3470869134376.903303914116171773.135915.03165858.10.05362400048893.97481749489211.1623884649317.187570970217173424.795930.27167494.520.04466261637480.74347838227745.6048519217264.861373539518175076.465930.27169146.190.03719881556292.03790755146512.6369269086220.599019357219175076.465930.27169146.190.0309823295240.54290595645424.2764820949183.733576138520176728.125945.52170782.60.02580471174406.99576147454560.4181911586153.4224296841TOTAL781217.4169173728103.1969173137

Calculo del VAN0.0000000565

Calculo del TIR0.2006461965

B/C27.798

Problema 3Problema 3Elaborar el cuadro de deuda por analuidada constante y el grafico vector tiempoDatos Invercion = 240355.5Se requiere finacioamiento al 85% =0.85Horizonte de deuda =9aosi = 15.25% =0.1525Periodo de gracia =2aos

Solucion

n =7Invercion total =204302.175Calculo de R R =49474.9623821861

PeriodosaldoAmortizacionInteresPagos finacieros InicialFinal1204302.175031156.081687531156.08168752204302.175031156.081687531156.08168753204302.175185983.29430531418318.880694686131156.081687549474.96238218614185983.294305314164870.78430468821112.510000625828362.452381560449474.96238218615164870.784304688140538.61652896724332.167775721225142.794606464949474.96238218616140538.616528967112495.79316744828042.823361518721432.139020667449474.96238218617112495.79316744880176.439243297932319.353924150317155.608458035949474.9623821861880176.439243297942928.383845714737248.055397583212226.906984602949474.9623821861942928.383845714742928.38384571466546.578536471549474.9623821861GRAFICO VECTOR TIEMPOSuma31156.081687528362.452381560425142.794606464921432.139020667417155.608458035912226.90698460296546.578536471518318.880694686121112.510000625824332.167775721228042.823361518732319.353924150337248.055397583237248.055397583231,156.0831,156.08123456789204302.175