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