{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2018 Q3 Total","RD 2018 Q3 Cap T","RD 2018 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 2018 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 2018 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",457888.8869985108,null,165910.81799636994,null,126471.03103947012,null,47134.992667140032,null,797405.72870149079]
[null," - Number of loans",407060,null,35790,null,12451,null,13482,null,468783]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",173388.17081720996,null,76839.751889020015,null,19810.870661849989,null,8665.95637351,null,278704.74974158994]
[null," - repayment loans",127101.36334578996,null,70382.246430380023,null,18378.145296409988,null,5468.7524418300009,null,221330.50751440995]
[null," - interest-only ",46286.80747141999,null,6457.5054586399992,null,1432.7253654400006,null,3197.2039316799992,null,57374.242227179995]
[null,"FlexLån®",250241.4609881599,null,69642.90172268993,null,34305.218474289992,null,25308.47872789,null,379498.05991302984]
[null," - repayment loans",103666.56325202991,null,45553.082377079947,null,19905.600542569988,null,8554.641115819999,null,177679.88728749985]
[null," - interest-only ",146574.89773612999,null,24089.81934560998,null,14399.61793172,null,16753.837612070001,null,201818.17262552999]
[null,"FlexGaranti®, Rentedyk TM",13140.672810020003,null,401.50942766000009,null,202.26317541999998,null,200.60021762999995,null,13945.045630730006]
[null," - repayment loans",10555.935800030005,null,376.51783345000013,null,202.26317541999998,null,193.17788233999994,null,11327.894691240006]
[null," - interest-only ",2584.7370099900008,null,24.991594209999999,null,0,null,7.4223352900000004,null,2617.1509394900008]
[null,"FlexKort®",21039.933651849999,null,2251.7406227000006,null,2270.8176780900003,null,7695.7357776100007,null,33258.227730250001]
[null," - repayment loans",6171.0721971400017,null,1182.5455354400003,null,1425.2310836299998,null,2168.3410823399986,null,10947.189898549999]
[null," - interest-only ",14868.861454709999,null,1069.1950872600003,null,845.58659446000013,null,5527.3946952700016,null,22311.0378317]
[null,"Other floating rate loans",78.648731269999999,null,16774.914334300003,null,69881.861049819985,null,5264.2215704999999,null,91999.645685889991]
[null," - repayment loans",48.740144759999993,null,6207.6622596000034,null,33193.942975809987,null,2068.8484119299997,null,41519.193792099992]
[null," - interest-only ",29.908586510000006,null,10567.252074699998,null,36687.918074010006,null,3195.3731585700002,null,50480.451893789999]
[null," Total",457888.88699850993,null,165910.81799636999,null,126471.03103946998,null,47134.992667140003,null,797405.72870148986]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",204467.71144828983,null,64403.401003190069,null,51207.114587210002,null,3501.2329768799991,null,323579.46001556987]
[null," - Other Sealand",86994.208128289771,null,16905.687316979991,null,10416.421641409994,null,13084.662470619998,null,127400.97955729974]
[null," - Region South Denmark",71460.866624509988,null,29045.392931590017,null,24021.278251220021,null,16272.588455360003,null,140800.12626268002]
[null," - Region Central Jutland",72496.808638549934,null,39587.530852260046,null,18764.621755169988,null,8702.4381795500067,null,139551.39942552996]
[null," - Region North Jutland",22468.684252999989,null,12802.00931543998,null,5658.1399514700033,null,5574.0705847299978,null,46502.904104639973]
[null," - Other area",0.60790586999999985,null,3166.7965769099997,null,16403.454852989995,null,0,null,19570.859335769997]
[null,"Total",457888.88699850952,null,165910.81799637008,null,126471.03103946999,null,47134.992667140003,null,797405.72870148963]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",247163.92487846038,null,7919.5537378099989,null,3187.5881345999978,null,3136.3033865799957,null,261407.37013745037]
[null," 2 - 5",175913.28243576005,null,11165.553443279983,null,5018.3846052499921,null,6357.0408706199996,null,198454.26135491004]
[null," 5 - 20",33680.249610179977,null,44878.885087349925,null,18950.431998189972,null,15481.884180739988,null,112991.45087645987]
[null," 20 - 50",1022.9790934699998,null,38433.317773789982,null,18149.355741139996,null,14205.244350020004,null,71810.89695841998]
[null," 50 - 100",108.45098064,null,24763.849525639984,null,14787.603919529987,null,6232.3106675200033,null,45892.215093329971]
[null," 100 and above",0,null,38749.658428499999,null,66377.666640760013,null,1722.2092116600004,null,106849.53428092001]
[null,"Total",457888.88699851045,null,165910.81799636988,null,126471.03103946998,null,47134.992667140003,null,797405.72870149021]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",26905.459721440013,null,9540.2718294199949,null,6473.2333431400002,null,1268.4541234699998,null,44187.419017470012]
[null,"> 12 - ≤ 24 months",26158.946623839995,null,7661.3465880599933,null,9870.1403972499938,null,1556.9230461900006,null,45247.356655339987]
[null,"> 24 - ≤ 36 months",21477.43408569002,null,7238.2562941800024,null,7006.2289123200007,null,1377.4257620499998,null,37099.345054240031]
[null,"> 36 - ≤ 60 months",40531.978612649938,null,13146.982734310004,null,14202.735132519991,null,2607.9446537499989,null,70489.641133229932]
[null,"> 60 months",342815.06795489037,null,128323.96055040015,null,88918.69325423993,null,40324.245081680107,null,600381.96684121061]
[null,"Total",457888.8869985104,null,165910.81799637014,null,126471.0310394699,null,47134.992667140104,null,797405.72870149044]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",170805.70333503958,null,70129.770966406097,null,54118.521134294693,null,18703.041328431442,null,313757.03676417179]
[null,"20 - 40%",143565.52243998932,null,45197.298278882394,null,43932.986016961069,null,15529.151953198882,null,248224.95868903166]
[null,"40 - 60%",96594.164939670169,null,27768.545034857118,null,22628.799630306352,null,9751.5814102302829,null,156743.09101506392]
[null,"60 - 80%",39902.727840603904,null,12972.6077509026,null,3860.1338013284103,null,2617.1505151586762,null,59352.61990799359]
[null,"> 80 %",7020.7684429467554,null,9842.5959650017903,null,1930.5904568393901,null,534.06746052073436,null,19328.02232530867]
[null,"Total",457888.88699824974,null,165910.81799605,null,126471.03103972992,null,47134.99266754002,null,797405.72870156972]

{"sheet":"RD 2018 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 2018 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",270330.64487569046,null,83555.511132710177,null,100789.29091160992,null,38067.159525800016,null,492742.60644581052]
[null," - Number of loans",225832,null,16391,null,8405,null,10383,null,261011]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",10.378567760000001,null,0,null,0,null,4.5536196900000006,null,14.932187450000001]
[null," - repayment loans",5.1695450799999998,null,0,null,0,null,4.5536196900000006,null,9.7231647700000003]
[null," - interest-only ",5.2090226800000012,null,0,null,0,null,0,null,5.2090226800000012]
[null,"FlexLån®",249208.45316338009,null,65377.649121149916,null,33637.220441140009,null,25217.108125840001,null,373440.43085151003]
[null," - repayment loans",103457.10976113006,null,42186.893751129937,null,19748.020996140011,null,8514.6441632400038,null,173906.66867164001]
[null," - interest-only ",145751.34340225003,null,23190.755370019982,null,13889.199445,null,16702.463962599995,null,199533.76217987001]
[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®",21039.933651849999,null,2251.7406226999997,null,2270.8176780900003,null,7695.7357776100025,null,33258.227730250001]
[null," - repayment loans",6171.0721971400017,null,1182.5455354399999,null,1425.2310836300003,null,2168.3410823400004,null,10947.189898550001]
[null," - interest-only ",14868.861454709999,null,1069.1950872600003,null,845.5865944599999,null,5527.3946952700016,null,22311.0378317]
[null,"Other floating rate loans",71.8794927,null,15926.121388860005,null,64881.252792380023,null,5149.7620026599989,null,86029.0156766]
[null," - repayment loans",41.970906190000001,null,5419.9963195500022,null,29999.198783150005,null,1954.38884409,null,37415.55485298]
[null," - interest-only ",29.908586510000006,null,10506.125069310001,null,34882.054009230014,null,3195.3731585699993,null,48613.460823620007]
[null," Total",270330.64487569011,null,83555.511132709915,null,100789.29091161003,null,38067.159525799994,null,492742.60644581006]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",126682.26427961999,null,30148.184890799988,null,41859.790864229995,null,2758.6190220599988,null,201448.85905670997]
[null," - Other Sealand",49949.999929880018,null,7716.6465529099978,null,7503.9111674100013,null,10979.03812374,null,76149.595773940018]
[null," - Region South Denmark",38576.657828899988,null,15142.243932359988,null,18719.038848180011,null,12566.831169239998,null,85004.771778679991]
[null," - Region Central Jutland",42677.360896680002,null,20464.893458580009,null,13265.435726320005,null,7170.1552772500008,null,83577.845358830018]
[null," - Region North Jutland",12444.361940609997,null,7119.7287532000055,null,3329.2350045000007,null,4592.5159335100007,null,27485.84163182]
[null," - Other area",0,null,2963.8135448600001,null,16111.879300970004,null,0,null,19075.692845830003]
[null,"Total",270330.64487568999,null,83555.511132710002,null,100789.29091161002,null,38067.159525799994,null,492742.60644581]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",134549.07843502008,null,4855.133684950003,null,1915.6765372999996,null,2053.6241114300014,null,143373.51276870008]
[null," 2 - 5",111206.13906225991,null,5669.9912734900026,null,3453.7782384699995,null,5011.7072061100007,null,125341.61578032993]
[null," 5 - 20",23792.770423149996,null,20424.599039660003,null,13561.252647309999,null,13018.196951860009,null,70796.819061980015]
[null," 20 - 50",719.09466036000003,null,17679.473871119993,null,12877.746936450007,null,11529.007137599994,null,42805.322605529997]
[null," 50 - 100",63.562294899999998,null,12997.838221390008,null,10701.111141639996,null,4918.2416543899999,null,28680.753312320001]
[null," 100 and above",0,null,21928.475042099988,null,58279.725410439991,null,1536.38246441,null,81744.582916949978]
[null,"Total",270330.64487568999,null,83555.511132709988,null,100789.29091160999,null,38067.159525800009,null,492742.60644581006]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",15514.345228349996,null,6873.1141947600008,null,5200.3061248700005,null,974.48701246999974,null,28562.252560449997]
[null,"> 12 - ≤ 24 months",13341.295209059997,null,4612.7253510500032,null,7624.6145442599991,null,1082.2388323900002,null,26660.873936759999]
[null,"> 24 - ≤ 36 months",12865.001273360007,null,3887.1564076799982,null,5665.1117738899993,null,1036.0431025200003,null,23453.312557450005]
[null,"> 36 - ≤ 60 months",21671.721365739995,null,8446.1488902300025,null,12211.009904190003,null,2020.0287249400003,null,44348.908885100005]
[null,"> 60 months",206938.28179918017,null,59736.36628899003,null,70088.248564400055,null,32954.361853479953,null,369717.25850605016]
[null,"Total",270330.64487569017,null,83555.511132710031,null,100789.29091161006,null,38067.159525799951,null,492742.60644581018]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",100848.0810669639,null,31821.727969249103,null,44980.946806671309,null,15286.404543915878,null,192937.16038680021]
[null,"20 - 40%",85298.965111011028,null,24734.379911993146,null,34801.781369336793,null,12545.487718529093,null,157380.61411087005]
[null,"40 - 60%",57398.50666736094,null,16147.957462976181,null,17039.498183261887,null,7729.4537129104719,null,98315.416026509498]
[null,"60 - 80%",22587.739425184693,null,6917.1671771964338,null,2793.8197421735849,null,2072.0024881518607,null,34370.728832706576]
[null,"> 80 %",4197.35260488944,null,3934.2786112052195,null,1173.2448103264139,null,433.81106275267319,null,9738.6870891737453]
[null,"Total",270330.64487540995,null,83555.511132620071,null,100789.29091176999,null,38067.159526259973,null,492742.60644606012]

{"sheet":"RD 2018 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 2018 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",174092.1304160099,null,51139.386609120018,null,20217.441631119993,null,8633.0660722799985,null,254082.02472852991]
[null," - Number of loans",152075,null,9803,null,2876,null,2548,null,167302]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",169060.37875174993,null,49920.734264479994,null,19510.501094979976,null,8528.4332605299969,null,247020.04737173993]
[null," - repayment loans",122814.01049443995,null,43463.228805839994,null,18077.775729539979,null,5331.2293288499986,null,189686.24435866997]
[null," - interest-only ",46246.368257309987,null,6457.5054586400001,null,1432.7253654400004,null,3197.2039316799987,null,57333.803013069992]
[null,"FlexLån®",1033.0078247800002,null,1131.6992230600001,null,667.99803314999997,null,83.393967480000001,null,2916.0990484699996]
[null," - repayment loans",209.45349090000005,null,232.63524747000002,null,157.57954642999999,null,32.020318010000004,null,631.68860281000002]
[null," - interest-only ",823.55433388000006,null,899.06397559000015,null,510.41848671999998,null,51.373649469999997,null,2284.4104456599998]
[null,"FlexGaranti®, Rentedyk TM",3998.7438394800006,null,86.953121580000001,null,38.942502990000001,null,21.238844270000005,null,4145.8783083200005]
[null," - repayment loans",1932.2130107000003,null,62.754355609999998,null,38.942502990000001,null,13.816508980000004,null,2047.7263782800003]
[null," - interest-only ",2066.5308287799999,null,24.19876597,null,0,null,7.4223352900000013,null,2098.15193004]
[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",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," Total",174092.13041600995,null,51139.386609119996,null,20217.441631119978,null,8633.0660722799967,null,254082.02472852994]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",74541.765935529969,null,24620.34016498,null,8006.9819151300017,null,721.3474196300001,null,107890.43543526997]
[null," - Other Sealand",33025.407045489999,null,4944.186929110002,null,2457.1986910600003,null,1997.7807981399997,null,42424.573463799999]
[null," - Region South Denmark",29943.324461369997,null,7499.3224421399991,null,3602.6725103400004,null,3522.9877825599997,null,44568.307196409987]
[null," - Region Central Jutland",27519.711533789985,null,11378.494957539997,null,4044.4255723599995,null,1454.7813150600005,null,44397.413378749981]
[null," - Region North Jutland",9061.9214398299991,null,2697.0421153500019,null,2106.1629422299993,null,936.16875688999971,null,14801.295254300001]
[null," - Other area",0,null,0,null,0,null,0,null,0]
[null,"Total",174092.13041600995,null,51139.386609119989,null,20217.441631120004,null,8633.0660722799985,null,254082.02472852997]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100619.31795757999,null,2145.9176895399996,null,976.14673349000009,null,894.5658268899997,null,104635.94820749998]
[null," 2 - 5",63309.272320749958,null,3957.0465088899991,null,1429.2763335000009,null,1250.3524899100005,null,69945.947653049952]
[null," 5 - 20",9814.7670188299981,null,15900.231327659983,null,4865.43197728,null,2379.5855239499997,null,32960.01584771998]
[null," 20 - 50",303.88443311000003,null,11535.989763119995,null,4651.6989996800021,null,2615.5248978399986,null,19107.098093749995]
[null," 50 - 100",44.88868574,null,7066.6839425599992,null,3136.9315180800004,null,1307.91776766,null,11556.421914039998]
[null," 100 and above",0,null,10533.517377350001,null,5157.9560690899998,null,185.11956602999999,null,15876.593012470001]
[null,"Total",174092.13041600992,null,51139.386609119974,null,20217.441631120004,null,8633.0660722799985,null,254082.02472852991]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",11376.183630580004,null,1812.7834214000009,null,1259.94354716,null,292.93598110000005,null,14741.846580240006]
[null,"> 12 - ≤ 24 months",12793.533575010002,null,2990.7604705799995,null,2211.7405436200002,null,459.62467166999994,null,18455.659260880002]
[null,"> 24 - ≤ 36 months",8586.0355468800044,null,3297.4354405099989,null,1340.5359860899996,null,339.78514040000005,null,13563.792113880003]
[null,"> 36 - ≤ 60 months",18827.757234460001,null,4200.7223010799971,null,1977.0230510399999,null,579.40132391999987,null,25584.903910500001]
[null,"> 60 months",122508.62042908008,null,38837.684975549979,null,13428.19850321,null,6961.3189551899995,null,181735.82286303007]
[null,"Total",174092.13041601007,null,51139.386609119982,null,20217.441631120004,null,8633.0660722799985,null,254082.02472853006]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",63162.335858150633,null,25040.329811279662,null,7462.7420729133219,null,3152.5518517223081,null,98817.95959406592]
[null,"20 - 40%",54371.153023508239,null,12691.091025972506,null,7477.0264449468286,null,2874.0884832536058,null,77413.358977681171]
[null,"40 - 60%",37368.472870994636,null,7024.6015239309618,null,4425.7870694988978,null,1995.5927217661117,null,50814.454186190611]
[null,"60 - 80%",16658.572947971701,null,3249.12895344668,null,496.7452047541596,null,520.44180813140213,null,20924.888914303941]
[null,"> 80 %",2531.5957153848649,null,3134.2352941301729,null,355.14083908679112,null,90.391207326571347,null,6111.3630559284002]
[null,"Total",174092.13041601007,null,51139.386608759982,null,20217.441631199996,null,8633.0660721999993,null,254082.02472817004]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":40,"n_cols":4,"rows_kept":40,"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,31,50]
[null,"2018*",23,27]
[]
[null,"*2018Q3"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":68,"n_cols":5,"rows_kept":68,"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}]
[null,"2017 Q4",26,5,{"$f":"C65+D65","v":31}]
[null,"2018 Q1",28,3,{"$f":"C66+D66","v":31}]
[null,"2018 Q2",24,3,{"$f":"C67+D67","v":27}]
[null,"2018 Q3",20,3,{"$f":"C68+D68","v":23}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":56,"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","2017 Q4","2018 Q1","2018 Q2","2018 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,63.35,62.92,62.22,61.41]
[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,52.17,52.36,51.02,51.23]
[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,58.15,56.8,56.98,56.92]
[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,69.56,68.099999999999994,67.36,67.36]
[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,62.68,62.12,61.36,60.94]

