Wat doet de Wet betaalbare huur met mijn rendement?
Beschrijving
Bereken wat de Wet betaalbare huur kost bij een nieuwe huurder: lagere maximale huur, lager rendement en het effect op de waarde.
Invoer velden
Resultaten
Sinds de Wet betaalbare huur (1 juli 2024) geldt ook voor middenhuurwoningen tot 186 punten een maximale huur. Zittende huurders met een contract van vóór die datum houden hun huur, maar bij een nieuwe huurder moet de huur vaak omlaag. Voor beleggers betekent dat minder huurinkomsten, een lager rendement en een lagere waarde in verhuurde staat.
Deze tool vergelijkt je huidige huur met de maximale huur bij een nieuwe huurder, en rekent uit wat dat doet met het bruto en netto rendement. Het waarde-effect is de daling in waarde als een koper hetzelfde rendement wil. Geldt bij jouw woning de WOZ-cap? Dan zie je ook wat de WOZ-prijsopslag per 1 januari 2027 terugbrengt.
Bereken de punten met Maximale huurprijs 2027 berekenen, vergelijk met verkopen via Verkopen of blijven verhuren, en reken de waarde uit met Huurwaardekapitalisatie (BAR/NAR).
Formulas:
-
h_p = if(punten < 40, 40, if(punten > 250, 250, round(punten, 0)))
-
h_cap = if(punten_unc > punten && punten <= 186 && punten_unc > 186, 1, 0)
-
h_p27 = if(h_cap == 1, if(punten_unc > 250, 250, round(punten_unc, 0)), h_p)
-
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_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_toe = if(toeslag == 'rijks', 0.35, if(toeslag == 'gem', 0.15, if(toeslag == 'gezicht', 0.05, if(toeslag == 'nieuw' && punten > 143 && punten <= 186, 0.10, 0))))
-
segment = if(punten <= 143, 'sociale huur', if(punten <= 186, 'middenhuur', 'vrije sector'))
-
h_m26 = if(punten <= 186, h_t26 * (1 + h_toe), 0)
-
h_m27 = if(punten <= 186, if(h_cap == 1, 1263.32 * (1 + h_toe) + h_t27 - 1263.32, h_t27 * (1 + h_toe)), 0)
-
max_2026 = if(punten <= 186, concat('€ ', format(h_m26, '0.00')), 'geen maximum')
-
max_2027 = if(punten <= 186, concat('€ ', format(h_m27, '0.00')), 'geen maximum')
-
h_v26 = if(punten <= 186 && huur > h_m26, huur - h_m26, 0)
-
h_v27 = if(punten <= 186 && huur > h_m27, huur - h_m27, 0)
-
verlies_maand = round(h_v26, 2)
Volgens de regels van 2026. -
verlies_jaar = round(h_v26 * 12, 0)
-
h_j0 = huur * 12
-
h_j1 = (huur - h_v26) * 12
-
h_j2 = (huur - h_v27) * 12
-
bar_nu = if(waarde > 0, round(h_j0 / waarde * 100, 2), 0)
-
bar_na = if(waarde > 0, round(h_j1 / waarde * 100, 2), 0)
-
nar_nu = if(waarde > 0, round((h_j0 - kosten) / waarde * 100, 2), 0)
Huur min exploitatiekosten, gedeeld door de waarde. Zonder rente en belasting. -
nar_na = if(waarde > 0, round((h_j1 - kosten) / waarde * 100, 2), 0)
-
h_wv = if(h_j0 > 0 && waarde > 0, h_v26 * 12 / (h_j0 / waarde), 0)
-
waarde_effect = if(h_wv > 0, concat('− ', concat('€ ', format(round(h_wv,0), '0.#'))), '€ 0')
-
herstel_2027 = if(h_v26 > h_v27, round((h_v26 - h_v27) * 12, 0), 0)
Door de WOZ-prijsopslag en de indexatie van de huurprijstabel 2027, bij een nieuw huurcontract. -
h_o1 = concat('Bij een nieuwe huurder moet de huur € ', format(h_v26, '0.00'), ' per maand omlaag naar € ', format(h_m26, '0.00'), ' (', segment, '). Je netto rendement daalt van ', format(nar_nu, '0.0#'), '% naar ', format(nar_na, '0.0#'), '%. Bij een gelijk rendement voor een koper is de woning verhuurd ongeveer ', concat('€ ', format(round(h_wv,0), '0.#')), ' minder waard.', if(herstel_2027 > 0, concat(' Per 2027 win je bij een nieuw contract ', concat('€ ', format(round(herstel_2027,0), '0.#')), ' per jaar terug.'), ''))
-
oordeel = if(huur <= 0 || punten <= 0 || waarde <= 0, 'Vul de huur, de punten en de waarde in.', if(punten > 186, concat('Met ', format(punten, '0'), ' punten valt de woning in de vrije sector: de Wet betaalbare huur begrenst de huur bij een nieuwe huurder niet, alleen de jaarlijkse verhoging.'), if(h_v26 <= 0, concat('De huur van € ', format(huur, '0'), ' past al binnen het maximum van € ', format(h_m26, '0.00'), ' (', segment, '). De wet kost je bij een nieuwe huurder geen huur.'), h_o1)))
-
volgende = 'Zittende huurders met een contract van vóór 1 juli 2024 houden hun huur. Weeg af wat je bij vertrek doet met Verkopen of blijven verhuren, of verhoog de punten met Huurwoning naar label D: wat levert verduurzamen op?'
Berekening informatie
Meer over huren & verhuren
Ontdek meer tools gerelateerd aan huren & verhuren