 |
Amortization Calculators - Do It Yourself In Excel
Here you can find a free download explaining how to prepare amortization calculators yourself using excel. The example and explanations include simple loan with fixed interest rate. Interest payments can be done on a monthly, quarterly or semiannual basis.
The download included step by step instruction, explaining how to start, what data you should be using and what calculations you will have to do.
The information you will need is the following:
-
-
-
-
regularity of interest payments
Based on this data you will be able to calculate monthly payment yourself using certain excel function and prepare amortization schedule.
Download amortization calculator here
Other Resources
Below you can also find a list of all calculators you can download for free on our site:
Free Excel Calculator 1 - simple fixed rate mortgage
Free Excel Calculator 2 - fixed rate mortgage with extra payment
Free Excel Calculator 3 - comparing the options & amortization for quarterly and semiannual interest payments
Free Excel Calculator 4 - compare annuity & linear payments
Free Excel Calculator 5 - determining loan duration
Free Excel Calculator 6 - exploring refinancing options
Free Excel Calculator 7 - do it yourself in Excel
What to make more calculations? Explore 87 Business & Accounting Forms
Download 87 different accounting and business forms helping you to: prepare financial statements / calculate financial ratios / calculate break-even, depreciation, standard cost variances, and much more.
The package includes 5 Groups of different forms in 3 formats (Excel, PDF and filled in PDF). Essential for improving practical accounting knowledge and useful in accounting practice or business management. Important! You can view all the forms online before downloading.
Click here to learn more...
Featured Tutorials & Material Online
Exclusive Members Area - Lifetime Access, No Monthly Fees

Click here to learn more
What Is Inside:
High quality video and printable PDF material on financial accounting combining theory and practice, including:
Seminar Videos (4+ hours)
Two seminars on Bookkeeping Basics and Understanding Financial Statements. Together with videos you get access to PDF printouts of the videos and 50 questions exams to test your understanding.
Self-Study Materials (PDF)
1,500+ pages of PDF files organized by topic. Includes explanations, quizzes, cheat sheet, Q&A, and more:
Online Exams
1,660 interactive exam questions with answers, including Bookeeping Proficiency, Financial Accounting, Managerial and Cost Accounting, Financial Ratios and Video Seminars exams.
87 Business Forms
Professional business forms in Excel and PDF format, including filled in examples for better application.
Click here to learn more
What Next?
Subscribe to our RSS feed
Leave Amortization Calculators and return to Home page
|
|
|
 |
|
| Sign Up For News |
|
 |
| Learning Material |
|
 |
| Explore Today |
|
|
 |
| Accounting Software |
|
 |
|