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