19,196 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 3,100,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שלושה מיליון ומאה אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
19,196 ש"ח
1,507,104 ש"ח
4,607,104 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 3,091,783 | ₪ 8,217 | ₪ 10,979 | ₪ 19,196 | ₪ 19,196 |
| 2 | ₪ 3,083,537 | ₪ 8,246 | ₪ 10,950 | ₪ 19,196 | ₪ 38,393 |
| 3 | ₪ 3,075,261 | ₪ 8,275 | ₪ 10,921 | ₪ 19,196 | ₪ 57,589 |
| 4 | ₪ 3,066,957 | ₪ 8,305 | ₪ 10,892 | ₪ 19,196 | ₪ 76,785 |
| 5 | ₪ 3,058,622 | ₪ 8,334 | ₪ 10,862 | ₪ 19,196 | ₪ 95,981 |
| 6 | ₪ 3,050,259 | ₪ 8,364 | ₪ 10,833 | ₪ 19,196 | ₪ 115,178 |
| 7 | ₪ 3,041,866 | ₪ 8,393 | ₪ 10,803 | ₪ 19,196 | ₪ 134,374 |
| 8 | ₪ 3,033,443 | ₪ 8,423 | ₪ 10,773 | ₪ 19,196 | ₪ 153,570 |
| 9 | ₪ 3,024,990 | ₪ 8,453 | ₪ 10,743 | ₪ 19,196 | ₪ 172,766 |
| 10 | ₪ 3,016,507 | ₪ 8,483 | ₪ 10,714 | ₪ 19,196 | ₪ 191,963 |
| 11 | ₪ 3,007,994 | ₪ 8,513 | ₪ 10,683 | ₪ 19,196 | ₪ 211,159 |
| 12 | ₪ 2,999,451 | ₪ 8,543 | ₪ 10,653 | ₪ 19,196 | ₪ 230,355 |
| 13 | ₪ 2,990,878 | ₪ 8,573 | ₪ 10,623 | ₪ 19,196 | ₪ 249,551 |
| 14 | ₪ 2,982,274 | ₪ 8,604 | ₪ 10,593 | ₪ 19,196 | ₪ 268,748 |
| 15 | ₪ 2,973,640 | ₪ 8,634 | ₪ 10,562 | ₪ 19,196 | ₪ 287,944 |
| 16 | ₪ 2,964,976 | ₪ 8,665 | ₪ 10,532 | ₪ 19,196 | ₪ 307,140 |
| 17 | ₪ 2,956,280 | ₪ 8,695 | ₪ 10,501 | ₪ 19,196 | ₪ 326,337 |
| 18 | ₪ 2,947,554 | ₪ 8,726 | ₪ 10,470 | ₪ 19,196 | ₪ 345,533 |
| 19 | ₪ 2,938,797 | ₪ 8,757 | ₪ 10,439 | ₪ 19,196 | ₪ 364,729 |
| 20 | ₪ 2,930,009 | ₪ 8,788 | ₪ 10,408 | ₪ 19,196 | ₪ 383,925 |
| 21 | ₪ 2,921,190 | ₪ 8,819 | ₪ 10,377 | ₪ 19,196 | ₪ 403,122 |
| 22 | ₪ 2,912,340 | ₪ 8,850 | ₪ 10,346 | ₪ 19,196 | ₪ 422,318 |
| 23 | ₪ 2,903,458 | ₪ 8,882 | ₪ 10,315 | ₪ 19,196 | ₪ 441,514 |
| 24 | ₪ 2,894,545 | ₪ 8,913 | ₪ 10,283 | ₪ 19,196 | ₪ 460,710 |
| 25 | ₪ 2,885,600 | ₪ 8,945 | ₪ 10,252 | ₪ 19,196 | ₪ 479,907 |
| 26 | ₪ 2,876,624 | ₪ 8,976 | ₪ 10,220 | ₪ 19,196 | ₪ 499,103 |
| 27 | ₪ 2,867,615 | ₪ 9,008 | ₪ 10,188 | ₪ 19,196 | ₪ 518,299 |
| 28 | ₪ 2,858,575 | ₪ 9,040 | ₪ 10,156 | ₪ 19,196 | ₪ 537,496 |
| 29 | ₪ 2,849,503 | ₪ 9,072 | ₪ 10,124 | ₪ 19,196 | ₪ 556,692 |
| 30 | ₪ 2,840,399 | ₪ 9,104 | ₪ 10,092 | ₪ 19,196 | ₪ 575,888 |
| 31 | ₪ 2,831,262 | ₪ 9,137 | ₪ 10,060 | ₪ 19,196 | ₪ 595,084 |
| 32 | ₪ 2,822,093 | ₪ 9,169 | ₪ 10,027 | ₪ 19,196 | ₪ 614,281 |
| 33 | ₪ 2,812,892 | ₪ 9,201 | ₪ 9,995 | ₪ 19,196 | ₪ 633,477 |
| 34 | ₪ 2,803,658 | ₪ 9,234 | ₪ 9,962 | ₪ 19,196 | ₪ 652,673 |
| 35 | ₪ 2,794,391 | ₪ 9,267 | ₪ 9,930 | ₪ 19,196 | ₪ 671,869 |
| 36 | ₪ 2,785,092 | ₪ 9,299 | ₪ 9,897 | ₪ 19,196 | ₪ 691,066 |
| 37 | ₪ 2,775,760 | ₪ 9,332 | ₪ 9,864 | ₪ 19,196 | ₪ 710,262 |
| 38 | ₪ 2,766,394 | ₪ 9,365 | ₪ 9,831 | ₪ 19,196 | ₪ 729,458 |
| 39 | ₪ 2,756,996 | ₪ 9,399 | ₪ 9,798 | ₪ 19,196 | ₪ 748,654 |
| 40 | ₪ 2,747,564 | ₪ 9,432 | ₪ 9,764 | ₪ 19,196 | ₪ 767,851 |
| 41 | ₪ 2,738,098 | ₪ 9,465 | ₪ 9,731 | ₪ 19,196 | ₪ 787,047 |
| 42 | ₪ 2,728,599 | ₪ 9,499 | ₪ 9,697 | ₪ 19,196 | ₪ 806,243 |
| 43 | ₪ 2,719,067 | ₪ 9,532 | ₪ 9,664 | ₪ 19,196 | ₪ 825,440 |
| 44 | ₪ 2,709,501 | ₪ 9,566 | ₪ 9,630 | ₪ 19,196 | ₪ 844,636 |
| 45 | ₪ 2,699,901 | ₪ 9,600 | ₪ 9,596 | ₪ 19,196 | ₪ 863,832 |
| 46 | ₪ 2,690,267 | ₪ 9,634 | ₪ 9,562 | ₪ 19,196 | ₪ 883,028 |
| 47 | ₪ 2,680,598 | ₪ 9,668 | ₪ 9,528 | ₪ 19,196 | ₪ 902,225 |
| 48 | ₪ 2,670,896 | ₪ 9,702 | ₪ 9,494 | ₪ 19,196 | ₪ 921,421 |
| 49 | ₪ 2,661,159 | ₪ 9,737 | ₪ 9,459 | ₪ 19,196 | ₪ 940,617 |
| 50 | ₪ 2,651,388 | ₪ 9,771 | ₪ 9,425 | ₪ 19,196 | ₪ 959,813 |
| 51 | ₪ 2,641,582 | ₪ 9,806 | ₪ 9,390 | ₪ 19,196 | ₪ 979,010 |
| 52 | ₪ 2,631,741 | ₪ 9,841 | ₪ 9,356 | ₪ 19,196 | ₪ 998,206 |
| 53 | ₪ 2,621,865 | ₪ 9,876 | ₪ 9,321 | ₪ 19,196 | ₪ 1,017,402 |
| 54 | ₪ 2,611,955 | ₪ 9,910 | ₪ 9,286 | ₪ 19,196 | ₪ 1,036,599 |
| 55 | ₪ 2,602,009 | ₪ 9,946 | ₪ 9,251 | ₪ 19,196 | ₪ 1,055,795 |
| 56 | ₪ 2,592,029 | ₪ 9,981 | ₪ 9,215 | ₪ 19,196 | ₪ 1,074,991 |
| 57 | ₪ 2,582,012 | ₪ 10,016 | ₪ 9,180 | ₪ 19,196 | ₪ 1,094,187 |
| 58 | ₪ 2,571,961 | ₪ 10,052 | ₪ 9,145 | ₪ 19,196 | ₪ 1,113,384 |
| 59 | ₪ 2,561,874 | ₪ 10,087 | ₪ 9,109 | ₪ 19,196 | ₪ 1,132,580 |
| 60 | ₪ 2,551,751 | ₪ 10,123 | ₪ 9,073 | ₪ 19,196 | ₪ 1,151,776 |
| 61 | ₪ 2,541,592 | ₪ 10,159 | ₪ 9,037 | ₪ 19,196 | ₪ 1,170,972 |
| 62 | ₪ 2,531,397 | ₪ 10,195 | ₪ 9,001 | ₪ 19,196 | ₪ 1,190,169 |
| 63 | ₪ 2,521,166 | ₪ 10,231 | ₪ 8,965 | ₪ 19,196 | ₪ 1,209,365 |
| 64 | ₪ 2,510,899 | ₪ 10,267 | ₪ 8,929 | ₪ 19,196 | ₪ 1,228,561 |
| 65 | ₪ 2,500,595 | ₪ 10,304 | ₪ 8,893 | ₪ 19,196 | ₪ 1,247,757 |
| 66 | ₪ 2,490,255 | ₪ 10,340 | ₪ 8,856 | ₪ 19,196 | ₪ 1,266,954 |
| 67 | ₪ 2,479,879 | ₪ 10,377 | ₪ 8,820 | ₪ 19,196 | ₪ 1,286,150 |
| 68 | ₪ 2,469,465 | ₪ 10,413 | ₪ 8,783 | ₪ 19,196 | ₪ 1,305,346 |
| 69 | ₪ 2,459,015 | ₪ 10,450 | ₪ 8,746 | ₪ 19,196 | ₪ 1,324,543 |
| 70 | ₪ 2,448,528 | ₪ 10,487 | ₪ 8,709 | ₪ 19,196 | ₪ 1,343,739 |
| 71 | ₪ 2,438,004 | ₪ 10,524 | ₪ 8,672 | ₪ 19,196 | ₪ 1,362,935 |
| 72 | ₪ 2,427,442 | ₪ 10,562 | ₪ 8,635 | ₪ 19,196 | ₪ 1,382,131 |
| 73 | ₪ 2,416,843 | ₪ 10,599 | ₪ 8,597 | ₪ 19,196 | ₪ 1,401,328 |
| 74 | ₪ 2,406,206 | ₪ 10,637 | ₪ 8,560 | ₪ 19,196 | ₪ 1,420,524 |
| 75 | ₪ 2,395,532 | ₪ 10,674 | ₪ 8,522 | ₪ 19,196 | ₪ 1,439,720 |
| 76 | ₪ 2,384,820 | ₪ 10,712 | ₪ 8,484 | ₪ 19,196 | ₪ 1,458,916 |
| 77 | ₪ 2,374,070 | ₪ 10,750 | ₪ 8,446 | ₪ 19,196 | ₪ 1,478,113 |
| 78 | ₪ 2,363,282 | ₪ 10,788 | ₪ 8,408 | ₪ 19,196 | ₪ 1,497,309 |
| 79 | ₪ 2,352,455 | ₪ 10,826 | ₪ 8,370 | ₪ 19,196 | ₪ 1,516,505 |
| 80 | ₪ 2,341,591 | ₪ 10,865 | ₪ 8,332 | ₪ 19,196 | ₪ 1,535,701 |
| 81 | ₪ 2,330,688 | ₪ 10,903 | ₪ 8,293 | ₪ 19,196 | ₪ 1,554,898 |
| 82 | ₪ 2,319,746 | ₪ 10,942 | ₪ 8,255 | ₪ 19,196 | ₪ 1,574,094 |
| 83 | ₪ 2,308,765 | ₪ 10,981 | ₪ 8,216 | ₪ 19,196 | ₪ 1,593,290 |
| 84 | ₪ 2,297,746 | ₪ 11,019 | ₪ 8,177 | ₪ 19,196 | ₪ 1,612,487 |
| 85 | ₪ 2,286,687 | ₪ 11,058 | ₪ 8,138 | ₪ 19,196 | ₪ 1,631,683 |
| 86 | ₪ 2,275,590 | ₪ 11,098 | ₪ 8,099 | ₪ 19,196 | ₪ 1,650,879 |
| 87 | ₪ 2,264,453 | ₪ 11,137 | ₪ 8,059 | ₪ 19,196 | ₪ 1,670,075 |
| 88 | ₪ 2,253,277 | ₪ 11,176 | ₪ 8,020 | ₪ 19,196 | ₪ 1,689,272 |
| 89 | ₪ 2,242,061 | ₪ 11,216 | ₪ 7,980 | ₪ 19,196 | ₪ 1,708,468 |
| 90 | ₪ 2,230,805 | ₪ 11,256 | ₪ 7,941 | ₪ 19,196 | ₪ 1,727,664 |
| 91 | ₪ 2,219,510 | ₪ 11,296 | ₪ 7,901 | ₪ 19,196 | ₪ 1,746,860 |
| 92 | ₪ 2,208,174 | ₪ 11,336 | ₪ 7,861 | ₪ 19,196 | ₪ 1,766,057 |
| 93 | ₪ 2,196,798 | ₪ 11,376 | ₪ 7,821 | ₪ 19,196 | ₪ 1,785,253 |
| 94 | ₪ 2,185,383 | ₪ 11,416 | ₪ 7,780 | ₪ 19,196 | ₪ 1,804,449 |
| 95 | ₪ 2,173,926 | ₪ 11,456 | ₪ 7,740 | ₪ 19,196 | ₪ 1,823,646 |
| 96 | ₪ 2,162,429 | ₪ 11,497 | ₪ 7,699 | ₪ 19,196 | ₪ 1,842,842 |
| 97 | ₪ 2,150,892 | ₪ 11,538 | ₪ 7,659 | ₪ 19,196 | ₪ 1,862,038 |
| 98 | ₪ 2,139,313 | ₪ 11,579 | ₪ 7,618 | ₪ 19,196 | ₪ 1,881,234 |
| 99 | ₪ 2,127,693 | ₪ 11,620 | ₪ 7,577 | ₪ 19,196 | ₪ 1,900,431 |
| 100 | ₪ 2,116,033 | ₪ 11,661 | ₪ 7,536 | ₪ 19,196 | ₪ 1,919,627 |
| 101 | ₪ 2,104,331 | ₪ 11,702 | ₪ 7,494 | ₪ 19,196 | ₪ 1,938,823 |
| 102 | ₪ 2,092,587 | ₪ 11,743 | ₪ 7,453 | ₪ 19,196 | ₪ 1,958,019 |
| 103 | ₪ 2,080,802 | ₪ 11,785 | ₪ 7,411 | ₪ 19,196 | ₪ 1,977,216 |
| 104 | ₪ 2,068,976 | ₪ 11,827 | ₪ 7,370 | ₪ 19,196 | ₪ 1,996,412 |
| 105 | ₪ 2,057,107 | ₪ 11,869 | ₪ 7,328 | ₪ 19,196 | ₪ 2,015,608 |
| 106 | ₪ 2,045,196 | ₪ 11,911 | ₪ 7,286 | ₪ 19,196 | ₪ 2,034,804 |
| 107 | ₪ 2,033,243 | ₪ 11,953 | ₪ 7,243 | ₪ 19,196 | ₪ 2,054,001 |
| 108 | ₪ 2,021,248 | ₪ 11,995 | ₪ 7,201 | ₪ 19,196 | ₪ 2,073,197 |
| 109 | ₪ 2,009,211 | ₪ 12,038 | ₪ 7,159 | ₪ 19,196 | ₪ 2,092,393 |
| 110 | ₪ 1,997,130 | ₪ 12,080 | ₪ 7,116 | ₪ 19,196 | ₪ 2,111,590 |
| 111 | ₪ 1,985,007 | ₪ 12,123 | ₪ 7,073 | ₪ 19,196 | ₪ 2,130,786 |
| 112 | ₪ 1,972,841 | ₪ 12,166 | ₪ 7,030 | ₪ 19,196 | ₪ 2,149,982 |
| 113 | ₪ 1,960,632 | ₪ 12,209 | ₪ 6,987 | ₪ 19,196 | ₪ 2,169,178 |
| 114 | ₪ 1,948,380 | ₪ 12,252 | ₪ 6,944 | ₪ 19,196 | ₪ 2,188,375 |
| 115 | ₪ 1,936,084 | ₪ 12,296 | ₪ 6,901 | ₪ 19,196 | ₪ 2,207,571 |
| 116 | ₪ 1,923,745 | ₪ 12,339 | ₪ 6,857 | ₪ 19,196 | ₪ 2,226,767 |
| 117 | ₪ 1,911,362 | ₪ 12,383 | ₪ 6,813 | ₪ 19,196 | ₪ 2,245,963 |
| 118 | ₪ 1,898,935 | ₪ 12,427 | ₪ 6,769 | ₪ 19,196 | ₪ 2,265,160 |
| 119 | ₪ 1,886,464 | ₪ 12,471 | ₪ 6,725 | ₪ 19,196 | ₪ 2,284,356 |
| 120 | ₪ 1,873,949 | ₪ 12,515 | ₪ 6,681 | ₪ 19,196 | ₪ 2,303,552 |
| 121 | ₪ 1,861,389 | ₪ 12,559 | ₪ 6,637 | ₪ 19,196 | ₪ 2,322,748 |
| 122 | ₪ 1,848,786 | ₪ 12,604 | ₪ 6,592 | ₪ 19,196 | ₪ 2,341,945 |
| 123 | ₪ 1,836,137 | ₪ 12,648 | ₪ 6,548 | ₪ 19,196 | ₪ 2,361,141 |
| 124 | ₪ 1,823,444 | ₪ 12,693 | ₪ 6,503 | ₪ 19,196 | ₪ 2,380,337 |
| 125 | ₪ 1,810,706 | ₪ 12,738 | ₪ 6,458 | ₪ 19,196 | ₪ 2,399,534 |
| 126 | ₪ 1,797,922 | ₪ 12,783 | ₪ 6,413 | ₪ 19,196 | ₪ 2,418,730 |
| 127 | ₪ 1,785,094 | ₪ 12,829 | ₪ 6,368 | ₪ 19,196 | ₪ 2,437,926 |
| 128 | ₪ 1,772,219 | ₪ 12,874 | ₪ 6,322 | ₪ 19,196 | ₪ 2,457,122 |
| 129 | ₪ 1,759,300 | ₪ 12,920 | ₪ 6,277 | ₪ 19,196 | ₪ 2,476,319 |
| 130 | ₪ 1,746,334 | ₪ 12,965 | ₪ 6,231 | ₪ 19,196 | ₪ 2,495,515 |
| 131 | ₪ 1,733,323 | ₪ 13,011 | ₪ 6,185 | ₪ 19,196 | ₪ 2,514,711 |
| 132 | ₪ 1,720,266 | ₪ 13,057 | ₪ 6,139 | ₪ 19,196 | ₪ 2,533,907 |
| 133 | ₪ 1,707,162 | ₪ 13,104 | ₪ 6,093 | ₪ 19,196 | ₪ 2,553,104 |
| 134 | ₪ 1,694,012 | ₪ 13,150 | ₪ 6,046 | ₪ 19,196 | ₪ 2,572,300 |
| 135 | ₪ 1,680,815 | ₪ 13,197 | ₪ 6,000 | ₪ 19,196 | ₪ 2,591,496 |
| 136 | ₪ 1,667,572 | ₪ 13,243 | ₪ 5,953 | ₪ 19,196 | ₪ 2,610,693 |
| 137 | ₪ 1,654,282 | ₪ 13,290 | ₪ 5,906 | ₪ 19,196 | ₪ 2,629,889 |
| 138 | ₪ 1,640,944 | ₪ 13,337 | ₪ 5,859 | ₪ 19,196 | ₪ 2,649,085 |
| 139 | ₪ 1,627,560 | ₪ 13,385 | ₪ 5,812 | ₪ 19,196 | ₪ 2,668,281 |
| 140 | ₪ 1,614,128 | ₪ 13,432 | ₪ 5,764 | ₪ 19,196 | ₪ 2,687,478 |
| 141 | ₪ 1,600,648 | ₪ 13,480 | ₪ 5,717 | ₪ 19,196 | ₪ 2,706,674 |
| 142 | ₪ 1,587,121 | ₪ 13,527 | ₪ 5,669 | ₪ 19,196 | ₪ 2,725,870 |
| 143 | ₪ 1,573,546 | ₪ 13,575 | ₪ 5,621 | ₪ 19,196 | ₪ 2,745,066 |
| 144 | ₪ 1,559,922 | ₪ 13,623 | ₪ 5,573 | ₪ 19,196 | ₪ 2,764,263 |
| 145 | ₪ 1,546,251 | ₪ 13,672 | ₪ 5,525 | ₪ 19,196 | ₪ 2,783,459 |
| 146 | ₪ 1,532,531 | ₪ 13,720 | ₪ 5,476 | ₪ 19,196 | ₪ 2,802,655 |
| 147 | ₪ 1,518,762 | ₪ 13,769 | ₪ 5,428 | ₪ 19,196 | ₪ 2,821,851 |
| 148 | ₪ 1,504,945 | ₪ 13,817 | ₪ 5,379 | ₪ 19,196 | ₪ 2,841,048 |
| 149 | ₪ 1,491,079 | ₪ 13,866 | ₪ 5,330 | ₪ 19,196 | ₪ 2,860,244 |
| 150 | ₪ 1,477,163 | ₪ 13,915 | ₪ 5,281 | ₪ 19,196 | ₪ 2,879,440 |
| 151 | ₪ 1,463,199 | ₪ 13,965 | ₪ 5,232 | ₪ 19,196 | ₪ 2,898,637 |
| 152 | ₪ 1,449,185 | ₪ 14,014 | ₪ 5,182 | ₪ 19,196 | ₪ 2,917,833 |
| 153 | ₪ 1,435,121 | ₪ 14,064 | ₪ 5,133 | ₪ 19,196 | ₪ 2,937,029 |
| 154 | ₪ 1,421,007 | ₪ 14,114 | ₪ 5,083 | ₪ 19,196 | ₪ 2,956,225 |
| 155 | ₪ 1,406,844 | ₪ 14,164 | ₪ 5,033 | ₪ 19,196 | ₪ 2,975,422 |
| 156 | ₪ 1,392,630 | ₪ 14,214 | ₪ 4,983 | ₪ 19,196 | ₪ 2,994,618 |
| 157 | ₪ 1,378,366 | ₪ 14,264 | ₪ 4,932 | ₪ 19,196 | ₪ 3,013,814 |
| 158 | ₪ 1,364,051 | ₪ 14,315 | ₪ 4,882 | ₪ 19,196 | ₪ 3,033,010 |
| 159 | ₪ 1,349,686 | ₪ 14,365 | ₪ 4,831 | ₪ 19,196 | ₪ 3,052,207 |
| 160 | ₪ 1,335,270 | ₪ 14,416 | ₪ 4,780 | ₪ 19,196 | ₪ 3,071,403 |
| 161 | ₪ 1,320,803 | ₪ 14,467 | ₪ 4,729 | ₪ 19,196 | ₪ 3,090,599 |
| 162 | ₪ 1,306,284 | ₪ 14,518 | ₪ 4,678 | ₪ 19,196 | ₪ 3,109,796 |
| 163 | ₪ 1,291,715 | ₪ 14,570 | ₪ 4,626 | ₪ 19,196 | ₪ 3,128,992 |
| 164 | ₪ 1,277,093 | ₪ 14,621 | ₪ 4,575 | ₪ 19,196 | ₪ 3,148,188 |
| 165 | ₪ 1,262,420 | ₪ 14,673 | ₪ 4,523 | ₪ 19,196 | ₪ 3,167,384 |
| 166 | ₪ 1,247,695 | ₪ 14,725 | ₪ 4,471 | ₪ 19,196 | ₪ 3,186,581 |
| 167 | ₪ 1,232,917 | ₪ 14,777 | ₪ 4,419 | ₪ 19,196 | ₪ 3,205,777 |
| 168 | ₪ 1,218,088 | ₪ 14,830 | ₪ 4,367 | ₪ 19,196 | ₪ 3,224,973 |
| 169 | ₪ 1,203,205 | ₪ 14,882 | ₪ 4,314 | ₪ 19,196 | ₪ 3,244,169 |
| 170 | ₪ 1,188,271 | ₪ 14,935 | ₪ 4,261 | ₪ 19,196 | ₪ 3,263,366 |
| 171 | ₪ 1,173,283 | ₪ 14,988 | ₪ 4,208 | ₪ 19,196 | ₪ 3,282,562 |
| 172 | ₪ 1,158,242 | ₪ 15,041 | ₪ 4,155 | ₪ 19,196 | ₪ 3,301,758 |
| 173 | ₪ 1,143,148 | ₪ 15,094 | ₪ 4,102 | ₪ 19,196 | ₪ 3,320,954 |
| 174 | ₪ 1,128,000 | ₪ 15,148 | ₪ 4,049 | ₪ 19,196 | ₪ 3,340,151 |
| 175 | ₪ 1,112,799 | ₪ 15,201 | ₪ 3,995 | ₪ 19,196 | ₪ 3,359,347 |
| 176 | ₪ 1,097,544 | ₪ 15,255 | ₪ 3,941 | ₪ 19,196 | ₪ 3,378,543 |
| 177 | ₪ 1,082,235 | ₪ 15,309 | ₪ 3,887 | ₪ 19,196 | ₪ 3,397,740 |
| 178 | ₪ 1,066,871 | ₪ 15,363 | ₪ 3,833 | ₪ 19,196 | ₪ 3,416,936 |
| 179 | ₪ 1,051,453 | ₪ 15,418 | ₪ 3,779 | ₪ 19,196 | ₪ 3,436,132 |
| 180 | ₪ 1,035,981 | ₪ 15,472 | ₪ 3,724 | ₪ 19,196 | ₪ 3,455,328 |
| 181 | ₪ 1,020,454 | ₪ 15,527 | ₪ 3,669 | ₪ 19,196 | ₪ 3,474,525 |
| 182 | ₪ 1,004,872 | ₪ 15,582 | ₪ 3,614 | ₪ 19,196 | ₪ 3,493,721 |
| 183 | ₪ 989,234 | ₪ 15,637 | ₪ 3,559 | ₪ 19,196 | ₪ 3,512,917 |
| 184 | ₪ 973,542 | ₪ 15,693 | ₪ 3,504 | ₪ 19,196 | ₪ 3,532,113 |
| 185 | ₪ 957,793 | ₪ 15,748 | ₪ 3,448 | ₪ 19,196 | ₪ 3,551,310 |
| 186 | ₪ 941,989 | ₪ 15,804 | ₪ 3,392 | ₪ 19,196 | ₪ 3,570,506 |
| 187 | ₪ 926,129 | ₪ 15,860 | ₪ 3,336 | ₪ 19,196 | ₪ 3,589,702 |
| 188 | ₪ 910,213 | ₪ 15,916 | ₪ 3,280 | ₪ 19,196 | ₪ 3,608,898 |
| 189 | ₪ 894,240 | ₪ 15,973 | ₪ 3,224 | ₪ 19,196 | ₪ 3,628,095 |
| 190 | ₪ 878,211 | ₪ 16,029 | ₪ 3,167 | ₪ 19,196 | ₪ 3,647,291 |
| 191 | ₪ 862,125 | ₪ 16,086 | ₪ 3,110 | ₪ 19,196 | ₪ 3,666,487 |
| 192 | ₪ 845,982 | ₪ 16,143 | ₪ 3,053 | ₪ 19,196 | ₪ 3,685,684 |
| 193 | ₪ 829,782 | ₪ 16,200 | ₪ 2,996 | ₪ 19,196 | ₪ 3,704,880 |
| 194 | ₪ 813,525 | ₪ 16,257 | ₪ 2,939 | ₪ 19,196 | ₪ 3,724,076 |
| 195 | ₪ 797,210 | ₪ 16,315 | ₪ 2,881 | ₪ 19,196 | ₪ 3,743,272 |
| 196 | ₪ 780,837 | ₪ 16,373 | ₪ 2,823 | ₪ 19,196 | ₪ 3,762,469 |
| 197 | ₪ 764,406 | ₪ 16,431 | ₪ 2,765 | ₪ 19,196 | ₪ 3,781,665 |
| 198 | ₪ 747,917 | ₪ 16,489 | ₪ 2,707 | ₪ 19,196 | ₪ 3,800,861 |
| 199 | ₪ 731,370 | ₪ 16,547 | ₪ 2,649 | ₪ 19,196 | ₪ 3,820,057 |
| 200 | ₪ 714,764 | ₪ 16,606 | ₪ 2,590 | ₪ 19,196 | ₪ 3,839,254 |
| 201 | ₪ 698,099 | ₪ 16,665 | ₪ 2,531 | ₪ 19,196 | ₪ 3,858,450 |
| 202 | ₪ 681,375 | ₪ 16,724 | ₪ 2,472 | ₪ 19,196 | ₪ 3,877,646 |
| 203 | ₪ 664,592 | ₪ 16,783 | ₪ 2,413 | ₪ 19,196 | ₪ 3,896,843 |
| 204 | ₪ 647,750 | ₪ 16,843 | ₪ 2,354 | ₪ 19,196 | ₪ 3,916,039 |
| 205 | ₪ 630,847 | ₪ 16,902 | ₪ 2,294 | ₪ 19,196 | ₪ 3,935,235 |
| 206 | ₪ 613,885 | ₪ 16,962 | ₪ 2,234 | ₪ 19,196 | ₪ 3,954,431 |
| 207 | ₪ 596,863 | ₪ 17,022 | ₪ 2,174 | ₪ 19,196 | ₪ 3,973,628 |
| 208 | ₪ 579,781 | ₪ 17,082 | ₪ 2,114 | ₪ 19,196 | ₪ 3,992,824 |
| 209 | ₪ 562,638 | ₪ 17,143 | ₪ 2,053 | ₪ 19,196 | ₪ 4,012,020 |
| 210 | ₪ 545,434 | ₪ 17,204 | ₪ 1,993 | ₪ 19,196 | ₪ 4,031,216 |
| 211 | ₪ 528,170 | ₪ 17,265 | ₪ 1,932 | ₪ 19,196 | ₪ 4,050,413 |
| 212 | ₪ 510,844 | ₪ 17,326 | ₪ 1,871 | ₪ 19,196 | ₪ 4,069,609 |
| 213 | ₪ 493,457 | ₪ 17,387 | ₪ 1,809 | ₪ 19,196 | ₪ 4,088,805 |
| 214 | ₪ 476,009 | ₪ 17,449 | ₪ 1,748 | ₪ 19,196 | ₪ 4,108,001 |
| 215 | ₪ 458,498 | ₪ 17,510 | ₪ 1,686 | ₪ 19,196 | ₪ 4,127,198 |
| 216 | ₪ 440,926 | ₪ 17,572 | ₪ 1,624 | ₪ 19,196 | ₪ 4,146,394 |
| 217 | ₪ 423,291 | ₪ 17,635 | ₪ 1,562 | ₪ 19,196 | ₪ 4,165,590 |
| 218 | ₪ 405,594 | ₪ 17,697 | ₪ 1,499 | ₪ 19,196 | ₪ 4,184,787 |
| 219 | ₪ 387,834 | ₪ 17,760 | ₪ 1,436 | ₪ 19,196 | ₪ 4,203,983 |
| 220 | ₪ 370,012 | ₪ 17,823 | ₪ 1,374 | ₪ 19,196 | ₪ 4,223,179 |
| 221 | ₪ 352,126 | ₪ 17,886 | ₪ 1,310 | ₪ 19,196 | ₪ 4,242,375 |
| 222 | ₪ 334,177 | ₪ 17,949 | ₪ 1,247 | ₪ 19,196 | ₪ 4,261,572 |
| 223 | ₪ 316,164 | ₪ 18,013 | ₪ 1,184 | ₪ 19,196 | ₪ 4,280,768 |
| 224 | ₪ 298,087 | ₪ 18,077 | ₪ 1,120 | ₪ 19,196 | ₪ 4,299,964 |
| 225 | ₪ 279,947 | ₪ 18,141 | ₪ 1,056 | ₪ 19,196 | ₪ 4,319,160 |
| 226 | ₪ 261,742 | ₪ 18,205 | ₪ 991 | ₪ 19,196 | ₪ 4,338,357 |
| 227 | ₪ 243,473 | ₪ 18,269 | ₪ 927 | ₪ 19,196 | ₪ 4,357,553 |
| 228 | ₪ 225,139 | ₪ 18,334 | ₪ 862 | ₪ 19,196 | ₪ 4,376,749 |
| 229 | ₪ 206,740 | ₪ 18,399 | ₪ 797 | ₪ 19,196 | ₪ 4,395,945 |
| 230 | ₪ 188,276 | ₪ 18,464 | ₪ 732 | ₪ 19,196 | ₪ 4,415,142 |
| 231 | ₪ 169,746 | ₪ 18,529 | ₪ 667 | ₪ 19,196 | ₪ 4,434,338 |
| 232 | ₪ 151,151 | ₪ 18,595 | ₪ 601 | ₪ 19,196 | ₪ 4,453,534 |
| 233 | ₪ 132,490 | ₪ 18,661 | ₪ 535 | ₪ 19,196 | ₪ 4,472,731 |
| 234 | ₪ 113,763 | ₪ 18,727 | ₪ 469 | ₪ 19,196 | ₪ 4,491,927 |
| 235 | ₪ 94,970 | ₪ 18,793 | ₪ 403 | ₪ 19,196 | ₪ 4,511,123 |
| 236 | ₪ 76,110 | ₪ 18,860 | ₪ 336 | ₪ 19,196 | ₪ 4,530,319 |
| 237 | ₪ 57,183 | ₪ 18,927 | ₪ 270 | ₪ 19,196 | ₪ 4,549,516 |
| 238 | ₪ 38,190 | ₪ 18,994 | ₪ 203 | ₪ 19,196 | ₪ 4,568,712 |
| 239 | ₪ 19,129 | ₪ 19,061 | ₪ 135 | ₪ 19,196 | ₪ 4,587,908 |
| 240 | ₪ 0 | ₪ 19,129 | ₪ 68 | ₪ 19,196 | ₪ 4,607,104 |
| סה"כ | ₪ 3,100,000 | ₪ 1,507,104 | ₪ 4,607,104 | ₪ 4,607,104 |
ראו גם: מה ההחזר על משכנתא של 3,000,000 שח? | מה ההחזר על משכנתא של 3,100,000 שח?