Scribd Logo
Upload

Welcome to Scribd!

  • 51 views

    EMI IRR 7.19%: Principal EMI Principal Interest Cumulative Cumulative Outstndg Component Component Principal Interest

    Uploaded by

    Pradeep Yaddanapudi
    This document outlines the details of a 48-month loan with an amount of Rs. 5,040,000 taken at an interest rate of 21%. It shows the breakdown of principal and interest components of each EMI of Rs. 156,067 over the tenure of the loan. By the end of the 48 months, the borrower would have paid a total interest of Rs. 5,618,416.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    EMI IRR 7.19%: Principal EMI Principal Interest Cumulative Cumulative Outstndg Component Component Principal Interest

    Uploaded by

    Pradeep Yaddanapudi
    51 views5 pages
    This document outlines the details of a 48-month loan with an amount of Rs. 5,040,000 taken at an interest rate of 21%. It shows the breakdown of principal and interest components of each EMI of Rs. 156,067 over the tenure of the loan. By the end of the 48 months, the borrower would have paid a total interest of Rs. 5,618,416.

    Original Title

    Emi Calculator

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the details of a 48-month loan with an amount of Rs. 5,040,000 taken at an interest rate of 21%. It shows the breakdown of principal and interest components of each EMI of Rs. 156,067 over the tenure of the loan. By the end of the 48 months, the borrower would have paid a total interest of Rs. 5,618,416.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    51 views5 pages

    EMI IRR 7.19%: Principal EMI Principal Interest Cumulative Cumulative Outstndg Component Component Principal Interest

    Uploaded by

    Pradeep Yaddanapudi
    This document outlines the details of a 48-month loan with an amount of Rs. 5,040,000 taken at an interest rate of 21%. It shows the breakdown of principal and interest components of each EMI of Rs. 156,067 over the tenure of the loan. By the end of the 48 months, the borrower would have paid a total interest of Rs. 5,618,416.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 5

    Loan amount 5040000

    Tenure 48
    Interest Rate 21.00%
    EMI 156,067

    Mth Principal EMI Principal Interest Cumulative Cumulative IRR


    Outstndg component component Principal Interest 7.19%
    0 -5E+06
    1 5040000 156067 67867 88200 67867 88200 156067
    2 4972133 156067 69055 87012 136922 175212 156067
    3 4903078 156067 70263 85804 207185 261016 156067
    4 4832815 156067 71493 84574 278678 345590 156067
    5 4761322 156067 72744 83323 351422 428914 156067
    6 4688578 156067 74017 82050 425439 510964 156067
    7 4614561 156067 75312 80755 500751 591719 156067
    8 4539249 156067 76630 79437 577381 671155 156067
    9 4462619 156067 77971 78096 655353 749251 156067
    10 4384647 156067 79336 76731 734688 825983 156067
    11 4305312 156067 80724 75343 815413 901325 156067
    12 4224587 156067 82137 73930 897549 975256 156067
    13 4142451 156067 83574 72493 981124 1047749 156067
    14 4058876 156067 85037 71030 1066160 1118779 156067
    15 3973840 156067 86525 69542 1152685 1188321 156067
    16 3887315 156067 88039 68028 1240724 1256349 156067
    17 3799276 156067 89580 66487 1330304 1322837 156067
    18 3709696 156067 91147 64920 1421452 1387756 156067
    19 3618548 156067 92743 63325 1514194 1451081 156067
    20 3525806 156067 94366 61702 1608560 1512782 156067
    21 3431440 156067 96017 60050 1704577 1572833 156067
    22 3335423 156067 97697 58370 1802274 1631202 156067
    23 3237726 156067 99407 56660 1901681 1687863 156067
    24 3138319 156067 101147 54921 2002827 1742783 156067
    25 3037173 156067 102917 53151 2105744 1795934 156067
    26 2934256 156067 104718 51349 2210461 1847283 156067
    27 2829539 156067 106550 49517 2317012 1896800 156067
    28 2722988 156067 108415 47652 2425426 1944453 156067
    29 2614574 156067 110312 45755 2535738 1990208 156067
    30 2504262 156067 112243 43825 2647981 2034032 156067
    31 2392019 156067 114207 41860 2762188 2075892 156067
    32 2277812 156067 116205 39862 2878393 2115754 156067
    33 2161607 156067 118239 37828 2996632 2153582 156067
    34 2043368 156067 120308 35759 3116940 2189341 156067
    35 1923060 156067 122414 33654 3239354 2222995 156067
    36 1800646 156067 124556 31511 3363910 2254506 156067
    5618416
    Note -

    This principal interest break-up presumes exact one month gap between
    each instalment (even the first instalment). However, practically, as we
    have a fixed due date, the period between disbursement and 1st due date
    will not be exactly one month.
    Hence for giving Principal Interest break-up to customers, please do not
    use this schedule. This report is available in Equation Retail module, where
    the exact number of days for 1st EMI is factored.
    7-Feb-04
    7-Mar-04
    7-Apr-04
    7-May-04
    7-Jun-04
    7-Jul-04
    7-Aug-04
    7-Sep-04
    7-Oct-04
    7-Nov-04
    7-Dec-04
    7-Jan-05
    7-Feb-05
    7-Mar-05
    7-Apr-05
    7-May-05
    7-Jun-05
    7-Jul-05
    7-Aug-05
    7-Sep-05
    7-Oct-05
    7-Nov-05
    7-Dec-05
    7-Jan-06
    7-Feb-06
    7-Mar-06
    7-Apr-06
    7-May-06
    7-Jun-06
    7-Jul-06
    7-Aug-06
    7-Sep-06
    7-Oct-06
    7-Nov-06
    7-Dec-06
    7-Jan-07

    You might also like