11,918 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,200,000 ש״ח ל-25 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ומאתיים אלף שקלים לתקופה של עשרים וחמש שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
11,918 ש"ח
1,375,471 ש"ח
3,575,471 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,195,873 | ₪ 4,127 | ₪ 7,792 | ₪ 11,918 | ₪ 11,918 |
| 2 | ₪ 2,191,732 | ₪ 4,141 | ₪ 7,777 | ₪ 11,918 | ₪ 23,836 |
| 3 | ₪ 2,187,576 | ₪ 4,156 | ₪ 7,762 | ₪ 11,918 | ₪ 35,755 |
| 4 | ₪ 2,183,406 | ₪ 4,171 | ₪ 7,748 | ₪ 11,918 | ₪ 47,673 |
| 5 | ₪ 2,179,220 | ₪ 4,185 | ₪ 7,733 | ₪ 11,918 | ₪ 59,591 |
| 6 | ₪ 2,175,020 | ₪ 4,200 | ₪ 7,718 | ₪ 11,918 | ₪ 71,509 |
| 7 | ₪ 2,170,805 | ₪ 4,215 | ₪ 7,703 | ₪ 11,918 | ₪ 83,428 |
| 8 | ₪ 2,166,575 | ₪ 4,230 | ₪ 7,688 | ₪ 11,918 | ₪ 95,346 |
| 9 | ₪ 2,162,330 | ₪ 4,245 | ₪ 7,673 | ₪ 11,918 | ₪ 107,264 |
| 10 | ₪ 2,158,070 | ₪ 4,260 | ₪ 7,658 | ₪ 11,918 | ₪ 119,182 |
| 11 | ₪ 2,153,795 | ₪ 4,275 | ₪ 7,643 | ₪ 11,918 | ₪ 131,101 |
| 12 | ₪ 2,149,505 | ₪ 4,290 | ₪ 7,628 | ₪ 11,918 | ₪ 143,019 |
| 13 | ₪ 2,145,200 | ₪ 4,305 | ₪ 7,613 | ₪ 11,918 | ₪ 154,937 |
| 14 | ₪ 2,140,879 | ₪ 4,321 | ₪ 7,598 | ₪ 11,918 | ₪ 166,855 |
| 15 | ₪ 2,136,543 | ₪ 4,336 | ₪ 7,582 | ₪ 11,918 | ₪ 178,774 |
| 16 | ₪ 2,132,192 | ₪ 4,351 | ₪ 7,567 | ₪ 11,918 | ₪ 190,692 |
| 17 | ₪ 2,127,825 | ₪ 4,367 | ₪ 7,552 | ₪ 11,918 | ₪ 202,610 |
| 18 | ₪ 2,123,443 | ₪ 4,382 | ₪ 7,536 | ₪ 11,918 | ₪ 214,528 |
| 19 | ₪ 2,119,045 | ₪ 4,398 | ₪ 7,521 | ₪ 11,918 | ₪ 226,447 |
| 20 | ₪ 2,114,632 | ₪ 4,413 | ₪ 7,505 | ₪ 11,918 | ₪ 238,365 |
| 21 | ₪ 2,110,203 | ₪ 4,429 | ₪ 7,489 | ₪ 11,918 | ₪ 250,283 |
| 22 | ₪ 2,105,758 | ₪ 4,445 | ₪ 7,474 | ₪ 11,918 | ₪ 262,201 |
| 23 | ₪ 2,101,298 | ₪ 4,460 | ₪ 7,458 | ₪ 11,918 | ₪ 274,119 |
| 24 | ₪ 2,096,822 | ₪ 4,476 | ₪ 7,442 | ₪ 11,918 | ₪ 286,038 |
| 25 | ₪ 2,092,330 | ₪ 4,492 | ₪ 7,426 | ₪ 11,918 | ₪ 297,956 |
| 26 | ₪ 2,087,822 | ₪ 4,508 | ₪ 7,410 | ₪ 11,918 | ₪ 309,874 |
| 27 | ₪ 2,083,298 | ₪ 4,524 | ₪ 7,394 | ₪ 11,918 | ₪ 321,792 |
| 28 | ₪ 2,078,758 | ₪ 4,540 | ₪ 7,378 | ₪ 11,918 | ₪ 333,711 |
| 29 | ₪ 2,074,202 | ₪ 4,556 | ₪ 7,362 | ₪ 11,918 | ₪ 345,629 |
| 30 | ₪ 2,069,630 | ₪ 4,572 | ₪ 7,346 | ₪ 11,918 | ₪ 357,547 |
| 31 | ₪ 2,065,042 | ₪ 4,588 | ₪ 7,330 | ₪ 11,918 | ₪ 369,465 |
| 32 | ₪ 2,060,437 | ₪ 4,605 | ₪ 7,314 | ₪ 11,918 | ₪ 381,384 |
| 33 | ₪ 2,055,816 | ₪ 4,621 | ₪ 7,297 | ₪ 11,918 | ₪ 393,302 |
| 34 | ₪ 2,051,179 | ₪ 4,637 | ₪ 7,281 | ₪ 11,918 | ₪ 405,220 |
| 35 | ₪ 2,046,526 | ₪ 4,654 | ₪ 7,265 | ₪ 11,918 | ₪ 417,138 |
| 36 | ₪ 2,041,855 | ₪ 4,670 | ₪ 7,248 | ₪ 11,918 | ₪ 429,057 |
| 37 | ₪ 2,037,169 | ₪ 4,687 | ₪ 7,232 | ₪ 11,918 | ₪ 440,975 |
| 38 | ₪ 2,032,465 | ₪ 4,703 | ₪ 7,215 | ₪ 11,918 | ₪ 452,893 |
| 39 | ₪ 2,027,746 | ₪ 4,720 | ₪ 7,198 | ₪ 11,918 | ₪ 464,811 |
| 40 | ₪ 2,023,009 | ₪ 4,737 | ₪ 7,182 | ₪ 11,918 | ₪ 476,730 |
| 41 | ₪ 2,018,255 | ₪ 4,753 | ₪ 7,165 | ₪ 11,918 | ₪ 488,648 |
| 42 | ₪ 2,013,485 | ₪ 4,770 | ₪ 7,148 | ₪ 11,918 | ₪ 500,566 |
| 43 | ₪ 2,008,698 | ₪ 4,787 | ₪ 7,131 | ₪ 11,918 | ₪ 512,484 |
| 44 | ₪ 2,003,894 | ₪ 4,804 | ₪ 7,114 | ₪ 11,918 | ₪ 524,402 |
| 45 | ₪ 1,999,073 | ₪ 4,821 | ₪ 7,097 | ₪ 11,918 | ₪ 536,321 |
| 46 | ₪ 1,994,235 | ₪ 4,838 | ₪ 7,080 | ₪ 11,918 | ₪ 548,239 |
| 47 | ₪ 1,989,379 | ₪ 4,855 | ₪ 7,063 | ₪ 11,918 | ₪ 560,157 |
| 48 | ₪ 1,984,507 | ₪ 4,873 | ₪ 7,046 | ₪ 11,918 | ₪ 572,075 |
| 49 | ₪ 1,979,617 | ₪ 4,890 | ₪ 7,028 | ₪ 11,918 | ₪ 583,994 |
| 50 | ₪ 1,974,710 | ₪ 4,907 | ₪ 7,011 | ₪ 11,918 | ₪ 595,912 |
| 51 | ₪ 1,969,785 | ₪ 4,924 | ₪ 6,994 | ₪ 11,918 | ₪ 607,830 |
| 52 | ₪ 1,964,844 | ₪ 4,942 | ₪ 6,976 | ₪ 11,918 | ₪ 619,748 |
| 53 | ₪ 1,959,884 | ₪ 4,959 | ₪ 6,959 | ₪ 11,918 | ₪ 631,667 |
| 54 | ₪ 1,954,907 | ₪ 4,977 | ₪ 6,941 | ₪ 11,918 | ₪ 643,585 |
| 55 | ₪ 1,949,913 | ₪ 4,995 | ₪ 6,924 | ₪ 11,918 | ₪ 655,503 |
| 56 | ₪ 1,944,900 | ₪ 5,012 | ₪ 6,906 | ₪ 11,918 | ₪ 667,421 |
| 57 | ₪ 1,939,870 | ₪ 5,030 | ₪ 6,888 | ₪ 11,918 | ₪ 679,340 |
| 58 | ₪ 1,934,822 | ₪ 5,048 | ₪ 6,870 | ₪ 11,918 | ₪ 691,258 |
| 59 | ₪ 1,929,757 | ₪ 5,066 | ₪ 6,852 | ₪ 11,918 | ₪ 703,176 |
| 60 | ₪ 1,924,673 | ₪ 5,084 | ₪ 6,835 | ₪ 11,918 | ₪ 715,094 |
| 61 | ₪ 1,919,571 | ₪ 5,102 | ₪ 6,817 | ₪ 11,918 | ₪ 727,013 |
| 62 | ₪ 1,914,451 | ₪ 5,120 | ₪ 6,798 | ₪ 11,918 | ₪ 738,931 |
| 63 | ₪ 1,909,314 | ₪ 5,138 | ₪ 6,780 | ₪ 11,918 | ₪ 750,849 |
| 64 | ₪ 1,904,158 | ₪ 5,156 | ₪ 6,762 | ₪ 11,918 | ₪ 762,767 |
| 65 | ₪ 1,898,983 | ₪ 5,174 | ₪ 6,744 | ₪ 11,918 | ₪ 774,685 |
| 66 | ₪ 1,893,790 | ₪ 5,193 | ₪ 6,726 | ₪ 11,918 | ₪ 786,604 |
| 67 | ₪ 1,888,579 | ₪ 5,211 | ₪ 6,707 | ₪ 11,918 | ₪ 798,522 |
| 68 | ₪ 1,883,350 | ₪ 5,230 | ₪ 6,689 | ₪ 11,918 | ₪ 810,440 |
| 69 | ₪ 1,878,102 | ₪ 5,248 | ₪ 6,670 | ₪ 11,918 | ₪ 822,358 |
| 70 | ₪ 1,872,835 | ₪ 5,267 | ₪ 6,652 | ₪ 11,918 | ₪ 834,277 |
| 71 | ₪ 1,867,550 | ₪ 5,285 | ₪ 6,633 | ₪ 11,918 | ₪ 846,195 |
| 72 | ₪ 1,862,246 | ₪ 5,304 | ₪ 6,614 | ₪ 11,918 | ₪ 858,113 |
| 73 | ₪ 1,856,923 | ₪ 5,323 | ₪ 6,595 | ₪ 11,918 | ₪ 870,031 |
| 74 | ₪ 1,851,582 | ₪ 5,342 | ₪ 6,577 | ₪ 11,918 | ₪ 881,950 |
| 75 | ₪ 1,846,221 | ₪ 5,361 | ₪ 6,558 | ₪ 11,918 | ₪ 893,868 |
| 76 | ₪ 1,840,841 | ₪ 5,380 | ₪ 6,539 | ₪ 11,918 | ₪ 905,786 |
| 77 | ₪ 1,835,443 | ₪ 5,399 | ₪ 6,520 | ₪ 11,918 | ₪ 917,704 |
| 78 | ₪ 1,830,025 | ₪ 5,418 | ₪ 6,501 | ₪ 11,918 | ₪ 929,623 |
| 79 | ₪ 1,824,588 | ₪ 5,437 | ₪ 6,481 | ₪ 11,918 | ₪ 941,541 |
| 80 | ₪ 1,819,132 | ₪ 5,456 | ₪ 6,462 | ₪ 11,918 | ₪ 953,459 |
| 81 | ₪ 1,813,657 | ₪ 5,475 | ₪ 6,443 | ₪ 11,918 | ₪ 965,377 |
| 82 | ₪ 1,808,162 | ₪ 5,495 | ₪ 6,423 | ₪ 11,918 | ₪ 977,296 |
| 83 | ₪ 1,802,647 | ₪ 5,514 | ₪ 6,404 | ₪ 11,918 | ₪ 989,214 |
| 84 | ₪ 1,797,114 | ₪ 5,534 | ₪ 6,384 | ₪ 11,918 | ₪ 1,001,132 |
| 85 | ₪ 1,791,560 | ₪ 5,553 | ₪ 6,365 | ₪ 11,918 | ₪ 1,013,050 |
| 86 | ₪ 1,785,987 | ₪ 5,573 | ₪ 6,345 | ₪ 11,918 | ₪ 1,024,968 |
| 87 | ₪ 1,780,394 | ₪ 5,593 | ₪ 6,325 | ₪ 11,918 | ₪ 1,036,887 |
| 88 | ₪ 1,774,781 | ₪ 5,613 | ₪ 6,306 | ₪ 11,918 | ₪ 1,048,805 |
| 89 | ₪ 1,769,149 | ₪ 5,633 | ₪ 6,286 | ₪ 11,918 | ₪ 1,060,723 |
| 90 | ₪ 1,763,496 | ₪ 5,653 | ₪ 6,266 | ₪ 11,918 | ₪ 1,072,641 |
| 91 | ₪ 1,757,824 | ₪ 5,673 | ₪ 6,246 | ₪ 11,918 | ₪ 1,084,560 |
| 92 | ₪ 1,752,131 | ₪ 5,693 | ₪ 6,226 | ₪ 11,918 | ₪ 1,096,478 |
| 93 | ₪ 1,746,418 | ₪ 5,713 | ₪ 6,205 | ₪ 11,918 | ₪ 1,108,396 |
| 94 | ₪ 1,740,685 | ₪ 5,733 | ₪ 6,185 | ₪ 11,918 | ₪ 1,120,314 |
| 95 | ₪ 1,734,932 | ₪ 5,753 | ₪ 6,165 | ₪ 11,918 | ₪ 1,132,233 |
| 96 | ₪ 1,729,158 | ₪ 5,774 | ₪ 6,145 | ₪ 11,918 | ₪ 1,144,151 |
| 97 | ₪ 1,723,364 | ₪ 5,794 | ₪ 6,124 | ₪ 11,918 | ₪ 1,156,069 |
| 98 | ₪ 1,717,550 | ₪ 5,815 | ₪ 6,104 | ₪ 11,918 | ₪ 1,167,987 |
| 99 | ₪ 1,711,714 | ₪ 5,835 | ₪ 6,083 | ₪ 11,918 | ₪ 1,179,906 |
| 100 | ₪ 1,705,858 | ₪ 5,856 | ₪ 6,062 | ₪ 11,918 | ₪ 1,191,824 |
| 101 | ₪ 1,699,982 | ₪ 5,877 | ₪ 6,042 | ₪ 11,918 | ₪ 1,203,742 |
| 102 | ₪ 1,694,084 | ₪ 5,897 | ₪ 6,021 | ₪ 11,918 | ₪ 1,215,660 |
| 103 | ₪ 1,688,166 | ₪ 5,918 | ₪ 6,000 | ₪ 11,918 | ₪ 1,227,579 |
| 104 | ₪ 1,682,227 | ₪ 5,939 | ₪ 5,979 | ₪ 11,918 | ₪ 1,239,497 |
| 105 | ₪ 1,676,266 | ₪ 5,960 | ₪ 5,958 | ₪ 11,918 | ₪ 1,251,415 |
| 106 | ₪ 1,670,285 | ₪ 5,981 | ₪ 5,937 | ₪ 11,918 | ₪ 1,263,333 |
| 107 | ₪ 1,664,282 | ₪ 6,003 | ₪ 5,916 | ₪ 11,918 | ₪ 1,275,251 |
| 108 | ₪ 1,658,258 | ₪ 6,024 | ₪ 5,894 | ₪ 11,918 | ₪ 1,287,170 |
| 109 | ₪ 1,652,213 | ₪ 6,045 | ₪ 5,873 | ₪ 11,918 | ₪ 1,299,088 |
| 110 | ₪ 1,646,146 | ₪ 6,067 | ₪ 5,852 | ₪ 11,918 | ₪ 1,311,006 |
| 111 | ₪ 1,640,058 | ₪ 6,088 | ₪ 5,830 | ₪ 11,918 | ₪ 1,322,924 |
| 112 | ₪ 1,633,949 | ₪ 6,110 | ₪ 5,809 | ₪ 11,918 | ₪ 1,334,843 |
| 113 | ₪ 1,627,817 | ₪ 6,131 | ₪ 5,787 | ₪ 11,918 | ₪ 1,346,761 |
| 114 | ₪ 1,621,664 | ₪ 6,153 | ₪ 5,765 | ₪ 11,918 | ₪ 1,358,679 |
| 115 | ₪ 1,615,489 | ₪ 6,175 | ₪ 5,743 | ₪ 11,918 | ₪ 1,370,597 |
| 116 | ₪ 1,609,293 | ₪ 6,197 | ₪ 5,722 | ₪ 11,918 | ₪ 1,382,516 |
| 117 | ₪ 1,603,074 | ₪ 6,219 | ₪ 5,700 | ₪ 11,918 | ₪ 1,394,434 |
| 118 | ₪ 1,596,833 | ₪ 6,241 | ₪ 5,678 | ₪ 11,918 | ₪ 1,406,352 |
| 119 | ₪ 1,590,571 | ₪ 6,263 | ₪ 5,655 | ₪ 11,918 | ₪ 1,418,270 |
| 120 | ₪ 1,584,286 | ₪ 6,285 | ₪ 5,633 | ₪ 11,918 | ₪ 1,430,189 |
| 121 | ₪ 1,577,978 | ₪ 6,307 | ₪ 5,611 | ₪ 11,918 | ₪ 1,442,107 |
| 122 | ₪ 1,571,649 | ₪ 6,330 | ₪ 5,589 | ₪ 11,918 | ₪ 1,454,025 |
| 123 | ₪ 1,565,297 | ₪ 6,352 | ₪ 5,566 | ₪ 11,918 | ₪ 1,465,943 |
| 124 | ₪ 1,558,922 | ₪ 6,374 | ₪ 5,544 | ₪ 11,918 | ₪ 1,477,862 |
| 125 | ₪ 1,552,525 | ₪ 6,397 | ₪ 5,521 | ₪ 11,918 | ₪ 1,489,780 |
| 126 | ₪ 1,546,106 | ₪ 6,420 | ₪ 5,499 | ₪ 11,918 | ₪ 1,501,698 |
| 127 | ₪ 1,539,663 | ₪ 6,442 | ₪ 5,476 | ₪ 11,918 | ₪ 1,513,616 |
| 128 | ₪ 1,533,198 | ₪ 6,465 | ₪ 5,453 | ₪ 11,918 | ₪ 1,525,534 |
| 129 | ₪ 1,526,710 | ₪ 6,488 | ₪ 5,430 | ₪ 11,918 | ₪ 1,537,453 |
| 130 | ₪ 1,520,199 | ₪ 6,511 | ₪ 5,407 | ₪ 11,918 | ₪ 1,549,371 |
| 131 | ₪ 1,513,664 | ₪ 6,534 | ₪ 5,384 | ₪ 11,918 | ₪ 1,561,289 |
| 132 | ₪ 1,507,107 | ₪ 6,557 | ₪ 5,361 | ₪ 11,918 | ₪ 1,573,207 |
| 133 | ₪ 1,500,526 | ₪ 6,581 | ₪ 5,338 | ₪ 11,918 | ₪ 1,585,126 |
| 134 | ₪ 1,493,923 | ₪ 6,604 | ₪ 5,314 | ₪ 11,918 | ₪ 1,597,044 |
| 135 | ₪ 1,487,295 | ₪ 6,627 | ₪ 5,291 | ₪ 11,918 | ₪ 1,608,962 |
| 136 | ₪ 1,480,645 | ₪ 6,651 | ₪ 5,268 | ₪ 11,918 | ₪ 1,620,880 |
| 137 | ₪ 1,473,970 | ₪ 6,674 | ₪ 5,244 | ₪ 11,918 | ₪ 1,632,799 |
| 138 | ₪ 1,467,272 | ₪ 6,698 | ₪ 5,220 | ₪ 11,918 | ₪ 1,644,717 |
| 139 | ₪ 1,460,551 | ₪ 6,722 | ₪ 5,197 | ₪ 11,918 | ₪ 1,656,635 |
| 140 | ₪ 1,453,805 | ₪ 6,745 | ₪ 5,173 | ₪ 11,918 | ₪ 1,668,553 |
| 141 | ₪ 1,447,036 | ₪ 6,769 | ₪ 5,149 | ₪ 11,918 | ₪ 1,680,472 |
| 142 | ₪ 1,440,243 | ₪ 6,793 | ₪ 5,125 | ₪ 11,918 | ₪ 1,692,390 |
| 143 | ₪ 1,433,425 | ₪ 6,817 | ₪ 5,101 | ₪ 11,918 | ₪ 1,704,308 |
| 144 | ₪ 1,426,584 | ₪ 6,842 | ₪ 5,077 | ₪ 11,918 | ₪ 1,716,226 |
| 145 | ₪ 1,419,718 | ₪ 6,866 | ₪ 5,052 | ₪ 11,918 | ₪ 1,728,145 |
| 146 | ₪ 1,412,828 | ₪ 6,890 | ₪ 5,028 | ₪ 11,918 | ₪ 1,740,063 |
| 147 | ₪ 1,405,913 | ₪ 6,914 | ₪ 5,004 | ₪ 11,918 | ₪ 1,751,981 |
| 148 | ₪ 1,398,974 | ₪ 6,939 | ₪ 4,979 | ₪ 11,918 | ₪ 1,763,899 |
| 149 | ₪ 1,392,011 | ₪ 6,964 | ₪ 4,955 | ₪ 11,918 | ₪ 1,775,817 |
| 150 | ₪ 1,385,023 | ₪ 6,988 | ₪ 4,930 | ₪ 11,918 | ₪ 1,787,736 |
| 151 | ₪ 1,378,010 | ₪ 7,013 | ₪ 4,905 | ₪ 11,918 | ₪ 1,799,654 |
| 152 | ₪ 1,370,972 | ₪ 7,038 | ₪ 4,880 | ₪ 11,918 | ₪ 1,811,572 |
| 153 | ₪ 1,363,909 | ₪ 7,063 | ₪ 4,856 | ₪ 11,918 | ₪ 1,823,490 |
| 154 | ₪ 1,356,821 | ₪ 7,088 | ₪ 4,831 | ₪ 11,918 | ₪ 1,835,409 |
| 155 | ₪ 1,349,709 | ₪ 7,113 | ₪ 4,805 | ₪ 11,918 | ₪ 1,847,327 |
| 156 | ₪ 1,342,571 | ₪ 7,138 | ₪ 4,780 | ₪ 11,918 | ₪ 1,859,245 |
| 157 | ₪ 1,335,407 | ₪ 7,163 | ₪ 4,755 | ₪ 11,918 | ₪ 1,871,163 |
| 158 | ₪ 1,328,219 | ₪ 7,189 | ₪ 4,730 | ₪ 11,918 | ₪ 1,883,082 |
| 159 | ₪ 1,321,005 | ₪ 7,214 | ₪ 4,704 | ₪ 11,918 | ₪ 1,895,000 |
| 160 | ₪ 1,313,765 | ₪ 7,240 | ₪ 4,679 | ₪ 11,918 | ₪ 1,906,918 |
| 161 | ₪ 1,306,500 | ₪ 7,265 | ₪ 4,653 | ₪ 11,918 | ₪ 1,918,836 |
| 162 | ₪ 1,299,208 | ₪ 7,291 | ₪ 4,627 | ₪ 11,918 | ₪ 1,930,755 |
| 163 | ₪ 1,291,892 | ₪ 7,317 | ₪ 4,601 | ₪ 11,918 | ₪ 1,942,673 |
| 164 | ₪ 1,284,549 | ₪ 7,343 | ₪ 4,575 | ₪ 11,918 | ₪ 1,954,591 |
| 165 | ₪ 1,277,180 | ₪ 7,369 | ₪ 4,549 | ₪ 11,918 | ₪ 1,966,509 |
| 166 | ₪ 1,269,785 | ₪ 7,395 | ₪ 4,523 | ₪ 11,918 | ₪ 1,978,428 |
| 167 | ₪ 1,262,364 | ₪ 7,421 | ₪ 4,497 | ₪ 11,918 | ₪ 1,990,346 |
| 168 | ₪ 1,254,917 | ₪ 7,447 | ₪ 4,471 | ₪ 11,918 | ₪ 2,002,264 |
| 169 | ₪ 1,247,443 | ₪ 7,474 | ₪ 4,444 | ₪ 11,918 | ₪ 2,014,182 |
| 170 | ₪ 1,239,943 | ₪ 7,500 | ₪ 4,418 | ₪ 11,918 | ₪ 2,026,100 |
| 171 | ₪ 1,232,416 | ₪ 7,527 | ₪ 4,391 | ₪ 11,918 | ₪ 2,038,019 |
| 172 | ₪ 1,224,863 | ₪ 7,553 | ₪ 4,365 | ₪ 11,918 | ₪ 2,049,937 |
| 173 | ₪ 1,217,282 | ₪ 7,580 | ₪ 4,338 | ₪ 11,918 | ₪ 2,061,855 |
| 174 | ₪ 1,209,675 | ₪ 7,607 | ₪ 4,311 | ₪ 11,918 | ₪ 2,073,773 |
| 175 | ₪ 1,202,041 | ₪ 7,634 | ₪ 4,284 | ₪ 11,918 | ₪ 2,085,692 |
| 176 | ₪ 1,194,380 | ₪ 7,661 | ₪ 4,257 | ₪ 11,918 | ₪ 2,097,610 |
| 177 | ₪ 1,186,692 | ₪ 7,688 | ₪ 4,230 | ₪ 11,918 | ₪ 2,109,528 |
| 178 | ₪ 1,178,977 | ₪ 7,715 | ₪ 4,203 | ₪ 11,918 | ₪ 2,121,446 |
| 179 | ₪ 1,171,234 | ₪ 7,743 | ₪ 4,176 | ₪ 11,918 | ₪ 2,133,365 |
| 180 | ₪ 1,163,464 | ₪ 7,770 | ₪ 4,148 | ₪ 11,918 | ₪ 2,145,283 |
| 181 | ₪ 1,155,666 | ₪ 7,798 | ₪ 4,121 | ₪ 11,918 | ₪ 2,157,201 |
| 182 | ₪ 1,147,841 | ₪ 7,825 | ₪ 4,093 | ₪ 11,918 | ₪ 2,169,119 |
| 183 | ₪ 1,139,988 | ₪ 7,853 | ₪ 4,065 | ₪ 11,918 | ₪ 2,181,038 |
| 184 | ₪ 1,132,107 | ₪ 7,881 | ₪ 4,037 | ₪ 11,918 | ₪ 2,192,956 |
| 185 | ₪ 1,124,199 | ₪ 7,909 | ₪ 4,010 | ₪ 11,918 | ₪ 2,204,874 |
| 186 | ₪ 1,116,262 | ₪ 7,937 | ₪ 3,982 | ₪ 11,918 | ₪ 2,216,792 |
| 187 | ₪ 1,108,297 | ₪ 7,965 | ₪ 3,953 | ₪ 11,918 | ₪ 2,228,711 |
| 188 | ₪ 1,100,304 | ₪ 7,993 | ₪ 3,925 | ₪ 11,918 | ₪ 2,240,629 |
| 189 | ₪ 1,092,283 | ₪ 8,021 | ₪ 3,897 | ₪ 11,918 | ₪ 2,252,547 |
| 190 | ₪ 1,084,233 | ₪ 8,050 | ₪ 3,869 | ₪ 11,918 | ₪ 2,264,465 |
| 191 | ₪ 1,076,155 | ₪ 8,078 | ₪ 3,840 | ₪ 11,918 | ₪ 2,276,384 |
| 192 | ₪ 1,068,048 | ₪ 8,107 | ₪ 3,811 | ₪ 11,918 | ₪ 2,288,302 |
| 193 | ₪ 1,059,912 | ₪ 8,136 | ₪ 3,783 | ₪ 11,918 | ₪ 2,300,220 |
| 194 | ₪ 1,051,748 | ₪ 8,164 | ₪ 3,754 | ₪ 11,918 | ₪ 2,312,138 |
| 195 | ₪ 1,043,555 | ₪ 8,193 | ₪ 3,725 | ₪ 11,918 | ₪ 2,324,056 |
| 196 | ₪ 1,035,332 | ₪ 8,222 | ₪ 3,696 | ₪ 11,918 | ₪ 2,335,975 |
| 197 | ₪ 1,027,081 | ₪ 8,251 | ₪ 3,667 | ₪ 11,918 | ₪ 2,347,893 |
| 198 | ₪ 1,018,800 | ₪ 8,281 | ₪ 3,638 | ₪ 11,918 | ₪ 2,359,811 |
| 199 | ₪ 1,010,490 | ₪ 8,310 | ₪ 3,608 | ₪ 11,918 | ₪ 2,371,729 |
| 200 | ₪ 1,002,151 | ₪ 8,339 | ₪ 3,579 | ₪ 11,918 | ₪ 2,383,648 |
| 201 | ₪ 993,782 | ₪ 8,369 | ₪ 3,549 | ₪ 11,918 | ₪ 2,395,566 |
| 202 | ₪ 985,383 | ₪ 8,399 | ₪ 3,520 | ₪ 11,918 | ₪ 2,407,484 |
| 203 | ₪ 976,955 | ₪ 8,428 | ₪ 3,490 | ₪ 11,918 | ₪ 2,419,402 |
| 204 | ₪ 968,497 | ₪ 8,458 | ₪ 3,460 | ₪ 11,918 | ₪ 2,431,321 |
| 205 | ₪ 960,009 | ₪ 8,488 | ₪ 3,430 | ₪ 11,918 | ₪ 2,443,239 |
| 206 | ₪ 951,490 | ₪ 8,518 | ₪ 3,400 | ₪ 11,918 | ₪ 2,455,157 |
| 207 | ₪ 942,942 | ₪ 8,548 | ₪ 3,370 | ₪ 11,918 | ₪ 2,467,075 |
| 208 | ₪ 934,363 | ₪ 8,579 | ₪ 3,340 | ₪ 11,918 | ₪ 2,478,994 |
| 209 | ₪ 925,754 | ₪ 8,609 | ₪ 3,309 | ₪ 11,918 | ₪ 2,490,912 |
| 210 | ₪ 917,115 | ₪ 8,640 | ₪ 3,279 | ₪ 11,918 | ₪ 2,502,830 |
| 211 | ₪ 908,445 | ₪ 8,670 | ₪ 3,248 | ₪ 11,918 | ₪ 2,514,748 |
| 212 | ₪ 899,744 | ₪ 8,701 | ₪ 3,217 | ₪ 11,918 | ₪ 2,526,667 |
| 213 | ₪ 891,012 | ₪ 8,732 | ₪ 3,187 | ₪ 11,918 | ₪ 2,538,585 |
| 214 | ₪ 882,250 | ₪ 8,763 | ₪ 3,156 | ₪ 11,918 | ₪ 2,550,503 |
| 215 | ₪ 873,456 | ₪ 8,794 | ₪ 3,125 | ₪ 11,918 | ₪ 2,562,421 |
| 216 | ₪ 864,631 | ₪ 8,825 | ₪ 3,093 | ₪ 11,918 | ₪ 2,574,339 |
| 217 | ₪ 855,775 | ₪ 8,856 | ₪ 3,062 | ₪ 11,918 | ₪ 2,586,258 |
| 218 | ₪ 846,888 | ₪ 8,887 | ₪ 3,031 | ₪ 11,918 | ₪ 2,598,176 |
| 219 | ₪ 837,969 | ₪ 8,919 | ₪ 2,999 | ₪ 11,918 | ₪ 2,610,094 |
| 220 | ₪ 829,019 | ₪ 8,950 | ₪ 2,968 | ₪ 11,918 | ₪ 2,622,012 |
| 221 | ₪ 820,037 | ₪ 8,982 | ₪ 2,936 | ₪ 11,918 | ₪ 2,633,931 |
| 222 | ₪ 811,023 | ₪ 9,014 | ₪ 2,904 | ₪ 11,918 | ₪ 2,645,849 |
| 223 | ₪ 801,977 | ₪ 9,046 | ₪ 2,872 | ₪ 11,918 | ₪ 2,657,767 |
| 224 | ₪ 792,899 | ₪ 9,078 | ₪ 2,840 | ₪ 11,918 | ₪ 2,669,685 |
| 225 | ₪ 783,789 | ₪ 9,110 | ₪ 2,808 | ₪ 11,918 | ₪ 2,681,604 |
| 226 | ₪ 774,647 | ₪ 9,142 | ₪ 2,776 | ₪ 11,918 | ₪ 2,693,522 |
| 227 | ₪ 765,472 | ₪ 9,175 | ₪ 2,744 | ₪ 11,918 | ₪ 2,705,440 |
| 228 | ₪ 756,265 | ₪ 9,207 | ₪ 2,711 | ₪ 11,918 | ₪ 2,717,358 |
| 229 | ₪ 747,025 | ₪ 9,240 | ₪ 2,678 | ₪ 11,918 | ₪ 2,729,277 |
| 230 | ₪ 737,752 | ₪ 9,273 | ₪ 2,646 | ₪ 11,918 | ₪ 2,741,195 |
| 231 | ₪ 728,447 | ₪ 9,305 | ₪ 2,613 | ₪ 11,918 | ₪ 2,753,113 |
| 232 | ₪ 719,109 | ₪ 9,338 | ₪ 2,580 | ₪ 11,918 | ₪ 2,765,031 |
| 233 | ₪ 709,737 | ₪ 9,371 | ₪ 2,547 | ₪ 11,918 | ₪ 2,776,950 |
| 234 | ₪ 700,333 | ₪ 9,405 | ₪ 2,514 | ₪ 11,918 | ₪ 2,788,868 |
| 235 | ₪ 690,895 | ₪ 9,438 | ₪ 2,480 | ₪ 11,918 | ₪ 2,800,786 |
| 236 | ₪ 681,423 | ₪ 9,471 | ₪ 2,447 | ₪ 11,918 | ₪ 2,812,704 |
| 237 | ₪ 671,919 | ₪ 9,505 | ₪ 2,413 | ₪ 11,918 | ₪ 2,824,622 |
| 238 | ₪ 662,380 | ₪ 9,539 | ₪ 2,380 | ₪ 11,918 | ₪ 2,836,541 |
| 239 | ₪ 652,808 | ₪ 9,572 | ₪ 2,346 | ₪ 11,918 | ₪ 2,848,459 |
| 240 | ₪ 643,202 | ₪ 9,606 | ₪ 2,312 | ₪ 11,918 | ₪ 2,860,377 |
| 241 | ₪ 633,561 | ₪ 9,640 | ₪ 2,278 | ₪ 11,918 | ₪ 2,872,295 |
| 242 | ₪ 623,887 | ₪ 9,674 | ₪ 2,244 | ₪ 11,918 | ₪ 2,884,214 |
| 243 | ₪ 614,178 | ₪ 9,709 | ₪ 2,210 | ₪ 11,918 | ₪ 2,896,132 |
| 244 | ₪ 604,435 | ₪ 9,743 | ₪ 2,175 | ₪ 11,918 | ₪ 2,908,050 |
| 245 | ₪ 594,658 | ₪ 9,778 | ₪ 2,141 | ₪ 11,918 | ₪ 2,919,968 |
| 246 | ₪ 584,846 | ₪ 9,812 | ₪ 2,106 | ₪ 11,918 | ₪ 2,931,887 |
| 247 | ₪ 574,999 | ₪ 9,847 | ₪ 2,071 | ₪ 11,918 | ₪ 2,943,805 |
| 248 | ₪ 565,117 | ₪ 9,882 | ₪ 2,036 | ₪ 11,918 | ₪ 2,955,723 |
| 249 | ₪ 555,200 | ₪ 9,917 | ₪ 2,001 | ₪ 11,918 | ₪ 2,967,641 |
| 250 | ₪ 545,248 | ₪ 9,952 | ₪ 1,966 | ₪ 11,918 | ₪ 2,979,560 |
| 251 | ₪ 535,261 | ₪ 9,987 | ₪ 1,931 | ₪ 11,918 | ₪ 2,991,478 |
| 252 | ₪ 525,238 | ₪ 10,023 | ₪ 1,896 | ₪ 11,918 | ₪ 3,003,396 |
| 253 | ₪ 515,180 | ₪ 10,058 | ₪ 1,860 | ₪ 11,918 | ₪ 3,015,314 |
| 254 | ₪ 505,087 | ₪ 10,094 | ₪ 1,825 | ₪ 11,918 | ₪ 3,027,233 |
| 255 | ₪ 494,957 | ₪ 10,129 | ₪ 1,789 | ₪ 11,918 | ₪ 3,039,151 |
| 256 | ₪ 484,792 | ₪ 10,165 | ₪ 1,753 | ₪ 11,918 | ₪ 3,051,069 |
| 257 | ₪ 474,591 | ₪ 10,201 | ₪ 1,717 | ₪ 11,918 | ₪ 3,062,987 |
| 258 | ₪ 464,354 | ₪ 10,237 | ₪ 1,681 | ₪ 11,918 | ₪ 3,074,905 |
| 259 | ₪ 454,080 | ₪ 10,274 | ₪ 1,645 | ₪ 11,918 | ₪ 3,086,824 |
| 260 | ₪ 443,770 | ₪ 10,310 | ₪ 1,608 | ₪ 11,918 | ₪ 3,098,742 |
| 261 | ₪ 433,423 | ₪ 10,347 | ₪ 1,572 | ₪ 11,918 | ₪ 3,110,660 |
| 262 | ₪ 423,040 | ₪ 10,383 | ₪ 1,535 | ₪ 11,918 | ₪ 3,122,578 |
| 263 | ₪ 412,620 | ₪ 10,420 | ₪ 1,498 | ₪ 11,918 | ₪ 3,134,497 |
| 264 | ₪ 402,163 | ₪ 10,457 | ₪ 1,461 | ₪ 11,918 | ₪ 3,146,415 |
| 265 | ₪ 391,669 | ₪ 10,494 | ₪ 1,424 | ₪ 11,918 | ₪ 3,158,333 |
| 266 | ₪ 381,138 | ₪ 10,531 | ₪ 1,387 | ₪ 11,918 | ₪ 3,170,251 |
| 267 | ₪ 370,570 | ₪ 10,568 | ₪ 1,350 | ₪ 11,918 | ₪ 3,182,170 |
| 268 | ₪ 359,964 | ₪ 10,606 | ₪ 1,312 | ₪ 11,918 | ₪ 3,194,088 |
| 269 | ₪ 349,321 | ₪ 10,643 | ₪ 1,275 | ₪ 11,918 | ₪ 3,206,006 |
| 270 | ₪ 338,640 | ₪ 10,681 | ₪ 1,237 | ₪ 11,918 | ₪ 3,217,924 |
| 271 | ₪ 327,921 | ₪ 10,719 | ₪ 1,199 | ₪ 11,918 | ₪ 3,229,843 |
| 272 | ₪ 317,164 | ₪ 10,757 | ₪ 1,161 | ₪ 11,918 | ₪ 3,241,761 |
| 273 | ₪ 306,369 | ₪ 10,795 | ₪ 1,123 | ₪ 11,918 | ₪ 3,253,679 |
| 274 | ₪ 295,536 | ₪ 10,833 | ₪ 1,085 | ₪ 11,918 | ₪ 3,265,597 |
| 275 | ₪ 284,664 | ₪ 10,872 | ₪ 1,047 | ₪ 11,918 | ₪ 3,277,516 |
| 276 | ₪ 273,754 | ₪ 10,910 | ₪ 1,008 | ₪ 11,918 | ₪ 3,289,434 |
| 277 | ₪ 262,805 | ₪ 10,949 | ₪ 970 | ₪ 11,918 | ₪ 3,301,352 |
| 278 | ₪ 251,818 | ₪ 10,987 | ₪ 931 | ₪ 11,918 | ₪ 3,313,270 |
| 279 | ₪ 240,792 | ₪ 11,026 | ₪ 892 | ₪ 11,918 | ₪ 3,325,188 |
| 280 | ₪ 229,726 | ₪ 11,065 | ₪ 853 | ₪ 11,918 | ₪ 3,337,107 |
| 281 | ₪ 218,622 | ₪ 11,105 | ₪ 814 | ₪ 11,918 | ₪ 3,349,025 |
| 282 | ₪ 207,478 | ₪ 11,144 | ₪ 774 | ₪ 11,918 | ₪ 3,360,943 |
| 283 | ₪ 196,294 | ₪ 11,183 | ₪ 735 | ₪ 11,918 | ₪ 3,372,861 |
| 284 | ₪ 185,071 | ₪ 11,223 | ₪ 695 | ₪ 11,918 | ₪ 3,384,780 |
| 285 | ₪ 173,808 | ₪ 11,263 | ₪ 655 | ₪ 11,918 | ₪ 3,396,698 |
| 286 | ₪ 162,506 | ₪ 11,303 | ₪ 616 | ₪ 11,918 | ₪ 3,408,616 |
| 287 | ₪ 151,163 | ₪ 11,343 | ₪ 576 | ₪ 11,918 | ₪ 3,420,534 |
| 288 | ₪ 139,780 | ₪ 11,383 | ₪ 535 | ₪ 11,918 | ₪ 3,432,453 |
| 289 | ₪ 128,357 | ₪ 11,423 | ₪ 495 | ₪ 11,918 | ₪ 3,444,371 |
| 290 | ₪ 116,893 | ₪ 11,464 | ₪ 455 | ₪ 11,918 | ₪ 3,456,289 |
| 291 | ₪ 105,389 | ₪ 11,504 | ₪ 414 | ₪ 11,918 | ₪ 3,468,207 |
| 292 | ₪ 93,844 | ₪ 11,545 | ₪ 373 | ₪ 11,918 | ₪ 3,480,126 |
| 293 | ₪ 82,258 | ₪ 11,586 | ₪ 332 | ₪ 11,918 | ₪ 3,492,044 |
| 294 | ₪ 70,631 | ₪ 11,627 | ₪ 291 | ₪ 11,918 | ₪ 3,503,962 |
| 295 | ₪ 58,963 | ₪ 11,668 | ₪ 250 | ₪ 11,918 | ₪ 3,515,880 |
| 296 | ₪ 47,254 | ₪ 11,709 | ₪ 209 | ₪ 11,918 | ₪ 3,527,799 |
| 297 | ₪ 35,503 | ₪ 11,751 | ₪ 167 | ₪ 11,918 | ₪ 3,539,717 |
| 298 | ₪ 23,710 | ₪ 11,792 | ₪ 126 | ₪ 11,918 | ₪ 3,551,635 |
| 299 | ₪ 11,876 | ₪ 11,834 | ₪ 84 | ₪ 11,918 | ₪ 3,563,553 |
| 300 | ₪ 0 | ₪ 11,876 | ₪ 42 | ₪ 11,918 | ₪ 3,575,471 |
| סה"כ | ₪ 2,200,000 | ₪ 1,375,471 | ₪ 3,575,471 | ₪ 3,575,471 |
ראו גם: מה ההחזר על משכנתא של 2,100,000 שח? | מה ההחזר על משכנתא של 2,300,000 שח?