14,552 ש"ח
לוח סילוקין בשיטת שפיצר למשכנתא של 2,350,000 ש״ח ל-20 שנה
לוח סילוקין מציג כיצד כל תשלום חודשי מתחלק בין הקרן לריבית, ומהי יתרת הקרן לאחר כל תשלום.
עבור משכנתא של
שני מיליון ושלוש מאות וחמישים אלף שקלים לתקופה של עשרים שנה בריבית של
4.25% לוח הסילוקין בשיטת שפיצר ייראה כך:
איך עובד לוח שפיצר? ההחזר החודשי הכולל אמור להישאר קבוע לאורך כל התקופה. מה שמשתנה הוא החלוקה בין הקרן לריבית: בתחילה חלק גדול יותר מהתשלום הוא ריבית, ובהמשך חלק גדול יותר הוא החזר הקרן.
הבהרה: הלוח מניח ריבית שנתית קבועה שאינה צמודה. התשלום החודשי קבוע, בעוד החלוקה בין קרן לריבית משתנה לאורך התקופה. הוא אינו כולל הצמדה, שינויי ריבית, עמלות, ביטוחים או עלויות נוספות.
14,552 ש"ח
1,142,482 ש"ח
3,492,482 ש"ח
שפיצר מול קרן שווה: איך יתרת החוב יורדת?
הגרף משווה את שתי שיטות הסילוקין באותו סכום, באותה ריבית ולאותה תקופה, כדי לראות כמה חוב נשאר בכל שלב.
איך קוראים את הגרף? הציר האופקי מציג את הזמן שחלף מתחילת המשכנתא, והציר האנכי מציג את יתרת החוב לבנק. הקו הכחול הוא שפיצר והקו הירוק הוא קרן שווה. בקרן שווה החוב יורד בקצב קבוע יותר; בשפיצר הוא יורד לאט יותר בתחילה ומהר יותר בהמשך.
הסכומים בטבלה מעוגלים לשקל הקרוב כדי להקל על הקריאה. הסיכום שמעליה מציג את הערכים המדויקים.
| תקופהחודש | יתרה בסוף החודש | החזר לקרן | החזר ריבית | החזר חודשי | מצטבר |
|---|---|---|---|---|---|
| 1 | ₪ 2,343,771 | ₪ 6,229 | ₪ 8,323 | ₪ 14,552 | ₪ 14,552 |
| 2 | ₪ 2,337,520 | ₪ 6,251 | ₪ 8,301 | ₪ 14,552 | ₪ 29,104 |
| 3 | ₪ 2,331,246 | ₪ 6,273 | ₪ 8,279 | ₪ 14,552 | ₪ 43,656 |
| 4 | ₪ 2,324,951 | ₪ 6,296 | ₪ 8,256 | ₪ 14,552 | ₪ 58,208 |
| 5 | ₪ 2,318,633 | ₪ 6,318 | ₪ 8,234 | ₪ 14,552 | ₪ 72,760 |
| 6 | ₪ 2,312,293 | ₪ 6,340 | ₪ 8,212 | ₪ 14,552 | ₪ 87,312 |
| 7 | ₪ 2,305,930 | ₪ 6,363 | ₪ 8,189 | ₪ 14,552 | ₪ 101,864 |
| 8 | ₪ 2,299,545 | ₪ 6,385 | ₪ 8,167 | ₪ 14,552 | ₪ 116,416 |
| 9 | ₪ 2,293,137 | ₪ 6,408 | ₪ 8,144 | ₪ 14,552 | ₪ 130,968 |
| 10 | ₪ 2,286,707 | ₪ 6,430 | ₪ 8,122 | ₪ 14,552 | ₪ 145,520 |
| 11 | ₪ 2,280,254 | ₪ 6,453 | ₪ 8,099 | ₪ 14,552 | ₪ 160,072 |
| 12 | ₪ 2,273,778 | ₪ 6,476 | ₪ 8,076 | ₪ 14,552 | ₪ 174,624 |
| 13 | ₪ 2,267,278 | ₪ 6,499 | ₪ 8,053 | ₪ 14,552 | ₪ 189,176 |
| 14 | ₪ 2,260,756 | ₪ 6,522 | ₪ 8,030 | ₪ 14,552 | ₪ 203,728 |
| 15 | ₪ 2,254,211 | ₪ 6,545 | ₪ 8,007 | ₪ 14,552 | ₪ 218,280 |
| 16 | ₪ 2,247,643 | ₪ 6,568 | ₪ 7,984 | ₪ 14,552 | ₪ 232,832 |
| 17 | ₪ 2,241,051 | ₪ 6,592 | ₪ 7,960 | ₪ 14,552 | ₪ 247,384 |
| 18 | ₪ 2,234,436 | ₪ 6,615 | ₪ 7,937 | ₪ 14,552 | ₪ 261,936 |
| 19 | ₪ 2,227,798 | ₪ 6,638 | ₪ 7,914 | ₪ 14,552 | ₪ 276,488 |
| 20 | ₪ 2,221,136 | ₪ 6,662 | ₪ 7,890 | ₪ 14,552 | ₪ 291,040 |
| 21 | ₪ 2,214,451 | ₪ 6,685 | ₪ 7,867 | ₪ 14,552 | ₪ 305,592 |
| 22 | ₪ 2,207,741 | ₪ 6,709 | ₪ 7,843 | ₪ 14,552 | ₪ 320,144 |
| 23 | ₪ 2,201,008 | ₪ 6,733 | ₪ 7,819 | ₪ 14,552 | ₪ 334,696 |
| 24 | ₪ 2,194,252 | ₪ 6,757 | ₪ 7,795 | ₪ 14,552 | ₪ 349,248 |
| 25 | ₪ 2,187,471 | ₪ 6,781 | ₪ 7,771 | ₪ 14,552 | ₪ 363,800 |
| 26 | ₪ 2,180,666 | ₪ 6,805 | ₪ 7,747 | ₪ 14,552 | ₪ 378,352 |
| 27 | ₪ 2,173,837 | ₪ 6,829 | ₪ 7,723 | ₪ 14,552 | ₪ 392,904 |
| 28 | ₪ 2,166,984 | ₪ 6,853 | ₪ 7,699 | ₪ 14,552 | ₪ 407,456 |
| 29 | ₪ 2,160,107 | ₪ 6,877 | ₪ 7,675 | ₪ 14,552 | ₪ 422,008 |
| 30 | ₪ 2,153,206 | ₪ 6,902 | ₪ 7,650 | ₪ 14,552 | ₪ 436,560 |
| 31 | ₪ 2,146,279 | ₪ 6,926 | ₪ 7,626 | ₪ 14,552 | ₪ 451,112 |
| 32 | ₪ 2,139,329 | ₪ 6,951 | ₪ 7,601 | ₪ 14,552 | ₪ 465,664 |
| 33 | ₪ 2,132,354 | ₪ 6,975 | ₪ 7,577 | ₪ 14,552 | ₪ 480,216 |
| 34 | ₪ 2,125,354 | ₪ 7,000 | ₪ 7,552 | ₪ 14,552 | ₪ 494,768 |
| 35 | ₪ 2,118,329 | ₪ 7,025 | ₪ 7,527 | ₪ 14,552 | ₪ 509,320 |
| 36 | ₪ 2,111,279 | ₪ 7,050 | ₪ 7,502 | ₪ 14,552 | ₪ 523,872 |
| 37 | ₪ 2,104,205 | ₪ 7,075 | ₪ 7,477 | ₪ 14,552 | ₪ 538,424 |
| 38 | ₪ 2,097,105 | ₪ 7,100 | ₪ 7,452 | ₪ 14,552 | ₪ 552,976 |
| 39 | ₪ 2,089,980 | ₪ 7,125 | ₪ 7,427 | ₪ 14,552 | ₪ 567,528 |
| 40 | ₪ 2,082,830 | ₪ 7,150 | ₪ 7,402 | ₪ 14,552 | ₪ 582,080 |
| 41 | ₪ 2,075,655 | ₪ 7,175 | ₪ 7,377 | ₪ 14,552 | ₪ 596,632 |
| 42 | ₪ 2,068,454 | ₪ 7,201 | ₪ 7,351 | ₪ 14,552 | ₪ 611,184 |
| 43 | ₪ 2,061,228 | ₪ 7,226 | ₪ 7,326 | ₪ 14,552 | ₪ 625,736 |
| 44 | ₪ 2,053,976 | ₪ 7,252 | ₪ 7,300 | ₪ 14,552 | ₪ 640,288 |
| 45 | ₪ 2,046,699 | ₪ 7,278 | ₪ 7,274 | ₪ 14,552 | ₪ 654,840 |
| 46 | ₪ 2,039,396 | ₪ 7,303 | ₪ 7,249 | ₪ 14,552 | ₪ 669,392 |
| 47 | ₪ 2,032,066 | ₪ 7,329 | ₪ 7,223 | ₪ 14,552 | ₪ 683,944 |
| 48 | ₪ 2,024,711 | ₪ 7,355 | ₪ 7,197 | ₪ 14,552 | ₪ 698,496 |
| 49 | ₪ 2,017,330 | ₪ 7,381 | ₪ 7,171 | ₪ 14,552 | ₪ 713,048 |
| 50 | ₪ 2,009,923 | ₪ 7,407 | ₪ 7,145 | ₪ 14,552 | ₪ 727,601 |
| 51 | ₪ 2,002,489 | ₪ 7,434 | ₪ 7,118 | ₪ 14,552 | ₪ 742,153 |
| 52 | ₪ 1,995,029 | ₪ 7,460 | ₪ 7,092 | ₪ 14,552 | ₪ 756,705 |
| 53 | ₪ 1,987,543 | ₪ 7,486 | ₪ 7,066 | ₪ 14,552 | ₪ 771,257 |
| 54 | ₪ 1,980,030 | ₪ 7,513 | ₪ 7,039 | ₪ 14,552 | ₪ 785,809 |
| 55 | ₪ 1,972,491 | ₪ 7,539 | ₪ 7,013 | ₪ 14,552 | ₪ 800,361 |
| 56 | ₪ 1,964,925 | ₪ 7,566 | ₪ 6,986 | ₪ 14,552 | ₪ 814,913 |
| 57 | ₪ 1,957,332 | ₪ 7,593 | ₪ 6,959 | ₪ 14,552 | ₪ 829,465 |
| 58 | ₪ 1,949,712 | ₪ 7,620 | ₪ 6,932 | ₪ 14,552 | ₪ 844,017 |
| 59 | ₪ 1,942,065 | ₪ 7,647 | ₪ 6,905 | ₪ 14,552 | ₪ 858,569 |
| 60 | ₪ 1,934,392 | ₪ 7,674 | ₪ 6,878 | ₪ 14,552 | ₪ 873,121 |
| 61 | ₪ 1,926,691 | ₪ 7,701 | ₪ 6,851 | ₪ 14,552 | ₪ 887,673 |
| 62 | ₪ 1,918,962 | ₪ 7,728 | ₪ 6,824 | ₪ 14,552 | ₪ 902,225 |
| 63 | ₪ 1,911,207 | ₪ 7,756 | ₪ 6,796 | ₪ 14,552 | ₪ 916,777 |
| 64 | ₪ 1,903,423 | ₪ 7,783 | ₪ 6,769 | ₪ 14,552 | ₪ 931,329 |
| 65 | ₪ 1,895,613 | ₪ 7,811 | ₪ 6,741 | ₪ 14,552 | ₪ 945,881 |
| 66 | ₪ 1,887,774 | ₪ 7,838 | ₪ 6,714 | ₪ 14,552 | ₪ 960,433 |
| 67 | ₪ 1,879,908 | ₪ 7,866 | ₪ 6,686 | ₪ 14,552 | ₪ 974,985 |
| 68 | ₪ 1,872,014 | ₪ 7,894 | ₪ 6,658 | ₪ 14,552 | ₪ 989,537 |
| 69 | ₪ 1,864,092 | ₪ 7,922 | ₪ 6,630 | ₪ 14,552 | ₪ 1,004,089 |
| 70 | ₪ 1,856,142 | ₪ 7,950 | ₪ 6,602 | ₪ 14,552 | ₪ 1,018,641 |
| 71 | ₪ 1,848,164 | ₪ 7,978 | ₪ 6,574 | ₪ 14,552 | ₪ 1,033,193 |
| 72 | ₪ 1,840,158 | ₪ 8,006 | ₪ 6,546 | ₪ 14,552 | ₪ 1,047,745 |
| 73 | ₪ 1,832,123 | ₪ 8,035 | ₪ 6,517 | ₪ 14,552 | ₪ 1,062,297 |
| 74 | ₪ 1,824,060 | ₪ 8,063 | ₪ 6,489 | ₪ 14,552 | ₪ 1,076,849 |
| 75 | ₪ 1,815,968 | ₪ 8,092 | ₪ 6,460 | ₪ 14,552 | ₪ 1,091,401 |
| 76 | ₪ 1,807,847 | ₪ 8,120 | ₪ 6,432 | ₪ 14,552 | ₪ 1,105,953 |
| 77 | ₪ 1,799,698 | ₪ 8,149 | ₪ 6,403 | ₪ 14,552 | ₪ 1,120,505 |
| 78 | ₪ 1,791,520 | ₪ 8,178 | ₪ 6,374 | ₪ 14,552 | ₪ 1,135,057 |
| 79 | ₪ 1,783,313 | ₪ 8,207 | ₪ 6,345 | ₪ 14,552 | ₪ 1,149,609 |
| 80 | ₪ 1,775,077 | ₪ 8,236 | ₪ 6,316 | ₪ 14,552 | ₪ 1,164,161 |
| 81 | ₪ 1,766,812 | ₪ 8,265 | ₪ 6,287 | ₪ 14,552 | ₪ 1,178,713 |
| 82 | ₪ 1,758,517 | ₪ 8,295 | ₪ 6,257 | ₪ 14,552 | ₪ 1,193,265 |
| 83 | ₪ 1,750,193 | ₪ 8,324 | ₪ 6,228 | ₪ 14,552 | ₪ 1,207,817 |
| 84 | ₪ 1,741,840 | ₪ 8,353 | ₪ 6,199 | ₪ 14,552 | ₪ 1,222,369 |
| 85 | ₪ 1,733,457 | ₪ 8,383 | ₪ 6,169 | ₪ 14,552 | ₪ 1,236,921 |
| 86 | ₪ 1,725,044 | ₪ 8,413 | ₪ 6,139 | ₪ 14,552 | ₪ 1,251,473 |
| 87 | ₪ 1,716,601 | ₪ 8,442 | ₪ 6,110 | ₪ 14,552 | ₪ 1,266,025 |
| 88 | ₪ 1,708,129 | ₪ 8,472 | ₪ 6,080 | ₪ 14,552 | ₪ 1,280,577 |
| 89 | ₪ 1,699,627 | ₪ 8,502 | ₪ 6,050 | ₪ 14,552 | ₪ 1,295,129 |
| 90 | ₪ 1,691,094 | ₪ 8,532 | ₪ 6,020 | ₪ 14,552 | ₪ 1,309,681 |
| 91 | ₪ 1,682,531 | ₪ 8,563 | ₪ 5,989 | ₪ 14,552 | ₪ 1,324,233 |
| 92 | ₪ 1,673,938 | ₪ 8,593 | ₪ 5,959 | ₪ 14,552 | ₪ 1,338,785 |
| 93 | ₪ 1,665,315 | ₪ 8,623 | ₪ 5,929 | ₪ 14,552 | ₪ 1,353,337 |
| 94 | ₪ 1,656,661 | ₪ 8,654 | ₪ 5,898 | ₪ 14,552 | ₪ 1,367,889 |
| 95 | ₪ 1,647,976 | ₪ 8,685 | ₪ 5,867 | ₪ 14,552 | ₪ 1,382,441 |
| 96 | ₪ 1,639,261 | ₪ 8,715 | ₪ 5,837 | ₪ 14,552 | ₪ 1,396,993 |
| 97 | ₪ 1,630,515 | ₪ 8,746 | ₪ 5,806 | ₪ 14,552 | ₪ 1,411,545 |
| 98 | ₪ 1,621,737 | ₪ 8,777 | ₪ 5,775 | ₪ 14,552 | ₪ 1,426,097 |
| 99 | ₪ 1,612,929 | ₪ 8,808 | ₪ 5,744 | ₪ 14,552 | ₪ 1,440,649 |
| 100 | ₪ 1,604,089 | ₪ 8,840 | ₪ 5,712 | ₪ 14,552 | ₪ 1,455,201 |
| 101 | ₪ 1,595,219 | ₪ 8,871 | ₪ 5,681 | ₪ 14,552 | ₪ 1,469,753 |
| 102 | ₪ 1,586,316 | ₪ 8,902 | ₪ 5,650 | ₪ 14,552 | ₪ 1,484,305 |
| 103 | ₪ 1,577,382 | ₪ 8,934 | ₪ 5,618 | ₪ 14,552 | ₪ 1,498,857 |
| 104 | ₪ 1,568,417 | ₪ 8,965 | ₪ 5,587 | ₪ 14,552 | ₪ 1,513,409 |
| 105 | ₪ 1,559,420 | ₪ 8,997 | ₪ 5,555 | ₪ 14,552 | ₪ 1,527,961 |
| 106 | ₪ 1,550,391 | ₪ 9,029 | ₪ 5,523 | ₪ 14,552 | ₪ 1,542,513 |
| 107 | ₪ 1,541,330 | ₪ 9,061 | ₪ 5,491 | ₪ 14,552 | ₪ 1,557,065 |
| 108 | ₪ 1,532,237 | ₪ 9,093 | ₪ 5,459 | ₪ 14,552 | ₪ 1,571,617 |
| 109 | ₪ 1,523,111 | ₪ 9,125 | ₪ 5,427 | ₪ 14,552 | ₪ 1,586,169 |
| 110 | ₪ 1,513,954 | ₪ 9,158 | ₪ 5,394 | ₪ 14,552 | ₪ 1,600,721 |
| 111 | ₪ 1,504,763 | ₪ 9,190 | ₪ 5,362 | ₪ 14,552 | ₪ 1,615,273 |
| 112 | ₪ 1,495,541 | ₪ 9,223 | ₪ 5,329 | ₪ 14,552 | ₪ 1,629,825 |
| 113 | ₪ 1,486,286 | ₪ 9,255 | ₪ 5,297 | ₪ 14,552 | ₪ 1,644,377 |
| 114 | ₪ 1,476,997 | ₪ 9,288 | ₪ 5,264 | ₪ 14,552 | ₪ 1,658,929 |
| 115 | ₪ 1,467,676 | ₪ 9,321 | ₪ 5,231 | ₪ 14,552 | ₪ 1,673,481 |
| 116 | ₪ 1,458,322 | ₪ 9,354 | ₪ 5,198 | ₪ 14,552 | ₪ 1,688,033 |
| 117 | ₪ 1,448,935 | ₪ 9,387 | ₪ 5,165 | ₪ 14,552 | ₪ 1,702,585 |
| 118 | ₪ 1,439,515 | ₪ 9,420 | ₪ 5,132 | ₪ 14,552 | ₪ 1,717,137 |
| 119 | ₪ 1,430,061 | ₪ 9,454 | ₪ 5,098 | ₪ 14,552 | ₪ 1,731,689 |
| 120 | ₪ 1,420,574 | ₪ 9,487 | ₪ 5,065 | ₪ 14,552 | ₪ 1,746,241 |
| 121 | ₪ 1,411,053 | ₪ 9,521 | ₪ 5,031 | ₪ 14,552 | ₪ 1,760,793 |
| 122 | ₪ 1,401,499 | ₪ 9,555 | ₪ 4,997 | ₪ 14,552 | ₪ 1,775,345 |
| 123 | ₪ 1,391,910 | ₪ 9,588 | ₪ 4,964 | ₪ 14,552 | ₪ 1,789,897 |
| 124 | ₪ 1,382,288 | ₪ 9,622 | ₪ 4,930 | ₪ 14,552 | ₪ 1,804,449 |
| 125 | ₪ 1,372,632 | ₪ 9,656 | ₪ 4,896 | ₪ 14,552 | ₪ 1,819,001 |
| 126 | ₪ 1,362,941 | ₪ 9,691 | ₪ 4,861 | ₪ 14,552 | ₪ 1,833,553 |
| 127 | ₪ 1,353,216 | ₪ 9,725 | ₪ 4,827 | ₪ 14,552 | ₪ 1,848,105 |
| 128 | ₪ 1,343,457 | ₪ 9,759 | ₪ 4,793 | ₪ 14,552 | ₪ 1,862,657 |
| 129 | ₪ 1,333,663 | ₪ 9,794 | ₪ 4,758 | ₪ 14,552 | ₪ 1,877,209 |
| 130 | ₪ 1,323,834 | ₪ 9,829 | ₪ 4,723 | ₪ 14,552 | ₪ 1,891,761 |
| 131 | ₪ 1,313,971 | ₪ 9,863 | ₪ 4,689 | ₪ 14,552 | ₪ 1,906,313 |
| 132 | ₪ 1,304,072 | ₪ 9,898 | ₪ 4,654 | ₪ 14,552 | ₪ 1,920,865 |
| 133 | ₪ 1,294,139 | ₪ 9,933 | ₪ 4,619 | ₪ 14,552 | ₪ 1,935,417 |
| 134 | ₪ 1,284,170 | ₪ 9,969 | ₪ 4,583 | ₪ 14,552 | ₪ 1,949,969 |
| 135 | ₪ 1,274,166 | ₪ 10,004 | ₪ 4,548 | ₪ 14,552 | ₪ 1,964,521 |
| 136 | ₪ 1,264,127 | ₪ 10,039 | ₪ 4,513 | ₪ 14,552 | ₪ 1,979,073 |
| 137 | ₪ 1,254,052 | ₪ 10,075 | ₪ 4,477 | ₪ 14,552 | ₪ 1,993,625 |
| 138 | ₪ 1,243,942 | ₪ 10,111 | ₪ 4,441 | ₪ 14,552 | ₪ 2,008,177 |
| 139 | ₪ 1,233,795 | ₪ 10,146 | ₪ 4,406 | ₪ 14,552 | ₪ 2,022,729 |
| 140 | ₪ 1,223,613 | ₪ 10,182 | ₪ 4,370 | ₪ 14,552 | ₪ 2,037,281 |
| 141 | ₪ 1,213,395 | ₪ 10,218 | ₪ 4,334 | ₪ 14,552 | ₪ 2,051,833 |
| 142 | ₪ 1,203,140 | ₪ 10,255 | ₪ 4,297 | ₪ 14,552 | ₪ 2,066,385 |
| 143 | ₪ 1,192,849 | ₪ 10,291 | ₪ 4,261 | ₪ 14,552 | ₪ 2,080,937 |
| 144 | ₪ 1,182,522 | ₪ 10,327 | ₪ 4,225 | ₪ 14,552 | ₪ 2,095,489 |
| 145 | ₪ 1,172,158 | ₪ 10,364 | ₪ 4,188 | ₪ 14,552 | ₪ 2,110,041 |
| 146 | ₪ 1,161,757 | ₪ 10,401 | ₪ 4,151 | ₪ 14,552 | ₪ 2,124,593 |
| 147 | ₪ 1,151,320 | ₪ 10,437 | ₪ 4,115 | ₪ 14,552 | ₪ 2,139,145 |
| 148 | ₪ 1,140,845 | ₪ 10,474 | ₪ 4,078 | ₪ 14,552 | ₪ 2,153,697 |
| 149 | ₪ 1,130,334 | ₪ 10,512 | ₪ 4,040 | ₪ 14,552 | ₪ 2,168,249 |
| 150 | ₪ 1,119,785 | ₪ 10,549 | ₪ 4,003 | ₪ 14,552 | ₪ 2,182,802 |
| 151 | ₪ 1,109,199 | ₪ 10,586 | ₪ 3,966 | ₪ 14,552 | ₪ 2,197,354 |
| 152 | ₪ 1,098,575 | ₪ 10,624 | ₪ 3,928 | ₪ 14,552 | ₪ 2,211,906 |
| 153 | ₪ 1,087,914 | ₪ 10,661 | ₪ 3,891 | ₪ 14,552 | ₪ 2,226,458 |
| 154 | ₪ 1,077,215 | ₪ 10,699 | ₪ 3,853 | ₪ 14,552 | ₪ 2,241,010 |
| 155 | ₪ 1,066,478 | ₪ 10,737 | ₪ 3,815 | ₪ 14,552 | ₪ 2,255,562 |
| 156 | ₪ 1,055,703 | ₪ 10,775 | ₪ 3,777 | ₪ 14,552 | ₪ 2,270,114 |
| 157 | ₪ 1,044,890 | ₪ 10,813 | ₪ 3,739 | ₪ 14,552 | ₪ 2,284,666 |
| 158 | ₪ 1,034,039 | ₪ 10,851 | ₪ 3,701 | ₪ 14,552 | ₪ 2,299,218 |
| 159 | ₪ 1,023,149 | ₪ 10,890 | ₪ 3,662 | ₪ 14,552 | ₪ 2,313,770 |
| 160 | ₪ 1,012,221 | ₪ 10,928 | ₪ 3,624 | ₪ 14,552 | ₪ 2,328,322 |
| 161 | ₪ 1,001,254 | ₪ 10,967 | ₪ 3,585 | ₪ 14,552 | ₪ 2,342,874 |
| 162 | ₪ 990,248 | ₪ 11,006 | ₪ 3,546 | ₪ 14,552 | ₪ 2,357,426 |
| 163 | ₪ 979,203 | ₪ 11,045 | ₪ 3,507 | ₪ 14,552 | ₪ 2,371,978 |
| 164 | ₪ 968,119 | ₪ 11,084 | ₪ 3,468 | ₪ 14,552 | ₪ 2,386,530 |
| 165 | ₪ 956,996 | ₪ 11,123 | ₪ 3,429 | ₪ 14,552 | ₪ 2,401,082 |
| 166 | ₪ 945,833 | ₪ 11,163 | ₪ 3,389 | ₪ 14,552 | ₪ 2,415,634 |
| 167 | ₪ 934,631 | ₪ 11,202 | ₪ 3,350 | ₪ 14,552 | ₪ 2,430,186 |
| 168 | ₪ 923,389 | ₪ 11,242 | ₪ 3,310 | ₪ 14,552 | ₪ 2,444,738 |
| 169 | ₪ 912,107 | ₪ 11,282 | ₪ 3,270 | ₪ 14,552 | ₪ 2,459,290 |
| 170 | ₪ 900,786 | ₪ 11,322 | ₪ 3,230 | ₪ 14,552 | ₪ 2,473,842 |
| 171 | ₪ 889,424 | ₪ 11,362 | ₪ 3,190 | ₪ 14,552 | ₪ 2,488,394 |
| 172 | ₪ 878,022 | ₪ 11,402 | ₪ 3,150 | ₪ 14,552 | ₪ 2,502,946 |
| 173 | ₪ 866,580 | ₪ 11,442 | ₪ 3,110 | ₪ 14,552 | ₪ 2,517,498 |
| 174 | ₪ 855,097 | ₪ 11,483 | ₪ 3,069 | ₪ 14,552 | ₪ 2,532,050 |
| 175 | ₪ 843,573 | ₪ 11,524 | ₪ 3,028 | ₪ 14,552 | ₪ 2,546,602 |
| 176 | ₪ 832,009 | ₪ 11,564 | ₪ 2,988 | ₪ 14,552 | ₪ 2,561,154 |
| 177 | ₪ 820,404 | ₪ 11,605 | ₪ 2,947 | ₪ 14,552 | ₪ 2,575,706 |
| 178 | ₪ 808,757 | ₪ 11,646 | ₪ 2,906 | ₪ 14,552 | ₪ 2,590,258 |
| 179 | ₪ 797,070 | ₪ 11,688 | ₪ 2,864 | ₪ 14,552 | ₪ 2,604,810 |
| 180 | ₪ 785,340 | ₪ 11,729 | ₪ 2,823 | ₪ 14,552 | ₪ 2,619,362 |
| 181 | ₪ 773,570 | ₪ 11,771 | ₪ 2,781 | ₪ 14,552 | ₪ 2,633,914 |
| 182 | ₪ 761,758 | ₪ 11,812 | ₪ 2,740 | ₪ 14,552 | ₪ 2,648,466 |
| 183 | ₪ 749,903 | ₪ 11,854 | ₪ 2,698 | ₪ 14,552 | ₪ 2,663,018 |
| 184 | ₪ 738,007 | ₪ 11,896 | ₪ 2,656 | ₪ 14,552 | ₪ 2,677,570 |
| 185 | ₪ 726,069 | ₪ 11,938 | ₪ 2,614 | ₪ 14,552 | ₪ 2,692,122 |
| 186 | ₪ 714,089 | ₪ 11,981 | ₪ 2,571 | ₪ 14,552 | ₪ 2,706,674 |
| 187 | ₪ 702,066 | ₪ 12,023 | ₪ 2,529 | ₪ 14,552 | ₪ 2,721,226 |
| 188 | ₪ 690,000 | ₪ 12,066 | ₪ 2,486 | ₪ 14,552 | ₪ 2,735,778 |
| 189 | ₪ 677,892 | ₪ 12,108 | ₪ 2,444 | ₪ 14,552 | ₪ 2,750,330 |
| 190 | ₪ 665,741 | ₪ 12,151 | ₪ 2,401 | ₪ 14,552 | ₪ 2,764,882 |
| 191 | ₪ 653,547 | ₪ 12,194 | ₪ 2,358 | ₪ 14,552 | ₪ 2,779,434 |
| 192 | ₪ 641,309 | ₪ 12,237 | ₪ 2,315 | ₪ 14,552 | ₪ 2,793,986 |
| 193 | ₪ 629,028 | ₪ 12,281 | ₪ 2,271 | ₪ 14,552 | ₪ 2,808,538 |
| 194 | ₪ 616,704 | ₪ 12,324 | ₪ 2,228 | ₪ 14,552 | ₪ 2,823,090 |
| 195 | ₪ 604,336 | ₪ 12,368 | ₪ 2,184 | ₪ 14,552 | ₪ 2,837,642 |
| 196 | ₪ 591,925 | ₪ 12,412 | ₪ 2,140 | ₪ 14,552 | ₪ 2,852,194 |
| 197 | ₪ 579,469 | ₪ 12,456 | ₪ 2,096 | ₪ 14,552 | ₪ 2,866,746 |
| 198 | ₪ 566,969 | ₪ 12,500 | ₪ 2,052 | ₪ 14,552 | ₪ 2,881,298 |
| 199 | ₪ 554,425 | ₪ 12,544 | ₪ 2,008 | ₪ 14,552 | ₪ 2,895,850 |
| 200 | ₪ 541,837 | ₪ 12,588 | ₪ 1,964 | ₪ 14,552 | ₪ 2,910,402 |
| 201 | ₪ 529,204 | ₪ 12,633 | ₪ 1,919 | ₪ 14,552 | ₪ 2,924,954 |
| 202 | ₪ 516,526 | ₪ 12,678 | ₪ 1,874 | ₪ 14,552 | ₪ 2,939,506 |
| 203 | ₪ 503,804 | ₪ 12,723 | ₪ 1,829 | ₪ 14,552 | ₪ 2,954,058 |
| 204 | ₪ 491,036 | ₪ 12,768 | ₪ 1,784 | ₪ 14,552 | ₪ 2,968,610 |
| 205 | ₪ 478,223 | ₪ 12,813 | ₪ 1,739 | ₪ 14,552 | ₪ 2,983,162 |
| 206 | ₪ 465,365 | ₪ 12,858 | ₪ 1,694 | ₪ 14,552 | ₪ 2,997,714 |
| 207 | ₪ 452,461 | ₪ 12,904 | ₪ 1,648 | ₪ 14,552 | ₪ 3,012,266 |
| 208 | ₪ 439,511 | ₪ 12,950 | ₪ 1,602 | ₪ 14,552 | ₪ 3,026,818 |
| 209 | ₪ 426,516 | ₪ 12,995 | ₪ 1,557 | ₪ 14,552 | ₪ 3,041,370 |
| 210 | ₪ 413,474 | ₪ 13,041 | ₪ 1,511 | ₪ 14,552 | ₪ 3,055,922 |
| 211 | ₪ 400,387 | ₪ 13,088 | ₪ 1,464 | ₪ 14,552 | ₪ 3,070,474 |
| 212 | ₪ 387,253 | ₪ 13,134 | ₪ 1,418 | ₪ 14,552 | ₪ 3,085,026 |
| 213 | ₪ 374,072 | ₪ 13,180 | ₪ 1,372 | ₪ 14,552 | ₪ 3,099,578 |
| 214 | ₪ 360,845 | ₪ 13,227 | ₪ 1,325 | ₪ 14,552 | ₪ 3,114,130 |
| 215 | ₪ 347,571 | ₪ 13,274 | ₪ 1,278 | ₪ 14,552 | ₪ 3,128,682 |
| 216 | ₪ 334,250 | ₪ 13,321 | ₪ 1,231 | ₪ 14,552 | ₪ 3,143,234 |
| 217 | ₪ 320,882 | ₪ 13,368 | ₪ 1,184 | ₪ 14,552 | ₪ 3,157,786 |
| 218 | ₪ 307,466 | ₪ 13,416 | ₪ 1,136 | ₪ 14,552 | ₪ 3,172,338 |
| 219 | ₪ 294,003 | ₪ 13,463 | ₪ 1,089 | ₪ 14,552 | ₪ 3,186,890 |
| 220 | ₪ 280,493 | ₪ 13,511 | ₪ 1,041 | ₪ 14,552 | ₪ 3,201,442 |
| 221 | ₪ 266,934 | ₪ 13,559 | ₪ 993 | ₪ 14,552 | ₪ 3,215,994 |
| 222 | ₪ 253,327 | ₪ 13,607 | ₪ 945 | ₪ 14,552 | ₪ 3,230,546 |
| 223 | ₪ 239,673 | ₪ 13,655 | ₪ 897 | ₪ 14,552 | ₪ 3,245,098 |
| 224 | ₪ 225,969 | ₪ 13,703 | ₪ 849 | ₪ 14,552 | ₪ 3,259,650 |
| 225 | ₪ 212,218 | ₪ 13,752 | ₪ 800 | ₪ 14,552 | ₪ 3,274,202 |
| 226 | ₪ 198,417 | ₪ 13,800 | ₪ 752 | ₪ 14,552 | ₪ 3,288,754 |
| 227 | ₪ 184,568 | ₪ 13,849 | ₪ 703 | ₪ 14,552 | ₪ 3,303,306 |
| 228 | ₪ 170,670 | ₪ 13,898 | ₪ 654 | ₪ 14,552 | ₪ 3,317,858 |
| 229 | ₪ 156,722 | ₪ 13,948 | ₪ 604 | ₪ 14,552 | ₪ 3,332,410 |
| 230 | ₪ 142,725 | ₪ 13,997 | ₪ 555 | ₪ 14,552 | ₪ 3,346,962 |
| 231 | ₪ 128,679 | ₪ 14,047 | ₪ 505 | ₪ 14,552 | ₪ 3,361,514 |
| 232 | ₪ 114,582 | ₪ 14,096 | ₪ 456 | ₪ 14,552 | ₪ 3,376,066 |
| 233 | ₪ 100,436 | ₪ 14,146 | ₪ 406 | ₪ 14,552 | ₪ 3,390,618 |
| 234 | ₪ 86,240 | ₪ 14,196 | ₪ 356 | ₪ 14,552 | ₪ 3,405,170 |
| 235 | ₪ 71,993 | ₪ 14,247 | ₪ 305 | ₪ 14,552 | ₪ 3,419,722 |
| 236 | ₪ 57,696 | ₪ 14,297 | ₪ 255 | ₪ 14,552 | ₪ 3,434,274 |
| 237 | ₪ 43,349 | ₪ 14,348 | ₪ 204 | ₪ 14,552 | ₪ 3,448,826 |
| 238 | ₪ 28,950 | ₪ 14,398 | ₪ 154 | ₪ 14,552 | ₪ 3,463,378 |
| 239 | ₪ 14,501 | ₪ 14,449 | ₪ 103 | ₪ 14,552 | ₪ 3,477,930 |
| 240 | ₪ 0 | ₪ 14,501 | ₪ 51 | ₪ 14,552 | ₪ 3,492,482 |
| סה"כ | ₪ 2,350,000 | ₪ 1,142,482 | ₪ 3,492,482 | ₪ 3,492,482 |
ראו גם: מה ההחזר על משכנתא של 2,250,000 שח? | מה ההחזר על משכנתא של 2,450,000 שח?