{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RD 2014 Q3 Total","RD 2014 Q3 Cap T","RD 2014 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 2014 Q3 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 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",419831.76906653953,null,162090.96239095982,null,121094.68649841027,null,47888.283408180017,null,750905.70136408973]
[null," - Number of loans",423503,null,42766,null,15679,null,15465,null,497413]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",131082.96463249021,null,68027.052231940208,null,12539.717697200023,null,4573.8892898600006,null,216223.62385149041]
[null," - repayment loans",95516.215143430192,null,65558.777433190204,null,11319.146551830023,null,3138.8949884699996,null,175533.0341169204]
[null," - interest-only ",35566.749489060021,null,2468.2747987499984,null,1220.5711453700003,null,1434.9943013900004,null,40690.589734570021]
[null,"FlexLån®",253065.86601429022,null,75518.839100289973,null,47585.591951739967,null,27993.478163460022,null,404163.77522978018]
[null," - repayment loans",88235.473455200045,null,48731.454583559993,null,17596.618373289981,null,7777.1389816299989,null,162340.68539368003]
[null," - interest-only ",164830.39255909019,null,26787.384516729984,null,29988.973578449986,null,20216.339181830026,null,241823.08983610015]
[null,"FlexGaranti®, Rentedyk TM",24837.042116030014,null,861.21247227000015,null,384.5695937399999,null,451.58932104999997,null,26534.413503090011]
[null," - repayment loans",10943.691881410004,null,495.30062522000009,null,265.92305722999993,null,205.67226131999996,null,11910.587825180002]
[null," - interest-only ",13893.350234620011,null,365.91184705000001,null,118.64653650999998,null,245.91705973000001,null,14623.82567791001]
[null,"FlexKort®",10718.240237639995,null,2377.4470347199999,null,2189.5599833500005,null,6096.4978679000051,null,21381.745123610002]
[null," - repayment loans",3148.7666979499995,null,651.69018937999965,null,1200.9836802300006,null,1266.9998196400011,null,6268.4403872000012]
[null," - interest-only ",7569.473539689996,null,1725.7568453400002,null,988.57630311999969,null,4829.498048260004,null,15113.304736409998]
[null,"Other floating rate loans",127.65606608999998,null,15306.411551740008,null,58395.2472723799,null,8772.8287659100006,null,82602.143656119923]
[null," - repayment loans",24.6457853,null,2667.6466675800002,null,16851.371423319997,null,1646.5954330099985,null,21190.259309209996]
[null," - interest-only ",103.01028079,null,12638.764884160008,null,41543.875849059907,null,7126.2333329000012,null,61411.884346909923]
[null," Total",419831.76906654041,null,162090.96239096017,null,121094.68649840989,null,47888.283408180032,null,750905.70136409043]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",169432.56390596952,null,56879.180893270088,null,45977.371149869934,null,3260.3114390699998,null,275549.42738817952]
[null," - Other Sealand",85983.187601769983,null,19596.715319859988,null,10565.698165970016,null,12772.738315030005,null,128918.33940262999]
[null," - Region South Denmark",69439.934791249951,null,30079.058570479992,null,25361.82829895999,null,16383.677572769991,null,141264.49923345994]
[null," - Region Central Jutland",71286.348130990053,null,38013.629175079965,null,20557.631078290033,null,9252.2705004899944,null,139109.87888485004]
[null," - Region North Jutland",23687.737665409997,null,16325.543587510034,null,6819.9212069900086,null,6219.2855808199938,null,53052.48804073003]
[null," - Other area",1.9969711499999998,null,1196.8348447599999,null,11812.236598330001,null,0,null,13011.06841424]
[null,"Total",419831.76906653948,null,162090.96239096008,null,121094.68649840997,null,47888.283408179981,null,750905.70136408939]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",266955.95891842979,null,9973.5505029600245,null,4294.5722119899974,null,3669.4418627500008,null,284893.52349612984]
[null," 2 - 5",134062.99365127989,null,13072.199525549991,null,6713.3539413799954,null,7025.5622482799936,null,160874.10936648989]
[null," 5 - 20",18241.871375799994,null,43308.218290440105,null,21312.331122239993,null,15760.217082980009,null,98622.637871460101]
[null," 20 - 50",518.89523656000006,null,37155.425396799983,null,20159.628921949989,null,14526.193424780015,null,72360.142980089979]
[null," 50 - 100",52.049884470000002,null,22163.236343529992,null,16733.625109829984,null,6046.2257195300026,null,44995.137057359985]
[null," 100 and above",0,null,36418.332331680009,null,51881.175191019996,null,860.6430698600002,null,89160.150592560007]
[null,"Total",419831.76906653959,null,162090.96239096008,null,121094.68649840994,null,47888.283408180025,null,750905.70136408985]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",31015.331370740034,null,6954.6854466800023,null,6529.8250565099897,null,1811.9272820800002,null,46311.769156010028]
[null," 1",53649.775155199983,null,22072.258449309997,null,25974.458357849999,null,11352.420004170006,null,113048.91196652999]
[null," 2",69469.595529760089,null,22599.512825239981,null,20919.092178800005,null,4058.7050685899981,null,117046.90560239008]
[null," 3",34599.840472589967,null,7167.3762989699999,null,6130.4681007399977,null,1982.3818922600001,null,49880.066764559968]
[null," 4",31120.880139790002,null,9819.8636059699929,null,14476.596264349982,null,2578.7531411899986,null,57996.093151299974]
[null," 6",89663.204341569959,null,12936.337927489998,null,15031.692685730008,null,8469.5566936500018,null,126100.79164843998]
[null," 8",34184.996979739954,null,15814.731639129999,null,17957.150643930006,null,9752.6269838899971,null,77709.506246689954]
[null," 10",52612.762590030077,null,16639.252085560023,null,10519.96038482,null,5131.4713139600008,null,84903.446374370105]
[null," 15",21323.597287859953,null,20452.655047200005,null,3111.8568482900027,null,2434.6825794199985,null,47322.791762769957]
[null," 20",1735.5005059700013,null,15448.414681179989,null,327.87132156000007,null,154.73570983000002,null,17666.522218539994]
[null," 25",368.5046048800001,null,11549.969124670002,null,46.520727260000001,null,23.287553879999997,null,11988.282010690002]
[null," 30",87.780088409999962,null,635.90525956000033,null,69.193928569999997,null,137.73518526000004,null,930.61446180000019]
[null,"Total",419831.76906654,null,162090.96239096002,null,121094.68649841002,null,47888.283408180003,null,750905.70136409008]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",134205.43084606121,null,59351.10111245056,null,44801.21301814312,null,18402.70736252853,null,256760.45233918342]
[null,"20 - 40%",117594.15564956366,null,40476.838886572594,null,36647.440100049556,null,15259.057394313068,null,209977.49203049886]
[null,"40 - 60%",90566.860159888485,null,29288.473133484735,null,26589.888281171414,null,9776.7187381404674,null,156221.94031268512]
[null,"60 - 80%",53778.714463196295,null,17263.822131688896,null,7961.6565994808761,null,3546.4449202886576,null,82550.638114654721]
[null,"> 80 %",23686.607948079618,null,15710.727126343305,null,5094.48849940531,null,903.35499279925898,null,45395.178566627488]
[null,"Total",419831.76906678925,null,162090.96239054011,null,121094.68649825027,null,47888.283408069976,null,750905.70136364968]

{"sheet":"RD 2014 Q3 Cap T","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 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",232073.78552056977,null,67789.66231816003,null,86439.83923904995,null,38709.168065490121,null,425012.45514326991]
[null," - Number of loans",210016,null,16163,null,9072,null,11193,null,246444]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",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,"FlexLån®",221271.84941054016,null,53698.273803429976,null,36563.274070040017,null,26171.904552439981,null,337705.30183645012]
[null," - repayment loans",79401.654970030024,null,35934.000391399997,null,15298.213075120002,null,7332.279395779995,null,137966.14783233003]
[null," - interest-only ",141870.19444051012,null,17764.273412029987,null,21265.060994920015,null,18839.625156659986,null,199739.15400412012]
[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®",10718.240237639995,null,2377.4470347199999,null,2189.55998335,null,6096.4978679000023,null,21381.745123609991]
[null," - repayment loans",3148.7666979499995,null,651.69018937999977,null,1200.9836802300001,null,1266.9998196399997,null,6268.4403871999984]
[null," - interest-only ",7569.473539689996,null,1725.7568453399999,null,988.57630311999992,null,4829.4980482600031,null,15113.304736409997]
[null,"Other floating rate loans",83.695872389999991,null,11713.941480010009,null,47687.005185660004,null,6440.7656451500034,null,65925.40818321002]
[null," - repayment loans",17.352646049999997,null,2276.8655626300015,null,14022.670162569997,null,1303.0199458900001,null,17619.908317139998]
[null," - interest-only ",66.343226340000001,null,9437.0759173800088,null,33664.335023090011,null,5137.7456992600028,null,48305.499866070015]
[null," Total",232073.78552057015,null,67789.662318159986,null,86439.839239050038,null,38709.168065489983,null,425012.45514327014]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",101304.8273330201,null,22268.181959429956,null,32168.542298469991,null,2763.2862427500008,null,158504.83783367008]
[null," - Other Sealand",45524.547429239974,null,7324.0326718099959,null,6739.0773172500021,null,10417.825511240006,null,70005.482929539983]
[null," - Region South Denmark",34147.052708090006,null,13065.468205129995,null,18173.789902019987,null,12520.78189059,null,77907.092705829986]
[null," - Region Central Jutland",39036.872592239997,null,16766.434622790006,null,13749.132413279998,null,7692.4226490099982,null,77244.86227731999]
[null," - Region North Jutland",12060.485457979998,null,7623.0990438599947,null,4134.0882275900012,null,5314.8517719000029,null,29132.524501329994]
[null," - Other area",0,null,742.44581514000004,null,11475.209080440003,null,0,null,12217.654895580003]
[null,"Total",232073.78552057006,null,67789.662318159957,null,86439.839239049994,null,38709.168065490005,null,425012.45514327008]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",132477.19389860009,null,5601.8584916200007,null,2261.8566385700015,null,2136.616991440002,null,142477.52602023011]
[null," 2 - 5",85594.16768335033,null,5991.1633067900048,null,4260.1620482800045,null,5188.3707619000006,null,101033.86380032032]
[null," 5 - 20",13576.593458739993,null,14908.937297719995,null,14290.336773520006,null,13163.733502709991,null,55939.601032689985]
[null," 20 - 50",425.8304798800001,null,13867.766467459998,null,13379.901708670001,null,12172.946544840001,null,39846.445200850008]
[null," 50 - 100",0,null,9346.5121725500012,null,10828.276390340005,null,5280.2824127200001,null,25455.070975610008]
[null," 100 and above",0,null,18073.424582020005,null,41419.305679669997,null,767.2178518799999,null,60259.948113569997]
[null,"Total",232073.78552057041,null,67789.662318160001,null,86439.839239050023,null,38709.16806548999,null,425012.45514327043]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",13518.334585199986,null,4451.022716620002,null,5491.7077046499999,null,1076.3807258499994,null,24537.445732319986]
[null," 1",31937.891893610005,null,10501.467063170006,null,23182.200159039992,null,10311.163485860001,null,75932.722601680012]
[null," 2",28273.577939279992,null,11252.420250260002,null,15825.272787589993,null,2823.5033338500007,null,58174.774310979978]
[null," 3",19938.575446490006,null,4601.1475440600007,null,5196.2080638200005,null,1737.7045998100009,null,31473.635654180009]
[null," 4",16655.765977859995,null,4630.8624025899999,null,10230.251073719997,null,2025.7301950900007,null,33542.609649259997]
[null," 6",67731.322135080045,null,8627.8605852000037,null,12961.173540999998,null,7808.1233125400013,null,97128.479573820034]
[null," 8",20701.219015409999,null,6596.1101615199959,null,6094.5233307599947,null,6877.0878610099944,null,40268.940368699979]
[null," 10",17228.729282309996,null,8105.3032388200008,null,5273.8130235099989,null,3725.9869896000027,null,34333.832534239998]
[null," 15",15560.508488870006,null,8861.8630135299973,null,2088.118639509999,null,2208.74623436,null,28719.236376270001]
[null," 20",527.86075645999983,null,161.60534238999998,null,96.570915450000015,null,114.74132752000003,null,900.77834181999992]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",232073.78552057,null,67789.662318160015,null,86439.839239049979,null,38709.168065489997,null,425012.45514326997]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",71715.476324710442,null,21231.996202765524,null,33039.059522256961,null,14304.383910493134,null,140290.91596022606]
[null,"20 - 40%",64195.067032181709,null,17982.441273272572,null,27198.752277018477,null,12445.105575426212,null,121821.36615789897]
[null,"40 - 60%",51236.14155533247,null,14497.079016680927,null,18926.362542146191,null,8200.981759311022,null,92860.56487347059]
[null,"60 - 80%",31156.772221385134,null,8234.9231831509132,null,4769.7382837232608,null,2990.0367180344788,null,47151.470406293796]
[null,"> 80 %",13770.328387420353,null,5843.2226421700607,null,2505.9266140851187,null,768.66010211510581,null,22888.137745790638]
[null,"Total",232073.78552103008,null,67789.662318039991,null,86439.839239230016,null,38709.168065379949,null,425012.45514368004]

{"sheet":"RD 2014 Q3 Cap S","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2014 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",142550.03960632,null,52354.500210790109,null,21864.000884340006,null,7051.1243233899932,null,223819.6650248401]
[null," - Number of loans",133728,null,9236,null,3329,null,2335,null,148628]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",105881.3484205101,null,31356.552309060004,null,10299.377144959995,null,3466.4052051399985,null,151003.6830796701]
[null," - repayment loans",74949.026030570079,null,29183.442678500003,null,9156.8965073399941,null,2230.1162253099992,null,115519.48144172008]
[null," - interest-only ",30932.322389940018,null,2173.1096305599999,null,1142.4806376200004,null,1236.2889798299998,null,35484.20163795002]
[null,"FlexLån®",30878.01783741,null,19065.481115750004,null,7259.8552531099986,null,1598.5564299,null,58801.910636170003]
[null," - repayment loans",8677.5332330799938,null,12373.206457630002,null,2167.6090368799996,null,396.91683578999999,null,23615.265563379999]
[null," - interest-only ",22200.484604330006,null,6692.2746581200017,null,5092.2462162299989,null,1201.6395941100002,null,35186.645072790008]
[null,"FlexGaranti®, Rentedyk TM",5768.5676727300006,null,119.20017698999997,null,54.060363490000007,null,38.215947469999996,null,5980.0441606800005]
[null," - repayment loans",2287.6604966400005,null,72.847139509999991,null,43.598287210000009,null,20.789117949999998,null,2424.8950413100006]
[null," - interest-only ",3480.9071760900001,null,46.353037479999998,null,10.46207628,null,17.426829519999998,null,3555.1491193700003]
[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",22.10567567,null,1813.266608989999,null,4250.7081227799999,null,1947.9467408799999,null,8034.0271483199995]
[null," - repayment loans",5.3259946100000004,null,251.82624273000002,null,1155.6511179000001,null,221.74148346000004,null,1634.5448387000004]
[null," - interest-only ",16.779681060000001,null,1561.4403662599991,null,3095.05700488,null,1726.2052574199997,null,6399.4823096199989]
[null," Total",142550.03960632006,null,52354.500210790015,null,21864.000884339992,null,7051.1243233899995,null,223819.66502484013]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",54273.17393646,null,21263.717315139991,null,7755.1086289900059,null,377.87449748,null,83669.874378069988]
[null," - Other Sealand",28667.543458479984,null,6012.6155343000019,null,2530.6731824199992,null,1867.2265088399997,null,39078.058684039977]
[null," - Region South Denmark",26216.327521120031,null,9136.8351391600027,null,5133.4869201000029,null,3070.5636888599979,null,43557.213269240034]
[null," - Region Central Jutland",24809.529705739995,null,11257.107303010011,null,4323.4556211200006,null,1071.3469286300005,null,41461.439558500002]
[null," - Region North Jutland",8583.4649845200001,null,4437.1833222099995,null,2087.4251660299997,null,664.11269958000003,null,15772.186172339998]
[null," - Other area",0,null,247.04159697,null,33.851365680000001,null,0,null,280.89296264999996]
[null,"Total",142550.03960632,null,52354.500210790007,null,21864.000884340003,null,7051.1243233899977,null,223819.66502483998]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",96396.771193800188,null,2099.5096948400005,null,1003.5577086700001,null,873.13119134000067,null,100372.96978865018]
[null," 2 - 5",41825.657146699996,null,4099.4139982599963,null,1792.1105274100005,null,1312.32296911,null,49029.504641479994]
[null," 5 - 20",4239.6673183099992,null,15466.201623760022,null,5528.2766101600055,null,2098.3802201799999,null,27332.525772410027]
[null," 20 - 50",87.943947509999987,null,11892.02587505,null,5491.8779589100013,null,2105.7851702900002,null,19577.632951760002]
[null," 50 - 100",0,null,6727.4745157299949,null,3746.0339983799995,null,623.40401148000012,null,11096.912525589994]
[null," 100 and above",0,null,12069.874503150006,null,4302.1440808099997,null,38.100760989999998,null,16410.119344950006]
[null,"Total",142550.03960632018,null,52354.500210790007,null,21864.00088434001,null,7051.1243233900013,null,223819.66502484024]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",17496.996785539995,null,2503.6627300600012,null,1038.1173518599996,null,735.54655622999974,null,21774.323423689999]
[null," 1",21711.883261589988,null,11570.791386139999,null,2227.0244731600001,null,1041.2565183100003,null,36550.955639199979]
[null," 2",41196.017590480013,null,11347.092574979999,null,4962.3007783899993,null,1235.2017347399997,null,58740.612678590012]
[null," 3",14661.2650261,null,2566.2287549099992,null,934.26003691999983,null,244.67729245000007,null,18406.431110379996]
[null," 4",14465.11416193,null,5189.0012033799976,null,2849.1405876299991,null,553.02294610000024,null,23056.278899039993]
[null," 6",21928.349009630005,null,4308.4773422899998,null,2070.5191447300003,null,661.43338111000014,null,28968.778877760007]
[null," 8",5018.9594799999977,null,5241.5799499899995,null,6156.4659264700022,null,2235.7503619599997,null,18652.755718419998]
[null," 10",4315.7736940799987,null,3811.0458377000014,null,1203.5821013599998,null,217.69034252999998,null,9548.0919756700023]
[null," 15",1696.0696532999996,null,5768.3073501399949,null,408.90898616000004,null,122.14924651999998,null,7995.4352361199935]
[null," 20",59.610943670000012,null,48.313081200000013,null,13.68149766,null,4.395943439999999,null,126.00146597000001]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",142550.03960632,null,52354.500210789985,null,21864.000884339999,null,7051.1243233899986,null,223819.66502483995]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",43918.592891403758,null,22012.967143515252,null,7053.6645962253351,null,2830.4590459869532,null,75815.683677131281]
[null,"20 - 40%",40553.459577269175,null,13505.153333277383,null,6508.8479780699845,null,2250.4004080803493,null,62817.861296696894]
[null,"40 - 60%",31619.813608039483,null,8478.3835926152515,null,4908.5177628473621,null,1364.7985133958373,null,46371.513476897933]
[null,"60 - 80%",18836.887734876142,null,4572.6652325020705,null,2195.2666017350066,null,489.37787326318835,null,26094.197442376408]
[null,"> 80 %",7621.2857949316376,null,3785.3309085500096,null,1197.7039453123002,null,116.08848262367357,null,12720.40913141762]
[null,"Total",142550.03960652018,null,52354.500210459963,null,21864.000884189991,null,7051.1243233500027,null,223819.66502452016]

{"sheet":"Repossed Properties - Year","index":3,"n_rows":42,"n_cols":4,"rows_kept":42,"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*",71,85]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q3 2014"]

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

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

{"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 2014 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%",134.2054308460612,null,59.351101112450564,null,44.801213018143123,null,18.402707362528531,null,0.34193434924372623,null,256.76045233918342]
[null," - 20-40%",117.59415564956366,null,40.476838886572594,null,36.64744010004955,null,15.259057394313068,null,0.27963230489418089,null,209.97749203049887]
[null," - 40-60%",90.566860159888492,null,29.288473133484732,null,26.589888281171412,null,9.7767187381404668,null,0.20804468527670653,null,156.22194031268509]
[null," - 60-80%",53.778714463196295,null,17.263822131688897,null,7.9616565994808761,null,3.5464449202886579,null,0.10993476007006235,null,82.550638114654731]
[null," - >80%",23.686607948079615,null,15.710727126343306,null,5.0944884994053092,null,0.9033549927992589,null,6.0453900515323747E-2,null,45.395178566627486]
[null,"Total",419.83176906678926,null,162.09096239054008,null,121.09468649825028,null,47.888283408069981,null,0.99999999999999967,null,750.90570136364954]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",71.715476324710451,null,21.231996202765522,null,33.039059522256956,null,14.304383910493133,null,0.33008659925695399,null,140.29091596022607]
[null," - 20-40%",64.195067032181711,null,17.98244127327257,null,27.198752277018478,null,12.445105575426211,null,0.28663010856167953,null,121.82136615789896]
[null," - 40-60%",51.236141555332466,null,14.497079016680928,null,18.92636254214619,null,8.2009817593110217,null,0.21848904367303326,null,92.860564873470608]
[null," - 60-80%",31.156772221385136,null,8.2349231831509133,null,4.7697382837232611,null,2.9900367180344785,null,0.11094138497742079,null,47.151470406293797]
[null," - >80%",13.770328387420353,null,5.843222642170061,null,2.5059266140851189,null,0.76866010211510583,null,5.3852863530912419E-2,null,22.88813774579064]
[null,"Total",232.07378552103012,null,67.789662318039987,null,86.439839239229997,null,38.709168065379956,null,1,null,425.01245514368009]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",43.918592891403755,null,22.012967143515251,null,7.0536645962253353,null,2.8304590459869532,null,0.33873557834529627,null,75.81568367713129]
[null," - 20-40%",40.553459577269173,null,13.505153333277384,null,6.5088479780699844,null,2.2504004080803495,null,0.28066283313316115,null,62.817861296696897]
[null," - 40-60%",31.619813608039482,null,8.4783835926152502,null,4.9085177628473629,null,1.3647985133958374,null,0.20718248091300556,null,46.371513476897931]
[null," - 60-80%",18.836887734876139,null,4.5726652325020707,null,2.1952666017350069,null,0.48937787326318838,null,0.11658581224092937,null,26.094197442376405]
[null," - >80%",7.6212857949316382,null,3.7853309085500095,null,1.1977039453123002,null,0.11608848262367358,null,5.6833295367607957E-2,null,12.720409131417622]
[null,"Total",142.55003960652019,null,52.35450021045996,null,21.864000884189991,null,7.0511243233500025,null,1.0000000000000004,null,223.81966502452013]

{"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 2014 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%",53.680072094781082,null,184.37713512116079,null,18.703245123241988,null,256.76045233918387]
[null," - 20-40%",36.266255017926511,null,156.20965912776998,null,17.501577884802181,null,209.97749203049867]
[null," - 40-60%",23.879099260772765,null,117.40765004389097,null,14.935191008021626,null,156.22194031268538]
[null," - 60-80%",12.08259550171274,null,60.679948142438555,null,9.7880944705035233,null,82.550638114654816]
[null," - >80%",10.033550158266033,null,27.740105192528084,null,7.6215232158333954,null,45.395178566627507]
[null,"Total",135.94157203345912,null,546.41449762778836,null,68.549631702402721,null,750.90570136365022]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",22.071231920537443,null,105.33249642981262,null,12.887187609876037,null,140.2909159602261]
[null," - 20-40%",16.281524008063524,null,93.275548113924074,null,12.264294035911323,null,121.82136615789892]
[null," - 40-60%",10.893617470837778,null,71.381735429059546,null,10.585211973573323,null,92.860564873470651]
[null," - 60-80%",4.9237721021788712,null,35.431851595615726,null,6.79584670849923,null,47.151470406293825]
[null," - >80%",2.8515814210944304,null,15.329263733946302,null,4.7072925907498977,null,22.88813774579063]
[null,"Total",57.021726922712055,null,320.75089530235823,null,47.239832918609807,null,425.01245514368009]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",16.011268406933105,null,56.114484621725509,null,3.6899306484726786,null,75.81568367713129]
[null," - 20-40%",11.443822703489753,null,47.854962037496911,null,3.5190765557101078,null,62.817861296696769]
[null," - 40-60%",7.3086404344082929,null,36.009170892010474,null,3.0537021504791171,null,46.371513476897881]
[null," - 60-80%",3.674806683096147,null,20.344386176026493,null,2.0750045832537309,null,26.09419744237637]
[null," - >80%",2.2249126321164421,null,8.7249884669817579,null,1.7705080323194402,null,12.720409131417641]
[null,"Total",40.663450860043739,null,169.04799219424115,null,14.108221970235075,null,223.81966502451994]

{"sheet":"3m arrears","index":8,"n_rows":10,"n_cols":40,"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"]
[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]
[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]
[null,"Agriculture",0.16513532042923695,0.16431853752939363,9.3967375674896297E-2,0.19843422594147503,5.889101487273319E-2,0.10324608128944894,5.1987899564359293E-2,0.11048749938034283,5.9550574556876672E-2,7.4205049225378614E-2,0.13256736027664506,7.2184377008623166E-2,8.9182844607290229E-2,0.10977809013734693,0.20187739094823096,0.24,0.38745729660902001,0.43,0.56000000000000005,0.69,0.64,0.62,0.46,0.57999999999999996,0.73,0.58328999999999998,0.56000000000000005,0.52803846547461519,0.56810281900656956,0.52631260095191801,0.47053383152737932,0.4125704264093748,0.46308121934256113,0.3145449136957576,0.44,0.42079094786587184,0.41219469725925079,0.40754396996893993]
[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]
[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]

{"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",52354500210.790108,52107458613.820114]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",21864000884.339973,21830149518.659973]
["S-Landbrug","S",null,"Landbrug",7051124323.389986,7051124323.389986]
["S-Privat","S",null,"Privat",142550039606.32037,142550039606.32037]
["S Total-","S Total","S Total",null,223819665024.84045,223538772062.19043]
["T-Boligudl","T","T","Boligudl",67789662318.160027,67047348686.150017]
["T-Erhverv","T",null,"Erhverv",86439839239.049942,74964630158.60997]
["T-Landbrug","T",null,"Landbrug",38709168065.490013,38709168065.490013]
["T-Privat","T",null,"Privat",232073785520.56964,232073785520.56964]
["T Total-","T Total","T Total",null,425012455143.26965,412794932430.81964]
["Ø-Boligudl","Ø","Ø","Boligudl",41946799862.010124,41751916614.130127]
["Ø-Erhverv","Ø",null,"Erhverv",12790846375.020014,12500944531.550016]
["Ø-Landbrug","Ø",null,"Landbrug",2127991019.3000007,2127991019.3000007]
["Ø-Privat","Ø",null,"Privat",45207943939.650047,45207943939.650047]
["Ø Total-","Ø Total","Ø Total",null,102073581195.98019,101588796104.63019]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,750905701364.09033,737922500597.64026]
[]
[]
[]
[]
[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":232073785520.56964}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":67047348686.150017}]
[null,null,"T-Erhverv","Erhverv","Commercial",74964630158.60997]
[null,null,"T-Landbrug","Landbrug","Agriculture",38709168065.490013]
[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":12217522712.450012}]
[]
[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":142550039606.32037}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":52107458613.820114}]
[null,null,"S-Erhverv","Erhverv","Commercial",21830149518.659973]
[null,null,"S-Landbrug","Landbrug","Agriculture",7051124323.389986]
[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":280892962.6499939}]
[]
[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":45207943939.650047}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":41751916614.130127}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",12500944531.550016]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2127991019.3000007]
[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":484785091.34999084}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":419831769066.54004}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":160906723914.10025}]
[null,null,null,null,"Commercial",109295724208.81996]
[null,null,null,null,"Agriculture",47888283408.18]
[null,null,null,null,"Nordic",12983200766.449997]

{"sheet":"Borrower Exposure to Int. rate","index":10,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
["kapcenter","(Alle)"]
[]
["Sum af kormar",null,"sektor4"]
["afdr_fri","prodtyp","Privat","Erhverv_samlet"]
["J","Fixed",35566749489.06002,5123840245.5099983]
[null,"F1,F3,F5",148445278744.20993,56358473634.569992]
[null,"Øv. flex",16385113814.879988,20634223642.440002]
[null,"Rentedyk+flexgar",13893350234.62001,730475443.28999996]
[null,"CITA+Other FL",7672483820.4799967,68852705262.83992]
["J Total",null,221962976103.24997,151699718228.6499]
["N","Fixed",95516215143.430191,80016818973.490219]
[null,"F1,F3,F5",83223404754.200119,55939114951.219971]
[null,"Øv. flex",5012068701.0000048,18166096987.260006]
[null,"Rentedyk+flexgar",10943691881.410004,966895943.76999998]
[null,"CITA+Other FL",3173412483.25,24285287213.159996]
["N Total",null,197868792963.29031,179374214068.90018]