The Loan Calculator for Excel is a Microsoft Excel spreadsheet designed for quick and easy analysis of the effect of a loan's terms on the borrower's payment obligations.

The spreadsheet is fully-customizable and easy-to-use. Simply enter the principal amount, interest rate, payment frequency and the term (length) of the loan and a payment table is automatically generated. The table automatically calculates and shows the breakdown of each payment between principal and interest and displays a running total of the balance that will be owed after each payment.

The Loan Calculator for Excel can accommodate loans with up to 500 payment periods and users may enter extra payments in any payment period.

Date and number fields may be re-formatted by the user (using Excel's built-in formatting capabilities) to accommodate non-US conventions.

The Loan Calculator for Excel is a quick and easy way to analyze your loans.

This spreadsheet was designed by a CFA charterholder.

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

• Designed by a financial professional (CFA charterholder).

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