Learn Excel 2010 â âVariable Rate Loan Pmtâ: #1438âI was in Milwaukee this week at the IIA Regional Conference when Heidi asked me about calculating a loan payment for a loan, with variable interest rates.â In Episode #1438, Bill shows us how to use Goal Seek to back into this answer.