Schedule Templates

Amortization Schedule Template

When you take up a loan, you will be given a schedule to repay it over a period of time. Most financial institutions have a loan amortization computation to assist you in this process. You can also design your own amortization schedule to track your repayments and to be aware of the outstanding amount anytime without having to call up the loan company.

The amortization schedule can be quite straightforward and organized to record the appropriate information of your loan. It is a good piece of tool to employ as it helps you budget and track your outstanding loan.

The amortization schedule template header can have the following information:

* User name

* Loan Details

* Loan Company Details

The Loan details column lists:

* Type of loan

* Amount of loan

* Annual Interest rate

* Loan Period

* Start date of repayment

* Number of annual repayments

The Loan Company details column records:

* Lender Name

* Lender Address & Contact

* Scheduled monthly payment

* Actual Payments

* Early Payments

The body of the amortization schedule template has:

* Payment Number

* Payment Date

* Balance

* Scheduled Payment

* Total Payment

* Principal

* Interest

* Ending Balance

* Cumulative Interest

The above information allows you a full view of your financial status with regards to the loan that you have taken and the progress in your repayments. This way, you have a good overview of how much interest you have paid with regards to the loan taken.

Consider the attached sample template for your convenience.

This movie requires Flash Player 9

To download this file. Subscribe or Login.

Leave a Reply

Your email address will not be published. Required fields are marked *