{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2015 Q2 Total","RD 2015 Q2 Cap T","RD 2015 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 2015 Q2 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2015 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",426140.78301293973,null,146681.51998664971,null,123144.80587526984,null,48229.831652949913,null,744196.94052780932]
[null," - Number of loans",414066,null,38897,null,14771,null,14816,null,482550]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",140659.95747738992,null,64588.326175329967,null,13356.006476920005,null,5499.9159044300004,null,224104.20603406988]
[null," - repayment loans",106416.61335329991,null,61995.685124159965,null,12227.949885680006,null,3651.8396626100021,null,184292.08802574986]
[null," - interest-only ",34243.344124090014,null,2592.6410511699992,null,1128.05659124,null,1848.0762418199988,null,39812.118008320009]
[null,"FlexLån®",249900.82477863983,null,62938.941019090045,null,45769.748076329968,null,26821.995923710034,null,385431.50979776989]
[null," - repayment loans",90240.721784580048,null,38059.629787620033,null,18127.224884079966,null,7940.1599049200104,null,154367.73636120005]
[null," - interest-only ",159660.10299405979,null,24879.311231470008,null,27642.523192250006,null,18881.836018790025,null,231063.77343656981]
[null,"FlexGaranti®, Rentedyk TM",22127.051421310014,null,719.91705061000016,null,371.46735306000016,null,395.07920969000008,null,23613.515034670014]
[null," - repayment loans",10729.043837760015,null,450.03758861000011,null,277.21896518000011,null,207.82302851,null,11664.123420060017]
[null," - interest-only ",11398.007583549997,null,269.87946199999999,null,94.248387880000024,null,187.25618118000006,null,11949.391614609996]
[null,"FlexKort®",13332.598314200006,null,2868.5144008400007,null,2475.5309194400002,null,7109.9243593700048,null,25786.567993850014]
[null," - repayment loans",3913.1034097600023,null,961.31234050000057,null,1430.7382289299999,null,1562.1650375899992,null,7867.3190167800012]
[null," - interest-only ",9419.4949044400037,null,1907.2020603400001,null,1044.7926905100001,null,5547.7593217800058,null,17919.248977070012]
[null,"Other floating rate loans",120.35102140000002,null,15565.821340779998,null,61172.05304952008,null,8402.9162557499985,null,85261.14166745008]
[null," - repayment loans",24.846414090000003,null,3379.7942004200045,null,18343.554135680009,null,1620.1570902500009,null,23368.351840440013]
[null," - interest-only ",95.504607310000011,null,12186.027140359993,null,42828.498913840071,null,6782.7591654999969,null,61892.789827010063]
[null," Total",426140.78301293979,null,146681.51998665,null,123144.80587527006,null,48229.831652950037,null,744196.9405278099]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",174804.10491404944,null,54161.269668600027,null,46388.698596449933,null,3343.7420647800031,null,278697.81524387945]
[null," - Other Sealand",86253.627492450134,null,16986.556064719996,null,10259.819390879989,null,13367.068584580049,null,126867.07153263017]
[null," - Region South Denmark",70005.036528349941,null,26781.382955700068,null,25378.162714810052,null,16321.183078279993,null,138485.76527714008]
[null," - Region Central Jutland",71748.774899610013,null,33970.909685319995,null,20593.401410859951,null,9170.0474052999998,null,135483.13340108996]
[null," - Region North Jutland",23327.446015969977,null,13335.411688189997,null,6579.4991670299951,null,6027.7905200099958,null,49270.147391199964]
[null," - Other area",1.7931625099999997,null,1445.9899241200001,null,13945.224595239999,null,0,null,15393.007681869998]
[null,"Total",426140.78301293944,null,146681.51998665009,null,123144.80587526994,null,48229.831652950044,null,744196.94052780967]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",262886.21055338002,null,9504.6454348199895,null,4006.9794231399983,null,3486.3429186100043,null,279884.17832995002]
[null," 2 - 5",141772.62670634003,null,13000.572922750007,null,6247.1855522699971,null,6944.750088020005,null,167965.13526938003]
[null," 5 - 20",20728.524317420022,null,44217.153937899959,null,21659.755283549988,null,15445.520606650036,null,102050.95414552001]
[null," 20 - 50",646.2470166999999,null,34655.963937880013,null,19333.387067939992,null,14662.582126250016,null,69298.180148770014]
[null," 50 - 100",107.17441909999999,null,19818.187276590001,null,16100.536278480005,null,6182.9025378100005,null,42208.80051198]
[null," 100 and above",0,null,25484.996476710006,null,55796.962269890028,null,1507.7333756099999,null,82789.692122210035]
[null,"Total",426140.78301294014,null,146681.51998664998,null,123144.80587527002,null,48229.831652950059,null,744196.94052781013]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",72382.003380339986,null,23788.551350380025,null,16562.029658129999,null,6551.5432958399988,null,119284.12768469]
[null," 1",62202.915166679995,null,15779.994764870011,null,24743.371793159975,null,11080.171298030007,null,113806.45302273997]
[null," 2",35578.682440740005,null,10414.955073189998,null,12180.339790310003,null,1883.5645927499986,null,60057.541896990006]
[null," 3",30788.161123649988,null,8322.3016557500032,null,10079.555339139997,null,2167.835740139999,null,51357.853858679991]
[null," 4",41677.311897389976,null,9078.2464618399918,null,9293.6904030200003,null,2501.7785575400007,null,62551.027319789973]
[null," 6",72695.841289949924,null,11687.242028390008,null,16861.32915922,null,5068.1233031400025,null,106312.53578069994]
[null," 8",43894.446518179924,null,12450.348933349995,null,20213.371187640012,null,10230.59288779001,null,86788.759526959941]
[null," 10",37547.970079869978,null,12361.857401619998,null,9751.8490962399883,null,5701.5220955599962,null,65363.19867328996]
[null," 15",27225.492826390004,null,14413.398019089993,null,3003.006484340001,null,2687.7040051700019,null,47329.601334990002]
[null," 20",1765.0544449100016,null,14767.077612130006,null,354.21342086999994,null,204.7586252400001,null,17091.10410315001]
[null," 25",313.9009073000002,null,13103.091031209999,null,37.846867220000007,null,11.697896030000001,null,13466.536701759998]
[null," 30",69.002937539999991,null,514.45565482999996,null,64.202675980000024,null,140.53935572000006,null,788.20062406999989]
[null,"Total",426140.78301293973,null,146681.51998665003,null,123144.80587526997,null,48229.831652950023,null,744196.94052780967]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",142258.27963697285,null,56675.738783134329,null,46669.64390485231,null,18794.969106703633,null,264398.63143166312]
[null,"20 - 40%",123481.11246426489,null,38083.178116731629,null,39761.517073853393,null,15476.828119833986,null,216802.63577468391]
[null,"40 - 60%",92355.398592334663,null,25983.602581656887,null,25653.542105037155,null,9765.5364373180673,null,153758.07971634678]
[null,"60 - 80%",49537.355824313476,null,14361.511221783639,null,6695.0595309319378,null,3395.6140654180435,null,73989.5406424471]
[null,"> 80 %",18508.636494443614,null,11577.489283063698,null,4365.0432607253479,null,796.88392373634679,null,35248.052961968999]
[null,"Total",426140.78301232948,null,146681.5199863702,null,123144.80587540014,null,48229.831653010078,null,744196.94052711001]

{"sheet":"RD 2015 Q2 Cap T","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2015 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",250127.4021256702,null,65807.450423099959,null,90998.873101779944,null,39089.702075329966,null,446023.42772588]
[null," - Number of loans",221712,null,16288,null,9153,null,10971,null,258124]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",0.30743127000000003,null,0,null,0,null,0,null,0.30743127000000003]
[null," - repayment loans",0.30743127000000003,null,0,null,0,null,0,null,0.30743127000000003]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"FlexLån®",236715.95851004001,null,50660.61908932004,null,38356.829315460003,null,25813.454459619999,null,351546.86137444008]
[null," - repayment loans",86618.904858379974,null,31824.542689970032,null,16958.288211810013,null,7711.5870866799924,null,143113.32284684002]
[null," - interest-only ",150097.05365166004,null,18836.076399350008,null,21398.541103649997,null,18101.867372940007,null,208433.53852760003]
[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®",13332.598314200006,null,2868.5144008399993,null,2475.5309194400002,null,7109.9243593699994,null,25786.567993850007]
[null," - repayment loans",3913.1034097600023,null,961.3123405,null,1430.7382289300001,null,1562.1650375899997,null,7867.319016780003]
[null," - interest-only ",9419.4949044400037,null,1907.202060339999,null,1044.7926905100001,null,5547.7593217799995,null,17919.248977070005]
[null,"Other floating rate loans",78.537870159999997,null,12278.316932939999,null,50166.51286688001,null,6166.3232563399997,null,68689.690926320021]
[null," - repayment loans",17.685328819999999,null,2999.5109743799985,null,15679.946547920008,null,1295.7517629399997,null,19992.894614060006]
[null," - interest-only ",60.852541340000002,null,9278.8059585600004,null,34486.566318960009,null,4870.5714934000007,null,48696.796312260012]
[null," Total",250127.40212567002,null,65807.450423100032,null,90998.873101780031,null,39089.702075329995,null,446023.42772588012]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",109324.0154591599,null,22457.381178839991,null,32893.983010460011,null,2872.0785788999997,null,167547.45822735989]
[null," - Other Sealand",49198.656831479952,null,6618.2635943700016,null,6716.4201689599959,null,11054.532494360008,null,73587.873089169952]
[null," - Region South Denmark",36926.253101610047,null,12697.873108870006,null,19168.116697420021,null,12494.84007095,null,81287.082978850085]
[null," - Region Central Jutland",42008.94008043997,null,16339.918538880012,null,14273.225878390009,null,7620.3605465500023,null,80242.445044259992]
[null," - Region North Jutland",12669.536652979989,null,6709.4612673099937,null,4345.85189292,null,5047.8903845699979,null,28772.740197779982]
[null," - Other area",0,null,984.55273483000008,null,13601.27545363,null,0,null,14585.828188459998]
[null,"Total",250127.40212566982,null,65807.450423100003,null,90998.873101780046,null,39089.702075330009,null,446023.42772587994]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",139048.24357247003,null,5608.4264645000148,null,2217.7484754700017,null,2106.4895536700019,null,148980.90806611005]
[null," 2 - 5",94711.105891080006,null,6310.1221256100007,null,4119.4701931299996,null,5237.5238764299966,null,110378.22208625]
[null," 5 - 20",15858.075194519992,null,18211.61510759002,null,15146.133759189996,null,12835.392540090004,null,62051.216601390006]
[null," 20 - 50",454.77391174000007,null,13545.063034660003,null,13580.515626949997,null,12215.618587060007,null,39795.971160410001]
[null," 50 - 100",55.203555860000002,null,9839.2541132499991,null,10609.173738430005,null,5307.5402079999949,null,25811.171615540003]
[null," 100 and above",0,null,12292.969577489997,null,45325.831308609981,null,1387.1373100799999,null,59005.938196179981]
[null,"Total",250127.40212567002,null,65807.450423100032,null,90998.873101779973,null,39089.702075330002,null,446023.42772588]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",17573.179817669992,null,6058.7632388800012,null,8223.6009868799974,null,3839.4958226300018,null,35695.039866059989]
[null," 1",33978.054853850008,null,12859.580667079994,null,23274.816104270005,null,10083.453383790005,null,80195.905008990012]
[null," 2",20011.157605090004,null,3569.5501465400016,null,10341.0923685,null,1416.2432535200003,null,35338.043373650013]
[null," 3",15994.492234660009,null,5750.5053269000055,null,9159.4591907900012,null,1693.6933410900008,null,32598.150093440014]
[null," 4",27060.681249330006,null,6821.5571237199993,null,8249.799574050001,null,2259.8845886699992,null,44391.922535770005]
[null," 6",62296.23888216004,null,7678.8803005100053,null,14432.740316969996,null,4723.3520955900003,null,89131.211595230037]
[null," 8",37263.259781180022,null,5770.3777218400082,null,9917.6808203699966,null,7597.9466087800047,null,60549.264932170037]
[null," 10",16173.943739219996,null,7642.4365031199986,null,4918.8844675400005,null,4970.5570075099977,null,33705.821717389998]
[null," 15",18920.330567909994,null,9081.0726650200013,null,2286.1554032699992,null,2332.2389371200002,null,32619.797573319993]
[null," 20",856.06339460000027,null,574.72672948999968,null,194.64386914000005,null,172.83703663,null,1798.2710298600002]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",250127.40212567008,null,65807.450423100017,null,90998.873101780002,null,39089.702075330002,null,446023.42772588006]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",81334.3476545249,null,21857.049046425247,null,35572.09474983003,null,14985.965263581051,null,153749.45671436121]
[null,"20 - 40%",71511.729486873679,null,18194.493017755933,null,30679.563690490017,null,12523.247481477852,null,132909.03367659746]
[null,"40 - 60%",54915.800751913484,null,13688.590904480121,null,18608.694848460014,null,8050.3396897532684,null,95263.426194606887]
[null,"60 - 80%",30459.506052529152,null,7451.4235782615779,null,4123.0659792899978,null,2866.641176648739,null,44900.636786729468]
[null,"> 80 %",11906.018180128844,null,4615.8938759670709,null,2015.4538333599992,null,663.50846411909868,null,19200.874353575011]
[null,"Total",250127.40212597002,null,65807.45042288996,null,90998.873101430057,null,39089.702075580004,null,446023.42772587005]

