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