{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2014 Q2 Total","RD 2014 Q2 Cap T","RD 2014 Q2 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 2014 Q2 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q2 - Total portfolio"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",428611.63752017834,null,145162.87917204984,null,123747.28550873013,null,49123.746307370042,null,746645.54850832827]
[null," - Number of loans",423986,null,40994,null,15794,null,15505,null,496279]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",133513.65120748998,null,62149.67411735007,null,12846.592805169994,null,4480.8026894099958,null,212990.72081942004]
[null," - repayment loans",97488.537281609999,null,59662.686832320069,null,11652.173040209995,null,3168.2314770599969,null,171971.62863120003]
[null," - interest-only ",36025.113925879989,null,2486.9872850300026,null,1194.4197649600001,null,1312.5712123499995,null,41019.092188219984]
[null,"FlexLån®",259116.6694219601,null,63971.06188927008,null,48644.760461820006,null,29110.768939649952,null,400843.2607127002]
[null," - repayment loans",90305.489664550143,null,36329.478960340086,null,17996.154671119995,null,8061.6701026799974,null,152692.79339869021]
[null," - interest-only ",168811.17975740996,null,27641.582928929991,null,30648.60579070001,null,21049.098836969955,null,248150.46731400996]
[null,"FlexGaranti®, Rentedyk TM",26262.857675340012,null,919.7722242399999,null,407.82163261999995,null,469.0633097600001,null,28059.514841960015]
[null," - repayment loans",11540.310537440004,null,516.14798535999989,null,286.37834782999994,null,211.19491643999999,null,12554.031787070006]
[null," - interest-only ",14722.547137900006,null,403.62423888000001,null,121.44328479000001,null,257.86839332000011,null,15505.483054890006]
[null,"FlexKort®",9574.5396353499982,null,2344.3894806800004,null,2290.2283306399986,null,5949.2644693499997,null,20158.421916020001]
[null," - repayment loans",2844.8739840099993,null,636.05156120000015,null,1244.8802756499988,null,1254.3730911000005,null,5980.1789119599989]
[null," - interest-only ",6729.6656513400003,null,1708.3379194800002,null,1045.3480549899998,null,4694.8913782499994,null,14178.243004060001]
[null,"Other floating rate loans",143.91958004,null,15777.981460509998,null,59557.88227848005,null,9113.8468992000016,null,84593.630218230042]
[null," - repayment loans",23.417418720000001,null,2638.1310731100007,null,16787.25393725,null,1788.0793278900005,null,21236.88175697]
[null," - interest-only ",120.50216132,null,13139.850387399998,null,42770.628341230047,null,7325.7675713100007,null,63356.748461260038]
[null," Total",428611.63752018003,null,145162.87917205013,null,123747.28550873004,null,49123.746307369947,null,746645.54850833013]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",172240.19805816017,null,52503.497317880043,null,46879.387006949968,null,3338.9140287199984,null,274961.99641171016]
[null," - Other Sealand",88157.865573820149,null,17168.229660670004,null,10864.625688970009,null,12973.659629969974,null,129164.38055343012]
[null," - Region South Denmark",70994.425247959924,null,27178.384572890016,null,26396.635738069977,null,16889.141081370006,null,141458.58664028993]
[null," - Region Central Jutland",72869.329360000047,null,33667.142623979998,null,20967.241398889968,null,9471.1862756399987,null,136974.89965851]
[null," - Region North Jutland",24347.385778750042,null,13377.938403150021,null,6850.8314866599958,null,6450.8452916700016,null,51027.000960230056]
[null," - Other area",2.4335014900000003,null,1267.6865934800005,null,11788.564189189996,null,0,null,13058.684284159997]
[null,"Total",428611.63752018032,null,145162.87917205007,null,123747.28550872992,null,49123.746307369976,null,746645.54850833036]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",266411.05011188932,null,9929.3690911499998,null,4274.3404748199982,null,3610.0445155800012,null,284224.80419343931]
[null," 2 - 5",142140.96461992958,null,13617.4422044,null,6828.5266232699978,null,7134.7922773299997,null,169721.72572492957]
[null," 5 - 20",19431.549586729994,null,44853.131761079974,null,21851.022986469987,null,16017.123008859995,null,102152.82734313996]
[null," 20 - 50",573.74676112999987,null,34530.045834439974,null,20218.576365049968,null,15198.246127220003,null,70520.615087839935]
[null," 50 - 100",54.326440499999997,null,19307.586525789993,null,17878.649328239993,null,6196.2982057500021,null,43436.860500279981]
[null," 100 and above",0,null,22925.303755189998,null,52696.169730880014,null,967.24217262999991,null,76588.715658700006]
[null,"Total",428611.63752017892,null,145162.87917204993,null,123747.28550872995,null,49123.746307369998,null,746645.54850832885]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",35016.344067689963,null,11797.375534690011,null,21032.463905249992,null,10678.494351609994,null,78524.677859239964]
[null," 1",47944.844029029999,null,15001.973019799998,null,14987.432869279995,null,2582.2867559400015,null,80516.536674049989]
[null," 2",81274.463284669939,null,19683.134720689988,null,19112.719530739996,null,4311.7885680599975,null,124382.10610415992]
[null," 3",22575.24447704,null,5564.3258168099992,null,6660.0979323900037,null,1769.3156397600001,null,36568.98386600001]
[null," 4",44101.297565479988,null,9294.2069213400009,null,14329.520979759995,null,2873.7893015600007,null,70598.814768139986]
[null," 6",82052.098219780062,null,11783.443600119994,null,15456.93758936001,null,9504.3151010200036,null,118796.79451028007]
[null," 8",37835.282535859995,null,16139.644290260012,null,19730.667465510014,null,9572.9862943300031,null,83278.580585960022]
[null," 10",54914.054763030123,null,14801.342080520002,null,8932.7412692300004,null,5151.6476616100017,null,83799.785774390126]
[null," 15",20704.259708390036,null,14533.206875779999,null,3067.7238864099968,null,2364.2204796599995,null,40669.410950240032]
[null," 20",1727.5098618999994,null,14848.950778740009,null,316.08775852999997,null,139.53180383,null,17032.080203000009]
[null," 25",365.63028440999989,null,11092.707672470002,null,54.609767480000002,null,27.331914010000002,null,11540.279638370001]
[null," 30",100.60872289999999,null,622.56786083000009,null,66.28255479000002,null,148.03843598,null,937.49757450000004]
[null,"Total",428611.63752018014,null,145162.87917204999,null,123747.28550873,null,49123.746307370006,null,746645.54850833013]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",137622.80262237595,null,53974.413532773433,null,46348.56511469448,null,18676.797883071416,null,256622.57915291525]
[null,"20 - 40%",120223.54247590069,null,35711.0145365274,null,37517.654474237745,null,15588.507998932646,null,209040.71948559847]
[null,"40 - 60%",92413.679469061884,null,25564.731208759975,null,26901.672680081316,null,10184.540956998284,null,155064.62431490145]
[null,"60 - 80%",55187.077147133088,null,15627.757640431922,null,7573.4457755819622,null,3762.1938749123938,null,82150.474438059377]
[null,"> 80 %",23164.535805508622,null,14284.962253387223,null,5405.9474642345758,null,911.70559289528671,null,43767.151116025707]
[null,"Total",428611.63751998014,null,145162.87917187993,null,123747.28550883006,null,49123.746306810019,null,746645.54850750021]

