Woningwaarde berekenen met prijsontwikkeling

Formulas:

• h_a = if(jaar_bekend < 1995, 1995, if(jaar_bekend > 2026, 2026, ceil(jaar_bekend - 0.9999)))
  
• h_b = if(jaar_doel < 1995, 1995, if(jaar_doel > 2026, 2026, ceil(jaar_doel - 0.9999)))
  
• h_nla = if(h_a<=1995,29.6,if(h_a<=1996,32.6,if(h_a<=1997,36.3,if(h_a<=1998,40.1,if(h_a<=1999,46.5,if(h_a<=2000,54.8,if(h_a<=2001,60.9,if(h_a<=2002,64.7,if(h_a<=2003,67.1,if(h_a<=2004,69.9,if(h_a<=2005,72.6,if(h_a<=2006,75.9,if(h_a<=2007,79.2,if(h_a<=2008,81.7,if(h_a<=2009,79.1,if(h_a<=2010,77.5,if(h_a<=2011,75.7,if(h_a<=2012,71,if(h_a<=2013,66.5,if(h_a<=2014,67.3,if(h_a<=2015,69.5,if(h_a<=2016,73.3,if(h_a<=2017,79.3,if(h_a<=2018,86.6,if(h_a<=2019,92.7,if(h_a<=2020,100,if(h_a<=2021,115.1,if(h_a<=2022,130.4,if(h_a<=2023,126.6,if(h_a<=2024,137.7,if(h_a<=2025,149.5,154.9)))))))))))))))))))))))))))))))
  
• h_nlb = if(h_b<=1995,29.6,if(h_b<=1996,32.6,if(h_b<=1997,36.3,if(h_b<=1998,40.1,if(h_b<=1999,46.5,if(h_b<=2000,54.8,if(h_b<=2001,60.9,if(h_b<=2002,64.7,if(h_b<=2003,67.1,if(h_b<=2004,69.9,if(h_b<=2005,72.6,if(h_b<=2006,75.9,if(h_b<=2007,79.2,if(h_b<=2008,81.7,if(h_b<=2009,79.1,if(h_b<=2010,77.5,if(h_b<=2011,75.7,if(h_b<=2012,71,if(h_b<=2013,66.5,if(h_b<=2014,67.3,if(h_b<=2015,69.5,if(h_b<=2016,73.3,if(h_b<=2017,79.3,if(h_b<=2018,86.6,if(h_b<=2019,92.7,if(h_b<=2020,100,if(h_b<=2021,115.1,if(h_b<=2022,130.4,if(h_b<=2023,126.6,if(h_b<=2024,137.7,if(h_b<=2025,149.5,154.9)))))))))))))))))))))))))))))))
  
• h_gra = if(h_a<=1995,30.8,if(h_a<=1996,33.6,if(h_a<=1997,36.2,if(h_a<=1998,38.8,if(h_a<=1999,43,if(h_a<=2000,50,if(h_a<=2001,57.3,if(h_a<=2002,62.7,if(h_a<=2003,66.3,if(h_a<=2004,70,if(h_a<=2005,75.8,if(h_a<=2006,80.3,if(h_a<=2007,82.8,if(h_a<=2008,84.7,if(h_a<=2009,81.1,if(h_a<=2010,80.5,if(h_a<=2011,78.4,if(h_a<=2012,73.4,if(h_a<=2013,69.6,if(h_a<=2014,69.3,if(h_a<=2015,71.2,if(h_a<=2016,74.5,if(h_a<=2017,79.2,if(h_a<=2018,84.8,if(h_a<=2019,90.6,if(h_a<=2020,100,if(h_a<=2021,117.3,if(h_a<=2022,134.6,if(h_a<=2023,131.6,if(h_a<=2024,144.3,if(h_a<=2025,160,169.9)))))))))))))))))))))))))))))))
  
• h_grb = if(h_b<=1995,30.8,if(h_b<=1996,33.6,if(h_b<=1997,36.2,if(h_b<=1998,38.8,if(h_b<=1999,43,if(h_b<=2000,50,if(h_b<=2001,57.3,if(h_b<=2002,62.7,if(h_b<=2003,66.3,if(h_b<=2004,70,if(h_b<=2005,75.8,if(h_b<=2006,80.3,if(h_b<=2007,82.8,if(h_b<=2008,84.7,if(h_b<=2009,81.1,if(h_b<=2010,80.5,if(h_b<=2011,78.4,if(h_b<=2012,73.4,if(h_b<=2013,69.6,if(h_b<=2014,69.3,if(h_b<=2015,71.2,if(h_b<=2016,74.5,if(h_b<=2017,79.2,if(h_b<=2018,84.8,if(h_b<=2019,90.6,if(h_b<=2020,100,if(h_b<=2021,117.3,if(h_b<=2022,134.6,if(h_b<=2023,131.6,if(h_b<=2024,144.3,if(h_b<=2025,160,169.9)))))))))))))))))))))))))))))))
  
