rajanpras Started The Discussion:
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.
On suggestion from a CA in another forum, I have added the feature of chosing the Fy such that the Principle and Interest for that FY is displayed. This version 1.1 is now available at the same URL - Prasanth's Website | .
There is the option for repayment of Principle - this ise last column in cream color.
Regarding the second item, generally the Banks fix the EMI and with increase or decrease in rates or on repayment of Principle, the EMI remains fixed and tenure changes. But yes, if the tenure goes to more than 35 years for a 20 year loan with increase in interest rate, banks might decide to hike the EMI. Let me look at this option. Will keep you posted.
Please note that there is a minor correction in Principal computation when there is repayment. This is now corrected and version 1.2 and the same is now available for download at the same URL - Prasanth's Website |.
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> home loans home loan interest rate microsoft excel Location-India-Bangalore Complete List Of Categories
Interesting Relevant Discussions