=Here is what I did. 11886.87 48 291.09; 13972.32=A3*48 $291.09=-PMT(8.16%/12,A2,A1) ; 0.68%=RATE(A2,-A3,A1,0) 8.16%=A7*12 Three values in A1 to A3 Calculated total in A4 Used PMT function, and manually figured the interest rate by trying values till correct value gotten. In A6 used the rate function, It calculates rate for the payment.A7 calculates the yearly rate. Is that want you want? -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy