Vertex42 has a nice Excel based Amortization schedule calculator that is completely free for personal use, and works very well. Advantage of using this Excel Based Amortization Schedule Calculator is that you can store the excel by entering your loan information once, and always refer to that in future.
After downloading the excel, you enter your loan information in this. You can enter your loan amount, Annual Interest Rate, Term of Loan in years, and First Payment Date. Apart from this, Excel Based Amortization Schedule Calculator also lets you specify values for these options:
Payment Frequency: You can choose one of the following values for Payment Frequency
Annual
Semi-Annual
Quarterly
Bi-Monthly
Monthly
Semi-Monthly
Bi-Weekly
Weekly
Compound Period: For Compound Period also you get the same options as mentioned for Payment Frequency above.
Payment Type: You can choose your Payment Type to be at Beginning of Period, or End of Period.
Once you have provided all the above information about your mortgage, this Excel Based Amortization Schedule Calculator prepares the complete Amortization schedule for you. It shows you the Due Date, Payment to be made on each due date, Interest, Principal, and remaining balance for that period.
Here is a video tutorial that explains how to use this free Excel Based Amortization Schedule Calculator.
This free Excel Based Amortization Schedule Calculator also has a column for additional payments. If you make any additional payment in any period, just enter that in additional payment column. Then your amortization schedule excel will be updated to reflect recalculated payments.
Another great feature of this Free Excel Based Amortization Schedule Calculator is that you can record your actual payments as well that you make. Based on that, it keeps on updating the whole Amortization schedule to reflect the amounts that you have paid. So, this Excel Based Amortization Schedule Calculator serves the dual purpose of calculating your amortization schedule, as well as storing your actual payments made.
Download links, and Video Tutorials at the end.
Vertex42 has a nice Excel based Amortization schedule calculator that is completely free for personal use, and works very well. Advantage of using this Excel Based Amortization Schedule Calculator is that you can store the excel by entering your loan information once, and always refer to that in future.
After downloading the excel, you enter your loan information in this. You can enter your loan amount, Annual Interest Rate, Term of Loan in years, and First Payment Date. Apart from this, Excel Based Amortization Schedule Calculator also lets you specify values for these options:
Payment Frequency: You can choose one of the following values for Payment Frequency
- Annual
- Semi-Annual
- Quarterly
- Bi-Monthly
- Monthly
- Semi-Monthly
- Bi-Weekly
- Weekly
Compound Period: For Compound Period also you get the same options as mentioned for Payment Frequency above.
Payment Type: You can choose your Payment Type to be at Beginning of Period, or End of Period.
Once you have provided all the above information about your mortgage, this Excel Based Amortization Schedule Calculator prepares the complete Amortization schedule for you. It shows you the Due Date, Payment to be made on each due date, Interest, Principal, and remaining balance for that period.
This free Excel Based Amortization Schedule Calculator also has a column for additional payments. If you make any additional payment in any period, just enter that in additional payment column. Then your amortization schedule excel will be updated to reflect recalculated payments.
Another great feature of this Free Excel Based Amortization Schedule Calculator is that you can record your actual payments as well that you make. Based on that, it keeps on updating the whole Amortization schedule to reflect the amounts that you have paid. So, this Excel Based Amortization Schedule Calculator serves the dual purpose of calculating your amortization schedule, as well as storing your actual payments made.
Download links at the end.
