{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2013 Q4 Total","RD 2013 Q4 Cap T","RD 2013 Q4 Cap S","Repossed Properties - Year","Repossed Properties - Quarter","LTV","LTV - Sectors","LTV - Classification","3m arrears","Borrower segmentation Nordic"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":1},"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 2013 Q4 Total","index":0,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2013 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",423016.70300970972,null,142216.08912348989,null,120154.48796003958,null,48855.115319089877,null,734242.395412329]
[null," - Number of loans",426431,null,41724,null,16132,null,15583,null,499870]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",130393.47512108032,null,61685.550598590031,null,12813.939100229998,null,4335.9443843600002,null,209228.90920426039]
[null," - repayment loans",95629.377130470326,null,59290.165801850038,null,11621.322287059998,null,3137.6381396100005,null,169678.50335899036]
[null," - interest-only ",34764.097990610011,null,2395.3847967399988,null,1192.6168131699994,null,1198.3062447499997,null,39550.405845270005]
[null,"FlexLån®",260498.56919195011,null,64791.126992949903,null,58689.001802410006,null,30461.233129100034,null,414439.93111641001]
[null," - repayment loans",87875.158889670376,null,36111.969831409893,null,28176.911906100002,null,8330.1125631300129,null,160494.15319031026]
[null," - interest-only ",172623.41030227972,null,28679.157161540013,null,30512.089896309997,null,22131.120565970021,null,253945.77792609975]
[null,"FlexGaranti®, Rentedyk TM",27176.304077399993,null,950.59523576999993,null,428.07822403999995,null,485.81605094000014,null,29040.793588149994]
[null," - repayment loans",11980.163783119997,null,524.28445325999985,null,304.56044847000004,null,214.30467255000008,null,13023.313357399998]
[null," - interest-only ",15196.140294279998,null,426.31078251000014,null,123.51777557,null,271.51137839,null,16017.480230749996]
[null,"FlexKort®",4800.5341705799992,null,977.88892011000041,null,1249.1543895500001,null,4693.3016220900008,null,11720.879102330002]
[null," - repayment loans",1550.2316419699998,null,336.52375910000018,null,614.67751080999994,null,1030.2041184300001,null,3531.6370303100002]
[null," - interest-only ",3250.3025286099992,null,641.36516101000007,null,634.47687874000007,null,3663.0975036600007,null,8189.2420720200007]
[null,"RD EURIBOR3®",38.842964789999996,null,668.19193817999997,null,3756.8256498799992,null,4963.1206385900005,null,9426.9811914399979]
[null," - repayment loans",10.202848620000001,null,49.189921780000006,null,601.88028515000008,null,852.9321769400002,null,1514.2052324900003]
[null," - interest-only ",28.640116169999999,null,619.0020164,null,3154.9453647299993,null,4110.1884616499992,null,7912.7759589499992]
[null,"RD CIBOR6®",108.97748391000003,null,13142.73543789,null,43217.488793929988,null,3915.6994940100012,null,60384.90120973999]
[null," - repayment loans",13.40044851,null,2421.5931557200001,null,12778.18946659999,null,834.5422871100003,null,16047.725357939991]
[null," - interest-only ",95.577035400000014,null,10721.142282169998,null,30439.299327329998,null,3081.1572069000013,null,44337.175851799999]
[null," Total",423016.70300971036,null,142216.08912348995,null,120154.48796003997,null,48855.115319090051,null,734242.3954123304]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",168877.39567406019,null,50875.028171400096,null,46087.980138989929,null,3323.6300573099998,null,269164.0340417602]
[null," - Other Sealand",87763.766253860085,null,17075.192320589991,null,10846.548246760003,null,12830.349434859989,null,128515.85625607008]
[null," - Region South Denmark",70192.606909820039,null,26664.407728539969,null,25266.050507940014,null,16928.669410410006,null,139051.73455671006]
[null," - Region Central Jutland",71943.599812530039,null,33449.656322700052,null,20029.842290380013,null,9310.1220599800017,null,134733.22048559011]
[null," - Region North Jutland",24236.069301620024,null,13300.499698109978,null,6484.9847342300045,null,6462.3443565300004,null,50483.898090490009]
[null," - Other area",3.2650578199999996,null,851.30488214999991,null,11439.082041740001,null,0,null,12293.651981710002]
[null,"Total",423016.70300971041,null,142216.08912349009,null,120154.48796003996,null,48855.115319089993,null,734242.39541233028]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",267433.22768370004,null,10118.174558559971,null,4391.7925380400056,null,3688.5500865600025,null,285631.74486685998]
[null," 2 - 5",136719.17932189009,null,13723.250307449987,null,6915.2828290099833,null,7195.6403186599919,null,164553.35277701003]
[null," 5 - 20",18228.114985569977,null,44619.020394069921,null,21918.072896869999,null,15952.246070579997,null,100717.45434708991]
[null," 20 - 50",582.29983820999996,null,34559.131651489981,null,20131.362298760043,null,15244.452697009998,null,70517.246485470023]
[null," 50 - 100",53.88118034,null,18220.879439259985,null,17030.083173740004,null,5806.6742153900013,null,41111.518008729989]
[null," 100 and above",0,null,20975.63277266001,null,49767.894223619965,null,967.55193088999988,null,71711.078927169961]
[null,"Total",423016.70300971007,null,142216.08912348983,null,120154.48796003999,null,48855.115319089979,null,734242.39541232982]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",31331.766511819991,null,10591.35032,null,15973.78930292001,null,9276.8832039799963,null,67173.789338720002]
[null," 1",73056.601596330001,null,20783.323043569999,null,23591.232789639991,null,4771.0990047099995,null,122202.25643424998]
[null," 2",60782.524886310042,null,14097.773958299995,null,13715.820036819996,null,3607.8738885100011,null,92203.992769940029]
[null," 3",11821.078499640009,null,4946.9332227999994,null,6355.4305052099962,null,1029.1328247400004,null,24152.575052390006]
[null," 4",61449.78170287003,null,8415.8305194700133,null,14294.256152379992,null,4555.0113892399995,null,88714.879763960038]
[null," 6",70573.561276439941,null,12166.076401529992,null,19606.874701270015,null,9867.6428072899962,null,112214.15518652996]
[null," 8",43291.690876999906,null,17248.666919079973,null,16054.218952859994,null,8884.8403195000064,null,85479.417068439885]
[null," 10",52171.523366309972,null,13534.600795219996,null,7329.8020220900016,null,4560.4598228800005,null,77596.386006499975]
[null," 15",16765.810779729985,null,15540.55399467001,null,2812.7233698000045,null,2003.1212026500004,null,37122.209346849995]
[null," 20",1452.8560445000005,null,14017.266310809999,null,286.23624631000001,null,116.68304864999999,null,15873.041650269999]
[null," 25",203.31113006000004,null,10216.172887420002,null,73.334576349999992,null,38.875956020000004,null,10531.694549850003]
[null," 30",116.19633870000001,null,657.54075062000027,null,60.769304390000009,null,143.49185091999999,null,977.99824463000027]
[null,"Total",423016.70300970989,null,142216.08912349,null,120154.48796004,null,48855.115319089993,null,734242.39541232993]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",135877.6929263761,null,52978.207098652667,null,44817.12583979519,null,18260.644371167491,null,251933.67023599139]
[null,"20 - 40%",118449.05914282519,null,35735.798272459564,null,37176.831849112918,null,14962.622686196055,null,206324.31195059375]
[null,"40 - 60%",90919.690843380857,null,25139.749816590906,null,25816.011413524855,null,9636.6764147452395,null,151512.12848824187]
[null,"60 - 80%",54494.520447222138,null,15298.141872424034,null,7780.8890019694763,null,3734.4636855612816,null,81308.015007176917]
[null,"> 80 %",23275.739649305789,null,13064.192063562612,null,4563.6298549676512,null,2260.7081612399538,null,43164.269729076004]
[null,"Total",423016.70300911012,null,142216.0891236898,null,120154.4879593701,null,48855.115318910022,null,734242.39541107998]

