Spreadsheet: vkaminski__40664__Position_030200
Sheet: Input_Escalators

 | 1 |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  | 1999-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00
1 | IGPM | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.049065
2 | TJLP | 2 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
3 | USD | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.6
4 |  | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
5 |  | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
6 |  | 6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7 |  | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
8 |  | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
9 |  | 9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 |  | 10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | 1998-12-31 00:00:00 | 1999-01-31 00:00:00 | 1999-02-28 00:00:00 | 1999-03-31 00:00:00 | 1999-04-30 00:00:00 | 1999-05-31 00:00:00 | 1999-06-30 00:00:00 | 1999-07-31 00:00:00 | 1999-08-31 00:00:00 | 1999-09-30 00:00:00 | 1999-10-31 00:00:00 | 1999-11-30 00:00:00 | 1999-12-31 00:00:00 | 2000-01-31 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-02-28 00:00:00 | 2003-03-31 00:00:00 | 2003-04-30 00:00:00 | 2003-05-31 00:00:00 | 2003-06-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-31 00:00:00 | 2003-09-30 00:00:00 | 2003-10-31 00:00:00 | 2003-11-30 00:00:00 | 2003-12-31 00:00:00 | 2004-01-31 00:00:00 | 2004-02-29 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-05-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-31 00:00:00 | 2004-08-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-31 00:00:00 | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-28 00:00:00 | 2005-03-31 00:00:00 | 2005-04-30 00:00:00 | 2005-05-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-31 00:00:00 | 2005-08-31 00:00:00 | 2005-09-30 00:00:00 | 2005-10-31 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00 | 2006-01-31 00:00:00 | 2006-02-28 00:00:00 | 2006-03-31 00:00:00 | 2006-04-30 00:00:00 | 2006-05-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-31 00:00:00 | 2006-08-31 00:00:00 | 2006-09-30 00:00:00 | 2006-10-31 00:00:00 | 2006-11-30 00:00:00 | 2006-12-31 00:00:00 | 2007-01-31 00:00:00 | 2007-02-28 00:00:00 | 2007-03-31 00:00:00 | 2007-04-30 00:00:00 | 2007-05-31 00:00:00 | 2007-06-30 00:00:00 | 2007-07-31 00:00:00 | 2007-08-31 00:00:00 | 2007-09-30 00:00:00 | 2007-10-31 00:00:00 | 2007-11-30 00:00:00 | 2007-12-31 00:00:00 | 2008-01-31 00:00:00 | 2008-02-29 00:00:00 | 2008-03-31 00:00:00 | 2008-04-30 00:00:00 | 2008-05-31 00:00:00 | 2008-06-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-31 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | 2013-04-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-31 00:00:00 | 2014-09-30 00:00:00 | 2014-10-31 00:00:00 | 2014-11-30 00:00:00 | 2014-12-31 00:00:00 | 2015-01-31 00:00:00 | 2015-02-28 00:00:00 | 2015-03-31 00:00:00 | 2015-04-30 00:00:00 | 2015-05-31 00:00:00 | 2015-06-30 00:00:00 | 2015-07-31 00:00:00 | 2015-08-31 00:00:00 | 2015-09-30 00:00:00 | 2015-10-31 00:00:00 | 2015-11-30 00:00:00 | 2015-12-31 00:00:00 | 2016-01-31 00:00:00 | 2016-02-29 00:00:00 | 2016-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-05-31 00:00:00 | 2016-06-30 00:00:00 | 2016-07-31 00:00:00 | 2016-08-31 00:00:00 | 2016-09-30 00:00:00 | 2016-10-31 00:00:00 | 2016-11-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00 | 2018-08-31 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00
1 | IGPM |  | 0.0084 | 0.0361 | 0.0283 | 0.0071 | -0.0029 | 0.0036 | 0.0155 | 0.0156 | 0.0145 | 0.017 | 0.0239 | 0.025 | 0.0198
2 | TJLP |  | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
3 | USD |  | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.65 | 1.7 | 1.81 | 1.78
4
5
6
7
8
9
10
1 | IGPM
2 | TJLP
3 | USD
4
5
6
7
8
9
10
 | ENRON  FORECAST
 |  | Exchange Rate (BRL/US$) |  | Enron Curve |  |  | Inflation
 | Date | Market | Forecast1 | Enron Curve | Devaluation | Cumm. Devaluation | US2 | Brazil IGPM | "Net" Inflation | Net Inflation ( Cumm.)
 |  | Market | Forecast | 1.877
 | Current | 1.877 |  | 2.0233
 | 1999-12-31 00:00:00 | 2.0233 | 2.05 | 2.3933 | 0.07794352690463491 | 0 | 0.02600928963878985 | 0.152 | 0.1259907103612102 | 0.1259907103612102 | -0.1259907103612102
 | 2000-12-31 00:00:00 |  | 2.3933 | 2.515555555555556 | 0.1828695695151485 | 0.1828695695151485 | 0.02335913093183014 | 0.1173 | 0.09394086906816987 | 0.231767256255228 | -0.04889768674007944
 | 2001-12-31 00:00:00 |  | 2.515555555555556 | 2.641111111111111 | 0.05108241990371276 | 0.2432934095564454 | 0.02097609360182529 | 0.1 | 0.07902390639817472 | 0.3291063166178778 | -0.08581290706143241
 | 2002-12-31 00:00:00 |  | 2.641111111111111 | 2.766666666666667 | 0.04991166077738529 | 0.3053482484609853 | 0.01886017764877532 | 0.0945248904818796 | 0.07566471283310428 | 0.4296727643894345 | -0.1243245159284492
 | 2003-12-31 00:00:00 |  | 2.766666666666667 | 2.892222222222223 | 0.04753891459823301 | 0.3674030873655252 | 0.01701138307268023 | 0.0895248904818796 | 0.07251350740919937 | 0.5333433509827183 | -0.1659402636171932
 | 2004-12-31 00:00:00 |  | 2.892222222222223 | 3.017777777777778 | 0.0453815261044177 | 0.4294579262700651 | 0.01542970987354 | 0.0845248904818796 | 0.0690951806083396 | 0.6392899867534658 | -0.2098320604834008
 | 2005-12-31 00:00:00 |  | 3.017777777777778 | 3.143333333333334 | 0.04341144832885124 | 0.4915127651746052 | 0.01411515805135466 | 0.07952489048187959 | 0.06540973243052493 | 0.7465155061630488 | -0.2550027409884437
 | 2006-12-31 00:00:00 |  | 3.143333333333334 | 3.26888888888889 | 0.04160530191458034 | 0.5535676040791451 | 0.01306772760612418 | 0.07452489048187959 | 0.06145716287575541 | 0.8538513940903438 | -0.3002837900111988
 | 2007-12-31 00:00:00 |  | 3.26888888888889 | 3.394444444444445 | 0.03994344291268992 | 0.615622442983685 | 0.01228741853784858 | 0.06952489048187958 | 0.057237471944031 | 0.9599611612479926 | -0.3443387182643076
 | 2008-12-31 00:00:00 |  | 3.394444444444445 | 3.52 | 0.03840924541128476 | 0.6776772818882248 | 0.01177423084652784 | 0.06452489048187958 | 0.05275065963535173 | 1.063350405363494 | -0.3856731234752693
 | 2009-12-31 00:00:00 |  | 3.52 | 3.645555555555557 | 0.0369885433715218 | 0.7397321207927645 | 0.01152816453216199 | 0.05952489048187957 | 0.04799672594971759 | 1.162384469307964 | -0.4226523485151998
 | 2010-12-31 00:00:00 |  | 3.645555555555557 | 3.771111111111112 | 0.03566919191919227 | 0.8017869596973048 | 0.011549219594751 | 0.05452489048187958 | 0.04297567088712857 | 1.255314392592382 | -0.4535274328950767
 | 2011-12-31 00:00:00 |  | 3.771111111111112 | 3.896666666666668 | 0.0344407192928986 | 0.8638417986018447 | 0.01183739603429489 | 0.05198783454987821 | 0.04015043851558332 | 1.345866254445472 | -0.4820244558436275
 | 2012-12-31 00:00:00 |  | 3.896666666666668 | 4.022222222222223 | 0.03329404832056571 | 0.9258966375063846 | 0.01239269385079365 | 0.05188929889298899 | 0.03949660504219533 | 1.43852000737912 | -0.5126233698727349
 | 2013-12-31 00:00:00 |  | 4.022222222222223 | 4.147777777777779 | 0.03222127174222966 | 0.9879514764109243 | 0.0132151130442473 | 0.05088929889298899 | 0.03767418584874169 | 1.530389263332995 | -0.5424377869220711
 | 2014-12-31 00:00:00 |  | 4.147777777777779 | 4.273333333333334 | 0.03121546961325961 | 1.050006315315464 | 0.01430465361465581 | 0.05087538259728897 | 0.03657072898263316 | 1.622927443302911 | -0.5729211279874469
 | 2015-12-31 00:00:00 |  | 4.273333333333334 | 4.39888888888889 | 0.03027055987141702 | 1.112061154220004 | 0.01566131556201919 | 0.0511295336787565 | 0.03546821811673731 | 1.715958005966355 | -0.603896851746351
 | 2016-12-31 00:00:00 |  | 4.39888888888889 | 4.524444444444446 | 0.02938117524700989 | 1.174115993124544 | 0.01728509888633744 | 0.04999901787468065 | 0.03271391898834321 | 1.804807636149281 | -0.6306916430247367
 | 2017-12-31 00:00:00 |  | 4.524444444444446 | 4.65 | 0.0285425612528416 | 1.236170832029084 | 0.01917600358761057 | 0.04892459504747727 | 0.0297485914598667 | 1.8882467126406 | -0.6520758806115157
 | 2018-12-31 00:00:00 |  | 4.65 | 4.6 | 0.0277504911591353 | 1.298225670933624 | 0.02133402966583858 | 0.04906530180021185 | 0.02773127213437328 | 1.968341468220045 | -0.6701157972864213
 | 2019-12-31 00:00:00 |  | 4.6 | 4.6 |  |  |  | 0.04906530180021185
 | 2020-12-31 00:00:00 |  | 4.6 |  |  |  |  | 0.04906530180021185