{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Spreadsheet14.1","Spreadsheet14.2","Spreadsheet14.3"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":18,"defined_names":2373,"comments":2,"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":"Spreadsheet14.1","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Credit curve",null,null,null,"5Y","10Y"]
[null,1,200,null,"CVA",{"$f":"-SUMPRODUCT(D19:D38,E19:E38)*LGD","v":-5.592882240253472E-3},{"$f":"-SUMPRODUCT(D19:D58,E19:E58)*LGD","v":-1.4126234533417558E-2}]
[null,3,200,null,"Risky Duration",{"$f":"(1-EXP(-C12/10000/LGD*5))/(C12/10000/LGD)","v":4.6055482532815759},{"$f":"(1-EXP(-C12/10000/LGD*10))/(C12/10000/LGD)","v":8.5040606827863225}]
[null,5,200,null,"CVA (bps)",{"$f":"F10*10000/F11","v":-12.143792514318777},{"$f":"G10*10000/G11","v":-16.611163843187857}]
[null,7,200,null,"EPE",{"$f":"AVERAGE(E19:E38)","v":6.1665977811419817E-2},{"$f":"AVERAGE(E19:E58)","v":8.5807894002250334E-2}]
[null,10,200,null,"CVA (bps)",{"$f":"-F13*C12","v":-12.333195562283963},{"$f":"-G13*C14","v":-17.161578800450066}]
[null,"LGD",0.6]
[]
[null,null,"Spread","Def Prob","EE"]
[null,0,{"$f":"cubicspline($B$10:$B$14,$C$10:$C$14,B18)","v":200}]
[null,{"$f":"B18+0.25","v":0.25},200,{"$f":"EXP(-B18*C18/10000/LGD)-EXP(-B19*C19/10000/LGD)","v":8.2987073611240358E-3},{"$f":"SQRT(B19)*4%","v":0.02}]
[null,0.5,200,8.2298388172584724E-3,{"$f":"SQRT(B20)*4%","v":2.8284271247461905E-2}]
[null,0.75,200,8.1615417932848766E-3,3.4641016151377546E-2]
[null,1,200,8.0938115463267124E-3,0.04]
[null,1.25,200,8.0266433728677367E-3,4.4721359549995794E-2]
[null,1.5,200,7.9600326084241502E-3,4.8989794855663557E-2]
[null,1.75,200,7.8939746272218558E-3,5.2915026221291815E-2]
[null,2,200,7.828464841874383E-3,5.656854249492381E-2]
[null,2.25,200,7.7634987030649194E-3,0.06]
[null,2.5,200,7.6990716992295649E-3,6.3245553203367597E-2]
[null,2.75,200,7.6351793562454695E-3,6.6332495807107997E-2]
[null,3,200,7.5718172371183057E-3,6.9282032302755092E-2]
[null,3.25,200,7.5089809416754028E-3,7.211102550927978E-2]
[null,3.5,200,7.4466661062603245E-3,7.4833147735478833E-2]
[null,3.75,200,7.3848684034283352E-3,7.7459666924148338E-2]
[null,4,200,7.3235835416479711E-3,0.08]
[null,4.25,200,7.2628072650011699E-3,8.2462112512353219E-2]
[null,4.5,200,7.2025353528885061E-3,8.4852813742385694E-2]
[null,4.75,200,7.1427636197368694E-3,8.717797887081348E-2]
[null,5,200,7.0834879147069207E-3,8.9442719099991588E-2]
[null,5.25,200,7.0247041214066552E-3,9.1651513899116799E-2]
[null,5.5,200,6.9664081576047421E-3,9.3808315196468595E-2]
[null,5.75,200,6.9085959749465298E-3,9.5916630466254385E-2]
[null,6,200,6.8512635586742698E-3,9.7979589711327114E-2]
[null,6.25,200,6.7944069273468966E-3,0.1]
[null,6.5,200,6.7380221325643586E-3,0.10198039027185569]
[null,6.75,200,6.6821052586935048E-3,0.10392304845413264]
[null,7,200,6.6266524225954138E-3,0.10583005244258363]
[null,7.25,200.00001017252603,6.5716694263286968E-3,0.10770329614269007]
[null,7.5,199.99998982747394,6.5171039360839567E-3,0.10954451150103323]
[null,7.75,200,6.4630496942880145E-3,0.11135528725660043]
[null,8,200.00001017252603,6.4094153040001878E-3,0.11313708498984762]
[null,8.25,199.9999974568685,6.3562020950360676E-3,0.11489125293076058]
[null,8.5,200,6.303469426387931E-3,0.11661903789690602]
[null,8.75,199.999994913737,6.2511506032466579E-3,0.11832159566199232]
[null,9,200.000005086263,6.1992908216866871E-3,0.12]
[null,9.25,200,6.147827969231745E-3,0.1216552506059644]
[null,9.5,200.00000254313153,6.096817482791228E-3,0.12328828005937953]
[null,9.75,200.00000127156574,6.0462174285824677E-3,0.12489995996796797]
[null,10,200,5.9960415753287366E-3,0.12649110640673519]

