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