{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2015 Q1 Total","RD 2015 Q1 Cap T","RD 2015 Q1 Cap S","Repossed Properties - Year","Repossed Properties - Quarter","LTV","LTV - Sectors","LTV - Classification","3m arrears","Borrower segmentation Nordic","Borrower Exposure to Int. rate"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":2},"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 2015 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 2015 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",431746.68332269142,null,148701.37167870044,null,123810.41767951981,null,48498.946568310042,null,752757.41924922168]
[null," - Number of loans",415394,null,39748,null,15037,null,14883,null,485062]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",142371.81000241992,null,65601.294786760016,null,13429.725207609996,null,5672.094880579999,null,227074.92487736992]
[null," - repayment loans",107277.68101436994,null,62798.703854140018,null,12103.809087199996,null,3781.7765645999989,null,185961.97052030993]
[null," - interest-only ",35094.128988049983,null,2802.5909326199999,null,1325.9161204100001,null,1890.3183159800001,null,41112.954357059993]
[null,"FlexLån®",252703.06325643952,null,63636.668402830044,null,45847.724396940001,null,26731.174320849997,null,388918.63037705957]
[null," - repayment loans",90940.702110360144,null,38570.176628660025,null,17751.308118329984,null,8017.6119121399961,null,155279.79876949015]
[null," - interest-only ",161762.36114607938,null,25066.491774170023,null,28096.416278610017,null,18713.562408710004,null,233638.83160756939]
[null,"FlexGaranti®, Rentedyk TM",23292.260607690008,null,779.21863383000004,null,375.69688354999982,null,414.08883955000005,null,24861.264964620012]
[null," - repayment loans",10970.820294130002,null,437.73217791000002,null,263.44566118999984,null,194.34330908000004,null,11866.341442310004]
[null," - interest-only ",12321.44031356001,null,341.48645592000003,null,112.25122236,null,219.74553047000001,null,12994.92352231001]
[null,"FlexKort®",13256.999613239997,null,2868.3559278000002,null,2508.1696056800001,null,7019.8015187999972,null,25653.326665519995]
[null," - repayment loans",3880.7814455800012,null,900.08836025999994,null,1434.8094521200005,null,1511.9708225100001,null,7727.6500804700017]
[null," - interest-only ",9376.2181676599957,null,1968.2675675400003,null,1073.3601535599996,null,5507.8306962899969,null,17925.676585049994]
[null,"Other floating rate loans",122.54984289999999,null,15815.833927479995,null,61649.101585740005,null,8661.7870085299983,null,86249.272364649994]
[null," - repayment loans",25.62324108,null,3465.4238519400001,null,18578.461706100017,null,1652.7949046899996,null,23722.303703810016]
[null," - interest-only ",96.926601819999988,null,12350.410075539994,null,43070.639879639995,null,7008.9921038399998,null,62526.968660839979]
[null," Total",431746.68332268944,null,148701.37167870003,null,123810.41767952002,null,48498.946568309999,null,752757.41924921959]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",176087.3700600602,null,54529.918940269919,null,46439.139479459969,null,3367.7784919499964,null,280424.20697174012]
[null," - Other Sealand",87759.385574619751,null,17299.462948210003,null,10597.825374569997,null,13307.674553130015,null,128964.34845052977]
[null," - Region South Denmark",71189.401972969936,null,27345.330335810027,null,25616.413050289953,null,16465.810556450004,null,140616.95591551994]
[null," - Region Central Jutland",72860.853663020214,null,34458.870068330012,null,21217.924638010038,null,9238.0614879799978,null,137775.70985734026]
[null," - Region North Jutland",23847.79223216002,null,13619.776647629984,null,6793.4762857899968,null,6119.621478799997,null,50380.666644379999]
[null," - Other area",1.8798198599999998,null,1448.0127384500004,null,13145.638851400003,null,0,null,14595.531409710004]
[null,"Total",431746.68332269014,null,148701.37167869994,null,123810.41767951996,null,48498.946568310006,null,752757.41924922005]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",263209.93418673973,null,9597.7540438199849,null,4091.3830019200104,null,3471.598424570001,null,280370.66965704976]
[null," 2 - 5",146487.06205621944,null,13180.687588709987,null,6373.6746062399907,null,6989.8380588999999,null,173031.26231006943]
[null," 5 - 20",21306.66056854001,null,44553.795477520005,null,21642.995116700044,null,15798.029539630015,null,103301.48070239008]
[null," 20 - 50",631.43030642999997,null,35016.903386450009,null,19887.16869951001,null,14639.070352840012,null,70174.572745230034]
[null," 50 - 100",111.59620476000001,null,20877.64345858002,null,17036.726953469988,null,6353.838128299999,null,44379.804745110014]
[null," 100 and above",0,null,25474.587723619989,null,54778.469301680001,null,1246.5720640700001,null,81499.629089369992]
[null,"Total",431746.68332268926,null,148701.37167869997,null,123810.41767952005,null,48498.946568310021,null,752757.41924921924]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",71703.295412149891,null,16506.394425450017,null,14725.781560869997,null,5690.8226988199985,null,108626.29409728988]
[null," 1",55957.800737609999,null,17623.897432949991,null,25224.666834439988,null,11118.600718929996,null,109924.96572392996]
[null," 2",49555.157095640017,null,16644.44247970001,null,19950.759224900019,null,3355.40294038,null,89505.761740620044]
[null," 3",25905.918206209994,null,5749.6235807400053,null,3315.5818601199985,null,1263.3434436900002,null,36234.467090760001]
[null," 4",38338.244836160033,null,10468.947129789996,null,10528.89983437,null,2468.1277867199992,null,61804.219587040032]
[null," 6",85877.861367270016,null,10926.65302292,null,15682.351241589991,null,5951.7968938199974,null,118438.66252560001]
[null," 8",34840.161757989968,null,12980.094209429997,null,20732.55458874999,null,10275.184843929988,null,78827.995400099942]
[null," 10",43581.714743099961,null,13780.671532769997,null,10250.734043380009,null,5506.4921472499918,null,73119.612466499952]
[null," 15",23739.08225089997,null,15060.740477609977,null,2898.0002747999997,null,2514.9266335499983,null,44212.749636859946]
[null," 20",1833.2594435100004,null,15317.175960829998,null,389.6919996499999,null,204.66740663000002,null,17744.794810619998]
[null," 25",337.34110559999999,null,13055.058801519994,null,43.793326779999994,null,15.138291839999999,null,13451.331525739994]
[null," 30",76.846366550000027,null,587.67262499000003,null,67.602889869999998,null,134.44276275000004,null,866.56464416000006]
[null,"Total",431746.68332268985,null,148701.37167869997,null,123810.41767951997,null,48498.946568309962,null,752757.41924921994]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",138930.95202157329,null,56321.061248346537,null,44569.355854728419,null,18917.50994032931,null,258738.87906497758]
[null,"20 - 40%",121517.72411090185,null,38412.032328550878,null,38747.673277760441,null,15618.439024169504,null,214295.86874138267]
[null,"40 - 60%",93151.734398011613,null,26437.417472035038,null,27671.788245037998,null,9732.6495224151331,null,156993.5896374998]
[null,"60 - 80%",54645.517282709392,null,15029.100961111011,null,7987.7741758207685,null,3444.8571032112845,null,81107.249522852449]
[null,"> 80 %",23500.755509703631,null,12501.759668996661,null,4833.8261256624573,null,785.49097843470645,null,41621.832282797463]
[null,"Total",431746.6833228998,null,148701.37167904014,null,123810.41767901009,null,48498.946568559935,null,752757.41924950993]

