RiskSerializationData116ERROR:#NAME?FALSE11GF1_rK0qDwEACADdAAwjACYAOwB5AIIAgwCPAJsAuwApANcALQD//wAAAAABAQEAAQQAAAAABDAuMDAAAAABOFRhc2EgZGUgY3JlY2ltaWVudG8gZGUgbGFzIHZlbnRhcyAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAQABAQUAAQABAwEBAP8BAQEBAQABAQEAAgABAQEBAQABAQEAAgABnwAAGgATVHJpYW5nKDAsMC4wNSwwLjA4KQAAJQECAMMAzQABAQIBoJmZmZmZmT8AADMzMzMzM+8/AAAFAAEBAQA=1ERROR:#NAME?11TRUEFALSE1FALSEERROR:#NAME?ERROR:#NAME?FALSE11GF1_rK0qDwEACADHAAwjACYAPgBlAG4AbwB7AIcApQApAMEALQD//wAAAAABAQEAAQQAAAAAB0dlbmVyYWwAAAABIUludmVyc2nDs24gLyBWYXJpYWJsZXMgZGUgZW50cmFkYQEAAQEFAAEAAQMBAQD/AQEBAQEAAQEBAAIAAQEBAQEAAQEBAAIAAYsAABgAEVBlcnQoMTA4LDEyMCwxMzIpAAAlAQIArQC3AAEBAgGgmZmZmZmZPwAAMzMzMzMz7z8AAAUAAQEBAA==1ERROR:#NAME?21TRUEFALSE1FALSEERROR:#NAME?ERROR:#NAME?FALSE11GF1_rK0qDwEACADDAAwjACYAOwBkAG0AbgB6AIYAoQApAL0ALQD//wAAAAABAQEAAQQAAAAABDAuMDAAAAABI0Nvc3RvcyBmaWpvcyAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAQABAQUAAQABAwEBAP8BAQEBAQABAQEAAgABAQEBAQABAQEAAgABigAAFQAOVW5pZm9ybSg0NSw1NSkAACUBAgCpALMAAQECAaCZmZmZmZk/AAAzMzMzMzPvPwAABQABAQEA1ERROR:#NAME?31TRUEFALSE1FALSEERROR:#NAME?ERROR:#NAME?FALSE11GF1_rK0qDwEACADWAAwjACYAOwBzAHwAfQCJAJUAtAApANAALQD//wAAAAABAQEAAQQAAAAABDAuMDAAAAABMkNvc3RvcyB2YXJpYWJsZXMgKCUgdmVudGFzKSAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAQABAQUAAQABAwEBAP8BAQEBAQABAQEAAgABAQEBAQABAQEAAgABmQAAGQASUGVydCgwLjI1LDAuMywwLjQpAAAlAQIAvADGAAEBAgGgmZmZmZmZPwAAMzMzMzMz7z8AAAUAAQEBAA==1ERROR:#NAME?41TRUEFALSE1FALSEERROR:#NAME?ERROR:#NAME?FALSE11GF1_rK0qDwEACADhAAwjACYAOwB+AIcAiACUAKAAvwApANsALQD//wAAAAABAQEAAQQAAAAABDAuMDAAAAABPVRhc2EgZGUgZXNjYWxhbWllbnRvIChkZSBjb3N0b3MgZmlqb3MpIC8gVmFyaWFibGVzIGRlIGVudHJhZGEBAAEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAGkAAAZABJVbmlmb3JtKDAuMDEsMC4wNSkAACUBAgDHANEAAQECAaCZmZmZmZk/AAAzMzMzMzPvPwAABQABAQEA1ERROR:#NAME?51TRUEFALSE1FALSEERROR:#NAME?ERROR:#NAME?FALSE11GF1_rK0qDwEACADiAAwjACYAPAB/AIgAiQCVAKEAwAApANwALQD//wAAAAABAQEAAQQAAAAABTAuMDAwAAAAAT1UYXNhIGRlIGVzY2FsYW1pZW50byAoZGUgY29zdG9zIGZpam9zKSAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAQABAQUAAQABAwEBAP8BAQEBAQABAQEAAgABAQEBAQABAQEAAgABpQAAGQASVW5pZm9ybSgwLjAxLDAuMDQpAAAlAQIAyADSAAEBAgGamZmZmZmpPwAAZmZmZmZm7j8AAAUAAQEBAA==1ERROR:#NAME?01FALSEFALSE1FALSEERROR:#NAME?0ERROR:#NAME?TRUE05GF1_rK0qDwEACAAFAQwjACYAUwCGAI8AkACcAKgA5AApAP8ALQD//wABAAABAQEAAQQAAAAAHCQjLCMjMC4wMF8pO1tSZWRdKCQjLCMjMC4wMCkAAAABLVZhbG9yIGFjdHVhbCBuZXRvIEAgMTAlIC8gVmFyaWFibGVzIGRlIHNhbGlkYQEAAQEFAAEAAQMBAQD/AQEBAQEAAQEBAAIAAQEBAQEAAQEBAAIAAawAAjQALVZhbG9yIGFjdHVhbCBuZXRvIEAgMTAlIC8gVmFyaWFibGVzIGRlIHNhbGlkYQAALwECAAIA7AD1AAEBAgEAAAAAAAAAAAFmZmZmZmbuPwAABQABAQEA113GF1_Z0CmcQEACAD3AAwjACYATgAAAKYApwDgAOwAAAAAAAAAKAD//wABEAEEAAAAABwkIywjIzAuMDBfKTtbUmVkXSgkIywjIzAuMDApAAAAATVWYWxvciBhY3R1YWwgbmV0byBAIDEwJSAvIFZhcmlhYmxlcyBkZSBzYWxpZGEgKFNpbSMxKQEdUmVncmVzacOzbiAtIFZhbG9yZXMgbWFwZWFkb3MBAf8BAQEBAS1WYWxvciBhY3R1YWwgbmV0byBAIDEwJSAvIFZhcmlhYmxlcyBkZSBzYWxpZGEBAQEAAgABAQEAAQABAQEAAgAB8AADBwAAAAAvAQ==0~0~>75%~90%>75%90%ERROR:#NAME?11FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05GF1_rK0qDwEACAD6AAwjACYAOQB0AH0AfgCKAJYA2gApAPQALQD//wABAAABAQEAAQQAAAAAAjAlAAAAATVUYXNhIGludGVybmEgZGUgcmV0b3JubyAvIFZhcmlhYmxlcyBkZSBzYWxpZGEgKFNpbSMxKQEAAQEFAAEAAQMBAQD/AQEBAQEAAQEBAAIAAQEBAQEAAQEBAAIAAZoAAjwANVRhc2EgaW50ZXJuYSBkZSByZXRvcm5vIC8gVmFyaWFibGVzIGRlIHNhbGlkYSAoU2ltIzEpAAAvAQIAAgDiAOsAAQECAZSZmZmZmbk/ATwK16NwPeI/AQUAAQEBAA==113GF1_Z0CmcQEACADdAAwjACYANAAAAIwAjQDGANIAAAAAAAAAKAD//wABEAEEAAAAAAIwJQAAAAE1VGFzYSBpbnRlcm5hIGRlIHJldG9ybm8gLyBWYXJpYWJsZXMgZGUgc2FsaWRhIChTaW0jMSkBHVJlZ3Jlc2nDs24gLSBWYWxvcmVzIG1hcGVhZG9zAQH/AQEBAQEtVGFzYSBpbnRlcm5hIGRlIHJldG9ybm8gLyBWYXJpYWJsZXMgZGUgc2FsaWRhAQEBAAIAAQEBAAEAAQEBAAIAAdYAAwcAAAAALwE=0~0~>75%~90%>75%90%ERROR:#NAME?21FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05GF1_rK0qDwEACAC8AAwjACYAOABUAF0AXgBqAHYAmwApALYALQD//wAAAAABAQEAAQQAAAAAATAAAAABFkZsdWpvIGRlIGNhamEgLyBBw7FvIDABAAEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAF6AAIdABZGbHVqbyBkZSBjYWphIC8gQcOxbyAwAAAvAQIAAgCjAKwAAQECAQAAAAAAEF7AAWZmZmZmZu4/AAAFAAEBAQA=100>75%90%ERROR:#NAME?31FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05111GF1_Z0CmcQEACAChAAwjACYAMgAAAGgAaQCKAJYAAAAAAAAAKAD//wABEAEEAAAAAAAAAAABFkZsdWpvIGRlIGNhamEgLyBBw7FvIDEBGkNvZWZpY2llbnRlcyBkZSByZWdyZXNpw7NuAQH/AQEBAQEVVmFsb3IgZGVsIGNvZWZpY2llbnRlAQEBAAIAAQEBAAEAAQEBAAIAAZoAAwcAAAAALwE=0~0~>75%~90%>75%90%ERROR:#NAME?41FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05GF1_rK0qDwEACAC9AAwjACYAOABUAF0AXgBqAHYAmwApALcALQD//wAAAAABAQEAAQQAAAAAATAAAAABFkZsdWpvIGRlIGNhamEgLyBBw7FvIDIBAAEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAF6AAIdABZGbHVqbyBkZSBjYWphIC8gQcOxbyAyAAAvAQIAAgCjAK0AAQECAZqZmZmZmak/AABmZmZmZmbuPwAABQABAQEA100>75%90%ERROR:#NAME?51FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05GF1_rK0qDwEACAC9AAwjACYAOABUAF0AXgBqAHYAmwApALcALQD//wAAAAABAQEAAQQAAAAAATAAAAABFkZsdWpvIGRlIGNhamEgLyBBw7FvIDMBAAEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAF6AAIdABZGbHVqbyBkZSBjYWphIC8gQcOxbyAzAAAvAQIAAgCjAK0AAQECAZqZmZmZmak/AABmZmZmZmbuPwAABQABAQEA100>75%90%ERROR:#NAME?61FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?TRUE05GF1_rK0qDwEACAC7AAwjACYAOABUAF0AXgBqAHYAmwApALUALQD//wAAAAABAQEAAQQAAAAAATAAAAABFkZsdWpvIGRlIGNhamEgLyBBw7FvIDQBAAEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAF6AAIdABZGbHVqbyBkZSBjYWphIC8gQcOxbyA0AAAvAQIAAgCjAKwAAQECAQAAAAAAAPD/AQAAAAAAYFlAAQUAAQEBAA==100>75%90%ERROR:#NAME?71FALSETRUE0FALSEERROR:#NAME?000>75%90%000>75%90%000>75%90%000>75%90%ERROR:#NAME?FALSE15GF1_rK0qDwEACADzAAwjACYAPgB6AIMAhACQAJwA0QApAO0ALQD//wABAAABAQEAAQQAAAAAB0dlbmVyYWwAAAABElZlbnRhcyBwcm95ZWN0YWRhcwEkQ29tcGFyYWNpw7NuIGNvbiBUcmlhbmcoMTIwLDE2MCwyMDApAQEFAAEAAQMBAQD/AQEBAQEAAQEBAAIAAQEBAQEAAQEBAAIAAqMAAsAAABkAElZlbnRhcyBwcm95ZWN0YWRhcwAALwECAAIADwAIVGXDs3JpY2EBASUBAgDZAOMAAQECAZqZmZmZmak/AABmZmZmZmbuPwAABQABAQEA200ERROR:#NAME?11FALSEFALSE1FALSEERROR:#NAME?ERROR:#NAME?11TRUEFALSE1TRUEERROR:#NAME?000000000000ERROR:#NAME?FALSE15GF1_rK0qDwEACAAOAQwjACYAPgCHAJAAkQCdAKkA7QApAAgBLQD//wAAAAABAQEAAQQAAAAAB0dlbmVyYWwAAAABIUludmVyc2nDs24gLyBWYXJpYWJsZXMgZGUgZW50cmFkYQEiQ29tcGFyYWNpw7NuIGNvbiBQZXJ0KDEwOCwxMjAsMTMyKQEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAKwAALcAAAoACFJbnZlcnNpw7NuIC8gVmFyaWFibGVzIGRlIGVudHJhZGEAAC8BAgACAA8ACFRlw7NyaWNhAQElAQIA9QD+AAEBAgEAAAAAAIBcQAFmZmZmZmbuPwAABQABAQEA200ERROR:#NAME?31FALSEFALSE1FALSEERROR:#NAME?ERROR:#NAME?31TRUEFALSE1TRUEERROR:#NAME?000000000000ERROR:#NAME?FALSE15GF1_rK0qDwEACAAKAQwjACYAOACAAIkAigCWAKIA6AApAAQBLQD//wABAAABAQEAAQQAAAAAATAAAAABI0Nvc3RvcyBmaWpvcyAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAR9Db21wYXJhY2nDs24gY29uIFVuaWZvcm0oNDUsNTUpAQEFAAEAAQMBAQD/AQEBAQEAAQEBAAIAAQEBAQEAAQEBAAIAAqkAAtcAACoAI0Nvc3RvcyBmaWpvcyAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhAAAvAQIAAgAPAAhUZcOzcmljYQEBJQECAPAA+gABAQIBmpmZmZmZqT8AAGZmZmZmZu4/AAAFAAEBAQA=200ERROR:#NAME?41FALSEFALSE1FALSEERROR:#NAME?ERROR:#NAME?41TRUEFALSE1TRUEERROR:#NAME?000000000000ERROR:#NAME?FALSE15GF1_rK0qDwEACAAvAQwjACYAOwCWAJ8AoACsALgADQEpACkBLQD//wAAAAABAQEAAQQAAAAABDAuMDAAAAABMkNvc3RvcyB2YXJpYWJsZXMgKCUgdmVudGFzKSAvIFZhcmlhYmxlcyBkZSBlbnRyYWRhASNDb21wYXJhY2nDs24gY29uIFBlcnQoMC4yNSwwLjMsMC40KQEBBQABAAEDAQEA/wEBAQEBAAEBAQACAAEBAQEBAAEBAQACAAK/AAL8AAA5ADJDb3N0b3MgdmFyaWFibGVzICglIHZlbnRhcykgLyBWYXJpYWJsZXMgZGUgZW50cmFkYQAALwECAAIADwAIVGXDs3JpY2EBASUBAgAVAR8BAQECAZqZmZmZmak/AABmZmZmZmbuPwAABQABAQEA200ERROR:#NAME?51FALSEFALSE1FALSEERROR:#NAME?ERROR:#NAME?51TRUEFALSE1TRUEERROR:#NAME?0000000000000FALSE1120056508000100FALSE1120056508000500FALSE11200565080001000FALSE11200565080001500FALSE112005650800020000

