Huurwoning naar label D: wat levert verduurzamen op?

Formulas:

• h_lpn = if(type == 'een', if(label_nu == 'app4', 62, if(label_nu == 'app3', 57, if(label_nu == 'app2', 52, if(label_nu == 'app1', 47, if(label_nu == 'a', 41, if(label_nu == 'b', 34, if(label_nu == 'c', 22, if(label_nu == 'd', 14, if(label_nu == 'e', -5, if(label_nu == 'f', -9, if(label_nu == 'g', -15, 0))))))))))), if(label_nu == 'app4', 58, if(label_nu == 'app3', 53, if(label_nu == 'app2', 48, if(label_nu == 'app1', 43, if(label_nu == 'a', 37, if(label_nu == 'b', 30, if(label_nu == 'c', 15, if(label_nu == 'd', 11, if(label_nu == 'e', -5, if(label_nu == 'f', -9, if(label_nu == 'g', -15, 0))))))))))))
  
• h_lpd = if(type == 'een', if(label_doel == 'app4', 62, if(label_doel == 'app3', 57, if(label_doel == 'app2', 52, if(label_doel == 'app1', 47, if(label_doel == 'a', 41, if(label_doel == 'b', 34, if(label_doel == 'c', 22, if(label_doel == 'd', 14, if(label_doel == 'e', -5, if(label_doel == 'f', -9, if(label_doel == 'g', -15, 0))))))))))), if(label_doel == 'app4', 58, if(label_doel == 'app3', 53, if(label_doel == 'app2', 48, if(label_doel == 'app1', 43, if(label_doel == 'a', 37, if(label_doel == 'b', 30, if(label_doel == 'c', 15, if(label_doel == 'd', 11, if(label_doel == 'e', -5, if(label_doel == 'f', -9, if(label_doel == 'g', -15, 0))))))))))))
  
• extra_punten = h_lpd - h_lpn
  Uit de energieprestatie-tabel van het woningwaarderingsstelsel.
• h_p0 = if(punten < 40, 40, if(punten > 250, 250, round(punten, 0)))
  
• h_p1 = if(round(punten + extra_punten, 0) < 40, 40, if(round(punten + extra_punten, 0) > 250, 250, round(punten + extra_punten, 0)))
  
• h_t0_0 = if(h_p0 == 40, 250.26, if(h_p0 == 41, 256.53, if(h_p0 == 42, 262.75, if(h_p0 == 43, 269.02, if(h_p0 == 44, 275.27, if(h_p0 == 45, 281.5, if(h_p0 == 46, 287.78, if(h_p0 == 47, 294.03, if(h_p0 == 48, 300.29, if(h_p0 == 49, 306.54, if(h_p0 == 50, 312.8, if(h_p0 == 51, 319.02, if(h_p0 == 52, 325.3, if(h_p0 == 53, 331.54, if(h_p0 == 54, 337.8, if(h_p0 == 55, 344.05, if(h_p0 == 56, 350.35, if(h_p0 == 57, 356.53, if(h_p0 == 58, 362.79, if(h_p0 == 59, 369.09, if(h_p0 == 60, 375.32, if(h_p0 == 61, 381.55, if(h_p0 == 62, 387.83, if(h_p0 == 63, 394.06, if(h_p0 == 64, 400.32, if(h_p0 == 65, 406.58, if(h_p0 == 66, 412.85, if(h_p0 == 67, 419.1, if(h_p0 == 68, 425.33, if(h_p0 == 69, 431.56, if(h_p0 == 70, 437.81, 0)))))))))))))))))))))))))))))))
  
