-
I have a Present Value (PV), Future Value(FV) at N years into the future. How do i find the interest that equates Fv to Pv? There is no simple function. The manual says "rate()" function, but it does not exist in my version 3.22.0. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
If you are not able to update to a more recent version (3.22 is four years old), I recommend that you use an equation (preferably using |
Beta Was this translation helpful? Give feedback.
If you are not able to update to a more recent version (3.22 is four years old), I recommend that you use an equation (preferably using
newtonsolve
function), e.g.newtonsolve(fv(x, 12, 1000) = -20000, 0.1)
. The rate function uses an equation with the pmt function, e.g.newtonsolve(pmt(x, 10, 10000) = -1500, 0.1)
.