16,719 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,700,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ושבע מאות אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
16,719 ש"ח
1,312,639 ש"ח
4,012,639 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,692,843 | ₪ 7,157 | ₪ 9,563 | ₪ 16,719 | ₪ 16,719 |
| 2 | ₪ 2,685,661 | ₪ 7,182 | ₪ 9,537 | ₪ 16,719 | ₪ 33,439 |
| 3 | ₪ 2,678,453 | ₪ 7,208 | ₪ 9,512 | ₪ 16,719 | ₪ 50,158 |
| 4 | ₪ 2,671,220 | ₪ 7,233 | ₪ 9,486 | ₪ 16,719 | ₪ 66,877 |
| 5 | ₪ 2,663,961 | ₪ 7,259 | ₪ 9,461 | ₪ 16,719 | ₪ 83,597 |
| 6 | ₪ 2,656,677 | ₪ 7,284 | ₪ 9,435 | ₪ 16,719 | ₪ 100,316 |
| 7 | ₪ 2,649,367 | ₪ 7,310 | ₪ 9,409 | ₪ 16,719 | ₪ 117,035 |
| 8 | ₪ 2,642,031 | ₪ 7,336 | ₪ 9,383 | ₪ 16,719 | ₪ 133,755 |
| 9 | ₪ 2,634,668 | ₪ 7,362 | ₪ 9,357 | ₪ 16,719 | ₪ 150,474 |
| 10 | ₪ 2,627,280 | ₪ 7,388 | ₪ 9,331 | ₪ 16,719 | ₪ 167,193 |
| 11 | ₪ 2,619,866 | ₪ 7,414 | ₪ 9,305 | ₪ 16,719 | ₪ 183,913 |
| 12 | ₪ 2,612,425 | ₪ 7,441 | ₪ 9,279 | ₪ 16,719 | ₪ 200,632 |
| 13 | ₪ 2,604,958 | ₪ 7,467 | ₪ 9,252 | ₪ 16,719 | ₪ 217,351 |
| 14 | ₪ 2,597,465 | ₪ 7,493 | ₪ 9,226 | ₪ 16,719 | ₪ 234,071 |
| 15 | ₪ 2,589,945 | ₪ 7,520 | ₪ 9,199 | ₪ 16,719 | ₪ 250,790 |
| 16 | ₪ 2,582,398 | ₪ 7,547 | ₪ 9,173 | ₪ 16,719 | ₪ 267,509 |
| 17 | ₪ 2,574,825 | ₪ 7,573 | ₪ 9,146 | ₪ 16,719 | ₪ 284,229 |
| 18 | ₪ 2,567,225 | ₪ 7,600 | ₪ 9,119 | ₪ 16,719 | ₪ 300,948 |
| 19 | ₪ 2,559,598 | ₪ 7,627 | ₪ 9,092 | ₪ 16,719 | ₪ 317,667 |
| 20 | ₪ 2,551,944 | ₪ 7,654 | ₪ 9,065 | ₪ 16,719 | ₪ 334,387 |
| 21 | ₪ 2,544,262 | ₪ 7,681 | ₪ 9,038 | ₪ 16,719 | ₪ 351,106 |
| 22 | ₪ 2,536,554 | ₪ 7,708 | ₪ 9,011 | ₪ 16,719 | ₪ 367,825 |
| 23 | ₪ 2,528,818 | ₪ 7,736 | ₪ 8,984 | ₪ 16,719 | ₪ 384,545 |
| 24 | ₪ 2,521,055 | ₪ 7,763 | ₪ 8,956 | ₪ 16,719 | ₪ 401,264 |
| 25 | ₪ 2,513,265 | ₪ 7,791 | ₪ 8,929 | ₪ 16,719 | ₪ 417,983 |
| 26 | ₪ 2,505,446 | ₪ 7,818 | ₪ 8,901 | ₪ 16,719 | ₪ 434,703 |
| 27 | ₪ 2,497,600 | ₪ 7,846 | ₪ 8,873 | ₪ 16,719 | ₪ 451,422 |
| 28 | ₪ 2,489,727 | ₪ 7,874 | ₪ 8,846 | ₪ 16,719 | ₪ 468,141 |
| 29 | ₪ 2,481,825 | ₪ 7,902 | ₪ 8,818 | ₪ 16,719 | ₪ 484,861 |
| 30 | ₪ 2,473,896 | ₪ 7,930 | ₪ 8,790 | ₪ 16,719 | ₪ 501,580 |
| 31 | ₪ 2,465,938 | ₪ 7,958 | ₪ 8,762 | ₪ 16,719 | ₪ 518,299 |
| 32 | ₪ 2,457,952 | ₪ 7,986 | ₪ 8,734 | ₪ 16,719 | ₪ 535,019 |
| 33 | ₪ 2,449,938 | ₪ 8,014 | ₪ 8,705 | ₪ 16,719 | ₪ 551,738 |
| 34 | ₪ 2,441,896 | ₪ 8,042 | ₪ 8,677 | ₪ 16,719 | ₪ 568,457 |
| 35 | ₪ 2,433,825 | ₪ 8,071 | ₪ 8,648 | ₪ 16,719 | ₪ 585,177 |
| 36 | ₪ 2,425,725 | ₪ 8,100 | ₪ 8,620 | ₪ 16,719 | ₪ 601,896 |
| 37 | ₪ 2,417,597 | ₪ 8,128 | ₪ 8,591 | ₪ 16,719 | ₪ 618,615 |
| 38 | ₪ 2,409,440 | ₪ 8,157 | ₪ 8,562 | ₪ 16,719 | ₪ 635,335 |
| 39 | ₪ 2,401,254 | ₪ 8,186 | ₪ 8,533 | ₪ 16,719 | ₪ 652,054 |
| 40 | ₪ 2,393,039 | ₪ 8,215 | ₪ 8,504 | ₪ 16,719 | ₪ 668,773 |
| 41 | ₪ 2,384,795 | ₪ 8,244 | ₪ 8,475 | ₪ 16,719 | ₪ 685,493 |
| 42 | ₪ 2,376,522 | ₪ 8,273 | ₪ 8,446 | ₪ 16,719 | ₪ 702,212 |
| 43 | ₪ 2,368,220 | ₪ 8,302 | ₪ 8,417 | ₪ 16,719 | ₪ 718,931 |
| 44 | ₪ 2,359,888 | ₪ 8,332 | ₪ 8,387 | ₪ 16,719 | ₪ 735,651 |
| 45 | ₪ 2,351,526 | ₪ 8,361 | ₪ 8,358 | ₪ 16,719 | ₪ 752,370 |
| 46 | ₪ 2,343,135 | ₪ 8,391 | ₪ 8,328 | ₪ 16,719 | ₪ 769,089 |
| 47 | ₪ 2,334,715 | ₪ 8,421 | ₪ 8,299 | ₪ 16,719 | ₪ 785,809 |
| 48 | ₪ 2,326,264 | ₪ 8,451 | ₪ 8,269 | ₪ 16,719 | ₪ 802,528 |
| 49 | ₪ 2,317,784 | ₪ 8,480 | ₪ 8,239 | ₪ 16,719 | ₪ 819,247 |
| 50 | ₪ 2,309,273 | ₪ 8,511 | ₪ 8,209 | ₪ 16,719 | ₪ 835,967 |
| 51 | ₪ 2,300,732 | ₪ 8,541 | ₪ 8,179 | ₪ 16,719 | ₪ 852,686 |
| 52 | ₪ 2,292,162 | ₪ 8,571 | ₪ 8,148 | ₪ 16,719 | ₪ 869,405 |
| 53 | ₪ 2,283,560 | ₪ 8,601 | ₪ 8,118 | ₪ 16,719 | ₪ 886,125 |
| 54 | ₪ 2,274,929 | ₪ 8,632 | ₪ 8,088 | ₪ 16,719 | ₪ 902,844 |
| 55 | ₪ 2,266,266 | ₪ 8,662 | ₪ 8,057 | ₪ 16,719 | ₪ 919,563 |
| 56 | ₪ 2,257,573 | ₪ 8,693 | ₪ 8,026 | ₪ 16,719 | ₪ 936,283 |
| 57 | ₪ 2,248,850 | ₪ 8,724 | ₪ 7,996 | ₪ 16,719 | ₪ 953,002 |
| 58 | ₪ 2,240,095 | ₪ 8,755 | ₪ 7,965 | ₪ 16,719 | ₪ 969,721 |
| 59 | ₪ 2,231,309 | ₪ 8,786 | ₪ 7,934 | ₪ 16,719 | ₪ 986,441 |
| 60 | ₪ 2,222,492 | ₪ 8,817 | ₪ 7,903 | ₪ 16,719 | ₪ 1,003,160 |
| 61 | ₪ 2,213,644 | ₪ 8,848 | ₪ 7,871 | ₪ 16,719 | ₪ 1,019,879 |
| 62 | ₪ 2,204,765 | ₪ 8,879 | ₪ 7,840 | ₪ 16,719 | ₪ 1,036,599 |
| 63 | ₪ 2,195,854 | ₪ 8,911 | ₪ 7,809 | ₪ 16,719 | ₪ 1,053,318 |
| 64 | ₪ 2,186,912 | ₪ 8,942 | ₪ 7,777 | ₪ 16,719 | ₪ 1,070,037 |
| 65 | ₪ 2,177,938 | ₪ 8,974 | ₪ 7,745 | ₪ 16,719 | ₪ 1,086,756 |
| 66 | ₪ 2,168,932 | ₪ 9,006 | ₪ 7,714 | ₪ 16,719 | ₪ 1,103,476 |
| 67 | ₪ 2,159,894 | ₪ 9,038 | ₪ 7,682 | ₪ 16,719 | ₪ 1,120,195 |
| 68 | ₪ 2,150,825 | ₪ 9,070 | ₪ 7,650 | ₪ 16,719 | ₪ 1,136,914 |
| 69 | ₪ 2,141,723 | ₪ 9,102 | ₪ 7,618 | ₪ 16,719 | ₪ 1,153,634 |
| 70 | ₪ 2,132,589 | ₪ 9,134 | ₪ 7,585 | ₪ 16,719 | ₪ 1,170,353 |
| 71 | ₪ 2,123,422 | ₪ 9,166 | ₪ 7,553 | ₪ 16,719 | ₪ 1,187,072 |
| 72 | ₪ 2,114,224 | ₪ 9,199 | ₪ 7,520 | ₪ 16,719 | ₪ 1,203,792 |
| 73 | ₪ 2,104,992 | ₪ 9,231 | ₪ 7,488 | ₪ 16,719 | ₪ 1,220,511 |
| 74 | ₪ 2,095,728 | ₪ 9,264 | ₪ 7,455 | ₪ 16,719 | ₪ 1,237,230 |
| 75 | ₪ 2,086,431 | ₪ 9,297 | ₪ 7,422 | ₪ 16,719 | ₪ 1,253,950 |
| 76 | ₪ 2,077,101 | ₪ 9,330 | ₪ 7,389 | ₪ 16,719 | ₪ 1,270,669 |
| 77 | ₪ 2,067,738 | ₪ 9,363 | ₪ 7,356 | ₪ 16,719 | ₪ 1,287,388 |
| 78 | ₪ 2,058,342 | ₪ 9,396 | ₪ 7,323 | ₪ 16,719 | ₪ 1,304,108 |
| 79 | ₪ 2,048,913 | ₪ 9,429 | ₪ 7,290 | ₪ 16,719 | ₪ 1,320,827 |
| 80 | ₪ 2,039,450 | ₪ 9,463 | ₪ 7,257 | ₪ 16,719 | ₪ 1,337,546 |
| 81 | ₪ 2,029,954 | ₪ 9,496 | ₪ 7,223 | ₪ 16,719 | ₪ 1,354,266 |
| 82 | ₪ 2,020,424 | ₪ 9,530 | ₪ 7,189 | ₪ 16,719 | ₪ 1,370,985 |
| 83 | ₪ 2,010,860 | ₪ 9,564 | ₪ 7,156 | ₪ 16,719 | ₪ 1,387,704 |
| 84 | ₪ 2,001,263 | ₪ 9,598 | ₪ 7,122 | ₪ 16,719 | ₪ 1,404,424 |
| 85 | ₪ 1,991,631 | ₪ 9,632 | ₪ 7,088 | ₪ 16,719 | ₪ 1,421,143 |
| 86 | ₪ 1,981,965 | ₪ 9,666 | ₪ 7,054 | ₪ 16,719 | ₪ 1,437,862 |
| 87 | ₪ 1,972,266 | ₪ 9,700 | ₪ 7,019 | ₪ 16,719 | ₪ 1,454,582 |
| 88 | ₪ 1,962,531 | ₪ 9,734 | ₪ 6,985 | ₪ 16,719 | ₪ 1,471,301 |
| 89 | ₪ 1,952,763 | ₪ 9,769 | ₪ 6,951 | ₪ 16,719 | ₪ 1,488,020 |
| 90 | ₪ 1,942,959 | ₪ 9,803 | ₪ 6,916 | ₪ 16,719 | ₪ 1,504,740 |
| 91 | ₪ 1,933,121 | ₪ 9,838 | ₪ 6,881 | ₪ 16,719 | ₪ 1,521,459 |
| 92 | ₪ 1,923,248 | ₪ 9,873 | ₪ 6,846 | ₪ 16,719 | ₪ 1,538,178 |
| 93 | ₪ 1,913,341 | ₪ 9,908 | ₪ 6,812 | ₪ 16,719 | ₪ 1,554,898 |
| 94 | ₪ 1,903,398 | ₪ 9,943 | ₪ 6,776 | ₪ 16,719 | ₪ 1,571,617 |
| 95 | ₪ 1,893,420 | ₪ 9,978 | ₪ 6,741 | ₪ 16,719 | ₪ 1,588,336 |
| 96 | ₪ 1,883,406 | ₪ 10,013 | ₪ 6,706 | ₪ 16,719 | ₪ 1,605,056 |
| 97 | ₪ 1,873,357 | ₪ 10,049 | ₪ 6,670 | ₪ 16,719 | ₪ 1,621,775 |
| 98 | ₪ 1,863,273 | ₪ 10,085 | ₪ 6,635 | ₪ 16,719 | ₪ 1,638,494 |
| 99 | ₪ 1,853,152 | ₪ 10,120 | ₪ 6,599 | ₪ 16,719 | ₪ 1,655,214 |
| 100 | ₪ 1,842,996 | ₪ 10,156 | ₪ 6,563 | ₪ 16,719 | ₪ 1,671,933 |
| 101 | ₪ 1,832,804 | ₪ 10,192 | ₪ 6,527 | ₪ 16,719 | ₪ 1,688,652 |
| 102 | ₪ 1,822,576 | ₪ 10,228 | ₪ 6,491 | ₪ 16,719 | ₪ 1,705,372 |
| 103 | ₪ 1,812,312 | ₪ 10,264 | ₪ 6,455 | ₪ 16,719 | ₪ 1,722,091 |
| 104 | ₪ 1,802,011 | ₪ 10,301 | ₪ 6,419 | ₪ 16,719 | ₪ 1,738,810 |
| 105 | ₪ 1,791,674 | ₪ 10,337 | ₪ 6,382 | ₪ 16,719 | ₪ 1,755,530 |
| 106 | ₪ 1,781,300 | ₪ 10,374 | ₪ 6,346 | ₪ 16,719 | ₪ 1,772,249 |
| 107 | ₪ 1,770,889 | ₪ 10,411 | ₪ 6,309 | ₪ 16,719 | ₪ 1,788,968 |
| 108 | ₪ 1,760,442 | ₪ 10,447 | ₪ 6,272 | ₪ 16,719 | ₪ 1,805,688 |
| 109 | ₪ 1,749,958 | ₪ 10,484 | ₪ 6,235 | ₪ 16,719 | ₪ 1,822,407 |
| 110 | ₪ 1,739,436 | ₪ 10,522 | ₪ 6,198 | ₪ 16,719 | ₪ 1,839,126 |
| 111 | ₪ 1,728,877 | ₪ 10,559 | ₪ 6,161 | ₪ 16,719 | ₪ 1,855,846 |
| 112 | ₪ 1,718,281 | ₪ 10,596 | ₪ 6,123 | ₪ 16,719 | ₪ 1,872,565 |
| 113 | ₪ 1,707,647 | ₪ 10,634 | ₪ 6,086 | ₪ 16,719 | ₪ 1,889,284 |
| 114 | ₪ 1,696,976 | ₪ 10,671 | ₪ 6,048 | ₪ 16,719 | ₪ 1,906,004 |
| 115 | ₪ 1,686,267 | ₪ 10,709 | ₪ 6,010 | ₪ 16,719 | ₪ 1,922,723 |
| 116 | ₪ 1,675,519 | ₪ 10,747 | ₪ 5,972 | ₪ 16,719 | ₪ 1,939,442 |
| 117 | ₪ 1,664,734 | ₪ 10,785 | ₪ 5,934 | ₪ 16,719 | ₪ 1,956,162 |
| 118 | ₪ 1,653,911 | ₪ 10,823 | ₪ 5,896 | ₪ 16,719 | ₪ 1,972,881 |
| 119 | ₪ 1,643,049 | ₪ 10,862 | ₪ 5,858 | ₪ 16,719 | ₪ 1,989,600 |
| 120 | ₪ 1,632,149 | ₪ 10,900 | ₪ 5,819 | ₪ 16,719 | ₪ 2,006,320 |
| 121 | ₪ 1,621,210 | ₪ 10,939 | ₪ 5,781 | ₪ 16,719 | ₪ 2,023,039 |
| 122 | ₪ 1,610,233 | ₪ 10,978 | ₪ 5,742 | ₪ 16,719 | ₪ 2,039,758 |
| 123 | ₪ 1,599,216 | ₪ 11,016 | ₪ 5,703 | ₪ 16,719 | ₪ 2,056,478 |
| 124 | ₪ 1,588,161 | ₪ 11,055 | ₪ 5,664 | ₪ 16,719 | ₪ 2,073,197 |
| 125 | ₪ 1,577,066 | ₪ 11,095 | ₪ 5,625 | ₪ 16,719 | ₪ 2,089,916 |
| 126 | ₪ 1,565,932 | ₪ 11,134 | ₪ 5,585 | ₪ 16,719 | ₪ 2,106,636 |
| 127 | ₪ 1,554,759 | ₪ 11,173 | ₪ 5,546 | ₪ 16,719 | ₪ 2,123,355 |
| 128 | ₪ 1,543,546 | ₪ 11,213 | ₪ 5,506 | ₪ 16,719 | ₪ 2,140,074 |
| 129 | ₪ 1,532,293 | ₪ 11,253 | ₪ 5,467 | ₪ 16,719 | ₪ 2,156,794 |
| 130 | ₪ 1,521,001 | ₪ 11,292 | ₪ 5,427 | ₪ 16,719 | ₪ 2,173,513 |
| 131 | ₪ 1,509,668 | ₪ 11,332 | ₪ 5,387 | ₪ 16,719 | ₪ 2,190,232 |
| 132 | ₪ 1,498,296 | ₪ 11,373 | ₪ 5,347 | ₪ 16,719 | ₪ 2,206,952 |
| 133 | ₪ 1,486,883 | ₪ 11,413 | ₪ 5,306 | ₪ 16,719 | ₪ 2,223,671 |
| 134 | ₪ 1,475,430 | ₪ 11,453 | ₪ 5,266 | ₪ 16,719 | ₪ 2,240,390 |
| 135 | ₪ 1,463,936 | ₪ 11,494 | ₪ 5,225 | ₪ 16,719 | ₪ 2,257,110 |
| 136 | ₪ 1,452,401 | ₪ 11,535 | ₪ 5,185 | ₪ 16,719 | ₪ 2,273,829 |
| 137 | ₪ 1,440,826 | ₪ 11,575 | ₪ 5,144 | ₪ 16,719 | ₪ 2,290,548 |
| 138 | ₪ 1,429,210 | ₪ 11,616 | ₪ 5,103 | ₪ 16,719 | ₪ 2,307,268 |
| 139 | ₪ 1,417,552 | ₪ 11,658 | ₪ 5,062 | ₪ 16,719 | ₪ 2,323,987 |
| 140 | ₪ 1,405,853 | ₪ 11,699 | ₪ 5,020 | ₪ 16,719 | ₪ 2,340,706 |
| 141 | ₪ 1,394,113 | ₪ 11,740 | ₪ 4,979 | ₪ 16,719 | ₪ 2,357,426 |
| 142 | ₪ 1,382,331 | ₪ 11,782 | ₪ 4,937 | ₪ 16,719 | ₪ 2,374,145 |
| 143 | ₪ 1,370,507 | ₪ 11,824 | ₪ 4,896 | ₪ 16,719 | ₪ 2,390,864 |
| 144 | ₪ 1,358,642 | ₪ 11,865 | ₪ 4,854 | ₪ 16,719 | ₪ 2,407,584 |
| 145 | ₪ 1,346,735 | ₪ 11,907 | ₪ 4,812 | ₪ 16,719 | ₪ 2,424,303 |
| 146 | ₪ 1,334,785 | ₪ 11,950 | ₪ 4,770 | ₪ 16,719 | ₪ 2,441,022 |
| 147 | ₪ 1,322,793 | ₪ 11,992 | ₪ 4,727 | ₪ 16,719 | ₪ 2,457,742 |
| 148 | ₪ 1,310,758 | ₪ 12,034 | ₪ 4,685 | ₪ 16,719 | ₪ 2,474,461 |
| 149 | ₪ 1,298,681 | ₪ 12,077 | ₪ 4,642 | ₪ 16,719 | ₪ 2,491,180 |
| 150 | ₪ 1,286,562 | ₪ 12,120 | ₪ 4,599 | ₪ 16,719 | ₪ 2,507,900 |
| 151 | ₪ 1,274,399 | ₪ 12,163 | ₪ 4,557 | ₪ 16,719 | ₪ 2,524,619 |
| 152 | ₪ 1,262,193 | ₪ 12,206 | ₪ 4,513 | ₪ 16,719 | ₪ 2,541,338 |
| 153 | ₪ 1,249,944 | ₪ 12,249 | ₪ 4,470 | ₪ 16,719 | ₪ 2,558,058 |
| 154 | ₪ 1,237,651 | ₪ 12,292 | ₪ 4,427 | ₪ 16,719 | ₪ 2,574,777 |
| 155 | ₪ 1,225,315 | ₪ 12,336 | ₪ 4,383 | ₪ 16,719 | ₪ 2,591,496 |
| 156 | ₪ 1,212,936 | ₪ 12,380 | ₪ 4,340 | ₪ 16,719 | ₪ 2,608,216 |
| 157 | ₪ 1,200,512 | ₪ 12,424 | ₪ 4,296 | ₪ 16,719 | ₪ 2,624,935 |
| 158 | ₪ 1,188,045 | ₪ 12,468 | ₪ 4,252 | ₪ 16,719 | ₪ 2,641,654 |
| 159 | ₪ 1,175,533 | ₪ 12,512 | ₪ 4,208 | ₪ 16,719 | ₪ 2,658,374 |
| 160 | ₪ 1,162,977 | ₪ 12,556 | ₪ 4,163 | ₪ 16,719 | ₪ 2,675,093 |
| 161 | ₪ 1,150,377 | ₪ 12,600 | ₪ 4,119 | ₪ 16,719 | ₪ 2,691,812 |
| 162 | ₪ 1,137,732 | ₪ 12,645 | ₪ 4,074 | ₪ 16,719 | ₪ 2,708,532 |
| 163 | ₪ 1,125,042 | ₪ 12,690 | ₪ 4,029 | ₪ 16,719 | ₪ 2,725,251 |
| 164 | ₪ 1,112,307 | ₪ 12,735 | ₪ 3,985 | ₪ 16,719 | ₪ 2,741,970 |
| 165 | ₪ 1,099,527 | ₪ 12,780 | ₪ 3,939 | ₪ 16,719 | ₪ 2,758,690 |
| 166 | ₪ 1,086,702 | ₪ 12,825 | ₪ 3,894 | ₪ 16,719 | ₪ 2,775,409 |
| 167 | ₪ 1,073,831 | ₪ 12,871 | ₪ 3,849 | ₪ 16,719 | ₪ 2,792,128 |
| 168 | ₪ 1,060,915 | ₪ 12,916 | ₪ 3,803 | ₪ 16,719 | ₪ 2,808,848 |
| 169 | ₪ 1,047,953 | ₪ 12,962 | ₪ 3,757 | ₪ 16,719 | ₪ 2,825,567 |
| 170 | ₪ 1,034,945 | ₪ 13,008 | ₪ 3,712 | ₪ 16,719 | ₪ 2,842,286 |
| 171 | ₪ 1,021,891 | ₪ 13,054 | ₪ 3,665 | ₪ 16,719 | ₪ 2,859,006 |
| 172 | ₪ 1,008,791 | ₪ 13,100 | ₪ 3,619 | ₪ 16,719 | ₪ 2,875,725 |
| 173 | ₪ 995,645 | ₪ 13,147 | ₪ 3,573 | ₪ 16,719 | ₪ 2,892,444 |
| 174 | ₪ 982,452 | ₪ 13,193 | ₪ 3,526 | ₪ 16,719 | ₪ 2,909,164 |
| 175 | ₪ 969,212 | ₪ 13,240 | ₪ 3,480 | ₪ 16,719 | ₪ 2,925,883 |
| 176 | ₪ 955,925 | ₪ 13,287 | ₪ 3,433 | ₪ 16,719 | ₪ 2,942,602 |
| 177 | ₪ 942,591 | ₪ 13,334 | ₪ 3,386 | ₪ 16,719 | ₪ 2,959,322 |
| 178 | ₪ 929,210 | ₪ 13,381 | ₪ 3,338 | ₪ 16,719 | ₪ 2,976,041 |
| 179 | ₪ 915,782 | ₪ 13,428 | ₪ 3,291 | ₪ 16,719 | ₪ 2,992,760 |
| 180 | ₪ 902,306 | ₪ 13,476 | ₪ 3,243 | ₪ 16,719 | ₪ 3,009,480 |
| 181 | ₪ 888,782 | ₪ 13,524 | ₪ 3,196 | ₪ 16,719 | ₪ 3,026,199 |
| 182 | ₪ 875,211 | ₪ 13,572 | ₪ 3,148 | ₪ 16,719 | ₪ 3,042,918 |
| 183 | ₪ 861,591 | ₪ 13,620 | ₪ 3,100 | ₪ 16,719 | ₪ 3,059,638 |
| 184 | ₪ 847,923 | ₪ 13,668 | ₪ 3,051 | ₪ 16,719 | ₪ 3,076,357 |
| 185 | ₪ 834,207 | ₪ 13,716 | ₪ 3,003 | ₪ 16,719 | ₪ 3,093,076 |
| 186 | ₪ 820,442 | ₪ 13,765 | ₪ 2,954 | ₪ 16,719 | ₪ 3,109,796 |
| 187 | ₪ 806,629 | ₪ 13,814 | ₪ 2,906 | ₪ 16,719 | ₪ 3,126,515 |
| 188 | ₪ 792,766 | ₪ 13,863 | ₪ 2,857 | ₪ 16,719 | ₪ 3,143,234 |
| 189 | ₪ 778,855 | ₪ 13,912 | ₪ 2,808 | ₪ 16,719 | ₪ 3,159,953 |
| 190 | ₪ 764,894 | ₪ 13,961 | ₪ 2,758 | ₪ 16,719 | ₪ 3,176,673 |
| 191 | ₪ 750,883 | ₪ 14,010 | ₪ 2,709 | ₪ 16,719 | ₪ 3,193,392 |
| 192 | ₪ 736,823 | ₪ 14,060 | ₪ 2,659 | ₪ 16,719 | ₪ 3,210,111 |
| 193 | ₪ 722,714 | ₪ 14,110 | ₪ 2,610 | ₪ 16,719 | ₪ 3,226,831 |
| 194 | ₪ 708,554 | ₪ 14,160 | ₪ 2,560 | ₪ 16,719 | ₪ 3,243,550 |
| 195 | ₪ 694,344 | ₪ 14,210 | ₪ 2,509 | ₪ 16,719 | ₪ 3,260,269 |
| 196 | ₪ 680,084 | ₪ 14,260 | ₪ 2,459 | ₪ 16,719 | ₪ 3,276,989 |
| 197 | ₪ 665,773 | ₪ 14,311 | ₪ 2,409 | ₪ 16,719 | ₪ 3,293,708 |
| 198 | ₪ 651,412 | ₪ 14,361 | ₪ 2,358 | ₪ 16,719 | ₪ 3,310,427 |
| 199 | ₪ 636,999 | ₪ 14,412 | ₪ 2,307 | ₪ 16,719 | ₪ 3,327,147 |
| 200 | ₪ 622,536 | ₪ 14,463 | ₪ 2,256 | ₪ 16,719 | ₪ 3,343,866 |
| 201 | ₪ 608,022 | ₪ 14,515 | ₪ 2,205 | ₪ 16,719 | ₪ 3,360,585 |
| 202 | ₪ 593,456 | ₪ 14,566 | ₪ 2,153 | ₪ 16,719 | ₪ 3,377,305 |
| 203 | ₪ 578,838 | ₪ 14,618 | ₪ 2,102 | ₪ 16,719 | ₪ 3,394,024 |
| 204 | ₪ 564,169 | ₪ 14,669 | ₪ 2,050 | ₪ 16,719 | ₪ 3,410,743 |
| 205 | ₪ 549,448 | ₪ 14,721 | ₪ 1,998 | ₪ 16,719 | ₪ 3,427,463 |
| 206 | ₪ 534,674 | ₪ 14,773 | ₪ 1,946 | ₪ 16,719 | ₪ 3,444,182 |
| 207 | ₪ 519,849 | ₪ 14,826 | ₪ 1,894 | ₪ 16,719 | ₪ 3,460,901 |
| 208 | ₪ 504,970 | ₪ 14,878 | ₪ 1,841 | ₪ 16,719 | ₪ 3,477,621 |
| 209 | ₪ 490,040 | ₪ 14,931 | ₪ 1,788 | ₪ 16,719 | ₪ 3,494,340 |
| 210 | ₪ 475,056 | ₪ 14,984 | ₪ 1,736 | ₪ 16,719 | ₪ 3,511,059 |
| 211 | ₪ 460,019 | ₪ 15,037 | ₪ 1,682 | ₪ 16,719 | ₪ 3,527,779 |
| 212 | ₪ 444,929 | ₪ 15,090 | ₪ 1,629 | ₪ 16,719 | ₪ 3,544,498 |
| 213 | ₪ 429,785 | ₪ 15,144 | ₪ 1,576 | ₪ 16,719 | ₪ 3,561,217 |
| 214 | ₪ 414,588 | ₪ 15,197 | ₪ 1,522 | ₪ 16,719 | ₪ 3,577,937 |
| 215 | ₪ 399,337 | ₪ 15,251 | ₪ 1,468 | ₪ 16,719 | ₪ 3,594,656 |
| 216 | ₪ 384,032 | ₪ 15,305 | ₪ 1,414 | ₪ 16,719 | ₪ 3,611,375 |
| 217 | ₪ 368,673 | ₪ 15,359 | ₪ 1,360 | ₪ 16,719 | ₪ 3,628,095 |
| 218 | ₪ 353,259 | ₪ 15,414 | ₪ 1,306 | ₪ 16,719 | ₪ 3,644,814 |
| 219 | ₪ 337,791 | ₪ 15,468 | ₪ 1,251 | ₪ 16,719 | ₪ 3,661,533 |
| 220 | ₪ 322,268 | ₪ 15,523 | ₪ 1,196 | ₪ 16,719 | ₪ 3,678,253 |
| 221 | ₪ 306,690 | ₪ 15,578 | ₪ 1,141 | ₪ 16,719 | ₪ 3,694,972 |
| 222 | ₪ 291,057 | ₪ 15,633 | ₪ 1,086 | ₪ 16,719 | ₪ 3,711,691 |
| 223 | ₪ 275,369 | ₪ 15,689 | ₪ 1,031 | ₪ 16,719 | ₪ 3,728,411 |
| 224 | ₪ 259,624 | ₪ 15,744 | ₪ 975 | ₪ 16,719 | ₪ 3,745,130 |
| 225 | ₪ 243,825 | ₪ 15,800 | ₪ 920 | ₪ 16,719 | ₪ 3,761,849 |
| 226 | ₪ 227,969 | ₪ 15,856 | ₪ 864 | ₪ 16,719 | ₪ 3,778,569 |
| 227 | ₪ 212,057 | ₪ 15,912 | ₪ 807 | ₪ 16,719 | ₪ 3,795,288 |
| 228 | ₪ 196,089 | ₪ 15,968 | ₪ 751 | ₪ 16,719 | ₪ 3,812,007 |
| 229 | ₪ 180,064 | ₪ 16,025 | ₪ 694 | ₪ 16,719 | ₪ 3,828,727 |
| 230 | ₪ 163,982 | ₪ 16,082 | ₪ 638 | ₪ 16,719 | ₪ 3,845,446 |
| 231 | ₪ 147,844 | ₪ 16,139 | ₪ 581 | ₪ 16,719 | ₪ 3,862,165 |
| 232 | ₪ 131,648 | ₪ 16,196 | ₪ 524 | ₪ 16,719 | ₪ 3,878,885 |
| 233 | ₪ 115,395 | ₪ 16,253 | ₪ 466 | ₪ 16,719 | ₪ 3,895,604 |
| 234 | ₪ 99,084 | ₪ 16,311 | ₪ 409 | ₪ 16,719 | ₪ 3,912,323 |
| 235 | ₪ 82,716 | ₪ 16,368 | ₪ 351 | ₪ 16,719 | ₪ 3,929,043 |
| 236 | ₪ 66,289 | ₪ 16,426 | ₪ 293 | ₪ 16,719 | ₪ 3,945,762 |
| 237 | ₪ 49,805 | ₪ 16,485 | ₪ 235 | ₪ 16,719 | ₪ 3,962,481 |
| 238 | ₪ 33,262 | ₪ 16,543 | ₪ 176 | ₪ 16,719 | ₪ 3,979,201 |
| 239 | ₪ 16,660 | ₪ 16,602 | ₪ 118 | ₪ 16,719 | ₪ 3,995,920 |
| 240 | ₪ 0 | ₪ 16,660 | ₪ 59 | ₪ 16,719 | ₪ 4,012,639 |
| סה"כ | ₪ 2,700,000 | ₪ 1,312,639 | ₪ 4,012,639 | ₪ 4,012,639 |
ראו גם: מה ההחזר על משכנתא של 2,600,000 שח? | מה ההחזר על משכנתא של 2,800,000 שח?