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