What is the formula to calculate APR with no payments?

C

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!
 
D

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.
 
C

Carl

Just what I needed. Thanks.

David Biddulph said:
=(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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mathematical formula of rate 5
Future Value Calculation 2
is there a formula for FV with UNEQUAL payments 3
Help please - formula to calculate Tax 4
where is the formula for calculating the APR 2
APR Question 11
Financial Functions, in particular, the INTRATE function 5
WANTED: Excel template for loan payment record with random/irregular payments 1

Top