I'm trying to calculate the interest rate of an annuity with a final payment. I have the present value, the payment amount, the final payment amount, and the number of payments. I've discovered the "MORT" and "COMPOUND" functions, but is there anything that combines these?
I am not much of a finance guy and these simple functions have always been sufficient for me. What is it thay they do not do for you? Have you examined the other functions in the Financial category? There are close to two dozen, perhaps one of those would be closer to your needs.