You can change the loan term and rate as you did before. If you're trying to determine the interest rate, you can use Excel's RATE function to quickly calculate it. Note that the RATE function will ...

Excel predicts it will take approximately 36.5 months to pay off the loan. Useful, right? You can build this into a spreadsheet template that allows you to experiment with different payoff periods ...