{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2018 Q2 Total","RD 2018 Q2 Cap T","RD 2018 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 2018 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 2018 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",457240.71888394933,null,164280.6591613006,null,128575.53924994009,null,47089.417509689862,null,797186.33480487985]
[null," - Number of loans",408599,null,35870,null,12564,null,13509,null,470542]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",171862.25569950999,null,78170.645511239942,null,19429.74088573999,null,8386.9146331999964,null,277849.55672968994]
[null," - repayment loans",126475.14062747998,null,71817.469352069951,null,18053.300498019988,null,5294.0360398099965,null,221639.94651737993]
[null," - interest-only ",45387.115072030007,null,6353.1761591699969,null,1376.44038772,null,3092.8785933899999,null,56209.610212310006]
[null,"FlexLån®",250443.09568917009,null,66668.712709540036,null,34980.395093909996,null,25383.038381850023,null,377475.24187447014]
[null," - repayment loans",102790.3493334001,null,42704.875998980016,null,20353.253087259993,null,8773.0194361600061,null,174621.49785580015]
[null," - interest-only ",147652.74635577001,null,23963.836710560012,null,14627.142006650001,null,16610.018945690015,null,202853.74401867003]
[null,"FlexGaranti®, Rentedyk TM",13643.047204930004,null,412.91055706999992,null,213.03919503999998,null,204.44798322999995,null,14473.444940270005]
[null," - repayment loans",10901.203996430002,null,387.96359993999994,null,212.03733576999997,null,197.04138072999996,null,11698.246312870002]
[null," - interest-only ",2741.8432085000013,null,24.946957129999998,null,1.00185927,null,7.4066025,null,2775.1986274000014]
[null,"FlexKort®",21211.633836510002,null,2301.979377749999,null,2275.6445263600008,null,7601.9000395200001,null,33391.157780139998]
[null," - repayment loans",6287.45660873,null,1206.1313546899999,null,1258.8616076500009,null,2204.2485293999998,null,10956.698100469999]
[null," - interest-only ",14924.177227780003,null,1095.8480230599994,null,1016.7829187099998,null,5397.6515101200011,null,22434.459679670003]
[null,"Other floating rate loans",80.686453830000005,null,16726.411005699996,null,71676.719548890018,null,5513.1164718900009,null,93996.933480309992]
[null," - repayment loans",45.726314179999996,null,6210.7334350299961,null,32614.229325209984,null,2140.0979791500013,null,41010.787053569984]
[null," - interest-only ",34.960139650000009,null,10515.677570670003,null,39062.490223680026,null,3373.0184927399996,null,52986.146426740022]
[null," Total",457240.71888395015,null,164280.65916129999,null,128575.53924993999,null,47089.417509690014,null,797186.33480488008]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",203218.92349407051,null,63470.342352750049,null,51537.858417230033,null,3487.5511488400007,null,321714.67541289062]
[null," - Other Sealand",87119.669325090028,null,16986.365824980003,null,10611.760908570013,null,13164.682910790005,null,127882.47896943004]
[null," - Region South Denmark",71492.495094270067,null,28811.91884982002,null,23917.745706170008,null,16209.523724190007,null,140431.68337445011]
[null," - Region Central Jutland",72812.375499529997,null,39252.827191479977,null,18949.062546410012,null,8659.9599459600031,null,139674.22518337998]
[null," - Region North Jutland",22596.618292209994,null,12647.23110219999,null,5660.8920704999973,null,5567.6997799100036,null,46472.441244819995]
[null," - Other area",0.63717878000000006,null,3111.9738400699998,null,17898.219601059998,null,0,null,21010.830619909997]
[null,"Total",457240.71888395061,null,164280.65916130002,null,128575.53924994006,null,47089.417509690014,null,797186.33480488078]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",248581.57390347024,null,8003.9165585700093,null,3212.5953965200001,null,3140.1020062999987,null,262938.18786486023]
[null," 2 - 5",174491.07752945015,null,11296.522285919993,null,5100.3480461300051,null,6415.7233563099971,null,197303.67121781016]
[null," 5 - 20",33142.477355830008,null,44948.903141630006,null,19136.395983609986,null,15333.071360569998,null,112560.84784163999]
[null," 20 - 50",916.79984253999987,null,38111.860728649961,null,18579.050595619996,null,14175.925606829996,null,71783.636773639955]
[null," 50 - 100",108.79025265999999,null,24509.982070780006,null,15096.701123510005,null,6320.6352637399996,null,46036.108710690009]
[null," 100 and above",0,null,37409.474375749989,null,67450.448104549971,null,1703.9599159399997,null,106563.88239623996]
[null,"Total",457240.71888395038,null,164280.65916129999,null,128575.53924993997,null,47089.417509689985,null,797186.33480488055]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",29634.052295560028,null,10069.510580449994,null,9772.9907338099929,null,1195.2490002399998,null,50671.802610060018]
[null,"> 12 - ≤ 24 months",24587.112140190005,null,7250.9113169700058,null,7199.4477143599988,null,1321.5023264900008,null,40358.973498010011]
[null,"> 24 - ≤ 36 months",20952.183445379975,null,6983.8396526400029,null,8195.6459769699995,null,1697.6372845699998,null,37829.306359559974]
[null,"> 36 - ≤ 60 months",40670.604480899972,null,13067.257805119994,null,14379.114301320004,null,2389.2711454200003,null,70506.247732759963]
[null,"> 60 months",341396.76652192004,null,126909.13980611999,null,89028.340523480074,null,40485.757752969985,null,597820.00460449012]
[null,"Total",457240.71888395003,null,164280.65916129999,null,128575.53924994006,null,47089.417509689985,null,797186.33480488008]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",168448.25290323552,null,70270.898096609933,null,55604.44026594529,null,18656.129018835294,null,312979.72028462606]
[null,"20 - 40%",142185.57723027247,null,44565.586257148578,null,44456.665311835161,null,15522.990412974836,null,246730.81921223106]
[null,"40 - 60%",96911.332076309482,null,27030.173232509209,null,22110.320318515624,null,9707.8859538237903,null,155759.71158115807]
[null,"60 - 80%",41683.529652367361,null,12766.261463328068,null,3990.9989012283336,null,2644.0827295885247,null,61084.872746512294]
[null,"> 80 %",8012.0270217849247,null,9647.7401117543595,null,2413.1144523756711,null,558.32939467749384,null,20631.210980592448]
[null,"Total",457240.71888396976,null,164280.65916135017,null,128575.53924990009,null,47089.417509899933,null,797186.3348051199]

{"sheet":"RD 2018 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 2018 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",270661.35239409009,null,83707.229442880052,null,102468.63847052006,null,38290.445197009998,null,495127.66550450027]
[null," - Number of loans",226761,null,16511,null,8477,null,10432,null,262181]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",8.2386476999999996,null,7.8135850800000002,null,0,null,14.46052682,null,30.512759600000003]
[null," - repayment loans",6.4297337900000002,null,0,null,0,null,7.58709232,null,14.01682611]
[null," - interest-only ",1.8089139100000002,null,7.8135850800000002,null,0,null,6.8734345000000001,null,16.495933489999999]
[null,"FlexLån®",249367.87496649002,null,65525.801363890037,null,34301.877025950002,null,25290.243606920008,null,374485.79696325009]
[null," - repayment loans",102565.97660308996,null,42468.344195580015,null,20188.892661010006,null,8731.9916497299928,null,173955.20510940996]
[null," - interest-only ",146801.89836340005,null,23057.457168310022,null,14112.984364939999,null,16558.251957190019,null,200530.5918538401]
[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®",21211.633836510002,null,2301.9793777499999,null,2275.6445263600008,null,7601.9000395200001,null,33391.157780139998]
[null," - repayment loans",6287.45660873,null,1206.1313546899999,null,1258.8616076500009,null,2204.2485293999998,null,10956.698100469999]
[null," - interest-only ",14924.177227780003,null,1095.8480230599998,null,1016.7829187099998,null,5397.6515101200011,null,22434.459679670003]
[null,"Other floating rate loans",73.604943390000003,null,15871.635116160003,null,65891.116918210013,null,5383.8410237500011,null,87220.198001510013]
[null," - repayment loans",38.644803739999993,null,5416.8185831999999,null,28866.182327019989,null,2023.9380702400001,null,36345.583784199989]
[null," - interest-only ",34.960139650000009,null,10454.816532960003,null,37024.934591190024,null,3359.9029535100012,null,50874.614217310031]
[null," Total",270661.35239408998,null,83707.229442880052,null,102468.63847052002,null,38290.445197010013,null,495127.6655045001]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",126385.55251338994,null,30117.363322320001,null,41748.981762409981,null,2761.8942025299998,null,201013.79180064989]
[null," - Other Sealand",50199.780676949966,null,7781.2842547500022,null,7680.4333118400018,null,11142.362338020002,null,76803.860581559973]
[null," - Region South Denmark",38547.759510549986,null,15270.229743079999,null,18507.513752330004,null,12626.724664549998,null,84952.227670509994]
[null," - Region Central Jutland",43005.344867299988,null,20467.78318078001,null,13451.476983210001,null,7143.3598580299968,null,84067.964889320006]
[null," - Region North Jutland",12522.914825900003,null,7163.5099517000008,null,3476.4534204299989,null,4616.1041338799978,null,27778.982331910003]
[null," - Other area",0,null,2907.0589902500001,null,17603.779240300006,null,0,null,20510.838230550005]
[null,"Total",270661.35239408986,null,83707.229442880009,null,102468.63847051999,null,38290.445197009998,null,495127.6655044998]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",135137.01838911991,null,4941.8684757400006,null,1924.8349741599998,null,2056.1178349799989,null,144059.83967399993]
[null," 2 - 5",111070.19796870003,null,5767.9195991999986,null,3502.5345478499985,null,5043.9435191899993,null,125384.59563494004]
[null," 5 - 20",23696.162107789994,null,20537.093716170002,null,13817.634534510005,null,13009.048056839996,null,71059.938415309996]
[null," 20 - 50",694.38310408000007,null,17679.83763700999,null,13363.44073772,null,11616.28909943,null,43353.950578239994]
[null," 50 - 100",63.590824399999995,null,13217.209218960001,null,11110.191660200004,null,5000.5674423300006,null,29391.559145890005]
[null," 100 and above",0,null,21563.300795799994,null,58750.002016079998,null,1564.4792442400001,null,81877.782056119991]
[null,"Total",270661.35239408992,null,83707.229442879994,null,102468.63847052,null,38290.445197009998,null,495127.66550449998]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",16942.835485590007,null,7870.0313077599994,null,7526.4243226400004,null,863.43898806000004,null,33202.73010405001]
[null,"> 12 - ≤ 24 months",13022.48106893001,null,3709.0971987599969,null,5005.6231087599981,null,967.54572222000036,null,22704.747098670006]
[null,"> 24 - ≤ 36 months",12478.298291699997,null,4049.7353958599992,null,6486.9953928900004,null,1261.1631939699994,null,24276.192274419998]
[null,"> 36 - ≤ 60 months",21899.810469200002,null,8764.0724316400028,null,12495.025320469995,null,1924.5993516700003,null,45083.507572979994]
[null,"> 60 months",206317.92707867001,null,59314.293108860045,null,70954.570325759938,null,33273.697941089958,null,369860.48845437996]
[null,"Total",270661.35239409003,null,83707.229442880038,null,102468.63847051993,null,38290.445197009954,null,495127.66550449992]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",99431.572276080202,null,31959.762306654247,null,46297.45279967953,null,15369.001989551854,null,193057.78937196583]
[null,"20 - 40%",84512.354626702348,null,24814.097639877229,null,35372.952872858405,null,12637.928483251419,null,157337.33362268939]
[null,"40 - 60%",57801.616783474688,null,15940.070870613374,null,16511.842295086131,null,7709.9221740690709,null,97963.45212324326]
[null,"60 - 80%",24003.828059041054,null,6926.0434918531573,null,2812.8922212838793,null,2111.5564164193624,null,35854.320188597456]
[null,"> 80 %",4911.9806489816838,null,4067.2551341519902,null,1473.4982814520824,null,462.03613395829183,null,10914.770198544049]
[null,"Total",270661.35239427997,null,83707.229443150005,null,102468.63847036003,null,38290.445197250003,null,495127.66550503997]

{"sheet":"RD 2018 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 2018 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",172493.30971346985,null,52576.905660749959,null,19832.74753438,null,8351.6054771199979,null,253254.56838571982]
[null," - Number of loans",151515,null,9730,null,2866,null,2509,null,166620]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",167268.99295212995,null,51346.493828829953,null,19114.905935150004,null,8232.6980212400049,null,245963.09073734988]
[null," - repayment loans",121926.46963182994,null,45001.131254739958,null,17738.465547430005,null,5146.6928623500044,null,189812.75929634989]
[null," - interest-only ",45342.52332030001,null,6345.3625740899979,null,1376.44038772,null,3086.0051588900005,null,56150.331441000009]
[null,"FlexLån®",1075.2207226800001,null,1142.9113456500002,null,678.51806796000005,null,84.429416240000009,null,2981.0795525299995]
[null," - repayment loans",224.37273030999998,null,236.53180339999997,null,164.36042624999999,null,32.662427740000005,null,657.92738769999994]
[null," - interest-only ",850.84799237000004,null,906.37954224999999,null,514.15764171000001,null,51.766988500000011,null,2323.1521648299999]
[null,"FlexGaranti®, Rentedyk TM",4149.09603866,null,87.50048627000001,null,39.323531270000004,null,21.362500410000003,null,4297.2825566100009]
[null," - repayment loans",1951.08943163,null,63.344432370000014,null,38.321672,null,13.955897910000003,null,2066.7114339100003]
[null," - interest-only ",2198.0066070300004,null,24.1560539,null,1.00185927,null,7.4066025,null,2230.5711227000002]
[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",0,null,0,null,0,null,13.115539230000001,null,13.115539230000001]
[null," - repayment loans",0,null,0,null,0,null,0,null,0]
[null," - interest-only ",0,null,0,null,0,null,13.115539230000001,null,13.115539230000001]
[null," Total",172493.30971346993,null,52576.905660749959,null,19832.747534380003,null,8351.6054771200033,null,253254.5683857199]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",73408.06862737998,null,24528.033747490001,null,7759.2643545499986,null,703.33771849000027,null,106398.70444790999]
[null," - Other Sealand",32741.014376480009,null,5052.3386471800013,null,2464.7639215899999,null,1909.8784825200003,null,42167.995427770002]
[null," - Region South Denmark",29871.591787490001,null,8367.5135761599977,null,3615.8512504200003,null,3396.0796899799993,null,45251.036304050001]
[null," - Region Central Jutland",27399.213533740003,null,11869.918117289997,null,4034.4333654200004,null,1437.1206090000003,null,44740.685625449994]
[null," - Region North Jutland",9073.4213883800076,null,2759.1015726300002,null,1958.4346424,null,905.1889771299999,null,14696.146580540004]
[null," - Other area",0,null,0,null,0,null,0,null,0]
[null,"Total",172493.30971346999,null,52576.905660749995,null,19832.74753438,null,8351.6054771199997,null,253254.56838571999]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",100936.03748811998,null,2114.9212564400009,null,974.25560087999975,null,892.26832222999997,null,104917.48266766999]
[null," 2 - 5",61921.206556470002,null,3961.25812382,null,1469.8101080599997,null,1270.5911068000003,null,68622.865895149997]
[null," 5 - 20",9368.4495021599942,null,15805.182390089996,null,4745.9535948500024,null,2254.3297899299996,null,32173.915277029995]
[null," 20 - 50",222.41673846,null,11834.862770099999,null,4595.4341725000004,null,2481.8016186300001,null,19134.51529969]
[null," 50 - 100",45.199428259999998,null,7605.2131519099967,null,2955.5076551100005,null,1313.8450606500001,null,11919.765295929998]
[null," 100 and above",0,null,11255.467968390003,null,5091.7864029800012,null,138.76957887999998,null,16486.023950250004]
[null,"Total",172493.30971346996,null,52576.905660750002,null,19832.747534380003,null,8351.6054771199997,null,253254.56838571996]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",12673.541631350006,null,2165.8917853699995,null,2243.8125924899996,null,330.58520612999996,null,17413.831215340004]
[null,"> 12 - ≤ 24 months",11537.249204290007,null,3478.063927050001,null,1732.6566987399997,null,338.36696825999991,null,17086.336798340009]
[null,"> 24 - ≤ 36 months",8453.0127955900007,null,2901.1521306299983,null,1459.2879163399998,null,434.85632036000004,null,13248.309162919999]
[null,"> 36 - ≤ 60 months",18582.409276570001,null,4152.1128626399977,null,1875.2935629199999,null,456.08243577999997,null,25065.898137909997]
[null,"> 60 months",121247.09680566993,null,39879.684955059987,null,12521.69676388999,null,6791.7145465900012,null,180440.19307120991]
[null,"Total",172493.30971346996,null,52576.905660749988,null,19832.747534379989,null,8351.6054771200015,null,253254.5683857199]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",62031.341029805575,null,25617.146602859575,null,7448.6906080866474,null,3015.2982896513322,null,98112.476530403132]
[null,"20 - 40%",53605.033833358466,null,12782.775664728881,null,7278.6364567839173,null,2771.4900678104386,null,76437.936022681708]
[null,"40 - 60%",37142.573698511835,null,7128.4385179712672,null,4204.9412909930797,null,1968.3571860848049,null,50444.310693560983]
[null,"60 - 80%",16951.644329765983,null,3500.4666441566674,null,548.4668563674735,null,508.04092171665775,null,21508.61875200678]
[null,"> 80 %",2762.7168218980314,null,3548.0782308636121,null,352.0123221788823,null,88.419011776765629,null,6751.2263867172906]
[null,"Total",172493.3097133399,null,52576.90566058,null,19832.747534409998,null,8351.6054770399987,null,253254.56838536987]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":40,"n_cols":4,"rows_kept":40,"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]
[null,2017,31,50]
[null,"2018*",27,21]
[]
[null,"*2018Q2"]

{"sheet":"Repossed Properties - Quarter","index":4,"n_rows":67,"n_cols":5,"rows_kept":67,"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}]
[null,"2017 Q1",41,9,{"$f":"C62+D62","v":50}]
[null,"2017 Q2",36,9,{"$f":"C63+D63","v":45}]
[null,"2017 Q3",30,7,{"$f":"C64+D64","v":37}]
[null,"2017 Q4",26,5,{"$f":"C65+D65","v":31}]
[null,"2018 Q1",28,3,{"$f":"C66+D66","v":31}]
[null,"2018 Q2",24,3,{"$f":"C67+D67","v":27}]

{"sheet":"LTV","index":5,"n_rows":10,"n_cols":55,"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","2017 Q1","2017 Q2","2017 Q3","2017 Q4","2018 Q1","2018 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,65.734999999999999,64.723202000000001,64.628,64.430000000000007,63.746000000000002,63.35,62.92,62.22]
[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,54.387,53,52.76,52.17,52.36,51.02]
[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,59.094000000000001,59.28,58.594000000000001,58.15,56.8,56.98]
[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,68.769000000000005,69.680000000000007,67.759,69.56,68.099999999999994,67.36]
[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,63.621000000000002,63.51,62.624000000000002,62.68,62.12,61.36]

{"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 2018 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%",168.44825290323553,null,70.27089809660994,null,55.604440265945293,null,18.656129018835294,null,0.3926054758090366,null,312.97972028462607]
[null," - 20-40%",142.18557723027246,null,44.565586257148574,null,44.45666531183516,null,15.522990412974837,null,0.30950206801092095,null,246.73081921223104]
[null," - 40-60%",96.911332076309478,null,27.03017323250921,null,22.110320318515626,null,9.7078859538237889,null,0.19538683088344097,null,155.75971158115811]
[null," - 60-80%",41.683529652367362,null,12.766261463328068,null,3.9909989012283336,null,2.6440827295885247,null,7.6625589375469025E-2,null,61.084872746512289]
[null," - >80%",8.0120270217849239,null,9.6477401117543611,null,2.4131144523756709,null,0.55832939467749376,null,2.5880035921132478E-2,null,20.631210980592446]
[null,"Total",457.24071888396981,null,164.28065916135017,null,128.57553924990009,null,47.089417509899938,null,1,null,797.18633480511994]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",99.431572276080203,null,31.959762306654248,null,46.297452799679526,null,15.369001989551855,null,0.38991517303934747,null,193.05778937196584]
[null," - 20-40%",84.512354626702347,null,24.814097639877229,null,35.372952872858406,null,12.63792848325142,null,0.31777124282118679,null,157.33733362268941]
[null," - 40-60%",57.801616783474685,null,15.940070870613372,null,16.511842295086129,null,7.70992217406907,null,0.19785493509702914,null,97.963452123243243]
[null," - 60-80%",24.003828059041055,null,6.9260434918531573,null,2.8128922212838794,null,2.1115564164193623,null,7.2414293699434751E-2,null,35.854320188597455]
[null," - >80%",4.9119806489816833,null,4.0672551341519902,null,1.4734982814520825,null,0.46203613395829185,null,2.2044355343001823E-2,null,10.914770198544048]
[null,"Total",270.66135239427996,null,83.707229443149998,null,102.46863847036001,null,38.290445197250001,null,1,null,495.12766550504]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",62.031341029805574,null,25.617146602859574,null,7.4486906080866468,null,3.0152982896513323,null,0.38740654178884665,null,98.112476530403129]
[null," - 20-40%",53.605033833358469,null,12.782775664728879,null,7.278636456783917,null,2.7714900678104386,null,0.30182253575923013,null,76.437936022681697]
[null," - 40-60%",37.142573698511832,null,7.1284385179712659,null,4.2049412909930792,null,1.9683571860848048,null,0.19918420826589545,null,50.444310693560979]
[null," - 60-80%",16.951644329765983,null,3.5004666441566674,null,0.5484668563674735,null,0.50804092171665771,null,8.4928848032773716E-2,null,21.508618752006779]
[null," - >80%",2.7627168218980311,null,3.5480782308636121,null,0.35201232217888229,null,8.841901177676563E-2,null,2.665786615325395E-2,null,6.7512263867172901]
[null,"Total",172.4933097133399,null,52.576905660579996,null,19.83274753441,null,8.3516054770399997,null,0.99999999999999978,null,253.25456838536985]

{"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 2018 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%",83.290851155811268,null,217.34252086328402,null,12.346348265530681,null,312.97972028462601]
[null," - 20-40%",55.57818772411418,null,179.73150857998212,null,11.421122908134567,null,246.73081921223087]
[null," - 40-60%",30.733670736876505,null,115.89125157803733,null,9.1347892662445105,null,155.75971158115834]
[null," - 60-80%",11.559432046489967,null,44.49900626674372,null,5.026434433278653,null,61.084872746512339]
[null," - >80%",5.9812043618128596,null,11.527121679660873,null,3.1228849391186957,null,20.631210980592428]
[null,"Total",187.14334602510482,null,568.99140896770814,null,41.051579812307111,null,797.18633480512005]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",44.701560769399819,null,138.81580879715651,null,9.5404198054093072,null,193.05778937196564]
[null," - 20-40%",30.76418229128998,null,117.64919176141845,null,8.9239595699810224,null,157.33733362268947]
[null," - 40-60%",17.218882996000787,null,73.736666809366795,null,7.0079023178758071,null,97.963452123243385]
[null," - 60-80%",6.0763951786653347,null,25.941309435956377,null,3.8366155739757186,null,35.854320188597434]
[null," - >80%",2.5872094084311268,null,5.9033289111024025,null,2.4242318790105117,null,10.914770198544041]
[null,"Total",101.34823064378705,null,362.04630571500053,null,31.733129146252367,null,495.12766550504]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",27.502801239910617,null,68.437232926075481,null,2.172442364417059,null,98.112476530403171]
[null," - 20-40%",18.527290659162581,null,55.870301541876913,null,2.0403438216422987,null,76.437936022681782]
[null," - 40-60%",10.151195075335808,null,38.457500024299499,null,1.8356155939256849,null,50.444310693560993]
[null," - 60-80%",3.4979714091480276,null,16.995831585738223,null,1.0148157571205263,null,21.508618752006779]
[null," - >80%",1.656697088800257,null,4.5678138788813341,null,0.52671541903569541,null,6.7512263867172866]
[null,"Total",61.335955472357291,null,184.32867995687144,null,7.5899329561412641,null,253.25456838536999]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":45,"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","2017 Q1","2017 Q2","2017 Q3","2017 Q4","2018 Q1","2018 Q2"]
[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,0.28999999999999998,0.3,0.27,0.26,0.22,0.22]
[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,0.97,0.74,0.71,0.46,0.28999999999999998,0.24]
[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,1.38,1.18,0.8,0.69,1.27,1.49]
[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,0.14000000000000001,0.21,0.09,0.12,7.0000000000000007E-2,0.13]
[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,0.46,0.45,0.34,0.31,0.26,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",52576905660.749962,52576905660.749962]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",19832747534.379971,19832747534.379971]
["S-Landbrug","S",null,"Landbrug",8351605477.1199951,8351605477.1199951]
["S-Privat","S",null,"Privat",172493309713.47018,172493309713.47018]
["S Total-","S Total","S Total",null,253254568385.72009,253254568385.72009]
["T-Boligudl","T","T","Boligudl",83707229442.880051,80800170452.630051]
["T-Erhverv","T",null,"Erhverv",102468638470.52005,84864859230.220078]
["T-Landbrug","T",null,"Landbrug",38290445197.009987,38290445197.009987]
["T-Privat","T",null,"Privat",270661352394.09027,270661352394.09027]
["T Total-","T Total","T Total",null,495127665504.50037,474616827273.95038]
["Ø-Boligudl","Ø","Ø","Boligudl",27996524057.670025,27792979442.470024]
["Ø-Erhverv","Ø",null,"Erhverv",6274153245.0399961,5979712884.2799969]
["Ø-Landbrug","Ø",null,"Landbrug",447366835.56,447366835.56]
["Ø-Privat","Ø",null,"Privat",14086056776.389996,14086056776.389996]
["Ø Total-","Ø Total","Ø Total",null,48804100914.660019,48306115938.70002]
["Grand Total-","Grand Total","Grand Total",null,797186334804.88062,776177511598.37061]
[]
[]
[]
[]
[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":270661352394.09027}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":80800170452.630051}]
[null,null,"T-Erhverv","Erhverv","Commercial",84864859230.220078]
[null,null,"T-Landbrug","Landbrug","Agriculture",38290445197.009987]
[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":20510838230.549927}]
[]
[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":172493309713.47018}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":52576905660.749962}]
[null,null,"S-Erhverv","Erhverv","Commercial",19832747534.379971]
[null,null,"S-Landbrug","Landbrug","Agriculture",8351605477.1199951]
[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":0}]
[]
[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":14086056776.389996}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":27792979442.470024}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",5979712884.2799969]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",447366835.56]
[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":497984975.96000671}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":457240718883.95044}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":161170055555.85004}]
[null,null,null,null,"Commercial",110677319648.88005]
[null,null,null,null,"Agriculture",47089417509.68998]
[null,null,null,null,"Nordic",21008823206.509933]

{"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",2741843208.4899998,33355418.920000002]
[null,"F1",23128438159.509998,5387630895.9399996]
[null,"F3",33343603928.119999,8691500442.4899998]
[null,"F5",78653922488.229996,22704037277.220001]
[null,"Fixed",45387115072,10822495140.190001]
[null,"Floaters",14959137367.51,60461468739.010002]
[null,"Øv. flex",12526781779.99,18417829047.32]
["J Total",null,210740842003.84998,126518316961.09]
["N","CapFloat",10901203996.41,797042316.37]
[null,"F1",15136810324.93,18122742359.110001]
[null,"F3",21277921141.720001,9237093470.7800007]
[null,"F5",61610751157.269997,37482841201.889999]
[null,"Fixed",126475140627.41,95164805889.880005]
[null,"Floaters",6333182922.9099998,45634302231.07]
[null,"Øv. flex",4764866709.4700003,6988471490.4499998]
["N Total",null,246499876880.12,213427298959.55002]