{"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 BPA Value, Risk Statistics, and Cash Flows"]
[]
[]
[]
[]
[]
[]
[]
[null,"Details",null,null,"Results"]
[null,"settlement date","2007-08-14",null,null,null,"clean bond price (excludes accrued)",999900.1731222217,1]
[null,"maturity date","2010-09-23",null,null,null,"accrued interest",9621.944444444445,2]
[null,"dated date",null,null,null,null,"dirty bond price (includes accrued)",1009522.1175666662,3]
[null,"date of first coupon after dated date",null,null,null,null,"duration",2.815604031822321,4]
[null,"date of last coupon prior to maturity",null,null,null,null,"modified duration",2.763636232272307,5]
[null,"coupon frequency",2,null,null,null,"modified convexity",8.914484503142967,6]
[null,"coupon rate",0.0737,null,null,null,"basis point value",-278.95019329238715,7]
[null,"market rate",0.0744,null,null,null,"yield value change per 1bp increase in price",-3.584291182592355e-05,8]
[null,"principal",1000000,null,null,null,"next cash flow date","2007-09-27",9]
[null,"yield to maturity",0.07439,null,null,null,"previous cash flow date","2007-06-28",10]
[null,"yield type",1,null,null,null,"number of days from value date to maturity",1136,11]
[null,null,null,null,null,null,"years to maturity",3.1555555555555554,12]
[null,null,null,null,null,null,"number of days from value date to next cash flow",44,13]
[null,null,null,null,null,null,"number of days of accrued interest",47,14]
[null,null,null,null,null,null,"number of remaining cash flows",13,15]
[]
[]
[]
[null,"Cash Flow Table"]
[null,"cash flow date","interest","principal","total cash flow","accrued interest"]
[null,"2007-09-27",18629.722222222223,0,18629.722222222223,9621.944444444445]
[null,"2007-12-27",18806.666666666664,0,18806.666666666664,0]
[null,"2008-03-27",18806.666666666664,0,18806.666666666664,0]
[null,"2008-06-26",18806.666666666664,0,18806.666666666664,0]
[null,"2008-09-25",18806.666666666664,0,18806.666666666664,0]
[null,"2008-12-24",18600,0,18600,0]
[null,"2009-03-26",19013.33333333333,0,19013.33333333333,0]
[null,"2009-06-25",18806.666666666664,0,18806.666666666664,0]
[null,"2009-09-24",18806.666666666664,0,18806.666666666664,0]
[null,"2009-12-24",18806.666666666664,0,18806.666666666664,0]
[null,"2010-03-25",18806.666666666664,0,18806.666666666664,0]
[null,"2010-06-24",18806.666666666664,0,18806.666666666664,0]
[null,"2010-09-23",18806.666666666664,1000000,1018806.6666666666,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"]