{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2017 Q4 Total","RD 2017 Q4 Cap T","RD 2017 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 2017 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 2017 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",453904.75059140899,null,161855.00872981001,null,128301.89311562986,null,47776.026452120059,null,791837.67888896901]
[null," - Number of loans",409950,null,36269,null,12945,null,13662,null,472826]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",168882.42376570002,null,76909.974543459975,null,17893.261859320002,null,7904.4404360000017,null,271590.10060448002]
[null," - repayment loans",125566.10047765999,null,71109.090620729985,null,16521.046830200004,null,5079.5226889500018,null,218275.76061753999]
[null," - interest-only ",43316.323288040017,null,5800.8839227299995,null,1372.2150291200001,null,2824.9177470499999,null,53314.339986940024]
[null,"FlexLån®",248724.67993251982,null,65205.535660600013,null,37032.068534040016,null,25623.63630581,null,376585.92043296987]
[null," - repayment loans",101072.03460302003,null,41963.187351210021,null,21538.681246150016,null,9008.9498078400047,null,173582.85300822006]
[null," - interest-only ",147652.64532949982,null,23242.348309389992,null,15493.38728789,null,16614.686497969997,null,203003.06742474978]
[null,"FlexGaranti®, Rentedyk TM",14822.854826760009,null,441.26515765999989,null,226.22536513999995,null,221.05660664000007,null,15711.401956200007]
[null," - repayment loans",11663.394664910007,null,413.61737261999991,null,223.12058065999997,null,213.41138206000005,null,12513.544000250005]
[null," - interest-only ",3159.4601618500014,null,27.647785040000002,null,3.1047844800000002,null,7.6452245799999998,null,3197.8579559500013]
[null,"FlexKort®",21380.166620020005,null,2418.3146074700012,null,2495.9326162500006,null,7759.9045979599987,null,34054.318441700001]
[null," - repayment loans",6401.67853311,null,1252.7007650700004,null,1307.28295002,null,2003.0815432599995,null,10964.743791460001]
[null," - interest-only ",14978.488086910003,null,1165.6138424000005,null,1188.6496662300005,null,5756.8230546999994,null,23089.574650240007]
[null,"Other floating rate loans",94.625446409999995,null,16879.91876062001,null,70654.404740879938,null,6266.9885057099991,null,93895.937453619947]
[null," - repayment loans",50.697647270000004,null,5461.5874194800026,null,29374.204096209964,null,2060.3684342900001,null,36946.857597249968]
[null," - interest-only ",43.927799139999998,null,11418.331341140009,null,41280.200644669974,null,4206.6200714199986,null,56949.079856369979]
[null," Total",453904.75059140992,null,161855.00872981004,null,128301.89311562998,null,47776.026452120001,null,791837.67888896971]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",199342.93406195028,null,61244.892512749961,null,50961.04193853007,null,3468.0829050699958,null,315016.95141830033]
[null," - Other Sealand",87131.651856609911,null,17094.216747100003,null,10672.112075280011,null,13560.16584589,null,128458.14652487992]
[null," - Region South Denmark",71555.202360059862,null,28511.189366669991,null,24783.398881780009,null,16350.968870090002,null,141200.75947859988]
[null," - Region Central Jutland",72991.582002570038,null,38998.846712009981,null,18970.39609208997,null,8701.2341366399996,null,139662.05894331]
[null," - Region North Jutland",22882.672262829979,null,12805.67018555,null,5759.9695881700027,null,5695.5746944299999,null,47143.886730979983]
[null," - Other area",0.70804739000000005,null,3200.1932057299996,null,17154.974539780003,null,0,null,20355.875792900002]
[null,"Total",453904.75059141003,null,161855.00872980992,null,128301.89311563005,null,47776.026452119993,null,791837.67888897005]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",250350.95460657083,null,8288.2071641199964,null,3347.5136711200012,null,3208.2533461699973,null,265194.92878798081]
[null," 2 - 5",171102.65448699988,null,11707.195557840012,null,5358.4315263800017,null,6452.4084754999967,null,194620.69004671992]
[null," 5 - 20",31465.56870829999,null,45034.811118879996,null,19466.004318869989,null,15406.946910099998,null,111373.33105615]
[null," 20 - 50",928.78547114000003,null,37609.336948499993,null,18243.190385299993,null,14659.992547939997,null,71441.305352879994]
[null," 50 - 100",56.787318399999997,null,23130.689092689991,null,15776.458923900003,null,6337.2078939100011,null,45301.1432289]
[null," 100 and above",0,null,36084.768847779997,null,66110.294290060017,null,1711.2172784999996,null,103906.28041634003]
[null,"Total",453904.75059141073,null,161855.00872981001,null,128301.89311563001,null,47776.026452119993,null,791837.67888897075]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",27883.514014949989,null,8862.745747480003,null,9313.8689339000011,null,1242.13643841,null,47302.265134739995]
[null,"> 12 - ≤ 24 months",23278.730927159977,null,6763.0566103200008,null,7543.5050737999936,null,1447.8257276399993,null,39033.118338919965]
[null,"> 24 - ≤ 36 months",23015.178460930012,null,7463.8390207000002,null,8063.0281855699986,null,1600.0178517299992,null,40142.063518930008]
[null,"> 36 - ≤ 60 months",37407.506165669998,null,11849.563543100003,null,14322.585104550008,null,2337.7591888799998,null,65917.414002200007]
[null,"> 60 months",342319.82102269906,null,126915.80380820979,null,89058.90581780998,null,41148.287245460073,null,599442.81789417879]
[null,"Total",453904.75059140899,null,161855.00872980981,null,128301.89311562998,null,47776.026452120073,null,791837.67888896877]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",164595.07986849983,null,66891.378317852708,null,54241.920719235823,null,18514.722059774835,null,304243.10096536321]
[null,"20 - 40%",139572.37422412456,null,43763.090039560804,null,43763.851556362904,null,15607.808227560472,null,242707.12404760873]
[null,"40 - 60%",96652.343737289586,null,27372.384246852667,null,23494.308711242986,null,10076.451043378645,null,157595.48773876388]
[null,"60 - 80%",43692.274830778639,null,13329.510922298168,null,4199.1618054602686,null,2883.237626905378,null,64104.185185442453]
[null,"> 80 %",9392.6779302773375,null,10498.64520325565,null,2602.6503228581582,null,693.80749545070557,null,23187.780951841851]
[null,"Total",453904.75059096992,null,161855.00872981997,null,128301.89311516013,null,47776.026453070037,null,791837.67888902011]

{"sheet":"RD 2017 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 2017 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",268685.44279956032,null,81137.749351130027,null,100617.48555046997,null,39272.541450439974,null,489713.21915160021]
[null," - Number of loans",226894,null,16736,null,8594,null,10552,null,262776]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",13.219071619999999,null,73.5462828,null,14.842553499999999,null,3.9909706000000003,null,105.59887852000001]
[null," - repayment loans",2.3739729199999999,null,28.674409829999998,null,14.842553499999999,null,3.9909706000000003,null,49.88190685]
[null," - interest-only ",10.845098699999999,null,44.871872969999998,null,0,null,0,null,55.71697167]
[null,"FlexLån®",247207.40133182006,null,63659.467463210007,null,35957.00684853999,null,25499.162406419997,null,372323.03804999008]
[null," - repayment loans",100670.81552434999,null,41550.651960850024,null,20987.080063249992,null,8946.7192543699966,null,172155.26680282]
[null," - interest-only ",146536.58580747005,null,22108.81550235999,null,14969.926785289997,null,16552.443152050004,null,200167.77124717005]
[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®",21380.166620020005,null,2418.3146074700003,null,2495.9326162500001,null,7759.9045979599987,null,34054.318441700001]
[null," - repayment loans",6401.67853311,null,1252.7007650700004,null,1307.2829500200003,null,2003.0815432600002,null,10964.743791460001]
[null," - interest-only ",14978.488086910003,null,1165.6138424000001,null,1188.6496662300001,null,5756.8230546999985,null,23089.574650240007]
[null,"Other floating rate loans",84.655776100000011,null,14986.420997650002,null,62149.703532179963,null,6009.4834754599988,null,83230.263781389964]
[null," - repayment loans",42.736824640000009,null,4388.9455709300009,null,24925.251596519978,null,1842.5966897999995,null,31199.530681889981]
[null," - interest-only ",41.918951460000002,null,10597.475426720001,null,37224.451935659985,null,4166.8867856599991,null,52030.733099499987]
[null," Total",268685.44279956009,null,81137.749351130027,null,100617.48555046995,null,39272.541450439996,null,489713.21915159997]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",124499.96337984999,null,27963.476641480018,null,40243.442962769994,null,2762.4592433300008,null,195469.34222743]
[null," - Other Sealand",50090.577439600005,null,7786.7241501100025,null,7286.1928366500006,null,11562.698750070005,null,76726.19317643001]
[null," - Region South Denmark",38344.923896920009,null,15083.84057007001,null,19188.936478069998,null,12852.140312910002,null,85469.841257970023]
[null," - Region Central Jutland",43115.178861399996,null,20347.300403829984,null,13403.757780899994,null,7320.9023445399962,null,84187.139390669967]
[null," - Region North Jutland",12634.799221789995,null,7217.4766223799979,null,3676.410755319997,null,4774.3407995899988,null,28303.027399079991]
[null," - Other area",0,null,2738.9309632599998,null,16818.74473676,null,0,null,19557.675700019998]
[null,"Total",268685.44279956003,null,81137.749351129998,null,100617.48555046997,null,39272.541450439996,null,489713.21915160003]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",135178.96008534002,null,5173.9185527500031,null,1983.9775805300001,null,2099.8198662199984,null,144436.67608484003]
[null," 2 - 5",109902.64110201006,null,6053.0877788700027,null,3612.1082249200012,null,5059.1841423999967,null,124627.02124820006]
[null," 5 - 20",22874.574352699994,null,20624.253809650007,null,13797.309378969994,null,13066.497131889993,null,70362.634673209992]
[null," 20 - 50",672.47994111000003,null,16999.10300549,null,13142.330174690003,null,12293.162074769996,null,43107.075196059996]
[null," 50 - 100",56.787318399999997,null,12302.110994349998,null,10702.308028620004,null,5153.966384880001,null,28215.172726250003]
[null," 100 and above",0,null,19985.275210020016,null,57379.452162739995,null,1599.9118502799997,null,78964.639223040009]
[null,"Total",268685.44279956009,null,81137.749351130027,null,100617.48555047,null,39272.541450439989,null,489713.21915160009]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",15922.856174269993,null,5860.542360280002,null,6295.9500792999997,null,895.84925504000068,null,28975.197868889994]
[null,"> 12 - ≤ 24 months",13146.083271920004,null,3932.1767022399995,null,6024.9786805600015,null,1071.71796997,null,24174.956624690007]
[null,"> 24 - ≤ 36 months",11203.424279359995,null,4035.1811028100033,null,6311.6151534399996,null,1184.4998906300007,null,22734.720426239997]
[null,"> 36 - ≤ 60 months",21429.008460859994,null,8113.4268340699955,null,13338.945854220003,null,1831.2443532300006,null,44712.625502379997]
[null,"> 60 months",206984.07061314984,null,59196.422351730005,null,68645.995782949976,null,34289.22998157001,null,369115.71872939984]
[null,"Total",268685.44279955979,null,81137.749351129998,null,100617.48555046998,null,39272.541450440011,null,489713.21915159986]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",96808.812419244321,null,29738.248136359827,null,44055.465169703944,null,15360.632978988866,null,185963.15870429698]
[null,"20 - 40%",82653.488447668729,null,23577.21302791261,null,34820.740497519604,null,12826.983207326284,null,153878.42518042724]
[null,"40 - 60%",57714.834233571302,null,16190.758214319367,null,17597.664317398703,null,8150.3773678676562,null,99653.634133157029]
[null,"60 - 80%",25637.425425119818,null,7309.155777919399,null,2771.2299327696142,null,2354.3709274829152,null,38072.182063291752]
[null,"> 80 %",5870.8822741058411,null,4322.3741945987395,null,1372.3856328881402,null,580.17696930426985,null,12145.819070896991]
[null,"Total",268685.44279971003,null,81137.749351109946,null,100617.48555028001,null,39272.541450969991,null,489713.21915207]

{"sheet":"RD 2017 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 2017 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",169562.29553409995,null,52441.325357080015,null,21116.447395090032,null,7914.6428090100044,null,251034.71109527998]
[null," - Number of loans",149828,null,9591,null,2972,null,2445,null,164836]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",163614.72940305999,null,49938.316261370048,null,17471.95636847999,null,7709.8076345200006,null,238734.80966743006]
[null," - repayment loans",120363.03738899999,null,44182.304211610048,null,16099.741339359991,null,4884.8898874700026,null,185529.97282744004]
[null," - interest-only ",43251.692014060027,null,5756.012049760001,null,1372.2150291200001,null,2824.917747049999,null,53204.836839990028]
[null,"FlexLån®",1512.69071669,null,1546.0681973900005,null,1075.0616855000001,null,111.18382775000001,null,4245.00442733]
[null," - repayment loans",396.63119465999995,null,412.53539036000006,null,551.60118290000014,null,52.417980300000004,null,1413.1857482200001]
[null," - interest-only ",1116.0595220300002,null,1133.5328070300004,null,523.46050260000004,null,58.765847449999988,null,2831.8186791100002]
[null,"FlexGaranti®, Rentedyk TM",4432.8665666699999,null,90.718058180000014,null,42.129034479999994,null,21.729411000000002,null,4587.4430703300013]
[null," - repayment loans",1924.0056623800001,null,63.862491609999999,null,39.024250000000002,null,14.084186420000004,null,2040.9765904100002]
[null," - interest-only ",2508.8609042900002,null,26.855566570000004,null,3.1047844800000002,null,7.6452245800000007,null,2546.4664799200004]
[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",2.0088476800000001,null,866.2228401399999,null,2527.3003066300007,null,71.921935740000009,null,3467.4539301900004]
[null," - repayment loans",0,null,106.05011825,null,803.5489705,null,32.188649980000001,null,941.78773873]
[null," - interest-only ",2.0088476800000001,null,760.17272188999982,null,1723.7513361300005,null,39.733285760000008,null,2525.6661914600004]
[null," Total",169562.29553410001,null,52441.325357080044,null,21116.447395089992,null,7914.6428090099998,null,251034.71109528007]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",70945.080254930028,null,24327.359847400014,null,8601.5966713499965,null,665.26565706999975,null,104539.30243075003]
[null," - Other Sealand",32435.888879920007,null,5117.2835025299992,null,2810.5811508100005,null,1847.7734190800013,null,42211.526952340006]
[null," - Region South Denmark",29826.47852663001,null,8162.6139309899972,null,3764.7384189299978,null,3275.9309585299998,null,45029.761835080004]
[null," - Region Central Jutland",27221.176964539995,null,11728.509725179996,null,4066.9090280399992,null,1258.0299624599998,null,44274.625680219986]
[null," - Region North Jutland",9133.6709080799992,null,2854.4614484299982,null,1838.2150739699996,null,867.64281187000017,null,14693.990242349999]
[null," - Other area",0,null,251.09690255000001,null,34.407051989999999,null,0,null,285.50395454]
[null,"Total",169562.29553410001,null,52441.325357080008,null,21116.447395089996,null,7914.6428090099998,null,251034.71109528004]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",101417.53165132004,null,2110.5296009000003,null,997.89263831999949,null,902.20145232000016,null,105428.15534286003]
[null," 2 - 5",59384.066715270012,null,4013.1138840099998,null,1601.39596345,null,1264.1360111700003,null,66262.712573900004]
[null," 5 - 20",8504.3916374799992,null,15651.885765869998,null,5036.4099301999986,null,2230.2375779600002,null,31422.924911509996]
[null," 20 - 50",256.30553002999994,null,11812.993490370005,null,4473.9695827699989,null,2230.6749030599999,null,18773.943506230004]
[null," 50 - 100",0,null,7295.6677511600037,null,3914.3401451100003,null,1176.8395197899997,null,12386.847416060004]
[null," 100 and above",0,null,11557.13486477,null,5092.4391352399998,null,110.55334471,null,16760.12734472]
[null,"Total",169562.29553410006,null,52441.325357080001,null,21116.447395089996,null,7914.6428090099998,null,251034.71109528004]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",11935.750430109998,null,2968.4965908000008,null,2547.2597822599996,null,346.28718336999998,null,17797.793986539997]
[null,"> 12 - ≤ 24 months",10103.700955359998,null,2772.5679581599993,null,1276.0329486500002,null,374.43932432999998,null,14526.741186499998]
[null,"> 24 - ≤ 36 months",11786.352961849996,null,3375.78963196,null,1737.4883764399999,null,412.97810578999997,null,17312.609076039997]
[null,"> 36 - ≤ 60 months",15887.990307089996,null,3540.2543720000008,null,973.17599871999994,null,482.14848967000006,null,20883.569167479996]
[null,"> 60 months",119848.50087968993,null,39784.216804159973,null,14582.490289020001,null,6298.7897058499966,null,180513.9976787199]
[null,"Total",169562.29553409992,null,52441.325357079972,null,21116.447395089999,null,7914.6428090099962,null,251034.7110952799]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",60240.19018256179,null,24675.383892881237,null,8331.2256148278939,null,2810.4099822155986,null,96057.209672486511]
[null,"20 - 40%",52425.31790516217,null,13113.332774635783,null,7099.2036398320242,null,2629.8641018163448,null,75267.71842144632]
[null,"40 - 60%",36658.671119072853,null,7042.1955977452653,null,4487.6355295254198,null,1871.3289619380594,null,50059.83120828159]
[null,"60 - 80%",17161.761831598451,null,3568.901015650571,null,782.86307708484242,null,499.06840754971319,null,22012.594331883578]
[null,"> 80 %",3076.3544951747704,null,4041.512076407153,null,415.51953367981707,null,103.97135581028294,null,7637.3574610720234]
[null,"Total",169562.29553357002,null,52441.325357320005,null,21116.447394950002,null,7914.6428093299992,null,251034.71109517]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":39,"n_cols":4,"rows_kept":39,"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,"*2017Q4"]

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

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

{"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 2017 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%",164.59507986849982,null,66.891378317852713,null,54.241920719235821,null,18.514722059774833,null,0.38422407657113317,null,304.24310096536317]
[null," - 20-40%",139.57237422412456,null,43.763090039560808,null,43.763851556362908,null,15.607808227560472,null,0.30651120869637899,null,242.70712404760874]
[null," - 40-60%",96.652343737289584,null,27.372384246852668,null,23.494308711242986,null,10.076451043378645,null,0.19902499204114241,null,157.59548773876389]
[null," - 60-80%",43.692274830778643,null,13.329510922298168,null,4.1991618054602684,null,2.8832376269053777,null,8.0956219809321522E-2,null,64.104185185442461]
[null," - >80%",9.3926779302773387,null,10.49864520325565,null,2.6026503228581581,null,0.69380749545070552,null,2.928350288202405E-2,null,23.187780951841852]
[null,"Total",453.90475059096997,null,161.85500872982001,null,128.30189311516014,null,47.776026453070038,null,1.0000000000000002,null,791.83767888902025]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",96.808812419244319,null,29.738248136359829,null,44.055465169703943,null,15.360632978988868,null,0.37973889907707409,null,185.96315870429694]
[null," - 20-40%",82.653488447668735,null,23.57721302791261,null,34.820740497519608,null,12.826983207326284,null,0.31422150589862596,null,153.87842518042726]
[null," - 40-60%",57.714834233571302,null,16.190758214319366,null,17.597664317398703,null,8.1503773678676552,null,0.20349386178650761,null,99.653634133157027]
[null," - 60-80%",25.637425425119819,null,7.3091557779193996,null,2.7712299327696144,null,2.3543709274829152,null,7.7743831643370953E-2,null,38.072182063291748]
[null," - >80%",5.8708822741058411,null,4.3223741945987397,null,1.3723856328881403,null,0.58017696930426976,null,2.4801901594421465E-2,null,12.145819070896991]
[null,"Total",268.68544279971002,null,81.137749351109932,null,100.61748555028002,null,39.272541450969996,null,1,null,489.71321915206994]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",60.24019018256179,null,24.675383892881232,null,8.3312256148278934,null,2.8104099822155986,null,0.38264513004367023,null,96.057209672486508]
[null," - 20-40%",52.425317905162167,null,13.113332774635783,null,7.0992036398320248,null,2.6298641018163447,null,0.29982992428848415,null,75.267718421446318]
[null," - 40-60%",36.658671119072856,null,7.0421955977452653,null,4.48763552952542,null,1.8713289619380593,null,0.19941398139679326,null,50.059831208281601]
[null," - 60-80%",17.161761831598451,null,3.5689010156505709,null,0.78286307708484248,null,0.49906840754971321,null,8.7687452607055461E-2,null,22.01259433188358]
[null," - >80%",3.0763544951747703,null,4.0415120764071535,null,0.41551953367981709,null,0.10397135581028294,null,3.0423511663997014E-2,null,7.6373574610720247]
[null,"Total",169.56229553357005,null,52.441325357320004,null,21.116447394950001,null,7.9146428093299983,null,1,null,251.03471109517002]

{"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 2017 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%",77.601884141686369,null,212.98126077284687,null,13.659956050829964,null,304.24310096536323]
[null," - 20-40%",52.270792024405566,null,177.75234540560601,null,12.683986617596716,null,242.70712404760826]
[null," - 40-60%",29.364762802478591,null,117.97650918768429,null,10.254215748601334,null,157.59548773876421]
[null," - 60-80%",11.408947640207305,null,46.852727115377654,null,5.8425104298576391,null,64.104185185442603]
[null," - >80%",6.0191013867682086,null,13.149012145247761,null,4.0196674198258648,null,23.187780951841834]
[null,"Total",176.66548799554604,null,568.7118546267626,null,46.460336266711515,null,791.83767888902014]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",41.511112405269273,null,133.9839685347755,null,10.46807776425212,null,185.96315870429689]
[null," - 20-40%",28.917331490400876,null,115.14475580474917,null,9.8163378852773437,null,153.87842518042737]
[null," - 40-60%",16.390934898491025,null,75.449088857078934,null,7.813610377587092,null,99.653634133157055]
[null," - 60-80%",5.9884364256289064,null,27.663397355062958,null,4.4203482825999201,null,38.072182063291784]
[null," - >80%",2.757076836508479,null,6.418938542499669,null,2.9698036918888464,null,12.145819070896994]
[null,"Total",95.564892056298547,null,358.66014909416623,null,35.488178001605327,null,489.71321915207011]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",25.328260684203887,null,68.347311434443967,null,2.3816375538386101,null,96.057209672486465]
[null," - 20-40%",17.212470368578586,null,55.758950710702415,null,2.2962973421653894,null,75.267718421446389]
[null," - 40-60%",9.5896076586790944,null,38.431227756863279,null,2.0389957927392111,null,50.05983120828158]
[null," - 60-80%",3.380984234546295,null,17.454769145020904,null,1.1768409523163641,null,22.012594331883566]
[null," - >80%",1.3838968143536252,null,5.4390257688337647,null,0.81443487788462909,null,7.6373574610720194]
[null,"Total",56.895219760361492,null,185.43128481586436,null,8.7082065189442037,null,251.03471109517005]

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

{"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",52441325357.080017,52190228454.530022]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21116447395.090023,21082040343.100025]
["S-Landbrug","S",null,"Landbrug",7914642809.0099983,7914642809.0099983]
["S-Privat","S",null,"Privat",169562295534.1004,169562295534.1004]
["S Total-","S Total","S Total",null,251034711095.28046,250749207140.74045]
["T-Boligudl","T","T","Boligudl",81137749351.13002,78398818387.86998]
["T-Erhverv","T",null,"Erhverv",100617485550.46988,83798740813.709991]
["T-Landbrug","T",null,"Landbrug",39272541450.440033,39272541450.440033]
["T-Privat","T",null,"Privat",268685442799.56003,268685442799.56003]
["T Total-","T Total","T Total",null,489713219151.59998,470155543451.58002]
["Ø-Boligudl","Ø","Ø","Boligudl",28275934021.599998,28067757884.919998]
["Ø-Erhverv","Ø",null,"Erhverv",6567960170.0699997,6266137419.039999]
["Ø-Landbrug","Ø",null,"Landbrug",588842192.67000008,588842192.67000008]
["Ø-Privat","Ø",null,"Privat",15657012257.75001,15657012257.75001]
["Ø Total-","Ø Total","Ø Total",null,51089748642.090004,50579749754.380005]
["Grand Total-","Grand Total","Grand Total",null,791837678888.97046,771484500346.70068]
[]
[]
[]
[]
[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":268685442799.56003}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":78398818387.86998}]
[null,null,"T-Erhverv","Erhverv","Commercial",83798740813.709991]
[null,null,"T-Landbrug","Landbrug","Agriculture",39272541450.440033]
[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":19557675700.019897}]
[]
[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":169562295534.1004}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":52190228454.530022}]
[null,null,"S-Erhverv","Erhverv","Commercial",21082040343.100025]
[null,null,"S-Landbrug","Landbrug","Agriculture",7914642809.0099983]
[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":285503954.53997803}]
[]
[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":15657012257.75001}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":28067757884.919998}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",6266137419.039999]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",588842192.67000008]
[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":509998887.70999908}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":453904750591.4104}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":158656804727.32001}]
[null,null,null,null,"Commercial",111146918575.85001]
[null,null,null,null,"Agriculture",47776026452.120026]
[null,null,null,null,"Nordic",20353178542.269875]

{"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",3159460161.8400002,38397794.100000001]
[null,"F1",21855217666.560001,5958356600.1599998]
[null,"F3",37606158288.099998,9352089832.2700005]
[null,"F5",74916504470.160004,22351337691.880001]
[null,"Fixed",43316323288.029999,9998016698.9200001]
[null,"Floaters",15022415886.08,65016238620.629997]
[null,"Øv. flex",13274764904.690001,17688637970.959999]
["J Total",null,209150844665.45999,130403075208.91998]
["N","CapFloat",11663394664.9,850149335.39999998]
[null,"F1",15450416840,9062392872.8400002]
[null,"F3",26178743089.610001,9911119362.8500004]
[null,"F5",54181229543.68,46006543877.480003]
[null,"Fixed",125566100477.64999,92709660139.809998]
[null,"Floaters",6452376180.3599997,41459225208.339996]
[null,"Øv. flex",5261645129.6400003,7530762292.0200005]
["N Total",null,244753905925.84,207529853088.73999]