Public Function loanPayment(borrow, rate, years) loanPayment = (borrow*rate/1200)/(1-(1+rate/1200)^(-12*years)) End Function