{"sheet":"RD 2015 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 2015 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",243619.69242328996,null,64878.459480370017,null,89995.762928839889,null,38408.372410530043,null,436902.28724302992]
[null," - Number of loans",214700,null,15944,null,9089,null,10823,null,250556]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",13.691691899999999,null,6.7909956900000008,null,0,null,33.811211129999997,null,54.293898720000001]
[null," - repayment loans",2.8798356699999998,null,0,null,0,null,18.011502539999999,null,20.891338210000001]
[null," - interest-only ",10.811856229999998,null,6.7909956900000008,null,0,null,15.79970859,null,33.402560510000001]
[null,"FlexLån®",230266.60132222009,null,49656.568003390057,null,36935.426794670006,null,24990.328510500014,null,341848.92463078018]
[null," - repayment loans",84710.064456970096,null,31814.676059100042,null,15913.129604780013,null,7685.4435677000029,null,140123.31368855014]
[null," - interest-only ",145556.53686525,null,17841.891944290015,null,21022.297189889992,null,17304.884942800014,null,201725.61094223001]
[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®",13256.999613239997,null,2868.3559278000007,null,2508.1696056800001,null,7019.8015187999972,null,25653.326665519995]
[null," - repayment loans",3880.7814455800012,null,900.08836026000006,null,1434.8094521200007,null,1511.9708225100007,null,7727.6500804700036]
[null," - interest-only ",9376.2181676599957,null,1968.2675675400008,null,1073.3601535599994,null,5507.830696289996,null,17925.676585049991]
[null,"Other floating rate loans",82.39979593000001,null,12346.744553489996,null,50552.166528490023,null,6364.4311700999988,null,69345.742048010012]
[null," - repayment loans",18.408678350000002,null,3064.7157930100002,null,15870.243446940003,null,1326.5250956400002,null,20279.893013940004]
[null," - interest-only ",63.991117580000001,null,9282.028760479996,null,34681.92308155002,null,5037.9060744599983,null,49065.849034070015]
[null," Total",243619.69242329008,null,64878.459480370053,null,89995.76292884002,null,38408.372410530013,null,436902.28724303015]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",106357.72295600994,null,21657.576974579984,null,32625.46192701003,null,2837.971900670002,null,163478.73375826995]
[null," - Other Sealand",48004.20737129997,null,6664.2238920499931,null,6876.3165504900062,null,10648.212420590004,null,72192.960234429978]
[null," - Region South Denmark",35926.561137890014,null,12588.444658640014,null,18796.956959900017,null,12355.898494830004,null,79667.861251260052]
[null," - Region Central Jutland",40890.651325090061,null,16258.804878529989,null,14415.351379640008,null,7527.4389629999978,null,79092.246546260052]
[null," - Region North Jutland",12440.549632999995,null,6726.6270578599961,null,4480.3284155600004,null,5038.8506314399956,null,28686.355737859987]
[null," - Other area",0,null,982.78201870999987,null,12801.34769624,null,0,null,13784.129714949999]
[null,"Total",243619.69242328999,null,64878.459480369973,null,89995.762928840079,null,38408.372410530006,null,436902.28724303009]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",134050.28038385004,null,5541.336790300008,null,2230.550766099997,null,2041.3003171299986,null,143863.46825738007]
[null," 2 - 5",93349.209205800071,null,6267.4084569500028,null,4118.7277257700007,null,5186.4480504899993,null,108921.79343901007]
[null," 5 - 20",15734.380740090006,null,17694.004734099981,null,14782.082860770011,null,12945.081564560005,null,61155.549899520003]
[null," 20 - 50",463.04131952000006,null,13421.213074530006,null,13457.324141719999,null,12004.793650980006,null,39346.372186750006]
[null," 50 - 100",22.780774029999996,null,10085.983438199994,null,11028.335669950005,null,5332.5320094800027,null,26469.631891660003]
[null," 100 and above",0,null,11868.51298629001,null,44378.741764529994,null,898.21681789000002,null,57145.471568709996]
[null,"Total",243619.69242329008,null,64878.459480369995,null,89995.762928839991,null,38408.372410530013,null,436902.28724303021]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",17592.225166179986,null,5626.8113687200012,null,7666.4850699799972,null,2773.8304570099995,null,33659.352061889978]
[null," 1",33987.208055849995,null,11796.819605499993,null,23825.621752740015,null,10221.740660920001,null,79831.390075010015]
[null," 2",24413.895086650005,null,7135.0340760299987,null,16723.899759650001,null,2386.19802854,null,50659.02695087]
[null," 3",11530.833471919996,null,3156.4208999699995,null,2356.2162088700006,null,910.69183356000019,null,17954.162414319995]
[null," 4",25107.96424727,null,6486.2558883100028,null,8000.8409006299989,null,2206.3471461599993,null,41801.408182369996]
[null," 6",67435.327711239996,null,7243.8305936400002,null,13664.037766089998,null,5349.9719758600004,null,93693.168046830004]
[null," 8",27471.99295745002,null,5551.177112839996,null,9699.1608334699995,null,7588.6853672700026,null,50311.016271030021]
[null," 10",16881.426954480015,null,8162.6274965599969,null,5665.5514056599995,null,4511.64722833,null,35221.253085030017]
[null," 15",18364.594644220015,null,9426.2260237799819,null,2193.1479725100003,null,2289.7520609800008,null,32273.720701490001]
[null," 20",834.2241280300002,null,293.25641502000002,null,200.80125924000004,null,169.50765189999998,null,1497.78945419]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",243619.69242329002,null,64878.459480369973,null,89995.762928840006,null,38408.372410530006,null,436902.28724303003]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",76847.624527942215,null,20799.472796954546,null,33541.33187285997,null,14686.55251504001,null,145874.98171279675]
[null,"20 - 40%",67905.984954208674,null,17675.682618011939,null,29518.223109929972,null,12309.232519659983,null,127409.12320181058]
[null,"40 - 60%",53220.745334289604,null,13852.185958687824,null,19928.017813950013,null,7890.1859280299905,null,94891.135034957435]
[null,"60 - 80%",31644.649230897092,null,7669.5143990977494,null,4875.3419141800032,null,2875.1911355900002,null,47064.696679764842]
[null,"> 80 %",14000.68837610228,null,4881.6037080378646,null,2132.8482174100013,null,647.2103123199995,null,21662.350613870145]
[null,"Total",243619.69242343988,null,64878.459480789927,null,89995.762928329976,null,38408.372410639975,null,436902.28724319971]

