{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2014 Q4 Total","RD 2014 Q4 Cap T","RD 2014 Q4 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 2014 Q4 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q4 - 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",430251.54919100035,null,146073.53943671024,null,123719.27941715003,null,48455.1876210099,null,748499.55566587043]
[null," - Number of loans",418776,null,39919,null,15312,null,15033,null,489040]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",135986.82510703988,null,62553.942180850085,null,12466.154614710011,null,4827.4988022299995,null,215834.42070482997]
[null," - repayment loans",100585.48745427989,null,59999.673569280079,null,11404.783297920012,null,3302.3389972599989,null,175292.28331874]
[null," - interest-only ",35401.33765275999,null,2554.2686115700017,null,1061.3713167899996,null,1525.1598049700003,null,40542.137386089991]
[null,"FlexLån®",256982.98077134992,null,64358.408506290012,null,47678.188407449969,null,27377.632659330029,null,396397.21034441993]
[null," - repayment loans",91760.512701339947,null,38789.929177980011,null,18074.998068539997,null,8152.1934168599964,null,156777.63336471995]
[null," - interest-only ",165222.46807000996,null,25568.479328309997,null,29603.190338909968,null,19225.439242470031,null,239619.57697969995]
[null,"FlexGaranti®, Rentedyk TM",24471.281892859992,null,831.00504625999974,null,386.29778402999995,null,432.96010686,null,26121.544830009996]
[null," - repayment loans",11010.178791369994,null,463.51576411999997,null,267.40129786,null,199.96731270000001,null,11941.063166049995]
[null," - interest-only ",13461.103101489998,null,367.48928213999989,null,118.89648617,null,232.99279415999999,null,14180.481663959998]
[null,"FlexKort®",12684.296486430007,null,2640.5195207899992,null,2380.3927578900002,null,6979.2873125799997,null,24684.496077690008]
[null," - repayment loans",3767.4033196399996,null,821.35401747000003,null,1326.3822214500001,null,1472.9501349299992,null,7388.0896934899993]
[null," - interest-only ",8916.8931667900069,null,1819.1655033199993,null,1054.0105364400004,null,5506.3371776500007,null,17296.406384200007]
[null,"Other floating rate loans",126.16493331999997,null,15689.664182519993,null,60808.245853070017,null,8837.8087400099976,null,85461.88370892001]
[null," - repayment loans",24.96870925,null,3071.1212969399985,null,17750.373312739997,null,1653.1717477299999,null,22499.635066659997]
[null," - interest-only ",101.19622406999997,null,12618.542885579995,null,43057.87254033002,null,7184.6369922799977,null,62962.248642260012]
[null," Total",430251.54919099977,null,146073.5394367101,null,123719.27941715,null,48455.187621010031,null,748499.55566586985]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",174721.46460451995,null,53111.674359739976,null,46822.968094129959,null,3309.342210310002,null,277965.44926869991]
[null," - Other Sealand",87810.254905729613,null,17060.842129189983,null,10538.551993650002,null,13050.053960650026,null,128459.70298921963]
[null," - Region South Denmark",71006.27234751005,null,27149.221442329996,null,25547.777505289989,null,16548.104199170011,null,140251.37549430004]
[null," - Region Central Jutland",72719.532729479979,null,33784.313765769963,null,21270.270845059993,null,9350.9734113200047,null,137125.09075162993]
[null," - Region North Jutland",23992.066777210046,null,13547.158492750032,null,6802.6441307999876,null,6196.7138395599995,null,50538.583240320062]
[null," - Other area",1.9578265499999998,null,1420.3292469299997,null,12737.066848219998,null,0,null,14159.353921699996]
[null,"Total",430251.54919099965,null,146073.53943670992,null,123719.27941714993,null,48455.187621010038,null,748499.55566586962]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",264591.00773684977,null,9709.6341843599803,null,4142.5326081600042,null,3518.7484724099941,null,281961.92300177971]
[null," 2 - 5",144587.95345087998,null,13412.35081473997,null,6615.9564417899956,null,6999.1013882400048,null,171615.36209564994]
[null," 5 - 20",20386.30930101002,null,44173.766314049979,null,21388.786016740018,null,15759.639674309994,null,101708.50130611002]
[null," 20 - 50",577.53262050000012,null,34299.001316589965,null,19847.926099650005,null,14889.608010110011,null,69614.068046849992]
[null," 50 - 100",108.74608176,null,19927.14717878,null,17621.995618460005,null,6302.6853269999992,null,43960.574205999998]
[null," 100 and above",0,null,24551.639628190005,null,54102.082632350008,null,985.40474893999976,null,79639.127009480013]
[null,"Total",430251.54919099977,null,146073.53943670989,null,123719.27941715004,null,48455.187621010002,null,748499.55566586962]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",49272.311872400038,null,12131.481813040004,null,9932.6487923799923,null,3973.3085653700009,null,75309.75104319003]
[null," 1",53440.39844752002,null,17453.981079980011,null,26345.996176239998,null,11081.67557299,null,108322.05127673001]
[null," 2",66686.028727770026,null,19615.463412580011,null,20858.637939310007,null,4284.1115928099998,null,111444.24167247003]
[null," 3",31022.04124362002,null,6023.4532421899985,null,4570.7047734199987,null,1244.4026610799992,null,42860.601920310022]
[null," 4",30306.176648550012,null,9573.1713370199959,null,11735.21416502001,null,2573.8514959499994,null,54188.413646540015]
[null," 6",94054.550165759982,null,11650.268277200004,null,15406.651330540019,null,7486.6404359499993,null,128598.11020945001]
[null," 8",32978.336973379948,null,13475.554643889996,null,20787.236428359985,null,9719.3995570700099,null,76960.527602699935]
[null," 10",48080.406029490019,null,14356.965490069999,null,10678.735432859992,null,5407.5363068400029,null,78523.643259260003]
[null," 15",22159.813298399989,null,14695.930034149978,null,2913.2744909800003,null,2342.6553608300014,null,42111.673184359977]
[null," 20",1812.1010507499986,null,14890.796187260003,null,382.5530144600001,null,187.45092187999992,null,17272.901174350001]
[null," 25",359.7607819700001,null,11628.390281269985,null,44.092741249999996,null,18.518235149999999,null,12050.762039639983]
[null," 30",79.623951389999974,null,578.08363806000011,null,63.534132329999998,null,135.63691508999997,null,856.87863687000015]
[null,"Total",430251.54919100006,null,146073.53943670998,null,123719.27941715001,null,48455.187621010002,null,748499.55566586996]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",137916.37983834938,null,53972.942749050198,null,45371.813582145965,null,18517.460240901702,null,255778.59641044727]
[null,"20 - 40%",120836.64730183706,null,37036.735200131072,null,37394.239459765085,null,15479.656397110097,null,210747.27835884332]
[null,"40 - 60%",92983.874677235624,null,26035.514042737934,null,27265.305030846208,null,9868.6269884661506,null,156153.32073928593]
[null,"60 - 80%",54731.532120435928,null,15216.700344369148,null,8504.7202778014071,null,3611.0055535672341,null,82063.958296173703]
[null,"> 80 %",23783.115252511336,null,13811.647100511751,null,5183.2010673513314,null,978.4384408447869,null,43756.401861219209]
[null,"Total",430251.54919036938,null,146073.53943680011,null,123719.27941790999,null,48455.18762088997,null,748499.5556659695]

{"sheet":"RD 2014 Q4 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 2014 Q4 - 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",240181.46011191988,null,61964.067782450082,null,89520.317020140064,null,39232.817678859908,null,430898.66259337001]
[null," - Number of loans",210779,null,15492,null,9009,null,10900,null,246180]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",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,"FlexLån®",227412.54284398016,null,47088.272326830003,null,37555.194792430018,null,25759.302893050008,null,337815.31285629014]
[null," - repayment loans",82081.400222949946,null,29277.115709850012,null,15911.891053020006,null,7701.3652820199968,null,134971.77226783996]
[null," - interest-only ",145331.14262103022,null,17811.156616979992,null,21643.303739410007,null,18057.937611030011,null,202843.54058845018]
[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®",12684.296486430007,null,2640.5195207899992,null,2380.3927578899998,null,6979.2873125799979,null,24684.496077690001]
[null," - repayment loans",3767.4033196399996,null,821.35401746999992,null,1326.3822214499999,null,1472.9501349299996,null,7388.0896934899993]
[null," - interest-only ",8916.8931667900069,null,1819.1655033199993,null,1054.0105364400001,null,5506.3371776499989,null,17296.406384200003]
[null,"Other floating rate loans",84.620781509999986,null,12235.275934829999,null,49584.729469820057,null,6494.2274732299966,null,68398.85365939005]
[null," - repayment loans",17.550003839999999,null,2672.6234012999998,null,14906.137728120011,null,1316.3859108699999,null,18912.697044130007]
[null," - interest-only ",67.070777669999984,null,9562.6525335299993,null,34678.591741700046,null,5177.8415623599967,null,49486.156615260043]
[null," Total",240181.4601119202,null,61964.067782450002,null,89520.317020140079,null,39232.817678860003,null,430898.66259337025]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",105607.45394779008,null,21199.424875460001,null,32914.218448959989,null,2812.5793794200008,null,162533.67665163008]
[null," - Other Sealand",46977.893114839979,null,6250.8489808600007,null,6811.8805262000051,null,10767.810762420009,null,70808.433384319986]
[null," - Region South Denmark",35137.051020799976,null,11868.535685409992,null,18638.780493059996,null,12617.47289059001,null,78261.840089859965]
[null," - Region Central Jutland",40110.41772200002,null,15330.180718310012,null,14389.716947420011,null,7761.4348586399929,null,77591.750246370037]
[null," - Region North Jutland",12348.644306489979,null,6356.1387895099942,null,4370.8299676900006,null,5273.5197877900027,null,28349.132851479972]
[null," - Other area",0,null,958.9387329000001,null,12394.890636810002,null,0,null,13353.829369710002]
[null,"Total",240181.46011192008,null,61964.067782450002,null,89520.317020140006,null,39232.817678860018,null,430898.66259337013]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",131817.23120712995,null,5500.2778634999931,null,2197.0919445999994,null,2044.6358882499994,null,141559.23690347996]
[null," 2 - 5",92498.556146170013,null,6191.0533390800056,null,4192.6371902400006,null,5212.9692149900002,null,108095.21589048003]
[null," 5 - 20",15362.390575139994,null,16309.559173459995,null,14541.937135269998,null,13091.601842440014,null,59305.488726309995]
[null," 20 - 50",482.53315996999993,null,12597.694396709992,null,13541.004439809994,null,12504.705535419998,null,39125.937531909978]
[null," 50 - 100",20.749023510000001,null,9557.8602869799979,null,11348.838318300001,null,5487.9549038999976,null,26415.402532689997]
[null," 100 and above",0,null,11807.622722719994,null,43698.807991919988,null,890.9502938600001,null,56397.381008499986]
[null,"Total",240181.46011191997,null,61964.067782449973,null,89520.317020139977,null,39232.817678860018,null,430898.66259336995]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",18864.356886700029,null,6209.1385859399998,null,6800.7369456800006,null,2694.3136387400004,null,34568.546057060026]
[null," 1",33603.71367431002,null,10734.674768299999,null,24574.661056550001,null,10393.492878300001,null,79306.54237746002]
[null," 2",27485.222100880012,null,8356.9570736800033,null,15896.476979060002,null,2805.0564780699992,null,54543.712631690018]
[null," 3",15777.164485720004,null,3507.0033411200029,null,3570.8388505499984,null,1010.0681364999999,null,23865.074813890005]
[null," 4",19854.740186200001,null,5254.4915454999964,null,8686.8932439200016,null,2280.5807471499998,null,36076.705722769999]
[null," 6",68665.835160200033,null,7825.3998345300042,null,13198.413701830003,null,6683.6899122400018,null,96373.338608800041]
[null," 8",22498.100910789988,null,5083.9910996699946,null,9025.6753591500019,null,6889.731886079996,null,43497.499255689982]
[null," 10",16208.767888459994,null,7539.9759658999983,null,5577.8234673600036,null,4192.821567699998,null,33519.388889419992]
[null," 15",16529.047000559996,null,7260.9644819199993,null,2012.2126014600005,null,2132.6492388299985,null,27934.873322769992]
[null," 20",694.51181810000003,null,191.4710858900001,null,176.58481458000009,null,150.41319525,null,1212.9809138200001]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",240181.46011192005,null,61964.067782450002,null,89520.317020140006,null,39232.817678860003,null,430898.66259337013]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",74885.708034298645,null,19111.879471823424,null,33695.210794895829,null,14517.601642885149,null,142210.39994390309]
[null,"20 - 40%",66786.783235072478,null,16370.708395183843,null,27975.921658392079,null,12557.845302468861,null,123691.25859111726]
[null,"40 - 60%",52933.075836779084,null,13345.551842070248,null,19814.728377089017,null,8240.9037093315928,null,94334.259765269933]
[null,"60 - 80%",31642.673176446369,null,7604.8106962941083,null,5433.9601783358939,null,3083.9299015057841,null,47765.373952582158]
[null,"> 80 %",13933.219829283422,null,5531.117377448435,null,2600.4960116073066,null,832.53712281862749,null,22897.370341157788]
[null,"Total",240181.46011188001,null,61964.06778282005,null,89520.317020320115,null,39232.817679010019,null,430898.6625940302]

{"sheet":"RD 2014 Q4 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 2014 Q4 - 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",150887.77383171977,null,46771.025391399984,null,21384.133317409978,null,7347.723389010006,null,226390.65592953973]
[null," - Number of loans",138134,null,9096,null,3350,null,2401,null,152981]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",116304.54757318989,null,29980.570993659992,null,10603.151659790006,null,3920.0653313499984,null,160808.33555798989]
[null," - repayment loans",84307.429600849908,null,27623.503256049993,null,9614.9589471500076,null,2558.6420265399984,null,124104.53383058991]
[null," - interest-only ",31997.117972339984,null,2357.0677376099998,null,988.19271263999951,null,1361.42330481,null,36703.801727399987]
[null,"FlexLån®",28761.275561090013,null,14928.361374939996,null,6455.4681656900002,null,1434.07838608,null,51579.183487800008]
[null," - repayment loans",9516.0192421899974,null,9073.1395407399941,null,2066.1406037699999,null,408.14773267999988,null,21063.447119379995]
[null," - interest-only ",19245.256318900014,null,5855.2218342000006,null,4389.3275619200012,null,1025.9306534,null,30515.736368420017]
[null,"FlexGaranti®, Rentedyk TM",5799.3787683600003,null,121.00684792000001,null,54.83050054000001,null,33.435388429999996,null,6008.6515052500017]
[null," - repayment loans",2322.3969256600008,null,73.611755260000024,null,44.122409650000009,null,18.70370707,null,2458.8347976400014]
[null," - interest-only ",3476.9818427000005,null,47.395092660000003,null,10.708090890000001,null,14.73168136,null,3549.8167076100003]
[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",22.571929079999997,null,1741.0861748799996,null,4270.682991390001,null,1960.1442831500001,null,7994.4853785000014]
[null," - repayment loans",5.4222540600000002,null,257.74810643999996,null,1157.6339895599999,null,214.56886077999999,null,1635.37321084]
[null," - interest-only ",17.14967502,null,1483.3380684399997,null,3113.0490018300011,null,1745.5754223700001,null,6359.1121676600005]
[null," Total",150887.77383171991,null,46771.025391399999,null,21384.133317410007,null,7347.7233890099969,null,226390.65592953991]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",57364.506696700053,null,20081.778111619944,null,7978.7348007800001,null,381.80021339000001,null,85806.819822489997]
[null," - Other Sealand",30410.791204319983,null,5170.9873630599968,null,2487.0781227800003,null,1857.1115683299995,null,39925.968258489986]
[null," - Region South Denmark",27964.953041690016,null,8104.2117867000015,null,4533.7564479200028,null,3231.8356139299981,null,43834.756890240031]
[null," - Region Central Jutland",26220.438589170008,null,9665.2123827000105,null,4473.4808776900018,null,1160.3336774299999,null,41519.465526990018]
[null," - Region North Jutland",8927.0842998400021,null,3497.9771913299983,null,1876.7086761599996,null,716.64231593000011,null,15018.412483260001]
[null," - Other area",0,null,250.85855599000001,null,34.37439208,null,0,null,285.23294807000002]
[null,"Total",150887.77383172006,null,46771.025391399955,null,21384.133317410007,null,7347.7233890099988,null,226390.65592954005]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100033.28470659995,null,2177.0662061400017,null,1034.3328204099998,null,892.47415710000018,null,104137.15789024996]
[null," 2 - 5",46099.622263029931,null,4442.182501690002,null,1836.3143195700013,null,1355.5734982699992,null,53733.692582559932]
[null," 5 - 20",4629.7755829300004,null,15731.645991210014,null,5521.1737727799991,null,2211.88276443,null,28094.478111350014]
[null," 20 - 50",89.81036078999999,null,11077.468496899999,null,5173.3406393800014,null,2162.6528609899992,null,18503.272358060003]
[null," 50 - 100",35.280918369999995,null,5648.9920412799993,null,4061.97425699,null,686.51154767000003,null,10432.75876431]
[null," 100 and above",0,null,7693.6701541799994,null,3756.9975082800006,null,38.628560549999996,null,11489.296223009998]
[null,"Total",150887.77383171988,null,46771.025391400013,null,21384.133317410004,null,7347.7233890099997,null,226390.65592953988]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",30407.954985699973,null,5922.3432270999965,null,2723.8118848299996,null,1278.9949266299996,null,40333.105024259974]
[null," 1",19836.68477321,null,6719.3063116799995,null,1430.0121988399997,null,688.18269469000006,null,28674.185978419995]
[null," 2",39200.806626890015,null,11258.506338900004,null,4731.65130795,null,1479.0551147399999,null,56670.019388480017]
[null," 3",15244.876757899998,null,2516.4499010700019,null,867.77056485000026,null,234.33452457999999,null,18863.431748400002]
[null," 4",10451.221656810005,null,4318.6797915199968,null,1626.5985581499997,null,293.27074880000021,null,16689.770755280002]
[null," 6",25385.407089640019,null,3824.8684426700001,null,2208.2376287099996,null,802.95052370999974,null,32221.463684730017]
[null," 8",4862.0189231900058,null,5347.2919024300008,null,6547.7422355599956,null,2256.3074354600003,null,19013.360496640002]
[null," 10",3734.48251304,null,2356.5515677299995,null,926.25026680999997,null,203.71652104999998,null,7221.0008686299998]
[null," 15",1691.9181692099994,null,4457.8198805900001,null,306.05707060999998,null,107.32004995999999,null,6563.1151703699989]
[null," 20",72.402336129999995,null,49.20802771000001,null,16.001601100000002,null,3.5908493900000003,null,141.20281433]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",150887.77383172,null,46771.025391399999,null,21384.133317409993,null,7347.7233890100015,null,226390.65592954002]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",46913.516308965882,null,20194.919063857993,null,6806.1336131916778,null,2876.9594544109245,null,76791.528440426482]
[null,"20 - 40%",43071.460894385593,null,12113.338053775935,null,6187.7704058159561,null,2423.9972732863853,null,63796.566627263863]
[null,"40 - 60%",33379.121704572062,null,7042.8972603308002,null,5018.0229255035701,null,1440.7386262905841,null,46880.780516697021]
[null,"60 - 80%",19747.728863957727,null,3893.6427843922129,null,2194.0247601135447,null,474.15665914591295,null,26309.553067609402]
[null,"> 80 %",7775.9460592287314,null,3526.2282285830438,null,1178.1816134452602,null,131.87137563619618,null,12612.227276893229]
[null,"Total",150887.77383110998,null,46771.025390939991,null,21384.133318070006,null,7347.7233887700031,null,226390.65592888999]

