; EMI & Loan calculator
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

EMI & Loan calculator

VIEWS: 120 PAGES: 10

  • pg 1
									EMI and Loan Calculator
Enter values Insert Loan amount Insert Annual interest rate Inrest Loan period in years Insert Start date of loan Equated Monthly payment (EMI) Number of EMI payments Total interest Total cost of loan 100,000.00 10.000% 20 25-Apr-2008 (Insert in MM/DD/YYYY format) 965 240 131,605 231,605

No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

EMI Payment Date 25-May-2008 25-Jun-2008 25-Jul-2008 25-Aug-2008 25-Sep-2008 25-Oct-2008 25-Nov-2008 25-Dec-2008 25-Jan-2009 25-Feb-2009 25-Mar-2009 25-Apr-2009 25-May-2009 25-Jun-2009 25-Jul-2009 25-Aug-2009 25-Sep-2009 25-Oct-2009 25-Nov-2009 25-Dec-2009 25-Jan-2010 25-Feb-2010 25-Mar-2010 25-Apr-2010 25-May-2010 25-Jun-2010 25-Jul-2010

Beginning Balance 100,000 99,868 99,736 99,602 99,467 99,330 99,193 99,055 98,915 98,775 98,633 98,490 98,345 98,200 98,053 97,905 97,756 97,606 97,454 97,301 97,147 96,991 96,835 96,677 96,517 96,357 96,194

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 132 133 134 135 136 137 138 140 141 142 143 144 145 147 148 149 150 152 153 154 155 157 158 159 161 162 163

Interest 833 832 831 830 829 828 827 825 824 823 822 821 820 818 817 816 815 813 812 811 810 808 807 806 804 803 802

Ending Balance 99,868 99,736 99,602 99,467 99,330 99,193 99,055 98,915 98,775 98,633 98,490 98,345 98,200 98,053 97,905 97,756 97,606 97,454 97,301 97,147 96,991 96,835 96,677 96,517 96,357 96,194 96,031

No. 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69

EMI Payment Date 25-Aug-2010 25-Sep-2010 25-Oct-2010 25-Nov-2010 25-Dec-2010 25-Jan-2011 25-Feb-2011 25-Mar-2011 25-Apr-2011 25-May-2011 25-Jun-2011 25-Jul-2011 25-Aug-2011 25-Sep-2011 25-Oct-2011 25-Nov-2011 25-Dec-2011 25-Jan-2012 25-Feb-2012 25-Mar-2012 25-Apr-2012 25-May-2012 25-Jun-2012 25-Jul-2012 25-Aug-2012 25-Sep-2012 25-Oct-2012 25-Nov-2012 25-Dec-2012 25-Jan-2013 25-Feb-2013 25-Mar-2013 25-Apr-2013 25-May-2013 25-Jun-2013 25-Jul-2013 25-Aug-2013 25-Sep-2013 25-Oct-2013 25-Nov-2013 25-Dec-2013 25-Jan-2014

Beginning Balance 96,031 95,866 95,700 95,533 95,364 95,193 95,022 94,849 94,674 94,498 94,320 94,141 93,961 93,779 93,595 93,410 93,224 93,035 92,846 92,654 92,461 92,267 92,071 91,873 91,674 91,473 91,270 91,065 90,859 90,651 90,442 90,230 90,017 89,802 89,586 89,367 89,147 88,925 88,701 88,475 88,247 88,018

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 165 166 168 169 170 172 173 175 176 178 179 181 182 184 185 187 188 190 191 193 195 196 198 199 201 203 204 206 208 210 211 213 215 217 218 220 222 224 226 228 230 232

Interest 800 799 798 796 795 793 792 790 789 787 786 785 783 781 780 778 777 775 774 772 771 769 767 766 764 762 761 759 757 755 754 752 750 748 747 745 743 741 739 737 735 733

Ending Balance 95,866 95,700 95,533 95,364 95,193 95,022 94,849 94,674 94,498 94,320 94,141 93,961 93,779 93,595 93,410 93,224 93,035 92,846 92,654 92,461 92,267 92,071 91,873 91,674 91,473 91,270 91,065 90,859 90,651 90,442 90,230 90,017 89,802 89,586 89,367 89,147 88,925 88,701 88,475 88,247 88,018 87,786

No. 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111