{"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 2018 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%",170.8057033350396,null,70.129770966406099,null,54.118521134294696,null,18.703041328431443,null,0.39347226320416345,null,313.7570367641718]
[null," - 20-40%",143.56552243998931,null,45.197298278882393,null,43.932986016961067,null,15.52915195319888,null,0.31129066390483662,null,248.22495868903167]
[null," - 40-60%",96.594164939670165,null,27.768545034857116,null,22.62879963030635,null,9.7515814102302834,null,0.19656629664586375,null,156.7430910150639]
[null," - 60-80%",39.902727840603902,null,12.972607750902599,null,3.8601338013284101,null,2.6171505151586762,null,7.4432146361223833E-2,null,59.352619907993585]
[null," - >80%",7.0207684429467552,null,9.8425959650017916,null,1.9305904568393901,null,0.53406746052073428,null,2.4238629883912222E-2,null,19.32802232530867]
[null,"Total",457.88888699824975,null,165.91081799605001,null,126.47103103972992,null,47.134992667540011,null,1,null,797.40572870156961]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",100.8480810669639,null,31.821727969249103,null,44.980946806671312,null,15.286404543915879,null,0.39155769739169244,null,192.9371603868002]
[null," - 20-40%",85.298965111011029,null,24.734379911993145,null,34.801781369336794,null,12.545487718529094,null,0.31939721073845945,null,157.38061411087006]
[null," - 40-60%",57.398506667360941,null,16.14795746297618,null,17.039498183261887,null,7.7294537129104723,null,0.19952692286063134,null,98.315416026509467]
[null," - 60-80%",22.587739425184694,null,6.9171671771964336,null,2.7938197421735849,null,2.0720024881518606,null,6.9753920978353812E-2,null,34.370728832706568]
[null," - >80%",4.1973526048894403,null,3.9342786112052193,null,1.1732448103264139,null,0.43381106275267323,null,1.9764248030862797E-2,null,9.7386870891737463]
[null,"Total",270.33064487540997,null,83.555511132620083,null,100.78929091176998,null,38.067159526259978,null,0.99999999999999978,null,492.74260644606005]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",63.162335858150634,null,25.040329811279662,null,7.4627420729133211,null,3.1525518517223081,null,0.38892148982119623,null,98.817959594065925]
[null," - 20-40%",54.371153023508242,null,12.691091025972506,null,7.4770264449468291,null,2.874088483253606,null,0.30467861337496011,null,77.413358977681185]
[null," - 40-60%",37.368472870994637,null,7.0246015239309614,null,4.425787069498897,null,1.9955927217661116,null,0.19999232232407824,null,50.814454186190602]
[null," - 60-80%",16.658572947971702,null,3.2491289534466801,null,0.49674520475415962,null,0.52044180813140206,null,8.2354857399654535E-2,null,20.924888914303942]
[null," - >80%",2.5315957153848649,null,3.1342352941301725,null,0.35514083908679112,null,9.0391207326571341E-2,null,2.4052717080110836E-2,null,6.1113630559283996]
[null,"Total",174.09213041601006,null,51.139386608759978,null,20.217441631199996,null,8.6330660721999983,null,0.99999999999999989,null,254.08202472817007]