{"sheet":"RD 2015 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 2015 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",152244.84867208963,null,45278.267986620005,null,21240.792200040014,null,7894.0712251399973,null,226657.98008388962]
[null," - Number of loans",137359,null,8823,null,3243,null,2422,null,151847]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",126857.93014084006,null,32167.426045510027,null,11933.359765499992,null,4884.6990713799987,null,175843.41502323007]
[null," - repayment loans",94215.445097830045,null,29478.294334200025,null,10658.156309299991,null,3139.0894592100003,null,137490.98520054008]
[null," - interest-only ",32642.485043010016,null,2689.1317113099994,null,1275.2034561999999,null,1745.6096121699986,null,38352.429822690014]
[null,"FlexLån®",19738.24021978,null,11240.366388269997,null,5130.3723596399996,null,1019.2803711899999,null,37128.259338879994]
[null," - repayment loans",5184.6978146500014,null,6262.0141135599979,null,1617.5236149900002,null,251.57427542999989,null,13315.809818629999]
[null," - interest-only ",14553.54240513,null,4978.3522747099987,null,3512.8487446499998,null,767.70609576000004,null,23812.449520249997]
[null,"FlexGaranti®, Rentedyk TM",5627.6827206400012,null,121.43842227,null,54.441698340000016,null,32.366535219999996,null,5835.9293764700014]
[null," - repayment loans",2230.72769543,null,73.983436060000002,null,43.740391590000016,null,18.560934870000001,null,2367.0124579499998]
[null," - interest-only ",3396.9550252100016,null,47.454986210000001,null,10.701306750000001,null,13.805600349999997,null,3468.9169185200012]
[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",20.995590829999998,null,1749.0371305700005,null,4122.6183765600008,null,1957.7252473499993,null,7850.37634531]
[null," - repayment loans",5.2063211699999998,null,259.41028687000005,null,1030.6649922099998,null,225.71335925,null,1520.9949595]
[null," - interest-only ",15.789269659999999,null,1489.6268437000003,null,3091.9533843500008,null,1732.0118880999994,null,6329.3813858100002]
[null," Total",152244.84867209007,null,45278.26798662002,null,21240.792200039992,null,7894.0712251399991,null,226657.98008389008]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",58612.837881059953,null,20645.498924090018,null,8146.2866357799976,null,413.27804911000004,null,87817.901490039963]
[null," - Other Sealand",30389.545431400016,null,4895.9600498299978,null,2527.0372691400012,null,1946.9825278200005,null,39759.525278190013]
[null," - Region South Denmark",28163.410692079997,null,7313.9564178499959,null,4511.5856713800013,null,3411.9083375999999,null,43400.861118909997]
[null," - Region Central Jutland",26112.965332720029,null,9054.2344067400045,null,4275.9025838499983,null,1254.3516716199999,null,40697.453994930031]
[null," - Region North Jutland",8966.0893348299869,null,3115.4033482400009,null,1745.2827733299998,null,867.55063899000038,null,14694.326095389988]
[null," - Other area",0,null,253.21483986999999,null,34.697266560000003,null,0,null,287.91210642999999]
[null,"Total",152244.84867208995,null,45278.26798662002,null,21240.792200039996,null,7894.0712251400009,null,226657.98008389]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100096.22988796023,null,2123.5638806399998,null,1043.5867690800001,null,909.13562380999986,null,104172.51616149023]
[null," 2 - 5",46851.022152899975,null,4381.0208592500003,null,1763.5499063500006,null,1390.6313095300004,null,54386.224228029976]
[null," 5 - 20",5098.20805655,null,14777.298307200004,null,5475.2440788799959,null,2344.9347042000013,null,27695.685146830001]
[null," 20 - 50",163.22423704999997,null,10538.25875760001,null,5334.9031250399994,null,2346.8349572899997,null,18383.221076980008]
[null," 50 - 100",36.164337630000006,null,5547.8425871700019,null,3776.2320028299991,null,864.28898052999989,null,10224.527908160002]
[null," 100 and above",0,null,7910.2835947600015,null,3847.2763178599998,null,38.245649780000001,null,11795.805562400001]
[null,"Total",152244.84867209021,null,45278.26798662002,null,21240.792200039996,null,7894.0712251399991,null,226657.98008389023]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",52088.095910640033,null,10389.897585860002,null,6280.0243836799982,null,2428.4800530799998,null,71186.49793326002]
[null," 1",21970.592681759998,null,5827.0778274499999,null,1340.43994456,null,896.86005800999999,null,30034.97051178]
[null," 2",25140.508341429995,null,9508.4337152099997,null,2712.1162622400002,null,969.20491183999991,null,38330.263230720004]
[null," 3",14375.084734290009,null,2593.2026807699981,null,827.90617100999987,null,352.65161013000005,null,18148.845196200007]
[null," 4",13228.648494999998,null,3977.6136274500004,null,1062.6837488299996,null,261.78064055999994,null,18530.726511839996]
[null," 6",18437.072015750015,null,3674.0184822799979,null,2010.4120040499997,null,551.65879581999991,null,24673.161297900013]
[null," 8",3712.5451402200015,null,4860.4650748699996,null,5990.6073464100009,null,2215.7042227599995,null,16779.321784260002]
[null," 10",2281.8317413600003,null,1557.1758479500004,null,778.27242650999995,null,134.69422797999999,null,4751.9742438000003]
[null," 15",959.27158917999998,null,2772.9926540499982,null,228.01588908000002,null,79.462470019999998,null,4039.7426023299981]
[null," 20",51.198022460000004,null,117.39049073000001,null,10.314023669999999,null,3.5742349399999997,null,182.47677179999999]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",152244.84867209004,null,45278.267986619998,null,21240.792200039996,null,7894.0712251399982,null,226657.98008389003]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",47663.953784480218,null,20506.348150442911,null,6755.6068377937681,null,2980.5223493799986,null,77906.43112209691]
[null,"20 - 40%",43692.395556893454,null,11811.431207091142,null,6424.5652732205081,null,2670.8854324700014,null,64599.277469675108]
[null,"40 - 60%",33693.772531141214,null,6570.9875312371878,null,5074.0326718356664,null,1623.8259838700003,null,46962.618718084072]
[null,"60 - 80%",19752.36084896588,null,3514.0851740510866,null,1995.9867268918445,null,504.58549939000045,null,25767.018249298813]
[null,"> 80 %",7442.3659504392672,null,2875.4159237976446,null,990.6006900882129,null,114.25196011999999,null,11422.634524445126]
[null,"Total",152244.84867192004,null,45278.267986619969,null,21240.792199829997,null,7894.0712252300018,null,226657.98008360004]

