18,267 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,950,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ותשע מאות וחמישים אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
18,267 ש"ח
1,434,180 ש"ח
4,384,180 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,942,180 | ₪ 7,820 | ₪ 10,448 | ₪ 18,267 | ₪ 18,267 |
| 2 | ₪ 2,934,333 | ₪ 7,847 | ₪ 10,420 | ₪ 18,267 | ₪ 36,535 |
| 3 | ₪ 2,926,458 | ₪ 7,875 | ₪ 10,392 | ₪ 18,267 | ₪ 54,802 |
| 4 | ₪ 2,918,555 | ₪ 7,903 | ₪ 10,365 | ₪ 18,267 | ₪ 73,070 |
| 5 | ₪ 2,910,625 | ₪ 7,931 | ₪ 10,337 | ₪ 18,267 | ₪ 91,337 |
| 6 | ₪ 2,902,666 | ₪ 7,959 | ₪ 10,308 | ₪ 18,267 | ₪ 109,605 |
| 7 | ₪ 2,894,678 | ₪ 7,987 | ₪ 10,280 | ₪ 18,267 | ₪ 127,872 |
| 8 | ₪ 2,886,663 | ₪ 8,015 | ₪ 10,252 | ₪ 18,267 | ₪ 146,139 |
| 9 | ₪ 2,878,619 | ₪ 8,044 | ₪ 10,224 | ₪ 18,267 | ₪ 164,407 |
| 10 | ₪ 2,870,547 | ₪ 8,072 | ₪ 10,195 | ₪ 18,267 | ₪ 182,674 |
| 11 | ₪ 2,862,446 | ₪ 8,101 | ₪ 10,167 | ₪ 18,267 | ₪ 200,942 |
| 12 | ₪ 2,854,316 | ₪ 8,130 | ₪ 10,138 | ₪ 18,267 | ₪ 219,209 |
| 13 | ₪ 2,846,158 | ₪ 8,158 | ₪ 10,109 | ₪ 18,267 | ₪ 237,476 |
| 14 | ₪ 2,837,971 | ₪ 8,187 | ₪ 10,080 | ₪ 18,267 | ₪ 255,744 |
| 15 | ₪ 2,829,755 | ₪ 8,216 | ₪ 10,051 | ₪ 18,267 | ₪ 274,011 |
| 16 | ₪ 2,821,509 | ₪ 8,245 | ₪ 10,022 | ₪ 18,267 | ₪ 292,279 |
| 17 | ₪ 2,813,235 | ₪ 8,275 | ₪ 9,993 | ₪ 18,267 | ₪ 310,546 |
| 18 | ₪ 2,804,931 | ₪ 8,304 | ₪ 9,964 | ₪ 18,267 | ₪ 328,814 |
| 19 | ₪ 2,796,597 | ₪ 8,333 | ₪ 9,934 | ₪ 18,267 | ₪ 347,081 |
| 20 | ₪ 2,788,235 | ₪ 8,363 | ₪ 9,905 | ₪ 18,267 | ₪ 365,348 |
| 21 | ₪ 2,779,842 | ₪ 8,392 | ₪ 9,875 | ₪ 18,267 | ₪ 383,616 |
| 22 | ₪ 2,771,420 | ₪ 8,422 | ₪ 9,845 | ₪ 18,267 | ₪ 401,883 |
| 23 | ₪ 2,762,968 | ₪ 8,452 | ₪ 9,815 | ₪ 18,267 | ₪ 420,151 |
| 24 | ₪ 2,754,486 | ₪ 8,482 | ₪ 9,786 | ₪ 18,267 | ₪ 438,418 |
| 25 | ₪ 2,745,974 | ₪ 8,512 | ₪ 9,755 | ₪ 18,267 | ₪ 456,685 |
| 26 | ₪ 2,737,432 | ₪ 8,542 | ₪ 9,725 | ₪ 18,267 | ₪ 474,953 |
| 27 | ₪ 2,728,860 | ₪ 8,572 | ₪ 9,695 | ₪ 18,267 | ₪ 493,220 |
| 28 | ₪ 2,720,257 | ₪ 8,603 | ₪ 9,665 | ₪ 18,267 | ₪ 511,488 |
| 29 | ₪ 2,711,624 | ₪ 8,633 | ₪ 9,634 | ₪ 18,267 | ₪ 529,755 |
| 30 | ₪ 2,702,960 | ₪ 8,664 | ₪ 9,604 | ₪ 18,267 | ₪ 548,023 |
| 31 | ₪ 2,694,266 | ₪ 8,694 | ₪ 9,573 | ₪ 18,267 | ₪ 566,290 |
| 32 | ₪ 2,685,541 | ₪ 8,725 | ₪ 9,542 | ₪ 18,267 | ₪ 584,557 |
| 33 | ₪ 2,676,784 | ₪ 8,756 | ₪ 9,511 | ₪ 18,267 | ₪ 602,825 |
| 34 | ₪ 2,667,997 | ₪ 8,787 | ₪ 9,480 | ₪ 18,267 | ₪ 621,092 |
| 35 | ₪ 2,659,179 | ₪ 8,818 | ₪ 9,449 | ₪ 18,267 | ₪ 639,360 |
| 36 | ₪ 2,650,329 | ₪ 8,849 | ₪ 9,418 | ₪ 18,267 | ₪ 657,627 |
| 37 | ₪ 2,641,449 | ₪ 8,881 | ₪ 9,387 | ₪ 18,267 | ₪ 675,894 |
| 38 | ₪ 2,632,536 | ₪ 8,912 | ₪ 9,355 | ₪ 18,267 | ₪ 694,162 |
| 39 | ₪ 2,623,593 | ₪ 8,944 | ₪ 9,324 | ₪ 18,267 | ₪ 712,429 |
| 40 | ₪ 2,614,617 | ₪ 8,976 | ₪ 9,292 | ₪ 18,267 | ₪ 730,697 |
| 41 | ₪ 2,605,610 | ₪ 9,007 | ₪ 9,260 | ₪ 18,267 | ₪ 748,964 |
| 42 | ₪ 2,596,570 | ₪ 9,039 | ₪ 9,228 | ₪ 18,267 | ₪ 767,232 |
| 43 | ₪ 2,587,499 | ₪ 9,071 | ₪ 9,196 | ₪ 18,267 | ₪ 785,499 |
| 44 | ₪ 2,578,396 | ₪ 9,103 | ₪ 9,164 | ₪ 18,267 | ₪ 803,766 |
| 45 | ₪ 2,569,260 | ₪ 9,136 | ₪ 9,132 | ₪ 18,267 | ₪ 822,034 |
| 46 | ₪ 2,560,092 | ₪ 9,168 | ₪ 9,099 | ₪ 18,267 | ₪ 840,301 |
| 47 | ₪ 2,550,892 | ₪ 9,200 | ₪ 9,067 | ₪ 18,267 | ₪ 858,569 |
| 48 | ₪ 2,541,659 | ₪ 9,233 | ₪ 9,034 | ₪ 18,267 | ₪ 876,836 |
| 49 | ₪ 2,532,393 | ₪ 9,266 | ₪ 9,002 | ₪ 18,267 | ₪ 895,103 |
| 50 | ₪ 2,523,095 | ₪ 9,299 | ₪ 8,969 | ₪ 18,267 | ₪ 913,371 |
| 51 | ₪ 2,513,763 | ₪ 9,331 | ₪ 8,936 | ₪ 18,267 | ₪ 931,638 |
| 52 | ₪ 2,504,399 | ₪ 9,365 | ₪ 8,903 | ₪ 18,267 | ₪ 949,906 |
| 53 | ₪ 2,495,001 | ₪ 9,398 | ₪ 8,870 | ₪ 18,267 | ₪ 968,173 |
| 54 | ₪ 2,485,570 | ₪ 9,431 | ₪ 8,836 | ₪ 18,267 | ₪ 986,441 |
| 55 | ₪ 2,476,106 | ₪ 9,464 | ₪ 8,803 | ₪ 18,267 | ₪ 1,004,708 |
| 56 | ₪ 2,466,608 | ₪ 9,498 | ₪ 8,770 | ₪ 18,267 | ₪ 1,022,975 |
| 57 | ₪ 2,457,076 | ₪ 9,532 | ₪ 8,736 | ₪ 18,267 | ₪ 1,041,243 |
| 58 | ₪ 2,447,511 | ₪ 9,565 | ₪ 8,702 | ₪ 18,267 | ₪ 1,059,510 |
| 59 | ₪ 2,437,912 | ₪ 9,599 | ₪ 8,668 | ₪ 18,267 | ₪ 1,077,778 |
| 60 | ₪ 2,428,279 | ₪ 9,633 | ₪ 8,634 | ₪ 18,267 | ₪ 1,096,045 |
| 61 | ₪ 2,418,611 | ₪ 9,667 | ₪ 8,600 | ₪ 18,267 | ₪ 1,114,312 |
| 62 | ₪ 2,408,910 | ₪ 9,702 | ₪ 8,566 | ₪ 18,267 | ₪ 1,132,580 |
| 63 | ₪ 2,399,174 | ₪ 9,736 | ₪ 8,532 | ₪ 18,267 | ₪ 1,150,847 |
| 64 | ₪ 2,389,404 | ₪ 9,770 | ₪ 8,497 | ₪ 18,267 | ₪ 1,169,115 |
| 65 | ₪ 2,379,599 | ₪ 9,805 | ₪ 8,462 | ₪ 18,267 | ₪ 1,187,382 |
| 66 | ₪ 2,369,759 | ₪ 9,840 | ₪ 8,428 | ₪ 18,267 | ₪ 1,205,650 |
| 67 | ₪ 2,359,885 | ₪ 9,875 | ₪ 8,393 | ₪ 18,267 | ₪ 1,223,917 |
| 68 | ₪ 2,349,975 | ₪ 9,909 | ₪ 8,358 | ₪ 18,267 | ₪ 1,242,184 |
| 69 | ₪ 2,340,031 | ₪ 9,945 | ₪ 8,323 | ₪ 18,267 | ₪ 1,260,452 |
| 70 | ₪ 2,330,051 | ₪ 9,980 | ₪ 8,288 | ₪ 18,267 | ₪ 1,278,719 |
| 71 | ₪ 2,320,036 | ₪ 10,015 | ₪ 8,252 | ₪ 18,267 | ₪ 1,296,987 |
| 72 | ₪ 2,309,985 | ₪ 10,051 | ₪ 8,217 | ₪ 18,267 | ₪ 1,315,254 |
| 73 | ₪ 2,299,899 | ₪ 10,086 | ₪ 8,181 | ₪ 18,267 | ₪ 1,333,521 |
| 74 | ₪ 2,289,777 | ₪ 10,122 | ₪ 8,145 | ₪ 18,267 | ₪ 1,351,789 |
| 75 | ₪ 2,279,619 | ₪ 10,158 | ₪ 8,110 | ₪ 18,267 | ₪ 1,370,056 |
| 76 | ₪ 2,269,425 | ₪ 10,194 | ₪ 8,074 | ₪ 18,267 | ₪ 1,388,324 |
| 77 | ₪ 2,259,195 | ₪ 10,230 | ₪ 8,038 | ₪ 18,267 | ₪ 1,406,591 |
| 78 | ₪ 2,248,929 | ₪ 10,266 | ₪ 8,001 | ₪ 18,267 | ₪ 1,424,859 |
| 79 | ₪ 2,238,627 | ₪ 10,302 | ₪ 7,965 | ₪ 18,267 | ₪ 1,443,126 |
| 80 | ₪ 2,228,288 | ₪ 10,339 | ₪ 7,928 | ₪ 18,267 | ₪ 1,461,393 |
| 81 | ₪ 2,217,912 | ₪ 10,376 | ₪ 7,892 | ₪ 18,267 | ₪ 1,479,661 |
| 82 | ₪ 2,207,500 | ₪ 10,412 | ₪ 7,855 | ₪ 18,267 | ₪ 1,497,928 |
| 83 | ₪ 2,197,051 | ₪ 10,449 | ₪ 7,818 | ₪ 18,267 | ₪ 1,516,196 |
| 84 | ₪ 2,186,565 | ₪ 10,486 | ₪ 7,781 | ₪ 18,267 | ₪ 1,534,463 |
| 85 | ₪ 2,176,041 | ₪ 10,523 | ₪ 7,744 | ₪ 18,267 | ₪ 1,552,730 |
| 86 | ₪ 2,165,481 | ₪ 10,561 | ₪ 7,707 | ₪ 18,267 | ₪ 1,570,998 |
| 87 | ₪ 2,154,883 | ₪ 10,598 | ₪ 7,669 | ₪ 18,267 | ₪ 1,589,265 |
| 88 | ₪ 2,144,247 | ₪ 10,636 | ₪ 7,632 | ₪ 18,267 | ₪ 1,607,533 |
| 89 | ₪ 2,133,574 | ₪ 10,673 | ₪ 7,594 | ₪ 18,267 | ₪ 1,625,800 |
| 90 | ₪ 2,122,863 | ₪ 10,711 | ₪ 7,556 | ₪ 18,267 | ₪ 1,644,068 |
| 91 | ₪ 2,112,114 | ₪ 10,749 | ₪ 7,518 | ₪ 18,267 | ₪ 1,662,335 |
| 92 | ₪ 2,101,327 | ₪ 10,787 | ₪ 7,480 | ₪ 18,267 | ₪ 1,680,602 |
| 93 | ₪ 2,090,502 | ₪ 10,825 | ₪ 7,442 | ₪ 18,267 | ₪ 1,698,870 |
| 94 | ₪ 2,079,638 | ₪ 10,864 | ₪ 7,404 | ₪ 18,267 | ₪ 1,717,137 |
| 95 | ₪ 2,068,736 | ₪ 10,902 | ₪ 7,365 | ₪ 18,267 | ₪ 1,735,405 |
| 96 | ₪ 2,057,796 | ₪ 10,941 | ₪ 7,327 | ₪ 18,267 | ₪ 1,753,672 |
| 97 | ₪ 2,046,816 | ₪ 10,979 | ₪ 7,288 | ₪ 18,267 | ₪ 1,771,939 |
| 98 | ₪ 2,035,798 | ₪ 11,018 | ₪ 7,249 | ₪ 18,267 | ₪ 1,790,207 |
| 99 | ₪ 2,024,741 | ₪ 11,057 | ₪ 7,210 | ₪ 18,267 | ₪ 1,808,474 |
| 100 | ₪ 2,013,644 | ₪ 11,096 | ₪ 7,171 | ₪ 18,267 | ₪ 1,826,742 |
| 101 | ₪ 2,002,508 | ₪ 11,136 | ₪ 7,132 | ₪ 18,267 | ₪ 1,845,009 |
| 102 | ₪ 1,991,333 | ₪ 11,175 | ₪ 7,092 | ₪ 18,267 | ₪ 1,863,277 |
| 103 | ₪ 1,980,118 | ₪ 11,215 | ₪ 7,053 | ₪ 18,267 | ₪ 1,881,544 |
| 104 | ₪ 1,968,864 | ₪ 11,254 | ₪ 7,013 | ₪ 18,267 | ₪ 1,899,811 |
| 105 | ₪ 1,957,570 | ₪ 11,294 | ₪ 6,973 | ₪ 18,267 | ₪ 1,918,079 |
| 106 | ₪ 1,946,235 | ₪ 11,334 | ₪ 6,933 | ₪ 18,267 | ₪ 1,936,346 |
| 107 | ₪ 1,934,861 | ₪ 11,375 | ₪ 6,893 | ₪ 18,267 | ₪ 1,954,614 |
| 108 | ₪ 1,923,446 | ₪ 11,415 | ₪ 6,853 | ₪ 18,267 | ₪ 1,972,881 |
| 109 | ₪ 1,911,991 | ₪ 11,455 | ₪ 6,812 | ₪ 18,267 | ₪ 1,991,148 |
| 110 | ₪ 1,900,495 | ₪ 11,496 | ₪ 6,772 | ₪ 18,267 | ₪ 2,009,416 |
| 111 | ₪ 1,888,958 | ₪ 11,536 | ₪ 6,731 | ₪ 18,267 | ₪ 2,027,683 |
| 112 | ₪ 1,877,381 | ₪ 11,577 | ₪ 6,690 | ₪ 18,267 | ₪ 2,045,951 |
| 113 | ₪ 1,865,763 | ₪ 11,618 | ₪ 6,649 | ₪ 18,267 | ₪ 2,064,218 |
| 114 | ₪ 1,854,103 | ₪ 11,660 | ₪ 6,608 | ₪ 18,267 | ₪ 2,082,486 |
| 115 | ₪ 1,842,402 | ₪ 11,701 | ₪ 6,567 | ₪ 18,267 | ₪ 2,100,753 |
| 116 | ₪ 1,830,660 | ₪ 11,742 | ₪ 6,525 | ₪ 18,267 | ₪ 2,119,020 |
| 117 | ₪ 1,818,876 | ₪ 11,784 | ₪ 6,484 | ₪ 18,267 | ₪ 2,137,288 |
| 118 | ₪ 1,807,051 | ₪ 11,826 | ₪ 6,442 | ₪ 18,267 | ₪ 2,155,555 |
| 119 | ₪ 1,795,183 | ₪ 11,867 | ₪ 6,400 | ₪ 18,267 | ₪ 2,173,823 |
| 120 | ₪ 1,783,274 | ₪ 11,909 | ₪ 6,358 | ₪ 18,267 | ₪ 2,192,090 |
| 121 | ₪ 1,771,322 | ₪ 11,952 | ₪ 6,316 | ₪ 18,267 | ₪ 2,210,357 |
| 122 | ₪ 1,759,328 | ₪ 11,994 | ₪ 6,273 | ₪ 18,267 | ₪ 2,228,625 |
| 123 | ₪ 1,747,292 | ₪ 12,036 | ₪ 6,231 | ₪ 18,267 | ₪ 2,246,892 |
| 124 | ₪ 1,735,213 | ₪ 12,079 | ₪ 6,188 | ₪ 18,267 | ₪ 2,265,160 |
| 125 | ₪ 1,723,091 | ₪ 12,122 | ₪ 6,146 | ₪ 18,267 | ₪ 2,283,427 |
| 126 | ₪ 1,710,926 | ₪ 12,165 | ₪ 6,103 | ₪ 18,267 | ₪ 2,301,695 |
| 127 | ₪ 1,698,718 | ₪ 12,208 | ₪ 6,060 | ₪ 18,267 | ₪ 2,319,962 |
| 128 | ₪ 1,686,467 | ₪ 12,251 | ₪ 6,016 | ₪ 18,267 | ₪ 2,338,229 |
| 129 | ₪ 1,674,172 | ₪ 12,295 | ₪ 5,973 | ₪ 18,267 | ₪ 2,356,497 |
| 130 | ₪ 1,661,834 | ₪ 12,338 | ₪ 5,929 | ₪ 18,267 | ₪ 2,374,764 |
| 131 | ₪ 1,649,453 | ₪ 12,382 | ₪ 5,886 | ₪ 18,267 | ₪ 2,393,032 |
| 132 | ₪ 1,637,027 | ₪ 12,426 | ₪ 5,842 | ₪ 18,267 | ₪ 2,411,299 |
| 133 | ₪ 1,624,557 | ₪ 12,470 | ₪ 5,798 | ₪ 18,267 | ₪ 2,429,566 |
| 134 | ₪ 1,612,044 | ₪ 12,514 | ₪ 5,754 | ₪ 18,267 | ₪ 2,447,834 |
| 135 | ₪ 1,599,485 | ₪ 12,558 | ₪ 5,709 | ₪ 18,267 | ₪ 2,466,101 |
| 136 | ₪ 1,586,883 | ₪ 12,603 | ₪ 5,665 | ₪ 18,267 | ₪ 2,484,369 |
| 137 | ₪ 1,574,236 | ₪ 12,647 | ₪ 5,620 | ₪ 18,267 | ₪ 2,502,636 |
| 138 | ₪ 1,561,544 | ₪ 12,692 | ₪ 5,575 | ₪ 18,267 | ₪ 2,520,904 |
| 139 | ₪ 1,548,807 | ₪ 12,737 | ₪ 5,530 | ₪ 18,267 | ₪ 2,539,171 |
| 140 | ₪ 1,536,025 | ₪ 12,782 | ₪ 5,485 | ₪ 18,267 | ₪ 2,557,438 |
| 141 | ₪ 1,523,197 | ₪ 12,827 | ₪ 5,440 | ₪ 18,267 | ₪ 2,575,706 |
| 142 | ₪ 1,510,325 | ₪ 12,873 | ₪ 5,395 | ₪ 18,267 | ₪ 2,593,973 |
| 143 | ₪ 1,497,406 | ₪ 12,918 | ₪ 5,349 | ₪ 18,267 | ₪ 2,612,241 |
| 144 | ₪ 1,484,442 | ₪ 12,964 | ₪ 5,303 | ₪ 18,267 | ₪ 2,630,508 |
| 145 | ₪ 1,471,432 | ₪ 13,010 | ₪ 5,257 | ₪ 18,267 | ₪ 2,648,775 |
| 146 | ₪ 1,458,376 | ₪ 13,056 | ₪ 5,211 | ₪ 18,267 | ₪ 2,667,043 |
| 147 | ₪ 1,445,274 | ₪ 13,102 | ₪ 5,165 | ₪ 18,267 | ₪ 2,685,310 |
| 148 | ₪ 1,432,125 | ₪ 13,149 | ₪ 5,119 | ₪ 18,267 | ₪ 2,703,578 |
| 149 | ₪ 1,418,930 | ₪ 13,195 | ₪ 5,072 | ₪ 18,267 | ₪ 2,721,845 |
| 150 | ₪ 1,405,688 | ₪ 13,242 | ₪ 5,025 | ₪ 18,267 | ₪ 2,740,113 |
| 151 | ₪ 1,392,399 | ₪ 13,289 | ₪ 4,978 | ₪ 18,267 | ₪ 2,758,380 |
| 152 | ₪ 1,379,063 | ₪ 13,336 | ₪ 4,931 | ₪ 18,267 | ₪ 2,776,647 |
| 153 | ₪ 1,365,679 | ₪ 13,383 | ₪ 4,884 | ₪ 18,267 | ₪ 2,794,915 |
| 154 | ₪ 1,352,249 | ₪ 13,431 | ₪ 4,837 | ₪ 18,267 | ₪ 2,813,182 |
| 155 | ₪ 1,338,771 | ₪ 13,478 | ₪ 4,789 | ₪ 18,267 | ₪ 2,831,450 |
| 156 | ₪ 1,325,245 | ₪ 13,526 | ₪ 4,741 | ₪ 18,267 | ₪ 2,849,717 |
| 157 | ₪ 1,311,671 | ₪ 13,574 | ₪ 4,694 | ₪ 18,267 | ₪ 2,867,984 |
| 158 | ₪ 1,298,049 | ₪ 13,622 | ₪ 4,646 | ₪ 18,267 | ₪ 2,886,252 |
| 159 | ₪ 1,284,379 | ₪ 13,670 | ₪ 4,597 | ₪ 18,267 | ₪ 2,904,519 |
| 160 | ₪ 1,270,660 | ₪ 13,719 | ₪ 4,549 | ₪ 18,267 | ₪ 2,922,787 |
| 161 | ₪ 1,256,893 | ₪ 13,767 | ₪ 4,500 | ₪ 18,267 | ₪ 2,941,054 |
| 162 | ₪ 1,243,077 | ₪ 13,816 | ₪ 4,451 | ₪ 18,267 | ₪ 2,959,322 |
| 163 | ₪ 1,229,212 | ₪ 13,865 | ₪ 4,403 | ₪ 18,267 | ₪ 2,977,589 |
| 164 | ₪ 1,215,298 | ₪ 13,914 | ₪ 4,353 | ₪ 18,267 | ₪ 2,995,856 |
| 165 | ₪ 1,201,335 | ₪ 13,963 | ₪ 4,304 | ₪ 18,267 | ₪ 3,014,124 |
| 166 | ₪ 1,187,322 | ₪ 14,013 | ₪ 4,255 | ₪ 18,267 | ₪ 3,032,391 |
| 167 | ₪ 1,173,260 | ₪ 14,062 | ₪ 4,205 | ₪ 18,267 | ₪ 3,050,659 |
| 168 | ₪ 1,159,148 | ₪ 14,112 | ₪ 4,155 | ₪ 18,267 | ₪ 3,068,926 |
| 169 | ₪ 1,144,986 | ₪ 14,162 | ₪ 4,105 | ₪ 18,267 | ₪ 3,087,193 |
| 170 | ₪ 1,130,774 | ₪ 14,212 | ₪ 4,055 | ₪ 18,267 | ₪ 3,105,461 |
| 171 | ₪ 1,116,511 | ₪ 14,263 | ₪ 4,005 | ₪ 18,267 | ₪ 3,123,728 |
| 172 | ₪ 1,102,198 | ₪ 14,313 | ₪ 3,954 | ₪ 18,267 | ₪ 3,141,996 |
| 173 | ₪ 1,087,834 | ₪ 14,364 | ₪ 3,904 | ₪ 18,267 | ₪ 3,160,263 |
| 174 | ₪ 1,073,419 | ₪ 14,415 | ₪ 3,853 | ₪ 18,267 | ₪ 3,178,531 |
| 175 | ₪ 1,058,954 | ₪ 14,466 | ₪ 3,802 | ₪ 18,267 | ₪ 3,196,798 |
| 176 | ₪ 1,044,437 | ₪ 14,517 | ₪ 3,750 | ₪ 18,267 | ₪ 3,215,065 |
| 177 | ₪ 1,029,868 | ₪ 14,568 | ₪ 3,699 | ₪ 18,267 | ₪ 3,233,333 |
| 178 | ₪ 1,015,248 | ₪ 14,620 | ₪ 3,647 | ₪ 18,267 | ₪ 3,251,600 |
| 179 | ₪ 1,000,577 | ₪ 14,672 | ₪ 3,596 | ₪ 18,267 | ₪ 3,269,868 |
| 180 | ₪ 985,853 | ₪ 14,724 | ₪ 3,544 | ₪ 18,267 | ₪ 3,288,135 |
| 181 | ₪ 971,077 | ₪ 14,776 | ₪ 3,492 | ₪ 18,267 | ₪ 3,306,402 |
| 182 | ₪ 956,249 | ₪ 14,828 | ₪ 3,439 | ₪ 18,267 | ₪ 3,324,670 |
| 183 | ₪ 941,368 | ₪ 14,881 | ₪ 3,387 | ₪ 18,267 | ₪ 3,342,937 |
| 184 | ₪ 926,435 | ₪ 14,933 | ₪ 3,334 | ₪ 18,267 | ₪ 3,361,205 |
| 185 | ₪ 911,448 | ₪ 14,986 | ₪ 3,281 | ₪ 18,267 | ₪ 3,379,472 |
| 186 | ₪ 896,409 | ₪ 15,039 | ₪ 3,228 | ₪ 18,267 | ₪ 3,397,740 |
| 187 | ₪ 881,316 | ₪ 15,093 | ₪ 3,175 | ₪ 18,267 | ₪ 3,416,007 |
| 188 | ₪ 866,170 | ₪ 15,146 | ₪ 3,121 | ₪ 18,267 | ₪ 3,434,274 |
| 189 | ₪ 850,971 | ₪ 15,200 | ₪ 3,068 | ₪ 18,267 | ₪ 3,452,542 |
| 190 | ₪ 835,717 | ₪ 15,254 | ₪ 3,014 | ₪ 18,267 | ₪ 3,470,809 |
| 191 | ₪ 820,410 | ₪ 15,308 | ₪ 2,960 | ₪ 18,267 | ₪ 3,489,077 |
| 192 | ₪ 805,048 | ₪ 15,362 | ₪ 2,906 | ₪ 18,267 | ₪ 3,507,344 |
| 193 | ₪ 789,632 | ₪ 15,416 | ₪ 2,851 | ₪ 18,267 | ₪ 3,525,611 |
| 194 | ₪ 774,161 | ₪ 15,471 | ₪ 2,797 | ₪ 18,267 | ₪ 3,543,879 |
| 195 | ₪ 758,635 | ₪ 15,526 | ₪ 2,742 | ₪ 18,267 | ₪ 3,562,146 |
| 196 | ₪ 743,055 | ₪ 15,581 | ₪ 2,687 | ₪ 18,267 | ₪ 3,580,414 |
| 197 | ₪ 727,419 | ₪ 15,636 | ₪ 2,632 | ₪ 18,267 | ₪ 3,598,681 |
| 198 | ₪ 711,728 | ₪ 15,691 | ₪ 2,576 | ₪ 18,267 | ₪ 3,616,949 |
| 199 | ₪ 695,981 | ₪ 15,747 | ₪ 2,521 | ₪ 18,267 | ₪ 3,635,216 |
| 200 | ₪ 680,178 | ₪ 15,802 | ₪ 2,465 | ₪ 18,267 | ₪ 3,653,483 |
| 201 | ₪ 664,320 | ₪ 15,858 | ₪ 2,409 | ₪ 18,267 | ₪ 3,671,751 |
| 202 | ₪ 648,405 | ₪ 15,915 | ₪ 2,353 | ₪ 18,267 | ₪ 3,690,018 |
| 203 | ₪ 632,434 | ₪ 15,971 | ₪ 2,296 | ₪ 18,267 | ₪ 3,708,286 |
| 204 | ₪ 616,407 | ₪ 16,028 | ₪ 2,240 | ₪ 18,267 | ₪ 3,726,553 |
| 205 | ₪ 600,323 | ₪ 16,084 | ₪ 2,183 | ₪ 18,267 | ₪ 3,744,820 |
| 206 | ₪ 584,181 | ₪ 16,141 | ₪ 2,126 | ₪ 18,267 | ₪ 3,763,088 |
| 207 | ₪ 567,983 | ₪ 16,198 | ₪ 2,069 | ₪ 18,267 | ₪ 3,781,355 |
| 208 | ₪ 551,727 | ₪ 16,256 | ₪ 2,012 | ₪ 18,267 | ₪ 3,799,623 |
| 209 | ₪ 535,414 | ₪ 16,313 | ₪ 1,954 | ₪ 18,267 | ₪ 3,817,890 |
| 210 | ₪ 519,042 | ₪ 16,371 | ₪ 1,896 | ₪ 18,267 | ₪ 3,836,158 |
| 211 | ₪ 502,613 | ₪ 16,429 | ₪ 1,838 | ₪ 18,267 | ₪ 3,854,425 |
| 212 | ₪ 486,126 | ₪ 16,487 | ₪ 1,780 | ₪ 18,267 | ₪ 3,872,692 |
| 213 | ₪ 469,580 | ₪ 16,546 | ₪ 1,722 | ₪ 18,267 | ₪ 3,890,960 |
| 214 | ₪ 452,976 | ₪ 16,604 | ₪ 1,663 | ₪ 18,267 | ₪ 3,909,227 |
| 215 | ₪ 436,313 | ₪ 16,663 | ₪ 1,604 | ₪ 18,267 | ₪ 3,927,495 |
| 216 | ₪ 419,591 | ₪ 16,722 | ₪ 1,545 | ₪ 18,267 | ₪ 3,945,762 |
| 217 | ₪ 402,809 | ₪ 16,781 | ₪ 1,486 | ₪ 18,267 | ₪ 3,964,029 |
| 218 | ₪ 385,968 | ₪ 16,841 | ₪ 1,427 | ₪ 18,267 | ₪ 3,982,297 |
| 219 | ₪ 369,068 | ₪ 16,900 | ₪ 1,367 | ₪ 18,267 | ₪ 4,000,564 |
| 220 | ₪ 352,108 | ₪ 16,960 | ₪ 1,307 | ₪ 18,267 | ₪ 4,018,832 |
| 221 | ₪ 335,087 | ₪ 17,020 | ₪ 1,247 | ₪ 18,267 | ₪ 4,037,099 |
| 222 | ₪ 318,007 | ₪ 17,081 | ₪ 1,187 | ₪ 18,267 | ₪ 4,055,367 |
| 223 | ₪ 300,866 | ₪ 17,141 | ₪ 1,126 | ₪ 18,267 | ₪ 4,073,634 |
| 224 | ₪ 283,664 | ₪ 17,202 | ₪ 1,066 | ₪ 18,267 | ₪ 4,091,901 |
| 225 | ₪ 266,401 | ₪ 17,263 | ₪ 1,005 | ₪ 18,267 | ₪ 4,110,169 |
| 226 | ₪ 249,077 | ₪ 17,324 | ₪ 944 | ₪ 18,267 | ₪ 4,128,436 |
| 227 | ₪ 231,692 | ₪ 17,385 | ₪ 882 | ₪ 18,267 | ₪ 4,146,704 |
| 228 | ₪ 214,245 | ₪ 17,447 | ₪ 821 | ₪ 18,267 | ₪ 4,164,971 |
| 229 | ₪ 196,736 | ₪ 17,509 | ₪ 759 | ₪ 18,267 | ₪ 4,183,238 |
| 230 | ₪ 179,166 | ₪ 17,571 | ₪ 697 | ₪ 18,267 | ₪ 4,201,506 |
| 231 | ₪ 161,533 | ₪ 17,633 | ₪ 635 | ₪ 18,267 | ₪ 4,219,773 |
| 232 | ₪ 143,837 | ₪ 17,695 | ₪ 572 | ₪ 18,267 | ₪ 4,238,041 |
| 233 | ₪ 126,079 | ₪ 17,758 | ₪ 509 | ₪ 18,267 | ₪ 4,256,308 |
| 234 | ₪ 108,259 | ₪ 17,821 | ₪ 447 | ₪ 18,267 | ₪ 4,274,576 |
| 235 | ₪ 90,375 | ₪ 17,884 | ₪ 383 | ₪ 18,267 | ₪ 4,292,843 |
| 236 | ₪ 72,427 | ₪ 17,947 | ₪ 320 | ₪ 18,267 | ₪ 4,311,110 |
| 237 | ₪ 54,416 | ₪ 18,011 | ₪ 257 | ₪ 18,267 | ₪ 4,329,378 |
| 238 | ₪ 36,342 | ₪ 18,075 | ₪ 193 | ₪ 18,267 | ₪ 4,347,645 |
| 239 | ₪ 18,203 | ₪ 18,139 | ₪ 129 | ₪ 18,267 | ₪ 4,365,913 |
| 240 | ₪ 0 | ₪ 18,203 | ₪ 64 | ₪ 18,267 | ₪ 4,384,180 |
| סה"כ | ₪ 2,950,000 | ₪ 1,434,180 | ₪ 4,384,180 | ₪ 4,384,180 |
ראו גם: מה ההחזר על משכנתא של 2,850,000 שח? | מה ההחזר על משכנתא של 3,050,000 שח?