Maximale huurprijs 2027 berekenen

Formulas:

• h_m2 = if(m2_vertrek > 0, round(m2_vertrek, 0), 0)
  
• h_m2o = if(m2_overig > 0, round(m2_overig, 0), 0)
  
• r1 = h_m2
  
• r2 = round((h_m2o * 0.75) * 4, 0) / 4
  
• r3 = if(verwarmd == 'ja', 2 * if(n_vertrek > 0, round(n_vertrek, 0), 0) + if(n_verkeer > 4, 4, if(n_verkeer > 0, round(n_verkeer, 0), 0)) + if(koeling > 2, 2, if(koeling > 0, round(koeling, 0), 0)), 0)
  
• h_lab = if(label != 'geen', label, if(bouwjaar >= 2002, 'a', if(bouwjaar >= 2000, 'b', if(bouwjaar >= 1992, 'c', if(bouwjaar >= 1984, 'd', if(bouwjaar >= 1979, 'e', if(bouwjaar >= 1977, 'f', 'g')))))))
  
• h_r4 = if(type == 'een', if(h_lab == 'app4', 62, if(h_lab == 'app3', 57, if(h_lab == 'app2', 52, if(h_lab == 'app1', 47, if(h_lab == 'a', 41, if(h_lab == 'b', 34, if(h_lab == 'c', 22, if(h_lab == 'd', 14, if(h_lab == 'e', -5, if(h_lab == 'f', -9, if(h_lab == 'g', -15, 0))))))))))), if(h_lab == 'app4', 58, if(h_lab == 'app3', 53, if(h_lab == 'app2', 48, if(h_lab == 'app1', 43, if(h_lab == 'a', 37, if(h_lab == 'b', 30, if(h_lab == 'c', 15, if(h_lab == 'd', 11, if(h_lab == 'e', -5, if(h_lab == 'f', -9, if(h_lab == 'g', -15, 0))))))))))))
  
• r4 = if(monument != 'geen' && h_r4 < 0, 0, h_r4)
  
• h_kx = if(keuken == 'eigen', if(keuken_pt > 0, keuken_pt, 0), if(keuken == 'k1', 2.25, if(keuken == 'k2', 4.75, if(keuken == 'k3', 8, 0))))
  
• r5 = round((if(aanrecht == 'a1', 4 + if(h_kx > 4, 4, h_kx), if(aanrecht == 'a2', 7 + if(h_kx > 7, 7, h_kx), 0))) * 4, 0) / 4
  
• h_dp = if(douche == 'd', 4, if(douche == 'bad', 6, if(douche == 'bd', 7, 0)))
  
• h_bx = if(badx == 'eigen', if(badx_pt > 0, badx_pt, 0), if(badx == 'b1', 3.75, 0))
  
• r6 = round((if(toilet == 'eigen', if(toilet_pt > 0, toilet_pt, 0), if(toilet == 't1', 3, if(toilet == 't1h', 3.75, if(toilet == 'tb', 2, if(toilet == 't2', 5, if(toilet == 't2a', 6, 0)))))) + if(wastafel > 0, round(wastafel, 0), 0) + h_dp + if(h_bx > h_dp, h_dp, h_bx)) * 4, 0) / 4
  
• h_b = if(buiten == 'prive', if(buiten_m2 > 0, 2 + 0.35 * buiten_m2, 0), if(buiten == 'gem' && buiten_m2 > 0 && buiten_adr > 0, 0.75 * buiten_m2 / buiten_adr, 0))
  
• r8 = round((if(buiten == 'geen', -5, if(h_b > 15, 15, h_b))) * 4, 0) / 4
  
• r8_27 = round((if(buiten == 'geen', 0, if(h_b > 15, 15, h_b))) * 4, 0) / 4
  
• h_rest = r1 + r2 + r3 + r4 + r5 + r6 + r8 + if(extra_pt > 0, extra_pt, 0) + if(monument == 'rijks_oud', 50, 0)
  
• h_rest27 = h_rest - r8 + r8_27
  
• h_w = if(woz > 85806, woz, 85806)
  
