{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2016 Q1 Total","RD 2016 Q1 Cap T","RD 2016 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 2016 Q1 Total","index":0,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,2,5,10],[64,1,64,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",429723.98626137059,null,149859.9876761504,null,127141.25609131002,null,48329.172802429959,null,755054.40283126093]
[null," - Number of loans",411160,null,38035,null,14312,null,14496,null,478003]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",148026.97239269016,null,69625.513654419963,null,14242.644238969991,null,5782.6839691399991,null,237677.81425522009]
[null," - repayment loans",111160.23952259017,null,66210.179233739953,null,13108.721051299992,null,3840.4911225800006,null,194319.63093021011]
[null," - interest-only ",36866.732870099986,null,3415.3344206800007,null,1133.9231876700001,null,1942.192846559999,null,43358.183325009981]
[null,"FlexLån®",246202.43593428005,null,60926.773280839996,null,43690.135110220013,null,25461.992495200011,null,376281.33682054008]
[null," - repayment loans",94335.433803939843,null,37883.111431440011,null,20368.790420900019,null,8040.9552914300039,null,160628.29094770987]
[null," - interest-only ",151867.0021303402,null,23043.661849399989,null,23321.344689319994,null,17421.037203770007,null,215653.04587283023]
[null,"FlexGaranti®, Rentedyk TM",19714.613509489991,null,614.58033025999998,null,344.61294837000014,null,339.74796229000003,null,21013.554750409992]
[null," - repayment loans",12013.946317449996,null,478.87737412000001,null,310.37360617000013,null,225.62810032000002,null,13028.825398059998]
[null," - interest-only ",7700.6671920399931,null,135.70295614,null,34.239342200000003,null,114.11986197,null,7984.7293523499939]
[null,"FlexKort®",15651.398073720004,null,3282.5246529899996,null,2725.2988494200004,null,8269.6167632099987,null,29928.83833934]
[null," - repayment loans",4666.4887341599961,null,1255.6217197199994,null,1511.7385846700004,null,2025.7372359799999,null,9459.5862745299946]
[null," - interest-only ",10984.909339560007,null,2026.9029332700004,null,1213.5602647500002,null,6243.8795272299994,null,20469.252064810004]
[null,"Other floating rate loans",128.56635119000001,null,15410.595757640001,null,66138.564944329992,null,8475.1316125900012,null,90152.858665749998]
[null," - repayment loans",33.769251519999997,null,3900.0460828699988,null,21974.184165740018,null,1858.5227248099998,null,27766.522224940018]
[null," - interest-only ",94.797099670000009,null,11510.549674770002,null,44164.38077858997,null,6616.6088877800021,null,62386.336440809973]
[null," Total",429723.98626137018,null,149859.98767614996,null,127141.25609131,null,48329.17280243001,null,755054.40283126011]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",179462.11991676976,null,55894.592696619962,null,48488.32220266993,null,3447.9037285899985,null,287292.93854464975]
[null," - Other Sealand",85865.106793740051,null,16702.226870729995,null,10290.715787539995,null,13392.009211699988,null,126250.05866371002]
[null," - Region South Denmark",69951.629735049981,null,27403.252791179966,null,25617.589990409972,null,16237.521606479997,null,139209.99412311995]
[null," - Region Central Jutland",71448.605113620011,null,35124.036618689919,null,20062.196552159981,null,9126.8879185999976,null,135761.72620306991]
[null," - Region North Jutland",22995.308788500035,null,13171.116075439999,null,6419.6825159600039,null,6124.8503370600019,null,48710.957716960045]
[null," - Other area",1.21591369,null,1564.7626234899999,null,16262.749042569998,null,0,null,17828.727579749997]
[null,"Total",429723.98626136989,null,149859.98767614985,null,127141.25609130987,null,48329.172802429988,null,755054.40283125977]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",257758.86740994977,null,9163.3216795200024,null,3830.0700653400049,null,3411.5479278100001,null,274163.80708261975]
[null," 2 - 5",148365.94905840006,null,12614.845134170007,null,5910.3772616200094,null,6780.5627343499991,null,173671.73418854008]
[null," 5 - 20",22908.388683639991,null,44080.398322910085,null,21547.216772870022,null,15677.132602520003,null,104213.13638194012]
[null," 20 - 50",584.15613879000011,null,35769.780286189904,null,19098.771404770017,null,14583.057455089989,null,70035.765284839901]
[null," 50 - 100",106.62497059,null,20588.99508466,null,15919.810404379996,null,6228.8520355699966,null,42844.282495199994]
[null," 100 and above",0,null,27642.647168700005,null,60835.010182329999,null,1648.0200470900002,null,90125.677398119995]
[null,"Total",429723.98626136989,null,149859.98767615002,null,127141.25609131006,null,48329.172802429995,null,755054.40283125965]
[]
[null,"Bond debt outstanding by seasoning*"]
[null,"≤ 12 months",22700,null,10560,null,9460.0000000000073,null,3820,null,46540.000000000007]
[null,"> 12 - ≤ 24 months",25570.000000000004,null,14210,null,7469.9999999999964,null,2380,null,49630]
[null,"> 24 - ≤ 36 months",48220.000000000007,null,8600,null,8819.9999999999927,null,3100,null,68740]
[null,"> 36 - ≤ 60 months",55830.000000000007,null,13309.999999999998,null,11610.000000000009,null,4410,null,85160.000000000015]
[null,"> 60 months",277404,null,103180,null,89781,null,34619,null,504984]
[null,"Total",429724,null,149860,null,127141,null,48329,null,755054]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",148024.13389082695,null,59126.168161242211,null,48916.979375506671,null,18900.487032925073,null,274967.76846050093]
[null,"20 - 40%",127351.66009858515,null,39947.296022774317,null,41443.670775051811,null,15624.782451585192,null,224367.40934799646]
[null,"40 - 60%",92871.307102761333,null,26709.359573034573,null,26691.816793169524,null,9811.7665389473641,null,156084.25000791281]
[null,"60 - 80%",46934.06225175572,null,14235.2579577001,null,6318.8559572633703,null,3227.8997147976006,null,70716.075881516779]
[null,"> 80 %",14542.822917841626,null,9841.9059617491803,null,3769.9331902688541,null,764.23706416476693,null,28918.899134024425]
[null,"Total",429723.98626177083,null,149859.98767650037,null,127141.25609126022,null,48329.172802419991,null,755054.40283195139]
[]
[]
[null,"*) New definition of seasoning compared to previous risk reports. Now defined by duration of customer relationship as opposed to duration of individual loan."]

