# How To Calculate An Amortization Schedule

On December 12, 2021How do you calculate a 30 year amortization schedule?

**Multiply the number of years in your loan term by 12 (the number of months in a year)** to get the number of payments for your loan. For example, a 30-year fixed mortgage would have 360 payments (30x12=360).

How do I calculate Impt results in Excel?