• h_mt = if(h_m2 + h_m2o > 0, h_m2 + h_m2o, 1)
  
• h_11a = if(h_mt <= 40 && bouwjaar >= 2018 && bouwjaar <= 2022 && regio == 'ja', 1, 0)
  
• h_d1 = if(wozjaar == 'p24', 15329, 16954)
  
• h_d2 = if(h_11a == 1, if(wozjaar == 'p24', 103, 114), if(wozjaar == 'p24', 242, 268))
  
• h_d2_27 = if(h_11a == 1, h_d2, if(h_mt <= 40 && (monument == 'rijks' || monument == 'rijks_oud'), 233, h_d2))
  
• h_wz = round((h_w / h_d1 + h_w / h_mt / h_d2) * 4, 0) / 4
  
• r11 = if(bouwjaar >= 2015 && bouwjaar <= 2019 && h_rest + h_wz >= 110 && h_wz < 40, 40, h_wz)
  
• h_unc = round(h_rest + r11, 0)
  
• h_cap = if(h_11a == 0 && h_unc >= 187 && r11 > h_rest * 33 / 67, 1, 0)
  
• punten = if(h_cap == 1, if(round(h_rest + h_rest * 33 / 67, 0) < 187, 186, round(h_rest + h_rest * 33 / 67, 0)), h_unc)
  Na de WOZ-cap: het WOZ-deel mag niet meer dan 33% van de punten zijn als de woning anders boven 186 punten komt.
• h_wz_27 = round((h_w / h_d1 + h_w / h_mt / h_d2_27) * 4, 0) / 4
  
• r11_27 = if(bouwjaar >= 2015 && bouwjaar <= 2019 && h_rest27 + h_wz_27 >= 110 && h_wz_27 < 40, 40, h_wz_27)
  
• h_unc_27 = round(h_rest27 + r11_27, 0)
  
• h_cap_27 = if(h_11a == 0 && h_unc_27 >= 187 && r11_27 > h_rest27 * 33 / 67, 1, 0)
  
• punten_27 = if(h_cap_27 == 1, if(round(h_rest27 + h_rest27 * 33 / 67, 0) < 187, 186, round(h_rest27 + h_rest27 * 33 / 67, 0)), h_unc_27)
  Met de regels per 1 januari 2027: geen minpunten voor ontbrekende buitenruimte.
• h_toe = if(monument == 'rijks', 0.35, if(monument == 'gem', 0.15, if(nieuwbouw == 'ja' && punten > 143 && punten <= 186, 0.10, if(monument == 'gezicht', 0.05, 0))))
  
• h_toe27 = if(monument == 'rijks', 0.35, if(monument == 'gem', 0.15, if(nieuwbouw == 'ja' && punten_27 > 143 && punten_27 <= 186, 0.10, if(monument == 'gezicht', 0.05, 0))))
  
• h_p = if(punten > 250, 250, if(punten < 40, 40, round(punten, 0)))
  
• h_t26_0 = if(h_p == 40, 250.26, if(h_p == 41, 256.53, if(h_p == 42, 262.75, if(h_p == 43, 269.02, if(h_p == 44, 275.27, if(h_p == 45, 281.5, if(h_p == 46, 287.78, if(h_p == 47, 294.03, if(h_p == 48, 300.29, if(h_p == 49, 306.54, if(h_p == 50, 312.8, if(h_p == 51, 319.02, if(h_p == 52, 325.3, if(h_p == 53, 331.54, if(h_p == 54, 337.8, if(h_p == 55, 344.05, if(h_p == 56, 350.35, if(h_p == 57, 356.53, if(h_p == 58, 362.79, if(h_p == 59, 369.09, if(h_p == 60, 375.32, if(h_p == 61, 381.55, if(h_p == 62, 387.83, if(h_p == 63, 394.06, if(h_p == 64, 400.32, if(h_p == 65, 406.58, if(h_p == 66, 412.85, if(h_p == 67, 419.1, if(h_p == 68, 425.33, if(h_p == 69, 431.56, if(h_p == 70, 437.81, 0)))))))))))))))))))))))))))))))
  
