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