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