{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Spreadsheet13.1"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":18,"defined_names":940,"comments":1,"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":"Spreadsheet13.1","index":0,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,3,16,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parameters"]
[null,"Interest rate",null,0.05]
[null,"Counterparty 5Y Spread",null,500]
[null,"Institution 5Y Spread",null,250]
[null,"Counterparty Recovery",null,0.4]
[null,"Institution Recovery",null,0.4]
[]
[null,"Calculations"]
[null,"Conditional",null,"Unconditional"]
[null,"CVA",{"$f":"(1-CntrptyRec)*SUMPRODUCT(D25:D88,E24:E87,G25:G88,I25:I88)","v":241171.44430175482},"UCVA",{"$f":"(1-CntrptyRec)*SUMPRODUCT(D25:D88,G25:G88,I25:I88)","v":262292.53432212956}]
[null,"DVA",{"$f":"-(1-InstitutionRec)*SUMPRODUCT(F25:F88,C24:C87,H25:H88,I25:I88)","v":-246293.23091174962},"UDVA",{"$f":"-(1-InstitutionRec)*SUMPRODUCT(F25:F88,H25:H88,I25:I88)","v":-289353.27372000425}]
[null,"BCVA",{"$f":"C18+C19","v":-5121.7866099948005},"UBCVA",{"$f":"E18+E19","v":-27060.739397874684}]
[]
[]
[null,null,"Survival (C)","Def Prob (C)","Survival (I)","Def Prob (I)","EE","NEE","DF"]
[null,0,1,null,1,null,0,0,{"$f":"EXP(-5%*B24)","v":1}]
[null,2.747252747252747E-3,{"$f":"C24*EXP(-(B25-B24)*SpreadCntrpty/10000/(1-CntrptyRec))","v":0.99977108847530438},{"$f":"C24-C25","v":2.289115246956186E-4},{"$f":"E24*EXP(-(B25-B24)*InstitutionSpread/10000/(1-InstitutionRec))","v":0.99988553768684163},{"$f":"-E24+E25","v":-1.1446231315836997E-4},156872.45360000015,-153796.65569999997,{"$f":"EXP(-5%*B25)","v":0.99986264679645243}]
[null,2.7472527472527476E-2,0.99771324133608752,2.0578471392168618E-3,0.99885596626144624,{"$f":"-E25+E26","v":-1.0295714253953925E-3},447001.20710000041,-511027.21870000026,0.99862731661925808]
[null,5.4945054945054951E-2,0.99543171193736202,2.2815293987255014E-3,0.99771324133608741,-1.142724925358829E-3,630855.96080000047,-759487.57939999946,0.9972565174981799]
[null,8.2417582417582416E-2,0.99315539984575607,2.2763120916059476E-3,0.99657182372659714,-1.1414176094902695E-3,727309.07450000057,-984517.1599999998,0.99588760005027355]
[null,0.16483516483516483,0.9863576482427836,6.7977516029724683E-3,0.99315539984575596,-3.4164238808411795E-3,944687.17470000032,-1416638.4787000001,0.99179211193389361]
[null,0.24725274725274723,0.97960642453148139,6.7512237113022122E-3,0.98975068806820288,-3.4047117775530822E-3,980508.96070000029,-1813069.2468999987,0.98771346610263766]
[null,0.32967032967032966,0.97290141024703491,6.7050142844464755E-3,0.98635764824278338,-3.3930398254194971E-3,1090906.1788000008,-2129213.9189000009,0.98365159329429308]
[null,0.41208791208791207,0.96624228910439391,6.6591211426410002E-3,0.98297624035598818,-3.3814078867951958E-3,1196140.8755000001,-2539759.995800002,0.97960642453148128]
[null,0.49450549450549447,0.95962874698335299,6.6135421210409273E-3,0.97960642453148117,-3.3698158245070164E-3,1188799.0899,-2829756.910600001,0.97557789112048632]
[null,0.57692307692307698,0.95306047191373378,6.5682750696192116E-3,0.97624816102962941,-3.3582635018517548E-3,1501480.5085,-2622916.4022000013,0.97156592465008829]
[null,0.65934065934065933,0.94653715406066929,6.5233178530644809E-3,0.97290141024703458,-3.3467507825948317E-3,1498393.5210000006,-2903819.4387999983,0.96757045699040134]
[null,0.74175824175824179,0.94005848570998807,6.478668350681227E-3,0.96956613271606562,-3.3352775309689608E-3,1435685.5603999998,-3214667.0885999962,0.96359142029171718]
[null,0.82417582417582413,0.93362416125369918,6.4343244562888868E-3,0.96624228910439358,-3.3238436116720393E-3,1516901.7683999999,-3443259.6057000016,0.95962874698335277]
[null,0.90659340659340659,0.92723387717557626,6.3902840781229209E-3,0.96292984021452754,-3.3124488898660376E-3,1463426.2144999998,-3701271.0434000008,0.95568236977250232]
[null,0.98901098901098894,0.92088733203684014,6.3465451387361149E-3,0.95962874698335265,-3.3010932311748897E-3,1397729.2390999994,-3888231.8288000003,0.95175222164309548]
[null,1.0714285714285714,0.91458422646193949,6.3031055749006581E-3,0.95633897048166916,-3.2897765016834946E-3,1620135.6594999994,-3525220.3189000045,0.94783823585465843]
[null,1.153846153846154,0.90832426312442904,6.2599633375104435E-3,0.95306047191373344,-3.278498567935717E-3,1592243.9699999997,-3698635.0359,0.94394034594118092]
[null,1.2362637362637363,0.90210714673294412,6.2171163914849226E-3,0.94979321261680072,-3.267259296932723E-3,1625436.0725999991,-3910498.1993999984,0.94005848570998762]
[null,1.3186813186813187,0.89593258401727127,6.1745627156728489E-3,0.94653715406066885,-3.2560585561318689E-3,1620920.6138999998,-4028796.1588999988,0.93619258924061399]
[null,1.401098901098901,0.88980028371451447,6.132300302756799E-3,0.94329225784722393,-3.2448962134449255E-3,1630026.4891000004,-4191455.5310999951,0.93234259088368665]
[null,1.4835164835164836,0.88370995655535578,6.0903271591586927E-3,0.94005848570998751,-3.2337721372364125E-3,1661223.2676999986,-4330779.6935999962,0.92850842525980881]
[null,1.5659340659340659,0.87766131525041013,6.0486413049456456E-3,0.93683579951366558,-3.2226861963219333E-3,1896267.6783,-4012770.8465999961,0.92469002725844984]
[null,1.6483516483516483,0.8716540744766732,6.0072407737369327E-3,0.93362416125369851,-3.2116382599670645E-3,1938649.2337000018,-4215728.6931000026,0.92088733203683959]
[null,1.7307692307692308,0.86568795086406281,5.9661236126103967E-3,0.93042353305581305,-3.2006281978854689E-3,1914384.7328999992,-4257420.0839999942,0.91710027501886759]
[null,1.8131868131868132,0.85976266298205151,5.9252878820112986E-3,0.92723387717557559,-3.1896558802374519E-3,1897175.3328999996,-4308451.068,0.91332879189398597]
[null,1.8956043956043955,0.85387793132639134,5.8847316556601692E-3,0.92405515599794708,-3.1787211776285185E-3,1891604.6289999995,-4436893.481699992,0.90957281861611738]
[null,1.9780219780219779,0.84803347830592923,5.8444530204621037E-3,0.92088733203683948,-3.1678239611075965E-3,1862476.4532999988,-4510921.1763999993,0.90583229140256794]
[null,2.0604395604395602,0.8422290282295124,5.8044500764168339E-3,0.91773036793467366,-3.1569641021658157E-3,2005894.5245999997,-4138304.8130000015,0.90210714673294345]
[null,2.1428571428571428,0.83646430729298393,5.7647209365284668E-3,0.91458422646193882,-3.1461414727348425E-3,2058717.7652999999,-4169073.7940000002,0.89839732134807104]
[null,2.2252747252747254,0.83073904356626682,5.7252637267171114E-3,0.91144887051675361,-3.1353559451852142E-3,2059718.1285999988,-4179745.2564999997,0.89470275224892493]
[null,2.3076923076923079,0.82505296698053665,5.6860765857301709E-3,0.90832426312442838,-3.1246073923252293E-3,2077630.0824000007,-4157349.8984999973,0.89102337669555631]
[null,2.3901098901098901,0.81940580931548224,5.6471576650544142E-3,0.90521036743702921,-3.1138956873991708E-3,1964755.8311000003,-4203903.8944999985,0.88735913220602847]
[null,2.4725274725274726,{"$f":"C56*EXP(-(B57-B56)*SpreadCntrpty/10000/(1-CntrptyRec))","v":0.81379730418665308},{"$f":"C56-C57","v":5.6085051288291554E-3},{"$f":"E56*EXP(-(B57-B56)*InstitutionSpread/10000/(1-InstitutionRec))","v":0.90210714673294334},-3.1032207040858628E-3,1863411.8062,-4255274.2696999963,0.88370995655535511]
[null,2.5549450549450547,0.80822718703289387,5.5701171537592131E-3,0.89901456441644645,-3.0925823164968946E-3,2006002.3548000001,-3898548.3723999979,0.88007578777444417]
[null,2.6373626373626373,0.80269519510386433,5.5319919290295338E-3,0.89593258401727049,-3.0819803991759542E-3,2007368.2804000007,-3917549.4817000004,0.87645656414904505]
[null,2.7197802197802194,0.79720106744764552,5.4941276562188168E-3,0.89286116919017411,-3.0714148270963859E-3,1980181.9427,-3908787.4208999998,0.87285222421870112]
[null,2.802197802197802,0.79174454489842994,5.4565225492155811E-3,0.8898002837145137,-3.0608854756604131E-3,1975839.9553000003,-3836739.5537000019,0.8692627067757055]
[null,2.8846153846153841,0.78632537006429637,5.4191748341335666E-3,0.88674989149381656,-3.0503922206971401E-3,1876590.6473000003,-3844930.1716000028,0.86568795086406214]
[null,2.9670329670329672,0.78094328731506824,5.3820827492281342E-3,0.883709956555355,-3.0399349384615526E-3,1791108.7770000007,-3831388.2869999968,0.86212789577844995]
[null,3.0494505494505497,0.77559804277025579,5.3452445448124442E-3,0.88068044304972215,-3.0295135056328526E-3,1906796.0631999993,-3269798.1203999971,0.8585824810631929]
[null,3.1318681318681318,0.77028938428707916,5.3086584831766315E-3,0.87766131525040925,-3.019127799312904E-3,1844680.8702000002,-3105951.3495000033,0.85505164651123267]
[null,3.2142857142857144,0.7650170614485754,5.2723228385037624E-3,0.87465253755338435,-3.0087776970249003E-3,1699516.2819000003,-3008959.755100003,0.85153533216310628]
[null,3.2967032967032965,0.75978082555178528,5.2362358967901201E-3,0.87165407447667231,-2.9984630767120324E-3,1604310.529700001,-2833186.4334000046,0.84803347830592857]
[null,3.3791208791208796,0.7545804295960219,5.2003959557633817E-3,0.8686658906599366,-2.9881838167357122E-3,1521538.0326000003,-2675797.9394000024,0.84454602547237689]
[null,3.4615384615384617,0.74941562827121955,5.1648013248023483E-3,0.86568795086406192,-2.9779397958746845E-3,1379207.1855999997,-2599877.4510999988,0.84107291443968257]
[null,3.5439560439560442,0.74428617794636154,5.1294503248580092E-3,0.86272021997073911,-2.9677308933228064E-3,1469271.3344999996,-2051116.0387000006,0.83761408622862454]
[null,3.6263736263736264,0.73919183665798827,5.0943412883732719E-3,0.85976266298205062,-2.9575569886884923E-3,1358332.7918,-1968949.394199999,0.83416948210252784]
[null,3.7087912087912089,0.73413236409878313,5.0594725592051359E-3,0.85681524502005801,-2.9474179619926044E-3,1269422.6202000007,-1848731.0140000009,0.83073904356626616]
[null,3.7912087912087911,0.72910752160623715,5.0248424925459778E-3,0.85387793132639045,-2.9373136936675648E-3,1153961.8235000004,-1695773.290599999,0.82732271236526844]
[null,3.8736263736263736,0.72411707215139065,4.9904494548465017E-3,0.85095068726183509,-2.9272440645553566E-3,1053227.2349000003,-1576991.9526000004,0.82392043048453001]
[null,3.9560439560439558,0.71916078032765263,4.9562918237380238E-3,0.84803347830592835,-2.9172089559067471E-3,935819.85980000021,-1539867.6170000003,0.82053214014762688]
[null,4.0384615384615383,0.71423841233969576,4.922367987956866E-3,0.84512627005654872,-2.9072082493796225E-3,1044127.2811,-1099132.695099999,0.81715778381573478]
[null,4.1208791208791204,0.70934973599242857,4.8886763472671957E-3,0.84222902822951151,-2.8972418270372113E-3,918914.35639999947,-1143915.4436999997,0.81379730418665241]
[null,4.2032967032967035,0.70449452068004181,4.8552153123867514E-3,0.83934171865816409,-2.8873095713474184E-3,828366.32709999941,-1176553.2459999998,0.81045064419382773]
[null,4.2857142857142856,0.69967253737513124,4.8219833049105709E-3,0.83646430729298304,-2.8774113651810485E-3,721858.31669999915,-1178667.7663999998,0.8071177470053893]
[null,4.3681318681318686,0.69488355861789308,4.7889787572381604E-3,0.83359676020117301,-2.8675470918100299E-3,611608.19339999999,-1236729.9596000016,0.80379855602318095]
[null,4.4505494505494507,0.69012735850539553,4.756200112497555E-3,0.83073904356626593,-2.8577166349070815E-3,526200.7546000001,-1325854.875499998,0.80049301488180113]
[null,4.5329670329670328,0.6854037126809216,4.7236458244739321E-3,0.82789112368772277,-2.8479198785431592E-3,631776.22400000028,-920930.33520000009,0.79720106744764485]
[null,4.6153846153846159,0.68071239832338637,4.6913143575352256E-3,0.82505296698053576,-2.8381567071870117E-3,586060.48910000001,-918729.73760000092,0.79392265781795124]
[null,4.697802197802198,0.67605319413682641,4.659204186559962E-3,0.82222453997483258,-2.8284270057031824E-3,549724.17839999986,-914500.10049999866,0.79065773031985409]
[null,4.7802197802197801,0.67142588033996042,4.6273137968659839E-3,0.81940580931548135,-2.8187306593512318E-3,574786.43509999965,-872034.80149999948,0.78740622950943595]
[null,4.8626373626373622,0.66683023865582214,4.5956416841382852E-3,0.81659674176169761,-2.8090675537837395E-3,566271.8459999999,-875742.53330000036,0.78416810017078709]
[null,4.9450549450549453,0.66226605230146396,4.5641863543581795E-3,0.81379730418665219,-2.7994375750454159E-3,557088.58889999986,-908098.90619999904,0.78094328731506757]
[null,5,0.65924063020044477,3.0254221010191928E-3,0.8119363461506347,-1.8609580360174904E-3,549732.71279999986,-949933.84699999983,0.77880078307140488]