Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What will be Rate of Interest (ROI) ? | Excel Worksheet Functions | |||
to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
Annual interest rate | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Effective rate of Interest and Copounding Interest | Excel Worksheet Functions |