View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Calculate How Long Funds Will Last

homework?


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ridgerunner" wrote in message
...
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?