• h_fra = if(h_a<=1995,32.3,if(h_a<=1996,35.3,if(h_a<=1997,38.5,if(h_a<=1998,42.4,if(h_a<=1999,47.7,if(h_a<=2000,56.7,if(h_a<=2001,64.3,if(h_a<=2002,68.5,if(h_a<=2003,73,if(h_a<=2004,77.4,if(h_a<=2005,81.3,if(h_a<=2006,85.7,if(h_a<=2007,88.7,if(h_a<=2008,90.8,if(h_a<=2009,86.9,if(h_a<=2010,86.6,if(h_a<=2011,83.1,if(h_a<=2012,77.7,if(h_a<=2013,72.5,if(h_a<=2014,71.7,if(h_a<=2015,73.1,if(h_a<=2016,75.9,if(h_a<=2017,80.5,if(h_a<=2018,86.6,if(h_a<=2019,92.9,if(h_a<=2020,100,if(h_a<=2021,116.8,if(h_a<=2022,133.2,if(h_a<=2023,129.7,if(h_a<=2024,141,if(h_a<=2025,153.9,161.1)))))))))))))))))))))))))))))))
  
• h_frb = if(h_b<=1995,32.3,if(h_b<=1996,35.3,if(h_b<=1997,38.5,if(h_b<=1998,42.4,if(h_b<=1999,47.7,if(h_b<=2000,56.7,if(h_b<=2001,64.3,if(h_b<=2002,68.5,if(h_b<=2003,73,if(h_b<=2004,77.4,if(h_b<=2005,81.3,if(h_b<=2006,85.7,if(h_b<=2007,88.7,if(h_b<=2008,90.8,if(h_b<=2009,86.9,if(h_b<=2010,86.6,if(h_b<=2011,83.1,if(h_b<=2012,77.7,if(h_b<=2013,72.5,if(h_b<=2014,71.7,if(h_b<=2015,73.1,if(h_b<=2016,75.9,if(h_b<=2017,80.5,if(h_b<=2018,86.6,if(h_b<=2019,92.9,if(h_b<=2020,100,if(h_b<=2021,116.8,if(h_b<=2022,133.2,if(h_b<=2023,129.7,if(h_b<=2024,141,if(h_b<=2025,153.9,161.1)))))))))))))))))))))))))))))))
  
• h_dra = if(h_a<=1995,33.7,if(h_a<=1996,37,if(h_a<=1997,40.4,if(h_a<=1998,44,if(h_a<=1999,50.4,if(h_a<=2000,59.8,if(h_a<=2001,66.7,if(h_a<=2002,70.4,if(h_a<=2003,73.5,if(h_a<=2004,76.8,if(h_a<=2005,80.2,if(h_a<=2006,84,if(h_a<=2007,87.7,if(h_a<=2008,89.3,if(h_a<=2009,87,if(h_a<=2010,85.6,if(h_a<=2011,83.2,if(h_a<=2012,78.5,if(h_a<=2013,73.2,if(h_a<=2014,73,if(h_a<=2015,74.1,if(h_a<=2016,75.8,if(h_a<=2017,79.9,if(h_a<=2018,85.3,if(h_a<=2019,92.1,if(h_a<=2020,100,if(h_a<=2021,118.2,if(h_a<=2022,135.4,if(h_a<=2023,132.4,if(h_a<=2024,145.5,if(h_a<=2025,161.7,170.8)))))))))))))))))))))))))))))))
  
• h_drb = if(h_b<=1995,33.7,if(h_b<=1996,37,if(h_b<=1997,40.4,if(h_b<=1998,44,if(h_b<=1999,50.4,if(h_b<=2000,59.8,if(h_b<=2001,66.7,if(h_b<=2002,70.4,if(h_b<=2003,73.5,if(h_b<=2004,76.8,if(h_b<=2005,80.2,if(h_b<=2006,84,if(h_b<=2007,87.7,if(h_b<=2008,89.3,if(h_b<=2009,87,if(h_b<=2010,85.6,if(h_b<=2011,83.2,if(h_b<=2012,78.5,if(h_b<=2013,73.2,if(h_b<=2014,73,if(h_b<=2015,74.1,if(h_b<=2016,75.8,if(h_b<=2017,79.9,if(h_b<=2018,85.3,if(h_b<=2019,92.1,if(h_b<=2020,100,if(h_b<=2021,118.2,if(h_b<=2022,135.4,if(h_b<=2023,132.4,if(h_b<=2024,145.5,if(h_b<=2025,161.7,170.8)))))))))))))))))))))))))))))))
  
• h_ova = if(h_a<=1995,33,if(h_a<=1996,36.4,if(h_a<=1997,40.2,if(h_a<=1998,43.9,if(h_a<=1999,50.1,if(h_a<=2000,59.5,if(h_a<=2001,66.6,if(h_a<=2002,71,if(h_a<=2003,73.5,if(h_a<=2004,76.7,if(h_a<=2005,79.4,if(h_a<=2006,82.6,if(h_a<=2007,84.4,if(h_a<=2008,86.2,if(h_a<=2009,83.9,if(h_a<=2010,82.6,if(h_a<=2011,80.4,if(h_a<=2012,76.4,if(h_a<=2013,71.8,if(h_a<=2014,72.4,if(h_a<=2015,73.2,if(h_a<=2016,76,if(h_a<=2017,80.4,if(h_a<=2018,86.4,if(h_a<=2019,92.1,if(h_a<=2020,100,if(h_a<=2021,115.4,if(h_a<=2022,131.3,if(h_a<=2023,129.7,if(h_a<=2024,140.9,if(h_a<=2025,155,160.7)))))))))))))))))))))))))))))))
  
