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