Finding the interest rate.
 

So present value = future value / (1+discount rate)^n where n is the number
of compounding periods.

If I have PV, FV, and n, I assume I use the RATE formula to get the interest
rate. I keep getting #NUM. Any suggestions?

Thank you

Finding the interest rate.
 

You also need the amount of the fixed payment entered as a negative value.
See Excel help on "Rate".
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Kevin W"
wrote in message
So present value = future value / (1+discount rate)^n where n is the number
of compounding periods.
If I have PV, FV, and n, I assume I use the RATE formula to get the interest
rate. I keep getting #NUM. Any suggestions?
Thank you

Finding the interest rate.
 

The Rate function is the one you want, and will work with correct data.

FV and PV need opposite signs. Did you do that?

If you need more help, post your formula.

Regards,
Fred

"Kevin W" <Kevin wrote in message
...
So present value = future value / (1+discount rate)^n where n is the
number
of compounding periods.

If I have PV, FV, and n, I assume I use the RATE formula to get the
interest
rate. I keep getting #NUM. Any suggestions?

Thank you

Finding the interest rate.
 

Rate will work with a zero PMT. Also, PMT can be positive if, for example,
you are accumulating money rather than paying off a loan.

Regards,
Fred.

"Jim Cone" wrote in message
...

You also need the amount of the fixed payment entered as a negative value.
See Excel help on "Rate".
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Kevin W"
wrote in message
So present value = future value / (1+discount rate)^n where n is the
number
of compounding periods.
If I have PV, FV, and n, I assume I use the RATE formula to get the
interest
rate. I keep getting #NUM. Any suggestions?
Thank you