• h_t26_1 = if(h_p == 71, 444.09, if(h_p == 72, 450.36, if(h_p == 73, 456.57, if(h_p == 74, 462.86, if(h_p == 75, 469.09, if(h_p == 76, 475.36, if(h_p == 77, 481.6, if(h_p == 78, 487.89, if(h_p == 79, 494.1, if(h_p == 80, 500.38, if(h_p == 81, 507.22, if(h_p == 82, 514.08, if(h_p == 83, 520.96, if(h_p == 84, 527.81, if(h_p == 85, 534.7, if(h_p == 86, 541.56, if(h_p == 87, 548.41, if(h_p == 88, 555.29, if(h_p == 89, 562.13, if(h_p == 90, 569.03, if(h_p == 91, 575.87, if(h_p == 92, 582.71, if(h_p == 93, 589.61, if(h_p == 94, 596.45, if(h_p == 95, 603.32, if(h_p == 96, 610.19, if(h_p == 97, 617.08, if(h_p == 98, 623.94, if(h_p == 99, 630.82, if(h_p == 100, 637.67, if(h_p == 101, 644.53, 0)))))))))))))))))))))))))))))))
  
• h_t26_2 = if(h_p == 102, 651.36, if(h_p == 103, 658.24, if(h_p == 104, 665.12, if(h_p == 105, 671.95, if(h_p == 106, 678.85, if(h_p == 107, 685.7, if(h_p == 108, 692.56, if(h_p == 109, 699.44, if(h_p == 110, 706.32, if(h_p == 111, 713.2, if(h_p == 112, 720.05, if(h_p == 113, 726.9, if(h_p == 114, 733.79, if(h_p == 115, 740.66, if(h_p == 116, 747.51, if(h_p == 117, 754.37, if(h_p == 118, 761.21, if(h_p == 119, 768.08, if(h_p == 120, 774.94, if(h_p == 121, 781.85, if(h_p == 122, 788.71, if(h_p == 123, 795.56, if(h_p == 124, 802.44, if(h_p == 125, 809.3, if(h_p == 126, 816.14, if(h_p == 127, 823.02, if(h_p == 128, 829.94, if(h_p == 129, 836.74, if(h_p == 130, 843.62, if(h_p == 131, 850.49, if(h_p == 132, 857.33, 0)))))))))))))))))))))))))))))))
  
• h_t26_3 = if(h_p == 133, 864.24, if(h_p == 134, 871.06, if(h_p == 135, 877.97, if(h_p == 136, 884.79, if(h_p == 137, 891.67, if(h_p == 138, 898.56, if(h_p == 139, 905.39, if(h_p == 140, 912.26, if(h_p == 141, 919.14, if(h_p == 142, 925.98, if(h_p == 143, 932.93, if(h_p == 144, 939.73, if(h_p == 145, 946.61, if(h_p == 146, 953.45, if(h_p == 147, 960.33, if(h_p == 148, 967.18, if(h_p == 149, 974.05, if(h_p == 150, 980.91, if(h_p == 151, 987.78, if(h_p == 152, 994.63, if(h_p == 153, 1001.5, if(h_p == 154, 1008.35, if(h_p == 155, 1015.22, if(h_p == 156, 1022.07, if(h_p == 157, 1029.0, if(h_p == 158, 1035.81, if(h_p == 159, 1042.73, if(h_p == 160, 1049.57, if(h_p == 161, 1056.42, if(h_p == 162, 1063.32, if(h_p == 163, 1070.14, 0)))))))))))))))))))))))))))))))
  