EMI Payment Date 25-Feb-2014 25-Mar-2014 25-Apr-2014 25-May-2014 25-Jun-2014 25-Jul-2014 25-Aug-2014 25-Sep-2014 25-Oct-2014 25-Nov-2014 25-Dec-2014 25-Jan-2015 25-Feb-2015 25-Mar-2015 25-Apr-2015 25-May-2015 25-Jun-2015 25-Jul-2015 25-Aug-2015 25-Sep-2015 25-Oct-2015 25-Nov-2015 25-Dec-2015 25-Jan-2016 25-Feb-2016 25-Mar-2016 25-Apr-2016 25-May-2016 25-Jun-2016 25-Jul-2016 25-Aug-2016 25-Sep-2016 25-Oct-2016 25-Nov-2016 25-Dec-2016 25-Jan-2017 25-Feb-2017 25-Mar-2017 25-Apr-2017 25-May-2017 25-Jun-2017 25-Jul-2017

Beginning Balance 87,786 87,553 87,317 87,080 86,841 86,599 86,356 86,110 85,863 85,613 85,362 85,108 84,852 84,595 84,334 84,072 83,808 83,541 83,272 83,001 82,728 82,452 82,174 81,894 81,612 81,327 81,039 80,750 80,458 80,163 79,866 79,567 79,265 78,960 78,653 78,343 78,031 77,717 77,399 77,079 76,756 76,431

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 233 235 237 239 241 243 245 247 249 252 254 256 258 260 262 264 267 269 271 273 276 278 280 283 285 287 290 292 295 297 299 302 304 307 310 312 315 317 320 323 325 328

Interest 732 730 728 726 724 722 720 718 716 713 711 709 707 705 703 701 698 696 694 692 689 687 685 682 680 678 675 673 670 668 666 663 661 658 655 653 650 648 645 642 640 637

Ending Balance 87,553 87,317 87,080 86,841 86,599 86,356 86,110 85,863 85,613 85,362 85,108 84,852 84,595 84,334 84,072 83,808 83,541 83,272 83,001 82,728 82,452 82,174 81,894 81,612 81,327 81,039 80,750 80,458 80,163 79,866 79,567 79,265 78,960 78,653 78,343 78,031 77,717 77,399 77,079 76,756 76,431 76,103

No. 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153

EMI Payment Date 25-Aug-2017 25-Sep-2017 25-Oct-2017 25-Nov-2017 25-Dec-2017 25-Jan-2018 25-Feb-2018 25-Mar-2018 25-Apr-2018 25-May-2018 25-Jun-2018 25-Jul-2018 25-Aug-2018 25-Sep-2018 25-Oct-2018 25-Nov-2018 25-Dec-2018 25-Jan-2019 25-Feb-2019 25-Mar-2019 25-Apr-2019 25-May-2019 25-Jun-2019 25-Jul-2019 25-Aug-2019 25-Sep-2019 25-Oct-2019 25-Nov-2019 25-Dec-2019 25-Jan-2020 25-Feb-2020 25-Mar-2020 25-Apr-2020 25-May-2020 25-Jun-2020 25-Jul-2020 25-Aug-2020 25-Sep-2020 25-Oct-2020 25-Nov-2020 25-Dec-2020 25-Jan-2021

Beginning Balance 76,103 75,772 75,439 75,102 74,763 74,421 74,076 73,728 73,378 73,024 72,668 72,308 71,946 71,580 71,212 70,840 70,466 70,088 69,707 69,323 68,935 68,545 68,151 67,754 67,354 66,950 66,543 66,132 65,718 65,301 64,880 64,456 64,028 63,596 63,161 62,723 62,280 61,834 61,385 60,931 60,474 60,013

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 331 334 336 339 342 345 348 351 354 356 359 362 365 369 372 375 378 381 384 387 391 394 397 400 404 407 410 414 417 421 424 428 431 435 439 442 446 450 453 457 461 465

Interest 634 631 629 626 623 620 617 614 611 609 606 603 600 597 593 590 587 584 581 578 574 571 568 565 561 558 555 551 548 544 541 537 534 530 526 523 519 515 512 508 504 500

Ending Balance 75,772 75,439 75,102 74,763 74,421 74,076 73,728 73,378 73,024 72,668 72,308 71,946 71,580 71,212 70,840 70,466 70,088 69,707 69,323 68,935 68,545 68,151 67,754 67,354 66,950 66,543 66,132 65,718 65,301 64,880 64,456 64,028 63,596 63,161 62,723 62,280 61,834 61,385 60,931 60,474 60,013 59,548

No. 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195

EMI Payment Date 25-Feb-2021 25-Mar-2021 25-Apr-2021 25-May-2021 25-Jun-2021 25-Jul-2021 25-Aug-2021 25-Sep-2021 25-Oct-2021 25-Nov-2021 25-Dec-2021 25-Jan-2022 25-Feb-2022 25-Mar-2022 25-Apr-2022 25-May-2022 25-Jun-2022 25-Jul-2022 25-Aug-2022 25-Sep-2022 25-Oct-2022 25-Nov-2022 25-Dec-2022 25-Jan-2023 25-Feb-2023 25-Mar-2023 25-Apr-2023 25-May-2023 25-Jun-2023 25-Jul-2023 25-Aug-2023 25-Sep-2023 25-Oct-2023 25-Nov-2023 25-Dec-2023 25-Jan-2024 25-Feb-2024 25-Mar-2024 25-Apr-2024 25-May-2024 25-Jun-2024 25-Jul-2024

