Loan Amortization Schedule Calculator
Originally published: 21/10/2020 13:51
Publication number: ELQ-80464-1
View all versions & Certificate

Loan Amortization Schedule Calculator

Generate loan amortization schedules, with breakdown of interest and principal repayments.

This loan amortization schedule calculator is simple to use, yet flexible and powerful. It calculates the loan repayment amounts for each period, the specific dates for each repayment, how much of each repayment goes towards principal and interest, the outstanding loan balance at any given point in time, and the total interest over the life of the loan.

Different loan types include:
- Annuity: Regular fixed payments covering both principal and interest. The interest component is highest at the start of the loan and gradually decreases over time, whereas the principal component is smallest at the start and gradually increases. Mortgages are commonly structured as annuities.
- Fixed Principal: Equal principal repayments, with the interest payments decreasing over the life of the loan.
- Interest Only: Regular fixed interest payments, with the entire principal repaid as a lump sum at maturity.
- Zero-coupon: All payments of principal and interest are deferred until maturity.

The calculator also has the following customization options:
- Annual, bi-annual, quarterly, bi-monthly, monthly, fortnightly or weekly instalments
- Up to 5,200 instalments across 100 years
- Interest rate compounding frequencies, including annual, bi-annual, bi-monthly, monthly, fortnightly, weekly, daily 30/360 and daily actual/actual day count conventions
- Balloon repayments (i.e. lump sum principal repayment at maturity)
- Interest-free grace periods
- Principal repayment grace periods

This Best Practice includes
1 Excel File

Acquire business license for $3.00

Add to cart

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Tibor Rusiňák(last updated: 19/07/2021 08:51)
  • benedictus makumbe(last updated: 10/12/2020 20:27)
  • Diana Bianu(last updated: 05/12/2020 13:46)
  • Amir Ganic(last updated: 22/10/2020 11:02)
  • David Kroeger(last updated: 21/10/2020 22:24)
    Loan Amort calculatofr
    very nice, staightforward. Good array of loan type options presented.

People using this Best Practice also downloaded


Discussion feed for Loan Amortization Schedule Calculator

The user community and author are here to help. Go ahead!

  • Amir Ganic
    Thanks again for this nice tool...but once I change a date it does not work properly...Can you help me fix it...
    arrow_drop_uparrow_drop_downReply reply

    4.8 / 5 (5 votes)

    please wait...