• h_t26_4 = if(h_p == 164, 1077.0, if(h_p == 165, 1083.88, if(h_p == 166, 1090.76, if(h_p == 167, 1097.61, if(h_p == 168, 1104.46, if(h_p == 169, 1111.39, if(h_p == 170, 1118.23, if(h_p == 171, 1125.08, if(h_p == 172, 1131.94, if(h_p == 173, 1138.85, if(h_p == 174, 1145.69, if(h_p == 175, 1152.55, if(h_p == 176, 1159.4, if(h_p == 177, 1166.27, if(h_p == 178, 1173.15, if(h_p == 179, 1180.01, if(h_p == 180, 1186.84, if(h_p == 181, 1193.76, if(h_p == 182, 1200.61, if(h_p == 183, 1207.46, if(h_p == 184, 1214.31, if(h_p == 185, 1221.21, if(h_p == 186, 1228.07, if(h_p == 187, 1234.92, if(h_p == 188, 1241.81, if(h_p == 189, 1248.65, if(h_p == 190, 1255.53, if(h_p == 191, 1262.4, if(h_p == 192, 1269.25, if(h_p == 193, 1276.12, if(h_p == 194, 1283.0, 0)))))))))))))))))))))))))))))))
  
• h_t26_5 = if(h_p == 195, 1289.86, if(h_p == 196, 1296.7, if(h_p == 197, 1303.57, if(h_p == 198, 1310.46, if(h_p == 199, 1317.28, if(h_p == 200, 1324.18, if(h_p == 201, 1331.03, if(h_p == 202, 1337.89, if(h_p == 203, 1344.75, if(h_p == 204, 1351.63, if(h_p == 205, 1358.5, if(h_p == 206, 1365.34, if(h_p == 207, 1372.24, if(h_p == 208, 1379.09, if(h_p == 209, 1385.95, if(h_p == 210, 1392.84, if(h_p == 211, 1399.69, if(h_p == 212, 1406.56, if(h_p == 213, 1413.43, if(h_p == 214, 1420.28, if(h_p == 215, 1427.15, if(h_p == 216, 1433.99, if(h_p == 217, 1440.86, if(h_p == 218, 1447.71, if(h_p == 219, 1454.6, if(h_p == 220, 1461.49, if(h_p == 221, 1468.31, if(h_p == 222, 1475.19, if(h_p == 223, 1482.05, if(h_p == 224, 1488.95, if(h_p == 225, 1495.77, 0)))))))))))))))))))))))))))))))
  
• h_t26_6 = if(h_p == 226, 1502.67, if(h_p == 227, 1509.53, if(h_p == 228, 1516.4, if(h_p == 229, 1523.28, if(h_p == 230, 1530.12, if(h_p == 231, 1536.98, if(h_p == 232, 1543.85, if(h_p == 233, 1550.71, if(h_p == 234, 1557.56, if(h_p == 235, 1564.46, if(h_p == 236, 1571.31, if(h_p == 237, 1578.17, if(h_p == 238, 1585.01, if(h_p == 239, 1591.91, if(h_p == 240, 1598.76, if(h_p == 241, 1605.64, if(h_p == 242, 1612.52, if(h_p == 243, 1619.36, if(h_p == 244, 1626.24, if(h_p == 245, 1633.1, if(h_p == 246, 1639.96, if(h_p == 247, 1646.78, if(h_p == 248, 1653.7, if(h_p == 249, 1660.54, if(h_p == 250, 1667.4, 0)))))))))))))))))))))))))
  
• h_t26 = if(h_p <= 40, 250.26, h_t26_0 + h_t26_1 + h_t26_2 + h_t26_3 + h_t26_4 + h_t26_5 + h_t26_6)
  
• h_p27 = if(h_cap_27 == 1, if(h_unc_27 > 250, 250, h_unc_27), if(punten_27 > 250, 250, if(punten_27 < 40, 40, punten_27)))
  
• h_t27_0 = if(h_p27 == 40, 257.45, if(h_p27 == 41, 263.9, if(h_p27 == 42, 270.29, if(h_p27 == 43, 276.74, if(h_p27 == 44, 283.17, if(h_p27 == 45, 289.58, if(h_p27 == 46, 296.04, if(h_p27 == 47, 302.47, if(h_p27 == 48, 308.91, if(h_p27 == 49, 315.34, if(h_p27 == 50, 321.78, if(h_p27 == 51, 328.18, if(h_p27 == 52, 334.64, if(h_p27 == 53, 341.06, if(h_p27 == 54, 347.5, if(h_p27 == 55, 353.93, if(h_p27 == 56, 360.41, if(h_p27 == 57, 366.77, if(h_p27 == 58, 373.21, if(h_p27 == 59, 379.69, if(h_p27 == 60, 386.1, if(h_p27 == 61, 392.5, if(h_p27 == 62, 398.96, if(h_p27 == 63, 405.37, if(h_p27 == 64, 411.81, if(h_p27 == 65, 418.25, if(h_p27 == 66, 424.7, if(h_p27 == 67, 431.13, if(h_p27 == 68, 437.54, if(h_p27 == 69, 443.95, if(h_p27 == 70, 450.38, 0)))))))))))))))))))))))))))))))
  