{"sheet":"RD 2015 Q2 Cap S","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2015 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",145918.33267485019,null,45425.462851460063,null,20390.263639259996,null,7642.8622992800019,null,219376.92146485025]
[null," - Number of loans",136225,null,9125,null,3199,null,2429,null,150978]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",127858.06023807,null,33481.013032540075,null,12184.172176850005,null,4878.5819969300019,null,178401.82744439007]
[null," - repayment loans",95424.107763309992,null,30966.944521550075,null,11088.595350750003,null,3123.3651478700021,null,140603.01278348008]
[null," - interest-only ",32433.952474760004,null,2514.0685109899996,null,1095.5768260999998,null,1755.2168490600004,null,37798.81466091]
[null,"FlexLån®",12558.605630399996,null,10139.885466270005,null,4089.7981770699998,null,834.98236825000015,null,27623.271641989999]
[null," - repayment loans",3523.0230974599986,null,5881.7626788000043,null,1115.6368366600002,null,188.40786402000001,null,10708.830476940002]
[null," - interest-only ",9035.5825329399959,null,4258.1227874699989,null,2974.1613404099994,null,646.57450423000012,null,16914.441165049997]
[null,"FlexGaranti®, Rentedyk TM",5480.7966141200004,null,120.16671561999999,null,53.165391360000001,null,32.052872360000002,null,5686.1815934599999]
[null," - repayment loans",2150.2219840099992,null,72.893778929999996,null,42.56600589,null,18.32865966,null,2284.010428489999]
[null," - interest-only ",3330.5746301100016,null,47.272936689999995,null,10.599385470000003,null,13.724212699999999,null,3402.1711649700014]
[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",20.87019226,null,1684.3976370300002,null,4063.1278939800009,null,1897.2450617400007,null,7665.6407850100022]
[null," - repayment loans",5.1535826600000005,null,239.32321296000003,null,1002.0587057600001,null,225.03103982000002,null,1471.5665412000001]
[null," - interest-only ",15.7166096,null,1445.0744240700001,null,3061.0691882200008,null,1672.2140219200007,null,6194.0742438100024]
[null," Total",145918.33267485004,null,45425.462851460084,null,20390.263639260003,null,7642.8622992800038,null,219376.92146485008]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",56857.53923569998,null,20622.746424980007,null,8096.8868202899957,null,374.53551279999994,null,85951.707993769989]
[null," - Other Sealand",28812.136572609983,null,5035.3997099399985,null,2458.4813222499993,null,1966.4476124599994,null,38272.465217259982]
[null," - Region South Denmark",26941.466062369993,null,7236.7690527499972,null,4050.246632180003,null,3270.9080102300018,null,41499.389757529992]
[null," - Region Central Jutland",24766.348652990015,null,9192.6463247099982,null,4000.7909757799989,null,1202.3122961900003,null,39162.098249670016]
[null," - Region North Jutland",8540.8421511800043,null,3086.4066521599989,null,1749.3963295800002,null,828.65886760000024,null,14205.304000520004]
[null," - Other area",0,null,251.49468691999999,null,34.461559180000002,null,0,null,285.95624609999999]
[null,"Total",145918.33267484998,null,45425.462851459997,null,20390.26363926,null,7642.8622992800028,null,219376.92146485002]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",98689.070510810037,null,2215.327302749999,null,1071.7341111199996,null,936.83358428999975,null,102912.96550897002]
[null," 2 - 5",42462.503310859967,null,4416.4403420399976,null,1729.1031807100003,null,1373.5423180599989,null,49981.58915166997]
[null," 5 - 20",4580.406334180002,null,14817.165152759982,null,5348.5429453499983,null,2231.2779929000017,null,26977.392425189988]
[null," 20 - 50",186.352519,null,10683.806873650008,null,4821.1307887499997,null,2265.9117193700008,null,17957.201900770007]
[null," 50 - 100",0,null,5293.8121878899992,null,3417.8514657799992,null,769.49839335000001,null,9481.1620470199978]
[null," 100 and above",0,null,7998.9109923699989,null,4001.9011475500001,null,65.798291309999996,null,12066.610431229998]
[null,"Total",145918.33267485001,null,45425.46285145999,null,20390.26363926,null,7642.8622992800019,null,219376.92146485005]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",54808.823562670026,null,17729.788111499998,null,7924.6803509700003,null,2712.047473210001,null,83175.339498350033]
[null," 1",28224.860312829995,null,2920.4140977899992,null,1409.7300517799999,null,996.7179142399998,null,33551.722376639998]
[null," 2",15567.524835649998,null,6845.404926649996,null,1326.8136214599997,null,467.32133922999992,null,24207.064722989991]
[null," 3",14793.668888989998,null,2571.7963288500014,null,920.09614834999979,null,474.14239904999999,null,18759.703765239999]
[null," 4",14616.630648060003,null,2256.6893381199989,null,775.22343121999984,null,241.89396886999995,null,17890.437386270001]
[null," 6",10399.315315049995,null,4008.3617278799989,null,1130.0116921699994,null,344.77120754999999,null,15882.459942649994]
[null," 8",4315.7005117299987,null,4808.4590689200022,null,5890.4136947000006,null,2182.7497284900005,null,17197.323003840003]
[null," 10",2199.4217848099997,null,1172.9873598400002,null,768.42919243999995,null,127.31523886000002,null,4268.1535759500002]
[null," 15",941.93582095999977,null,2705.7074897800007,null,235.92976998999998,null,92.530073479999984,null,3976.1031542100004]
[null," 20",50.450994100000003,null,405.85440213000015,null,8.9356861799999994,null,3.3729562999999998,null,468.61403871000022]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",145918.33267485001,null,45425.462851459983,null,20390.263639260003,null,7642.8622992800019,null,219376.92146485002]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",48442.768292476962,null,21032.821826626248,null,6793.1058279040881,null,2906.0404458855073,null,79174.73639289281]
[null,"20 - 40%",43659.822493157226,null,11608.813636499237,null,6240.5371954793936,null,2562.9031301048331,null,64072.076455240684]
[null,"40 - 60%",32348.510656579318,null,6669.5322260121784,null,4730.5854516843401,null,1559.6665334145403,null,45308.294867690383]
[null,"60 - 80%",16507.117254280984,null,3302.4686562138095,null,1799.319063789485,null,486.54888574375201,null,22095.453860028032]
[null,"> 80 %",4960.1139775851916,null,2811.8265059185433,null,826.71610085268276,null,127.70330389137345,null,8726.3598882477909]
[null,"Total",145918.33267407969,null,45425.462851270015,null,20390.263639709992,null,7642.8622990400054,null,219376.92146409967]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":42,"n_cols":4,"rows_kept":42,"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*",67,36]
[]
[]
[]
[]
[]
[]
[null,"*Q2 2015"]

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

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

