See accounting policy B.
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | |
---|---|---|---|---|
31 December 2021 | Level 1 | Level 2 | Level 3 | Total fair value |
Financial assets | | | | |
| | | | |
Investments available for sale | | | | |
Government bonds | 13,889 | 260 | - | 14,149 |
Corporate bonds | 10,762 | 53 | 12 | 10,827 |
Asset-backed securities | 17 | 5 | 508 | 530 |
Preference shares | - | 307 | 4 | 311 |
Equities | 3,110 | 679 | 321 | 4,111 |
Mortgage equity funds | - | - | 398 | 398 |
Other participating interests | 7 | - | - | 7 |
| 27,786 | 1,304 | 1,243 | 30,333 |
| | | | |
Investments at fair value through profit or loss | | | | |
Equities | 12 | - | 6 | 18 |
Real estate equity funds | - | - | 2,202 | 2,202 |
Mortgage equity funds | - | - | 781 | 781 |
Rural property contracts | - | - | 215 | 215 |
| 12 | - | 3,205 | 3,216 |
| | | | |
Investments on behalf of policyholders | | | | |
Government bonds | 1,626 | - | - | 1,626 |
Corporate bonds | 787 | - | - | 787 |
Derivatives | - | 6 | - | 6 |
Equities | 8,645 | - | - | 8,645 |
Real estate equity funds | 249 | - | - | 249 |
Mortgage equity funds | - | - | 234 | 234 |
Cash and cash equivalents | 18 | - | - | 18 |
Other investments | 6 | 4 | - | 9 |
| 11,331 | 9 | 234 | 11,574 |
| | | | |
Investments related to investment contracts | | | | |
Equities | 1,794 | - | - | 1,794 |
Real estate equity funds | 119 | - | - | 119 |
Cash and cash equivalents | 39 | - | - | 39 |
| 1,952 | - | - | 1,952 |
| | | | |
Derivatives | | | | |
Foreign exchange contracts | - | 25 | - | 25 |
Interest rate contracts | | | | |
- Swaps | - | 5,870 | - | 5,870 |
- Options | - | 237 | - | 237 |
- Futures | 37 | - | - | 37 |
Inflation linked swaps | - | 14 | - | 14 |
Equity index contracts | 28 | - | - | 28 |
| 65 | 6,147 | - | 6,212 |
| | | | |
Cash and cash equivalents | 2,306 | - | - | 2,306 |
| | | | |
Total financial assets | 43,452 | 7,460 | 4,682 | 55,593 |
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | |
---|---|---|---|---|
31 December 2021 | Level 1 | Level 2 | Level 3 | Total fair value |
Financial liabilities | | | | |
| | | | |
Liabilities arising from investment contracts | 1,952 | - | - | 1,952 |
| | | | |
Derivatives | | | | |
Foreign exchange contracts | - | 78 | - | 78 |
Interest rate contracts | | | | |
- Swaps | - | 678 | - | 678 |
- Futures | - | 3 | - | 3 |
| - | 759 | - | 759 |
| | | | |
Total financial liabilities | 1,952 | 759 | - | 2,711 |
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | |
---|---|---|---|---|
31 December 2020 | Level 1 | Level 2 | Level 3 | Total fair value |
Financial assets | | | | |
| | | | |
Investments available for sale | | | | |
Government bonds | 17,381 | 9 | - | 17,390 |
Corporate bonds | 11,591 | 223 | 3 | 11,817 |
Asset-backed securities | - | - | 404 | 404 |
Preference shares | - | 313 | 3 | 316 |
Equities | 2,645 | 520 | 282 | 3,447 |
Mortgage equity funds | - | - | 393 | 393 |
Other participating interests | 7 | - | - | 7 |
| 31,623 | 1,065 | 1,085 | 33,774 |
| | | | |
Investments at fair value through profit or loss | | | | |
Equities | 53 | - | 10 | 62 |
Real estate equity funds | - | - | 2,029 | 2,029 |
Mortgage equity funds | - | - | 590 | 590 |
Rural property contracts | - | - | 143 | 143 |
| 53 | - | 2,772 | 2,825 |
| | | | |
Investments on behalf of policyholders | | | | |
Government bonds | 1,583 | - | - | 1,583 |
Corporate bonds | 764 | - | - | 764 |
Derivatives | - | 14 | - | 14 |
Equities | 7,676 | - | - | 7,676 |
Cash and cash equivalents | 112 | - | - | 112 |
Other investments | 1 | 4 | - | 5 |
| 10,136 | 18 | - | 10,154 |
| | | | |
Derivatives | | | | |
Foreign exchange contracts | - | 57 | - | 57 |
Interest rate contracts | | | | |
- Swaps | - | 8,874 | - | 8,874 |
- Options | - | 223 | - | 223 |
Equity index contracts | 13 | - | - | 13 |
| 13 | 9,155 | - | 9,168 |
| | | | |
Cash and cash equivalents | 2,846 | - | - | 2,846 |
| | | | |
Total financial assets | 44,671 | 10,238 | 3,857 | 58,767 |
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | |
---|---|---|---|---|
31 December 2020 | Level 1 | Level 2 | Level 3 | Total fair value |
Financial liabilities | | | | |
| | | | |
Derivatives | | | | |
Foreign exchange contracts | - | 4 | - | 4 |
Interest rate contracts | | | | |
- Swaps | - | 1,362 | - | 1,362 |
- Futures | 8 | 10 | - | 19 |
Inflation linked swaps | - | 35 | - | 35 |
| 8 | 1,411 | - | 1,419 |
| | | | |
Total financial liabilities | 8 | 1,411 | - | 1,419 |
Cash and cash equivalents are classified as level 1 when not subject to restrictions.
2021 | To level 1 | To level 2 | To level 3 | Total |
---|---|---|---|---|
From: | | | | |
Level 1: Fair value based on quoted prices in an active market | - | 205 | - | 205 |
Level 2: Fair value based on observable market data | 171 | - | - | 171 |
Level 3: Fair value not based on observable market data | 38 | - | - | 38 |
Fixed income funds are adjusted from level 2 to level 1 (€ 171 million), from level 3 to level 1 (€ 38 million) and from level 1 to level 2 (€ 205 million). Those movements are based respectively on increased and decreased observability of the inputs during the period.
2020 | To level 1 | To level 2 | To level 3 | Total |
---|---|---|---|---|
From: | | | | |
Level 1: Fair value based on quoted prices in an active market | - | 12 | - | 12 |
Level 2: Fair value based on observable market data | 353 | - | - | 353 |
Level 3: Fair value not based on observable market data | - | - | - | - |
Fixed income funds were adjusted from level 2 to level 1 (€ 353 million) and from level 1 to level 2 (€ 12 million). Both movements are based respectively on increased and decreased observability of the inputs during the period.
The following two tables show the movement in financial assets measured at fair value including investment on behalf of policyholders and investment property that are categorised within level 3.
| 2021 | 2020 |
---|---|---|
At 1 January | 1,085 | 1,023 |
| | |
Changes in value of investments, realised/unrealised gains and losses: | | |
- Realised gains and losses | 37 | 13 |
- Recognised in Other comprehensive income (unrealised gains and losses) | 20 | -4 |
| | |
Purchases | 407 | 254 |
Repayments | -80 | -162 |
Disposal | -190 | -112 |
Amortisation | -1 | - |
Impairments | 1 | 1 |
Reclassification of investments from/to Level 3 valuation technique | -36 | - |
Changes in the composition of the group | - | 72 |
| | |
At 31 December | 1,243 | 1,085 |
| 2021 | 2020 |
---|---|---|
At 1 January | 2,772 | 3,014 |
| | |
Changes in value of investments, realised/unrealised gains and losses: | | |
- Fair value gains and losses | 121 | - |
| | |
Purchases | 565 | 396 |
Capital improvements | - | 4 |
Disposal | -21 | -653 |
| | |
Reclassification of investments from/to Level 3 valuation technique | -2 | - |
Transfer between investments on behalf of policyholders and investment property | - | 10 |
Transfer between investments and investment property | 2 | 1 |
| | |
At 31 December | 3,439 | 2,772 |
| | |
Total revaluations of investments, held at end of period, recognised in the income statement | 122 | -74 |
Available for sale investments
The main non-observable market input for the asset-backed securities and mortgage equity funds available for sale are based on quotes published by an independent data vendor. If the quote of the data vendor is not available, values or quotes from other pricing services are obtained, including a check on the validity of the value or quote by an independent third party, to base the fair value on. There is no material difference in the fair value of the asset-backed securities and mortgage equity funds if a quote was used from an alternative data vendor.
The main non-observable market input for the equities and unlisted equities classified as level 3 is the net asset value as published by the investee. It is estimated that a 10% increase in valuation of these equities would have no significant impact on net result but would increase equity by € 32 million (2020: € 28 million), being approximately 0.4% (before tax) (2020: 0.4% (before tax)) of total equity. A decrease would have the opposite effect unless the impairment criteria are met.
Investments at fair value through profit or loss
The method of determining the fair value of the mortgage equity funds is similar to that of mortgage loans, however it excludes assumptions for originating cost and is determined within the funds structure. See chapter 6.7.1.2 for the main non-observable inputs.
The table below discloses the sensitivities to non-observable market inputs for the property portfolio, including real estate equity funds.
31-Dec-21 | | | | | | | | Change in theoretical rental value | ||
---|---|---|---|---|---|---|---|---|---|---|
| Fair value | Valuation technique | Gross | Gross theoretical rental value (€) | Gross | Gross yield (%) | Change in yield | -5% | 0% | 5% |
Investments at fair value through profit or loss | | | | | | | | | | |
Rural property contracts | 215 | DCF | total | 4,378,039 | mean | 2.0% | -5% | - | 11 | 23 |
| | | max | 147,419 | max | 3.0% | 0% | -11 | - | 11 |
| | | min | 466 | min | 0.6% | 5% | -21 | -10 | - |
Total rural property contracts | 215 | | | | | | | | | |
| | | | | | | | | | |
Real estate equity funds associates | 1,817 | DCF | | 76,670,413 | | 4.2% | -5% | - | 96 | 191 |
| | | | | | | 0% | -91 | - | 91 |
| | | | | | | 5% | -173 | -87 | - |
Real estate equity funds third parties | 385 | | | | | | | | | |
Total real estate equity funds | 2,202 | | | | | | | | | |
31-Dec-20 | | | | | | | | Change in theoretical rental value | ||
---|---|---|---|---|---|---|---|---|---|---|
| Fair value | Valuation technique | Gross | Gross theoretical rental value (€) | Gross | Gross yield (%) | Change in yield | -5% | 0% | 5% |
Investments at fair value through profit or loss | | | | | | | | | | |
Rural property contracts | 143 | DCF | total | 2,503,101 | mean | 1.7% | -5% | - | 8 | 15 |
| | | max | 146,878 | max | 2.9% | 0% | -7 | - | 7 |
| | | min | 10 | min | 1.3% | 5% | -14 | -7 | - |
Total rural property contracts | 143 | | | | | | | | | |
| | | | | | | | | | |
Real estate equity funds associates | 1,735 | DCF | | 78,271,360 | | 4.5% | -5% | - | 91 | 183 |
| | | | | | | 0% | -87 | - | 87 |
| | | | | | | 5% | -165 | -83 | - |
Real estate equity funds third parties | 294 | | | | | | | | | |
Total real estate equity funds | 2,029 | | | | | | | | | |
The main non-observable market input for the real estate equity funds third parties is the net asset value as published by the investee. An increase or decrease in the net asset value of equities classified as level 3 will have a direct proportional impact on the fair value of the investment.
The breakdown of the fair values of financial assets and liabilities not measured at fair value, and for which the fair value is disclosed in accordance with the level of fair value hierarchy, as explained in accounting policy B, is as follows:
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | | |
---|---|---|---|---|---|
31 December 2021 | Level 1 | Level 2 | Level 3 | Total fair value | Total carrying value |
Financial assets | | | | | |
Due from customers | - | 1,513 | 10,696 | 12,209 | 11,461 |
Due from credit institutions | 124 | 3,558 | - | 3,682 | 2,971 |
Trade and other receivables | - | 827 | - | 827 | 827 |
Total financial assets | 124 | 5,898 | 10,696 | 16,718 | 15,259 |
| | | | | |
Financial liabilities | | | | | |
Subordinated liabilities | - | 1,132 | - | 1,132 | 992 |
Borrowings | - | 137 | 55 | 192 | 192 |
Due to customers | - | 573 | - | 573 | 573 |
Due to banks | 5,636 | 105 | - | 5,741 | 5,741 |
Other financial liabilities | 92 | 16 | - | 108 | 108 |
Total financial liabilities | 5,728 | 1,963 | 55 | 7,745 | 7,605 |
| Fair value based on quoted prices in an active market | Fair value based on observable market data | Fair value not based on observable market data | | |
---|---|---|---|---|---|
31 December 2020 | Level 1 | Level 2 | Level 3 | Total fair value | Total carrying value |
Financial assets | | | | | |
Due from customers | - | 621 | 8,866 | 9,487 | 8,813 |
Due from credit institutions | 1,757 | 4,025 | - | 5,782 | 4,727 |
Trade and other receivables | - | 830 | - | 830 | 830 |
Total financial assets | 1,757 | 5,475 | 8,866 | 16,099 | 14,370 |
| | | | | |
Financial liabilities | | | | | |
Subordinated liabilities | - | 1,157 | - | 1,157 | 991 |
Borrowings | - | 33 | 21 | 54 | 54 |
Due to customers | - | 553 | - | 553 | 553 |
Due to banks | 7,891 | 105 | - | 7,996 | 7,996 |
Other financial liabilities | 88 | 22 | - | 110 | 110 |
Total financial liabilities | 7,980 | 1,869 | 21 | 9,870 | 9,704 |
In 2020, amounts due from credit institutions presented as level 1 mainly consisted of reverse repurchase agreements. Amounts due to banks presented as level 1 primarily comprise the liability recognised for the cash collateral received. The accrued interest included in other liabilities follows the classification of the underlying assets. Level 2 category financial assets relates primarily to the receivable due from the credit institution for savings-linked mortgage loans amounting to a fair value of € 3,124 million (2020: € 3,659 million).
The mortgage loan portfolio is classified as level 3 ‘not measured on the basis of market observable market data’. Non-observable market inputs are used in the valuation methods, in addition to the observable market inputs. The valuation method used to determine the fair value of the mortgage loan portfolio is based on the spread on the interest rate curve for discounting the mortgage portfolio cash flows on consumer rates and includes assumptions for originating cost, proposal risk, and the options related to early redemption and moving.
The mortgage loan portfolio consists of high quality mortgages with a relatively fixed return, limited impairments and arrears (see chapter 6.5.8). The mortgage loan portfolio consists only of Dutch mortgages with a limited counterparty default risk in line with the strategic investment plan (see chapter 6.8.4).
The breakdown of the investment property, land and buildings for own use and plants in accordance with the fair value hierarchy, as explained in accounting policy B, is as follows:
| Fair value based on quoted prices in an active market | Fair Value based on observable market data | Fair Value not based on observable market data | |
---|---|---|---|---|
31 December 2021 | Level 1 | Level 2 | Level 3 | Total fair value |
Investment property | - | - | 2,052 | 2,052 |
Land and buildings for own use | - | - | 145 | 145 |
Plants | - | - | 332 | 332 |
| | | | |
Total | - | - | 2,530 | 2,530 |
| Fair value based on quoted prices in an active market | Fair Value based on observable market data | Fair Value not based on observable market data | |
---|---|---|---|---|
31 December 2020 | Level 1 | Level 2 | Level 3 | Total fair value |
Investment property | - | - | 1,973 | 1,973 |
Land and buildings for own use | - | - | 158 | 158 |
| | | | |
Total | - | - | 2,130 | 2,130 |
The property portfolio are classified as a level 3 ‘not measured on the basis of market observable market data’. Non- observable market inputs are used in the valuation methods, in addition to the observable market inputs. The fair value measurement is based on valuations by independent professional appraisers. These valuations have been performed for the entire portfolio of investment property, buildings for own use and plants. Independent professional appraisers use reference transactions of comparable properties, in combination with the DCF and income capitalisation method, to determine the fair value of the property or plant. The reference transactions of comparable objects of the property portfolio are generally based on observable data consisting of the land register ‘Kadaster’ and the rural land price monitor as published by the Dutch Government ‘Grondprijsmonitor’ in an active property market.
For plants the cost price is a good approximation of the fair value at year-end, as the plants were acquired in December 2021.
The property has a relatively fixed return. The property portfolio is well diversified and consists of residential, retail, offices and rural property, throughout the Netherlands. The retail portfolio focusses on high street locations with relative low vacancy rates. The following table shows a breakdown of the fair value and vacancy rates of the portfolio of investment property.
| Fair value | Vacancy rate | ||
---|---|---|---|---|
| 31 December 2021 | 31 December 2020 | 2021 | 2020 |
Retail | 161 | 174 | 5.0% | 6.9% |
Residential | 1 | 1 | - | - |
Rural | 1,625 | 1,574 | - | - |
Offices | 241 | 209 | 8.2% | 10.0% |
Property under development | 12 | - | 100.0% | 100.0% |
Parking | 12 | 15 | - | - |
Total | 2,052 | 1,973 | 2.9% | 4.0% |
The movements in investment property and plants measured at fair value (recurring basis) that are categorised within level 3 are presented in chapter 6.5.2 and 6.5.3.
Significant inputs to the Level 3 values of investment property are the net initial yield and market rental value. These inputs are verified with the following market observable data:
Market rent per square meter for renewals and their respective re-letting rates;
Reviewed rent per square meter;
Investment transaction of comparable objects;
The 10 year Dutch Government Bond Yield (%) rate as published by the DNB.
The table below discloses the sensitivities to non-observable market inputs for the property portfolio (excluding development investment property and plants).
31 December 2021 | Change in theoretical rental value | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
| Fair value | Valuation technique | Gross | Gross theoretical rental value (€) | Gross | Gross yield (%) | Change in yield | -5% | 0% | 5% |
Investment property - Fair value model | | | | | | | | | | |
Retail | 161 | DCF | total | 11,096,858 | mean | 6.9% | -5% | - | 8 | 17 |
| | | max | 1,617,540 | max | 12.9% | 0% | -8 | - | 8 |
| | | min | 41,519 | min | 2.4% | 5% | -15 | -8 | - |
Residential | 1 | DCF | total | 75,501 | mean | 7.5% | -5% | - | - | - |
| | | max | 75,501 | max | 7.5% | 0% | - | - | - |
| | | min | 75,501 | min | 7.5% | 5% | - | - | - |
Rural | 1,625 | DCF | total | 36,171,938 | mean | 2.2% | -5% | - | 86 | 171 |
| | | max | 1,865,893 | max | 7.3% | 0% | -81 | - | 81 |
| | | min | 308 | min | 0.4% | 5% | -155 | -77 | - |
Offices | 241 | DCF | total | 14,271,731 | mean | 5.9% | -5% | - | 13 | 25 |
| | | max | 5,015,714 | max | 9.2% | 0% | -12 | - | 12 |
| | | min | 38,656 | min | 3.4% | 5% | -23 | -11 | - |
Property under development | 12 | | | | | | | | | |
| | | | | | | | | | |
Parking | 12 | | | | | | | | | |
| | | | | | | | | | |
Land and buildings for own use | 145 | DCF | total | 9,607,224 | mean | 6.9% | -5% | - | 7 | 15 |
| | | max | 9,607,224 | max | 6.9% | 0% | -7 | - | 7 |
| | | min | 9,607,224 | min | 6.9% | 5% | -13 | -7 | - |
| | | | | | | | | | |
Plants | 332 | | | | | | | | | |
| | | | | | | | | | |
Total | 2,530 | | | | | | | | | |
31 December 2020 | Change in theoretical rental value | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
| Fair value | Valuation technique | Gross | Gross theoretical rental value (€) | Gross | Gross yield (%) | Change in yield | -5% | 0% | 5% |
Investment property - Fair value model | | | | | | | | | | |
Retail | 174 | DCF | total | 9,287,682 | mean | 5.3% | -5% | - | 9 | 18 |
| | | max | 1,653,606 | max | 15.3% | 0% | -9 | - | 9 |
| | | min | 44,367 | min | 3.4% | 5% | -17 | -8 | - |
Residential | 1 | DCF | total | 86,335 | mean | 8.4% | -5% | - | - | - |
| | | max | 86,335 | max | 8.4% | 0% | - | - | - |
| | | min | 86,335 | min | 8.4% | 5% | - | - | - |
Rural | 1,574 | DCF | total | 24,025,481 | mean | 1.5% | -5% | - | 83 | 166 |
| | | max | 1,619,813 | max | 4.8% | 0% | -79 | - | 79 |
| | | min | 616 | min | 0.8% | 5% | -150 | -75 | - |
Offices | 209 | DCF | total | 12,282,146 | mean | 5.9% | -5% | - | 11 | 22 |
| | | max | 4,519,785 | max | 9.3% | 0% | -10 | - | 10 |
| | | min | 915,980 | min | 4.8% | 5% | -20 | -10 | - |
Property under development | 15 | | | | | | | | | |
| | | | | | | | | | |
Land and buildings for own use | 158 | DCF | total | 9,502,139 | mean | 6.2% | -5% | - | 8 | 16 |
| | | max | 9,502,139 | max | 6.2% | 0% | -8 | - | 8 |
| | | min | 9,502,139 | min | 6.2% | 5% | -15 | -7 | - |
| | | | | | | | | | |
Total | 2,130 | | | | | | | | | |