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