Just what I needed. Thanks.

"David Biddulph" wrote:

=(B1/A1)^(1/C1)-1
and format as percentage.
I have assumed that PV is in A1, FV in B1, and duration in years in C1.
--
David Biddulph

"Carl" wrote in message
...
Can someone give me the formula to calculate the annual yield or APR using
the value at the beginning (PV), value at the end (FV) and the time
duration
when there are NO payments of any kind involved? Thanks in advance!