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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What Function is the Opposite of the FV() Function
Is there one?
|
#2
|
|||
|
|||
|
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 03:50 PM |