{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2012 Q4 Total","RD 2012 Q4 Cap T","RD 2012 Q4 Cap S","Repossed Properties - Year","Repossed Properties - Quarter","LTV","LTV - Sectors","LTV - Classification","3m arrears","Borrower segmentation Nordic"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":1},"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 2012 Q4 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2012 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",429753.91698826,null,143387.26983991024,null,114697.4967340202,null,50328.428893149961,null,738167.11245534034]
[null," - Number of loans",439430,null,43097,null,16806,null,16460,null,515793]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",132628.3851388797,null,61863.983552459846,null,13084.363544030008,null,4142.9670769199956,null,211719.69931228954]
[null," - repayment loans",96965.939518039741,null,59385.641261729841,null,11998.202379690008,null,3180.9363924599957,null,171530.71955191958]
[null," - interest-only ",35662.445620839964,null,2478.3422907300005,null,1086.1611643400001,null,962.03068445999997,null,40188.97976036997]
[null,"FlexLån®",267368.12830673973,null,68718.993600290079,null,63578.037467120041,null,38823.213645550015,null,438488.37301969988]
[null," - repayment loans",85689.89692614002,null,36170.701490740073,null,25819.911213809966,null,9391.9389867399841,null,157072.44861743005]
[null," - interest-only ",181678.23138059973,null,32548.292109550002,null,37758.126253310074,null,29431.274658810031,null,281415.92440226983]
[null,"FlexGaranti®, Rentedyk TM",29599.986425440002,null,1088.9575301699999,null,460.23133945999996,null,527.83381952000013,null,31677.009114590001]
[null," - repayment loans",13424.093443240004,null,598.45677412999976,null,331.83412793999997,null,237.37822727000008,null,14591.762572580004]
[null," - interest-only ",16175.892982199997,null,490.50075604000011,null,128.39721151999998,null,290.45559225000005,null,17085.246542009998]
[null,"RD EURIBOR3®",38.965534919999996,null,688.30639795999991,null,2458.3984237300001,null,4183.7021830699978,null,7369.3725396799973]
[null," - repayment loans",10.429855210000001,null,37.960551430000002,null,397.82618909000007,null,609.44100858000013,null,1055.6576043100001]
[null," - interest-only ",28.535679709999993,null,650.34584653000002,null,2060.5722346400003,null,3574.2611744899973,null,6313.714935369997]
[null,"RD CIBOR6®",118.45158228000003,null,11027.028759030014,null,35116.465959680027,null,2650.7121680899995,null,48912.65846908003]
[null," - repayment loans",20.616939070000001,null,1828.7186334599996,null,8494.1648984600015,null,588.92499098999986,null,10932.425461979999]
[null," - interest-only ",97.834643210000024,null,9198.3101255700149,null,26622.30106122002,null,2061.7871771,null,37980.233007100032]
[null," Total",429753.91698825953,null,143387.26983990995,null,114697.49673402007,null,50328.42889315002,null,738167.11245533952]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",170006.38623221981,null,50638.338255190109,null,44583.98677359007,null,3365.0104858400009,null,268593.72174683999]
[null," - Other Sealand",90161.06184910977,null,17645.873149540017,null,11185.618859670014,null,13235.201188140003,null,132227.75504645979]
[null," - Region South Denmark",71485.955037179927,null,26351.128311570064,null,23843.285403929967,null,17263.767406089988,null,138944.13615876995]
[null," - Region Central Jutland",73152.772099259964,null,34476.300513899951,null,20422.65684556001,null,9737.1024343599984,null,137788.83189307991]
[null," - Region North Jutland",24943.886706179965,null,13747.050833649984,null,6593.5797241100036,null,6727.3473787199928,null,52011.864642659944]
[null," - Other area",3.8550643099999999,null,528.57877606,null,8068.369127160001,null,0,null,8600.8029675300004]
[null,"Total",429753.91698825947,null,143387.26983991012,null,114697.49673402007,null,50328.428893149983,null,738167.11245533964]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",280566.59853942925,null,10252.298021539993,null,4622.7600832600028,null,3799.9239518899994,null,299241.58059611928]
[null," 2 - 5",131258.39389805947,null,14136.211550429985,null,7119.3923312600018,null,7327.512054460004,null,159841.50983420949]
[null," 5 - 20",17299.275692529987,null,45498.59032670001,null,22495.331717519992,null,16847.561865859978,null,102140.75960260996]
[null," 20 - 50",574.62384550000002,null,35105.185550370028,null,20019.214237839995,null,15599.980548690011,null,71299.004182400036]
[null," 50 - 100",55.025012740000001,null,18226.242656649993,null,16558.268419810011,null,5653.8684812799956,null,40493.404570480001]
[null," 100 and above",0,null,20168.741734220002,null,43882.529944330017,null,1099.5819909700001,null,65150.853669520016]
[null,"Total",429753.91698825872,null,143387.26983991,null,114697.49673402002,null,50328.42889314999,null,738167.11245533871]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",49400.751400730012,null,13054.064055300005,null,16136.473673140008,null,3128.9357968900008,null,81720.224926060022]
[null," 1",68629.740477880056,null,15701.529710230008,null,15089.363905479997,null,4015.4806560399988,null,103436.11474963007]
[null," 2",55060.826173539972,null,11759.663633929978,null,17262.569071099995,null,3590.86961655,null,87673.928495119952]
[null," 3",29923.230843510006,null,4055.5772654000016,null,5167.4678687799988,null,2700.7486638099963,null,41847.0246415]
[null," 4",56872.506058720006,null,7097.3653344500053,null,11514.437177609994,null,6231.0688413399957,null,81715.377412120011]
[null," 6",44722.315907559954,null,16676.679540299996,null,26116.053463090029,null,14943.512521719991,null,102458.56143266997]
[null," 8",80584.176645829823,null,22106.726205200008,null,16823.142909039994,null,9780.3564671199892,null,129294.40222718981]
[null," 10",32793.630191880024,null,10039.56316998,null,3592.0635416699993,null,3814.8220344400011,null,50240.078937970015]
[null," 15",10140.85524585,null,16634.60496058999,null,2539.2513727099999,null,1808.772283650002,null,31123.483862799992]
[null," 20",1440.9121025799991,null,16787.182127149987,null,290.10616536999981,null,109.11766880999997,null,18627.318063909985]
[null," 25",35.592221680000009,null,8286.4518949499979,null,105.01306286999998,null,89.226121689999999,null,8516.2833011899984]
[null," 30",149.37971850000002,null,1187.8619424300002,null,61.554523160000002,null,115.51822109,null,1514.3144051800002]
[null,"Total",429753.91698825982,null,143387.26983990998,null,114697.49673402002,null,50328.428893149969,null,738167.11245533987]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",136596.84706340486,null,49862.085905435524,null,42720.805993713089,null,18367.260821627497,null,247546.99978418095]
[null,"20 - 40%",117808.49422275749,null,34261.151526575435,null,34137.313518709409,null,15523.396322745986,null,201730.35559078833]
[null,"40 - 60%",90635.762574762441,null,24791.244960285982,null,24275.179349591424,null,10130.773260400758,null,149832.96014504059]
[null,"60 - 80%",57150.844384304895,null,16367.606922661626,null,8250.7730112854915,null,4151.3808103963593,null,85920.605128648371]
[null,"> 80 %",27561.968742629655,null,18105.180524361527,null,5313.4248613505824,null,2155.617678199465,null,53136.191806541225]
[null,"Total",429753.91698785929,null,143387.26983932007,null,114697.49673464999,null,50328.428893370066,null,738167.11245519947]