{"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,70,108]
[null,"2015*",67,20]
[]
[]
[]
[]
[]
[]
[null,"*Q1 2015"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":54,"n_cols":5,"rows_kept":54,"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]
[null,"2014 Q3",57,14,71]
[null,"2014 Q4",56,14,{"$f":"C53+D53","v":70}]
[null,"2015 Q1",53,14,67]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":42,"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","2014 Q3","2014 Q4","2015 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,72.239999999999995,72.575999999999993,72.349999999999994,72.150000000000006]
[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,59.878,60.38,60.5]
[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,59.557000000000002,59.78,58.63]
[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,76.644000000000005,78.349999999999994,75.760000000000005]
[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,70.62,70.91,70.25]

{"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 2015 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%",138.93095202157329,null,56.321061248346538,null,44.569355854728414,null,18.91750994032931,null,0.34372145986011943,null,258.73887906497754]
[null," - 20-40%",121.51772411090185,null,38.412032328550879,null,38.747673277760441,null,15.618439024169504,null,0.28468117784216995,null,214.29586874138266]
[null," - 40-60%",93.151734398011612,null,26.437417472035037,null,27.671788245037998,null,9.7326495224151319,null,0.20855801035348212,null,156.99358963749978]
[null," - 60-80%",54.645517282709392,null,15.029100961111011,null,7.9877741758207685,null,3.4448571032112847,null,0.10774686166987954,null,81.10724952285247]
[null," - >80%",23.500755509703634,null,12.501759668996662,null,4.8338261256624575,null,0.7854909784347065,null,5.5292490274348828E-2,null,41.621832282797456]
[null,"Total",431.74668332289986,null,148.70137167904014,null,123.81041767901009,null,48.498946568559937,null,0.99999999999999978,null,752.75741924950989]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",76.847624527942216,null,20.799472796954543,null,33.541331872859971,null,14.68655251504001,null,0.33388468307925351,null,145.87498171279674]
[null," - 20-40%",67.905984954208677,null,17.67568261801194,null,29.51822310992997,null,12.309232519659982,null,0.29161926344159611,null,127.40912320181059]
[null," - 40-60%",53.220745334289603,null,13.852185958687825,null,19.928017813950014,null,7.8901859280299904,null,0.21719074906590427,null,94.891135034957429]
[null," - 60-80%",31.644649230897091,null,7.6695143990977499,null,4.8753419141800034,null,2.8751911355900002,null,0.10772362162884828,null,47.064696679764843]
[null," - >80%",14.00068837610228,null,4.8816037080378649,null,2.1328482174100016,null,0.64721031231999948,null,4.9581682784397715E-2,null,21.662350613870146]
[null,"Total",243.61969242343989,null,64.878459480789928,null,89.995762928329953,null,38.408372410639984,null,0.99999999999999989,null,436.90228724319974]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",47.663953784480213,null,20.506348150442911,null,6.7556068377937679,null,2.9805223493799988,null,0.34371801554642828,null,77.906431122096876]
[null," - 20-40%",43.692395556893459,null,11.811431207091143,null,6.4245652732205079,null,2.6708854324700013,null,0.28500773476340191,null,64.599277469675116]
[null," - 40-60%",33.693772531141214,null,6.5709875312371873,null,5.074032671835667,null,1.6238259838700004,null,0.20719596416046093,null,46.962618718084066]
[null," - 60-80%",19.752360848965882,null,3.514085174051087,null,1.9959867268918445,null,0.50458549939000041,null,0.11368237835612476,null,25.767018249298811]
[null," - >80%",7.4423659504392674,null,2.8754159237976444,null,0.99060069008821283,null,0.11425196012,null,5.0395907173583852E-2,null,11.422634524445126]
[null,"Total",152.24484867192004,null,45.278267986619973,null,21.240792199829997,null,7.8940712252300012,null,0.99999999999999978,null,226.65798008359999]