• h_ovb = if(h_b<=1995,33,if(h_b<=1996,36.4,if(h_b<=1997,40.2,if(h_b<=1998,43.9,if(h_b<=1999,50.1,if(h_b<=2000,59.5,if(h_b<=2001,66.6,if(h_b<=2002,71,if(h_b<=2003,73.5,if(h_b<=2004,76.7,if(h_b<=2005,79.4,if(h_b<=2006,82.6,if(h_b<=2007,84.4,if(h_b<=2008,86.2,if(h_b<=2009,83.9,if(h_b<=2010,82.6,if(h_b<=2011,80.4,if(h_b<=2012,76.4,if(h_b<=2013,71.8,if(h_b<=2014,72.4,if(h_b<=2015,73.2,if(h_b<=2016,76,if(h_b<=2017,80.4,if(h_b<=2018,86.4,if(h_b<=2019,92.1,if(h_b<=2020,100,if(h_b<=2021,115.4,if(h_b<=2022,131.3,if(h_b<=2023,129.7,if(h_b<=2024,140.9,if(h_b<=2025,155,160.7)))))))))))))))))))))))))))))))
  
• h_fla = if(h_a<=1995,33.3,if(h_a<=1996,35.8,if(h_a<=1997,38.3,if(h_a<=1998,41.1,if(h_a<=1999,49.4,if(h_a<=2000,58.3,if(h_a<=2001,63.8,if(h_a<=2002,68.1,if(h_a<=2003,70.6,if(h_a<=2004,71.7,if(h_a<=2005,73.5,if(h_a<=2006,75.1,if(h_a<=2007,76.9,if(h_a<=2008,77.8,if(h_a<=2009,75.4,if(h_a<=2010,73.4,if(h_a<=2011,71.3,if(h_a<=2012,67.8,if(h_a<=2013,64.5,if(h_a<=2014,65,if(h_a<=2015,65.8,if(h_a<=2016,68.9,if(h_a<=2017,74.9,if(h_a<=2018,83.4,if(h_a<=2019,91,if(h_a<=2020,100,if(h_a<=2021,118.9,if(h_a<=2022,137.3,if(h_a<=2023,133.1,if(h_a<=2024,146,if(h_a<=2025,157.5,161.5)))))))))))))))))))))))))))))))
  
• h_flb = if(h_b<=1995,33.3,if(h_b<=1996,35.8,if(h_b<=1997,38.3,if(h_b<=1998,41.1,if(h_b<=1999,49.4,if(h_b<=2000,58.3,if(h_b<=2001,63.8,if(h_b<=2002,68.1,if(h_b<=2003,70.6,if(h_b<=2004,71.7,if(h_b<=2005,73.5,if(h_b<=2006,75.1,if(h_b<=2007,76.9,if(h_b<=2008,77.8,if(h_b<=2009,75.4,if(h_b<=2010,73.4,if(h_b<=2011,71.3,if(h_b<=2012,67.8,if(h_b<=2013,64.5,if(h_b<=2014,65,if(h_b<=2015,65.8,if(h_b<=2016,68.9,if(h_b<=2017,74.9,if(h_b<=2018,83.4,if(h_b<=2019,91,if(h_b<=2020,100,if(h_b<=2021,118.9,if(h_b<=2022,137.3,if(h_b<=2023,133.1,if(h_b<=2024,146,if(h_b<=2025,157.5,161.5)))))))))))))))))))))))))))))))
  
• h_gea = if(h_a<=1995,32.1,if(h_a<=1996,35.6,if(h_a<=1997,39.8,if(h_a<=1998,44.4,if(h_a<=1999,52.4,if(h_a<=2000,62.1,if(h_a<=2001,68.8,if(h_a<=2002,73,if(h_a<=2003,75.3,if(h_a<=2004,78.7,if(h_a<=2005,80.8,if(h_a<=2006,84.3,if(h_a<=2007,87.6,if(h_a<=2008,89.4,if(h_a<=2009,86,if(h_a<=2010,84.2,if(h_a<=2011,81.7,if(h_a<=2012,76.1,if(h_a<=2013,70.8,if(h_a<=2014,70.7,if(h_a<=2015,72.1,if(h_a<=2016,74.8,if(h_a<=2017,79.7,if(h_a<=2018,86.5,if(h_a<=2019,92.3,if(h_a<=2020,100,if(h_a<=2021,117,if(h_a<=2022,134.7,if(h_a<=2023,131.1,if(h_a<=2024,142.4,if(h_a<=2025,156.7,164.4)))))))))))))))))))))))))))))))
  
• h_geb = if(h_b<=1995,32.1,if(h_b<=1996,35.6,if(h_b<=1997,39.8,if(h_b<=1998,44.4,if(h_b<=1999,52.4,if(h_b<=2000,62.1,if(h_b<=2001,68.8,if(h_b<=2002,73,if(h_b<=2003,75.3,if(h_b<=2004,78.7,if(h_b<=2005,80.8,if(h_b<=2006,84.3,if(h_b<=2007,87.6,if(h_b<=2008,89.4,if(h_b<=2009,86,if(h_b<=2010,84.2,if(h_b<=2011,81.7,if(h_b<=2012,76.1,if(h_b<=2013,70.8,if(h_b<=2014,70.7,if(h_b<=2015,72.1,if(h_b<=2016,74.8,if(h_b<=2017,79.7,if(h_b<=2018,86.5,if(h_b<=2019,92.3,if(h_b<=2020,100,if(h_b<=2021,117,if(h_b<=2022,134.7,if(h_b<=2023,131.1,if(h_b<=2024,142.4,if(h_b<=2025,156.7,164.4)))))))))))))))))))))))))))))))
  
