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