19,816 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 3,200,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שלושה מיליון ומאתיים אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
19,816 ש"ח
1,555,721 ש"ח
4,755,721 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 3,191,518 | ₪ 8,482 | ₪ 11,333 | ₪ 19,816 | ₪ 19,816 |
| 2 | ₪ 3,183,006 | ₪ 8,512 | ₪ 11,303 | ₪ 19,816 | ₪ 39,631 |
| 3 | ₪ 3,174,463 | ₪ 8,542 | ₪ 11,273 | ₪ 19,816 | ₪ 59,447 |
| 4 | ₪ 3,165,891 | ₪ 8,573 | ₪ 11,243 | ₪ 19,816 | ₪ 79,262 |
| 5 | ₪ 3,157,288 | ₪ 8,603 | ₪ 11,213 | ₪ 19,816 | ₪ 99,078 |
| 6 | ₪ 3,148,654 | ₪ 8,633 | ₪ 11,182 | ₪ 19,816 | ₪ 118,893 |
| 7 | ₪ 3,139,990 | ₪ 8,664 | ₪ 11,151 | ₪ 19,816 | ₪ 138,709 |
| 8 | ₪ 3,131,296 | ₪ 8,695 | ₪ 11,121 | ₪ 19,816 | ₪ 158,524 |
| 9 | ₪ 3,122,570 | ₪ 8,725 | ₪ 11,090 | ₪ 19,816 | ₪ 178,340 |
| 10 | ₪ 3,113,814 | ₪ 8,756 | ₪ 11,059 | ₪ 19,816 | ₪ 198,155 |
| 11 | ₪ 3,105,026 | ₪ 8,787 | ₪ 11,028 | ₪ 19,816 | ₪ 217,971 |
| 12 | ₪ 3,096,208 | ₪ 8,819 | ₪ 10,997 | ₪ 19,816 | ₪ 237,786 |
| 13 | ₪ 3,087,358 | ₪ 8,850 | ₪ 10,966 | ₪ 19,816 | ₪ 257,602 |
| 14 | ₪ 3,078,477 | ₪ 8,881 | ₪ 10,934 | ₪ 19,816 | ₪ 277,417 |
| 15 | ₪ 3,069,564 | ₪ 8,913 | ₪ 10,903 | ₪ 19,816 | ₪ 297,233 |
| 16 | ₪ 3,060,620 | ₪ 8,944 | ₪ 10,871 | ₪ 19,816 | ₪ 317,048 |
| 17 | ₪ 3,051,644 | ₪ 8,976 | ₪ 10,840 | ₪ 19,816 | ₪ 336,864 |
| 18 | ₪ 3,042,637 | ₪ 9,008 | ₪ 10,808 | ₪ 19,816 | ₪ 356,679 |
| 19 | ₪ 3,033,597 | ₪ 9,039 | ₪ 10,776 | ₪ 19,816 | ₪ 376,495 |
| 20 | ₪ 3,024,526 | ₪ 9,072 | ₪ 10,744 | ₪ 19,816 | ₪ 396,310 |
| 21 | ₪ 3,015,422 | ₪ 9,104 | ₪ 10,712 | ₪ 19,816 | ₪ 416,126 |
| 22 | ₪ 3,006,286 | ₪ 9,136 | ₪ 10,680 | ₪ 19,816 | ₪ 435,941 |
| 23 | ₪ 2,997,118 | ₪ 9,168 | ₪ 10,647 | ₪ 19,816 | ₪ 455,757 |
| 24 | ₪ 2,987,917 | ₪ 9,201 | ₪ 10,615 | ₪ 19,816 | ₪ 475,572 |
| 25 | ₪ 2,978,684 | ₪ 9,233 | ₪ 10,582 | ₪ 19,816 | ₪ 495,388 |
| 26 | ₪ 2,969,418 | ₪ 9,266 | ₪ 10,550 | ₪ 19,816 | ₪ 515,203 |
| 27 | ₪ 2,960,119 | ₪ 9,299 | ₪ 10,517 | ₪ 19,816 | ₪ 535,019 |
| 28 | ₪ 2,950,787 | ₪ 9,332 | ₪ 10,484 | ₪ 19,816 | ₪ 554,834 |
| 29 | ₪ 2,941,423 | ₪ 9,365 | ₪ 10,451 | ₪ 19,816 | ₪ 574,650 |
| 30 | ₪ 2,932,025 | ₪ 9,398 | ₪ 10,418 | ₪ 19,816 | ₪ 594,465 |
| 31 | ₪ 2,922,593 | ₪ 9,431 | ₪ 10,384 | ₪ 19,816 | ₪ 614,281 |
| 32 | ₪ 2,913,129 | ₪ 9,465 | ₪ 10,351 | ₪ 19,816 | ₪ 634,096 |
| 33 | ₪ 2,903,631 | ₪ 9,498 | ₪ 10,317 | ₪ 19,816 | ₪ 653,912 |
| 34 | ₪ 2,894,099 | ₪ 9,532 | ₪ 10,284 | ₪ 19,816 | ₪ 673,727 |
| 35 | ₪ 2,884,533 | ₪ 9,566 | ₪ 10,250 | ₪ 19,816 | ₪ 693,543 |
| 36 | ₪ 2,874,934 | ₪ 9,599 | ₪ 10,216 | ₪ 19,816 | ₪ 713,358 |
| 37 | ₪ 2,865,300 | ₪ 9,633 | ₪ 10,182 | ₪ 19,816 | ₪ 733,174 |
| 38 | ₪ 2,855,633 | ₪ 9,668 | ₪ 10,148 | ₪ 19,816 | ₪ 752,989 |
| 39 | ₪ 2,845,931 | ₪ 9,702 | ₪ 10,114 | ₪ 19,816 | ₪ 772,805 |
| 40 | ₪ 2,836,195 | ₪ 9,736 | ₪ 10,079 | ₪ 19,816 | ₪ 792,620 |
| 41 | ₪ 2,826,424 | ₪ 9,771 | ₪ 10,045 | ₪ 19,816 | ₪ 812,436 |
| 42 | ₪ 2,816,619 | ₪ 9,805 | ₪ 10,010 | ₪ 19,816 | ₪ 832,251 |
| 43 | ₪ 2,806,779 | ₪ 9,840 | ₪ 9,976 | ₪ 19,816 | ₪ 852,067 |
| 44 | ₪ 2,796,904 | ₪ 9,875 | ₪ 9,941 | ₪ 19,816 | ₪ 871,882 |
| 45 | ₪ 2,786,994 | ₪ 9,910 | ₪ 9,906 | ₪ 19,816 | ₪ 891,698 |
| 46 | ₪ 2,777,049 | ₪ 9,945 | ₪ 9,871 | ₪ 19,816 | ₪ 911,513 |
| 47 | ₪ 2,767,069 | ₪ 9,980 | ₪ 9,835 | ₪ 19,816 | ₪ 931,329 |
| 48 | ₪ 2,757,054 | ₪ 10,015 | ₪ 9,800 | ₪ 19,816 | ₪ 951,144 |
| 49 | ₪ 2,747,003 | ₪ 10,051 | ₪ 9,765 | ₪ 19,816 | ₪ 970,960 |
| 50 | ₪ 2,736,916 | ₪ 10,087 | ₪ 9,729 | ₪ 19,816 | ₪ 990,775 |
| 51 | ₪ 2,726,794 | ₪ 10,122 | ₪ 9,693 | ₪ 19,816 | ₪ 1,010,591 |
| 52 | ₪ 2,716,636 | ₪ 10,158 | ₪ 9,657 | ₪ 19,816 | ₪ 1,030,406 |
| 53 | ₪ 2,706,442 | ₪ 10,194 | ₪ 9,621 | ₪ 19,816 | ₪ 1,050,222 |
| 54 | ₪ 2,696,212 | ₪ 10,230 | ₪ 9,585 | ₪ 19,816 | ₪ 1,070,037 |
| 55 | ₪ 2,685,945 | ₪ 10,266 | ₪ 9,549 | ₪ 19,816 | ₪ 1,089,853 |
| 56 | ₪ 2,675,642 | ₪ 10,303 | ₪ 9,513 | ₪ 19,816 | ₪ 1,109,668 |
| 57 | ₪ 2,665,303 | ₪ 10,339 | ₪ 9,476 | ₪ 19,816 | ₪ 1,129,484 |
| 58 | ₪ 2,654,927 | ₪ 10,376 | ₪ 9,440 | ₪ 19,816 | ₪ 1,149,299 |
| 59 | ₪ 2,644,515 | ₪ 10,413 | ₪ 9,403 | ₪ 19,816 | ₪ 1,169,115 |
| 60 | ₪ 2,634,065 | ₪ 10,450 | ₪ 9,366 | ₪ 19,816 | ₪ 1,188,930 |
| 61 | ₪ 2,623,579 | ₪ 10,487 | ₪ 9,329 | ₪ 19,816 | ₪ 1,208,746 |
| 62 | ₪ 2,613,055 | ₪ 10,524 | ₪ 9,292 | ₪ 19,816 | ₪ 1,228,561 |
| 63 | ₪ 2,602,494 | ₪ 10,561 | ₪ 9,255 | ₪ 19,816 | ₪ 1,248,377 |
| 64 | ₪ 2,591,896 | ₪ 10,598 | ₪ 9,217 | ₪ 19,816 | ₪ 1,268,192 |
| 65 | ₪ 2,581,260 | ₪ 10,636 | ₪ 9,180 | ₪ 19,816 | ₪ 1,288,008 |
| 66 | ₪ 2,570,586 | ₪ 10,674 | ₪ 9,142 | ₪ 19,816 | ₪ 1,307,823 |
| 67 | ₪ 2,559,875 | ₪ 10,711 | ₪ 9,104 | ₪ 19,816 | ₪ 1,327,639 |
| 68 | ₪ 2,549,126 | ₪ 10,749 | ₪ 9,066 | ₪ 19,816 | ₪ 1,347,454 |
| 69 | ₪ 2,538,338 | ₪ 10,787 | ₪ 9,028 | ₪ 19,816 | ₪ 1,367,270 |
| 70 | ₪ 2,527,513 | ₪ 10,826 | ₪ 8,990 | ₪ 19,816 | ₪ 1,387,085 |
| 71 | ₪ 2,516,649 | ₪ 10,864 | ₪ 8,952 | ₪ 19,816 | ₪ 1,406,901 |
| 72 | ₪ 2,505,746 | ₪ 10,902 | ₪ 8,913 | ₪ 19,816 | ₪ 1,426,716 |
| 73 | ₪ 2,494,805 | ₪ 10,941 | ₪ 8,875 | ₪ 19,816 | ₪ 1,446,532 |
| 74 | ₪ 2,483,826 | ₪ 10,980 | ₪ 8,836 | ₪ 19,816 | ₪ 1,466,347 |
| 75 | ₪ 2,472,807 | ₪ 11,019 | ₪ 8,797 | ₪ 19,816 | ₪ 1,486,163 |
| 76 | ₪ 2,461,749 | ₪ 11,058 | ₪ 8,758 | ₪ 19,816 | ₪ 1,505,978 |
| 77 | ₪ 2,450,653 | ₪ 11,097 | ₪ 8,719 | ₪ 19,816 | ₪ 1,525,794 |
| 78 | ₪ 2,439,517 | ₪ 11,136 | ₪ 8,679 | ₪ 19,816 | ₪ 1,545,609 |
| 79 | ₪ 2,428,341 | ₪ 11,176 | ₪ 8,640 | ₪ 19,816 | ₪ 1,565,425 |
| 80 | ₪ 2,417,126 | ₪ 11,215 | ₪ 8,600 | ₪ 19,816 | ₪ 1,585,240 |
| 81 | ₪ 2,405,871 | ₪ 11,255 | ₪ 8,561 | ₪ 19,816 | ₪ 1,605,056 |
| 82 | ₪ 2,394,576 | ₪ 11,295 | ₪ 8,521 | ₪ 19,816 | ₪ 1,624,871 |
| 83 | ₪ 2,383,242 | ₪ 11,335 | ₪ 8,481 | ₪ 19,816 | ₪ 1,644,687 |
| 84 | ₪ 2,371,867 | ₪ 11,375 | ₪ 8,441 | ₪ 19,816 | ₪ 1,664,502 |
| 85 | ₪ 2,360,452 | ₪ 11,415 | ₪ 8,400 | ₪ 19,816 | ₪ 1,684,318 |
| 86 | ₪ 2,348,996 | ₪ 11,456 | ₪ 8,360 | ₪ 19,816 | ₪ 1,704,133 |
| 87 | ₪ 2,337,500 | ₪ 11,496 | ₪ 8,319 | ₪ 19,816 | ₪ 1,723,949 |
| 88 | ₪ 2,325,963 | ₪ 11,537 | ₪ 8,279 | ₪ 19,816 | ₪ 1,743,764 |
| 89 | ₪ 2,314,385 | ₪ 11,578 | ₪ 8,238 | ₪ 19,816 | ₪ 1,763,580 |
| 90 | ₪ 2,302,767 | ₪ 11,619 | ₪ 8,197 | ₪ 19,816 | ₪ 1,783,395 |
| 91 | ₪ 2,291,107 | ₪ 11,660 | ₪ 8,156 | ₪ 19,816 | ₪ 1,803,211 |
| 92 | ₪ 2,279,406 | ₪ 11,701 | ₪ 8,114 | ₪ 19,816 | ₪ 1,823,026 |
| 93 | ₪ 2,267,663 | ₪ 11,743 | ₪ 8,073 | ₪ 19,816 | ₪ 1,842,842 |
| 94 | ₪ 2,255,879 | ₪ 11,784 | ₪ 8,031 | ₪ 19,816 | ₪ 1,862,657 |
| 95 | ₪ 2,244,053 | ₪ 11,826 | ₪ 7,990 | ₪ 19,816 | ₪ 1,882,473 |
| 96 | ₪ 2,232,185 | ₪ 11,868 | ₪ 7,948 | ₪ 19,816 | ₪ 1,902,288 |
| 97 | ₪ 2,220,275 | ₪ 11,910 | ₪ 7,906 | ₪ 19,816 | ₪ 1,922,104 |
| 98 | ₪ 2,208,323 | ₪ 11,952 | ₪ 7,863 | ₪ 19,816 | ₪ 1,941,919 |
| 99 | ₪ 2,196,329 | ₪ 11,994 | ₪ 7,821 | ₪ 19,816 | ₪ 1,961,735 |
| 100 | ₪ 2,184,292 | ₪ 12,037 | ₪ 7,779 | ₪ 19,816 | ₪ 1,981,550 |
| 101 | ₪ 2,172,212 | ₪ 12,079 | ₪ 7,736 | ₪ 19,816 | ₪ 2,001,366 |
| 102 | ₪ 2,160,090 | ₪ 12,122 | ₪ 7,693 | ₪ 19,816 | ₪ 2,021,181 |
| 103 | ₪ 2,147,925 | ₪ 12,165 | ₪ 7,650 | ₪ 19,816 | ₪ 2,040,997 |
| 104 | ₪ 2,135,717 | ₪ 12,208 | ₪ 7,607 | ₪ 19,816 | ₪ 2,060,812 |
| 105 | ₪ 2,123,465 | ₪ 12,252 | ₪ 7,564 | ₪ 19,816 | ₪ 2,080,628 |
| 106 | ₪ 2,111,170 | ₪ 12,295 | ₪ 7,521 | ₪ 19,816 | ₪ 2,100,443 |
| 107 | ₪ 2,098,832 | ₪ 12,338 | ₪ 7,477 | ₪ 19,816 | ₪ 2,120,259 |
| 108 | ₪ 2,086,450 | ₪ 12,382 | ₪ 7,433 | ₪ 19,816 | ₪ 2,140,074 |
| 109 | ₪ 2,074,024 | ₪ 12,426 | ₪ 7,390 | ₪ 19,816 | ₪ 2,159,890 |
| 110 | ₪ 2,061,554 | ₪ 12,470 | ₪ 7,346 | ₪ 19,816 | ₪ 2,179,705 |
| 111 | ₪ 2,049,040 | ₪ 12,514 | ₪ 7,301 | ₪ 19,816 | ₪ 2,199,521 |
| 112 | ₪ 2,036,481 | ₪ 12,558 | ₪ 7,257 | ₪ 19,816 | ₪ 2,219,336 |
| 113 | ₪ 2,023,878 | ₪ 12,603 | ₪ 7,213 | ₪ 19,816 | ₪ 2,239,152 |
| 114 | ₪ 2,011,231 | ₪ 12,648 | ₪ 7,168 | ₪ 19,816 | ₪ 2,258,967 |
| 115 | ₪ 1,998,538 | ₪ 12,692 | ₪ 7,123 | ₪ 19,816 | ₪ 2,278,783 |
| 116 | ₪ 1,985,801 | ₪ 12,737 | ₪ 7,078 | ₪ 19,816 | ₪ 2,298,598 |
| 117 | ₪ 1,973,018 | ₪ 12,782 | ₪ 7,033 | ₪ 19,816 | ₪ 2,318,414 |
| 118 | ₪ 1,960,191 | ₪ 12,828 | ₪ 6,988 | ₪ 19,816 | ₪ 2,338,229 |
| 119 | ₪ 1,947,317 | ₪ 12,873 | ₪ 6,942 | ₪ 19,816 | ₪ 2,358,045 |
| 120 | ₪ 1,934,399 | ₪ 12,919 | ₪ 6,897 | ₪ 19,816 | ₪ 2,377,860 |
| 121 | ₪ 1,921,434 | ₪ 12,965 | ₪ 6,851 | ₪ 19,816 | ₪ 2,397,676 |
| 122 | ₪ 1,908,424 | ₪ 13,010 | ₪ 6,805 | ₪ 19,816 | ₪ 2,417,491 |
| 123 | ₪ 1,895,367 | ₪ 13,057 | ₪ 6,759 | ₪ 19,816 | ₪ 2,437,307 |
| 124 | ₪ 1,882,265 | ₪ 13,103 | ₪ 6,713 | ₪ 19,816 | ₪ 2,457,122 |
| 125 | ₪ 1,869,115 | ₪ 13,149 | ₪ 6,666 | ₪ 19,816 | ₪ 2,476,938 |
| 126 | ₪ 1,855,920 | ₪ 13,196 | ₪ 6,620 | ₪ 19,816 | ₪ 2,496,753 |
| 127 | ₪ 1,842,677 | ₪ 13,242 | ₪ 6,573 | ₪ 19,816 | ₪ 2,516,569 |
| 128 | ₪ 1,829,388 | ₪ 13,289 | ₪ 6,526 | ₪ 19,816 | ₪ 2,536,384 |
| 129 | ₪ 1,816,051 | ₪ 13,336 | ₪ 6,479 | ₪ 19,816 | ₪ 2,556,200 |
| 130 | ₪ 1,802,668 | ₪ 13,384 | ₪ 6,432 | ₪ 19,816 | ₪ 2,576,015 |
| 131 | ₪ 1,789,237 | ₪ 13,431 | ₪ 6,384 | ₪ 19,816 | ₪ 2,595,831 |
| 132 | ₪ 1,775,758 | ₪ 13,479 | ₪ 6,337 | ₪ 19,816 | ₪ 2,615,646 |
| 133 | ₪ 1,762,232 | ₪ 13,526 | ₪ 6,289 | ₪ 19,816 | ₪ 2,635,462 |
| 134 | ₪ 1,748,657 | ₪ 13,574 | ₪ 6,241 | ₪ 19,816 | ₪ 2,655,277 |
| 135 | ₪ 1,735,035 | ₪ 13,622 | ₪ 6,193 | ₪ 19,816 | ₪ 2,675,093 |
| 136 | ₪ 1,721,365 | ₪ 13,671 | ₪ 6,145 | ₪ 19,816 | ₪ 2,694,908 |
| 137 | ₪ 1,707,646 | ₪ 13,719 | ₪ 6,096 | ₪ 19,816 | ₪ 2,714,724 |
| 138 | ₪ 1,693,878 | ₪ 13,768 | ₪ 6,048 | ₪ 19,816 | ₪ 2,734,539 |
| 139 | ₪ 1,680,062 | ₪ 13,816 | ₪ 5,999 | ₪ 19,816 | ₪ 2,754,355 |
| 140 | ₪ 1,666,196 | ₪ 13,865 | ₪ 5,950 | ₪ 19,816 | ₪ 2,774,170 |
| 141 | ₪ 1,652,282 | ₪ 13,914 | ₪ 5,901 | ₪ 19,816 | ₪ 2,793,986 |
| 142 | ₪ 1,638,318 | ₪ 13,964 | ₪ 5,852 | ₪ 19,816 | ₪ 2,813,801 |
| 143 | ₪ 1,624,305 | ₪ 14,013 | ₪ 5,802 | ₪ 19,816 | ₪ 2,833,617 |
| 144 | ₪ 1,610,242 | ₪ 14,063 | ₪ 5,753 | ₪ 19,816 | ₪ 2,853,432 |
| 145 | ₪ 1,596,130 | ₪ 14,113 | ₪ 5,703 | ₪ 19,816 | ₪ 2,873,248 |
| 146 | ₪ 1,581,967 | ₪ 14,163 | ₪ 5,653 | ₪ 19,816 | ₪ 2,893,063 |
| 147 | ₪ 1,567,755 | ₪ 14,213 | ₪ 5,603 | ₪ 19,816 | ₪ 2,912,879 |
| 148 | ₪ 1,553,492 | ₪ 14,263 | ₪ 5,552 | ₪ 19,816 | ₪ 2,932,694 |
| 149 | ₪ 1,539,178 | ₪ 14,314 | ₪ 5,502 | ₪ 19,816 | ₪ 2,952,510 |
| 150 | ₪ 1,524,814 | ₪ 14,364 | ₪ 5,451 | ₪ 19,816 | ₪ 2,972,325 |
| 151 | ₪ 1,510,399 | ₪ 14,415 | ₪ 5,400 | ₪ 19,816 | ₪ 2,992,141 |
| 152 | ₪ 1,495,932 | ₪ 14,466 | ₪ 5,349 | ₪ 19,816 | ₪ 3,011,956 |
| 153 | ₪ 1,481,415 | ₪ 14,517 | ₪ 5,298 | ₪ 19,816 | ₪ 3,031,772 |
| 154 | ₪ 1,466,846 | ₪ 14,569 | ₪ 5,247 | ₪ 19,816 | ₪ 3,051,587 |
| 155 | ₪ 1,452,226 | ₪ 14,620 | ₪ 5,195 | ₪ 19,816 | ₪ 3,071,403 |
| 156 | ₪ 1,437,554 | ₪ 14,672 | ₪ 5,143 | ₪ 19,816 | ₪ 3,091,218 |
| 157 | ₪ 1,422,829 | ₪ 14,724 | ₪ 5,091 | ₪ 19,816 | ₪ 3,111,034 |
| 158 | ₪ 1,408,053 | ₪ 14,776 | ₪ 5,039 | ₪ 19,816 | ₪ 3,130,849 |
| 159 | ₪ 1,393,224 | ₪ 14,829 | ₪ 4,987 | ₪ 19,816 | ₪ 3,150,665 |
| 160 | ₪ 1,378,343 | ₪ 14,881 | ₪ 4,934 | ₪ 19,816 | ₪ 3,170,480 |
| 161 | ₪ 1,363,409 | ₪ 14,934 | ₪ 4,882 | ₪ 19,816 | ₪ 3,190,296 |
| 162 | ₪ 1,348,423 | ₪ 14,987 | ₪ 4,829 | ₪ 19,816 | ₪ 3,210,111 |
| 163 | ₪ 1,333,383 | ₪ 15,040 | ₪ 4,776 | ₪ 19,816 | ₪ 3,229,927 |
| 164 | ₪ 1,318,290 | ₪ 15,093 | ₪ 4,722 | ₪ 19,816 | ₪ 3,249,742 |
| 165 | ₪ 1,303,143 | ₪ 15,147 | ₪ 4,669 | ₪ 19,816 | ₪ 3,269,558 |
| 166 | ₪ 1,287,943 | ₪ 15,200 | ₪ 4,615 | ₪ 19,816 | ₪ 3,289,374 |
| 167 | ₪ 1,272,689 | ₪ 15,254 | ₪ 4,561 | ₪ 19,816 | ₪ 3,309,189 |
| 168 | ₪ 1,257,381 | ₪ 15,308 | ₪ 4,507 | ₪ 19,816 | ₪ 3,329,005 |
| 169 | ₪ 1,242,019 | ₪ 15,362 | ₪ 4,453 | ₪ 19,816 | ₪ 3,348,820 |
| 170 | ₪ 1,226,602 | ₪ 15,417 | ₪ 4,399 | ₪ 19,816 | ₪ 3,368,636 |
| 171 | ₪ 1,211,131 | ₪ 15,471 | ₪ 4,344 | ₪ 19,816 | ₪ 3,388,451 |
| 172 | ₪ 1,195,604 | ₪ 15,526 | ₪ 4,289 | ₪ 19,816 | ₪ 3,408,267 |
| 173 | ₪ 1,180,023 | ₪ 15,581 | ₪ 4,234 | ₪ 19,816 | ₪ 3,428,082 |
| 174 | ₪ 1,164,387 | ₪ 15,636 | ₪ 4,179 | ₪ 19,816 | ₪ 3,447,898 |
| 175 | ₪ 1,148,696 | ₪ 15,692 | ₪ 4,124 | ₪ 19,816 | ₪ 3,467,713 |
| 176 | ₪ 1,132,948 | ₪ 15,747 | ₪ 4,068 | ₪ 19,816 | ₪ 3,487,529 |
| 177 | ₪ 1,117,145 | ₪ 15,803 | ₪ 4,013 | ₪ 19,816 | ₪ 3,507,344 |
| 178 | ₪ 1,101,286 | ₪ 15,859 | ₪ 3,957 | ₪ 19,816 | ₪ 3,527,160 |
| 179 | ₪ 1,085,371 | ₪ 15,915 | ₪ 3,900 | ₪ 19,816 | ₪ 3,546,975 |
| 180 | ₪ 1,069,400 | ₪ 15,971 | ₪ 3,844 | ₪ 19,816 | ₪ 3,566,791 |
| 181 | ₪ 1,053,372 | ₪ 16,028 | ₪ 3,787 | ₪ 19,816 | ₪ 3,586,606 |
| 182 | ₪ 1,037,287 | ₪ 16,085 | ₪ 3,731 | ₪ 19,816 | ₪ 3,606,422 |
| 183 | ₪ 1,021,145 | ₪ 16,142 | ₪ 3,674 | ₪ 19,816 | ₪ 3,626,237 |
| 184 | ₪ 1,004,946 | ₪ 16,199 | ₪ 3,617 | ₪ 19,816 | ₪ 3,646,053 |
| 185 | ₪ 988,690 | ₪ 16,256 | ₪ 3,559 | ₪ 19,816 | ₪ 3,665,868 |
| 186 | ₪ 972,376 | ₪ 16,314 | ₪ 3,502 | ₪ 19,816 | ₪ 3,685,684 |
| 187 | ₪ 956,004 | ₪ 16,372 | ₪ 3,444 | ₪ 19,816 | ₪ 3,705,499 |
| 188 | ₪ 939,575 | ₪ 16,430 | ₪ 3,386 | ₪ 19,816 | ₪ 3,725,315 |
| 189 | ₪ 923,087 | ₪ 16,488 | ₪ 3,328 | ₪ 19,816 | ₪ 3,745,130 |
| 190 | ₪ 906,541 | ₪ 16,546 | ₪ 3,269 | ₪ 19,816 | ₪ 3,764,946 |
| 191 | ₪ 889,936 | ₪ 16,605 | ₪ 3,211 | ₪ 19,816 | ₪ 3,784,761 |
| 192 | ₪ 873,272 | ₪ 16,664 | ₪ 3,152 | ₪ 19,816 | ₪ 3,804,577 |
| 193 | ₪ 856,549 | ₪ 16,723 | ₪ 3,093 | ₪ 19,816 | ₪ 3,824,392 |
| 194 | ₪ 839,768 | ₪ 16,782 | ₪ 3,034 | ₪ 19,816 | ₪ 3,844,208 |
| 195 | ₪ 822,926 | ₪ 16,841 | ₪ 2,974 | ₪ 19,816 | ₪ 3,864,023 |
| 196 | ₪ 806,025 | ₪ 16,901 | ₪ 2,915 | ₪ 19,816 | ₪ 3,883,839 |
| 197 | ₪ 789,064 | ₪ 16,961 | ₪ 2,855 | ₪ 19,816 | ₪ 3,903,654 |
| 198 | ₪ 772,044 | ₪ 17,021 | ₪ 2,795 | ₪ 19,816 | ₪ 3,923,470 |
| 199 | ₪ 754,962 | ₪ 17,081 | ₪ 2,734 | ₪ 19,816 | ₪ 3,943,285 |
| 200 | ₪ 737,821 | ₪ 17,142 | ₪ 2,674 | ₪ 19,816 | ₪ 3,963,101 |
| 201 | ₪ 720,618 | ₪ 17,202 | ₪ 2,613 | ₪ 19,816 | ₪ 3,982,916 |
| 202 | ₪ 703,355 | ₪ 17,263 | ₪ 2,552 | ₪ 19,816 | ₪ 4,002,732 |
| 203 | ₪ 686,031 | ₪ 17,324 | ₪ 2,491 | ₪ 19,816 | ₪ 4,022,547 |
| 204 | ₪ 668,645 | ₪ 17,386 | ₪ 2,430 | ₪ 19,816 | ₪ 4,042,363 |
| 205 | ₪ 651,197 | ₪ 17,447 | ₪ 2,368 | ₪ 19,816 | ₪ 4,062,178 |
| 206 | ₪ 633,688 | ₪ 17,509 | ₪ 2,306 | ₪ 19,816 | ₪ 4,081,994 |
| 207 | ₪ 616,117 | ₪ 17,571 | ₪ 2,244 | ₪ 19,816 | ₪ 4,101,809 |
| 208 | ₪ 598,484 | ₪ 17,633 | ₪ 2,182 | ₪ 19,816 | ₪ 4,121,625 |
| 209 | ₪ 580,788 | ₪ 17,696 | ₪ 2,120 | ₪ 19,816 | ₪ 4,141,440 |
| 210 | ₪ 563,029 | ₪ 17,759 | ₪ 2,057 | ₪ 19,816 | ₪ 4,161,256 |
| 211 | ₪ 545,208 | ₪ 17,821 | ₪ 1,994 | ₪ 19,816 | ₪ 4,181,071 |
| 212 | ₪ 527,323 | ₪ 17,885 | ₪ 1,931 | ₪ 19,816 | ₪ 4,200,887 |
| 213 | ₪ 509,375 | ₪ 17,948 | ₪ 1,868 | ₪ 19,816 | ₪ 4,220,702 |
| 214 | ₪ 491,364 | ₪ 18,011 | ₪ 1,804 | ₪ 19,816 | ₪ 4,240,518 |
| 215 | ₪ 473,288 | ₪ 18,075 | ₪ 1,740 | ₪ 19,816 | ₪ 4,260,333 |
| 216 | ₪ 455,149 | ₪ 18,139 | ₪ 1,676 | ₪ 19,816 | ₪ 4,280,149 |
| 217 | ₪ 436,946 | ₪ 18,204 | ₪ 1,612 | ₪ 19,816 | ₪ 4,299,964 |
| 218 | ₪ 418,678 | ₪ 18,268 | ₪ 1,548 | ₪ 19,816 | ₪ 4,319,780 |
| 219 | ₪ 400,345 | ₪ 18,333 | ₪ 1,483 | ₪ 19,816 | ₪ 4,339,595 |
| 220 | ₪ 381,947 | ₪ 18,398 | ₪ 1,418 | ₪ 19,816 | ₪ 4,359,411 |
| 221 | ₪ 363,485 | ₪ 18,463 | ₪ 1,353 | ₪ 19,816 | ₪ 4,379,226 |
| 222 | ₪ 344,956 | ₪ 18,528 | ₪ 1,287 | ₪ 19,816 | ₪ 4,399,042 |
| 223 | ₪ 326,363 | ₪ 18,594 | ₪ 1,222 | ₪ 19,816 | ₪ 4,418,857 |
| 224 | ₪ 307,703 | ₪ 18,660 | ₪ 1,156 | ₪ 19,816 | ₪ 4,438,673 |
| 225 | ₪ 288,977 | ₪ 18,726 | ₪ 1,090 | ₪ 19,816 | ₪ 4,458,488 |
| 226 | ₪ 270,185 | ₪ 18,792 | ₪ 1,023 | ₪ 19,816 | ₪ 4,478,304 |
| 227 | ₪ 251,327 | ₪ 18,859 | ₪ 957 | ₪ 19,816 | ₪ 4,498,119 |
| 228 | ₪ 232,401 | ₪ 18,925 | ₪ 890 | ₪ 19,816 | ₪ 4,517,935 |
| 229 | ₪ 213,409 | ₪ 18,992 | ₪ 823 | ₪ 19,816 | ₪ 4,537,750 |
| 230 | ₪ 194,349 | ₪ 19,060 | ₪ 756 | ₪ 19,816 | ₪ 4,557,566 |
| 231 | ₪ 175,222 | ₪ 19,127 | ₪ 688 | ₪ 19,816 | ₪ 4,577,381 |
| 232 | ₪ 156,027 | ₪ 19,195 | ₪ 621 | ₪ 19,816 | ₪ 4,597,197 |
| 233 | ₪ 136,764 | ₪ 19,263 | ₪ 553 | ₪ 19,816 | ₪ 4,617,012 |
| 234 | ₪ 117,433 | ₪ 19,331 | ₪ 484 | ₪ 19,816 | ₪ 4,636,828 |
| 235 | ₪ 98,033 | ₪ 19,400 | ₪ 416 | ₪ 19,816 | ₪ 4,656,643 |
| 236 | ₪ 78,565 | ₪ 19,468 | ₪ 347 | ₪ 19,816 | ₪ 4,676,459 |
| 237 | ₪ 59,028 | ₪ 19,537 | ₪ 278 | ₪ 19,816 | ₪ 4,696,274 |
| 238 | ₪ 39,421 | ₪ 19,606 | ₪ 209 | ₪ 19,816 | ₪ 4,716,090 |
| 239 | ₪ 19,746 | ₪ 19,676 | ₪ 140 | ₪ 19,816 | ₪ 4,735,905 |
| 240 | ₪ 0 | ₪ 19,746 | ₪ 70 | ₪ 19,816 | ₪ 4,755,721 |
| סה"כ | ₪ 3,200,000 | ₪ 1,555,721 | ₪ 4,755,721 | ₪ 4,755,721 |
ראו גם: מה ההחזר על משכנתא של 3,100,000 שח? | מה ההחזר על משכנתא של 3,200,000 שח?