{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2017 Q2 Total","RD 2017 Q2 Cap T","RD 2017 Q2 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 Q2 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 Q2 - 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",444503.3167770498,null,158213.58616195977,null,126535.46360674003,null,48004.771171730004,null,777257.13771747949]
[null," - Number of loans",410154,null,36830,null,13385,null,13887,null,474256]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",163672.35514658998,null,74753.277379550025,null,16410.733858660002,null,7020.3809643299983,null,261856.74734913002]
[null," - repayment loans",122162.02705326999,null,69849.493421130013,null,15303.497046000002,null,4511.6045831499987,null,211826.62210355001]
[null," - interest-only ",41510.328093319979,null,4903.783958420001,null,1107.2368126600002,null,2508.7763811799987,null,50030.125245579977]
[null,"FlexLån®",244087.56948298006,null,63755.756855139996,null,40205.427640779999,null,25446.132705020009,null,373494.88668392005]
[null," - repayment loans",93042.931316660004,null,39572.158802439997,null,20899.424112699988,null,8141.1386751500022,null,161655.65290694998]
[null," - interest-only ",151044.63816632007,null,24183.598052700003,null,19306.003528080015,null,17304.994029870006,null,211839.2337769701]
[null,"FlexGaranti®, Rentedyk TM",16143.073164860001,null,484.65772432999995,null,281.65567447999996,null,252.36743434000005,null,17161.753998009997]
[null," - repayment loans",11926.553337709998,null,426.21353153999991,null,270.45995853999995,null,213.69616736,null,12836.922995149998]
[null," - interest-only ",4216.5198271500012,null,58.44419279000001,null,11.195715939999998,null,38.671266980000006,null,4324.8310028600008]
[null,"FlexKort®",20488.836608820002,null,2456.5811330799997,null,2652.3144532300007,null,8076.1323865300028,null,33673.864581660011]
[null," - repayment loans",6127.6138736299981,null,1285.3826826799996,null,1401.8359830400002,null,2068.8207587000006,null,10883.65329805]
[null," - interest-only ",14361.222735190006,null,1171.1984504000004,null,1250.4784701900003,null,6007.3116278300022,null,22790.21128361001]
[null,"Other floating rate loans",111.4823738,null,16763.31306986,null,66985.331979590017,null,7209.7576815100019,null,91069.885104760004]
[null," - repayment loans",50.305574010000008,null,4880.3207988200011,null,24697.289323140019,null,1936.1295837499999,null,31564.04527972002]
[null," - interest-only ",61.176799789999997,null,11882.992271040001,null,42288.042656449987,null,5273.6280977600018,null,59505.839825039991]
[null," Total",444503.31677705009,null,158213.58616196006,null,126535.46360674003,null,48004.771171730012,null,777257.13771748007]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",192433.87434630006,null,59542.929885350008,null,48008.385079880034,null,3515.1511552900006,null,303500.34046682005]
[null," - Other Sealand",86167.794513670291,null,17011.183480250002,null,10809.334621229986,null,13573.234774050003,null,127561.54738920028]
[null," - Region South Denmark",70722.48726385989,null,28516.220589609988,null,25246.124185059998,null,16185.54168394,null,140670.37372246987]
[null," - Region Central Jutland",72355.125194150169,null,37021.883028479999,null,19194.37137035,null,8831.8876147299925,null,137403.26720771016]
[null," - Region North Jutland",22823.248327939971,null,13125.464047629986,null,6019.3372095099967,null,5898.9559437200005,null,47867.005528799957]
[null," - Other area",0.78713113000000001,null,2995.9051306399997,null,17257.911140710003,null,0,null,20254.603402480003]
[null,"Total",444503.31677705032,null,158213.58616196,null,126535.46360674003,null,48004.771171729997,null,777257.13771748031]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",252465.23847237977,null,8550.6681588100018,null,3513.4083265699992,null,3287.9102157999969,null,267817.22517355974]
[null," 2 - 5",162486.80346597981,null,11955.722251570001,null,5531.8263960300055,null,6508.7264251600009,null,186483.07853873985]
[null," 5 - 20",28592.48611632999,null,45034.508142259932,null,20149.769436579969,null,15502.613398409991,null,109279.37709357988]
[null," 20 - 50",901.94228205000024,null,37109.28430461001,null,18297.092074550015,null,14583.461529199994,null,70891.78019041002]
[null," 50 - 100",56.846440310000006,null,22138.730888199989,null,16463.533593259999,null,6397.6277021499955,null,45056.738623919984]
[null," 100 and above",0,null,33424.672416510002,null,62579.833779749992,null,1724.4319010100003,null,97728.938097269987]
[null,"Total",444503.31677704962,null,158213.58616195992,null,126535.46360673996,null,48004.771171729983,null,777257.13771747949]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",26736.394711150024,null,7385.5689970399981,null,7235.752887550002,null,1032.1241454999997,null,42389.840741240019]
[null,"> 12 - ≤ 24 months",21038.905148340004,null,7025.9215414300033,null,8356.1852915399995,null,1584.61376716,null,38005.625748470004]
[null,"> 24 - ≤ 36 months",22719.548759130008,null,6848.6843280199982,null,6356.2683208300023,null,1370.3984052199996,null,37294.899813200012]
[null,"> 36 - ≤ 60 months",43529.057952600022,null,12130.284709279998,null,15554.551807550015,null,2219.2487653099997,null,73433.14323474004]
[null,"> 60 months",330479.41020583,null,124823.12658619002,null,89032.705299269976,null,41798.386088540043,null,586133.62817983003]
[null,"Total",444503.31677705003,null,158213.58616196003,null,126535.46360673998,null,48004.771171730041,null,777257.13771748019]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",158764.75992736549,null,65085.552137409548,null,53150.365546123321,null,18199.010894742441,null,295199.68850564072]
[null,"20 - 40%",135187.94731283808,null,42662.249728202769,null,42564.239701040016,null,15566.627027069733,null,235981.06376915058]
[null,"40 - 60%",95249.499975411571,null,26848.023610006705,null,23329.485973709088,null,10408.870291342333,null,155835.8798504697]
[null,"60 - 80%",44516.278743773153,null,13177.947895736728,null,4891.3288582020123,null,3076.6357988968457,null,65662.19129660874]
[null,"> 80 %",10784.830816691963,null,10439.812791014067,null,2600.0435276053595,null,753.6271600586374,null,24578.314295370026]
[null,"Total",444503.31677608017,null,158213.58616236981,null,126535.4636066798,null,48004.771172109991,null,777257.13771723979]

{"sheet":"RD 2017 Q2 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 Q2 - 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",262913.3985480704,null,78299.782104000275,null,98713.918105820063,null,38882.947272110017,null,478810.04603000073]
[null," - Number of loans",226697,null,16994,null,8825,null,10581,null,263097]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",21.494259669999998,null,0,null,0,null,1.01554503,null,22.5098047]
[null," - repayment loans",1.7869478999999999,null,0,null,0,null,0,null,1.7869478999999999]
[null," - interest-only ",19.70731177,null,0,null,0,null,1.01554503,null,20.722856800000002]
[null,"FlexLån®",242320.45181301012,null,61573.875921380008,null,38649.154813489993,null,25259.655499589993,null,367803.13804747007]
[null," - repayment loans",92686.090421500063,null,39216.737560099995,null,20675.958142429994,null,8088.7050267399973,null,160667.49115077005]
[null," - interest-only ",149634.36139151006,null,22357.138361280002,null,17973.196671059999,null,17170.950472849996,null,207135.64689670008]
[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®",20488.836608820002,null,2456.5811330800007,null,2652.3144532299993,null,8076.1323865299937,null,33673.864581659996]
[null," - repayment loans",6127.6138736299981,null,1285.3826826800002,null,1401.83598304,null,2068.8207586999997,null,10883.653298049998]
[null," - interest-only ",14361.222735190006,null,1171.1984504000004,null,1250.4784701899998,null,6007.311627829994,null,22790.211283610002]
[null,"Other floating rate loans",82.615866570000009,null,14269.325049540001,null,57412.448839099961,null,5546.1438409600014,null,77310.533596169975]
[null," - repayment loans",45.873583600000011,null,4518.3066084700004,null,22021.349409749997,null,1680.2567456300001,null,28265.786347449997]
[null," - interest-only ",36.742282969999998,null,9751.0184410700022,null,35391.099429349968,null,3865.8870953300011,null,49044.74724871997]
[null," Total",262913.39854807011,null,78299.782104000013,null,98713.918105819947,null,38882.947272109996,null,478810.04603000014]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",119863.50086097005,null,26891.648461800018,null,37610.491353129997,null,2870.6972225200016,null,187236.33789842008]
[null," - Other Sealand",49836.50790605996,null,7734.4225506599987,null,7295.1724234300018,null,11497.343848789998,null,76363.446728939962]
[null," - Region South Denmark",37859.921552970009,null,14796.720445789997,null,19443.755562239992,null,12218.995501819998,null,84319.393062819989]
[null," - Region Central Jutland",42726.778225060028,null,18986.582721800001,null,13631.372091189998,null,7374.4162043599972,null,82719.149242410029]
[null," - Region North Jutland",12626.690003009993,null,7351.5276854100011,null,3803.81041473,null,4921.494494620003,null,28703.522597769996]
[null," - Other area",0,null,2538.8802385399999,null,16929.316261100001,null,0,null,19468.196499640002]
[null,"Total",262913.39854806999,null,78299.782104000013,null,98713.91810581999,null,38882.947272110003,null,478810.04603000014]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",136041.1959489201,null,5344.3487357100066,null,2050.2660789299989,null,2125.1129713900009,null,145560.92373495011]
[null," 2 - 5",105231.16467062001,null,6156.2262895199983,null,3739.656491339998,null,5028.4875873200017,null,120155.53503880002]
[null," 5 - 20",20952.244045149997,null,20612.793251779989,null,14321.676880069999,null,12927.524557249999,null,68814.238734249986]
[null," 20 - 50",631.94744307000008,null,16601.044673789995,null,13282.44071600001,null,11950.228912679997,null,42465.66174553999]
[null," 50 - 100",56.846440310000006,null,11987.703023839997,null,10927.869397210003,null,5272.5342143600019,null,28244.953075720001]
[null," 100 and above",0,null,17597.666129360001,null,54392.008542270007,null,1579.0590291100002,null,73568.733700740006]
[null,"Total",262913.39854807011,null,78299.782103999984,null,98713.918105820005,null,38882.947272110003,null,478810.04603000014]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",14106.121100659993,null,3985.5404032200004,null,4835.4485259100011,null,762.75761482000007,null,23689.867644609993]
[null,"> 12 - ≤ 24 months",12254.610973329989,null,4351.8537774400029,null,7044.2644097399989,null,1206.0980161199996,null,24856.827176629991]
[null,"> 24 - ≤ 36 months",10954.792088300008,null,4388.9042044299958,null,5095.139884879999,null,1076.1633458000003,null,21514.999523409999]
[null,"> 36 - ≤ 60 months",23137.270486789985,null,8950.6263312799965,null,14027.263633470007,null,1694.8129556800016,null,47809.973407219994]
[null,"> 60 months",202460.60389898991,null,56622.857387629963,null,67711.801651819915,null,34143.115339690034,null,360938.37827812991]
[null,"Total",262913.39854806988,null,78299.782103999969,null,98713.918105819917,null,38882.947272110032,null,478810.04602999985]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",92959.719838692952,null,28565.250431729139,null,43264.725281269137,null,14779.003011326782,null,179568.698563018]
[null,"20 - 40%",79646.083973928355,null,22716.994181516588,null,33941.190711307769,null,12606.327403277357,null,148910.59627003007]
[null,"40 - 60%",56833.213112732519,null,15532.938460928432,null,17165.316432248583,null,8373.6239426032098,null,97905.091948512738]
[null,"60 - 80%",26618.719284278606,null,7280.5118382458086,null,3009.9049940289165,null,2504.2194225393405,null,39413.355539092663]
[null,"> 80 %",6855.6623380775418,null,4204.0871917300237,null,1332.7806868956181,null,619.77349270333923,null,13012.30370940652]
[null,"Total",262913.39854770998,null,78299.782104149999,null,98713.91810575001,null,38882.94727245003,null,478810.04603005998]

{"sheet":"RD 2017 Q2 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 Q2 - 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",164016.53520304995,null,50842.00395057998,null,20813.397704530013,null,8380.1224352400077,null,244052.0592934]
[null," - Number of loans",146965,null,9407,null,3023,null,2530,null,161925]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",157507.72334838001,null,47383.953365229965,null,15906.789220970006,null,6763.6668917400002,null,227562.13282631998]
[null," - repayment loans",116141.12411046002,null,42487.547167469966,null,14801.296969040004,null,4255.9060555900005,null,177685.87430256]
[null," - interest-only ",41366.599237919967,null,4896.4061977599995,null,1105.4922519299998,null,2507.7608361499992,null,49876.258523759971]
[null,"FlexLån®",1767.1176699699993,null,2181.8809337599992,null,1556.2728272899997,null,174.09188967000003,null,5679.3633206899985]
[null," - repayment loans",356.84089515999995,null,355.42124234000011,null,223.46597027000001,null,40.048332649999999,null,975.77644041999997]
[null," - interest-only ",1410.2767748099996,null,1826.4596914199992,null,1332.8068570199998,null,134.04355702000001,null,4703.5868802699988]
[null,"FlexGaranti®, Rentedyk TM",4723.4145708899996,null,97.082383199999981,null,46.007149590000004,null,25.180011739999998,null,4891.6841154200001]
[null," - repayment loans",1872.3955953099994,null,59.619017409999998,null,39.217397069999997,null,15.599781559999998,null,1986.8317913499993]
[null," - interest-only ",2851.0189755800002,null,37.46336578999999,null,6.7897525199999995,null,9.5802301799999992,null,2904.8523240700001]
[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",18.279613810000001,null,1179.08726839,null,3304.3285066799999,null,1417.1836420900001,null,5918.8790309699989]
[null," - repayment loans",2.5120963500000002,null,151.51632432999997,null,919.58007767000061,null,187.24840909000002,null,1260.8569074400004]
[null," - interest-only ",15.767517460000001,null,1027.5709440599999,null,2384.7484290099992,null,1229.9352329999999,null,4658.0221235299987]
[null," Total",164016.53520304998,null,50842.003950579965,null,20813.397704530005,null,8380.1224352400004,null,244052.0592934]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",68087.876040930059,null,23502.36555387,null,8196.4678098000004,null,602.57510313000012,null,100389.28450773006]
[null," - Other Sealand",31221.692688399969,null,4988.2490800500009,null,2876.7828128199981,null,1898.1076056999993,null,40984.832186969972]
[null," - Region South Denmark",29085.76946422999,null,8197.4944804400002,null,3881.5128505699977,null,3668.5108988699999,null,44833.287694109989]
[null," - Region Central Jutland",26660.153664769987,null,10963.48532560001,null,3923.6572375699998,null,1298.0138505999994,null,42845.310078539995]
[null," - Region North Jutland",8961.043344720003,null,2938.5883513800022,null,1900.4706990699997,null,912.91497694000032,null,14713.017372110005]
[null," - Other area",0,null,251.82115924000001,null,34.506294700000005,null,0,null,286.32745394]
[null,"Total",164016.53520304998,null,50842.003950580009,null,20813.397704529994,null,8380.1224352399986,null,244052.0592934]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",101095.71842945003,null,2112.0892714299989,null,1036.1019565399999,null,917.09944142999984,null,105161.00909885]
[null," 2 - 5",55109.711375230014,null,4008.06625192,null,1625.9202654299993,null,1332.3571390900001,null,62076.05503167001]
[null," 5 - 20",7541.110559390002,null,15362.73178679,null,5046.9873303600007,null,2381.3860893799997,null,30332.215765920006]
[null," 20 - 50",269.99483898,null,11341.771235960003,null,4465.3639910799993,null,2499.5180320000004,null,18576.648098019999]
[null," 50 - 100",0,null,6663.4502416700034,null,4113.7839149200008,null,1105.15276354,null,11882.386920130004]
[null," 100 and above",0,null,11353.89516281,null,4525.2402461999982,null,144.60896980000001,null,16023.744378809997]
[null,"Total",164016.53520305007,null,50842.003950580001,null,20813.397704529998,null,8380.1224352400004,null,244052.05929340003]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",12592.898086250001,null,3357.9331759700012,null,1946.4778653499998,null,269.36653067999998,null,18166.675658250002]
[null,"> 12 - ≤ 24 months",8754.4203343899953,null,2620.3433088299998,null,1065.3595250400001,null,375.93486361000026,null,12816.058031869998]
[null,"> 24 - ≤ 36 months",11727.212149540004,null,2383.5339550400004,null,1233.2646185199997,null,288.99531787999996,null,15633.006040980004]
[null,"> 36 - ≤ 60 months",20117.031172779996,null,3002.0373138899981,null,1276.98487041,null,500.32842118999997,null,24896.381778269992]
[null,"> 60 months",110824.97346008988,null,39478.156196850017,null,15291.310825210006,null,6945.4973018800001,null,172539.9377840299]
[null,"Total",164016.53520304986,null,50842.003950580016,null,20813.397704530005,null,8380.1224352400004,null,244052.05929339991]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",57636.574722632649,null,23979.857773131931,null,7891.0937155254314,null,2969.7262877973667,null,92477.252499087394]
[null,"20 - 40%",50555.059185788072,null,12684.165866180057,null,6868.0511099213509,null,2769.3885719339246,null,72876.664733823403]
[null,"40 - 60%",35737.945565240901,null,7033.8744107100911,null,4407.3654454156713,null,1972.3365353754268,null,49151.521956742086]
[null,"60 - 80%",16768.667915013619,null,3324.153355481671,null,1113.876690161575,null,545.57910979336486,null,21752.277070450229]
[null,"> 80 %",3318.2878137347566,null,3819.9525453562514,null,533.01074355597427,null,123.09193039991719,null,7794.3430330469]
[null,"Total",164016.53520240998,null,50842.003950860009,null,20813.397704580002,null,8380.1224352999998,null,244052.05929315003]

{"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*",45,32]
[]
[null,"*2017Q2"]

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

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

{"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 Q2"]
[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%",158.76475992736547,null,65.08555213740955,null,53.150365546123318,null,18.199010894742443,null,0.37979669041396724,null,295.19968850564084]
[null," - 20-40%",135.18794731283808,null,42.662249728202767,null,42.564239701040016,null,15.566627027069732,null,0.30360745796714533,null,235.98106376915058]
[null," - 40-60%",95.249499975411581,null,26.848023610006706,null,23.329485973709087,null,10.408870291342334,null,0.20049462692378853,null,155.83587985046972]
[null," - 60-80%",44.516278743773157,null,13.177947895736729,null,4.8913288582020122,null,3.076635798896846,null,8.4479367393723623E-2,null,65.662191296608739]
[null," - >80%",10.784830816691963,null,10.439812791014067,null,2.6000435276053597,null,0.75362716005863739,null,3.1621857301375372E-2,null,24.578314295370024]
[null,"Total",444.50331677608028,null,158.21358616236984,null,126.5354636066798,null,48.004771172109983,null,1.0000000000000002,null,777.25713771723986]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",92.959719838692948,null,28.56525043172914,null,43.264725281269136,null,14.779003011326783,null,0.37503118418644155,null,179.56869856301802]
[null," - 20-40%",79.646083973928356,null,22.716994181516586,null,33.941190711307769,null,12.606327403277357,null,0.31100140338467613,null,148.91059627003006]
[null," - 40-60%",56.833213112732523,null,15.532938460928433,null,17.165316432248581,null,8.37362394260321,null,0.20447585166658389,null,97.905091948512762]
[null," - 60-80%",26.618719284278605,null,7.2805118382458085,null,3.0099049940289162,null,2.5042194225393404,null,8.2315222635529817E-2,null,39.41335553909267]
[null," - >80%",6.8556623380775417,null,4.2040871917300233,null,1.3327806868956182,null,0.61977349270333926,null,2.7176338126768545E-2,null,13.012303709406522]
[null,"Total",262.91339854770996,null,78.299782104149998,null,98.713918105750011,null,38.882947272450032,null,1,null,478.81004603005999]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",57.636574722632652,null,23.979857773131936,null,7.8910937155254315,null,2.9697262877973665,null,0.37892428675639955,null,92.477252499087385]
[null," - 20-40%",50.555059185788068,null,12.684165866180058,null,6.8680511099213506,null,2.7693885719339248,null,0.29861114446195086,null,72.876664733823404]
[null," - 40-60%",35.737945565240899,null,7.0338744107100908,null,4.407365445415671,null,1.9723365353754267,null,0.20139769399651883,null,49.151521956742087]
[null," - 60-80%",16.768667915013619,null,3.3241533554816707,null,1.1138766901615751,null,0.54557910979336488,null,8.9129660013734499E-2,null,21.75227707045023]
[null," - >80%",3.3182878137347567,null,3.8199525453562511,null,0.53301074355597422,null,0.12309193039991718,null,3.1937214771396397E-2,null,7.794343033046899]
[null,"Total",164.01653520241001,null,50.842003950860004,null,20.813397704580002,null,8.3801224353000006,null,1,null,244.05205929314997]

{"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 Q2"]
[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%",73.491257264793632,null,207.23946490180006,null,14.46896633904681,null,295.19968850564049]
[null," - 20-40%",48.606589857022222,null,173.8544458573318,null,13.520028054797097,null,235.98106376915112]
[null," - 40-60%",28.07952512365862,null,116.59354486485515,null,11.162809861955857,null,155.83587985046961]
[null," - 60-80%",11.490029275543582,null,47.816150226328126,null,6.3560117947370474,null,65.662191296608754]
[null," - >80%",6.6240265343871547,null,13.906124047717251,null,4.048163713265561,null,24.578314295369964]
[null,"Total",168.29142805540519,null,559.40972989803242,null,49.55597976380237,null,777.25713771723997]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",39.532179663041632,null,129.19750989468804,null,10.839009005288386,null,179.56869856301805]
[null," - 20-40%",26.584024977667681,null,112.10175707635925,null,10.224814216003004,null,148.91059627002994]
[null," - 40-60%",15.519103599402943,null,74.010963375822186,null,8.3750249732875321,null,97.905091948512663]
[null," - 60-80%",6.0674602201936363,null,28.623270663110901,null,4.7226246557881826,null,39.41335553909272]
[null," - >80%",3.1212196386498996,null,7.0126792256749857,null,2.8784048450816275,null,13.012303709406513]
[null,"Total",90.823988098955795,null,350.94618023565539,null,37.03987769544873,null,478.81004603005994]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",23.31641102065144,null,66.490986730178591,null,2.6698547482573738,null,92.477252499087413]
[null," - 20-40%",15.761838607205402,null,54.526487614145076,null,2.5883385124728777,null,72.876664733823347]
[null," - 40-60%",8.9727131860514717,null,37.875355972134173,null,2.3034527985565507,null,49.151521956742194]
[null," - 60-80%",3.2911286074479031,null,17.136770035925821,null,1.3243784270765073,null,21.75227707045023]
[null," - >80%",1.3821898248912181,null,5.5536665340541989,null,0.8584866741014795,null,7.7943430330468964]
[null,"Total",52.724281246247436,null,181.58326688643785,null,9.7445111604647892,null,244.05205929315008]

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

{"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",50842003950.579979,50590182791.339973]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",20813397704.529984,20778891409.829987]
["S-Landbrug","S",null,"Landbrug",8380122435.2400055,8380122435.2400055]
["S-Privat","S",null,"Privat",164016535203.04996,164016535203.04996]
["S Total-","S Total","S Total",null,244052059293.3999,243765731839.4599]
["T-Boligudl","T","T","Boligudl",78299782104.000275,75760901865.460297]
["T-Erhverv","T",null,"Erhverv",98713918105.820129,81784601844.719955]
["T-Landbrug","T",null,"Landbrug",38882947272.109978,38882947272.109978]
["T-Privat","T",null,"Privat",262913398548.06979,262913398548.06979]
["T Total-","T Total","T Total",null,478810046030.00018,459341849530.35999]
["Ø-Boligudl","Ø","Ø","Boligudl",29071800107.380001,28869199797.350002]
["Ø-Erhverv","Ø",null,"Erhverv",7008147796.3900013,6714059211.4800024]
["Ø-Landbrug","Ø",null,"Landbrug",741701464.38000035,741701464.38000035]
["Ø-Privat","Ø",null,"Privat",17573383025.929977,17573383025.929977]
["Ø Total-","Ø Total","Ø Total",null,54395032394.079979,53898343499.139977]
["Grand Total-","Grand Total","Grand Total",null,777257137717.47998,757005924868.95984]
[]
[]
[]
[]
[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":262913398548.06979}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":75760901865.460297}]
[null,null,"T-Erhverv","Erhverv","Commercial",81784601844.719955]
[null,null,"T-Landbrug","Landbrug","Agriculture",38882947272.109978]
[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":19468196499.640137}]
[]
[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":164016535203.04996}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":50590182791.339973}]
[null,null,"S-Erhverv","Erhverv","Commercial",20778891409.829987]
[null,null,"S-Landbrug","Landbrug","Agriculture",8380122435.2400055]
[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":286327453.94000244}]
[]
[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":17573383025.929977}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":28869199797.350002}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6714059211.4800024]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",741701464.38000035]
[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":496688894.93999481}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":444503316777.04974}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":155220284454.15027}]
[null,null,null,null,"Commercial",109277552466.02994]
[null,null,null,null,"Agriculture",48004771171.72998]
[null,null,null,null,"Nordic",20251212848.520134]

{"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",4216519827.1599998,108311175.73]
[null,"F1",24277696349.400002,8726440619.6299992]
[null,"F3",41275950300.709999,10444605723.02]
[null,"F5",71110766760.869995,22912706742.830002]
[null,"Fixed",41510328093.32,8519797152.25]
[null,"Floaters",14422399534.969999,67873651573.849998]
[null,"Øv. flex",14380224755.139999,18710842525.209999]
["J Total",null,211193885621.57001,137296355512.51999]
["N","CapFloat",11926553337.67,910369657.46000004]
[null,"F1",15801827242.629999,8690678246.4400005]
[null,"F3",25021107929.950001,9464749629.3700008]
[null,"F5",47227113083.870003,42660661702.25]
[null,"Fixed",122162027053.28,89664595050.100006]
[null,"Floaters",6177919447.71,36269779130.07]
[null,"Øv. flex",4992883060.3199997,7796632012.1499996]
["N Total",null,233309431155.42999,195457465427.84]