| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate partial payments | Excel Worksheet Functions | |||
| How to calculate PV of payments where pmts. change every 5 yrs. | Excel Discussion (Misc queries) | |||
| How do I calculate the accumulated payments from an annuity at yr | New Users to Excel | |||
| Does anyone have a formula to calculate the car lease payments | Excel Discussion (Misc queries) | |||
| how do i calculate my mortgage payments | Excel Worksheet Functions | |||
Linear Mode
