{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2016 Q4 Total","RD 2016 Q4 Cap T","RD 2016 Q4 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 Q4 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 Q4 - 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",440005.95267689839,null,156019.4506211293,null,127010.76027484992,null,48062.226975550075,null,771098.39054842771]
[null," - Number of loans",409834,null,37241,null,13776,null,14045,null,474896]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",157997.15267850991,null,74794.642093339979,null,15205.631721039983,null,6693.2411096200003,null,254690.6676025099]
[null," - repayment loans",119059.18984941998,null,70330.647800099978,null,14106.535480339982,null,4382.4768878599998,null,207878.85001771993]
[null," - interest-only ",38937.962829089942,null,4463.994293239999,null,1099.0962407,null,2310.7642217600001,null,46811.81758478994]
[null,"FlexLån®",245334.75860858988,null,61532.853328800069,null,43666.214226170021,null,25400.556646059995,null,375934.38280962]
[null," - repayment loans",95952.115125779936,null,37644.548094250051,null,22635.275452120019,null,8245.9003045900008,null,164477.83897674002]
[null," - interest-only ",149382.64348280994,null,23888.305234550018,null,21030.938774050002,null,17154.656341469992,null,211456.54383287998]
[null,"FlexGaranti®, Rentedyk TM",17386.021925729998,null,525.72921957000005,null,295.27024966000005,null,292.48493715000012,null,18499.506332110002]
[null," - repayment loans",11921.537440040001,null,446.91545974000002,null,279.31606110000001,null,223.47024669000007,null,12871.239207570001]
[null," - interest-only ",5464.4844856899999,null,78.813759830000009,null,15.954188559999997,null,69.014690460000011,null,5628.2671245399997]
[null,"FlexKort®",19170.824323669996,null,2576.6130971299999,null,2541.3115336100004,null,8226.7472583099934,null,32515.496212719994]
[null," - repayment loans",5774.0389694899977,null,1218.6039326199998,null,1362.0655142400005,null,1945.9493525599992,null,10300.657768909998]
[null," - interest-only ",13396.785354180001,null,1358.0091645099999,null,1179.2460193699999,null,6280.7979057499942,null,22214.838443809997]
[null,"Other floating rate loans",117.1951404,null,16589.612882289999,null,65302.332544370009,null,7449.1970244099975,null,89458.337591470001]
[null," - repayment loans",62.105144960000004,null,4799.081092700002,null,21739.484926120014,null,1939.507898269999,null,28540.179062050014]
[null," - interest-only ",55.089995439999996,null,11790.531789590001,null,43562.847618249994,null,5509.6891261399987,null,60918.15852941999]
[null," Total",440005.95267689979,null,156019.45062113006,null,127010.76027485001,null,48062.22697554998,null,771098.39054843003]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",187826.68207818034,null,57930.109660279988,null,48432.486170259945,null,3522.3566752599986,null,297711.63458398031]
[null," - Other Sealand",86168.946021339973,null,17235.575608179995,null,10370.136207309997,null,13415.30930976998,null,127189.96714659993]
[null," - Region South Denmark",70689.446337430127,null,28284.310816310019,null,25743.806976410029,null,16186.073193890001,null,140903.6373240402]
[null," - Region Central Jutland",72298.835908579611,null,36268.464309159986,null,19658.00324776,null,8944.9830002500003,null,137170.28646574958]
[null," - Region North Jutland",23020.987072180025,null,13279.795757949987,null,6328.5554624500055,null,5993.5047963800071,null,48622.84308896002]
[null," - Other area",1.0552591899999999,null,3021.1944692500001,null,16477.772210659998,null,0,null,19500.021939099999]
[null,"Total",440005.95267690008,null,156019.45062112997,null,127010.76027484998,null,48062.226975549987,null,771098.39054843003]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",254894.8860654796,null,8863.5998033400028,null,3663.403195470004,null,3345.6110455999979,null,270767.5001098896]
[null," 2 - 5",157963.48380691017,null,12275.396135429988,null,5714.4577650700048,null,6608.3677670699999,null,182561.70547448017]
[null," 5 - 20",26337.213891810003,null,44719.286098599892,null,21150.481732290013,null,15588.835670829996,null,107795.81739352991]
[null," 20 - 50",753.61251427000025,null,36357.69107646004,null,19036.074920540021,null,14261.338587889995,null,70408.717099160043]
[null," 50 - 100",56.756398429999997,null,21708.685714540014,null,16440.694948849999,null,6600.134709650004,null,44806.271771470019]
[null," 100 and above",0,null,32094.791792759999,null,61005.647712629987,null,1657.9391945099994,null,94758.378699899986]
[null,"Total",440005.95267689979,null,156019.45062112994,null,127010.76027485004,null,48062.226975549987,null,771098.39054842968]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",39737.254490250001,null,7591.0631534900058,null,11080.362227080001,null,2173.7827031100023,null,60582.46257393001]
[null,"> 12 - ≤ 24 months",38143.422672180059,null,7693.6137469199939,null,12102.46480928999,null,3201.5799269499998,null,61141.081155340042]
[null,"> 24 - ≤ 36 months",31213.122665690073,null,6194.1106858600078,null,12051.938904789989,null,2106.9997151900002,null,51566.171971530071]
[null,"> 36 - ≤ 60 months",97678.970688970105,null,13198.963415070011,null,14850.288814160003,null,3336.2500421700015,null,129064.47296037011]
[null,"> 60 months",233233.18215980963,null,121341.69961979025,null,76925.705519530005,null,37243.614588130018,null,468744.2018872599]
[null,"Total",440005.95267689985,null,156019.45062113027,null,127010.76027484998,null,48062.226975550024,null,771098.39054843015]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",156470.45565466984,null,63499.817030666702,null,50605.655458198249,null,18485.24992544288,null,289061.17806897766]
[null,"20 - 40%",133456.67901325255,null,42026.601670700591,null,41988.251365733719,null,15562.562044044234,null,233034.09409373111]
[null,"40 - 60%",94536.472693700183,null,27248.132016892119,null,25694.399422403134,null,10068.155664743204,null,157547.15979773866]
[null,"60 - 80%",44312.910247984888,null,13313.761485408353,null,5848.9193266595057,null,3172.5705763779747,null,66648.161636430712]
[null,"> 80 %",11229.435067311497,null,9931.1384173023889,null,2873.5347016453748,null,773.68876481168945,null,24807.796951070948]
[null,"Total",440005.95267691894,null,156019.45062097016,null,127010.76027463998,null,48062.226975419981,null,771098.39054794901]

{"sheet":"RD 2016 Q4 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 Q4 - 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",261436.1215061096,null,75284.312619169999,null,99713.081727649973,null,39119.284519429944,null,475552.80037235952]
[null," - Number of loans",226566,null,17060,null,9037,null,10668,null,263331]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",10.224142039999998,null,0,null,0,null,6.4807806299999999,null,16.704922669999998]
[null," - repayment loans",6.0525730599999994,null,0,null,0,null,6.4807806299999999,null,12.53335369]
[null," - interest-only ",4.17156898,null,0,null,0,null,0,null,4.17156898]
[null,"FlexLån®",242178.70433423985,null,58932.023686960063,null,41308.914159310014,null,25203.025010659996,null,367622.66719116992]
[null," - repayment loans",94721.23673405993,null,37095.655935660041,null,21707.631540180013,null,8188.8933336699911,null,161713.41754356999]
[null," - interest-only ",147457.46760017992,null,21836.367751300018,null,19601.282619129997,null,17014.131676990004,null,205909.24964759994]
[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®",19170.824323669996,null,2576.6130971299999,null,2541.3115336099995,null,8226.7472583099989,null,32515.496212720001]
[null," - repayment loans",5774.0389694899977,null,1218.6039326199991,null,1362.0655142399996,null,1945.9493525600008,null,10300.657768909998]
[null," - interest-only ",13396.785354180001,null,1358.0091645100013,null,1179.2460193699999,null,6280.7979057499988,null,22214.83844381]
[null,"Other floating rate loans",76.368706160000002,null,13775.675835080006,null,55862.856034729979,null,5683.0314698300017,null,75397.932045799986]
[null," - repayment loans",53.852243919999999,null,4504.4755795400015,null,19582.465641950006,null,1676.3082430600002,null,25817.101708470011]
[null," - interest-only ",22.516462239999999,null,9271.2002555400031,null,36280.390392779977,null,4006.7232267700019,null,49580.830337329986]
[null," Total",261436.12150610983,null,75284.312619170072,null,99713.081727649987,null,39119.284519430003,null,475552.80037235998]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",117942.75402703998,null,25005.594184870006,null,38370.97226016999,null,2917.7676653799981,null,184237.08813745997]
[null," - Other Sealand",49993.223032950067,null,7684.6870849800034,null,7443.4532056199996,null,11459.810565029991,null,76581.173888580059]
[null," - Region South Denmark",37881.487807910024,null,14429.316699080016,null,19621.893290460004,null,12247.004185000018,null,84179.70198245006]
[null," - Region Central Jutland",42903.918446150048,null,18392.750885100013,null,13912.340290709993,null,7488.1695470799941,null,82697.179169040042]
[null," - Region North Jutland",12714.738192059995,null,7208.6379902399995,null,4222.2419630500008,null,5006.5325569399984,null,29152.150702289997]
[null," - Other area",0,null,2563.3257748999999,null,16142.18071764,null,0,null,18705.50649254]
[null,"Total",261436.12150611012,null,75284.312619170028,null,99713.081727649987,null,39119.284519429995,null,475552.8003723601]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",137880.9240297798,null,5509.3480623400037,null,2140.4774369399993,null,2136.5824649099991,null,147667.3319939698]
[null," 2 - 5",103413.29452484995,null,6398.1619604199977,null,3864.4537100099992,null,5134.4254643499971,null,118810.33565962993]
[null," 5 - 20",19572.902685489997,null,20391.781307320016,null,15146.658348199993,null,13019.830455370007,null,68131.172796380022]
[null," 20 - 50",512.24386756000001,null,16510.808979220008,null,13892.418920949998,null,11833.009908519994,null,42748.481676249998]
[null," 50 - 100",56.756398429999997,null,11474.99360461001,null,10802.536782050003,null,5484.9349631200002,null,27819.22174821001]
[null," 100 and above",0,null,14999.218705260006,null,53866.536529499994,null,1510.5012631600002,null,70376.256497919996]
[null,"Total",261436.12150610972,null,75284.312619170043,null,99713.081727649987,null,39119.28451943001,null,475552.80037235975]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",23475.575078959999,null,6135.5379929100081,null,8852.8937912200017,null,1662.9128289799999,null,40126.919692070012]
[null,"> 12 - ≤ 24 months",19449.545898190019,null,4769.6651281799932,null,10474.910656269994,null,2562.6064699399994,null,37256.728152580006]
[null,"> 24 - ≤ 36 months",19065.894809990012,null,3844.9743714799993,null,10865.467017790004,null,1649.1477325599999,null,35425.483931820017]
[null,"> 36 - ≤ 60 months",49920.117596939999,null,8357.5917217599981,null,12892.432813580001,null,2596.7778705800001,null,73766.920002860003]
[null,"> 60 months",149524.98812203007,null,52176.543404840013,null,56627.377448789979,null,30647.839617369966,null,288976.74859303003]
[null,"Total",261436.1215061101,null,75284.312619170014,null,99713.081727649973,null,39119.284519429959,null,475552.80037236004]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",91896.877011193836,null,27461.692035859371,null,41267.361054559246,null,15048.924358193357,null,175674.85445980582]
[null,"20 - 40%",78924.366476042123,null,21700.084782171725,null,33742.641318347254,null,12600.701904872074,null,146967.79448143317]
[null,"40 - 60%",56724.383772190165,null,15411.724816122751,null,19433.363520888015,null,8211.1888844857276,null,99780.660993686659]
[null,"60 - 80%",26730.280260407108,null,7039.9143012140648,null,3852.4810783923372,null,2615.5114104821428,null,40238.187050495653]
[null,"> 80 %",7160.2139865566314,null,3670.8966836520444,null,1417.2347550031059,null,642.95796114669497,null,12891.303386358479]
[null,"Total",261436.12150638987,null,75284.31261901994,null,99713.081727189958,null,39119.284519179993,null,475552.80037177977]

{"sheet":"RD 2016 Q4 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 Q4 - 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",158802.8507168401,null,50914.64110880997,null,20198.771132869995,null,8084.260854410004,null,238000.52381293004]
[null," - Number of loans",143397,null,9200,null,3025,null,2476,null,158098]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",150877.07908482995,null,46907.665351590003,null,14588.921686409984,null,6383.989423670002,null,218757.65554649994]
[null," - repayment loans",112273.01085545003,null,42455.715561630008,null,13492.709837139982,null,4077.7328306500012,null,172299.16908486999]
[null," - interest-only ",38604.068229379947,null,4451.9497899599974,null,1096.2118492700001,null,2306.2565930200003,null,46458.486461629946]
[null,"FlexLån®",2999.14303449,null,2473.3807938800001,null,2037.8122230099998,null,183.09283313999998,null,7693.428884519999]
[null," - repayment loans",1114.6814454099999,null,422.6468483299999,null,608.88811682999994,null,42.568168659999998,null,2188.7845792299995]
[null," - interest-only ",1884.4615890799996,null,2050.73394555,null,1428.9241061799999,null,140.52466447999998,null,5504.6443052899986]
[null,"FlexGaranti®, Rentedyk TM",4906.6263905099986,null,101.84368233000001,null,46.73058271,null,28.56047078000001,null,5083.7611263299987]
[null," - repayment loans",1934.8581841999994,null,63.238543550000003,null,39.95124002,null,15.926427200000004,null,2053.9743949699991]
[null," - interest-only ",2971.7682063099996,null,38.605138780000004,null,6.77934269,null,12.634043580000002,null,3029.7867313599995]
[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.002207010000003,null,1431.7512810100006,null,3525.3066407400011,null,1488.6181268200003,null,6465.6782555800019]
[null," - repayment loans",6.3037035100000001,null,158.92245266,null,997.2528006,null,183.30111872999996,null,1345.7800755000001]
[null," - interest-only ",13.698503500000001,null,1272.8288283500005,null,2528.0538401400013,null,1305.3170080900002,null,5119.898180080002]
[null," Total",158802.85071683995,null,50914.641108810014,null,20198.771132869988,null,8084.2608544100012,null,238000.52381292993]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",64706.532183639967,null,23535.170224269979,null,7987.5776366299997,null,560.36834447000012,null,96789.648389009948]
[null," - Other Sealand",30536.739336550007,null,5121.4282965099974,null,2236.9786598600003,null,1742.6114473000005,null,39637.757740220011]
[null," - Region South Denmark",28581.998825989976,null,8217.3305675600022,null,4162.146336329999,null,3609.5065021000009,null,44570.982231979979]
[null," - Region Central Jutland",26070.692690390013,null,10615.884353520007,null,4021.2053028599998,null,1275.4804391199993,null,41983.262785890023]
[null," - Region North Jutland",8906.8876802699997,null,3173.342555090002,null,1756.4029500500003,null,896.29412141999956,null,14732.927306830004]
[null," - Other area",0,null,251.48511186000002,null,34.46024714,null,0,null,285.945359]
[null,"Total",158802.85071683992,null,50914.641108809992,null,20198.771132869999,null,8084.2608544099994,null,238000.52381292995]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100044.66679866005,null,2125.0908088099991,null,1033.1515922899996,null,921.84347077000018,null,104124.75267053004]
[null," 2 - 5",51966.77196541999,null,3975.3129946600016,null,1645.3586894400005,null,1279.8744391199998,null,58867.31808864]
[null," 5 - 20",6596.3840881900014,null,15016.88509392,null,5132.3496788399989,null,2351.4327934200019,null,29097.051654370003]
[null," 20 - 50",195.02786456999999,null,10634.03298439,null,4556.3819133199995,null,2301.7506283500002,null,17687.193390629996]
[null," 50 - 100",0,null,6569.8569183199988,null,4053.6405103400002,null,1082.7115770199998,null,11706.209005680001]
[null," 100 and above",0,null,12593.462308710003,null,3777.8887486400004,null,146.64794573000003,null,16517.999003080004]
[null,"Total",158802.85071684007,null,50914.641108809999,null,20198.771132869999,null,8084.2608544100021,null,238000.52381293004]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",16112.336562469998,null,1391.7146561399998,null,1876.2766210099996,null,493.61332698000012,null,19873.941166599994]
[null,"> 12 - ≤ 24 months",18513.412272679998,null,2804.2498808600008,null,1592.5484336100005,null,626.60637750000001,null,23536.816964649999]
[null,"> 24 - ≤ 36 months",11994.837115520002,null,2255.612860929999,null,1179.0855207699997,null,445.09127014999996,null,15874.62676737]
[null,"> 36 - ≤ 60 months",39515.454291660004,null,4633.117263260001,null,1505.5292632800001,null,706.82082318999994,null,46360.921641390007]
[null,"> 60 months",72666.810474509897,null,39829.946447619921,null,14045.331294199992,null,5812.1290565899981,null,132354.21727291981]
[null,"Total",158802.85071683989,null,50914.641108809919,null,20198.771132869992,null,8084.2608544099976,null,238000.52381292981]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",55553.434059106847,null,23393.237175772625,null,7295.8151444209243,null,2908.4562519805258,null,89150.942631280923]
[null,"20 - 40%",48945.022336377471,null,12989.691022475798,null,6568.9447473796999,null,2746.5074161837497,null,71250.165522416719]
[null,"40 - 60%",34726.673516703973,null,7294.8805047116175,null,4491.2147102810304,null,1784.5597951448424,null,48297.328526841455]
[null,"60 - 80%",16235.134234699271,null,3510.5621816113285,null,1197.448504465538,null,526.66246994625806,null,21469.807390722395]
[null,"> 80 %",3342.5865700724257,null,3726.2702240486287,null,645.34802639279428,null,118.07492141462652,null,7832.2797419284752]
[null,"Total",158802.85071696001,null,50914.641108619995,null,20198.77113293999,null,8084.260854670003,null,238000.52381318994]

{"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,51,81]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":61,"n_cols":5,"rows_kept":61,"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}]
[null,"2016 Q3",41,15,{"$f":"C60+D60","v":56}]
[null,"2016 Q4",38,13,{"$f":"C61+D61","v":51}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":49,"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","2016 Q3","2016 Q4"]
[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,65.734999999999999,64.723202000000001]
[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,56.378999999999998,55.373230999999997]
[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,59.05,58.872926]
[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,70.709000000000003,70.689116999999996]
[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,64.956000000000003,64.221069999999997]

{"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 Q4"]
[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%",156.47045565466982,null,63.499817030666705,null,50.605655458198243,null,18.485249925442879,null,0.37486938322302593,null,289.0611780689776]
[null," - 20-40%",133.45667901325257,null,42.026601670700593,null,41.988251365733717,null,15.562562044044235,null,0.30221058291683778,null,233.03409409373108]
[null," - 40-60%",94.536472693700176,null,27.248132016892121,null,25.694399422403134,null,10.068155664743204,null,0.20431524916785823,null,157.54715979773866]
[null," - 60-80%",44.312910247984888,null,13.313761485408351,null,5.8489193266595061,null,3.1725705763779746,null,8.6432759364301059E-2,null,66.648161636430714]
[null," - >80%",11.229435067311497,null,9.9311384173023889,null,2.8735347016453749,null,0.77368876481168936,null,3.2172025327977041E-2,null,24.807796951070948]
[null,"Total",440.00595267691887,null,156.01945062097016,null,127.01076027463998,null,48.062226975419975,null,1,null,771.09839054794895]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",91.896877011193837,null,27.461692035859372,null,41.267361054559245,null,15.048924358193357,null,0.36941188091514959,null,175.6748544598058]
[null," - 20-40%",78.924366476042124,null,21.700084782171725,null,33.742641318347253,null,12.600701904872075,null,0.30904621814136318,null,146.96779448143317]
[null," - 40-60%",56.724383772190166,null,15.411724816122751,null,19.433363520888015,null,8.211188884485729,null,0.20982036256684791,null,99.780660993686666]
[null," - 60-80%",26.73028026040711,null,7.0399143012140648,null,3.8524810783923371,null,2.6155114104821431,null,8.4613500370596229E-2,null,40.238187050495654]
[null," - >80%",7.1602139865566308,null,3.6708966836520442,null,1.4172347550031059,null,0.64295796114669501,null,2.7108038006043195E-2,null,12.891303386358477]
[null,"Total",261.43612150638984,null,75.284312619019971,null,99.713081727189973,null,39.119284519179999,null,1,null,475.55280037177977]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",55.553434059106849,null,23.393237175772626,null,7.2958151444209243,null,2.9084562519805259,null,0.37458296815034237,null,89.150942631280927]
[null," - 20-40%",48.94502233637747,null,12.9896910224758,null,6.5689447473796996,null,2.7465074161837495,null,0.29936978448981066,null,71.250165522416722]
[null," - 40-60%",34.726673516703968,null,7.2948805047116174,null,4.4912147102810307,null,1.7845597951448424,null,0.20292950516676478,null,48.297328526841454]
[null," - 60-80%",16.235134234699274,null,3.5105621816113284,null,1.1974485044655381,null,0.52666246994625809,null,9.0209076210161457E-2,null,21.469807390722398]
[null," - >80%",3.342586570072426,null,3.726270224048629,null,0.64534802639279421,null,0.11807492141462651,null,3.2908665982920887E-2,null,7.8322797419284758]
[null,"Total",158.80285071695997,null,50.914641108619989,null,20.198771132939989,null,8.0842608546700028,null,1.0000000000000002,null,238.00052381318997]

{"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 Q4"]
[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%",69.213181675992558,null,204.42824835666619,null,15.419748036319634,null,289.06117806897834]
[null," - 20-40%",46.060841813892516,null,172.49012130119283,null,14.483130978645816,null,233.03409409373117]
[null," - 40-60%",26.509527863845886,null,119.00338137195914,null,12.034250561933906,null,157.54715979773891]
[null," - 60-80%",10.730532565011243,null,48.947675164441115,null,6.969953906978227,null,66.648161636430586]
[null," - >80%",5.7283002116066557,null,14.474055780034904,null,4.6054409594293917,null,24.807796951070952]
[null,"Total",158.24238413034885,null,559.34348197429404,null,53.512524443306972,null,771.09839054794998]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",36.576362916394245,null,127.58898353326721,null,11.509508010144438,null,175.67485445980589]
[null," - 20-40%",24.899483790707659,null,111.17692986117133,null,10.89138082955427,null,146.96779448143326]
[null," - 40-60%",14.283356785639018,null,76.397874110915666,null,9.0994300971318935,null,99.780660993686581]
[null," - 60-80%",5.4153104354604489,null,29.639863139508055,null,5.1830134755271571,null,40.238187050495661]
[null," - >80%",2.2272893949326957,null,7.5044643928741435,null,3.1595495985516378,null,12.891303386358477]
[null,"Total",83.401803323134075,null,352.3081150377364,null,39.842882010909392,null,475.55280037177988]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",21.79386045012507,null,64.549379257733278,null,2.807702923422613,null,89.150942631280955]
[null," - 20-40%",14.839248587167988,null,53.646824773030403,null,2.764092162218327,null,71.250165522416722]
[null," - 40-60%",8.4751530194910281,null,37.459501582088521,null,2.3626739252619307,null,48.297328526841483]
[null," - 60-80%",3.0249618259391786,null,17.035314142716491,null,1.4095314220666779,null,21.469807390722348]
[null," - >80%",1.2977013682395022,null,5.5821164460992678,null,0.95246192758970949,null,7.8322797419284793]
[null,"Total",49.430925250962765,null,178.27313620166797,null,10.296462360559257,null,238.00052381318997]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":39,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","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","2016 Q3","2016 Q4"]
[null,"Private",0.15656218014927964,0.17622091059825712,0.21226328148524881,0.23504379286900098,0.34621659433492169,0.48567081299722087,0.63763978533718857,0.70915120590311731,0.78891781003792383,0.884183102468585,0.66014775406359882,0.57160041949894835,0.55422562049590962,0.49518388603850316,0.49110552801689522,0.6619027318422005,0.4648789078035972,0.46832181852500976,0.43548524598554395,0.42244695436316571,0.43178507225390916,0.4489009708773069,0.42524190317220628,0.34556169541261328,0.39486932956755244,0.39165920483661149,0.38089192955661699,0.31589258394518216,0.30406651058489231,0.30220907955598109,0.31330024963699726,0.2642695530501542,0.28144963972229237,0.26251829878317595,0.27048180491465101,0.27092701552282933,0.29635580051520782]
[null,"Commercial",0.14755295177431865,8.6561935281377345E-2,0.1302500765064474,0.19974043569052896,0.31830955393429977,0.45037133694297959,1.1985979832481644,1.5621732902413716,2.5952748166498667,1.523145417237034,1.7759759291753354,1.6899327680265703,1.4822631479958117,1.0176578563538299,1.6925160102921666,1.3822367058417195,1.2855621410685494,1.2198105515838669,1.0692050316506838,1.0873151068240114,1.2748021933757456,1.0704785438655486,1.1414629242385435,1.1262714491262065,0.99763191702061105,1.0855713883277764,0.91804284337792474,0.84431163831617229,0.89993952488976359,1.3313241780657834,1.7008584999681573,0.96409495539694856,1.0269371879108964,1.0999113706925037,0.93180996923328352,0.92435286165055541,1.2090339917170199]
[null,"Agriculture",0.16492939721116656,0.16352636059288203,0.18131578827259506,0.18585644226829021,0.29156621157097973,0.33372263690950654,0.6566990574356345,1.0562629456645494,1.0257603538302378,1.6219284518633401,1.3613901254075007,1.3102129459712726,0.93905113371874971,1.1799230483352952,1.6199597092132287,1.5673729058140449,1.3765609345047594,1.4478763731756665,1.6000588751467346,2.0190195305098846,1.7009234277787137,1.5152123905496004,1.4393100918431909,1.2379810635040327,1.2534017927207908,1.4422602051639715,1.1279391584469076,0.9218002510970208,1.1901637995616265,0.95794405873716559,1.3614154268775058,1.4843503432483875,1.3626687376114672,1.754021390291743,2.0350763958207363,2.0258747749073289,1.4581695282698581]
[null,"Rental Residential",0.10881653835393289,7.2900290215380664E-2,0.20464014665077832,0.16571449515978301,0.67866484831018647,0.72076484713388633,2.4415707119300158,1.0415567313575762,3.1518579850978306,1.2613760651035448,1.9114554979658624,0.9980525218506836,1.5838617600771265,0.8097837561888761,1.2452133108466987,0.58315400331599609,0.827580373339592,1.094845259395181,1.2689464300675897,1.1091723102862634,1.3479556446765679,1.2856214843013938,1.4062204663942004,1.2159326565244508,1.0565290633750315,1.4551837062387438,0.65298416819966598,0.69949155353057135,0.62912291933402753,0.35436787495800426,0.39745870096644126,0.23296917886124544,0.43297702935824278,0.19531119152575055,0.23189962105621692,0.13492304160070345,0.20693631147950448]
[null,"Total",0.14463063189580319,0.11360534965430442,0.18768779885976775,0.19728265752607319,0.4071896442411998,0.54574819260952367,1.1867057540503803,1.0427039051559712,1.7800927570175831,1.237627901612,1.2810736250868875,1.0071306927190868,1.0553341596738197,0.79360601023521704,1.0642564682134805,0.83359709968849593,0.83451995720702687,0.95372864815735314,0.90078809963093975,0.9399593444498533,0.97752861418901849,0.99680059202279458,0.93819550317166944,0.91259386488129202,0.7854081252307219,1.0557314295752029,0.64873671370510011,0.61802120893024015,0.61208062629723725,0.58280097381845619,0.76463115148218486,0.48189249819686247,0.58706260481597794,0.52098721825771332,0.57290758656015295,0.48564694492417804,0.58374279409140806]

{"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",50914641108.809967,50663155996.949959]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",20198771132.869984,20164310885.729984]
["S-Landbrug","S",null,"Landbrug",8084260854.4100103,8084260854.4100103]
["S-Privat","S",null,"Privat",158802850716.83978,158802850716.83978]
["S Total-","S Total","S Total",null,238000523812.92975,237714578453.92975]
["T-Boligudl","T","T","Boligudl",75284312619.169998,72720986844.269943]
["T-Erhverv","T",null,"Erhverv",99713081727.649841,83570901010.009949]
["T-Landbrug","T",null,"Landbrug",39119284519.430031,39119284519.430031]
["T-Privat","T",null,"Privat",261436121506.10999,261436121506.10999]
["T Total-","T Total","T Total",null,475552800372.35986,456847293879.81995]
["Ø-Boligudl","Ø","Ø","Boligudl",29820496893.150036,29619806597.900036]
["Ø-Erhverv","Ø",null,"Erhverv",7098907414.3300037,6806265144.3200026]
["Ø-Landbrug","Ø",null,"Landbrug",858681601.71000028,858681601.71000028]
["Ø-Privat","Ø",null,"Privat",19766980453.949978,19766980453.949978]
["Ø Total-","Ø Total","Ø Total",null,57545066363.140015,57051733797.88002]
["Grand Total-","Grand Total","Grand Total",null,771098390548.42944,751613606131.62964]
[]
[]
[]
[]
[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":261436121506.10999}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":72720986844.269943}]
[null,null,"T-Erhverv","Erhverv","Commercial",83570901010.009949]
[null,null,"T-Landbrug","Landbrug","Agriculture",39119284519.430031]
[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":18705506492.539917}]
[]
[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":158802850716.83978}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":50663155996.949959}]
[null,null,"S-Erhverv","Erhverv","Commercial",20164310885.729984]
[null,null,"S-Landbrug","Landbrug","Agriculture",8084260854.4100103]
[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":285945359.00003052}]
[]
[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":19766980453.949978}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":29619806597.900036}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6806265144.3200026]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",858681601.71000028]
[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":493332565.26000214}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":440005952676.89972}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":153003949439.11993}]
[null,null,null,null,"Commercial",110541477040.05994]
[null,null,null,null,"Agriculture",48062226975.550041]
[null,null,null,null,"Nordic",19484784416.79995]

{"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",5464484485.7200003,163782638.81999999]
[null,"F1",26383399480.5,9153311070.1299992]
[null,"F3",46322722616.129997,12252768549.17]
[null,"F5",61817391575.199997,22911735455.23]
[null,"Fixed",38937962829.120003,7873854755.71]
[null,"Floaters",13451875349.67,69681121623.490005]
[null,"Øv. flex",14859129810.9,17756085275.490002]
["J Total",null,207236966147.23999,139792659368.04001]
["N","CapFloat",11921537440.08,949701767.45000005]
[null,"F1",17633594852.869999,9808316186.6000004]
[null,"F3",32160298647.02,10418553475]
[null,"F5",39949310201.949997,39933948218.93]
[null,"Fixed",119059189849.49001,88819660168.110001]
[null,"Floaters",5836144114.4399996,33004692716.360001]
[null,"Øv. flex",6208911423.8800001,8364905970.2200003]
["N Total",null,232768986529.73001,191299778502.67001]