{"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 2018 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%",82.941716882769498,null,218.68465557676899,null,12.130664304633941,null,313.75703676417248]
[null," - 20-40%",55.884871363960514,null,181.16020348374636,null,11.179883841324315,null,248.22495868903118]
[null," - 40-60%",30.805243342035673,null,117.04676754888138,null,8.8910801241467698,null,156.74309101506384]
[null," - 60-80%",11.241976283665759,null,43.283622255285458,null,4.8270213690425336,null,59.352619907993748]
[null," - >80%",5.955414982832969,null,10.587371200192374,null,2.7852361422833272,null,19.32802232530867]
[null,"Total",186.82922285526442,null,570.76262006487445,null,39.813885781430884,null,797.40572870156984]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",44.203728959663025,null,139.38858148358989,null,9.3448499435472367,null,192.93716038680017]
[null," - 20-40%",30.990235125452976,null,117.70812921088756,null,8.6822497745294296,null,157.38061411086997]
[null," - 40-60%",17.261790891858517,null,74.225497242380442,null,6.8281278922705253,null,98.315416026509482]
[null," - 60-80%",5.9201844316887184,null,24.80092674092819,null,3.6496176600896626,null,34.370728832706568]
[null," - >80%",2.5013946130400333,null,5.0938590851284244,null,2.1434333910052978,null,9.7386870891737551]
[null,"Total",100.87733402170326,null,361.21699376291451,null,30.648278661442156,null,492.74260644605994]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",27.498289238597369,null,69.0793327488134,null,2.240337606655181,null,98.81795959406594]
[null," - 20-40%",18.369772272329666,null,56.935736740448554,null,2.1078499649029627,null,77.413358977681185]
[null," - 40-60%",10.026223003675328,null,38.977906232435629,null,1.8103249500795786,null,50.814454186190531]
[null," - 60-80%",3.1932262706600834,null,16.711242452930311,null,1.0204201907135626,null,20.924888914303956]
[null," - >80%",1.3198185217095129,null,4.3120819562591688,null,0.47946257795971808,null,6.1113630559283996]
[null,"Total",60.40732930697196,null,186.01630013088706,null,7.6583952903110042,null,254.08202472817001]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":46,"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","2017 Q4","2018 Q1","2018 Q2","2018 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,0.26,0.22,0.22,0.19]
[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,0.46,0.28999999999999998,0.24,0.11]
[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,0.69,1.27,1.49,1.52]
[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,0.12,7.0000000000000007E-2,0.13,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,0.31,0.26,0.3,0.23]

