Home Loan Planner - Excel based - interest rate Xls Download
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Forms, Formats & Questionnaires

rajanpras Started The Discussion:

Hi,

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.

Regards.
Prasanth

rajanpras -  Member Since: May 2008
Hi,

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 | .

Regards.
Prasanth

myusufk -  Member Since: Mar 2008
Hi I am not able to access the URL will you please send the file in my personal ID: myusufk@hotmail.com Thanks is advance

maheshkk -  Member Since: Mar 2008
Dear Prasanth Yesterday i was looking to the calculator, today while browsing the citehr site for other purpose i got this, it is wounderful. Thanks a lot for the contribution

kumar shanmugam -  Member Since: Sep 2007
Dude Its really very good tool for a novice in acconts like me, but it will be very good to have below.
1. Option for repayment in principle amount
2. Manually change the EMI(If i am rounding to 15000 instead of 14990)

But really a good tool :-)

rajanpras -  Member Since: May 2008
Quote:
Originally Posted by kumar shanmugam View Post
Dude Its really very good tool for a novice in acconts like me, but it will be very good to have below.
1. Option for repayment in principle amount
2. Manually change the EMI(If i am rounding to 15000 instead of 14990)

But really a good tool :-)
Hi,

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.

Thanks.
Prasanth

rush2san -  Member Since: Oct 2008
Wow... This is excellent. I was searching for this for long and always found just the EMI calculator but never the full schedule that changes with changes in rate of interest during the term. Great work.
Thanks.
Sandy

rajanpras -  Member Since: May 2008
Hi all,

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 |.

Regards.
Prasanth

jaihr -  Member Since: Sep 2008
:icon5: Pls see it, it will be useful to all......... House - loan calculation.


Attached FilesProvided by community member jaihr. Join us to learn and grow with your peers.
File Type: xls Loan_Calc.xls (140.5 KB, 1688 views)
TMi -  Member Since: Sep 2008
Hi, Home loan available at attractive rates, Visit (Home loan) at http://homeloan4me.blogspot.com/ Send me the details at tm.isysnsol@gmail.com Regards, TMi




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • Found This Useful? +Vote Up This 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.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network