{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2013 Q1 Total","RD 2013 Q1 Cap T","RD 2013 Q1 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 Q1 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 Q1 - Total portfolio"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",426642.84523826931,null,143806.68667418946,null,116770.8751253198,null,49891.858312050033,null,737112.26534982864]
[null," - Number of loans",435011,null,43063,null,16691,null,16366,null,511131]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",133429.28004646991,null,62746.415474469897,null,13316.370279859977,null,4172.9319426100037,null,213664.9977434098]
[null," - repayment loans",97849.94946121992,null,60185.977050999893,null,12086.893535699977,null,3144.6581744300038,null,173267.4782223498]
[null," - interest-only ",35579.330585249976,null,2560.4384234700028,null,1229.4767441600002,null,1028.2737681800004,null,40397.519521059985]
[null,"FlexLån®",263954.84626032936,null,68175.810909019914,null,65042.754691770017,null,38377.91173814996,null,435551.32359926921]
[null," - repayment loans",86370.852660989854,null,35815.712618839956,null,26126.954321650064,null,9487.942846440008,null,157801.46244791985]
[null," - interest-only ",177583.99359933948,null,32360.098290179962,null,38915.800370119956,null,28889.968891709952,null,277749.86115134938]
[null,"FlexGaranti®, Rentedyk TM",29113.038714269987,null,1051.6694584200002,null,453.27025925000009,null,516.4737579099999,null,31134.452189849992]
[null," - repayment loans",12896.350253490002,null,585.64182234000032,null,327.00840989000011,null,235.52542702999995,null,14044.525912750003]
[null," - interest-only ",16216.688460779988,null,466.02763607999987,null,126.26184936000003,null,280.94833088000001,null,17089.926277099989]
[null,"RD EURIBOR3®",39.07346278,null,687.90207247000001,null,2450.3692730099992,null,4187.529647280001,null,7364.8744555399999]
[null," - repayment loans",10.4147087,null,38.174273699999986,null,392.04082879000003,null,601.76341650999996,null,1042.3932277000001]
[null," - interest-only ",28.658754080000001,null,649.72779877000005,null,2058.3284442199993,null,3585.7662307700007,null,6322.4812278400004]
[null,"RD CIBOR6®",106.60675442,null,11144.888759810005,null,35508.110621429994,null,2637.0112260999995,null,49396.617361759992]
[null," - repayment loans",16.788246970000003,null,1903.1936860299998,null,9092.7909380900037,null,581.16736887000013,null,11593.940239960004]
[null," - interest-only ",89.818507449999998,null,9241.6950737800053,null,26415.319683339985,null,2055.8438572299997,null,37802.677121799985]
[null," Total",426642.84523826925,null,143806.68667418981,null,116770.87512531999,null,49891.858312049975,null,737112.26534982887]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",168901.8402934199,null,51132.299353019909,null,45082.115745120092,null,3358.4792812100018,null,268474.7346727699]
[null," - Other Sealand",89441.150839229784,null,17545.546398200029,null,11065.263746030005,null,13111.980026289995,null,131163.9410097498]
[null," - Region South Denmark",70968.917838190158,null,26468.636673310015,null,25623.651495249989,null,17154.998022719985,null,140216.20402947016]
[null," - Region Central Jutland",72598.128270119996,null,34477.014181799997,null,20228.884119909995,null,9626.6824150199973,null,136930.70898684999]
[null," - Region North Jutland",24729.108633229993,null,13655.190361360015,null,6612.9000428299951,null,6639.7185668100046,null,51636.91760423001]
[null," - Other area",3.6993640799999996,null,527.99970649999989,null,8158.0599761800013,null,0,null,8689.7590467600021]
[null,"Total",426642.84523826983,null,143806.68667418996,null,116770.8751253201,null,49891.858312049982,null,737112.2653498298]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",270406.78647395986,null,10250.213241109985,null,4582.0582733400106,null,3758.2645309200093,null,288997.32251932984]
[null," 2 - 5",137207.90945962022,null,14076.571099060016,null,7034.9871752700001,null,7287.0099144799951,null,165606.47764843021]
[null," 5 - 20",18398.38188311,null,45368.340207949943,null,22383.222714739994,null,16628.179482160009,null,102778.12428795994]
[null," 20 - 50",574.78846310999984,null,35575.560126759949,null,20484.283284709982,null,15662.903134470002,null,72297.535009049927]
[null," 50 - 100",54.978958470000002,null,18293.178915039989,null,16335.713330019995,null,5458.8263938299997,null,40142.697597359984]
[null," 100 and above",0,null,20242.823084270003,null,45950.610347239992,null,1096.6748561900001,null,67290.108287700001]
[null,"Total",426642.84523827001,null,143806.68667418987,null,116770.87512531996,null,49891.858312050019,null,737112.2653498298]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",42189.949724000071,null,13439.60821979,null,18293.738101749979,null,2828.4530161600001,null,76751.749061700059]
[null," 1",80270.366122409978,null,17058.265792409991,null,14552.49098110999,null,4545.5441348800005,null,116426.66703080994]
[null," 2",39977.665892459983,null,11399.564242569997,null,17159.166874310009,null,3209.6558685299997,null,71746.052877869995]
[null," 3",33460.125798080029,null,4140.1788452899991,null,6074.3948829799901,null,2526.5374947800019,null,46201.237021130022]
[null," 4",61909.408291910033,null,6829.0058732100024,null,9973.9173078999956,null,4627.9114669499986,null,83340.242939970034]
[null," 6",46008.159178980059,null,16016.789205310008,null,26890.322568660016,null,16032.549272889995,null,104947.82022584007]
[null," 8",74685.84124842973,null,20635.996223480048,null,16624.661416159997,null,9531.810723229999,null,121478.30961129979]
[null," 10",34122.211930280027,null,11023.101550039995,null,3761.7888626400004,null,4235.4783289600036,null,53142.580671920026]
[null," 15",12322.160872120005,null,16066.344265589993,null,2977.7374929599996,null,2038.2400837800005,null,33404.482714449994]
[null," 20",1506.5000180900006,null,16019.977270740008,null,297.65023709000002,null,115.2936492,null,17939.421175120009]
[null," 25",38.947527750000006,null,9972.8739048799926,null,102.70870577999999,null,54.836087020000008,null,10169.366225429994]
[null," 30",151.50863375999992,null,1204.98128088,null,62.297693980000005,null,145.54818567000004,null,1564.33579429]
[null,"Total",426642.84523826995,null,143806.68667419007,null,116770.87512531996,null,49891.858312049997,null,737112.26534982992]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",133512.83168019934,null,52677.33309789731,null,40316.066421929245,null,18039.699959274138,null,244545.93115930006]
[null,"20 - 40%",116445.18823038855,null,35317.589667715256,null,34533.628329619205,null,15423.692005894683,null,201720.09823361767]
[null,"40 - 60%",90589.251967682168,null,24590.293787642262,null,24829.266137704391,null,10200.846998130957,null,150209.65889115978]
[null,"60 - 80%",57883.892305586523,null,15493.685699540103,null,9115.145629592871,null,4007.3558118865367,null,86500.079446606032]
[null,"> 80 %",28211.681055034282,null,15727.784420824744,null,7976.7686059843809,null,2220.2635365837032,null,54136.497618427107]
[null,"Total",426642.84523889091,null,143806.68667361967,null,116770.87512483008,null,49891.858311770018,null,737112.2653491107]

