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