Calculate Loan Payment Excel

Prior to taking on that loan or mortgage, it is usually recommended to check precisely what your monthly repayments can be, and if you can afford them. This can be useful for deciding the loan amount as well as term of the loan product. Different type of payment calculators are available that will help you do calculations based on your requirements as well as the kind of loan.

Loan calculators permit you to very easily compare the total interest payable and also the monthly instalments for various interest rates and loan terms. A number of mortgage calculators can be found on the web and a brief search shows numerous results. Nevertheless, in order to guarantee accuracy and reliability you should use mortgage calculators provided by reputed websites like bankrate.com or you can of course use excel if you have a copy installed on you computer.

Here are a few resources to help you get started and calculate loan payment. Excel
formulas included and easy to follow instructions.

 
Calculate Loan Payment Excel
This is a nice step by step guide to calculating your loan or mortgage payments with Excel

Spreadsheet Templates for Personal Finance
This site has a nice collection of financial templates for excel and Open Office Calc including a loan payment calculator.

The following video show how to create a simple loan calculator in Excel.