{"sheet":"RD 2012 Q4 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 2012 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",163132.02903529006,null,42685.099397080034,null,69138.748761180002,null,38342.329869890047,null,313298.20706344018]
[null," - Number of loans",142057,null,11916,null,7612,null,10521,null,172106]
[]
[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®",163026.0947494501,null,34775.936377749982,null,42867.502254410007,null,34087.489910060038,null,274757.02329167014]
[null," - repayment loans",52761.478924970041,null,17081.656153479984,null,19630.457857429992,null,7911.2050215200079,null,97384.79795740002]
[null," - interest-only ",110264.61582448006,null,17694.280224270002,null,23237.044396980014,null,26176.284888540027,null,177372.2253342701]
[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,"RD EURIBOR3®",19.944382009999998,null,318.19143939999998,null,1586.62457073,null,2086.7357917799995,null,4011.4961839199991]
[null," - repayment loans",4.8624398100000006,null,9.5363051400000014,null,230.12098357999997,null,362.44975324999996,null,606.96948178000002]
[null," - interest-only ",15.081942199999999,null,308.65513426000001,null,1356.5035871500002,null,1724.2860385299996,null,3404.5267021399995]
[null,"RD CIBOR6®",85.989903829999989,null,7590.9715799300038,null,24684.621936039988,null,2168.1041680500002,null,34529.68758785]
[null," - repayment loans",18.57838915,null,1471.5564068600002,null,5908.8974377700015,null,432.27983837999983,null,7831.3120721600017]
[null," - interest-only ",67.411514679999996,null,6119.4151730700032,null,18775.724498269989,null,1735.8243296700005,null,26698.375515689993]
[null," Total",163132.02903529009,null,42685.09939707999,null,69138.748761179988,null,38342.329869890033,null,313298.20706344012]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",71290.397468020019,null,15250.607081439994,null,27144.814518220013,null,2643.9040203500003,null,116329.72308803003]
[null," - Other Sealand",31515.058024950016,null,3698.9379863499971,null,6242.6124757399966,null,9879.4708849600047,null,51336.079372000015]
[null," - Region South Denmark",23686.117574349999,null,8268.7452244199994,null,14375.688171489994,null,12838.110939390008,null,59168.66190965]
[null," - Region Central Jutland",27786.569048599995,null,11023.211074920007,null,11760.972672109998,null,7590.1450434900053,null,58160.897839120007]
[null," - Region North Jutland",8853.8869193700084,null,4377.4848535199953,null,3496.1117458099993,null,5390.6989817000003,null,22118.182500400002]
[null," - Other area",0,null,66.113176429999996,null,6118.5491778099995,null,0,null,6184.6623542399993]
[null,"Total",163132.02903529003,null,42685.099397079997,null,69138.748761180002,null,38342.329869890018,null,313298.20706344006]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",90076.191780389956,null,4267.7343079299999,null,1876.438885289999,null,1779.0967579300002,null,97999.461731539952]
[null," 2 - 5",62069.878434570048,null,5301.0772982300014,null,3609.4932632799992,null,4726.0001925900006,null,75706.449188670042]
[null," 5 - 20",10644.46007043001,null,11221.584777369997,null,12963.193217680002,null,13329.925382040006,null,48159.163447520019]
[null," 20 - 50",341.49874990000006,null,8148.4839911000035,null,11650.475011070002,null,12712.953067520002,null,32853.410819590004]
[null," 50 - 100",0,null,6474.2415873899972,null,9159.2411987999967,null,4879.5516449999996,null,20513.034431189993]
[null," 100 and above",0,null,7271.9774350600001,null,29879.907185059998,null,914.80282481000017,null,38066.687444929994]
[null,"Total",163132.02903529,null,42685.099397079997,null,69138.748761179988,null,38342.329869890003,null,313298.20706344]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",19624.394518050001,null,6719.6614849300031,null,12292.118220150003,null,2178.7031242999992,null,40814.877347430011]
[null," 1",31136.286767399997,null,8651.2976520699976,null,12120.609677449998,null,3026.3517012299999,null,54934.545798149993]
[null," 2",16264.321027639999,null,3862.7552148900004,null,9945.9352601099999,null,2476.341145670001,null,32549.352648310003]
[null," 3",14273.820215130008,null,2310.2950395300008,null,4228.9210248299987,null,2392.9030337700001,null,23205.939313260009]
[null," 4",33189.146979519996,null,4319.9102844100016,null,10063.985255780002,null,5638.243219179999,null,53211.285738890008]
[null," 6",17107.150391719999,null,4291.5203710199985,null,9799.3228157100057,null,11111.983385699994,null,42309.976964149995]
[null," 8",15934.117366909995,null,8438.3321799400001,null,7825.9237933099994,null,7203.8678378400045,null,39402.241177999997]
[null," 10",11464.570574759995,null,2323.1231619300006,null,1647.01680642,null,2908.4773458899986,null,18343.187888999993]
[null," 15",3960.9298569199996,null,1692.3975590000005,null,1160.7816733399998,null,1346.5677139699992,null,8160.6768032299997]
[null," 20",177.29133723999996,null,75.806449360000016,null,54.134234080000006,null,58.891362340000008,null,366.12338302000001]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",163132.02903529,null,42685.099397080012,null,69138.748761180002,null,38342.329869889989,null,313298.20706344006]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",48755.85182165217,null,12523.379047021343,null,25807.072558848202,null,13240.555764203318,null,100326.85919172502]
[null,"20 - 40%",43689.896840065827,null,10396.55652615458,null,21211.33803473632,null,11928.454200628947,null,87226.245601585659]
[null,"40 - 60%",35704.704896445248,null,8515.4304194160086,null,15650.170575756661,null,8115.3813108861832,null,67985.687202504108]
[null,"60 - 80%",23750.424070196445,null,5834.1115148431854,null,4183.9833843213155,null,3329.6281925952844,null,37098.147161956236]
[null,"> 80 %",11231.151407020252,null,5415.621889344874,null,2286.1842077975452,null,1728.3104019862881,null,20661.267906148962]
[null,"Total",163132.02903537994,null,42685.099396779988,null,69138.74876146004,null,38342.329870300018,null,313298.20706391998]