• h_t0_1 = if(h_p0 == 71, 444.09, if(h_p0 == 72, 450.36, if(h_p0 == 73, 456.57, if(h_p0 == 74, 462.86, if(h_p0 == 75, 469.09, if(h_p0 == 76, 475.36, if(h_p0 == 77, 481.6, if(h_p0 == 78, 487.89, if(h_p0 == 79, 494.1, if(h_p0 == 80, 500.38, if(h_p0 == 81, 507.22, if(h_p0 == 82, 514.08, if(h_p0 == 83, 520.96, if(h_p0 == 84, 527.81, if(h_p0 == 85, 534.7, if(h_p0 == 86, 541.56, if(h_p0 == 87, 548.41, if(h_p0 == 88, 555.29, if(h_p0 == 89, 562.13, if(h_p0 == 90, 569.03, if(h_p0 == 91, 575.87, if(h_p0 == 92, 582.71, if(h_p0 == 93, 589.61, if(h_p0 == 94, 596.45, if(h_p0 == 95, 603.32, if(h_p0 == 96, 610.19, if(h_p0 == 97, 617.08, if(h_p0 == 98, 623.94, if(h_p0 == 99, 630.82, if(h_p0 == 100, 637.67, if(h_p0 == 101, 644.53, 0)))))))))))))))))))))))))))))))
  
• h_t0_2 = if(h_p0 == 102, 651.36, if(h_p0 == 103, 658.24, if(h_p0 == 104, 665.12, if(h_p0 == 105, 671.95, if(h_p0 == 106, 678.85, if(h_p0 == 107, 685.7, if(h_p0 == 108, 692.56, if(h_p0 == 109, 699.44, if(h_p0 == 110, 706.32, if(h_p0 == 111, 713.2, if(h_p0 == 112, 720.05, if(h_p0 == 113, 726.9, if(h_p0 == 114, 733.79, if(h_p0 == 115, 740.66, if(h_p0 == 116, 747.51, if(h_p0 == 117, 754.37, if(h_p0 == 118, 761.21, if(h_p0 == 119, 768.08, if(h_p0 == 120, 774.94, if(h_p0 == 121, 781.85, if(h_p0 == 122, 788.71, if(h_p0 == 123, 795.56, if(h_p0 == 124, 802.44, if(h_p0 == 125, 809.3, if(h_p0 == 126, 816.14, if(h_p0 == 127, 823.02, if(h_p0 == 128, 829.94, if(h_p0 == 129, 836.74, if(h_p0 == 130, 843.62, if(h_p0 == 131, 850.49, if(h_p0 == 132, 857.33, 0)))))))))))))))))))))))))))))))
  
• h_t0_3 = if(h_p0 == 133, 864.24, if(h_p0 == 134, 871.06, if(h_p0 == 135, 877.97, if(h_p0 == 136, 884.79, if(h_p0 == 137, 891.67, if(h_p0 == 138, 898.56, if(h_p0 == 139, 905.39, if(h_p0 == 140, 912.26, if(h_p0 == 141, 919.14, if(h_p0 == 142, 925.98, if(h_p0 == 143, 932.93, if(h_p0 == 144, 939.73, if(h_p0 == 145, 946.61, if(h_p0 == 146, 953.45, if(h_p0 == 147, 960.33, if(h_p0 == 148, 967.18, if(h_p0 == 149, 974.05, if(h_p0 == 150, 980.91, if(h_p0 == 151, 987.78, if(h_p0 == 152, 994.63, if(h_p0 == 153, 1001.5, if(h_p0 == 154, 1008.35, if(h_p0 == 155, 1015.22, if(h_p0 == 156, 1022.07, if(h_p0 == 157, 1029.0, if(h_p0 == 158, 1035.81, if(h_p0 == 159, 1042.73, if(h_p0 == 160, 1049.57, if(h_p0 == 161, 1056.42, if(h_p0 == 162, 1063.32, if(h_p0 == 163, 1070.14, 0)))))))))))))))))))))))))))))))
  
• h_t0_4 = if(h_p0 == 164, 1077.0, if(h_p0 == 165, 1083.88, if(h_p0 == 166, 1090.76, if(h_p0 == 167, 1097.61, if(h_p0 == 168, 1104.46, if(h_p0 == 169, 1111.39, if(h_p0 == 170, 1118.23, if(h_p0 == 171, 1125.08, if(h_p0 == 172, 1131.94, if(h_p0 == 173, 1138.85, if(h_p0 == 174, 1145.69, if(h_p0 == 175, 1152.55, if(h_p0 == 176, 1159.4, if(h_p0 == 177, 1166.27, if(h_p0 == 178, 1173.15, if(h_p0 == 179, 1180.01, if(h_p0 == 180, 1186.84, if(h_p0 == 181, 1193.76, if(h_p0 == 182, 1200.61, if(h_p0 == 183, 1207.46, if(h_p0 == 184, 1214.31, if(h_p0 == 185, 1221.21, if(h_p0 == 186, 1228.07, if(h_p0 == 187, 1234.92, if(h_p0 == 188, 1241.81, if(h_p0 == 189, 1248.65, if(h_p0 == 190, 1255.53, if(h_p0 == 191, 1262.4, if(h_p0 == 192, 1269.25, if(h_p0 == 193, 1276.12, if(h_p0 == 194, 1283.0, 0)))))))))))))))))))))))))))))))
  
