Our Biweekly Mortgage Payment Amortization template is easy-to-use. It is absolutely free to download right from this page. Within a matter of seconds, you will be able to have access to the charts and start using them right away. The chart is customizable to fit your needs.
How to Use the Biweekly Mortgage Payment Amortization
The first chart, Inputs, in the top left hand corner is going to need:
- Loan principal amount
- Annual interest rate
- Loan period in years with a maximum of 30 years
- Base year
- Loan start date
- Date of first payment
The second chart, Key Figures, in the top right hand corner is going to need:
- Annual loan payments
- Biweekly payments
- Interest over term of loan
- Sum of all payments
The big chart, First 26 Payments, in the middle is going to need:
- Payment number
- Payment date
- Beginning balance
- Payment
- Principal
- Interest
- Cumulative principal
- Cumulative interest
- Ending balance
The items needed will be listed across the chart.
The chart at the bottom of the page, Payments for Calendar Years after Year One, is going to need:
- Year
- Beginning balance
- Payment
- Principal
- Interest
- Ending balance
Tips on Using the Biweekly Mortgage Payment Amortization
- The grey areas of the chart are going to be able to do all the math for you. You will be able to just enter in the figure amounts needed.
- The Biweekly Mortgage Payment Amortization template is going to be able to allow you to easily see the payments that you need to make and the interest amounts that are going to accrue. This is a great chart to use for businesses in order to keep track of their clients mortgage payments.
- For any items not needed in the chart, they can be easily taken out or replaced with something else needed.
Check out the Biweekly Mortgage Payment Amortization template today and download your free, customizable template to use.
Download: Biweekly Mortgage Payment Amortization
Check this out while you wait!