I have developed a Microsoft Excel based Home Loan Calculator (Amortization Schedule) and is available for download at Prasanth's Website | . The reason why I am not attaching is that this could be revised based on inputs and / or feedback from Users.
This not only calcultes the EMI applicable, but also gives the split of interest and Principal components of each EMI. In addition, this also takes care of Principal pre-payments made and also interest rate changes done for floating rates.
Do mail or reply to this thread with suggestions and / or issues if any.
Please note that the 2.0 version is now released at the same URL - Prasanth's Website | . This now has the feature that EMI can be altered and also warns when the existing EMI will not be valid.
Regards.
Prasanth
Similar Topics
Home Loan Planner - Excel based Hi,
I have developed a Micsoft Excel based Home Loan Calculator (Amortization Schedule) and is available for download at Prasanth’s Website | . The reason[..] 6 Replies
Tax benefit - Home loan versus HRA Hi
Want to know if one can claim home loan tax benefit for a property puchased on loan & for which EMI is being paid and[..] 2 Replies
Tax benefit - Home loan versus HRA Hi
Want to know if one can claim home loan tax benefit for a property puchased on loan & for which EMI is being paid and[..] 2 Replies