Flujo de caja determinsticoDatos de entradaFLUJO DE CAJA - MODELO DETERMINISTICOFlujo de caja (en miles de US$)Indicadores de rentabilidadPeriodo01234Precio de ventaUS$160Ingresos por ventas160166173180Tasa de crecimiento de las ventas%0.04Inversin-120ProduccinUnidades1000Costos fijos-50-51-52-53Valor actual neto @ 10%92.2179413974InversinUS$120,000Costos variables-48-50-52-54Tasa interna de retorno41%Costos fijosUS$50,000Flujo de caja-12062656973Relacin beneficio/costo1.21Costos variables (% ventas)%0.3Tasa de escalamiento (costos fijos)%0.02Tasa de descuento%0.1Valor Actual de Beneficios535.922300389312098101104107Valor Actual de Costos443.7043589919

pb alliance - 2006

Flujo de caja probabilistico

FLUJO DE CAJA - MODELO PROBABILISTICO - FLUJO DE CAJAVariables de entradaFlujo de caja (en miles de US$)Variables de salidaVentas proyectadasERROR:#NAME?Periodo01234Tasa de crecimiento de las ventasERROR:#NAME?Ingresos por ventasERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ProduccinERROR:#NAME?InversinERROR:#NAME?Valor actual neto @ 10%ERROR:#NAME?InversinERROR:#NAME?Costos fijosERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ERROR:#NAME?Costos fijosERROR:#NAME?Costos variablesERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ERROR:#NAME?Tasa interna de retornoERROR:#NAME?Costos variables (% ventas)ERROR:#NAME?Flujo de cajaERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ERROR:#NAME?ERROR:#NAME?Tasa de escalamiento (de costos fijos)ERROR:#NAME?Tasa de descuento0.10

Rango de las variables de entrada segn opinin de expertosVariablesMinMost likelyMaxTipo de distribucinVentas proyectadas120160200TriangularProduccin77010001100TriangularTasa de crecimiento de las ventas0.010.040.08TriangularInversin100120160PertCostos fijos405060UniformeCostos variables (% ventas)0.100.300.40PertTasa de escalamiento (de costos fijos)0.010.020.04Uniforme

pb alliance - 2009

Hoja2

Hoja3