{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Introduction","Bonds","Odd Coupon","Par Value","Definitions","CCode","Subscription"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Title","index":0,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["FinTools® Azure"]
[]
["BONDS XL"]
["Bond Functions"]
[]
["for"]
["Fixed Income Pricing,"]
["Risk Management"]
["and"]
["Financial Reporting"]
[]
["Release"]
["2021-06-16"]
[]
["Montgomery Investment Technology, Inc."]
["© 1989-2021"]

{"sheet":"Introduction","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Introduction"]
[]
["Bond Valuation using FinTools Azure"]
[]
["This template allows the user to calculate the price, yield, duration, and other statistics for various types of bonds, including "]
["US Treasuries, Munis, Corporates, and Japanese Governments using the Bonds_Azure function."]
[]
["Please see the Bonds, Odd Coupon, and Par Value tabs for function use examples."]
[]
["The Definitions tab has detailed descriptions of all the inputs."]

{"sheet":"Bonds","index":2,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["BONDS XL Bonds",null,null,null,null,null,"Key to Bonds_Azure() function"]
[]
["Valuation of Derivatives using FinTools Azure",null,"Price","Yield",null,"Argument Description (column C)"]
["Type of Bond",null,1,1,null,"TypeBond: 1=US Treasury"]
["Function (below)"]
["Input Basis",null,1,2,null,"InputBasis: 1=The bond Price"]
["Clean Price or Yield",null,102,5.4678410000000004E-2]
["Redemption Value",null,100,100]
["Coupon Rate",null,0.06,0.06]
["Coupon Frequency",null,2,2]
["Settlement Date",null,"2018-08-01","2018-08-01"]
["Maturity Date",null,"2022-11-15","2022-11-15"]
["Issue Dated Date"]
["First Coupon Date"]
["Last Coupon Date"]
["End Of Month Rule"]
["Par Value"]
[]
["  Output:","Func"]
["Yield To Maturity",1,{"$f":"Bonds_Azure(C$4,$B20,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":5.4678369999999997E-2},{"$f":"Bonds_Azure(D$4,$B20,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":5.4678409999999997E-2}]
["Price To Maturity",2,{"$f":"Bonds_Azure(C$4,$B21,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":102},{"$f":"Bonds_Azure(D$4,$B21,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":102}]
["Accrued Interest",3,{"$f":"Bonds_Azure(C$4,$B22,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":1.27},{"$f":"Bonds_Azure(D$4,$B22,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":1.27}]
["Total Price",4,{"$f":"Bonds_Azure(C$4,$B23,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":103.27},{"$f":"Bonds_Azure(D$4,$B23,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":103.27}]
["Macaulay Duration (years)",5,{"$f":"Bonds_Azure(C$4,$B24,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.8039383559082713},{"$f":"Bonds_Azure(D$4,$B24,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.8039383559082713}]
["Macaulay Duration (modified)",6,{"$f":"Bonds_Azure(C$4,$B25,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.7027092938168642},{"$f":"Bonds_Azure(D$4,$B25,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.7027092938168642}]
["Convexity (years)",7,{"$f":"Bonds_Azure(C$4,$B26,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":16.613373834032213},{"$f":"Bonds_Azure(D$4,$B26,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":16.613373834032213}]
["Value of an 0.01",8,{"$f":"Bonds_Azure(C$4,$B27,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.8238529423793466E-2},{"$f":"Bonds_Azure(D$4,$B27,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.8238529423793466E-2}]
["Value of a 32nd",9,{"$f":"Bonds_Azure(C$4,$B28,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":8.1709999999991789E-5},{"$f":"Bonds_Azure(D$4,$B28,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":8.1749999999991552E-5}]
[]
["Previous Coupon Date",20,{"$f":"Bonds_Azure(C$4,$B30,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":"2018-05-15"},{"$f":"Bonds_Azure(D$4,$B30,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":"2018-05-15"}]
["Days From Previous Coupon Date",21,{"$f":"Bonds_Azure(C$4,$B31,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":78},{"$f":"Bonds_Azure(D$4,$B31,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":78}]
["Next Coupon Date",22,{"$f":"Bonds_Azure(C$4,$B32,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":"2018-11-15"},{"$f":"Bonds_Azure(D$4,$B32,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":"2018-11-15"}]
["Days To Next Coupon Date",23,{"$f":"Bonds_Azure(C$4,$B33,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":106},{"$f":"Bonds_Azure(D$4,$B33,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":106}]
["Days In Coupon Period",24,{"$f":"Bonds_Azure(C$4,$B34,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":184},{"$f":"Bonds_Azure(D$4,$B34,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":184}]
["Coupons To Maturity",25,{"$f":"Bonds_Azure(C$4,$B35,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":9},{"$f":"Bonds_Azure(D$4,$B35,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":9}]
["Days To Maturity",26,{"$f":"Bonds_Azure(C$4,$B36,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":1567},{"$f":"Bonds_Azure(D$4,$B36,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":1567}]
[]
["  Function:"]
["Bonds_Azure(TypeBond,Func,InputBasis,Price_Yield,RedempVal,CoupRate,CoupFreq,SettleDate,MaturityDate,"]
["     IssueDate,FirstCoupDate,LastCoupDate,MonthEndRule,ParValue) "]

{"sheet":"Odd Coupon","index":3,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["BONDS XL Bonds",null,null,null,null,null,"Odd First and Last Coupon Examples"]
[]
["Bond",null,"Odd First","Odd Last"]
["Type of Bond",null,1,1]
["Function (below)"]
["Input Basis",null,1,1]
["Clean Price or Yield",null,102,102]
["Redemption Value",null,100,100]
["Coupon Rate",null,0.06,0.06]
["Coupon Frequency",null,2,2]
["Settlement Date",null,"2018-08-01","2018-08-01"]
["Maturity Date",null,"2022-11-15","2022-11-15"]
["Issue Dated Date",null,"2018-01-01"]
["First Coupon Date",null,"2018-11-15"]
["Last Coupon Date",null,null,"2022-09-15"]
["End Of Month Rule"]
["Par Value"]
[]
["  Output:","Func"]
["Yield To Maturity",1,{"$f":"Bonds_Azure(C$4,$B20,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":5.4588980000000009E-2},{"$f":"Bonds_Azure(D$4,$B20,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":5.4706320000000003E-2}]
["Price To Maturity",2,{"$f":"Bonds_Azure(C$4,$B21,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":102},{"$f":"Bonds_Azure(D$4,$B21,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":102}]
["Accrued Interest",3,{"$f":"Bonds_Azure(C$4,$B22,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.49},{"$f":"Bonds_Azure(D$4,$B22,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":2.27}]
["Total Price",4,{"$f":"Bonds_Azure(C$4,$B23,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":105.49},{"$f":"Bonds_Azure(D$4,$B23,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":104.27}]
["Macaulay Duration (years)",5,{"$f":"Bonds_Azure(C$4,$B24,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.7311548511260129},{"$f":"Bonds_Azure(D$4,$B24,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.7659144911855282}]
["Macaulay Duration (modified)",6,{"$f":"Bonds_Azure(C$4,$B25,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.6320206911440494},{"$f":"Bonds_Azure(D$4,$B25,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.6655919890051969}]
["Convexity (years)",7,{"$f":"Bonds_Azure(C$4,$B26,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":16.275406391372268},{"$f":"Bonds_Azure(D$4,$B26,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":16.442505914191578}]
["Value of an 0.01",8,{"$f":"Bonds_Azure(C$4,$B27,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":3.8315185381385675E-2},{"$f":"Bonds_Azure(D$4,$B27,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":3.8219779506377449E-2}]
["Value of a 32nd",9,{"$f":"Bonds_Azure(C$4,$B28,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":8.1540000000004942E-5},{"$f":"Bonds_Azure(D$4,$B28,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":8.1700000000003992E-5}]
[]
["Previous Coupon Date",20,{"$f":"Bonds_Azure(C$4,$B30,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":"2018-01-01"},{"$f":"Bonds_Azure(D$4,$B30,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":"2018-03-15"}]
["Days From Previous Coupon Date",21,{"$f":"Bonds_Azure(C$4,$B31,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":212},{"$f":"Bonds_Azure(D$4,$B31,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":139}]
["Next Coupon Date",22,{"$f":"Bonds_Azure(C$4,$B32,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":"2018-11-15"},{"$f":"Bonds_Azure(D$4,$B32,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":"2018-09-15"}]
["Days To Next Coupon Date",23,{"$f":"Bonds_Azure(C$4,$B33,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":106},{"$f":"Bonds_Azure(D$4,$B33,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":45}]
["Days In Coupon Period",24,{"$f":"Bonds_Azure(C$4,$B34,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":318},{"$f":"Bonds_Azure(D$4,$B34,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":184}]
["Coupons To Maturity",25,{"$f":"Bonds_Azure(C$4,$B35,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":9},{"$f":"Bonds_Azure(D$4,$B35,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":10}]
["Days To Maturity",26,{"$f":"Bonds_Azure(C$4,$B36,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":1567},{"$f":"Bonds_Azure(D$4,$B36,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":1567}]
[]
["  Function:"]
["Bonds_Azure(TypeBond,Func,InputBasis,Price_Yield,RedempVal,CoupRate,CoupFreq,SettleDate,MaturityDate,"]
["     IssueDate,FirstCoupDate,LastCoupDate,MonthEndRule,ParValue) "]

{"sheet":"Par Value","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["BONDS XL Bonds",null,null,null,null,null,"Par Value Argument example"]
[]
["  Input:",null,"Example 1","Example 2","Example 3"]
["Type of Bond",null,1,1,1]
["Function (below)"]
["Input Basis",null,1,1,1]
["Clean Price or Yield",null,102,102,102]
["Redemption Value",null,100,100,100]
["Coupon Rate",null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
["Coupon Frequency",null,2,2,2]
["Settlement Date",null,"2018-08-01","2018-08-01","2018-08-01"]
["Maturity Date",null,"2022-11-15","2022-11-15","2022-11-15"]
["Issue Dated Date"]
["First Coupon Date"]
["Last Coupon Date"]
["End Of Month Rule"]
["Par Value",null,null,100,1000000]
[]
["  Output:","Func"]
["Yield To Maturity",1,{"$f":"Bonds_Azure(C$4,$B20,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":6.4549490000000001E-2},{"$f":"Bonds_Azure(D$4,$B20,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":6.4549490000000001E-2},{"$f":"Bonds_Azure(E$4,$B20,E$6,E$7,E$8,E$9,E$10,E$11,E$12,E$13,E$14,E$15,E$16,E$17,Subscription!$C$4)","v":6.4549490000000001E-2}]
["Price To Maturity",2,{"$f":"Bonds_Azure(C$4,$B21,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":102},{"$f":"Bonds_Azure(D$4,$B21,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":102},{"$f":"Bonds_Azure(E$4,$B21,E$6,E$7,E$8,E$9,E$10,E$11,E$12,E$13,E$14,E$15,E$16,E$17,Subscription!$C$4)","v":1020000}]
["Accrued Interest",3,{"$f":"Bonds_Azure(C$4,$B22,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":1.48},{"$f":"Bonds_Azure(D$4,$B22,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":1.48},{"$f":"Bonds_Azure(E$4,$B22,E$6,E$7,E$8,E$9,E$10,E$11,E$12,E$13,E$14,E$15,E$16,E$17,Subscription!$C$4)","v":14836.96}]
["Total Price",4,{"$f":"Bonds_Azure(C$4,$B23,C$6,C$7,C$8,C$9,C$10,C$11,C$12,C$13,C$14,C$15,C$16,C$17,Subscription!$C$4)","v":103.48},{"$f":"Bonds_Azure(D$4,$B23,D$6,D$7,D$8,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17,Subscription!$C$4)","v":103.48},{"$f":"Bonds_Azure(E$4,$B23,E$6,E$7,E$8,E$9,E$10,E$11,E$12,E$13,E$14,E$15,E$16,E$17,Subscription!$C$4)","v":1034836.96}]
[]
["  Function:"]
["Bonds_Azure(TypeBond,Func,InputBasis,Price_Yield,RedempVal,CoupRate,CoupFreq,SettleDate,MaturityDate,"]
["     IssueDate,FirstCoupDate,LastCoupDate,MonthEndRule,ParValue) "]

{"sheet":"Definitions","index":5,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["BONDS XL Bonds function: Definitions",null,null,"FinTools Azure"]
[]
["Function:"]
["Bonds_Azure(TypeBond,Func,InputBasis,Price_Yield,RedempVal,CoupRate,CoupFreq,SettleDate,MaturityDate,"]
["                          IssueDate,FirstCoupDate,LastCoupDate,MonthEndRule,ParValue) "]
[]
["Input:","Example Args","Description"]
["TypeBond","1,2,3,4,5,6,7,8,9,10","1=US Treasury, 2=US Agency, 3=US Municipal, 4=US Corporate"]
[null,null,"5=Actual/Act, 6=30/360, 7=30e/360, 8=Act/365, 9=Act/360, 10=Japanese Govt Bond"]
["Func","1-9","See Output"]
[null,"20-26","See Output"]
["InputBasis","1,2","1=Price, 2=Yield"]
["Price_Yield",">=0","The price or yield of the security, depending on Input Basis"]
["RedempVal",">=0","The value of the bond at redemption (maturity or call)"]
["CoupRate",">=0","The bond's coupon rate in decimal form"]
["CoupFreq","1,2,3,4,6,12","The number of coupon payments per year"]
["SettleDate","> IssueDate,< MaturityDate","The date of settlement"]
["MaturityDate","> than all other dates","The maturity or call date"]
["  Optional Arguments:"]
["IssueDate","< than all other dates","The bond's date of issuance; leave blank for regular coupon flows"]
["FirstCoupDate","< LastCoupDate, <Maturity","The date of first coupon payment;  leave blank for regular coupon flows"]
["LastCoupDate","< MaturityDate","The date of last coupon payment;  leave blank for regular coupon flows"]
["MonthEndRule","0,1","0=Coupon payment always on last day of month; 1=Coupon payment on same date"]
["Par Value",1000000,"The bond par value, with 100 as the default value"]
[]
["Output:","Function"]
[null,1,"Yield To Maturity"]
[null,2,"Price To Maturity"]
[null,3,"Accrued Interest"]
[null,4,"Total Price"]
[null,5,"Macaulay Duration (years)"]
[null,6,"Macaulay Duration (modified)"]
[null,7,"Convexity (years)"]
[null,8,"Value of an 0.01"]
[null,9,"Value of a 32nd"]
[]
[null,20,"Previous Coupon Date"]
[null,21,"Days From Previous Coupon Date"]
[null,22,"Next Coupon Date"]
[null,23,"Days To Next Coupon Date"]
[null,24,"Days In Coupon Period"]
[null,25,"Coupons To Maturity"]
[null,26,"Days To Maturity"]

{"sheet":"CCode","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Color Code used in FinTools Templates"]
[]
["Red","Input Cell"]
["Green","Intermediate Calculation or  Description"]
["Blue","FinTools Function Output Cell"]
[]
["Dark Blue","Text Label"]
["Black","FinTools Function and Arguments"]
["Dark Teal","Total Calculation"]

{"sheet":"Subscription","index":7,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["FinTools Azure: Subscriptions"]
[]
["Module","Function","Subscription Key","Name"]
["ALL","All","5c1fecb42902487c9a5e1f6db0fa109d","All_Azure Key"]