{"sheet":"RD 2013 Q4 Cap T","index":1,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2013 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",212945.91361938993,null,51032.380635279995,null,82578.086687460163,null,39057.776741469926,null,385614.15768359997]
[null," - Number of loans",187551,null,14342,null,8646,null,10873,null,221412]
[]
[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®",208042.38627038992,null,39958.798261909971,null,45523.343632839991,null,27949.874724659989,null,321474.40288979985]
[null," - repayment loans",71692.823349399885,null,21838.887003699965,null,24799.234757569986,null,7577.6260926800014,null,125908.57120334984]
[null," - interest-only ",136349.56292099002,null,18119.911258210002,null,20724.108875270005,null,20372.248631979986,null,195565.83168645002]
[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®",4800.5341705800001,null,977.88892011000041,null,1249.1543895499999,null,4693.301622089999,null,11720.87910233]
[null," - repayment loans",1550.2316419700001,null,336.52375910000018,null,614.67751081000006,null,1030.2041184299999,null,3531.6370303099998]
[null," - interest-only ",3250.3025286100001,null,641.36516101000007,null,634.47687873999985,null,3663.0975036599993,null,8189.2420720200007]
[null,"RD EURIBOR3®",19.674490189999997,null,323.77484850999997,null,2915.1816128100004,null,2971.1340001900003,null,6229.7649517]
[null," - repayment loans",4.6758957599999995,null,20.4532442,null,411.06894582000001,null,613.86687193000023,null,1050.06495771]
[null," - interest-only ",14.998594429999999,null,303.32160431,null,2504.1126669900004,null,2357.2671282599999,null,5179.6999939899997]
[null,"RD CIBOR6®",83.318688229999992,null,9771.9186047500061,null,32890.407052259994,null,3443.4663945299985,null,46189.110739769989]
[null," - repayment loans",11.382017809999999,null,2039.7139886500001,null,9878.9321383200004,null,686.13245932999985,null,12616.160604109999]
[null," - interest-only ",71.936670419999984,null,7732.2046161000053,null,23011.47491393999,null,2757.3339351999985,null,33572.950135659994]
[null," Total",212945.91361938993,null,51032.380635279973,null,82578.086687459974,null,39057.776741469977,null,385614.15768359986]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",92658.31034460997,null,17369.291278079989,null,31220.454547089961,null,2830.1526920699994,null,144078.20886184991]
[null," - Other Sealand",41981.804124470007,null,4770.3799352400001,null,6578.4147192599958,null,10267.302984500009,null,63597.901763470007]
[null," - Region South Denmark",31180.817607500005,null,9922.8090437699939,null,17462.996672409998,null,12966.29000744,null,71532.913331119998]
[null," - Region Central Jutland",35860.835517939973,null,13346.263174419997,null,12533.147530469983,null,7555.12497747,null,69295.371200299953]
[null," - Region North Jutland",11264.14602486999,null,5235.3195365200081,null,3689.5410224900024,null,5438.9060799900089,null,25627.912663870011]
[null," - Other area",0,null,388.31766725,null,11093.532195739999,null,0,null,11481.84986299]
[null,"Total",212945.91361938996,null,51032.380635280002,null,82578.086687459945,null,39057.776741470014,null,385614.15768359986]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",117398.7935720801,null,5212.9952968799998,null,2136.3223521399982,null,2015.4369164300008,null,126763.54813753012]
[null," 2 - 5",81967.35315032005,null,5966.9040493700059,null,4105.7822517100039,null,5167.0446429300018,null,97207.084094330072]
[null," 5 - 20",13133.982917370004,null,14217.049532459991,null,13954.325107899987,null,13219.864342329989,null,54525.221900059965]
[null," 20 - 50",445.78397961999997,null,10621.129549889998,null,13077.776465800005,null,12781.772349849989,null,36926.462345159998]
[null," 50 - 100",0,null,7411.4817296499959,null,10735.529588639998,null,5016.6658779799982,null,23163.677196269993]
[null," 100 and above",0,null,7602.8204770300044,null,38568.350921270001,null,856.9926119500002,null,47028.16401025001]
[null,"Total",212945.91361939014,null,51032.380635280002,null,82578.086687459989,null,39057.77674146997,null,385614.15768360015]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",20068.650918139992,null,5349.5544792599976,null,14641.606049160006,null,8832.7666420900041,null,48892.57808865]
[null," 1",29628.743881170016,null,8972.3499340599974,null,17809.660281700002,null,3157.6799198000008,null,59568.434016730011]
[null," 2",30215.962232749996,null,8323.8111297499963,null,11395.645247049999,null,2998.9410338900007,null,52934.359643439988]
[null," 3",5699.7390447100033,null,1630.6492133600002,null,3436.4538775399992,null,825.00658111000041,null,11591.848716720004]
[null," 4",32397.762245680002,null,4716.4053213900042,null,11236.466591999992,null,3760.3782930500006,null,52111.012452120005]
[null," 6",51051.749880669988,null,6086.2884495900071,null,12845.202484439997,null,8032.5920843200083,null,78015.83289902001]
[null," 8",17152.326346609996,null,6480.8385509099999,null,5572.3997347999966,null,6669.875430959999,null,35875.440063279988]
[null," 10",16923.56023033999,null,4110.9351532499986,null,4014.33572594,null,3036.1075589400016,null,28084.938668469989]
[null," 15",9496.3760292200113,null,5257.0493726200048,null,1560.19429928,null,1675.5642858500009,null,17989.183986970016]
[null," 20",311.04281009999994,null,104.49903109000003,null,66.122395549999993,null,68.864911460000002,null,550.52914820000001]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",212945.91361938999,null,51032.380635280009,null,82578.086687460003,null,39057.776741470007,null,385614.15768359997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",65177.039930508887,null,15813.870935931274,null,31605.390500738744,null,13979.104793876513,null,126575.40616105542]
[null,"20 - 40%",58515.334552660934,null,13062.876594670506,null,26638.576277900298,null,12004.623174953484,null,110221.41060018525]
[null,"40 - 60%",47096.234556072523,null,10799.177648648933,null,17421.894144359187,null,8040.7778553010667,null,83358.084204381696]
[null,"60 - 80%",29473.965028823532,null,6777.4943590514467,null,4529.614103197202,null,3120.2564655816564,null,43901.329956653834]
[null,"> 80 %",12683.33955131406,null,4578.96109693789,null,2382.6116608045381,null,1913.0144518072559,null,21557.926760863742]
[null,"Total",212945.91361937998,null,51032.38063524005,null,82578.086686999974,null,39057.776741519971,null,385614.15768313996]

{"sheet":"RD 2013 Q4 Cap S","index":2,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2013 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",153665.00947098003,null,49661.75148171989,null,23433.256720369973,null,7209.5799790999954,null,233969.5976521699]
[null," - Number of loans",144022,null,9379,null,3593,null,2467,null,159461]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",96183.30305216994,null,25925.701992280017,null,9727.201439749997,null,2853.2471658900004,null,134689.45365008994]
[null," - repayment loans",68144.448321559947,null,23991.608369060017,null,8621.652394879995,null,1890.9722008799999,null,102648.68128637996]
[null," - interest-only ",28038.854730609986,null,1934.0936232200008,null,1105.5490448700002,null,962.27496501000064,null,32040.772363709988]
[null,"FlexLån®",51351.461435900026,null,21750.02049209,null,9181.3289655900007,null,2251.77650111,null,84534.587394690025]
[null," - repayment loans",15955.372947529992,null,13797.132329330001,null,3179.4104388099995,null,689.01827133999984,null,33620.933987009994]
[null," - interest-only ",35396.088488370035,null,7952.8881627599994,null,6001.9185267800003,null,1562.7582297700003,null,50913.653407680031]
[null,"FlexGaranti®, Rentedyk TM",6107.5989552100018,null,123.04833293999999,null,56.322096770000002,null,41.047960310000001,null,6328.0173452300014]
[null," - repayment loans",2429.4709177800028,null,74.651975190000016,null,45.71693664,null,20.706218050000004,null,2570.5460476600024]
[null," - interest-only ",3678.1280374299995,null,48.39635775,null,10.605160130000002,null,20.34174226,null,3757.471297569999]
[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,"RD EURIBOR3®",19.168474600000003,null,344.41708966999994,null,841.64403706999997,null,1991.9866384000013,null,3197.2162397400007]
[null," - repayment loans",5.5269528599999997,null,28.736677580000002,null,190.81133932999998,null,239.06530501000003,null,464.14027477999997]
[null," - interest-only ",13.64152174,null,315.68041208999995,null,650.83269773999996,null,1752.9213333900013,null,2733.0759649600009]
[null,"RD CIBOR6®",3.4775531000000002,null,1518.5635747399997,null,3626.760181189999,null,71.521713390000002,null,5220.3230224199988]
[null," - repayment loans",0,null,234.35203009999995,null,1093.4930903699999,null,14.127492530000001,null,1341.9726129999997]
[null," - interest-only ",3.4775531000000002,null,1284.2115446399998,null,2533.2670908199993,null,57.394220859999997,null,3878.3504094199993]
[null," Total",153665.00947097995,null,49661.751481720014,null,23433.256720369998,null,7209.5799791000018,null,233969.59765216996]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",58467.251117090003,null,20286.348707690016,null,8330.6972605299979,null,364.82688948999993,null,87449.123974800037]
[null," - Other Sealand",31459.921021959985,null,6101.6777360100032,null,2684.9066211799995,null,1962.4298774099998,null,42208.935256559984]
[null," - Region South Denmark",27897.76495055003,null,8662.8135510499997,null,5507.995180959997,null,2968.1615565400002,null,45036.735239100031]
[null," - Region Central Jutland",26668.380166440013,null,10391.931875020004,null,4768.302955629998,null,1185.6624291199996,null,43014.277426210021]
[null," - Region North Jutland",9171.6922149399907,null,3967.8600167500003,null,2106.9445405799997,null,728.49922654,null,15974.995998809989]
[null," - Other area",0,null,251.11959519999999,null,34.41016149,null,0,null,285.52975669]
[null,"Total",153665.00947098003,null,49661.751481720014,null,23433.256720369991,null,7209.5799790999999,null,233969.59765217008]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",103226.32768237992,null,2298.4937980899977,null,1025.5110540000001,null,912.13452211000003,null,107462.46705657993]
[null," 2 - 5",45796.934203289966,null,4367.1419061700071,null,1896.5389225899996,null,1349.2212982100007,null,53409.836330259961]
[null," 5 - 20",4510.5590976800004,null,16418.239689630005,null,6110.3206684499946,null,2089.6940827300004,null,29128.813538490002]
[null," 20 - 50",131.18848763,null,12626.017672540011,null,5685.3193805600013,null,2184.5137112899993,null,20627.039252020011]
[null," 50 - 100",0,null,6046.9856324099974,null,3957.4602496200009,null,620.97212194999997,null,10625.418003979999]
[null," 100 and above",0,null,7904.8727828799956,null,4758.1064451500006,null,53.04424281,null,12716.023470839995]
[null,"Total",153665.00947097989,null,49661.751481720006,null,23433.256720369998,null,7209.5799790999999,null,233969.59765216993]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",11262.185278510011,null,5241.7958407400001,null,987.95542210999986,null,444.11656189000013,null,17936.053103250011]
[null," 1",43427.857715160004,null,11810.973109510005,null,5540.3983051500018,null,1613.4190849100003,null,62392.648214730012]
[null," 2",30566.562653559995,null,5773.9628285500003,null,2032.9179190999998,null,608.93285461999983,null,38982.376255829993]
[null," 3",6121.3394549299956,null,3316.2840094400021,null,1644.5893374100003,null,204.12624362999995,null,11286.339045409995]
[null," 4",29052.019457189992,null,3699.4251980800009,null,3057.7895603800021,null,794.63309618999983,null,36603.867311839997]
[null," 6",19466.386502809979,null,6045.4347000199959,null,6133.077484880002,null,1832.0837077600013,null,33476.982395469975]
[null," 8",4903.9396413900004,null,4751.2150272399986,null,2856.2790519299992,null,1222.2592296699997,null,13733.692950229997]
[null," 10",6094.9988989200001,null,5145.7000139700003,null,522.61073496999984,null,273.85574981000008,null,12037.165397669998]
[null," 15",2705.2360343000009,null,3824.5891872399989,null,642.28418603000011,null,205.9724005299999,null,7378.0818080999998]
[null," 20",64.483834210000012,null,52.371566930000007,null,15.35471841,null,10.181050089999999,null,142.39116964000002]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",153665.00947097997,null,49661.751481719999,null,23433.256720370005,null,7209.5799791000018,null,233969.59765217002]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",47380.507466094386,null,20143.725035015563,null,7599.1836245456925,null,2833.114967156208,null,77956.531092811856]
[null,"20 - 40%",43668.632622291399,null,12816.942742463512,null,6929.319951649456,null,2229.7359585434569,null,65644.631274947809]
[null,"40 - 60%",34145.20182835454,null,7940.0505677654965,null,5276.5028760137875,null,1320.5713618905966,null,48682.326634024423]
[null,"60 - 80%",20379.95998765777,null,4649.9631174819015,null,2350.2520208978767,null,520.58498879279898,null,27900.760114830347]
[null,"> 80 %",8090.7075662720181,null,4111.0700191635033,null,1277.9982472431718,null,305.57270243694182,null,13785.348535115634]
[null,"Total",153665.00947067011,null,49661.751481889987,null,23433.256720349982,null,7209.5799788200029,null,233969.59765173006]

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

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

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

{"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 2013 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%",135.87769292637608,null,52.978207098652668,null,44.817125839795189,null,18.260644371167491,null,0.34312057136790841,null,251.93367023599143]
[null," - 20-40%",118.44905914282519,null,35.735798272459562,null,37.176831849112915,null,14.962622686196054,null,0.28100299470596363,null,206.32431195059371]
[null," - 40-60%",90.919690843380863,null,25.139749816590903,null,25.816011413524855,null,9.6366764147452386,null,0.20635164822294808,null,151.51212848824187]
[null," - 60-80%",54.494520447222136,null,15.298141872424035,null,7.7808890019694763,null,3.7344636855612818,null,0.1107372926370658,null,81.30801500717692]
[null," - >80%",23.275739649305791,null,13.064192063562613,null,4.5636298549676511,null,2.260708161239954,null,5.8787493066114305E-2,null,43.164269729076011]
[null,"Total",423.01670300911007,null,142.21608912368978,null,120.15448795937007,null,48.855115318910016,null,1,null,734.24239541108]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",65.177039930508883,null,15.813870935931275,null,31.605390500738743,null,13.979104793876513,null,0.32824366958295836,null,126.57540616105543]
[null," - 20-40%",58.515334552660931,null,13.062876594670506,null,26.638576277900299,null,12.004623174953483,null,0.2858334125033718,null,110.22141060018522]
[null," - 40-60%",47.096234556072524,null,10.799177648648934,null,17.421894144359189,null,8.0407778553010658,null,0.2161696673825893,null,83.358084204381726]
[null," - 60-80%",29.473965028823532,null,6.7774943590514471,null,4.5296141031972015,null,3.1202564655816563,null,0.1138478167410224,null,43.901329956653839]
[null," - >80%",12.683339551314059,null,4.5789610969378902,null,2.3826116608045385,null,1.913014451807256,null,5.590543379005794E-2,null,21.557926760863747]
[null,"Total",212.94591361937992,null,51.032380635240052,null,82.578086686999981,null,39.057776741519973,null,0.99999999999999978,null,385.61415768313992]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",47.380507466094386,null,20.143725035015567,null,7.5991836245456925,null,2.8331149671562081,null,0.33319085845013174,null,77.956531092811844]
[null," - 20-40%",43.668632622291398,null,12.816942742463512,null,6.9293199516494557,null,2.2297359585434569,null,0.28056906509990925,null,65.644631274947812]
[null," - 40-60%",34.145201828354537,null,7.9400505677654971,null,5.2765028760137875,null,1.3205713618905965,null,0.20807116447022042,null,48.682326634024413]
[null," - 60-80%",20.379959987657774,null,4.6499631174819012,null,2.3502520208978765,null,0.52058498879279902,null,0.11924951102562212,null,27.900760114830348]
[null," - >80%",8.0907075662720178,null,4.1110700191635035,null,1.2779982472431719,null,0.30557270243694179,null,5.8919400954116678E-2,null,13.785348535115636]
[null,"Total",153.6650094706701,null,49.661751481889986,null,23.433256720349984,null,7.2095799788200035,null,1.0000000000000002,null,233.96959765173006]

{"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 2013 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%",49.550864358970976,null,182.90551883283584,null,19.477287044185005,null,251.93367023599183]
[null," - 20-40%",33.81660471499152,null,154.62910008206825,null,17.878607153533569,null,206.32431195059334]
[null," - 40-60%",21.170561697717307,null,115.12566425724232,null,15.21590253328211,null,151.51212848824173]
[null," - 60-80%",9.5689031494738526,null,61.712268353248717,null,10.026843504454348,null,81.30801500717692]
[null," - >80%",7.4697907937209731,null,27.013508429603839,null,8.6809705057512137,null,43.164269729076025]
[null,"Total",121.57672471487463,null,541.38605995499893,null,71.279610741206241,null,734.24239541107988]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",17.85858755528869,null,96.269380230245005,null,12.447438375521793,null,126.5754061610555]
[null," - 20-40%",12.819357949176467,null,85.787340824797965,null,11.614711826210769,null,110.22141060018519]
[null," - 40-60%",8.1786863409691062,null,65.020779406552208,null,10.158618456860527,null,83.358084204381839]
[null," - 60-80%",3.3312125443097544,null,33.983293043371681,null,6.5868243689723549,null,43.901329956653797]
[null," - >80%",1.6793341794913621,null,14.721772878514347,null,5.1568197028580434,null,21.557926760863754]
[null,"Total",43.867178569235385,null,295.7825663834812,null,45.96441273042349,null,385.61415768314004]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",15.202359204070955,null,58.296397323224241,null,4.4577745655165888,null,77.956531092811787]
[null," - 20-40%",11.295065938639867,null,50.221619655934127,null,4.1279456803738235,null,65.644631274947812]
[null," - 40-60%",7.0301260559216461,null,38.14841927843748,null,3.5037812996653206,null,48.682326634024449]
[null," - 60-80%",3.3690327406372509,null,22.048898256618365,null,2.4828291175747284,null,27.900760114830344]
[null," - >80%",2.4705368870575466,null,8.9898666865050867,null,2.3249449615530025,null,13.785348535115636]
[null,"Total",39.367120826327273,null,177.7052012007193,null,16.897275624683463,null,233.96959765173003]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":37,"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"]
[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]
[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]
[null,"Agriculture",0.16513532042923695,0.16431853752939363,9.3967375674896297E-2,0.19843422594147503,5.889101487273319E-2,0.10324608128944894,5.1987899564359293E-2,0.11048749938034283,5.9550574556876672E-2,7.4205049225378614E-2,0.13256736027664506,7.2184377008623166E-2,8.9182844607290229E-2,0.10977809013734693,0.20187739094823096,0.24,0.38745729660902001,0.43,0.56000000000000005,0.69,0.64,0.62,0.46,0.57999999999999996,0.73,0.58328999999999998,0.56000000000000005,0.52803846547461519,0.56810281900656956,0.52631260095191801,0.47053383152737932,0.4125704264093748,0.46308121934256113,0.3145449136957576,0.44]
[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]
[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]

{"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",49661751481.719887,49410631886.519897]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",23433256720.369995,23398846558.879997]
["S-Landbrug","S",null,"Landbrug",7209579979.0999985,7209579979.0999985]
["S-Privat","S",null,"Privat",153665009470.97937,153665009470.97937]
["S Total-","S Total","S Total",null,233969597652.16925,233684067895.47928]
["T-Boligudl","T","T","Boligudl",51032380635.279991,50644253851.779984]
["T-Erhverv","T",null,"Erhverv",82578086687.459732,71484554491.720032]
["T-Landbrug","T",null,"Landbrug",39057776741.469925,39057776741.469925]
["T-Privat","T",null,"Privat",212945913619.39005,212945913619.39005]
["T Total-","T Total","T Total",null,385614157683.59973,374132498704.35999]
["Ø-Boligudl","Ø","Ø","Boligudl",41521957006.490059,41324374641.650047]
["Ø-Erhverv","Ø",null,"Erhverv",14143144552.209978,13847343655.20998]
["Ø-Landbrug","Ø",null,"Landbrug",2587758598.519999,2587758598.519999]
["Ø-Privat","Ø",null,"Privat",56405779919.339981,56405779919.339981]
["Ø Total-","Ø Total","Ø Total",null,114658640076.56001,114165256814.72]
["Grand Total-","Grand Total","Grand Total",null,734242395412.32898,721981823414.5592]
[]
[]
[]
[]
[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":212945913619.39005}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":50644253851.779984}]
[null,null,"T-Erhverv","Erhverv","Commercial",71484554491.720032]
[null,null,"T-Landbrug","Landbrug","Agriculture",39057776741.469925]
[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":11481658979.239746}]
[]
[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":153665009470.97937}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":49410631886.519897}]
[null,null,"S-Erhverv","Erhverv","Commercial",23398846558.879997]
[null,null,"S-Landbrug","Landbrug","Agriculture",7209579979.0999985]
[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":285529756.68997192}]
[]
[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":56405779919.339981}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":41324374641.650047}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",13847343655.20998]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2587758598.519999]
[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":493383261.8400116}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":423016703009.70935}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":141379260379.94992}]
[null,null,null,null,"Commercial",108730744705.81001]
[null,null,null,null,"Agriculture",48855115319.08992]
[null,null,null,null,"Nordic",12260571997.76973]