| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
Hybrid Mode