• h_uta = if(h_a<=1995,28.3,if(h_a<=1996,31,if(h_a<=1997,34.9,if(h_a<=1998,39,if(h_a<=1999,45.1,if(h_a<=2000,53.1,if(h_a<=2001,57.2,if(h_a<=2002,59.9,if(h_a<=2003,62,if(h_a<=2004,64.9,if(h_a<=2005,68.1,if(h_a<=2006,71.5,if(h_a<=2007,75.9,if(h_a<=2008,79.3,if(h_a<=2009,77.1,if(h_a<=2010,75.3,if(h_a<=2011,73.7,if(h_a<=2012,68.9,if(h_a<=2013,64.4,if(h_a<=2014,65.4,if(h_a<=2015,68,if(h_a<=2016,72.5,if(h_a<=2017,79.3,if(h_a<=2018,86.5,if(h_a<=2019,92.6,if(h_a<=2020,100,if(h_a<=2021,115.6,if(h_a<=2022,131,if(h_a<=2023,124.5,if(h_a<=2024,139,if(h_a<=2025,152.4,157)))))))))))))))))))))))))))))))
  
• h_utb = if(h_b<=1995,28.3,if(h_b<=1996,31,if(h_b<=1997,34.9,if(h_b<=1998,39,if(h_b<=1999,45.1,if(h_b<=2000,53.1,if(h_b<=2001,57.2,if(h_b<=2002,59.9,if(h_b<=2003,62,if(h_b<=2004,64.9,if(h_b<=2005,68.1,if(h_b<=2006,71.5,if(h_b<=2007,75.9,if(h_b<=2008,79.3,if(h_b<=2009,77.1,if(h_b<=2010,75.3,if(h_b<=2011,73.7,if(h_b<=2012,68.9,if(h_b<=2013,64.4,if(h_b<=2014,65.4,if(h_b<=2015,68,if(h_b<=2016,72.5,if(h_b<=2017,79.3,if(h_b<=2018,86.5,if(h_b<=2019,92.6,if(h_b<=2020,100,if(h_b<=2021,115.6,if(h_b<=2022,131,if(h_b<=2023,124.5,if(h_b<=2024,139,if(h_b<=2025,152.4,157)))))))))))))))))))))))))))))))
  
• h_nha = if(h_a<=1995,24.6,if(h_a<=1996,27.2,if(h_a<=1997,30.6,if(h_a<=1998,34.4,if(h_a<=1999,41.3,if(h_a<=2000,49.2,if(h_a<=2001,54.8,if(h_a<=2002,57.3,if(h_a<=2003,57.9,if(h_a<=2004,59.9,if(h_a<=2005,62.3,if(h_a<=2006,65.7,if(h_a<=2007,70.2,if(h_a<=2008,73.9,if(h_a<=2009,71.3,if(h_a<=2010,69.8,if(h_a<=2011,68.8,if(h_a<=2012,64.4,if(h_a<=2013,60.2,if(h_a<=2014,62.1,if(h_a<=2015,65.7,if(h_a<=2016,71.3,if(h_a<=2017,79.2,if(h_a<=2018,88,if(h_a<=2019,94,if(h_a<=2020,100,if(h_a<=2021,114.4,if(h_a<=2022,128.6,if(h_a<=2023,122.5,if(h_a<=2024,132.6,if(h_a<=2025,140.8,143.7)))))))))))))))))))))))))))))))
  
• h_nhb = if(h_b<=1995,24.6,if(h_b<=1996,27.2,if(h_b<=1997,30.6,if(h_b<=1998,34.4,if(h_b<=1999,41.3,if(h_b<=2000,49.2,if(h_b<=2001,54.8,if(h_b<=2002,57.3,if(h_b<=2003,57.9,if(h_b<=2004,59.9,if(h_b<=2005,62.3,if(h_b<=2006,65.7,if(h_b<=2007,70.2,if(h_b<=2008,73.9,if(h_b<=2009,71.3,if(h_b<=2010,69.8,if(h_b<=2011,68.8,if(h_b<=2012,64.4,if(h_b<=2013,60.2,if(h_b<=2014,62.1,if(h_b<=2015,65.7,if(h_b<=2016,71.3,if(h_b<=2017,79.2,if(h_b<=2018,88,if(h_b<=2019,94,if(h_b<=2020,100,if(h_b<=2021,114.4,if(h_b<=2022,128.6,if(h_b<=2023,122.5,if(h_b<=2024,132.6,if(h_b<=2025,140.8,143.7)))))))))))))))))))))))))))))))
  
• h_zha = if(h_a<=1995,29.2,if(h_a<=1996,31.7,if(h_a<=1997,35.3,if(h_a<=1998,38.6,if(h_a<=1999,44.2,if(h_a<=2000,51.7,if(h_a<=2001,58,if(h_a<=2002,62.2,if(h_a<=2003,65.5,if(h_a<=2004,68.2,if(h_a<=2005,70.8,if(h_a<=2006,73.5,if(h_a<=2007,76,if(h_a<=2008,78.2,if(h_a<=2009,75.8,if(h_a<=2010,74.4,if(h_a<=2011,73,if(h_a<=2012,68.5,if(h_a<=2013,64.5,if(h_a<=2014,65.2,if(h_a<=2015,67.2,if(h_a<=2016,70.8,if(h_a<=2017,77.1,if(h_a<=2018,85.8,if(h_a<=2019,92.3,if(h_a<=2020,100,if(h_a<=2021,113.9,if(h_a<=2022,128.5,if(h_a<=2023,125.4,if(h_a<=2024,135.5,if(h_a<=2025,147.1,152.7)))))))))))))))))))))))))))))))
  
