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