{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Sheet3","Print"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":85,"n_cols":8,"rows_kept":85,"cut":false,"hidden":false,"merged":[[37,2,39,3]]}
[]
[]
[null,null,"Berekenen Verantwoord Krediet Maximum"]
[]
[]
[]
[null,null,"Naam:",null,null,"Naam partner:"]
[]
[null,null,"Burgerlijke staat","Maak keuze"]
[]
[null,null,"Bruto basissalaris:",null,null,"Bruto basissalaris:"]
[]
[null,null,"Vaste toeslagen per maand:",0,null,"Vaste toeslagen per maand:",0]
[]
[]
[]
[null,null,"Totaal bruto inkomen:",{"$f":"D13+D11","v":0},null,"Totaal bruto inkomen:",{"$f":"G13+G11","v":0}]
[]
[null,null,"Type dienstverband:","Maak keuze",null,"Type dienstverband:","Maak keuze"]
[]
[null,null,"Te betalen partneralimentatie:",0,null,"Te betalen partneralimentatie:",0]
[]
[null,null,"Te betalen kinderalimentatie:",0,null,"Te betalen kinderalimentatie:",0]
[]
[null,null,"Totaal limieten DK, RK, VK niet inlossen:",0]
[]
[null,null,"Totaal maandlasten AK niet inlossen:",0]
[]
[null,null,"Type woning:","Maak keuze"]
[]
[null,null,"Woonlasten:"]
[]
[null,null,"2e hypotheek niet inlossen (limiet):",0]
[]
[null,null,"Verantwoord kredietmaximum:",{"$f":"IF(D85<2500,0,D85)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"IF(D35=0,\"Aan de hand van deze berekening is het helaas niet mogelijk om in aanmerking te komen voor een financiering. Neem bij twijfel altijd contact op met A&H Advies BV via 036 536 36 03. Onze medewerkers staan u graag te woord.\",\"Deze berekening betreft een indicatie en er kunnen geen rechten aan worden ontleend. Neem contact met A&H Advies BV op via 036 536 36 03.\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,"Norm","Inkomen","Norm max","Norm berekenen","Norm gebruiken"]
[null,null,"Alleenstaand",723,{"$f":"D63","v":{"$error":"#N/A"}},1036,{"$f":"15%*(E43-D43-$D$65)+D43","v":{"$error":"#N/A"}},{"$f":"IF(G43>F43,F43,G43)","v":{"$error":"#N/A"}}]
[null,null,"Alleenstaand met kind(eren)",931,{"$f":"D63","v":{"$error":"#N/A"}},1189,{"$f":"15%*(E44-D44-$D$65)+D44","v":{"$error":"#N/A"}},{"$f":"IF(G44>F44,F44,G44)","v":{"$error":"#N/A"}}]
[null,null,"Samen",1172,{"$f":"D63+E63","v":{"$error":"#N/A"}},1417,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Samen met kind(eren)",1273,{"$f":"D63+E63","v":{"$error":"#N/A"}},1480,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Gebruiken",null,{"$f":"VLOOKUP(D9,$C$43:$E$47,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(D9,$C$43:$H$46,6,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Hoofd","Partner"]
[null,null,"Netto Inkomen",{"$f":"IF(D17>0,LOOKUP(D17,Sheet3!$A$1:$B$513),147)","v":147},{"$f":"IF(G17>0,LOOKUP(G17,Sheet3!$A$1:$B$513),147)","v":147}]
[null,null,"Vast dienstverband",{"$f":"D50","v":147},{"$f":"E50","v":147}]
[null,null,"Tijdelijk dienstverband",{"$f":"D50*0.7","v":102.89999999999999},{"$f":"E50*0.7","v":102.89999999999999}]
[null,null,"WGA",{"$f":"D50*0.7","v":102.89999999999999},{"$f":"E50*0.7","v":102.89999999999999}]
[null,null,"IVA",{"$f":"D50","v":147},{"$f":"E50","v":147}]
[null,null,"WW",147,147]
[null,null,"Oproepkracht",147,147]
[null,null,"Uitzend Fase A",147,147]
[null,null,"Uitzend Fase B",{"$f":"D50*0.7","v":102.89999999999999},{"$f":"E50*0.7","v":102.89999999999999}]
[null,null,"Uitzend Fase C",{"$f":"D50","v":147},{"$f":"E50","v":147}]
[null,null,"Zelfstandig",{"$f":"D50","v":147},{"$f":"E50","v":147}]
[null,null,"Pensioen en/of AOW",{"$f":"D50","v":147},{"$f":"E50","v":147}]
[null,null,"Geen inkomen",147,147]
[null,null,"Gebruiken",{"$f":"VLOOKUP(D19,$C$50:$E$62,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G19,$C$50:$E$62,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Basishuur",227]
[]
[null,null,"Koopwoning",{"$f":"IF(E47>3268,0.7*D31,0.75*D31)","v":{"$error":"#N/A"}}]
[null,null,"Huurwoning",{"$f":"IF(D31>300,D31,300)","v":300}]
[null,null,"Inwonend",{"$f":"E47*0.33","v":{"$error":"#N/A"}}]
[null,null,"Gebruiken",{"$f":"VLOOKUP(D29,$C$67:$D$69,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Aftrek leencapaciteit"]
[null,null,"Alimentatie",{"$f":"D21+D23+G21+G23","v":0}]
[null,null,"Naastlopend DK",{"$f":"2%*D25","v":0}]
[null,null,"Naastlopend AK",{"$f":"D27","v":0}]
[null,null,"Naastlopend 2H",{"$f":"1%*D33","v":0}]
[null,null,"Totaal",{"$f":"SUM(D73:D76)","v":0}]
[]
[null,null,"VKM"]
[null,null,"Inkomen",{"$f":"E47","v":{"$error":"#N/A"}}]
[null,null,"Woonlasten",{"$f":"D70","v":{"$error":"#N/A"}}]
[null,null,"Norm",{"$f":"H47","v":{"$error":"#N/A"}}]
[null,null,"Aftrek",{"$f":"D77","v":0}]
[null,null,"Leencapaciteit",{"$f":"D80-D81-D82-D83","v":{"$error":"#N/A"}}]
[null,null,"VKM",{"$f":"D84*50","v":{"$error":"#N/A"}}]

{"sheet":"Sheet3","index":1,"n_rows":513,"n_cols":3,"rows_kept":513,"cut":false,"hidden":true,"merged":[]}
["Loonheffing","Korting","Zonder Korting"]
[0,0,0]
[150,150]
[175,175]
[200,200]
[225,225]
[250,250]
[275,275]
[300,300]
[325,325]
[350,350]
[375,375]
[400,398.94,255.44]
[405,403.93,257.18]
[410,408.91,260.49]
[415,413.9,263.89999999999998]
[420,418.88,267.20999999999998]
[425,423.87,270.54000000000002]
[430,428.86,273.94]
[435,433.84,277.26]
[440,438.83,280.66000000000003]
[445,443.82,283.99]
[450,448.8,285.72000000000003]
[455,453.8,289.05]
[460,458.78,292.45]
[465,463.77,295.77]
[470,468.76,299.18]
[475,473.74,302.49]
[480,478.73,305.89999999999998]
[485,483.72,309.22000000000003]
[490,488.7,312.52999999999997]
[495,493.69,314.27]
[500,498.67,317.67]
[505,503.66,320.99]
[510,508.65,324.39999999999998]
[515,513.04999999999995,327.71]
[520,516.45000000000005,331.04]
[525,519.94000000000005,334.44]
[530,523.34,337.76]
[535,526.83000000000004,341.16]
[540,528.64,342.81]
[545,532.13,346.22]
[550,535.54,349.54]
[555,539.03,352.95]
[560,542.44000000000005,356.27]
[565,545.92999999999995,359.68]
[570,549.32000000000005,362.99]
[575,552.73,366.31]
[580,556.21,369.71]
[585,558.20000000000005,371.45]
[590,561.61,374.77]
[595,565.09,378.17]
[600,568.49,381.49]
[605,571.9,384.82]
[610,575.38,388.21]
[615,578.79,391.54]
[620,582.27,394.93]
[625,585.66999999999996,398.26]
[630,587.58000000000004,400]
[635,590.98,403.31]
[640,594.47,406.72]
[645,597.87,410.04]
[650,601.35,413.44]
[655,604.77,416.77]
[660,608.25,420.17]
[665,611.66,423.49]
[670,615.15,426.81]
[675,617.04,428.54]
[680,620.53,431.95]
[685,623.94000000000005,435.27]
[690,627.59,438.67]
[695,631.74,441.99]
[700,635.97,445.31]
[705,640.29999999999995,448.71]
[710,644.54,452.04]
[715,648.85,455.43]
[720,652.34,457.09]
[725,656.66,460.5]
[730,660.89,463.81]
[735,665.22,467.22]
[740,669.45,470.53]
[745,673.77,473.94]
[750,677.93,477.26]
[755,682.17,480.58]
[760,686.49,483.99]
[765,690.06,485.73]
[770,694.29,489.04]
[775,698.62,492.45]
[780,702.85,495.76]
[785,707.09,499.09]
[790,711.41,502.49]
[795,715.64,505.81]
[800,719.96,509.21]
[805,724.2,512.54]
[810,727.68,514.27]
[815,731.92,517.59]
[820,736.24,520.99]
[825,740.48,524.30999999999995]
[830,744.8,527.72]
[835,749.03,531.03]
[840,753.35,534.44000000000005]
[845,757.59,537.76]
[850,761.82,541.07000000000005]
[855,765.41,542.82000000000005]
[860,769.64,546.22]
[865,773.88,549.54]
[870,778.2,552.95000000000005]
[875,782.43,556.26]
[880,786.67,559.59]
[885,790.99,562.99]
[890,795.22,566.30999999999995]
[895,799.55,569.71]
[900,803.03,571.36]
[905,807.35,574.77]
[910,811.59,578.09]
[915,815.9,581.49]
[920,820.06,584.80999999999995]
[925,824.38,588.22]
[930,828.61,591.53]
[935,832.85,594.85]
[940,837.17,598.25]
[945,840.74,599.99]
[950,844.98,603.30999999999995]
[955,849.3,606.72]
[960,853.54,610.04]
[965,857.78,613.37]
[970,862.1,616.76]
[975,866.25,620.09]
[980,870.57,623.48]
[985,874.81,626.80999999999995]
[990,878.38,628.54999999999995]
[995,882.61,631.86]
[1000,886.93,635.27]
[1005,891.17,638.59]
[1010,895.49,641.99]
[1015,899.73,645.30999999999995]
[1020,904.04,648.71]
[1025,908.28,652.03]
[1030,912.52,655.35]
[1035,916,657.08]
[1040,920.32,660.49]
[1045,924.56,663.81]
[1050,928.88,667.21]
[1055,933.13,670.54]
[1060,937.36,673.86]
[1065,941.68,677.26]
[1070,945.92,680.59]
[1075,950.23,683.98]
[1080,953.72,685.64]
[1085,957.96,689.05]
[1090,962.19,692.36]
[1095,966.52,695.77]
[1100,970.75,699.08]
[1105,975.07,702.49]
[1110,979.31,705.81]
[1115,983.54,709.12]
[1120,987.86,712.53]
[1125,991.44,714.27]
[1130,995.67,717.58]
[1135,999.99,720.99]
[1140,1004.22,724.3]
[1145,1008.38,727.63]
[1150,1012.7,731.03]
[1155,1016.94,734.36]
[1160,1021.26,737.76]
[1165,1025.5,741.09]
[1170,1029.07,742.82]
[1175,1033.31,746.14]
[1180,1037.6199999999999,749.54]
[1185,1041.8599999999999,752.86]
[1190,1046.18,756.27]
[1195,1050.4100000000001,759.58]
[1200,1054.6500000000001,762.99]
[1205,1058.8900000000001,766.31]
[1210,1063.1199999999999,769.62]
[1215,1066.7,771.36]
[1220,1071.01,774.76]
[1225,1075.25,778.08]
[1230,1079.57,781.49]
[1235,1083.8,784.8]
[1240,1088.04,788.13]
[1245,1092.3699999999999,791.53]
[1250,1096.5999999999999,794.85]
[1255,1100.93,798.26]
[1260,1104.33,799.91]
[1265,1108.6500000000001,803.32]
[1270,1112.8900000000001,806.64]
[1275,1117.2,810.04]
[1280,1121.44,813.36]
[1285,1125.77,816.77]
[1290,1130,820.08]
[1295,1134.24,823.4]
[1300,1138.55,826.8]
[1305,1142.1199999999999,828.54]
[1310,1146.28,831.86]
[1315,1150.5899999999999,835.26]
[1320,1154.83,838.58]
[1325,1159.07,841.91]
[1330,1163.3900000000001,845.3]
[1335,1167.6300000000001,848.63]
[1340,1171.94,852.02]
[1345,1176.18,855.35]
[1350,1179.75,857.09]
[1355,1183.99,860.41]
[1360,1188.32,863.82]
[1365,1192.56,867.14]
[1370,1196.79,870.54]
[1375,1201.03,873.86]
[1380,1205.3399999999999,877.26]
[1385,1209.58,880.58]
[1390,1213.82,883.9]
[1395,1217.3800000000001,885.63]
[1400,1221.71,889.04]
[1405,1225.95,892.36]
[1410,1230.26,895.76]
[1415,1234.5,899.08]
[1420,1238.73,902.4]
[1425,1242.97,905.8]
[1430,1247.21,909.13]
[1435,1251.52,912.52]
[1440,1255.01,914.18]
[1445,1259.3399999999999,917.59]
[1450,1263.57,920.9]
[1455,1267.9000000000001,924.32]
[1460,1272.1300000000001,927.63]
[1465,1276.45,931.04]
[1470,1280.69,934.36]
[1475,1284.92,937.67]
[1480,1289.25,941.08]
[1485,1292.74,942.82]
[1490,1296.1300000000001,946.13]
[1495,1299.54,949.54]
[1500,1302.8499999999999,952.85]
[1505,1306.18,956.18]
[1510,1309.58,959.58]
[1515,1312.9,962.9]
[1520,1316.3,966.3]
[1525,1319.63,969.63]
[1530,1321.36,971.36]
[1535,1324.68,974.68]
[1540,1328.08,978.08]
[1545,1331.4,981.4]
[1550,1334.81,984.81]
[1555,1338.13,988.13]
[1560,1341.54,991.54]
[1565,1344.86,994.86]
[1570,1348.17,998.17]
[1575,1349.91,999.91]
[1580,1353.31,1003.31]
[1585,1356.63,1006.63]
[1590,1360.04,1010.04]
[1595,1363.35,1013.35]
[1600,1366.68,1016.68]
[1605,1370.08,1020.08]
[1610,1373.4,1023.4]
[1615,1376.8,1026.8]
[1620,1378.45,1028.45]
[1625,1381.86,1031.8599999999999]
[1630,1385.18,1035.18]
[1635,1388.58,1038.58]
[1640,1391.9,1041.9000000000001]
[1645,1394.89,1044.97]
[1650,1397.95,1048.1199999999999]
[1655,1400.95,1051.2]
[1660,1403.93,1054.27]
[1665,1405.01,1055.51]
[1670,1408,1058.58]
[1675,1410.98,1061.6400000000001]
[1680,1414.05,1064.8]
[1685,1416.96,1067.8699999999999]
[1690,1419.94,1070.94]
[1695,1423.01,1074.0899999999999]
[1700,1425.99,1077.1600000000001]
[1705,1428.98,1080.23]
[1710,1430.05,1081.47]
[1715,1433.03,1084.53]
[1720,1436.11,1087.69]
[1725,1439.1,1090.76]
[1730,1442.08,1093.83]
[1735,1445.15,1096.98]
[1740,1448.13,1100.05]
[1745,1451.04,1103.1199999999999]
[1750,1454.11,1106.28]
[1755,1455.1,1107.43]
[1760,1458.17,1110.5899999999999]
[1765,1461.16,1113.6600000000001]
[1770,1464.14,1116.73]
[1775,1467.13,1119.8]
[1780,1470.2,1122.95]
[1785,1473.19,1126.02]
[1790,1476.18,1129.0899999999999]
[1795,1479.24,1132.24]
[1800,1480.15,1133.4000000000001]
[1805,1483.22,1136.55]
[1810,1486.2,1139.6199999999999]
[1815,1489.19,1142.69]
[1820,1492.25,1145.8399999999999]
[1825,1495.24,1148.9100000000001]
[1830,1498.23,1151.98]
[1835,1501.3,1155.1300000000001]
[1840,1504.29,1158.2]
[1845,1505.36,1159.44]
[1850,1508.34,1162.51]
[1860,1514.32,1168.74]
[1870,1520.3,1174.8800000000001]
[1880,1526.35,1181.0999999999999]
[1890,1530.41,1185.4100000000001]
[1900,1536.38,1191.54]
[1910,1542.36,1197.77]
[1920,1548.41,1203.99]
[1930,1554.38,1210.1300000000001]
[1940,1558.43,1214.43]
[1950,1564.5,1220.6600000000001]
[1960,1570.56,1226.8900000000001]
[1970,1576.45,1233.03]
[1980,1580.5,1237.33]
[1990,1586.56,1243.56]
[2000,1592.53,1249.7]
[2010,1598.59,1255.92]
[2020,1604.64,1262.1400000000001]
[2030,1608.62,1266.45]
[2040,1614.59,1272.5899999999999]
[2050,1620.64,1278.81]
[2060,1626.71,1285.04]
[2070,1630.77,1289.3499999999999]
[2080,1636.66,1295.49]
[2090,1642.71,1301.71]
[2100,1648.76,1307.93]
[2110,1654.74,1314.08]
[2120,1658.8,1318.38]
[2130,1664.85,1324.6]
[2140,1670.74,1330.74]
[2150,1676.8,1336.97]
[2160,1680.86,1341.28]
[2170,1686.92,1347.5]
[2180,1692.89,1353.64]
[2190,1698.95,1359.87]
[2200,1704.92,1366.09]
[2210,1708.97,1370.39]
[2220,1714.94,1376.53]
[2230,1721.01,1382.76]
[2240,1726.98,1388.89]
[2250,1730.95,1393.2]
[2260,1737.01,1399.43]
[2270,1743.07,1405.66]
[2280,1749.04,1411.79]
[2290,1755.1,1418.01]
[2300,1759.15,1422.32]
[2310,1765.13,1428.55]
[2320,1771.1,1434.68]
[2330,1777.15,1440.9]
[2340,1781.21,1445.21]
[2350,1787.19,1451.35]
[2360,1793.17,1457.58]
[2370,1799.22,1463.8]
[2380,1805.19,1469.94]
[2390,1809.25,1474.25]
[2400,1815.31,1480.47]
[2410,1821.36,1486.69]
[2420,1827.25,1492.83]
[2430,1831.31,1497.14]
[2440,1837.36,1503.36]
[2450,1843.33,1509.5]
[2460,1849.4,1515.73]
[2470,1855.46,1521.96]
[2480,1859.43,1526.26]
[2490,1865.4,1532.4]
[2500,1871.45,1538.62]
[2510,1877.52,1544.85]
[2520,1881.57,1549.15]
[2530,1887.46,1555.29]
[2540,1893.51,1561.51]
[2550,1899.57,1567.74]
[2560,1905.55,1573.89]
[2570,1909.61,1578.19]
[2580,1915.66,1584.41]
[2590,1921.56,1590.56]
[2600,1927.61,1596.78]
[2610,1931.66,1601.08]
[2620,1937.72,1607.3]
[2630,1943.7,1613.45]
[2640,1949.75,1619.67]
[2650,1955.72,1625.89]
[2660,1959.78,1630.2]
[2670,1965.76,1636.35]
[2680,1971.82,1642.57]
[2690,1977.79,1648.7]
[2700,1981.76,1653.01]
[2710,1987.82,1659.24]
[2720,1993.87,1665.46]
[2730,1999.84,1671.59]
[2740,2005.9,1677.81]
[2750,2009.96,1682.13]
[2760,2015.94,1688.36]
[2770,2021.91,1694.49]
[2780,2027.96,1700.71]
[2790,2032.03,1705.03]
[2800,2038.08,1711.25]
[2810,2044.05,1717.47]
[2820,2050.02,1723.6]
[2830,2056.08,1729.83]
[2840,2060.14,1734.14]
[2850,2066.19,1740.36]
[2860,2072.17,1746.5]
[2870,2078.15,1752.73]
[2880,2082.1999999999998,1757.04]
[2890,2088.17,1763.17]
[2900,2094.23,1769.39]
[2910,2100.29,1775.62]
[2920,2106.2600000000002,1781.76]
[2930,2110.23,1786.06]
[2940,2116.2800000000002,1792.28]
[2950,2122.35,1798.51]
[2960,2128.33,1804.66]
[2970,2132.38,1808.96]
[2980,2138.35,1815.18]
[2990,2144.33,1821.33]
[3000,2150.38,1827.55]
[3025,2163.48,1841.15]
[3050,2178.4899999999998,1856.66]
[3075,2191.6,1870.27]
[3100,2206.5300000000002,1885.7]
[3125,2219.64,1899.3]
[3150,2232.3200000000002,1912.9]
[3175,2246.5100000000002,1928.42]
[3200,2258.35,1941.94]
[3225,2272.37,1957.45]
[3250,2284.3000000000002,1971.05]
[3275,2298.3200000000002,1986.57]
[3300,2310.25,2000.17]
[3325,2324.27,2015.61]
[3350,2336.1999999999998,2029.2]
[3375,2348.06,2042.81]
[3400,2362.16,2058.3200000000002]
[3425,2374,2071.84]
[3450,2388.02,2087.35]
[3475,2399.96,2100.96]
[3500,2414.0500000000002,2116.4699999999998]
[3525,2425.9899999999998,2130.08]
[3550,2439.92,2145.5100000000002]
[3575,2451.86,2159.11]
[3600,2463.71,2172.71]
[3650,2489.65,2201.7399999999998]
[3700,2515.69,2230.86]
[3750,2541.64,2259.98]
[3800,2567.5100000000002,2289.0100000000002]
[3850,2593.54,2318.12]
[3900,2619.41,2347.16]
[3950,2645.36,2376.2800000000002]
[4000,2671.32,2405.3200000000002]
[4100,2725.4901960784314]
[4200,2779.4117647058824,2548.81]
[4300,2830.3921568627452]
[4400,2881.372549019608]
[4600,2981.372549019608,2692.9]
[4700,3032.3529411764707]
[4800,3085.2941176470586,2835.32]
[4900,3128.4313725490197]
[5000,3203.58]
[5100,3213.7254901960782]
[5200,3256.8627450980393,2954.32]
[5300,3300.9803921568628]
[5400,3342.1568627450979]
[5600,3429.4117647058824]
[5700,3473.5294117647059]
[5800,3516.6666666666665,3194.57]
[5900,3557.8431372549021]
[6100,3645.0980392156862]
[6200,3689.2156862745096]
[6300,3730.3921568627452]
[6400,3774.5098039215686,3434.82]
[6500,3817.6470588235293]
[6600,3861.7647058823527]
[6700,3904.9019607843138]
[6800,3946.0784313725489]
[6900,3990.1960784313724]
[7100,4101.5779092702169]
[7200,4142.998027613412]
[7300,4187.3767258382641]
[7400,4230.7692307692305]
[7500,4275.1479289940826,3913.99]
[7600,4318.540433925049,4393.99]
[7700,4359.9605522682441,4873.99]
[7800,4404.3392504930962,5353.99]
[7900,4447.7317554240626]
[8100,4597.58]
[8200,4642.17]
[8300,4686.67]
[8400,4729.93]
[8500,4777.93]
[8600,4825.93]
[8700,4873.93]
[8800,4921.93]
[8900,4969.93]
[9100,5065.93]
[9200,5113.93]
[9300,5161.93]
[9400,5209.93]
[9500,5257.93]
[9600,5303.93]
[9700,5353.93]
[9800,5401.93]
[9900,5449.93]
[10500,5737.93]
[11000,5977.93]
[11500,6217.93]
[12000,6457.93]
[12500,6697.93]
[13000,6937.93]
[13500,7177.93]
[14000,7417.93]
[14500,7657.93]
[15000,7897.93]

{"sheet":"Print","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,2,4],[36,1,40,4],[32,1,32,4],[31,1,31,4],[30,1,30,4],[8,1,9,4],[29,1,29,4],[33,1,33,4],[34,1,34,4],[5,1,5,4],[6,1,6,4],[28,1,28,3]]}
[]
[]
[]
[]
[null,"Cliënt(en):"]
[null,{"$f":"IF(Input!D7<>\"\",Input!D7,\"\")","v":""}]
[null,{"$f":"IF(Input!G7<>\"\",Input!G7,\"\")","v":""}]
[]
[null,"Verantwoord Krediet Maximum"]
[]
[]
[null,"Inkomsten"]
[null,"Netto inkomen*",{"$f":"Input!D63","v":{"$error":"#N/A"}}]
[null,"Netto inkomen partner*",{"$f":"IF(Input!D9=\"Alleenstaand\",0,IF(Input!D9=\"Alleenstaand met kind(eren)\",0,Input!E63))","v":{"$error":"#N/A"}}]
[null,"Totaal netto inkomen",null,{"$f":"C14+C13","v":{"$error":"#N/A"}}]
[]
[null,"Uitgaven"]
[null,"Woonlasten**",{"$f":"Input!D70","v":{"$error":"#N/A"}}]
[null,"Norm levensonderhoud",{"$f":"Input!H47","v":{"$error":"#N/A"}}]
[null,"Te betalen alimentatie",{"$f":"Input!D73","v":0}]
[null,"Bestaande financieringen (niet inlossen)***",{"$f":"Input!D74+Input!D75+Input!D76","v":0}]
[null,"Totale uitgaven",null,{"$f":"SUM(C18:C21)","v":{"$error":"#N/A"}}]
[]
[null,"Aflossingscapaciteit",null,{"$f":"IF(D15-D22<50,0,D15-D22)","v":{"$error":"#N/A"}}]
[]
[null,"Verantwoord Krediet Maximum",null,{"$f":"IF(D24*50>2500,D24*50,0)","v":{"$error":"#N/A"}}]
[]
[]
[null,"* Indicatie netto inkomen a.d.h.v. Roos & Roos vermenigvuldigt met factor (afhankelijk type inkomen)"]
[null,"** In geval van:"]
[null,"o Koopwoning; 70% of 75% bruto hypotheeklasten."]
[null,"o Huurwoning; kale huurlast met minimum van €300,-."]
[null,"o Inwonend; 33% van het netto inkomen."]
[null,"*** Naastlopende financieringen (DK, RK, VK etc) worden genormeerd op 2% van de kredietlimiet"]
[null,"*** Een persoonlijke lening wordt genormeerd op de werkelijke maandlast"]
[]
[null,"Let op! Deze berekening betreft een indicatie en er kunnen derhalve geen rechten aan worden ontleend. Neem bij twijfel contact op met Financium via 088 828 22 88."]