{"sheet":"RD 2013 Q1 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 Q1 - Capital center T"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",194647.44740664013,null,48688.838207899964,null,76122.121240909997,null,39374.650467730004,null,358833.05732318008]
[null," - Number of loans",173398,null,13728,null,8501,null,11220,null,206847]
[]
[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®",194547.97442407004,null,40628.226397770064,null,49212.399170030018,null,35126.276428109995,null,319514.87641998008]
[null," - repayment loans",66629.873926830027,null,20956.196404080016,null,22227.723521880001,null,8630.2400857600096,null,118444.03393855007]
[null," - interest-only ",127918.10049724001,null,19672.029993690048,null,26984.675648150012,null,26496.036342349984,null,201070.84248143007]
[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.851937800000002,null,317.27314141000005,null,1579.6761505299999,null,2086.9776906299994,null,4003.7789203699999]
[null," - repayment loans",4.8095508100000002,null,9.4275127900000015,null,226.73024698999998,null,359.17166467000004,null,600.13897525999994]
[null," - interest-only ",15.042386990000001,null,307.84562862000001,null,1352.94590354,null,1727.8060259599995,null,3403.6399451099996]
[null,"RD CIBOR6®",79.621044770000012,null,7743.33866872,null,25330.04592035,null,2161.3963489900002,null,35314.401982829993]
[null," - repayment loans",13.164335420000002,null,1551.8741761399997,null,6377.5324070900015,null,427.67341641000013,null,8370.2443350600006]
[null," - interest-only ",66.456709350000011,null,6191.4644925800012,null,18952.513513259997,null,1733.7229325799999,null,26944.157647769996]
[null," Total",194647.44740664004,null,48688.838207900073,null,76122.121240910012,null,39374.650467729996,null,358833.05732318014]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",83869.603570540014,null,16483.744936319981,null,28604.793554260013,null,2792.3225039700014,null,131750.46456508999]
[null," - Other Sealand",38635.028540419997,null,4639.8734643100024,null,6493.1847144200001,null,10241.221457689995,null,60009.308176839993]
[null," - Region South Denmark",28554.731991109991,null,9261.7047922299989,null,17128.135206000003,null,13169.304869230005,null,68113.876858570002]
[null," - Region Central Jutland",33075.837639240017,null,12863.907660600005,null,12493.815408039996,null,7700.0886068400041,null,66133.649314720024]
[null," - Region North Jutland",10512.24566533,null,5373.3200645199959,null,3589.1731678099982,null,5471.7130300000026,null,24946.451927659997]
[null," - Other area",0,null,66.287289920000006,null,7813.0191903800014,null,0,null,7879.3064803000016]
[null,"Total",194647.44740664001,null,48688.838207899986,null,76122.121240910012,null,39374.650467730004,null,358833.05732317996]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",107107.41010468001,null,4952.3600432800013,null,2116.8744678100011,null,1965.1654874700007,null,116141.81010324]
[null," 2 - 5",74912.996587579866,null,5820.0101994499992,null,3976.6551890499991,null,5105.3487036899987,null,89815.010679769868]
[null," 5 - 20",12312.62138115,null,13480.532365590003,null,13705.748497010001,null,13663.335629799991,null,53162.237873549988]
[null," 20 - 50",314.41933323000006,null,10004.112080989999,null,12788.515221029991,null,12966.067794319995,null,36073.114429569985]
[null," 50 - 100",0,null,6831.0057077100018,null,9791.7168476499937,null,4709.8167758,null,21332.539331159995]
[null," 100 and above",0,null,7600.8178108800021,null,33742.611018360003,null,964.91607665000015,null,42308.344905890008]
[null,"Total",194647.4474066399,null,48688.8382079,null,76122.121240909983,null,39374.650467729989,null,358833.05732317985]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",17860.89364450999,null,5708.1612403600047,null,15072.778976759993,null,2000.1869232800009,null,40642.02078490999]
[null," 1",35762.93987687998,null,9323.9639072399987,null,10661.834418019998,null,3405.8837551499996,null,59154.621957289979]
[null," 2",12728.018374080002,null,4093.5638497900009,null,11072.2224778,null,2263.8425320799997,null,30157.647233750005]
[null," 3",10736.984824129999,null,2340.9754691299991,null,4719.1700380799994,null,2079.7727274800009,null,19876.903058819997]
[null," 4",44422.734120709989,null,4305.7069753199985,null,8662.5255284500035,null,4234.2634094599998,null,61625.230033939995]
[null," 6",28633.755924899997,null,5809.8103454500015,null,13581.39794420999,null,12684.121891640007,null,60709.086106199997]
[null," 8",19924.190643590009,null,8765.76834375,null,8410.5981741300038,null,7435.1083972400065,null,44535.665558710018]
[null," 10",18322.789509650003,null,4491.832425120002,null,2082.8303514300005,null,3512.2447973699996,null,28409.697083570005]
[null," 15",5999.6527553099995,null,3759.6034505000021,null,1782.1583977400003,null,1688.2712864599998,null,13229.68589001]
[null," 20",255.48773287999998,null,89.452201240000022,null,76.604934290000003,null,70.954747569999995,null,492.49961598000004]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",194647.44740663996,null,48688.838207900008,null,76122.121240909983,null,39374.650467730011,null,358833.05732317996]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",58209.557077988145,null,15189.497626300908,null,26344.114001774531,null,13709.530650125469,null,113452.69935618906]
[null,"20 - 40%",52283.642251605248,null,12325.059368359409,null,23483.585135531994,null,12239.560677160071,null,100331.84743265672]
[null,"40 - 60%",42481.652579214577,null,9846.8983689405668,null,16702.918222172724,null,8369.7708072877103,null,77401.23997761558]
[null,"60 - 80%",28091.685206969087,null,6186.0382277834751,null,5311.0889993473093,null,3263.2703785384583,null,42852.08281263832]
[null,"> 80 %",13580.910290882844,null,5141.3446163656199,null,4280.4148816933885,null,1792.5179547282746,null,24795.187743670129]
[null,"Total",194647.44740665989,null,48688.838207749985,null,76122.121240519948,null,39374.65046783998,null,358833.05732276978]

{"sheet":"RD 2013 Q1 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 Q1 - Capital center S"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",162726.44283951013,null,46497.766244659986,null,25280.608298060015,null,7398.8884683399992,null,241903.70585057014]
[null," - Number of loans",147904,null,9047,null,3629,null,2508,null,163088]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",88279.386269439987,null,20413.121793930011,null,9029.489354329995,null,2277.5942038000012,null,119999.5916215]
[null," - repayment loans",62282.009136560024,null,18549.601060320012,null,7943.7208473399951,null,1540.7468187700013,null,90316.077862990031]
[null," - interest-only ",25997.37713287997,null,1863.5207336100007,null,1085.7685069899999,null,736.84738502999994,null,29683.513758509973]
[null,"FlexLån®",68137.656217289987,null,24028.375839900018,null,11610.734335130001,null,2907.1443830600006,null,106683.91077538001]
[null," - repayment loans",19535.152398540002,null,14378.637467960021,null,3738.3338746599975,null,790.62825126000007,null,38442.751992420024]
[null," - interest-only ",48602.503818749981,null,9649.7383719399968,null,7872.400460470004,null,2116.5161318000005,null,68241.158782959988]
[null,"FlexGaranti®, Rentedyk TM",6285.0937110199975,null,123.45563940000001,null,57.751753990000005,null,41.655266990000001,null,6507.9563713999978]
[null," - repayment loans",2490.7248691999994,null,75.330686820000011,null,47.128779969999997,null,21.23948146,null,2634.4238174499992]
[null," - interest-only ",3794.3688418199977,null,48.124952579999999,null,10.622974019999999,null,20.415785530000001,null,3873.5325539499977]
[null,"RD EURIBOR3®",19.221524980000002,null,370.62893106000007,null,870.69312247999994,null,2100.5519566500002,null,3361.0955351699999]
[null," - repayment loans",5.6051578900000001,null,28.746760909999995,null,165.31058179999999,null,242.59175184,null,442.25425243999996]
[null," - interest-only ",13.616367090000001,null,341.88217015000004,null,705.38254067999992,null,1857.9602048100003,null,2918.8412827299999]
[null,"RD CIBOR6®",5.0851167799999999,null,1562.1840403699996,null,3711.9397321300003,null,71.94265784000001,null,5351.1515471199991]
[null," - repayment loans",1.60953251,null,202.93886242000002,null,952.43672871000012,null,14.580930970000001,null,1171.56605461]
[null," - interest-only ",3.4755842700000001,null,1359.2451779499995,null,2759.5030034199999,null,57.361726869999998,null,4179.5854925099993]
[null," Total",162726.44283950995,null,46497.76624466003,null,25280.608298059997,null,7398.888468340002,null,241903.70585057]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",62546.734393259983,null,18949.79194657999,null,9715.0956612499976,null,398.15989521,null,91609.781896299988]
[null," - Other Sealand",33449.910407530013,null,5768.6817697499973,null,2757.5566302600018,null,2107.6569425900002,null,44083.805750130006]
[null," - Region South Denmark",29103.288752969995,null,7910.4106437099845,null,5708.4230317499978,null,2832.5983724099997,null,45554.720800839983]
[null," - Region Central Jutland",28057.930395219988,null,10010.66612767,null,4813.5265482799978,null,1252.1543095199997,null,44134.277380689986]
[null," - Region North Jutland",9568.5788905300069,null,3607.2383342300004,null,2251.6157464900002,null,808.31894860999967,null,16235.751919860004]
[null," - Other area",0,null,250.97742271999999,null,34.390680029999999,null,0,null,285.36810274999999]
[null,"Total",162726.44283950998,null,46497.766244659972,null,25280.608298059997,null,7398.8884683399992,null,241903.70585056997]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",106124.07634418015,null,2270.0678262099991,null,976.82403775999944,null,893.19699136999952,null,110264.16519952015]
[null," 2 - 5",50942.026820689971,null,4207.1128167800034,null,1919.3021098799991,null,1398.66834597,null,58467.110093319978]
[null," 5 - 20",5405.4182376799981,null,16308.025732510005,null,6347.5374736800004,null,2179.6943220699991,null,30240.675765940003]
[null," 20 - 50",254.92143695999997,null,12370.448292790014,null,5933.3672373799982,null,2285.7520063800011,null,20844.488973510015]
[null," 50 - 100",0,null,5622.4647526199979,null,4317.2117804500022,null,568.63175187999991,null,10508.308284949999]
[null," 100 and above",0,null,5719.6468237500012,null,5786.3656589100001,null,72.945050670000001,null,11578.95753333]
[null,"Total",162726.4428395101,null,46497.766244660022,null,25280.608298059997,null,7398.8884683400001,null,241903.70585057017]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",24329.056079490001,null,7731.446979429993,null,3220.9591249900004,null,828.26609287999997,null,36109.728276789996]
[null," 1",44506.212875120007,null,7734.3018851700035,null,3747.8583245899999,null,1139.6603797299999,null,57128.033464610016]
[null," 2",27249.647518379996,null,7306.0003927799989,null,4677.9723866699997,null,945.81333644999984,null,40179.433634280002]
[null," 3",22723.140973949983,null,1799.2033761599996,null,1355.2248449000001,null,446.76476729999996,null,26324.333962309982]
[null," 4",17486.364995419975,null,2523.2988978899989,null,1311.3917794499998,null,393.64805748999993,null,21714.703730249978]
[null," 6",11267.894939219994,null,7111.504087749996,null,7561.6934430500014,null,2764.3684471300012,null,28705.460917149991]
[null," 8",6920.3917604299995,null,4328.0268702000021,null,2402.4334712599998,null,357.87512074999995,null,14008.727222640002]
[null," 10",5676.2104394300004,null,4360.073703179999,null,398.49936181999976,null,275.52456662999998,null,10710.308071059999]
[null," 15",2439.3446161299998,null,3543.935696139999,null,588.11338272,null,235.77859480999993,null,6807.1722897999989]
[null," 20",128.17864194000001,null,59.974355960000004,null,16.462178609999999,null,11.189105169999999,null,215.80428167999997]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",162726.44283950995,null,46497.766244659993,null,25280.60829806,null,7398.8884683400001,null,241903.70585056994]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",47364.121918236968,null,17961.947403114526,null,7580.2929638989981,null,2605.2577599938149,null,75511.620045244315]
[null,"20 - 40%",44264.469600797835,null,12000.829496273005,null,7069.7082328519054,null,2312.3307643827106,null,65647.338094305451]
[null,"40 - 60%",35985.662879419295,null,7430.2272700900685,null,5426.0519518707397,null,1474.2222796028543,null,50316.164380982962]
[null,"60 - 80%",23811.066846662776,null,4634.3839329569637,null,2650.1186043516445,null,625.40922043528394,null,31720.978604406664]
[null,"> 80 %",11301.12159455312,null,4470.3781422254206,null,2554.4365449666893,null,381.66844348533425,null,18707.604725230562]
[null,"Total",162726.44283967002,null,46497.766244659979,null,25280.60829793998,null,7398.8884678999975,null,241903.70585016999]

{"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*",149,42]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q1 2013"]

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

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

{"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 Q1"]
[null,null," "]
[]
[null,"DKK billion ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Weighted distribution",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",133.51283168019935,null,52.677333097897311,null,40.316066421929236,null,18.039699959274138,null,0.33176212451637649,null,244.54593115930004]
[null," - 20-40%",116.44518823038855,null,35.317589667715254,null,34.533628329619205,null,15.423692005894685,null,0.2736626531890351,null,201.7200982336177]
[null," - 40-60%",90.589251967682173,null,24.59029378764226,null,24.829266137704391,null,10.200846998130956,null,0.20378125009223333,null,150.20965889115979]
[null," - 60-80%",57.883892305586528,null,15.493685699540103,null,9.1151456295928703,null,4.0073558118865362,null,0.11734993909732044,null,86.500079446606051]
[null," - >80%",28.211681055034283,null,15.727784420824745,null,7.9767686059843808,null,2.2202635365837029,null,7.344403310503457E-2,null,54.136497618427114]
[null,"Total",426.64284523889086,null,143.80668667361965,null,116.77087512483008,null,49.891858311770015,null,1,null,737.11226534911066]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",58.209557077988144,null,15.189497626300907,null,26.344114001774532,null,13.709530650125469,null,0.31617125858652012,null,113.45269935618906]
[null," - 20-40%",52.283642251605251,null,12.32505936835941,null,23.483585135531992,null,12.239560677160071,null,0.27960592087369579,null,100.33184743265673]
[null," - 40-60%",42.481652579214575,null,9.8468983689405647,null,16.702918222172723,null,8.3697708072877113,null,0.21570264611377002,null,77.401239977615575]
[null," - 60-80%",28.091685206969085,null,6.1860382277834747,null,5.3110889993473087,null,3.2632703785384582,null,0.11942066634650367,null,42.852082812638322]
[null," - >80%",13.580910290882844,null,5.14134461636562,null,4.280414881693388,null,1.7925179547282746,null,6.9099508079510333E-2,null,24.795187743670127]
[null,"Total",194.64744740665992,null,48.688838207749981,null,76.122121240519945,null,39.374650467839984,null,0.99999999999999989,null,358.83305732276978]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",47.364121918236968,null,17.961947403114525,null,7.580292963898998,null,2.6052577599938149,null,0.31215569757337508,null,75.511620045244314]
[null," - 20-40%",44.264469600797838,null,12.000829496273004,null,7.0697082328519061,null,2.3123307643827102,null,0.27137797605699376,null,65.647338094305468]
[null," - 40-60%",35.985662879419294,null,7.4302272700900689,null,5.4260519518707397,null,1.4742222796028543,null,0.20800080017024519,null,50.316164380982961]
[null," - 60-80%",23.811066846662776,null,4.6343839329569638,null,2.6501186043516447,null,0.62540922043528391,null,0.13113060212502067,null,31.720978604406668]
[null," - >80%",11.30112159455312,null,4.470378142225421,null,2.554436544966689,null,0.3816684434853343,null,7.7334924074365624E-2,null,18.707604725230564]
[null,"Total",162.72644283967,null,46.497766244659985,null,25.280608297939974,null,7.3988884678999964,null,1.0000000000000004,null,241.90370585016998]

{"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 Q1"]
[null,null," "]
[]
[null,"DKK billion ","Classification 1-3",null,"Classification 4-7",null,"Classification 8-11",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",45.554663321390059,null,178.08883683888789,null,20.902430999022272,null,244.54593115930021]
[null," - 20-40%",31.024732905438771,null,151.0009564964345,null,19.69440883174407,null,201.72009823361736]
[null," - 40-60%",19.860429602401251,null,113.55818619521763,null,16.791043093540807,null,150.20965889115968]
[null," - 60-80%",9.9827376303966382,null,65.368231899736458,null,11.149109916472923,null,86.500079446606023]
[null," - >80%",8.7874397980388608,null,35.260834296801043,null,10.088223523587235,null,54.136497618427143]
[null,"Total",115.21000325766559,null,543.27704572707751,null,78.625216364367304,null,737.11226534911043]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",13.332613264530218,null,86.768681933220577,null,13.351404158438401,null,113.4526993561892]
[null," - 20-40%",9.7124616120585028,null,77.86048248694172,null,12.758903333656482,null,100.3318474326567]
[null," - 40-60%",6.6758002084111689,null,59.777768630043809,null,10.94767113916064,null,77.401239977615631]
[null," - 60-80%",2.9303839356689707,null,32.883354892831441,null,7.0383439841378594,null,42.852082812638272]
[null," - >80%",1.6167806976499108,null,17.30749209112312,null,5.8709149548970734,null,24.795187743670105]
[null,"Total",34.268039718318768,null,274.59778003416062,null,49.967237570290457,null,358.83305732276989]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",13.798068039068399,null,57.092891743672638,null,4.6206602625032742,null,75.511620045244314]
[null," - 20-40%",10.524545902449091,null,50.589448383479855,null,4.5333438083765545,null,65.647338094305496]
[null," - 40-60%",6.6552152829656368,null,39.613306283994994,null,4.0476428140223328,null,50.316164380982961]
[null," - 60-80%",3.6329911296738877,null,25.112706775340136,null,2.9752806993926089,null,31.720978604406632]
[null," - >80%",2.7132884107753443,null,13.126220933330043,null,2.8680953811252019,null,18.707604725230588]
[null,"Total",37.324108764932355,null,185.53457411981768,null,19.045022965419971,null,241.90370585017001]

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

{"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",46497766244.659988,46246788821.939995]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",25280608298.059998,25246217618.029995]
["S-Landbrug","S",null,"Landbrug",7398888468.340003,7398888468.340003]
["S-Privat","S",null,"Privat",162726442839.50952,162726442839.50952]
["S Total-","S Total","S Total",null,241903705850.56952,241618337747.81952]
["T-Boligudl","T","T","Boligudl",48688838207.899963,48622767557.479958]
["T-Erhverv","T",null,"Erhverv",76122121240.910034,68309102050.530083]
["T-Landbrug","T",null,"Landbrug",39374650467.730019,39374650467.730019]
["T-Privat","T",null,"Privat",194647447406.63959,194647447406.63959]
["T Total-","T Total","T Total",null,358833057323.17957,350953967482.37964]
["Ø-Boligudl","Ø","Ø","Boligudl",48620082221.62989,48425210336.959885]
["Ø-Erhverv","Ø",null,"Erhverv",15368145586.349976,15074550749.279972]
["Ø-Landbrug","Ø",null,"Landbrug",3118319375.9800014,3118319375.9800014]
["Ø-Privat","Ø",null,"Privat",69268954992.119827,69268954992.119827]
["Ø Total-","Ø Total","Ø Total",null,136375502176.0797,135887035454.33969]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,737112265349.82886,728459340684.53894]
[]
[]
[]
[]
[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":194647447406.63959}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":48622767557.479958}]
[null,null,"T-Erhverv","Erhverv","Commercial",68309102050.530083]
[null,null,"T-Landbrug","Landbrug","Agriculture",39374650467.730019]
[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":7879089840.7999268}]
[]
[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":162726442839.50952}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":46246788821.939995}]
[null,null,"S-Erhverv","Erhverv","Commercial",25246217618.029995]
[null,null,"S-Landbrug","Landbrug","Agriculture",7398888468.340003]
[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":285368102.75}]
[]
[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":69268954992.119827}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":48425210336.959885}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",15074550749.279972]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",3118319375.9800014]
[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":488466721.74002075}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":426642845238.26892}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":143294766716.37982}]
[null,null,null,null,"Commercial",108629870417.84004]
[null,null,null,null,"Agriculture",49891858312.050026]
[null,null,null,null,"Nordic",8652924665.2899475]