• h_t0_5 = if(h_p0 == 195, 1289.86, if(h_p0 == 196, 1296.7, if(h_p0 == 197, 1303.57, if(h_p0 == 198, 1310.46, if(h_p0 == 199, 1317.28, if(h_p0 == 200, 1324.18, if(h_p0 == 201, 1331.03, if(h_p0 == 202, 1337.89, if(h_p0 == 203, 1344.75, if(h_p0 == 204, 1351.63, if(h_p0 == 205, 1358.5, if(h_p0 == 206, 1365.34, if(h_p0 == 207, 1372.24, if(h_p0 == 208, 1379.09, if(h_p0 == 209, 1385.95, if(h_p0 == 210, 1392.84, if(h_p0 == 211, 1399.69, if(h_p0 == 212, 1406.56, if(h_p0 == 213, 1413.43, if(h_p0 == 214, 1420.28, if(h_p0 == 215, 1427.15, if(h_p0 == 216, 1433.99, if(h_p0 == 217, 1440.86, if(h_p0 == 218, 1447.71, if(h_p0 == 219, 1454.6, if(h_p0 == 220, 1461.49, if(h_p0 == 221, 1468.31, if(h_p0 == 222, 1475.19, if(h_p0 == 223, 1482.05, if(h_p0 == 224, 1488.95, if(h_p0 == 225, 1495.77, 0)))))))))))))))))))))))))))))))
  
• h_t0_6 = if(h_p0 == 226, 1502.67, if(h_p0 == 227, 1509.53, if(h_p0 == 228, 1516.4, if(h_p0 == 229, 1523.28, if(h_p0 == 230, 1530.12, if(h_p0 == 231, 1536.98, if(h_p0 == 232, 1543.85, if(h_p0 == 233, 1550.71, if(h_p0 == 234, 1557.56, if(h_p0 == 235, 1564.46, if(h_p0 == 236, 1571.31, if(h_p0 == 237, 1578.17, if(h_p0 == 238, 1585.01, if(h_p0 == 239, 1591.91, if(h_p0 == 240, 1598.76, if(h_p0 == 241, 1605.64, if(h_p0 == 242, 1612.52, if(h_p0 == 243, 1619.36, if(h_p0 == 244, 1626.24, if(h_p0 == 245, 1633.1, if(h_p0 == 246, 1639.96, if(h_p0 == 247, 1646.78, if(h_p0 == 248, 1653.7, if(h_p0 == 249, 1660.54, if(h_p0 == 250, 1667.4, 0)))))))))))))))))))))))))
  
• h_t0 = if(h_p0 <= 40, 250.26, h_t0_0 + h_t0_1 + h_t0_2 + h_t0_3 + h_t0_4 + h_t0_5 + h_t0_6)
  
• h_t1_0 = if(h_p1 == 40, 250.26, if(h_p1 == 41, 256.53, if(h_p1 == 42, 262.75, if(h_p1 == 43, 269.02, if(h_p1 == 44, 275.27, if(h_p1 == 45, 281.5, if(h_p1 == 46, 287.78, if(h_p1 == 47, 294.03, if(h_p1 == 48, 300.29, if(h_p1 == 49, 306.54, if(h_p1 == 50, 312.8, if(h_p1 == 51, 319.02, if(h_p1 == 52, 325.3, if(h_p1 == 53, 331.54, if(h_p1 == 54, 337.8, if(h_p1 == 55, 344.05, if(h_p1 == 56, 350.35, if(h_p1 == 57, 356.53, if(h_p1 == 58, 362.79, if(h_p1 == 59, 369.09, if(h_p1 == 60, 375.32, if(h_p1 == 61, 381.55, if(h_p1 == 62, 387.83, if(h_p1 == 63, 394.06, if(h_p1 == 64, 400.32, if(h_p1 == 65, 406.58, if(h_p1 == 66, 412.85, if(h_p1 == 67, 419.1, if(h_p1 == 68, 425.33, if(h_p1 == 69, 431.56, if(h_p1 == 70, 437.81, 0)))))))))))))))))))))))))))))))
  