• h_zhb = if(h_b<=1995,29.2,if(h_b<=1996,31.7,if(h_b<=1997,35.3,if(h_b<=1998,38.6,if(h_b<=1999,44.2,if(h_b<=2000,51.7,if(h_b<=2001,58,if(h_b<=2002,62.2,if(h_b<=2003,65.5,if(h_b<=2004,68.2,if(h_b<=2005,70.8,if(h_b<=2006,73.5,if(h_b<=2007,76,if(h_b<=2008,78.2,if(h_b<=2009,75.8,if(h_b<=2010,74.4,if(h_b<=2011,73,if(h_b<=2012,68.5,if(h_b<=2013,64.5,if(h_b<=2014,65.2,if(h_b<=2015,67.2,if(h_b<=2016,70.8,if(h_b<=2017,77.1,if(h_b<=2018,85.8,if(h_b<=2019,92.3,if(h_b<=2020,100,if(h_b<=2021,113.9,if(h_b<=2022,128.5,if(h_b<=2023,125.4,if(h_b<=2024,135.5,if(h_b<=2025,147.1,152.7)))))))))))))))))))))))))))))))
  
• h_zea = if(h_a<=1995,32.2,if(h_a<=1996,35.3,if(h_a<=1997,38.2,if(h_a<=1998,40.8,if(h_a<=1999,45.8,if(h_a<=2000,52.9,if(h_a<=2001,59.5,if(h_a<=2002,66,if(h_a<=2003,70.2,if(h_a<=2004,75.6,if(h_a<=2005,79.7,if(h_a<=2006,83.9,if(h_a<=2007,85.8,if(h_a<=2008,87.6,if(h_a<=2009,86.2,if(h_a<=2010,84.5,if(h_a<=2011,83.5,if(h_a<=2012,79.4,if(h_a<=2013,77.2,if(h_a<=2014,76.7,if(h_a<=2015,77.2,if(h_a<=2016,79.2,if(h_a<=2017,81.5,if(h_a<=2018,85.7,if(h_a<=2019,92.3,if(h_a<=2020,100,if(h_a<=2021,115.5,if(h_a<=2022,130.7,if(h_a<=2023,129.7,if(h_a<=2024,136.5,if(h_a<=2025,146,150)))))))))))))))))))))))))))))))
  
• h_zeb = if(h_b<=1995,32.2,if(h_b<=1996,35.3,if(h_b<=1997,38.2,if(h_b<=1998,40.8,if(h_b<=1999,45.8,if(h_b<=2000,52.9,if(h_b<=2001,59.5,if(h_b<=2002,66,if(h_b<=2003,70.2,if(h_b<=2004,75.6,if(h_b<=2005,79.7,if(h_b<=2006,83.9,if(h_b<=2007,85.8,if(h_b<=2008,87.6,if(h_b<=2009,86.2,if(h_b<=2010,84.5,if(h_b<=2011,83.5,if(h_b<=2012,79.4,if(h_b<=2013,77.2,if(h_b<=2014,76.7,if(h_b<=2015,77.2,if(h_b<=2016,79.2,if(h_b<=2017,81.5,if(h_b<=2018,85.7,if(h_b<=2019,92.3,if(h_b<=2020,100,if(h_b<=2021,115.5,if(h_b<=2022,130.7,if(h_b<=2023,129.7,if(h_b<=2024,136.5,if(h_b<=2025,146,150)))))))))))))))))))))))))))))))
  
• h_nba = if(h_a<=1995,31.2,if(h_a<=1996,34.8,if(h_a<=1997,39.2,if(h_a<=1998,43.4,if(h_a<=1999,50,if(h_a<=2000,59.2,if(h_a<=2001,66.5,if(h_a<=2002,71.1,if(h_a<=2003,74.1,if(h_a<=2004,77.1,if(h_a<=2005,80,if(h_a<=2006,83.6,if(h_a<=2007,87,if(h_a<=2008,89.3,if(h_a<=2009,86.4,if(h_a<=2010,84.4,if(h_a<=2011,81.8,if(h_a<=2012,76.2,if(h_a<=2013,70.9,if(h_a<=2014,71.3,if(h_a<=2015,73.1,if(h_a<=2016,76.1,if(h_a<=2017,80.9,if(h_a<=2018,87.3,if(h_a<=2019,92.8,if(h_a<=2020,100,if(h_a<=2021,114,if(h_a<=2022,129.4,if(h_a<=2023,127.3,if(h_a<=2024,138.5,if(h_a<=2025,151.4,157.3)))))))))))))))))))))))))))))))
  