• h_t27_1 = if(h_p27 == 71, 456.84, if(h_p27 == 72, 463.29, if(h_p27 == 73, 469.68, if(h_p27 == 74, 476.15, if(h_p27 == 75, 482.56, if(h_p27 == 76, 489.01, if(h_p27 == 77, 495.43, if(h_p27 == 78, 501.9, if(h_p27 == 79, 508.28, if(h_p27 == 80, 514.74, if(h_p27 == 81, 521.78, if(h_p27 == 82, 528.84, if(h_p27 == 83, 535.92, if(h_p27 == 84, 542.96, if(h_p27 == 85, 550.05, if(h_p27 == 86, 557.11, if(h_p27 == 87, 564.15, if(h_p27 == 88, 571.23, if(h_p27 == 89, 578.27, if(h_p27 == 90, 585.37, if(h_p27 == 91, 592.4, if(h_p27 == 92, 599.44, if(h_p27 == 93, 606.54, if(h_p27 == 94, 613.57, if(h_p27 == 95, 620.64, if(h_p27 == 96, 627.71, if(h_p27 == 97, 634.79, if(h_p27 == 98, 641.85, if(h_p27 == 99, 648.93, if(h_p27 == 100, 655.98, if(h_p27 == 101, 663.03, 0)))))))))))))))))))))))))))))))
  
• h_t27_2 = if(h_p27 == 102, 670.06, if(h_p27 == 103, 677.14, if(h_p27 == 104, 684.21, if(h_p27 == 105, 691.24, if(h_p27 == 106, 698.34, if(h_p27 == 107, 705.38, if(h_p27 == 108, 712.44, if(h_p27 == 109, 719.52, if(h_p27 == 110, 726.6, if(h_p27 == 111, 733.67, if(h_p27 == 112, 740.72, if(h_p27 == 113, 747.77, if(h_p27 == 114, 754.85, if(h_p27 == 115, 761.92, if(h_p27 == 116, 768.97, if(h_p27 == 117, 776.02, if(h_p27 == 118, 783.06, if(h_p27 == 119, 790.13, if(h_p27 == 120, 797.18, if(h_p27 == 121, 804.29, if(h_p27 == 122, 811.35, if(h_p27 == 123, 818.4, if(h_p27 == 124, 825.47, if(h_p27 == 125, 832.53, if(h_p27 == 126, 839.57, if(h_p27 == 127, 846.64, if(h_p27 == 128, 853.76, if(h_p27 == 129, 860.76, if(h_p27 == 130, 867.84, if(h_p27 == 131, 874.9, if(h_p27 == 132, 881.94, 0)))))))))))))))))))))))))))))))
  
• h_t27_3 = if(h_p27 == 133, 889.05, if(h_p27 == 134, 896.06, if(h_p27 == 135, 903.17, if(h_p27 == 136, 910.19, if(h_p27 == 137, 917.26, if(h_p27 == 138, 924.35, if(h_p27 == 139, 931.38, if(h_p27 == 140, 938.45, if(h_p27 == 141, 945.52, if(h_p27 == 142, 952.56, if(h_p27 == 143, 959.71, if(h_p27 == 144, 966.7, if(h_p27 == 145, 973.78, if(h_p27 == 146, 980.82, if(h_p27 == 147, 987.9, if(h_p27 == 148, 994.94, if(h_p27 == 149, 1002.01, if(h_p27 == 150, 1009.07, if(h_p27 == 151, 1016.13, if(h_p27 == 152, 1023.18, if(h_p27 == 153, 1030.25, if(h_p27 == 154, 1037.29, if(h_p27 == 155, 1044.36, if(h_p27 == 156, 1051.41, if(h_p27 == 157, 1058.54, if(h_p27 == 158, 1065.54, if(h_p27 == 159, 1072.66, if(h_p27 == 160, 1079.7, if(h_p27 == 161, 1086.74, if(h_p27 == 162, 1093.84, if(h_p27 == 163, 1100.86, 0)))))))))))))))))))))))))))))))
  
