{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"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"}

{"sheet":"Sheet1","index":0,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Name","DaysToMaturity","ZCYield","Par rate",null,"Start date","Maturity","Time ","Time (360)","Time (365)","Days/days per year","t cpn ","Discount factor","Zero rate","Forward rate",null,"Year","Start date","Maturity","Days","Discount factor","Zero rate","Forward rate"]
["SEKOND",3,2.100041644572781,2.0499999999999998,null,"2011-11-21","2011-11-22",{"$f":"+B7","v":3},{"$f":"+H7/360","v":8.3333333333333332E-3},{"$f":"H7/365","v":8.21917808219178E-3},{"$f":"B7/365","v":8.21917808219178E-3},null,{"$f":"(1/(1+(D7/100)*I7))","v":0.99982919584570984},{"$f":"-100*LN(M7)/((G7-$F$7)/365)","v":6.234884118804735},null,null,"1Y","2011-11-23","2012-11-23",360,{"$f":"EXP(-(V7/100)*((S7-$F$7)/365))","v":0.9779021981625452},{"$f":"ipol(S7,G7:G25,N7:N25,0)","v":2.216345048021632}]
["STIBORTN",4,2.1479573617216863,2.2349999999999999,null,"2011-11-22","2011-11-23",4,{"$f":"+H8/360","v":1.1111111111111112E-2},{"$f":"H8/365","v":1.0958904109589041E-2},{"$f":"B8/365","v":1.0958904109589041E-2},{"$f":"DAYS360(G7,G8,0)/360","v":2.7777777777777779E-3},{"$f":"(1/(1+(D8/100)*I8))","v":0.99975172832080028},{"$f":"-100*LN(M8)/((G8-$F$7)/365)","v":4.531520692800088},{"$f":"((((1+N8)^K8)/(1+N7)^K7)^(1/(K8-K7))-1)","v":1.4721990048617322},null,"2Y","2011-11-23","2013-11-23",360,{"$f":"EXP(-(V8/100)*((S8-$F$7)/365))","v":0.9630461684019439},{"$f":"ipol(S8,G8:G25,N8:N25,0)","v":1.8749908614749047}]
["STIBOR1W",11,2.2873652600807759,2.3079999999999998,null,"2011-11-23","2011-11-30",11,{"$f":"+H9/360","v":3.0555555555555555E-2},3.0136986301369864E-2,{"$f":"B9/365","v":3.0136986301369864E-2},{"$f":"DAYS360(G8,G9,0)/360","v":1.9444444444444445E-2},{"$f":"(1/(1+(D9/100)*I9))","v":0.9992952747656737},{"$f":"-100*LN(M9)/((G9-$F$7)/365)","v":2.8590598834034626},{"$f":"((((1+N9)^K9)/(1+N8)^K8)^(1/(K9-K8))-1)","v":2.1414577173173237},null,"3Y","2011-11-23","2014-11-23",360,{"$f":"EXP(-(V9/100)*((S9-$F$7)/365))","v":0.94662641808228676},{"$f":"ipol(S9,G9:G25,N9:N25,0)","v":1.8233629354114911}]
["STIBOR1M",35,2.4413511444434377,2.4180000000000001,null,"2011-11-23","2011-12-23",35,{"$f":"+H10/360","v":9.7222222222222224E-2},9.5890410958904104E-2,{"$f":"B10/365","v":9.5890410958904104E-2},{"$f":"DAYS360(G9,G10,0)/360","v":6.3888888888888884E-2},{"$f":"(1/(1+(D10/100)*I10))","v":0.99765468012281133},{"$f":"-100*LN(M10)/((G10-$F$7)/365)","v":2.678272416786672},2.5982663808796667]
["STIBOR2M",66,2.5753282350696072,2.54,null,"2011-11-23","2012-01-23",66,0.18333333333333332,0.18082191780821918,{"$f":"B11/365","v":0.18082191780821918},{"$f":"DAYS360(G10,G11,0)/360","v":8.3333333333333329E-2},{"$f":"(1/(1+(D11/100)*I11))","v":0.99536491736812238},2.6916478521326024,2.7068076154363609,null,"11Y","2011-11-23","2022-11-23",360,{"$f":"EXP(-(V11/100)*((S11-$F$7)/365))","v":0.77849265393334477},{"$f":"ipol(S11,G15:G32,N15:N32,1)","v":2.2734935133245555}]
["STIBOR3M",95,2.7525530727795289,2.7130000000000001,null,"2011-11-23","2012-02-23",95,0.2638888888888889,0.26027397260273971,0.26027397260273971,{"$f":"DAYS360(G11,G12,0)/360","v":8.3333333333333329E-2},{"$f":"(1/(1+(D12/100)*I12))","v":0.99289158575404657},2.7700391259244013,2.9547081862736202]
["Stub",{"$f":"G13-F13","v":28},null,null,null,"2011-11-23","2011-12-21",{"$f":"G13-F13","v":28},7.7777777777777779E-2,7.6712328767123292E-2,7.6712328767123292E-2,null,{"$f":"EXP(-(N13/100)*(G13-$F$7)/365)","v":0.9977882087467651},{"$f":"(N10-N9)*(G13-G10)/(G10-G9)+N10","v":2.6939930660576974},2.8022815616630115,null,"13Y","2011-11-23","2024-11-23",360,{"$f":"EXP(-(V13/100)*((S13-$F$7)/365))","v":0.74015304760550127},{"$f":"ipol(S13,G16:G32,N16:N32,1)","v":2.3116791617381147}]
["SEKFRADEC11",103,2.7380743487841253,2.7300000000000004,null,"2011-12-21","2012-03-21",91,0.25277777777777777,0.24931506849315069,0.28219178082191781,{"$f":"DAYS360(G13,G14,0)/360","v":0.25},{"$f":"(1/(1+(D14/100)*I14)*M13)","v":0.9909498291342147},{"$f":"-100*LN(M14)/((G14-$F$7)/365)","v":2.7424387932924561},2.7606876304830763,null,"14Y","2011-11-23","2025-11-23",360,{"$f":"EXP(-(V14/100)*((S14-$F$7)/365))","v":0.72130907528182853},{"$f":"ipol(S14,G16:G32,N16:N32,1)","v":2.3307458671703296}]
["SEKFRAMAR12",194,2.547302759333836,2.2800000000000002,null,"2012-03-21","2012-06-20",91,0.25277777777777777,{"$f":"H15/365","v":0.24931506849315069},0.53150684931506853,{"$f":"DAYS360(G14,G15,0)/360","v":0.24722222222222223},{"$f":"(1/(1+(D15/100)*I15)*M14)","v":0.98527138173746776},{"$f":"-100*LN(M15)/((G15-$F$7)/365)","v":2.5546834318678395},2.353508434301725]
["SEKFRAJUN12",285,2.3267355527248013,1.82,null,"2012-06-20","2012-09-19",91,0.25277777777777777,0.24931506849315069,0.78082191780821919,0.24722222222222223,{"$f":"(1/(1+(D16/100)*I16)*M15)","v":0.98075934388927499},{"$f":"-100*LN(M16)/((G16-$F$7)/365)","v":2.3403567084537209},1.9256015275814944,null,"16Y","2011-11-23","2027-11-23",360,{"$f":"EXP(-(V16/100)*((S16-$F$7)/365))","v":0.69454877417704264},{"$f":"ipol(S16,G17:G34,N17:N34,1)","v":2.2757424712767182}]
["SEKFRASEP12",376,2.1507011123697461,1.57,null,"2012-09-19","2012-12-19",91,0.25277777777777777,0.24931506849315069,1.0301369863013699,0.25,{"$f":"(1/(1+(D17/100)*I17)*M16)","v":0.97688247723586707},{"$f":"-100*LN(M17)/((G17-$F$7)/365)","v":2.1667403838487962},1.6792580730004874,null,"17Y","2011-11-23","2028-11-23",360,{"$f":"EXP(-(V17/100)*((S17-$F$7)/365))","v":0.67911618708506138},{"$f":"ipol(S17,G17:G34,N17:N34,1)","v":2.2736882427169354}]
["SEKFRADEC12",467,2.0303672193279665,1.5049999999999999,null,"2012-12-19","2013-03-20",91,0.25277777777777777,0.24931506849315069,1.2794520547945205,0.25277777777777777,{"$f":"(1/(1+(D18/100)*I18)*M17)","v":0.97318020238537561},{"$f":"-100*LN(M18)/((G18-$F$7)/365)","v":2.0459575349917571},1.5938347828266721,null,"18Y","2011-11-23","2029-11-23",360,{"$f":"EXP(-(V18/100)*((S18-$F$7)/365))","v":0.66409452033169469},{"$f":"ipol(S18,G17:G34,N17:N34,1)","v":2.2716396268034909}]
["SEKFRAMAR13",558,1.947682641310422,1.4950000000000001,null,"2013-03-20","2013-06-19",91,0.25277777777777777,0.24931506849315069,1.5287671232876712,0.24722222222222223,0.96951637308049399,1.9617429582314754,1.5648340814821498,null,"19Y","2011-11-23","2030-11-23",360,{"$f":"EXP(-(V19/100)*((S19-$F$7)/365))","v":0.64943173254695985},{"$f":"ipol(S19,G17:G34,N17:N34,1)","v":2.2695910108900463}]
["SEKFRAJUN13",649,1.8911128887026063,1.5150000000000001,null,"2013-06-19","2013-09-18",91,0.25277777777777777,0.24931506849315069,1.7780821917808218,0.24722222222222223,0.96581769373751836,1.9032635199315326,1.5690876116192252]
["SEKFRASEP13",740,1.8541693871426901,1.56,null,"2013-09-18","2013-12-18",91,0.25277777777777777,0.24931506849315069,2.0273972602739727,0.25,{"$f":"(1/(1+(D21/100)*I21)*M20)","v":0.96202411198924076},1.8642815211504244,1.601035284528793,null,"21Y","2011-11-23","2032-11-23",360,{"$f":"EXP(-(V21/100)*((S21-$F$7)/365))","v":0.62110876944597659},{"$f":"ipol(S21,G17:G34,N17:N34,1)","v":2.2654881664168189}]
["SEKFRADEC13",831,1.8320826371684751,1.62,null,"2013-12-18","2014-03-19",91,0.25277777777777777,0.24931506849315069,2.2767123287671232,0.25277777777777777,{"$f":"(1/(1+(D22/100)*I22)*M21)","v":0.95810068966506234},1.8401504019351531,1.6513185498324319,null,"22Y","2011-11-23","2033-11-23",360,{"$f":"EXP(-(V22/100)*((S22-$F$7)/365))","v":0.62121870558691272},{"$f":"ipol(S22,G18:G35,N18:N35,1)","v":2.161810248711113}]
["SEKFRAMAR14",922,1.8204470950657692,1.68,null,"2014-03-19","2014-06-18",91,0.25277777777777777,0.24931506849315069,2.526027397260274,0.24722222222222223,{"$f":"(1/(1+(D23/100)*I23)*M22)","v":0.95404916089512759},1.8265562017659966,1.7053871649805994,null,"23Y","2011-11-23","2034-11-23",360,{"$f":"EXP(-(V23/100)*((S23-$F$7)/365))","v":0.61025478317873683},{"$f":"ipol(S23,G18:G35,N18:N35,1)","v":2.1452545169767157}]
["SEKFRAJUN14",1013,1.81736627023803,1.75,null,"2014-06-18","2014-09-17",91,0.25277777777777777,0.24931506849315069,2.7753424657534245,0.24722222222222223,0.94984740535892176,1.8215989939813917,1.7718608903958244,null,"24Y","2011-11-23","2035-11-23",360,{"$f":"EXP(-(V24/100)*((S24-$F$7)/365))","v":0.59968289454040935},{"$f":"ipol(S24,G18:G35,N18:N35,1)","v":2.1286987852423187}]
["SEKFRASEP14",1104,1.8215700926878853,1.83,null,"2014-09-17","2014-12-17",91,0.25277777777777777,0.24931506849315069,3.0246575342465754,0.25,{"$f":"(1/(1+(D25/100)*I25)*M24)","v":0.94547380113384338},{"$f":"-100*LN(M25)/((G25-$F$7)/365)","v":1.8239947950282431},1.8508022947149638]
["SEK4YSW",1466,1.8611525865590783,1.8624999999999998,null,"2011-11-23","2015-11-23",{"$f":"+B26","v":1466},4.072222222222222,4.0164383561643833,4.0164383561643833,0.93333333333333335,{"$f":"(100*$M$8-D26*(U7+U8+U9))/(100+D26)","v":0.92867409297509296},1.8461419725837722,1.9147630829323559,null,"26Y","2011-11-23","2037-11-23",360,{"$f":"EXP(-(V26/100)*((S26-$F$7)/365))","v":0.57086711096507003},{"$f":"ipol(S26,G19:G36,N19:N36,1)","v":2.1541064509042176}]
["SEK5YSW",1831,1.9666202275196998,1.9649999999999999,null,"2011-11-23","2016-11-23",{"$f":"+B27","v":1831},5.0861111111111112,5.0164383561643833,5.0164383561643833,1,{"$f":"(100*$M$8-D27*(U7+U8+U9)-D27*M26)/(100+D27*L27)","v":0.90694104631543249},{"$f":"-100*LN(M27)/((G27-$F$7)/365)","v":1.9492841868864401},2.4026008764629747,null,"27Y","2011-11-23","2038-11-23",360,{"$f":"EXP(-(V27/100)*((S27-$F$7)/365))","v":0.5597297710555682},{"$f":"ipol(S27,G19:G36,N19:N36,1)","v":2.1473025612612608}]
["SEK6YSW",2196,2.0847319918117835,2.0775000000000001,null,"2011-11-23","2017-11-23",2196,{"$f":"+H28/360","v":6.1},6.0164383561643833,6.0164383561643833,1,{"$f":"(100*$M$8-D28*(U7+U8+U9)-M26*D28-M27*L27*L28)/(100+D28*L28)","v":0.89285077262379231},{"$f":"-100*LN(M28)/((G28-$F$7)/365)","v":1.885486522230619},1.5856817180856924,null,"28Y","2011-11-23","2039-11-23",360,{"$f":"EXP(-(V28/100)*((S28-$F$7)/365))","v":0.5436723173408492},{"$f":"ipol(S28,G20:G37,N19:N36,1)","v":2.1745442230691707}]
["SEK7YSW",2561,2.1745856133064567,2.1625000000000001,null,"2011-11-23","2018-11-23",2561,7.1138888888888889,7.0164383561643833,7.0164383561643833,1,{"$f":"(100*M8-$D$29*(U7+U8+U9)-$D$29*(M26+M27*L27+M28*L28))/(100+$D$29*L29)","v":0.85971354289261404},{"$f":"-100*LN(M29)/((G29-$F$7)/365)","v":2.1559965897448716},{"$f":"((((1+N29)^K29)/(1+N28)^K28)^(1/(K29-K28))-1)","v":4.4110446231712261},null,"29Y","2011-11-23","2040-11-23",360,{"$f":"EXP(-(V29/100)*((S29-$F$7)/365))","v":0.53300093390035486},{"$f":"ipol(S29,G20:G37,N19:N36,1)","v":2.1677179563071314}]
["SEK8YSW",2926,2.2327925515576164,2.2175000000000002,null,"2011-11-23","2019-11-23",2926,8.1277777777777782,8.0164383561643842,8.0164383561643842,1,{"$f":"(100*$M$8-D30*(U7+U8+U9)-D30*(M26+L27*M27+M28*L28+M29*L29))/(100+$D$29*L30)","v":0.83802949033247454},{"$f":"-100*LN(M30)/((G30-$F$7)/365)","v":2.2057532675778879},2.5776409032002112]
["SEK9YSW",3293,2.2661881204323997,2.25,null,"2011-11-23","2020-11-23",3293,9.1472222222222221,9.0219178082191789,9.0219178082191789,1,{"$f":"(100*$M$8-D31*(U7+U8+U9)-D31*(M26+L27*M27+L28*M28+M29*L29+M30*L30))/(100+$D$29*L31)","v":0.8175128784051009},{"$f":"-100*LN(M31)/((G31-$F$7)/365)","v":2.2353601024601257},2.4814013479341535]
["SEK10YSW",3657,2.2868909338588317,2.27,null,"2011-11-23","2021-11-23",3657,10.158333333333333,10.019178082191781,10.019178082191781,1,{"$f":"(100*$M$8-D32*(U7+U8+U9)-D32*(M26+L27*M27+L28*M28+L29*M29+M30*L30+M31*L31))/(100+$D$29*L32)","v":0.79791635415622963},2.2544268078923406,2.4321055692498459]
["SEK12YSW",4387,2.3180442079641423,2.2999999999999998,null,"2011-11-23","2023-11-23",4387,12.186111111111112,12.019178082191781,12.019178082191781,{"$f":"DAYS360(G32,G33,0)/360/2","v":1},{"$f":"(100*$M$8-D33*(U7+U8+U9+U11)-D33*(M26+L27*M27+L28*M28+L29*M29+L30*M30+M31*L31+M32*L32))/(100+$D$29*L33)","v":0.76003866305771761},{"$f":"-100*LN(M33)/((G33-$F$7)/365)","v":2.2839425475768347},2.4358829383081892]
["SEK15YSW",5484,2.31108992674192,2.2975000000000003,null,"2011-11-23","2026-11-23",5484,15.233333333333333,15.024657534246575,15.024657534246575,{"$f":"DAYS360(G33,G34,0)/360/3","v":1},{"$f":"(100*$M$8-D34*($U$7+$U$8+$U$9+$U$11+$U$13+$U$14)-D34*(M26+L27*M27+L28*M28+L29*M29+L30*M30+L31*M31+M32*L32+M33*L33))/(100+$D$29*L34)","v":0.71031759327508637},{"$f":"-100*LN(M34)/((G34-$F$7)/365)","v":2.2777910871901628},2.2533058191868944]
["SEK20YSW",7311,2.2234284942959222,2.2275,null,"2011-11-23","2031-11-23",7311,20.308333333333334,20.030136986301368,20.030136986301368,{"$f":"DAYS360(G34,G35,0)/360/5","v":1},{"$f":"(100*$M$8-D35*($U$7+$U$8+$U$9+$U$11+$U$13+$U$14+$U$16+$U$17+$U$18+$U$19)-D35*(M26+L27*M27+L28*M28+L29*M29+L30*M30+L31*M31+L32*M32+M33*L33+M34*L34))/(100+$D$29*L35)","v":0.64441370074736848},{"$f":"-100*LN(M35)/((G35-$F$7)/365)","v":2.1949670703490423},1.9587173909253641]
["SEK25YSW",9138,2.1860035344629436,2.1974999999999998,null,"2011-11-23","2036-11-23",9138,25.383333333333333,25.035616438356165,25.035616438356165,{"$f":"DAYS360(G35,G36,0)/360/5","v":1},{"$f":"(100*$M$8-D36*($U$7+$U$8+$U$9+$U$11+$U$13+$U$14+$U$16+$U$17+$U$18+$U$19+$U$21+$U$22+$U$23+$U$24)-D36*(M26+L27*M27+L28*M28+L29*M29+L30*M30+L31*M31+L32*M32+L33*M33+M34*L34+M35*L35))/(100+$D$29*L36)","v":0.58230529184708046},{"$f":"-100*LN(M36)/((G36-$F$7)/365)","v":2.1609103405471743},2.0282219162727388]
["SEK30YSW",10962,2.1414257119594287,2.1624999999999996,null,"2011-11-23","2041-11-23",{"$f":"+B37","v":10962},30.45,30.032876712328768,30.032876712328768,{"$f":"DAYS360(G36,G37,0)/360/5","v":1},{"$f":"(100*$M$8-D37*($U$7+$U$8+$U$9+$U$11+$U$13+$U$14+$U$16+$U$17+$U$18+$U$19+$U$21+$U$22+$U$23+$U$24+$U$26+$U$27+$U$28+$U$29)-D37*(M26+L27*M27+L28*M28+L29*M29+L30*M30+L31*M31+L32*M32+L33*M33+L34*M34+M35*L35+M36*L36))/(100+$D$29*L37)","v":0.5295693264528496},{"$f":"-100*LN(M37)/((G37-$F$7)/365)","v":2.1170372805068127},1.9062380885206864]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}