The Loan Calculator for Excel is a collection of six Microsoft Excel
spreadsheets that let you quickly determine how different loan terms affect your
payment obligations.
The primary feature of each spreadsheet is an amortization schedule that shows
you the amount of each loan payment over time.
Another great feature of each spreadsheet is a loan summary that provides key
information about the number of payments required, loan payoff date and total
interest paid over the life of the loan.
In addition to the amortization schedule and loan summary, each spreadsheet
contains a graph showing the proportion of each payment that is applied to
principal vs. interest during the term of the loan.
The six spreadsheets that are included in the Loan Calculator for Excel are
listed below:
Fixed Rate Traditional Loan:
This Fixed Rate Traditional Loan Calculator is used for
analyzing traditional fixed rate loans such as fixed rate mortgages and car
loans. The loan may have up to 1,000 payment periods and the payment frequency
is fully adjustable. An extra unscheduled payment amount may be added to each
payment period.
The loan summary includes: Scheduled Payment Amount, Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments and Total Interest Paid.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created.
Fixed Rate Balloon Loan:
The Fixed Rate Balloon Loan Calculator is a great tool for analyzing loans that
require a large balloon payment at the end of the loan term. The loan may have
up to 1,000 payment periods. The payment frequency, amortization basis and fixed
rate payment period are all fully adjustable. An extra unscheduled payment
amount may be added to each payment period.
The loan summary includes: Scheduled Payment Amount, Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments, Total Interest Paid and Balloon Payment Amount.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created.
Fixed Rate Interest Only Loan:
The Fixed Rate Interest Only Loan Calculator is used for analyzing fixed rate
loans that have a predetermined period when only interest payments are required.
This results in lower payments in the early part of the loan and higher payments
in the latter part of the loan.
The loan may have up to 1,000 payment periods. The payment frequency and
interest only period are all fully adjustable. An extra unscheduled payment
amount may be added to each payment period.
The loan summary includes: Scheduled Payment Amount During Interest Only
Period, Scheduled Payment Amount After Interest Only Period, Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments and Total Interest Paid.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created.
Adjustable Rate Traditional Loan:
This Adjustable Rate Traditional Loan Calculator is used for
analyzing traditional adjustable rate loans such as adjustable rate mortgages and car
loans. The loan may have up to 1,000 payment periods and the payment frequency
is fully adjustable. An extra unscheduled payment amount may be added to each
payment period. In addition, the interest rate is adjustable for every payment
period in the loan.
The loan summary includes: Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments and Total Interest Paid.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created. Because scheduled payments for adjustable rate loans can
vary by each payment period, the Scheduled Payment Amount is listed for each
payment period in the Amortization Schedule instead of the Loan Summary.
Adjustable Rate Balloon Loan:
The Adjustable Rate Balloon Loan Calculator is a great tool for analyzing
adjustable rate loans that require a large balloon payment at the end of the
loan term. The loan may have up to 1,000 payment periods. The payment frequency,
amortization basis and adjustable rate payment period are all fully adjustable.
An extra unscheduled payment amount may be added to each payment period. In
addition, the interest rate is adjustable for every payment period in the loan.
The loan summary includes: Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments, Total Interest Paid and Balloon Payment Amount.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created. Because scheduled payments for adjustable rate loans can
vary by each payment period, the Scheduled Payment Amount is listed for each
payment period in the Amortization Schedule instead of the Loan Summary.
Adjustable Rate Interest Only Loan:
The Adjustable Rate Interest Only Loan Calculator is used for analyzing
adjustable rate loans that have a predetermined period when only interest
payments are required. This results in lower payments in the early part of the
loan and higher payments in the latter part of the loan.
The loan may have up to 1,000 payment periods. The payment frequency and
interest only period are all fully adjustable. An extra unscheduled payment
amount may be added to each payment period. In addition, the interest rate is
adjustable for every payment period in the loan.
The loan summary includes: Scheduled Number of
Payments, Actual Number of Payments, Loan Payoff Date, Total Amount of Extra
Payments and Total Interest Paid.
A full amortization schedule and a chart
showing the breakdown of principal and interest payments over time are both
automatically created. Because scheduled payments for adjustable rate loans can
vary by each payment period, the Scheduled Payment Amount is listed for each
payment period in the Amortization Schedule instead of the Loan Summary.
The currency and date formats in each of the six spreadsheets are easily changed using drop-down boxes at the
top of the page.
Supported Currencies: USD/CAD, GBP, Euro
Supported Date Formats: MM/DD/YYYY, DD/MM/YYYY
The Loan Calculator for Excel is a quick and easy way to analyze your loans.
These spreadsheets were designed by a CFA charterholder.
- Save time by using pre-designed templates 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
six different types of loans: Fixed Rate Traditional, Fixed Rate Balloon,
Fixed Rate Interest Only, Adjustable Rate Traditional, Adjustable Rate
Balloon, Adjustable Rate Interest Only
- Analyze
loans with up to 1,000 payment periods.
- Users
can enter an extra (unscheduled) payment to be included in every payment period.
-
Amortization table shows you the breakdown of all payments between principal and interest
over time.
-
Graphs show you the breakdown between principal and interest payments over
time.
-
Loan summary provides quick statistics about your loan.
-
Choose from multiple date and currency formats using specially-designed
drop-down boxes.
- Perfect
for anyone who needs a simple, easy-to-use spreadsheet for analyzing loans
and payment obligations.
- Designed by a
financial professional (CFA charterholder).
| Click the thumbnails below for partial screenshots of the Loan Calculator for Excel.
If the images appear blurry in the new window, click on the image to
zoom in. |
Fixed Rate Traditional Loan Calculator |
Fixed Rate Balloon Loan Calculator |
Fixed Rate Interest Only Loan Calculator |
Adjustable Rate Traditional Loan Calculator |
Adjustable Rate Balloon Loan Calculator |
Adjustable Rate Interest Only Loan Calculator |
|
The Loan Calculator for Excel requires
Excel 2003, 2007 or 2010 to run.
It is fully compatible with
Microsoft Windows 7, Windows Vista and Windows XP.
You may also use the
software on a Mac if you are running Windows 7, Windows Vista or Windows XP and Excel 2003, 2007 or 2010 on Parallels or VMWare Fusion.
This version will not work with
Excel for Mac. We will have a Mac version ready in July 2011.
Be sure to select the appropriate number of licenses when making your
purchase.