{"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 2015 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%",53.795637530254062,null,185.91105925738913,null,19.032182277333732,null,258.73887906497691]
[null," - 20-40%",37.481998766283354,null,159.09692894544528,null,17.716941029654127,null,214.29586874138275]
[null," - 40-60%",23.521319754756636,null,118.62777439354667,null,14.844495489196884,null,156.99358963750018]
[null," - 60-80%",10.962012139623543,null,60.667503187094169,null,9.4777341961349588,null,81.107249522852669]
[null," - >80%",7.8873845256808828,null,26.337616596215671,null,7.3968311609008923,null,41.621832282797449]
[null,"Total",133.64835271659848,null,550.64088237969099,null,68.468184153220591,null,752.75741924951012]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",23.015147031419019,null,109.41990687084666,null,13.439927810531355,null,145.87498171279702]
[null," - 20-40%",17.774514580455133,null,96.953129085331483,null,12.68147953602398,null,127.4091232018106]
[null," - 40-60%",10.953049002946646,null,73.16723472163774,null,10.770851310373029,null,94.891135034957415]
[null," - 60-80%",4.7436745311415507,null,35.651755200887479,null,6.6692669477357569,null,47.064696679764786]
[null," - >80%",2.4116517567612319,null,14.57123019139526,null,4.6794686657136246,null,21.662350613870117]
[null,"Total",58.898036902723575,null,329.76325607009863,null,48.24099427037774,null,436.90228724319991]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",16.666060940881749,null,57.66323177464799,null,3.5771384065671543,null,77.90643112209689]
[null," - 20-40%",11.499757490147685,null,49.642730258538201,null,3.4567897209891441,null,64.59927746967503]
[null," - 40-60%",7.2559492475717722,null,36.810249048613194,null,2.8964204218991565,null,46.962618718084123]
[null," - 60-80%",3.2878447969895586,null,20.495474389011193,null,1.9836990632980234,null,25.767018249298776]
[null," - >80%",1.76277345515141,null,8.0427318188308075,null,1.617129250462904,null,11.422634524445121]
[null,"Total",40.472385930742178,null,172.6544172896414,null,13.531176863216382,null,226.65798008359997]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":42,"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","2014 Q3","2014 Q4","2015 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,0.20374765009047413,0.19533888718789549,0.17754809588439302,0.19590249468675333]
[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,0.76492280361307252,0.77897538655254928,1.194715258404901]
[null,"Agriculture",0.28733545754687229,0.28591425530114489,0.16350323367431957,0.34527555313816655,0.10247036587855575,0.17964818144364114,9.0458945241985167E-2,0.19224824892179651,0.1036179997289654,0.12911678565215878,0.23066720688136241,0.12560081599500431,0.155178149616685,0.19101387683898366,0.35126666024992187,0.41759999999999997,0.67417569609969485,0.74819999999999998,0.97440000000000004,1.2005999999999999,1.1135999999999999,1.0788,0.8004,1.0091999999999999,1.2702,1.0149245999999998,0.97440000000000004,0.91878692992583044,0.98849890507143101,0.91578392565633737,0.81872886685764001,0.7178725419523122,0.80576132165605641,0.54730814983061826,0.76559999999999995,0.73217624928661695,0.7172187732310964,0.70912650774595554,1.0035221517145021,0.81239218354143794]
[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,0.37687573473480396,0.55809173343292406,0.26507511901436809]
[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,0.33338691074415494,0.38091100597796013,0.38906956469991866]

