{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DSUM Function Overview","Corporate Bond Price","Fixed Income Security Price","Used in VBA Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"DSUM Function Overview","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[5,2,5,3],[6,2,7,3]]}
[]
[null,"Excel PRICE Function"]
[null,"Quick Overview"]
[]
[null,"PRICE Evaluation"]
[null,{"$f":"PRICE(D10,D11,D12,D13,D14,D15,D16)","v":111.3730204982042},">>Formula>> =PRICE(D10,D11,D12,D13,D14,D15,D16)"]
[null,null,"*E10=settlement, D11=maturity, D12=rate, D13=yld, D14=redemption, D15=frequency, D16=[basis]"]
[null,"**Financial Function"]
[null,"Description","Referring Argument","Values"]
[null,"Settlement Date","settlement","2011-01-01"]
[null,"Maturity Date","maturity","2021-12-31"]
[null,"Annual Coupon Rate","rate",8.5000000000000006E-2]
[null,"Yield","yld",7.0000000000000007E-2]
[null,"Redemption Amount (Per $100 Face Value)","redemption",100]
[null,"Number of Coupon Payments (Per Annum)","frequency (semi-annual)",2]
[null,"Day Count Basis (US (NASD) 30/360)","[basis]",0]

{"sheet":"Corporate Bond Price","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3]]}
[]
[null,"Excel PRICE Function"]
[null,"Corporate Bond Price Calculation"]
[]
[null,"PRICE Evaluation"]
[null,{"$f":"PRICE(D10,D11,D12,D13,D14,D15,D16)","v":111.3730204982042}]
[]
[]
[null,"Description","Referring Argument","Values"]
[null,"Settlement Date","settlement","2011-01-01"]
[null,"Maturity Date","maturity","2021-12-31"]
[null,"Annual Coupon Rate","rate",8.5000000000000006E-2]
[null,"Yield","yld",7.0000000000000007E-2]
[null,"Redemption Amount (Per $100 Face Value)","redemption",100]
[null,"Number of Coupon Payments (Per Annum)","frequency (semi-annual)",2]
[null,"Day Count Basis (US (NASD) 30/360)","[basis]",0]

{"sheet":"Fixed Income Security Price","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3]]}
[]
[null,"Excel PRICE Function"]
[null,"Fixed Income Security Price Calculation"]
[]
[null,"PRICE Evaluation"]
[null,{"$f":"PRICE(D10,D11,D12,D13,D14,D15,D16)","v":88.783746310160112}]
[]
[]
[null,"Description","Referring Argument","Values"]
[null,"Settlement Date","settlement","2011-01-01"]
[null,"Maturity Date","maturity","2020-12-31"]
[null,"Annual Coupon Rate","rate",4.4999999999999998E-2]
[null,"Yield","yld",0.06]
[null,"Redemption Amount (Per $100 Face Value)","redemption",100]
[null,"Number of Coupon Payments (Per Annum)","frequency (quater-annual)",4]
[null,"Day Count Basis (US (NASD) 30/360)","[basis]",0]

{"sheet":"Used in VBA Macro","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3]]}
[]
[null,"Excel PRICE Function"]
[null,"PRICE Function Used in VBA Macro Code"]
[]
[null,"PRICE Evaluation"]
[null,111.3730204982042]
[]
[]
[null,"Description","Referring Argument","Values"]
[null,"Settlement Date","settlement","2011-01-01"]
[null,"Maturity Date","maturity","2021-12-31"]
[null,"Annual Coupon Rate","rate",8.5000000000000006E-2]
[null,"Yield","yld",7.0000000000000007E-2]
[null,"Redemption Amount (Per $100 Face Value)","redemption",100]
[null,"Number of Coupon Payments (Per Annum)","frequency (semi-annual)",2]
[null,"Day Count Basis (US (NASD) 30/360)","[basis]",0]