| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drawdown at fixed rate over set period from investment at fixed %
I want a formula that will work out the following. I have a lump sum that I
have invested at a fixed interest. I want to know how much a month/year I could get from this lump sum if I set a number of years when it would all be used up. ie say 10years when I will be 80 or 20years when I will be 90yrs. Formula to include: Lump Sum, Annual interest rate, Number of Yrs, Compounding period = Monthly/ annual income over number of yrs. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cash investment tracking when receiving variable interest rate | Excel Discussion (Misc queries) | |||
| a function giving the interest rate for inv x for period y & bal z | Excel Worksheet Functions | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| WHAT IS THE RATE BY MONTHS on A return of investment | Excel Discussion (Misc queries) | |||
Threaded Mode