{"sheet":"RD 2014 Q2 Cap T","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q2 - Capital center T"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",235198.70264036994,null,59214.001082530034,null,87999.369653339891,null,39842.568856930047,null,422254.64223316993]
[null," - Number of loans",207867,null,15450,null,9060,null,11201,null,243578]
[]
[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®",225525.24370322985,null,44804.881637340026,null,37226.160129930002,null,27191.609790469967,null,334747.89526096988]
[null," - repayment loans",80984.170174919971,null,26677.27339506003,null,15620.721000249992,null,7598.2853613499901,null,130880.44993157998]
[null," - interest-only ",144541.07352830991,null,18127.608242279995,null,21605.43912968001,null,19593.324429119977,null,203867.44532938986]
[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®",9574.5396353499946,null,2344.3894806800004,null,2290.2283306400009,null,5949.2644693500006,null,20158.421916019997]
[null," - repayment loans",2844.8739840099984,null,636.05156120000015,null,1244.8802756500008,null,1254.3730911000002,null,5980.1789119599998]
[null," - interest-only ",6729.6656513399957,null,1708.3379194800002,null,1045.3480549899998,null,4694.8913782500003,null,14178.243004059996]
[null,"Other floating rate loans",98.91930179000002,null,12064.729964509997,null,48482.981192770036,null,6701.6945971100004,null,67348.325056180038]
[null," - repayment loans",15.928937960000003,null,2232.8766519000014,null,13811.669565280012,null,1421.3896585999998,null,17481.864813740012]
[null," - interest-only ",82.990363830000007,null,9831.8533126099974,null,34671.311627490024,null,5280.3049385100003,null,49866.460242440015]
[null," Total",235198.70264036985,null,59214.001082530027,null,87999.369653340022,null,39842.568856929967,null,422254.64223316987]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",102304.80678584988,null,20366.045480290006,null,32580.14161995002,null,2862.1753389800015,null,158113.16922506993]
[null," - Other Sealand",46266.204707480028,null,6147.2097719099984,null,6857.6778886200009,null,10588.076306350013,null,69859.168674360029]
[null," - Region South Denmark",34696.048004579985,null,11382.410153559973,null,18984.222926940012,null,13019.909857969997,null,78082.590943049974]
[null," - Region Central Jutland",39659.39955745,null,14613.269005510016,null,13935.005939180008,null,7871.7145090999929,null,76079.389011240026]
[null," - Region North Jutland",12272.243585009996,null,5903.7319144500088,null,4200.1906861200032,null,5500.6928445300009,null,27876.859030110008]
[null," - Other area",0,null,801.33475681000004,null,11442.130592529998,null,0,null,12243.465349339998]
[null,"Total",235198.70264036988,null,59214.001082529998,null,87999.369653340051,null,39842.568856930004,null,422254.64223316999]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",129804.73316098994,null,5490.1890531000017,null,2223.7167236400023,null,2064.3569312400009,null,139582.99586896994]
[null," 2 - 5",90395.839869599993,null,6258.4062687899986,null,4278.5109288899976,null,5264.7587209199964,null,106197.51578819998]
[null," 5 - 20",14533.456146140004,null,15907.626008910003,null,14534.575953240006,null,13361.396963550003,null,58337.055071840019]
[null," 20 - 50",464.12224413000001,null,12357.528271850009,null,13441.520913570008,null,12901.122351000004,null,39164.293780550019]
[null," 50 - 100",0.55121951000000002,null,8644.642812549997,null,11544.379643030006,null,5379.9819532599995,null,25569.555628350001]
[null," 100 and above",0,null,10555.60866733,null,41976.665490970016,null,870.95193696000001,null,53403.226095260019]
[null,"Total",235198.70264036997,null,59214.001082530005,null,87999.369653340022,null,39842.568856930004,null,422254.64223316993]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",22472.114493850033,null,9336.6399779299991,null,20264.943580700001,null,10049.534665829999,null,62123.232718310028]
[null," 1",22347.852217339998,null,4074.43406289,null,11468.498887149997,null,1623.9063208100001,null,39514.691488189987]
[null," 2",34662.622816209994,null,9878.6185404500011,null,14192.963620190001,null,3030.3328023500003,null,61764.537779199993]
[null," 3",14017.680758169996,null,3731.9528942900006,null,5828.5428773499989,null,1614.1904466599999,null,25192.366976469995]
[null," 4",20455.244542219989,null,3620.4840425399993,null,9503.2396314600028,null,2163.441799539999,null,35742.410015759997]
[null," 6",67205.295046500003,null,7924.4483644800039,null,13233.787403240001,null,8805.0272038100011,null,97168.558018030017]
[null," 8",21103.110443270009,null,7098.503360910001,null,6229.7563927700003,null,6717.6031530099981,null,41148.973349960004]
[null," 10",17788.076661470001,null,6699.0156232200034,null,5151.3307735899998,null,3617.678147789999,null,33256.101206070001]
[null," 15",14719.817463279998,null,6713.1177734199955,null,2044.2501010200006,null,2124.4496087899997,null,25601.634946509996]
[null," 20",426.88819806000004,null,136.7864424,null,82.056385869999971,null,96.404708340000013,null,742.13573467000003]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",235198.70264037003,null,59214.001082530005,null,87999.369653339993,null,39842.568856929989,null,422254.64223317005]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",72779.174520895613,null,18598.381573926003,null,34051.583555559984,null,14586.644862160005,null,140015.78451254161]
[null,"20 - 40%",65096.833836884733,null,15318.028750092601,null,27666.143919619986,null,12726.843360060011,null,120807.84986665733]
[null,"40 - 60%",52019.482685404262,null,12393.364195372629,null,18974.471285430009,null,8568.6380801600135,null,91955.956246366914]
[null,"60 - 80%",31911.694301584772,null,7393.8176527879032,null,4521.1113789499968,null,3189.467533770001,null,47016.090867092673]
[null,"> 80 %",13391.517295620637,null,5510.4089103208735,null,2786.0595135900026,null,770.97502057999975,null,22458.96074011151]
[null,"Total",235198.70264039002,null,59214.001082499999,null,87999.369653149974,null,39842.568856730031,null,422254.64223276998]

{"sheet":"RD 2014 Q2 Cap S","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q2 - Capital center S"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",142785.52058681016,null,46235.296380440021,null,22256.240411929994,null,6917.3178318600048,null,218194.3752110402]
[null," - Number of loans",130867,null,8767,null,3299,null,2252,null,145185]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",104126.33141709006,null,28015.654319149962,null,10286.118967150001,null,3188.3243615299989,null,145616.42906492003]
[null," - repayment loans",73654.193866730042,null,25869.783440749961,null,9176.2781569000017,null,2094.1442595799986,null,110794.39972396001]
[null," - interest-only ",30472.137550360007,null,2145.8708784000019,null,1109.84081025,null,1094.1801019500003,null,34822.029340960005]
[null,"FlexLån®",32618.397457850024,null,16233.538695259995,null,7522.328802029997,null,1677.6800623799991,null,58051.945017520018]
[null," - repayment loans",9156.1223287500034,null,9209.6298619399968,null,2240.2936845299992,null,412.79105164999999,null,21018.836926870004]
[null," - interest-only ",23462.27512910002,null,7023.9088333199988,null,5282.0351174999978,null,1264.8890107299992,null,37033.108090650014]
[null,"FlexGaranti®, Rentedyk TM",6018.1814563100015,null,123.04630848999997,null,55.949445670000003,null,39.438740719999998,null,6236.6159511900014]
[null," - repayment loans",2391.6749272999991,null,75.443036719999995,null,45.211981130000005,null,21.549317769999998,null,2533.8792629199988]
[null," - interest-only ",3626.5065290100024,null,47.603271769999985,null,10.73746454,null,17.88942295,null,3702.736688270003]
[null,"FlexKort®",0,null,0,null,0,null,0,null,0]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,0,null,0]
[null,"Other floating rate loans",22.610255559999999,null,1863.0570575400002,null,4391.8431970800002,null,2011.8746672299999,null,8289.3851774100003]
[null," - repayment loans",5.4657815699999999,null,258.85758059999995,null,1206.4032338099998,null,235.02417831999992,null,1705.7507742999999]
[null," - interest-only ",17.144473989999998,null,1604.1994769400003,null,3185.4399632699997,null,1776.8504889099997,null,6583.6344031099998]
[null," Total",142785.52058681007,null,46235.296380439962,null,22256.240411930004,null,6917.3178318599976,null,218194.37521103999]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",54238.308080079994,null,19549.421031569993,null,7943.7350202499993,null,351.63192539000005,null,82083.096057289993]
[null," - Other Sealand",28866.649920640015,null,5066.5873568499983,null,2600.7847983400002,null,1843.4445706199999,null,38377.466646450019]
[null," - Region South Denmark",26214.143514579981,null,8066.2736744799986,null,5238.5220715599953,null,2968.130116179997,null,42487.069376799969]
[null," - Region Central Jutland",24793.770950349997,null,9690.3459191299917,null,4409.0867773200016,null,1076.9034647800001,null,39970.107111579986]
[null," - Region North Jutland",8672.6481211600021,null,3609.2369883200017,null,2029.3848019399998,null,677.20775488999993,null,14988.477666310004]
[null," - Other area",0,null,253.43141009000001,null,34.726942520000001,null,0,null,288.15835261000001]
[null,"Total",142785.52058680999,null,46235.296380439977,null,22256.240411929997,null,6917.3178318599976,null,218194.37521103994]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",94617.860055839861,null,2049.00387735,null,951.48524608999958,null,850.04937841999993,null,98468.398557699853]
[null," 2 - 5",43741.345311760015,null,4262.5948909599992,null,1813.6832266999995,null,1261.7842314799996,null,51079.407660900011]
[null," 5 - 20",4321.9967985999992,null,15646.259059509994,null,5649.3599075999964,null,2072.8474868299986,null,27690.46325253999]
[null," 20 - 50",104.31842061,null,11224.526877230008,null,5508.2563868999951,null,2030.3206721000001,null,18867.422356840001]
[null," 50 - 100",0,null,5763.3297672400004,null,3953.47417989,null,663.18092447999993,null,10379.98487161]
[null," 100 and above",0,null,7289.5819081500013,null,4379.9814647499998,null,39.135138549999994,null,11708.69851145]
[null,"Total",142785.52058680987,null,46235.296380440006,null,22256.24041192999,null,6917.3178318599985,null,218194.37521103985]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",12544.229573840003,null,2460.7355567599993,null,709.2049354799999,null,628.95968577999997,null,16343.129751860002]
[null," 1",25596.991811689986,null,10927.538956909993,null,2994.2240159300004,null,958.38043513000002,null,40477.135219659984]
[null," 2",46611.840468459988,null,9804.5161802400071,null,4783.1353503500004,null,1281.4557657100004,null,62480.947764760007]
[null," 3",8557.5637188700002,null,1832.3729225200007,null,685.9207492300003,null,155.12519310000002,null,11230.982583720001]
[null," 4",23646.053023259999,null,5673.7228788000048,null,3538.9679342900004,null,710.34750201999964,null,33569.09133837001]
[null," 6",14843.160393419985,null,3858.9952356400026,null,2223.1501861200004,null,699.28789720999976,null,21624.593712389986]
[null," 8",5136.4090053900009,null,4535.9758395299987,null,5871.1780250700012,null,2125.3525149799998,null,17668.915384970001]
[null," 10",4106.3672610399999,null,3280.4739902999981,null,1014.5145292899999,null,230.69763926000005,null,8632.0534198899968]
[null," 15",1696.0767361000001,null,3815.9815624500011,null,422.78315658000002,null,124.93955147,null,6059.7810066000011]
[null," 20",46.828594739999986,null,44.983257290000005,null,13.161529590000001,null,2.7716472000000003,null,107.74502882]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",142785.52058680996,null,46235.296380440006,null,22256.240411930004,null,6917.3178318599994,null,218194.37521103997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",43845.068918982026,null,19801.59959637182,null,7251.7544974700022,null,2706.2795352999951,null,73604.702548123838]
[null,"20 - 40%",40604.28108439147,null,11851.683873007491,null,6614.3315098300018,null,2226.7321104900002,null,61297.028577718964]
[null,"40 - 60%",31762.122512673566,null,7204.6975399943994,null,5019.5909085300018,null,1376.1259672099993,null,45362.536928407957]
[null,"60 - 80%",19083.56017273436,null,4012.0838509145678,null,2185.1636384599974,null,493.32776272000001,null,25774.135424828924]
[null,"> 80 %",7490.4878979486029,null,3365.2315199817717,null,1185.3998577099999,null,114.85245605,null,12155.971731690375]
[null,"Total",142785.52058673004,null,46235.296380270047,null,22256.240411999999,null,6917.3178317699949,null,218194.37521077006]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"End year","Stock","Repossed in year"]
[null,1986,471,933]
[null,1987,630,1238]
[null,1988,1562,2797]
[null,1989,2654,4209]
[null,1990,3201,4213]
[null,1991,2463,3950]
[null,1992,2331,3441]
[null,1993,1720,3264]
[null,1994,732,1479]
[null,1995,215,572]
[null,1996,97,265]
[null,1997,32,198]
[null,1998,24,107]
[null,1999,15,87]
[null,2000,28,109]
[null,2001,54,117]
[null,2002,51,169]
[null,2003,51,158]
[null,2004,26,101]
[null,2005,13,47]
[null,2006,1,16]
[null,2007,4,6]
[null,2008,23,46]
[null,2009,37,58]
[null,2010,164,235]
[null,2011,161,217]
[null,2012,156,198]
[null,2013,122,164]
[null,"2014*",91,63]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q2 2014"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Quarter","Homeowner Segment","Corporate Segments","Total"]
[null,"2002 Q4",45,6,{"$f":"C5+D5","v":51}]
[null,"2003 Q1",48,7,{"$f":"C6+D6","v":55}]
[null,"2003 Q2",59,5,64]
[null,"2003 Q3",64,5,69]
[null,"2003 Q4",46,5,51]
[null,"2004 Q1",49,5,54]
[null,"2004 Q2",41,5,46]
[null,"2004 Q3",26,3,29]
[null,"2004 Q4",24,2,26]
[null,"2005 Q1",20,3,23]
[null,"2005 Q2",15,3,18]
[null,"2005 Q3",10,3,13]
[null,"2005 Q4",10,3,13]
[null,"2006 Q1",6,1,7]
[null,"2006 Q2",5,0,5]
[null,"2006 Q3",0,0,0]
[null,"2006 Q4",1,0,1]
[null,"2007 Q1",0,0,0]
[null,"2007 Q2",0,0,0]
[null,"2007 Q3",1,0,1]
[null,"2007 Q4",4,0,4]
[null,"2008 Q1",4,0,4]
[null,"2008 Q2",8,0,8]
[null,"2008 Q3",12,1,13]
[null,"2008 Q4",20,3,23]
[null,"2009 Q1",26,1,27]
[null,"2009 Q2",27,1,28]
[null,"2009 Q3",24,2,26]
[null,"2009 Q4",30,7,37]
[null,"2010 Q1",61,20,81]
[null,"2010 Q2",87,27,114]
[null,"2010 Q3",113,32,145]
[null,"2010 Q4",133,31,164]
[null,"2011 Q1",140,39,{"$f":"C38+D38","v":179}]
[null,"2011 Q2",130,34,{"$f":"C39+D39","v":164}]
[null,"2011 Q3",116,37,153]
[null,"2011 Q4",118,43,161]
[null,"2012 Q1",118,48,166]
[null,"2012 Q2",135,51,186]
[null,"2012 Q3",115,42,157]
[null,"2012 Q4",109,47,156]
[null,"2013 Q1",109,40,149]
[null,"2013 Q2",109,29,138]
[null,"2013 Q3",96,32,128]
[null,"2013 Q4",96,26,122]
[null,"2014 Q1",91,16,107]
[null,"2014 Q2",72,19,91]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":39,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Loan to value %","2005 Q2","2005 Q3","2005 Q4","2006 Q1","2006 Q2","2006 Q3","2006 Q4","2007 Q1","2007 Q2","2007 Q3","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2"]
[null,"Private",64.97,65.47,62.75,61.55,59.06,58.73,56.28,57.15,56.02,56.58,57.84,59.3,57.14,60.13,66.03,67.569999999999993,69.23,71.959999999999994,72.38,70.58,72.23,70.98,70.599999999999994,68.52,70.45,72.83,76.209999999999994,75.959999999999994,73.59,72.099999999999994,72.989999999999995,74.52,72.7,73.37,72.400000000000006,73.244,72.239999999999995]
[null,"Commercial",53.51,54.3,48.54,50.65,51.63,49.59,49,49.02,49.09,45.89,47.15,48.46,48.04,54.46,54.78,54.31,59.27,62.88,65.5,62.25,61.09,61.45,62.52,60.69,64.89,60.06,64.209999999999994,63.93,62.81,59.64,60.21,63.78,59.46,59.81,59.4,58.201000000000001,59.31]
[null,"Agriculture",59.45,58.76,56.45,56.1,55.16,53.87,51.21,52.33,52.31,51.76,53.22,52.13,51.31,54.91,49.92,53.32,57.56,59.24,61.03,59.03,60.92,60.43,61.94,60.21,60.49,61.62,61.43,60.4,63.42,63.17,63.71,64,63.18,63.14,64.2,59.475999999999999,60.07]
[null,"Rental residential",94,96.46,68.72,62.18,61.5,62.66,59.74,60.99,59.82,56.41,57.98,58.79,61.47,63.05,66.13,67.87,71.83,76.05,76.02,74.87,76.510000000000005,78.48,74.41,74.11,73.63,75.59,79.3,79.540000000000006,77.67,85.24,84.34,79.930000000000007,80.739999999999995,77.16,78.400000000000006,75.965999999999994,78.180000000000007]
[null,"Total",69.260000000000005,70.3,62.09,60.27,58.53,58.27,55.91,56.8,55.83,55.12,56.33,57.42,56.42,59.53,63.26,64.64,67.38,70.44,71.23,69.34,70.55,70.19,69.47,67.8,69.489999999999995,70.61,73.930000000000007,73.72,71.989999999999995,72.040000000000006,72.47,73.12,71.73,71.44,71.099999999999994,70.578999999999994,70.66]

