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.

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.