Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solve for interest rate of a security when pv, fv, nper are know?
I need to solve for the rate of growth of a mutual fund over a period of
time. I know pv, fv, and nper. What I don't know is if RATE or INTRATE is the better formula to use. Plugging in the constants, these two formulas return different results. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solve for interest rate of a security when pv, fv, nper are know?
Pete,
You need periodic payment information to use RATE, so it appears that INTRATE would be better. The two functions use different parameters, so it is difficult to see how you are able to compare them. HTH, Bernie MS Excel MVP "Pete at CitiStreet" <Pete at wrote in message ... I need to solve for the rate of growth of a mutual fund over a period of time. I know pv, fv, and nper. What I don't know is if RATE or INTRATE is the better formula to use. Plugging in the constants, these two formulas return different results. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solve for interest rate of a security when pv, fv, nper are kn
Bernie:
That is what I thought. I was asked to test the RATE fnuction by a co-worker. Thanks -- PCW "Bernie Deitrick" wrote: Pete, You need periodic payment information to use RATE, so it appears that INTRATE would be better. The two functions use different parameters, so it is difficult to see how you are able to compare them. HTH, Bernie MS Excel MVP "Pete at CitiStreet" <Pete at wrote in message ... I need to solve for the rate of growth of a mutual fund over a period of time. I know pv, fv, and nper. What I don't know is if RATE or INTRATE is the better formula to use. Plugging in the constants, these two formulas return different results. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate Rate when PMT, Nper & PV is known | Excel Worksheet Functions | |||
bank cal for interest on cd | Excel Worksheet Functions | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
solving for NPer w/o function (algebra question) | Excel Worksheet Functions |