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 <7C4B2F12-BFF7-448F-9DF9-(E-Mail Removed)>,
jamook <(E-Mail Removed)> 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.