How 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?

Summary.
Get interest in given period.
The interest amount.
=IPMT (rate, per, nper, pv, [fv], [type])
rate - The interest rate per period.
The IPMT function can be used to calculate the interest portion of a given loan payment in a given payment period.
## Related Question how to calculate an amortization schedule