Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bao bao is offline
external usenet poster
 
Posts: 3
Default FV Calculation problem

Annual Controbution $3000 Rate of Return 3% Years of contribution 5 Years.
How do i calculate the amount saved
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default FV Calculation problem

If contributions are made at the beginning of the period
=FV(3%,5,-3000,,1)
at the end of the period
=FV(3%,5,-3000)

Both scenarios assume the present value is 0 and the contributions are made
once a year.


"bao" wrote:

Annual Controbution $3000 Rate of Return 3% Years of contribution 5 Years.
How do i calculate the amount saved

Reply
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
Mortgage calculation after a large extra payment Gary Wachs Excel Discussion (Misc queries) 6 April 16th 06 08:55 AM
VLOOKUP Problem Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM
Problem withe ABS Function M and D Excel Worksheet Functions 6 March 8th 06 12:45 PM
Calculation Setting in Excel Stuart Bisset Excel Discussion (Misc queries) 0 June 17th 05 09:54 AM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM


All times are GMT +1. The time now is 11:00 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"