G H Addressing the future financial risk of flooding 2 Social cost-benefit analysis - Option X Detail of analysis Instructions: You need to complete the spreadsheet by inserting appropriate calculations into the yellow cells. 3. This will automatically create answers in the green cells. 51. New homes built on floodplains each y Income quintile Bottorn Second Middle Fourth Top Total Baseline New home purchases on floodplains by income quintile, number pa 8000 7200 4500 2300 8000 25000 Average price of new homes purchased on Floodplains, 120000 180000 232000 315000 820000 259380 Option X Tax rate 10% 10% 10% 10% 10% Average price including tax of new homes on floodplains. 2 132000 198000 255200 346500 902000 285318 Price elasticity of demand (PED) -0.90 -0.70 -0.20 -0.10 0.00 Change in number of new homes bought on floodplains O Remaining new homes built on floodplains 8000 7200 4500 2300 3000 25000 69000 107000 129000 140000 157000 602000 2. Grants to improve flood resilience Baseline Existing homes at risk of flooding, number Option X Tax revenue available to fund flood-resilience grants, Emillion pa Size of each grant. Number of grants, number pa 96.0 648.5 10000 9600 129.6 10000 12960 104.4 10000 10440 72.5 10000 7245 246.0 10000 24600 64845 3. Benefit to households of improved flood resilience Number of existing homes receiving a flood- resilience grant, number pa Proportion of these homes flooding each year, 9600 12960 10440 7245 24600 64845 % pa 140% 140% 1.40% 140% 140% 134 181 146 101 344 908 Number of these hornes flooding each year number pa Average reduction in flood damage per household due to flood-resilience measures funded by the grant pa Aggregate benefit from the grants Emillion Equity weighting Equity weighted benefit from grants Benefits of grant after equity weighting, Emillion 18 220.000 2.7 2/25 6.0 220.000 36 1.45 53 $120.000 29 105 3.1 $20.000 2.0 0.75 15 $20.000 6.9 0.45 3.1 19 0.0 Option X Equity benefit Option X Costs and benefits Option X - NPV G H Addressing the future financial risk of flooding 2 Social cost-benefit analysis - Option X Detail of analysis Instructions: You need to complete the spreadsheet by inserting appropriate calculations into the yellow cells. 3. This will automatically create answers in the green cells. 51. New homes built on floodplains each y Income quintile Bottorn Second Middle Fourth Top Total Baseline New home purchases on floodplains by income quintile, number pa 8000 7200 4500 2300 8000 25000 Average price of new homes purchased on Floodplains, 120000 180000 232000 315000 820000 259380 Option X Tax rate 10% 10% 10% 10% 10% Average price including tax of new homes on floodplains. 2 132000 198000 255200 346500 902000 285318 Price elasticity of demand (PED) -0.90 -0.70 -0.20 -0.10 0.00 Change in number of new homes bought on floodplains O Remaining new homes built on floodplains 8000 7200 4500 2300 3000 25000 69000 107000 129000 140000 157000 602000 2. Grants to improve flood resilience Baseline Existing homes at risk of flooding, number Option X Tax revenue available to fund flood-resilience grants, Emillion pa Size of each grant. Number of grants, number pa 96.0 648.5 10000 9600 129.6 10000 12960 104.4 10000 10440 72.5 10000 7245 246.0 10000 24600 64845 3. Benefit to households of improved flood resilience Number of existing homes receiving a flood- resilience grant, number pa Proportion of these homes flooding each year, 9600 12960 10440 7245 24600 64845 % pa 140% 140% 1.40% 140% 140% 134 181 146 101 344 908 Number of these hornes flooding each year number pa Average reduction in flood damage per household due to flood-resilience measures funded by the grant pa Aggregate benefit from the grants Emillion Equity weighting Equity weighted benefit from grants Benefits of grant after equity weighting, Emillion 18 220.000 2.7 2/25 6.0 220.000 36 1.45 53 $120.000 29 105 3.1 $20.000 2.0 0.75 15 $20.000 6.9 0.45 3.1 19 0.0 Option X Equity benefit Option X Costs and benefits Option X - NPV