{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2017 Q3 Total","RD 2017 Q3 Cap T","RD 2017 Q3 Cap S","Repossed Properties - Year","Repossed Properties - Quarter","LTV","LTV - Sectors","LTV - Classification","3m arrears","Borrower segmentation Nordic","Borrower Exposure to Int. rate"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":2},"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":"RD 2017 Q3 Total","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2017 Q3 - Total portfolio"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",451097.71580509865,null,160245.62494683947,null,129821.64574781015,null,48165.995407870003,null,789330.98190761823]
[null," - Number of loans",411748,null,36768,null,13270,null,13858,null,475644]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",168225.2189402401,null,76738.619053719842,null,19300.622237539996,null,7429.1110496100064,null,271693.57128110994]
[null," - repayment loans",125323.02581883011,null,71179.975213569851,null,16649.514652299997,null,4759.8670023400045,null,217912.38268703994]
[null," - interest-only ",42902.193121410011,null,5558.6438401499963,null,2651.1075852399999,null,2669.2440472700009,null,53781.188594070009]
[null,"FlexLån®",246303.5022138202,null,63876.69349988996,null,40696.92627933,null,25643.29174185,null,376520.41373489011]
[null," - repayment loans",92854.655624340026,null,40032.378933959975,null,20963.447478619993,null,8040.1585262400013,null,161890.64056315998]
[null," - interest-only ",153448.84658948018,null,23844.314565929984,null,19733.478800710003,null,17603.133215609996,null,214629.77317173014]
[null,"FlexGaranti®, Rentedyk TM",15479.038882470009,null,463.93597779999993,null,232.05516565000005,null,239.68534191999996,null,16414.715367840006]
[null," - repayment loans",11747.07780242001,null,417.62813977999997,null,225.77289051000005,null,216.67425380999995,null,12607.153086520009]
[null," - interest-only ",3731.9610800499981,null,46.307838020000013,null,6.2822751400000003,null,23.011088109999999,null,3807.5622813199984]
[null,"FlexKort®",20988.248070199992,null,2444.46185767,null,2584.6338088999996,null,7854.7524423599998,null,33872.096179129992]
[null," - repayment loans",6243.339622239997,null,1256.9379033600001,null,1329.4006498899996,null,2049.7694041900013,null,10879.447579679996]
[null," - interest-only ",14744.908447959995,null,1187.5239543099997,null,1255.23315901,null,5804.9830381699985,null,22992.648599449993]
[null,"Other floating rate loans",101.70769836999999,null,16721.914557759999,null,67007.408256390016,null,6999.1548321299961,null,90830.185344650017]
[null," - repayment loans",51.071223149999994,null,4779.0468879900027,null,25887.307868740027,null,1968.5392066200002,null,32685.965186500031]
[null," - interest-only ",50.636475220000001,null,11942.867669769998,null,41120.100387649996,null,5030.6156255099968,null,58144.220158149983]
[null," Total",451097.71580510028,null,160245.62494683976,null,129821.64574781003,null,48165.995407870003,null,789330.98190761998]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",196764.80950068004,null,59680.159826890107,null,50657.234839329962,null,3509.8244689899984,null,310612.02863589016]
[null," - Other Sealand",86979.65457304017,null,16991.248546840019,null,10861.269087449999,null,13655.573080629987,null,128487.74528796018]
[null," - Region South Denmark",71395.905823830093,null,28775.559376299974,null,25501.90970091003,null,16290.531995210004,null,141963.90689625009]
[null," - Region Central Jutland",73013.62552935,null,38669.139813240014,null,19634.231133610014,null,8831.3018335400066,null,140148.29830974006]
[null," - Region North Jutland",22942.971760570024,null,13125.794379239982,null,5987.3377176299982,null,5878.7640295000047,null,47934.86788694001]
[null," - Other area",0.74861763000000003,null,3003.7230043300005,null,17179.663268880002,null,0,null,20184.134890840003]
[null,"Total",451097.71580510028,null,160245.62494684008,null,129821.64574781001,null,48165.995407870003,null,789330.98190762056]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",251563.59359787044,null,8453.5807118399953,null,3434.1906741899957,null,3241.9276332700038,null,266693.29261717043]
[null," 2 - 5",167908.16278307937,null,11799.741988520005,null,5478.7417486500026,null,6508.9093785600026,null,191695.55589880937]
[null," 5 - 20",30687.629619040003,null,45255.757398079972,null,19865.317483710005,null,15575.907597809994,null,111384.61209863996]
[null," 20 - 50",881.36183647999985,null,37399.032833860037,null,18670.227153829994,null,14637.626876249991,null,71588.248700420023]
[null," 50 - 100",56.967968630000001,null,22814.923092419998,null,16780.399293420003,null,6485.7041072100028,null,46137.994461680006]
[null," 100 and above",0,null,34522.588922119998,null,65592.769394010014,null,1715.9198147700001,null,101831.27813090001]
[null,"Total",451097.71580509981,null,160245.62494684002,null,129821.64574781003,null,48165.995407869988,null,789330.98190761986]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",27538.801221860012,null,7745.3025631199989,null,11096.564227080002,null,1254.7903375900005,null,47635.45834965002]
[null,"> 12 - ≤ 24 months",21791.189489620014,null,7010.5502577499965,null,8058.80194957,null,1406.3948993699996,null,38266.936596310014]
[null,"> 24 - ≤ 36 months",23075.29911791001,null,7143.7561929199937,null,6058.1345695699983,null,1421.5242721799998,null,37698.714152580003]
[null,"> 36 - ≤ 60 months",41359.954951300046,null,13086.045712660007,null,15656.703630510019,null,2269.5856434099996,null,72372.289937880079]
[null,"> 60 months",337332.47102440946,null,125259.9702203897,null,88951.441371080087,null,41813.700255320051,null,593357.58287119935]
[null,"Total",451097.71580509964,null,160245.62494683973,null,129821.64574781012,null,48165.995407870054,null,789330.9819076194]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",162921.20888299489,null,67338.071055597567,null,54835.149478934414,null,18520.812890977468,null,303615.24230850436]
[null,"20 - 40%",138189.12309115657,null,43671.733160320073,null,43869.451781826683,null,15731.851656173938,null,241462.15968947724]
[null,"40 - 60%",96148.702383555923,null,26963.442807181382,null,23467.300379610737,null,10217.185100450823,null,156796.63067079886]
[null,"60 - 80%",43840.762253246277,null,12526.987718382672,null,5025.2867049883853,null,2981.4566146056154,null,64374.493291222949]
[null,"> 80 %",9997.919193126485,null,9745.390205558333,null,2624.4574021697372,null,714.68914587217114,null,23082.455946726732]
[null,"Total",451097.71580408013,null,160245.62494704002,null,129821.64574752997,null,48165.995408080009,null,789330.98190672998]