{"sheet":"RD 2012 Q4 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 2012 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",192490.19389789962,null,50384.641423489942,null,28514.21701290995,null,8655.0132950399984,null,280044.06562933954]
[null," - Number of loans",176595,null,10297,null,4298,null,3116,null,194306]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",83196.836433210032,null,18042.01986326,null,8294.4197292600038,null,2081.5922505900012,null,111614.86827632003]
[null," - repayment loans",58361.019661360042,null,16332.251532350003,null,7389.1539054200039,null,1432.776515420001,null,83515.201614550038]
[null," - interest-only ",24835.816771850001,null,1709.7683309100003,null,905.26582384000017,null,648.81573517000004,null,28099.666661770003]
[null,"FlexLån®",102940.87319946998,null,30285.080269449929,null,15528.79501415999,null,4360.9895994799999,null,153115.73808255987]
[null," - repayment loans",32653.686619140011,null,18502.614646669954,null,5075.0986230099943,null,1405.5562340900001,null,57636.956122909956]
[null," - interest-only ",70287.186580329959,null,11782.465622779977,null,10453.696391149995,null,2955.4333653899998,null,95478.781959649932]
[null,"FlexGaranti®, Rentedyk TM",6326.7087481900026,null,124.70320452999997,null,58.068092100000001,null,41.737302440000001,null,6551.2173472600034]
[null," - repayment loans",2504.4712322700011,null,76.738871419999967,null,47.480856420000002,null,19.438703200000003,null,2648.129663310001]
[null," - interest-only ",3822.2375159200019,null,47.964333110000005,null,10.587235679999999,null,22.298599239999998,null,3903.087683950002]
[null,"RD EURIBOR3®",19.021152910000001,null,370.11495855999993,null,871.77385300000003,null,2096.9663912899996,null,3357.8763557599996]
[null," - repayment loans",5.5674154000000007,null,28.424246289999999,null,167.70520550999998,null,246.99125533000003,null,448.68812253000004]
[null," - interest-only ",13.45373751,null,341.69071226999995,null,704.06864748999999,null,1849.9751359599995,null,2909.1882332299997]
[null,"RD CIBOR6®",6.75436412,null,1562.7231276899995,null,3761.1603243899999,null,73.727751239999989,null,5404.3655674399997]
[null," - repayment loans",0,null,198.44465820000005,null,786.72611694999989,null,14.658840469999999,null,999.82961562000003]
[null," - interest-only ",6.75436412,null,1364.2784694899995,null,2974.4342074400001,null,59.068910769999995,null,4404.5359518199994]
[null," Total",192490.1938979,null,50384.64142348992,null,28514.217012909998,null,8655.0132950400002,null,280044.06562933995]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",74376.567590430073,null,19018.537351400009,null,10298.052595370002,null,500.83345384000012,null,104193.99099104007]
[null," - Other Sealand",40321.921742920036,null,6667.7169281400083,null,3025.8864585900001,null,2553.3872707400019,null,52568.912400390043]
[null," - Region South Denmark",33586.032195100001,null,8394.7268131599958,null,6513.6138809699978,null,3182.209437680001,null,51676.582326909993]
[null," - Region Central Jutland",33110.620908679994,null,11448.624517670001,null,5541.5588899399936,null,1455.1719175299991,null,51555.976233819987]
[null," - Region North Jutland",11095.051460769997,null,4605.3465172900051,null,2268.0998943699997,null,963.41121525000062,null,18931.90908768]
[null," - Other area",0,null,249.68929583000002,null,867.0052936699999,null,0,null,1116.6945894999999]
[null,"Total",192490.19389790008,null,50384.641423490022,null,28514.21701290999,null,8655.0132950400002,null,280044.06562934007]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",127056.14527051982,null,2783.7580529099969,null,1164.5615111099999,null,1059.5987262699996,null,132064.06356080982]
[null," 2 - 5",59098.449587529998,null,4560.3110249900001,null,2233.2344701200009,null,1751.5904690900006,null,67643.585551730008]
[null," 5 - 20",6107.9545641699997,null,17931.183739660013,null,6939.7083479600024,null,2684.0790087600012,null,33662.925660550012]
[null," 20 - 50",227.64447568,null,13535.469730429988,null,6479.2021814100017,null,2442.9818393099995,null,22685.298226829986]
[null," 50 - 100",0,null,5642.1886954099991,null,4949.86351844,null,590.84978429,null,11182.90199814]
[null," 100 and above",0,null,5931.7301800899986,null,6747.6469838700032,null,125.91346732000001,null,12805.290631280001]
[null,"Total",192490.19389789982,null,50384.641423489993,null,28514.217012910009,null,8655.0132950400002,null,280044.06562933984]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",29776.356882680007,null,6334.4025703700072,null,3844.3554529899998,null,950.23267259000011,null,40905.347578630019]
[null," 1",37492.710118529983,null,7050.2320581599988,null,2667.6383698599993,null,989.12895480999998,null,48199.709501359983]
[null," 2",38796.505145900002,null,7896.9084190399954,null,5280.9318742399983,null,1114.52847088,null,53088.87391006]
[null," 3",15649.410628379997,null,1745.2822258700005,null,938.54684395000015,null,307.84563004000006,null,18641.085328239998]
[null," 4",23680.076438530006,null,2777.4550500400001,null,1450.4519218300009,null,592.82562215999997,null,28500.80903256001]
[null," 6",18127.775538780013,null,8555.0342934799992,null,10050.726154380003,null,3163.2971028699985,null,39896.833089510008]
[null," 8",13069.916481100008,null,5227.0573496300012,null,2677.9173519999999,null,570.85211790999995,null,21545.74330064001]
[null," 10",12365.027078999994,null,5592.1361429000017,null,841.96475049000037,null,575.6616693200001,null,19374.789641709995]
[null," 15",3351.4628216200008,null,5176.6112419300007,null,733.54012362999981,null,374.09744712000003,null,9635.7116343000016]
[null," 20",180.95276338000005,null,29.522072069999993,null,28.14416954,null,16.543607340000001,null,255.16261233000003]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",192490.1938979,null,50384.64142349,null,28514.217012910005,null,8655.0132950399984,null,280044.06562934001]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",57616.557033302575,null,17627.10189320095,null,9318.0238169469612,null,3273.0181816355444,null,87834.700925086014]
[null,"20 - 40%",52473.425967490854,null,12620.438438966385,null,8129.0399410329246,null,2674.1851626519665,null,75897.089510142134]
[null,"40 - 60%",41893.369159282789,null,8644.4232669636094,null,6030.124680856331,null,1638.2395306444946,null,58206.156637747234]
[null,"60 - 80%",27268.41278361134,null,5659.012431559102,null,3011.4241307239813,null,707.8696120572954,null,36646.718957951714]
[null,"> 80 %",13238.428953622319,null,5833.665392699977,null,2025.604443579798,null,361.70080795069646,null,21459.399597852789]
[null,"Total",192490.19389730989,null,50384.641423390021,null,28514.217013139994,null,8655.0132949399958,null,280044.06562877994]