{"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 2015 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%",142.25827963697284,null,56.675738783134328,null,46.669643904852308,null,18.794969106703633,null,0.35528046009486586,null,264.39863143166315]
[null," - 20-40%",123.4811124642649,null,38.083178116731631,null,39.761517073853391,null,15.476828119833986,null,0.2913242771747005,null,216.80263577468389]
[null," - 40-60%",92.355398592334652,null,25.983602581656886,null,25.653542105037154,null,9.7655364373180671,null,0.20660939509834708,null,153.75807971634677]
[null," - 60-80%",49.53735582431348,null,14.36151122178364,null,6.6950595309319381,null,3.3956140654180436,null,9.9421989816352627E-2,null,73.98954064244711]
[null," - >80%",18.508636494443614,null,11.577489283063699,null,4.3650432607253471,null,0.79688392373634687,null,4.7363877815733882E-2,null,35.248052961969009]
[null,"Total",426.14078301232951,null,146.68151998637018,null,123.14480587540014,null,48.229831653010073,null,1,null,744.19694052710997]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",81.334347654524905,null,21.857049046425249,null,35.572094749830029,null,14.985965263581051,null,0.34471161637916697,null,153.74945671436123]
[null," - 20-40%",71.511729486873676,null,18.194493017755931,null,30.679563690490017,null,12.523247481477853,null,0.29798666485807224,null,132.90903367659746]
[null," - 40-60%",54.91580075191348,null,13.688590904480122,null,18.608694848460015,null,8.0503396897532689,null,0.21358390674750977,null,95.263426194606893]
[null," - 60-80%",30.459506052529154,null,7.4514235782615774,null,4.123065979289998,null,2.8666411766487387,null,0.10066878552918929,null,44.900636786729471]
[null," - >80%",11.906018180128843,null,4.6158938759670702,null,2.0154538333599992,null,0.6635084641190987,null,4.3049026486061709E-2,null,19.20087435357501]
[null,"Total",250.12740212597006,null,65.807450422889943,null,90.998873101430064,null,39.089702075580014,null,1,null,446.02342772587008]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",48.442768292476963,null,21.032821826626247,null,6.7931058279040881,null,2.9060404458855071,null,0.36090731816495786,null,79.174736392892797]
[null," - 20-40%",43.659822493157229,null,11.608813636499237,null,6.2405371954793942,null,2.5629031301048331,null,0.29206388724771065,null,64.072076455240691]
[null," - 40-60%",32.348510656579322,null,6.6695322260121781,null,4.7305854516843402,null,1.5596665334145403,null,0.20653172888609861,null,45.308294867690385]
[null," - 60-80%",16.507117254280981,null,3.3024686562138097,null,1.7993190637894849,null,0.48654888574375199,null,0.10071913541572729,null,22.095453860028027]
[null," - >80%",4.9601139775851921,null,2.8118265059185434,null,0.82671610085268266,null,0.12770330389137347,null,3.9777930285505581E-2,null,8.7263598882477904]
[null,"Total",145.91833267407969,null,45.425462851270019,null,20.390263639709993,null,7.6428622990400061,null,1,null,219.37692146409969]

