{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["工作表1","Check"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"工作表1","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["time to maturity (in 0.5 years)",10]
["annual coupon rate",0.08]
["discount interest rate",0.43471295759081841]
["par value",100]
["number of coupon payments per year (1 or 2)",2]
["Bond Price",20]

{"sheet":"Check","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B1/(1+interest_rate/payment_frequency)^A1","v":3.2858082818584533}]
[2,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B2/(1+interest_rate/payment_frequency)^A2","v":2.6991340162823998}]
[3,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B3/(1+interest_rate/payment_frequency)^A3","v":2.2172092261366445}]
[4,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B4/(1+interest_rate/payment_frequency)^A4","v":1.8213311094631897}]
[5,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B5/(1+interest_rate/payment_frequency)^A5","v":1.4961362108701484}]
[6,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B6/(1+interest_rate/payment_frequency)^A6","v":1.2290041881163645}]
[7,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B7/(1+interest_rate/payment_frequency)^A7","v":1.0095680349378686}]
[8,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B8/(1+interest_rate/payment_frequency)^A8","v":0.82931175257460332}]
[9,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B9/(1+interest_rate/payment_frequency)^A9","v":0.68123985621304495}]
[10,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B10/(1+interest_rate/payment_frequency)^A10","v":0.55960589036922126}]
[11,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B11/(1+interest_rate/payment_frequency)^A11","v":0.45968941728799018}]
[12,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B12/(1+interest_rate/payment_frequency)^A12","v":0.37761282360189108}]
[13,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B13/(1+interest_rate/payment_frequency)^A13","v":0.31019083578176226}]
[14,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B14/(1+interest_rate/payment_frequency)^A14","v":0.25480690429207747}]
[15,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B15/(1+interest_rate/payment_frequency)^A15","v":0.20931165909940555}]
[16,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B16/(1+interest_rate/payment_frequency)^A16","v":0.17193949573959003}]
[17,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B17/(1+interest_rate/payment_frequency)^A17","v":0.14124005476992776}]
[18,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B18/(1+interest_rate/payment_frequency)^A18","v":0.11602193542329256}]
[19,{"$f":"coupon*par/payment_frequency","v":4},{"$f":"B19/(1+interest_rate/payment_frequency)^A19","v":9.5306459072775324E-2}]
[20,{"$f":"par + coupon*par/payment_frequency","v":104},{"$f":"B20/(1+interest_rate/payment_frequency)^A20","v":2.0355318914835379}]
[null,null,{"$f":"SUM(C1:C20)","v":20.00000004337419}]