{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2016 Q3 Total","RD 2016 Q3 Cap T","RD 2016 Q3 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 Q3 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 Q3 - 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",440535.83130471007,null,155638.84817514999,null,126912.42250760991,null,48529.168887480009,null,771616.27087494999]
[null," - Number of loans",412811,null,37864,null,14102,null,14420,null,479197]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",155392.54990736014,null,72968.730099479944,null,14558.238343820027,null,6120.3345450100005,null,249039.8528956701]
[null," - repayment loans",116978.2184790301,null,69139.655573749958,null,13436.190817730027,null,4021.3760826000012,null,203575.44095311008]
[null," - interest-only ",38414.331428330042,null,3829.0745257300009,null,1122.0475260900002,null,2098.9584624099994,null,45464.411942560037]
[null,"FlexLån®",249078.56826628032,null,62175.437520590021,null,43721.035850449982,null,25638.870001510004,null,380613.91163883032]
[null," - repayment loans",92774.980692130004,null,37444.089985180013,null,20384.576049959986,null,7917.98061349,null,158521.62734076002]
[null," - interest-only ",156303.5875741503,null,24731.347535410005,null,23336.459800489996,null,17720.889388020005,null,222092.2842980703]
[null,"FlexGaranti®, Rentedyk TM",18256.303394370014,null,552.14582505999965,null,318.75703331,null,316.94760483000005,null,19444.153857570011]
[null," - repayment loans",12033.042019810006,null,461.47781005999968,null,300.19357616000002,null,232.41060733,null,13027.124013360004]
[null," - interest-only ",6223.2613745600083,null,90.668015000000011,null,18.563457149999998,null,84.536997499999998,null,6417.0298442100075]
[null,"FlexKort®",17690.958339309993,null,2603.0019845899992,null,2564.9381926900001,null,8358.4058639800005,null,31217.304380569993]
[null," - repayment loans",5259.8966140899993,null,1233.8030796799994,null,1373.5499694400003,null,1974.2204157899992,null,9841.4700789999988]
[null," - interest-only ",12431.061725219995,null,1369.1989049099998,null,1191.3882232499998,null,6384.1854481900018,null,21375.834301569997]
[null,"Other floating rate loans",117.45139738999998,null,17339.53274543001,null,65749.453087340051,null,8094.6108721500004,null,91301.048102310058]
[null," - repayment loans",34.268461309999992,null,4845.9896862900032,null,22628.977577880014,null,1898.1056988900004,null,29407.341424370014]
[null," - interest-only ",83.18293607999999,null,12493.543059140005,null,43120.47550946004,null,6196.5051732600004,null,61893.706677940041]
[null," Total",440535.83130471047,null,155638.84817514999,null,126912.42250761006,null,48529.168887480009,null,771616.27087495045]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",186785.59049065993,null,57522.827176889936,null,49213.242364230005,null,3507.1899702900037,null,297028.85000206984]
[null," - Other Sealand",86729.217134689956,null,17432.923020820032,null,10268.741691249994,null,13482.461192819996,null,127913.34303957997]
[null," - Region South Denmark",71047.335776020074,null,28129.431696049982,null,25811.676900300019,null,16359.380236920009,null,141347.82460929011]
[null," - Region Central Jutland",72738.607335880079,null,36061.712065989945,null,19990.934498649971,null,9097.8781466499986,null,137889.13204716999]
[null," - Region North Jutland",23233.973556219971,null,13481.632156640006,null,6473.1684342100007,null,6082.259340800003,null,49271.03348786998]
[null," - Other area",1.1070112400000001,null,3010.3220587600003,null,15154.658618969997,null,0,null,18166.087688969998]
[null,"Total",440535.83130471001,null,155638.84817514991,null,126912.42250761,null,48529.168887480009,null,771616.27087494987]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",256204.09463520019,null,9063.3259548799961,null,3700.9010151700013,null,3340.3180923700002,null,272308.63969762024]
[null," 2 - 5",157830.52171456962,null,12414.22519979999,null,5843.0016372200071,null,6692.8603305500001,null,182780.60888213958]
[null," 5 - 20",25725.681448419993,null,44830.544212349843,null,21288.384596680004,null,15845.777497119991,null,107690.38775456983]
[null," 20 - 50",718.55923636000011,null,36632.193316459961,null,19424.807184669997,null,14459.389375420005,null,71234.949112909977]
[null," 50 - 100",56.974270159999996,null,21831.789063579999,null,16548.257656400001,null,6430.5656629700034,null,44867.586653110004]
[null," 100 and above",0,null,30866.770428079995,null,60107.070417470022,null,1760.2579290499998,null,92734.098774600017]
[null,"Total",440535.83130470972,null,155638.84817514979,null,126912.42250761004,null,48529.168887480002,null,771616.2708749494]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",39055.407405490019,null,6991.6372131999997,null,9588.8207851499919,null,2269.1400980499993,null,57905.005501890017]
[null,"> 12 - ≤ 24 months",38170.633131949937,null,7575.7921658099949,null,12157.274899900012,null,3113.4340755400008,null,61017.134273199947]
[null,"> 24 - ≤ 36 months",30118.821052670031,null,6210.5766738500024,null,11715.06038038,null,2080.2829397200017,null,50124.741046620038]
[null,"> 36 - ≤ 60 months",101700.15871206025,null,13677.122111369994,null,15163.126330190022,null,3683.9311559800008,null,134224.33830960025]
[null,"> 60 months",231490.81100253994,null,121183.72001092003,null,78288.140111989997,null,37382.380618189978,null,468345.05174363998]
[null,"Total",440535.83130471018,null,155638.84817515002,null,126912.42250761001,null,48529.16888747998,null,771616.27087495022]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",154657.99904179163,null,62957.87053589047,null,50039.012845463891,null,18645.590914731431,null,286300.47333787737]
[null,"20 - 40%",132326.30173781732,null,42005.657867977527,null,41094.654225872764,null,15703.810459457967,null,231130.42429112559]
[null,"40 - 60%",94846.432158487689,null,27436.409658907738,null,25864.750113861723,null,10135.531884100354,null,158283.12381535748]
[null,"60 - 80%",45998.532933688264,null,13527.51645452294,null,6572.0895839585855,null,3258.0462206968209,null,69356.185192866615]
[null,"> 80 %",12706.565432745574,null,9711.3936576110482,null,3341.9157383430706,null,786.18940779341347,null,26546.064236493108]
[null,"Total",440535.8313045305,null,155638.84817490974,null,126912.42250750003,null,48529.168886779982,null,771616.27087372006]

{"sheet":"RD 2016 Q3 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 Q3 - 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",263195.0850767201,null,75563.515975449889,null,98879.279148779882,null,39804.440699920058,null,477442.32090086985]
[null," - Number of loans",230192,null,17336,null,9258,null,11054,null,267840]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",28.703208110000006,null,0,null,0,null,17.224453370000003,null,45.927661480000005]
[null," - repayment loans",4.6003393100000007,null,0,null,0,null,8.0763646300000005,null,12.676703940000001]
[null," - interest-only ",24.102868800000003,null,0,null,0,null,9.1480887400000004,null,33.250957540000009]
[null,"FlexLån®",245398.89145217001,null,58527.624109780023,null,40595.756238370013,null,25340.946910610015,null,369863.21871093003]
[null," - repayment loans",91888.467217360012,null,36813.937115550019,null,19968.299484880001,null,7848.0548866700074,null,156518.75870446005]
[null," - interest-only ",153510.42423480999,null,21713.686994230004,null,20627.456753490005,null,17492.892023940007,null,213344.46000647004]
[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®",17690.958339309993,null,2603.0019845900001,null,2564.9381926900005,null,8358.4058639799969,null,31217.304380569993]
[null," - repayment loans",5259.8966140899993,null,1233.8030796799997,null,1373.5499694399998,null,1974.2204157900003,null,9841.4700789999988]
[null," - interest-only ",12431.061725219995,null,1369.1989049100002,null,1191.3882232500005,null,6384.1854481899973,null,21375.834301569994]
[null,"Other floating rate loans",76.53207712999999,null,14432.889881080006,null,55718.584717720034,null,6087.8634719600013,null,76315.870147890033]
[null," - repayment loans",25.955877439999995,null,4539.0738756800001,null,20235.457954530022,null,1605.2945727100002,null,26405.782280360021]
[null," - interest-only ",50.576199690000003,null,9893.8160054000055,null,35483.126763190012,null,4482.5688992500009,null,49910.087867530012]
[null," Total",263195.08507672005,null,75563.515975450035,null,98879.279148780042,null,39804.440699920015,null,477442.3209008702]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",117895.75835924999,null,24931.806768109982,null,38785.462432060005,null,2931.3752778099988,null,184544.40283722995]
[null," - Other Sealand",50684.116129950053,null,7721.7482140300044,null,7141.2856430000029,null,11593.041662540019,null,77140.191649520086]
[null," - Region South Denmark",38309.314618080018,null,14397.978594149992,null,19818.464139689997,null,12578.366322619997,null,85104.123674540009]
[null," - Region Central Jutland",43396.169863159994,null,18614.689924850016,null,13967.216759899991,null,7561.2908360799993,null,83539.36738399]
[null," - Region North Jutland",12909.726106280003,null,7345.4930433800009,null,4348.8646003100002,null,5140.3666008699993,null,29744.450350840005]
[null," - Other area",0,null,2551.7994309299997,null,14817.98557382,null,0,null,17369.78500475]
[null,"Total",263195.08507672005,null,75563.515975449991,null,98879.279148779999,null,39804.440699920015,null,477442.32090087008]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",140083.21027064996,null,5619.8494684200004,null,2165.3209715900011,null,2152.7673279599994,null,150021.14803861995]
[null," 2 - 5",103490.30842431,null,6523.1509889200042,null,3981.3447726400013,null,5180.330191540007,null,119175.13437741001]
[null," 5 - 20",19086.98682670002,null,20317.219708580003,null,15320.830070090018,null,13326.247483200004,null,68051.284088570043]
[null," 20 - 50",477.6052848999999,null,16645.091552029997,null,13947.599392750004,null,12133.892325360013,null,43204.188555040018]
[null," 50 - 100",56.974270159999996,null,11473.244182429999,null,10902.899421030004,null,5359.8253812299972,null,27792.943254849997]
[null," 100 and above",0,null,14984.960075069999,null,52561.284520680012,null,1651.3779906300001,null,69197.622586380021]
[null,"Total",263195.08507671999,null,75563.515975450005,null,98879.279148780042,null,39804.440699920022,null,477442.32090087008]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",24099.09104260998,null,5678.7135521,null,7804.9357233100027,null,1833.7386149600011,null,39416.47893297999]
[null,"> 12 - ≤ 24 months",18495.520436330004,null,4750.9614716399992,null,10264.69852451,null,2453.1728349300006,null,35964.353267410006]
[null,"> 24 - ≤ 36 months",18936.413019420004,null,4054.7050422599987,null,10953.66649216,null,1713.6802131499992,null,35658.464766990008]
[null,"> 36 - ≤ 60 months",52285.510387290036,null,9161.4525407900037,null,12730.464024959998,null,2822.8259951799996,null,77000.252948220033]
[null,"> 60 months",149378.55019107004,null,51917.683368659978,null,57125.514383840025,null,30981.023041700006,null,289402.77098527004]
[null,"Total",263195.08507672005,null,75563.515975449976,null,98879.279148780028,null,39804.440699920007,null,477442.32090087008]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",91483.535582386059,null,27136.302238435153,null,40691.721768538358,null,15222.899919558022,null,174534.45950891761]
[null,"20 - 40%",78776.787652304949,null,21761.617912526111,null,32952.563483678867,null,12877.89783671773,null,146368.86688522768]
[null,"40 - 60%",57222.03812293653,null,15458.168740546187,null,19342.385755701671,null,8325.7405454844065,null,100348.33316466879]
[null,"60 - 80%",27755.944232954116,null,7232.8517627666979,null,4326.9653646090283,null,2712.4482895480096,null,42028.209649877848]
[null,"> 80 %",7956.7794857284644,null,3974.575321155849,null,1565.6427760121392,null,665.45410825185616,null,14162.451691148308]
[null,"Total",263195.08507631015,null,75563.515975430011,null,98879.279148540067,null,39804.440699560022,null,477442.32089984027]

{"sheet":"RD 2016 Q3 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 Q3 - 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",155655.56031455984,null,48672.390799549925,null,19935.159025789992,null,7592.9641177600006,null,231856.07425765978]
[null," - Number of loans",139501,null,8957,null,2983,null,2333,null,153774]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",147178.19379256008,null,44204.06785911,null,13840.844478780024,null,5684.5007226400012,null,210907.60685309008]
[null," - repayment loans",109264.12999535006,null,40390.037091449994,null,12722.757286920023,null,3600.8414191900006,null,165977.76579291007]
[null," - interest-only ",37914.063797210038,null,3814.0307676600009,null,1118.0871918600003,null,2083.6593034500006,null,44929.841060180035]
[null,"FlexLån®",3423.9846399999992,null,2843.2029271900005,null,2235.9275101099997,null,195.9090415,null,8699.0241188]
[null," - repayment loans",850.04102827999998,null,431.44824943000009,null,380.78651796999998,null,47.185687809999997,null,1709.4614834900001]
[null," - interest-only ",2573.9436117199989,null,2411.7546777600005,null,1855.1409921399998,null,148.72335369000001,null,6989.5626353099988]
[null,"FlexGaranti®, Rentedyk TM",5033.2796838199984,null,105.31290883000001,null,47.278079390000009,null,28.786486010000004,null,5214.6571580499995]
[null," - repayment loans",1985.295518489999,null,62.515682400000003,null,40.486592890000011,null,16.129811110000002,null,2104.4276048899992]
[null," - interest-only ",3047.98416533,null,42.797226430000002,null,6.7914865000000004,null,12.656674900000002,null,3110.2295531599998]
[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.102198179999998,null,1519.8071044199999,null,3811.1089575100004,null,1683.7678676100002,null,7034.78612772]
[null," - repayment loans",6.3561881899999992,null,170.42669431000002,null,956.15172040000004,null,206.06224093,null,1338.9968438300002]
[null," - interest-only ",13.746009990000001,null,1349.38041011,null,2854.9572371100003,null,1477.70562668,null,5695.7892838900007]
[null," Total",155655.56031456005,null,48672.390799550005,null,19935.159025790021,null,7592.9641177600015,null,231856.07425766008]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",63152.036869050033,null,22827.304674259984,null,7891.9838210800008,null,529.68343872999992,null,94401.008803120014]
[null," - Other Sealand",29873.822908900009,null,4917.0054444099987,null,2296.1656670099992,null,1639.3692036100003,null,38726.363223930006]
[null," - Region South Denmark",28113.88680348,null,7713.2961622099956,null,3994.2045896999998,null,3327.8600004900009,null,43149.247555879992]
[null," - Region Central Jutland",25720.817126969974,null,9895.1728702099954,null,3953.8014548900001,null,1265.3176833699993,null,40835.109135439969]
[null," - Region North Jutland",8794.9966061600026,null,3067.8514946899991,null,1764.5055578100003,null,830.7337915600001,null,14458.087450219999]
[null," - Other area",0,null,251.76015377000002,null,34.497935299999995,null,0,null,286.25808906999998]
[null,"Total",155655.56031456002,null,48672.390799549969,null,19935.159025790002,null,7592.9641177600006,null,231856.07425765996]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",97611.250788580059,null,2092.5018315199995,null,998.64426859000014,null,862.69058046000032,null,101565.08746915006]
[null," 2 - 5",51418.695244480048,null,3919.1945830999998,null,1620.9599726200004,null,1277.8305474300003,null,58236.680347630048]
[null," 5 - 20",6434.2290194199968,null,14658.57352978,null,5003.2353259800011,null,2254.0190440399997,null,28350.056919220002]
[null," 20 - 50",191.38526208000002,null,10320.787622720001,null,4849.9793314199987,null,2161.2629231499996,null,17523.415139370001]
[null," 50 - 100",0,null,6397.8477051400005,null,3595.0959614399999,null,979.99911637000014,null,10972.94278295]
[null," 100 and above",0,null,11283.485527289999,null,3867.2441657400004,null,57.161906309999992,null,15207.891599339999]
[null,"Total",155655.56031456008,null,48672.390799550005,null,19935.159025790002,null,7592.9641177600006,null,231856.07425766013]
[]
[null,"Bond debt outstanding by seasoning"]
[null,"≤ 12 months",14788.197266479994,null,1255.804039430001,null,1434.2730167899999,null,414.73875089000006,null,17893.013073589991]
[null,"> 12 - ≤ 24 months",19485.621092759993,null,2700.5395690700016,null,1855.2800999100007,null,648.14922768999998,null,24689.589989429991]
[null,"> 24 - ≤ 36 months",11015.655609469995,null,1982.3928530499991,null,745.71497859999988,null,356.36834169999997,null,14100.131782819995]
[null,"> 36 - ≤ 60 months",40270.960457780006,null,4322.4796907799991,null,1630.4785506499995,null,752.44137906000003,null,46976.360078270001]
[null,"> 60 months",70095.125888070048,null,38411.174647219901,null,14269.412379839992,null,5421.2664184200039,null,128196.97933354994]
[null,"Total",155655.56031456005,null,48672.390799549903,null,19935.159025789992,null,7592.9641177600042,null,231856.0742576599]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",53422.787195023797,null,22653.811618301334,null,6893.5686588329318,null,2722.4417050840675,null,85692.60917724212]
[null,"20 - 40%",47450.955918332787,null,12623.183699512028,null,6267.4773009129058,null,2540.0279921193683,null,68881.64491087709]
[null,"40 - 60%",34200.334629903336,null,7108.692031528908,null,4628.0578581788131,null,1702.5371565820358,null,47639.621676193099]
[null,"60 - 80%",16700.827132023074,null,3372.4418878537931,null,1381.9178105768053,null,517.00588545874621,null,21972.192715912421]
[null,"> 80 %",3880.6554392970338,null,2914.2615622439657,null,764.13739740853828,null,110.95137826578448,null,7670.0057772153223]
[null,"Total",155655.56031458001,null,48672.390799440029,null,19935.159025909998,null,7592.9641175100023,null,231856.07425744005]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"End year","Stock","Repossed in year"]
[null,1986,471,933]
[null,1987,630,1238]
[null,1988,1562,2797]
[null,1989,2654,4209]
[null,1990,3201,4213]
[null,1991,2463,3950]
[null,1992,2331,3441]
[null,1993,1720,3264]
[null,1994,732,1479]
[null,1995,215,572]
[null,1996,97,265]
[null,1997,32,198]
[null,1998,24,107]
[null,1999,15,87]
[null,2000,28,109]
[null,2001,54,117]
[null,2002,51,169]
[null,2003,51,158]
[null,2004,26,101]
[null,2005,13,47]
[null,2006,1,16]
[null,2007,4,6]
[null,2008,23,46]
[null,2009,37,58]
[null,2010,164,235]
[null,2011,161,217]
[null,2012,156,198]
[null,2013,122,164]
[null,2014,70,108]
[null,2015,58,78]
[null,"2016*",56,58]
[]
[null,"*2016Q3"]

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

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

{"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 Q3"]
[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%",154.65799904179161,null,62.957870535890471,null,50.039012845463887,null,18.645590914731429,null,0.37103996396251765,null,286.30047333787741]
[null," - 20-40%",132.32630173781735,null,42.005657867977526,null,41.094654225872766,null,15.703810459457967,null,0.29954063051238011,null,231.13042429112562]
[null," - 40-60%",94.846432158487687,null,27.436409658907738,null,25.864750113861721,null,10.135531884100354,null,0.20513191568152084,null,158.2831238153575]
[null," - 60-80%",45.99853293368826,null,13.52751645452294,null,6.5720895839585856,null,3.2580462206968206,null,8.9884295874596939E-2,null,69.356185192866604]
[null," - >80%",12.706565432745576,null,9.7113936576110476,null,3.3419157383430704,null,0.78618940779341351,null,3.4403193968984537E-2,null,26.546064236493109]
[null,"Total",440.5358313045304,null,155.63884817490973,null,126.91242250750003,null,48.529168886779985,null,0.99999999999999989,null,771.61627087372028]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",91.483535582386068,null,27.136302238435153,null,40.691721768538358,null,15.222899919558021,null,0.36556135027990561,null,174.53445950891759]
[null," - 20-40%",78.776787652304947,null,21.761617912526113,null,32.952563483678865,null,12.877897836717729,null,0.3065686900343581,null,146.36886688522765]
[null," - 40-60%",57.222038122936532,null,15.458168740546187,null,19.34238575570167,null,8.3257405454844058,null,0.21017896565084829,null,100.3483331646688]
[null," - 60-80%",27.755944232954118,null,7.2328517627666979,null,4.3269653646090269,null,2.7124482895480093,null,8.8027826210853852E-2,null,42.028209649877851]
[null," - >80%",7.9567794857284637,null,3.9745753211558488,null,1.5656427760121392,null,0.66545410825185625,null,2.9663167824034106E-2,null,14.162451691148307]
[null,"Total",263.19508507631014,null,75.563515975430008,null,98.879279148540064,null,39.804440699560018,null,0.99999999999999989,null,477.44232089984018]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",53.422787195023794,null,22.653811618301333,null,6.8935686588329315,null,2.7224417050840675,null,0.36959397959138141,null,85.692609177242119]
[null," - 20-40%",47.450955918332788,null,12.623183699512028,null,6.2674773009129057,null,2.5400279921193682,null,0.29708794618162448,null,68.881644910877085]
[null," - 40-60%",34.200334629903338,null,7.1086920315289079,null,4.6280578581788125,null,1.7025371565820357,null,0.2054706646300615,null,47.639621676193102]
[null," - 60-80%",16.700827132023072,null,3.372441887853793,null,1.3819178105768053,null,0.51700588545874615,null,9.4766517488412735E-2,null,21.972192715912417]
[null," - >80%",3.8806554392970338,null,2.9142615622439658,null,0.76413739740853825,null,0.11095137826578448,null,3.3080892108519763E-2,null,7.6700057772153221]
[null,"Total",155.65556031458004,null,48.672390799440031,null,19.935159025909996,null,7.592964117510002,null,0.99999999999999978,null,231.85607425744007]

{"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 Q3"]
[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%",67.699499441385896,null,202.27542656083418,null,16.325547335656349,null,286.30047333787638]
[null," - 20-40%",44.966002559720749,null,170.83115009104128,null,15.333271640364133,null,231.13042429112616]
[null," - 40-60%",26.814938480481452,null,118.73627781409861,null,12.731907520777298,null,158.28312381535736]
[null," - 60-80%",11.077777621666947,null,50.732906425552315,null,7.5455011456473038,null,69.356185192866562]
[null," - >80%",5.9427810310173861,null,15.422445672473472,null,5.1808375330022418,null,26.546064236493102]
[null,"Total",156.5009991342724,null,557.99820656399993,null,57.11706517544733,null,771.61627087371971]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",36.171605823969429,null,126.31676596455627,null,12.046087720391812,null,174.53445950891751]
[null," - 20-40%",24.530246430281949,null,110.36947475024711,null,11.469145704698564,null,146.36886688522765]
[null," - 40-60%",14.810860506859312,null,76.018847299092641,null,9.5186253587168448,null,100.3483331646688]
[null," - 60-80%",5.7486960267290037,null,30.743406514513882,null,5.5361071086349538,null,42.028209649877837]
[null," - >80%",2.3596353228218288,null,8.218148643980582,null,3.5846677243459024,null,14.162451691148313]
[null,"Total",83.621044110661529,null,351.66664317239042,null,42.154633616788075,null,477.44232089984001]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",20.419973127927239,null,62.335706734022089,null,2.9369293152927667,null,85.692609177242105]
[null," - 20-40%",13.948992455926227,null,52.115119368154595,null,2.817533086796316,null,68.881644910877142]
[null," - 40-60%",8.0812598379803493,null,37.103898486871365,null,2.4544633513413658,null,47.63962167619308]
[null," - 60-80%",2.97854002169281,null,17.452867411008501,null,1.5407852832110938,null,21.972192715912406]
[null," - >80%",1.2051621772508281,null,5.4896583535128229,null,0.9751852464516737,null,7.6700057772153247]
[null,"Total",46.633927620777449,null,174.49725035356937,null,10.724896283093214,null,231.85607425744004]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":48,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"3 month arrears","2005 Q2","2005 Q3","2005 Q4","2006 Q1","2006 Q2","2006 Q3","2006 Q4","2007 Q1","2007 Q2","2007 Q3","2007 Q4","2008 Q1","2008 Q2","2008 Q3","2008 Q4","2009 Q1","2009 Q2","2009 Q3","2009 Q4","2010 Q1","2010 Q2","2010 Q3","2010 Q4","2011 Q1","2011 Q2","2011 Q3","2011 Q4","2012 Q1","2012 Q2","2012 Q3","2012 Q4","2013 Q1","2013 Q2","2013 Q3","2013 Q4","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3"]
[null,"Private",8.0652528612137897E-2,7.7191298368422895E-2,6.9556929511739488E-2,5.6591704792520001E-2,5.1296367647227961E-2,5.6647210289428276E-2,5.0244429306712655E-2,6.0543838606434336E-2,6.16656827446775E-2,7.0253843806781346E-2,8.0928251690201194E-2,0.10004882266970098,0.11781523259771912,0.1405975605147636,0.21226550425193944,0.31,0.40858428118318801,0.47,0.52,0.54,0.42,0.36,0.33,0.28999999999999998,0.28999999999999998,0.3463,0.26,0.26190376313394481,0.24316578085023852,0.2369410256441489,0.2412168151228983,0.24464011849638104,0.26151874154946242,0.18995975418317132,0.21,0.20871851307349823,0.20374765009047413,0.19533888718789549,0.17754809588439302,0.19590249468675333,0.19,0.15893288234797173,0.16149788193874809,0.16149788193874809,0.15,0.16449818754446421]
[null,"Commercial",0.16563791556290958,0.2132773695526021,0.12204037907712323,0.10503765547972971,8.8360652070989781E-2,9.3490201160133263E-2,0.12575758646685919,0.13869347004763621,6.9749523648991063E-2,8.4826854962818915E-2,0.13082680939576194,6.3690962238606902E-2,9.4493334396141937E-2,0.13624324754250733,0.3969035165305469,0.5,1.19219168754725,1.49,2.2799999999999998,1.66,1.68,1.53,1.45,0.99,1.52,1.0514600000000001,1.1100000000000001,0.98135130215418731,0.91779340446955104,0.9167755240471176,0.97966799583253905,0.96572955607584687,0.90468379651813313,1.0725515021846566,0.89,0.87131255651855843,0.76461653695092491,0.76492280361307252,0.77897538655254928,1.194715258404901,1.46,0.82675167690184714,0.85336926232454113,0.89,0.69,0.81554975340876124]
[null,"Agriculture",0.28733545754687229,0.28591425530114489,0.16350323367431957,0.34527555313816655,0.10247036587855575,0.17964818144364114,9.0458945241985167E-2,0.19224824892179651,0.1036179997289654,0.12911678565215878,0.23066720688136241,0.12560081599500431,0.155178149616685,0.19101387683898366,0.35126666024992187,0.41759999999999997,0.67417569609969485,0.74819999999999998,0.97440000000000004,1.2005999999999999,1.1135999999999999,1.0788,0.8004,1.0091999999999999,1.2702,1.0149245999999998,0.97440000000000004,0.91878692992583044,0.98849890507143101,0.91578392565633737,0.81872886685764001,0.7178725419523122,0.80576132165605641,0.54730814983061826,0.76559999999999995,0.73217624928661695,0.7172187732310964,0.70912650774595554,1.0035221517145021,0.81239218354143794,1.05,1.1685196839142329,1.2412515438452036,1.58,1.73,1.6719091646228039]
[null,"Rental Residential",4.3803406849193607E-2,9.5903072670480427E-2,3.6486627092520228E-2,8.0964019790819894E-2,3.0837731696558998E-2,9.0809206617881597E-2,0.13105243766129279,0.12018992862817277,4.2604410955085943E-2,9.7458697328710153E-2,9.7552936486864472E-2,7.1229672369108821E-2,0.17376216832575472,0.14733228176836374,0.54055865639875256,0.47,1.43,0.78,2.3199999999999998,1.05,1.25,0.73,1.23,0.54,0.79,0.48215999999999998,0.61,1.0340488552503766,0.94359445546940601,0.95685367926700082,1.015570738474074,1.0358365609598339,1.1088667897697735,1.0818705545393414,0.69,1.0079192391688849,0.56932045694128441,0.37687573473480396,0.55809173343292406,0.26507511901436809,0.38,0.23610434466412475,0.36501409231622234,0.15,0.21,0.13418814040566654]
[null,"Total",9.3078859231499098E-2,0.1041114235941326,7.4301233393325866E-2,7.876830458817323E-2,5.4285894101353913E-2,7.2796144890424228E-2,7.1601991163809345E-2,9.0566535002575665E-2,6.0047323754447109E-2,7.9214700905587174E-2,9.2930152243926437E-2,8.4504082108036338E-2,0.12016587495976419,0.13984787324621051,0.28332394419109863,0.37,0.66341144567458699,0.69,1.02,0.84,0.73,0.62,0.63,0.48,0.56999999999999995,0.48478000000000004,0.46,0.58369618019212233,0.47098288764955432,0.5326320421930133,0.48741117386115446,0.56540413616177954,0.51758010480584227,0.55014006668795445,0.41,0.53504965819159567,0.36591361753693991,0.33338691074415494,0.38091100597796013,0.38906956469991866,0.47,0.32200314121386003,0.35811697073053689,0.33,0.3,0.32402749788656332]

{"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",48672390799.549927,48420630645.779922]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",19935159025.789978,19900661090.489983]
["S-Landbrug","S",null,"Landbrug",7592964117.7600002,7592964117.7600002]
["S-Privat","S",null,"Privat",155655560314.55991,155655560314.55991]
["S Total-","S Total","S Total",null,231856074257.65979,231569816168.58981]
["T-Boligudl","T","T","Boligudl",75563515975.44989,73011716544.519897]
["T-Erhverv","T",null,"Erhverv",98879279148.780167,84061293574.960129]
["T-Landbrug","T",null,"Landbrug",39804440699.919991,39804440699.919991]
["T-Privat","T",null,"Privat",263195085076.71982,263195085076.71982]
["T Total-","T Total","T Total",null,477442320900.86987,460072535896.11987]
["Ø-Boligudl","Ø","Ø","Boligudl",31402941400.149986,31202403186.049988]
["Ø-Erhverv","Ø",null,"Erhverv",8097984333.0400009,7804901224.1100006]
["Ø-Landbrug","Ø",null,"Landbrug",1131764069.8,1131764069.8]
["Ø-Privat","Ø",null,"Privat",21685185913.43,21685185913.43]
["Ø Total-","Ø Total","Ø Total",null,62317875716.419991,61824254393.389992]
["Grand Total-","Grand Total","Grand Total",null,771616270874.94983,753466606458.09985]
[]
[]
[]
[]
[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":263195085076.71982}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":73011716544.519897}]
[null,null,"T-Erhverv","Erhverv","Commercial",84061293574.960129]
[null,null,"T-Landbrug","Landbrug","Agriculture",39804440699.919991]
[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":17369785004.75}]
[]
[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":155655560314.55991}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":48420630645.779922}]
[null,null,"S-Erhverv","Erhverv","Commercial",19900661090.489983]
[null,null,"S-Landbrug","Landbrug","Agriculture",7592964117.7600002]
[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":286258089.06994629}]
[]
[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":21685185913.43}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":31202403186.049988}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",7804901224.1100006]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",1131764069.8]
[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":493621323.02999878}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":440535831304.70972}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":152634750376.34979}]
[null,null,null,null,"Commercial",111766855889.5601]
[null,null,null,null,"Agriculture",48529168887.479996]
[null,null,null,null,"Nordic",18149664416.849945]

{"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",6223261374.6700001,193768469.63]
[null,"F1",28930905335.700001,11315664153.040001]
[null,"F3",50450261555.230003,14238445078.65]
[null,"F5",60375449210.260002,21143388975.009998]
[null,"Fixed",38414331428.360001,7050080514.2200003]
[null,"Floaters",12514244661.25,70755296318.259995]
[null,"Øv. flex",16546971472.83,19091198517.16]
["J Total",null,213455425038.30002,143787842025.97]
["N","CapFloat",12033042019.75,994081993.58000004]
[null,"F1",18418233145.59,9600421656.1900005]
[null,"F3",31218240724.509998,10725662111.1]
[null,"F5",37617688076.169998,38456066580.629997]
[null,"Fixed",116978218479.09,86597222473.949997]
[null,"Floaters",5294165075.4200001,33954646427.689999]
[null,"Øv. flex",5520818745.8800001,6964496300.6000004]
["N Total",null,227080406266.41,187292597543.74002]