{"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 2015 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%",55.721955050512399,null,189.67679258135379,null,18.999883799795821,null,264.39863143166201]
[null," - 20-40%",38.530618639894499,null,160.68217029591256,null,17.589846838876557,null,216.80263577468361]
[null," - 40-60%",23.381347565302757,null,115.65551883464529,null,14.721213316399531,null,153.75807971634759]
[null," - 60-80%",10.261399710182555,null,54.736089901606732,null,8.9920510306581161,null,73.989540642447409]
[null," - >80%",6.9359794981295639,null,21.448977379997327,null,6.863096083842124,null,35.248052961969016]
[null,"Total",134.83130046402178,null,542.19954899351569,null,67.166091069572147,null,744.19694052710963]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",24.89627890819246,null,115.01964415291106,null,13.833533653257788,null,153.74945671436132]
[null," - 20-40%",19.054392103433837,null,100.91755798375601,null,12.937083589407644,null,132.90903367659749]
[null," - 40-60%",11.357207506896199,null,72.999248256159476,null,10.906970431551201,null,95.263426194606879]
[null," - 60-80%",4.7451809271740366,null,33.662114017906184,null,6.4933418416491797,null,44.900636786729407]
[null," - >80%",2.2184815706339469,null,12.571904797510731,null,4.4104879854303478,null,19.200874353575024]
[null,"Total",62.271541016330481,null,335.17046920824345,null,48.581417501296158,null,446.02342772587008]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",17.584155273463384,null,58.232422063339051,null,3.3581590560905585,null,79.174736392892996]
[null," - 20-40%",11.589524060579222,null,49.234008837513642,null,3.2485435571479004,null,64.072076455240762]
[null," - 40-60%",7.203427260604701,null,35.319306559095338,null,2.7855610479903494,null,45.308294867690385]
[null," - 60-80%",2.8381543114251184,null,17.47703616963819,null,1.7802633789646838,null,22.095453860027991]
[null," - >80%",1.6386172395308847,null,5.7239988245188282,null,1.3637438241980768,null,8.7263598882477904]
[null,"Total",40.853878145603318,null,165.98677245410502,null,12.536270864391568,null,219.37692146409989]

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

