{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["RD 2013 Q2 Total","RD 2013 Q2 Cap T","RD 2013 Q2 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 2013 Q2 Total","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[null,"Realkredit Danmark 2013 Q2 - Total portfolio"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",423032.31791436789,null,142028.12854617042,null,117568.08273699999,null,49703.096454479863,null,732331.62565201824]
[null," - Number of loans",431945,null,42538,null,16543,null,16262,null,507288]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",130678.66651131997,null,60643.867748979967,null,13075.165498309976,null,4228.3654383500034,null,208626.06519695994]
[null," - repayment loans",96013.624000869982,null,58171.845592139958,null,11883.254466829974,null,3085.1635015200031,null,169153.88756135994]
[null," - interest-only ",34665.042510449988,null,2472.0221568400016,null,1191.9110314800007,null,1143.2019368300005,null,39472.177635599997]
[null,"FlexLån®",263734.73918498028,null,68541.242887830042,null,65938.297741700022,null,38227.085752559993,null,436441.36556707032]
[null," - repayment loans",86695.510680549953,null,36300.300699110026,null,27385.516162649961,null,9391.6745054500007,null,159773.00204775995]
[null," - interest-only ",177039.2285044303,null,32240.94218872003,null,38552.781579050061,null,28835.411247109991,null,276668.36351931037]
[null,"FlexGaranti®, Rentedyk TM",28479.14626301001,null,1019.8718382000001,null,444.68068761000006,null,503.41384714000009,null,30447.112635960009]
[null," - repayment loans",12633.299169319993,null,568.56211848000009,null,318.18767221000002,null,226.72336489,null,13746.772324899992]
[null," - interest-only ",15845.847093690018,null,451.30971971999986,null,126.4930154,null,276.69048225000006,null,16700.340311060019]
[null,"RD EURIBOR3®",38.999270850000002,null,667.60224053999991,null,2429.1344224000004,null,4141.8911977299995,null,7277.6271315199992]
[null," - repayment loans",10.34466872,null,38.080507060000002,null,386.67624670000004,null,591.08234165000022,null,1026.1837641300003]
[null," - interest-only ",28.654602130000004,null,629.52173347999997,null,2042.4581757000005,null,3550.8088560799988,null,6251.4433673899994]
[null,"RD CIBOR6®",100.76668420999999,null,11155.543830619994,null,35680.804386979995,null,2602.3402186999992,null,49539.455120509992]
[null," - repayment loans",10.81155899,null,1933.2545161599994,null,9092.3304293699912,null,563.07968673999972,null,11599.476191259992]
[null," - interest-only ",89.955125219999999,null,9222.289314459993,null,26588.473957610007,null,2039.2605319599995,null,37939.978929249999]
[null," Total",423032.31791437016,null,142028.12854617005,null,117568.08273700003,null,49703.096454479994,null,732331.62565202022]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",167853.29837532018,null,50621.294884099952,null,44786.922611389906,null,3351.8610703999998,null,266613.37694121007]
[null," - Other Sealand",88435.758442610007,null,17334.524008989982,null,10887.359938619995,null,13090.327123870004,null,129747.96951408997]
[null," - Region South Denmark",70251.068114010006,null,25984.969960809998,null,25551.067570009964,null,17062.521028549989,null,138849.62667337997]
[null," - Region Central Jutland",72045.736148430035,null,33852.192956729974,null,20177.780224810005,null,9627.7622093800019,null,135703.47153935002]
[null," - Region North Jutland",24442.908893180014,null,13376.291512279999,null,6597.629867149999,null,6570.6250222800008,null,50987.455294890016]
[null," - Other area",3.54794082,null,858.85522326,null,9567.3225250200012,null,0,null,10429.7256891]
[null,"Total",423032.31791437021,null,142028.12854616993,null,117568.08273699986,null,49703.096454479994,null,732331.62565201998]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",269641.32754752936,null,10232.023900669999,null,4532.5149617200013,null,3762.8197444300031,null,288168.68615434942]
[null," 2 - 5",134885.3931965701,null,13878.278192599966,null,7031.23389959001,null,7181.1443818000052,null,162976.04967056008]
[null," 5 - 20",17884.871369369979,null,45106.932108889865,null,22178.82735459003,null,16660.43083712002,null,101831.06166996989]
[null," 20 - 50",566.23415965000015,null,34906.733051620002,null,20236.404270479979,null,15638.34537191,null,71347.716853659993]
[null," 50 - 100",54.491641250000001,null,18069.675483949995,null,16441.701300070003,null,5475.0565338399992,null,40040.924959110002]
[null," 100 and above",0,null,19834.485808440011,null,47147.400950550022,null,985.29958538000028,null,67967.186344370028]
[null,"Total",423032.31791436952,null,142028.12854616984,null,117568.08273700005,null,49703.096454480015,null,732331.6256520194]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",27952.745633019997,null,8638.5552410300079,null,8655.6406264800025,null,1781.204470409999,null,47028.145970940001]
[null," 1",86024.31102501,null,20500.455515770005,null,22002.299076519987,null,4700.8216989400025,null,133227.88731624]
[null," 2",37425.968519249996,null,11877.690725240012,null,14116.045144009988,null,3136.4225510900014,null,66556.126939590002]
[null," 3",37733.739640959961,null,5230.64639515,null,9980.9799232199966,null,2325.9780915499996,null,55271.344050879961]
[null," 4",56553.450094279935,null,7010.4637656400055,null,11432.698521109975,null,4499.7985654199992,null,79496.41094644992]
[null," 6",57186.234410970057,null,16252.87795090998,null,26707.406399469997,null,16096.075597610004,null,116242.59435896004]
[null," 8",63008.783396730018,null,18858.252115719995,null,16652.828970439969,null,9659.3864715900036,null,108179.25095447998]
[null," 10",41903.024348089974,null,12376.374785980006,null,4383.1815547999977,null,4962.7030539000007,null,63625.283742769971]
[null," 15",13489.457831130008,null,15394.180770060018,null,3170.1787777099985,null,2231.1256216899983,null,34284.943000590021]
[null," 20",1581.2086579499996,null,15579.092155720005,null,318.82386475000004,null,119.58862207000001,null,17598.713300490006]
[null," 25",37.45557015,null,9528.0979663600101,null,92.633318250000002,null,48.206671920000005,null,9706.393526680009]
[null," 30",135.93878682999994,null,781.44115858999987,null,55.366560240000013,null,141.78503829000002,null,1114.5315439499998]
[null,"Total",423032.31791436998,null,142028.12854617005,null,117568.08273699992,null,49703.096454480001,null,732331.62565201975]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",135405.10515787813,null,51732.310488579249,null,44173.77256125681,null,18389.46927598508,null,249700.65748369932]
[null,"20 - 40%",117626.37952546521,null,35036.227383424652,null,35701.316892203729,null,15394.160798594839,null,203758.08459968842]
[null,"40 - 60%",90312.672253827506,null,24618.192421218861,null,24198.159915788248,null,9833.8690262174132,null,148962.89361705203]
[null,"60 - 80%",55092.292721247402,null,15237.297868115318,null,8141.9075696754098,null,3802.7665494174512,null,82274.264708455579]
[null,"> 80 %",24595.868255430938,null,15404.10038371168,null,5352.9257981158462,null,2282.8308044251771,null,47635.725241683649]
[null,"Total",423032.31791384914,null,142028.12854504975,null,117568.08273704005,null,49703.096454639963,null,732331.62565057888]

{"sheet":"RD 2013 Q2 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 2013 Q2 - Capital center T"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",205909.7852321199,null,50026.87121024989,null,77928.879868020143,null,39566.542846619974,null,373432.07915700995]
[null," - Number of loans",183455,null,14083,null,8659,null,11337,null,217534]
[]
[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®",205814.85481981994,null,41953.257296759999,null,50894.954198629988,null,35378.461801129975,null,334041.52811633988]
[null," - repayment loans",70101.026170689991,null,21612.742080730015,null,23834.681931619987,null,8629.0760717599969,null,124177.52625479997]
[null," - interest-only ",135713.82864912995,null,20340.515216029988,null,27060.272267009997,null,26749.38572936998,null,209864.00186153993]
[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.794557740000002,null,296.79291368999998,null,1575.5184919799999,null,2064.0538584599999,null,3956.1598218700001]
[null," - repayment loans",4.7652971700000002,null,9.33583359,null,223.75320956000002,null,350.8080430899999,null,588.66238340999985]
[null," - interest-only ",15.02926057,null,287.45708010000004,null,1351.7652824200002,null,1713.2458153700002,null,3367.49743846]
[null,"RD CIBOR6®",75.135854559999999,null,7776.8209998000002,null,25458.407177410012,null,2124.0271870300003,null,35434.39121880001]
[null," - repayment loans",8.7799834800000003,null,1546.9454105599998,null,6258.9212605999992,null,410.01380586999989,null,8224.6604605100001]
[null," - interest-only ",66.35587108,null,6229.8755892400004,null,19199.485916810012,null,1714.0133811600006,null,27209.730758290014]
[null," Total",205909.78523211996,null,50026.871210249992,null,77928.879868019983,null,39566.542846619981,null,373432.07915700995]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",88733.710800849905,null,16890.589041829986,null,28676.005659580005,null,2832.0403533199988,null,137132.34585557989]
[null," - Other Sealand",40982.473726879995,null,4801.6826147500024,null,6464.3888615800006,null,10350.658637720013,null,62599.203840930008]
[null," - Region South Denmark",30311.052211239996,null,9332.2699711700006,null,17459.640989969994,null,13116.623220359985,null,70219.586392739977]
[null," - Region Central Jutland",34871.246908400004,null,13259.01962382999,null,12483.671977230011,null,7785.1985495999979,null,68399.137059059998]
[null," - Region North Jutland",11011.301584749997,null,5347.2810875499999,null,3625.2540774100021,null,5482.0220856200021,null,25465.858835330007]
[null," - Other area",0,null,396.02887112000002,null,9219.9183022500001,null,0,null,9615.9471733700011]
[null,"Total",205909.78523211987,null,50026.871210249978,null,77928.879868020013,null,39566.542846619996,null,373432.0791570099]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",114689.35320059994,null,5097.5689857799925,null,2178.9247592699999,null,2017.7383287299992,null,123983.58527437995]
[null," 2 - 5",78279.380659379953,null,5897.5873496900031,null,4121.4697768200022,null,5110.1776930100023,null,93408.61547889997]
[null," 5 - 20",12567.31757795999,null,13893.592304900007,null,13910.689436370003,null,13791.238904639991,null,54162.838223869985]
[null," 20 - 50",373.73379418000002,null,10245.31919692999,null,12751.609711929992,null,13027.036045990004,null,36397.698749029987]
[null," 50 - 100",0,null,6950.0844668200025,null,9863.7195650500016,null,4747.545007820002,null,21561.349039690002]
[null," 100 and above",0,null,7942.7189061299978,null,35102.466618579987,null,872.80686643000024,null,43917.992391139982]
[null,"Total",205909.7852321199,null,50026.871210249985,null,77928.879868019983,null,39566.542846619996,null,373432.0791570099]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",10954.694436649997,null,2615.9599612200013,null,6343.7341060400004,null,1019.4077171599997,null,20933.796221069999]
[null," 1",36968.567200990015,null,10600.07400586,null,16911.241612540001,null,3347.4390663999998,null,67827.321885790021]
[null," 2",19327.590321060001,null,6059.7958574500008,null,10007.111866539999,null,2729.8086367599985,null,38124.306681809998]
[null," 3",14354.63503987999,null,2108.2761607700008,null,7217.4913404900008,null,1652.8295888899991,null,25333.232130029992]
[null," 4",40305.586529280001,null,4970.118870119999,null,10467.142856859993,null,4158.8022269500016,null,59901.650483209989]
[null," 6",38970.083274300028,null,6357.8982169999999,null,14104.665741030003,null,12758.309667970008,null,72190.956900300051]
[null," 8",19335.003170070002,null,8720.2325067500005,null,8606.777915460003,null,8167.675939949997,null,44829.689532230004]
[null," 10",18882.005270969992,null,4353.7807295900002,null,2266.5611017699998,null,3797.4384325899978,null,29299.785534919989]
[null," 15",6560.4396537399998,null,4148.5646699699992,null,1921.5815935400003,null,1863.1679612799999,null,14493.75387853]
[null," 20",251.18033517999996,null,92.170231520000044,null,82.571733750000007,null,71.663608669999988,null,497.58590912]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",205909.78523212002,null,50026.871210249992,null,77928.879868019998,null,39566.542846620003,null,373432.07915701007]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",62615.601447211586,null,15478.630408209194,null,29983.573278052885,null,14099.036514417223,null,122176.84164789091]
[null,"20 - 40%",56197.936403945467,null,12692.516161399992,null,24134.105378554599,null,12335.417741564535,null,105359.97568546458]
[null,"40 - 60%",45324.726452030249,null,10349.112344231349,null,16365.449103372242,null,8118.5734732583824,null,80157.861372892221]
[null,"60 - 80%",28807.592519994945,null,6460.3937566359364,null,4751.4710500486945,null,3112.2207901822321,null,43131.678116861811]
[null,"> 80 %",12963.928408207916,null,5046.2185393635582,null,2694.2810580615173,null,1901.2943274676118,null,22605.722333100603]
[null,"Total",205909.78523139012,null,50026.871209840028,null,77928.879868089934,null,39566.542846889992,null,373432.07915621006]

{"sheet":"RD 2013 Q2 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 2013 Q2 - Capital center S"]
[null,null," "]
[]
[null,"DKK million ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Total DKKm/ number"]
[null,"Mortgage loans"]
[null," - Bond debt outstanding",153505.29804492014,null,46906.153854170014,null,24716.586292840009,null,7236.0578762699961,null,232364.09606820013]
[null," - Number of loans",142582,null,9199,null,3573,null,2460,null,157814]
[]
[null,"Bond debt outstanding by loan type"]
[null,"Fixed-rate loans",90546.080414359982,null,21731.222389769959,null,9270.960366569996,null,2535.6571721900004,null,124083.92034288995]
[null," - repayment loans",64274.499736339989,null,19798.035132719961,null,8214.7796995799963,null,1664.2724405600009,null,93951.587009199953]
[null," - interest-only ",26271.580678020004,null,1933.1872570500011,null,1056.18066699,null,871.38473162999981,null,30132.33333369001]
[null,"FlexLån®",56690.897066469974,null,23156.767575339996,null,10852.813075709999,null,2509.5130533299989,null,93209.990770849981]
[null," - repayment loans",16392.139025780009,null,14211.97043277999,null,3391.4911714300006,null,697.75654386999986,null,34693.35717386]
[null," - interest-only ",40298.758040689958,null,8944.7971425600099,null,7461.3219042799992,null,1811.7565094599991,null,58516.633596989966]
[null,"FlexGaranti®, Rentedyk TM",6245.6512976299991,null,124.22988721000002,null,57.301793809999999,null,41.489228679999997,null,6468.6722073299998]
[null," - repayment loans",2479.1547517500003,null,75.829449129999986,null,46.676481430000003,null,21.08055461,null,2622.7412369200006]
[null," - interest-only ",3766.4965458799993,null,48.400438080000008,null,10.62531238,null,20.40867407,null,3845.9309704099996]
[null,"RD EURIBOR3®",19.20471311,null,370.80932685000005,null,853.61593041999993,null,2077.83733927,null,3321.4673096500001]
[null," - repayment loans",5.5793715500000012,null,28.744673470000002,null,162.92303713999999,null,240.27429855999998,null,437.52138071999997]
[null," - interest-only ",13.625341559999999,null,342.06465337999998,null,690.69289328000002,null,1837.5630407100002,null,2883.9459289300003]
[null,"RD CIBOR6®",3.4645533500000001,null,1523.124675,null,3681.89512633,null,71.561082799999994,null,5280.0454374799992]
[null," - repayment loans",0,null,236.95612323,null,1054.9429616799996,null,14.381412429999999,null,1306.2804973399998]
[null," - interest-only ",3.4645533500000001,null,1286.16855177,null,2626.9521646500002,null,57.179670369999997,null,3973.7649401399999]
[null," Total",153505.29804491994,null,46906.153854169956,null,24716.586292839991,null,7236.0578762699997,null,232364.0960681999]
[]
[null,"Bond debt outstanding by geographic area"]
[null," - Metropolitan area",58776.311221489959,null,19229.896852780003,null,9417.2173320999991,null,372.23220141999991,null,87795.657607789966]
[null," - Other Sealand",31395.281056600012,null,5814.1064438000039,null,2716.4148163000023,null,2023.5412571500005,null,41949.343573850019]
[null," - Region South Denmark",27556.870641589972,null,7961.9850486300084,null,5598.656288410004,null,2869.8932009999994,null,43987.40517962999]
[null," - Region Central Jutland",26613.743567450034,null,10020.816829859999,null,4747.6120961399984,null,1210.6973431900008,null,42592.869836640035]
[null," - Region North Jutland",9163.0915577900014,null,3629.1678166600022,null,2202.4042301199997,null,759.69387350999943,null,15754.357478080005]
[null," - Other area",0,null,250.18086244,null,34.281529770000006,null,0,null,284.46239220999996]
[null,"Total",153505.29804492,null,46906.153854170021,null,24716.586292840006,null,7236.0578762699997,null,232364.09606820001]
[]
[null,"Bond debt outstanding by size, DKKm"]
[null," 0 - 2",102173.39271914001,null,2273.9841670100027,null,985.49371408000025,null,905.18770932000007,null,106338.05830955003]
[null," 2 - 5",46464.710671529967,null,4263.3745542900015,null,1879.4525676500016,null,1336.4186036400006,null,53943.956397109971]
[null," 5 - 20",4680.0788924299986,null,16429.037958919984,null,6105.4780550600008,null,2130.7676678399998,null,29345.362574249986]
[null," 20 - 50",187.11576181999999,null,12381.829121400015,null,5794.6433388400019,null,2230.5065197999988,null,20594.094741860015]
[null," 50 - 100",0,null,5482.4661279299999,null,4222.8143488000005,null,579.05352890000006,null,10284.334005629999]
[null," 100 and above",0,null,6075.4619246199991,null,5728.7042684100006,null,54.123846769999993,null,11858.290039799998]
[null,"Total",153505.29804492,null,46906.153854169999,null,24716.586292840006,null,7236.0578762699988,null,232364.09606819999]
[]
[null,"Bond debt outstanding by seasoning"]
[null," 0 ",16998.051196370005,null,6022.5952798100079,null,2065.0985614299998,null,761.79675324999971,null,25847.541790860014]
[null," 1",49055.743824019999,null,9900.3815099099975,null,4948.3751002500012,null,1353.38263254,null,65257.883066719995]
[null," 2",18098.378198190003,null,5817.8948677899989,null,2684.3504113499994,null,406.61391433000006,null,27007.237391660001]
[null," 3",23379.104601080002,null,3122.3702343799996,null,2763.4885827300013,null,673.14850265999996,null,29938.111920850002]
[null," 4",16247.557145570001,null,2040.3448955200004,null,965.55566424999995,null,340.9963384699999,null,19594.454043810005]
[null," 6",14659.719038959993,null,7488.9109036499985,null,7865.9452279299994,null,2818.6453721499993,null,32833.220542689989]
[null," 8",6148.0241146900025,null,3781.715114820001,null,2376.6434257800001,null,315.18360414999995,null,12621.566259440004]
[null," 10",6212.3601832300001,null,5018.2658516500032,null,389.99634341999996,null,318.11428311000009,null,11938.736661410005]
[null," 15",2552.9267719600007,null,3651.1929837099997,null,637.45458274999987,null,236.54248289000006,null,7078.11682131]
[null," 20",153.43297085,null,62.482212930000003,null,19.678392949999999,null,11.63399272,null,247.22756944999998]
[null," 25",0,null,0,null,0,null,0,null,0]
[null," 30",0,null,0,null,0,null,0,null,0]
[null,"Total",153505.29804492003,null,46906.153854170007,null,24716.586292839998,null,7236.0578762699988,null,232364.09606820004]
[]
[null,"Bond debt outstanding by Loan To Value"]
[null,"0 - 20%",46664.145982294038,null,18375.270954973941,null,8015.4060879012095,null,2680.2231646118012,null,75735.046189780987]
[null,"20 - 40%",43057.516107348158,null,11981.627280565841,null,7505.8646183880119,null,2232.6654350763029,null,64777.673441378312]
[null,"40 - 60%",33977.987314900958,null,7507.2508315756131,null,5238.7375084201203,null,1389.1032119786671,null,48113.078866875352]
[null,"60 - 80%",20987.580962720032,null,4451.1283452219313,null,2330.3302930491054,null,590.74069378463241,null,28359.780294775705]
[null,"> 80 %",8818.0676778468405,null,4590.8764415526812,null,1626.2477850215491,null,343.32537055859825,null,15378.517274979667]
[null,"Total",153505.29804511002,null,46906.153853890006,null,24716.586292779997,null,7236.0578760100034,null,232364.09606779003]

{"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*",138,91]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Q2 2013"]

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

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

{"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 2013 Q2"]
[null,null," "]
[]
[null,"DKK billion ","Private",null,"Rental Residential",null,"Commercial",null,"Agriculture",null,"Weighted distribution",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",135.40510515787813,null,51.732310488579245,null,44.173772561256811,null,18.389469275985082,null,0.34096664507950691,null,249.70065748369927]
[null," - 20-40%",117.62637952546521,null,35.036227383424659,null,35.701316892203728,null,15.394160798594839,null,0.27823198870959115,null,203.75808459968843]
[null," - 40-60%",90.3126722538275,null,24.618192421218861,null,24.198159915788249,null,9.8338690262174122,null,0.20340906824106952,null,148.962893617052]
[null," - 60-80%",55.092292721247404,null,15.237297868115318,null,8.1419075696754106,null,3.8027665494174512,null,0.11234563936162921,null,82.27426470845559]
[null," - >80%",24.59586825543094,null,15.404100383711681,null,5.3529257981158462,null,2.2828308044251773,null,6.5046658608203162E-2,null,47.635725241683645]
[null,"Total",423.03231791384923,null,142.02812854504978,null,117.56808273704004,null,49.703096454639955,null,0.99999999999999989,null,732.33162565057899]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",62.615601447211588,null,15.478630408209195,null,29.983573278052887,null,14.099036514417223,null,0.32717286078891794,null,122.1768416478909]
[null," - 20-40%",56.197936403945462,null,12.692516161399992,null,24.134105378554601,null,12.335417741564536,null,0.28213959530078708,null,105.35997568546459]
[null," - 40-60%",45.324726452030248,null,10.349112344231349,null,16.365449103372242,null,8.1185734732583832,null,0.21465178233753576,null,80.157861372892228]
[null," - 60-80%",28.807592519994945,null,6.4603937566359368,null,4.7514710500486945,null,3.1122207901822319,null,0.11550073098786842,null,43.131678116861806]
[null," - >80%",12.963928408207916,null,5.0462185393635579,null,2.6942810580615171,null,1.9012943274676117,null,6.0535030584890966E-2,null,22.605722333100601]
[null,"Total",205.90978523139017,null,50.026871209840031,null,77.92887986808995,null,39.566542846889988,null,1.0000000000000002,null,373.43207915621008]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",46.664145982294038,null,18.375270954973942,null,8.0154060879012103,null,2.6802231646118013,null,0.32593265255440335,null,75.735046189781002]
[null," - 20-40%",43.057516107348157,null,11.981627280565842,null,7.5058646183880118,null,2.2326654350763029,null,0.27877660334615573,null,64.777673441378312]
[null," - 40-60%",33.977987314900957,null,7.5072508315756128,null,5.2387375084201206,null,1.389103211978667,null,0.20705900645183509,null,48.113078866875355]
[null," - 60-80%",20.987580962720031,null,4.4511283452219317,null,2.3303302930491054,null,0.59074069378463245,null,0.122048891264604,null,28.3597802947757]
[null," - >80%",8.8180676778468392,null,4.5908764415526813,null,1.6262477850215493,null,0.3433253705585983,null,6.6182846383002022E-2,null,15.37851727497967]
[null,"Total",153.50529804511001,null,46.906153853890011,null,24.716586292780001,null,7.2360578760100021,null,1.0000000000000002,null,232.36409606779003]

{"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 2013 Q2"]
[null,null," "]
[]
[null,"DKK billion ","Classification 1-3",null,"Classification 4-7",null,"Classification 8-11",null,"Total DKKm/ number"]
[null,"LTV by intervals, Total"]
[null," - 0-20%",47.609829393518844,null,181.72453492472059,null,20.366293165459972,null,249.70065748369942]
[null," - 20-40%",32.257717648597819,null,152.56086406062684,null,18.939502890464116,null,203.75808459968877]
[null," - 40-60%",20.124846950428566,null,112.90540992513698,null,15.932636741486927,null,148.96289361705249]
[null," - 60-80%",9.7737499746632661,null,62.25142980469186,null,10.249084929100526,null,82.274264708455661]
[null," - >80%",8.8017192085855385,null,29.521165310970382,null,9.3128407221278398,null,47.635725241683758]
[null,"Total",118.56786317579402,null,538.96340402614658,null,74.8003584486394,null,732.33162565058001]
[]
[null,"LTV by intervals, Capital center T"]
[null," - 0-20%",15.892069175222773,null,93.182974140681011,null,13.101798331987085,null,122.17684164789087]
[null," - 20-40%",11.129601570123526,null,81.778889063742426,null,12.451485051598496,null,105.35997568546445]
[null," - 40-60%",7.248199183404517,null,62.361728002858335,null,10.547934186629348,null,80.157861372892199]
[null," - 60-80%",3.1669908123223962,null,33.303695039565419,null,6.660992264973987,null,43.131678116861799]
[null," - >80%",1.7144405749221783,null,15.319739652107453,null,5.5715421060709902,null,22.605722333100619]
[null,"Total",39.15130131599539,null,285.94702589895462,null,48.333751941259905,null,373.43207915620991]
[]
[null,"LTV by intervals, Capital center S"]
[null," - 0-20%",14.44133493789759,null,56.864689737489577,null,4.4290215143939049,null,75.735046189781073]
[null," - 20-40%",10.840488812083775,null,49.786641353419455,null,4.1505432758750391,null,64.777673441378269]
[null," - 40-60%",6.7885484702446259,null,37.678064189131234,null,3.6464662074994645,null,48.113078866875327]
[null," - 60-80%",3.4224803673676734,null,22.398586115414655,null,2.5387138119933548,null,28.359780294775682]
[null," - >80%",2.8751681754275542,null,10.093091006296367,null,2.4102580932557278,null,15.378517274979648]
[null,"Total",38.368020763021221,null,176.82107240175128,null,17.175002903017489,null,232.36409606778997]

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

{"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",46906153854.170013,46655972991.730011]
[{"$f":"B4&\"-\"&D4","v":"S-Erhverv"},{"$f":"IF(C4=\"\",B3,C4)","v":"S"},null,"Erhverv",24716586292.840015,24682304763.070019]
["S-Landbrug","S",null,"Landbrug",7236057876.2700024,7236057876.2700024]
["S-Privat","S",null,"Privat",153505298044.92032,153505298044.92032]
["S Total-","S Total","S Total",null,232364096068.20035,232079633675.99036]
["T-Boligudl","T","T","Boligudl",50026871210.249893,49631081729.239899]
["T-Erhverv","T",null,"Erhverv",77928879868.020203,68708961565.770088]
["T-Landbrug","T",null,"Landbrug",39566542846.619972,39566542846.619972]
["T-Privat","T",null,"Privat",205909785232.1199,205909785232.1199]
["T Total-","T Total","T Total",null,373432079157.01001,363816371373.74988]
["Ø-Boligudl","Ø","Ø","Boligudl",45095103481.750015,44897796587.150017]
["Ø-Erhverv","Ø",null,"Erhverv",14922616576.139992,14625977623.109989]
["Ø-Landbrug","Ø",null,"Landbrug",2900495731.5899973,2900495731.5899973]
["Ø-Privat","Ø",null,"Privat",63617234637.330009,63617234637.330009]
["Ø Total-","Ø Total","Ø Total",null,126535450426.81001,126041504579.18002]
["Hovedtotal-","Hovedtotal","Hovedtotal",null,732331625652.02026,721937509628.92017]
[]
[]
[]
[]
[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":205909785232.1199}]
[null,null,{"$f":"RIGHT($E$23,1)&\"-\"&D25","v":"T-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C25,$A$3:$F$18,6,FALSE)","v":49631081729.239899}]
[null,null,"T-Erhverv","Erhverv","Commercial",68708961565.770088]
[null,null,"T-Landbrug","Landbrug","Agriculture",39566542846.619972]
[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":9615707783.2601318}]
[]
[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":153505298044.92032}]
[null,null,{"$f":"RIGHT($E$30,1)&\"-\"&D32","v":"S-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C32,$A$3:$F$18,6,FALSE)","v":46655972991.730011}]
[null,null,"S-Erhverv","Erhverv","Commercial",24682304763.070019]
[null,null,"S-Landbrug","Landbrug","Agriculture",7236057876.2700024]
[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":284462392.21002197}]
[]
[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":63617234637.330009}]
[null,null,{"$f":"RIGHT($E$37,1)&\"-\"&D39","v":"Ø-Boligudl"},"Boligudl","Rental Residential",{"$f":"VLOOKUP(C39,$A$3:$F$18,6,FALSE)","v":44897796587.150017}]
[null,null,"Ø-Erhverv","Erhverv","Commercial",14625977623.109989]
[null,null,"Ø-Landbrug","Landbrug","Agriculture",2900495731.5899973]
[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":493945847.63000488}]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Private",{"$f":"SUM(F24,F31,F38)","v":423032317914.37024}]
[null,null,null,null,"Rental Residential",{"$f":"SUM(F25,F32,F39)","v":141184851308.11993}]
[null,null,null,null,"Commercial",108017243951.95009]
[null,null,null,null,"Agriculture",49703096454.479973]
[null,null,null,null,"Nordic",10394116023.100159]