Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Amortization Template 1.0
 
Access Amortization Template 1.0

Microsoft Access Loan Amortization 1.0 Template


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

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 class, and I have a more complex Loan Amortization Seminar which shows how this database was built. This database template is available for people who want just the database template, but don't need the video instruction. 

Features

  • 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

Update

  • I recently updated the database template for this Seminar. See Loan Amortization Template 2.0.
  • If you purchased a copy of version 1.0 of this original template between 2021-06-13 and 2022-06-13 you qualify for a free copy. If you purchased it before that date, you get a 50% discount. Contact me for details.

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable version of the template which will let you see it work in action. Sample databases are available for 32-bit and 64-bit versions of Access 2007 or higher, and there is also a version for Access 2003.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2013 or higher (possibly 2007, but I haven't tested it). There is also an older database for Access 2003 users.

Full Video Seminar

If you would like to learn how this database was built, again, get the Loan Amortization Seminar. It covers everything step-by-step. Please note that the full Seminar database is completely different from the simpler Template database available for purchase on this page. The 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.

Support Not Provided

Please note that technical support is not provided to people who just purchase the Template. That's what the Seminar is for: to explain how the database works. If you have questions, you will just be forwarded to the Seminar page. 

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the database for your business needs and for use within your organization ONLY. You may not resell or distribute any form of this database to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a database you are reselling. Additional licenses are required if you plan on using this database with more than ten (10) employees within your organization.

Customize For Your Needs

If you would like to discuss customizing this database for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Access Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. 

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Order Now

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #templates, microsoft access loan amortization template

 

Comments for Access Amortization Template 1.0
 
Age Subject From
3 monthsNot Calculating ProperlyTimothy Schmidt
3 monthsHow To Use This DatabaseTimothy Schmidt

 

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

8/17/2022Append Mistake #2
8/15/2022Append Mistake #1
8/14/2022Hex to RGB
8/12/2022Transpose Data
8/11/2022Crosstab
8/9/2022Append Query
8/8/2022Indexing
8/5/2022No Data
8/4/2022Secondary Emails
8/1/2022Limit Long Text
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: templates access microsoft access loan amortization template  PermaLink  Microsoft Access Amortization Template 1.0