Beginning Balance 59,548 59,079 58,606 58,130 57,649 57,164 56,676 56,183 55,686 55,185 54,680 54,171 53,657 53,139 52,617 52,091 51,560 51,024 50,484 49,940 49,391 48,838 48,280 47,717 47,150 46,578 46,001 45,419 44,833 44,241 43,645 43,043 42,437 41,826 41,209 40,588 39,961 39,329 38,692 38,049 37,401 36,748

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 469 473 477 481 485 489 493 497 501 505 509 514 518 522 527 531 535 540 544 549 553 558 563 567 572 577 582 587 591 596 601 606 611 616 622 627 632 637 643 648 653 659

Interest 496 492 488 484 480 476 472 468 464 460 456 451 447 443 438 434 430 425 421 416 412 407 402 398 393 388 383 378 374 369 364 359 354 349 343 338 333 328 322 317 312 306

Ending Balance 59,079 58,606 58,130 57,649 57,164 56,676 56,183 55,686 55,185 54,680 54,171 53,657 53,139 52,617 52,091 51,560 51,024 50,484 49,940 49,391 48,838 48,280 47,717 47,150 46,578 46,001 45,419 44,833 44,241 43,645 43,043 42,437 41,826 41,209 40,588 39,961 39,329 38,692 38,049 37,401 36,748 36,089

No. 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237

EMI Payment Date 25-Aug-2024 25-Sep-2024 25-Oct-2024 25-Nov-2024 25-Dec-2024 25-Jan-2025 25-Feb-2025 25-Mar-2025 25-Apr-2025 25-May-2025 25-Jun-2025 25-Jul-2025 25-Aug-2025 25-Sep-2025 25-Oct-2025 25-Nov-2025 25-Dec-2025 25-Jan-2026 25-Feb-2026 25-Mar-2026 25-Apr-2026 25-May-2026 25-Jun-2026 25-Jul-2026 25-Aug-2026 25-Sep-2026 25-Oct-2026 25-Nov-2026 25-Dec-2026 25-Jan-2027 25-Feb-2027 25-Mar-2027 25-Apr-2027 25-May-2027 25-Jun-2027 25-Jul-2027 25-Aug-2027 25-Sep-2027 25-Oct-2027 25-Nov-2027 25-Dec-2027 25-Jan-2028

Beginning Balance 36,089 35,425 34,755 34,079 33,398 32,712 32,019 31,321 30,617 29,907 29,191 28,470 27,742 27,008 26,268 25,522 24,770 24,011 23,246 22,475 21,697 20,913 20,122 19,325 18,521 17,710 16,893 16,068 15,237 14,399 13,554 12,702 11,843 10,977 10,103 9,222 8,334 7,439 6,535 5,625 4,707 3,781

EMI 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965 965

Principal 664 670 675 681 687 692 698 704 710 716 722 728 734 740 746 752 759 765 771 778 784 791 797 804 811 817 824 831 838 845 852 859 866 874 881 888 896 903 911 918 926 934

Interest 301 295 290 284 278 273 267 261 255 249 243 237 231 225 219 213 206 200 194 187 181 174 168 161 154 148 141 134 127 120 113 106 99 91 84 77 69 62 54 47 39 32

Ending Balance 35,425 34,755 34,079 33,398 32,712 32,019 31,321 30,617 29,907 29,191 28,470 27,742 27,008 26,268 25,522 24,770 24,011 23,246 22,475 21,697 20,913 20,122 19,325 18,521 17,710 16,893 16,068 15,237 14,399 13,554 12,702 11,843 10,977 10,103 9,222 8,334 7,439 6,535 5,625 4,707 3,781 2,847

No. 238 239 240

EMI Payment Date 25-Feb-2028 25-Mar-2028 25-Apr-2028

Beginning Balance 2,847 1,906 957

EMI 965 965 965

Principal 941 949 957

Interest 24 16 8

Ending Balance 1,906 957 0

No.

EMI Payment Date

Beginning Balance

EMI

Principal

Interest

Ending Balance

No.

EMI Payment Date

Beginning Balance

EMI

Principal

Interest

Ending Balance

No.

EMI Payment Date

Beginning Balance

EMI

Principal

Interest

Ending Balance


								
To top