{"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",45278267986.620003,45025053146.750015]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21240792200.039997,21206094933.479996]
["S-Landbrug","S",null,"Landbrug",7894071225.1399965,7894071225.1399965]
["S-Privat","S",null,"Privat",152244848672.08929,152244848672.08929]
["S Total-","S Total","S Total",null,226657980083.88928,226370067977.45929]
["T-Boligudl","T","T","Boligudl",64878459480.370018,63895761865.939995]
["T-Erhverv","T",null,"Erhverv",89995762928.839645,77194415232.59964]
["T-Landbrug","T",null,"Landbrug",38408372410.530037,38408372410.530037]
["T-Privat","T",null,"Privat",243619692423.28967,243619692423.28967]
["T Total-","T Total","T Total",null,436902287243.02936,423118241932.35937]
["Ø-Boligudl","Ø","Ø","Boligudl",38544644211.709938,38344066094.029953]
["Ø-Erhverv","Ø",null,"Erhverv",12573862550.640015,12276771115.600012]
["Ø-Landbrug","Ø",null,"Landbrug",2196502932.6399999,2196502932.6399999]
["Ø-Privat","Ø",null,"Privat",35882142227.310028,35882142227.310028]
["Ø Total-","Ø Total","Ø Total",null,89197151922.299988,88699482369.579987]
["Grand Total-","Grand Total","Grand Total",null,752757419249.21875,738187792279.39856]
[]
[]
[]
[]
[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":243619692423.28967}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":63895761865.939995}]
[null,null,"T-Erhverv","Erhverv","Commercial",77194415232.59964]
[null,null,"T-Landbrug","Landbrug","Agriculture",38408372410.530037]
[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":13784045310.669983}]
[]
[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":152244848672.08929}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":45025053146.750015}]
[null,null,"S-Erhverv","Erhverv","Commercial",21206094933.479996]
[null,null,"S-Landbrug","Landbrug","Agriculture",7894071225.1399965]
[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":287912106.43002319}]
[]
[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":35882142227.310028}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":38344066094.029953}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",12276771115.600012]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2196502932.6399999]
[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":497669552.72000122}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":431746683322.68896}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":147264881106.71997}]
[null,null,null,null,"Commercial",110677281281.67964]
[null,null,null,null,"Agriculture",48498946568.310036]
[null,null,null,null,"Nordic",14569626969.820007]

{"sheet":"Borrower Exposure to Int. rate","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
["Sum af kormar",null,"sektor2"]
["afdr_fri","prodtyp2","Privat","Erhverv"]
["J","CapFloat",12321440313.440001,673483208.76999998]
[null,"F1",34698932235.760002,16167923291.98]
[null,"F3",55129807438.419998,14755572248.209999]
[null,"F5",53749757709.709999,18967319028.759998]
[null,"Fixed",35094128988.029999,6018825369.0200005]
[null,"Floaters",9473144769.5400009,70979500476.460007]
[null,"Øv. flex",18183863762.169998,21985655892.709999]
["J Total",null,218651075217.07001,149548279515.91]
["N","CapFloat",10970820294.190001,895521148.19000006]
[null,"F1",20656749613.849998,12039279145.76]
[null,"F3",32060181231.919998,9931873378.0100002]
[null,"F5",31822139670.27,36137264745.860001]
[null,"Fixed",107277681014.16,78684289506.050003]
[null,"Floaters",3906404686.6799998,27543549097.560001]
[null,"Øv. flex",6401631594.2700005,6230679389.0900002]
["N Total",null,213095608105.34,171462456410.51999]