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