{"sheet":"RD 2017 Q3 Cap T","index":1,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2017 Q3 - Capital center T"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",265744.08011337963,null,78831.287973930099,null,100757.31308803998,null,38800.23996751001,null,484132.92114285968]
[null," - Number of loans",227521,null,16986,null,8761,null,10557,null,263825]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",64.968563320000001,null,0,null,1352.5876614000001,null,0,null,1417.5562247200003]
[null," - repayment loans",12.704174079999998,null,0,null,72.120969560000006,null,0,null,84.825143640000007]
[null," - interest-only ",52.26438924,null,0,null,1280.4666918400001,null,0,null,1332.7310810800002]
[null,"FlexLån®",244610.5990429502,null,61862.86420941996,null,39185.801135360001,null,25460.20993672001,null,371119.47432445013]
[null," - repayment loans",92512.575370610095,null,39699.139086029973,null,20747.359121979996,null,7989.8396094300078,null,160948.91318805004]
[null," - interest-only ",152098.02367234009,null,22163.725123389984,null,18438.442013380001,null,17470.370327290002,null,210170.56113640009]
[null,"FlexGaranti®, Rentedyk TM",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"FlexKort®",20988.248070199992,null,2444.4618576699995,null,2584.6338088999996,null,7854.7524423600016,null,33872.096179129992]
[null," - repayment loans",6243.339622239997,null,1256.9379033600001,null,1329.4006498899998,null,2049.7694041900004,null,10879.447579679996]
[null," - interest-only ",14744.908447959995,null,1187.5239543099995,null,1255.2331590099998,null,5804.9830381700012,null,22992.648599449996]
[null,"Other floating rate loans",80.264436910000001,null,14523.961906839993,null,57634.290482379998,null,5485.2775884299999,null,77723.79441455999]
[null," - repayment loans",43.505671729999989,null,4368.9021846899977,null,22520.443568300012,null,1672.57236278,null,28605.423787500007]
[null," - interest-only ",36.758765179999997,null,10155.059722149996,null,35113.846914079986,null,3812.7052256500006,null,49118.37062705998]
[null," Total",265744.08011338022,null,78831.287973929953,null,100757.31308804,null,38800.23996751001,null,484132.92114286014]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",122181.62389894007,null,26489.50000297997,null,39637.601926729985,null,2820.6200894700005,null,191129.34591812003]
[null," - Other Sealand",50012.962997500028,null,7649.3183585799989,null,7361.8058229399994,null,11582.330328450002,null,76606.417507470032]
[null," - Region South Denmark",37988.895304659971,null,15060.061573410001,null,19638.438542080021,null,12130.138574550008,null,84817.533994700003]
[null," - Region Central Jutland",42951.156607369994,null,19784.479339300011,null,13531.443446200003,null,7347.911632499995,null,83614.991025370007]
[null," - Region North Jutland",12609.441304909997,null,7302.1106750200051,null,3737.9819509900003,null,4919.2393425399996,null,28568.773273460003]
[null," - Other area",0,null,2545.8180246400002,null,16850.041399099999,null,0,null,19395.859423739999]
[null,"Total",265744.0801133801,null,78831.287973929997,null,100757.31308804001,null,38800.239967510002,null,484132.92114286002]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",135424.42305002012,null,5292.0161705200017,null,2012.31199937,null,2103.9833916200009,null,144832.73461153012]
[null," 2 - 5",107461.58884535999,null,6111.8092834899999,null,3695.8207584800025,null,5030.7251434799964,null,122299.94403080999]
[null," 5 - 20",22182.108465130012,null,20555.982183429991,null,14029.074214559998,null,12894.647434209997,null,69661.812297330005]
[null," 20 - 50",618.99178424000002,null,16577.50350477999,null,13421.351057970003,null,11892.554901570002,null,42510.401248559989]
[null," 50 - 100",56.967968630000001,null,12053.376574689997,null,10841.029149509997,null,5273.9421902300001,null,28225.315883059993]
[null," 100 and above",0,null,18240.600257019989,null,56757.725908149972,null,1604.3869064,null,76602.713071569946]
[null,"Total",265744.0801133801,null,78831.287973929968,null,100757.31308803998,null,38800.239967510002,null,484132.92114286002]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",14374.349600770009,null,4554.0977143899991,null,7482.4672127500007,null,846.07285891999982,null,27256.987386830006]
[null,"> 12 - ≤ 24 months",13053.706277070003,null,3985.0426642300026,null,6582.7304605500021,null,1119.1001907,null,24740.57959255001]
[null,"> 24 - ≤ 36 months",10758.491057520001,null,4039.0899298500003,null,4550.2456805600004,null,1054.5613220899997,null,20402.387990020001]
[null,"> 36 - ≤ 60 months",22985.162860900004,null,9544.6616919600001,null,14398.079909760003,null,1695.3210245800003,null,48623.225487200012]
[null,"> 60 months",204572.37031711987,null,56708.395973500024,null,67743.78982441999,null,34085.184571219943,null,363109.74068625987]
[null,"Total",265744.08011337987,null,78831.287973930026,null,100757.31308804,null,38800.239967509944,null,484132.92114285991]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",95361.062952343244,null,29607.218821625771,null,44713.50847557532,null,14992.749207118148,null,184674.53945666249]
[null,"20 - 40%",81298.993667868242,null,23312.176546329709,null,34335.569692894816,null,12667.58080890273,null,151614.32071599548]
[null,"40 - 60%",57105.058397589797,null,15342.967755685853,null,17146.242710502385,null,8149.204381053275,null,97743.473244831301]
[null,"60 - 80%",25773.469234855853,null,6574.7064908819584,null,3167.099616406907,null,2398.0808485138191,null,37913.356190658538]
[null,"> 80 %",6205.4958600930913,null,3994.218359556633,null,1394.8925924405889,null,592.62472205202766,null,12187.23153414234]
[null,"Total",265744.08011275023,null,78831.287974079925,null,100757.31308782,null,38800.239967639995,null,484132.92114229017]

