{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2014 Q1 Total","RD 2014 Q1 Cap T","RD 2014 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 2014 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 2014 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",425015.36093122174,null,145381.37661159964,null,123872.29524715991,null,48998.47866821997,null,743267.51145820133]
[null," - Number of loans",426456,null,41843,null,16112,null,15612,null,500023]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",132306.88229486992,null,62529.061399320053,null,13084.009373910012,null,4435.3907655200001,null,212355.34383361999]
[null," - repayment loans",97151.47421966985,null,59978.033413330057,null,11901.071334640012,null,3160.1415283700012,null,172190.72049600992]
[null," - interest-only ",35155.408075200081,null,2551.0279859900006,null,1182.9380392699998,null,1275.2492371499993,null,40164.623337610079]
[null,"FlexLån®",258076.23257282059,null,64223.622959849999,null,49767.599848189973,null,29314.618245199996,null,401382.07362606056]
[null," - repayment loans",90740.733100089972,null,36130.299924269988,null,18500.110386929966,null,8196.4881991899911,null,153567.63161047993]
[null," - interest-only ",167335.49947273062,null,28093.323035580008,null,31267.489461260007,null,21118.130046010006,null,247814.44201558066]
[null,"FlexGaranti®, Rentedyk TM",26582.580873349987,null,943.05949804000022,null,419.72433129000007,null,480.24169130999991,null,28425.606393989987]
[null," - repayment loans",11698.771449109983,null,520.96938323000006,null,298.97211095000006,null,208.93924873999995,null,12727.652192029984]
[null," - interest-only ",14883.809424240004,null,422.0901148100001,null,120.75222034000001,null,271.30244256999998,null,15697.954201960003]
[null,"FlexKort®",7906.5622653600003,null,2204.0020771599993,null,2072.7308233099998,null,5704.3741267299993,null,17887.669292559996]
[null," - repayment loans",2408.6379036400003,null,553.20562819000008,null,1116.64222281,null,1225.9048613800001,null,5304.3906160200004]
[null," - interest-only ",5497.92436172,null,1650.7964489699993,null,956.0886005000001,null,4478.4692653499997,null,12583.27867654]
[null,"Other floating rate loans",143.10292481999997,null,15481.630677230007,null,58528.230870459971,null,9063.8538394599982,null,83216.818311969968]
[null," - repayment loans",23.451354460000001,null,2694.7526993499996,null,15911.552829150001,null,1781.7450429700002,null,20411.501925929999]
[null," - interest-only ",119.65157035999997,null,12786.877977880009,null,42616.67804130997,null,7282.108796489998,null,62805.316386039973]
[null," Total",425015.36093122052,null,145381.37661160008,null,123872.29524715994,null,48998.478668219992,null,743267.51145820052]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",170188.31021151016,null,52410.404525390055,null,46366.102950229972,null,3363.9395165600017,null,272328.75720369018]
[null," - Other Sealand",87782.563129200018,null,17065.241390729996,null,11462.616304419993,null,12934.882897910013,null,129245.30372226003]
[null," - Region South Denmark",70428.482783610001,null,27116.083967840008,null,27874.496419769988,null,16785.350738200003,null,142204.41390942002]
[null," - Region Central Jutland",72302.933880770128,null,34210.630450749981,null,21550.234407819997,null,9431.172696769996,null,137494.97143611012]
[null," - Region North Jutland",24310.056840779987,null,13302.805467669989,null,6856.032680960001,null,6483.1328187799973,null,50952.027808189974]
[null," - Other area",3.0140853499999998,null,1276.2108092199996,null,9762.8124839600023,null,0,null,11042.037378530003]
[null,"Total",425015.36093122029,null,145381.37661160005,null,123872.29524715996,null,48998.478668220007,null,743267.51145820029]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",266942.15423352004,null,10056.798639119999,null,4321.9803731600023,null,3654.2869748000003,null,284975.22022060002]
[null," 2 - 5",138259.72574828975,null,13796.794677250007,null,6917.9330998499963,null,7061.7808986499967,null,166036.23442403975]
[null," 5 - 20",19200.900680100007,null,44734.201896589933,null,21949.613519849965,null,16112.146681760019,null,101996.86277829992]
[null," 20 - 50",559.25034921000008,null,34486.893441330023,null,20406.653743809991,null,15200.211788559991,null,70653.009322910002]
[null," 50 - 100",53.329920100000002,null,18323.843795890007,null,17594.874053810017,null,5978.0353002600013,null,41950.08307006002]
[null," 100 and above",0,null,23982.844161420002,null,52681.240456679981,null,992.01702419000003,null,77656.101642289999]
[null,"Total",425015.36093121977,null,145381.37661160002,null,123872.29524715994,null,48998.478668220007,null,743267.51145819982]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",34198.010344559974,null,13214.083416450008,null,20668.178924259984,null,10393.620943330006,null,78473.893628599966]
[null," 1",61870.47528142995,null,19132.994138300015,null,22994.237633899993,null,4087.7275588300017,null,108085.43461245995]
[null," 2",72848.860964029998,null,15439.053830220006,null,12371.174315119999,null,3830.0196592300003,null,104489.10876860001]
[null," 3",11504.659399630002,null,5405.0890118500029,null,6071.4654492200025,null,904.04157622999969,null,23885.255436930005]
[null," 4",52277.285933539941,null,8078.0641890000052,null,15132.560766570014,null,3977.4194175199996,null,79465.330306629956]
[null," 6",77736.212124869999,null,12363.559334889998,null,17975.298923979979,null,9266.6370217499971,null,117341.70740548997]
[null," 8",39028.097065600057,null,16183.240526239997,null,16998.804218559999,null,9183.8834594700056,null,81394.02526987005]
[null," 10",54661.159739239978,null,14382.074323589979,null,8268.5712303600067,null,4844.8791802200012,null,82156.684473409958]
[null," 15",18794.530438849983,null,14546.060332780002,null,2934.6980084300012,null,2199.1073748899994,null,38474.396154949987]
[null," 20",1659.3219615900011,null,15096.855984160002,null,315.92296343000004,null,126.19826220000002,null,17198.299171380004]
[null," 25",319.13525375999996,null,10866.963343330004,null,67.603521130000004,null,37.412417670000011,null,11291.114535890003]
[null," 30",117.61242411999997,null,673.33818078999968,null,73.7792922,null,147.53179687999997,null,1012.2616939899998]
[null,"Total",425015.36093121982,null,145381.37661160005,null,123872.29524715996,null,48998.478668219999,null,743267.5114581997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",134719.28105795139,null,54413.90456806148,null,47034.267364549785,null,18865.316233086047,null,255032.76922364871]
[null,"20 - 40%",117873.21436882947,null,36746.672691109918,null,38401.865795782942,null,15600.46870203266,null,208622.22155775499]
[null,"40 - 60%",91224.100510196789,null,25966.593549701131,null,26579.283860181204,null,9956.3332004146014,null,153726.31112049372]
[null,"60 - 80%",55882.199014542493,null,15369.584505886452,null,7196.9676442581394,null,3701.7178453634933,null,82150.469010050583]
[null,"> 80 %",25316.565980089712,null,12884.621296651392,null,4659.9105825178822,null,874.64268751323209,null,43735.740546772235]
[null,"Total",425015.36093160987,null,145381.37661141038,null,123872.29524728995,null,48998.478668410033,null,743267.5114587202]

{"sheet":"RD 2014 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 2014 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",226637.28725032028,null,57465.776687930003,null,85721.892932750037,null,39424.296586070006,null,409249.25345707039]
[null," - Number of loans",201638,null,15188,null,8966,null,11131,null,236923]
[]
[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®",218632.48257160027,null,43488.119877540019,null,36230.397937390029,null,27116.672598029993,null,325467.67298456031]
[null," - repayment loans",79563.002898710183,null,26082.514611680017,null,15219.433148090022,null,7650.4762198199933,null,128515.42687830022]
[null," - interest-only ",139069.47967289007,null,17405.605265860002,null,21010.964789300011,null,19466.196378209999,null,196952.24610626008]
[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®",7906.5622653600003,null,2204.0020771599993,null,2072.7308233100002,null,5704.3741267300011,null,17887.66929256]
[null," - repayment loans",2408.6379036399999,null,553.20562819000008,null,1116.6422228100002,null,1225.9048613800001,null,5304.3906160200004]
[null," - interest-only ",5497.9243617200009,null,1650.7964489699993,null,956.08860049999998,null,4478.4692653500015,null,12583.278676540001]
[null,"Other floating rate loans",98.242413360000015,null,11773.654733229998,null,47418.764172050011,null,6603.249861309997,null,65893.91117995001]
[null," - repayment loans",15.920820819999999,null,2286.542172689999,null,12854.563104859993,null,1397.7053552600005,null,16554.731453629993]
[null," - interest-only ",82.321592540000012,null,9487.1125605399993,null,34564.201067190021,null,5205.544506049996,null,49339.179726320013]
[null," Total",226637.28725032031,null,57465.776687930025,null,85721.892932750037,null,39424.296586069991,null,409249.25345707033]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",98194.459407890041,null,19770.42127322001,null,31587.483564250033,null,2854.7540400900002,null,152407.11828545007]
[null," - Other Sealand",44840.095999370031,null,5805.4457918700009,null,6837.4066297900063,null,10431.839027450005,null,67914.787448480056]
[null," - Region South Denmark",33405.031065389994,null,11079.805079690008,null,20293.544279829999,null,12937.415618310004,null,77715.796043220005]
[null," - Region Central Jutland",38271.163266550036,null,14304.593938230002,null,13536.693441499992,null,7711.8513274899988,null,73824.301973770038]
[null," - Region North Jutland",11926.537511120001,null,5691.895493210005,null,4048.615930110001,null,5488.4365727300019,null,27155.485507170004]
[null," - Other area",0,null,813.61511170999995,null,9418.1490872700015,null,0,null,10231.764198980001]
[null,"Total",226637.28725032008,null,57465.776687930032,null,85721.892932750037,null,39424.296586070006,null,409249.25345707015]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",125836.10083210007,null,5407.5550608800022,null,2193.6544505300003,null,2056.7168526699979,null,135494.02719618008]
[null," 2 - 5",86237.023981129911,null,6178.21729848,null,4204.4831907300004,null,5152.8713719499956,null,101772.5958422899]
[null," 5 - 20",14113.43772589999,null,15521.685154960011,null,14242.512219819986,null,13384.733947720004,null,57262.369048399989]
[null," 20 - 50",450.72471118999994,null,11845.18583774,null,13395.341901519996,null,12746.322974089999,null,38437.575424539995]
[null," 50 - 100",0,null,7908.7944133399978,null,11025.326529689999,null,5217.0773122599976,null,24151.198255289997]
[null," 100 and above",0,null,10604.338922530003,null,40660.574640459992,null,866.57412737999982,null,52131.487690369984]
[null,"Total",226637.28725031999,null,57465.776687930011,null,85721.892932749965,null,39424.296586069984,null,409249.25345706986]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",23189.703538319991,null,8471.6521133199985,null,19695.902377300008,null,9873.7459827400053,null,61231.004011680008]
[null," 1",26701.688430409995,null,7686.7984485200031,null,18038.100583880001,null,2682.6884969700004,null,55109.275959779996]
[null," 2",33492.140944550003,null,7768.386174569996,null,8366.0671991300005,null,2927.1438226700002,null,52553.738140919995]
[null," 3",4651.0071581500024,null,2198.6388278699992,null,3383.6910189500013,null,748.95302647000005,null,10982.290031440003]
[null," 4",23951.302789309986,null,3831.2697957500018,null,10798.392629389999,null,3109.2031101300022,null,41690.168324579994]
[null," 6",64356.083101760029,null,7079.8836754100012,null,13468.23759966,null,8121.8562966999998,null,93026.060673530024]
[null," 8",18867.700165809987,null,7952.2179079900034,null,5023.1746094100026,null,6620.6895842500007,null,38463.782267459988]
[null," 10",18241.201927969993,null,5951.2408054299967,null,4926.3957889300009,null,3318.8871726399984,null,32437.725694969991]
[null," 15",12820.691411959999,null,6401.6274206499993,null,1947.0420542000004,null,1940.2445376599997,null,23109.605424470003]
[null," 20",365.76778207999996,null,124.06151842000003,null,74.88907189999999,null,80.884555840000019,null,645.60292823999998]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",226637.28725031999,null,57465.776687930003,null,85721.892932750008,null,39424.296586069999,null,409249.25345706992]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",68984.91153274721,null,18254.119195189534,null,33376.372409052041,null,14582.907744009903,null,135198.31088099867]
[null,"20 - 40%",61858.866703090032,null,15049.410309409073,null,27663.863850772716,null,12618.689954825457,null,117190.83081809725]
[null,"40 - 60%",49841.619127701117,null,12263.035638072519,null,18370.696242249211,null,8358.1681419411052,null,88833.519149963962]
[null,"60 - 80%",31585.060663644585,null,7194.8274208110543,null,4086.0139684978444,null,3120.7769547385187,null,45986.679007692001]
[null,"> 80 %",14366.82922373687,null,4704.3841242178451,null,2224.9464623681788,null,743.75379059505553,null,22039.913600917953]
[null,"Total",226637.28725091982,null,57465.776687700018,null,85721.892932939983,null,39424.296586110038,null,409249.25345766993]

{"sheet":"RD 2014 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 2014 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",142990.3740215002,null,45791.143947720091,null,22588.823848590004,null,6919.5144132500045,null,218289.85623106032]
[null," - Number of loans",131996,null,8724,null,3331,null,2250,null,146301]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",99417.416163799993,null,26973.784907689995,null,10114.689581770001,null,3037.4795816300007,null,139543.37023489]
[null," - repayment loans",70376.504911689975,null,24854.925749559992,null,9022.1243724300002,null,1986.9651235700007,null,106240.52015724996]
[null," - interest-only ",29040.911252110007,null,2118.8591581300002,null,1092.5652093399999,null,1050.5144580600002,null,33302.850077640011]
[null,"FlexLån®",37522.70811197997,null,16839.399030219996,null,7976.2843422600017,null,1780.7157132800003,null,64119.107197739977]
[null," - repayment loans",10640.343015009999,null,9467.3652405299927,null,2625.4088842000001,null,446.73636351999983,null,23179.853503259994]
[null," - interest-only ",26882.365096969974,null,7372.0337896900028,null,5350.8754580600016,null,1333.9793497600006,null,40939.253694479979]
[null,"FlexGaranti®, Rentedyk TM",6027.597819540003,null,122.80568697999998,null,55.806902030000003,null,40.125990899999998,null,6246.3363994500032]
[null," - repayment loans",2408.1207174499991,null,75.731506199999984,null,45.215792450000002,null,20.502136529999998,null,2549.5701526299995]
[null," - interest-only ",3619.4771020900039,null,47.074180779999999,null,10.591109579999999,null,19.62385437,null,3696.7662468200042]
[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.65192618,null,1855.1543228300004,null,4442.0430225299988,null,2061.1931274399999,null,8381.0423989800001]
[null," - repayment loans",5.5096148300000003,null,262.21643366000001,null,1262.5349091499997,null,251.38631350999989,null,1781.6472711499998]
[null," - interest-only ",17.14231135,null,1592.9378891700003,null,3179.508113379999,null,1809.8068139299999,null,6599.3951278300001]
[null," Total",142990.37402149994,null,45791.143947719997,null,22588.823848590004,null,6919.51441325,null,218289.85623105991]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",54429.000078989928,null,19353.14306735,null,8028.7745754600001,null,353.25445982999997,null,82164.17218162994]
[null," - Other Sealand",28955.950249919966,null,5093.4553352700013,null,2614.5021280000005,null,1849.2648351199996,null,38513.172548309973]
[null," - Region South Denmark",26145.545591679962,null,7897.203320759998,null,5221.1747875800002,null,2898.8174105600001,null,42162.741110579955]
[null," - Region Central Jutland",24802.542334369984,null,9613.3655054499905,null,4621.8180465799987,null,1147.3317080599995,null,40185.057594459977]
[null," - Region North Jutland",8657.3357665399999,null,3583.1537888899979,null,2068.1848006200003,null,670.84599968000032,null,14979.520355729997]
[null," - Other area",0,null,250.82293000000001,null,34.369510349999999,null,0,null,285.19244035000003]
[null,"Total",142990.37402149985,null,45791.143947719989,null,22588.823848589996,null,6919.51441325,null,218289.85623105988]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",95578.097224980011,null,2054.1866516300011,null,941.18001073000028,null,856.91781152000044,null,99430.381698860016]
[null," 2 - 5",43019.514746099914,null,4265.99208198,null,1841.9214207400003,null,1235.4787603900006,null,50362.907009209914]
[null," 5 - 20",4289.5337829300033,null,15310.818519840004,null,5807.3690169299971,null,2030.9209005700002,null,27438.642220270005]
[null," 20 - 50",103.22826748999999,null,11205.987838159996,null,5527.0646765500023,null,2137.1623218700006,null,18973.443104069996]
[null," 50 - 100",0,null,5514.8633959800027,null,3940.8254127500004,null,590.41590391000011,null,10046.104712640003]
[null," 100 and above",0,null,7439.2954601300007,null,4530.4633108899998,null,68.618714990000015,null,12038.37748601]
[null,"Total",142990.37402149991,null,45791.143947720004,null,22588.82384859,null,6919.5144132500018,null,218289.85623106]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",10980.357000950009,null,4736.8603846399983,null,890.83555686999978,null,514.77270338000005,null,17122.825645840006]
[null," 1",35043.475970139996,null,11258.711772080003,null,4373.831572099999,null,1376.7673503900003,null,52052.786664710009]
[null," 2",39104.097856779983,null,7030.3563343200003,null,3346.3077430099984,null,883.64115585000013,null,50364.403089959989]
[null," 3",6812.6410487700023,null,3205.0709726900013,null,1124.5365309599997,null,154.00291596000008,null,11296.251468380004]
[null," 4",28060.477122839999,null,4131.8176456600031,null,3477.0875519800002,null,809.25610523999978,null,36478.638425720004]
[null," 6",13061.222782480003,null,5237.4568030599958,null,4218.1576233099995,null,1120.6163687000003,null,23637.453577550004]
[null," 8",4576.1953395199989,null,3048.1081323000021,null,4187.2461444200017,null,1744.8501500299994,null,13556.39976627]
[null," 10",3736.1381506799989,null,3671.1694238199998,null,558.67825781999966,null,193.80432909000007,null,8159.7901614099983]
[null," 15",1580.7141017399988,null,3426.6333571599994,null,402.10916090999996,null,119.24182809,null,5528.6984478999975]
[null," 20",35.054647600000003,null,44.959121989999993,null,10.033707210000001,null,2.56150652,null,92.608983320000007]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",142990.37402149997,null,45791.143947720004,null,22588.823848589996,null,6919.5144132500009,null,218289.85623106002]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",43179.081578114427,null,19237.584824253689,null,7478.4195564351312,null,2781.3996190059033,null,72676.485577809159]
[null,"20 - 40%",40165.592215634839,null,11955.260616354588,null,6758.6067379620545,null,2212.2306234155485,null,61091.690193367031]
[null,"40 - 60%",31796.535699203079,null,7144.5050416860777,null,5010.3633330649182,null,1315.7265281530938,null,45267.130602107172]
[null,"60 - 80%",19557.83432932532,null,4033.7760938463575,null,2240.7008924515208,null,498.53934698174811,null,26330.850662604949]
[null,"> 80 %",8291.3301991623521,null,3420.0173715492315,null,1100.7333286863766,null,111.61829569371137,null,12923.699195091671]
[null,"Total",142990.37402144002,null,45791.143947689947,null,22588.823848600005,null,6919.5144132500045,null,218289.85623097999]

{"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,117,35]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q1 2014"]

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

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

{"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 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%",134.71928105795141,null,54.413904568061476,null,47.034267364549784,null,18.865316233086048,null,0.34312379498886891,null,255.0327692236487]
[null," - 20-40%",117.87321436882947,null,36.746672691109914,null,38.401865795782946,null,15.600468702032659,null,0.28068255149255433,null,208.62222155775498]
[null," - 40-60%",91.224100510196791,null,25.96659354970113,null,26.579283860181203,null,9.956333200414603,null,0.20682501084810487,null,153.72631112049373]
[null," - 60-80%",55.882199014542493,null,15.369584505886452,null,7.1969676442581392,null,3.7017178453634934,null,0.11052611306637618,null,82.150469010050571]
[null," - >80%",25.31656598008971,null,12.884621296651392,null,4.6599105825178819,null,0.87464268751323215,null,5.8842529604095598E-2,null,43.735740546772213]
[null,"Total",425.01536093160991,null,145.38137661141039,null,123.87229524728996,null,48.99847866841003,null,0.99999999999999989,null,743.26751145872015]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",68.984911532747205,null,18.254119195189535,null,33.376372409052038,null,14.582907744009903,null,0.33035689066927704,null,135.19831088099869]
[null," - 20-40%",61.858866703090037,null,15.049410309409073,null,27.663863850772717,null,12.618689954825456,null,0.28635563737251574,null,117.19083081809728]
[null," - 40-60%",49.841619127701115,null,12.26303563807252,null,18.37069624224921,null,8.3581681419411051,null,0.21706458447859411,null,88.833519149963948]
[null," - 60-80%",31.585060663644583,null,7.1948274208110545,null,4.086013968497844,null,3.1207769547385187,null,0.11236838826011095,null,45.986679007691997]
[null," - >80%",14.36682922373687,null,4.704384124217845,null,2.2249464623681789,null,0.74375379059505553,null,5.3854499219502222E-2,null,22.039913600917949]
[null,"Total",226.6372872509198,null,57.465776687700021,null,85.72189293293998,null,39.424296586110039,null,1,null,409.24925345766985]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",43.179081578114427,null,19.237584824253688,null,7.4784195564351315,null,2.7813996190059034,null,0.33293569766662762,null,72.67648557780916]
[null," - 20-40%",40.165592215634845,null,11.955260616354588,null,6.7586067379620545,null,2.2122306234155484,null,0.2798649980726719,null,61.091690193367036]
[null," - 40-60%",31.79653569920308,null,7.1445050416860783,null,5.0103633330649187,null,1.3157265281530939,null,0.20737166345562325,null,45.267130602107166]
[null," - 60-80%",19.557834329325321,null,4.0337760938463569,null,2.240700892451521,null,0.49853934698174812,null,0.12062333594990035,null,26.330850662604945]
[null," - >80%",8.2913301991623527,null,3.4200173715492315,null,1.1007333286863765,null,0.11161829569371137,null,5.920430485517688E-2,null,12.923699195091672]
[null,"Total",142.99037402144003,null,45.791143947689939,null,22.588823848600004,null,6.9195144132500053,null,1,null,218.28985623097998]

{"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 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%",48.069363779113303,null,187.17326181862475,null,19.79014362591073,null,255.03276922364878]
[null," - 20-40%",33.336912601976572,null,156.87590945143151,null,18.409399504347192,null,208.62222155775527]
[null," - 40-60%",21.409255230487751,null,116.65556262303068,null,15.661493266975242,null,153.72631112049368]
[null," - 60-80%",10.160999500005374,null,61.688635660403975,null,10.300833849641013,null,82.150469010050358]
[null," - >80%",8.229135897984964,null,27.51626038037816,null,7.990344268409137,null,43.735740546772263]
[null,"Total",121.20566700956796,null,549.90962993386904,null,72.152214515283305,null,743.26751145872026]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",17.703303756817245,null,104.22905666063306,null,13.265950463548412,null,135.19831088099872]
[null," - 20-40%",13.647627379458374,null,91.01475978435262,null,12.528443654286331,null,117.19083081809733]
[null," - 40-60%",9.1603066278125596,null,68.75612429576266,null,10.917088226388756,null,88.833519149963976]
[null," - 60-80%",4.0649636600035457,null,34.852343553866667,null,7.0693717938218157,null,45.986679007692032]
[null," - >80%",2.5127317637916184,null,14.698590972197811,null,4.8285908649285085,null,22.039913600917938]
[null,"Total",47.088933187883342,null,313.5508752668128,null,48.609445002973821,null,409.24925345766997]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",13.95396921989925,null,54.799093679435877,null,3.9234226784740329,null,72.67648557780916]
[null," - 20-40%",10.109374779232754,null,47.253507635482769,null,3.7288077786515088,null,61.091690193367029]
[null," - 40-60%",6.3022454492143689,null,35.782349017630473,null,3.1825361352623389,null,45.26713060210718]
[null," - 60-80%",3.1296087477234007,null,20.98590527891557,null,2.2153366359659987,null,26.330850662604966]
[null," - >80%",2.0453559898669047,null,8.9931903612700843,null,1.8851528439546825,null,12.923699195091672]
[null,"Total",35.540554185936678,null,167.81404597273476,null,14.935256072308562,null,218.28985623098001]

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

{"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",45791143947.720093,45540321017.720085]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",22588823848.589996,22554454338.239994]
["S-Landbrug","S",null,"Landbrug",6919514413.2499971,6919514413.2499971]
["S-Privat","S",null,"Privat",142990374021.50009,142990374021.50009]
["S Total-","S Total","S Total",null,218289856231.06018,218004663790.71017]
["T-Boligudl","T","T","Boligudl",57465776687.93,56652322789.060013]
["T-Erhverv","T",null,"Erhverv",85721892932.749924,76303743845.479996]
["T-Landbrug","T",null,"Landbrug",39424296586.070015,39424296586.070015]
["T-Privat","T",null,"Privat",226637287250.31976,226637287250.31976]
["T Total-","T Total","T Total",null,409249253457.0697,399017650470.92981]
["Ø-Boligudl","Ø","Ø","Boligudl",42124455975.949997,41926630052.390007]
["Ø-Erhverv","Ø",null,"Erhverv",15561578465.819992,15266041456.919992]
["Ø-Landbrug","Ø",null,"Landbrug",2654667668.9000006,2654667668.9000006]
["Ø-Privat","Ø",null,"Privat",55387699659.40004,55387699659.40004]
["Ø Total-","Ø Total","Ø Total",null,115728401770.07004,115235038837.61005]
["Grand Total-","Grand Total","Grand Total",null,743267511458.19983,732257353099.25]
[]
[]
[]
[]
[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":226637287250.31976}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":56652322789.060013}]
[null,null,"T-Erhverv","Erhverv","Commercial",76303743845.479996]
[null,null,"T-Landbrug","Landbrug","Agriculture",39424296586.070015]
[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":10231602986.139954}]
[]
[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":142990374021.50009}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":45540321017.720085}]
[null,null,"S-Erhverv","Erhverv","Commercial",22554454338.239994]
[null,null,"S-Landbrug","Landbrug","Agriculture",6919514413.2499971]
[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":285192440.3500061}]
[]
[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":55387699659.40004}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":41926630052.390007}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",15266041456.919992]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2654667668.9000006]
[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":493362932.46000671}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":425015360931.21985}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":144119273859.1701}]
[null,null,null,null,"Commercial",114124239640.63998]
[null,null,null,null,"Agriculture",48998478668.220016]
[null,null,null,null,"Nordic",11010158358.949966]