{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2016 Q2 Total","RD 2016 Q2 Cap T","RD 2016 Q2 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 2016 Q2 Total","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",434986.46348059981,null,153058.08695630945,null,126836.57653294018,null,48546.196192349998,null,763427.32316219935]
[null," - Number of loans",412194,null,37837,null,14195,null,14472,null,478698]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",150729.93605377001,null,70723.770851480018,null,14405.469458990008,null,5931.008760380003,null,241790.18512462007]
[null," - repayment loans",113180.82049013999,null,67189.774398430018,null,13191.361536180008,null,3888.1652973800028,null,197450.12172213002]
[null," - interest-only ",37549.115563630032,null,3533.9964530500006,null,1214.1079228099995,null,2042.8434629999997,null,44340.063402490036]
[null,"FlexLån®",248528.12575082004,null,62134.54866508003,null,44005.901586480009,null,25779.658215040006,null,380448.23421742005]
[null," - repayment loans",93545.970583469883,null,37722.812016410026,null,20595.401280020003,null,8012.2794547600024,null,159876.4633346599]
[null," - interest-only ",154982.15516735017,null,24411.736648670001,null,23410.500306460006,null,17767.378760280004,null,220571.77088276017]
[null,"FlexGaranti®, Rentedyk TM",19060.70408299999,null,587.41194532999975,null,335.00734946000006,null,327.22894481000009,null,20310.352322599992]
[null," - repayment loans",12129.331671959992,null,472.89861780999979,null,311.09719304000004,null,222.68907240000004,null,13136.016555209992]
[null," - interest-only ",6931.372411039998,null,114.51332752000003,null,23.910156419999996,null,104.53987241,null,7174.3357673899982]
[null,"FlexKort®",16542.972474149999,null,2605.1190519699999,null,2607.2143313700012,null,8320.737504140001,null,30076.04336163]
[null," - repayment loans",4964.9921140100023,null,1240.7374631599994,null,1393.6250443600009,null,2013.8879550499996,null,9613.2425765800017]
[null," - interest-only ",11577.980360139998,null,1364.3815888100005,null,1213.5892870100004,null,6306.8495490900023,null,20462.80078505]
[null,"Other floating rate loans",124.72511886000001,null,17007.236442449986,null,65482.983806640055,null,8187.5627679800009,null,90802.508135930053]
[null," - repayment loans",33.56268068,null,4427.1612539999978,null,22222.652636610015,null,1866.8009969299997,null,28550.177568220017]
[null," - interest-only ",91.162438180000024,null,12580.075188449988,null,43260.33117003004,null,6320.7617710500008,null,62252.330567710029]
[null," Total",434986.46348060004,null,153058.08695631003,null,126836.57653294006,null,48546.196192350013,null,763427.32316220016]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",182799.08419323014,null,56580.613138499975,null,48993.57296880996,null,3518.6163649399982,null,291891.88666548004]
[null," - Other Sealand",86388.895314289941,null,16994.103311049985,null,10356.530205489986,null,13409.730348549998,null,127149.25917937992]
[null," - Region South Denmark",70540.827710649974,null,27675.478848779985,null,25782.590999790027,null,16389.280394749996,null,140388.17795396998]
[null," - Region Central Jutland",72137.03720697001,null,35593.732664530013,null,19998.361637629965,null,9116.6761605200008,null,136845.80766965001]
[null," - Region North Jutland",23119.461894970002,null,13185.866824590004,null,6505.7862529999975,null,6111.8929235899986,null,48923.007896150004]
[null," - Other area",1.1571604900000001,null,3028.2921688599995,null,15199.734468220004,null,0,null,18229.183797570004]
[null,"Total",434986.4634806001,null,153058.08695630994,null,126836.57653293994,null,48546.196192349991,null,763427.32316219993]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",256860.34873726079,null,9097.9007622099725,null,3770.423856339994,null,3366.4854529900017,null,273095.15880880074]
[null," 2 - 5",153076.00726709998,null,12522.210308910006,null,5911.234146800005,null,6768.9399877100032,null,178278.39171051999]
[null," 5 - 20",24315.247217620017,null,44427.791267360022,null,21431.199051759966,null,15668.185749730012,null,105842.42328647002]
[null," 20 - 50",627.96000737999987,null,36211.487828130055,null,19251.733145160004,null,14666.664434179997,null,70757.845414850046]
[null," 50 - 100",106.90025124,null,21211.869279399994,null,16294.502960639995,null,6318.4105662599986,null,43931.683057539994]
[null," 100 and above",0,null,29586.827510299991,null,60177.483372240022,null,1757.5100014799998,null,91521.82088402001]
[null,"Total",434986.4634806008,null,153058.08695631006,null,126836.57653293999,null,48546.196192350013,null,763427.32316220098]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",38277.282751930026,null,6232.615073029996,null,10825.912360530012,null,2683.8409412599999,null,58019.651126750039]
[null,"> 12 - ≤ 24 months",36862.77724405998,null,7430.5894195399997,null,11152.680420979998,null,2664.8704350000016,null,58110.917519579976]
[null,"> 24 - ≤ 36 months",28910.700494999979,null,6171.8035040999957,null,12024.785961720001,null,2139.0617069900004,null,49246.351667809977]
[null,"> 36 - ≤ 60 months",100609.63921826999,null,13176.641052900019,null,14638.690200409996,null,3471.2997666900001,null,131896.27023827002]
[null,"> 60 months",230326.06377134024,null,120046.43790674026,null,78194.507589299828,null,37587.123342410036,null,466154.13260979042]
[null,"Total",434986.46348060021,null,153058.08695631026,null,126836.57653293986,null,48546.196192350035,null,763427.3231622004]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",151102.27218886875,null,61529.72344547329,null,51173.884241797845,null,19290.515609074559,null,283096.39548521442]
[null,"20 - 40%",129622.88360164243,null,41068.719685660493,null,42249.20256222938,null,15753.007083923098,null,228693.8129334554]
[null,"40 - 60%",93760.655293713586,null,26943.765043163396,null,24293.740263971496,null,9667.0159319621525,null,154665.17653281064]
[null,"60 - 80%",46618.769960155645,null,13798.990202998284,null,5813.0381776111271,null,3124.567953857319,null,69355.366294622378]
[null,"> 80 %",13881.882435158785,null,9716.8885785645743,null,3306.7112872699909,null,711.08961377288699,null,27616.571914766238]
[null,"Total",434986.4634795392,null,153058.08695586005,null,126836.57653287984,null,48546.19619259001,null,763427.32316086907]

{"sheet":"RD 2016 Q2 Cap T","index":1,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",261350.66879335992,null,75111.448415430044,null,98591.819273609872,null,39958.54315690996,null,475012.47963930981]
[null," - Number of loans",229934,null,17277,null,9275,null,11073,null,267559]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",15.873421870000001,null,0,null,0.45193065000000004,null,52.422590089999993,null,68.747942609999996]
[null," - repayment loans",6.9390059900000001,null,0,null,0,null,9.2028392899999982,null,16.141845279999998]
[null," - interest-only ",8.9344158800000013,null,0,null,0.45193065000000004,null,43.2197508,null,52.606097329999997]
[null,"FlexLån®",244707.80964150012,null,58399.016885230019,null,40838.508605530013,null,25477.605829749999,null,369422.94096201012]
[null," - repayment loans",92614.064309090012,null,37071.538371700022,null,20173.23701278001,null,7940.0837885700066,null,157798.92348214003]
[null," - interest-only ",152093.74533241009,null,21327.478513529997,null,20665.271592750003,null,17537.522041179993,null,211624.01747987009]
[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®",16542.972474149999,null,2605.1190519700003,null,2607.2143313700008,null,8320.7375041400028,null,30076.04336163]
[null," - repayment loans",4964.9921140100023,null,1240.7374631600003,null,1393.6250443600006,null,2013.8879550499998,null,9613.2425765800017]
[null," - interest-only ",11577.980360139998,null,1364.3815888100003,null,1213.5892870100001,null,6306.8495490900032,null,20462.80078505]
[null,"Other floating rate loans",84.013255839999999,null,14107.312478229991,null,55145.644406059982,null,6107.7772329300005,null,75444.747373059989]
[null," - repayment loans",25.24617507,null,4118.6658664599972,null,19779.07811925,null,1551.9451596300005,null,25474.935320410001]
[null," - interest-only ",58.76708077,null,9988.6466117699947,null,35366.566286809983,null,4555.8320733,null,49969.812052649977]
[null," Total",261350.66879336012,null,75111.448415430001,null,98591.819273610003,null,39958.543156910004,null,475012.47963931004]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",116119.63890939996,null,24677.543872159993,null,38335.946234510011,null,3004.2925143999996,null,182137.42153046996]
[null," - Other Sealand",50751.380367709979,null,7715.4924440699988,null,7192.5808120499987,null,11532.594384870001,null,77192.04800869996]
[null," - Region South Denmark",38249.686255169981,null,14467.098144320005,null,19825.374280699987,null,12648.593228349991,null,85190.751908539969]
[null," - Region Central Jutland",43286.649220409985,null,18365.277199259992,null,13999.471864930012,null,7615.8055639900049,null,83267.203848589998]
[null," - Region North Jutland",12943.314040669997,null,7314.5891313800066,null,4373.8626798199975,null,5157.2574652999992,null,29789.023317170002]
[null," - Other area",0,null,2571.4476242400001,null,14864.583401600001,null,0,null,17436.031025839999]
[null,"Total",261350.66879335986,null,75111.448415429986,null,98591.819273610003,null,39958.543156909989,null,475012.47963930992]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",140738.9280878698,null,5616.3889164299962,null,2204.8100744900007,null,2158.4003045900004,null,150718.52738337978]
[null," 2 - 5",101851.89916790006,null,6564.3191040599986,null,4009.005566060001,null,5248.6401314300001,null,117673.86396945005]
[null," 5 - 20",18244.033125739988,null,20174.872704549984,null,15475.281857540007,null,13183.864815759995,null,67078.052503589977]
[null," 20 - 50",459.01325900000001,null,16339.521757380004,null,13692.421451120003,null,12399.674095619997,null,42890.630563120001]
[null," 50 - 100",56.795152850000001,null,11293.078397710004,null,10891.569207730001,null,5319.9147162700001,null,27561.357474560005]
[null," 100 and above",0,null,15123.267535300003,null,52318.731116670009,null,1648.0490932399998,null,69090.047745210002]
[null,"Total",261350.66879335986,null,75111.448415429986,null,98591.819273610017,null,39958.543156909996,null,475012.47963930981]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",23569.281882990006,null,5045.4852465899976,null,9054.1199987100026,null,2200.7578769499996,null,39869.645005240003]
[null,"> 12 - ≤ 24 months",18261.572240830006,null,4716.4481628700014,null,9393.0255528199959,null,2094.7248927000014,null,34465.770849220011]
[null,"> 24 - ≤ 36 months",18232.670717730001,null,4119.0430751300019,null,11105.157633609999,null,1818.2782591800001,null,35275.149685650002]
[null,"> 36 - ≤ 60 months",51979.730886490041,null,9224.3842331100004,null,12216.681695040003,null,2696.8971866099992,null,76117.694001250042]
[null,"> 60 months",149307.41306532014,null,52006.087697730029,null,56822.834393430086,null,31147.884941469969,null,289284.22009795019]
[null,"Total",261350.66879336018,null,75111.44841543003,null,98591.819273610075,null,39958.543156909975,null,475012.47963931022]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",89504.806811537768,null,26511.377739590258,null,41482.933303202124,null,15701.155772638662,null,173200.27362696882]
[null,"20 - 40%",77418.389015036242,null,21526.440352029647,null,33702.850166959899,null,12940.672239886015,null,145588.35177391177]
[null,"40 - 60%",56940.97899869,null,15421.394009680902,null,18146.652614920116,null,8036.8455483855496,null,98545.871171676568]
[null,"60 - 80%",28595.469499523992,null,7452.563766917915,null,3583.093397537908,null,2659.2386519976603,null,42290.365315977477]
[null,"> 80 %",8891.0244684217705,null,4199.6725470213023,null,1676.289790909957,null,620.63094449212645,null,15387.617750845155]
[null,"Total",261350.66879320977,null,75111.448415240025,null,98591.819273529996,null,39958.54315740001,null,475012.47963937983]

{"sheet":"RD 2016 Q2 Cap S","index":2,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2016 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",150035.27100268009,null,46312.731149370018,null,19737.79554992,null,7388.828491769993,null,223474.62619374009]
[null," - Number of loans",136246,null,8814,null,2969,null,2300,null,150329]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",141333.52272339002,null,41784.065267400023,null,13586.475898770012,null,5408.4200555599991,null,202112.48394512004]
[null," - repayment loans",104435.99885006998,null,38270.182712330025,null,12378.245468060013,null,3418.4667051399983,null,158502.8937356]
[null," - interest-only ",36897.523873320024,null,3513.8825550699994,null,1208.2304307099996,null,1989.9533504200006,null,43609.590209520022]
[null,"FlexLån®",3542.8656737599999,null,2902.4174320800007,null,2269.88679254,null,198.64054077999998,null,8913.8104391599991]
[null," - repayment loans",893.12657578000017,null,437.60204801000003,null,388.37018536000005,null,48.904021489999998,null,1768.0028306400004]
[null," - interest-only ",2649.7390979799998,null,2464.8153840700006,null,1881.5166071800002,null,149.73651928999999,null,7145.80760852]
[null,"FlexGaranti®, Rentedyk TM",5138.8040455799983,null,106.22046075999999,null,48.010918060000009,null,28.937381550000005,null,5321.9728059499967]
[null," - repayment loans",2035.5693090599998,null,62.427278609999995,null,41.223333820000008,null,16.291036100000003,null,2155.5109575899996]
[null," - interest-only ",3103.234736519998,null,43.793182150000007,null,6.7875842400000002,null,12.646345450000002,null,3166.4618483599979]
[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.078559950000002,null,1520.0279891299999,null,3833.4219405500007,null,1752.8305138799994,null,7126.3590035099996]
[null," - repayment loans",6.3695979700000009,null,172.36737499999998,null,974.80873789999998,null,222.32251492000006,null,1375.86822579]
[null," - interest-only ",13.70896198,null,1347.6606141299999,null,2858.6132026500004,null,1530.5079989599992,null,5750.4907777199996]
[null," Total",150035.27100268003,null,46312.731149370025,null,19737.795549920014,null,7388.8284917699984,null,223474.62619374003]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",60342.692390989971,null,22049.353361580026,null,7777.4986144000013,null,464.48287399000003,null,90634.02724096]
[null," - Other Sealand",28993.008088480012,null,4459.4041665599962,null,2318.1239249200007,null,1616.7865064799992,null,37387.322686440006]
[null," - Region South Denmark",27259.288141600016,null,7155.5282468700052,null,3932.3843139600021,null,3262.8958839099992,null,41610.09658634002]
[null," - Region Central Jutland",24913.253808879981,null,9603.0933214299966,null,3907.5132757699989,null,1208.8128974099998,null,39632.673303489973]
[null," - Region North Jutland",8527.0285727300015,null,2793.9269269800011,null,1767.8233934200011,null,835.85032998000065,null,13924.629223110007]
[null," - Other area",0,null,251.42512594999999,null,34.452027450000003,null,0,null,285.8771534]
[null,"Total",150035.27100268001,null,46312.731149370025,null,19737.795549920007,null,7388.8284917699984,null,223474.62619374]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",96024.71296390002,null,2086.0893491000002,null,997.28270152000005,null,855.24595320000003,null,99963.33096772003]
[null," 2 - 5",47984.516115890023,null,3942.8224310199998,null,1620.4098574000002,null,1259.5552120400007,null,54807.303616350022]
[null," 5 - 20",5857.0951745100047,null,14234.113812049998,null,4974.3005781699985,null,2209.8016499099999,null,27275.311214639998]
[null," 20 - 50",168.94674838,null,10053.51881553,null,4870.3213380100024,null,2100.3274592599996,null,17193.11436118]
[null," 50 - 100",0,null,6127.238308850001,null,3350.7141748700005,null,906.81904448000012,null,10384.771528200001]
[null," 100 and above",0,null,9868.9484328199978,null,3924.7668999500002,null,57.079172879999994,null,13850.794505649998]
[null,"Total",150035.27100268006,null,46312.731149369996,null,19737.795549920003,null,7388.8284917700003,null,223474.62619374009]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",14479.750122349997,null,1121.2493780299997,null,1417.7105301900001,null,468.26407348000004,null,17486.974104049998]
[null,"> 12 - ≤ 24 months",18374.938664429999,null,2580.9493606399974,null,1719.7437845100008,null,558.54083358999992,null,23234.172643170001]
[null,"> 24 - ≤ 36 months",10249.250260580007,null,1881.8918520300001,null,843.38206326,null,312.40866616000011,null,13286.932842030008]
[null,"> 36 - ≤ 60 months",38926.376973849969,null,3756.5498722600005,null,1674.4290230400002,null,664.90119334999986,null,45022.257062499972]
[null,"> 60 months",68004.95498147,null,36972.090686410025,null,14082.530148919997,null,5384.7137251899958,null,124444.28954199002]
[null,"Total",150035.27100267998,null,46312.731149370025,null,19737.79554992,null,7388.8284917699957,null,223474.62619374]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",51179.429211683768,null,21836.779573213786,null,7065.0342313815399,null,2827.0357348225202,null,82908.278751101607]
[null,"20 - 40%",45589.855115802719,null,11998.282104433316,null,6272.7828204978077,null,2512.8069002350126,null,66373.726940968845]
[null,"40 - 60%",33031.305561719841,null,6608.8072633708034,null,4261.6140735461104,null,1528.2519302085243,null,45429.978828845269]
[null,"60 - 80%",16264.856555301485,null,3387.2785044708053,null,1422.1708238474353,null,437.39781223919022,null,21511.703695858916]
[null,"> 80 %",3969.8245577020148,null,2481.5837038512682,null,716.193600847114,null,83.336114004751039,null,7250.9379764051482]
[null,"Total",150035.27100220983,null,46312.731149339976,null,19737.795550120012,null,7388.8284915099994,null,223474.62619317981]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":36,"n_cols":4,"rows_kept":36,"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,58,78]
[null,2016,56,39]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":59,"n_cols":5,"rows_kept":59,"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]
[null,"2015 Q2",55,12,{"$f":"C55+D55","v":67}]
[null,"2015 Q3",56,13,{"$f":"C56+D56","v":69}]
[null,"2015 Q4",45,13,58]
[null,"2016 Q1",47,10,57]
[null,"2016 Q2",44,12,{"$f":"C59+D59","v":56}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":47,"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","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 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,72.575999999999993,72.349999999999994,72.150000000000006,69.239999999999995,67.185000000000002,66.164000000000001,67,66.48]
[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,57.84,58.116999999999997,57.783000000000001,57.8,54.93]
[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,58.7,58.494999999999997,58.84,58.3,57.59]
[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,74.37,74.665000000000006,71.064999999999998,71.61,70.61]
[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,67.87,66.759,65.433000000000007,65.87,65]

{"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 2016 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%",151.10227218886874,null,61.529723445473287,null,51.173884241797843,null,19.290515609074557,null,0.37082298065137559,null,283.09639548521437]
[null," - 20-40%",129.62288360164243,null,41.068719685660483,null,42.249202562229378,null,15.753007083923098,null,0.29956199627042324,null,228.6938129334554]
[null," - 40-60%",93.760655293713597,null,26.943765043163395,null,24.293740263971497,null,9.6670159319621529,null,0.20259318973866444,null,154.66517653281062]
[null," - 60-80%",46.618769960155646,null,13.798990202998283,null,5.8130381776111273,null,3.1245679538573188,null,9.0847372356894107E-2,null,69.355366294622385]
[null," - >80%",13.881882435158785,null,9.7168885785645749,null,3.3067112872699909,null,0.71108961377288704,null,3.617446098264273E-2,null,27.616571914766237]
[null,"Total",434.98646347953922,null,153.05808695586003,null,126.83657653287985,null,48.54619619259001,null,1.0000000000000002,null,763.42732316086904]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",89.504806811537762,null,26.511377739590259,null,41.482933303202124,null,15.701155772638662,null,0.36462257530256692,null,173.20027362696879]
[null," - 20-40%",77.41838901503624,null,21.526440352029649,null,33.702850166959898,null,12.940672239886014,null,0.30649374072116942,null,145.58835177391182]
[null," - 40-60%",56.940978998689999,null,15.421394009680903,null,18.146652614920118,null,8.0368455483855499,null,0.20745954137139866,null,98.545871171676566]
[null," - 60-80%",28.59546949952399,null,7.4525637669179154,null,3.5830933975379082,null,2.6592386519976601,null,8.9030008954887871E-2,null,42.290365315977475]
[null," - >80%",8.8910244684217705,null,4.1996725470213025,null,1.676289790909957,null,0.62063094449212641,null,3.239413364997723E-2,null,15.387617750845155]
[null,"Total",261.35066879320976,null,75.111448415240034,null,98.591819273530007,null,39.958543157400015,null,1,null,475.01247963937982]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",51.179429211683768,null,21.836779573213786,null,7.0650342313815404,null,2.8270357348225201,null,0.37099638631650567,null,82.908278751101619]
[null," - 20-40%",45.58985511580272,null,11.998282104433315,null,6.2727828204978078,null,2.5128069002350126,null,0.29700788886695767,null,66.373726940968851]
[null," - 40-60%",33.03130556171984,null,6.6088072633708039,null,4.2616140735461103,null,1.5282519302085242,null,0.20328920380237675,null,45.429978828845286]
[null," - 60-80%",16.264856555301485,null,3.3872785044708054,null,1.4221708238474353,null,0.43739781223919028,null,9.6260161890877938E-2,null,21.511703695858916]
[null," - >80%",3.9698245577020148,null,2.4815837038512689,null,0.71619360084711392,null,8.333611400475105E-2,null,3.2446359123282163E-2,null,7.2509379764051491]
[null,"Total",150.03527100220984,null,46.312731149339989,null,19.737795550120005,null,7.3888284915099991,null,1.0000000000000002,null,223.47462619317983]

{"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 2016 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%",65.401090953308042,null,201.24071383511492,null,16.454590696792035,null,283.096395485215]
[null," - 20-40%",44.401742491095597,null,168.94120768523993,null,15.350862757120019,null,228.69381293345555]
[null," - 40-60%",26.006736866210293,null,115.9941907856832,null,12.664248880917464,null,154.66517653281096]
[null," - 60-80%",11.019004083494959,null,50.747369199879756,null,7.5889930112477284,null,69.355366294622442]
[null," - >80%",6.3204195867562243,null,16.066334228084671,null,5.2298180999253594,null,27.616571914766254]
[null,"Total",153.14899398086513,null,552.98981573400249,null,57.288513446002611,null,763.42732316087029]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",34.898316127527295,null,126.08999438163191,null,12.211963117809777,null,173.20027362696896]
[null," - 20-40%",24.722220492053683,null,109.32667916090594,null,11.5394521209523,null,145.58835177391191]
[null," - 40-60%",14.491801178060141,null,74.564187555317545,null,9.4898824382988582,null,98.545871171676552]
[null," - 60-80%",5.8245654053207847,null,30.816754002101089,null,5.64904590855555,null,42.290365315977425]
[null," - >80%",2.5923858272396947,null,9.1084498967874374,null,3.6867820268180131,null,15.387617750845147]
[null,"Total",82.529289030201596,null,349.90606499674391,null,42.5771256124345,null,475.01247963937999]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",19.284435764583623,null,60.719932296006313,null,2.9039106905117542,null,82.90827875110169]
[null," - 20-40%",13.148173981915514,null,50.441083607895941,null,2.7844693511574685,null,66.373726940968922]
[null," - 40-60%",7.4729056293419314,null,35.528106478434736,null,2.4289667210686208,null,45.429978828845286]
[null," - 60-80%",2.7553994564886026,null,17.305888703183712,null,1.4504155361866407,null,21.511703695858955]
[null," - >80%",1.2652615948371706,null,5.0590839708173414,null,0.9265924107506287,null,7.2509379764051403]
[null,"Total",43.926176427166844,null,169.05409505633804,null,10.494354709675115,null,223.47462619318]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":47,"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","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 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,0.19533888718789549,0.17754809588439302,0.19590249468675333,0.19,0.15893288234797173,0.16149788193874809,0.16149788193874809,0.15]
[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,1.46,0.82675167690184714,0.85336926232454113,0.89,0.69]
[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,1.05,1.1685196839142329,1.2412515438452036,1.58,1.73]
[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,0.38,0.23610434466412475,0.36501409231622234,0.15,0.21]
[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,0.47,0.32200314121386003,0.35811697073053689,0.33,0.3]

{"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",46312731149.370018,46061306023.420029]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",19737795549.920013,19703343522.470009]
["S-Landbrug","S",null,"Landbrug",7388828491.7699995,7388828491.7699995]
["S-Privat","S",null,"Privat",150035271002.68021,150035271002.68021]
["S Total-","S Total","S Total",null,223474626193.74023,223188749040.34024]
["T-Boligudl","T","T","Boligudl",75111448415.430038,72540000791.190033]
["T-Erhverv","T",null,"Erhverv",98591819273.610046,83727235872.009964]
["T-Landbrug","T",null,"Landbrug",39958543156.909996,39958543156.909996]
["T-Privat","T",null,"Privat",261350668793.36014,261350668793.36014]
["T Total-","T Total","T Total",null,475012479639.31024,457576448613.47015]
["Ø-Boligudl","Ø","Ø","Boligudl",31633907391.509991,31435222765.609989]
["Ø-Erhverv","Ø",null,"Erhverv",8506961709.4100084,8215931111.4400091]
["Ø-Landbrug","Ø",null,"Landbrug",1198824543.6700001,1198824543.6700001]
["Ø-Privat","Ø",null,"Privat",23600523684.559956,23600523684.559956]
["Ø Total-","Ø Total","Ø Total",null,64940217329.149948,64450502105.279953]
["Grand Total-","Grand Total","Grand Total",null,763427323162.20044,745215699759.09033]
[]
[]
[]
[]
[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":261350668793.36014}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":72540000791.190033}]
[null,null,"T-Erhverv","Erhverv","Commercial",83727235872.009964]
[null,null,"T-Landbrug","Landbrug","Agriculture",39958543156.909996]
[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":17436031025.840149}]
[]
[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":150035271002.68021}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":46061306023.420029}]
[null,null,"S-Erhverv","Erhverv","Commercial",19703343522.470009]
[null,null,"S-Landbrug","Landbrug","Agriculture",7388828491.7699995]
[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":285877153.40002441}]
[]
[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":23600523684.559956}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":31435222765.609989}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",8215931111.4400091]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",1198824543.6700001]
[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":489715223.86999512}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":434986463480.60028}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":150036529580.22006}]
[null,null,null,null,"Commercial",111646510505.91998]
[null,null,null,null,"Agriculture",48546196192.349991]
[null,null,null,null,"Nordic",18211623403.110168]

{"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",6931372411.0900002,242963356.33000001]
[null,"F1",29920465575.779999,11628150247.24]
[null,"F3",50947661730.540001,14193026243.6]
[null,"F5",57354195747.129997,21006824948.419998]
[null,"Fixed",37549115563.489998,6790947838.7700005]
[null,"Floaters",11669142798.27,71045988554.369995]
[null,"Øv. flex",16759832113.950001,18761614276.130001]
["J Total",null,211131785940.25,143669515464.85999]
["N","CapFloat",12129331671.9,1006684883.3099999]
[null,"F1",19344858447.84,9911142671.7600002]
[null,"F3",32130843270.91,10833938757.92]
[null,"F5",36424060298.919998,38607096889.769997]
[null,"Fixed",113180820490.2,84269301231.940002]
[null,"Floaters",4998554794.75,33164865350.040001]
[null,"Øv. flex",5646208565.8100004,6978314431.5]
["N Total",null,223854677540.32999,184771344216.24002]