If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
drawdown at fixed rate over set period from investment at fixed %
One way:
Assume Lump sum in A1, Annual interest rate in A2, number of years in A3: Monthly income: =ROUND(PMT(A2/12,A3*12,-A1,0),2) Note that -A1 is used since the Lump sum is an outlay of cash, while the payments are inflows. Yearly income would just be the monthly income * 12. In article , jamook wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FOrm and COmbo Box... | NWO | Using Forms | 17 | November 20th, 2005 05:47 AM |
Cash investment tracking when receiving variable interest rate | Jeannz | General Discussion | 0 | September 13th, 2005 03:35 AM |
Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
novice needs help with query | terry | Running & Setting Up Queries | 4 | March 12th, 2005 01:09 AM |
Query with interpolation of dates/rates? | Red | Running & Setting Up Queries | 12 | November 19th, 2004 04:03 PM |