• h_t1_1 = if(h_p1 == 71, 444.09, if(h_p1 == 72, 450.36, if(h_p1 == 73, 456.57, if(h_p1 == 74, 462.86, if(h_p1 == 75, 469.09, if(h_p1 == 76, 475.36, if(h_p1 == 77, 481.6, if(h_p1 == 78, 487.89, if(h_p1 == 79, 494.1, if(h_p1 == 80, 500.38, if(h_p1 == 81, 507.22, if(h_p1 == 82, 514.08, if(h_p1 == 83, 520.96, if(h_p1 == 84, 527.81, if(h_p1 == 85, 534.7, if(h_p1 == 86, 541.56, if(h_p1 == 87, 548.41, if(h_p1 == 88, 555.29, if(h_p1 == 89, 562.13, if(h_p1 == 90, 569.03, if(h_p1 == 91, 575.87, if(h_p1 == 92, 582.71, if(h_p1 == 93, 589.61, if(h_p1 == 94, 596.45, if(h_p1 == 95, 603.32, if(h_p1 == 96, 610.19, if(h_p1 == 97, 617.08, if(h_p1 == 98, 623.94, if(h_p1 == 99, 630.82, if(h_p1 == 100, 637.67, if(h_p1 == 101, 644.53, 0)))))))))))))))))))))))))))))))
  
• h_t1_2 = if(h_p1 == 102, 651.36, if(h_p1 == 103, 658.24, if(h_p1 == 104, 665.12, if(h_p1 == 105, 671.95, if(h_p1 == 106, 678.85, if(h_p1 == 107, 685.7, if(h_p1 == 108, 692.56, if(h_p1 == 109, 699.44, if(h_p1 == 110, 706.32, if(h_p1 == 111, 713.2, if(h_p1 == 112, 720.05, if(h_p1 == 113, 726.9, if(h_p1 == 114, 733.79, if(h_p1 == 115, 740.66, if(h_p1 == 116, 747.51, if(h_p1 == 117, 754.37, if(h_p1 == 118, 761.21, if(h_p1 == 119, 768.08, if(h_p1 == 120, 774.94, if(h_p1 == 121, 781.85, if(h_p1 == 122, 788.71, if(h_p1 == 123, 795.56, if(h_p1 == 124, 802.44, if(h_p1 == 125, 809.3, if(h_p1 == 126, 816.14, if(h_p1 == 127, 823.02, if(h_p1 == 128, 829.94, if(h_p1 == 129, 836.74, if(h_p1 == 130, 843.62, if(h_p1 == 131, 850.49, if(h_p1 == 132, 857.33, 0)))))))))))))))))))))))))))))))
  
• h_t1_3 = if(h_p1 == 133, 864.24, if(h_p1 == 134, 871.06, if(h_p1 == 135, 877.97, if(h_p1 == 136, 884.79, if(h_p1 == 137, 891.67, if(h_p1 == 138, 898.56, if(h_p1 == 139, 905.39, if(h_p1 == 140, 912.26, if(h_p1 == 141, 919.14, if(h_p1 == 142, 925.98, if(h_p1 == 143, 932.93, if(h_p1 == 144, 939.73, if(h_p1 == 145, 946.61, if(h_p1 == 146, 953.45, if(h_p1 == 147, 960.33, if(h_p1 == 148, 967.18, if(h_p1 == 149, 974.05, if(h_p1 == 150, 980.91, if(h_p1 == 151, 987.78, if(h_p1 == 152, 994.63, if(h_p1 == 153, 1001.5, if(h_p1 == 154, 1008.35, if(h_p1 == 155, 1015.22, if(h_p1 == 156, 1022.07, if(h_p1 == 157, 1029.0, if(h_p1 == 158, 1035.81, if(h_p1 == 159, 1042.73, if(h_p1 == 160, 1049.57, if(h_p1 == 161, 1056.42, if(h_p1 == 162, 1063.32, if(h_p1 == 163, 1070.14, 0)))))))))))))))))))))))))))))))
  
