{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2013 Q3 Total","RD 2013 Q3 Cap T","RD 2013 Q3 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 Q3 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2013 Q3 - 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",422233.87845305965,null,141727.97673498993,null,119626.39696824038,null,49518.211910840138,null,733106.46406713]
[null," - Number of loans",430775,null,42569,null,16505,null,16265,null,506114]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",129716.72008752984,null,60562.407950450135,null,12974.056749719977,null,4157.0510648199979,null,207410.23585251995]
[null," - repayment loans",95019.873864679888,null,58202.745363260132,null,11816.053991669974,null,3033.7994191199973,null,168072.47263872999]
[null," - interest-only ",34696.84622284997,null,2359.6625871900005,null,1158.0027580500005,null,1123.2516457000002,null,39337.763213789971]
[null,"FlexLån®",264543.49270113045,null,68355.178852859899,null,67156.624800089892,null,38106.719872430069,null,438162.01622651023]
[null," - repayment loans",87302.017080089849,null,36394.690333459919,null,28667.861018179949,null,9382.2378804000018,null,161746.80631212972]
[null," - interest-only ",177241.47562104059,null,31960.48851939998,null,38488.76378190994,null,28724.481992030072,null,276415.20991438057]
[null,"FlexGaranti®, Rentedyk TM",27827.701811370007,null,968.63978069000007,null,438.79613882000001,null,494.65216099000003,null,29729.789891870005]
[null," - repayment loans",12258.038599649994,null,534.58135285000014,null,312.56763975999991,null,222.38987630999995,null,13327.577468569994]
[null," - interest-only ",15569.663211720013,null,434.05842783999992,null,126.22849906000002,null,272.26228468000005,null,16402.212423300014]
[null,"RD EURIBOR3®",38.905154109999998,null,680.20427901000016,null,2416.0711683399995,null,4162.2277176899997,null,7297.4083191499994]
[null," - repayment loans",10.27028378,null,47.938028139999993,null,405.52206959,null,584.07228766999992,null,1047.8026691799998]
[null," - interest-only ",28.634870330000002,null,632.26625087000014,null,2010.5490987499998,null,3578.1554300199996,null,6249.6056499699989]
[null,"RD CIBOR6®",107.05869891999998,null,11161.545871979994,null,36640.848111269974,null,2597.5610949100005,null,50507.01377707997]
[null," - repayment loans",12.154607179999999,null,1879.6645097199998,null,9832.1255520399991,null,557.19080428999996,null,12281.135473229999]
[null," - interest-only ",94.904091739999998,null,9281.8813622599937,null,26808.722559229973,null,2040.3702906200003,null,38225.878303849968]
[null," Total",422233.87845306029,null,141727.97673499005,null,119626.39696823983,null,49518.211910840066,null,733106.46406713023]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",168090.15727493027,null,50426.965329160063,null,45738.390439990078,null,3335.4205281999998,null,267590.93357228045]
[null," - Other Sealand",87885.577759589869,null,17190.917517869992,null,10898.712781179998,null,13108.161980829991,null,129083.37003946985]
[null," - Region South Denmark",70072.424811219957,null,26206.340361080009,null,25563.479324769974,null,16981.279857399972,null,138823.5243544699]
[null," - Region Central Jutland",71869.462082430167,null,33711.561576619984,null,20195.45140315004,null,9555.5826329899937,null,135332.05769519016]
[null," - Region North Jutland",24312.862486320028,null,13331.670341289997,null,6522.2889293399976,null,6537.7669114199962,null,50704.588668370016]
[null," - Other area",3.3940385700000002,null,860.5216089700001,null,10708.074089810001,null,0,null,11571.989737350003]
[null,"Total",422233.87845306029,null,141727.97673499008,null,119626.39696824009,null,49518.211910839949,null,733106.46406713023]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",268868.26731115056,null,10251.943326150002,null,4495.3006921599972,null,3764.2914814099981,null,287379.80281087052]
[null," 2 - 5",134819.2724684499,null,13906.115558410005,null,7044.9290088399939,null,7296.435165699997,null,163066.75220139991]
[null," 5 - 20",17874.419186789994,null,45173.869155220069,null,22221.614077149985,null,16429.393786239976,null,101699.29620540002]
[null," 20 - 50",618.13823174000015,null,34497.398937889993,null,20316.440617359985,null,15580.390092829995,null,71012.367879819984]
[null," 50 - 100",53.781254930000003,null,18000.174605080014,null,16921.779601950013,null,5458.7849105199975,null,40434.520372480016]
[null," 100 and above",0,null,19898.475152239997,null,48626.332970780008,null,988.91647414000022,null,69513.724597160006]
[null,"Total",422233.8784530604,null,141727.97673499008,null,119626.39696823999,null,49518.211910839957,null,733106.46406713035]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",25107.741760080018,null,7003.6535955400041,null,7451.4071418399926,null,1534.3044097699999,null,41097.106907230009]
[null," 1",75901.256456639981,null,20465.607624489981,null,24264.420914409991,null,4512.7351886000006,null,125144.02018413997]
[null," 2",51881.467557109958,null,13937.669743219998,null,13614.172606460001,null,3497.4786678900005,null,82930.788574679944]
[null," 3",24812.265569289953,null,4737.7143840400022,null,10149.931013669993,null,2050.1210240399996,null,41750.031991039948]
[null," 4",61178.821721899927,null,7352.5111485699945,null,10828.479401320001,null,4307.4144278899994,null,83667.226699679915]
[null," 6",64201.358112619942,null,15833.184447379997,null,27313.282919949994,null,15580.366361709994,null,122928.19184165992]
[null," 8",53999.590979309985,null,18024.436282770013,null,17404.696058679991,null,9848.4471509899995,null,99277.170471749982]
[null," 10",48731.466686980049,null,12762.734961810003,null,4841.92284466,null,5505.0450333499994,null,71841.169526800062]
[null," 15",14600.996652289987,null,15513.63750768,null,3291.810318769999,null,2366.3387924500012,null,35772.78327118999]
[null," 20",1609.80922495,null,15141.808626709993,null,320.79434502999993,null,125.22291544000004,null,17197.635112129992]
[null," 25",75.970306900000011,null,10162.375122910003,null,81.728901950000008,null,39.557679249999993,null,10359.632011010004]
[null," 30",133.13342499000001,null,792.64328987000044,null,63.750501500000006,null,151.18025945999997,null,1140.7074758200004]
[null,"Total",422233.87845305982,null,141727.97673498999,null,119626.39696823998,null,49518.211910839993,null,733106.46406712965]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",133809.84616383107,null,53707.894542160066,null,43904.656224088059,null,18421.929514574051,null,249844.32644465324]
[null,"20 - 40%",116838.80861185999,null,35403.368602250448,null,37125.65129061287,null,15270.300536304685,null,204638.12904102798]
[null,"40 - 60%",90420.847051559729,null,24627.210253758421,null,25919.063959828014,null,9712.9995791838119,null,150680.12084432997]
[null,"60 - 80%",55828.891086651129,null,14641.510412478085,null,7874.9220045775382,null,3787.1504058813093,null,82132.47390958808]
[null,"> 80 %",25335.485538828179,null,13347.992924263011,null,4802.103489273366,null,2325.8318754561305,null,45811.413827820681]
[null,"Total",422233.87845273002,null,141727.97673491004,null,119626.39696837985,null,49518.211911399987,null,733106.46406741999]

{"sheet":"RD 2013 Q3 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 2013 Q3 - 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",208546.38947553982,null,50534.798240659984,null,80156.318482199902,null,39530.017135769966,null,378767.5233341697]
[null," - Number of loans",186150,null,14311,null,8732,null,11401,null,220594]
[]
[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®",208445.09932927007,null,42399.506693320021,null,52375.399896050032,null,35315.974038419969,null,338535.97995706013]
[null," - repayment loans",71410.778685470141,null,21968.816070670026,null,25179.618055110019,null,8640.9231798499986,null,127200.13599110019]
[null," - interest-only ",137034.32064379996,null,20430.690622649992,null,27195.781840940017,null,26675.050858569964,null,211335.84396595994]
[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,"RD EURIBOR3®",19.712283409999998,null,335.85854124000002,null,1569.3829861300001,null,2090.0942782800003,null,4015.0480890600002]
[null," - repayment loans",4.7152739299999995,null,19.187985599999998,null,220.51843717000003,null,345.80693486000001,null,590.22863156000005]
[null," - interest-only ",14.997009479999999,null,316.67055563999998,null,1348.8645489600001,null,1744.2873434200003,null,3424.8194575000002]
[null,"RD CIBOR6®",81.577862859999996,null,7799.4330060999946,null,26211.535600020012,null,2123.9488190699999,null,36216.495288050006]
[null," - repayment loans",10.144453379999998,null,1496.6982248899999,null,6915.166888050001,null,407.13059443999981,null,8829.1401607600019]
[null," - interest-only ",71.433409480000009,null,6302.7347812099943,null,19296.368711970008,null,1716.81822463,null,27387.355127290004]
[null," Total",208546.38947554011,null,50534.798240660013,null,80156.318482200048,null,39530.017135769966,null,378767.52333417011]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",90319.183055549962,null,16993.912516780012,null,29538.307564429986,null,2836.9357263300017,null,139688.33886308997]
[null," - Other Sealand",41262.141789490001,null,4825.5456405100012,null,6561.469391949996,null,10398.503239380001,null,63047.660061330003]
[null," - Region South Denmark",30640.437931690005,null,9593.0782980999902,null,17540.472472570014,null,13102.066504980008,null,70876.055207340018]
[null," - Region Central Jutland",35222.622598649985,null,13385.184875939982,null,12500.200882720002,null,7738.8307634200064,null,68846.839120729986]
[null," - Region North Jutland",11102.004100160009,null,5337.9146113499974,null,3652.0781354399974,null,5453.6809016599973,null,25545.67774861]
[null," - Other area",0,null,399.16229797999995,null,10363.790035089998,null,0,null,10762.952333069998]
[null,"Total",208546.38947553994,null,50534.798240659991,null,80156.318482200004,null,39530.017135770009,null,378767.52333416999]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",116091.39368488999,null,5177.5647758899977,null,2195.6943454799989,null,2055.4425175400006,null,125520.09532379998]
[null," 2 - 5",79317.818777619992,null,5982.7067812599989,null,4140.2794173900002,null,5210.8426859399942,null,94651.647662209973]
[null," 5 - 20",12692.858851919998,null,14046.012336829997,null,13954.169649910003,null,13654.792632460014,null,54347.833471120015]
[null," 20 - 50",444.31816110999989,null,10465.159473369986,null,12954.954478890009,null,12929.05050495001,null,36793.482618320006]
[null," 50 - 100",0,null,7081.4665805699997,null,10334.2770287,null,4801.9343968499979,null,22217.678006120001]
[null," 100 and above",0,null,7781.8882927399973,null,36576.943561829983,null,877.95439802999999,null,45236.786252599981]
[null,"Total",208546.38947553997,null,50534.798240659984,null,80156.318482200004,null,39530.017135770016,null,378767.52333416993]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",11461.084623179999,null,2507.4318436400004,null,5391.9750904700022,null,938.76604245999977,null,20299.257599749999]
[null," 1",30963.246721109997,null,9171.8108408400076,null,18921.533279950003,null,3179.4501926700009,null,62236.041034570007]
[null," 2",26660.801165329998,null,7740.6988235300005,null,9672.7680276400006,null,2986.2148125999993,null,47060.482829100001]
[null," 3",10637.79355627,null,1791.0445992800005,null,7553.3882990899992,null,1507.4414551599998,null,21489.667909799999]
[null," 4",37469.344864830004,null,4859.3319250499999,null,9303.7719375800007,null,3823.2718455099994,null,55455.720572970007]
[null," 6",45214.884676299982,null,6848.5035894600069,null,15882.257571410006,null,12439.014754600003,null,80384.660591769993]
[null," 8",19104.911787329984,null,8625.5030077199972,null,8975.0950591100009,null,8594.9787133999998,null,45300.48856755998]
[null," 10",19289.853631840004,null,3718.4109660599997,null,2387.8039183600013,null,3979.3910579099988,null,29375.459574170007]
[null," 15",7417.4397221700019,null,5173.1226090399923,null,1985.51218868,null,2008.5732106299999,null,16584.647730519995]
[null," 20",327.02872717999998,null,98.940036040000038,null,82.213109910000014,null,72.915050830000013,null,581.09692396000003]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",208546.38947553997,null,50534.798240660006,null,80156.318482200004,null,39530.017135769995,null,378767.52333416999]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",62959.594165357732,null,16175.647181715662,null,29836.120362094687,null,14169.056124461482,null,123140.41783362956]
[null,"20 - 40%",56588.317832234796,null,13183.027868882216,null,26047.496291961452,null,12273.633450958612,null,108092.47544403707]
[null,"40 - 60%",45918.957656935709,null,10581.066717275409,null,17332.445985963226,null,8036.8193708349927,null,81869.289731009339]
[null,"60 - 80%",29602.99966648571,null,6172.14058086155,null,4432.7264245919841,null,3101.0389431414073,null,43308.90561508065]
[null,"> 80 %",13476.520154606062,null,4422.9158921551934,null,2507.5294176986586,null,1949.4692469435238,null,22356.434711403439]
[null,"Total",208546.38947562,null,50534.798240890028,null,80156.318482310002,null,39530.01713634003,null,378767.52333516005]

{"sheet":"RD 2013 Q3 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 2013 Q3 - 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",153829.98930348034,null,47468.281052910083,null,24716.71233971999,null,7205.7878652000018,null,233220.77056131046]
[null," - Number of loans",144049,null,9297,null,3635,null,2477,null,159458]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",92742.055516510052,null,22876.769635670029,null,9513.5001231100014,null,2563.375583340001,null,127695.70085863008]
[null," - repayment loans",65676.305570720069,null,21027.252058600028,null,8451.8468909700005,null,1687.3136423300009,null,96842.718162620105]
[null," - interest-only ",27065.749945789983,null,1849.5175770699996,null,1061.6532321399998,null,876.06194101000028,null,30852.982696009978]
[null,"FlexLån®",54903.383232540007,null,22600.583894120002,null,10626.230619760003,null,2457.6137899400005,null,90587.811536360023]
[null," - repayment loans",15694.697385500003,null,13955.828324379996,null,3330.2416721299996,null,678.41563005999944,null,33659.183012070003]
[null," - interest-only ",39208.685847040011,null,8644.7555697400076,null,7295.9889476300032,null,1779.198159880001,null,56928.628524290027]
[null,"FlexGaranti®, Rentedyk TM",6161.8879012000007,null,122.99024005999999,null,56.695978709999999,null,41.14945711,null,6382.7235770800007]
[null," - repayment loans",2454.3618233800003,null,74.801204979999994,null,46.104727889999999,null,20.808171859999998,null,2596.0759281099995]
[null," - interest-only ",3707.5260778200018,null,48.189035079999996,null,10.591250820000001,null,20.341285249999999,null,3786.6476489700012]
[null,"RD EURIBOR3®",19.1928707,null,344.34573776999997,null,846.68818221000004,null,2072.1334394100004,null,3282.3602300900006]
[null," - repayment loans",5.5550098499999994,null,28.750042539999999,null,185.00363241999997,null,238.26535281,null,457.57403762000001]
[null," - interest-only ",13.637860849999999,null,315.59569522999993,null,661.68454979000012,null,1833.8680866000007,null,2824.786192470001]
[null,"RD CIBOR6®",3.4697825300000003,null,1523.5915452899997,null,3673.5974359299998,null,71.515595399999995,null,5272.1743591499999]
[null," - repayment loans",0,null,235.48172994999999,null,1106.3942185000001,null,14.249621560000001,null,1356.12557001]
[null," - interest-only ",3.4697825300000003,null,1288.1098153399996,null,2567.2032174299998,null,57.265973839999987,null,3916.0487891399994]
[null," Total",153829.98930348008,null,47468.281052910017,null,24716.712339720005,null,7205.7878652000027,null,233220.77056131011]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",58817.717901980046,null,19464.774699130001,null,9384.4180330700001,null,363.82479767000012,null,88030.735431850058]
[null," - Other Sealand",31443.301975069993,null,5813.7448038600032,null,2712.5181019499987,null,2033.1978604299995,null,42002.762741309991]
[null," - Region South Denmark",27719.99198359,null,8108.6526833699963,null,5634.2056071600018,null,2832.0071538700008,null,44294.857427990006]
[null," - Region Central Jutland",26676.604423339995,null,10115.00084115,null,4818.1652204899992,null,1205.2976517300008,null,42815.068136709997]
[null," - Region North Jutland",9172.3730195000044,null,3715.5495553800001,null,2133.0721048500018,null,771.46040149999942,null,15792.455081230008]
[null," - Other area",0,null,250.55847002000002,null,34.333272200000003,null,0,null,284.89174222000003]
[null,"Total",153829.98930348005,null,47468.281052909995,null,24716.712339720001,null,7205.7878652000009,null,233220.77056131003]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",103174.09671504996,null,2300.5658941400002,null,999.06141927999977,null,908.87587291,null,107382.59990137996]
[null," 2 - 5",45941.190539990064,null,4328.1827047200004,null,1920.9234804800001,null,1359.0340570500005,null,53549.330782240075]
[null," 5 - 20",4546.2300177699954,null,16499.796879559985,null,6225.7271260800017,null,2099.6254596299996,null,29371.379483039986]
[null," 20 - 50",168.47203067000001,null,12274.44452757,null,5810.0888294899996,null,2274.8678706699998,null,20527.873258399999]
[null," 50 - 100",0,null,5644.8297995299972,null,4189.8149629399995,null,510.04663111000008,null,10344.691393579998]
[null," 100 and above",0,null,6420.4612473899988,null,5571.0965214500011,null,53.337973829999996,null,12044.89574267]
[null,"Total",153829.98930348005,null,47468.281052909988,null,24716.712339720001,null,7205.7878651999999,null,233220.77056131]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",13646.657136900001,null,4496.2217519000005,null,1531.92463578,null,595.53836731000001,null,20270.341891890002]
[null," 1",44938.00973552998,null,11293.796783650007,null,5203.0418253999987,null,1333.2849959300004,null,62768.133340509994]
[null," 2",25220.666391779981,null,6196.9709196900021,null,2528.2708354700003,null,511.26385528999998,null,34457.172002229978]
[null," 3",14174.472013020002,null,2946.6697847600008,null,2596.542714579999,null,542.67956888000003,null,20260.364081240001]
[null," 4",23709.173308629986,null,2493.1792235200001,null,1524.7074637400001,null,484.14258237999991,null,28211.202578269989]
[null," 6",17490.61747441001,null,7110.1026123800002,null,7727.6076854499979,null,2856.3258098500014,null,35184.65358209001]
[null," 8",5493.3652724899994,null,3921.3081231599972,null,2491.0127479899998,null,314.0769542700001,null,12219.763097909998]
[null," 10",6608.8012105699981,null,5304.6395986800007,null,458.81005226000013,null,324.95037044999998,null,12697.20123196]
[null," 15",2469.9722499500003,null,3648.8158492500011,null,637.16011079999998,null,232.94967393000007,null,6988.8978839300016]
[null," 20",78.254510199999984,null,56.576405919999992,null,17.634268250000002,null,10.57568691,null,163.04087127999998]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",153829.98930347999,null,47468.28105291001,null,24716.712339719994,null,7205.7878652000018,null,233220.77056130997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",46553.704954212517,null,19386.308035548296,null,8174.6332972153587,null,2711.2581774442483,null,76825.904464420411]
[null,"20 - 40%",43088.590643342352,null,12040.373492170749,null,7273.4032695409014,null,2192.2902344181157,null,64594.65763947212]
[null,"40 - 60%",34080.607293928362,null,7423.8619465385145,null,5479.0357028680801,null,1360.0909099832588,null,48343.59585331822]
[null,"60 - 80%",21111.867893974071,null,4321.8217675117758,null,2385.8313100701166,null,593.70158838298914,null,28413.222559938953]
[null,"> 80 %",8995.2185180527413,null,4295.9158108306456,null,1403.8087600755528,null,348.44695497138724,null,15043.390043930329]
[null,"Total",153829.98930351005,null,47468.281052599974,null,24716.712339770012,null,7205.787865199999,null,233220.77056108005]

