{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Main","Holidays"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Main","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Mexican Udibonos Value, Risk Statistics, and Cash Flows"]
[]
[]
[]
[]
[]
[]
[]
[null,"Details",null,null,"Results"]
[null,"settlement date","2007-08-16",null,null,null,"clean bond price (excludes accrued)",3838610.590675082,1]
[null,"maturity date","2016-06-16",null,null,null,"accrued interest",26126.48694444444,2]
[null,"dated date",null,null,null,null,"dirty bond price (includes accrued)",3864737.0776195265,3]
[null,"date of first coupon after dated date",null,null,null,null,"duration",7.285912021353348,4]
[null,"date of last coupon prior to maturity",null,null,null,null,"modified duration",7.106262457291896,5]
[null,"coupon rate",0.05,null,null,null,"modified convexity",61.06946736825398,6]
[null,"principal",1000000,null,null,null,"basis point value",-2745.203513024921,7]
[null,"yield",0.0500053,null,null,null,"yield value change per 1bp increase in price",-3.6411519495218422e-06,8]
[null,"value per UDI (in Pesos)",3.838994,null,null,null,"next cash flow date","2007-12-27",9]
[null,null,null,null,null,null,"previous cash flow date","2007-06-28",10]
[null,null,null,null,null,null,"number of days from value date to maturity",3227,11]
[null,null,null,null,null,null,"years to maturity",8.963888888888889,12]
[null,null,null,null,null,null,"number of days from value date to next cash flow",133,13]
[null,null,null,null,null,null,"number of days of accrued interest",49,14]
[null,null,null,null,null,null,"number of remaining cash flows",18,15]
[]
[]
[]
[null,"Cash Flow Table"]
[null,"cash flow date","interest","principal","total cash flow","accrued interest"]
[null,"2007-12-27",97041.23722222222,0,97041.23722222222,26126.48694444444]
[null,"2008-06-26",97041.23722222222,0,97041.23722222222,0]
[null,"2008-12-24",96508.04361111112,0,96508.04361111112,0]
[null,"2009-06-25",97574.43083333333,0,97574.43083333333,0]
[null,"2009-12-24",97041.23722222222,0,97041.23722222222,0]
[null,"2010-06-24",97041.23722222222,0,97041.23722222222,0]
[null,"2010-12-23",97041.23722222222,0,97041.23722222222,0]
[null,"2011-06-23",97041.23722222222,0,97041.23722222222,0]
[null,"2011-12-22",97041.23722222222,0,97041.23722222222,0]
[null,"2012-06-21",97041.23722222222,0,97041.23722222222,0]
[null,"2012-12-20",97041.23722222222,0,97041.23722222222,0]
[null,"2013-06-20",97041.23722222222,0,97041.23722222222,0]
[null,"2013-12-19",97041.23722222222,0,97041.23722222222,0]

{"sheet":"Holidays","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Holidays"]
[]
[]
[null,"Holidays"]
[null,"date"]
[null,"2007-01-01"]
[null,"2007-04-21"]
[null,"2007-05-01"]
[null,"2007-09-07"]
[null,"2007-10-12"]
[null,"2007-11-02"]
[null,"2007-11-15"]
[null,"2007-12-25"]
[null,"2008-01-01"]
[null,"2008-04-21"]
[null,"2008-05-01"]
[null,"2008-09-07"]
[null,"2008-10-12"]
[null,"2008-11-02"]
[null,"2008-11-15"]
[null,"2008-12-25"]
[null,"2009-01-01"]
[null,"2009-04-21"]
[null,"2009-05-01"]
[null,"2009-09-07"]
[null,"2009-10-12"]
[null,"2009-11-02"]
[null,"2009-11-15"]
[null,"2009-12-25"]