What is the formula to calculate APR with no payments?
 

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!

What is the formula to calculate APR with no payments?
 

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

What is the formula to calculate APR with no payments?
 

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!

What is the formula to calculate APR with no payments?
 

If interested...

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

--
Dana DeLouis


"Carl" wrote in message
...
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!

What is the formula to calculate APR with no payments?
 

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

"Dana DeLouis" wrote:

If interested...

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

--
Dana DeLouis


"Carl" wrote in message
...
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!