{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MTB","PIB"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":21,"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"}

{"sheet":"MTB","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["MTBs - Price & Settlement Amount Computation"]
["Particulars",null,"Investment "]
["Face Value","Enter value that you want to invest",1000000]
["Tenor (Days)","Maturity days from purchase date",{"$f":"C8-C6","v":-4}]
["Deal Date","Date of deal trade","2021-03-27"]
["Deal Start/ Settlement Date","Actual deal start/settlement date (t+2 business day or spot)","2021-03-29"]
["Issue Date","Pleaseselect issue date from \"offer sheet\"","2020-12-31"]
["Maturity Date","Please enter amturity date of selected issue in \"offer sheet\"","2021-03-25"]
["Yield","Yield of selected issue in \"Offer sheet\"",7.0000000000000007E-2]
["Price","Offered price of selected issue in \"Offer sheet\"",{"$f":"ROUND(100/(((C$4/365)*(C$9))+1),4)","v":100.07680000000001}]
["Investment/Settlement Amount","Face Value*(Price/100)",{"$f":"ROUND(C3*(C10/100),0)","v":1000768}]
[]
["NOTE: *Input values in blue colour"]

{"sheet":"PIB","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["PIBs - Price & Settlement Amount Computation "]
["Particulars",null,"Investment "]
["Deal Date","Date of deal trade","2021-03-25"]
["Deal Start/Settlement Date","Actual deal start/settlement date (t+2 business day or spot)","2021-03-26"]
["Issue Date","Please select issue date from \"offer sheet\"","2020-10-22"]
["Issue Maturity","Please enter amturity date of selected issue in \"offer sheet\"","2023-10-22"]
["Coupons frequency per Year","Please enter frequency 2-Semiannual, 4-quarterly",4]
["Last Coupon date","Excel based calculation, do not change",{"$f":"COUPPCD(C4,C6,C7,1)","v":"2021-01-22"}]
["Next Coupon Date","Excel based calculation, do not change",{"$f":"COUPNCD(C4,C6,C7,1)","v":"2021-04-22"}]
["Accrued Days ","Excel based calculation, do not change",{"$f":"COUPDAYBS(C4,C6,C7,1)","v":63}]
["No. of coupon days in the period","Excel based calculation, do not change",{"$f":"C9-C8","v":90}]
["Price","Offered price of selected issue in \"Offer sheet\"",{"$f":"ROUND(PRICE(C4,C6,C13,C14,100,C7,1),4)","v":98.835599999999999}]
["Coupon Rate","Coupon rate of selected issue in \"Offer sheet\"",7.0000000000000007E-2]
["Yield","Yield of selected issue in \"Offer sheet\"",7.4999999999999997E-2]
["Face Value","Enter value that you want to invest",100000]
["Principle amount/Purchase Cost","Face Value * Price /100",{"$f":"ROUND(C15*(C12/100),0)","v":98836}]
["Accrued Mark-up","As per rule, Buyer of PIB also pays coupon to seller and receive same on maturity from SBP",{"$f":"ROUND((C15*C13/C7*C10/C11),0)","v":1225}]
["Settlement Amount","Face Value*(Price/100)+accrued income",{"$f":"ROUND(C16+C17,0)","v":100061}]
[]
[]
["NOTE: *Input values in blue colour"]