{"sheet":"Spreadsheet14.2","index":1,"n_rows":208,"n_cols":8,"rows_kept":208,"cut":false,"hidden":false,"merged":[[15,3,15,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[15,1,15,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parameters"]
[null,"Counterparty Spread",null,200]
[null,"Own Spread",null,100]
[null,"Counterparty LGD",null,0.6]
[null,"Own LGD",null,0.6]
[]
[null,"Calculations"]
[null,"Unconditional",null,"Conditional"]
[null,"UCVA",{"$f":"-CntrptyLGD*SUMPRODUCT(D26:D208,G26:G208)","v":-0.13090533840007923},"CVA",{"$f":"-CntrptyLGD*SUMPRODUCT(D26:D208,E25:E207,G26:G208)","v":-0.12617355784385212}]
[null,"UDVA",{"$f":"-PartyLGD*SUMPRODUCT(F26:F208,H26:H208)","v":0.13567987695216394},"DVA",{"$f":"-PartyLGD*SUMPRODUCT(F26:F208,C25:C207,H26:H208)","v":0.12644188681040799}]
[null,"UBCVA",{"$f":"C17+C18","v":4.7745385520847061E-3},"BCVA",{"$f":"E17+E18","v":2.6832896655587524E-4}]
[]
[]
[]
[]
[null,null,"Survival (C)","Def Prob (C)","Survival (P)","Def Prob (P)","EE","NEE"]
[null,0,1,null,1,null,0,0]
[null,2.747252747252747E-3,{"$f":"C25*EXP(-(B26-B25)*SpreadCntrpty/10000/CntrptyLGD)","v":0.99990842910129563},{"$f":"C25-C26","v":9.157089870437396E-5},{"$f":"E25*EXP(-(B26-B25)*InstitutionSpread/10000/PartyLGD)","v":0.99995421350244618},{"$f":"-E25+E26","v":-4.578649755382358E-5},0.15687245510000011,-0.15392001619999995]
[null,2.7472527472527476E-2,0.99908466825615683,8.2376084513879899E-4,0.99954222935109505,{"$f":"E26-E27","v":4.119841513511302E-4},0.44700120329999976,-0.51131337980000025]
[null,5.4945054945054951E-2,0.99817017434451494,9.1449391164188931E-4,0.99908466825615694,{"$f":"E27-E28","v":4.5756109493810815E-4},0.63085596040000047,-0.76160846979999963]
[null,8.2417582417582416E-2,0.9972565174981799,9.1365684633504252E-4,0.99862731661925819,4.5735163689875069E-4,0.72730907610000084,-0.98652922189999992]
[null,0.1098901098901099,0.99634369695095937,9.1282054722052752E-4,0.99817017434451505,4.5714227474313862E-4,0.84131349050000115,-1.1490066693999994]
[null,0.13736263736263737,0.99543171193736213,9.1198501359723849E-4,0.99771324133608763,4.5693300842741813E-4,0.90475696690000018,-1.292567024899999]
[null,0.16483516483516483,0.99452056169259773,9.1115024476440265E-4,0.99725651749818001,4.5672383790762439E-4,0.94468717560000059,-1.4200988597000019]
[null,0.19230769230769232,0.9936102454525757,9.1031624002202438E-4,0.9968000027350401,4.5651476313990358E-4,0.97921413239999955,-1.570514868700001]
[null,0.2197802197802198,0.99270076245390515,9.0948299867055216E-4,0.99634369695095948,4.5630578408062394E-4,0.97824546270000012,-1.6821779667999999]
[null,0.24725274725274723,0.99179211193389372,9.0865052001143365E-4,0.99588760005027377,4.5609690068570963E-4,0.98050895879999966,-1.8163238456999986]
[null,0.27472527472527475,0.99088429313054738,9.0781880334633858E-4,0.99543171193736224,4.5588811291152886E-4,1.0844669090000005,-1.8915243559000003]
[null,0.30219780219780218,0.98997730528256933,9.0698784797804688E-4,0.99497603251664801,4.5567942071422785E-4,1.0918204464000005,-2.0240384636000006]
[null,0.32967032967032966,0.98907114762935988,9.0615765320944952E-4,0.99452056169259784,4.5547082405017481E-4,1.0909061773000002,-2.1364558940000018]
[null,0.3571428571428571,0.98816581941101533,9.0532821834454769E-4,0.99406529936972243,4.5526232287540491E-4,1.1078296848000002,-2.2737426573000006]
[null,0.38461538461538464,0.98726131986832766,9.0449954268767563E-4,0.99361024545257592,4.5505391714650845E-4,1.1342975538000002,-2.4178547871]
[null,0.41208791208791207,0.98635764824278371,9.0367162554394476E-4,0.9931553998457564,4.5484560681952058E-4,1.1961408745999993,-2.5466157081999956]
[null,0.43956043956043961,0.98545480377656458,9.0284446621913261E-4,0.99270076245390548,4.5463739185092056E-4,1.2207165986000001,-2.6505110045999976]
[null,0.46703296703296704,0.98455278571254512,9.0201806401946083E-4,0.99224633318170841,4.5442927219707663E-4,1.2033569070000001,-2.7517224930999951]
[null,0.49450549450549447,0.98365159329429319,9.011924182519282E-4,0.99179211193389416,4.54221247814246E-4,1.1887990904000001,-2.8383995620999976]
[null,0.52197802197802201,0.98275122576606899,9.0036752822419963E-4,0.99133809861523525,4.5401331865890793E-4,1.4658325974999986,-2.4599535659000025]
[null,0.5494505494505495,0.9818516823728245,8.9954339324449517E-4,0.99088429313054782,4.5380548468743065E-4,1.4970367115999992,-2.5280820708999987]
[null,0.57692307692307698,0.9809529623602028,8.9872001262170098E-4,0.99043069538469164,4.535977458561824E-4,1.5014805073999984,-2.6312951597000009]
[null,0.60439560439560436,0.98005506497453754,8.9789738566525834E-4,0.98997730528256989,4.5339010212175346E-4,1.5051986816999992,-2.6889146078999979]
[null,0.63186813186813184,0.97915798946285204,8.9707551168549671E-4,0.98952412272912937,4.5318255344051206E-4,1.5143409693999994,-2.8392617414000005]
[null,0.65934065934065933,0.97826173507285907,8.9625438999296758E-4,0.98907114762936044,4.5297509976893746E-4,1.4983935199000005,-2.913155736599998]
[null,0.68681318681318682,0.97736630105295974,8.9543401989933269E-4,0.98861837988829682,4.5276774106361994E-4,1.4828375195999994,-3.0166221387999985]
[null,0.71428571428571419,0.97647168665224338,8.9461440071636478E-4,0.98816581941101589,4.5256047728092774E-4,1.469846541500001,-3.1224069646000001]
[null,0.74175824175824179,0.97557789112048654,8.9379553175683579E-4,0.98771346610263833,4.5235330837756216E-4,1.4356855617999997,-3.2240093474999969]
[null,0.76923076923076927,0.97468491370815236,8.9297741233418382E-4,0.98726131986832821,4.5214623431011347E-4,1.5227880427999989,-3.2420047360000024]
[null,0.79670329670329665,0.97379275366639029,8.9216004176206898E-4,0.98680938061329326,4.5193925503494992E-4,1.520594315900001,-3.3188298318999996]
[null,0.82417582417582413,0.97290141024703503,8.9134341935526162E-4,0.98635764824278427,4.5173237050899484E-4,1.5169017673000003,-3.4516562492]
[null,0.85164835164835173,0.97201088270260616,8.9052754442886517E-4,0.98590612266209565,4.5152558068861648E-4,1.5324732697999994,-3.5350054278999985]
[null,0.87912087912087922,{"$f":"C57*EXP(-(B58-B57)*SpreadCntrpty/10000/CntrptyLGD)","v":0.9711211702863074},{"$f":"C57-C58","v":8.8971241629876019E-4},{"$f":"E57*EXP(-(B58-B57)*InstitutionSpread/10000/PartyLGD)","v":0.98545480377656514},4.5131888553051613E-4,1.5205195511999996,-3.632192509899999]
[null,0.90659340659340659,0.97023227225202624,8.8889803428116032E-4,0.98500369149157374,4.5111228499139511E-4,1.4634262144999999,-3.7115153663999978]
[null,0.93406593406593408,0.96934418785433285,8.8808439769338943E-4,0.98455278571254579,4.509057790279547E-4,1.4410538919,-3.7630909352999957]
[null,0.96153846153846156,0.96845691634847986,8.8727150585299341E-4,0.98410208634494889,4.5069936759689622E-4,1.4213473048000003,-3.820953034800004]
[null,0.98901098901098894,0.96757045699040167,8.8645935807818432E-4,0.98365159329429397,4.5049305065492096E-4,1.3977292369999996,-3.8968825964000025]
[null,1.0164835164835164,0.9666848090367135,8.8564795368817339E-4,0.98320130646613513,4.5028682815884125E-4,1.6143084569000008,-3.469767350399998]
[null,1.043956043956044,0.96579997174471122,8.8483729200228289E-4,0.98275122576606977,4.5008070006535839E-4,1.6006554837999996,-3.5000308522000005]
[null,1.0714285714285714,0.96491594437237049,8.8402737234072326E-4,0.9823013510997386,4.4987466633117368E-4,1.6201356608999993,-3.5341811347000029]
[null,1.098901098901099,0.96403272617834601,8.832181940244821E-4,0.98185168237282539,4.4966872691321047E-4,1.6388060903999992,-3.6012204455999979]
[null,1.1263736263736264,0.96315031642197124,8.8240975637476904E-4,0.98140221949105699,4.4946288176839211E-4,1.6369879047000002,-3.6675242419000016]
[null,1.153846153846154,0.96226871436325756,8.8160205871368191E-4,0.98095296236020368,4.4925713085330887E-4,1.5922439704000004,-3.709908149899996]
[null,1.1813186813186813,0.96138791926289369,8.8079510036387365E-4,0.98050391088607869,4.4905147412499513E-4,1.621290055899999,-3.7537310468999965]
[null,1.2087912087912087,0.96050793038224502,8.7998888064866332E-4,0.98005506497453843,4.4884591154026321E-4,1.6080319333000008,-3.8357800478000033]
[null,1.2362637362637363,0.9596287469833531,8.7918339889192509E-4,0.97960642453148239,4.4864044305603645E-4,1.6254360733000002,-3.9218492510999989]
[null,1.2637362637362637,0.95875036832893479,8.7837865441831031E-4,0.97915798946285304,4.4843506862934923E-4,1.6714450742999998,-3.9231995885999957]
[null,1.2912087912087913,0.95787279368238198,8.7757464655280337E-4,0.97870975967463603,4.4822978821701387E-4,1.6682020612999993,-3.9902803311999993]
[null,1.3186813186813187,0.95699602230776071,8.7677137462127686E-4,0.97826173507286007,4.4802460177595371E-4,1.6209206122000002,-4.041096356299998]
[null,1.346153846153846,0.95612005346981077,8.7596883794993641E-4,0.97781391556359676,4.4781950926331415E-4,1.6061513168000003,-4.0930152316000008]
[null,1.3736263736263736,0.95524488643394478,8.7516703586598688E-4,0.97736630105296085,4.4761451063590751E-4,1.6156816034000008,-4.1531968345000054]
[null,1.401098901098901,0.95437052046624793,8.7436596769685515E-4,0.97691889144710986,4.4740960585099021E-4,1.630026490400001,-4.2054699088999969]
[null,1.4285714285714284,0.95349695483347707,8.735656327708563E-4,0.97647168665224449,4.4720479486537457E-4,1.6364606885000004,-4.2462420624999977]
[null,1.4560439560439562,0.95262418880306021,8.7276603041686052E-4,0.97602468657460828,4.4700007763620597E-4,1.649052127399999,-4.2974662828000048]
[null,1.4835164835164836,0.95175222164309592,8.7196715996429308E-4,0.97557789112048765,4.4679545412062982E-4,1.6612232685000006,-4.3460336320999984]
[null,1.5109890109890109,0.95088105262235278,8.711690207431344E-4,0.97513130019621197,4.4659092427568048E-4,1.8360324210999999,-3.8911985730999983]
[null,1.5384615384615385,0.95001068101026853,8.7037161208425307E-4,0.97468491370815347,4.4638648805850334E-4,1.8815330112000006,-3.9633051958999972]
[null,1.5659340659340659,0.94914110607694979,8.695749333187397E-4,0.97423873156272733,4.4618214542613277E-4,1.8962676789999999,-4.0286413744999967]
[null,1.5934065934065933,0.94827232709317111,8.6877898377868412E-4,0.9737927536663914,4.4597789633593621E-4,1.8972449101999993,-4.1131263878000013]
[null,1.6208791208791209,0.94740434333037471,8.6798376279639822E-4,0.97334697992564645,4.4577374074494802E-4,1.8896248174999999,-4.1740665856999986]
[null,1.6483516483516483,0.94653715406066952,8.6718926970519306E-4,0.97290141024703614,4.455696786103136E-4,1.9386492323000004,-4.2318468302000003]
[null,1.6758241758241756,0.9456707585568308,8.6639550383871278E-4,0.97245604453714674,4.4536570988940039E-4,1.9081900907999996,-4.2528399935000021]
[null,1.7032967032967035,0.94480515609229954,8.6560246453126766E-4,0.97201088270260727,4.4516183453946478E-4,1.8901030322999997,-4.2771354215999953]
[null,1.7307692307692308,0.94394034594118159,8.6481015111794513E-4,0.97156592465008973,4.4495805251754117E-4,1.9143847339000002,-4.2747444782000006]
[null,1.7582417582417584,{"$f":"C89*EXP(-(B90-B89)*SpreadCntrpty/10000/CntrptyLGD)","v":0.94307632737824731},{"$f":"C89-C90","v":8.640185629342767E-4},{"$f":"E89*EXP(-(B90-B89)*InstitutionSpread/10000/PartyLGD)","v":0.97112117028630862},4.44754363781108E-4,1.9256632095999997,-4.2416270815000017]
[null,1.7857142857142858,0.94221309967893097,8.6322769931634902E-4,0.9706766195180212,4.4455076828742168E-4,1.9096013177999995,-4.2925714308000043]
[null,1.8131868131868132,0.94135066211932994,8.6243755960102586E-4,0.97023227225202746,{"$f":"E91-E92","v":4.4434726599373864E-4},1.8971753347999987,-4.3234362806000011]
[null,1.8406593406593408,0.94048901397620432,8.6164814312561511E-4,0.96978812839517003,4.441438568574263E-4,1.9208302577999987,-4.3674893538999973]
[null,1.8681318681318682,0.93962815452697612,8.6085944922820179E-4,0.96934418785433418,4.439405408358521E-4,1.8787926490999987,-4.4178957899999984]
[null,1.8956043956043955,0.93876808304972881,8.6007147724731503E-4,0.9689004505364478,4.4373731788638349E-4,1.8916046285999994,-4.4516651280999975]
[null,1.9230769230769231,0.93790879882320655,8.5928422652226111E-4,0.9684569163484813,4.4353418796649891E-4,1.8695571538999993,-4.4557413469000027]
[null,1.9505494505494505,0.93705030112681387,8.5849769639267937E-4,0.96801358519744785,4.4333115103345477E-4,1.8743583942999986,-4.507116520900003]
[null,1.9780219780219779,0.93619258924061466,8.5771188619920835E-4,0.96757045699040312,4.4312820704472955E-4,1.8624764527999986,-4.524649365200001]
[null,2.0054945054945055,0.93533566244533195,8.5692679528270865E-4,0.9671275316344452,4.4292535595791271E-4,1.903547585399999,-4.3589549856000005]
[null,2.0329670329670328,0.93447952002234713,8.5614242298481802E-4,0.96668480903671494,4.4272259773026068E-4,2.0047590381000004,-4.1033888518000046]
[null,2.0604395604395602,0.93362416125369929,8.5535876864784033E-4,0.96624228910439558,4.4251993231936293E-4,2.0058945236000003,-4.1529575355000024]
[null,2.087912087912088,0.93276958542208477,8.5457583161452355E-4,0.96579997174471277,4.4231735968280894E-4,2.0270063843999995,-4.1866385149999994]
[null,2.1153846153846154,0.93191579181085649,8.5379361122828179E-4,0.96535785686493469,4.4211487977807717E-4,2.0057837912999994,-4.2077775060999967]
[null,2.1428571428571428,0.93106277970402329,8.5301210683319528E-4,0.96491594437237205,4.4191249256264609E-4,2.0587177651000008,-4.1865394607000015]
[null,2.1703296703296706,0.93021054838624928,8.522313177740104E-4,0.96447423417437783,4.4171019799421618E-4,2.0548083590000008,-4.1776063297000006]
[null,2.197802197802198,0.92935909714285359,8.5145124339569556E-4,0.96403272617834757,4.4150799603026591E-4,2.0658057263000003,-4.1838751285999978]
[null,2.2252747252747254,0.92850842525980926,8.5067188304432939E-4,0.96359142029171918,4.4130588662838477E-4,2.0597181280000001,-4.1964229181999979]
[null,2.2527472527472527,0.92765853202374315,8.4989323606610157E-4,0.96315031642197291,4.4110386974627325E-4,2.0810834219000007,-4.2129530057000046]
[null,2.2802197802197801,0.92680941672193484,8.4911530180831196E-4,0.96270941447663128,4.4090194534163185E-4,2.0830870183999997,-4.1527147520000049]
[null,2.3076923076923079,0.92596107864231647,8.4833807961837149E-4,0.96226871436325934,4.4070011337193904E-4,2.0776300811000006,-4.1723016293999988]
[null,2.3351648351648353,0.92511351707347189,8.4756156884457923E-4,0.96182821598946422,4.4049837379511736E-4,2.0212066056000002,-4.1914352064999987]
[null,2.3626373626373627,0.9242667313046361,8.4678576883578938E-4,0.96138791926289557,4.4029672656864527E-4,2.0072577437999999,-4.2062738627999989]
[null,2.3901098901098901,0.9234207206256948,8.4601067894130022E-4,0.96094782409124513,4.4009517165044532E-4,1.9647558318,-4.2212167827999965]
[null,2.4175824175824174,0.92257548432718361,8.452362985111872E-4,0.96050793038224702,4.3989370899810698E-4,1.9363182926999998,-4.2454549224000022]
[null,2.4450549450549448,0.92173102170028742,8.4446262689619189E-4,0.96006823804367747,4.3969233856955281E-4,1.9159619513999997,-4.2691886177999949]
[null,2.4725274725274726,0.92088733203684014,8.4368966344727792E-4,0.9596287469833551,4.3949106032237228E-4,1.8634118066999998,-4.2750549973999989]
[null,2.5,0.92004441462932374,8.4291740751640809E-4,0.95918945710914061,4.3928987421448795E-4,1.8584127432000015,-4.310891503299997]
[null,2.5274725274725274,0.91920226877086786,8.421458584558783E-4,0.9587503683289369,4.3908878020371134E-4,2.0053984297000005,-3.8491530398000013]
[null,2.5549450549450547,0.91836089375524921,8.4137501561865058E-4,0.95831148055068904,4.3888777824785397E-4,2.0060023549000001,-3.9165402175999993]
[null,2.5824175824175826,0.91752028887689085,8.4060487835835307E-4,0.9578727936823842,4.3868686830483838E-4,2.0192074654000001,-3.9291450132000012]
[null,2.6098901098901099,0.91668045343086169,8.3983544602916904E-4,0.95743430763205173,4.3848605033247612E-4,1.9869871638999999,-3.9346270126000009]
[null,2.6373626373626373,{"$f":"C121*EXP(-(B122-B121)*SpreadCntrpty/10000/CntrptyLGD)","v":0.91584138671287585},8.3906671798583687E-4,{"$f":"E121*EXP(-(B122-B121)*InstitutionSpread/10000/PartyLGD)","v":0.95699602230776304},4.3828532428868971E-4,2.0073682815000007,-3.9359722177999981]
[null,2.6648351648351647,0.9150030880192922,8.3829869358365006E-4,0.95655793761763164,4.3808469013140172E-4,2.0116647018,-3.9387481027999991]
[null,2.6923076923076921,0.91416555664711363,8.3753137217856821E-4,0.9561200534698131,4.3788414781853469E-4,2.0215165250000005,-3.9298039872000023]
[null,2.7197802197802194,0.91332879189398641,8.367647531272171E-4,0.95568236977250509,4.3768369730801115E-4,1.9801819427999996,-3.924444372]
[null,2.7472527472527473,0.91249279305819986,8.3599883578655554E-4,0.95524488643394723,4.374833385578647E-4,1.9743453824000017,-3.9060996258000031]
[null,2.7747252747252746,0.91165755943868554,8.3523361951431951E-4,0.9548076033624211,4.3728307152612889E-4,1.9953854310999999,-3.844698429600002]
[null,2.802197802197802,0.91082309033501674,8.3446910366880012E-4,0.95437052046625037,4.3708289617072626E-4,1.9758399551000012,-3.8541044901000019]
[null,2.8296703296703294,0.90998938504740778,8.3370528760895457E-4,0.95393363765380068,4.3688281244969041E-4,1.9425734935999994,-3.8584470916000018]
[null,2.8571428571428568,0.9091564428767136,8.3294217069418419E-4,0.95349695483347952,4.366828203211659E-4,1.9117034869000007,-3.8536106380999948]
[null,2.8846153846153841,0.90832426312442904,8.3217975228455643E-4,0.95306047191373644,4.3648291974307529E-4,1.8765906466,-3.8613790811000026]
[null,2.9120879120879124,0.90749284509268835,8.3141803174069384E-4,0.95262418880306277,4.362831106736742E-4,1.8334081577000005,-3.8422542667000013]
[null,2.9395604395604398,0.90666218808426446,8.3065700842388512E-4,0.95218810540999177,4.3608339307099619E-4,1.8211813866999993,-3.8567093614000045]
[null,2.9670329670329672,0.9058322914025686,8.2989668169586306E-4,0.95175222164309858,4.3588376689318586E-4,1.7911087766999996,-3.8468001059999946]
[null,2.9945054945054945,0.90500315435164969,8.2913705091891554E-4,0.9513165374110002,4.356842320983878E-4,1.7718778684999998,-3.8544850591000026]
[null,3.0219780219780219,0.90417477623619347,8.2837811545621864E-4,0.95088105262235545,4.354847886447466E-4,1.9169793328999996,-3.3086673555999981]
[null,3.0494505494505497,0.90334715636152219,8.2761987467128151E-4,0.95044576718586493,4.3528543649051787E-4,1.9067960644000008,-3.2842307820999972]
[null,3.0769230769230771,0.90252029403359402,8.2686232792816838E-4,0.9500106810102712,4.3508617559373519E-4,1.8839707074000005,-3.2303946002000008]
[null,3.1043956043956045,0.90169418855900241,8.2610547459160966E-4,0.94957579400435843,4.3488700591276519E-4,1.8763561589999989,-3.1522487827000005]
[null,3.1318681318681318,0.90086883924497541,8.2534931402700185E-4,0.94914110607695257,4.3468792740586348E-4,1.8446808678999986,-3.1193166081000001]
[null,3.1593406593406592,0.90004424539937533,8.2459384560007454E-4,0.94870661713692128,4.3448894003128569E-4,1.7764807420000004,-3.0756148388999982]
[null,3.1868131868131866,0.89922040633069789,8.238390686774455E-4,0.94827232709317399,4.3429004374728741E-4,1.7433864474999994,-3.0452484168999958]
[null,3.2142857142857144,0.89839732134807182,8.2308498262606555E-4,0.94783823585466187,4.3409123851212428E-4,1.6995162805999995,-3.0211665166999988]
[null,3.2417582417582418,0.89757498976125827,8.2233158681355167E-4,0.9474043433303776,4.3389252428427394E-4,1.6834758469000004,-2.984692243900001]
[null,3.2692307692307692,0.89675341088065008,8.2157888060818696E-4,0.94697064942935583,4.3369390102176997E-4,1.6441944318999988,-2.889172671699999]
[null,3.2967032967032965,0.89593258401727138,8.2082686337869859E-4,0.94653715406067251,4.3349536868331207E-4,1.6043105291999984,-2.843713112100005]
[null,3.3241758241758239,0.8951125084827769,8.200755344944799E-4,0.94610385713344536,4.3329692722715585E-4,1.5795738704000002,-2.7826302863000012]
[null,3.3516483516483513,0.89429318358945153,8.1932489332536829E-4,0.9456707585568338,4.3309857661155693E-4,1.5528314217999994,-2.7378970691000006]
[null,3.3791208791208796,0.89347460865020956,8.1857493924197833E-4,0.9452378582400387,4.3290031679510399E-4,1.5215380326000003,-2.6866828497000022]
[null,3.4065934065934069,0.89265678297859419,8.1782567161536868E-4,0.94480515609230253,4.3270214773616367E-4,1.4804901401000015,-2.6621259933999992]
[null,3.4340659340659343,0.89183970588877692,8.1707708981726412E-4,0.94437265202290932,4.3250406939321362E-4,1.4250771810999989,-2.6212465418000002]
[null,3.4615384615384617,0.8910233766955572,8.1632919321972253E-4,0.94394034594118459,4.3230608172473151E-4,1.3792071863999997,-2.6116041747999992]
[null,3.4890109890109891,0.8902077947143614,8.1558198119580094E-4,0.94350823775649539,4.3210818468919499E-4,1.3466586459999996,-2.5884413000999991]
[null,3.5164835164835169,{"$f":"C153*EXP(-(B154-B153)*SpreadCntrpty/10000/CntrptyLGD)","v":0.88939295926124273},{"$f":"C153-C154","v":8.1483545311866745E-4},{"$f":"E153*EXP(-(B154-B153)*InstitutionSpread/10000/PartyLGD)","v":0.94307632737825031},4.3191037824508172E-4,1.4890125996999994,-2.0728763083999997]
[null,3.5439560439560442,0.88857886965288035,8.1408960836237831E-4,0.94264461471589933,4.3171266235098038E-4,1.4692713349999995,-2.0628014069000002]
[null,3.5714285714285716,0.88776552520657881,8.133444463015449E-4,0.94221309967893396,{"$f":"E155-E156","v":4.3151503696536864E-4},1.4080348786999992,-2.0487637810000003]
[null,3.598901098901099,0.88695292524026759,8.1259996631122267E-4,0.94178178217688713,4.3131750204683517E-4,1.3935327176000007,-2.0257575499000033]
[null,3.6263736263736264,0.88614106907250056,8.1185616776702219E-4,0.94135066211933305,4.3112005755407967E-4,1.3583327925999997,-1.9792773217999988]
[null,3.6538461538461537,0.88532995602245534,8.1111305004522016E-4,0.94091973941588747,4.3092270344557981E-4,1.3242324750999999,-1.9495130626000023]
[null,3.6813186813186816,0.8845195854099327,8.1037061252264841E-4,0.94048901397620743,4.3072543968003529E-4,1.2949231207999996,-1.9085816144999994]
[null,3.7087912087912089,0.883709956555356,8.0962885457669387E-4,0.94005848570999151,4.3052826621592377E-4,1.2694226198000009,-1.8569907621999993]
[null,3.7362637362637363,0.88290106877977059,8.0888777558540959E-4,0.93962815452697934,4.30331183012167E-4,1.2175772714000006,-1.830784419]
[null,3.7637362637362637,0.88209292140484341,8.0814737492718169E-4,0.9391980203369521,4.3013419002724262E-4,1.2125036749,-1.7376306279000007]
[null,3.7912087912087911,0.88128551375286224,8.0740765198117348E-4,0.93876808304973214,4.2993728721996138E-4,1.1539618217000005,-1.7034358826999978]
[null,3.8186813186813184,0.88047884514673513,8.0666860612710334E-4,0.93833834257518312,4.2974047454902298E-4,1.1068862867000004,-1.6585855132000009]
[null,3.8461538461538463,0.87967291490999,8.0593023674513375E-4,0.93790879882320999,4.2954375197312711E-4,1.0766944434000003,-1.6219988096]
[null,3.8736263736263736,0.8788677223667738,8.0519254321620437E-4,0.9374794517037589,4.293471194510845E-4,1.0532272353999999,-1.5836375860000014]
[null,3.901098901098901,0.87806326684185232,8.0445552492147687E-4,0.93705030112681731,4.2915057694159486E-4,1.0004268328999997,-1.5621651598000017]
[null,3.9285714285714284,0.87725954766060932,8.0371918124300112E-4,0.93662134700241384,4.2895412440346892E-4,0.98019205949999977,-1.5560312983000011]
[null,3.9560439560439558,0.87645656414904605,8.0298351156327108E-4,0.93619258924061821,4.2875776179562841E-4,0.93581986030000031,-1.5458544088999995]
[null,3.9835164835164831,0.87565431563378071,8.022485152653358E-4,0.93576402775154144,4.2856148907677305E-4,0.90454505990000045,-1.5441940796000018]
[null,4.0109890109890109,0.8748528014420478,8.015141917329105E-4,0.93533566244533561,4.2836530620582458E-4,0.94984450400000009,-1.3678369137999991]
[null,4.0384615384615383,0.87405202090169776,8.0078054035004342E-4,0.93490749323219391,4.2816921314170475E-4,1.0441272800999992,-1.1050194229999988]
[null,4.0659340659340657,0.8732519733411962,8.0004756050156001E-4,0.9344795200223508,4.2797320984311327E-4,0.98956747539999868,-1.1259104586000013]
[null,4.0934065934065931,0.87245265808962336,7.9931525157284078E-4,0.93405174272608171,4.277772962690829E-4,0.94856365149999944,-1.1441959154999997]
[null,4.1208791208791204,0.87165407447667353,7.9858361294982139E-4,0.93362416125370307,4.2758147237864641E-4,0.91891435349999917,-1.1499395877]
[null,4.1483516483516487,0.87085622183265476,7.9785264401877054E-4,0.93319677551557256,4.2738573813050351E-4,0.90535989509999959,-1.1608384111000005]
[null,4.1758241758241761,0.87005909948848803,7.9712234416673411E-4,0.93276958542208865,4.2719009348390902E-4,0.87010210919999986,-1.1671354982000004]
[null,4.2032967032967035,0.86926270677570661,7.9639271278142409E-4,0.93234259088369109,4.2699453839756263E-4,0.82836632869999971,-1.1826826347999997]
[null,4.2307692307692308,0.86846704302645572,7.9566374925088557E-4,0.93191579181086048,4.2679907283060814E-4,0.78590519179999985,-1.1996594648000014]
[null,4.2582417582417582,0.867672107573492,7.949354529637187E-4,0.93148918811411829,4.2660369674218934E-4,0.73150107799999942,-1.2320683555000003]
[null,4.2857142857142856,0.8668778997501827,7.9420782330930084E-4,0.93106277970402729,4.2640841009100594E-4,0.72185831779999976,-1.1853279629]
[null,4.3131868131868139,0.86608441889050525,7.9348085967745341E-4,0.93063656649119086,4.2621321283642377E-4,0.68381711579999938,-1.2032946193999987]
[null,4.3406593406593412,0.86529166432904681,7.9275456145844192E-4,0.93021054838625339,4.2601810493747561E-4,0.65062909839999983,-1.2220850033000012]
[null,4.3681318681318686,0.8644996354010035,7.9202892804330904E-4,0.92978472529990031,4.2582308635308319E-4,0.61160819290000001,-1.2433459674000009]
[null,4.395604395604396,{"$f":"C185*EXP(-(B186-B185)*SpreadCntrpty/10000/CntrptyLGD)","v":0.86370833144218007},7.9130395882343052E-4,{"$f":"E185*EXP(-(B186-B185)*InstitutionSpread/10000/PartyLGD)","v":0.9293590971428578},4.2562815704250134E-4,0.58083712460000003,-1.2704039706999999]
[null,4.4230769230769234,0.86291775178898922,7.9057965319084822E-4,0.92893366382589293,4.2543331696487385E-4,0.55412374460000013,-1.3004048002999999]
[null,4.4505494505494507,0.86212789577845095,7.8985601053827015E-4,0.92850842525981359,4.2523856607934452E-4,0.52620075589999959,-1.3328247432999991]
[null,4.4780219780219781,0.86133876274819221,7.8913303025873738E-4,0.92808338135546853,4.2504390434505712E-4,0.49566504390000032,-1.3742055412999994]
[null,4.5054945054945055,0.86055035203644614,7.8841071174606814E-4,0.92765853202374748,4.2484933172104444E-4,0.51864981140000033,-1.2211976061000005]
[null,4.5329670329670328,0.85976266298205173,7.8768905439441372E-4,0.9272338771755807,4.2465484816678334E-4,0.63177622509999964,-0.92689680480000025]
[null,4.5604395604395602,0.85897569492445314,7.8696805759859156E-4,0.92680941672193928,4.244604536414176E-4,0.62201942229999996,-0.92712171609999949]
[null,4.5879120879120876,0.85818944720369905,7.8624772075408522E-4,0.92638515057383519,4.2426614810409102E-4,0.60901503559999992,-0.93144037179999994]
[null,4.6153846153846159,0.85740391916044223,7.8552804325682235E-4,0.92596107864232102,4.2407193151416944E-4,0.58606048709999914,-0.92519800200000057]
[null,4.6428571428571432,0.85661911013593917,7.8480902450306367E-4,0.92553720083849012,4.2387780383090767E-4,0.57079836340000034,-0.92525078379999992]
[null,4.6703296703296706,0.8558350194720491,7.840906638900691E-4,0.92511351707347655,4.2368376501356053E-4,0.56035363300000007,-0.9214336332000006]
[null,4.697802197802198,0.85505164651123367,7.8337296081543162E-4,0.92469002725845495,4.2348981502160488E-4,0.54972417959999964,-0.92055922619999841]
[null,4.7252747252747254,0.85426899059655659,7.8265591467707729E-4,0.92426673130464077,4.232959538141845E-4,0.5437006477999996,-0.91747792120000105]
[null,4.7527472527472527,0.85348705107168266,7.8193952487393137E-4,0.9238436291232901,4.2310218135066524E-4,0.54479580309999986,-0.92947687589999994]
[null,4.7802197802197801,0.85270582728087763,7.8122379080503013E-4,0.92342072062569958,4.2290849759052396E-4,0.57478643249999928,-0.87835371700000042]
[null,4.8076923076923075,0.85192531856900744,7.80508711870187E-4,0.92299800572320634,4.2271490249323751E-4,0.57688840639999994,-0.87823491920000052]
[null,4.8351648351648349,0.85114552428153756,7.7979428746988155E-4,0.92257548432718839,4.2252139601794969E-4,0.57359981930000004,-0.87857047610000139]
[null,4.8626373626373622,0.85036644376453263,7.7908051700492642E-4,0.92215315634906403,4.223279781243594E-4,0.56627184680000053,-0.88204910110000012]
[null,4.8901098901098896,0.84958807636465594,7.7836739987668935E-4,0.92173102170029231,4.2213464877172147E-4,0.5640830202999999,-0.89157611299999973]
[null,4.917582417582417,0.84881042142916874,7.7765493548720421E-4,0.92130908029237268,4.2194140791962376E-4,0.56038117959999967,-0.89962674269999965]
[null,4.9450549450549453,0.84803347830592968,7.7694312323906001E-4,0.92088733203684514,4.2174825552754314E-4,0.55708858549999984,-0.9147935028999995]
[null,4.9725274725274726,0.8472572463433945,7.7623196253517879E-4,0.92046577684529018,4.2155519155495647E-4,0.55374304730000012,-0.93200614459999997]
[null,5,0.84648172489061524,7.7552145277925977E-4,0.92004441462932884,4.213622159613406E-4,0.54973271309999983,-0.95740683380000025]

{"sheet":"Spreadsheet14.3","index":2,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[8,4,8,5],[8,1,8,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Option details",null,null,"Credit / Funding",null,null,null,"Value"]
[null,"Spot",100,null,"Credit Spread",150,null,"CVA",{"$f":"-SUMPRODUCT(C19:C58,E19:E58)*LGD","v":-0.11418708392985344}]
[null,"Strike",100,null,"Funding Spread",75,null,"FVA (FCA)",{"$f":"-SUMPRODUCT(D19:D58,E19:E58)","v":-5.7478227679679118E-2}]
[null,"Volatility",0.25,null,"LGD",0.6,null,"Total",{"$f":"I11+I10","v":-0.17166531160953255}]
[null,"Maturity",1]
[null,"Interest rate",0.05]
[]
[]
[null,null,"Def Prob","Funding Prob","EE"]
[null,0,null,null,{"$f":"BSCall(Spot,Strike,Maturity-B18,IRate,Volatility)","v":12.335985885541788}]
[null,{"$f":"B18+Maturity/40","v":2.5000000000000001E-2},{"$f":"EXP(-B18*CreditSpread/10000/LGD)-EXP(-B19*CreditSpread/10000/LGD)","v":6.2480472818371435E-4},{"$f":"EXP(-FundingSpread*B18/10000)-EXP(-FundingSpread*B19/10000)","v":1.8748242297361717E-4},{"$f":"BSCall(Spot,Strike,Maturity-B19,IRate,Volatility)","v":12.153879264391172}]
[null,{"$f":"B19+Maturity/40","v":0.05},{"$f":"EXP(-B19*CreditSpread/10000/LGD)-EXP(-B20*CreditSpread/10000/LGD)","v":6.2441434723536915E-4},{"$f":"EXP(-FundingSpread*B19/10000)-EXP(-FundingSpread*B20/10000)","v":1.8744727331465594E-4},{"$f":"BSCall(Spot,Strike,Maturity-B20,IRate,Volatility)","v":11.97004254354939}]
[null,{"$f":"B20+Maturity/40","v":7.5000000000000011E-2},{"$f":"EXP(-B20*CreditSpread/10000/LGD)-EXP(-B21*CreditSpread/10000/LGD)","v":6.2402421019891463E-4},{"$f":"EXP(-FundingSpread*B20/10000)-EXP(-FundingSpread*B21/10000)","v":1.8741213024564551E-4},{"$f":"BSCall(Spot,Strike,Maturity-B21,IRate,Volatility)","v":11.784410812198125}]
[null,{"$f":"B21+Maturity/40","v":0.1},{"$f":"EXP(-B21*CreditSpread/10000/LGD)-EXP(-B22*CreditSpread/10000/LGD)","v":6.2363431692191718E-4},{"$f":"EXP(-FundingSpread*B21/10000)-EXP(-FundingSpread*B22/10000)","v":1.8737699376536465E-4},{"$f":"BSCall(Spot,Strike,Maturity-B22,IRate,Volatility)","v":11.596915061824618}]
[null,{"$f":"B22+Maturity/40","v":0.125},{"$f":"EXP(-B22*CreditSpread/10000/LGD)-EXP(-B23*CreditSpread/10000/LGD)","v":6.2324466725194316E-4},{"$f":"EXP(-FundingSpread*B22/10000)-EXP(-FundingSpread*B23/10000)","v":1.8734186387259211E-4},{"$f":"BSCall(Spot,Strike,Maturity-B23,IRate,Volatility)","v":11.407481139561312}]
[null,{"$f":"B23+Maturity/40","v":0.15},{"$f":"EXP(-B23*CreditSpread/10000/LGD)-EXP(-B24*CreditSpread/10000/LGD)","v":6.2285526103711408E-4},{"$f":"EXP(-FundingSpread*B23/10000)-EXP(-FundingSpread*B24/10000)","v":1.8730674056610663E-4},{"$f":"BSCall(Spot,Strike,Maturity-B24,IRate,Volatility)","v":11.216029566808984}]
[null,{"$f":"B24+Maturity/40","v":0.17499999999999999},{"$f":"EXP(-B24*CreditSpread/10000/LGD)-EXP(-B25*CreditSpread/10000/LGD)","v":6.2246609812499631E-4},{"$f":"EXP(-FundingSpread*B24/10000)-EXP(-FundingSpread*B25/10000)","v":1.8727162384446494E-4},{"$f":"BSCall(Spot,Strike,Maturity-B25,IRate,Volatility)","v":11.022474742271839}]
[null,{"$f":"B25+Maturity/40","v":0.19999999999999998},{"$f":"EXP(-B25*CreditSpread/10000/LGD)-EXP(-B26*CreditSpread/10000/LGD)","v":6.2207717836371135E-4},{"$f":"EXP(-FundingSpread*B25/10000)-EXP(-FundingSpread*B26/10000)","v":1.8723651370666783E-4},{"$f":"BSCall(Spot,Strike,Maturity-B26,IRate,Volatility)","v":10.826725073639103}]
[null,{"$f":"B26+Maturity/40","v":0.22499999999999998},{"$f":"EXP(-B26*CreditSpread/10000/LGD)-EXP(-B27*CreditSpread/10000/LGD)","v":6.2168850160138067E-4},{"$f":"EXP(-FundingSpread*B26/10000)-EXP(-FundingSpread*B27/10000)","v":1.8720141015138303E-4},{"$f":"BSCall(Spot,Strike,Maturity-B27,IRate,Volatility)","v":10.628681825408322}]
[null,{"$f":"B27+Maturity/40","v":0.24999999999999997},{"$f":"EXP(-B27*CreditSpread/10000/LGD)-EXP(-B28*CreditSpread/10000/LGD)","v":6.213000676862368E-4},{"$f":"EXP(-FundingSpread*B27/10000)-EXP(-FundingSpread*B28/10000)","v":1.8716631317750032E-4},{"$f":"BSCall(Spot,Strike,Maturity-B28,IRate,Volatility)","v":10.42823783471183}]
[null,{"$f":"B28+Maturity/40","v":0.27499999999999997},{"$f":"EXP(-B28*CreditSpread/10000/LGD)-EXP(-B29*CreditSpread/10000/LGD)","v":6.2091187646617918E-4},{"$f":"EXP(-FundingSpread*B28/10000)-EXP(-FundingSpread*B29/10000)","v":1.8713122278357641E-4},{"$f":"BSCall(Spot,Strike,Maturity-B29,IRate,Volatility)","v":10.225276527074485}]
[null,{"$f":"B29+Maturity/40","v":0.3},{"$f":"EXP(-B29*CreditSpread/10000/LGD)-EXP(-B30*CreditSpread/10000/LGD)","v":6.2052392779010646E-4},{"$f":"EXP(-FundingSpread*B29/10000)-EXP(-FundingSpread*B30/10000)","v":1.8709613896850108E-4},{"$f":"BSCall(Spot,Strike,Maturity-B30,IRate,Volatility)","v":10.01967270939771}]
[null,{"$f":"B30+Maturity/40","v":0.32500000000000001},{"$f":"EXP(-B30*CreditSpread/10000/LGD)-EXP(-B31*CreditSpread/10000/LGD)","v":6.2013622150602909E-4},{"$f":"EXP(-FundingSpread*B30/10000)-EXP(-FundingSpread*B31/10000)","v":1.8706106173105308E-4},{"$f":"BSCall(Spot,Strike,Maturity-B31,IRate,Volatility)","v":9.8112883393151549}]
[null,{"$f":"B31+Maturity/40","v":0.35000000000000003},{"$f":"EXP(-B31*CreditSpread/10000/LGD)-EXP(-B32*CreditSpread/10000/LGD)","v":6.197487574626237E-4},{"$f":"EXP(-FundingSpread*B31/10000)-EXP(-FundingSpread*B32/10000)","v":1.8702599107001117E-4},{"$f":"BSCall(Spot,Strike,Maturity-B32,IRate,Volatility)","v":9.5999736530900748}]
[null,{"$f":"B32+Maturity/40","v":0.37500000000000006},{"$f":"EXP(-B32*CreditSpread/10000/LGD)-EXP(-B33*CreditSpread/10000/LGD)","v":6.1936153550878892E-4},{"$f":"EXP(-FundingSpread*B32/10000)-EXP(-FundingSpread*B33/10000)","v":1.8699092698393205E-4},{"$f":"BSCall(Spot,Strike,Maturity-B33,IRate,Volatility)","v":9.3855635119994574}]
[null,{"$f":"B33+Maturity/40","v":0.40000000000000008},{"$f":"EXP(-B33*CreditSpread/10000/LGD)-EXP(-B34*CreditSpread/10000/LGD)","v":6.1897455549286828E-4},{"$f":"EXP(-FundingSpread*B33/10000)-EXP(-FundingSpread*B34/10000)","v":1.8695586947192755E-4},{"$f":"BSCall(Spot,Strike,Maturity-B34,IRate,Volatility)","v":9.1678770289772444}]
[null,{"$f":"B34+Maturity/40","v":0.4250000000000001},{"$f":"EXP(-B34*CreditSpread/10000/LGD)-EXP(-B35*CreditSpread/10000/LGD)","v":6.1858781726409351E-4},{"$f":"EXP(-FundingSpread*B34/10000)-EXP(-FundingSpread*B35/10000)","v":1.8692081853255438E-4},{"$f":"BSCall(Spot,Strike,Maturity-B35,IRate,Volatility)","v":8.9467133732188842}]
[null,{"$f":"B35+Maturity/40","v":0.45000000000000012},{"$f":"EXP(-B35*CreditSpread/10000/LGD)-EXP(-B36*CreditSpread/10000/LGD)","v":6.1820132067091915E-4},{"$f":"EXP(-FundingSpread*B35/10000)-EXP(-FundingSpread*B36/10000)","v":1.8688577416459129E-4},{"$f":"BSCall(Spot,Strike,Maturity-B36,IRate,Volatility)","v":8.7218504081225916}]
[null,{"$f":"B36+Maturity/40","v":0.47500000000000014},{"$f":"EXP(-B36*CreditSpread/10000/LGD)-EXP(-B37*CreditSpread/10000/LGD)","v":6.1781506556290999E-4},{"$f":"EXP(-FundingSpread*B36/10000)-EXP(-FundingSpread*B37/10000)","v":1.8685073636681704E-4},{"$f":"BSCall(Spot,Strike,Maturity-B37,IRate,Volatility)","v":8.4930399513277521}]
[null,{"$f":"B37+Maturity/40","v":0.50000000000000011},{"$f":"EXP(-B37*CreditSpread/10000/LGD)-EXP(-B38*CreditSpread/10000/LGD)","v":6.1742905178874263E-4},{"$f":"EXP(-FundingSpread*B37/10000)-EXP(-FundingSpread*B38/10000)","v":1.8681570513801038E-4},{"$f":"BSCall(Spot,Strike,Maturity-B38,IRate,Volatility)","v":8.2600044043632082}]
[null,{"$f":"B38+Maturity/40","v":0.52500000000000013},{"$f":"EXP(-B38*CreditSpread/10000/LGD)-EXP(-B39*CreditSpread/10000/LGD)","v":6.1704327919787083E-4},{"$f":"EXP(-FundingSpread*B38/10000)-EXP(-FundingSpread*B39/10000)","v":1.8678068047695007E-4},{"$f":"BSCall(Spot,Strike,Maturity-B39,IRate,Volatility)","v":8.0224309014155182}]
[null,{"$f":"B39+Maturity/40","v":0.55000000000000016},{"$f":"EXP(-B39*CreditSpread/10000/LGD)-EXP(-B40*CreditSpread/10000/LGD)","v":6.166577476395263E-4},{"$f":"EXP(-FundingSpread*B39/10000)-EXP(-FundingSpread*B40/10000)","v":1.8674566238241486E-4},{"$f":"BSCall(Spot,Strike,Maturity-B40,IRate,Volatility)","v":7.779964769881822}]
[null,{"$f":"B40+Maturity/40","v":0.57500000000000018},{"$f":"EXP(-B40*CreditSpread/10000/LGD)-EXP(-B41*CreditSpread/10000/LGD)","v":6.162724569631628E-4},{"$f":"EXP(-FundingSpread*B40/10000)-EXP(-FundingSpread*B41/10000)","v":1.867106508531835E-4},{"$f":"BSCall(Spot,Strike,Maturity-B41,IRate,Volatility)","v":7.5322014246661197}]
[null,{"$f":"B41+Maturity/40","v":0.6000000000000002},{"$f":"EXP(-B41*CreditSpread/10000/LGD)-EXP(-B42*CreditSpread/10000/LGD)","v":6.1588740701823408E-4},{"$f":"EXP(-FundingSpread*B41/10000)-EXP(-FundingSpread*B42/10000)","v":1.8667564588792374E-4},{"$f":"BSCall(Spot,Strike,Maturity-B42,IRate,Volatility)","v":7.2786760624611233}]
[null,{"$f":"B42+Maturity/40","v":0.62500000000000022},{"$f":"EXP(-B42*CreditSpread/10000/LGD)-EXP(-B43*CreditSpread/10000/LGD)","v":6.1550259765419391E-4},{"$f":"EXP(-FundingSpread*B42/10000)-EXP(-FundingSpread*B43/10000)","v":1.8664064748552534E-4},{"$f":"BSCall(Spot,Strike,Maturity-B43,IRate,Volatility)","v":7.0188502809734032}]
[null,{"$f":"B43+Maturity/40","v":0.65000000000000024},{"$f":"EXP(-B43*CreditSpread/10000/LGD)-EXP(-B44*CreditSpread/10000/LGD)","v":6.1511802872105115E-4},{"$f":"EXP(-FundingSpread*B43/10000)-EXP(-FundingSpread*B44/10000)","v":1.8660565564476705E-4},{"$f":"BSCall(Spot,Strike,Maturity-B44,IRate,Volatility)","v":6.7520935682479859}]
[null,{"$f":"B44+Maturity/40","v":0.67500000000000027},{"$f":"EXP(-B44*CreditSpread/10000/LGD)-EXP(-B45*CreditSpread/10000/LGD)","v":6.1473370006837058E-4},{"$f":"EXP(-FundingSpread*B44/10000)-EXP(-FundingSpread*B45/10000)","v":1.865706703642056E-4},{"$f":"BSCall(Spot,Strike,Maturity-B45,IRate,Volatility)","v":6.4776618179155179}]
[null,{"$f":"B45+Maturity/40","v":0.70000000000000029},{"$f":"EXP(-B45*CreditSpread/10000/LGD)-EXP(-B46*CreditSpread/10000/LGD)","v":6.1434961154582801E-4},{"$f":"EXP(-FundingSpread*B45/10000)-EXP(-FundingSpread*B46/10000)","v":1.8653569164295281E-4},{"$f":"BSCall(Spot,Strike,Maturity-B46,IRate,Volatility)","v":6.1946639134813495}]
[null,{"$f":"B46+Maturity/40","v":0.72500000000000031},{"$f":"EXP(-B46*CreditSpread/10000/LGD)-EXP(-B47*CreditSpread/10000/LGD)","v":6.139657630038764E-4},{"$f":"EXP(-FundingSpread*B46/10000)-EXP(-FundingSpread*B47/10000)","v":1.8650071947945435E-4},{"$f":"BSCall(Spot,Strike,Maturity-B47,IRate,Volatility)","v":5.9020191473998764}]
[null,{"$f":"B47+Maturity/40","v":0.75000000000000033},{"$f":"EXP(-B47*CreditSpread/10000/LGD)-EXP(-B48*CreditSpread/10000/LGD)","v":6.1358215429230256E-4},{"$f":"EXP(-FundingSpread*B47/10000)-EXP(-FundingSpread*B48/10000)","v":1.8646575387271103E-4},{"$f":"BSCall(Spot,Strike,Maturity-B48,IRate,Volatility)","v":5.5983951559904881}]
[null,{"$f":"B48+Maturity/40","v":0.77500000000000036},{"$f":"EXP(-B48*CreditSpread/10000/LGD)-EXP(-B49*CreditSpread/10000/LGD)","v":6.1319878526100435E-4},{"$f":"EXP(-FundingSpread*B48/10000)-EXP(-FundingSpread*B49/10000)","v":1.8643079482139058E-4},{"$f":"BSCall(Spot,Strike,Maturity-B49,IRate,Volatility)","v":5.282116499259331}]
[null,{"$f":"B49+Maturity/40","v":0.80000000000000038},{"$f":"EXP(-B49*CreditSpread/10000/LGD)-EXP(-B50*CreditSpread/10000/LGD)","v":6.128156557607678E-4},{"$f":"EXP(-FundingSpread*B49/10000)-EXP(-FundingSpread*B50/10000)","v":1.8639584232427175E-4},{"$f":"BSCall(Spot,Strike,Maturity-B50,IRate,Volatility)","v":4.9510272014412635}]
[null,{"$f":"B50+Maturity/40","v":0.8250000000000004},{"$f":"EXP(-B50*CreditSpread/10000/LGD)-EXP(-B51*CreditSpread/10000/LGD)","v":6.1243276564149074E-4},{"$f":"EXP(-FundingSpread*B50/10000)-EXP(-FundingSpread*B51/10000)","v":1.8636089638013331E-4},{"$f":"BSCall(Spot,Strike,Maturity-B51,IRate,Volatility)","v":4.6022720433083038}]
[null,{"$f":"B51+Maturity/40","v":0.85000000000000042},{"$f":"EXP(-B51*CreditSpread/10000/LGD)-EXP(-B52*CreditSpread/10000/LGD)","v":6.1205011475384818E-4},{"$f":"EXP(-FundingSpread*B51/10000)-EXP(-FundingSpread*B52/10000)","v":1.8632595698764298E-4},{"$f":"BSCall(Spot,Strike,Maturity-B52,IRate,Volatility)","v":4.2319299095240908}]
[null,{"$f":"B52+Maturity/40","v":0.87500000000000044},{"$f":"EXP(-B52*CreditSpread/10000/LGD)-EXP(-B53*CreditSpread/10000/LGD)","v":6.1166770294818207E-4},{"$f":"EXP(-FundingSpread*B52/10000)-EXP(-FundingSpread*B53/10000)","v":1.8629102414580156E-4},{"$f":"BSCall(Spot,Strike,Maturity-B53,IRate,Volatility)","v":3.8343571832737879}]
[null,{"$f":"B53+Maturity/40","v":0.90000000000000047},{"$f":"EXP(-B53*CreditSpread/10000/LGD)-EXP(-B54*CreditSpread/10000/LGD)","v":6.1128553007538944E-4},{"$f":"EXP(-FundingSpread*B53/10000)-EXP(-FundingSpread*B54/10000)","v":1.8625609785327679E-4},{"$f":"BSCall(Spot,Strike,Maturity-B54,IRate,Volatility)","v":3.400893710779286}]
[null,{"$f":"B54+Maturity/40","v":0.92500000000000049},{"$f":"EXP(-B54*CreditSpread/10000/LGD)-EXP(-B55*CreditSpread/10000/LGD)","v":6.1090359598592325E-4},{"$f":"EXP(-FundingSpread*B54/10000)-EXP(-FundingSpread*B55/10000)","v":1.862211781087364E-4},{"$f":"BSCall(Spot,Strike,Maturity-B55,IRate,Volatility)","v":2.9169642097484285}]
[null,{"$f":"B55+Maturity/40","v":0.95000000000000051},{"$f":"EXP(-B55*CreditSpread/10000/LGD)-EXP(-B56*CreditSpread/10000/LGD)","v":6.1052190053068056E-4},{"$f":"EXP(-FundingSpread*B55/10000)-EXP(-FundingSpread*B56/10000)","v":1.8618626491107015E-4},{"$f":"BSCall(Spot,Strike,Maturity-B56,IRate,Volatility)","v":2.3541544049708065}]
[null,{"$f":"B56+Maturity/40","v":0.97500000000000053},{"$f":"EXP(-B56*CreditSpread/10000/LGD)-EXP(-B57*CreditSpread/10000/LGD)","v":6.1014044356055841E-4},{"$f":"EXP(-FundingSpread*B56/10000)-EXP(-FundingSpread*B57/10000)","v":1.861513582589458E-4},{"$f":"BSCall(Spot,Strike,Maturity-B57,IRate,Volatility)","v":1.6391231577128806}]
[null,{"$f":"B57+Maturity/40","v":1.0000000000000004},{"$f":"EXP(-B57*CreditSpread/10000/LGD)-EXP(-B58*CreditSpread/10000/LGD)","v":6.0975922492656487E-4},{"$f":"EXP(-FundingSpread*B57/10000)-EXP(-FundingSpread*B58/10000)","v":1.8611645815125311E-4},{"$f":"BSCall(Spot,Strike,Maturity-B58,IRate,Volatility)","v":0}]