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