{"sheet":"RD 2017 Q3 Cap S","index":2,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2017 Q3 - Capital center S"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",168812.83627332008,null,51923.345969340073,null,22192.904944979982,null,8701.8035460300052,null,251630.89073367012]
[null," - Number of loans",149348,null,9551,null,3048,null,2579,null,164526]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",162511.11532605012,null,48710.293135520034,null,17483.025159509994,null,7212.366501759996,null,235916.80012284013]
[null," - repayment loans",119741.39990096007,null,43151.649295370036,null,16113.442247169993,null,4543.1224544899978,null,183549.61389799009]
[null," - interest-only ",42769.715425090028,null,5558.64384015,null,1369.5829123400001,null,2669.2440472699982,null,52367.186224850026]
[null,"FlexLån®",1692.9031708699995,null,2013.8292904699997,null,1511.12514397,null,172.06140951999998,null,5389.9190148299986]
[null," - repayment loans",342.08025372999992,null,333.23984792999994,null,216.08835664000003,null,39.298521200000003,null,930.70697949999987]
[null," - interest-only ",1350.8229171399996,null,1680.5894425399997,null,1295.0367873299999,null,132.76288831999997,null,4459.2120353299988]
[null,"FlexGaranti®, Rentedyk TM",4595.1673801300012,null,96.511364839999999,null,42.628954890000003,null,21.917357070000005,null,4756.2250569300004]
[null," - repayment loans",1816.0535697999999,null,59.713717299999999,null,36.34667975,null,13.810269630000004,null,1925.92423648]
[null," - interest-only ",2779.1138103300009,null,36.797647540000007,null,6.2822751400000003,null,8.107087439999999,null,2830.3008204500006]
[null,"FlexKort®",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"Other floating rate loans",13.65039627,null,1102.7121785100001,null,3156.1256866100002,null,1295.4582776799998,null,5567.9465390699997]
[null," - repayment loans",2.4846354100000001,null,148.97515463000002,null,860.1169814000001,null,175.2990906,null,1186.8758620399999]
[null," - interest-only ",11.165760859999999,null,953.73702388000004,null,2296.0087052100002,null,1120.1591870799998,null,4381.0706770299994]
[null," Total",168812.83627332011,null,51923.345969340036,null,22192.904944979997,null,8701.8035460299943,null,251630.89073367012]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",70420.295816610043,null,23883.337100940036,null,8901.2749818499979,null,648.62342126999977,null,103853.5313206701]
[null," - Other Sealand",32119.828263199986,null,4974.1467638100012,null,2887.3019798400005,null,1916.1271106099998,null,41897.404117459992]
[null," - Region South Denmark",29848.842480309981,null,8206.9933907499963,null,3952.4039429800009,null,3886.8533669600001,null,45895.093180999982]
[null," - Region Central Jutland",27262.521199129998,null,11654.657458499996,null,4471.8739930500005,null,1347.9911261700006,null,44737.043776849991]
[null," - Region North Jutland",9161.3485140699977,null,2952.3760910500018,null,1945.54183349,null,902.20852102000038,null,14961.474959629999]
[null," - Other area",0,null,251.83516428999999,null,34.508213770000005,null,0,null,286.34337806000002]
[null,"Total",168812.83627332002,null,51923.345969340036,null,22192.904944980004,null,8701.8035460299998,null,251630.89073367004]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",101656.20323603008,null,2128.4033363799995,null,1020.5511086600004,null,910.48518910000007,null,105715.64287017009]
[null," 2 - 5",58480.40529797005,null,4054.6670957700026,null,1625.1297238000004,null,1341.5870423399999,null,65501.789159880049]
[null," 5 - 20",8413.8576870799989,null,15706.370958740004,null,5123.8081152599998,null,2533.500260849999,null,31777.537021930002]
[null," 20 - 50",262.37005223999995,null,11586.617115279985,null,4734.1362815500006,null,2600.0705562499993,null,19183.194005319983]
[null," 50 - 100",0,null,6904.7988241600024,null,4520.7252375700009,null,1205.4393710500001,null,12630.963432780003]
[null," 100 and above",0,null,11542.48863901,null,5168.5544781400004,null,110.72112643999999,null,16821.764243590002]
[null,"Total",168812.83627332011,null,51923.345969339993,null,22192.90494498,null,8701.8035460299998,null,251630.89073367009]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",13130.534964659993,null,3133.8886172099992,null,3163.478899780001,null,408.71747866999999,null,19836.619960319993]
[null,"> 12 - ≤ 24 months",8707.3366029400022,null,2975.5850158600001,null,1232.5522192799999,null,285.60053658000004,null,13201.074374660004]
[null,"> 24 - ≤ 36 months",12290.147455800006,null,3032.8104912200001,null,1493.8536227099996,null,362.2856498299999,null,17179.097219560008]
[null,"> 36 - ≤ 60 months",18274.869428549995,null,3358.5325885700026,null,1185.1311306800001,null,549.90664516999993,null,23368.439792969999]
[null,"> 60 months",116409.94782137002,null,39422.529256479997,null,15117.889072529997,null,7095.2932357800028,null,178045.65938616003]
[null,"Total",168812.83627332002,null,51923.345969339993,null,22192.904944979997,null,8701.8035460300034,null,251630.89073367004]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",59680.469584569473,null,24687.722929373624,null,8155.2586084279892,null,3128.7288918658069,null,95652.180014236888]
[null,"20 - 40%",52156.55758825651,null,13079.402693699381,null,7483.9339889529001,null,2890.8890836695464,null,75610.783354578336]
[null,"40 - 60%",36593.214031939424,null,7334.0559090807383,null,4926.3302549760929,null,2011.5316769019996,null,50865.131872898251]
[null,"60 - 80%",17084.809644173594,null,3341.0484347273841,null,1136.7585226175931,null,556.36999965813413,null,22118.986601176704]
[null,"> 80 %",3297.7854239909243,null,3481.1160027088117,null,490.62356992542772,null,114.2838940145127,null,7383.8088906396761]
[null,"Total",168812.83627292994,null,51923.345969589944,null,22192.904944900001,null,8701.8035461100008,null,251630.89073352987]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"End year","Stock","Repossed in year"]
[null,1986,471,933]
[null,1987,630,1238]
[null,1988,1562,2797]
[null,1989,2654,4209]
[null,1990,3201,4213]
[null,1991,2463,3950]
[null,1992,2331,3441]
[null,1993,1720,3264]
[null,1994,732,1479]
[null,1995,215,572]
[null,1996,97,265]
[null,1997,32,198]
[null,1998,24,107]
[null,1999,15,87]
[null,2000,28,109]
[null,2001,54,117]
[null,2002,51,169]
[null,2003,51,158]
[null,2004,26,101]
[null,2005,13,47]
[null,2006,1,16]
[null,2007,4,6]
[null,2008,23,46]
[null,2009,37,58]
[null,2010,164,235]
[null,2011,161,217]
[null,2012,156,198]
[null,2013,122,164]
[null,2014,70,108]
[null,2015,58,78]
[null,2016,51,81]
[null,"2017*",34,43]
[]
[null,"*2017Q3"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Quarter","Homeowner Segment","Corporate Segments","Total"]
[null,"2002 Q4",45,6,{"$f":"C5+D5","v":51}]
[null,"2003 Q1",48,7,{"$f":"C6+D6","v":55}]
[null,"2003 Q2",59,5,64]
[null,"2003 Q3",64,5,69]
[null,"2003 Q4",46,5,51]
[null,"2004 Q1",49,5,54]
[null,"2004 Q2",41,5,46]
[null,"2004 Q3",26,3,29]
[null,"2004 Q4",24,2,26]
[null,"2005 Q1",20,3,23]
[null,"2005 Q2",15,3,18]
[null,"2005 Q3",10,3,13]
[null,"2005 Q4",10,3,13]
[null,"2006 Q1",6,1,7]
[null,"2006 Q2",5,0,5]
[null,"2006 Q3",0,0,0]
[null,"2006 Q4",1,0,1]
[null,"2007 Q1",0,0,0]
[null,"2007 Q2",0,0,0]
[null,"2007 Q3",1,0,1]
[null,"2007 Q4",4,0,4]
[null,"2008 Q1",4,0,4]
[null,"2008 Q2",8,0,8]
[null,"2008 Q3",12,1,13]
[null,"2008 Q4",20,3,23]
[null,"2009 Q1",26,1,27]
[null,"2009 Q2",27,1,28]
[null,"2009 Q3",24,2,26]
[null,"2009 Q4",30,7,37]
[null,"2010 Q1",61,20,81]
[null,"2010 Q2",87,27,114]
[null,"2010 Q3",113,32,145]
[null,"2010 Q4",133,31,164]
[null,"2011 Q1",140,39,{"$f":"C38+D38","v":179}]
[null,"2011 Q2",130,34,{"$f":"C39+D39","v":164}]
[null,"2011 Q3",116,37,153]
[null,"2011 Q4",118,43,161]
[null,"2012 Q1",118,48,166]
[null,"2012 Q2",135,51,186]
[null,"2012 Q3",115,42,157]
[null,"2012 Q4",109,47,156]
[null,"2013 Q1",109,40,149]
[null,"2013 Q2",109,29,138]
[null,"2013 Q3",96,32,128]
[null,"2013 Q4",96,26,122]
[null,"2014 Q1",91,16,107]
[null,"2014 Q2",72,19,91]
[null,"2014 Q3",57,14,71]
[null,"2014 Q4",56,14,{"$f":"C53+D53","v":70}]
[null,"2015 Q1",53,14,67]
[null,"2015 Q2",55,12,{"$f":"C55+D55","v":67}]
[null,"2015 Q3",56,13,{"$f":"C56+D56","v":69}]
[null,"2015 Q4",45,13,58]
[null,"2016 Q1",47,10,57]
[null,"2016 Q2",44,12,{"$f":"C59+D59","v":56}]
[null,"2016 Q3",41,15,{"$f":"C60+D60","v":56}]
[null,"2016 Q4",38,13,{"$f":"C61+D61","v":51}]
[null,"2017 Q1",41,9,{"$f":"C62+D62","v":50}]
[null,"2017 Q2",36,9,{"$f":"C63+D63","v":45}]
[null,"2017 Q3",30,7,{"$f":"C64+D64","v":37}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":52,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Loan to value %","2005 Q2","2005 Q3","2005 Q4","2006 Q1","2006 Q2","2006 Q3","2006 Q4","2007 Q1","2007 Q2","2007 Q3","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"Private",64.97,65.47,62.75,61.55,59.06,58.73,56.28,57.15,56.02,56.58,57.84,59.3,57.14,60.13,66.03,67.569999999999993,69.23,71.959999999999994,72.38,70.58,72.23,70.98,70.599999999999994,68.52,70.45,72.83,76.209999999999994,75.959999999999994,73.59,72.099999999999994,72.989999999999995,74.52,72.7,73.37,72.400000000000006,73.244,72.239999999999995,72.575999999999993,72.349999999999994,72.150000000000006,69.239999999999995,67.185000000000002,66.164000000000001,67,66.48,65.734999999999999,64.723202000000001,64.628,64.430000000000007,63.746000000000002]
[null,"Commercial",53.51,54.3,48.54,50.65,51.63,49.59,49,49.02,49.09,45.89,47.15,48.46,48.04,54.46,54.78,54.31,59.27,62.88,65.5,62.25,61.09,61.45,62.52,60.69,64.89,60.06,64.209999999999994,63.93,62.81,59.64,60.21,63.78,59.46,59.81,59.4,58.201000000000001,59.31,59.878,60.38,60.5,57.84,58.116999999999997,57.783000000000001,57.8,54.93,56.378999999999998,55.373230999999997,54.387,53,52.76]
[null,"Agriculture",59.45,58.76,56.45,56.1,55.16,53.87,51.21,52.33,52.31,51.76,53.22,52.13,51.31,54.91,49.92,53.32,57.56,59.24,61.03,59.03,60.92,60.43,61.94,60.21,60.49,61.62,61.43,60.4,63.42,63.17,63.71,64,63.18,63.14,64.2,59.475999999999999,60.07,59.557000000000002,59.78,58.63,58.7,58.494999999999997,58.84,58.3,57.59,59.05,58.872926,59.094000000000001,59.28,58.594000000000001]
[null,"Rental residential",94,96.46,68.72,62.18,61.5,62.66,59.74,60.99,59.82,56.41,57.98,58.79,61.47,63.05,66.13,67.87,71.83,76.05,76.02,74.87,76.510000000000005,78.48,74.41,74.11,73.63,75.59,79.3,79.540000000000006,77.67,85.24,84.34,79.930000000000007,80.739999999999995,77.16,78.400000000000006,75.965999999999994,78.180000000000007,76.644000000000005,78.349999999999994,75.760000000000005,74.37,74.665000000000006,71.064999999999998,71.61,70.61,70.709000000000003,70.689116999999996,68.769000000000005,69.680000000000007,67.759]
[null,"Total",69.260000000000005,70.3,62.09,60.27,58.53,58.27,55.91,56.8,55.83,55.12,56.33,57.42,56.42,59.53,63.26,64.64,67.38,70.44,71.23,69.34,70.55,70.19,69.47,67.8,69.489999999999995,70.61,73.930000000000007,73.72,71.989999999999995,72.040000000000006,72.47,73.12,71.73,71.44,71.099999999999994,70.578999999999994,70.66,70.62,70.91,70.25,67.87,66.759,65.433000000000007,65.87,65,64.956000000000003,64.221069999999997,63.621000000000002,63.51,62.624000000000002]

{"sheet":"LTV - Sectors","index":6,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,12]]}
[]
[]
[]
[null,"Realkredit Danmark 2017 Q3"]
[null,null," "]
[]
[null,"DKK billion ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Weighted distribution",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",162.9212088829949,null,67.338071055597567,null,54.835149478934419,null,18.520812890977467,null,0.38464883460558313,null,303.61524230850438]
[null," - 20-40%",138.18912309115655,null,43.671733160320073,null,43.869451781826683,null,15.731851656173939,null,0.30590736360834897,null,241.46215968947723]
[null," - 40-60%",96.148702383555928,null,26.96344280718138,null,23.467300379610737,null,10.217185100450823,null,0.19864497183682883,null,156.79663067079886]
[null," - 60-80%",43.840762253246275,null,12.526987718382671,null,5.0252867049883854,null,2.9814566146056154,null,8.1555766550196862E-2,null,64.374493291222947]
[null," - >80%",9.997919193126485,null,9.7453902055583317,null,2.6244574021697376,null,0.71468914587217114,null,2.9243063399042181E-2,null,23.082455946726725]
[null,"Total",451.09771580408017,null,160.24562494704,null,129.82164574752997,null,48.165995408080015,null,1,null,789.33098190673013]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",95.361062952343246,null,29.607218821625771,null,44.713508475575317,null,14.992749207118147,null,0.38145420687552301,null,184.67453945666247]
[null," - 20-40%",81.298993667868245,null,23.312176546329709,null,34.335569692894815,null,12.667580808902731,null,0.31316672363091563,null,151.61432071599549]
[null," - 40-60%",57.105058397589801,null,15.342967755685853,null,17.146242710502385,null,8.1492043810532753,null,0.20189387867738864,null,97.743473244831321]
[null," - 60-80%",25.773469234855853,null,6.5747064908819581,null,3.1670996164069067,null,2.3980808485138194,null,7.8311873733361584E-2,null,37.91335619065854]
[null," - >80%",6.205495860093091,null,3.994218359556633,null,1.3948925924405891,null,0.59262472205202765,null,2.5173317082810866E-2,null,12.187231534142342]
[null,"Total",265.74408011275023,null,78.831287974079927,null,100.75731308782001,null,38.800239967640003,null,0.99999999999999967,null,484.13292114229012]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",59.680469584569472,null,24.687722929373624,null,8.1552586084279888,null,3.1287288918658072,null,0.38012892509103702,null,95.65218001423689]
[null," - 20-40%",52.156557588256511,null,13.079402693699381,null,7.4839339889528995,null,2.8908890836695464,null,0.30048291421679252,null,75.610783354578345]
[null," - 40-60%",36.593214031939425,null,7.334055909080738,null,4.9263302549760937,null,2.0115316769019995,null,0.20214184246068193,null,50.86513187289826]
[null," - 60-80%",17.084809644173593,null,3.3410484347273841,null,1.1367585226175931,null,0.55636999965813405,null,8.7902508856116945E-2,null,22.118986601176704]
[null," - >80%",3.2977854239909243,null,3.4811160027088119,null,0.49062356992542772,null,0.11428389401451271,null,2.9343809375371666E-2,null,7.3838088906396768]
[null,"Total",168.81283627292993,null,51.923345969589938,null,22.192904944900004,null,8.7018035461099998,null,1,null,251.63089073352987]

{"sheet":"LTV - Classification","index":7,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,8]]}
[]
[]
[]
[null,"Realkredit Danmark 2017 Q3"]
[null,null," "]
[]
[null,"DKK billion ","Classification 1-3",null,"Classification 4-7",null,"Classification 8-11",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",77.663812975245463,null,211.92587146205062,null,14.025557871208216,null,303.61524230850432]
[null," - 20-40%",51.625562843237965,null,176.76150198428022,null,13.075094861958963,null,241.46215968947715]
[null," - 40-60%",28.55582446532032,null,117.55894743349565,null,10.681858771982943,null,156.79663067079892]
[null," - 60-80%",11.241563224255721,null,47.144871815143752,null,5.9880582518235608,null,64.374493291223033]
[null," - >80%",6.0174082405528528,null,13.270517657570684,null,3.7945300486031894,null,23.082455946726725]
[null,"Total",175.10417174861229,null,566.66171035254104,null,47.565099805576878,null,789.33098190673024]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",41.858989271200151,null,132.31691411941136,null,10.498636066050846,null,184.67453945666236]
[null," - 20-40%",28.391330531670008,null,113.3617235529763,null,9.8612666313492436,null,151.61432071599555]
[null," - 40-60%",15.579798502645867,null,74.14475532606059,null,8.0189194161248167,null,97.743473244831279]
[null," - 60-80%",5.7279230151227232,null,27.762379386911366,null,4.4230537886244097,null,37.913356190658497]
[null," - >80%",2.7648180583097854,null,6.7233359709739631,null,2.6990775048585989,null,12.187231534142347]
[null,"Total",94.32285937894855,null,354.30910835633358,null,35.500953407007913,null,484.13292114229006]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",24.654287270206883,null,68.356098675248603,null,2.6417940687814414,null,95.652180014236919]
[null," - 20-40%",16.838303850769467,null,56.192345597077619,null,2.5801339067312887,null,75.610783354578373]
[null," - 40-60%",9.3668278166531831,null,39.262463033575656,null,2.2358410226694869,null,50.865131872898331]
[null," - 60-80%",3.3276409523896504,null,17.502523422737433,null,1.2888222260496316,null,22.118986601176715]
[null," - >80%",1.3232801625045658,null,5.2456614845113769,null,0.81486724362373464,null,7.3838088906396777]
[null,"Total",55.510340052523752,null,186.55909221315068,null,9.5614584678555836,null,251.63089073353001]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":42,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"Private",0.15656218014927964,0.17622091059825712,0.21226328148524881,0.23504379286900098,0.34621659433492169,0.48567081299722087,0.63763978533718857,0.70915120590311731,0.78891781003792383,0.884183102468585,0.66014775406359882,0.57160041949894835,0.55422562049590962,0.49518388603850316,0.49110552801689522,0.6619027318422005,0.4648789078035972,0.46832181852500976,0.43548524598554395,0.42244695436316571,0.43178507225390916,0.4489009708773069,0.42524190317220628,0.34556169541261328,0.39486932956755244,0.39165920483661149,0.38089192955661699,0.31589258394518216,0.30406651058489231,0.30220907955598109,0.31330024963699726,0.2642695530501542,0.28144963972229237,0.26251829878317595,0.27048180491465101,0.27092701552282933,0.29635580051520782,0.28999999999999998,0.3,0.27]
[null,"Commercial",0.14755295177431865,8.6561935281377345E-2,0.1302500765064474,0.19974043569052896,0.31830955393429977,0.45037133694297959,1.1985979832481644,1.5621732902413716,2.5952748166498667,1.523145417237034,1.7759759291753354,1.6899327680265703,1.4822631479958117,1.0176578563538299,1.6925160102921666,1.3822367058417195,1.2855621410685494,1.2198105515838669,1.0692050316506838,1.0873151068240114,1.2748021933757456,1.0704785438655486,1.1414629242385435,1.1262714491262065,0.99763191702061105,1.0855713883277764,0.91804284337792474,0.84431163831617229,0.89993952488976359,1.3313241780657834,1.7008584999681573,0.96409495539694856,1.0269371879108964,1.0999113706925037,0.93180996923328352,0.92435286165055541,1.2090339917170199,0.97,0.74,0.71]
[null,"Agriculture",0.16492939721116656,0.16352636059288203,0.18131578827259506,0.18585644226829021,0.29156621157097973,0.33372263690950654,0.6566990574356345,1.0562629456645494,1.0257603538302378,1.6219284518633401,1.3613901254075007,1.3102129459712726,0.93905113371874971,1.1799230483352952,1.6199597092132287,1.5673729058140449,1.3765609345047594,1.4478763731756665,1.6000588751467346,2.0190195305098846,1.7009234277787137,1.5152123905496004,1.4393100918431909,1.2379810635040327,1.2534017927207908,1.4422602051639715,1.1279391584469076,0.9218002510970208,1.1901637995616265,0.95794405873716559,1.3614154268775058,1.4843503432483875,1.3626687376114672,1.754021390291743,2.0350763958207363,2.0258747749073289,1.4581695282698581,1.38,1.18,0.8]
[null,"Rental Residential",0.10881653835393289,7.2900290215380664E-2,0.20464014665077832,0.16571449515978301,0.67866484831018647,0.72076484713388633,2.4415707119300158,1.0415567313575762,3.1518579850978306,1.2613760651035448,1.9114554979658624,0.9980525218506836,1.5838617600771265,0.8097837561888761,1.2452133108466987,0.58315400331599609,0.827580373339592,1.094845259395181,1.2689464300675897,1.1091723102862634,1.3479556446765679,1.2856214843013938,1.4062204663942004,1.2159326565244508,1.0565290633750315,1.4551837062387438,0.65298416819966598,0.69949155353057135,0.62912291933402753,0.35436787495800426,0.39745870096644126,0.23296917886124544,0.43297702935824278,0.19531119152575055,0.23189962105621692,0.13492304160070345,0.20693631147950448,0.14000000000000001,0.21,0.09]
[null,"Total",0.14463063189580319,0.11360534965430442,0.18768779885976775,0.19728265752607319,0.4071896442411998,0.54574819260952367,1.1867057540503803,1.0427039051559712,1.7800927570175831,1.237627901612,1.2810736250868875,1.0071306927190868,1.0553341596738197,0.79360601023521704,1.0642564682134805,0.83359709968849593,0.83451995720702687,0.95372864815735314,0.90078809963093975,0.9399593444498533,0.97752861418901849,0.99680059202279458,0.93819550317166944,0.91259386488129202,0.7854081252307219,1.0557314295752029,0.64873671370510011,0.61802120893024015,0.61208062629723725,0.58280097381845619,0.76463115148218486,0.48189249819686247,0.58706260481597794,0.52098721825771332,0.57290758656015295,0.48564694492417804,0.58374279409140806,0.46,0.45,0.34]

{"sheet":"Borrower segmentation Nordic","index":9,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":true,"merged":[[22,4,22,5],[29,4,29,5],[36,4,36,5],[43,4,43,5]]}
[null,null,null,null,"Værdier"]
[null,null,"kapcenter","sektor4","Sum af kormar","Sum af kormar_non_Nordic"]
[{"$f":"B3&\"-\"&D3","v":"S-Boligudl"},{"$f":"IF(C3=\"\",B2,C3)","v":"S"},"S","Boligudl",51923345969.340073,51671510805.050072]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",22192904944.980007,22158396731.210011]
["S-Landbrug","S",null,"Landbrug",8701803546.0299988,8701803546.0299988]
["S-Privat","S",null,"Privat",168812836273.3197,168812836273.3197]
["S Total-","S Total","S Total",null,251630890733.6698,251344547355.6098]
["T-Boligudl","T","T","Boligudl",78831287973.930099,76285469949.289978]
["T-Erhverv","T",null,"Erhverv",100757313088.04012,83907271688.940079]
["T-Landbrug","T",null,"Landbrug",38800239967.510033,38800239967.510033]
["T-Privat","T",null,"Privat",265744080113.38013,265744080113.38013]
["T Total-","T Total","T Total",null,484132921142.86035,464737061719.12024]
["Ø-Boligudl","Ø","Ø","Boligudl",29490991003.569984,29287220684.219986]
["Ø-Erhverv","Ø",null,"Erhverv",6871427714.7900028,6576314058.7800026]
["Ø-Landbrug","Ø",null,"Landbrug",663951894.33000016,663951894.33000016]
["Ø-Privat","Ø",null,"Privat",16540799418.399984,16540799418.399984]
["Ø Total-","Ø Total","Ø Total",null,53567170031.089973,53068286055.729973]
["Grand Total-","Grand Total","Grand Total",null,789330981907.62012,769149895130.45996]
[]
[]
[]
[]
[null,null,null,null,"Kapcenter T"]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D24","v":"T-Privat"},"Privat","Private",{"$f":"VLOOKUP(C24,$A$3:$F$18,6,FALSE)","v":265744080113.38013}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":76285469949.289978}]
[null,null,"T-Erhverv","Erhverv","Commercial",83907271688.940079]
[null,null,"T-Landbrug","Landbrug","Agriculture",38800239967.510033]
[null,null,{"$f":"RIGHT($E$23,1)&\" \"&D28","v":"T Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C28,$A$3:$F$18,5,FALSE)-SUM(F24:F27)","v":19395859423.740173}]
[]
[null,null,null,null,"Kapcenter S"]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D31","v":"S-Privat"},"Privat","Private",{"$f":"VLOOKUP(C31,$A$3:$F$18,6,FALSE)","v":168812836273.3197}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":51671510805.050072}]
[null,null,"S-Erhverv","Erhverv","Commercial",22158396731.210011]
[null,null,"S-Landbrug","Landbrug","Agriculture",8701803546.0299988]
[null,null,{"$f":"RIGHT($E$30,1)&\" \"&D35","v":"S Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C35,$A$3:$F$18,5,FALSE)-SUM(F31:F34)","v":286343378.05999756}]
[]
[null,null,null,null,"Kapcenter Ø"]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D38","v":"Ø-Privat"},"Privat","Private",{"$f":"VLOOKUP(C38,$A$3:$F$18,6,FALSE)","v":16540799418.399984}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":29287220684.219986}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6576314058.7800026]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",663951894.33000016]
[null,null,{"$f":"RIGHT($E$37,1)&\" \"&D42","v":"Ø Total-"},"Total-","Nordic",{"$f":"VLOOKUP(C42,$A$3:$F$18,5,FALSE)-SUM(F38:F41)","v":498883975.35999298}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":451097715805.09979}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":157244201438.56006}]
[null,null,null,null,"Commercial",112641982478.93008]
[null,null,null,null,"Agriculture",48165995407.870033]
[null,null,null,null,"Nordic",20181086777.160164]

{"sheet":"Borrower Exposure to Int. rate","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
["Sum af kormar",null,"sektor2"]
["afdr_fri","prodtyp2","Privat","Erhverv"]
["J","CapFloat",3731961080.0500002,75601201.280000001]
[null,"F1",23640676469.5,8622905010.0900002]
[null,"F3",41164914847.559998,9952993461.1499996]
[null,"F5",74473401582.210007,23976915856.009998]
[null,"Fixed",42902193121.459999,10878995472.58]
[null,"Floaters",14795544923.219999,66341323834.639999]
[null,"Øv. flex",14169853690.18,18628112255.029999]
["J Total",null,214878545714.17999,138476847090.78]
["N","CapFloat",11747077802.459999,860075284.03999996]
[null,"F1",15249386770.049999,8392321904.1199999]
[null,"F3",24425704958.779999,9425101852.9699993]
[null,"F5",48302818614.389999,43482267879.279999]
[null,"Fixed",125323025818.72,92589356868.320007]
[null,"Floaters",6294410845.2799997,37271001920.839996]
[null,"Øv. flex",4876745281,7736293302.4499998]
["N Total",null,236219170090.67999,199756419012.02002]