What is the formula to calculate APR with no payments?

[Carl]

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!

 

[David Biddulph]

=(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.

 

[Carl]

Just what I needed. Thanks.

=(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.

 

[Dana DeLouis]

If interested...

=RATE(C1,0,-A1,B1)

 

[Carl]

Thanks! This works as well and is a little easier to understand.