| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Crete an An Account with regular withdrawls with a declining bala.
Looking for an Excel program that will calculate from a starting month to end
how long an amount of money will last that accumulates a fixed yearly interest but has a monthly withdrawl. Like having an IRA with say $100,000 nest egg and you withdrawl $500 a month and the account accumulates say 5% apr |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Crete an An Account with regular withdrawls with a declining bala.
early1_us
=NPER(0.05/12,500,-100000,0) gives 431 months. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "early1_us" wrote in message ... Looking for an Excel program that will calculate from a starting month to end how long an amount of money will last that accumulates a fixed yearly interest but has a monthly withdrawl. Like having an IRA with say $100,000 nest egg and you withdrawl $500 a month and the account accumulates say 5% apr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| account # entry needs to return the account description | Excel Worksheet Functions | |||
| Declining balance | Excel Worksheet Functions | |||
| Create account with regular income - How? | Excel Discussion (Misc queries) | |||
| Having trouble finding a BASIC running balance sheet. in/out bala | Excel Discussion (Misc queries) | |||
| Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
Linear Mode
