SLIDE 22 CEEC-conference 13-10-2017 Tim de Jonge 22/23
Investment Acquisition value of existing premises (per dwelling) 80.600 € Number of dwellings (per staircase) before renovation 8 Number of dwellings (per staircase) after renovation 10 Acquisition value of existing dwelling 64.480 € Construction costs (VAT excluded) 79.000 € VAT on construction costs 21% 16.590 € Construction costs (VAT included) 95.590 € Additional costs 20% 19.120 € Contingencies ca. 5% 5.690 € 120.400 € Yield / transfer to operation 184.880 € Balance (profit / loss)
184.880 € 184.880 € Operation Intended operation period (years) 30 Inflation 0,00% Real (internal) rate of return 1,82% which is nominal 1,82% Real depreciation rate / year
which is nominal
Vacancies 1,00% Annual reservation for management 900 € VAT included Annual reservation for maintenance and repair 1.200 € VAT included Annual reservation for business expenses 600 € VAT included Acquisition value of renovated dwelling 184.880 € Management (discounted value) 21.040 € Maintenance (discounted value) 28.050 € Property expenses (discounted value) 14.020 € Total discounted value of periodic expenses 63.110 € Gross revenues from rent (discounted value) 173.360 € Less: cash value due to vacancies
€ Net revenues from rent (discounted value) 171.630 € Nominal exit-value (non-recurring yield) 155.270 € Discounted exit-value (non-recurring yield) 92.000 € Balance (profit / loss) 6% 15.640 € 263.630 € 263.630 € Housing expenses Rent per month 618,05 € Energy per month 122,27 € Service costs per month
Total housing expenses 740,32 € Costs Benefits Costs Benefits Costs Benefits
Life cycle approach (NEN-standard 2699) 786.469 / 10 = 79.000 80.600 x 8 /10 = 64.480 Renovation ~ nw.const.-level (635x6 + 592x4) / 10 = 618 (128x6 + 113x4) / 10 = 122
IRR = 2,23%
(763x6 + 705x4) / 10 = 740
What we can do, is make more apartments in the building block. Investment costs and housing expenses will change. But the effect is, that the IRR moves to the safer end of the spread.
Investment Acquisition value of existing premises (per dwelling) 80.600 € Number of dwellings (per staircase) before renovation 8 Number of dwellings (per staircase) after renovation 10 Acquisition value of existing dwelling 64.480 € Construction costs (VAT excluded) 87.000 € VAT on construction costs 21% 18.270 € Construction costs (VAT included) 105.270 € Additional costs 20% 21.050 € Contingencies ca. 5% 6.280 € 132.600 € Yield / transfer to operation 197.080 € Balance (profit / loss)
197.080 € 197.080 € Operation Intended operation period (years) 30 Inflation 0,00% Real (internal) rate of return 1,82% which is nominal 1,82% Real depreciation rate / year
which is nominal
Vacancies 1,00% Annual reservation for management 900 € VAT included Annual reservation for maintenance and repair 1.200 € VAT included Annual reservation for business expenses 600 € VAT included Acquisition value of renovated dwelling 197.080 € Management (discounted value) 21.040 € Maintenance (discounted value) 28.050 € Property expenses (discounted value) 14.020 € Total discounted value of periodic expenses 63.110 € Gross revenues from rent (discounted value) 180.240 € Less: cash value due to vacancies
€ Net revenues from rent (discounted value) 178.440 € Nominal exit-value (non-recurring yield) 165.520 € Discounted exit-value (non-recurring yield) 98.070 € Balance (profit / loss) 6% 16.320 € 276.510 € 276.510 € Housing expenses Rent per month 642,56 € Energy per month 73,25 € Service costs per month
Total housing expenses 715,81 € Costs Benefits Costs Benefits Costs Benefits
Life cycle approach (NEN-standard 2699) 867.445 / 10 = 87.000 80.00 x 8 / 10 = 64.480 Renovation ~ sustainable (661x6 + 615x4) / 10 = 643 (77x6 + 68x4) / 10 = 73
IRR = 2,22% actually IRR could be higher, but some is given to tenants
(738x6 + 683x4) / 10 = 716
Finally, we add the extra measures, to make it a sustainable renovation in terms of energy efficiency and CO2-reduction. This can yield the same IRR, if the profit of the reduction of energy-costs is split 50/50 between the tenant and the housing association. Of course an extra investment has to be made.