LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 361
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate partial payments Jean Excel Worksheet Functions 4 December 29th 06 05:36 PM
How to calculate PV of payments where pmts. change every 5 yrs. GlennB Excel Discussion (Misc queries) 1 July 5th 06 05:43 PM
How do I calculate the accumulated payments from an annuity at yr jmuirman New Users to Excel 2 August 7th 05 04:29 PM
Does anyone have a formula to calculate the car lease payments Captain Jack Excel Discussion (Misc queries) 2 July 30th 05 03:11 PM
how do i calculate my mortgage payments mike Excel Worksheet Functions 3 January 25th 05 05:42 PM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"