{"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",51139386609.120018,51139386609.120018]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",20217441631.119991,20217441631.119991]
["S-Landbrug","S",null,"Landbrug",8633066072.2799911,8633066072.2799911]
["S-Privat","S",null,"Privat",174092130416.01044,174092130416.01044]
["S Total-","S Total","S Total",null,254082024728.53043,254082024728.53043]
["T-Boligudl","T","T","Boligudl",83555511132.710175,80591697587.850098]
["T-Erhverv","T",null,"Erhverv",100789290911.61011,84677411610.640152]
["T-Landbrug","T",null,"Landbrug",38067159525.800064,38067159525.800064]
["T-Privat","T",null,"Privat",270330644875.68933,270330644875.68933]
["T Total-","T Total","T Total",null,492742606445.80969,473666913599.97961]
["Ø-Boligudl","Ø","Ø","Boligudl",31215920254.539986,31014118399.259987]
["Ø-Erhverv","Ø",null,"Erhverv",5464298496.7399979,5172722944.7199974]
["Ø-Landbrug","Ø",null,"Landbrug",434767069.06000012,434767069.06000012]
["Ø-Privat","Ø",null,"Privat",13466111706.809998,13466111706.809998]
["Ø Total-","Ø Total","Ø Total",null,50581097527.149979,50087720119.849976]
["Grand Total-","Grand Total","Grand Total",null,797405728701.49023,777836658448.36011]
[]
[]
[]
[]
[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":270330644875.68933}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":80591697587.850098}]
[null,null,"T-Erhverv","Erhverv","Commercial",84677411610.640152]
[null,null,"T-Landbrug","Landbrug","Agriculture",38067159525.800064]
[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":19075692845.830078}]
[]
[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":174092130416.01044}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":51139386609.120018}]
[null,null,"S-Erhverv","Erhverv","Commercial",20217441631.119991]
[null,null,"S-Landbrug","Landbrug","Agriculture",8633066072.2799911]
[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":0}]
[]
[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":13466111706.809998}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":31014118399.259987}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",5172722944.7199974]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",434767069.06000012]
[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":493377407.30000305}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":457888886998.50977}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":162745202596.2301}]
[null,null,null,null,"Commercial",110067576186.48015]
[null,null,null,null,"Agriculture",47134992667.140053]
[null,null,null,null,"Nordic",19569070253.130081]

{"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",2584737010.0100002,32413929.510000002]
[null,"F1",22050516954.73,5360654825.0299997]
[null,"F3",32768883147.66,8719240720.3299999]
[null,"F5",79482181267.199997,22842436189.900002]
[null,"Fixed",46286807471.379997,11087434755.67]
[null,"Floaters",14898770041.15,57892719684.419998]
[null,"Øv. flex",12273316366.530001,18320943154.110001]
["J Total",null,210345212258.65997,124255843258.97]
["N","CapFloat",10555935800.190001,771958891.25]
[null,"F1",14602934714.219999,17596255827.82]
[null,"F3",20773638012.66,9024125560.0599995]
[null,"F5",63625272043.940002,37281108964.519997]
[null,"Fixed",127101363345.85001,94229144168.5]
[null,"Floaters",6219812341.8699999,46246571348.720001]
[null,"Øv. flex",4664718481.1800003,10111833683.4]
["N Total",null,247543674739.91,215260998444.26999]