Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    EMI Calculator

    Uploaded by

    hossainjahidul102
    EMI Calculator (excel)

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    EMI Calculator

    Uploaded by

    hossainjahidul102
    3 views7 pages
    EMI Calculator (excel)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    EMI Calculator (excel)

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    3 views7 pages

    EMI Calculator

    Uploaded by

    hossainjahidul102
    EMI Calculator (excel)

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 7

    Installment or Repayment Schedule Chart

    (Designed By TechGuruPlus.com)
    Annual Interest Rate % 10 Loan Amount 153380 Installment (Tenor)
    S.No. Instalment Interest Principal Repaid
    1 153,380 3,890 1,278 2,612
    2 150,768 3,890 1,256 2,634
    3 148,134 3,890 1,234 2,656
    4 145,479 3,890 1,212 2,678
    5 142,801 3,890 1,190 2,700
    6 140,101 3,890 1,168 2,723
    7 137,378 3,890 1,145 2,745
    8 134,633 3,890 1,122 2,768
    9 131,865 3,890 1,099 2,791
    10 129,073 3,890 1,076 2,815
    11 126,259 3,890 1,052 2,838
    12 123,421 3,890 1,029 2,862
    13 120,559 3,890 1,005 2,885
    14 117,674 3,890 981 2,909
    15 114,764 3,890 956 2,934
    16 111,831 3,890 932 2,958
    17 108,873 3,890 907 2,983
    18 105,890 3,890 882 3,008
    19 102,882 3,890 857 3,033
    20 99,849 3,890 832 3,058
    21 96,791 3,890 807 3,084
    22 93,708 3,890 781 3,109
    23 90,598 3,890 755 3,135
    24 87,463 3,890 729 3,161
    25 84,302 3,890 703 3,188
    26 81,114 3,890 676 3,214
    27 77,900 3,890 649 3,241
    28 74,659 3,890 622 3,268
    29 71,391 3,890 595 3,295
    30 68,096 3,890 567 3,323
    31 64,774 3,890 540 3,350
    32 61,423 3,890 512 3,378
    33 58,045 3,890 484 3,406
    34 54,639 3,890 455 3,435
    35 51,204 3,890 427 3,463
    36 47,740 3,890 398 3,492
    37 44,248 3,890 369 3,521
    38 40,727 3,890 339 3,551
    39 37,176 3,890 310 3,580
    40 33,596 3,890 280 3,610
    41 29,986 3,890 250 3,640
    42 26,345 3,890 220 3,671
    43 22,675 3,890 189 3,701
    44 18,974 3,890 158 3,732
    45 15,242 3,890 127 3,763
    46 11,479 3,890 96 3,794
    47 7,684 3,890 64 3,826
    48 3,858 3,890 32 3,858
    le Chart
    com)
    48 186,725 Total EMI (Principal + Interest)
    Remaining Principal Amount
    150,768
    148,134
    145,479
    142,801
    140,101
    137,378
    134,633
    131,865
    129,073
    126,259
    123,421
    120,559
    117,674
    114,764
    111,831
    108,873
    105,890
    102,882
    99,849
    96,791
    93,708
    90,598
    87,463
    84,302
    81,114
    77,900
    74,659
    71,391
    68,096
    64,774
    61,423
    58,045
    54,639
    51,204
    47,740
    44,248
    40,727
    37,176
    33,596
    29,986
    26,345
    22,675
    18,974
    15,242
    11,479
    7,684
    3,858
    0

    You might also like