{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1-Faktor-Schwellwertmodell","Beispiel","Tabelle3"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"1-Faktor-Schwellwertmodell","index":0,"n_rows":108,"n_cols":20,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,null,"1-Faktor-Schwellwertmodell"]
[null,null,"J. Lemm, 2011"]
[null,null,"grüne Felder = Eingabefelder",null,null,null,null,null,null,"erw. A.","erw. Verl.",null,"Rho",null,null,null,null,"VAR %","EL exakt"]
[null,null,"gelbe Felder = Ergebnisfelder",null,null,null,null,null,null,{"$f":"SUM(INDIRECT(\"f8:f\"&(7+$C$6)))","v":4.9999999999999902},{"$f":"SUMPRODUCT(INDIRECT(\"d8:d\"&(7+$C$6)),INDIRECT(\"e8:e\"&(7+$C$6)),INDIRECT(\"f8:f\"&(7+$C$6)))","v":2500},null,0.15,null,null,null,null,0.95,{"$f":"K4","v":2500}]
[null,null,"Anzahl","Min_Loss","Max_Loss",null,"Systemat. Faktor","X",null,"Summe A.","Summe Verl.",null,"N_Bins",null,null,"Summe","Summe","VAR €","EL emp."]
[null,null,{"$f":"MAX(C8:C10008)","v":100},0,{"$f":"SUMPRODUCT(INDIRECT(\"D8:D\"&(7+$C$6)),INDIRECT(\"E8:E\"&(7+$C$6)))","v":50000},null,1,{"$f":"NORMINV(RAND(),0,1)","v":-2.5351184050665836},null,{"$f":"SUM(INDIRECT(\"J8:J\"&(7+$C$6)))","v":31},{"$f":"SUM(INDIRECT(\"K8:K\"&(7+$C$6)))","v":15500},null,{"$f":"MAX(M8:M108)","v":101},null,null,{"$f":"SUM(INDIRECT(\"P8:P\"&7+$M$6))","v":1000},{"$f":"SUM(INDIRECT(\"q8:q\"&7+$M$6))","v":1},{"$f":"IF(P6>0,INDIRECT(\"o\"&7+VLOOKUP(R4,R8:T108,3)+1),\"\")","v":7920.7920792079231},{"$f":"SUMPRODUCT(INDIRECT(\"Q8:Q\"&7+M6),INDIRECT(\"S8:S\"&7+M6))","v":2719.8019801980208}]
[null,null,"Kunde","EAD(T€)","LGD%","PD","Schwelle","eps_i","y_i","Ausfall","Verlust",null,"Verlust","von","bis","Obs","relativ","kumuliert","mittl. Verl.","N"]
[null,null,1,1000,0.5,0.05,{"$f":"NORMINV(F8,0,1)","v":-1.6448536269514726},{"$f":"NORMINV(RAND(),0,1)","v":-0.98925277096996167},{"$f":"SQRT($M$4)*$H$6+SQRT(1-$M$4)*H8","v":-1.8938931264944527},{"$f":"IF(I8<=G8,1,0)","v":1},{"$f":"J8*E8*D8","v":500},null,1,{"$f":"D6","v":0},{"$f":"N8+($E$6-$D$6)/$M$6","v":495.04950495049508},102,{"$f":"IF($P$6>0,P8/$P$6,\"\")","v":0.10199999999999999},{"$f":"Q8","v":0.10199999999999999},{"$f":"(N8+O8)/2","v":247.52475247524754},1]
[null,null,2,1000,0.5,0.05,{"$f":"NORMINV(F9,0,1)","v":-1.6448536269514726},{"$f":"NORMINV(RAND(),0,1)","v":-0.74415276352464721},{"$f":"SQRT($M$4)*$H$6+SQRT(1-$M$4)*H9","v":-1.6679220849819631},{"$f":"IF(I9<=G9,1,0)","v":1},{"$f":"J9*E9*D9","v":500},null,2,{"$f":"O8","v":495.04950495049508},{"$f":"N9+($E$6-$D$6)/$M$6","v":990.09900990099015},140,{"$f":"IF($P$6>0,P9/$P$6,\"\")","v":0.14000000000000001},{"$f":"IF(AND(ISNUMBER(R8),ISNUMBER(Q9)),R8+Q9,0)","v":0.24199999999999999},{"$f":"(N9+O9)/2","v":742.57425742574264},2]
[null,null,3,1000,0.5,0.05,-1.6448536269514726,-0.14396063693127031,-1.1145722855774833,0,0,null,3,{"$f":"O9","v":990.09900990099015},1485.1485148514853,140,0.14000000000000001,{"$f":"IF(AND(ISNUMBER(R9),ISNUMBER(Q10)),R9+Q10,0)","v":0.38200000000000001},1237.6237623762377,3]
[null,null,4,1000,0.5,0.05,-1.6448536269514726,0.38584104201103436,-0.62611927232178433,0,0,null,4,1485.1485148514853,1980.1980198019803,107,0.107,0.48899999999999999,1732.6732673267329,4]
[null,null,5,1000,0.5,0.05,-1.6448536269514726,-1.4435875815613075,-2.3127691249687183,1,500,null,5,1980.1980198019803,2475.2475247524753,99,9.9000000000000005E-2,0.58799999999999997,2227.7227722772277,5]
[null,null,6,1000,0.5,0.05,-1.6448536269514726,0.80416821214985612,-0.240440678042945,0,0,null,6,2475.2475247524753,2970.2970297029706,81,8.1000000000000003E-2,0.66899999999999993,2722.772277227723,6]
[null,null,7,1000,0.5,0.05,-1.6448536269514726,0.8614080827702314,-0.18766812485152073,0,0,null,7,2970.2970297029706,3465.3465346534658,62,6.2E-2,0.73099999999999987,3217.8217821782182,7]
[null,null,8,1000,0.5,0.05,-1.6448536269514726,-0.52415134718314182,-1.4650908011191723,0,0,null,8,3465.3465346534658,3960.3960396039611,58,5.8000000000000003E-2,0.78899999999999992,3712.8712871287134,8]
[null,null,9,1000,0.5,0.05,-1.6448536269514726,0.884719736223334,-0.16617584231313232,0,0,null,9,3960.3960396039611,4455.4455445544563,38,3.7999999999999999E-2,0.82699999999999996,4207.9207920792087,9]
[null,null,10,1000,0.5,0.05,-1.6448536269514726,6.2582565610160804E-2,-0.92414886175924604,0,0,null,10,4455.4455445544563,4950.4950495049516,33,3.3000000000000002E-2,0.86,4702.9702970297039,10]
[null,null,11,1000,0.5,0.05,{"$f":"NORMINV(F18,0,1)","v":-1.6448536269514726},-1.3239119753988238,-2.202433667821869,{"$f":"IF(I18<=G18,1,0)","v":1},{"$f":"J18*E18*D18","v":500},null,11,4950.4950495049516,5445.5445544554468,21,2.1000000000000001E-2,0.88100000000000001,5198.0198019801992,11]
[null,null,12,1000,0.5,0.05,-1.6448536269514726,5.4768879154062818E-3,-0.97679769518630888,0,0,null,12,{"$f":"O18","v":5445.5445544554468},{"$f":"N19+($E$6-$D$6)/$M$6","v":5940.5940594059421},15,{"$f":"IF($P$6>0,P19/$P$6,\"\")","v":1.4999999999999999E-2},0.89600000000000002,{"$f":"(N19+O19)/2","v":5693.0693069306944},12]
[null,null,13,1000,0.5,0.05,-1.6448536269514726,1.087645793605438,2.0912738444615275E-2,0,0,null,13,5940.5940594059421,6435.6435643564373,16,1.6E-2,0.91200000000000003,6188.1188118811897,13]
[null,null,14,1000,0.5,0.05,-1.6448536269514726,-0.93633074240190972,-1.8451014269791248,1,500,null,14,6435.6435643564373,6930.6930693069326,12,1.2E-2,0.92400000000000004,6683.1683168316849,14]
[null,null,15,1000,0.5,0.05,-1.6448536269514726,-1.4239014114270505,-2.2946193728940569,1,500,null,15,6930.6930693069326,7425.7425742574278,18,1.7999999999999999E-2,0.94200000000000006,7178.2178217821802,15]
[null,null,16,1000,0.5,0.05,-1.6448536269514726,0.30000686682782091,-0.70525447172745448,0,0,null,16,7425.7425742574278,7920.7920792079231,12,1.2E-2,0.95400000000000007,7673.2673267326754,16]
[null,null,17,1000,0.5,0.05,-1.6448536269514726,1.1579444397180676,8.5724887756904122E-2,0,0,null,17,7920.7920792079231,8415.8415841584174,7,7.0000000000000001E-3,0.96100000000000008,8168.3168316831707,17]
[null,null,18,1000,0.5,0.05,-1.6448536269514726,-0.50237698415249932,-1.4450158303201479,0,0,null,18,8415.8415841584174,8910.8910891089126,10,0.01,0.97100000000000009,8663.3663366336659,18]
[null,null,19,1000,0.5,0.05,-1.6448536269514726,0.61765478252784722,-0.41239756367117297,0,0,null,19,8910.8910891089126,9405.9405940594079,8,8.0000000000000002E-3,0.97900000000000009,9158.4158415841594,19]
[null,null,20,1000,0.5,0.05,-1.6448536269514726,0.71953459723544899,-0.31846901557142326,0,0,null,20,9405.9405940594079,9900.9900990099031,4,4.0000000000000001E-3,0.9830000000000001,9653.4653465346564,20]
[null,null,21,1000,0.5,0.05,-1.6448536269514726,1.0701744878952708,4.8049904724311032E-3,0,0,null,21,9900.9900990099031,10396.039603960398,3,3.0000000000000001E-3,0.9860000000000001,10148.51485148515,21]
[null,null,22,1000,0.5,0.05,-1.6448536269514726,-1.6784091019722314,-2.5292638696644802,1,500,null,22,{"$f":"O28","v":10396.039603960398},{"$f":"N29+($E$6-$D$6)/$M$6","v":10891.089108910894},2,{"$f":"IF($P$6>0,P29/$P$6,\"\")","v":2E-3},{"$f":"IF(AND(ISNUMBER(R28),ISNUMBER(Q29)),R28+Q29,0)","v":0.9880000000000001},{"$f":"(N29+O29)/2","v":10643.564356435647},22]
[null,null,23,1000,0.5,0.05,-1.6448536269514726,0.76436301566651654,-0.27713925590388777,0,0,null,23,10891.089108910894,11386.138613861389,4,4.0000000000000001E-3,0.9920000000000001,11138.61386138614,23]
[null,null,24,1000,0.5,0.05,-1.6448536269514726,-1.0116414843133696,-1.9145345002955665,1,500,null,24,11386.138613861389,11881.188118811884,1,1E-3,0.9930000000000001,11633.663366336637,24]
[null,null,25,1000,0.5,0.05,-1.6448536269514726,0.74881003708742033,-0.2914783936492179,0,0,null,25,11881.188118811884,12376.237623762379,2,2E-3,0.99500000000000011,12128.712871287131,25]
[null,null,26,1000,0.5,0.05,-1.6448536269514726,-1.385185580494438,-2.2589251404456316,1,500,null,26,12376.237623762379,12871.287128712875,1,1E-3,0.99600000000000011,12623.762376237628,26]
[null,null,27,1000,0.5,0.05,-1.6448536269514726,-1.6436444192279727,-2.497212415854043,1,500,null,27,12871.287128712875,13366.33663366337,null,0,0.99600000000000011,13118.811881188121,27]
[null,null,28,1000,0.5,0.05,-1.6448536269514726,0.43210243716578411,-0.58346837339322333,0,0,null,28,13366.33663366337,13861.386138613865,null,0,0.99600000000000011,13613.861386138618,28]
[null,null,29,1000,0.5,0.05,-1.6448536269514726,-1.381699957307257,-2.2557115546520725,1,500,null,29,13861.386138613865,14356.43564356436,null,0,0.99600000000000011,14108.910891089112,29]
[null,null,30,1000,0.5,0.05,-1.6448536269514726,-0.68976527844534119,-1.6177793013210617,0,0,null,30,14356.43564356436,14851.485148514856,1,1E-3,0.99700000000000011,14603.960396039609,30]
[null,null,31,1000,0.5,0.05,-1.6448536269514726,-0.85986928099385762,-1.7746074427070129,1,500,null,31,14851.485148514856,15346.534653465351,1,1E-3,0.99800000000000011,15099.009900990102,31]
[null,null,32,1000,0.5,0.05,-1.6448536269514726,-0.49004396195153505,-1.4336453456726908,0,0,null,32,15346.534653465351,15841.584158415846,null,0,0.99800000000000011,15594.059405940599,32]
[null,null,33,1000,0.5,0.05,-1.6448536269514726,-1.4777805960653194,-2.344293526703578,1,500,null,33,15841.584158415846,16336.633663366341,null,0,0.99800000000000011,16089.108910891093,33]
[null,null,34,1000,0.5,0.05,-1.6448536269514726,-0.731182206678887,-1.6559638224344302,1,500,null,34,16336.633663366341,16831.683168316835,null,0,0.99800000000000011,16584.158415841586,34]
[null,null,35,1000,0.5,0.05,-1.6448536269514726,0.40191841747281054,-0.61129666453914078,0,0,null,35,16831.683168316835,17326.732673267328,1,1E-3,0.99900000000000011,17079.207920792083,35]
[null,null,36,1000,0.5,0.05,-1.6448536269514726,-0.50855553364361195,-1.4507121714916376,0,0,null,36,17326.732673267328,17821.782178217822,null,0,0.99900000000000011,17574.257425742573,36]
[null,null,37,1000,0.5,0.05,-1.6448536269514726,-0.96345311746254247,-1.8701070212450124,1,500,null,37,17821.782178217822,18316.831683168315,null,0,0.99900000000000011,18069.30693069307,37]
[null,null,38,1000,0.5,0.05,-1.6448536269514726,0.82266505521705491,-0.22338743134518413,0,0,null,38,18316.831683168315,18811.881188118808,1,1E-3,1,18564.35643564356,38]
[null,null,39,1000,0.5,0.05,-1.6448536269514726,-0.66320018576611584,-1.5932874960242394,0,0,null,39,18811.881188118808,19306.930693069302,null,0,1,19059.405940594057,39]
[null,null,40,1000,0.5,0.05,-1.6448536269514726,-4.8554950087738212E-2,-1.0266125884442328,0,0,null,40,19306.930693069302,19801.980198019795,null,0,1,19554.455445544547,40]
[null,null,41,1000,0.5,0.05,-1.6448536269514726,2.029413706476025E-2,-0.96313686645958341,0,0,null,41,19801.980198019795,20297.029702970289,null,0,1,20049.504950495044,41]
[null,null,42,1000,0.5,0.05,-1.6448536269514726,-2.2248965867128638,-3.0331004357565234,1,500,null,42,20297.029702970289,20792.079207920782,null,0,1,20544.554455445534,42]
[null,null,43,1000,0.5,0.05,-1.6448536269514726,-0.11492922304772764,-1.0878066444817442,0,0,null,43,20792.079207920782,21287.128712871276,null,0,1,21039.603960396031,43]
[null,null,44,1000,0.5,0.05,-1.6448536269514726,-1.0145459991232351,-1.9172123306372084,1,500,null,44,21287.128712871276,21782.178217821769,null,0,1,21534.653465346521,44]
[null,null,45,1000,0.5,0.05,-1.6448536269514726,2.5628351950093538,1.3809701653616835,0,0,null,45,21782.178217821769,22277.227722772262,null,0,1,22029.702970297018,45]
[null,null,46,1000,0.5,0.05,-1.6448536269514726,6.7083440180452522E-2,-0.91999926043949576,0,0,null,46,22277.227722772262,22772.277227722756,null,0,1,22524.752475247507,46]
[null,null,47,1000,0.5,0.05,-1.6448536269514726,-1.6681059224521537,-2.5197648075007981,1,500,null,47,22772.277227722756,23267.326732673249,null,0,1,23019.801980198004,47]
[null,null,48,1000,0.5,0.05,-1.6448536269514726,-2.0530760594964215,-2.8746897368217743,1,500,null,48,23267.326732673249,23762.376237623743,null,0,1,23514.851485148494,48]
[null,null,49,1000,0.5,0.05,-1.6448536269514726,1.6174804284965953,0.50939613558387231,0,0,null,49,23762.376237623743,24257.425742574236,null,0,1,24009.900990098991,49]
[null,null,50,1000,0.5,0.05,-1.6448536269514726,2.048540210950744,0.90681361839257479,0,0,null,50,24257.425742574236,24752.47524752473,null,0,1,24504.950495049481,50]
[null,null,51,1000,0.5,0.05,-1.6448536269514726,0.87523637281500155,-0.17491907136791085,0,0,null,51,24752.47524752473,25247.524752475223,null,0,1,24999.999999999978,51]
[null,null,52,1000,0.5,0.05,-1.6448536269514726,0.4111756695691276,-0.60276189981370454,0,0,null,52,25247.524752475223,25742.574257425716,null,0,1,25495.049504950468,52]
[null,null,53,1000,0.5,0.05,-1.6448536269514726,-0.90340414529017821,-1.8147446043892268,1,500,null,53,25742.574257425716,26237.62376237621,null,0,1,25990.099009900965,53]
[null,null,54,1000,0.5,0.05,-1.6448536269514726,-1.5413994761090746,-2.4029472359922366,1,500,null,54,26237.62376237621,26732.673267326703,null,0,1,26485.148514851455,54]
[null,null,55,1000,0.5,0.05,-1.6448536269514726,-0.33077706247977934,-1.2868085196471859,0,0,null,55,26732.673267326703,27227.722772277197,null,0,1,26980.198019801952,55]
[null,null,56,1000,0.5,0.05,-1.6448536269514726,0.38218704116689167,-0.62948809464474031,0,0,null,56,27227.722772277197,27722.77227722769,null,0,1,27475.247524752442,56]
[null,null,57,1000,0.5,0.05,-1.6448536269514726,0.78963421437105519,-0.25384036190933013,0,0,null,57,27722.77227722769,28217.821782178184,null,0,1,27970.297029702939,57]
[null,null,58,1000,0.5,0.05,-1.6448536269514726,-0.65971517866704055,-1.5900744782358487,0,0,null,58,28217.821782178184,28712.871287128677,null,0,1,28465.346534653429,58]
[null,null,59,1000,0.5,0.05,-1.6448536269514726,-9.0158576047349448E-2,-1.0649692363561547,0,0,null,59,28712.871287128677,29207.92079207917,null,0,1,28960.396039603926,59]
[null,null,60,1000,0.5,0.05,-1.6448536269514726,-0.95871886866059031,-1.8657422595148641,1,500,null,60,29207.92079207917,29702.970297029664,null,0,1,29455.445544554415,60]
[null,null,61,1000,0.5,0.05,-1.6448536269514726,-1.0040405596977793,-1.9075267940545697,1,500,null,61,29702.970297029664,30198.019801980157,null,0,1,29950.495049504912,61]
[null,null,62,1000,0.5,0.05,-1.6448536269514726,0.41458478037926005,-0.59961885494631906,0,0,null,62,30198.019801980157,30693.069306930651,null,0,1,30445.544554455402,62]
[null,null,63,1000,0.5,0.05,-1.6448536269514726,-0.31477812645644521,-1.2720582294535345,0,0,null,63,30693.069306930651,31188.118811881144,null,0,1,30940.594059405899,63]
[null,null,64,1000,0.5,0.05,-1.6448536269514726,-8.9837438764625282E-3,-0.99012973895487666,0,0,null,64,31188.118811881144,31683.168316831638,null,0,1,31435.643564356389,64]
[null,null,65,1000,0.5,0.05,-1.6448536269514726,0.14777765402923221,-0.8456028712369833,0,0,null,65,31683.168316831638,32178.217821782131,null,0,1,31930.693069306886,65]
[null,null,66,1000,0.5,0.05,-1.6448536269514726,{"$f":"NORMINV(RAND(),0,1)","v":-0.43888628147418685},{"$f":"SQRT($M$4)*$H$6+SQRT(1-$M$4)*H73","v":-1.3864802947234012},0,0,null,66,32178.217821782131,32673.267326732624,null,0,1,32425.742574257376,66]
[null,null,67,1000,0.5,0.05,-1.6448536269514726,-0.76581428614175873,-1.687893022060075,1,500,null,67,32673.267326732624,33168.316831683122,null,0,1,32920.792079207873,67]
[null,null,68,1000,0.5,0.05,-1.6448536269514726,0.18815214559892918,-0.80837942924024153,0,0,null,68,33168.316831683122,33663.366336633619,null,0,1,33415.84158415837,68]
[null,null,69,1000,0.5,0.05,-1.6448536269514726,2.6161838601700942,1.4301552043803514,0,0,null,69,33663.366336633619,34158.415841584116,null,0,1,33910.891089108867,69]
[null,null,70,1000,0.5,0.05,-1.6448536269514726,1.2854565947209233,0.20328528594630924,0,0,null,70,34158.415841584116,34653.465346534613,null,0,1,34405.940594059364,70]
[null,null,71,1000,0.5,0.05,-1.6448536269514726,0.55576484302291096,-0.46945726854366565,0,0,null,71,34653.465346534613,35148.51485148511,null,0,1,34900.990099009861,71]
[null,null,72,1000,0.5,0.05,-1.6448536269514726,2.1619330771040102,1.0113566754565646,0,0,null,72,35148.51485148511,35643.564356435607,null,0,1,35396.039603960358,72]
[null,null,73,1000,0.5,0.05,-1.6448536269514726,-1.9847981484372756,-2.8117406131756857,1,500,null,73,35643.564356435607,36138.613861386104,null,0,1,35891.089108910855,73]
[null,null,74,1000,0.5,0.05,-1.6448536269514726,-2.0008257093282955,-2.8265172941933585,1,500,null,74,36138.613861386104,36633.663366336601,null,0,1,36386.138613861352,74]
[null,null,75,1000,0.5,0.05,{"$f":"NORMINV(F82,0,1)","v":-1.6448536269514726},1.5141296227612111,0.41411140076643083,{"$f":"IF(I82<=G82,1,0)","v":0},{"$f":"J82*E82*D82","v":0},null,75,36633.663366336601,37128.712871287098,null,0,1,36881.18811881185,75]
[null,null,76,1000,0.5,0.05,-1.6448536269514726,-0.12161245999640997,-1.0939682844984442,0,0,null,76,37128.712871287098,37623.762376237595,null,0,1,37376.237623762347,76]
[null,null,77,1000,0.5,0.05,-1.6448536269514726,-0.7768697222308274,-1.6980856305118677,1,500,null,77,37623.762376237595,38118.811881188092,null,0,1,37871.287128712844,77]
[null,null,78,1000,0.5,0.05,-1.6448536269514726,-0.51150559925612238,-1.4534319975982848,0,0,null,78,38118.811881188092,38613.861386138589,null,0,1,38366.336633663341,78]
[null,null,79,1000,0.5,0.05,-1.6448536269514726,0.37530746103179835,-0.63583075413504042,0,0,null,79,38613.861386138589,39108.910891089086,null,0,1,38861.386138613838,79]
[null,null,80,1000,0.5,0.05,-1.6448536269514726,0.77583085987974199,-0.26656642594857372,0,0,null,80,39108.910891089086,39603.960396039583,null,0,1,39356.435643564335,80]
[null,null,81,1000,0.5,0.05,-1.6448536269514726,0.32695958772630224,-0.68040529087059898,0,0,null,81,39603.960396039583,40099.00990099008,null,0,1,39851.485148514832,81]
[null,null,82,1000,0.5,0.05,-1.6448536269514726,-0.94780024677714392,-1.8556757875281835,1,500,null,82,40099.00990099008,40594.059405940578,null,0,1,40346.534653465329,82]
[null,null,83,1000,0.5,0.05,-1.6448536269514726,0.46303669860797492,-0.55494839353124348,0,0,null,83,40594.059405940578,41089.108910891075,null,0,1,40841.584158415826,83]
[null,null,84,1000,0.5,0.05,-1.6448536269514726,0.69944277700012791,-0.3369927585601713,0,0,null,84,41089.108910891075,41584.158415841572,null,0,1,41336.633663366323,84]
[null,null,85,1000,0.5,0.05,-1.6448536269514726,-1.494082921629893,-2.3593235282335629,1,500,null,85,41584.158415841572,42079.207920792069,null,0,1,41831.68316831682,85]
[null,null,86,1000,0.5,0.05,-1.6448536269514726,0.3491475791671162,-0.65994897351993709,0,0,null,86,{"$f":"O92","v":42079.207920792069},{"$f":"N93+($E$6-$D$6)/$M$6","v":42574.257425742566},null,{"$f":"IF($P$6>0,P93/$P$6,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(R92),ISNUMBER(Q93)),R92+Q93,0)","v":1},{"$f":"(N93+O93)/2","v":42326.732673267317},86]
[null,null,87,1000,0.5,0.05,-1.6448536269514726,1.2845464968937983,0.20244621720854261,0,0,null,87,42574.257425742566,43069.306930693063,null,0,1,42821.782178217814,87]
[null,null,88,1000,0.5,0.05,-1.6448536269514726,1.1681907792546256,9.5171546045085487E-2,0,0,null,88,43069.306930693063,43564.35643564356,null,0,1,43316.831683168311,88]
[null,null,89,1000,0.5,0.05,-1.6448536269514726,-0.41235997490158,-1.3620242484500082,0,0,null,89,43564.35643564356,44059.405940594057,null,0,1,43811.881188118808,89]
[null,null,90,1000,0.5,0.05,-1.6448536269514726,0.27051206886119422,-0.73244733183867317,0,0,null,90,44059.405940594057,44554.455445544554,null,0,1,44306.930693069306,90]
[null,null,91,1000,0.5,0.05,-1.6448536269514726,-1.2502212743083951E-2,-0.99337360696861832,0,0,null,91,44554.455445544554,45049.504950495051,null,0,1,44801.980198019803,91]
[null,null,92,1000,0.5,0.05,-1.6448536269514726,0.62242078525861599,-0.40800352626518277,0,0,null,92,45049.504950495051,45544.554455445548,null,0,1,45297.0297029703,92]
[null,null,93,1000,0.5,0.05,-1.6448536269514726,1.981802745594446,0.84528471551063133,0,0,null,93,45544.554455445548,46039.603960396045,null,0,1,45792.079207920797,93]
[null,null,94,1000,0.5,0.05,-1.6448536269514726,-0.59288061767768629,-1.5284560576033484,0,0,null,94,46039.603960396045,46534.653465346542,null,0,1,46287.128712871294,94]
[null,null,95,1000,0.5,0.05,-1.6448536269514726,-0.94205728021989843,-1.8503810339790565,1,500,null,95,46534.653465346542,47029.702970297039,null,0,1,46782.178217821791,95]
[null,null,96,1000,0.5,0.05,-1.6448536269514726,-1.0584535708715215,-1.9576931116117189,1,500,null,96,47029.702970297039,47524.752475247536,null,0,1,47277.227722772288,96]
[null,null,97,1000,0.5,0.05,-1.6448536269514726,-0.42554293680925492,-1.374178338788669,0,0,null,97,47524.752475247536,48019.801980198034,null,0,1,47772.277227722785,97]
[null,null,98,1000,0.5,0.05,-1.6448536269514726,-0.54806199690908908,-1.4871353309342852,0,0,null,98,48019.801980198034,48514.851485148531,null,0,1,48267.326732673282,98]
[null,null,99,1000,0.5,0.05,-1.6448536269514726,0.25462943169625529,-0.7470903997827939,0,0,null,99,48514.851485148531,49009.900990099028,null,0,1,48762.376237623779,99]
[null,null,100,1000,0.5,0.05,-1.6448536269514726,-0.68804985805092933,-1.616197761862139,0,0,null,100,49009.900990099028,49504.950495049525,null,0,1,49257.425742574276,100]
[null,null,null,null,null,null,null,null,null,null,null,null,101,49504.950495049525,50000.000000000022,null,0,1,49752.475247524773,101]

{"sheet":"Beispiel","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["1-Faktor-Schwellwertmodell"]
["J. Lemm, 2011"]
[]
[null,null,"Systematisch",null,null,"Korrelation"]
[null,null,"M","X",null,"Rho"]
[null,null,1,{"$f":"NORMINV(RAND(),0,1)","v":-0.87858113511137936},null,0.5]
[null,null,null,null,null,null,null,null,"Min_Loss","Max_Loss","Summe"]
[null,null,"Kunden",null,null,null,null,null,0,{"$f":"SUMPRODUCT(D11:D20,E11:E20)","v":5000},{"$f":"SUM(K11:K20)","v":1500}]
[null,null,"N","EAD(T€)","LGD%","PD","Schwelle","eps_i","y_i","Ausfall","Verlust"]
[null,null,1,1000,0.5,0.1,{"$f":"NORMINV(F11,0,1)","v":-1.2815515655446006},{"$f":"NORMINV(RAND(),0,1)","v":-1.1543872057065636},{"$f":"SQRT($F$7)*$D$7+SQRT(1-$F$7)*H11","v":-1.4375256997299319},{"$f":"IF(I11<=G11,1,0)","v":1},{"$f":"J11*E11*D11","v":500}]
[null,null,2,1000,0.5,0.1,{"$f":"NORMINV(F12,0,1)","v":-1.2815515655446006},{"$f":"NORMINV(RAND(),0,1)","v":1.3202915822051136},{"$f":"SQRT($F$7)*$D$7+SQRT(1-$F$7)*H12","v":0.31233645246092123},{"$f":"IF(I12<=G12,1,0)","v":0},{"$f":"J12*E12*D12","v":0}]
[null,null,3,1000,0.5,0.1,-1.2815515655446006,0.47687239169053591,-0.28405097653480532,0,0]
[null,null,4,1000,0.5,0.1,-1.2815515655446006,-0.57339743652948438,-1.0267038941448121,0,0]
[null,null,5,1000,0.5,0.1,-1.2815515655446006,0.35766195176843024,-0.36834548699195779,0,0]
[null,null,6,1000,0.5,0.1,-1.2815515655446006,1.2501215682034328,0.26271875972437775,0,0]
[null,null,7,1000,0.5,0.1,-1.2815515655446006,-1.5986657129401387,-1.7516780449302294,1,500]
[null,null,8,1000,0.5,0.1,-1.2815515655446006,0.2502427786505142,-0.44430231273308796,0,0]
[null,null,9,1000,0.5,0.1,-1.2815515655446006,-0.70636956385871863,-1.1207293870881148,0,0]
[null,null,10,1000,0.5,0.1,-1.2815515655446006,-2.2301801290750474,-2.1982261709962865,1,500]

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