• h_t27_4 = if(h_p27 == 164, 1107.91, if(h_p27 == 165, 1114.99, if(h_p27 == 166, 1122.07, if(h_p27 == 167, 1129.12, if(h_p27 == 168, 1136.16, if(h_p27 == 169, 1143.29, if(h_p27 == 170, 1150.33, if(h_p27 == 171, 1157.37, if(h_p27 == 172, 1164.43, if(h_p27 == 173, 1171.54, if(h_p27 == 174, 1178.58, if(h_p27 == 175, 1185.63, if(h_p27 == 176, 1192.68, if(h_p27 == 177, 1199.75, if(h_p27 == 178, 1206.82, if(h_p27 == 179, 1213.88, if(h_p27 == 180, 1220.91, if(h_p27 == 181, 1228.02, if(h_p27 == 182, 1235.07, if(h_p27 == 183, 1242.12, if(h_p27 == 184, 1249.16, if(h_p27 == 185, 1256.26, if(h_p27 == 186, 1263.32, if(h_p27 == 187, 1270.37, if(h_p27 == 188, 1277.45, if(h_p27 == 189, 1284.49, if(h_p27 == 190, 1291.57, if(h_p27 == 191, 1298.63, if(h_p27 == 192, 1305.68, if(h_p27 == 193, 1312.75, if(h_p27 == 194, 1319.83, 0)))))))))))))))))))))))))))))))
  
• h_t27_5 = if(h_p27 == 195, 1326.88, if(h_p27 == 196, 1333.92, if(h_p27 == 197, 1340.99, if(h_p27 == 198, 1348.07, if(h_p27 == 199, 1355.09, if(h_p27 == 200, 1362.19, if(h_p27 == 201, 1369.23, if(h_p27 == 202, 1376.29, if(h_p27 == 203, 1383.35, if(h_p27 == 204, 1390.43, if(h_p27 == 205, 1397.49, if(h_p27 == 206, 1404.53, if(h_p27 == 207, 1411.63, if(h_p27 == 208, 1418.67, if(h_p27 == 209, 1425.73, if(h_p27 == 210, 1432.82, if(h_p27 == 211, 1439.87, if(h_p27 == 212, 1446.93, if(h_p27 == 213, 1454.0, if(h_p27 == 214, 1461.05, if(h_p27 == 215, 1468.11, if(h_p27 == 216, 1475.15, if(h_p27 == 217, 1482.22, if(h_p27 == 218, 1489.26, if(h_p27 == 219, 1496.35, if(h_p27 == 220, 1503.44, if(h_p27 == 221, 1510.45, if(h_p27 == 222, 1517.53, if(h_p27 == 223, 1524.59, if(h_p27 == 224, 1531.69, if(h_p27 == 225, 1538.7, 0)))))))))))))))))))))))))))))))
  
• h_t27_6 = if(h_p27 == 226, 1545.8, if(h_p27 == 227, 1552.86, if(h_p27 == 228, 1559.92, if(h_p27 == 229, 1567.0, if(h_p27 == 230, 1574.04, if(h_p27 == 231, 1581.1, if(h_p27 == 232, 1588.16, if(h_p27 == 233, 1595.22, if(h_p27 == 234, 1602.27, if(h_p27 == 235, 1609.36, if(h_p27 == 236, 1616.41, if(h_p27 == 237, 1623.47, if(h_p27 == 238, 1630.5, if(h_p27 == 239, 1637.6, if(h_p27 == 240, 1644.65, if(h_p27 == 241, 1651.73, if(h_p27 == 242, 1658.8, if(h_p27 == 243, 1665.84, if(h_p27 == 244, 1672.92, if(h_p27 == 245, 1679.97, if(h_p27 == 246, 1687.03, if(h_p27 == 247, 1694.05, if(h_p27 == 248, 1701.17, if(h_p27 == 249, 1708.2, if(h_p27 == 250, 1715.26, 0)))))))))))))))))))))))))
  