{"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,"*Q4 2014"]

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

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

{"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 2014 Q4"]
[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%",137.9163798383494,null,53.972942749050205,null,45.371813582145968,null,18.517460240901702,null,0.34172177454784308,null,255.77859641044725]
[null," - 20-40%",120.83664730183706,null,37.036735200131076,null,37.394239459765082,null,15.479656397110096,null,0.28155965726837756,null,210.74727835884332]
[null," - 40-60%",92.983874677235633,null,26.035514042737933,null,27.265305030846207,null,9.8686269884661506,null,0.20862179483907659,null,156.15332073928593]
[null," - 60-80%",54.731532120435929,null,15.216700344369148,null,8.5047202778014075,null,3.6110055535672339,null,0.10963795191990217,null,82.063958296173723]
[null," - >80%",23.783115252511337,null,13.811647100511751,null,5.183201067351332,null,0.97843844084478682,null,5.8458821424800175E-2,null,43.756401861219203]
[null,"Total",430.25154919036936,null,146.0735394368001,null,123.71927941791,null,48.455187620889966,null,0.99999999999999967,null,748.49955566596941]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",74.885708034298645,null,19.111879471823425,null,33.695210794895829,null,14.517601642885149,null,0.33003212190956865,null,142.21039994390304]
[null," - 20-40%",66.786783235072477,null,16.370708395183843,null,27.975921658392078,null,12.557845302468861,null,0.28705417149937318,null,123.69125859111726]
[null," - 40-60%",52.933075836779082,null,13.345551842070247,null,19.814728377089015,null,8.2409037093315938,null,0.21892446636379251,null,94.334259765269934]
[null," - 60-80%",31.642673176446369,null,7.6048106962941082,null,5.4339601783358935,null,3.0839299015057842,null,0.11085059690144397,null,47.765373952582152]
[null," - >80%",13.933219829283422,null,5.5311173774484352,null,2.6004960116073064,null,0.83253712281862746,null,5.3138643325821772E-2,null,22.897370341157789]
[null,"Total",240.18146011188,null,61.964067782820067,null,89.520317020320121,null,39.232817679010019,null,1,null,430.89866259403016]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",46.913516308965882,null,20.194919063857995,null,6.8061336131916779,null,2.8769594544109243,null,0.33919919585615294,null,76.791528440426475]
[null," - 20-40%",43.071460894385588,null,12.113338053775934,null,6.1877704058159564,null,2.423997273286385,null,0.28179858557105186,null,63.796566627263857]
[null," - 40-60%",33.379121704572064,null,7.0428972603308004,null,5.0180229255035709,null,1.4407386262905841,null,0.20707913197363775,null,46.880780516697016]
[null," - 60-80%",19.747728863957725,null,3.8936427843922128,null,2.1940247601135447,null,0.47415665914591293,null,0.11621306965899385,null,26.309553067609396]
[null," - >80%",7.7759460592287315,null,3.5262282285830437,null,1.1781816134452601,null,0.13187137563619619,null,5.5710016940163705E-2,null,12.612227276893231]
[null,"Total",150.88777383111,null,46.77102539093999,null,21.38413331807001,null,7.3477233887700031,null,1,null,226.39065592889]

{"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 2014 Q4"]
[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%",53.212549599420377,null,184.36555515903146,null,18.200491651995748,null,255.77859641044759]
[null," - 20-40%",36.393489135815734,null,157.19003204708838,null,17.163757175939612,null,210.74727835884374]
[null," - 40-60%",23.236061086656335,null,118.27845489385587,null,14.638804758773471,null,156.15332073928568]
[null," - 60-80%",10.91840193010202,null,61.62410721293633,null,9.5214491531354977,null,82.063958296173837]
[null," - >80%",8.3415363887244904,null,27.655596359632966,null,7.75926911286167,null,43.756401861219132]
[null,"Total",132.10203814071895,null,549.11374567254506,null,67.283771852705996,null,748.49955566596998]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",21.983738507694468,null,107.4116348175863,null,12.815026618622339,null,142.21039994390313]
[null," - 20-40%",16.255153304030813,null,95.201529657722347,null,12.23457562936402,null,123.69125859111718]
[null," - 40-60%",10.578493279917851,null,73.194424944573711,null,10.561341540778409,null,94.334259765269977]
[null," - 60-80%",4.5594084085787898,null,36.471688440197717,null,6.7342771038056943,null,47.765373952582202]
[null," - >80%",2.4393792810539106,null,15.603381919427468,null,4.8546091406764145,null,22.897370341157796]
[null,"Total",55.816172781275831,null,327.88265977950755,null,47.199830033246876,null,430.89866259403027]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",16.4632276666016,null,56.814165020478917,null,3.5141357533459767,null,76.791528440426504]
[null," - 20-40%",11.686428409432958,null,48.730332917521281,null,3.3798053003095552,null,63.796566627263793]
[null," - 40-60%",7.5226268492486508,null,36.453481007455657,null,2.904672659992702,null,46.880780516697016]
[null," - 60-80%",3.579986578412421,null,20.74943948147995,null,1.9801270077169986,null,26.309553067609368]
[null," - >80%",2.1987863539569252,null,8.6238124198853772,null,1.7896285030509536,null,12.612227276893256]
[null,"Total",41.451055857652563,null,171.37123084682119,null,13.568369224416186,null,226.39065592888994]

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

{"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",46771025391.399986,46520166835.409981]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21384133317.409966,21349758925.329964]
["S-Landbrug","S",null,"Landbrug",7347723389.010004,7347723389.010004]
["S-Privat","S",null,"Privat",150887773831.71991,150887773831.71991]
["S Total-","S Total","S Total",null,226390655929.53986,226105422981.46985]
["T-Boligudl","T","T","Boligudl",61964067782.450081,61005214592.920036]
["T-Erhverv","T",null,"Erhverv",89520317020.139786,77125426383.329773]
["T-Landbrug","T",null,"Landbrug",39232817678.860001,39232817678.860001]
["T-Privat","T",null,"Privat",240181460111.9198,240181460111.9198]
["T Total-","T Total","T Total",null,430898662593.36969,417544918767.0296]
["Ø-Boligudl","Ø","Ø","Boligudl",37338446262.85997,37139862006.519981]
["Ø-Erhverv","Ø",null,"Erhverv",12814829079.599981,12520053432.38998]
["Ø-Landbrug","Ø",null,"Landbrug",1874646553.1400006,1874646553.1400006]
["Ø-Privat","Ø",null,"Privat",39182315247.360023,39182315247.360023]
["Ø Total-","Ø Total","Ø Total",null,91210237142.959976,90716877239.409973]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,748499555665.86938,734367218987.90955]
[]
[]
[]
[]
[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":240181460111.9198}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":61005214592.920036}]
[null,null,"T-Erhverv","Erhverv","Commercial",77125426383.329773]
[null,null,"T-Landbrug","Landbrug","Agriculture",39232817678.860001]
[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":13353743826.340088}]
[]
[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":150887773831.71991}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":46520166835.409981}]
[null,null,"S-Erhverv","Erhverv","Commercial",21349758925.329964]
[null,null,"S-Landbrug","Landbrug","Agriculture",7347723389.010004]
[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":285232948.07000732}]
[]
[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":39182315247.360023}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":37139862006.519981}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",12520053432.38998]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",1874646553.1400006]
[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":493359903.54998779}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":430251549190.99976}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":144665243434.85001}]
[null,null,null,null,"Commercial",110995238741.04971]
[null,null,null,null,"Agriculture",48455187621.010002]
[null,null,null,null,"Nordic",14132336677.960083]

{"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",13461103101.58,719378562.45000005]
[null,"F1",40232484898.5,19298716131.34]
[null,"F3",55174677536.400002,14718905827.1]
[null,"F5",53909207877.68,20003531740.59]
[null,"Fixed",35401337652.620003,5140799733.3500004]
[null,"Floaters",9018089390.7999992,71240565635.470001]
[null,"Øv. flex",15906097757.33,20375955210.619999]
["J Total",null,223102998214.90997,151497852840.91998]
["N","CapFloat",11010178791.34,930884374.64999998]
[null,"F1",22453800231.07,13364527493.07]
[null,"F3",31458809694.849998,9354686567.5499992]
[null,"F5",32227544769.209999,35966550197.290001]
[null,"Fixed",100585487454.23,74706795864.669998]
[null,"Floaters",3792372028.8699999,26095352731.23]
[null,"Øv. flex",5620358006.1199999,6331356405.3699999]
["N Total",null,207148550975.69,166750153633.82999]