The Excel Loan Calculator is the best way to see how a loan's terms will effect the borrower's payment obligations. The model is fully-customizable and accommodates loans with up to 500 payment periods.

Simply enter the principal amount, interest rate, payment frequency and the length of the loan and a payment table is automatically generated. View upcoming payments and each payment's breakdown between principal and interest. An additional feature is the ability to make extra payments each period.

• Save time by using a pre-designed template as a basis for your analysis.
• Reduce errors caused when practitioners try to design their own payment tables. Simply enter a few pieces of information about your loan and view the results. The calculations are already done for you.
• Analyze loans with up to 500 payment periods.
• Users can enter additional (unscheduled) payments in any payment period.
• See the breakdown of all payments between principal and interest and view how changes in loan terms and extra payments effect the breakdown.
• The spreadsheet is fully-editable. Source code and calculations are not blocked or hidden behind passwords, as you may find in other companies' templates. Anyone with a basic knowledge of Excel can expand the capabilities of the spreadsheet to fit their needs.
• Date and number fields may be re-formatted by the user (using Excel's built-in formatting capabilities) to accommodate non-US conventions.
• Perfect for anyone who needs a simple, easy-to-use spreadsheet for analyzing loans and payment obligations.
  

• This software runs on any version of Microsoft Excel from 97-2007.
• All recent Microsoft operating systems are supported, including Windows 95, Windows 98, Windows 2000, Windows ME, Windows CE, Windows XP and Vista. Windows Mobile 5.0 and 6.0 are also supported, provided you have Microsoft Excel or Documents-To-Go installed on your mobile device.
• It is also fully-compatible with MAC OS and OS X. You must be running Excel 2004 or 2008 for Mac.

US$29.95 Loan Calculator for Excel