{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2018 Q1 Total","RD 2018 Q1 Cap T","RD 2018 Q1 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 Q1 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 Q1 - 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",454572.65305975103,null,161876.52727167989,null,127797.36620440983,null,47133.403268669921,null,791379.94980451057]
[null," - Number of loans",409037,null,36031,null,12746,null,13559,null,471373]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",169597.95276959008,null,76994.525309740071,null,18360.662630160004,null,8169.8206470000023,null,273122.96135649021]
[null," - repayment loans",125460.34049182004,null,71060.539348510065,null,17089.841544300001,null,5215.7082745100024,null,218826.42965914015]
[null," - interest-only ",44137.612277770058,null,5933.9859612299997,null,1270.8210858600003,null,2954.1123724899994,null,54296.531697350059]
[null,"FlexLån®",249346.43969064011,null,65939.944700379987,null,35539.698521859988,null,25425.081985400007,null,376251.16489828011]
[null," - repayment loans",103677.42796372004,null,42425.580849059981,null,20716.464255609986,null,8890.3635916200055,null,175709.83666001001]
[null," - interest-only ",145669.01172692009,null,23514.363851320002,null,14823.23426625,null,16534.718393780004,null,200541.32823827007]
[null,"FlexGaranti®, Rentedyk TM",14149.589516200014,null,431.42113086999996,null,220.11285794999989,null,211.15530205999997,null,15012.278807080012]
[null," - repayment loans",11233.965454020012,null,406.51341005999996,null,219.1125743799999,null,203.76034858999998,null,12063.351787050011]
[null," - interest-only ",2915.6240621800016,null,24.907720809999997,null,1.0002835700000001,null,7.3949534699999999,null,2948.9270200300016]
[null,"FlexKort®",21389.706609260003,null,2368.60930766,null,2456.32831399,null,7625.8451634400008,null,33840.489394349999]
[null," - repayment loans",6408.3281690700005,null,1263.5614739600001,null,1375.4346969000001,null,2259.7003153700007,null,11307.024655300002]
[null," - interest-only ",14981.378440190001,null,1105.0478336999997,null,1080.8936170899999,null,5366.1448480700001,null,22533.464739049999]
[null,"Other floating rate loans",88.964474060000001,null,16142.026823029999,null,71220.563880449947,null,5701.5001707700003,null,93153.055348309936]
[null," - repayment loans",45.366161439999999,null,6069.1770032300037,null,32688.249183759985,null,2158.7828800899997,null,40961.575228519978]
[null," - interest-only ",43.598312620000002,null,10072.849819799996,null,38532.314696689966,null,3542.7172906800001,null,52191.480119789965]
[null," Total",454572.65305975027,null,161876.52727168007,null,127797.36620440995,null,47133.403268670008,null,791379.94980451034]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",201073.21550688992,null,61637.731439259995,null,51030.228519039985,null,3468.3000647700014,null,317209.47552995989]
[null," - Other Sealand",86881.419689450035,null,17015.312034319977,null,10550.468652619998,null,13278.523228630009,null,127725.72360502]
[null," - Region South Denmark",71307.535901639974,null,28436.843258940007,null,23945.538156830011,null,16156.107137779996,null,139846.02445518997]
[null," - Region Central Jutland",72666.496855030055,null,39005.741643630005,null,18973.10790747001,null,8684.1644279800057,null,139329.51083411009]
[null," - Region North Jutland",22643.318755210013,null,12737.423004020009,null,5769.4082894700041,null,5546.3084095100003,null,46696.458458210029]
[null," - Other area",0.66635153000000003,null,3043.4758915100001,null,17528.614678979997,null,0,null,20572.756922019998]
[null,"Total",454572.65305975004,null,161876.52727167998,null,127797.36620440999,null,47133.403268670016,null,791379.94980451011]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",249382.50151118072,null,8108.6634659199972,null,3267.0075692700002,null,3185.6725662999988,null,263943.84511267068]
[null," 2 - 5",171982.21999152008,null,11492.150840419994,null,5186.9640028500025,null,6458.8993018300025,null,195120.2341366201]
[null," 5 - 20",32212.096766269988,null,44979.898849509977,null,19159.402469390003,null,15331.783288400005,null,111683.18137356998]
[null," 20 - 50",939.34712875000002,null,37920.376917549998,null,18735.935868370001,null,14242.351427969996,null,71838.011342640006]
[null," 50 - 100",56.487662030000003,null,23552.321708410025,null,15508.687838580001,null,6199.8525479900009,null,45317.349757010023]
[null," 100 and above",0,null,35823.11548986999,null,65939.368455950011,null,1714.8441361800001,null,103477.32808199998]
[null,"Total",454572.65305975085,null,161876.52727167998,null,127797.36620441001,null,47133.403268670001,null,791379.94980451069]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",28807.618312429986,null,8939.9868734899937,null,8496.0176867300015,null,1022.9812409900003,null,47266.604113639987]
[null,"> 12 - ≤ 24 months",23830.971014990006,null,6974.0127778100014,null,7787.3404623899996,null,1450.5550596100002,null,40042.879314800004]
[null,"> 24 - ≤ 36 months",22272.455551960004,null,7187.6943715100006,null,8830.6218330999982,null,1859.6329111099999,null,40150.404667679999]
[null,"> 36 - ≤ 60 months",38264.011446219985,null,12440.042603570004,null,12796.453905110002,null,2241.1611923700011,null,65741.669147269989]
[null,"> 60 months",341397.59673415072,null,126334.79064529996,null,89886.932317079758,null,40559.072864589958,null,598178.39256112033]
[null,"Total",454572.65305975068,null,161876.52727167995,null,127797.36620440976,null,47133.403268669957,null,791379.94980451034]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",165694.02089811827,null,68016.846240938074,null,53493.411740801988,null,18751.975610949103,null,305956.25449080742]
[null,"20 - 40%",140334.36893454852,null,44134.665509536484,null,43858.098449884077,null,15545.400658305965,null,243872.53355227507]
[null,"40 - 60%",96743.654105201043,null,26948.023521817791,null,23315.89329421506,null,9592.9809284497642,null,156600.55184968366]
[null,"60 - 80%",42950.656948073745,null,12801.77298703065,null,4305.1282574128172,null,2640.5868664473869,null,62698.145058964605]
[null,"> 80 %",8849.952173528005,null,9975.2190129569535,null,2824.8344621962415,null,602.45920402776619,null,22252.46485270897]
[null,"Total",454572.65305946954,null,161876.52727227993,null,127797.36620451018,null,47133.403268179987,null,791379.94980443968]

{"sheet":"RD 2018 Q1 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 Q1 - 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",269662.53903122974,null,81667.803533509839,null,100260.34957066996,null,38493.011584760039,null,490083.70372016967]
[null," - Number of loans",226609,null,16551,null,8466,null,10455,null,262081]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",42.706509880000006,null,140.26756519999998,null,0,null,26.2057608,null,209.17983587999998]
[null," - repayment loans",8.353817470000001,null,20.96689688,null,0,null,26.2057608,null,55.526475150000003]
[null," - interest-only ",34.352692410000003,null,119.30066832,null,0,null,0,null,153.65336073]
[null,"FlexLån®",248150.32744614995,null,64716.852272399978,null,34849.784904860004,null,25328.483731849999,null,373045.44835526001]
[null," - repayment loans",103391.10427003003,null,42162.815153809985,null,20543.93906217,null,8845.907989819998,null,174943.76647583005]
[null," - interest-only ",144759.22317611994,null,22554.037118589997,null,14305.845842690003,null,16482.575742030003,null,198101.68187942993]
[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®",21389.706609260003,null,2368.6093076599996,null,2456.3283139899986,null,7625.8451634400008,null,33840.489394349999]
[null," - repayment loans",6408.3281690700005,null,1263.5614739599998,null,1375.4346968999992,null,2259.7003153699998,null,11307.0246553]
[null," - interest-only ",14981.378440190001,null,1105.0478336999995,null,1080.8936170899999,null,5366.144848070001,null,22533.464739049999]
[null,"Other floating rate loans",79.798465940000014,null,14442.074388250006,null,62954.236351819978,null,5512.4769286700002,null,82988.586134679979]
[null," - repayment loans",38.200853860000002,null,5024.9620109300022,null,26939.995903459985,null,1992.7075528500006,null,33995.866321099988]
[null," - interest-only ",41.597612080000012,null,9417.1123773200034,null,36014.240448359989,null,3519.7693758199998,null,48992.719813579992]
[null," Total",269662.53903122997,null,81667.803533509985,null,100260.34957066998,null,38493.011584760003,null,490083.70372016996]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",125576.82701175007,null,28741.531897239984,null,40412.825862529993,null,2723.027779649999,null,197454.21255117006]
[null," - Other Sealand",50167.971394800006,null,7800.1753064100049,null,7141.5685322499994,null,11277.936387249996,null,76387.651620710007]
[null," - Region South Denmark",38393.185009019995,null,15028.52992069,null,18476.04243791,null,12672.19957544001,null,84569.956943059995]
[null," - Region Central Jutland",43010.04729627999,null,20363.479000389998,null,13519.334757169998,null,7192.8152563599979,null,84085.676310199997]
[null," - Region North Jutland",12514.508319379996,null,7148.302877629998,null,3514.4789940499986,null,4627.0325860600005,null,27804.322777119996]
[null," - Other area",0,null,2585.78453115,null,17196.098986760004,null,0,null,19781.883517910002]
[null,"Total",269662.53903123003,null,81667.803533509985,null,100260.34957066998,null,38493.011584760003,null,490083.70372017002]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",135126.04570192008,null,5007.5011940199938,null,1939.8984957600003,null,2083.0624073600002,null,144156.50779906008]
[null," 2 - 5",110443.57488841993,null,5859.8513657300027,null,3481.8933433600014,null,5083.0144472199972,null,124868.33404472991]
[null," 5 - 20",23376.540655009994,null,20567.231491570023,null,13532.829083150003,null,13039.082126269986,null,70515.683355999994]
[null," 20 - 50",659.89012385000012,null,17492.822011560009,null,13186.828561139999,null,11785.053437840006,null,43124.594134390012]
[null," 50 - 100",56.487662030000003,null,12640.711583239992,null,10990.265315369998,null,4927.2197750300002,null,28614.68433566999]
[null," 100 and above",0,null,20099.685887390002,null,57128.634771889992,null,1575.5793910400002,null,78803.900050319993]
[null,"Total",269662.53903123003,null,81667.803533510029,null,100260.34957066998,null,38493.011584759988,null,490083.70372017002]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",16854.993719510003,null,6914.8053536400012,null,6478.3667357300019,null,709.17879207999954,null,30957.344600960001]
[null,"> 12 - ≤ 24 months",12932.723077300005,null,3450.9157766700032,null,5136.3231906299998,null,1110.2298426900002,null,22630.19188729001]
[null,"> 24 - ≤ 36 months",11823.987039060003,null,3783.4798799900041,null,7488.372244469997,null,1419.8796321799998,null,24515.718795700006]
[null,"> 36 - ≤ 60 months",21498.408959309989,null,8790.4703648200029,null,11038.546162710001,null,1702.7394545699992,null,43030.164941409996]
[null,"> 60 months",206552.42623604991,null,58728.132158390043,null,70118.741237129972,null,33550.983863239991,null,368950.28349480993]
[null,"Total",269662.53903122991,null,81667.803533510058,null,100260.34957066998,null,38493.011584759988,null,490083.7037201699]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",97673.733576862403,null,30475.166574588093,null,43694.134280509854,null,15467.615574971498,null,187310.65000693186]
[null,"20 - 40%",83356.800028987302,null,24080.420310763406,null,34799.071658526031,null,12680.647305978826,null,154916.93930425559]
[null,"40 - 60%",57908.939968171042,null,15947.138660036217,null,17406.783168308146,null,7710.5939814055246,null,98973.455777920928]
[null,"60 - 80%",25177.886603095558,null,6881.0512805791359,null,2858.6921129222587,null,2128.641132557872,null,37046.271129154826]
[null,"> 80 %",5545.1788536035865,null,4284.026707493108,null,1501.6683502836727,null,505.51358959631392,null,11836.387500976678]
[null,"Total",269662.5390307199,null,81667.803533459955,null,100260.34957054997,null,38493.01158451003,null,490083.70371923991]

{"sheet":"RD 2018 Q1 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 Q1 - 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",170123.3769495798,null,52173.881373280026,null,21158.429495770022,null,8111.7780479500088,null,251567.46586657988]
[null," - Number of loans",150625,null,9661,null,2973,null,2483,null,165742]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",164651.32636894006,null,50037.894294080033,null,18006.969901410008,null,7967.9263565800002,null,240664.11692101014]
[null," - repayment loans",120591.40628345002,null,44223.209001170027,null,16736.148815550008,null,5013.8139840900003,null,186564.57808426008]
[null," - interest-only ",44059.920085490048,null,5814.6852929100014,null,1270.8210858600003,null,2954.1123724899994,null,54099.538836750056]
[null,"FlexLån®",1192.4574281300002,null,1223.0924279800004,null,689.91361700000004,null,87.302012590000004,null,3192.7654857000002]
[null," - repayment loans",282.66887733000004,null,262.76569525000002,null,172.52519344000001,null,35.159360839999998,null,753.11912686000005]
[null," - interest-only ",909.78855080000017,null,960.32673273000012,null,517.38842355999998,null,52.142651749999999,null,2439.6463588400002]
[null,"FlexGaranti®, Rentedyk TM",4277.5924519700002,null,91.909984550000019,null,41.517484830000001,null,21.493983750000002,null,4432.5139051000006]
[null," - repayment loans",1935.2149931700001,null,67.79192304,null,40.51720126,null,14.099030279999999,null,2057.62314775]
[null," - interest-only ",2342.3774587999997,null,24.118061509999997,null,1.0002835700000001,null,7.3949534699999999,null,2374.8907573500001]
[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",2.00070054,null,820.9846666699998,null,2420.0284925299998,null,35.055695030000003,null,3278.0695547699993]
[null," - repayment loans",0,null,226.04188134999995,null,1937.1720479099997,null,12.10778017,null,2175.3217094299998]
[null," - interest-only ",2.00070054,null,594.94278531999998,null,482.85644461999993,null,22.947914860000001,null,1102.7478453399997]
[null," Total",170123.37694958004,null,52173.881373280034,null,21158.429495770004,null,8111.7780479499997,null,251567.46586658011]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",71870.935925120022,null,24052.381299729976,null,8552.9580722999981,null,705.57981488999985,null,105181.85511204001]
[null," - Other Sealand",32330.158042669995,null,5069.5448644399958,null,2929.86760207,null,1864.32230878,null,42193.89281795999]
[null," - Region South Denmark",29704.775321379995,null,8197.3324754200003,null,3656.7779851599994,null,3287.0447794099987,null,44845.930561369991]
[null," - Region Central Jutland",27132.582181480007,null,11753.662744519992,null,3970.3759736499997,null,1384.8700713199996,null,44241.49097097]
[null," - Region North Jutland",9084.9254789300012,null,2850.881443400001,null,2014.1823529600006,null,869.96107355000015,null,14819.950348840004]
[null," - Other area",0,null,250.07854577000001,null,34.267509629999999,null,0,null,284.34605540000001]
[null,"Total",170123.37694958001,null,52173.881373279968,null,21158.42949577,null,8111.7780479499988,null,251567.46586657999]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",101191.17746960004,null,2125.8052682500006,null,987.94834461000028,null,901.91561312999943,null,105206.84669559004]
[null," 2 - 5",59897.811706819994,null,4025.0565993300029,null,1569.5273223100012,null,1259.2459239800005,null,66751.641552439993]
[null," 5 - 20",8754.9307682600029,null,15687.446494860002,null,5024.0843655499966,null,2211.7281647399982,null,31678.189793409994]
[null," 20 - 50",279.45700489999996,null,11817.356163199996,null,4918.002217780001,null,2334.0470471399999,null,19348.862433019996]
[null," 50 - 100",0,null,7253.2378608399949,null,3471.1568646499995,null,1266.3208326200001,null,11990.715558109994]
[null," 100 and above",0,null,11264.978986799997,null,5187.7103808700003,null,138.52046634000001,null,16591.209834009998]
[null,"Total",170123.37694958004,null,52173.88137327999,null,21158.429495769997,null,8111.7780479499979,null,251567.46586658002]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",11932.783097720006,null,1995.6560089500001,null,1984.6685470500004,null,313.76598278000006,null,16226.87363650001]
[null,"> 12 - ≤ 24 months",10871.492845870003,null,3462.1651203699998,null,1976.4073677399997,null,340.04518129999991,null,16650.110515280001]
[null,"> 24 - ≤ 36 months",10425.974374389987,null,3370.7036135800004,null,1332.0203715600003,null,435.89422015000008,null,15564.592579679987]
[null,"> 36 - ≤ 60 months",16552.70466829,null,3489.6083198899987,null,1750.1788684499995,null,514.36705246000008,null,22306.858909089995]
[null,"> 60 months",120340.42196331,null,39855.748310490017,null,14115.154340969997,null,6507.7056112600048,null,180819.03022603004]
[null,"Total",170123.37694957998,null,52173.881373280012,null,21158.429495769997,null,8111.7780479500043,null,251567.46586658002]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",60820.971723635557,null,24895.865399279814,null,8045.6785510331338,null,2960.6864338579917,null,96723.202107806486]
[null,"20 - 40%",52722.274330617227,null,13018.525834079574,null,7263.0967825019043,null,2729.5318356335265,null,75733.428782832227]
[null,"40 - 60%",36710.151530505005,null,7005.2266068332801,null,4537.0723446132406,null,1846.5072149207092,null,50098.957696872232]
[null,"60 - 80%",16955.194373595754,null,3539.233680926955,null,779.31496222190458,null,485.43940900219332,null,21759.182425746807]
[null,"> 80 %",2914.784991176437,null,3715.0298524903878,null,533.26685583980941,null,89.613154305579172,null,7252.6948538122142]
[null,"Total",170123.37694952998,null,52173.881373610006,null,21158.429496209992,null,8111.7780477200004,null,251567.46586706999]

{"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*",31,12]
[]
[null,"*2018Q1"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":66,"n_cols":5,"rows_kept":66,"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}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":54,"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"]
[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]
[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]
[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]
[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]
[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]

{"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 Q1"]
[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%",165.69402089811825,null,68.016846240938079,null,53.493411740801989,null,18.751975610949103,null,0.38661107672289807,null,305.95625449080745]
[null," - 20-40%",140.33436893454854,null,44.134665509536482,null,43.858098449884082,null,15.545400658305965,null,0.30816112236927307,null,243.87253355227509]
[null," - 40-60%",96.743654105201045,null,26.948023521817792,null,23.315893294215062,null,9.592980928449764,null,0.1978828903719152,null,156.60055184968368]
[null," - 60-80%",42.950656948073743,null,12.801772987030651,null,4.3051282574128171,null,2.6405868664473866,null,7.9226350218321973E-2,null,62.698145058964599]
[null," - >80%",8.8499521735280062,null,9.9752190129569538,null,2.8248344621962413,null,0.6024592040277662,null,2.8118560317591877E-2,null,22.252464852708968]
[null,"Total",454.57265305946953,null,161.87652727227996,null,127.79736620451018,null,47.133403268179983,null,1.0000000000000002,null,791.37994980443978]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",97.673733576862389,null,30.475166574588094,null,43.694134280509857,null,15.467615574971498,null,0.38220134353669249,null,187.31065000693184]
[null," - 20-40%",83.356800028987308,null,24.080420310763405,null,34.799071658526032,null,12.680647305978827,null,0.31610302103210652,null,154.91693930425555]
[null," - 40-60%",57.90893996817104,null,15.947138660036217,null,17.406783168308149,null,7.7105939814055251,null,0.20195214618811533,null,98.973455777920933]
[null," - 60-80%",25.177886603095558,null,6.8810512805791362,null,2.8586921129222587,null,2.1286411325578718,null,7.5591722083413665E-2,null,37.046271129154825]
[null," - >80%",5.545178853603586,null,4.2840267074931084,null,1.5016683502836725,null,0.50551358959631387,null,2.4151767159671836E-2,null,11.836387500976681]
[null,"Total",269.66253903071993,null,81.667803533459974,null,100.26034957054996,null,38.493011584510036,null,0.99999999999999978,null,490.08370371923985]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",60.820971723635559,null,24.895865399279813,null,8.0456785510331343,null,2.9606864338579917,null,0.38448215779585621,null,96.723202107806486]
[null," - 20-40%",52.722274330617225,null,13.018525834079572,null,7.2630967825019042,null,2.7295318356335265,null,0.30104619658112025,null,75.73342878283222]
[null," - 40-60%",36.710151530505001,null,7.0052266068332809,null,4.5370723446132404,null,1.8465072149207091,null,0.19914720500203659,null,50.098957696872233]
[null," - 60-80%",16.955194373595752,null,3.5392336809269551,null,0.77931496222190466,null,0.48543940900219334,null,8.6494421489480305E-2,null,21.759182425746804]
[null," - >80%",2.914784991176437,null,3.715029852490388,null,0.53326685583980937,null,8.9613154305579173E-2,null,2.8830019131506405E-2,null,7.2526948538122129]
[null,"Total",170.12337694953001,null,52.173881373610008,null,21.15842949620999,null,8.1117780477200014,null,0.99999999999999967,null,251.56746586706998]

{"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 Q1"]
[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%",79.928199949676483,null,212.70128557238445,null,13.3267689687463,null,305.95625449080723]
[null," - 20-40%",53.79048063555237,null,177.75877657647092,null,12.323276340251926,null,243.87253355227523]
[null," - 40-60%",29.871330539482926,null,116.84922740854815,null,9.8799939016528402,null,156.60055184968391]
[null," - 60-80%",11.442626453143644,null,45.787933042964895,null,5.4675855628558514,null,62.698145058964393]
[null," - >80%",5.9852107066000606,null,12.81492569984113,null,3.452328446267793,null,22.252464852708982]
[null,"Total",181.01784828445551,null,565.91214830020965,null,44.449953219774713,null,791.37994980443978]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",42.592718474208056,null,134.46938441421619,null,10.248547118507574,null,187.31065000693184]
[null," - 20-40%",29.759940046896141,null,115.54789841645312,null,9.6091008409063008,null,154.91693930425558]
[null," - 40-60%",16.828496384567597,null,74.581881838179029,null,7.5630775551742575,null,98.97345577792089]
[null," - 60-80%",6.0068610066369192,null,26.938517290434898,null,4.1008928320830496,null,37.046271129154867]
[null," - >80%",2.7770963679003637,null,6.3941674980872918,null,2.6651236349890248,null,11.836387500976679]
[null,"Total",97.965112280209084,null,357.93184945737056,null,34.186741981660205,null,490.08370371923985]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",26.307772097960267,null,68.065544173414892,null,2.3498858364312634,null,96.723202107806429]
[null," - 20-40%",17.799441658443133,null,55.71872876694173,null,2.2152583574474005,null,75.733428782832263]
[null," - 40-60%",9.6985490969243084,null,38.422658698746964,null,1.9777499012009834,null,50.098957696872262]
[null," - 60-80%",3.4087642157406921,null,17.196732622189952,null,1.1536855878161765,null,21.759182425746822]
[null," - >80%",1.4971065565313184,null,5.1567601174385844,null,0.59882817984231063,null,7.2526948538122138]
[null,"Total",58.711633625599717,null,184.56042437873214,null,8.2954078627381342,null,251.56746586706998]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":44,"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"]
[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]
[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]
[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]
[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]
[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]

{"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",52173881373.280029,51923802827.510033]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21158429495.770027,21124161986.140026]
["S-Landbrug","S",null,"Landbrug",8111778047.9500065,8111778047.9500065]
["S-Privat","S",null,"Privat",170123376949.58032,170123376949.58032]
["S Total-","S Total","S Total",null,251567465866.58038,251283119811.18039]
["T-Boligudl","T","T","Boligudl",81667803533.509842,79082019002.359879]
["T-Erhverv","T",null,"Erhverv",100260349570.66989,83064250583.909836]
["T-Landbrug","T",null,"Landbrug",38493011584.759972,38493011584.759972]
["T-Privat","T",null,"Privat",269662539031.22995,269662539031.22995]
["T Total-","T Total","T Total",null,490083703720.16968,470301820202.25964]
["Ø-Boligudl","Ø","Ø","Boligudl",28034842364.890011,27828901799.090012]
["Ø-Erhverv","Ø",null,"Erhverv",6378587137.970005,6080338955.3800049]
["Ø-Landbrug","Ø",null,"Landbrug",528613635.96000004,528613635.96000004]
["Ø-Privat","Ø",null,"Privat",14786737078.94001,14786737078.94001]
["Ø Total-","Ø Total","Ø Total",null,49728780217.760025,49224591469.370026]
["Grand Total-","Grand Total","Grand Total",null,791379949804.51001,770809531482.81006]
[]
[]
[]
[]
[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":269662539031.22995}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":79082019002.359879}]
[null,null,"T-Erhverv","Erhverv","Commercial",83064250583.909836]
[null,null,"T-Landbrug","Landbrug","Agriculture",38493011584.759972]
[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":19781883517.910034}]
[]
[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":170123376949.58032}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":51923802827.510033}]
[null,null,"S-Erhverv","Erhverv","Commercial",21124161986.140026]
[null,null,"S-Landbrug","Landbrug","Agriculture",8111778047.9500065]
[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":284346055.3999939}]
[]
[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":14786737078.94001}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":27828901799.090012}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6080338955.3800049]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",528613635.96000004]
[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":504188748.38999939}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":454572653059.75031}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":158834723628.9599}]
[null,null,null,null,"Commercial",110268751525.42987]
[null,null,null,null,"Agriculture",47133403268.669975]
[null,null,null,null,"Nordic",20570418321.700027]

{"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",2915624062.1999998,33302957.870000001]
[null,"F1",22059396563.009998,5238762962.4300003]
[null,"F3",34982106252.230003,8871038564.4300003]
[null,"F5",76161238417,22728203261.59]
[null,"Fixed",44137612277.739998,10158919419.610001]
[null,"Floaters",15024976752.83,59699968105.93]
[null,"Øv. flex",12466270494.57,18034311722.880001]
["J Total",null,207747224819.57999,124764506994.74001]
["N","CapFloat",11233965454.030001,829386333.13]
[null,"F1",15584387200.02,11861660529.4]
[null,"F3",23790967925.060001,9425274040.5900002]
[null,"F5",58860937456.849998,43512405810.730003]
[null,"Fixed",125460340491.78,93366089167.289993]
[null,"Floaters",6453694330.6000004,45814905553.209999]
[null,"Øv. flex",5441135381.7399998,7233068315.5900002]
["N Total",null,246825428240.07999,212042789749.94]