Scribd Logo
Upload

Welcome to Scribd!

  • 39 views

    Home Loan Emi Calculator

    Uploaded by

    Prathamesh Karmarkar
    The document provides an amortization schedule for a home loan of Rs. 4,000,000 taken over 10 years at an interest rate of 9.5% per annum. It shows the monthly interest and principal payments, opening and closing balances over the loan term of 240 months. The monthly EMI is Rs. 51,759.02 and the loan is fully paid off by the end of the term with no remaining balance.

    Copyright:

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

    Home Loan Emi Calculator

    Uploaded by

    Prathamesh Karmarkar
    39 views7 pages
    The document provides an amortization schedule for a home loan of Rs. 4,000,000 taken over 10 years at an interest rate of 9.5% per annum. It shows the monthly interest and principal payments, opening and closing balances over the loan term of 240 months. The monthly EMI is Rs. 51,759.02 and the loan is fully paid off by the end of the term with no remaining balance.

    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?

    The document provides an amortization schedule for a home loan of Rs. 4,000,000 taken over 10 years at an interest rate of 9.5% per annum. It shows the monthly interest and principal payments, opening and closing balances over the loan term of 240 months. The monthly EMI is Rs. 51,759.02 and the loan is fully paid off by the end of the term with no remaining balance.

    Copyright:

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

    Home Loan Emi Calculator

    Uploaded by

    Prathamesh Karmarkar
    The document provides an amortization schedule for a home loan of Rs. 4,000,000 taken over 10 years at an interest rate of 9.5% per annum. It shows the monthly interest and principal payments, opening and closing balances over the loan term of 240 months. The monthly EMI is Rs. 51,759.02 and the loan is fully paid off by the end of the term with no remaining balance.

    Copyright:

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

    www.homeloanemi.

    com

    Enter loan amount


    ROI (p.a.)
    Term in years
    EMI (monthly rest)

    4000000 Enter the ammount of loan you are looking for


    9.50% Enter Interest rate
    10 Enter no of years
    51,759.02

    Amortization schedule
    Months
    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
    28
    29
    30
    31
    32

    Opening
    4000000
    3979908
    3959656
    3939244
    3918671
    3897935
    3877035
    3855969
    3834736
    3813335
    3791765
    3770024
    3748111
    3726025
    3703764
    3681326
    3658711
    3635917
    3612942
    3589785
    3566446
    3542921
    3519210
    3495311
    3471224
    3446945
    3422474
    3397810
    3372950
    3347894
    3322639
    3297184

    Interest
    31667
    31508
    31347
    31186
    31023
    30859
    30693
    30526
    30358
    30189
    30018
    29846
    29673
    29498
    29321
    29144
    28965
    28784
    28602
    28419
    28234
    28048
    27860
    27671
    27481
    27288
    27095
    26899
    26703
    26504
    26304
    26103

    Principal
    20092
    20251
    20412
    20573
    20736
    20900
    21066
    21233
    21401
    21570
    21741
    21913
    22086
    22261
    22438
    22615
    22794
    22975
    23157
    23340
    23525
    23711
    23899
    24088
    24279
    24471
    24664
    24860
    25057
    25255
    25455
    25656

    Closing
    3979908
    3959656
    3939244
    3918671
    3897935
    3877035
    3855969
    3834736
    3813335
    3791765
    3770024
    3748111
    3726025
    3703764
    3681326
    3658711
    3635917
    3612942
    3589785
    3566446
    3542921
    3519210
    3495311
    3471224
    3446945
    3422474
    3397810
    3372950
    3347894
    3322639
    3297184
    3271528

    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
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81

    3271528
    3245668
    3219604
    3193334
    3166855
    3140167
    3113268
    3086155
    3058828
    3031285
    3003524
    2975543
    2947340
    2918914
    2890263
    2861385
    2832279
    2802942
    2773373
    2743570
    2713531
    2683254
    2652737
    2621979
    2590978
    2559730
    2528236
    2496492
    2464497
    2432249
    2399745
    2366984
    2333963
    2300682
    2267136
    2233325
    2199247
    2164899
    2130278
    2095384
    2060213
    2024764
    1989035
    1953022
    1916725
    1880140
    1843265
    1806099
    1768638

    25900
    25695
    25489
    25281
    25071
    24860
    24647
    24432
    24216
    23998
    23778
    23556
    23333
    23108
    22881
    22653
    22422
    22190
    21956
    21720
    21482
    21242
    21001
    20757
    20512
    20265
    20015
    19764
    19511
    19255
    18998
    18739
    18477
    18214
    17948
    17680
    17411
    17139
    16865
    16588
    16310
    16029
    15747
    15461
    15174
    14884
    14593
    14298
    14002

    25859
    26064
    26270
    26478
    26688
    26899
    27112
    27327
    27543
    27761
    27981
    28203
    28426
    28651
    28878
    29106
    29337
    29569
    29803
    30039
    30277
    30517
    30758
    31002
    31247
    31494
    31744
    31995
    32248
    32504
    32761
    33020
    33282
    33545
    33811
    34079
    34348
    34620
    34894
    35171
    35449
    35730
    36012
    36298
    36585
    36875
    37167
    37461
    37757

    3245668
    3219604
    3193334
    3166855
    3140167
    3113268
    3086155
    3058828
    3031285
    3003524
    2975543
    2947340
    2918914
    2890263
    2861385
    2832279
    2802942
    2773373
    2743570
    2713531
    2683254
    2652737
    2621979
    2590978
    2559730
    2528236
    2496492
    2464497
    2432249
    2399745
    2366984
    2333963
    2300682
    2267136
    2233325
    2199247
    2164899
    2130278
    2095384
    2060213
    2024764
    1989035
    1953022
    1916725
    1880140
    1843265
    1806099
    1768638
    1730881

    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
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130

    1730881
    1692824
    1654467
    1615806
    1576838
    1537563
    1497976
    1458076
    1417860
    1377326
    1336471
    1295292
    1253787
    1211954
    1169790
    1127292
    1084457
    1041283
    997768
    953908
    909700
    865143
    820233
    774968
    729344
    683359
    637010
    590294
    543208
    495749
    447915
    399702
    351107
    302128
    252760
    203002
    152851
    102302
    51352
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    13703
    13402
    13098
    12792
    12483
    12172
    11859
    11543
    11225
    10904
    10580
    10254
    9926
    9595
    9261
    8924
    8585
    8243
    7899
    7552
    7202
    6849
    6494
    6135
    5774
    5410
    5043
    4673
    4300
    3925
    3546
    3164
    2780
    2392
    2001
    1607
    1210
    810
    407
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    38056
    38357
    38661
    38967
    39276
    39587
    39900
    40216
    40534
    40855
    41179
    41505
    41833
    42164
    42498
    42835
    43174
    43516
    43860
    44207
    44557
    44910
    45266
    45624
    45985
    46349
    46716
    47086
    47459
    47834
    48213
    48595
    48979
    49367
    49758
    50152
    50549
    50949
    51352
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    1692824
    1654467
    1615806
    1576838
    1537563
    1497976
    1458076
    1417860
    1377326
    1336471
    1295292
    1253787
    1211954
    1169790
    1127292
    1084457
    1041283
    997768
    953908
    909700
    865143
    820233
    774968
    729344
    683359
    637010
    590294
    543208
    495749
    447915
    399702
    351107
    302128
    252760
    203002
    152851
    102302
    51352
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    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

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    180
    181
    182
    183
    184
    185
    186
    187
    188
    189
    190
    191
    192
    193
    194
    195
    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

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    229
    230
    231
    232
    233
    234
    235
    236
    237
    238
    239
    240

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0

    are looking for

    You might also like