• h_nbb = if(h_b<=1995,31.2,if(h_b<=1996,34.8,if(h_b<=1997,39.2,if(h_b<=1998,43.4,if(h_b<=1999,50,if(h_b<=2000,59.2,if(h_b<=2001,66.5,if(h_b<=2002,71.1,if(h_b<=2003,74.1,if(h_b<=2004,77.1,if(h_b<=2005,80,if(h_b<=2006,83.6,if(h_b<=2007,87,if(h_b<=2008,89.3,if(h_b<=2009,86.4,if(h_b<=2010,84.4,if(h_b<=2011,81.8,if(h_b<=2012,76.2,if(h_b<=2013,70.9,if(h_b<=2014,71.3,if(h_b<=2015,73.1,if(h_b<=2016,76.1,if(h_b<=2017,80.9,if(h_b<=2018,87.3,if(h_b<=2019,92.8,if(h_b<=2020,100,if(h_b<=2021,114,if(h_b<=2022,129.4,if(h_b<=2023,127.3,if(h_b<=2024,138.5,if(h_b<=2025,151.4,157.3)))))))))))))))))))))))))))))))
  
• h_lia = if(h_a<=1995,39.2,if(h_a<=1996,43.1,if(h_a<=1997,48.2,if(h_a<=1998,52.9,if(h_a<=1999,60.4,if(h_a<=2000,68.5,if(h_a<=2001,72.5,if(h_a<=2002,76.1,if(h_a<=2003,77.7,if(h_a<=2004,80.7,if(h_a<=2005,82.5,if(h_a<=2006,85.1,if(h_a<=2007,87.1,if(h_a<=2008,88.2,if(h_a<=2009,84.5,if(h_a<=2010,82.6,if(h_a<=2011,80.8,if(h_a<=2012,76,if(h_a<=2013,71.6,if(h_a<=2014,72.4,if(h_a<=2015,73.7,if(h_a<=2016,76.6,if(h_a<=2017,80.5,if(h_a<=2018,86.5,if(h_a<=2019,92.6,if(h_a<=2020,100,if(h_a<=2021,113.5,if(h_a<=2022,127,if(h_a<=2023,126.1,if(h_a<=2024,136.6,if(h_a<=2025,148.3,154)))))))))))))))))))))))))))))))
  
• h_lib = if(h_b<=1995,39.2,if(h_b<=1996,43.1,if(h_b<=1997,48.2,if(h_b<=1998,52.9,if(h_b<=1999,60.4,if(h_b<=2000,68.5,if(h_b<=2001,72.5,if(h_b<=2002,76.1,if(h_b<=2003,77.7,if(h_b<=2004,80.7,if(h_b<=2005,82.5,if(h_b<=2006,85.1,if(h_b<=2007,87.1,if(h_b<=2008,88.2,if(h_b<=2009,84.5,if(h_b<=2010,82.6,if(h_b<=2011,80.8,if(h_b<=2012,76,if(h_b<=2013,71.6,if(h_b<=2014,72.4,if(h_b<=2015,73.7,if(h_b<=2016,76.6,if(h_b<=2017,80.5,if(h_b<=2018,86.5,if(h_b<=2019,92.6,if(h_b<=2020,100,if(h_b<=2021,113.5,if(h_b<=2022,127,if(h_b<=2023,126.1,if(h_b<=2024,136.6,if(h_b<=2025,148.3,154)))))))))))))))))))))))))))))))
  
• h_amsa = if(h_a<=1995,19.3,if(h_a<=1996,20.8,if(h_a<=1997,23.8,if(h_a<=1998,27.8,if(h_a<=1999,34.6,if(h_a<=2000,41.6,if(h_a<=2001,47.3,if(h_a<=2002,48.2,if(h_a<=2003,46.8,if(h_a<=2004,47.3,if(h_a<=2005,49.5,if(h_a<=2006,53.7,if(h_a<=2007,59.9,if(h_a<=2008,64.2,if(h_a<=2009,60.5,if(h_a<=2010,60.2,if(h_a<=2011,60,if(h_a<=2012,56.6,if(h_a<=2013,53.6,if(h_a<=2014,56.4,if(h_a<=2015,61.9,if(h_a<=2016,70.2,if(h_a<=2017,80.1,if(h_a<=2018,90.3,if(h_a<=2019,95.5,if(h_a<=2020,100,if(h_a<=2021,111.5,if(h_a<=2022,123.8,if(h_a<=2023,117.6,if(h_a<=2024,127.9,if(h_a<=2025,132.4,133.5)))))))))))))))))))))))))))))))
  
• h_amsb = if(h_b<=1995,19.3,if(h_b<=1996,20.8,if(h_b<=1997,23.8,if(h_b<=1998,27.8,if(h_b<=1999,34.6,if(h_b<=2000,41.6,if(h_b<=2001,47.3,if(h_b<=2002,48.2,if(h_b<=2003,46.8,if(h_b<=2004,47.3,if(h_b<=2005,49.5,if(h_b<=2006,53.7,if(h_b<=2007,59.9,if(h_b<=2008,64.2,if(h_b<=2009,60.5,if(h_b<=2010,60.2,if(h_b<=2011,60,if(h_b<=2012,56.6,if(h_b<=2013,53.6,if(h_b<=2014,56.4,if(h_b<=2015,61.9,if(h_b<=2016,70.2,if(h_b<=2017,80.1,if(h_b<=2018,90.3,if(h_b<=2019,95.5,if(h_b<=2020,100,if(h_b<=2021,111.5,if(h_b<=2022,123.8,if(h_b<=2023,117.6,if(h_b<=2024,127.9,if(h_b<=2025,132.4,133.5)))))))))))))))))))))))))))))))
  
