11,765 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 1,900,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
מיליון ותשע מאות אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
11,765 ש"ח
923,709 ש"ח
2,823,709 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 1,894,964 | ₪ 5,036 | ₪ 6,729 | ₪ 11,765 | ₪ 11,765 |
| 2 | ₪ 1,889,910 | ₪ 5,054 | ₪ 6,711 | ₪ 11,765 | ₪ 23,531 |
| 3 | ₪ 1,884,838 | ₪ 5,072 | ₪ 6,693 | ₪ 11,765 | ₪ 35,296 |
| 4 | ₪ 1,879,748 | ₪ 5,090 | ₪ 6,675 | ₪ 11,765 | ₪ 47,062 |
| 5 | ₪ 1,874,640 | ₪ 5,108 | ₪ 6,657 | ₪ 11,765 | ₪ 58,827 |
| 6 | ₪ 1,869,513 | ₪ 5,126 | ₪ 6,639 | ₪ 11,765 | ₪ 70,593 |
| 7 | ₪ 1,864,369 | ₪ 5,144 | ₪ 6,621 | ₪ 11,765 | ₪ 82,358 |
| 8 | ₪ 1,859,207 | ₪ 5,162 | ₪ 6,603 | ₪ 11,765 | ₪ 94,124 |
| 9 | ₪ 1,854,026 | ₪ 5,181 | ₪ 6,585 | ₪ 11,765 | ₪ 105,889 |
| 10 | ₪ 1,848,827 | ₪ 5,199 | ₪ 6,566 | ₪ 11,765 | ₪ 117,655 |
| 11 | ₪ 1,843,609 | ₪ 5,218 | ₪ 6,548 | ₪ 11,765 | ₪ 129,420 |
| 12 | ₪ 1,838,373 | ₪ 5,236 | ₪ 6,529 | ₪ 11,765 | ₪ 141,185 |
| 13 | ₪ 1,833,119 | ₪ 5,255 | ₪ 6,511 | ₪ 11,765 | ₪ 152,951 |
| 14 | ₪ 1,827,846 | ₪ 5,273 | ₪ 6,492 | ₪ 11,765 | ₪ 164,716 |
| 15 | ₪ 1,822,554 | ₪ 5,292 | ₪ 6,474 | ₪ 11,765 | ₪ 176,482 |
| 16 | ₪ 1,817,243 | ₪ 5,311 | ₪ 6,455 | ₪ 11,765 | ₪ 188,247 |
| 17 | ₪ 1,811,914 | ₪ 5,329 | ₪ 6,436 | ₪ 11,765 | ₪ 200,013 |
| 18 | ₪ 1,806,566 | ₪ 5,348 | ₪ 6,417 | ₪ 11,765 | ₪ 211,778 |
| 19 | ₪ 1,801,198 | ₪ 5,367 | ₪ 6,398 | ₪ 11,765 | ₪ 223,544 |
| 20 | ₪ 1,795,812 | ₪ 5,386 | ₪ 6,379 | ₪ 11,765 | ₪ 235,309 |
| 21 | ₪ 1,790,407 | ₪ 5,405 | ₪ 6,360 | ₪ 11,765 | ₪ 247,075 |
| 22 | ₪ 1,784,982 | ₪ 5,424 | ₪ 6,341 | ₪ 11,765 | ₪ 258,840 |
| 23 | ₪ 1,779,539 | ₪ 5,444 | ₪ 6,322 | ₪ 11,765 | ₪ 270,605 |
| 24 | ₪ 1,774,076 | ₪ 5,463 | ₪ 6,303 | ₪ 11,765 | ₪ 282,371 |
| 25 | ₪ 1,768,594 | ₪ 5,482 | ₪ 6,283 | ₪ 11,765 | ₪ 294,136 |
| 26 | ₪ 1,763,092 | ₪ 5,502 | ₪ 6,264 | ₪ 11,765 | ₪ 305,902 |
| 27 | ₪ 1,757,571 | ₪ 5,521 | ₪ 6,244 | ₪ 11,765 | ₪ 317,667 |
| 28 | ₪ 1,752,030 | ₪ 5,541 | ₪ 6,225 | ₪ 11,765 | ₪ 329,433 |
| 29 | ₪ 1,746,470 | ₪ 5,560 | ₪ 6,205 | ₪ 11,765 | ₪ 341,198 |
| 30 | ₪ 1,740,890 | ₪ 5,580 | ₪ 6,185 | ₪ 11,765 | ₪ 352,964 |
| 31 | ₪ 1,735,290 | ₪ 5,600 | ₪ 6,166 | ₪ 11,765 | ₪ 364,729 |
| 32 | ₪ 1,729,670 | ₪ 5,620 | ₪ 6,146 | ₪ 11,765 | ₪ 376,495 |
| 33 | ₪ 1,724,031 | ₪ 5,640 | ₪ 6,126 | ₪ 11,765 | ₪ 388,260 |
| 34 | ₪ 1,718,371 | ₪ 5,660 | ₪ 6,106 | ₪ 11,765 | ₪ 400,025 |
| 35 | ₪ 1,712,692 | ₪ 5,680 | ₪ 6,086 | ₪ 11,765 | ₪ 411,791 |
| 36 | ₪ 1,706,992 | ₪ 5,700 | ₪ 6,066 | ₪ 11,765 | ₪ 423,556 |
| 37 | ₪ 1,701,272 | ₪ 5,720 | ₪ 6,046 | ₪ 11,765 | ₪ 435,322 |
| 38 | ₪ 1,695,532 | ₪ 5,740 | ₪ 6,025 | ₪ 11,765 | ₪ 447,087 |
| 39 | ₪ 1,689,771 | ₪ 5,760 | ₪ 6,005 | ₪ 11,765 | ₪ 458,853 |
| 40 | ₪ 1,683,991 | ₪ 5,781 | ₪ 5,985 | ₪ 11,765 | ₪ 470,618 |
| 41 | ₪ 1,678,189 | ₪ 5,801 | ₪ 5,964 | ₪ 11,765 | ₪ 482,384 |
| 42 | ₪ 1,672,367 | ₪ 5,822 | ₪ 5,944 | ₪ 11,765 | ₪ 494,149 |
| 43 | ₪ 1,666,525 | ₪ 5,842 | ₪ 5,923 | ₪ 11,765 | ₪ 505,915 |
| 44 | ₪ 1,660,662 | ₪ 5,863 | ₪ 5,902 | ₪ 11,765 | ₪ 517,680 |
| 45 | ₪ 1,654,778 | ₪ 5,884 | ₪ 5,882 | ₪ 11,765 | ₪ 529,445 |
| 46 | ₪ 1,648,873 | ₪ 5,905 | ₪ 5,861 | ₪ 11,765 | ₪ 541,211 |
| 47 | ₪ 1,642,947 | ₪ 5,926 | ₪ 5,840 | ₪ 11,765 | ₪ 552,976 |
| 48 | ₪ 1,637,001 | ₪ 5,947 | ₪ 5,819 | ₪ 11,765 | ₪ 564,742 |
| 49 | ₪ 1,631,033 | ₪ 5,968 | ₪ 5,798 | ₪ 11,765 | ₪ 576,507 |
| 50 | ₪ 1,625,044 | ₪ 5,989 | ₪ 5,777 | ₪ 11,765 | ₪ 588,273 |
| 51 | ₪ 1,619,034 | ₪ 6,010 | ₪ 5,755 | ₪ 11,765 | ₪ 600,038 |
| 52 | ₪ 1,613,003 | ₪ 6,031 | ₪ 5,734 | ₪ 11,765 | ₪ 611,804 |
| 53 | ₪ 1,606,950 | ₪ 6,053 | ₪ 5,713 | ₪ 11,765 | ₪ 623,569 |
| 54 | ₪ 1,600,876 | ₪ 6,074 | ₪ 5,691 | ₪ 11,765 | ₪ 635,335 |
| 55 | ₪ 1,594,780 | ₪ 6,096 | ₪ 5,670 | ₪ 11,765 | ₪ 647,100 |
| 56 | ₪ 1,588,663 | ₪ 6,117 | ₪ 5,648 | ₪ 11,765 | ₪ 658,865 |
| 57 | ₪ 1,582,524 | ₪ 6,139 | ₪ 5,627 | ₪ 11,765 | ₪ 670,631 |
| 58 | ₪ 1,576,363 | ₪ 6,161 | ₪ 5,605 | ₪ 11,765 | ₪ 682,396 |
| 59 | ₪ 1,570,181 | ₪ 6,183 | ₪ 5,583 | ₪ 11,765 | ₪ 694,162 |
| 60 | ₪ 1,563,976 | ₪ 6,204 | ₪ 5,561 | ₪ 11,765 | ₪ 705,927 |
| 61 | ₪ 1,557,750 | ₪ 6,226 | ₪ 5,539 | ₪ 11,765 | ₪ 717,693 |
| 62 | ₪ 1,551,501 | ₪ 6,248 | ₪ 5,517 | ₪ 11,765 | ₪ 729,458 |
| 63 | ₪ 1,545,231 | ₪ 6,271 | ₪ 5,495 | ₪ 11,765 | ₪ 741,224 |
| 64 | ₪ 1,538,938 | ₪ 6,293 | ₪ 5,473 | ₪ 11,765 | ₪ 752,989 |
| 65 | ₪ 1,532,623 | ₪ 6,315 | ₪ 5,450 | ₪ 11,765 | ₪ 764,755 |
| 66 | ₪ 1,526,286 | ₪ 6,337 | ₪ 5,428 | ₪ 11,765 | ₪ 776,520 |
| 67 | ₪ 1,519,926 | ₪ 6,360 | ₪ 5,406 | ₪ 11,765 | ₪ 788,285 |
| 68 | ₪ 1,513,543 | ₪ 6,382 | ₪ 5,383 | ₪ 11,765 | ₪ 800,051 |
| 69 | ₪ 1,507,138 | ₪ 6,405 | ₪ 5,360 | ₪ 11,765 | ₪ 811,816 |
| 70 | ₪ 1,500,711 | ₪ 6,428 | ₪ 5,338 | ₪ 11,765 | ₪ 823,582 |
| 71 | ₪ 1,494,260 | ₪ 6,450 | ₪ 5,315 | ₪ 11,765 | ₪ 835,347 |
| 72 | ₪ 1,487,787 | ₪ 6,473 | ₪ 5,292 | ₪ 11,765 | ₪ 847,113 |
| 73 | ₪ 1,481,291 | ₪ 6,496 | ₪ 5,269 | ₪ 11,765 | ₪ 858,878 |
| 74 | ₪ 1,474,772 | ₪ 6,519 | ₪ 5,246 | ₪ 11,765 | ₪ 870,644 |
| 75 | ₪ 1,468,229 | ₪ 6,542 | ₪ 5,223 | ₪ 11,765 | ₪ 882,409 |
| 76 | ₪ 1,461,664 | ₪ 6,565 | ₪ 5,200 | ₪ 11,765 | ₪ 894,175 |
| 77 | ₪ 1,455,075 | ₪ 6,589 | ₪ 5,177 | ₪ 11,765 | ₪ 905,940 |
| 78 | ₪ 1,448,463 | ₪ 6,612 | ₪ 5,153 | ₪ 11,765 | ₪ 917,705 |
| 79 | ₪ 1,441,827 | ₪ 6,635 | ₪ 5,130 | ₪ 11,765 | ₪ 929,471 |
| 80 | ₪ 1,435,168 | ₪ 6,659 | ₪ 5,106 | ₪ 11,765 | ₪ 941,236 |
| 81 | ₪ 1,428,486 | ₪ 6,683 | ₪ 5,083 | ₪ 11,765 | ₪ 953,002 |
| 82 | ₪ 1,421,780 | ₪ 6,706 | ₪ 5,059 | ₪ 11,765 | ₪ 964,767 |
| 83 | ₪ 1,415,050 | ₪ 6,730 | ₪ 5,035 | ₪ 11,765 | ₪ 976,533 |
| 84 | ₪ 1,408,296 | ₪ 6,754 | ₪ 5,012 | ₪ 11,765 | ₪ 988,298 |
| 85 | ₪ 1,401,518 | ₪ 6,778 | ₪ 4,988 | ₪ 11,765 | ₪ 1,000,064 |
| 86 | ₪ 1,394,716 | ₪ 6,802 | ₪ 4,964 | ₪ 11,765 | ₪ 1,011,829 |
| 87 | ₪ 1,387,891 | ₪ 6,826 | ₪ 4,940 | ₪ 11,765 | ₪ 1,023,595 |
| 88 | ₪ 1,381,041 | ₪ 6,850 | ₪ 4,915 | ₪ 11,765 | ₪ 1,035,360 |
| 89 | ₪ 1,374,166 | ₪ 6,874 | ₪ 4,891 | ₪ 11,765 | ₪ 1,047,125 |
| 90 | ₪ 1,367,268 | ₪ 6,899 | ₪ 4,867 | ₪ 11,765 | ₪ 1,058,891 |
| 91 | ₪ 1,360,345 | ₪ 6,923 | ₪ 4,842 | ₪ 11,765 | ₪ 1,070,656 |
| 92 | ₪ 1,353,397 | ₪ 6,948 | ₪ 4,818 | ₪ 11,765 | ₪ 1,082,422 |
| 93 | ₪ 1,346,425 | ₪ 6,972 | ₪ 4,793 | ₪ 11,765 | ₪ 1,094,187 |
| 94 | ₪ 1,339,428 | ₪ 6,997 | ₪ 4,769 | ₪ 11,765 | ₪ 1,105,953 |
| 95 | ₪ 1,332,406 | ₪ 7,022 | ₪ 4,744 | ₪ 11,765 | ₪ 1,117,718 |
| 96 | ₪ 1,325,360 | ₪ 7,047 | ₪ 4,719 | ₪ 11,765 | ₪ 1,129,484 |
| 97 | ₪ 1,318,288 | ₪ 7,071 | ₪ 4,694 | ₪ 11,765 | ₪ 1,141,249 |
| 98 | ₪ 1,311,192 | ₪ 7,097 | ₪ 4,669 | ₪ 11,765 | ₪ 1,153,015 |
| 99 | ₪ 1,304,070 | ₪ 7,122 | ₪ 4,644 | ₪ 11,765 | ₪ 1,164,780 |
| 100 | ₪ 1,296,923 | ₪ 7,147 | ₪ 4,619 | ₪ 11,765 | ₪ 1,176,545 |
| 101 | ₪ 1,289,751 | ₪ 7,172 | ₪ 4,593 | ₪ 11,765 | ₪ 1,188,311 |
| 102 | ₪ 1,282,554 | ₪ 7,198 | ₪ 4,568 | ₪ 11,765 | ₪ 1,200,076 |
| 103 | ₪ 1,275,330 | ₪ 7,223 | ₪ 4,542 | ₪ 11,765 | ₪ 1,211,842 |
| 104 | ₪ 1,268,082 | ₪ 7,249 | ₪ 4,517 | ₪ 11,765 | ₪ 1,223,607 |
| 105 | ₪ 1,260,807 | ₪ 7,274 | ₪ 4,491 | ₪ 11,765 | ₪ 1,235,373 |
| 106 | ₪ 1,253,507 | ₪ 7,300 | ₪ 4,465 | ₪ 11,765 | ₪ 1,247,138 |
| 107 | ₪ 1,246,181 | ₪ 7,326 | ₪ 4,440 | ₪ 11,765 | ₪ 1,258,904 |
| 108 | ₪ 1,238,830 | ₪ 7,352 | ₪ 4,414 | ₪ 11,765 | ₪ 1,270,669 |
| 109 | ₪ 1,231,452 | ₪ 7,378 | ₪ 4,388 | ₪ 11,765 | ₪ 1,282,435 |
| 110 | ₪ 1,224,048 | ₪ 7,404 | ₪ 4,361 | ₪ 11,765 | ₪ 1,294,200 |
| 111 | ₪ 1,216,617 | ₪ 7,430 | ₪ 4,335 | ₪ 11,765 | ₪ 1,305,965 |
| 112 | ₪ 1,209,161 | ₪ 7,457 | ₪ 4,309 | ₪ 11,765 | ₪ 1,317,731 |
| 113 | ₪ 1,201,678 | ₪ 7,483 | ₪ 4,282 | ₪ 11,765 | ₪ 1,329,496 |
| 114 | ₪ 1,194,168 | ₪ 7,510 | ₪ 4,256 | ₪ 11,765 | ₪ 1,341,262 |
| 115 | ₪ 1,186,632 | ₪ 7,536 | ₪ 4,229 | ₪ 11,765 | ₪ 1,353,027 |
| 116 | ₪ 1,179,069 | ₪ 7,563 | ₪ 4,203 | ₪ 11,765 | ₪ 1,364,793 |
| 117 | ₪ 1,171,480 | ₪ 7,590 | ₪ 4,176 | ₪ 11,765 | ₪ 1,376,558 |
| 118 | ₪ 1,163,863 | ₪ 7,616 | ₪ 4,149 | ₪ 11,765 | ₪ 1,388,324 |
| 119 | ₪ 1,156,220 | ₪ 7,643 | ₪ 4,122 | ₪ 11,765 | ₪ 1,400,089 |
| 120 | ₪ 1,148,549 | ₪ 7,671 | ₪ 4,095 | ₪ 11,765 | ₪ 1,411,855 |
| 121 | ₪ 1,140,852 | ₪ 7,698 | ₪ 4,068 | ₪ 11,765 | ₪ 1,423,620 |
| 122 | ₪ 1,133,127 | ₪ 7,725 | ₪ 4,041 | ₪ 11,765 | ₪ 1,435,385 |
| 123 | ₪ 1,125,374 | ₪ 7,752 | ₪ 4,013 | ₪ 11,765 | ₪ 1,447,151 |
| 124 | ₪ 1,117,595 | ₪ 7,780 | ₪ 3,986 | ₪ 11,765 | ₪ 1,458,916 |
| 125 | ₪ 1,109,787 | ₪ 7,807 | ₪ 3,958 | ₪ 11,765 | ₪ 1,470,682 |
| 126 | ₪ 1,101,952 | ₪ 7,835 | ₪ 3,930 | ₪ 11,765 | ₪ 1,482,447 |
| 127 | ₪ 1,094,090 | ₪ 7,863 | ₪ 3,903 | ₪ 11,765 | ₪ 1,494,213 |
| 128 | ₪ 1,086,199 | ₪ 7,891 | ₪ 3,875 | ₪ 11,765 | ₪ 1,505,978 |
| 129 | ₪ 1,078,281 | ₪ 7,919 | ₪ 3,847 | ₪ 11,765 | ₪ 1,517,744 |
| 130 | ₪ 1,070,334 | ₪ 7,947 | ₪ 3,819 | ₪ 11,765 | ₪ 1,529,509 |
| 131 | ₪ 1,062,359 | ₪ 7,975 | ₪ 3,791 | ₪ 11,765 | ₪ 1,541,275 |
| 132 | ₪ 1,054,356 | ₪ 8,003 | ₪ 3,763 | ₪ 11,765 | ₪ 1,553,040 |
| 133 | ₪ 1,046,325 | ₪ 8,031 | ₪ 3,734 | ₪ 11,765 | ₪ 1,564,806 |
| 134 | ₪ 1,038,265 | ₪ 8,060 | ₪ 3,706 | ₪ 11,765 | ₪ 1,576,571 |
| 135 | ₪ 1,030,177 | ₪ 8,088 | ₪ 3,677 | ₪ 11,765 | ₪ 1,588,336 |
| 136 | ₪ 1,022,060 | ₪ 8,117 | ₪ 3,649 | ₪ 11,765 | ₪ 1,600,102 |
| 137 | ₪ 1,013,915 | ₪ 8,146 | ₪ 3,620 | ₪ 11,765 | ₪ 1,611,867 |
| 138 | ₪ 1,005,740 | ₪ 8,175 | ₪ 3,591 | ₪ 11,765 | ₪ 1,623,633 |
| 139 | ₪ 997,537 | ₪ 8,203 | ₪ 3,562 | ₪ 11,765 | ₪ 1,635,398 |
| 140 | ₪ 989,304 | ₪ 8,233 | ₪ 3,533 | ₪ 11,765 | ₪ 1,647,164 |
| 141 | ₪ 981,042 | ₪ 8,262 | ₪ 3,504 | ₪ 11,765 | ₪ 1,658,929 |
| 142 | ₪ 972,751 | ₪ 8,291 | ₪ 3,475 | ₪ 11,765 | ₪ 1,670,695 |
| 143 | ₪ 964,431 | ₪ 8,320 | ₪ 3,445 | ₪ 11,765 | ₪ 1,682,460 |
| 144 | ₪ 956,081 | ₪ 8,350 | ₪ 3,416 | ₪ 11,765 | ₪ 1,694,226 |
| 145 | ₪ 947,702 | ₪ 8,379 | ₪ 3,386 | ₪ 11,765 | ₪ 1,705,991 |
| 146 | ₪ 939,293 | ₪ 8,409 | ₪ 3,356 | ₪ 11,765 | ₪ 1,717,756 |
| 147 | ₪ 930,854 | ₪ 8,439 | ₪ 3,327 | ₪ 11,765 | ₪ 1,729,522 |
| 148 | ₪ 922,386 | ₪ 8,469 | ₪ 3,297 | ₪ 11,765 | ₪ 1,741,287 |
| 149 | ₪ 913,887 | ₪ 8,499 | ₪ 3,267 | ₪ 11,765 | ₪ 1,753,053 |
| 150 | ₪ 905,358 | ₪ 8,529 | ₪ 3,237 | ₪ 11,765 | ₪ 1,764,818 |
| 151 | ₪ 896,799 | ₪ 8,559 | ₪ 3,206 | ₪ 11,765 | ₪ 1,776,584 |
| 152 | ₪ 888,210 | ₪ 8,589 | ₪ 3,176 | ₪ 11,765 | ₪ 1,788,349 |
| 153 | ₪ 879,590 | ₪ 8,620 | ₪ 3,146 | ₪ 11,765 | ₪ 1,800,115 |
| 154 | ₪ 870,940 | ₪ 8,650 | ₪ 3,115 | ₪ 11,765 | ₪ 1,811,880 |
| 155 | ₪ 862,259 | ₪ 8,681 | ₪ 3,085 | ₪ 11,765 | ₪ 1,823,646 |
| 156 | ₪ 853,547 | ₪ 8,712 | ₪ 3,054 | ₪ 11,765 | ₪ 1,835,411 |
| 157 | ₪ 844,805 | ₪ 8,742 | ₪ 3,023 | ₪ 11,765 | ₪ 1,847,176 |
| 158 | ₪ 836,032 | ₪ 8,773 | ₪ 2,992 | ₪ 11,765 | ₪ 1,858,942 |
| 159 | ₪ 827,227 | ₪ 8,805 | ₪ 2,961 | ₪ 11,765 | ₪ 1,870,707 |
| 160 | ₪ 818,391 | ₪ 8,836 | ₪ 2,930 | ₪ 11,765 | ₪ 1,882,473 |
| 161 | ₪ 809,524 | ₪ 8,867 | ₪ 2,898 | ₪ 11,765 | ₪ 1,894,238 |
| 162 | ₪ 800,626 | ₪ 8,898 | ₪ 2,867 | ₪ 11,765 | ₪ 1,906,004 |
| 163 | ₪ 791,696 | ₪ 8,930 | ₪ 2,836 | ₪ 11,765 | ₪ 1,917,769 |
| 164 | ₪ 782,734 | ₪ 8,962 | ₪ 2,804 | ₪ 11,765 | ₪ 1,929,535 |
| 165 | ₪ 773,741 | ₪ 8,993 | ₪ 2,772 | ₪ 11,765 | ₪ 1,941,300 |
| 166 | ₪ 764,716 | ₪ 9,025 | ₪ 2,740 | ₪ 11,765 | ₪ 1,953,066 |
| 167 | ₪ 755,659 | ₪ 9,057 | ₪ 2,708 | ₪ 11,765 | ₪ 1,964,831 |
| 168 | ₪ 746,570 | ₪ 9,089 | ₪ 2,676 | ₪ 11,765 | ₪ 1,976,596 |
| 169 | ₪ 737,448 | ₪ 9,121 | ₪ 2,644 | ₪ 11,765 | ₪ 1,988,362 |
| 170 | ₪ 728,295 | ₪ 9,154 | ₪ 2,612 | ₪ 11,765 | ₪ 2,000,127 |
| 171 | ₪ 719,109 | ₪ 9,186 | ₪ 2,579 | ₪ 11,765 | ₪ 2,011,893 |
| 172 | ₪ 709,890 | ₪ 9,219 | ₪ 2,547 | ₪ 11,765 | ₪ 2,023,658 |
| 173 | ₪ 700,639 | ₪ 9,251 | ₪ 2,514 | ₪ 11,765 | ₪ 2,035,424 |
| 174 | ₪ 691,355 | ₪ 9,284 | ₪ 2,481 | ₪ 11,765 | ₪ 2,047,189 |
| 175 | ₪ 682,038 | ₪ 9,317 | ₪ 2,449 | ₪ 11,765 | ₪ 2,058,955 |
| 176 | ₪ 672,688 | ₪ 9,350 | ₪ 2,416 | ₪ 11,765 | ₪ 2,070,720 |
| 177 | ₪ 663,305 | ₪ 9,383 | ₪ 2,382 | ₪ 11,765 | ₪ 2,082,486 |
| 178 | ₪ 653,889 | ₪ 9,416 | ₪ 2,349 | ₪ 11,765 | ₪ 2,094,251 |
| 179 | ₪ 644,439 | ₪ 9,450 | ₪ 2,316 | ₪ 11,765 | ₪ 2,106,016 |
| 180 | ₪ 634,956 | ₪ 9,483 | ₪ 2,282 | ₪ 11,765 | ₪ 2,117,782 |
| 181 | ₪ 625,439 | ₪ 9,517 | ₪ 2,249 | ₪ 11,765 | ₪ 2,129,547 |
| 182 | ₪ 615,889 | ₪ 9,550 | ₪ 2,215 | ₪ 11,765 | ₪ 2,141,313 |
| 183 | ₪ 606,305 | ₪ 9,584 | ₪ 2,181 | ₪ 11,765 | ₪ 2,153,078 |
| 184 | ₪ 596,687 | ₪ 9,618 | ₪ 2,147 | ₪ 11,765 | ₪ 2,164,844 |
| 185 | ₪ 587,035 | ₪ 9,652 | ₪ 2,113 | ₪ 11,765 | ₪ 2,176,609 |
| 186 | ₪ 577,348 | ₪ 9,686 | ₪ 2,079 | ₪ 11,765 | ₪ 2,188,375 |
| 187 | ₪ 567,628 | ₪ 9,721 | ₪ 2,045 | ₪ 11,765 | ₪ 2,200,140 |
| 188 | ₪ 557,872 | ₪ 9,755 | ₪ 2,010 | ₪ 11,765 | ₪ 2,211,906 |
| 189 | ₪ 548,083 | ₪ 9,790 | ₪ 1,976 | ₪ 11,765 | ₪ 2,223,671 |
| 190 | ₪ 538,258 | ₪ 9,824 | ₪ 1,941 | ₪ 11,765 | ₪ 2,235,436 |
| 191 | ₪ 528,399 | ₪ 9,859 | ₪ 1,906 | ₪ 11,765 | ₪ 2,247,202 |
| 192 | ₪ 518,505 | ₪ 9,894 | ₪ 1,871 | ₪ 11,765 | ₪ 2,258,967 |
| 193 | ₪ 508,576 | ₪ 9,929 | ₪ 1,836 | ₪ 11,765 | ₪ 2,270,733 |
| 194 | ₪ 498,612 | ₪ 9,964 | ₪ 1,801 | ₪ 11,765 | ₪ 2,282,498 |
| 195 | ₪ 488,612 | ₪ 10,000 | ₪ 1,766 | ₪ 11,765 | ₪ 2,294,264 |
| 196 | ₪ 478,577 | ₪ 10,035 | ₪ 1,731 | ₪ 11,765 | ₪ 2,306,029 |
| 197 | ₪ 468,507 | ₪ 10,070 | ₪ 1,695 | ₪ 11,765 | ₪ 2,317,795 |
| 198 | ₪ 458,401 | ₪ 10,106 | ₪ 1,659 | ₪ 11,765 | ₪ 2,329,560 |
| 199 | ₪ 448,259 | ₪ 10,142 | ₪ 1,624 | ₪ 11,765 | ₪ 2,341,326 |
| 200 | ₪ 438,081 | ₪ 10,178 | ₪ 1,588 | ₪ 11,765 | ₪ 2,353,091 |
| 201 | ₪ 427,867 | ₪ 10,214 | ₪ 1,552 | ₪ 11,765 | ₪ 2,364,856 |
| 202 | ₪ 417,617 | ₪ 10,250 | ₪ 1,515 | ₪ 11,765 | ₪ 2,376,622 |
| 203 | ₪ 407,331 | ₪ 10,286 | ₪ 1,479 | ₪ 11,765 | ₪ 2,388,387 |
| 204 | ₪ 397,008 | ₪ 10,323 | ₪ 1,443 | ₪ 11,765 | ₪ 2,400,153 |
| 205 | ₪ 386,648 | ₪ 10,359 | ₪ 1,406 | ₪ 11,765 | ₪ 2,411,918 |
| 206 | ₪ 376,252 | ₪ 10,396 | ₪ 1,369 | ₪ 11,765 | ₪ 2,423,684 |
| 207 | ₪ 365,819 | ₪ 10,433 | ₪ 1,333 | ₪ 11,765 | ₪ 2,435,449 |
| 208 | ₪ 355,350 | ₪ 10,470 | ₪ 1,296 | ₪ 11,765 | ₪ 2,447,215 |
| 209 | ₪ 344,843 | ₪ 10,507 | ₪ 1,259 | ₪ 11,765 | ₪ 2,458,980 |
| 210 | ₪ 334,299 | ₪ 10,544 | ₪ 1,221 | ₪ 11,765 | ₪ 2,470,746 |
| 211 | ₪ 323,717 | ₪ 10,581 | ₪ 1,184 | ₪ 11,765 | ₪ 2,482,511 |
| 212 | ₪ 313,098 | ₪ 10,619 | ₪ 1,146 | ₪ 11,765 | ₪ 2,494,276 |
| 213 | ₪ 302,442 | ₪ 10,657 | ₪ 1,109 | ₪ 11,765 | ₪ 2,506,042 |
| 214 | ₪ 291,747 | ₪ 10,694 | ₪ 1,071 | ₪ 11,765 | ₪ 2,517,807 |
| 215 | ₪ 281,015 | ₪ 10,732 | ₪ 1,033 | ₪ 11,765 | ₪ 2,529,573 |
| 216 | ₪ 270,245 | ₪ 10,770 | ₪ 995 | ₪ 11,765 | ₪ 2,541,338 |
| 217 | ₪ 259,436 | ₪ 10,808 | ₪ 957 | ₪ 11,765 | ₪ 2,553,104 |
| 218 | ₪ 248,590 | ₪ 10,847 | ₪ 919 | ₪ 11,765 | ₪ 2,564,869 |
| 219 | ₪ 237,705 | ₪ 10,885 | ₪ 880 | ₪ 11,765 | ₪ 2,576,635 |
| 220 | ₪ 226,781 | ₪ 10,924 | ₪ 842 | ₪ 11,765 | ₪ 2,588,400 |
| 221 | ₪ 215,819 | ₪ 10,962 | ₪ 803 | ₪ 11,765 | ₪ 2,600,166 |
| 222 | ₪ 204,818 | ₪ 11,001 | ₪ 764 | ₪ 11,765 | ₪ 2,611,931 |
| 223 | ₪ 193,778 | ₪ 11,040 | ₪ 725 | ₪ 11,765 | ₪ 2,623,696 |
| 224 | ₪ 182,699 | ₪ 11,079 | ₪ 686 | ₪ 11,765 | ₪ 2,635,462 |
| 225 | ₪ 171,580 | ₪ 11,118 | ₪ 647 | ₪ 11,765 | ₪ 2,647,227 |
| 226 | ₪ 160,423 | ₪ 11,158 | ₪ 608 | ₪ 11,765 | ₪ 2,658,993 |
| 227 | ₪ 149,225 | ₪ 11,197 | ₪ 568 | ₪ 11,765 | ₪ 2,670,758 |
| 228 | ₪ 137,988 | ₪ 11,237 | ₪ 529 | ₪ 11,765 | ₪ 2,682,524 |
| 229 | ₪ 126,712 | ₪ 11,277 | ₪ 489 | ₪ 11,765 | ₪ 2,694,289 |
| 230 | ₪ 115,395 | ₪ 11,317 | ₪ 449 | ₪ 11,765 | ₪ 2,706,055 |
| 231 | ₪ 104,038 | ₪ 11,357 | ₪ 409 | ₪ 11,765 | ₪ 2,717,820 |
| 232 | ₪ 92,641 | ₪ 11,397 | ₪ 368 | ₪ 11,765 | ₪ 2,729,586 |
| 233 | ₪ 81,204 | ₪ 11,437 | ₪ 328 | ₪ 11,765 | ₪ 2,741,351 |
| 234 | ₪ 69,726 | ₪ 11,478 | ₪ 288 | ₪ 11,765 | ₪ 2,753,116 |
| 235 | ₪ 58,207 | ₪ 11,519 | ₪ 247 | ₪ 11,765 | ₪ 2,764,882 |
| 236 | ₪ 46,648 | ₪ 11,559 | ₪ 206 | ₪ 11,765 | ₪ 2,776,647 |
| 237 | ₪ 35,048 | ₪ 11,600 | ₪ 165 | ₪ 11,765 | ₪ 2,788,413 |
| 238 | ₪ 23,406 | ₪ 11,641 | ₪ 124 | ₪ 11,765 | ₪ 2,800,178 |
| 239 | ₪ 11,724 | ₪ 11,683 | ₪ 83 | ₪ 11,765 | ₪ 2,811,944 |
| 240 | ₪ 0 | ₪ 11,724 | ₪ 42 | ₪ 11,765 | ₪ 2,823,709 |
| סה"כ | ₪ 1,900,000 | ₪ 923,709 | ₪ 2,823,709 | ₪ 2,823,709 |
ראו גם: מה ההחזר על משכנתא של 1,800,000 שח? | מה ההחזר על משכנתא של 2,000,000 שח?