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