{"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",45425462851.46006,45173968164.540062]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",20390263639.259987,20355802080.079987]
["S-Landbrug","S",null,"Landbrug",7642862299.2799969,7642862299.2799969]
["S-Privat","S",null,"Privat",145918332674.85007,145918332674.85007]
["S Total-","S Total","S Total",null,219376921464.8501,219090965218.75012]
["T-Boligudl","T","T","Boligudl",65807450423.09996,64822939556.819931]
["T-Erhverv","T",null,"Erhverv",90998873101.780273,77397597648.150024]
["T-Landbrug","T",null,"Landbrug",39089702075.330002,39089702075.330002]
["T-Privat","T",null,"Privat",250127402125.67001,250127402125.67001]
["T Total-","T Total","T Total",null,446023427725.88025,431437641405.96997]
["Ø-Boligudl","Ø","Ø","Boligudl",35448606712.089989,35247273925.579987]
["Ø-Erhverv","Ø",null,"Erhverv",11755669134.229988,11458106890.999989]
["Ø-Landbrug","Ø",null,"Landbrug",1497267278.339999,1497267278.339999]
["Ø-Privat","Ø",null,"Privat",30095048212.419983,30095048212.419983]
["Ø Total-","Ø Total","Ø Total",null,78796591337.079956,78297696307.339951]
["Grand Total-","Grand Total","Grand Total",null,744196940527.8103,728826302932.06006]
[]
[]
[]
[]
[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":250127402125.67001}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":64822939556.819931}]
[null,null,"T-Erhverv","Erhverv","Commercial",77397597648.150024]
[null,null,"T-Landbrug","Landbrug","Agriculture",39089702075.330002]
[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":14585786319.910278}]
[]
[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":145918332674.85007}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":45173968164.540062}]
[null,null,"S-Erhverv","Erhverv","Commercial",20355802080.079987]
[null,null,"S-Landbrug","Landbrug","Agriculture",7642862299.2799969]
[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":285956246.09997559}]
[]
[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":30095048212.419983}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":35247273925.579987}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",11458106890.999989]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",1497267278.339999]
[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":498895029.74000549}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":426140783012.94006}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":145244181646.93997}]
[null,null,null,null,"Commercial",109211506619.23]
[null,null,null,null,"Agriculture",48229831652.949997]
[null,null,null,null,"Nordic",15370637595.750259]

{"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",11398007583.559999,551384031.01999998]
[null,"F1",31802373694.23,14348763676.09]
[null,"F3",56339078637.519997,15711973809.18]
[null,"F5",54528168825.919998,20551967255.490002]
[null,"Fixed",34243344124.099998,5568773884.29]
[null,"Floaters",9514999511.8799992,70297039292.460007]
[null,"Øv. flex",16990481836.09,20790965701.610001]
["J Total",null,214816454213.29999,147820867650.14001]
["N","CapFloat",10729043837.639999,935079582.32000005]
[null,"F1",18840043688.689999,10249112982.09]
[null,"F3",32639474373,10698650209.65]
[null,"F5",33282155372.990002,36999084500.269997]
[null,"Fixed",106416613353.36,77875474672.139999]
[null,"Floaters",3937949823.8400002,27297721033.459999]
[null,"Øv. flex",5479048350.1999998,6180166884.5699997]
["N Total",null,211324328799.72,170235289864.5]