Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    EMI Chart

    Uploaded by

    Dileep kumar
    The document outlines an equated installments calculator for a Rs. 900,000 loan with 36 installments at 10.5% annual interest. It shows that the equated monthly installment would be Rs. 29,252.20, and charts the opening balance, interest, principal, and closing balance for each installment over the course of the loan. It demonstrates how the interest portion decreases each period as the principal is paid down until the final installment pays off the remaining principal and closes the loan.

    Copyright:

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

    EMI Chart

    Uploaded by

    Dileep kumar
    18 views1 page
    The document outlines an equated installments calculator for a Rs. 900,000 loan with 36 installments at 10.5% annual interest. It shows that the equated monthly installment would be Rs. 29,252.20, and charts the opening balance, interest, principal, and closing balance for each installment over the course of the loan. It demonstrates how the interest portion decreases each period as the principal is paid down until the final installment pays off the remaining principal and closes the loan.

    Original Description:

    EMI chart for Home loan

    Original Title

    EMI Chart (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines an equated installments calculator for a Rs. 900,000 loan with 36 installments at 10.5% annual interest. It shows that the equated monthly installment would be Rs. 29,252.20, and charts the opening balance, interest, principal, and closing balance for each installment over the course of the loan. It demonstrates how the interest portion decreases each period as the principal is paid down until the final installment pays off the remaining principal and closes the loan.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    18 views1 page

    EMI Chart

    Uploaded by

    Dileep kumar
    The document outlines an equated installments calculator for a Rs. 900,000 loan with 36 installments at 10.5% annual interest. It shows that the equated monthly installment would be Rs. 29,252.20, and charts the opening balance, interest, principal, and closing balance for each installment over the course of the loan. It demonstrates how the interest portion decreases each period as the principal is paid down until the final installment pays off the remaining principal and closes the loan.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 1

    Equated Installments Calculator

    Developed by
    Principal 900,000.00 MANIKANDAN S A
    Instalments 36
    moratorium (instalments) 0 Instalments per year
    Instalments per year 12 Annual 1
    Interest pa 10.5 Half yearly 2
    Quarterly 4
    Bi-monthly 6
    Equated Instalment 29,252.20 Monthly 12

    Instalment Opening balance Amt. Payable Interest Principle Closing balance


    1 900,000.00 29,252.20 7,875.00 21,377.20 878,622.80
    2 878,622.80 29,252.20 7,687.95 21,564.25 857,058.55
    3 857,058.55 29,252.20 7,499.26 21,752.94 835,305.61
    4 835,305.61 29,252.20 7,308.92 21,943.28 813,362.34
    5 813,362.34 29,252.20 7,116.92 22,135.28 791,227.06
    6 791,227.06 29,252.20 6,923.24 22,328.96 768,898.10
    7 768,898.10 29,252.20 6,727.86 22,524.34 746,373.76
    8 746,373.76 29,252.20 6,530.77 22,721.43 723,652.33
    9 723,652.33 29,252.20 6,331.96 22,920.24 700,732.09
    10 700,732.09 29,252.20 6,131.41 23,120.79 677,611.29
    11 677,611.29 29,252.20 5,929.10 23,323.10 654,288.19
    12 654,288.19 29,252.20 5,725.02 23,527.18 630,761.02
    13 630,761.02 29,252.20 5,519.16 23,733.04 607,027.98
    14 607,027.98 29,252.20 5,311.49 23,940.70 583,087.27
    15 583,087.27 29,252.20 5,102.01 24,150.19 558,937.09
    16 558,937.09 29,252.20 4,890.70 24,361.50 534,575.59
    17 534,575.59 29,252.20 4,677.54 24,574.66 510,000.92
    18 510,000.92 29,252.20 4,462.51 24,789.69 485,211.23
    19 485,211.23 29,252.20 4,245.60 25,006.60 460,204.63
    20 460,204.63 29,252.20 4,026.79 25,225.41 434,979.22
    21 434,979.22 29,252.20 3,806.07 25,446.13 409,533.09
    22 409,533.09 29,252.20 3,583.41 25,668.78 383,864.31
    23 383,864.31 29,252.20 3,358.81 25,893.39 357,970.92
    24 357,970.92 29,252.20 3,132.25 26,119.95 331,850.97
    25 331,850.97 29,252.20 2,903.70 26,348.50 305,502.46
    26 305,502.46 29,252.20 2,673.15 26,579.05 278,923.41
    27 278,923.41 29,252.20 2,440.58 26,811.62 252,111.79
    28 252,111.79 29,252.20 2,205.98 27,046.22 225,065.57
    29 225,065.57 29,252.20 1,969.32 27,282.88 197,782.70
    30 197,782.70 29,252.20 1,730.60 27,521.60 170,261.10
    31 170,261.10 29,252.20 1,489.78 27,762.41 142,498.68
    32 142,498.68 29,252.20 1,246.86 28,005.34 114,493.35
    33 114,493.35 29,252.20 1,001.82 28,250.38 86,242.96
    34 86,242.96 29,252.20 754.63 28,497.57 57,745.39
    35 57,745.39 29,252.20 505.27 28,746.93 28,998.46
    36 28,998.46 29,252.20 253.74 28,998.46 0.00
    37 0.00 0.00 0.00 0.00 0.00
    38 0.00 0.00 0.00 0.00 0.00
    39 0.00 0.00 0.00 0.00 0.00
    40 0.00 0.00 0.00 0.00 0.00
    41 0.00 0.00 0.00 0.00 0.00
    42 0.00 0.00 0.00 0.00 0.00
    43 0.00 0.00 0.00 0.00 0.00
    44 0.00 0.00 0.00 0.00 0.00
    45 0.00 0.00 0.00 0.00 0.00
    46 0.00 0.00 0.00 0.00 0.00
    47 0.00 0.00 0.00 0.00 0.00
    48 0.00 0.00 0.00 0.00 0.00

    You might also like