For instance, if you have a $10,000 loan with a monthly payment of $300, and an annual interest rate of 6%, here’s how to set up your calculation: Using these inputs, Excel predicts it will take ...