• h_dha = if(h_a<=1995,25.5,if(h_a<=1996,27.3,if(h_a<=1997,30.2,if(h_a<=1998,33.5,if(h_a<=1999,37.9,if(h_a<=2000,45.3,if(h_a<=2001,52.1,if(h_a<=2002,56.2,if(h_a<=2003,59.1,if(h_a<=2004,61.9,if(h_a<=2005,64.5,if(h_a<=2006,67.5,if(h_a<=2007,70.6,if(h_a<=2008,73.2,if(h_a<=2009,71.1,if(h_a<=2010,70.1,if(h_a<=2011,68.9,if(h_a<=2012,64.2,if(h_a<=2013,59.7,if(h_a<=2014,61.2,if(h_a<=2015,63.7,if(h_a<=2016,68.9,if(h_a<=2017,76.6,if(h_a<=2018,86.2,if(h_a<=2019,93,if(h_a<=2020,100,if(h_a<=2021,114.5,if(h_a<=2022,127.1,if(h_a<=2023,122.4,if(h_a<=2024,131.2,if(h_a<=2025,141.4,146.9)))))))))))))))))))))))))))))))
  
• h_dhb = if(h_b<=1995,25.5,if(h_b<=1996,27.3,if(h_b<=1997,30.2,if(h_b<=1998,33.5,if(h_b<=1999,37.9,if(h_b<=2000,45.3,if(h_b<=2001,52.1,if(h_b<=2002,56.2,if(h_b<=2003,59.1,if(h_b<=2004,61.9,if(h_b<=2005,64.5,if(h_b<=2006,67.5,if(h_b<=2007,70.6,if(h_b<=2008,73.2,if(h_b<=2009,71.1,if(h_b<=2010,70.1,if(h_b<=2011,68.9,if(h_b<=2012,64.2,if(h_b<=2013,59.7,if(h_b<=2014,61.2,if(h_b<=2015,63.7,if(h_b<=2016,68.9,if(h_b<=2017,76.6,if(h_b<=2018,86.2,if(h_b<=2019,93,if(h_b<=2020,100,if(h_b<=2021,114.5,if(h_b<=2022,127.1,if(h_b<=2023,122.4,if(h_b<=2024,131.2,if(h_b<=2025,141.4,146.9)))))))))))))))))))))))))))))))
  
• h_rdama = if(h_a<=1995,24.2,if(h_a<=1996,26.7,if(h_a<=1997,29.8,if(h_a<=1998,32.5,if(h_a<=1999,37.2,if(h_a<=2000,43.6,if(h_a<=2001,49.2,if(h_a<=2002,53.5,if(h_a<=2003,56.3,if(h_a<=2004,58.3,if(h_a<=2005,60.6,if(h_a<=2006,62.8,if(h_a<=2007,64.9,if(h_a<=2008,66.7,if(h_a<=2009,65.5,if(h_a<=2010,65,if(h_a<=2011,64.6,if(h_a<=2012,61.4,if(h_a<=2013,58,if(h_a<=2014,58.9,if(h_a<=2015,61.5,if(h_a<=2016,65.9,if(h_a<=2017,74.4,if(h_a<=2018,85.2,if(h_a<=2019,92.2,if(h_a<=2020,100,if(h_a<=2021,114,if(h_a<=2022,128,if(h_a<=2023,124.5,if(h_a<=2024,132.5,if(h_a<=2025,142.1,146.2)))))))))))))))))))))))))))))))
  
• h_rdamb = if(h_b<=1995,24.2,if(h_b<=1996,26.7,if(h_b<=1997,29.8,if(h_b<=1998,32.5,if(h_b<=1999,37.2,if(h_b<=2000,43.6,if(h_b<=2001,49.2,if(h_b<=2002,53.5,if(h_b<=2003,56.3,if(h_b<=2004,58.3,if(h_b<=2005,60.6,if(h_b<=2006,62.8,if(h_b<=2007,64.9,if(h_b<=2008,66.7,if(h_b<=2009,65.5,if(h_b<=2010,65,if(h_b<=2011,64.6,if(h_b<=2012,61.4,if(h_b<=2013,58,if(h_b<=2014,58.9,if(h_b<=2015,61.5,if(h_b<=2016,65.9,if(h_b<=2017,74.4,if(h_b<=2018,85.2,if(h_b<=2019,92.2,if(h_b<=2020,100,if(h_b<=2021,114,if(h_b<=2022,128,if(h_b<=2023,124.5,if(h_b<=2024,132.5,if(h_b<=2025,142.1,146.2)))))))))))))))))))))))))))))))
  
• h_utra = if(h_a<=1995,20.6,if(h_a<=1996,22.8,if(h_a<=1997,26,if(h_a<=1998,29,if(h_a<=1999,35.6,if(h_a<=2000,40.3,if(h_a<=2001,43.3,if(h_a<=2002,45.2,if(h_a<=2003,47.4,if(h_a<=2004,50.4,if(h_a<=2005,54,if(h_a<=2006,57.3,if(h_a<=2007,62.2,if(h_a<=2008,66.2,if(h_a<=2009,64.5,if(h_a<=2010,63.2,if(h_a<=2011,63.3,if(h_a<=2012,59.3,if(h_a<=2013,56.1,if(h_a<=2014,57.4,if(h_a<=2015,61.2,if(h_a<=2016,67.2,if(h_a<=2017,75.3,if(h_a<=2018,83.7,if(h_a<=2019,91.4,if(h_a<=2020,100,if(h_a<=2021,116,if(h_a<=2022,128.8,if(h_a<=2023,119.8,if(h_a<=2024,138.1,if(h_a<=2025,151.1,154.2)))))))))))))))))))))))))))))))
  
