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