Does Excel 2003 have a function to calculate how long money will l
 

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

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

Does Excel 2003 have a function to calculate how long money wi
 

This is a great example of what you use a whole spreadsheet for. You're
asking a complicated question and you should be modeling out the cash flows
over time, and not relying on a function.

"Gary''s Student" wrote:

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