{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2017 Q1 Total","RD 2017 Q1 Cap T","RD 2017 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 2017 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 2017 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",441683.13388891175,null,157377.2424848704,null,128117.09524906991,null,48207.258905810042,null,775384.7305286621]
[null," - Number of loans",408993,null,37099,null,13505,null,14001,null,473598]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",161399.22473999005,null,74584.684847880097,null,16449.912810310001,null,6901.0378956100021,null,259334.86029379009]
[null," - repayment loans",121096.72703101004,null,69857.941210170087,null,15333.383629680002,null,4463.5474042800015,null,210751.59927514009]
[null," - interest-only ",40302.497708979994,null,4726.7436377100003,null,1116.5291806299999,null,2437.4904913300015,null,48583.261018649995]
[null,"FlexLån®",243250.7334320799,null,63057.234361240007,null,41783.960960900025,null,25533.414750830001,null,373625.34350504994]
[null," - repayment loans",95396.468273649865,null,39721.308387209996,null,22336.071068620015,null,8311.1593026699993,null,165765.00703214991]
[null," - interest-only ",147854.26515843003,null,23335.925974030008,null,19447.889892280014,null,17222.255448159998,null,207860.33647290006]
[null,"FlexGaranti®, Rentedyk TM",16745.829704849999,null,508.85815824000008,null,288.95544948999998,null,262.58334239999994,null,17806.226654980001]
[null," - repayment loans",12179.925147869999,null,450.54545958000011,null,273.60719384999999,null,217.88277345999995,null,13121.960574759998]
[null," - interest-only ",4565.9045569800001,null,58.312698659999981,null,15.348255640000001,null,44.700568940000004,null,4684.2660802199998]
[null,"FlexKort®",20163.554433989997,null,2522.9846376099995,null,2712.7253793500004,null,8227.0616784500053,null,33626.326129400004]
[null," - repayment loans",6045.8025105200004,null,1296.1236991500007,null,1405.9963112000003,null,2109.8223209099997,null,10857.744841780001]
[null," - interest-only ",14117.751923469999,null,1226.8609384599993,null,1306.7290681499999,null,6117.2393575400056,null,22768.581287620003]
[null,"Other floating rate loans",123.791578,null,16703.480479899987,null,66881.540649020011,null,7283.1612385200033,null,90991.973945439997]
[null," - repayment loans",54.594983399999997,null,4892.8785291600025,null,23521.793726539992,null,1886.6783192400001,null,30355.945558339998]
[null," - interest-only ",69.196594599999997,null,11810.601950739985,null,43359.746922480015,null,5396.4829192800034,null,60636.028387100014]
[null," Total",441683.13388890988,null,157377.24248487005,null,128117.09524907004,null,48207.258905810013,null,775384.73052866]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",189827.95221372036,null,58640.758617409978,null,48935.808901730023,null,3530.3119409500014,null,300934.83167381037]
[null," - Other Sealand",86117.97982941987,null,17212.847132880004,null,10787.899839640013,null,13510.764568720007,null,127629.4913706599]
[null," - Region South Denmark",70647.077973049978,null,28431.174420689978,null,25376.315246140042,null,16243.753429470004,null,140698.32106935]
[null," - Region Central Jutland",72157.881602100038,null,36842.710087239982,null,19515.544750900004,null,8938.31779241,null,137454.45423265002]
[null," - Region North Jutland",22931.418675849978,null,13228.318405090004,null,5999.5438305300022,null,5984.1111742600033,null,48143.392085729989]
[null," - Other area",0.82359477000000003,null,3021.4338215600001,null,17501.982680129997,null,0,null,20524.240096459998]
[null,"Total",441683.13388891029,null,157377.24248486993,null,128117.0952490701,null,48207.258905810013,null,775384.73052866023]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",253219.21072216029,null,8690.7875963500028,null,3572.3790912500003,null,3312.2749259400039,null,268794.65233570029]
[null," 2 - 5",160029.29105322971,null,12124.710921430007,null,5608.6370538199981,null,6521.0930805500047,null,184283.73210902975]
[null," 5 - 20",27523.705740039968,null,44811.005725379982,null,20430.15960723997,null,15532.33683327001,null,108297.20790592993]
[null," 20 - 50",854.13167832999989,null,36961.626207339999,null,18409.967998190019,null,14596.579669790015,null,70822.305553650018]
[null," 50 - 100",56.794695149999995,null,21848.915661560008,null,16438.055620670013,null,6525.1607507800027,null,44868.926728160019]
[null," 100 and above",0,null,32940.19637280998,null,63657.895877899966,null,1719.8136454800003,null,98317.905896189943]
[null,"Total",441683.13388891006,null,157377.24248486999,null,128117.09524906996,null,48207.258905810035,null,775384.73052865989]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",22629.67923652997,null,6358.6465093599982,null,7315.5237707900014,null,863.17062164999982,null,37167.020138329972]
[null,"> 12 - ≤ 24 months",21112.070035259982,null,6549.7076567799995,null,8788.7777751700014,null,1652.6329436899998,null,38103.188410899988]
[null,"> 24 - ≤ 36 months",22314.914552779985,null,6710.3051722700002,null,5442.1237490300027,null,1282.84488016,null,35750.188354239988]
[null,"> 36 - ≤ 60 months",44576.800899280017,null,12265.996040699994,null,16215.297035400019,null,2272.9888158000003,null,75331.082791180044]
[null,"> 60 months",331049.66916506056,null,125492.58710575981,null,90355.372918679932,null,42135.621644510007,null,589033.25083401031]
[null,"Total",441683.13388891052,null,157377.24248486981,null,128117.09524906994,null,48207.258905810013,null,775384.73052866012]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",157088.88249386428,null,64857.354259951564,null,51956.95742612148,null,18470.692360409481,null,292373.88654034678]
[null,"20 - 40%",133966.79899134615,null,42581.418092427622,null,42702.809170935463,null,15585.271773198236,null,234836.29802790747]
[null,"40 - 60%",94886.089726454913,null,26908.934274186853,null,25401.002401875368,null,10171.324588354331,null,157367.35099087146]
[null,"60 - 80%",44766.729283375527,null,13114.133351500828,null,5370.8385911981923,null,3148.6078852633518,null,66400.309111337905]
[null,"> 80 %",10974.633393359722,null,9915.4025073732209,null,2685.4876590995027,null,831.3622989046097,null,24406.885858737056]
[null,"Total",441683.13388840063,null,157377.2424854401,null,128117.09524923001,null,48207.25890613001,null,775384.73052920063]

{"sheet":"RD 2017 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 2017 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",261476.94740786002,null,77423.958818409825,null,100226.1183176699,null,39185.715757219965,null,478312.74030115968]
[null," - Number of loans",225648,null,17030,null,8867,null,10653,null,262198]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",29.119959939999998,null,0,null,307.02483071,null,47.724207909999997,null,383.86899855999997]
[null," - repayment loans",9.7949197699999999,null,0,null,307.02483071,null,20.301657379999998,null,337.12140785999998]
[null," - interest-only ",19.325040169999998,null,0,null,0,null,27.422550530000002,null,46.747590700000003]
[null,"FlexLån®",241201.29244590987,null,60788.089417360003,null,40066.785990520009,null,25345.85092407,null,367402.01877785992]
[null," - repayment loans",94837.013378119998,null,39354.948254820003,null,21985.648517280013,null,8258.2752738800027,null,164435.88542410004]
[null," - interest-only ",146364.27906778987,null,21433.14116254,null,18081.137473239996,null,17087.575650189996,null,202966.13335375988]
[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®",20163.554433989997,null,2522.984637609999,null,2712.7253793500008,null,8227.0616784500053,null,33626.326129400004]
[null," - repayment loans",6045.8025105200004,null,1296.1236991499995,null,1405.9963112000007,null,2109.8223209099997,null,10857.744841780001]
[null," - interest-only ",14117.751923469999,null,1226.8609384599995,null,1306.7290681500001,null,6117.2393575400056,null,22768.581287620003]
[null,"Other floating rate loans",82.980568020000007,null,14112.884763439979,null,57139.582117089994,null,5565.0789467899986,null,76900.526395339984]
[null," - repayment loans",46.38955533,null,4603.3952070499963,null,20807.654851759995,null,1618.9986313600002,null,27076.438245499994]
[null," - interest-only ",36.591012690000007,null,9509.4895563899845,null,36331.927265329999,null,3946.0803154299988,null,49824.08814983999]
[null," Total",261476.94740785987,null,77423.95881840997,null,100226.11831767001,null,39185.715757220001,null,478312.74030115991]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",118423.84120495991,null,26228.189133120013,null,38540.308649380015,null,2890.9730213199991,null,186083.31200877993]
[null," - Other Sealand",49858.228788690016,null,7833.3747328700019,null,7253.233295789998,null,11533.267537080012,null,76478.104354430034]
[null," - Region South Denmark",37876.694935080021,null,14615.157357900001,null,19548.867517510011,null,12291.900255419994,null,84332.620065910014]
[null," - Region Central Jutland",42647.637863489996,null,18758.070708809995,null,13882.228591539997,null,7486.9083783300048,null,82774.845542169976]
[null," - Region North Jutland",12670.544615640008,null,7423.8540682499943,null,3826.3067054300004,null,4982.6665650700033,null,28903.371954390008]
[null," - Other area",0,null,2565.3128174600001,null,17175.173558019997,null,0,null,19740.486375479995]
[null,"Total",261476.94740785996,null,77423.958818410014,null,100226.11831767001,null,39185.715757220016,null,478312.74030115997]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",136485.21949769001,null,5427.2288144800013,null,2071.4651363600005,null,2129.4464995500007,null,146113.35994808]
[null," 2 - 5",104080.78898407995,null,6273.4911476200032,null,3793.0829751900005,null,5049.3135079600015,null,119196.67661484996]
[null," 5 - 20",20243.074339349987,null,20504.360357409951,null,14522.852909229996,null,12967.781836590002,null,68238.06944257993]
[null," 20 - 50",611.06989159,null,16574.619139650003,null,13517.073760139998,null,12076.864108959997,null,42779.626900339994]
[null," 50 - 100",56.794695149999995,null,11624.14553808999,null,10886.44809935,null,5387.8160108600023,null,27955.20434344999]
[null," 100 and above",0,null,17020.113821160005,null,55435.19543740002,null,1574.4937932999999,null,74029.803051860028]
[null,"Total",261476.94740785993,null,77423.958818409941,null,100226.11831767001,null,39185.715757220009,null,478312.74030116003]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",12043.38676411001,null,3231.5087348100005,null,5025.70060663,null,649.04547739999975,null,20949.641582950011]
[null,"> 12 - ≤ 24 months",11894.612769119993,null,3956.2506850199993,null,7466.8706263200011,null,1242.2992930599996,null,24560.033373519993]
[null,"> 24 - ≤ 36 months",11032.88291982,null,4496.0790156900002,null,4302.6993854499997,null,1032.8273141000004,null,20864.488635059999]
[null,"> 36 - ≤ 60 months",23298.115464689999,null,8937.5822680900055,null,14610.484882379998,null,1734.1015000500004,null,48580.284115210008]
[null,"> 60 months",203207.94949011999,null,56802.538114800016,null,68820.36281688996,null,34527.442172609997,null,363358.29259441991]
[null,"Total",261476.94740785999,null,77423.958818410028,null,100226.11831766996,null,39185.715757220001,null,478312.74030115991]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",91883.311685629218,null,28446.766981497934,null,42304.425549105719,null,15041.962199180065,null,177676.46641541296]
[null,"20 - 40%",78899.980072691789,null,22391.781531385197,null,33962.033895335699,null,12637.837446818845,null,147891.63294623152]
[null,"40 - 60%",56723.660665391566,null,15512.890134635036,null,19123.687455498726,null,8204.2786848812102,null,99564.516940406524]
[null,"60 - 80%",26934.005929065992,null,7146.7036454248309,null,3466.9821772340551,null,2606.3294223821781,null,40154.021174107053]
[null,"> 80 %",7035.9890551513818,null,3925.8165258269951,null,1368.9892406557594,null,695.30800406768856,null,13026.102825701824]
[null,"Total",261476.9474079299,null,77423.958818769999,null,100226.11831782997,null,39185.715757329985,null,478312.74030185991]

{"sheet":"RD 2017 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 2017 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",161682.49472954989,null,50122.091322749999,null,20763.633107640006,null,8213.0849608700046,null,240781.30412080992]
[null," - Number of loans",145252,null,9278,null,3027,null,2497,null,160054]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",154799.94418821999,null,46537.237362540021,null,15581.588693370006,null,6570.6397855099995,null,223489.41002964001]
[null," - repayment loans",114715.63526579001,null,41820.41185517003,null,14467.941442420008,null,4161.1778675099995,null,175165.16643089004]
[null," - interest-only ",40084.308922429984,null,4716.8255073699975,null,1113.6472509499997,null,2409.461918,null,48324.243598749978]
[null,"FlexLån®",2049.4409861700001,null,2269.1449438799996,null,1717.1749703800001,null,175.41010771999998,null,6211.1710081500005]
[null," - repayment loans",559.45489553000004,null,366.36013238999999,null,350.42255133999998,null,40.730309749999989,null,1316.9678890099999]
[null," - interest-only ",1489.9860906400002,null,1902.7848114899996,null,1366.7524190400002,null,134.67979797000001,null,4894.2031191400001]
[null,"FlexGaranti®, Rentedyk TM",4813.123624060001,null,99.900984099999974,null,46.364878829999995,null,25.295644320000001,null,4984.6851313100015]
[null," - repayment loans",1904.0005081100012,null,62.519066229999986,null,39.591322099999999,null,15.73826616,null,2021.8491626000011]
[null," - interest-only ",2909.1231159500003,null,37.381917869999988,null,6.7735567300000001,null,9.5573781600000007,null,2962.8359687100001]
[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",19.985931099999998,null,1215.8080322300002,null,3418.5045650600005,null,1441.73942332,null,6096.03795171]
[null," - repayment loans",6.2776592899999999,null,154.55073722,null,960.51508719999993,null,189.21901866000002,null,1310.5625023700002]
[null," - interest-only ",13.708271809999999,null,1061.2572950100002,null,2457.9894778600005,null,1252.5204046599999,null,4785.4754493400005]
[null," Total",161682.49472955006,null,50122.091322750028,null,20763.633107640006,null,8213.0849608699991,null,240781.30412081003]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",66604.161184379962,null,22991.109997350013,null,8139.7088346999999,null,597.10269143000016,null,98332.082707859969]
[null," - Other Sealand",30911.055165149999,null,4963.9846216000005,null,2870.7391835700005,null,1784.3175974000005,null,40530.09656772]
[null," - Region South Denmark",28831.335456080003,null,8175.5484200000037,null,3898.6716357199994,null,3637.2474160100005,null,44542.802927810008]
[null," - Region Central Jutland",26384.446551309986,null,10839.571956880003,null,3966.8362788899994,null,1275.0624838600004,null,42465.917270939986]
[null," - Region North Jutland",8951.4963726299993,null,2900.2083968399984,null,1853.1918765900004,null,919.35477217000016,null,14624.251418229998]
[null," - Other area",0,null,251.66793008000002,null,34.48529817,null,0,null,286.15322824999998]
[null,"Total",161682.49472954994,null,50122.091322750013,null,20763.633107639995,null,8213.0849608700028,null,240781.30412080997]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100674.36057837994,null,2098.7223711700003,null,1040.0397847900001,null,913.84358323000004,null,104726.96631756992]
[null," 2 - 5",53616.074905279966,null,4013.3411198899989,null,1641.4806592399998,null,1301.01245374,null,60571.90913814996]
[null," 5 - 20",7148.9974591499986,null,15156.263655750005,null,5134.3129029300007,null,2354.5600209100007,null,29794.134038740001]
[null," 20 - 50",243.06178673999997,null,11009.15764983,null,4314.1024860699999,null,2381.83920807,null,17948.161130709999]
[null," 50 - 100",0,null,6581.4636747300001,null,4052.817401960001,null,1117.29915413,null,11751.580230820004]
[null," 100 and above",0,null,11263.142851380006,null,4580.8798726499999,null,144.53054079000003,null,15988.553264820006]
[null,"Total",161682.49472954989,null,50122.091322750013,null,20763.633107639998,null,8213.0849608700009,null,240781.30412080992]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",10545.406668199999,null,3093.02861545,null,1843.7129770300003,null,213.58245614999998,null,15695.730716829998]
[null,"> 12 - ≤ 24 months",9183.7658347500019,null,2538.7016301399999,null,1069.8313410800001,null,406.31809393000003,null,13198.616899900002]
[null,"> 24 - ≤ 36 months",11247.571477589998,null,2135.4596576899999,null,1117.3790451399998,null,242.68530119999994,null,14743.095481619999]
[null,"> 36 - ≤ 60 months",20985.760888030007,null,3115.4518743599988,null,1254.4404886700004,null,517.83530265000002,null,25873.488553710009]
[null,"> 60 months",109719.98986098004,null,39239.449545110045,null,15478.269255719997,null,6832.6638069400042,null,171270.37246875008]
[null,"Total",161682.49472955006,null,50122.091322750042,null,20763.633107639998,null,8213.0849608700046,null,240781.30412081012]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",56664.281508073487,null,23543.782967127539,null,7515.2906882792959,null,2932.9464650451259,null,90656.301628525442]
[null,"20 - 40%",49812.724817603885,null,12672.42263487625,null,6914.8939715550505,null,2742.3480362594491,null,72142.389460294653]
[null,"40 - 60%",35311.747774795986,null,6924.8841046983289,null,4564.1956927204265,null,1900.1562487794399,null,48700.983820994174]
[null,"60 - 80%",16616.829718505789,null,3309.9335563123545,null,1161.5367633509502,null,513.70036346298855,null,21602.000401632085]
[null,"> 80 %",3276.9109101208182,null,3671.0680599955526,null,607.71599161426218,null,123.93384744299564,null,7679.6288091736278]
[null,"Total",161682.49472909997,null,50122.091323010027,null,20763.633107519985,null,8213.0849609899997,null,240781.30412061993]

{"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*",50,16]
[]
[null,"*2017Q1"]

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

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

{"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 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%",157.08888249386428,null,64.857354259951563,null,51.956957426121484,null,18.47069236040948,null,0.37706944053541186,null,292.3738865403468]
[null," - 20-40%",133.96679899134617,null,42.581418092427619,null,42.70280917093546,null,15.585271773198237,null,0.30286422827495135,null,234.83629802790747]
[null," - 40-60%",94.886089726454912,null,26.908934274186851,null,25.40100240187537,null,10.171324588354333,null,0.20295389475037523,null,157.36735099087147]
[null," - 60-80%",44.766729283375525,null,13.114133351500827,null,5.3708385911981926,null,3.1486078852633521,null,8.5635306573576223E-2,null,66.40030911133789]
[null," - >80%",10.974633393359722,null,9.915402507373221,null,2.6854876590995027,null,0.83136229890460966,null,3.1477129865685301E-2,null,24.406885858737056]
[null,"Total",441.68313388840062,null,157.37724248544009,null,128.11709524923,null,48.207258906130008,null,1,null,775.38473052920062]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",91.883311685629209,null,28.446766981497937,null,42.304425549105723,null,15.041962199180064,null,0.37146505088549919,null,177.67646641541293]
[null," - 20-40%",78.89998007269179,null,22.391781531385195,null,33.962033895335701,null,12.637837446818846,null,0.3091944254984681,null,147.89163294623154]
[null," - 40-60%",56.723660665391563,null,15.512890134635036,null,19.123687455498725,null,8.2042786848812099,null,0.20815777743568376,null,99.564516940406548]
[null," - 60-80%",26.934005929065989,null,7.1467036454248314,null,3.4669821772340552,null,2.6063294223821782,null,8.3949303020375607E-2,null,40.154021174107058]
[null," - >80%",7.0359890551513811,null,3.925816525826995,null,1.3689892406557593,null,0.69530800406768856,null,2.7233443159973413E-2,null,13.026102825701825]
[null,"Total",261.47694740792991,null,77.423958818769989,null,100.22611831782997,null,39.185715757329994,null,1,null,478.31274030185989]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",56.664281508073486,null,23.543782967127541,null,7.515290688279296,null,2.9329464650451258,null,0.37650889033772722,null,90.656301628525441]
[null," - 20-40%",49.812724817603879,null,12.672422634876249,null,6.9148939715550508,null,2.742348036259449,null,0.29961790315810705,null,72.142389460294623]
[null," - 40-60%",35.311747774795982,null,6.9248841046983287,null,4.5641956927204266,null,1.9001562487794399,null,0.20226231433897918,null,48.700983820994175]
[null," - 60-80%",16.616829718505787,null,3.3099335563123544,null,1.1615367633509504,null,0.51370036346298853,null,8.9716269627024323E-2,null,21.602000401632083]
[null," - >80%",3.2769109101208183,null,3.6710680599955525,null,0.60771599161426226,null,0.12393384744299564,null,3.1894622538162269E-2,null,7.6796288091736287]
[null,"Total",161.68249472909994,null,50.122091323010025,null,20.763633107519986,null,8.2130849609899972,null,0.99999999999999989,null,240.78130412061998]

{"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 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%",71.113398557902627,null,205.94585125428881,null,15.314636728154744,null,292.37388654034618]
[null," - 20-40%",46.986334919392114,null,173.45364273467371,null,14.396320373841426,null,234.83629802790725]
[null," - 40-60%",26.913372785566782,null,118.48283017483183,null,11.971148030472744,null,157.36735099087136]
[null," - 60-80%",11.005602528575698,null,48.524144983495162,null,6.870561599266952,null,66.400309111337819]
[null," - >80%",6.0593857167954388,null,13.912830737865532,null,4.4346694040760868,null,24.406885858737056]
[null,"Total",162.07809450823268,null,560.31929988515503,null,52.987336135811958,null,775.3847305291996]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",38.073786854668192,null,128.14892597468321,null,11.453753586061641,null,177.67646641541305]
[null," - 20-40%",25.716588624031779,null,111.3112455176668,null,10.863798804532848,null,147.89163294623143]
[null," - 40-60%",14.869172559291654,null,75.703476963439243,null,8.9918674176756817,null,99.564516940406577]
[null," - 60-80%",5.8039418025993204,null,29.229798522088988,null,5.1202808494187426,null,40.154021174107051]
[null," - >80%",2.7533901766322479,null,7.143481190228699,null,3.1292314588408829,null,13.026102825701829]
[null,"Total",87.216880017223204,null,351.53692816810695,null,39.558932116529796,null,478.31274030185995]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",22.112968196672615,null,65.735205361618696,null,2.8081280702341682,null,90.656301628525469]
[null," - 20-40%",14.84183515657444,null,54.559863766017479,null,2.7406905377027484,null,72.142389460294666]
[null," - 40-60%",8.3864814691126046,null,37.882590920993195,null,2.431911430888321,null,48.700983820994118]
[null," - 60-80%",3.0061850070280283,null,17.19860424237606,null,1.3972111522279853,null,21.602000401632072]
[null," - >80%",1.2770448595524015,null,5.5127594161625035,null,0.88982453345872348,null,7.6796288091736287]
[null,"Total",49.624514688940096,null,180.88902370716795,null,10.267765724511946,null,240.78130412062001]

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

{"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",50122091322.75,49870423392.670013]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",20763633107.640003,20729147809.470005]
["S-Landbrug","S",null,"Landbrug",8213084960.8700008,8213084960.8700008]
["S-Privat","S",null,"Privat",161682494729.55008,161682494729.55008]
["S Total-","S Total","S Total",null,240781304120.81006,240495150892.56009]
["T-Boligudl","T","T","Boligudl",77423958818.409821,74858646000.949829]
["T-Erhverv","T",null,"Erhverv",100226118317.6698,83050944759.649811]
["T-Landbrug","T",null,"Landbrug",39185715757.219994,39185715757.219994]
["T-Privat","T",null,"Privat",261476947407.86047,261476947407.86047]
["T Total-","T Total","T Total",null,478312740301.1601,458572253925.68011]
["Ø-Boligudl","Ø","Ø","Boligudl",29831192343.709988,29630265150.469986]
["Ø-Erhverv","Ø",null,"Erhverv",7127343823.7600031,6835019999.8200035]
["Ø-Landbrug","Ø",null,"Landbrug",808458187.72000015,808458187.72000015]
["Ø-Privat","Ø",null,"Privat",18523691751.499962,18523691751.499962]
["Ø Total-","Ø Total","Ø Total",null,56290686106.689957,55797435089.509956]
["Grand Total-","Grand Total","Grand Total",null,775384730528.66003,754864839907.75]
[]
[]
[]
[]
[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":261476947407.86047}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":74858646000.949829}]
[null,null,"T-Erhverv","Erhverv","Commercial",83050944759.649811]
[null,null,"T-Landbrug","Landbrug","Agriculture",39185715757.219994]
[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":19740486375.480042}]
[]
[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":161682494729.55008}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":49870423392.670013}]
[null,null,"S-Erhverv","Erhverv","Commercial",20729147809.470005]
[null,null,"S-Landbrug","Landbrug","Agriculture",8213084960.8700008]
[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":286153228.24996948}]
[]
[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":18523691751.499962}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":29630265150.469986}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6835019999.8200035]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",808458187.72000015]
[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":493251017.18000793}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":441683133888.91046}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":154359334544.08984}]
[null,null,null,null,"Commercial",110615112568.93982]
[null,null,null,null,"Agriculture",48207258905.809998]
[null,null,null,null,"Nordic",20519890620.910019]

{"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",4565904556.9499998,118361523.20999999]
[null,"F1",24443577853.060001,9002236144.7900009]
[null,"F3",43885044391.389999,10547401788.889999]
[null,"F5",65050351414.389999,22352564468.299999]
[null,"Fixed",40302497708.989998,8280763309.5699997]
[null,"Floaters",14186948518.08,69217661156.75]
[null,"Øv. flex",14475291499.68,18103868912.560001]
["J Total",null,206909615942.53995,137622857304.07001]
["N","CapFloat",12179925147.719999,942035426.88999999]
[null,"F1",17099941745.549999,9449981537.2000008]
[null,"F3",27997996662.029999,9988153418.7600002]
[null,"F5",44560296153.959999,42871730227.860001]
[null,"Fixed",121096727031.08,89654872244.300003]
[null,"Floaters",6100397493.9499998,35113292906.18]
[null,"Øv. flex",5738233712.1099997,8058673574.6700001]
["N Total",null,234773517946.39999,196078739335.86002]