Enter the loan amount, annual interest rate, and term in years. This is exactly what Excel's PMT function computes.
=PMT(rate/12, years*12, -principal)
PMT — e.g. =PMT(6%/12, 60, -20000) for a $20k loan at 6% over 5 years.
Functions
Guides