A Loan Amortization
is one of the more complex things to calculate properly. Sure, you
can do basic amortization in an Excel sheet, but dealing with all of
the rounding errors and applying payment overages to
principal only is a nightmare.I cover the basics of Loan Amortization
in my Excel
Expert 6 and
Access 324
classes, but those lessons just scratch the surface. This database
template includes many features that are very difficult to get with
a simple Excel spreadsheet.
|
- Calculate the monthly payment based
on loan amount, interest rate, number of years
- Automatically adjust final payment to ensure there are no
rounding errors
- Create full amortization schedule showing principal and
interest for each month
- Track beginning and ending balance for each period
- Allow monthly payment overage to subtract from principal
balance
- Recalculate monthly interest payments as data changes
- Monthly payments automatically stored and applied where
needed
Click on the video below to watch a full walkthru of how to
use this database.
Download Sample
To download a sample working copy of this database:
Purchase Template Database
A
full, working, editable, royalty free copy of the above database
is available for $24.99. To purchase your copy of this database,
click here:
Purchase Loan Amortization
Template Database. Please make sure that the sample database (above) works for
you BEFORE purchasing. No refunds.

Full Video Seminar
If you would like to learn HOW this
database was built, there is a full video seminar available. This
seminar is nearly 6 hours long and includes a much more complex
database file with lots of bells and whistles. You can learn more
about it here:
Loan Amortization Seminar.
Please note that the
full Video Seminar database is completely
different from the simpler Template database
available for purchase on this page. The Video Seminar database
is much more advanced and includes extra features such as a
different payment frequency (monthly, bi-weekly, etc.). Don't
confuse the two. On this page you're buying just the Template
database. If you want the more advanced database, you need to
purchase the
Loan Amortization Seminar.
Customize For Your Needs
If you would like to discuss
customizing this database for your needs, please see my
consulting page for details on rates
and other information.
|