{"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,"*Q4 2012"]

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

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

{"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 2012 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%",136.59684706340485,null,49.862085905435521,null,42.720805993713086,null,18.367260821627493,null,0.33535360165372441,null,247.54699978418097]
[null," - 20-40%",117.80849422275749,null,34.261151526575439,null,34.137313518709405,null,15.523396322745986,null,0.27328548263254093,null,201.73035559078832]
[null," - 40-60%",90.635762574762438,null,24.791244960285979,null,24.275179349591422,null,10.130773260400758,null,0.20297972859652993,null,149.8329601450406]
[null," - 60-80%",57.150844384304897,null,16.367606922661626,null,8.2507730112854922,null,4.1513808103963594,null,0.11639722723878873,null,85.920605128648376]
[null," - >80%",27.561968742629652,null,18.105180524361526,null,5.3134248613505823,null,2.1556176781994649,null,7.1983959878415923E-2,null,53.13619180654122]
[null,"Total",429.75391698785933,null,143.38726983932008,null,114.69749673464999,null,50.328428893370059,null,0.99999999999999989,null,738.16711245519946]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",48.755851821652165,null,12.523379047021344,null,25.807072558848201,null,13.240555764203318,null,0.32022800300052812,null,100.32685919172503]
[null," - 20-40%",43.689896840065828,null,10.39655652615458,null,21.211338034736322,null,11.928454200628947,null,0.27841284640288266,null,87.226245601585674]
[null," - 40-60%",35.70470489644525,null,8.5154304194160098,null,15.650170575756663,null,8.1153813108861836,null,0.21699992425629638,null,67.985687202504096]
[null," - 60-80%",23.750424070196445,null,5.834111514843185,null,4.1839833843213157,null,3.3296281925952846,null,0.1184116165541521,null,37.098147161956234]
[null," - >80%",11.231151407020253,null,5.415621889344874,null,2.2861842077975454,null,1.728310401986288,null,6.5947609786140879E-2,null,20.661267906148961]
[null,"Total",163.13202903537996,null,42.685099396779997,null,69.138748761460036,null,38.34232987030002,null,1,null,313.29820706392002]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",57.616557033302577,null,17.627101893200951,null,9.31802381694696,null,3.2730181816355444,null,0.31364599970319579,null,87.83470092508604]
[null," - 20-40%",52.473425967490854,null,12.620438438966385,null,8.129039941032925,null,2.6741851626519666,null,0.27101838183834115,null,75.897089510142138]
[null," - 40-60%",41.893369159282791,null,8.6444232669636101,null,6.0301246808563311,null,1.6382395306444946,null,0.20784642055191413,null,58.206156637747227]
[null," - 60-80%",27.268412783611339,null,5.6590124315591019,null,3.0114241307239813,null,0.70786961205729548,null,0.13086054466345945,null,36.64671895795172]
[null," - >80%",13.238428953622318,null,5.8336653926999773,null,2.0256044435797982,null,0.36170080795069648,null,7.6628653243089567E-2,null,21.459399597852791]
[null,"Total",192.49019389730989,null,50.384641423390029,null,28.514217013139994,null,8.655013294939998,null,1,null,280.04406562877989]

{"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 2012 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%",55.690114460314554,null,166.0031320162839,null,25.853753307582668,null,247.54699978418114]
[null," - 20-40%",38.598556235332921,null,139.69403784628375,null,23.437761509171974,null,201.73035559078863]
[null," - 40-60%",24.646303623290024,null,105.76508176722177,null,19.421574754529075,null,149.83296014504086]
[null," - 60-80%",12.026603988955603,null,61.28771688947986,null,12.60628425021258,null,85.920605128648049]
[null," - >80%",10.276788666377756,null,32.452286552856378,null,10.407116587307225,null,53.136191806541362]
[null,"Total",141.23836697427089,null,505.20225507212564,null,91.726490408803528,null,738.16711245520014]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",13.256769229854559,null,73.528970224165533,null,13.541119737704982,null,100.32685919172508]
[null," - 20-40%",9.1367014627950169,null,65.443333239365614,null,12.646210899424984,null,87.226245601585617]
[null," - 40-60%",6.4511252424747365,null,50.84279947079667,null,10.69176248923268,null,67.985687202504096]
[null," - 60-80%",2.7272526966426498,null,27.578917134973523,null,6.7919773303400959,null,37.09814716195627]
[null," - >80%",1.6488381069784395,null,13.569058463535832,null,5.4433713356346916,null,20.661267906148964]
[null,"Total",33.2206867387454,null,230.96307853283719,null,49.114441792337438,null,313.29820706392007]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",17.679920620031925,null,63.252223009912214,null,6.9025572951418832,null,87.834700925086025]
[null," - 20-40%",13.780004884025242,null,55.689389936294376,null,6.4276946898225491,null,75.897089510142166]
[null," - 40-60%",8.805977680524439,null,43.875087471198135,null,5.5250914860247731,null,58.206156637747348]
[null," - 60-80%",4.7778205242345795,null,27.915737335810604,null,3.9531610979065568,null,36.646718957951741]
[null," - >80%",3.4405312221311308,null,14.724785255809568,null,3.2940831199120959,null,21.459399597852794]
[null,"Total",48.484254930947309,null,205.45722300902489,null,26.102587688807855,null,280.04406562878006]

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

{"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",50384641423.489944,50134952127.659943]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",28514217012.910007,27647211719.239998]
["S-Landbrug","S",null,"Landbrug",8655013295.0400028,8655013295.0400028]
["S-Privat","S",null,"Privat",192490193897.90002,192490193897.90002]
["S Total-","S Total","S Total",null,280044065629.33997,278927371039.83997]
["T-Boligudl","T","T","Boligudl",42685099397.080032,42619207776.010025]
["T-Erhverv","T",null,"Erhverv",69138748761.180069,63020199583.370132]
["T-Landbrug","T",null,"Landbrug",38342329869.890045,38342329869.890045]
["T-Privat","T",null,"Privat",163132029035.28958,163132029035.28958]
["T Total-","T Total","T Total",null,313298207063.4397,307113766264.55981]
["Ø-Boligudl","Ø","Ø","Boligudl",50317529019.339912,50121085893.349907]
["Ø-Erhverv","Ø",null,"Erhverv",17044530959.930004,15979285300.900007]
["Ø-Landbrug","Ø",null,"Landbrug",3331085728.2199974,3331085728.2199974]
["Ø-Privat","Ø",null,"Privat",74131694055.069778,74131694055.069778]
["Ø Total-","Ø Total","Ø Total",null,144824839762.55969,143563150977.53967]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,738167112455.33948,729604288281.93933]
[]
[]
[]
[]
[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":163132029035.28958}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":42619207776.010025}]
[null,null,"T-Erhverv","Erhverv","Commercial",63020199583.370132]
[null,null,"T-Landbrug","Landbrug","Agriculture",38342329869.890045]
[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":6184440798.8798828}]
[]
[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":192490193897.90002}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":50134952127.659943}]
[null,null,"S-Erhverv","Erhverv","Commercial",27647211719.239998]
[null,null,"S-Landbrug","Landbrug","Agriculture",8655013295.0400028]
[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":1116694589.5}]
[]
[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":74131694055.069778}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":50121085893.349907}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",15979285300.900007]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",3331085728.2199974]
[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":1261688785.0200195}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":429753916988.25934}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":142875245797.01987}]
[null,null,null,null,"Commercial",106646696603.51015]
[null,null,null,null,"Agriculture",50328428893.15004]
[null,null,null,null,"Nordic",8562824173.3999023]