• h_utrb = if(h_b<=1995,20.6,if(h_b<=1996,22.8,if(h_b<=1997,26,if(h_b<=1998,29,if(h_b<=1999,35.6,if(h_b<=2000,40.3,if(h_b<=2001,43.3,if(h_b<=2002,45.2,if(h_b<=2003,47.4,if(h_b<=2004,50.4,if(h_b<=2005,54,if(h_b<=2006,57.3,if(h_b<=2007,62.2,if(h_b<=2008,66.2,if(h_b<=2009,64.5,if(h_b<=2010,63.2,if(h_b<=2011,63.3,if(h_b<=2012,59.3,if(h_b<=2013,56.1,if(h_b<=2014,57.4,if(h_b<=2015,61.2,if(h_b<=2016,67.2,if(h_b<=2017,75.3,if(h_b<=2018,83.7,if(h_b<=2019,91.4,if(h_b<=2020,100,if(h_b<=2021,116,if(h_b<=2022,128.8,if(h_b<=2023,119.8,if(h_b<=2024,138.1,if(h_b<=2025,151.1,154.2)))))))))))))))))))))))))))))))
  
• idx_bekend = if(regio == 'gr', h_gra, if(regio == 'fr', h_fra, if(regio == 'dr', h_dra, if(regio == 'ov', h_ova, if(regio == 'fl', h_fla, if(regio == 'ge', h_gea, if(regio == 'ut', h_uta, if(regio == 'nh', h_nha, if(regio == 'zh', h_zha, if(regio == 'ze', h_zea, if(regio == 'nb', h_nba, if(regio == 'li', h_lia, if(regio == 'ams', h_amsa, if(regio == 'dh', h_dha, if(regio == 'rdam', h_rdama, if(regio == 'utr', h_utra, h_nla))))))))))))))))
  CBS/Kadaster prijsindex bestaande koopwoningen voor deze regio, 2020 = 100, jaargemiddelde.
• idx_doel = if(regio == 'gr', h_grb, if(regio == 'fr', h_frb, if(regio == 'dr', h_drb, if(regio == 'ov', h_ovb, if(regio == 'fl', h_flb, if(regio == 'ge', h_geb, if(regio == 'ut', h_utb, if(regio == 'nh', h_nhb, if(regio == 'zh', h_zhb, if(regio == 'ze', h_zeb, if(regio == 'nb', h_nbb, if(regio == 'li', h_lib, if(regio == 'ams', h_amsb, if(regio == 'dh', h_dhb, if(regio == 'rdam', h_rdamb, if(regio == 'utr', h_utrb, h_nlb))))))))))))))))
  Voor 2026 het 2e kwartaal van 2026.
• waarde = round(if(idx_bekend > 0, bedrag * idx_doel / idx_bekend, 0), 0)
  De bekende prijs maal de verhouding tussen de twee prijsindexen.
• verschil = round(waarde - bedrag, 0)
  
• perc = if(bedrag > 0 && idx_bekend > 0, round((idx_doel / idx_bekend - 1) * 100, 1), 0)
  
• perjaar = if(h_b != h_a && idx_bekend > 0, round((exp(ln(idx_doel / idx_bekend) / (h_b - h_a)) - 1) * 100, 1), 0)
  De gemiddelde jaarlijkse verandering, met rente-op-rente.
• overwaarde = round(if(hypotheek > 0, waarde - hypotheek, 0), 0)
  Geschatte waarde min je hypotheek. Negatief: je huis staat onder water.
• h_ow = if(hypotheek > 0, if(overwaarde >= 0, concat(' Met je hypotheek van ', concat('€ ', format(round(hypotheek,0), '0.#')), ' heb je ongeveer ', concat('€ ', format(round(overwaarde,0), '0.#')), ' overwaarde.'), concat(' Let op: je hypotheek is ', concat('€ ', format(round(0 - overwaarde,0), '0.#')), ' hoger dan de geschatte waarde.')), '')
  
• oordeel = if(bedrag <= 0, 'Vul een bekende prijs of waarde in.', concat('Indicatie: ', concat('€ ', format(round(bedrag,0), '0.#')), ' in ', format(h_a, '0.#'), ' is in ', format(h_b, '0.#'), ' ongeveer ', concat('€ ', format(round(waarde,0), '0.#')), ' (', format(perc, '0.0#'), '%).', h_ow, ' Dit is het gemiddelde voor je regio; jouw buurt en woning kunnen afwijken.'))
  
• volgende = if(hypotheek > 0 && overwaarde > 0, 'Bekijk wat je met je overwaarde kunt doen met Overwaarde berekenen en benutten 2026, of laat een taxatie doen voor een exacte waarde.', 'Vergelijk met de m²-prijs in je buurt via Vierkante meter prijs berekenen. Is je WOZ-waarde veel hoger? Check dan de WOZ-bezwaar zinvol-of-niet beslistool.')
  

Berekening informatie

Op jouw website?

<script src="https://ikbenbint.nl/widget.js"
  data-berekening="woningwaarde-berekenen-met-prijsontwikkeling">
</script>