Calculate How Long Funds Will Last
On Sun, 20 Dec 2009 14:44:01 -0800, ridgerunner
wrote:
I am not very good with financial worksheet functions and hope that someone
here can help. Is there a function that will return how long funds will last
if you earn a static interest rate and withdraw a static amount of money that
is more than the interest earned? Let's say, for example, the amount of
money is $1,000,000, the interest rate is 4% and the yearly withdrawal is
$50,000?
Take a look at the NPER worksheet function.
--ron
|