{"sheet":"RD 2016 Q1 Cap T","index":1,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,2,5,10],[64,1,64,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",254788.24238901978,null,72444.933556700038,null,98548.949435220027,null,39679.128503430067,null,465461.25388436991]
[null," - Number of loans",225463,null,17069,null,9198,null,11005,null,262735]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",39.07788403,null,0,null,0,null,10.05671588,null,49.134599910000006]
[null," - repayment loans",8.5303441499999977,null,0,null,0,null,10.05671588,null,18.58706003]
[null," - interest-only ",30.547539880000002,null,0,null,0,null,0,null,30.547539880000002]
[null,"FlexLån®",239013.70891650979,null,56669.982784269996,null,40134.43107608,null,25029.769631210005,null,360847.89240806975]
[null," - repayment loans",92290.749294149966,null,37068.731036149999,null,19726.603483570008,null,7939.5816851200061,null,157025.66549898995]
[null," - interest-only ",146722.95962235983,null,19601.251748119994,null,20407.827592509995,null,17090.187946090002,null,203822.22690907979]
[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®",15651.398073720004,null,3282.5246529900005,null,2725.298849419999,null,8269.6167632099969,null,29928.838339339996]
[null," - repayment loans",4666.4887341599961,null,1255.6217197199996,null,1511.7385846699995,null,2025.7372359799992,null,9459.5862745299928]
[null," - interest-only ",10984.909339560007,null,2026.9029332700009,null,1213.56026475,null,6243.8795272299976,null,20469.252064810004]
[null,"Other floating rate loans",84.057514759999989,null,12492.426119440004,null,55689.219509720002,null,6369.6853931300002,null,74635.388537050007]
[null," - repayment loans",25.408587309999998,null,3590.0660239499989,null,19477.099727680008,null,1539.6582840399999,null,24632.232622980006]
[null," - interest-only ",58.648927449999988,null,8902.3600954900048,null,36212.11978203999,null,4830.0271090900005,null,50003.15591406999]
[null," Total",254788.24238901981,null,72444.933556700009,null,98548.949435219998,null,39679.128503430009,null,465461.25388436968]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",112867.81796338994,null,24314.860349219984,null,37615.634952450011,null,2945.1206626099984,null,177743.43392766992]
[null," - Other Sealand",49713.342689370009,null,7401.348832729992,null,7081.5111423000044,null,11435.683882119991,null,75631.886546520007]
[null," - Region South Denmark",37314.892749279992,null,14274.052611330018,null,19550.17409528001,null,12522.616543579998,null,83661.735999470024]
[null," - Region Central Jutland",42193.164360880008,null,18070.004356539997,null,14020.074658730002,null,7604.6414877100005,null,81887.884863860003]
[null," - Region North Jutland",12699.024626099996,null,7276.3355335600008,null,4355.81565916,null,5171.0659274100017,null,29502.241746229996]
[null," - Other area",0,null,1108.3318733199999,null,15925.738927300003,null,0,null,17034.070800620004]
[null,"Total",254788.24238901996,null,72444.933556699994,null,98548.949435220027,null,39679.128503429994,null,465461.25388436991]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",138750.54621061962,null,5572.3966984299932,null,2187.3468432899986,null,2140.7715934100006,null,148651.06134574962]
[null," 2 - 5",98289.088852630026,null,6543.2493330199977,null,3960.0774191700029,null,5207.1019882899955,null,113999.51759311001]
[null," 5 - 20",17275.278282059997,null,19772.320975389986,null,15399.373055749978,null,13206.357970610014,null,65653.330283809977]
[null," 20 - 50",417.20210617999999,null,16139.01187446999,null,13549.36895781999,null,12341.880225519986,null,42447.463163989967]
[null," 50 - 100",56.126937529999999,null,10726.197945509999,null,10495.154917050002,null,5254.5338220699996,null,26532.013622160001]
[null," 100 and above",0,null,13691.756729880004,null,52957.628242140025,null,1528.4829035300002,null,68177.86787555003]
[null,"Total",254788.24238901964,null,72444.933556699965,null,98548.949435219998,null,39679.128503429994,null,465461.25388436962]
[]
[null,"Bond debt outstanding by seasoning*"]
[null,"≤ 12 months",15549.999999999998,null,5970.0000000000009,null,8270.0000000000073,null,3500,null,33290.000000000007]
[null,"> 12 - ≤ 24 months",11140,null,2969.9999999999995,null,5000,null,1760,null,20870]
[null,"> 24 - ≤ 36 months",8720,null,2270,null,4020,null,1310,null,16320]
[null,"> 36 - ≤ 60 months",23580.000000000004,null,7800,null,8640.0000000000036,null,3100,null,43120.000000000007]
[null,"> 60 months",195798,null,53435,null,72619.000000000102,null,30009,null,351861]
[null,"Total",254788,null,72445,null,98549.000000000116,null,39679,null,465461]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",86259.573065782795,null,24986.700840220161,null,39535.40495556478,null,15333.434103418209,null,166115.11296498595]
[null,"20 - 40%",74873.600095097339,null,20317.422594168071,null,33162.680178069546,null,12801.511480712597,null,141155.21434804756]
[null,"40 - 60%",55688.86477872674,null,15072.329610347284,null,20031.869490028843,null,8151.7099785644259,null,98944.7738576673]
[null,"60 - 80%",28678.065355133727,null,7769.6123453361524,null,3984.7571091560822,null,2734.7640376779827,null,43167.198847303946]
[null,"> 80 %",9288.1390937994311,null,4298.8681668182862,null,1834.2377025807509,null,657.70890268679102,null,16078.953865885258]
[null,"Total",254788.24238854003,null,72444.933556889955,null,98548.949435400005,null,39679.128503060005,null,465461.25388389005]
[]
[]
[null,"*) New definition of seasoning compared to previous risk reports. Now defined by duration of customer relationship as opposed to duration of individual loan."]

{"sheet":"RD 2016 Q1 Cap S","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,2,5,10],[64,1,64,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",149889.05100221033,null,45210.59376517991,null,19869.345332680019,null,7403.9022993600056,null,222372.89239943027]
[null," - Number of loans",137383,null,8762,null,3053,null,2336,null,151534]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",137754.61321459012,null,40185.536602129985,null,13341.225930040015,null,5271.2615714299982,null,196552.63731819016]
[null," - repayment loans",101727.15086752009,null,36794.46451044998,null,12221.650129060015,null,3339.6375779199984,null,154082.90308495014]
[null," - interest-only ",36027.462347070017,null,3391.0720916800024,null,1119.5758009799999,null,1931.62399351,null,42469.734233240022]
[null,"FlexLån®",6906.4705739999999,null,3384.9693750899987,null,2612.1869350500001,null,327.10600045000007,null,13230.732884589997]
[null," - repayment loans",2003.8079892500004,null,585.30373326999995,null,607.55086327000004,null,77.048978799999986,null,3273.7115645900008]
[null," - interest-only ",4902.662584749999,null,2799.6656418199987,null,2004.6360717800003,null,250.05702165000002,null,9957.021319999998]
[null,"FlexGaranti®, Rentedyk TM",5204.1604431999995,null,107.22633722,null,50.643050580000001,null,29.580340249999999,null,5391.6101712500003]
[null," - repayment loans",2048.4155786900005,null,60.049466100000004,null,40.048168909999994,null,17.010614660000002,null,2165.5238283600002]
[null," - interest-only ",3155.7448645099994,null,47.176871119999994,null,10.594881669999999,null,12.569725589999999,null,3226.0863428899993]
[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",23.806770420000003,null,1532.8614507400005,null,3865.2894170099994,null,1775.9543872300003,null,7197.9120253999999]
[null," - repayment loans",6.3995285300000004,null,172.06968050999998,null,998.13670738999986,null,224.47845001000002,null,1401.0843664399997]
[null," - interest-only ",17.407241890000002,null,1360.7917702300006,null,2867.1527096199993,null,1551.4759372200003,null,5796.82765896]
[null," Total",149889.05100221015,null,45210.593765179983,null,19869.345332680015,null,7403.9022993599983,null,222372.89239943016]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",59770.374942500006,null,21556.997398470019,null,7926.2681915000012,null,452.39423621999975,null,89706.034768690035]
[null," - Other Sealand",29142.458889480004,null,4376.4419962800002,null,2332.7728623599996,null,1688.4203159400004,null,37540.094064060002]
[null," - Region South Denmark",27351.89799198999,null,6974.7080069200001,null,3964.5214486700002,null,3217.2436435899995,null,41508.371091169982]
[null," - Region Central Jutland",25072.00295356999,null,9296.9625898900049,null,3921.2786556499996,null,1215.1368411900005,null,39505.381040300002]
[null," - Region North Jutland",8552.3162246699994,null,2755.547758369999,null,1690.2561954000005,null,830.70726242000001,null,13828.827440859999]
[null," - Other area",0,null,249.93601525,null,34.247979100000002,null,0,null,284.18399435000003]
[null,"Total",149889.05100220998,null,45210.593765180027,null,19869.345332680001,null,7403.9022993600011,null,222372.89239943001]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",97769.481223229974,null,2104.9387587500005,null,1032.70480729,null,890.58666696000057,null,101797.71145622998]
[null," 2 - 5",46541.255302629979,null,3987.3074356699994,null,1652.3181825600002,null,1306.0112431399996,null,53486.892163999975]
[null," 5 - 20",5411.3604437399999,null,14104.022926159994,null,5140.9800108500021,null,2186.1416744899984,null,26842.505055239995]
[null," 20 - 50",166.95403260999998,null,9854.1920234199988,null,4802.3312853900006,null,2073.1588575700007,null,16896.63619899]
[null," 50 - 100",0,null,5791.4760023999979,null,3430.0159838400009,null,881.39184412999987,null,10102.883830369998]
[null," 100 and above",0,null,9368.6566187799981,null,3810.9950627500007,null,66.612013070000003,null,13246.263694599998]
[null,"Total",149889.05100220992,null,45210.59376517999,null,19869.345332680005,null,7403.9022993599983,null,222372.89239942993]
[]
[null,"Bond debt outstanding by seasoning*"]
[null,"≤ 12 months",7150,null,4590.0000000000009,null,849.99999999999909,null,320,null,12910]
[null,"> 12 - ≤ 24 months",14430,null,11240.000000000002,null,2470.0000000000018,null,620,null,28760.000000000004]
[null,"> 24 - ≤ 36 months",39500,null,6330,null,4799.9999999999854,null,1790,null,52419.999999999985]
[null,"> 36 - ≤ 60 months",32250,null,5510,null,2559.9999999999927,null,1310,null,41629.999999999993]
[null,"> 60 months",56559,null,17541,null,9188.9999999999909,null,3364,null,86653]
[null,"Total",149889,null,45211,null,19868.999999999971,null,7404,null,222372.99999999997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",50853.092650973929,null,21011.967222143088,null,6787.6898150080933,null,2793.924397812717,null,81446.674085937819]
[null,"20 - 40%",45478.548687338181,null,11877.310542692088,null,6261.4236533087787,null,2505.8773310842521,null,66123.160214423289]
[null,"40 - 60%",33114.920232119781,null,6683.9705059924627,null,4531.1791219966144,null,1543.5641813433642,null,45873.634041452227]
[null,"60 - 80%",16332.79670666858,null,3374.2722965897588,null,1490.9692897065968,null,459.88731441968031,null,21657.925607384615]
[null,"> 80 %",4109.6927259394806,null,2263.0731975725994,null,798.0834525399132,null,100.64907500998547,null,7271.4984510619779]
[null,"Total",149889.05100303996,null,45210.593764990008,null,19869.345332559995,null,7403.9022996700005,null,222372.89240025994]
[]
[]
[null,"*) New definition of seasoning compared to previous risk reports. Now defined by duration of customer relationship as opposed to duration of individual loan."]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":36,"n_cols":4,"rows_kept":36,"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,57,17]

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

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

{"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 2016 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%",148.02413389082696,null,59.126168161242212,null,48.916979375506671,null,18.900487032925071,null,0.3641694789530272,null,274.96776846050091]
[null," - 20-40%",127.35166009858516,null,39.947296022774317,null,41.443670775051814,null,15.624782451585192,null,0.29715396467654631,null,224.3674093479965]
[null," - 40-60%",92.871307102761335,null,26.709359573034572,null,26.691816793169526,null,9.8117665389473654,null,0.20671921046019204,null,156.0842500079128]
[null," - 60-80%",46.934062251755719,null,14.235257957700099,null,6.3188559572633709,null,3.227899714797601,null,9.3656928052183938E-2,null,70.716075881516787]
[null," - >80%",14.542822917841626,null,9.8419059617491804,null,3.769933190268854,null,0.76423706416476689,null,3.8300417858050363E-2,null,28.918899134024429]
[null,"Total",429.72398626177085,null,149.85998767650037,null,127.14125609126023,null,48.329172802419997,null,0.99999999999999989,null,755.05440283195139]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",86.259573065782789,null,24.986700840220163,null,39.535404955564779,null,15.33343410341821,null,0.35688279438705678,null,166.11511296498594]
[null," - 20-40%",74.873600095097331,null,20.317422594168072,null,33.16268017806955,null,12.801511480712596,null,0.30325878506583265,null,141.15521434804756]
[null," - 40-60%",55.688864778726739,null,15.072329610347284,null,20.031869490028843,null,8.1517099785644263,null,0.21257359883782981,null,98.944773857667286]
[null," - 60-80%",28.678065355133729,null,7.7696123453361521,null,3.9847571091560821,null,2.7347640376779827,null,9.2740692135186986E-2,null,43.167198847303951]
[null," - >80%",9.2881390937994315,null,4.298868166818286,null,1.834237702580751,null,0.65770890268679105,null,3.4544129574093786E-2,null,16.078953865885261]
[null,"Total",254.78824238854,null,72.44493355688995,null,98.54894943539999,null,39.679128503060006,null,1,null,465.46125388388998]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",50.853092650973927,null,21.011967222143088,null,6.7876898150080933,null,2.7939243978127166,null,0.3662617021652888,null,81.446674085937829]
[null," - 20-40%",45.478548687338183,null,11.87731054269209,null,6.2614236533087784,null,2.5058773310842519,null,0.29735261119599488,null,66.123160214423308]
[null," - 40-60%",33.114920232119779,null,6.6839705059924635,null,4.5311791219966144,null,1.5435641813433643,null,0.20629148430053246,null,45.87363404145222]
[null," - 60-80%",16.332796706668578,null,3.3742722965897589,null,1.4909692897065969,null,0.45988731441968028,null,9.739463013505012E-2,null,21.657925607384616]
[null," - >80%",4.10969272593948,null,2.2630731975725995,null,0.7980834525399132,null,0.10064907500998546,null,3.2699572203133687E-2,null,7.2714984510619782]
[null,"Total",149.88905100303995,null,45.210593764990001,null,19.869345332559998,null,7.4039022996699986,null,1,null,222.37289240025996]

{"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 2016 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%",62.749499704076129,null,195.07420362116898,null,17.144065135255165,null,274.96776846050028]
[null," - 20-40%",42.732351101039157,null,165.63378515001273,null,16.0012730969442,null,224.3674093479961]
[null," - 40-60%",25.687155602807753,null,117.14273240958775,null,13.254361995517328,null,156.08425000791283]
[null," - 60-80%",10.816173605025593,null,51.936244187839939,null,7.9636580886509742,null,70.716075881516502]
[null," - >80%",6.2897104479355299,null,17.015485681822437,null,5.6137030042664584,null,28.918899134024425]
[null,"Total",148.27489046088417,null,546.80245105043184,null,59.977061320634121,null,755.05440283195014]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",32.885902451495944,null,120.56441800867792,null,12.66479250481215,null,166.115112964986]
[null," - 20-40%",23.402959356923084,null,105.75994012557651,null,11.992314865548012,null,141.15521434804762]
[null," - 40-60%",14.166206469410561,null,74.790249284371271,null,9.9883181038852751,null,98.944773857667101]
[null," - 60-80%",5.5088574462762052,null,31.741254191128689,null,5.917087209899087,null,43.167198847303979]
[null," - >80%",2.5075200964746034,null,9.6090969353031692,null,3.9623368341074925,null,16.078953865885264]
[null,"Total",78.471445820580399,null,342.46495854505758,null,44.524849518252012,null,465.46125388388998]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",18.389774544712836,null,59.973854371138771,null,3.0830451700863581,null,81.446674085937971]
[null," - 20-40%",12.486232959641006,null,50.703938457147004,null,2.9329887976353142,null,66.123160214423322]
[null," - 40-60%",7.4623610843434021,null,35.93004216177134,null,2.4812307953374479,null,45.873634041452185]
[null," - 60-80%",2.7823556104360416,null,17.35382149764169,null,1.5217484993068535,null,21.657925607384584]
[null," - >80%",1.1439847083999322,null,5.1268619661889856,null,1.0006517764730625,null,7.27149845106198]
[null,"Total",42.264708907533219,null,169.08851845388779,null,11.019665038839037,null,222.37289240026004]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":46,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","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"]
[null,"Private",8.0652528612137897E-2,7.7191298368422895E-2,6.9556929511739488E-2,5.6591704792520001E-2,5.1296367647227961E-2,5.6647210289428276E-2,5.0244429306712655E-2,6.0543838606434336E-2,6.16656827446775E-2,7.0253843806781346E-2,8.0928251690201194E-2,0.10004882266970098,0.11781523259771912,0.1405975605147636,0.21226550425193944,0.31,0.40858428118318801,0.47,0.52,0.54,0.42,0.36,0.33,0.28999999999999998,0.28999999999999998,0.3463,0.26,0.26190376313394481,0.24316578085023852,0.2369410256441489,0.2412168151228983,0.24464011849638104,0.26151874154946242,0.18995975418317132,0.21,0.20871851307349823,0.20374765009047413,0.19533888718789549,0.17754809588439302,0.19590249468675333,0.19,0.15893288234797173,0.16149788193874809,0.16149788193874809]
[null,"Commercial",0.16563791556290958,0.2132773695526021,0.12204037907712323,0.10503765547972971,8.8360652070989781E-2,9.3490201160133263E-2,0.12575758646685919,0.13869347004763621,6.9749523648991063E-2,8.4826854962818915E-2,0.13082680939576194,6.3690962238606902E-2,9.4493334396141937E-2,0.13624324754250733,0.3969035165305469,0.5,1.19219168754725,1.49,2.2799999999999998,1.66,1.68,1.53,1.45,0.99,1.52,1.0514600000000001,1.1100000000000001,0.98135130215418731,0.91779340446955104,0.9167755240471176,0.97966799583253905,0.96572955607584687,0.90468379651813313,1.0725515021846566,0.89,0.87131255651855843,0.76461653695092491,0.76492280361307252,0.77897538655254928,1.194715258404901,1.46,0.82675167690184714,0.85336926232454113,0.89]
[null,"Agriculture",0.28733545754687229,0.28591425530114489,0.16350323367431957,0.34527555313816655,0.10247036587855575,0.17964818144364114,9.0458945241985167E-2,0.19224824892179651,0.1036179997289654,0.12911678565215878,0.23066720688136241,0.12560081599500431,0.155178149616685,0.19101387683898366,0.35126666024992187,0.41759999999999997,0.67417569609969485,0.74819999999999998,0.97440000000000004,1.2005999999999999,1.1135999999999999,1.0788,0.8004,1.0091999999999999,1.2702,1.0149245999999998,0.97440000000000004,0.91878692992583044,0.98849890507143101,0.91578392565633737,0.81872886685764001,0.7178725419523122,0.80576132165605641,0.54730814983061826,0.76559999999999995,0.73217624928661695,0.7172187732310964,0.70912650774595554,1.0035221517145021,0.81239218354143794,1.05,1.1685196839142329,1.2412515438452036,1.58]
[null,"Rental Residential",4.3803406849193607E-2,9.5903072670480427E-2,3.6486627092520228E-2,8.0964019790819894E-2,3.0837731696558998E-2,9.0809206617881597E-2,0.13105243766129279,0.12018992862817277,4.2604410955085943E-2,9.7458697328710153E-2,9.7552936486864472E-2,7.1229672369108821E-2,0.17376216832575472,0.14733228176836374,0.54055865639875256,0.47,1.43,0.78,2.3199999999999998,1.05,1.25,0.73,1.23,0.54,0.79,0.48215999999999998,0.61,1.0340488552503766,0.94359445546940601,0.95685367926700082,1.015570738474074,1.0358365609598339,1.1088667897697735,1.0818705545393414,0.69,1.0079192391688849,0.56932045694128441,0.37687573473480396,0.55809173343292406,0.26507511901436809,0.38,0.23610434466412475,0.36501409231622234,0.15]
[null,"Total",9.3078859231499098E-2,0.1041114235941326,7.4301233393325866E-2,7.876830458817323E-2,5.4285894101353913E-2,7.2796144890424228E-2,7.1601991163809345E-2,9.0566535002575665E-2,6.0047323754447109E-2,7.9214700905587174E-2,9.2930152243926437E-2,8.4504082108036338E-2,0.12016587495976419,0.13984787324621051,0.28332394419109863,0.37,0.66341144567458699,0.69,1.02,0.84,0.73,0.62,0.63,0.48,0.56999999999999995,0.48478000000000004,0.46,0.58369618019212233,0.47098288764955432,0.5326320421930133,0.48741117386115446,0.56540413616177954,0.51758010480584227,0.55014006668795445,0.41,0.53504965819159567,0.36591361753693991,0.33338691074415494,0.38091100597796013,0.38906956469991866,0.47,0.32200314121386003,0.35811697073053689,0.33]

{"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",45210593765.179909,44960657749.929901]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",19869345332.679993,19835097353.579994]
["S-Landbrug","S",null,"Landbrug",7403902299.359993,7403902299.359993]
["S-Privat","S",null,"Privat",149889051002.21017,149889051002.21017]
["S Total-","S Total","S Total",null,222372892399.43005,222088708405.08008]
["T-Boligudl","T","T","Boligudl",72444933556.700043,71336601683.380081]
["T-Erhverv","T",null,"Erhverv",98548949435.219971,82623210507.919907]
["T-Landbrug","T",null,"Landbrug",39679128503.430031,39679128503.430031]
["T-Privat","T",null,"Privat",254788242389.01968,254788242389.01968]
["T Total-","T Total","T Total",null,465461253884.36975,448427183083.74969]
["Ø-Boligudl","Ø","Ø","Boligudl",32204460354.269997,32005195881.709995]
["Ø-Erhverv","Ø",null,"Erhverv",8722961323.4100037,8430426060.1400013]
["Ø-Landbrug","Ø",null,"Landbrug",1246141999.6399996,1246141999.6399996]
["Ø-Privat","Ø",null,"Privat",25046692870.139988,25046692870.139988]
["Ø Total-","Ø Total","Ø Total",null,67220256547.459991,66728456811.62999]
["Grand Total-","Grand Total","Grand Total",null,755054402831.25989,737244348300.45984]
[]
[]
[]
[]
[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":254788242389.01968}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":71336601683.380081}]
[null,null,"T-Erhverv","Erhverv","Commercial",82623210507.919907]
[null,null,"T-Landbrug","Landbrug","Agriculture",39679128503.430031]
[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":17034070800.619995}]
[]
[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":149889051002.21017}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":44960657749.929901}]
[null,null,"S-Erhverv","Erhverv","Commercial",19835097353.579994]
[null,null,"S-Landbrug","Landbrug","Agriculture",7403902299.359993]
[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":284183994.3500061}]
[]
[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":25046692870.139988}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":32005195881.709995}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",8430426060.1400013]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",1246141999.6399996]
[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":491799735.83000946}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":429723986261.36987}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":148302455315.01999}]
[null,null,null,null,"Commercial",110888733921.63991]
[null,null,null,null,"Agriculture",48329172802.430023]
[null,null,null,null,"Nordic",17810054530.800011]

{"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",7700667192.1099997,284062160.31]
[null,"F1",28877855990.330002,11837229460.639999]
[null,"F3",50807187009.879997,13114558803.440001]
[null,"F5",55916509448.139999,20322816988.439999]
[null,"Fixed",36866732870.220001,6491450454.9499998]
[null,"Floaters",11079706439.26,71775882066.350006]
[null,"Øv. flex",16265449681.83,18511438489.830002]
["J Total",null,207514108631.77002,142337438423.96002]
["N","CapFloat",12013946317.43,1014879080.61]
[null,"F1",20055039264.66,10198158450.25]
[null,"F3",32785210489.139999,10936311803.790001]
[null,"F5",35488628650.889999,38168618310.120003]
[null,"Fixed",111160239522.59,83159391407.740005]
[null,"Floaters",4700257985.7200003,32525850513.709999]
[null,"Øv. flex",6006555399.1199999,6989768579.5200005]
["N Total",null,222209877629.54999,182992978145.73999]