Here is where Excel templates come into play ... You can enter loan amount, annual interest rate, load period in years, ...