15,710 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,900,000 ש״ח ל-25 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ותשע מאות אלף שקלים לתקופה של עשרים וחמש שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
15,710 ש"ח
1,813,121 ש"ח
4,713,121 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,894,560 | ₪ 5,440 | ₪ 10,271 | ₪ 15,710 | ₪ 15,710 |
| 2 | ₪ 2,889,102 | ₪ 5,459 | ₪ 10,252 | ₪ 15,710 | ₪ 31,421 |
| 3 | ₪ 2,883,623 | ₪ 5,478 | ₪ 10,232 | ₪ 15,710 | ₪ 47,131 |
| 4 | ₪ 2,878,126 | ₪ 5,498 | ₪ 10,213 | ₪ 15,710 | ₪ 62,842 |
| 5 | ₪ 2,872,609 | ₪ 5,517 | ₪ 10,193 | ₪ 15,710 | ₪ 78,552 |
| 6 | ₪ 2,867,072 | ₪ 5,537 | ₪ 10,174 | ₪ 15,710 | ₪ 94,262 |
| 7 | ₪ 2,861,516 | ₪ 5,556 | ₪ 10,154 | ₪ 15,710 | ₪ 109,973 |
| 8 | ₪ 2,855,940 | ₪ 5,576 | ₪ 10,135 | ₪ 15,710 | ₪ 125,683 |
| 9 | ₪ 2,850,345 | ₪ 5,596 | ₪ 10,115 | ₪ 15,710 | ₪ 141,394 |
| 10 | ₪ 2,844,729 | ₪ 5,615 | ₪ 10,095 | ₪ 15,710 | ₪ 157,104 |
| 11 | ₪ 2,839,094 | ₪ 5,635 | ₪ 10,075 | ₪ 15,710 | ₪ 172,814 |
| 12 | ₪ 2,833,439 | ₪ 5,655 | ₪ 10,055 | ₪ 15,710 | ₪ 188,525 |
| 13 | ₪ 2,827,763 | ₪ 5,675 | ₪ 10,035 | ₪ 15,710 | ₪ 204,235 |
| 14 | ₪ 2,822,068 | ₪ 5,695 | ₪ 10,015 | ₪ 15,710 | ₪ 219,946 |
| 15 | ₪ 2,816,352 | ₪ 5,716 | ₪ 9,995 | ₪ 15,710 | ₪ 235,656 |
| 16 | ₪ 2,810,616 | ₪ 5,736 | ₪ 9,975 | ₪ 15,710 | ₪ 251,366 |
| 17 | ₪ 2,804,860 | ₪ 5,756 | ₪ 9,954 | ₪ 15,710 | ₪ 267,077 |
| 18 | ₪ 2,799,084 | ₪ 5,777 | ₪ 9,934 | ₪ 15,710 | ₪ 282,787 |
| 19 | ₪ 2,793,287 | ₪ 5,797 | ₪ 9,913 | ₪ 15,710 | ₪ 298,498 |
| 20 | ₪ 2,787,469 | ₪ 5,818 | ₪ 9,893 | ₪ 15,710 | ₪ 314,208 |
| 21 | ₪ 2,781,631 | ₪ 5,838 | ₪ 9,872 | ₪ 15,710 | ₪ 329,919 |
| 22 | ₪ 2,775,772 | ₪ 5,859 | ₪ 9,852 | ₪ 15,710 | ₪ 345,629 |
| 23 | ₪ 2,769,893 | ₪ 5,880 | ₪ 9,831 | ₪ 15,710 | ₪ 361,339 |
| 24 | ₪ 2,763,992 | ₪ 5,900 | ₪ 9,810 | ₪ 15,710 | ₪ 377,050 |
| 25 | ₪ 2,758,071 | ₪ 5,921 | ₪ 9,789 | ₪ 15,710 | ₪ 392,760 |
| 26 | ₪ 2,752,129 | ₪ 5,942 | ₪ 9,768 | ₪ 15,710 | ₪ 408,471 |
| 27 | ₪ 2,746,166 | ₪ 5,963 | ₪ 9,747 | ₪ 15,710 | ₪ 424,181 |
| 28 | ₪ 2,740,181 | ₪ 5,984 | ₪ 9,726 | ₪ 15,710 | ₪ 439,891 |
| 29 | ₪ 2,734,176 | ₪ 6,006 | ₪ 9,705 | ₪ 15,710 | ₪ 455,602 |
| 30 | ₪ 2,728,149 | ₪ 6,027 | ₪ 9,684 | ₪ 15,710 | ₪ 471,312 |
| 31 | ₪ 2,722,101 | ₪ 6,048 | ₪ 9,662 | ₪ 15,710 | ₪ 487,023 |
| 32 | ₪ 2,716,031 | ₪ 6,070 | ₪ 9,641 | ₪ 15,710 | ₪ 502,733 |
| 33 | ₪ 2,709,940 | ₪ 6,091 | ₪ 9,619 | ₪ 15,710 | ₪ 518,443 |
| 34 | ₪ 2,703,827 | ₪ 6,113 | ₪ 9,598 | ₪ 15,710 | ₪ 534,154 |
| 35 | ₪ 2,697,693 | ₪ 6,134 | ₪ 9,576 | ₪ 15,710 | ₪ 549,864 |
| 36 | ₪ 2,691,537 | ₪ 6,156 | ₪ 9,554 | ₪ 15,710 | ₪ 565,575 |
| 37 | ₪ 2,685,359 | ₪ 6,178 | ₪ 9,533 | ₪ 15,710 | ₪ 581,285 |
| 38 | ₪ 2,679,159 | ₪ 6,200 | ₪ 9,511 | ₪ 15,710 | ₪ 596,995 |
| 39 | ₪ 2,672,937 | ₪ 6,222 | ₪ 9,489 | ₪ 15,710 | ₪ 612,706 |
| 40 | ₪ 2,666,694 | ₪ 6,244 | ₪ 9,467 | ₪ 15,710 | ₪ 628,416 |
| 41 | ₪ 2,660,428 | ₪ 6,266 | ₪ 9,445 | ₪ 15,710 | ₪ 644,127 |
| 42 | ₪ 2,654,140 | ₪ 6,288 | ₪ 9,422 | ₪ 15,710 | ₪ 659,837 |
| 43 | ₪ 2,647,829 | ₪ 6,310 | ₪ 9,400 | ₪ 15,710 | ₪ 675,547 |
| 44 | ₪ 2,641,497 | ₪ 6,333 | ₪ 9,378 | ₪ 15,710 | ₪ 691,258 |
| 45 | ₪ 2,635,142 | ₪ 6,355 | ₪ 9,355 | ₪ 15,710 | ₪ 706,968 |
| 46 | ₪ 2,628,764 | ₪ 6,378 | ₪ 9,333 | ₪ 15,710 | ₪ 722,679 |
| 47 | ₪ 2,622,364 | ₪ 6,400 | ₪ 9,310 | ₪ 15,710 | ₪ 738,389 |
| 48 | ₪ 2,615,941 | ₪ 6,423 | ₪ 9,288 | ₪ 15,710 | ₪ 754,099 |
| 49 | ₪ 2,609,495 | ₪ 6,446 | ₪ 9,265 | ₪ 15,710 | ₪ 769,810 |
| 50 | ₪ 2,603,027 | ₪ 6,468 | ₪ 9,242 | ₪ 15,710 | ₪ 785,520 |
| 51 | ₪ 2,596,535 | ₪ 6,491 | ₪ 9,219 | ₪ 15,710 | ₪ 801,231 |
| 52 | ₪ 2,590,021 | ₪ 6,514 | ₪ 9,196 | ₪ 15,710 | ₪ 816,941 |
| 53 | ₪ 2,583,484 | ₪ 6,537 | ₪ 9,173 | ₪ 15,710 | ₪ 832,651 |
| 54 | ₪ 2,576,923 | ₪ 6,561 | ₪ 9,150 | ₪ 15,710 | ₪ 848,362 |
| 55 | ₪ 2,570,339 | ₪ 6,584 | ₪ 9,127 | ₪ 15,710 | ₪ 864,072 |
| 56 | ₪ 2,563,732 | ₪ 6,607 | ₪ 9,103 | ₪ 15,710 | ₪ 879,783 |
| 57 | ₪ 2,557,102 | ₪ 6,631 | ₪ 9,080 | ₪ 15,710 | ₪ 895,493 |
| 58 | ₪ 2,550,448 | ₪ 6,654 | ₪ 9,056 | ₪ 15,710 | ₪ 911,203 |
| 59 | ₪ 2,543,770 | ₪ 6,678 | ₪ 9,033 | ₪ 15,710 | ₪ 926,914 |
| 60 | ₪ 2,537,069 | ₪ 6,701 | ₪ 9,009 | ₪ 15,710 | ₪ 942,624 |
| 61 | ₪ 2,530,344 | ₪ 6,725 | ₪ 8,985 | ₪ 15,710 | ₪ 958,335 |
| 62 | ₪ 2,523,595 | ₪ 6,749 | ₪ 8,962 | ₪ 15,710 | ₪ 974,045 |
| 63 | ₪ 2,516,822 | ₪ 6,773 | ₪ 8,938 | ₪ 15,710 | ₪ 989,756 |
| 64 | ₪ 2,510,026 | ₪ 6,797 | ₪ 8,914 | ₪ 15,710 | ₪ 1,005,466 |
| 65 | ₪ 2,503,205 | ₪ 6,821 | ₪ 8,890 | ₪ 15,710 | ₪ 1,021,176 |
| 66 | ₪ 2,496,360 | ₪ 6,845 | ₪ 8,866 | ₪ 15,710 | ₪ 1,036,887 |
| 67 | ₪ 2,489,491 | ₪ 6,869 | ₪ 8,841 | ₪ 15,710 | ₪ 1,052,597 |
| 68 | ₪ 2,482,598 | ₪ 6,893 | ₪ 8,817 | ₪ 15,710 | ₪ 1,068,308 |
| 69 | ₪ 2,475,680 | ₪ 6,918 | ₪ 8,793 | ₪ 15,710 | ₪ 1,084,018 |
| 70 | ₪ 2,468,737 | ₪ 6,942 | ₪ 8,768 | ₪ 15,710 | ₪ 1,099,728 |
| 71 | ₪ 2,461,770 | ₪ 6,967 | ₪ 8,743 | ₪ 15,710 | ₪ 1,115,439 |
| 72 | ₪ 2,454,779 | ₪ 6,992 | ₪ 8,719 | ₪ 15,710 | ₪ 1,131,149 |
| 73 | ₪ 2,447,762 | ₪ 7,016 | ₪ 8,694 | ₪ 15,710 | ₪ 1,146,860 |
| 74 | ₪ 2,440,721 | ₪ 7,041 | ₪ 8,669 | ₪ 15,710 | ₪ 1,162,570 |
| 75 | ₪ 2,433,655 | ₪ 7,066 | ₪ 8,644 | ₪ 15,710 | ₪ 1,178,280 |
| 76 | ₪ 2,426,564 | ₪ 7,091 | ₪ 8,619 | ₪ 15,710 | ₪ 1,193,991 |
| 77 | ₪ 2,419,447 | ₪ 7,116 | ₪ 8,594 | ₪ 15,710 | ₪ 1,209,701 |
| 78 | ₪ 2,412,306 | ₪ 7,142 | ₪ 8,569 | ₪ 15,710 | ₪ 1,225,412 |
| 79 | ₪ 2,405,139 | ₪ 7,167 | ₪ 8,544 | ₪ 15,710 | ₪ 1,241,122 |
| 80 | ₪ 2,397,947 | ₪ 7,192 | ₪ 8,518 | ₪ 15,710 | ₪ 1,256,832 |
| 81 | ₪ 2,390,729 | ₪ 7,218 | ₪ 8,493 | ₪ 15,710 | ₪ 1,272,543 |
| 82 | ₪ 2,383,486 | ₪ 7,243 | ₪ 8,467 | ₪ 15,710 | ₪ 1,288,253 |
| 83 | ₪ 2,376,217 | ₪ 7,269 | ₪ 8,442 | ₪ 15,710 | ₪ 1,303,964 |
| 84 | ₪ 2,368,922 | ₪ 7,295 | ₪ 8,416 | ₪ 15,710 | ₪ 1,319,674 |
| 85 | ₪ 2,361,602 | ₪ 7,320 | ₪ 8,390 | ₪ 15,710 | ₪ 1,335,384 |
| 86 | ₪ 2,354,256 | ₪ 7,346 | ₪ 8,364 | ₪ 15,710 | ₪ 1,351,095 |
| 87 | ₪ 2,346,883 | ₪ 7,372 | ₪ 8,338 | ₪ 15,710 | ₪ 1,366,805 |
| 88 | ₪ 2,339,485 | ₪ 7,399 | ₪ 8,312 | ₪ 15,710 | ₪ 1,382,516 |
| 89 | ₪ 2,332,060 | ₪ 7,425 | ₪ 8,286 | ₪ 15,710 | ₪ 1,398,226 |
| 90 | ₪ 2,324,609 | ₪ 7,451 | ₪ 8,259 | ₪ 15,710 | ₪ 1,413,936 |
| 91 | ₪ 2,317,131 | ₪ 7,477 | ₪ 8,233 | ₪ 15,710 | ₪ 1,429,647 |
| 92 | ₪ 2,309,628 | ₪ 7,504 | ₪ 8,207 | ₪ 15,710 | ₪ 1,445,357 |
| 93 | ₪ 2,302,097 | ₪ 7,530 | ₪ 8,180 | ₪ 15,710 | ₪ 1,461,068 |
| 94 | ₪ 2,294,540 | ₪ 7,557 | ₪ 8,153 | ₪ 15,710 | ₪ 1,476,778 |
| 95 | ₪ 2,286,956 | ₪ 7,584 | ₪ 8,126 | ₪ 15,710 | ₪ 1,492,488 |
| 96 | ₪ 2,279,345 | ₪ 7,611 | ₪ 8,100 | ₪ 15,710 | ₪ 1,508,199 |
| 97 | ₪ 2,271,708 | ₪ 7,638 | ₪ 8,073 | ₪ 15,710 | ₪ 1,523,909 |
| 98 | ₪ 2,264,043 | ₪ 7,665 | ₪ 8,046 | ₪ 15,710 | ₪ 1,539,620 |
| 99 | ₪ 2,256,351 | ₪ 7,692 | ₪ 8,018 | ₪ 15,710 | ₪ 1,555,330 |
| 100 | ₪ 2,248,632 | ₪ 7,719 | ₪ 7,991 | ₪ 15,710 | ₪ 1,571,040 |
| 101 | ₪ 2,240,885 | ₪ 7,747 | ₪ 7,964 | ₪ 15,710 | ₪ 1,586,751 |
| 102 | ₪ 2,233,111 | ₪ 7,774 | ₪ 7,936 | ₪ 15,710 | ₪ 1,602,461 |
| 103 | ₪ 2,225,310 | ₪ 7,801 | ₪ 7,909 | ₪ 15,710 | ₪ 1,618,172 |
| 104 | ₪ 2,217,481 | ₪ 7,829 | ₪ 7,881 | ₪ 15,710 | ₪ 1,633,882 |
| 105 | ₪ 2,209,624 | ₪ 7,857 | ₪ 7,854 | ₪ 15,710 | ₪ 1,649,593 |
| 106 | ₪ 2,201,739 | ₪ 7,885 | ₪ 7,826 | ₪ 15,710 | ₪ 1,665,303 |
| 107 | ₪ 2,193,827 | ₪ 7,913 | ₪ 7,798 | ₪ 15,710 | ₪ 1,681,013 |
| 108 | ₪ 2,185,886 | ₪ 7,941 | ₪ 7,770 | ₪ 15,710 | ₪ 1,696,724 |
| 109 | ₪ 2,177,917 | ₪ 7,969 | ₪ 7,742 | ₪ 15,710 | ₪ 1,712,434 |
| 110 | ₪ 2,169,920 | ₪ 7,997 | ₪ 7,713 | ₪ 15,710 | ₪ 1,728,145 |
| 111 | ₪ 2,161,895 | ₪ 8,025 | ₪ 7,685 | ₪ 15,710 | ₪ 1,743,855 |
| 112 | ₪ 2,153,841 | ₪ 8,054 | ₪ 7,657 | ₪ 15,710 | ₪ 1,759,565 |
| 113 | ₪ 2,145,759 | ₪ 8,082 | ₪ 7,628 | ₪ 15,710 | ₪ 1,775,276 |
| 114 | ₪ 2,137,648 | ₪ 8,111 | ₪ 7,600 | ₪ 15,710 | ₪ 1,790,986 |
| 115 | ₪ 2,129,509 | ₪ 8,140 | ₪ 7,571 | ₪ 15,710 | ₪ 1,806,697 |
| 116 | ₪ 2,121,340 | ₪ 8,168 | ₪ 7,542 | ₪ 15,710 | ₪ 1,822,407 |
| 117 | ₪ 2,113,143 | ₪ 8,197 | ₪ 7,513 | ₪ 15,710 | ₪ 1,838,117 |
| 118 | ₪ 2,104,917 | ₪ 8,226 | ₪ 7,484 | ₪ 15,710 | ₪ 1,853,828 |
| 119 | ₪ 2,096,661 | ₪ 8,255 | ₪ 7,455 | ₪ 15,710 | ₪ 1,869,538 |
| 120 | ₪ 2,088,376 | ₪ 8,285 | ₪ 7,426 | ₪ 15,710 | ₪ 1,885,249 |
| 121 | ₪ 2,080,062 | ₪ 8,314 | ₪ 7,396 | ₪ 15,710 | ₪ 1,900,959 |
| 122 | ₪ 2,071,719 | ₪ 8,344 | ₪ 7,367 | ₪ 15,710 | ₪ 1,916,669 |
| 123 | ₪ 2,063,346 | ₪ 8,373 | ₪ 7,337 | ₪ 15,710 | ₪ 1,932,380 |
| 124 | ₪ 2,054,943 | ₪ 8,403 | ₪ 7,308 | ₪ 15,710 | ₪ 1,948,090 |
| 125 | ₪ 2,046,511 | ₪ 8,432 | ₪ 7,278 | ₪ 15,710 | ₪ 1,963,801 |
| 126 | ₪ 2,038,048 | ₪ 8,462 | ₪ 7,248 | ₪ 15,710 | ₪ 1,979,511 |
| 127 | ₪ 2,029,556 | ₪ 8,492 | ₪ 7,218 | ₪ 15,710 | ₪ 1,995,221 |
| 128 | ₪ 2,021,033 | ₪ 8,522 | ₪ 7,188 | ₪ 15,710 | ₪ 2,010,932 |
| 129 | ₪ 2,012,481 | ₪ 8,553 | ₪ 7,158 | ₪ 15,710 | ₪ 2,026,642 |
| 130 | ₪ 2,003,898 | ₪ 8,583 | ₪ 7,128 | ₪ 15,710 | ₪ 2,042,353 |
| 131 | ₪ 1,995,285 | ₪ 8,613 | ₪ 7,097 | ₪ 15,710 | ₪ 2,058,063 |
| 132 | ₪ 1,986,641 | ₪ 8,644 | ₪ 7,067 | ₪ 15,710 | ₪ 2,073,773 |
| 133 | ₪ 1,977,967 | ₪ 8,674 | ₪ 7,036 | ₪ 15,710 | ₪ 2,089,484 |
| 134 | ₪ 1,969,262 | ₪ 8,705 | ₪ 7,005 | ₪ 15,710 | ₪ 2,105,194 |
| 135 | ₪ 1,960,526 | ₪ 8,736 | ₪ 6,974 | ₪ 15,710 | ₪ 2,120,905 |
| 136 | ₪ 1,951,759 | ₪ 8,767 | ₪ 6,944 | ₪ 15,710 | ₪ 2,136,615 |
| 137 | ₪ 1,942,961 | ₪ 8,798 | ₪ 6,912 | ₪ 15,710 | ₪ 2,152,325 |
| 138 | ₪ 1,934,132 | ₪ 8,829 | ₪ 6,881 | ₪ 15,710 | ₪ 2,168,036 |
| 139 | ₪ 1,925,271 | ₪ 8,860 | ₪ 6,850 | ₪ 15,710 | ₪ 2,183,746 |
| 140 | ₪ 1,916,380 | ₪ 8,892 | ₪ 6,819 | ₪ 15,710 | ₪ 2,199,457 |
| 141 | ₪ 1,907,456 | ₪ 8,923 | ₪ 6,787 | ₪ 15,710 | ₪ 2,215,167 |
| 142 | ₪ 1,898,502 | ₪ 8,955 | ₪ 6,756 | ₪ 15,710 | ₪ 2,230,877 |
| 143 | ₪ 1,889,515 | ₪ 8,987 | ₪ 6,724 | ₪ 15,710 | ₪ 2,246,588 |
| 144 | ₪ 1,880,497 | ₪ 9,018 | ₪ 6,692 | ₪ 15,710 | ₪ 2,262,298 |
| 145 | ₪ 1,871,446 | ₪ 9,050 | ₪ 6,660 | ₪ 15,710 | ₪ 2,278,009 |
| 146 | ₪ 1,862,364 | ₪ 9,082 | ₪ 6,628 | ₪ 15,710 | ₪ 2,293,719 |
| 147 | ₪ 1,853,249 | ₪ 9,115 | ₪ 6,596 | ₪ 15,710 | ₪ 2,309,430 |
| 148 | ₪ 1,844,103 | ₪ 9,147 | ₪ 6,564 | ₪ 15,710 | ₪ 2,325,140 |
| 149 | ₪ 1,834,923 | ₪ 9,179 | ₪ 6,531 | ₪ 15,710 | ₪ 2,340,850 |
| 150 | ₪ 1,825,712 | ₪ 9,212 | ₪ 6,499 | ₪ 15,710 | ₪ 2,356,561 |
| 151 | ₪ 1,816,467 | ₪ 9,244 | ₪ 6,466 | ₪ 15,710 | ₪ 2,372,271 |
| 152 | ₪ 1,807,190 | ₪ 9,277 | ₪ 6,433 | ₪ 15,710 | ₪ 2,387,982 |
| 153 | ₪ 1,797,880 | ₪ 9,310 | ₪ 6,400 | ₪ 15,710 | ₪ 2,403,692 |
| 154 | ₪ 1,788,537 | ₪ 9,343 | ₪ 6,367 | ₪ 15,710 | ₪ 2,419,402 |
| 155 | ₪ 1,779,161 | ₪ 9,376 | ₪ 6,334 | ₪ 15,710 | ₪ 2,435,113 |
| 156 | ₪ 1,769,752 | ₪ 9,409 | ₪ 6,301 | ₪ 15,710 | ₪ 2,450,823 |
| 157 | ₪ 1,760,310 | ₪ 9,443 | ₪ 6,268 | ₪ 15,710 | ₪ 2,466,534 |
| 158 | ₪ 1,750,834 | ₪ 9,476 | ₪ 6,234 | ₪ 15,710 | ₪ 2,482,244 |
| 159 | ₪ 1,741,324 | ₪ 9,510 | ₪ 6,201 | ₪ 15,710 | ₪ 2,497,954 |
| 160 | ₪ 1,731,781 | ₪ 9,543 | ₪ 6,167 | ₪ 15,710 | ₪ 2,513,665 |
| 161 | ₪ 1,722,204 | ₪ 9,577 | ₪ 6,133 | ₪ 15,710 | ₪ 2,529,375 |
| 162 | ₪ 1,712,593 | ₪ 9,611 | ₪ 6,099 | ₪ 15,710 | ₪ 2,545,086 |
| 163 | ₪ 1,702,948 | ₪ 9,645 | ₪ 6,065 | ₪ 15,710 | ₪ 2,560,796 |
| 164 | ₪ 1,693,269 | ₪ 9,679 | ₪ 6,031 | ₪ 15,710 | ₪ 2,576,506 |
| 165 | ₪ 1,683,555 | ₪ 9,713 | ₪ 5,997 | ₪ 15,710 | ₪ 2,592,217 |
| 166 | ₪ 1,673,808 | ₪ 9,748 | ₪ 5,963 | ₪ 15,710 | ₪ 2,607,927 |
| 167 | ₪ 1,664,025 | ₪ 9,782 | ₪ 5,928 | ₪ 15,710 | ₪ 2,623,638 |
| 168 | ₪ 1,654,208 | ₪ 9,817 | ₪ 5,893 | ₪ 15,710 | ₪ 2,639,348 |
| 169 | ₪ 1,644,357 | ₪ 9,852 | ₪ 5,859 | ₪ 15,710 | ₪ 2,655,058 |
| 170 | ₪ 1,634,470 | ₪ 9,887 | ₪ 5,824 | ₪ 15,710 | ₪ 2,670,769 |
| 171 | ₪ 1,624,548 | ₪ 9,922 | ₪ 5,789 | ₪ 15,710 | ₪ 2,686,479 |
| 172 | ₪ 1,614,591 | ₪ 9,957 | ₪ 5,754 | ₪ 15,710 | ₪ 2,702,190 |
| 173 | ₪ 1,604,599 | ₪ 9,992 | ₪ 5,718 | ₪ 15,710 | ₪ 2,717,900 |
| 174 | ₪ 1,594,572 | ₪ 10,027 | ₪ 5,683 | ₪ 15,710 | ₪ 2,733,610 |
| 175 | ₪ 1,584,509 | ₪ 10,063 | ₪ 5,647 | ₪ 15,710 | ₪ 2,749,321 |
| 176 | ₪ 1,574,410 | ₪ 10,099 | ₪ 5,612 | ₪ 15,710 | ₪ 2,765,031 |
| 177 | ₪ 1,564,276 | ₪ 10,134 | ₪ 5,576 | ₪ 15,710 | ₪ 2,780,742 |
| 178 | ₪ 1,554,106 | ₪ 10,170 | ₪ 5,540 | ₪ 15,710 | ₪ 2,796,452 |
| 179 | ₪ 1,543,900 | ₪ 10,206 | ₪ 5,504 | ₪ 15,710 | ₪ 2,812,162 |
| 180 | ₪ 1,533,657 | ₪ 10,242 | ₪ 5,468 | ₪ 15,710 | ₪ 2,827,873 |
| 181 | ₪ 1,523,378 | ₪ 10,279 | ₪ 5,432 | ₪ 15,710 | ₪ 2,843,583 |
| 182 | ₪ 1,513,063 | ₪ 10,315 | ₪ 5,395 | ₪ 15,710 | ₪ 2,859,294 |
| 183 | ₪ 1,502,712 | ₪ 10,352 | ₪ 5,359 | ₪ 15,710 | ₪ 2,875,004 |
| 184 | ₪ 1,492,323 | ₪ 10,388 | ₪ 5,322 | ₪ 15,710 | ₪ 2,890,715 |
| 185 | ₪ 1,481,898 | ₪ 10,425 | ₪ 5,285 | ₪ 15,710 | ₪ 2,906,425 |
| 186 | ₪ 1,471,436 | ₪ 10,462 | ₪ 5,248 | ₪ 15,710 | ₪ 2,922,135 |
| 187 | ₪ 1,460,937 | ₪ 10,499 | ₪ 5,211 | ₪ 15,710 | ₪ 2,937,846 |
| 188 | ₪ 1,450,401 | ₪ 10,536 | ₪ 5,174 | ₪ 15,710 | ₪ 2,953,556 |
| 189 | ₪ 1,439,827 | ₪ 10,574 | ₪ 5,137 | ₪ 15,710 | ₪ 2,969,267 |
| 190 | ₪ 1,429,216 | ₪ 10,611 | ₪ 5,099 | ₪ 15,710 | ₪ 2,984,977 |
| 191 | ₪ 1,418,568 | ₪ 10,649 | ₪ 5,062 | ₪ 15,710 | ₪ 3,000,687 |
| 192 | ₪ 1,407,881 | ₪ 10,686 | ₪ 5,024 | ₪ 15,710 | ₪ 3,016,398 |
| 193 | ₪ 1,397,157 | ₪ 10,724 | ₪ 4,986 | ₪ 15,710 | ₪ 3,032,108 |
| 194 | ₪ 1,386,395 | ₪ 10,762 | ₪ 4,948 | ₪ 15,710 | ₪ 3,047,819 |
| 195 | ₪ 1,375,595 | ₪ 10,800 | ₪ 4,910 | ₪ 15,710 | ₪ 3,063,529 |
| 196 | ₪ 1,364,756 | ₪ 10,839 | ₪ 4,872 | ₪ 15,710 | ₪ 3,079,239 |
| 197 | ₪ 1,353,879 | ₪ 10,877 | ₪ 4,834 | ₪ 15,710 | ₪ 3,094,950 |
| 198 | ₪ 1,342,964 | ₪ 10,915 | ₪ 4,795 | ₪ 15,710 | ₪ 3,110,660 |
| 199 | ₪ 1,332,010 | ₪ 10,954 | ₪ 4,756 | ₪ 15,710 | ₪ 3,126,371 |
| 200 | ₪ 1,321,017 | ₪ 10,993 | ₪ 4,718 | ₪ 15,710 | ₪ 3,142,081 |
| 201 | ₪ 1,309,985 | ₪ 11,032 | ₪ 4,679 | ₪ 15,710 | ₪ 3,157,791 |
| 202 | ₪ 1,298,914 | ₪ 11,071 | ₪ 4,640 | ₪ 15,710 | ₪ 3,173,502 |
| 203 | ₪ 1,287,804 | ₪ 11,110 | ₪ 4,600 | ₪ 15,710 | ₪ 3,189,212 |
| 204 | ₪ 1,276,655 | ₪ 11,149 | ₪ 4,561 | ₪ 15,710 | ₪ 3,204,923 |
| 205 | ₪ 1,265,466 | ₪ 11,189 | ₪ 4,521 | ₪ 15,710 | ₪ 3,220,633 |
| 206 | ₪ 1,254,237 | ₪ 11,229 | ₪ 4,482 | ₪ 15,710 | ₪ 3,236,343 |
| 207 | ₪ 1,242,969 | ₪ 11,268 | ₪ 4,442 | ₪ 15,710 | ₪ 3,252,054 |
| 208 | ₪ 1,231,661 | ₪ 11,308 | ₪ 4,402 | ₪ 15,710 | ₪ 3,267,764 |
| 209 | ₪ 1,220,313 | ₪ 11,348 | ₪ 4,362 | ₪ 15,710 | ₪ 3,283,475 |
| 210 | ₪ 1,208,924 | ₪ 11,388 | ₪ 4,322 | ₪ 15,710 | ₪ 3,299,185 |
| 211 | ₪ 1,197,495 | ₪ 11,429 | ₪ 4,282 | ₪ 15,710 | ₪ 3,314,895 |
| 212 | ₪ 1,186,026 | ₪ 11,469 | ₪ 4,241 | ₪ 15,710 | ₪ 3,330,606 |
| 213 | ₪ 1,174,516 | ₪ 11,510 | ₪ 4,201 | ₪ 15,710 | ₪ 3,346,316 |
| 214 | ₪ 1,162,966 | ₪ 11,551 | ₪ 4,160 | ₪ 15,710 | ₪ 3,362,027 |
| 215 | ₪ 1,151,374 | ₪ 11,592 | ₪ 4,119 | ₪ 15,710 | ₪ 3,377,737 |
| 216 | ₪ 1,139,741 | ₪ 11,633 | ₪ 4,078 | ₪ 15,710 | ₪ 3,393,447 |
| 217 | ₪ 1,128,068 | ₪ 11,674 | ₪ 4,037 | ₪ 15,710 | ₪ 3,409,158 |
| 218 | ₪ 1,116,352 | ₪ 11,715 | ₪ 3,995 | ₪ 15,710 | ₪ 3,424,868 |
| 219 | ₪ 1,104,596 | ₪ 11,757 | ₪ 3,954 | ₪ 15,710 | ₪ 3,440,579 |
| 220 | ₪ 1,092,797 | ₪ 11,798 | ₪ 3,912 | ₪ 15,710 | ₪ 3,456,289 |
| 221 | ₪ 1,080,957 | ₪ 11,840 | ₪ 3,870 | ₪ 15,710 | ₪ 3,471,999 |
| 222 | ₪ 1,069,075 | ₪ 11,882 | ₪ 3,828 | ₪ 15,710 | ₪ 3,487,710 |
| 223 | ₪ 1,057,151 | ₪ 11,924 | ₪ 3,786 | ₪ 15,710 | ₪ 3,503,420 |
| 224 | ₪ 1,045,185 | ₪ 11,966 | ₪ 3,744 | ₪ 15,710 | ₪ 3,519,131 |
| 225 | ₪ 1,033,176 | ₪ 12,009 | ₪ 3,702 | ₪ 15,710 | ₪ 3,534,841 |
| 226 | ₪ 1,021,125 | ₪ 12,051 | ₪ 3,659 | ₪ 15,710 | ₪ 3,550,552 |
| 227 | ₪ 1,009,031 | ₪ 12,094 | ₪ 3,616 | ₪ 15,710 | ₪ 3,566,262 |
| 228 | ₪ 996,894 | ₪ 12,137 | ₪ 3,574 | ₪ 15,710 | ₪ 3,581,972 |
| 229 | ₪ 984,715 | ₪ 12,180 | ₪ 3,531 | ₪ 15,710 | ₪ 3,597,683 |
| 230 | ₪ 972,492 | ₪ 12,223 | ₪ 3,488 | ₪ 15,710 | ₪ 3,613,393 |
| 231 | ₪ 960,226 | ₪ 12,266 | ₪ 3,444 | ₪ 15,710 | ₪ 3,629,104 |
| 232 | ₪ 947,916 | ₪ 12,310 | ₪ 3,401 | ₪ 15,710 | ₪ 3,644,814 |
| 233 | ₪ 935,563 | ₪ 12,353 | ₪ 3,357 | ₪ 15,710 | ₪ 3,660,524 |
| 234 | ₪ 923,166 | ₪ 12,397 | ₪ 3,313 | ₪ 15,710 | ₪ 3,676,235 |
| 235 | ₪ 910,725 | ₪ 12,441 | ₪ 3,270 | ₪ 15,710 | ₪ 3,691,945 |
| 236 | ₪ 898,240 | ₪ 12,485 | ₪ 3,225 | ₪ 15,710 | ₪ 3,707,656 |
| 237 | ₪ 885,711 | ₪ 12,529 | ₪ 3,181 | ₪ 15,710 | ₪ 3,723,366 |
| 238 | ₪ 873,137 | ₪ 12,574 | ₪ 3,137 | ₪ 15,710 | ₪ 3,739,076 |
| 239 | ₪ 860,519 | ₪ 12,618 | ₪ 3,092 | ₪ 15,710 | ₪ 3,754,787 |
| 240 | ₪ 847,857 | ₪ 12,663 | ₪ 3,048 | ₪ 15,710 | ₪ 3,770,497 |
| 241 | ₪ 835,149 | ₪ 12,708 | ₪ 3,003 | ₪ 15,710 | ₪ 3,786,208 |
| 242 | ₪ 822,396 | ₪ 12,753 | ₪ 2,958 | ₪ 15,710 | ₪ 3,801,918 |
| 243 | ₪ 809,599 | ₪ 12,798 | ₪ 2,913 | ₪ 15,710 | ₪ 3,817,628 |
| 244 | ₪ 796,756 | ₪ 12,843 | ₪ 2,867 | ₪ 15,710 | ₪ 3,833,339 |
| 245 | ₪ 783,867 | ₪ 12,889 | ₪ 2,822 | ₪ 15,710 | ₪ 3,849,049 |
| 246 | ₪ 770,933 | ₪ 12,934 | ₪ 2,776 | ₪ 15,710 | ₪ 3,864,760 |
| 247 | ₪ 757,953 | ₪ 12,980 | ₪ 2,730 | ₪ 15,710 | ₪ 3,880,470 |
| 248 | ₪ 744,927 | ₪ 13,026 | ₪ 2,684 | ₪ 15,710 | ₪ 3,896,180 |
| 249 | ₪ 731,855 | ₪ 13,072 | ₪ 2,638 | ₪ 15,710 | ₪ 3,911,891 |
| 250 | ₪ 718,736 | ₪ 13,118 | ₪ 2,592 | ₪ 15,710 | ₪ 3,927,601 |
| 251 | ₪ 705,571 | ₪ 13,165 | ₪ 2,546 | ₪ 15,710 | ₪ 3,943,312 |
| 252 | ₪ 692,360 | ₪ 13,212 | ₪ 2,499 | ₪ 15,710 | ₪ 3,959,022 |
| 253 | ₪ 679,102 | ₪ 13,258 | ₪ 2,452 | ₪ 15,710 | ₪ 3,974,732 |
| 254 | ₪ 665,796 | ₪ 13,305 | ₪ 2,405 | ₪ 15,710 | ₪ 3,990,443 |
| 255 | ₪ 652,444 | ₪ 13,352 | ₪ 2,358 | ₪ 15,710 | ₪ 4,006,153 |
| 256 | ₪ 639,044 | ₪ 13,400 | ₪ 2,311 | ₪ 15,710 | ₪ 4,021,864 |
| 257 | ₪ 625,597 | ₪ 13,447 | ₪ 2,263 | ₪ 15,710 | ₪ 4,037,574 |
| 258 | ₪ 612,102 | ₪ 13,495 | ₪ 2,216 | ₪ 15,710 | ₪ 4,053,284 |
| 259 | ₪ 598,560 | ₪ 13,543 | ₪ 2,168 | ₪ 15,710 | ₪ 4,068,995 |
| 260 | ₪ 584,969 | ₪ 13,591 | ₪ 2,120 | ₪ 15,710 | ₪ 4,084,705 |
| 261 | ₪ 571,331 | ₪ 13,639 | ₪ 2,072 | ₪ 15,710 | ₪ 4,100,416 |
| 262 | ₪ 557,644 | ₪ 13,687 | ₪ 2,023 | ₪ 15,710 | ₪ 4,116,126 |
| 263 | ₪ 543,908 | ₪ 13,735 | ₪ 1,975 | ₪ 15,710 | ₪ 4,131,836 |
| 264 | ₪ 530,124 | ₪ 13,784 | ₪ 1,926 | ₪ 15,710 | ₪ 4,147,547 |
| 265 | ₪ 516,291 | ₪ 13,833 | ₪ 1,878 | ₪ 15,710 | ₪ 4,163,257 |
| 266 | ₪ 502,410 | ₪ 13,882 | ₪ 1,829 | ₪ 15,710 | ₪ 4,178,968 |
| 267 | ₪ 488,478 | ₪ 13,931 | ₪ 1,779 | ₪ 15,710 | ₪ 4,194,678 |
| 268 | ₪ 474,498 | ₪ 13,980 | ₪ 1,730 | ₪ 15,710 | ₪ 4,210,389 |
| 269 | ₪ 460,468 | ₪ 14,030 | ₪ 1,681 | ₪ 15,710 | ₪ 4,226,099 |
| 270 | ₪ 446,389 | ₪ 14,080 | ₪ 1,631 | ₪ 15,710 | ₪ 4,241,809 |
| 271 | ₪ 432,259 | ₪ 14,129 | ₪ 1,581 | ₪ 15,710 | ₪ 4,257,520 |
| 272 | ₪ 418,080 | ₪ 14,179 | ₪ 1,531 | ₪ 15,710 | ₪ 4,273,230 |
| 273 | ₪ 403,850 | ₪ 14,230 | ₪ 1,481 | ₪ 15,710 | ₪ 4,288,941 |
| 274 | ₪ 389,570 | ₪ 14,280 | ₪ 1,430 | ₪ 15,710 | ₪ 4,304,651 |
| 275 | ₪ 375,239 | ₪ 14,331 | ₪ 1,380 | ₪ 15,710 | ₪ 4,320,361 |
| 276 | ₪ 360,858 | ₪ 14,381 | ₪ 1,329 | ₪ 15,710 | ₪ 4,336,072 |
| 277 | ₪ 346,425 | ₪ 14,432 | ₪ 1,278 | ₪ 15,710 | ₪ 4,351,782 |
| 278 | ₪ 331,942 | ₪ 14,483 | ₪ 1,227 | ₪ 15,710 | ₪ 4,367,493 |
| 279 | ₪ 317,407 | ₪ 14,535 | ₪ 1,176 | ₪ 15,710 | ₪ 4,383,203 |
| 280 | ₪ 302,821 | ₪ 14,586 | ₪ 1,124 | ₪ 15,710 | ₪ 4,398,913 |
| 281 | ₪ 288,183 | ₪ 14,638 | ₪ 1,072 | ₪ 15,710 | ₪ 4,414,624 |
| 282 | ₪ 273,493 | ₪ 14,690 | ₪ 1,021 | ₪ 15,710 | ₪ 4,430,334 |
| 283 | ₪ 258,751 | ₪ 14,742 | ₪ 969 | ₪ 15,710 | ₪ 4,446,045 |
| 284 | ₪ 243,957 | ₪ 14,794 | ₪ 916 | ₪ 15,710 | ₪ 4,461,755 |
| 285 | ₪ 229,111 | ₪ 14,846 | ₪ 864 | ₪ 15,710 | ₪ 4,477,465 |
| 286 | ₪ 214,212 | ₪ 14,899 | ₪ 811 | ₪ 15,710 | ₪ 4,493,176 |
| 287 | ₪ 199,260 | ₪ 14,952 | ₪ 759 | ₪ 15,710 | ₪ 4,508,886 |
| 288 | ₪ 184,256 | ₪ 15,005 | ₪ 706 | ₪ 15,710 | ₪ 4,524,597 |
| 289 | ₪ 169,198 | ₪ 15,058 | ₪ 653 | ₪ 15,710 | ₪ 4,540,307 |
| 290 | ₪ 154,087 | ₪ 15,111 | ₪ 599 | ₪ 15,710 | ₪ 4,556,017 |
| 291 | ₪ 138,922 | ₪ 15,165 | ₪ 546 | ₪ 15,710 | ₪ 4,571,728 |
| 292 | ₪ 123,704 | ₪ 15,218 | ₪ 492 | ₪ 15,710 | ₪ 4,587,438 |
| 293 | ₪ 108,431 | ₪ 15,272 | ₪ 438 | ₪ 15,710 | ₪ 4,603,149 |
| 294 | ₪ 93,105 | ₪ 15,326 | ₪ 384 | ₪ 15,710 | ₪ 4,618,859 |
| 295 | ₪ 77,724 | ₪ 15,381 | ₪ 330 | ₪ 15,710 | ₪ 4,634,569 |
| 296 | ₪ 62,289 | ₪ 15,435 | ₪ 275 | ₪ 15,710 | ₪ 4,650,280 |
| 297 | ₪ 46,799 | ₪ 15,490 | ₪ 221 | ₪ 15,710 | ₪ 4,665,990 |
| 298 | ₪ 31,255 | ₪ 15,545 | ₪ 166 | ₪ 15,710 | ₪ 4,681,701 |
| 299 | ₪ 15,655 | ₪ 15,600 | ₪ 111 | ₪ 15,710 | ₪ 4,697,411 |
| 300 | ₪ 0 | ₪ 15,655 | ₪ 55 | ₪ 15,710 | ₪ 4,713,121 |
| סה"כ | ₪ 2,900,000 | ₪ 1,813,121 | ₪ 4,713,121 | ₪ 4,713,121 |
ראו גם: מה ההחזר על משכנתא של 2,800,000 שח? | מה ההחזר על משכנתא של 3,000,000 שח?