A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

What Function is the Opposite of the FV() Function



 
 
Thread Tools Display Modes
  #1  
Old September 29th, 2004, 02:36 PM
external usenet poster
 
Posts: n/a
Default What Function is the Opposite of the FV() Function

Is there one?
  #2  
Old September 29th, 2004, 05:24 PM
Alan Beban
external usenet poster
 
Posts: n/a
Default

wrote:

Is there one?

What do you mean by "Opposite"?

Alan Beban
  #3  
Old September 29th, 2004, 05:51 PM
Jim May
external usenet poster
 
Posts: n/a
Default

The FV() accumulates and gives you the future value of
say depositing $300.00 per month into an acct earning 3%
over a 48 month period and yields
$15,279.36
=-FV(C5/12,C6,C4)

I'm interested in Starting with $20,000 in an acct
earning 3% and withdrawing $400 per month for 20 months;

How much would remain in the Acct?




-----Original Message-----
wrote:

Is there one?

What do you mean by "Opposite"?

Alan Beban
.

  #4  
Old September 29th, 2004, 07:28 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default

Hi Jim,
Your question is about the value of an account at some time in the future.
So FV is the function we need.
=FV(rate, nper, pmt, [pv],[code for end or beginning of month])
Let's forget the last parameter - assume payment is paid (withdrawn) at end
of month
=FV(3%/12, 20, 400, -20000) = 12,831.23
Looks about right: started with 20,000, took out 8000 (20 * 400), leaving
12,000 but there was a minor interest accumulation.
We have to get the cash flow correct. I like to use: Money To me is
positive and from me is negative
So I put the 20000 into the annuity, I receive the 400 monthly.

Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"Jim May" wrote in message
...
The FV() accumulates and gives you the future value of
say depositing $300.00 per month into an acct earning 3%
over a 48 month period and yields
$15,279.36
=-FV(C5/12,C6,C4)

I'm interested in Starting with $20,000 in an acct
earning 3% and withdrawing $400 per month for 20 months;

How much would remain in the Acct?




-----Original Message-----
wrote:

Is there one?

What do you mean by "Opposite"?

Alan Beban
.



  #5  
Old September 29th, 2004, 11:36 PM
JMay
external usenet poster
 
Posts: n/a
Default

Berbard:
Appreciate the pointers; turns out it is the same (not opposite) Function
(The FV())
only with an added argument being employed (at the 4th position)
I got it working..
Thanks again for your patience and help!!
Jim May

"Bernard Liengme" wrote in message
...
Hi Jim,
Your question is about the value of an account at some time in the future.
So FV is the function we need.
=FV(rate, nper, pmt, [pv],[code for end or beginning of month])
Let's forget the last parameter - assume payment is paid (withdrawn) at

end
of month
=FV(3%/12, 20, 400, -20000) = 12,831.23
Looks about right: started with 20,000, took out 8000 (20 * 400), leaving
12,000 but there was a minor interest accumulation.
We have to get the cash flow correct. I like to use: Money To me is
positive and from me is negative
So I put the 20000 into the annuity, I receive the 400 monthly.

Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"Jim May" wrote in message
...
The FV() accumulates and gives you the future value of
say depositing $300.00 per month into an acct earning 3%
over a 48 month period and yields
$15,279.36
=-FV(C5/12,C6,C4)

I'm interested in Starting with $20,000 in an acct
earning 3% and withdrawing $400 per month for 20 months;

How much would remain in the Acct?




-----Original Message-----
wrote:

Is there one?
What do you mean by "Opposite"?

Alan Beban
.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
#Error using function as controlsource Laurel New Users 4 September 24th, 2004 08:31 PM
Customising the Function Wizard Frank Kabel Worksheet Functions 1 April 20th, 2004 06:46 PM
Function for % gain? Norman Harker Worksheet Functions 4 April 1st, 2004 11:54 AM
Returning multiple values from a worksheet function Steve Lloyd Worksheet Functions 4 January 14th, 2004 04:50 PM


All times are GMT +1. The time now is 11:48 PM.


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