View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Does Excel 2003 have a function to calculate how long money will l

You should checkout financial templates:

http://www.contextures.com/xlCondFormat01.html
--
Gary's Student
gsnu200703


"steven8264" wrote:

Does Excel 2003 have a function to calculate how long money will last similar
to the following tool that I found online?

Savings & Assumptions Input

Current savings balance in dollars
Proposed monthly withdrawal amounts in dollars
Annual withdrawal increases (if any) in percent
Annual before-tax return on savings in percent
Federal marginal tax bracket in percent
Desired amortization schedule set at monthly or yearly

Even if what's available within Excel is not as comprehensive as above, it
still would be helpful!

Thanks!

Steve