17,958 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,900,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ותשע מאות אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
17,958 ש"ח
1,409,872 ש"ח
4,309,872 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,892,313 | ₪ 7,687 | ₪ 10,271 | ₪ 17,958 | ₪ 17,958 |
| 2 | ₪ 2,884,599 | ₪ 7,714 | ₪ 10,244 | ₪ 17,958 | ₪ 35,916 |
| 3 | ₪ 2,876,857 | ₪ 7,742 | ₪ 10,216 | ₪ 17,958 | ₪ 53,873 |
| 4 | ₪ 2,869,088 | ₪ 7,769 | ₪ 10,189 | ₪ 17,958 | ₪ 71,831 |
| 5 | ₪ 2,861,292 | ₪ 7,796 | ₪ 10,161 | ₪ 17,958 | ₪ 89,789 |
| 6 | ₪ 2,853,468 | ₪ 7,824 | ₪ 10,134 | ₪ 17,958 | ₪ 107,747 |
| 7 | ₪ 2,845,616 | ₪ 7,852 | ₪ 10,106 | ₪ 17,958 | ₪ 125,705 |
| 8 | ₪ 2,837,737 | ₪ 7,880 | ₪ 10,078 | ₪ 17,958 | ₪ 143,662 |
| 9 | ₪ 2,829,829 | ₪ 7,907 | ₪ 10,050 | ₪ 17,958 | ₪ 161,620 |
| 10 | ₪ 2,821,894 | ₪ 7,935 | ₪ 10,022 | ₪ 17,958 | ₪ 179,578 |
| 11 | ₪ 2,813,930 | ₪ 7,964 | ₪ 9,994 | ₪ 17,958 | ₪ 197,536 |
| 12 | ₪ 2,805,938 | ₪ 7,992 | ₪ 9,966 | ₪ 17,958 | ₪ 215,494 |
| 13 | ₪ 2,797,918 | ₪ 8,020 | ₪ 9,938 | ₪ 17,958 | ₪ 233,451 |
| 14 | ₪ 2,789,870 | ₪ 8,049 | ₪ 9,909 | ₪ 17,958 | ₪ 251,409 |
| 15 | ₪ 2,781,793 | ₪ 8,077 | ₪ 9,881 | ₪ 17,958 | ₪ 269,367 |
| 16 | ₪ 2,773,687 | ₪ 8,106 | ₪ 9,852 | ₪ 17,958 | ₪ 287,325 |
| 17 | ₪ 2,765,553 | ₪ 8,134 | ₪ 9,823 | ₪ 17,958 | ₪ 305,283 |
| 18 | ₪ 2,757,389 | ₪ 8,163 | ₪ 9,795 | ₪ 17,958 | ₪ 323,240 |
| 19 | ₪ 2,749,197 | ₪ 8,192 | ₪ 9,766 | ₪ 17,958 | ₪ 341,198 |
| 20 | ₪ 2,740,976 | ₪ 8,221 | ₪ 9,737 | ₪ 17,958 | ₪ 359,156 |
| 21 | ₪ 2,732,726 | ₪ 8,250 | ₪ 9,708 | ₪ 17,958 | ₪ 377,114 |
| 22 | ₪ 2,724,447 | ₪ 8,279 | ₪ 9,678 | ₪ 17,958 | ₪ 395,072 |
| 23 | ₪ 2,716,138 | ₪ 8,309 | ₪ 9,649 | ₪ 17,958 | ₪ 413,029 |
| 24 | ₪ 2,707,800 | ₪ 8,338 | ₪ 9,620 | ₪ 17,958 | ₪ 430,987 |
| 25 | ₪ 2,699,432 | ₪ 8,368 | ₪ 9,590 | ₪ 17,958 | ₪ 448,945 |
| 26 | ₪ 2,691,035 | ₪ 8,397 | ₪ 9,560 | ₪ 17,958 | ₪ 466,903 |
| 27 | ₪ 2,682,608 | ₪ 8,427 | ₪ 9,531 | ₪ 17,958 | ₪ 484,861 |
| 28 | ₪ 2,674,151 | ₪ 8,457 | ₪ 9,501 | ₪ 17,958 | ₪ 502,818 |
| 29 | ₪ 2,665,664 | ₪ 8,487 | ₪ 9,471 | ₪ 17,958 | ₪ 520,776 |
| 30 | ₪ 2,657,147 | ₪ 8,517 | ₪ 9,441 | ₪ 17,958 | ₪ 538,734 |
| 31 | ₪ 2,648,600 | ₪ 8,547 | ₪ 9,411 | ₪ 17,958 | ₪ 556,692 |
| 32 | ₪ 2,640,023 | ₪ 8,577 | ₪ 9,380 | ₪ 17,958 | ₪ 574,650 |
| 33 | ₪ 2,631,415 | ₪ 8,608 | ₪ 9,350 | ₪ 17,958 | ₪ 592,607 |
| 34 | ₪ 2,622,777 | ₪ 8,638 | ₪ 9,320 | ₪ 17,958 | ₪ 610,565 |
| 35 | ₪ 2,614,108 | ₪ 8,669 | ₪ 9,289 | ₪ 17,958 | ₪ 628,523 |
| 36 | ₪ 2,605,409 | ₪ 8,699 | ₪ 9,258 | ₪ 17,958 | ₪ 646,481 |
| 37 | ₪ 2,596,678 | ₪ 8,730 | ₪ 9,227 | ₪ 17,958 | ₪ 664,439 |
| 38 | ₪ 2,587,917 | ₪ 8,761 | ₪ 9,197 | ₪ 17,958 | ₪ 682,396 |
| 39 | ₪ 2,579,125 | ₪ 8,792 | ₪ 9,166 | ₪ 17,958 | ₪ 700,354 |
| 40 | ₪ 2,570,301 | ₪ 8,823 | ₪ 9,134 | ₪ 17,958 | ₪ 718,312 |
| 41 | ₪ 2,561,447 | ₪ 8,855 | ₪ 9,103 | ₪ 17,958 | ₪ 736,270 |
| 42 | ₪ 2,552,561 | ₪ 8,886 | ₪ 9,072 | ₪ 17,958 | ₪ 754,228 |
| 43 | ₪ 2,543,643 | ₪ 8,917 | ₪ 9,040 | ₪ 17,958 | ₪ 772,185 |
| 44 | ₪ 2,534,694 | ₪ 8,949 | ₪ 9,009 | ₪ 17,958 | ₪ 790,143 |
| 45 | ₪ 2,525,713 | ₪ 8,981 | ₪ 8,977 | ₪ 17,958 | ₪ 808,101 |
| 46 | ₪ 2,516,701 | ₪ 9,013 | ₪ 8,945 | ₪ 17,958 | ₪ 826,059 |
| 47 | ₪ 2,507,656 | ₪ 9,044 | ₪ 8,913 | ₪ 17,958 | ₪ 844,017 |
| 48 | ₪ 2,498,580 | ₪ 9,077 | ₪ 8,881 | ₪ 17,958 | ₪ 861,974 |
| 49 | ₪ 2,489,471 | ₪ 9,109 | ₪ 8,849 | ₪ 17,958 | ₪ 879,932 |
| 50 | ₪ 2,480,330 | ₪ 9,141 | ₪ 8,817 | ₪ 17,958 | ₪ 897,890 |
| 51 | ₪ 2,471,157 | ₪ 9,173 | ₪ 8,785 | ₪ 17,958 | ₪ 915,848 |
| 52 | ₪ 2,461,951 | ₪ 9,206 | ₪ 8,752 | ₪ 17,958 | ₪ 933,806 |
| 53 | ₪ 2,452,713 | ₪ 9,238 | ₪ 8,719 | ₪ 17,958 | ₪ 951,763 |
| 54 | ₪ 2,443,442 | ₪ 9,271 | ₪ 8,687 | ₪ 17,958 | ₪ 969,721 |
| 55 | ₪ 2,434,138 | ₪ 9,304 | ₪ 8,654 | ₪ 17,958 | ₪ 987,679 |
| 56 | ₪ 2,424,801 | ₪ 9,337 | ₪ 8,621 | ₪ 17,958 | ₪ 1,005,637 |
| 57 | ₪ 2,415,431 | ₪ 9,370 | ₪ 8,588 | ₪ 17,958 | ₪ 1,023,595 |
| 58 | ₪ 2,406,028 | ₪ 9,403 | ₪ 8,555 | ₪ 17,958 | ₪ 1,041,552 |
| 59 | ₪ 2,396,591 | ₪ 9,436 | ₪ 8,521 | ₪ 17,958 | ₪ 1,059,510 |
| 60 | ₪ 2,387,121 | ₪ 9,470 | ₪ 8,488 | ₪ 17,958 | ₪ 1,077,468 |
| 61 | ₪ 2,377,618 | ₪ 9,503 | ₪ 8,454 | ₪ 17,958 | ₪ 1,095,426 |
| 62 | ₪ 2,368,081 | ₪ 9,537 | ₪ 8,421 | ₪ 17,958 | ₪ 1,113,384 |
| 63 | ₪ 2,358,510 | ₪ 9,571 | ₪ 8,387 | ₪ 17,958 | ₪ 1,131,341 |
| 64 | ₪ 2,348,905 | ₪ 9,605 | ₪ 8,353 | ₪ 17,958 | ₪ 1,149,299 |
| 65 | ₪ 2,339,267 | ₪ 9,639 | ₪ 8,319 | ₪ 17,958 | ₪ 1,167,257 |
| 66 | ₪ 2,329,594 | ₪ 9,673 | ₪ 8,285 | ₪ 17,958 | ₪ 1,185,215 |
| 67 | ₪ 2,319,887 | ₪ 9,707 | ₪ 8,251 | ₪ 17,958 | ₪ 1,203,173 |
| 68 | ₪ 2,310,145 | ₪ 9,742 | ₪ 8,216 | ₪ 17,958 | ₪ 1,221,130 |
| 69 | ₪ 2,300,369 | ₪ 9,776 | ₪ 8,182 | ₪ 17,958 | ₪ 1,239,088 |
| 70 | ₪ 2,290,558 | ₪ 9,811 | ₪ 8,147 | ₪ 17,958 | ₪ 1,257,046 |
| 71 | ₪ 2,280,713 | ₪ 9,845 | ₪ 8,112 | ₪ 17,958 | ₪ 1,275,004 |
| 72 | ₪ 2,270,833 | ₪ 9,880 | ₪ 8,078 | ₪ 17,958 | ₪ 1,292,962 |
| 73 | ₪ 2,260,917 | ₪ 9,915 | ₪ 8,043 | ₪ 17,958 | ₪ 1,310,919 |
| 74 | ₪ 2,250,967 | ₪ 9,950 | ₪ 8,007 | ₪ 17,958 | ₪ 1,328,877 |
| 75 | ₪ 2,240,981 | ₪ 9,986 | ₪ 7,972 | ₪ 17,958 | ₪ 1,346,835 |
| 76 | ₪ 2,230,960 | ₪ 10,021 | ₪ 7,937 | ₪ 17,958 | ₪ 1,364,793 |
| 77 | ₪ 2,220,904 | ₪ 10,056 | ₪ 7,901 | ₪ 17,958 | ₪ 1,382,751 |
| 78 | ₪ 2,210,812 | ₪ 10,092 | ₪ 7,866 | ₪ 17,958 | ₪ 1,400,708 |
| 79 | ₪ 2,200,684 | ₪ 10,128 | ₪ 7,830 | ₪ 17,958 | ₪ 1,418,666 |
| 80 | ₪ 2,190,520 | ₪ 10,164 | ₪ 7,794 | ₪ 17,958 | ₪ 1,436,624 |
| 81 | ₪ 2,180,321 | ₪ 10,200 | ₪ 7,758 | ₪ 17,958 | ₪ 1,454,582 |
| 82 | ₪ 2,170,085 | ₪ 10,236 | ₪ 7,722 | ₪ 17,958 | ₪ 1,472,540 |
| 83 | ₪ 2,159,813 | ₪ 10,272 | ₪ 7,686 | ₪ 17,958 | ₪ 1,490,497 |
| 84 | ₪ 2,149,504 | ₪ 10,308 | ₪ 7,649 | ₪ 17,958 | ₪ 1,508,455 |
| 85 | ₪ 2,139,159 | ₪ 10,345 | ₪ 7,613 | ₪ 17,958 | ₪ 1,526,413 |
| 86 | ₪ 2,128,778 | ₪ 10,382 | ₪ 7,576 | ₪ 17,958 | ₪ 1,544,371 |
| 87 | ₪ 2,118,359 | ₪ 10,418 | ₪ 7,539 | ₪ 17,958 | ₪ 1,562,329 |
| 88 | ₪ 2,107,904 | ₪ 10,455 | ₪ 7,503 | ₪ 17,958 | ₪ 1,580,286 |
| 89 | ₪ 2,097,412 | ₪ 10,492 | ₪ 7,465 | ₪ 17,958 | ₪ 1,598,244 |
| 90 | ₪ 2,086,882 | ₪ 10,529 | ₪ 7,428 | ₪ 17,958 | ₪ 1,616,202 |
| 91 | ₪ 2,076,315 | ₪ 10,567 | ₪ 7,391 | ₪ 17,958 | ₪ 1,634,160 |
| 92 | ₪ 2,065,711 | ₪ 10,604 | ₪ 7,354 | ₪ 17,958 | ₪ 1,652,118 |
| 93 | ₪ 2,055,070 | ₪ 10,642 | ₪ 7,316 | ₪ 17,958 | ₪ 1,670,075 |
| 94 | ₪ 2,044,390 | ₪ 10,679 | ₪ 7,278 | ₪ 17,958 | ₪ 1,688,033 |
| 95 | ₪ 2,033,673 | ₪ 10,717 | ₪ 7,241 | ₪ 17,958 | ₪ 1,705,991 |
| 96 | ₪ 2,022,918 | ₪ 10,755 | ₪ 7,203 | ₪ 17,958 | ₪ 1,723,949 |
| 97 | ₪ 2,012,124 | ₪ 10,793 | ₪ 7,164 | ₪ 17,958 | ₪ 1,741,907 |
| 98 | ₪ 2,001,293 | ₪ 10,832 | ₪ 7,126 | ₪ 17,958 | ₪ 1,759,864 |
| 99 | ₪ 1,990,423 | ₪ 10,870 | ₪ 7,088 | ₪ 17,958 | ₪ 1,777,822 |
| 100 | ₪ 1,979,515 | ₪ 10,908 | ₪ 7,049 | ₪ 17,958 | ₪ 1,795,780 |
| 101 | ₪ 1,968,568 | ₪ 10,947 | ₪ 7,011 | ₪ 17,958 | ₪ 1,813,738 |
| 102 | ₪ 1,957,582 | ₪ 10,986 | ₪ 6,972 | ₪ 17,958 | ₪ 1,831,696 |
| 103 | ₪ 1,946,557 | ₪ 11,025 | ₪ 6,933 | ₪ 17,958 | ₪ 1,849,653 |
| 104 | ₪ 1,935,493 | ₪ 11,064 | ₪ 6,894 | ₪ 17,958 | ₪ 1,867,611 |
| 105 | ₪ 1,924,390 | ₪ 11,103 | ₪ 6,855 | ₪ 17,958 | ₪ 1,885,569 |
| 106 | ₪ 1,913,248 | ₪ 11,142 | ₪ 6,816 | ₪ 17,958 | ₪ 1,903,527 |
| 107 | ₪ 1,902,066 | ₪ 11,182 | ₪ 6,776 | ₪ 17,958 | ₪ 1,921,485 |
| 108 | ₪ 1,890,845 | ₪ 11,221 | ₪ 6,736 | ₪ 17,958 | ₪ 1,939,442 |
| 109 | ₪ 1,879,584 | ₪ 11,261 | ₪ 6,697 | ₪ 17,958 | ₪ 1,957,400 |
| 110 | ₪ 1,868,283 | ₪ 11,301 | ₪ 6,657 | ₪ 17,958 | ₪ 1,975,358 |
| 111 | ₪ 1,856,942 | ₪ 11,341 | ₪ 6,617 | ₪ 17,958 | ₪ 1,993,316 |
| 112 | ₪ 1,845,561 | ₪ 11,381 | ₪ 6,577 | ₪ 17,958 | ₪ 2,011,274 |
| 113 | ₪ 1,834,140 | ₪ 11,421 | ₪ 6,536 | ₪ 17,958 | ₪ 2,029,231 |
| 114 | ₪ 1,822,678 | ₪ 11,462 | ₪ 6,496 | ₪ 17,958 | ₪ 2,047,189 |
| 115 | ₪ 1,811,175 | ₪ 11,502 | ₪ 6,455 | ₪ 17,958 | ₪ 2,065,147 |
| 116 | ₪ 1,799,632 | ₪ 11,543 | ₪ 6,415 | ₪ 17,958 | ₪ 2,083,105 |
| 117 | ₪ 1,788,048 | ₪ 11,584 | ₪ 6,374 | ₪ 17,958 | ₪ 2,101,063 |
| 118 | ₪ 1,776,423 | ₪ 11,625 | ₪ 6,333 | ₪ 17,958 | ₪ 2,119,020 |
| 119 | ₪ 1,764,756 | ₪ 11,666 | ₪ 6,291 | ₪ 17,958 | ₪ 2,136,978 |
| 120 | ₪ 1,753,049 | ₪ 11,708 | ₪ 6,250 | ₪ 17,958 | ₪ 2,154,936 |
| 121 | ₪ 1,741,300 | ₪ 11,749 | ₪ 6,209 | ₪ 17,958 | ₪ 2,172,894 |
| 122 | ₪ 1,729,509 | ₪ 11,791 | ₪ 6,167 | ₪ 17,958 | ₪ 2,190,852 |
| 123 | ₪ 1,717,677 | ₪ 11,832 | ₪ 6,125 | ₪ 17,958 | ₪ 2,208,809 |
| 124 | ₪ 1,705,802 | ₪ 11,874 | ₪ 6,083 | ₪ 17,958 | ₪ 2,226,767 |
| 125 | ₪ 1,693,886 | ₪ 11,916 | ₪ 6,041 | ₪ 17,958 | ₪ 2,244,725 |
| 126 | ₪ 1,681,927 | ₪ 11,959 | ₪ 5,999 | ₪ 17,958 | ₪ 2,262,683 |
| 127 | ₪ 1,669,926 | ₪ 12,001 | ₪ 5,957 | ₪ 17,958 | ₪ 2,280,641 |
| 128 | ₪ 1,657,883 | ₪ 12,043 | ₪ 5,914 | ₪ 17,958 | ₪ 2,298,598 |
| 129 | ₪ 1,645,797 | ₪ 12,086 | ₪ 5,872 | ₪ 17,958 | ₪ 2,316,556 |
| 130 | ₪ 1,633,668 | ₪ 12,129 | ₪ 5,829 | ₪ 17,958 | ₪ 2,334,514 |
| 131 | ₪ 1,621,496 | ₪ 12,172 | ₪ 5,786 | ₪ 17,958 | ₪ 2,352,472 |
| 132 | ₪ 1,609,281 | ₪ 12,215 | ₪ 5,743 | ₪ 17,958 | ₪ 2,370,430 |
| 133 | ₪ 1,597,022 | ₪ 12,258 | ₪ 5,700 | ₪ 17,958 | ₪ 2,388,387 |
| 134 | ₪ 1,584,721 | ₪ 12,302 | ₪ 5,656 | ₪ 17,958 | ₪ 2,406,345 |
| 135 | ₪ 1,572,376 | ₪ 12,345 | ₪ 5,613 | ₪ 17,958 | ₪ 2,424,303 |
| 136 | ₪ 1,559,987 | ₪ 12,389 | ₪ 5,569 | ₪ 17,958 | ₪ 2,442,261 |
| 137 | ₪ 1,547,554 | ₪ 12,433 | ₪ 5,525 | ₪ 17,958 | ₪ 2,460,219 |
| 138 | ₪ 1,535,077 | ₪ 12,477 | ₪ 5,481 | ₪ 17,958 | ₪ 2,478,176 |
| 139 | ₪ 1,522,556 | ₪ 12,521 | ₪ 5,437 | ₪ 17,958 | ₪ 2,496,134 |
| 140 | ₪ 1,509,990 | ₪ 12,565 | ₪ 5,392 | ₪ 17,958 | ₪ 2,514,092 |
| 141 | ₪ 1,497,380 | ₪ 12,610 | ₪ 5,348 | ₪ 17,958 | ₪ 2,532,050 |
| 142 | ₪ 1,484,726 | ₪ 12,655 | ₪ 5,303 | ₪ 17,958 | ₪ 2,550,008 |
| 143 | ₪ 1,472,027 | ₪ 12,699 | ₪ 5,258 | ₪ 17,958 | ₪ 2,567,965 |
| 144 | ₪ 1,459,282 | ₪ 12,744 | ₪ 5,213 | ₪ 17,958 | ₪ 2,585,923 |
| 145 | ₪ 1,446,493 | ₪ 12,790 | ₪ 5,168 | ₪ 17,958 | ₪ 2,603,881 |
| 146 | ₪ 1,433,658 | ₪ 12,835 | ₪ 5,123 | ₪ 17,958 | ₪ 2,621,839 |
| 147 | ₪ 1,420,778 | ₪ 12,880 | ₪ 5,078 | ₪ 17,958 | ₪ 2,639,797 |
| 148 | ₪ 1,407,852 | ₪ 12,926 | ₪ 5,032 | ₪ 17,958 | ₪ 2,657,754 |
| 149 | ₪ 1,394,880 | ₪ 12,972 | ₪ 4,986 | ₪ 17,958 | ₪ 2,675,712 |
| 150 | ₪ 1,381,862 | ₪ 13,018 | ₪ 4,940 | ₪ 17,958 | ₪ 2,693,670 |
| 151 | ₪ 1,368,799 | ₪ 13,064 | ₪ 4,894 | ₪ 17,958 | ₪ 2,711,628 |
| 152 | ₪ 1,355,689 | ₪ 13,110 | ₪ 4,848 | ₪ 17,958 | ₪ 2,729,586 |
| 153 | ₪ 1,342,532 | ₪ 13,156 | ₪ 4,801 | ₪ 17,958 | ₪ 2,747,543 |
| 154 | ₪ 1,329,329 | ₪ 13,203 | ₪ 4,755 | ₪ 17,958 | ₪ 2,765,501 |
| 155 | ₪ 1,316,080 | ₪ 13,250 | ₪ 4,708 | ₪ 17,958 | ₪ 2,783,459 |
| 156 | ₪ 1,302,783 | ₪ 13,297 | ₪ 4,661 | ₪ 17,958 | ₪ 2,801,417 |
| 157 | ₪ 1,289,439 | ₪ 13,344 | ₪ 4,614 | ₪ 17,958 | ₪ 2,819,375 |
| 158 | ₪ 1,276,048 | ₪ 13,391 | ₪ 4,567 | ₪ 17,958 | ₪ 2,837,332 |
| 159 | ₪ 1,262,610 | ₪ 13,438 | ₪ 4,519 | ₪ 17,958 | ₪ 2,855,290 |
| 160 | ₪ 1,249,124 | ₪ 13,486 | ₪ 4,472 | ₪ 17,958 | ₪ 2,873,248 |
| 161 | ₪ 1,235,590 | ₪ 13,534 | ₪ 4,424 | ₪ 17,958 | ₪ 2,891,206 |
| 162 | ₪ 1,222,008 | ₪ 13,582 | ₪ 4,376 | ₪ 17,958 | ₪ 2,909,164 |
| 163 | ₪ 1,208,378 | ₪ 13,630 | ₪ 4,328 | ₪ 17,958 | ₪ 2,927,121 |
| 164 | ₪ 1,194,700 | ₪ 13,678 | ₪ 4,280 | ₪ 17,958 | ₪ 2,945,079 |
| 165 | ₪ 1,180,973 | ₪ 13,727 | ₪ 4,231 | ₪ 17,958 | ₪ 2,963,037 |
| 166 | ₪ 1,167,198 | ₪ 13,775 | ₪ 4,183 | ₪ 17,958 | ₪ 2,980,995 |
| 167 | ₪ 1,153,374 | ₪ 13,824 | ₪ 4,134 | ₪ 17,958 | ₪ 2,998,953 |
| 168 | ₪ 1,139,501 | ₪ 13,873 | ₪ 4,085 | ₪ 17,958 | ₪ 3,016,910 |
| 169 | ₪ 1,125,579 | ₪ 13,922 | ₪ 4,036 | ₪ 17,958 | ₪ 3,034,868 |
| 170 | ₪ 1,111,608 | ₪ 13,971 | ₪ 3,986 | ₪ 17,958 | ₪ 3,052,826 |
| 171 | ₪ 1,097,587 | ₪ 14,021 | ₪ 3,937 | ₪ 17,958 | ₪ 3,070,784 |
| 172 | ₪ 1,083,517 | ₪ 14,071 | ₪ 3,887 | ₪ 17,958 | ₪ 3,088,742 |
| 173 | ₪ 1,069,396 | ₪ 14,120 | ₪ 3,837 | ₪ 17,958 | ₪ 3,106,699 |
| 174 | ₪ 1,055,226 | ₪ 14,170 | ₪ 3,787 | ₪ 17,958 | ₪ 3,124,657 |
| 175 | ₪ 1,041,005 | ₪ 14,221 | ₪ 3,737 | ₪ 17,958 | ₪ 3,142,615 |
| 176 | ₪ 1,026,734 | ₪ 14,271 | ₪ 3,687 | ₪ 17,958 | ₪ 3,160,573 |
| 177 | ₪ 1,012,413 | ₪ 14,321 | ₪ 3,636 | ₪ 17,958 | ₪ 3,178,531 |
| 178 | ₪ 998,041 | ₪ 14,372 | ₪ 3,586 | ₪ 17,958 | ₪ 3,196,488 |
| 179 | ₪ 983,618 | ₪ 14,423 | ₪ 3,535 | ₪ 17,958 | ₪ 3,214,446 |
| 180 | ₪ 969,144 | ₪ 14,474 | ₪ 3,484 | ₪ 17,958 | ₪ 3,232,404 |
| 181 | ₪ 954,618 | ₪ 14,525 | ₪ 3,432 | ₪ 17,958 | ₪ 3,250,362 |
| 182 | ₪ 940,041 | ₪ 14,577 | ₪ 3,381 | ₪ 17,958 | ₪ 3,268,320 |
| 183 | ₪ 925,413 | ₪ 14,628 | ₪ 3,329 | ₪ 17,958 | ₪ 3,286,277 |
| 184 | ₪ 910,732 | ₪ 14,680 | ₪ 3,278 | ₪ 17,958 | ₪ 3,304,235 |
| 185 | ₪ 896,000 | ₪ 14,732 | ₪ 3,226 | ₪ 17,958 | ₪ 3,322,193 |
| 186 | ₪ 881,216 | ₪ 14,784 | ₪ 3,173 | ₪ 17,958 | ₪ 3,340,151 |
| 187 | ₪ 866,379 | ₪ 14,837 | ₪ 3,121 | ₪ 17,958 | ₪ 3,358,109 |
| 188 | ₪ 851,490 | ₪ 14,889 | ₪ 3,068 | ₪ 17,958 | ₪ 3,376,066 |
| 189 | ₪ 836,547 | ₪ 14,942 | ₪ 3,016 | ₪ 17,958 | ₪ 3,394,024 |
| 190 | ₪ 821,552 | ₪ 14,995 | ₪ 2,963 | ₪ 17,958 | ₪ 3,411,982 |
| 191 | ₪ 806,504 | ₪ 15,048 | ₪ 2,910 | ₪ 17,958 | ₪ 3,429,940 |
| 192 | ₪ 791,403 | ₪ 15,101 | ₪ 2,856 | ₪ 17,958 | ₪ 3,447,898 |
| 193 | ₪ 776,248 | ₪ 15,155 | ₪ 2,803 | ₪ 17,958 | ₪ 3,465,855 |
| 194 | ₪ 761,039 | ₪ 15,209 | ₪ 2,749 | ₪ 17,958 | ₪ 3,483,813 |
| 195 | ₪ 745,777 | ₪ 15,262 | ₪ 2,695 | ₪ 17,958 | ₪ 3,501,771 |
| 196 | ₪ 730,460 | ₪ 15,317 | ₪ 2,641 | ₪ 17,958 | ₪ 3,519,729 |
| 197 | ₪ 715,090 | ₪ 15,371 | ₪ 2,587 | ₪ 17,958 | ₪ 3,537,687 |
| 198 | ₪ 699,664 | ₪ 15,425 | ₪ 2,533 | ₪ 17,958 | ₪ 3,555,644 |
| 199 | ₪ 684,185 | ₪ 15,480 | ₪ 2,478 | ₪ 17,958 | ₪ 3,573,602 |
| 200 | ₪ 668,650 | ₪ 15,535 | ₪ 2,423 | ₪ 17,958 | ₪ 3,591,560 |
| 201 | ₪ 653,060 | ₪ 15,590 | ₪ 2,368 | ₪ 17,958 | ₪ 3,609,518 |
| 202 | ₪ 637,415 | ₪ 15,645 | ₪ 2,313 | ₪ 17,958 | ₪ 3,627,476 |
| 203 | ₪ 621,715 | ₪ 15,700 | ₪ 2,258 | ₪ 17,958 | ₪ 3,645,433 |
| 204 | ₪ 605,959 | ₪ 15,756 | ₪ 2,202 | ₪ 17,958 | ₪ 3,663,391 |
| 205 | ₪ 590,148 | ₪ 15,812 | ₪ 2,146 | ₪ 17,958 | ₪ 3,681,349 |
| 206 | ₪ 574,280 | ₪ 15,868 | ₪ 2,090 | ₪ 17,958 | ₪ 3,699,307 |
| 207 | ₪ 558,356 | ₪ 15,924 | ₪ 2,034 | ₪ 17,958 | ₪ 3,717,265 |
| 208 | ₪ 542,376 | ₪ 15,980 | ₪ 1,978 | ₪ 17,958 | ₪ 3,735,222 |
| 209 | ₪ 526,339 | ₪ 16,037 | ₪ 1,921 | ₪ 17,958 | ₪ 3,753,180 |
| 210 | ₪ 510,245 | ₪ 16,094 | ₪ 1,864 | ₪ 17,958 | ₪ 3,771,138 |
| 211 | ₪ 494,094 | ₪ 16,151 | ₪ 1,807 | ₪ 17,958 | ₪ 3,789,096 |
| 212 | ₪ 477,887 | ₪ 16,208 | ₪ 1,750 | ₪ 17,958 | ₪ 3,807,054 |
| 213 | ₪ 461,621 | ₪ 16,265 | ₪ 1,693 | ₪ 17,958 | ₪ 3,825,011 |
| 214 | ₪ 445,298 | ₪ 16,323 | ₪ 1,635 | ₪ 17,958 | ₪ 3,842,969 |
| 215 | ₪ 428,918 | ₪ 16,381 | ₪ 1,577 | ₪ 17,958 | ₪ 3,860,927 |
| 216 | ₪ 412,479 | ₪ 16,439 | ₪ 1,519 | ₪ 17,958 | ₪ 3,878,885 |
| 217 | ₪ 395,982 | ₪ 16,497 | ₪ 1,461 | ₪ 17,958 | ₪ 3,896,843 |
| 218 | ₪ 379,427 | ₪ 16,555 | ₪ 1,402 | ₪ 17,958 | ₪ 3,914,800 |
| 219 | ₪ 362,813 | ₪ 16,614 | ₪ 1,344 | ₪ 17,958 | ₪ 3,932,758 |
| 220 | ₪ 346,140 | ₪ 16,673 | ₪ 1,285 | ₪ 17,958 | ₪ 3,950,716 |
| 221 | ₪ 329,408 | ₪ 16,732 | ₪ 1,226 | ₪ 17,958 | ₪ 3,968,674 |
| 222 | ₪ 312,617 | ₪ 16,791 | ₪ 1,167 | ₪ 17,958 | ₪ 3,986,632 |
| 223 | ₪ 295,766 | ₪ 16,851 | ₪ 1,107 | ₪ 17,958 | ₪ 4,004,589 |
| 224 | ₪ 278,856 | ₪ 16,910 | ₪ 1,048 | ₪ 17,958 | ₪ 4,022,547 |
| 225 | ₪ 261,886 | ₪ 16,970 | ₪ 988 | ₪ 17,958 | ₪ 4,040,505 |
| 226 | ₪ 244,855 | ₪ 17,030 | ₪ 928 | ₪ 17,958 | ₪ 4,058,463 |
| 227 | ₪ 227,765 | ₪ 17,091 | ₪ 867 | ₪ 17,958 | ₪ 4,076,421 |
| 228 | ₪ 210,614 | ₪ 17,151 | ₪ 807 | ₪ 17,958 | ₪ 4,094,378 |
| 229 | ₪ 193,402 | ₪ 17,212 | ₪ 746 | ₪ 17,958 | ₪ 4,112,336 |
| 230 | ₪ 176,129 | ₪ 17,273 | ₪ 685 | ₪ 17,958 | ₪ 4,130,294 |
| 231 | ₪ 158,795 | ₪ 17,334 | ₪ 624 | ₪ 17,958 | ₪ 4,148,252 |
| 232 | ₪ 141,400 | ₪ 17,395 | ₪ 562 | ₪ 17,958 | ₪ 4,166,210 |
| 233 | ₪ 123,943 | ₪ 17,457 | ₪ 501 | ₪ 17,958 | ₪ 4,184,167 |
| 234 | ₪ 106,424 | ₪ 17,519 | ₪ 439 | ₪ 17,958 | ₪ 4,202,125 |
| 235 | ₪ 88,843 | ₪ 17,581 | ₪ 377 | ₪ 17,958 | ₪ 4,220,083 |
| 236 | ₪ 71,200 | ₪ 17,643 | ₪ 315 | ₪ 17,958 | ₪ 4,238,041 |
| 237 | ₪ 53,494 | ₪ 17,706 | ₪ 252 | ₪ 17,958 | ₪ 4,255,999 |
| 238 | ₪ 35,726 | ₪ 17,768 | ₪ 189 | ₪ 17,958 | ₪ 4,273,956 |
| 239 | ₪ 17,894 | ₪ 17,831 | ₪ 127 | ₪ 17,958 | ₪ 4,291,914 |
| 240 | ₪ 0 | ₪ 17,894 | ₪ 63 | ₪ 17,958 | ₪ 4,309,872 |
| סה"כ | ₪ 2,900,000 | ₪ 1,409,872 | ₪ 4,309,872 | ₪ 4,309,872 |
ראו גם: מה ההחזר על משכנתא של 2,800,000 שח? | מה ההחזר על משכנתא של 3,000,000 שח?