• h_t1_4 = if(h_p1 == 164, 1077.0, if(h_p1 == 165, 1083.88, if(h_p1 == 166, 1090.76, if(h_p1 == 167, 1097.61, if(h_p1 == 168, 1104.46, if(h_p1 == 169, 1111.39, if(h_p1 == 170, 1118.23, if(h_p1 == 171, 1125.08, if(h_p1 == 172, 1131.94, if(h_p1 == 173, 1138.85, if(h_p1 == 174, 1145.69, if(h_p1 == 175, 1152.55, if(h_p1 == 176, 1159.4, if(h_p1 == 177, 1166.27, if(h_p1 == 178, 1173.15, if(h_p1 == 179, 1180.01, if(h_p1 == 180, 1186.84, if(h_p1 == 181, 1193.76, if(h_p1 == 182, 1200.61, if(h_p1 == 183, 1207.46, if(h_p1 == 184, 1214.31, if(h_p1 == 185, 1221.21, if(h_p1 == 186, 1228.07, if(h_p1 == 187, 1234.92, if(h_p1 == 188, 1241.81, if(h_p1 == 189, 1248.65, if(h_p1 == 190, 1255.53, if(h_p1 == 191, 1262.4, if(h_p1 == 192, 1269.25, if(h_p1 == 193, 1276.12, if(h_p1 == 194, 1283.0, 0)))))))))))))))))))))))))))))))
  
• h_t1_5 = if(h_p1 == 195, 1289.86, if(h_p1 == 196, 1296.7, if(h_p1 == 197, 1303.57, if(h_p1 == 198, 1310.46, if(h_p1 == 199, 1317.28, if(h_p1 == 200, 1324.18, if(h_p1 == 201, 1331.03, if(h_p1 == 202, 1337.89, if(h_p1 == 203, 1344.75, if(h_p1 == 204, 1351.63, if(h_p1 == 205, 1358.5, if(h_p1 == 206, 1365.34, if(h_p1 == 207, 1372.24, if(h_p1 == 208, 1379.09, if(h_p1 == 209, 1385.95, if(h_p1 == 210, 1392.84, if(h_p1 == 211, 1399.69, if(h_p1 == 212, 1406.56, if(h_p1 == 213, 1413.43, if(h_p1 == 214, 1420.28, if(h_p1 == 215, 1427.15, if(h_p1 == 216, 1433.99, if(h_p1 == 217, 1440.86, if(h_p1 == 218, 1447.71, if(h_p1 == 219, 1454.6, if(h_p1 == 220, 1461.49, if(h_p1 == 221, 1468.31, if(h_p1 == 222, 1475.19, if(h_p1 == 223, 1482.05, if(h_p1 == 224, 1488.95, if(h_p1 == 225, 1495.77, 0)))))))))))))))))))))))))))))))
  
• h_t1_6 = if(h_p1 == 226, 1502.67, if(h_p1 == 227, 1509.53, if(h_p1 == 228, 1516.4, if(h_p1 == 229, 1523.28, if(h_p1 == 230, 1530.12, if(h_p1 == 231, 1536.98, if(h_p1 == 232, 1543.85, if(h_p1 == 233, 1550.71, if(h_p1 == 234, 1557.56, if(h_p1 == 235, 1564.46, if(h_p1 == 236, 1571.31, if(h_p1 == 237, 1578.17, if(h_p1 == 238, 1585.01, if(h_p1 == 239, 1591.91, if(h_p1 == 240, 1598.76, if(h_p1 == 241, 1605.64, if(h_p1 == 242, 1612.52, if(h_p1 == 243, 1619.36, if(h_p1 == 244, 1626.24, if(h_p1 == 245, 1633.1, if(h_p1 == 246, 1639.96, if(h_p1 == 247, 1646.78, if(h_p1 == 248, 1653.7, if(h_p1 == 249, 1660.54, if(h_p1 == 250, 1667.4, 0)))))))))))))))))))))))))
  