{"sheet":"LTV - Sectors","index":6,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,12]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q2"]
[null,null," "]
[]
[null,"DKK billion ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Weighted distribution",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",137.62280262237596,null,53.974413532773433,null,46.34856511469448,null,18.676797883071416,null,0.34370067519439235,null,256.62257915291531]
[null," - 20-40%",120.22354247590069,null,35.711014536527394,null,37.517654474237744,null,15.588507998932645,null,0.27997316786185666,null,209.04071948559846]
[null," - 40-60%",92.41367946906189,null,25.564731208759977,null,26.901672680081315,null,10.184540956998283,null,0.2076817100495226,null,155.06462431490147]
[null," - 60-80%",55.187077147133088,null,15.627757640431923,null,7.5734457755819626,null,3.7621938749123935,null,0.11002606873137226,null,82.150474438059376]
[null," - >80%",23.164535805508621,null,14.284962253387222,null,5.4059474642345764,null,0.91170559289528663,null,5.8618378162856012E-2,null,43.767151116025708]
[null,"Total",428.61163751998026,null,145.16287917187995,null,123.74728550883007,null,49.12374630681002,null,0.99999999999999978,null,746.64554850750039]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",72.779174520895609,null,18.598381573926002,null,34.051583555559986,null,14.586644862160005,null,0.33159087078871519,null,140.01578451254161]
[null," - 20-40%",65.096833836884741,null,15.3180287500926,null,27.666143919619987,null,12.726843360060011,null,0.2861018868326885,null,120.80784986665734]
[null," - 40-60%",52.019482685404256,null,12.393364195372628,null,18.974471285430006,null,8.5686380801600137,null,0.21777370110161087,null,91.955956246366895]
[null," - 60-80%",31.91169430158477,null,7.3938176527879031,null,4.521111378949997,null,3.1894675337700011,null,0.11134534985449564,null,47.016090867092672]
[null," - >80%",13.391517295620638,null,5.5104089103208729,null,2.7860595135900024,null,0.77097502057999978,null,5.3188191422489782E-2,null,22.458960740111511]
[null,"Total",235.19870264039,null,59.214001082500005,null,87.999369653149984,null,39.842568856730026,null,1,null,422.25464223277004]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",43.845068918982022,null,19.801599596371819,null,7.2517544974700021,null,2.7062795352999949,null,0.33733547199382952,null,73.604702548123839]
[null," - 20-40%",40.604281084391474,null,11.85168387300749,null,6.6143315098300022,null,2.2267321104900004,null,0.28092854602006878,null,61.297028577718962]
[null," - 40-60%",31.762122512673564,null,7.2046975399943989,null,5.0195909085300014,null,1.3761259672099992,null,0.207899662329008,null,45.362536928407962]
[null," - 60-80%",19.083560172734359,null,4.0120838509145678,null,2.1851636384599971,null,0.49332776272000001,null,0.11812465559633142,null,25.774135424828923]
[null," - >80%",7.4904878979486025,null,3.3652315199817719,null,1.1853998577099998,null,0.11485245605,null,5.5711664060762445E-2,null,12.155971731690373]
[null,"Total",142.78552058673003,null,46.23529638027005,null,22.256240412000004,null,6.9173178317699948,null,1.0000000000000002,null,218.19437521077006]

{"sheet":"LTV - Classification","index":7,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,2,5,8]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 Q2"]
[null,null," "]
[]
[null,"DKK billion ","Classification 1-3",null,"Classification 4-7",null,"Classification 8-11",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",51.896268151261232,null,185.64869483278261,null,19.077616168871121,null,256.62257915291497]
[null," - 20-40%",34.05958347225971,null,157.14567165008182,null,17.835464363257092,null,209.04071948559863]
[null," - 40-60%",22.002336542510122,null,117.75645266585013,null,15.305835106541249,null,155.06462431490152]
[null," - 60-80%",10.732961302268681,null,61.389012897509367,null,10.028500238281303,null,82.150474438059348]
[null," - >80%",8.4105283092958913,null,27.777887983856292,null,7.578734822873483,null,43.767151116025673]
[null,"Total",127.10167777759563,null,549.71772003008027,null,69.82615069982424,null,746.64554850750005]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",21.140776476975944,null,105.658697617193,null,13.216310418372711,null,140.01578451254164]
[null," - 20-40%",14.861347865371965,null,93.374317033658841,null,12.572184967626431,null,120.80784986665724]
[null," - 40-60%",9.717314896068439,null,71.281106170463659,null,10.957535179834727,null,91.955956246366824]
[null," - 60-80%",4.2159827161387309,null,35.773478714417109,null,7.0266294365368447,null,47.016090867092686]
[null," - >80%",2.1433629451518872,null,15.638593707557302,null,4.6770040874022953,null,22.458960740111486]
[null,"Total",52.078784899706967,null,321.72619324328986,null,48.449664089773009,null,422.25464223276987]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",14.925257324097524,null,54.987401988587457,null,3.6920432354388137,null,73.604702548123797]
[null," - 20-40%",10.59687352536776,null,47.17616809160026,null,3.5239869607509196,null,61.29702857771894]
[null," - 40-60%",6.6663608383337403,null,35.666702359813456,null,3.029473730260785,null,45.362536928407977]
[null," - 60-80%",3.2798301826356582,null,20.413980531137621,null,2.08032471105563,null,25.774135424828913]
[null," - >80%",1.9484811373718121,null,8.4575438082394019,null,1.7499467860791431,null,12.155971731690357]
[null,"Total",37.416803007806493,null,166.70179677937818,null,14.07577542358529,null,218.19437521076998]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":39,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","2005 Q2","2005 Q3","2005 Q4","2006 Q1","2006 Q2","2006 Q3","2006 Q4","2007 Q1","2007 Q2","2007 Q3","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2"]
[null,"Private",8.0652528612137897E-2,7.7191298368422895E-2,6.9556929511739488E-2,5.6591704792520001E-2,5.1296367647227961E-2,5.6647210289428276E-2,5.0244429306712655E-2,6.0543838606434336E-2,6.16656827446775E-2,7.0253843806781346E-2,8.0928251690201194E-2,0.10004882266970098,0.11781523259771912,0.1405975605147636,0.21226550425193944,0.31,0.40858428118318801,0.47,0.52,0.54,0.42,0.36,0.33,0.28999999999999998,0.28999999999999998,0.3463,0.26,0.26190376313394481,0.24316578085023852,0.2369410256441489,0.2412168151228983,0.24464011849638104,0.26151874154946242,0.18995975418317132,0.21,0.20871851307349823,0.20374765009047413]
[null,"Commercial",0.16563791556290958,0.2132773695526021,0.12204037907712323,0.10503765547972971,8.8360652070989781E-2,9.3490201160133263E-2,0.12575758646685919,0.13869347004763621,6.9749523648991063E-2,8.4826854962818915E-2,0.13082680939576194,6.3690962238606902E-2,9.4493334396141937E-2,0.13624324754250733,0.3969035165305469,0.5,1.19219168754725,1.49,2.2799999999999998,1.66,1.68,1.53,1.45,0.99,1.52,1.0514600000000001,1.1100000000000001,0.98135130215418731,0.91779340446955104,0.9167755240471176,0.97966799583253905,0.96572955607584687,0.90468379651813313,1.0725515021846566,0.89,0.87131255651855843,0.76461653695092491]
[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,0.42079094786587184,0.41219469725925079]
[null,"Rental Residential",4.3803406849193607E-2,9.5903072670480427E-2,3.6486627092520228E-2,8.0964019790819894E-2,3.0837731696558998E-2,9.0809206617881597E-2,0.13105243766129279,0.12018992862817277,4.2604410955085943E-2,9.7458697328710153E-2,9.7552936486864472E-2,7.1229672369108821E-2,0.17376216832575472,0.14733228176836374,0.54055865639875256,0.47,1.43,0.78,2.3199999999999998,1.05,1.25,0.73,1.23,0.54,0.79,0.48215999999999998,0.61,1.0340488552503766,0.94359445546940601,0.95685367926700082,1.015570738474074,1.0358365609598339,1.1088667897697735,1.0818705545393414,0.69,1.0079192391688849,0.56932045694128441]
[null,"Total",9.3078859231499098E-2,0.1041114235941326,7.4301233393325866E-2,7.876830458817323E-2,5.4285894101353913E-2,7.2796144890424228E-2,7.1601991163809345E-2,9.0566535002575665E-2,6.0047323754447109E-2,7.9214700905587174E-2,9.2930152243926437E-2,8.4504082108036338E-2,0.12016587495976419,0.13984787324621051,0.28332394419109863,0.37,0.66341144567458699,0.69,1.02,0.84,0.73,0.62,0.63,0.48,0.56999999999999995,0.48478000000000004,0.46,0.58369618019212233,0.47098288764955432,0.5326320421930133,0.48741117386115446,0.56540413616177954,0.51758010480584227,0.55014006668795445,0.41,0.53504965819159567,0.36591361753693991]

{"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",46235296380.440018,45981864970.350029]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",22256240411.930012,22221513469.410011]
["S-Landbrug","S",null,"Landbrug",6917317831.8600054,6917317831.8600054]
["S-Privat","S",null,"Privat",142785520586.80963,142785520586.80963]
["S Total-","S Total","S Total",null,218194375211.03967,217906216858.42969]
["T-Boligudl","T","T","Boligudl",59214001082.530037,58412802700.080032]
["T-Erhverv","T",null,"Erhverv",87999369653.340057,76557239060.809906]
["T-Landbrug","T",null,"Landbrug",39842568856.930046,39842568856.930046]
["T-Privat","T",null,"Privat",235198702640.37036,235198702640.37036]
["T Total-","T Total","T Total",null,422254642233.17053,410011313258.19031]
["Ø-Boligudl","Ø","Ø","Boligudl",39713581709.079979,39513995264.219978]
["Ø-Erhverv","Ø",null,"Erhverv",13491675443.460003,13194143270.780003]
["Ø-Landbrug","Ø",null,"Landbrug",2363859618.5799985,2363859618.5799985]
["Ø-Privat","Ø",null,"Privat",50627414293.000191,50627414293.000191]
["Ø Total-","Ø Total","Ø Total",null,106196531064.12018,105699412446.58017]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,746645548508.33032,733616942563.2002]
[]
[]
[]
[]
[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":235198702640.37036}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":58412802700.080032}]
[null,null,"T-Erhverv","Erhverv","Commercial",76557239060.809906]
[null,null,"T-Landbrug","Landbrug","Agriculture",39842568856.930046]
[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":12243328974.980225}]
[]
[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":142785520586.80963}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":45981864970.350029}]
[null,null,"S-Erhverv","Erhverv","Commercial",22221513469.410011]
[null,null,"S-Landbrug","Landbrug","Agriculture",6917317831.8600054]
[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":288158352.60998535}]
[]
[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":50627414293.000191}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":39513995264.219978}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",13194143270.780003]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2363859618.5799985]
[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":497118617.54000854}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":428611637520.18018}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":143908662934.65002}]
[null,null,null,null,"Commercial",111972895800.99991]
[null,null,null,null,"Agriculture",49123746307.370056]
[null,null,null,null,"Nordic",13028605945.130219]