• h_t27 = if(h_p27 <= 40, 257.45, h_t27_0 + h_t27_1 + h_t27_2 + h_t27_3 + h_t27_4 + h_t27_5 + h_t27_6)
  
• h_b27 = if(h_cap_27 == 1, 1263.32, h_t27)
  
• segment = if(punten <= 143, 'sociale huur', if(punten <= 186, 'middenhuur', 'vrije sector'))
  
• h_max = if(punten <= 186, round(h_t26 * (1 + h_toe), 2), 0)
  
• max_huur = if(punten <= 186, concat('€ ', format(h_max, '0.00')), 'Geen maximum (vrije sector)')
  
• segment_27 = if(punten_27 <= 143, 'sociale huur', if(punten_27 <= 186, 'middenhuur', 'vrije sector'))
  
• h_max27 = if(punten_27 <= 186, round(h_b27 * (1 + h_toe27) + (h_t27 - h_b27), 2), 0)
  
• max_huur_27 = if(punten_27 <= 186, concat('€ ', format(h_max27, '0.00')), 'Geen maximum (vrije sector)')
  
• verschil_27 = if(punten_27 <= 186, round(h_max27 - h_max, 2), 0)
  Verschil tussen het maximum van 2027 en van 2026 voor een nieuw huurcontract, inclusief de indexatie van de huurprijstabel (2,87%).
• h_reden = concat(if(h_cap_27 == 1 && h_unc_27 > 186, concat('de WOZ-prijsopslag (huur volgens ', format(h_p27, '0'), ' punten zonder WOZ-cap)'), ''), if(h_cap_27 == 1 && h_unc_27 > 186 && buiten == 'geen', ' en ', ''), if(buiten == 'geen', 'het vervallen van 5 minpunten voor ontbrekende buitenruimte', ''))
  
• h_o1 = concat('Nu (2026): ', format(punten, '0'), ' punten, ', segment, if(punten <= 186, concat(', maximaal € ', format(h_max, '0.00'), ' kale huur'), ''), '. Per 1 januari 2027 bij een nieuw huurcontract: ', format(punten_27, '0'), ' punten, ', segment_27, if(punten_27 <= 186, concat(', maximaal € ', format(h_max27, '0.00')), ''), '. ')
  
• oordeel = if(h_m2 <= 0, 'Vul de oppervlakte van de kamers in.', concat(h_o1, if(verschil_27 > 0, concat('Dat is € ', format(verschil_27, '0.00'), ' per maand meer door ', if(h_reden == '', 'de jaarlijkse indexatie van de huurprijstabel', concat(h_reden, ' en de indexatie')), '. '), if(punten_27 > 186, 'Vrije sector: geen wettelijk maximum. ', 'Voor deze woning verandert het maximum niet. ')), if(huur > 0 && punten_27 <= 186, if(huur > h_max27, concat('De huur van € ', format(huur, '0.00'), ' ligt boven het maximum van 2027. '), concat('De huur van € ', format(huur, '0.00'), ' past binnen het maximum van 2027. ')), ''), 'Voor 2027 rekent de tool met de officiële huurprijstabel 2027; de WOZ-bedragen per punt voor 2027 volgen nog, dus de WOZ-punten zijn een indicatie.'))
  
• volgende = if(huur > 0 && huur > h_max && punten <= 186, 'Huurder? Kijk met Is mijn huur te hoog? wat je kunt terugvragen. Verhuurder? Pas de huur aan of laat de punten nakijken.', 'Verhuurder? Bekijk met Wat doet de Wet betaalbare huur met mijn rendement? wat dit betekent voor je rendement, of vergelijk met Verkopen of blijven verhuren.')
  

Berekening informatie

Op jouw website?

<script src="https://ikbenbint.nl/widget.js"
  data-berekening="maximale-huurprijs-2027-berekenen">
</script>