6,070 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 1,150,000 ש״ח ל-25 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
מיליון ומאה וחמישים אלף שקלים לתקופה של עשרים וחמש שנה בריבית של
4% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
6,070 ש"ח
671,037 ש"ח
1,821,037 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 1,147,763 | ₪ 2,237 | ₪ 3,833 | ₪ 6,070 | ₪ 6,070 |
| 2 | ₪ 1,145,519 | ₪ 2,244 | ₪ 3,826 | ₪ 6,070 | ₪ 12,140 |
| 3 | ₪ 1,143,267 | ₪ 2,252 | ₪ 3,818 | ₪ 6,070 | ₪ 18,210 |
| 4 | ₪ 1,141,008 | ₪ 2,259 | ₪ 3,811 | ₪ 6,070 | ₪ 24,280 |
| 5 | ₪ 1,138,741 | ₪ 2,267 | ₪ 3,803 | ₪ 6,070 | ₪ 30,351 |
| 6 | ₪ 1,136,467 | ₪ 2,274 | ₪ 3,796 | ₪ 6,070 | ₪ 36,421 |
| 7 | ₪ 1,134,185 | ₪ 2,282 | ₪ 3,788 | ₪ 6,070 | ₪ 42,491 |
| 8 | ₪ 1,131,896 | ₪ 2,290 | ₪ 3,781 | ₪ 6,070 | ₪ 48,561 |
| 9 | ₪ 1,129,598 | ₪ 2,297 | ₪ 3,773 | ₪ 6,070 | ₪ 54,631 |
| 10 | ₪ 1,127,294 | ₪ 2,305 | ₪ 3,765 | ₪ 6,070 | ₪ 60,701 |
| 11 | ₪ 1,124,981 | ₪ 2,312 | ₪ 3,758 | ₪ 6,070 | ₪ 66,771 |
| 12 | ₪ 1,122,661 | ₪ 2,320 | ₪ 3,750 | ₪ 6,070 | ₪ 72,841 |
| 13 | ₪ 1,120,333 | ₪ 2,328 | ₪ 3,742 | ₪ 6,070 | ₪ 78,912 |
| 14 | ₪ 1,117,997 | ₪ 2,336 | ₪ 3,734 | ₪ 6,070 | ₪ 84,982 |
| 15 | ₪ 1,115,654 | ₪ 2,343 | ₪ 3,727 | ₪ 6,070 | ₪ 91,052 |
| 16 | ₪ 1,113,303 | ₪ 2,351 | ₪ 3,719 | ₪ 6,070 | ₪ 97,122 |
| 17 | ₪ 1,110,943 | ₪ 2,359 | ₪ 3,711 | ₪ 6,070 | ₪ 103,192 |
| 18 | ₪ 1,108,576 | ₪ 2,367 | ₪ 3,703 | ₪ 6,070 | ₪ 109,262 |
| 19 | ₪ 1,106,202 | ₪ 2,375 | ₪ 3,695 | ₪ 6,070 | ₪ 115,332 |
| 20 | ₪ 1,103,819 | ₪ 2,383 | ₪ 3,687 | ₪ 6,070 | ₪ 121,402 |
| 21 | ₪ 1,101,428 | ₪ 2,391 | ₪ 3,679 | ₪ 6,070 | ₪ 127,473 |
| 22 | ₪ 1,099,029 | ₪ 2,399 | ₪ 3,671 | ₪ 6,070 | ₪ 133,543 |
| 23 | ₪ 1,096,623 | ₪ 2,407 | ₪ 3,663 | ₪ 6,070 | ₪ 139,613 |
| 24 | ₪ 1,094,208 | ₪ 2,415 | ₪ 3,655 | ₪ 6,070 | ₪ 145,683 |
| 25 | ₪ 1,091,785 | ₪ 2,423 | ₪ 3,647 | ₪ 6,070 | ₪ 151,753 |
| 26 | ₪ 1,089,354 | ₪ 2,431 | ₪ 3,639 | ₪ 6,070 | ₪ 157,823 |
| 27 | ₪ 1,086,915 | ₪ 2,439 | ₪ 3,631 | ₪ 6,070 | ₪ 163,893 |
| 28 | ₪ 1,084,468 | ₪ 2,447 | ₪ 3,623 | ₪ 6,070 | ₪ 169,963 |
| 29 | ₪ 1,082,013 | ₪ 2,455 | ₪ 3,615 | ₪ 6,070 | ₪ 176,034 |
| 30 | ₪ 1,079,550 | ₪ 2,463 | ₪ 3,607 | ₪ 6,070 | ₪ 182,104 |
| 31 | ₪ 1,077,078 | ₪ 2,472 | ₪ 3,598 | ₪ 6,070 | ₪ 188,174 |
| 32 | ₪ 1,074,598 | ₪ 2,480 | ₪ 3,590 | ₪ 6,070 | ₪ 194,244 |
| 33 | ₪ 1,072,110 | ₪ 2,488 | ₪ 3,582 | ₪ 6,070 | ₪ 200,314 |
| 34 | ₪ 1,069,614 | ₪ 2,496 | ₪ 3,574 | ₪ 6,070 | ₪ 206,384 |
| 35 | ₪ 1,067,109 | ₪ 2,505 | ₪ 3,565 | ₪ 6,070 | ₪ 212,454 |
| 36 | ₪ 1,064,596 | ₪ 2,513 | ₪ 3,557 | ₪ 6,070 | ₪ 218,524 |
| 37 | ₪ 1,062,074 | ₪ 2,521 | ₪ 3,549 | ₪ 6,070 | ₪ 224,595 |
| 38 | ₪ 1,059,545 | ₪ 2,530 | ₪ 3,540 | ₪ 6,070 | ₪ 230,665 |
| 39 | ₪ 1,057,006 | ₪ 2,538 | ₪ 3,532 | ₪ 6,070 | ₪ 236,735 |
| 40 | ₪ 1,054,459 | ₪ 2,547 | ₪ 3,523 | ₪ 6,070 | ₪ 242,805 |
| 41 | ₪ 1,051,904 | ₪ 2,555 | ₪ 3,515 | ₪ 6,070 | ₪ 248,875 |
| 42 | ₪ 1,049,340 | ₪ 2,564 | ₪ 3,506 | ₪ 6,070 | ₪ 254,945 |
| 43 | ₪ 1,046,768 | ₪ 2,572 | ₪ 3,498 | ₪ 6,070 | ₪ 261,015 |
| 44 | ₪ 1,044,187 | ₪ 2,581 | ₪ 3,489 | ₪ 6,070 | ₪ 267,085 |
| 45 | ₪ 1,041,598 | ₪ 2,589 | ₪ 3,481 | ₪ 6,070 | ₪ 273,156 |
| 46 | ₪ 1,039,000 | ₪ 2,598 | ₪ 3,472 | ₪ 6,070 | ₪ 279,226 |
| 47 | ₪ 1,036,393 | ₪ 2,607 | ₪ 3,463 | ₪ 6,070 | ₪ 285,296 |
| 48 | ₪ 1,033,777 | ₪ 2,615 | ₪ 3,455 | ₪ 6,070 | ₪ 291,366 |
| 49 | ₪ 1,031,153 | ₪ 2,624 | ₪ 3,446 | ₪ 6,070 | ₪ 297,436 |
| 50 | ₪ 1,028,520 | ₪ 2,633 | ₪ 3,437 | ₪ 6,070 | ₪ 303,506 |
| 51 | ₪ 1,025,878 | ₪ 2,642 | ₪ 3,428 | ₪ 6,070 | ₪ 309,576 |
| 52 | ₪ 1,023,228 | ₪ 2,651 | ₪ 3,420 | ₪ 6,070 | ₪ 315,646 |
| 53 | ₪ 1,020,569 | ₪ 2,659 | ₪ 3,411 | ₪ 6,070 | ₪ 321,717 |
| 54 | ₪ 1,017,900 | ₪ 2,668 | ₪ 3,402 | ₪ 6,070 | ₪ 327,787 |
| 55 | ₪ 1,015,223 | ₪ 2,677 | ₪ 3,393 | ₪ 6,070 | ₪ 333,857 |
| 56 | ₪ 1,012,537 | ₪ 2,686 | ₪ 3,384 | ₪ 6,070 | ₪ 339,927 |
| 57 | ₪ 1,009,842 | ₪ 2,695 | ₪ 3,375 | ₪ 6,070 | ₪ 345,997 |
| 58 | ₪ 1,007,138 | ₪ 2,704 | ₪ 3,366 | ₪ 6,070 | ₪ 352,067 |
| 59 | ₪ 1,004,425 | ₪ 2,713 | ₪ 3,357 | ₪ 6,070 | ₪ 358,137 |
| 60 | ₪ 1,001,703 | ₪ 2,722 | ₪ 3,348 | ₪ 6,070 | ₪ 364,207 |
| 61 | ₪ 998,972 | ₪ 2,731 | ₪ 3,339 | ₪ 6,070 | ₪ 370,278 |
| 62 | ₪ 996,232 | ₪ 2,740 | ₪ 3,330 | ₪ 6,070 | ₪ 376,348 |
| 63 | ₪ 993,482 | ₪ 2,749 | ₪ 3,321 | ₪ 6,070 | ₪ 382,418 |
| 64 | ₪ 990,724 | ₪ 2,759 | ₪ 3,312 | ₪ 6,070 | ₪ 388,488 |
| 65 | ₪ 987,956 | ₪ 2,768 | ₪ 3,302 | ₪ 6,070 | ₪ 394,558 |
| 66 | ₪ 985,179 | ₪ 2,777 | ₪ 3,293 | ₪ 6,070 | ₪ 400,628 |
| 67 | ₪ 982,393 | ₪ 2,786 | ₪ 3,284 | ₪ 6,070 | ₪ 406,698 |
| 68 | ₪ 979,598 | ₪ 2,795 | ₪ 3,275 | ₪ 6,070 | ₪ 412,768 |
| 69 | ₪ 976,793 | ₪ 2,805 | ₪ 3,265 | ₪ 6,070 | ₪ 418,839 |
| 70 | ₪ 973,979 | ₪ 2,814 | ₪ 3,256 | ₪ 6,070 | ₪ 424,909 |
| 71 | ₪ 971,155 | ₪ 2,824 | ₪ 3,247 | ₪ 6,070 | ₪ 430,979 |
| 72 | ₪ 968,322 | ₪ 2,833 | ₪ 3,237 | ₪ 6,070 | ₪ 437,049 |
| 73 | ₪ 965,480 | ₪ 2,842 | ₪ 3,228 | ₪ 6,070 | ₪ 443,119 |
| 74 | ₪ 962,628 | ₪ 2,852 | ₪ 3,218 | ₪ 6,070 | ₪ 449,189 |
| 75 | ₪ 959,767 | ₪ 2,861 | ₪ 3,209 | ₪ 6,070 | ₪ 455,259 |
| 76 | ₪ 956,896 | ₪ 2,871 | ₪ 3,199 | ₪ 6,070 | ₪ 461,329 |
| 77 | ₪ 954,015 | ₪ 2,880 | ₪ 3,190 | ₪ 6,070 | ₪ 467,400 |
| 78 | ₪ 951,125 | ₪ 2,890 | ₪ 3,180 | ₪ 6,070 | ₪ 473,470 |
| 79 | ₪ 948,225 | ₪ 2,900 | ₪ 3,170 | ₪ 6,070 | ₪ 479,540 |
| 80 | ₪ 945,316 | ₪ 2,909 | ₪ 3,161 | ₪ 6,070 | ₪ 485,610 |
| 81 | ₪ 942,397 | ₪ 2,919 | ₪ 3,151 | ₪ 6,070 | ₪ 491,680 |
| 82 | ₪ 939,468 | ₪ 2,929 | ₪ 3,141 | ₪ 6,070 | ₪ 497,750 |
| 83 | ₪ 936,530 | ₪ 2,939 | ₪ 3,132 | ₪ 6,070 | ₪ 503,820 |
| 84 | ₪ 933,581 | ₪ 2,948 | ₪ 3,122 | ₪ 6,070 | ₪ 509,890 |
| 85 | ₪ 930,623 | ₪ 2,958 | ₪ 3,112 | ₪ 6,070 | ₪ 515,961 |
| 86 | ₪ 927,655 | ₪ 2,968 | ₪ 3,102 | ₪ 6,070 | ₪ 522,031 |
| 87 | ₪ 924,677 | ₪ 2,978 | ₪ 3,092 | ₪ 6,070 | ₪ 528,101 |
| 88 | ₪ 921,689 | ₪ 2,988 | ₪ 3,082 | ₪ 6,070 | ₪ 534,171 |
| 89 | ₪ 918,691 | ₪ 2,998 | ₪ 3,072 | ₪ 6,070 | ₪ 540,241 |
| 90 | ₪ 915,684 | ₪ 3,008 | ₪ 3,062 | ₪ 6,070 | ₪ 546,311 |
| 91 | ₪ 912,666 | ₪ 3,018 | ₪ 3,052 | ₪ 6,070 | ₪ 552,381 |
| 92 | ₪ 909,638 | ₪ 3,028 | ₪ 3,042 | ₪ 6,070 | ₪ 558,451 |
| 93 | ₪ 906,600 | ₪ 3,038 | ₪ 3,032 | ₪ 6,070 | ₪ 564,522 |
| 94 | ₪ 903,552 | ₪ 3,048 | ₪ 3,022 | ₪ 6,070 | ₪ 570,592 |
| 95 | ₪ 900,493 | ₪ 3,058 | ₪ 3,012 | ₪ 6,070 | ₪ 576,662 |
| 96 | ₪ 897,425 | ₪ 3,068 | ₪ 3,002 | ₪ 6,070 | ₪ 582,732 |
| 97 | ₪ 894,346 | ₪ 3,079 | ₪ 2,991 | ₪ 6,070 | ₪ 588,802 |
| 98 | ₪ 891,257 | ₪ 3,089 | ₪ 2,981 | ₪ 6,070 | ₪ 594,872 |
| 99 | ₪ 888,158 | ₪ 3,099 | ₪ 2,971 | ₪ 6,070 | ₪ 600,942 |
| 100 | ₪ 885,048 | ₪ 3,110 | ₪ 2,961 | ₪ 6,070 | ₪ 607,012 |
| 101 | ₪ 881,928 | ₪ 3,120 | ₪ 2,950 | ₪ 6,070 | ₪ 613,082 |
| 102 | ₪ 878,798 | ₪ 3,130 | ₪ 2,940 | ₪ 6,070 | ₪ 619,153 |
| 103 | ₪ 875,657 | ₪ 3,141 | ₪ 2,929 | ₪ 6,070 | ₪ 625,223 |
| 104 | ₪ 872,506 | ₪ 3,151 | ₪ 2,919 | ₪ 6,070 | ₪ 631,293 |
| 105 | ₪ 869,344 | ₪ 3,162 | ₪ 2,908 | ₪ 6,070 | ₪ 637,363 |
| 106 | ₪ 866,172 | ₪ 3,172 | ₪ 2,898 | ₪ 6,070 | ₪ 643,433 |
| 107 | ₪ 862,989 | ₪ 3,183 | ₪ 2,887 | ₪ 6,070 | ₪ 649,503 |
| 108 | ₪ 859,796 | ₪ 3,193 | ₪ 2,877 | ₪ 6,070 | ₪ 655,573 |
| 109 | ₪ 856,591 | ₪ 3,204 | ₪ 2,866 | ₪ 6,070 | ₪ 661,643 |
| 110 | ₪ 853,377 | ₪ 3,215 | ₪ 2,855 | ₪ 6,070 | ₪ 667,714 |
| 111 | ₪ 850,151 | ₪ 3,226 | ₪ 2,845 | ₪ 6,070 | ₪ 673,784 |
| 112 | ₪ 846,915 | ₪ 3,236 | ₪ 2,834 | ₪ 6,070 | ₪ 679,854 |
| 113 | ₪ 843,668 | ₪ 3,247 | ₪ 2,823 | ₪ 6,070 | ₪ 685,924 |
| 114 | ₪ 840,410 | ₪ 3,258 | ₪ 2,812 | ₪ 6,070 | ₪ 691,994 |
| 115 | ₪ 837,141 | ₪ 3,269 | ₪ 2,801 | ₪ 6,070 | ₪ 698,064 |
| 116 | ₪ 833,861 | ₪ 3,280 | ₪ 2,790 | ₪ 6,070 | ₪ 704,134 |
| 117 | ₪ 830,571 | ₪ 3,291 | ₪ 2,780 | ₪ 6,070 | ₪ 710,204 |
| 118 | ₪ 827,269 | ₪ 3,302 | ₪ 2,769 | ₪ 6,070 | ₪ 716,275 |
| 119 | ₪ 823,957 | ₪ 3,313 | ₪ 2,758 | ₪ 6,070 | ₪ 722,345 |
| 120 | ₪ 820,633 | ₪ 3,324 | ₪ 2,747 | ₪ 6,070 | ₪ 728,415 |
| 121 | ₪ 817,298 | ₪ 3,335 | ₪ 2,735 | ₪ 6,070 | ₪ 734,485 |
| 122 | ₪ 813,953 | ₪ 3,346 | ₪ 2,724 | ₪ 6,070 | ₪ 740,555 |
| 123 | ₪ 810,596 | ₪ 3,357 | ₪ 2,713 | ₪ 6,070 | ₪ 746,625 |
| 124 | ₪ 807,227 | ₪ 3,368 | ₪ 2,702 | ₪ 6,070 | ₪ 752,695 |
| 125 | ₪ 803,848 | ₪ 3,379 | ₪ 2,691 | ₪ 6,070 | ₪ 758,765 |
| 126 | ₪ 800,458 | ₪ 3,391 | ₪ 2,679 | ₪ 6,070 | ₪ 764,836 |
| 127 | ₪ 797,056 | ₪ 3,402 | ₪ 2,668 | ₪ 6,070 | ₪ 770,906 |
| 128 | ₪ 793,642 | ₪ 3,413 | ₪ 2,657 | ₪ 6,070 | ₪ 776,976 |
| 129 | ₪ 790,218 | ₪ 3,425 | ₪ 2,645 | ₪ 6,070 | ₪ 783,046 |
| 130 | ₪ 786,782 | ₪ 3,436 | ₪ 2,634 | ₪ 6,070 | ₪ 789,116 |
| 131 | ₪ 783,334 | ₪ 3,448 | ₪ 2,623 | ₪ 6,070 | ₪ 795,186 |
| 132 | ₪ 779,875 | ₪ 3,459 | ₪ 2,611 | ₪ 6,070 | ₪ 801,256 |
| 133 | ₪ 776,405 | ₪ 3,471 | ₪ 2,600 | ₪ 6,070 | ₪ 807,326 |
| 134 | ₪ 772,922 | ₪ 3,482 | ₪ 2,588 | ₪ 6,070 | ₪ 813,397 |
| 135 | ₪ 769,429 | ₪ 3,494 | ₪ 2,576 | ₪ 6,070 | ₪ 819,467 |
| 136 | ₪ 765,923 | ₪ 3,505 | ₪ 2,565 | ₪ 6,070 | ₪ 825,537 |
| 137 | ₪ 762,406 | ₪ 3,517 | ₪ 2,553 | ₪ 6,070 | ₪ 831,607 |
| 138 | ₪ 758,878 | ₪ 3,529 | ₪ 2,541 | ₪ 6,070 | ₪ 837,677 |
| 139 | ₪ 755,337 | ₪ 3,541 | ₪ 2,530 | ₪ 6,070 | ₪ 843,747 |
| 140 | ₪ 751,785 | ₪ 3,552 | ₪ 2,518 | ₪ 6,070 | ₪ 849,817 |
| 141 | ₪ 748,220 | ₪ 3,564 | ₪ 2,506 | ₪ 6,070 | ₪ 855,887 |
| 142 | ₪ 744,644 | ₪ 3,576 | ₪ 2,494 | ₪ 6,070 | ₪ 861,958 |
| 143 | ₪ 741,056 | ₪ 3,588 | ₪ 2,482 | ₪ 6,070 | ₪ 868,028 |
| 144 | ₪ 737,457 | ₪ 3,600 | ₪ 2,470 | ₪ 6,070 | ₪ 874,098 |
| 145 | ₪ 733,845 | ₪ 3,612 | ₪ 2,458 | ₪ 6,070 | ₪ 880,168 |
| 146 | ₪ 730,221 | ₪ 3,624 | ₪ 2,446 | ₪ 6,070 | ₪ 886,238 |
| 147 | ₪ 726,585 | ₪ 3,636 | ₪ 2,434 | ₪ 6,070 | ₪ 892,308 |
| 148 | ₪ 722,936 | ₪ 3,648 | ₪ 2,422 | ₪ 6,070 | ₪ 898,378 |
| 149 | ₪ 719,276 | ₪ 3,660 | ₪ 2,410 | ₪ 6,070 | ₪ 904,448 |
| 150 | ₪ 715,603 | ₪ 3,673 | ₪ 2,398 | ₪ 6,070 | ₪ 910,519 |
| 151 | ₪ 711,919 | ₪ 3,685 | ₪ 2,385 | ₪ 6,070 | ₪ 916,589 |
| 152 | ₪ 708,222 | ₪ 3,697 | ₪ 2,373 | ₪ 6,070 | ₪ 922,659 |
| 153 | ₪ 704,512 | ₪ 3,709 | ₪ 2,361 | ₪ 6,070 | ₪ 928,729 |
| 154 | ₪ 700,791 | ₪ 3,722 | ₪ 2,348 | ₪ 6,070 | ₪ 934,799 |
| 155 | ₪ 697,056 | ₪ 3,734 | ₪ 2,336 | ₪ 6,070 | ₪ 940,869 |
| 156 | ₪ 693,310 | ₪ 3,747 | ₪ 2,324 | ₪ 6,070 | ₪ 946,939 |
| 157 | ₪ 689,551 | ₪ 3,759 | ₪ 2,311 | ₪ 6,070 | ₪ 953,009 |
| 158 | ₪ 685,779 | ₪ 3,772 | ₪ 2,299 | ₪ 6,070 | ₪ 959,080 |
| 159 | ₪ 681,995 | ₪ 3,784 | ₪ 2,286 | ₪ 6,070 | ₪ 965,150 |
| 160 | ₪ 678,198 | ₪ 3,797 | ₪ 2,273 | ₪ 6,070 | ₪ 971,220 |
| 161 | ₪ 674,389 | ₪ 3,809 | ₪ 2,261 | ₪ 6,070 | ₪ 977,290 |
| 162 | ₪ 670,566 | ₪ 3,822 | ₪ 2,248 | ₪ 6,070 | ₪ 983,360 |
| 163 | ₪ 666,732 | ₪ 3,835 | ₪ 2,235 | ₪ 6,070 | ₪ 989,430 |
| 164 | ₪ 662,884 | ₪ 3,848 | ₪ 2,222 | ₪ 6,070 | ₪ 995,500 |
| 165 | ₪ 659,023 | ₪ 3,861 | ₪ 2,210 | ₪ 6,070 | ₪ 1,001,570 |
| 166 | ₪ 655,150 | ₪ 3,873 | ₪ 2,197 | ₪ 6,070 | ₪ 1,007,641 |
| 167 | ₪ 651,264 | ₪ 3,886 | ₪ 2,184 | ₪ 6,070 | ₪ 1,013,711 |
| 168 | ₪ 647,364 | ₪ 3,899 | ₪ 2,171 | ₪ 6,070 | ₪ 1,019,781 |
| 169 | ₪ 643,452 | ₪ 3,912 | ₪ 2,158 | ₪ 6,070 | ₪ 1,025,851 |
| 170 | ₪ 639,527 | ₪ 3,925 | ₪ 2,145 | ₪ 6,070 | ₪ 1,031,921 |
| 171 | ₪ 635,589 | ₪ 3,938 | ₪ 2,132 | ₪ 6,070 | ₪ 1,037,991 |
| 172 | ₪ 631,637 | ₪ 3,951 | ₪ 2,119 | ₪ 6,070 | ₪ 1,044,061 |
| 173 | ₪ 627,672 | ₪ 3,965 | ₪ 2,105 | ₪ 6,070 | ₪ 1,050,131 |
| 174 | ₪ 623,694 | ₪ 3,978 | ₪ 2,092 | ₪ 6,070 | ₪ 1,056,202 |
| 175 | ₪ 619,703 | ₪ 3,991 | ₪ 2,079 | ₪ 6,070 | ₪ 1,062,272 |
| 176 | ₪ 615,699 | ₪ 4,004 | ₪ 2,066 | ₪ 6,070 | ₪ 1,068,342 |
| 177 | ₪ 611,681 | ₪ 4,018 | ₪ 2,052 | ₪ 6,070 | ₪ 1,074,412 |
| 178 | ₪ 607,650 | ₪ 4,031 | ₪ 2,039 | ₪ 6,070 | ₪ 1,080,482 |
| 179 | ₪ 603,605 | ₪ 4,045 | ₪ 2,025 | ₪ 6,070 | ₪ 1,086,552 |
| 180 | ₪ 599,547 | ₪ 4,058 | ₪ 2,012 | ₪ 6,070 | ₪ 1,092,622 |
| 181 | ₪ 595,476 | ₪ 4,072 | ₪ 1,998 | ₪ 6,070 | ₪ 1,098,692 |
| 182 | ₪ 591,390 | ₪ 4,085 | ₪ 1,985 | ₪ 6,070 | ₪ 1,104,763 |
| 183 | ₪ 587,292 | ₪ 4,099 | ₪ 1,971 | ₪ 6,070 | ₪ 1,110,833 |
| 184 | ₪ 583,179 | ₪ 4,112 | ₪ 1,958 | ₪ 6,070 | ₪ 1,116,903 |
| 185 | ₪ 579,053 | ₪ 4,126 | ₪ 1,944 | ₪ 6,070 | ₪ 1,122,973 |
| 186 | ₪ 574,913 | ₪ 4,140 | ₪ 1,930 | ₪ 6,070 | ₪ 1,129,043 |
| 187 | ₪ 570,759 | ₪ 4,154 | ₪ 1,916 | ₪ 6,070 | ₪ 1,135,113 |
| 188 | ₪ 566,592 | ₪ 4,168 | ₪ 1,903 | ₪ 6,070 | ₪ 1,141,183 |
| 189 | ₪ 562,410 | ₪ 4,181 | ₪ 1,889 | ₪ 6,070 | ₪ 1,147,253 |
| 190 | ₪ 558,215 | ₪ 4,195 | ₪ 1,875 | ₪ 6,070 | ₪ 1,153,323 |
| 191 | ₪ 554,005 | ₪ 4,209 | ₪ 1,861 | ₪ 6,070 | ₪ 1,159,394 |
| 192 | ₪ 549,782 | ₪ 4,223 | ₪ 1,847 | ₪ 6,070 | ₪ 1,165,464 |
| 193 | ₪ 545,544 | ₪ 4,238 | ₪ 1,833 | ₪ 6,070 | ₪ 1,171,534 |
| 194 | ₪ 541,293 | ₪ 4,252 | ₪ 1,818 | ₪ 6,070 | ₪ 1,177,604 |
| 195 | ₪ 537,027 | ₪ 4,266 | ₪ 1,804 | ₪ 6,070 | ₪ 1,183,674 |
| 196 | ₪ 532,747 | ₪ 4,280 | ₪ 1,790 | ₪ 6,070 | ₪ 1,189,744 |
| 197 | ₪ 528,452 | ₪ 4,294 | ₪ 1,776 | ₪ 6,070 | ₪ 1,195,814 |
| 198 | ₪ 524,144 | ₪ 4,309 | ₪ 1,762 | ₪ 6,070 | ₪ 1,201,884 |
| 199 | ₪ 519,821 | ₪ 4,323 | ₪ 1,747 | ₪ 6,070 | ₪ 1,207,955 |
| 200 | ₪ 515,484 | ₪ 4,337 | ₪ 1,733 | ₪ 6,070 | ₪ 1,214,025 |
| 201 | ₪ 511,132 | ₪ 4,352 | ₪ 1,718 | ₪ 6,070 | ₪ 1,220,095 |
| 202 | ₪ 506,765 | ₪ 4,366 | ₪ 1,704 | ₪ 6,070 | ₪ 1,226,165 |
| 203 | ₪ 502,384 | ₪ 4,381 | ₪ 1,689 | ₪ 6,070 | ₪ 1,232,235 |
| 204 | ₪ 497,989 | ₪ 4,396 | ₪ 1,675 | ₪ 6,070 | ₪ 1,238,305 |
| 205 | ₪ 493,579 | ₪ 4,410 | ₪ 1,660 | ₪ 6,070 | ₪ 1,244,375 |
| 206 | ₪ 489,154 | ₪ 4,425 | ₪ 1,645 | ₪ 6,070 | ₪ 1,250,445 |
| 207 | ₪ 484,714 | ₪ 4,440 | ₪ 1,631 | ₪ 6,070 | ₪ 1,256,516 |
| 208 | ₪ 480,260 | ₪ 4,454 | ₪ 1,616 | ₪ 6,070 | ₪ 1,262,586 |
| 209 | ₪ 475,791 | ₪ 4,469 | ₪ 1,601 | ₪ 6,070 | ₪ 1,268,656 |
| 210 | ₪ 471,306 | ₪ 4,484 | ₪ 1,586 | ₪ 6,070 | ₪ 1,274,726 |
| 211 | ₪ 466,807 | ₪ 4,499 | ₪ 1,571 | ₪ 6,070 | ₪ 1,280,796 |
| 212 | ₪ 462,293 | ₪ 4,514 | ₪ 1,556 | ₪ 6,070 | ₪ 1,286,866 |
| 213 | ₪ 457,764 | ₪ 4,529 | ₪ 1,541 | ₪ 6,070 | ₪ 1,292,936 |
| 214 | ₪ 453,220 | ₪ 4,544 | ₪ 1,526 | ₪ 6,070 | ₪ 1,299,006 |
| 215 | ₪ 448,660 | ₪ 4,559 | ₪ 1,511 | ₪ 6,070 | ₪ 1,305,077 |
| 216 | ₪ 444,086 | ₪ 4,575 | ₪ 1,496 | ₪ 6,070 | ₪ 1,311,147 |
| 217 | ₪ 439,496 | ₪ 4,590 | ₪ 1,480 | ₪ 6,070 | ₪ 1,317,217 |
| 218 | ₪ 434,891 | ₪ 4,605 | ₪ 1,465 | ₪ 6,070 | ₪ 1,323,287 |
| 219 | ₪ 430,270 | ₪ 4,620 | ₪ 1,450 | ₪ 6,070 | ₪ 1,329,357 |
| 220 | ₪ 425,635 | ₪ 4,636 | ₪ 1,434 | ₪ 6,070 | ₪ 1,335,427 |
| 221 | ₪ 420,983 | ₪ 4,651 | ₪ 1,419 | ₪ 6,070 | ₪ 1,341,497 |
| 222 | ₪ 416,316 | ₪ 4,667 | ₪ 1,403 | ₪ 6,070 | ₪ 1,347,567 |
| 223 | ₪ 411,634 | ₪ 4,682 | ₪ 1,388 | ₪ 6,070 | ₪ 1,353,638 |
| 224 | ₪ 406,936 | ₪ 4,698 | ₪ 1,372 | ₪ 6,070 | ₪ 1,359,708 |
| 225 | ₪ 402,222 | ₪ 4,714 | ₪ 1,356 | ₪ 6,070 | ₪ 1,365,778 |
| 226 | ₪ 397,493 | ₪ 4,729 | ₪ 1,341 | ₪ 6,070 | ₪ 1,371,848 |
| 227 | ₪ 392,748 | ₪ 4,745 | ₪ 1,325 | ₪ 6,070 | ₪ 1,377,918 |
| 228 | ₪ 387,987 | ₪ 4,761 | ₪ 1,309 | ₪ 6,070 | ₪ 1,383,988 |
| 229 | ₪ 383,210 | ₪ 4,777 | ₪ 1,293 | ₪ 6,070 | ₪ 1,390,058 |
| 230 | ₪ 378,417 | ₪ 4,793 | ₪ 1,277 | ₪ 6,070 | ₪ 1,396,128 |
| 231 | ₪ 373,608 | ₪ 4,809 | ₪ 1,261 | ₪ 6,070 | ₪ 1,402,199 |
| 232 | ₪ 368,784 | ₪ 4,825 | ₪ 1,245 | ₪ 6,070 | ₪ 1,408,269 |
| 233 | ₪ 363,943 | ₪ 4,841 | ₪ 1,229 | ₪ 6,070 | ₪ 1,414,339 |
| 234 | ₪ 359,086 | ₪ 4,857 | ₪ 1,213 | ₪ 6,070 | ₪ 1,420,409 |
| 235 | ₪ 354,213 | ₪ 4,873 | ₪ 1,197 | ₪ 6,070 | ₪ 1,426,479 |
| 236 | ₪ 349,323 | ₪ 4,889 | ₪ 1,181 | ₪ 6,070 | ₪ 1,432,549 |
| 237 | ₪ 344,418 | ₪ 4,906 | ₪ 1,164 | ₪ 6,070 | ₪ 1,438,619 |
| 238 | ₪ 339,495 | ₪ 4,922 | ₪ 1,148 | ₪ 6,070 | ₪ 1,444,689 |
| 239 | ₪ 334,557 | ₪ 4,938 | ₪ 1,132 | ₪ 6,070 | ₪ 1,450,760 |
| 240 | ₪ 329,602 | ₪ 4,955 | ₪ 1,115 | ₪ 6,070 | ₪ 1,456,830 |
| 241 | ₪ 324,631 | ₪ 4,971 | ₪ 1,099 | ₪ 6,070 | ₪ 1,462,900 |
| 242 | ₪ 319,643 | ₪ 4,988 | ₪ 1,082 | ₪ 6,070 | ₪ 1,468,970 |
| 243 | ₪ 314,638 | ₪ 5,005 | ₪ 1,065 | ₪ 6,070 | ₪ 1,475,040 |
| 244 | ₪ 309,617 | ₪ 5,021 | ₪ 1,049 | ₪ 6,070 | ₪ 1,481,110 |
| 245 | ₪ 304,579 | ₪ 5,038 | ₪ 1,032 | ₪ 6,070 | ₪ 1,487,180 |
| 246 | ₪ 299,524 | ₪ 5,055 | ₪ 1,015 | ₪ 6,070 | ₪ 1,493,250 |
| 247 | ₪ 294,452 | ₪ 5,072 | ₪ 998 | ₪ 6,070 | ₪ 1,499,321 |
| 248 | ₪ 289,363 | ₪ 5,089 | ₪ 982 | ₪ 6,070 | ₪ 1,505,391 |
| 249 | ₪ 284,258 | ₪ 5,106 | ₪ 965 | ₪ 6,070 | ₪ 1,511,461 |
| 250 | ₪ 279,135 | ₪ 5,123 | ₪ 948 | ₪ 6,070 | ₪ 1,517,531 |
| 251 | ₪ 273,996 | ₪ 5,140 | ₪ 930 | ₪ 6,070 | ₪ 1,523,601 |
| 252 | ₪ 268,839 | ₪ 5,157 | ₪ 913 | ₪ 6,070 | ₪ 1,529,671 |
| 253 | ₪ 263,665 | ₪ 5,174 | ₪ 896 | ₪ 6,070 | ₪ 1,535,741 |
| 254 | ₪ 258,473 | ₪ 5,191 | ₪ 879 | ₪ 6,070 | ₪ 1,541,811 |
| 255 | ₪ 253,265 | ₪ 5,209 | ₪ 862 | ₪ 6,070 | ₪ 1,547,882 |
| 256 | ₪ 248,039 | ₪ 5,226 | ₪ 844 | ₪ 6,070 | ₪ 1,553,952 |
| 257 | ₪ 242,796 | ₪ 5,243 | ₪ 827 | ₪ 6,070 | ₪ 1,560,022 |
| 258 | ₪ 237,535 | ₪ 5,261 | ₪ 809 | ₪ 6,070 | ₪ 1,566,092 |
| 259 | ₪ 232,257 | ₪ 5,278 | ₪ 792 | ₪ 6,070 | ₪ 1,572,162 |
| 260 | ₪ 226,961 | ₪ 5,296 | ₪ 774 | ₪ 6,070 | ₪ 1,578,232 |
| 261 | ₪ 221,647 | ₪ 5,314 | ₪ 757 | ₪ 6,070 | ₪ 1,584,302 |
| 262 | ₪ 216,316 | ₪ 5,331 | ₪ 739 | ₪ 6,070 | ₪ 1,590,372 |
| 263 | ₪ 210,967 | ₪ 5,349 | ₪ 721 | ₪ 6,070 | ₪ 1,596,443 |
| 264 | ₪ 205,600 | ₪ 5,367 | ₪ 703 | ₪ 6,070 | ₪ 1,602,513 |
| 265 | ₪ 200,215 | ₪ 5,385 | ₪ 685 | ₪ 6,070 | ₪ 1,608,583 |
| 266 | ₪ 194,812 | ₪ 5,403 | ₪ 667 | ₪ 6,070 | ₪ 1,614,653 |
| 267 | ₪ 189,391 | ₪ 5,421 | ₪ 649 | ₪ 6,070 | ₪ 1,620,723 |
| 268 | ₪ 183,953 | ₪ 5,439 | ₪ 631 | ₪ 6,070 | ₪ 1,626,793 |
| 269 | ₪ 178,496 | ₪ 5,457 | ₪ 613 | ₪ 6,070 | ₪ 1,632,863 |
| 270 | ₪ 173,021 | ₪ 5,475 | ₪ 595 | ₪ 6,070 | ₪ 1,638,933 |
| 271 | ₪ 167,527 | ₪ 5,493 | ₪ 577 | ₪ 6,070 | ₪ 1,645,004 |
| 272 | ₪ 162,015 | ₪ 5,512 | ₪ 558 | ₪ 6,070 | ₪ 1,651,074 |
| 273 | ₪ 156,485 | ₪ 5,530 | ₪ 540 | ₪ 6,070 | ₪ 1,657,144 |
| 274 | ₪ 150,937 | ₪ 5,549 | ₪ 522 | ₪ 6,070 | ₪ 1,663,214 |
| 275 | ₪ 145,370 | ₪ 5,567 | ₪ 503 | ₪ 6,070 | ₪ 1,669,284 |
| 276 | ₪ 139,784 | ₪ 5,586 | ₪ 485 | ₪ 6,070 | ₪ 1,675,354 |
| 277 | ₪ 134,180 | ₪ 5,604 | ₪ 466 | ₪ 6,070 | ₪ 1,681,424 |
| 278 | ₪ 128,557 | ₪ 5,623 | ₪ 447 | ₪ 6,070 | ₪ 1,687,494 |
| 279 | ₪ 122,916 | ₪ 5,642 | ₪ 429 | ₪ 6,070 | ₪ 1,693,565 |
| 280 | ₪ 117,255 | ₪ 5,660 | ₪ 410 | ₪ 6,070 | ₪ 1,699,635 |
| 281 | ₪ 111,576 | ₪ 5,679 | ₪ 391 | ₪ 6,070 | ₪ 1,705,705 |
| 282 | ₪ 105,878 | ₪ 5,698 | ₪ 372 | ₪ 6,070 | ₪ 1,711,775 |
| 283 | ₪ 100,161 | ₪ 5,717 | ₪ 353 | ₪ 6,070 | ₪ 1,717,845 |
| 284 | ₪ 94,424 | ₪ 5,736 | ₪ 334 | ₪ 6,070 | ₪ 1,723,915 |
| 285 | ₪ 88,669 | ₪ 5,755 | ₪ 315 | ₪ 6,070 | ₪ 1,729,985 |
| 286 | ₪ 82,894 | ₪ 5,775 | ₪ 296 | ₪ 6,070 | ₪ 1,736,055 |
| 287 | ₪ 77,101 | ₪ 5,794 | ₪ 276 | ₪ 6,070 | ₪ 1,742,125 |
| 288 | ₪ 71,287 | ₪ 5,813 | ₪ 257 | ₪ 6,070 | ₪ 1,748,196 |
| 289 | ₪ 65,455 | ₪ 5,832 | ₪ 238 | ₪ 6,070 | ₪ 1,754,266 |
| 290 | ₪ 59,603 | ₪ 5,852 | ₪ 218 | ₪ 6,070 | ₪ 1,760,336 |
| 291 | ₪ 53,732 | ₪ 5,871 | ₪ 199 | ₪ 6,070 | ₪ 1,766,406 |
| 292 | ₪ 47,841 | ₪ 5,891 | ₪ 179 | ₪ 6,070 | ₪ 1,772,476 |
| 293 | ₪ 41,930 | ₪ 5,911 | ₪ 159 | ₪ 6,070 | ₪ 1,778,546 |
| 294 | ₪ 36,000 | ₪ 5,930 | ₪ 140 | ₪ 6,070 | ₪ 1,784,616 |
| 295 | ₪ 30,049 | ₪ 5,950 | ₪ 120 | ₪ 6,070 | ₪ 1,790,686 |
| 296 | ₪ 24,079 | ₪ 5,970 | ₪ 100 | ₪ 6,070 | ₪ 1,796,757 |
| 297 | ₪ 18,090 | ₪ 5,990 | ₪ 80 | ₪ 6,070 | ₪ 1,802,827 |
| 298 | ₪ 12,080 | ₪ 6,010 | ₪ 60 | ₪ 6,070 | ₪ 1,808,897 |
| 299 | ₪ 6,050 | ₪ 6,030 | ₪ 40 | ₪ 6,070 | ₪ 1,814,967 |
| 300 | ₪ 0 | ₪ 6,050 | ₪ 20 | ₪ 6,070 | ₪ 1,821,037 |
| סה"כ | ₪ 1,150,000 | ₪ 671,037 | ₪ 1,821,037 | ₪ 1,821,037 |
ראו גם: מה ההחזר על משכנתא של 1,050,000 שח? | מה ההחזר על משכנתא של 1,250,000 שח?