jagomart
digital resources
picture1_Spreadsheet Calculator 46087 | New Homes Bonus Calculator


 261x       Filetype XLSX       File size 0.46 MB       Source: assets.publishing.service.gov.uk


File: Spreadsheet Calculator 46087 | New Homes Bonus Calculator
sheet 1 new homes bonus new homes bonus calculator step 1 please select the method you wish to use to view bonus payments step 2 select a local authority or ...

icon picture XLSX Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: New Homes Bonus












New Homes Bonus Calculator































Step 1. Please select the method you wish to use to view bonus payments




















Step 2. Select a local authority or county from the drop-down list





















Department for Communities and Local Government














newhomesbonus@communities.gsi.gov.uk


















Calculating the New Homes Bonus

































































Cumulative New Homes Bonus payments




































































Current year payments only





































































Illustrative Payments by Band






















Sheet 2: Calculating NHB
Return to homepage






















Calculation process

























Worked example










Council tax band Total A B C D E F G H

I Weighting (Band D equivalence)
6/9 7/9 8/9 9/9 11/9 13/9 15/9 18/9

II Previous year dwelling stock 7,521 1,500 1,286 1,125 1,000 818 692 600 500

III …in band D equivalents (II x I) 8,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000

IV Growth in dwelling stock* 75 15 13 11 10 8 7 6 5

V …in band D equivalents (IV x I) 80 10 10 10 10 10 10 10 10

VI National average Band D council tax rate £1,530 £1,020 £1,190 £1,360 £1,530 £1,869 £2,209 £2,549 £3,059

VII Baseline = 0.4% of band D equivalent stock (III x 0.4%) 32








VIII Units rewarded - Band D equivalents (V - VII) 48








IX Payment for Band D equivalents (VIII x VI) £73,419








X Affordable homes 15








XI Affordable homes payment (X x £350) £5,250








XII Annual payment (XI + IX) £78,669
































The worked example above shows the method for calculating the New Homes Bonus in a hypothetical local authority.

The calculation shows the outcome following a 1% growth in the housing stock, evenly split across the council tax bands and 15 new affordable homes. There is a baseline level of 0.4%, below which new homes are not rewarded with the Bonus and the national average Band D council tax rate of £1,529.56 is paid thereafter.

*In practice the growth in the dwelling stock is calculated from DCLG Council Taxbase (CTB) statistics with the effective stock (i.e. after accounting for demolished or long term empty property, Line 1 minus Line 3 minus Line 18 on the CTB form) in the previous year subtracted from the latest year.



























































































































































Sheet 3: Cumulative Payments
New Homes Bonus Calculator




Reform: No




















Please select your local authority or county (counties at bottom of list). Select your local authority or county Current housing stock (Oct 16): -










Net change in stock (Oct 16)1: -








Return to homepage
Affordable housing supply (15/16)3: -










Stock of empty homes (Oct 16): -































Year of Payment












Cumulative Payments 2011 / 12 2012 / 13 2013 / 14 2014 / 15 2015 / 16 2016 / 17 2017 / 18 2018 / 19 2019 / 20 2020 / 21



Payments for Year 1 £0 £0 £0 £0 £0 £0







Payments for Year 2
£0 £0 £0 £0 £0






Year of Delivery Payments for Year 3

£0 £0 £0 £0 £0






Payments for Year 4


£0 £0 £0 £0






Payments for Year 5



£0 £0 £0 £0





Payments for Year 6




£0 £0 £0 £0




Payments for Year 7





£0 £0 £0 £0



2017/18: Total Payments





£0









£0 £0 £0 £0 £0 £0






Total Payments (2017/18)












Year 1
£0












Year 2
£0












Year 3
£0












Year 4
£0












Year 5
£0












Year 6
£0












Year 7
£0












Total Payment:
£0



























Data sources:













1. Net additional dwellings are calculated by subtracting effective stock (total stock less long-term empty homes, and demolitions) as recorded on the CTB in one year from the previous year: See 'Calculating the New Homes Bonus' in the first page of this spreadsheet



2. Data taken from the Council Tax Base form: https://www.gov.uk/government/statistics/council-taxbase-2016-in-england













3. Data taken from Live Table 1008 - Affordable housing supply in England: 2015 to 2016: (https://www.gov.uk/government/statistical-data-sets/live-tables-on-affordable-housing-supply)



























































































































































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet new homes bonus calculator step please select the method you wish to use view payments a local authority or county from dropdown list department for communities and government newhomesbonus communitiesgsigovuk calculating cumulative current year only illustrative by band nhb return homepage calculation process worked example council tax total b c d e f g h i weighting equivalence ii previous dwelling stock iii hellip in equivalents x iv growth v vi national average rate pound vii baseline of equivalent viii units rewarded ix payment affordable xi xii annual above shows hypothetical outcome following housing evenly split across bands there is level below which are not with paid thereafter practice calculated dclg taxbase ctb statistics effective ie after accounting demolished long term empty property line minus on form subtracted latest reform no your counties at bottom oct net change supply delivery data sources additional dwellings subtracting less longterm demolitions as record...

no reviews yet
Please Login to review.