Ejer Cici Os Swaps

  • Upload
    dexgigi

  • View
    218

  • Download
    0

Embed Size (px)

DESCRIPTION

Swap en excel

Citation preview

Hoja1Tasa fija USD1.50%Fecha inicio7/16/15VN$250,000,000.00Plazo2aosPagomensualTasa euro0.5904%TCS1.0877usd/eurFechaFechaDas CupnDxVTasa en USDFactor de Descuenjto USDTasa cero en EuroFactor desc euroVN EuroFlujos euroSuma flujos euroVN USDFlujos USDsuma flujos usd07/16/1511-$229,842,787.53-$229,842,787.53$250,000,000.00$250,000,000.0018/14/1529290.001848340.9998511281-0.000817291.0000658416$118,890.30$118,890.30-$302,083.33-$302,083.3329/15/1532610.002363870.9995996157-0.00044951.0000761711$131,189.30$131,189.30-$333,333.33-$333,333.33310/16/1531920.002870.9992670931-0.000128521.0000328451$127,089.63$127,089.63-$322,916.67-$322,916.67411/13/15281200.002980680.99900742620.000133920.999955362$114,790.64$114,790.64-$291,666.67-$291,666.67512/16/15331530.003121050.99867531090.000380110.9998384793$135,288.96$135,288.96-$343,750.00-$343,750.0061/15/16301830.003387910.99828077320.000583440.9997035059$122,989.97$122,989.97-$312,500.00-$312,500.0072/16/16322150.003672680.99781139440.000808770.9995172178$131,189.30$131,189.30-$333,333.33-$333,333.3383/16/16292440.003932010.99734205450.001015030.9993125082$118,890.30$118,890.30-$302,083.33-$302,083.3394/15/16302740.004216110.99680133610.001219510.9990726781$122,989.97$122,989.97-$312,500.00-$312,500.00105/16/16313050.004509870.99619368130.001409720.9988070786$127,089.63$127,089.63-$322,916.67-$322,916.67116/16/16313360.004806580.99553389420.001566460.9985401051$127,089.63$127,089.63-$322,916.67-$322,916.67127/15/16293650.005108310.99484742780.001672030.9983076164$118,890.30$118,890.30-$302,083.33-$302,083.33138/16/16323970.005441530.99403499640.001735780.9980894775$131,189.30$131,189.30-$333,333.33-$333,333.33149/15/16304270.005753350.99322214050.001750780.9979276838$122,989.97$122,989.97-$312,500.00-$312,500.001510/14/16294560.006047380.99239821510.001730640.997812651$118,890.30$118,890.30-$302,083.33-$302,083.331611/16/16334890.006382340.99140516640.00167420.9977310382$135,288.96$135,288.96-$343,750.00-$343,750.001712/16/16305190.006687220.99045131430.001599230.9976997468$122,989.97$122,989.97-$312,500.00-$312,500.00181/16/17315500.007035380.98936580440.001505540.9977051479$127,089.63$127,089.63-$322,916.67-$322,916.67192/16/17315810.007387530.98821782220.001402790.9977411667$127,089.63$127,089.63-$322,916.67-$322,916.67203/16/17286090.007706040.98713170080.001308430.997791461$114,790.64$114,790.64-$291,666.67-$291,666.67214/14/17296380.008033460.98596277270.001215260.9978509177$118,890.30$118,890.30-$302,083.33-$302,083.33225/16/17326700.008394830.98461663390.001125130.9979103837$131,189.30$131,189.30-$333,333.33-$333,333.33236/16/17317010.008740980.9832642230.001058020.9979440356$127,089.63$127,089.63-$322,916.67-$322,916.67247/14/17287290.009026510.982049430.001020780.9979371845$229,842,787.53$114,790.64$229,727,996.90-$250,000,000.00-$291,666.67-$249,708,333.33VP Euro$2,281,370.89VP usd-$2,481,447.12VP euro-$2,281,370.89Diferencia$0.00