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