• h_t1 = if(h_p1 <= 40, 250.26, h_t1_0 + h_t1_1 + h_t1_2 + h_t1_3 + h_t1_4 + h_t1_5 + h_t1_6)
  
• h_pna = round(punten + extra_punten, 0)
  
• seg_nu = if(punten <= 143, 'sociale huur', if(punten <= 186, 'middenhuur', 'vrije sector'))
  
• seg_na = if(h_pna <= 143, 'sociale huur', if(h_pna <= 186, 'middenhuur', 'vrije sector'))
  
• max_nu = if(punten <= 186, concat('€ ', format(h_t0, '0.00')), 'geen maximum')
  
• max_na = if(h_pna <= 186, concat('€ ', format(h_t1, '0.00')), 'geen maximum (vrije sector)')
  
• h_iso = (16.25 * if(dak >= 20, dak, 0) + 20.25 * if(gevel > 0, gevel, 0) + 5.25 * if(spouw >= 10, spouw, 0) + 5.5 * if(vloer > 0, vloer, 0)) * if(dubbel == 'ja', 2, 1)
  
• h_gl = 25 * if(glas >= 3, glas, 0) + 111 * if(triple > 0, triple, 0)
  
• h_ve = if(vent > 0, if(0.3 * vent > 1200, 1200, 0.3 * vent), 0)
  
• h_sub = if(h_iso + h_gl + h_ve > 15000, 15000, h_iso + h_gl + h_ve)
  
• subsidie = concat('€ ', format(round(h_sub,0), '0.#'))
  
• h_net = if(kosten - h_sub > 0, kosten - h_sub, 0)
  
• netto = concat('€ ', format(round(h_net,0), '0.#'))
  
• h_dh = if(punten > 186, 0, if(h_pna > 186, 0, h_t1 - h_t0))
  
• extra_huur = if(punten > 186, 'n.v.t. (vrije sector)', if(h_pna > 186, 'vrije sector: markthuur', concat('€ ', format(h_dh, '0.00'), ' per maand')))
  
• h_ruimte = if(h_pna <= 186 && h_t1 > huur, h_t1 - huur, 0)
  
• terugverdientijd = if(h_dh > 0, round(h_net / (h_dh * 12), 1), 0)
  Netto investering gedeeld door de hogere maximale huur per jaar. Alleen haalbaar als je de huur ook echt verhoogt.
• h_plicht = if(label_nu == 'e' || label_nu == 'f' || label_nu == 'g', 1, 0)
  
• h_o1 = if(h_plicht == 1, if(label_doel == 'e' || label_doel == 'f' || label_doel == 'g', 'Let op: ook met het nieuwe label mag je de woning vanaf 2029 waarschijnlijk niet meer verhuren, want minimaal label D is de bedoeling. ', 'Met het nieuwe label voldoe je aan de eis van minimaal label D vanaf 2029. '), '')
  
• oordeel = if(punten <= 0, 'Vul het aantal WWS-punten in.', concat(h_o1, if(extra_punten <= 0, 'Het nieuwe label levert geen extra punten op. ', concat('Het betere label levert ', format(extra_punten, '0'), ' punten op', if(seg_nu != seg_na, concat(', en de woning gaat van ', seg_nu, ' naar ', seg_na), ''), '. ')), if(h_dh > 0, concat('De maximale huur stijgt met € ', format(h_dh, '0.00'), ' per maand. Na ', concat('€ ', format(round(h_sub,0), '0.#')), ' subsidie verdien je de investering in ongeveer ', format(terugverdientijd, '0.#'), ' jaar terug via de huur.'), if(h_pna > 186 && punten <= 186, 'Je mag daarna een vrije huur vragen bij een nieuwe huurder.', ''))))
  
• volgende = 'Vraag SVOH-subsidie aan bij RVO (bij € 25.000 of meer vóór de start). Bij een zittende huurder mag je de huur na woningverbetering alleen met een redelijk voorstel verhogen; reken de nieuwe huur door met Maximale huurprijs 2027 berekenen.'
  

Berekening informatie

Op jouw website?

<script src="https://ikbenbint.nl/widget.js"
  data-berekening="huurwoning-naar-label-d-wat-levert-verduurzamen-op">
</script>