{"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*",128,126]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q3 2013"]

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

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

{"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 Q3"]
[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%",133.80984616383108,null,53.707894542160062,null,43.904656224088058,null,18.42192951457405,null,0.34080224181692165,null,249.84432644465326]
[null," - 20-40%",116.83880861185999,null,35.403368602250453,null,37.125651290612872,null,15.270300536304685,null,0.27913835039136753,null,204.63812904102798]
[null," - 40-60%",90.420847051559718,null,24.627210253758424,null,25.919063959828016,null,9.712999579183812,null,0.20553647830129171,null,150.68012084432996]
[null," - 60-80%",55.828891086651133,null,14.641510412478086,null,7.8749220045775381,null,3.7871504058813095,null,0.11203348754272445,null,82.132473909588072]
[null," - >80%",25.335485538828177,null,13.347992924263012,null,4.8021034892733656,null,2.3258318754561307,null,6.2489441947694582E-2,null,45.811413827820687]
[null,"Total",422.23387845273004,null,141.72797673491004,null,119.62639696837984,null,49.518211911399987,null,1,null,733.10646406742001]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",62.959594165357736,null,16.175647181715661,null,29.83612036209469,null,14.169056124461481,null,0.32510817387230506,null,123.14041783362956]
[null," - 20-40%",56.588317832234793,null,13.183027868882215,null,26.047496291961451,null,12.273633450958613,null,0.28537947100704647,null,108.09247544403708]
[null," - 40-60%",45.91895765693571,null,10.58106671727541,null,17.332445985963226,null,8.0368193708349924,null,0.21614654025806129,null,81.869289731009331]
[null," - 60-80%",29.602999666485712,null,6.1721405808615506,null,4.4327264245919835,null,3.1010389431414076,null,0.11434165536087396,null,43.308905615080647]
[null," - >80%",13.476520154606062,null,4.422915892155193,null,2.5075294176986587,null,1.949469246943524,null,5.9024159501713407E-2,null,22.356434711403438]
[null,"Total",208.54638947562,null,50.534798240890034,null,80.156318482310013,null,39.530017136340021,null,1.0000000000000002,null,378.76752333516009]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",46.55370495421252,null,19.386308035548293,null,8.1746332972153581,null,2.7112581774442481,null,0.32941278891924369,null,76.825904464420432]
[null," - 20-40%",43.088590643342357,null,12.040373492170749,null,7.2734032695409008,null,2.1922902344181154,null,0.2769678596124649,null,64.594657639472118]
[null," - 40-60%",34.08060729392836,null,7.4238619465385138,null,5.4790357028680798,null,1.3600909099832588,null,0.20728683700432726,null,48.343595853318213]
[null," - 60-80%",21.111867893974072,null,4.3218217675117749,null,2.3858313100701167,null,0.59370158838298914,null,0.12182972593557048,null,28.413222559938951]
[null," - >80%",8.9952185180527415,null,4.2959158108306452,null,1.4038087600755527,null,0.34844695497138728,null,6.4502788528393487E-2,null,15.043390043930327]
[null,"Total",153.82998930351008,null,47.46828105259997,null,24.716712339770009,null,7.2057878651999987,null,0.99999999999999989,null,233.22077056108006]

{"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 Q3"]
[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%",48.313951476480888,null,181.57883199237855,null,19.951542975794016,null,249.84432644465346]
[null," - 20-40%",32.912268601446222,null,153.33315124177906,null,18.392709197802901,null,204.63812904102818]
[null," - 40-60%",20.70006960115829,null,114.28754668291691,null,15.692504560254628,null,150.68012084432985]
[null," - 60-80%",9.7265671084767202,null,62.076535427918579,null,10.329371373192551,null,82.132473909587844]
[null," - >80%",7.889326559263055,null,28.850047762578125,null,9.0720395059793777,null,45.811413827820559]
[null,"Total",119.54218334682517,null,540.1261131075712,null,73.438167613023467,null,733.10646406741978]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",16.185265806354913,null,94.101658237864839,null,12.853493789409724,null,123.14041783362947]
[null," - 20-40%",11.851966678074604,null,84.179369864932369,null,12.061138901030255,null,108.09247544403723]
[null," - 40-60%",7.7112224942140113,null,63.752123509628028,null,10.405943727167287,null,81.869289731009317]
[null," - 60-80%",3.2357903785715534,null,33.343280796498348,null,6.7298344400107135,null,43.308905615080612]
[null," - >80%",1.679884122027514,null,15.261598301542808,null,5.4149522878331506,null,22.356434711403473]
[null,"Total",40.664129479242597,null,290.63803071046641,null,47.465363145451136,null,378.76752333516015]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",14.878968084772371,null,57.510171333195196,null,4.4367650464528818,null,76.825904464420447]
[null," - 20-40%",11.000065640220225,null,49.463243593151311,null,4.1313484061004564,null,64.59465763947199]
[null," - 40-60%",6.8212968682442119,null,37.868699243182618,null,3.6535997418913353,null,48.343595853318163]
[null," - 60-80%",3.3863923155671092,null,22.447758283737347,null,2.5790719606345607,null,28.413222559939019]
[null," - >80%",2.7864367654372661,null,9.8540937566703235,null,2.402859521822708,null,15.043390043930298]
[null,"Total",38.87315967424118,null,177.14396620993679,null,17.203644676901941,null,233.22077056107992]

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

{"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",47468281052.91008,47217722582.890083]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",24716712339.719997,24682379067.519997]
["S-Landbrug","S",null,"Landbrug",7205787865.199995,7205787865.199995]
["S-Privat","S",null,"Privat",153829989303.48083,153829989303.48083]
["S Total-","S Total","S Total",null,233220770561.31091,232935878819.09091]
["T-Boligudl","T","T","Boligudl",50534798240.659981,50135874050.759987]
["T-Erhverv","T",null,"Erhverv",80156318482.200012,69792528447.110184]
["T-Landbrug","T",null,"Landbrug",39530017135.770065,39530017135.770065]
["T-Privat","T",null,"Privat",208546389475.5405,208546389475.5405]
["T Total-","T Total","T Total",null,378767523334.17053,368004809109.18079]
["Ø-Boligudl","Ø","Ø","Boligudl",43724897441.420013,43528901709.899994]
["Ø-Erhverv","Ø",null,"Erhverv",14753366146.319988,14459319120.709988]
["Ø-Landbrug","Ø",null,"Landbrug",2782406909.8700004,2782406909.8700004]
["Ø-Privat","Ø",null,"Privat",59857499674.040115,59857499674.040115]
["Ø Total-","Ø Total","Ø Total",null,121118170171.65012,120628127414.52011]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,733106464067.13159,721568815342.79175]
[]
[]
[]
[]
[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":208546389475.5405}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":50135874050.759987}]
[null,null,"T-Erhverv","Erhverv","Commercial",69792528447.110184]
[null,null,"T-Landbrug","Landbrug","Agriculture",39530017135.770065]
[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":10762714224.989807}]
[]
[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":153829989303.48083}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":47217722582.890083}]
[null,null,"S-Erhverv","Erhverv","Commercial",24682379067.519997]
[null,null,"S-Landbrug","Landbrug","Agriculture",7205787865.199995]
[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":284891742.22003174}]
[]
[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":59857499674.040115}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":43528901709.899994}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",14459319120.709988]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2782406909.8700004]
[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":490042757.13002014}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":422233878453.06146}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":140882498343.55005}]
[null,null,null,null,"Commercial",108934226635.34018]
[null,null,null,null,"Agriculture",49518211910.840065]
[null,null,null,null,"Nordic",11537648724.339859]